Interested to Buy Any Domain ? << Click Here >> for more details...
What column differentiates the V$ views to the GV$ views and
how?
- 3 Answers
- 10371 Views
- I also Faced
- E-Mail Answers
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
You create a private database link and upon
connection, fails with: ORA-2085: connects to
What is the difference between clustered and non-clustered index? : sql server DBA
What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?
Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.
what are the differences of where and if in SAS?
What are the commands you'd issue to show the explain plan for "select * from dual"?
what is the role of dip user in our database?
how can you enable flashback feature?
i have 10gp file.now i need store in database..but database have only 7gb memory only..how do u store the file ?
What is dcl? : sql server DBA
Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).
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 is grd?
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.
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.
