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
how can you initialize log miner?
how can you process messages in order asynchronously?
. 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?
what is a user-defined lock?
How would you extract DDL of a table without using a GUI tool?
what are the performance views in an oracle rac environment?
Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.
what is the role of dip user in our database?
What are the commands used in dcl? : sql server DBA
What is a correlated sub-query? : sql server DBA
What is dbcc? : sql server DBA
can u plz tell me what r the mandatory skills for getting job as a sql dba......plz send me all details thank you my id :k.mohann.mohan@gmail.com
What is replication? : sql server DBA
How do you troubleshoot errors in a sql server agent job? : sql server DBA
What are the differences in clustering in sql server 2005 and 2008 or 2008 r2? : sql server DBA