Topic : Architecture

How to check Oracle database version?


Answer :

SQL> Select * from v$version;

Show Answer Discuss

What is difference between oracle SID and Oracle service name?


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 the difference between SMON and PMON processes?


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

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.

Show Answer Discuss

How to perform logswitch?


Answer :

Alter system switch logfile;

Show Answer Discuss