Topic : Architecture

Explain briefly about Oracle database architecture?


Answer :

Oracle database architecture is a combination of instance and database.Instance is a combination of memory structures and background processes which helps in reading and writing the data to/from the database.


Mj : Nice answer Show Replies

Show Answer Discuss

What is difference between oracle SID and Oracle service name?


Answer :

Oracle SID is the unique name that uniquely identifies your instance/database where as the service name is the TNS alias can be same or different as SID.

Show Answer Discuss

Which buffer cache is called as Row cache also?


  • Library cache
  • Fixed Area/Reserved Area
  • Dictionary Cache
  • Result Cache

Answer :

Dictionary Cache

Show Answer Discuss

What are bind variables?


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 the difference between PGA and UGA?


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