what is the use of ocr?
No Answer is Posted For this Question
Be the First to Post Answer
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 differnce between process and thread ?
Describe what redo logs are.
What happens on checkpoint? : sql server DBA
Explain the use of setting GLOBAL_NAMES equal to TRUE.
Which dictionary tables and/or views would you look at to diagnose a locking issue?
What are the ways tablespaces can be managed and how do they differ?
Give the stages of instance startup to a usable state where normal users may access it.
When a user process fails, what background process cleans up after it?
What the different topologies in which replication can be configured? : sql server DBA
what is incremental checkpoint?
Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.