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


Please Help Members By Posting Answers For Below Questions

What purpose does the model database server? : sql server DBA

630


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

657


What would you do with an "in-doubt" distributed transaction?

1419


how does an oracle clusterware manage crs resources?

573


How would you go about verifying the network name that the local_listener is currently using?

2763






What are the commands used in dcl? : sql server DBA

579


What is a correlated sub-query? : sql server DBA

583


what is grd?

638


how can you get actual data change values from previous transactions in oracle?

614


internal architecture

1755


what is the use of ocr?

602


which background process invoke at the time of upgradation tell me???

2229


Where would you look for errors from the database engine?

2356


Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.

1548


what are the differences of where and if in SAS?

1664