 Related Questions I am getting error "No Communication channel" after changing the domain name? what is the solution? Read Answers (2) | Asked by : nil You have taken import of a table in a database. you have got the Integrity constraint violation error. How you are going to resolve it. Read Answers (4) | Asked by : Gaurav Oracle DBA Questionswhat happen when we kill smon,what happen when we kill pmonwhat is fracture block and how to fix itwhat is corrupted block and how to fix itwhat are the oracle threads are going to start ,when we start the databasehow to check index is working properly ,what are the steps to be taken andon what basis we have to decide particular index has to rebuild not all indexeswhat steps to be taken if receive a call that performance has gone down as dba what steps has be takenWhat possible View Question | Asked by : Ibad Tags : Backup Show one instance when you encountered an error in alert log and you overcome that error. What actions you took to overcome that error. Latest Answer : Hi,Oracle write error in alert log file. Depending upon the error corrective action needs to be taken.1) DeadLock Error : Take the trace file in user dump destination and analysis it for the error.2) ORA-01555 Snapshot error. Check the query try to fine ... What is Ora1555 error. Snapshot too Old error. Explain in detail. Latest Answer : Oracle Rollback Segments (Undo more recently) hold a copy of data before it was modified, and they work in a round-robin fashion. Writing and then eventually overwriting the entries as soon as the changes are committed. They are needed to provide ... I have applied the following commands:Shutdown abortstartupNow what will happen, will the database will give an error / it will work. Latest Answer : Yes, Given no other factors, the database will start up without issue. You killed all sessions, killed all transactions, and didn't write from the buffers. Note that instance recovery will take place during startup. ... What should you do when you find a stacktrace in the server errorlog? What is mutated trigger? In single user mode we got mutated error, as a DBA how you will resolve it? Latest Answer : If you are using before in trigger block, then replace it with afterMutated error, when same table access more than once in one state. ... Explain Dual table. Is any data internally stored in dual table. Lot of users are accessing select sysdate from dual and they getting some millisecond differences. If we execute SELECT SYSDATE FROM EMP; Latest Answer : Dual is a system owned table created during database creation. Dual table consist of a single column and a single row with value xWe will not get any error if we execute select sysdate from scott.emp Instead sysdate will be treated as a psudo column ... If the SQL * Plus hangs for a long time, what is the reason?
Sponsored Links
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
0 
4