What tuning indicators can one use?
Outline the steps required for physical standby database creation?
Latest Answer: Hi all,IT IS POSSIBLE WITH THE HELP OF DATA GUARD.To create a physical standby database ,the standby databse should be in MRM(Managed recovery mode)Let we proceed with an example, let db10 is a production database server and db15 is ...
If one user is already updating the table and it has a lock, the other user cannot access the table to update. then why and how the deadlock situation arises ?please explain with example.
If Materialized view contains the actual data and has to be re-created every time the original table data is changed and we intent to refresh the data in the view.then what is the actual use of materialized
What are the common problems while taking backups? What are the necessary steps to take backup on to tapes and disks in real time?
Discuss the advantages and disadvantages of hierarchical database management system in comparison with RDBMS. Discuss types of applications suitable for hierarchical DBMS and RDBMS.
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.
Latest Answer: When "Y",export will mark the table to be loaded as one extent for the import utility. This option will use only if you want to do import. export size will not change if we use compress=y. ...
View page << Previous 1 2 3 4 [5] 6 7 8 9 10 Next >>
Go Top
