How can we see the database version in os level
Answers were Sorted based on User's Feedback
Answer / kittu
]$ $ORACLE_HOME/OPatch/optach lsinventory -all
the above statement will display total oracle software locations
| Is This Answer Correct ? | 9 Yes | 3 No |
Answer / nagesh yadav
$ORACLE_HOME/oui
more oraparam.ini
OUI_VERSION=10.2.0.4.0
| Is This Answer Correct ? | 6 Yes | 2 No |
Answer / vivek
Run sqlplus command and check.
$sqlplus username/password@connection string
| Is This Answer Correct ? | 0 Yes | 0 No |
how can you initialize log miner?
what is asm?
What does coalescing a tablespace do?
Give the stages of instance startup to a usable state where normal users may access it.
What is checkpoint?
If CPU is very slow What can u do to speed up?
Compare and contrast TRUNCATE and DELETE for a table.
SUPPOSE AS A DBA YOU CREATED ONE USER BY DEFAULT HOW MANY PRIVILIZES WILL COME TO USER & WHERE CAN YOU SEE THAT PRIVILIZES.
Explain how you would restore a database using RMAN to Point in Time?
Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?
When a user process fails, what background process cleans up after it?
WHEN DOWN TIME WHAT CAN U DO?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)