What column differentiates the V$ views to the GV$ views and how?

What column differentiates the V$ views to the GV$ views and
how?

Question Posted / guest

3 Answers
10551 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

What column differentiates the V$ views to the GV$ views and how?..

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

What column differentiates the V$ views to the GV$ views and how?..

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

What column differentiates the V$ views to the GV$ views and how?..

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

Post New Answer

More DB Administration Interview Questions

how can you process messages in order asynchronously?

0 Answers Oracle,

Where do you find the default index fill factor and how to change it? : sql server DBA

0 Answers

Explian different types of BACKUPs avaialabe in SQL Server? Given a particular scenario, how would you go about choosing a backup plan?

1 Answers

What types of replication are supported in sql server? : sql server DBA

0 Answers

when does an alert gets signaled?

0 Answers Oracle,

how does an oracle clusterware manage crs resources?

0 Answers Oracle,

what is the last version,the release date of that version and fix pack of ibm db2 udb?

0 Answers

What is the difference between a TEMPORARY tablespace and a PERMANENT tablespace?

2 Answers

Which environment variables are absolutely critical in order to run the OUI?

2 Answers

What is the difference between clustered and non-clustered index? : sql server DBA

0 Answers

You have just had to restore from backup and do not have any control files. How would you go about bringing up this database?

3 Answers

What query tells you how much space a tablespace named "test" is taking up, and how much space is remaining?

1 Answers

For more DB Administration Interview Questions Click Here