 Related Questions Latest Answer : It is the file where actual data are stored. It is the physical part of the database ... 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 ... Thhere are 3 different ways :-1) SELECT name, value FROM v$parameter WHERE name = 'spfile'; //This query will return NULL if you are using PFILE2) SHOW PARAMETER spfile // This query will returns Latest Answer : select * from v$parameter where name='spfile'; ... Latest Answer : select file_name, tablespace_namefromdba_data_files; ... Read Answers (3) | Asked by : sushil k What is your datafile size? How long it can go? What is the max limit to which you can extend? Latest Answer : v$datafile data dictionary view will tell us the size of a datafile.to check the number of datafile you can check db_files init parameter. you can also alter this parameter but it will reflect after restartthe database.you can also resize the datafile ... You have a database. You have a datafile and some blocks are corrupted in the datafile. What statement will you issue to know how many blocks are corrupted? Latest Answer : you can use the DBVERIFY utility to check the corruption in datafiles so that you can now number of blocks corrupted.Here is the procedure :On o/s prompt login as oracle user : $ dbv file= 'datafile name'now in the output check for the ... 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 ... There are 100 datafiles, numbered from 1 to 100. File number 10 is deleted and it has 500 MB of data. The database is working in No-Archive log mode. How can the database be recovered? Latest Answer : This can be easily done but you will loose the data if you don't restore from backup.If you have a backup of datafiles and controlfile then restore them.If you don't have the backup then you need to usealter database create datafile 'new_filename.dbf' ... 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. ... How to check to memory gap once the SGA is started in Restricted mode?
Sponsored Links
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
