1 2 3 4 5 6 > >>   Sort: Rank

What Is Program Global Area (PGA) in Oracle
What Is Program Global Area (PGA) in Oracle? A Program Global Area (PGA) is a memory buffer that is allocated for each individual database session and it contains session specific information such as SQL statement data or buffers used for sorting. The value specifies the total memory allocated by al...
2020-07-07, 788👍, 0💬

What Is System Global Area in Oracle
What Is System Global Area (SGA) in Oracle? The System Global Area (SGA) is a memory area that contains data shared between all database users such as buffer cache and a shared pool of SQL statements. The SGA is allocated in memory when an Oracle database instance is started, and any change in the v...
2020-07-07, 785👍, 0💬

What Is a Server Parameter File in Oracle
What Is a Server Parameter File in Oracle? A server parameter file is a binary file that acts as a repository for initialization parameters. The server parameter file can reside on the machine where the Oracle database server executes. Initialization parameters stored in a server parameter file are ...
2020-07-07, 717👍, 0💬

What Is an Initialization Parameter File in Oracle
What Is an Initialization Parameter File in Oracle? An initialization parameter file is a text file that contains a list of initialization parameters. The file should be written in the client's default character set. Sample initialization parameter files are provided on the Oracle distribution mediu...
2020-07-07, 671👍, 0💬

What Is a User Account in Oracle
What Is a User Account in Oracle? A user account is identified by a user name and defines the user's attributes, including the following: Password for database authentication Privileges and roles Default tablespace for database objects Default temporary tablespace for query processing work space   ⇒...
2020-07-07, 577👍, 0💬

Use SQL*Plus Built-in Timer in Oracle
How To Use SQL*Plus Built-in Timers in Oracle? If you don't have a stopwatch/timer and want to measure elapsed periods of time, you can SQL*Plus Built-in Timers with the following commands: TIMING - Displays number of timers. TIMING START [name] - Starts a new timer with or without a name. TIMING SH...
2020-06-08, 840👍, 0💬

SQL*Plus Commands Stored in a File in Oracle
How Run SQL*Plus Commands That Are Stored in a Local File in Oracle? If you have a group of commands that you need to run them repeatedly every day, you can save those commands in a file (called SQL script file), and using the "@fileName" command to run them in SQL*Plus. If you want to try this, cre...
2020-06-08, 756👍, 0💬

Show Execution Path Reports in Oracle
How To Get Execution Path Reports on Query Statements in Oracle? If your user account has autotrace configured by the DBA, you can use the "SET AUTOTRACE ON EXPLAIN" command to turn on execution path reports on query statements. The tutorial exercise bellow shows you a good example: SQL> CONN...
2020-06-08, 655👍, 0💬

Setup Autotrace for a User Account in Oracle
How To Set Up Autotrace for a User Account in Oracle? If an Oracle user wants to use the autotrace feature, you can use the tutorial as an example to create the required table PLAN_TABLE, the required security role PLUSTRACE, and grant the role to that user: SQL> CONNECT HR/retneciyf SQL&...
2020-06-08, 655👍, 0💬

What Is Oracle Server Autotrace in Oracle
What Is Oracle Server Autotrace in Oracle? Autotrace is Oracle server feature that generates two statement execution reports very useful for performance tuning: Statement execution path - Shows you the execution loop logic of a DML statement. Statement execution statistics - Shows you various execut...
2020-06-08, 616👍, 0💬

What Is SQL*Plus in Oracle
What Is SQL*Plus in Oracle? SQL*Plus is an interactive and batch query tool that is installed with every Oracle Database Server or Client installation. It has a command-line user interface, a Windows Graphical User Interface (GUI) and the iSQL*Plus web-based user interface.   ⇒Oracle Database Basic ...
2020-05-29, 777👍, 2💬

💬 2020-05-29 FYIcenter.com: @Frank, Yes. SQL*Plus offers you query tools to connect to remote Oracle servers.

💬 2020-05-27 Frank Jam: What the usage for SQL*Plus? Query tools

Understanding SQL Language Basics for Oracle
Where to find answers to frequently asked questions on SQL Language Basics for Oracle? Here is a list of frequently asked questions and their answers compiled by FYIcenter.com DBA team on SQL Language Basics for Oracle. Clear answers are provided with tutorial exercises on data types, data literals,...
2020-05-29, 790👍, 0💬

