1. Categories >> Software >> Databases >> DB Administration
  2. Suggest New Category

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

Question Posted / guest

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

What are the recovery models for a database? : sql server DBA

0 Answers  

What are the different sql server versions you have worked on? : sql server DBA

0 Answers  

How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?

0 Answers  

Can you redefine a table online?

0 Answers   Oracle,

what is the difference between hot backup n rman backup?

1 Answers   Value Labs,




What are the commands used in dcl? : sql server DBA

0 Answers  

How would you force a log switch?

4 Answers  

What is transparent data encryption? : sql server DBA

0 Answers  

I lost one datafile i dont have backup how can you recover that???

2 Answers   HP,

How can we know the exact updation date of a particular database?

2 Answers   Satyam,

What background process refreshes materialized views?

2 Answers   Accenture, FLSmidth,

What is the difference between Datapump & export/import?

2 Answers  

For more DB Administration Interview Questions Click Here
Categories