Database is hung. Old and new user connections alike hang on
impact. What do you do? Your SYS SQLPLUS session IS able to
connect.
No Answer is Posted For this Question
Be the First to Post Answer
A table is classified as a parent table and you want to drop and re-create it. How would you do this without affecting the children tables?
i need a brief information about db2 dba course and realtime experts if any plz inform me nareshbhupathi93@gmail.com plzzz urgent
Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.
Describe what redo logs are.
what is the use of ocr?
How would you edit your CRONTAB to schedule the running of /test/test.sh to run every other day at 2PM?
Can you take Online Backups if the the database is running in NOARCHIVELOG mode? 5. How do you bring the database in ARCHIVELOG mode from NOARCHIVELOG mode? 6. You cannot shutdown the database for even some minutes, then in which mode you should run the database?
11 Answers FA, GE, Wipro,
what is the differnce between process and thread ?
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?
how can you initialize log miner?
Why does Oracle not permit the use of PCTUSED with indexes?
What is the default fill factor value? : sql server DBA
Oracle (3253)
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)