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
What is the importance of a recovery model? : sql server DBA
How do you troubleshoot errors in a sql server agent job? : sql server DBA
what is the use of ocr?
Why would you call update statistics? : sql server DBA
What are the differences in clustering in sql server 2005 and 2008 or 2008 r2? : sql server DBA
how can you find out if a table can be redefined?
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
What is the difference between dropping a database and taking a database offline? : sql server DBA
What are the steps you will take to improve performance of a poor performing query?
Does transparent data encryption provide encryption when transmitting data across network? : sql server DBA
Why does Oracle not permit the use of PCTUSED with indexes?
who owns the operating system files created by the utl_file package?
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.
how can you create a user-defined lock?
What are the different ways you can create databases in sql server? : sql server DBA