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
10643 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 do you increase the OS limitation for open files (LINUX and/or Solaris)?

1 Answers

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

0 Answers

i have 10gp file.now i need store in database..but database have only 7gb memory only..how do u store the file ?

0 Answers IBM,

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

0 Answers

when we login sql editor using username and password then it says this error "could not resolve service name" then what can we do at client side.( here thing is tnsnames.ora file is ok till yesterday and worked well, but now it giving error.

0 Answers

What command would you use to encrypt a PL/SQL application?

1 Answers

How would you force a log switch?

4 Answers

Is it possible to run 32 bit sql server 2000 on64bit windows platform.if how much memory is available to sql server?

1 Answers

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

0 Answers

when does an alert gets signaled?

0 Answers Oracle,

what is the use of ocr?

0 Answers Oracle,

How would you extract DDL of a table without using a GUI tool?

0 Answers

For more DB Administration Interview Questions Click Here