Maclean’s Oracle Database Tech Blog Archives

Error:  ORA 10061 Text:   disable SMON from cleaning temp segment ——————————————————————————- Explanation:         This is NOT an error but is a special EVENT code.         It should *NOT* be used unless explicitly requested by RD support.         It allows you to prevent SMON from cleaning up temporary segments.         If set in:          7.0.X:            …

Error: ORA 10212 Text: check cluster integrity ——————————————————————————- Explanation: This is NOT an error but is a special EVENT code. It should *NOT* be used unless explicitly requested by RD support. Event 10212 enables cluster block integrity checking. The causes a number of checks on the contents of a block. If the block is found…

Error: ORA 10228 Text: trace application of redo by kcocbk ——————————————————————————- Explanation: This is NOT an error but is a special EVENT code. It should *NOT* be used unless explicitly requested by RD support. Event 10228 is potentially useful in recovery situations since it traces the application of redo. Therefore, if cache recovery appears to…

Event:10210 See for similar events / parameters ~~~~~~~~~~~ Version/Use: 7.0 – 8.1.7 Check data block integrity after each modification 9.0+ This event is no longer valid. Use <Parameter:DB_BLOCK_CHECKING> instead. 7.0 – 8.1.7 “Check data block integrity after each modification” ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ NOTE: Events should NEVER be set by customers unless advised to do so by Oracle…

ksedmp             # KSE: dump the process state ksfdmp             # Call relevant dump routine kgeasi             # Raise an error on an ASSERTION failure (IGNORE) ktcrab             KTC: Kernel Transaction Control Real ABort – Abort a transaction. ktcsod             KTC: Transaction Control: STATE OBJECT PROCEDURE VECTOR DEFINITION kssdch_stage        kssdch             KSS: delete children of state obj. ksures              ktmres             ktmres -…

A nonunique index can be used to enforce a primary key or unique constraint. In Oracle8i indexes can be rebuilt without locking the table. The DROP COLUMN option of the ALTER TABLE command is restartable. The MOVE option of the ALTER TABLE command retains the constraints of the table. Data rows in the global temporary…

Materialized Views and Refresh Types This practice will familiarize you with the various features and privileges to ensure successful creation of a materialized view from a base table. 1) Grant the necessary privileges for user Scott to create materialized views and allow query rewrite on the materialized views owned by schema Scott. As user SYSTEM,…

Event: 10231 Text: skip corrupted blocks on _table_scans_ ——————————————————————————- Cause: Action: Corrupt blocks are skipped in table scans, and listed in trace files. Explanation: This is NOT an error but is a special EVENT code. It should *NOT* be used unless explicitly requested by ST support. 8.1 onwards: ~~~~~~~~~~~~ The “7.2 onwards” notes below still…

PURPOSE This document provides an example of DBMS_REPAIR as introduced in Oracle 8i. Oracle provides different methods for detecting and correcting data block corruption – DBMS_REPAIR is one option. WARNING: Any corruption that involves the loss of data requires analysis to understand how that data fits into the overall database system. Depending on the nature…

PURPOSE ——- The purpose of this article is to explain briefly the structure of the syntax to event-based trace generation. Setting an event: The structure of the trace syntax ————————————————— @ A comprehensive/full overview of the event syntax can be found in: @ Note:9331.1 – Full Event Syntax (from ksdp.c) @ Note:45217.1 – Summary Event…