Page 1 2 3

This is a collection of 17 FAQs for Oracle DBA on fundamental concepts. The clear answers and sample scripts provided can be used as learning tutorials or interview preparation guides. Topics included in this FAQ are:

  1. What Is Oracle?
  2. What Is an Oracle Database?
  3. What Is an Oracle Instance?
  4. What Is a Parameter File?
  5. What Is a Server Parameter File?
  6. What Is a Initialization Parameter File?
  7. What is System Global Area (SGA)?
  8. What is Program Global Area (PGA)?
  9. What Is a User Account?
  10. What Is the Relation of a User Account and a Schema?
  11. What Is a User Role?
  12. What is a Database Schema?
  13. What Is a Static Data Dictionary?
  14. What Is a Dynamic Performance View?
  15. What Is SQL*Plus?
  16. What Is What Is Transport Network Substrate (TNS)?
  17. What Is Open Database Communication (ODBC)?

Descriptions of some key concepts are based on Oracle documentations.

What Is Oracle?

Oracle is a company. Oracle is also a database server, which manages data in a very structured way. It allows users to store and retrieve related data in a multiuser environment so that many users can concurrently access the same data. All this is accomplished while delivering high performance. A database server also prevents unauthorized access and provides efficient solutions for failure recovery.

What Is an Oracle Database?

An Oracle database is a collection of data treated as a big unit in the database server.

What Is an Oracle Instance?

Every running Oracle database is associated with an Oracle instance. When a database is started on a database server (regardless of the type of computer), Oracle allocates a memory area called the System Global Area (SGA) and starts one or more Oracle processes. This combination of the SGA and the Oracle processes is called an Oracle instance. The memory and processes of an instance manage the associated database’s data efficiently and serve the one or multiple users of the database.

What Is a Parameter File?

A parameter file is a file that contains a list of initialization parameters and a value for each parameter. You specify initialization parameters in a parameter file that reflect your particular installation. Oracle supports the following two types of parameter files:

  • Server Parameter Files - Binary version. Persistent.
  • Initialization Parameter Files - Text version. Not persistent.

What Is a Server Parameter File?

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 persistent, in that any changes made to the parameters while an instance is running can persist across instance shutdown and startup.

What Is a Initialization Parameter File?

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 medium for each operating system. A sample file is sufficient for initial use, but you will probably want to modify the file to tune the database for best performance. Any changes will take effect after you completely shut down and restart the instance.

What is System Global Area (SGA)?

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 value will take effect at the next startup 

Page 1 2 3