|
| Home | Tech FAQ | Interview Questions | Placement Papers | Tech Articles | Learn | Freelance Projects | Online Testing | Geeks Talk | Job Postings | Knowledge Base | Site Search | Add/Ask Question |
 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 : Go to OEM => Databases => ... => Instance => Configuration, in "Database and Instance Information" section, the last row shows spfile ... Latest Answer : run this query in the sql promptsql> select tablespace_name,file_name from dba_data_files; ... Read Answers (2) | 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 : hi,In Oracle we can take the backup of our database in two mode cold backup or hot backup. When we want to take the hot backup of database when user is accessing the data, we can put the tablespace in backup mode. ... 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? What is mutated trigger? In single user mode we got mutated error, as a DBA how you will resolve it? How to check to memory gap once the SGA is started in Restricted mode?
Sponsored Links
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
