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
internal architecture
A table is classified as a parent table and you want to drop and re-create it. How would you do this without affecting the children tables?
when does an alert gets signaled?
What is the difference between dropping a database and taking a database offline? : sql server DBA
Why would you use sql agent? : sql server DBA
What view(s) do you use to associate a user's SQLPLUS session with his o/s process?
how to restore files with rman?
What are statistics, under what circumstances they go out of date, how do you update them?
what is logical system in sap basis
what are the benefits of flashback feature?
Where do you find the default index fill factor and how to change it? : sql server DBA
What is the importance of a recovery model? : sql server DBA
What authentication modes does sql server support? : sql server DBA
Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?
how can you initialize log miner?