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 is the purpose of catlaog in oracle rman?

2 Answers   Value Labs,

Can you take Image Backups using RMAN? . Can you use Backupsets created by RMAN with any other utility

1 Answers   Tech Mahindra,

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

0 Answers  

what are the differences of where and if in SAS?

0 Answers  

How can we see the database version in os level

6 Answers   Oracle,




What is blocking and how would you troubleshoot it?

1 Answers  

what is the difference between catalog & nocatalog?

3 Answers   CSC,

How do you recover a datafile that has not been physically been backed up since its creation and has been deleted. Provide syntax example.

4 Answers  

What is the default fill factor value? : sql server DBA

0 Answers  

Explain about your sql server dba experience? : sql server DBA

0 Answers  

How many memory layers are in the shared pool?

3 Answers  

You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?

0 Answers  

For more DB Administration Interview Questions Click Here
Categories