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
what do you understand by fine-grained auditing?
what is asm?
when does an alert gets signaled?
what are the performance views in an oracle rac environment?
who owns the operating system files created by the utl_file package?
how can you enable flashback feature?
internal architecture
What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?
Explain about your sql server dba experience? : sql server DBA
what is the role of dip user in our database?
how can you initialize log miner?
when we login sql editor using username and password then it says this error "could not resolve service name" then what can we do at client side.( here thing is tnsnames.ora file is ok till yesterday and worked well, but now it giving error.
How would you best determine why your MVIEW couldn't FAST REFRESH?
Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?
What is the difference between dropping a database and taking a database offline? : sql server DBA