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 ...
What is standby databases? Difference between Physical and logical standby databases
Latest Answer: A standby database is a transactionally consistent copy of the primary database. Using a backup copy of the primary database, you can create up to nine standby databases.A standby database can be either a physical standby database or a logical standby ...
What is a flash back query? This feature is also available in 9i. whats the difference between 9i and 10g (related to flash back query).
Latest Answer: Oracle 10g offers significant enhancements that help insure the high availability of any Oracle database, as well as improvements in the database disaster recovery arena. This paper explores one of the most intriguing new features of Oracle 10g: Flashback ...
Tell me any instance when your database encountered any problem. How you dealt with that problem.
Show one instance when you encountered an error in alert log and you overcome that error. What actions you took to overcome that error.
Latest Answer: Hi,Oracle write error in alert log file. Depending upon the error corrective action needs to be taken.1) DeadLock Error : Take the trace file in user dump destination and analysis it for the error.2) ORA-01555 Snapshot error. Check the query try to fine ...
Describe four properties of database isolation. In which situation lock contention will happen. What is transaction lock?
The ratio of disk (sort) is high. Is that good or bad? Why? How will you reduce disk sort?
Latest Answer: hi,Disk(sort)ratio is high is not good.Please set sort_area_retained_size and sort_area_size so that session can sort in max in memory. ...
What is simple replication and advance replication? What is the difference between simple replication and advance replication? How can we do simple replication?
DBMS_meta_data. This parameter is very usefull. What you infer from this parameter. What info you will find in that. explain in detail.
Latest Answer: To find the structure of a external table we used this package.syntax is below:SELECT DBMS_METADATA.GET_DDL ('TABLE','')||';' FROM DUAL ...
What is Cache Fusion Technology?
Latest Answer: Cache Fusion is a new technology that uses a high speed interprocess communication (IPC) interconnect to provide cache to cache transfers of data blocks between instances in a cluster. This eliminates disk I/O (which is inherently slow, since it is a ...
View page << Previous 4 5 6 7 [8] 9 10 11 12 13 Next >>
Go Top
