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 are the differences in clustering in sql server 2005 and 2008 or 2008 r2? : sql server DBA
How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?
Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.
I have kept recovery catalog on same target database and taken backup of target DB to disk. deleted the target DB & tried to restore and revoer DB using the backup on disk but it is not possible, how do we restore & recover DB
What are the different types of indexes available in sql server? : sql server DBA
What types of replication are supported in sql server? : sql server DBA
What are the commands you'd issue to show the explain plan for "select * from dual"?
Why would you call update statistics? : sql server DBA
What is a system database and what is a user database? : sql server DBA
What authentication modes does sql server support? : sql server DBA
Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracle's. What database recovery options are available? Database is in archive log mode.
how can you generate profile of pl/sql applications to identify performance bottlenecks?
how can you create a user-defined lock?
how can you schedule a job in database?
What purpose does the model database server? : sql server DBA