What column differentiates the V$ views to the GV$ views and
how?
Answer Posted / mahesh
GV$ view is a global view of v$. GV$ view contains on extra
column called Inst_ID which indicates the instance ID of
ordered query. This ID is useful for session tracking.
| Is This Answer Correct ? | 16 Yes | 1 No |
Post New Answer View All Answers
What are the operating modes in which database mirroring runs? : sql server DBA
how to restore files with rman?
How would you extract DDL of a table without using a GUI tool?
what is the use of ocr?
what are the types of connection load-balancing?
You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?
How would you go about verifying the network name that the local_listener is currently using?
can u plz tell me what r the mandatory skills for getting job as a sql dba......plz send me all details thank you my id :k.mohann.mohan@gmail.com
What is dcl? : sql server DBA
what is the last version,the release date of that version and fix pack of ibm db2 udb?
What is the importance of a recovery model? : sql server DBA
What are the steps you will take to improve performance of a poor performing query?
what is a user-defined lock?
In what script is "snap$" created? In what script is the "scott/tiger" schema created?
how can you communicate with operating system files from oracle?