Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  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

by issuing "alter tablespace begin backup;" what happens to tablespace?

5 Answers   CSC, Logica CMG,

How do you tell what your machine name is and what is its IP address?

4 Answers  

How to bind a cobol module to a given job? I am not able to understand this concept.Can anyone help me out as how to carry out this task?

0 Answers   EDS,

How can you gather statistics on a table?

3 Answers  

WHERE CAN WE SEE THE COMPLETE BACKBROUNG PROCESS IN RAC ENVIRONMENT THROUGH UNIX COMMAND.

2 Answers   Cognizant,

What view(s) do you use to associate a user's SQLPLUS session with his o/s process?

0 Answers  

How would you determine the time zone under which a database was operating?

2 Answers  

how can you schedule a job in database?

0 Answers   Oracle,

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

0 Answers  

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

0 Answers  

Where in the Oracle directory tree structure are audit traces placed?

1 Answers  

What is the difference between the 2 operating modes of database mirroring? : sql server DBA

0 Answers  

For more DB Administration Interview Questions Click Here
Categories