Oracle和MySQL - 博客园

EVENT: 10231 "skip corrupted blocks on _table_scans_"

摘要： Event: 10231Text: skip corrupted blocks on _table_scans_-------------------------------------------------------------------------------Cause:Action: Corrupt blocks are skipped in table scans, and lis... 阅读全文

posted @ 2013-03-19 00:32 Oracle和MySQL 阅读(303) 评论(0) 推荐(0)

Script to Collect RAC Diagnostic Information (racdiag.sql)

摘要： Script:-- NAME: RACDIAG.SQL-- SYS OR INTERNAL USER, CATPARR.SQL ALREADY RUN, PARALLEL QUERY OPTION ON-- -------------------------------------------------------------------------- AUTHOR:-- Michael Pol... 阅读全文

posted @ 2013-03-19 00:32 Oracle和MySQL 阅读(283) 评论(0) 推荐(0)

SCRIPT - to Tune the 'SESSION_CACHED_CURSORS' and 'OPEN_CURSORS' Parameters

摘要： Script:select 'session_cached_cursors' parameter, lpad(value, 5) value, decode(value, 0, ' n/a', to_char(100 * used / value, '990') || '%') usagefrom ( select max(s.value) used from ... 阅读全文

posted @ 2013-03-19 00:32 Oracle和MySQL 阅读(197) 评论(0) 推荐(0)

SCRIPT TO GENERATE SQL*LOADER CONTROL FILE

摘要： This script prepares a SQL*Loader control file for a table already existing in the database. The script acceptsthe table name and automatically creates a file with the table name and extension 'ctl'.... 阅读全文

posted @ 2013-03-19 00:32 Oracle和MySQL 阅读(282) 评论(0) 推荐(0)

Script: Computing Table Size

摘要： This script calculates the average row size for all tables in a schema.It generates a script (getAvgCol.sql) from USER_TABLES and then runs it.The following type of SELECT is generated for each table ... 阅读全文

posted @ 2013-03-19 00:32 Oracle和MySQL 阅读(138) 评论(0) 推荐(0)

Data Block Cache Header Format Changes (Oracle8 Physical layout)

摘要： Oracle8 has introduced a change with the data block cache header format. Thebasic idea is that incarnation and sequence numbers stored in the cache headerhave been replaced with an SCN number and seq... 阅读全文

posted @ 2013-03-19 00:32 Oracle和MySQL 阅读(173) 评论(0) 推荐(0)

Setting an Oracle event:The structure of the trace syntax

摘要： PURPOSE-------The purpose of this article is to explain briefly the structure of the syntax toevent-based trace generation.Setting an event: The structure of the trace syntax--------------------------... 阅读全文

posted @ 2013-03-19 00:32 Oracle和MySQL 阅读(199) 评论(0) 推荐(0)

Know more about Oracle Latches

摘要： Two purposes of latches were:Serialize Execution,Serialize AccessMatch the characteristics with latches and enqueues.Several modes of access EnqueueFIFO queue acquisition... 阅读全文

posted @ 2013-03-19 00:32 Oracle和MySQL 阅读(424) 评论(0) 推荐(0)

EVENT: 10060 dump predicates in optimizer (kko)

摘要： Event:10060Text: dump predicates in optimizer (kko)-------------------------------------------------------------------------------Explanation: This is a special EVENT code. It should *... 阅读全文

posted @ 2013-03-19 00:32 Oracle和MySQL 阅读(259) 评论(0) 推荐(0)

EVENT:10211 check index block integrity

摘要： Event:10211 See for similar events / parameters~~~~~~~~~~~ Version/Use: 7.0 - 8.1.7 Check data block integrity after each modification 9.0+ This event i... 阅读全文