What column differentiates the V$ views to the GV$ views and
how?
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / shrinidhi
The INST_ID column which indicates the instance in a RAC environment the information came from.
| Is This Answer Correct ? | 3 Yes | 1 No |
Answer / 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 |
A lady is trying to pick gloves and hats from her wardrobe in the dark. She has 22 white and 33 green ones. She wants to pick a pair of gloves of white and green. How many tries before she gets it right?
In which dictionary table or view would you look to determine at which time a snapshot or MVIEW last successfully refreshed?
now one user in online.now i want drop him..how do u drop him?
How many packages we have in db
the process of adding a cpu in sql server is called..?
Which dictionary tables and/or views would you look at to diagnose a locking issue?
What does coalescing a tablespace do?
In what script is "snap$" created? In what script is the "scott/tiger" schema created?
If you are given access to a sql server, how do you find if the sql instance is a named instance or a default instance? : sql server DBA
when does an alert gets signaled?
what is asm?
what do you understand by fine-grained auditing?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)