What Is SQL Standard in Oracle
What Is SQL Standard in Oracle? SQL, SEQUEL (Structured English Query Language), is a language for RDBMS (Relational Database Management Systems). SQL was developed by IBM Corporation. SQL became an ANSI standard, called SQL-87, in 1986. ISO made a major revision, called SQL-92, in 1992. The latest ...
2020-05-29, 764👍, 0💬

Oracle Built-in Data Types in Oracle
What Are the Oracle Built-in Data Types in Oracle? There are 20 Oracle built-in data types, divided into 6 groups: Character Datatypes - CHAR, NCHAR, NVARCHAR2, VARCHAR2 Number Datatypes - NUMBER, BINARY_FLOAT, BINARY_DOUBLE Long and Row Datatypes - LONG, LONG RAW, RAW Datetime Datatypes - DATE, TIM...
2020-05-29, 755👍, 0💬

Show Execution Statistics Reports in Oracle
How To Get Execution Statistics Reports on Query Statements in Oracle? If your user account has autotrace configured by the DBA, you can use the "SET AUTOTRACE ON STATISTICS" command to turn on execution statistics reports on query statements. The tutorial exercise bellow shows you a good example: S...
2020-05-29, 697👍, 0💬

Categories of Data Types in Oracle
How Many Categories of Data Types in Oracle? Oracles supports the following categories of data types: Oracle Built-in Datatypes. ANSI, DB2, and SQL/DS Datatypes. User-Defined Types. Oracle-Supplied Types.   ⇒Understanding SQL Language Basics for Oracle ⇒⇒Oracle Database Tutorials
2020-05-29, 695👍, 0💬

Introduction to Oracle Database 10g Express Edition
Where to find answers to frequently asked questions on Oracle Database 10g Express Edition? I want to learn how to install Oracle database. Here is a list of frequently asked questions and their answers compiled by FYIcenter.com DBA team on Oracle Database 10g Express Edition with installation instr...
2020-05-15, 983👍, 0💬

What Is Oracle Database 10g Express Edition in Oracle
What Is Oracle Database 10g Express Edition in Oracle? Based on Oracle Web site: Oracle Database 10g Express Edition (Oracle Database XE) is an entry-level, small-footprint database based on the Oracle Database 10g Release 2 code base that's free to develop, deploy, and distribute; fast to download;...
2020-05-15, 856👍, 0💬

What Is ODBC in Oracle
What Is Open Database Communication (ODBC) in Oracle? ODBC, Open Database Communication, a standard API (application program interface) developed by Microsoft for Windows applications to communicate with database management systems. Oracle offers ODBC drivers to allow Windows applications to connect...
2020-05-15, 844👍, 0💬

What Is Transport Network Substrate in Oracle
What Is Transport Network Substrate (TNS) in Oracle? TNS, Transport Network Substrate, is a foundation technology, built into the Oracle Net foundation layer that works with any standard network transport protocol.   ⇒Oracle Database Basic Concepts ⇒⇒Oracle Database Tutorials
2020-05-15, 788👍, 0💬

Download Oracle Database 10g XE in Oracle
How To Download Oracle Database 10g XE in Oracle? If you want to download a copy of Oracle Database 10g Express Edition, visit http://www.oracle.com/technolo gy/software/products/database/ xe/.If you are using Windows systems, there are downloads available for you: Oracle Database 10g Express Edition...
2020-05-05, 1822👍, 0💬

Verify 10g XE Server Installation in Oracle
How To Check Your Oracle Database 10g XE Installation in Oracle? If you want to check your fresh installation of 10g Express Edition without using any special client programs, you can use a Web browser with this address, http://localhost:8080/apex/. You will see the login page. Enter SYSTEM as the u...
2020-05-05, 872👍, 0💬

Limitations of Oracle Database 10g XE in Oracle
What Are the Limitations of Oracle Database 10g XE in Oracle? Oracle Database XE is free for runtime usage with the following limitations: Supports up to 4GB of user data (in addition to Oracle system data) Single instance only of Oracle Database XE on any server May be installed on a multiple CPU s...
2020-05-05, 742👍, 0💬

Install Oracle Database 10g XE in Oracle
How To Install Oracle Database 10g XE in Oracle? To install 10g universal edition, double click, OracleXEUniv.exe, the install wizard starts. It will guide you to finish the installation process. You should take notes about: The SYSTEM password you selected: fyicenter. Database server port: 1521. Da...
2020-05-05, 695👍, 0💬

1 2 3 4 5 6 > >>   Sort: Rank