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
How do you troubleshoot errors in a sql server agent job? : sql server DBA
What is the difference between the 2 operating modes of database mirroring? : sql server DBA
How would you extract DDL of a table without using a GUI tool?
how can you get actual data change values from previous transactions in oracle?
What types of replication are supported in sql server? : sql server DBA
List out some of the requirements to setup a sql server failover cluster.? : sql server DBA
what is asm?
How would you go about verifying the network name that the local_listener is currently using?
When setting replication, can you have distributor on sql server 2005, publisher on sql server 2008? : sql server DBA
suppose you want to audit specific activities on sensitive data. How can you achieve that?
How would you best determine why your MVIEW couldn't FAST REFRESH?
what do you understand by flashback feature of oracle?
What is dcl? : sql server DBA
What are the new features in sql server 2005 when compared to sql server 2000? : sql server DBA
What is a system database and what is a user database? : sql server DBA