Topic : Architecture

What is oraInventory ?


Answer :

With bind variable in SQL; oracle can cache queries in a single time in the SQL cache area. This avoids a hard parse each time; which saves on various locking and latching resource we use to check object existence and so on.

Show Answer Discuss

What is Global Inventory ?


Answer :

When you are running dedicated server then process information stored inside the process global area (PGA) and when you are using shared server then the process information stored inside user global area (UGA).

Show Answer Discuss

What is SGA?


Answer :

The system global area is a group of shared memory area that is dedicated to oracle instance. All oracle process uses the SGA to hold information. The SGA is used to store incoming data and internal control information that is needed by the database.

Show Answer Discuss

What is a system change number (SCN)?


Answer :

SCN is a value that is incremented whenever a dirty read occurs. SCN is incremented whenever a deadlock occurs. SCN is a value that keeps track of explicit locks. SCN is a value that is incremented whenever database changes are made.

Show Answer Discuss

What is log switch?


Answer :

The point at which oracle ends writing to one online redo log file and begins writing to another is called a log switch. Sometimes you can force the log switch. ALTER SYSTEM SWITCH LOGFILE;

Show Answer Discuss