What column differentiates the V$ views to the GV$ views and
how?

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the importance of a recovery model? : sql server DBA

552


How do you troubleshoot errors in a sql server agent job? : sql server DBA

566


what is the use of ocr?

600


Why would you call update statistics? : sql server DBA

579


What are the differences in clustering in sql server 2005 and 2008 or 2008 r2? : sql server DBA

548






how can you find out if a table can be redefined?

595


If you are given access to a sql server, how do you find if the sql instance is a named instance or a default instance? : sql server DBA

564


What is the difference between dropping a database and taking a database offline? : sql server DBA

578


What are the steps you will take to improve performance of a poor performing query?

2420


Does transparent data encryption provide encryption when transmitting data across network? : sql server DBA

601


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

2327


who owns the operating system files created by the utl_file package?

564


Draft one mock email requesting your non-technical management grant you downtime to (provide justification where applicable) complete the following tasks: (1) Generate statistics on a large table; (2) Generate an RDA – if you don't know what an RDA is please say so. (3) Rename datafiles.

1690


how can you create a user-defined lock?

584


What are the different ways you can create databases in sql server? : sql server DBA

599