What column differentiates the V$ views to the GV$ views and
how?
Answer Posted / krishna
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 ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is replication? : sql server DBA
what is a crs resource?
Why would you call update statistics? : sql server DBA
What view(s) do you use to associate a user's SQLPLUS session with his o/s process?
List out some of the requirements to setup a sql server failover cluster.? : sql server DBA
What is a system database and what is a user database? : sql server DBA
What purpose does the model database server? : sql server DBA
What is the difference between clustered and non-clustered index? : sql server DBA
who owns the operating system files created by the utl_file package?
Explain about your sql server dba experience? : sql server DBA
Explain materialized views and how they are used.
how can you communicate with operating system files from oracle?
Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.
What is dcl? : sql server DBA
What is the importance of a recovery model? : sql server DBA