How can we see the database version in os level
Answer Posted / kittu
]$ $ORACLE_HOME/OPatch/optach lsinventory -all
the above statement will display total oracle software locations
Is This Answer Correct ? | 9 Yes | 3 No |
Post New Answer View All Answers
how can you schedule a job in database?
how can you enable flashback feature?
A table is classified as a parent table and you want to drop and re-create it. How would you do this without affecting the children tables?
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
how does an oracle clusterware manage crs resources?
Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).
What are the different sql server versions you have worked on? : sql server DBA
How do you open a cluster administrator? : sql server DBA
What are the commands you'd issue to show the explain plan for "select * from dual"?
What is the importance of a recovery model? : sql server DBA
Why would you use sql agent? : sql server DBA
In which dictionary table or view would you look to determine at which time a snapshot or MVIEW last successfully refreshed?
what do you understand by fine-grained auditing?
suppose you want to audit specific activities on sensitive data. How can you achieve that?
Explain materialized views and how they are used.