-
Determine Number of Blocks Corrupted
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?
kunal1017
- Apr 1st, 2008
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= &...
hemant.agarwal03
- Mar 12th, 2008
You can check the "V_$DATABASE_BLOCK_CORRUPTION" view to determine the corrupted blocks.
-
What is difference between base table and data dictionary views?
kunal1017
- Jan 10th, 2008
HiBase tables are made when the database is created and these tables are stored in data dictionary. these base tables contains the information related to the database. these tables are own by sys.th...
-
What are the advantages of managing space using automatic segment space managed objects?
kunal1017
- Aug 28th, 2008
The automatic space management is enabled by using SEGMENT SPACE MANAGEMENT AUTO clause in create tablespace statement. It uses the bitmap segments to keep track of used and free space in segmen...
-
What are the advantages of data definition language (DDL) statements against a partitioned table with the UPDATE GLOBAL INDEXES clause?
kunal1017
- Aug 28th, 2008
When you perform DDL commands on a partition table then you should use UPDATE GLOBAL INDEXES clause. GLOBAL INDEXES are different from LOCAL INDEXES. Local Indexes are the indexes on partitions of...
-
Which outline category is used when you use ALTER SESSION to set USE_STORED_OUTLINE to true.
kunal1017
- Aug 28th, 2008
In this case DEFAULT category will be used. If the outline for your query is not stored in DEFAULT category then this query will not use the stored outline and it will execute normally without using any stored outline.
