How can we see the database version in os level
Answer Posted / nagesh yadav
$ORACLE_HOME/oui
more oraparam.ini
OUI_VERSION=10.2.0.4.0
Is This Answer Correct ? | 6 Yes | 2 No |
Post New Answer View All Answers
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 is the role of dip user in our database?
How can you control the amount of free space in your index pages? : sql server DBA
What are the different authentication modes in sql server and how can you change authentication mode? : sql server DBA
how can you process messages in order asynchronously?
What happens on checkpoint? : sql server DBA
how can you enable flashback feature?
What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?
What is the difference between clustered and non-clustered index? : sql server DBA
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?
Oracle client is not able to connect to Oracle server although tnsnames.ora file has valid enteries. Oracle error message is “ cannot resolve net service name”. Mention any three reasons.
I have A,B,C servers.i want to 3 servers jobs move to D server(target server)..how? note: i said that take the backup of msdb and restore to the target server..he said while restoring jobs replaced. what is the solution
What are the different types of database compression introduced in sql server 2008? : sql server DBA
What is dcl? : sql server DBA