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
Explain materialized views and how they are used.
You create a private database link and upon
connection, fails with: ORA-2085: connects to
How do you open a cluster administrator? : sql server DBA
what is a user-defined lock?
What types of replication are supported in sql server? : sql server DBA
What is the importance of a recovery model? : sql server DBA
Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.
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 many files can a database contain in sql server?how many types of data files exists in sql server? How many of those files can exist for a single database? : sql server DBA
how can you record information about current session?
What is the difference between clustered and non-clustered index? : sql server DBA
how do we explain a project in cognos in an interview? please help me. Also how do we perform testing in cognos after creating reports?
How would you go about verifying the network name that the local_listener is currently using?
How to start SQL Server in minimal configuration mode?
Why would you call update statistics? : sql server DBA