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. ...
exp userid=system/manager file=expfile.dmp log=expfile.log full=Y compress=Y buffer=1000000If i do't mention compress & buffer parameter , then this query will run/not.
Latest Answer: Yes, exactly it will run perfectly because compress and buffer both are optional. ...
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 ...
My database size is 100GB. I am using compress parameter. Will my database size reduce, remain same, Increase. What will Happen.
How to check whether database whether it is opened by pfile/spfile.
Latest Answer: Another alternative: SHOW PARAMETER SPFILE; ...
Explain the differences between 9i OEM & 10G OEM along with new features that changes the way you do your daily job
Db_buffercache : How we will tune it.
I have to check used space/unused space in table space. Which view /command will provide me the desired answer.
Latest Answer: dba_free_spaces and dba_segments ...
How the data is processed in DB Buffer Cache.
What are the changes that happen in Database buffer cache(List of all changes in DB Buffer Cache)
View page << Previous 1 2 3 4 [5] 6 7 8 9 10 Next >>
Go Top
