 Related Questions Latest Answer : Yes : Schema objects can stored in different tablespace and a tablespace can contained one or more schema objects data. ... It consists ofone or more data files.one or more control files.two or more redo log files.The Database containsmultiple users/schemasone or more rollback segmentsone or more tablespacesData dictionary Enqueues are another type of locking mechanism used in Oracle. An enqueue is a more sophisticated mechanism which permits several concurrent processes to have varying degree of sharing of "known" Latest Answer : An enqueue is a sophisticated locking mechanism that permits several concurrent processes to share known resources to varying degrees. Any object that can be used concurrently can be protected with enqueues. For example, Oracle allows varying levels of ... 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 What kind of backup you take Physical / Logical? Which one is better and Why? Latest Answer : Logical backup means backing up the individual database objects such as tables, views , indexes.. using the utility called EXPORT, provided by Oracle. The objects exported in this way can be imported into either same database or into any other database. ... Tags : Backup How to write script for export backup in shell. Can you take online backup of a Control File If yes, How? Latest Answer : Yes you could take a online backup of a control file. SQL> alter database backup controlfile to trace;This will create a text copy of your controlfile. You could use this text file to recreate your controlfile. ... Latest Answer : We need to put the tablespaces in backup mode during hot backup so that writing to datafiles related to this tablespace would stop and be written in the archive logs instead during the period of the backup. If you will not put the tablespaces in backup ... What are the common problems while taking backups? What are the necessary steps to take backup on to tapes and disks in real time? Is it possible to resize tablespaces and data files? If yes, how? Latest Answer : Hi all,Yes i agree with the answer but resize in the sense,the size should also get decrease.we can decrease even the size of the datafile but the condition is the datafile should be empty. ...
Sponsored Links
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
1 
0