How can we see the database version in os level
- 6 Answers
- 11016 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
what is the use of recording information about current session?
how can you communicate with operating system files from oracle?
Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?
Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?
how can you generate profile of pl/sql applications to identify performance bottlenecks?
What are the commands you'd issue to show the explain plan for "select * from dual"?
Claims and Drains are the locks used to control the concurrency between SQL processes and utilities. Referring to the above statement, what is the maximum number of concurrent Claimers for a Subsystem? Choice 1 32 Choice 2 64 Choice 3 128 Choice 4 256 Choice 5 No limit
You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?
What are the operating modes in which database mirroring runs? : sql server DBA
Why would you use sql agent? : sql server DBA
How would you best determine why your MVIEW couldn't FAST REFRESH?
currently iam working in mnc as a oracleappsdba,please send the EXPERIENCE RESUME those who r worked as a oracle apps dba
which background process invoke at the time of upgradation tell me???
Does transparent data encryption provide encryption when transmitting data across network? : sql server DBA
What is the difference between dropping a database and taking a database offline? : sql server DBA
