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

How do you find out from the RMAN catalog if a particular archive log has been backed-up?

2 Answers   IBM,

can u plz tell me what r the mandatory skills for getting job as a sql dba......plz send me all details thank you my id :k.mohann.mohan@gmail.com

0 Answers  

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  

How do you resize a data file?

2 Answers  

Why does Oracle not permit the use of PCTUSED with indexes?

0 Answers  

You have just compiled a PL/SQL package but got errors, how would you view the errors?

3 Answers  

how will you see when the database was started using sql prompt?

2 Answers   IBM,

As a part of your job, what are the DBCC commands that you commonly use for database maintenance?

1 Answers   IBM,

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 is rebuild index??

2 Answers   IBM, Sapient,

What is a correlated sub-query? : sql server DBA

0 Answers  

How do you trace the traffic hitting a sql server? : sql server DBA

0 Answers  

For more DB Administration Interview Questions Click Here
Categories