What column differentiates the V$ views to the GV$ views and
how?
Answer Posted / 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 |
Post New Answer View All Answers
how can you communicate with operating system files from oracle?
Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).
What purpose does the model database server? : sql server DBA
Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.
You create a private database link and upon
connection, fails with: ORA-2085: connects to
What is transparent data encryption? : sql server DBA
What are the different authentication modes in sql server and how can you change authentication mode? : sql server DBA
What is the default fill factor value? : sql server DBA
How can you tell how much space is left on a given file system and how much space each of the file system's subdirectories take-up?
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
what is the role of dip user in our database?
how can you get actual data change values from previous transactions in oracle?
what is a user-defined lock?
what are the performance views in an oracle rac environment?
who owns the operating system files created by the utl_file package?