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 is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?
what is grd?
how can you get actual data change values from previous transactions in oracle?
. I have my backup RMAN script called "backup_rman.sh". I am on the target database. My catalog username/password is rman/rman. My catalog db is called rman. How would you run this shell script from the o/s such that it would run as a background process?
i have 10gp file.now i need store in database..but database have only 7gb memory only..how do u store the file ?
What would you do with an "in-doubt" distributed transaction?
what is the use of ocr?
what is logical system in sap basis
In which dictionary table or view would you look to determine at which time a snapshot or MVIEW last successfully refreshed?
Typically, where is the conventional directory structure chosen for Oracle binaries to reside?
What are the different authentication modes in sql server and how can you change authentication mode? : sql server DBA
what is the use of recording information about current session?
What is a correlated sub-query? : sql server DBA
what is a crs resource?
What is the difference between the 2 operating modes of database mirroring? : sql server DBA