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 purpose does the model database server? : sql server DBA
How many files can a database contain in sql server?how many types of data files exists in sql server? How many of those files can exist for a single database? : sql server DBA
What would you do with an "in-doubt" distributed transaction?
how does an oracle clusterware manage crs resources?
How would you go about verifying the network name that the local_listener is currently using?
What are the commands used in dcl? : sql server DBA
What is a correlated sub-query? : sql server DBA
what is grd?
how can you get actual data change values from previous transactions in oracle?
internal architecture
what is the use of ocr?
which background process invoke at the time of upgradation tell me???
Where would you look for errors from the database engine?
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 are the differences of where and if in SAS?