Concepts and Architecture Question:

Download Job Interview Questions and Answers PDF

What is SID (System Identifier)?

Oracle Architecture and Concepts Interview Question
Oracle Architecture and Concepts Interview Question

Answer:

A SID (almost) uniquely identifies an instance. Actually, $ORACLE_HOME, $ORACLE_SID and $HOSTNAME identify an instance uniquely. The SID is 64 characters, or less; at least on Oracle 9i. The system identifier is included in the CONNECT_DATA parts of the connect descriptors in a tnsnames.ora file. The SID defaults to the database name.

Download Oracle Architecture and Concepts Interview Questions And Answers PDF

Previous QuestionNext Question
From where does PMON gets the conformance about failure? How is the user process terminated?What is Global Database Name?