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

Datapump backup steps?

1 Answers  

How would you go about verifying the network name that the local_listener is currently using?

0 Answers  

Explain the difference between ARCHIVELOG mode and NOARCHIVELOG mode and the benefits and disadvantages to each.

5 Answers  

What are the commands you'd issue to show the explain plan for "select * from dual"?

0 Answers  

Which types of backups you can take in Oracle? 2. A database is running in NOARCHIVELOG mode then which type of backups you can take? 3. Can you take partial backups if the Database is running in NOARCHIVELOG mode?

1 Answers  




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

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 do you understand by fine-grained auditing?

0 Answers   Oracle,

what is ora 24313?what is the procedure to exclude that error?

0 Answers  

What are the different types of database compression introduced in sql server 2008? : sql server DBA

0 Answers  

A table is classified as a parent table and you want to drop and re-create it. How would you do this without affecting the children tables?

0 Answers  

How many memory layers are in the shared pool?

3 Answers  

For more DB Administration Interview Questions Click Here
Categories