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 functionality does oracle provide to secure sensitive information?
What are the recovery models for a database? : sql server DBA
I got an error SQL1042C. An unexpected system error occurred. Explanation: A system error occurred. One possible reason for this error is that the database manager is not installed correctly or the environment is not set up correctly. On OS/2, while trying to start the database manager, a very common reason for this error is a corrupted NET.ACC file. The command cannot be processed. The tables and views would not be opened. What is the way to open the dataase? pls help me
What are the high-availability solutions in sql server and differentiate them briefly? : sql server DBA
What are the different types of database compression introduced in sql server 2008? : sql server DBA
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?
what do you understand by fine-grained auditing?
Where do you find the default index fill factor and how to change it? : sql server DBA
Which autogrowth database setting is good? : 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 generate profile of pl/sql applications to identify performance bottlenecks?
What are the operating modes in which database mirroring runs? : sql server DBA
how do we explain a project in cognos in an interview? please help me. Also how do we perform testing in cognos after creating reports?
What is the difference between the 2 operating modes of database mirroring? : sql server DBA
What are the steps you will take to improve performance of a poor performing query?