internal architecture
No Answer is Posted For this Question
Be the First to Post Answer
You're getting high "busy buffer waits" - how can you find what's causing it?
how can you schedule a job in database?
What column differentiates the V$ views to the GV$ views and how?
You create a private database link <link name> and upon connection, fails with: ORA-2085: <Link name> connects to <fully qualified remote db name>. What is the problem? How would you go about resolving this error?
How do you find out from the RMAN catalog if a particular archive log has been backed-up?
what is the use of home directory???
Explain the concept of the DUAL table.
How does Oracle guarantee data integrity of data changes?
what is the difference between db2start command and start database manager command?
how can you create a user-defined lock?
Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracle's. What database recovery options are available? Database is in archive log mode.
What SQL query from v$session can you run to show how many sessions are logged in as a particular user account?
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)