How can we see the database version in os level
- 6 Answers
- 11430 Views
- Oracle, I also Faced
- E-Mail Answers
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?
what do you understand by flashback feature of oracle?
How do you open a cluster administrator? : sql server DBA
What are the operating modes in which database mirroring runs? : sql server DBA
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.
how can you get actual data change values from previous transactions in oracle?
Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?
who owns the operating system files created by the utl_file package?
In which dictionary table or view would you look to determine at which time a snapshot or MVIEW last successfully refreshed?
What are the different authentication modes in sql server and how can you change authentication mode? : sql server DBA
What are the steps you will take to improve performance of a poor performing query?
Explain about your sql server dba experience? : sql server DBA
How do you trace the traffic hitting a sql server? : sql server DBA
What are the different types of indexes available in sql server? : sql server DBA
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.
