ORACLE数据库服务热线：13764045638 诗檀软件

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

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

摘要： 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 ... 阅读全文

摘要： 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'.... 阅读全文

摘要： 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 ... 阅读全文

摘要： 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... 阅读全文

摘要： 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--------------------------... 阅读全文

摘要： ----------------------------------------------------------------------------------- Script: rolling_back.sql-- Purpose: to predict when transactions will finish rolling back-- For: 9.0+---- Copyright... 阅读全文

摘要： 在测试ASMlib的时候出现了oracleasm无法创建磁盘的错误，具体如下:[root@vrh1 yum.repos.d]# /etc/init.d/oracleasm configureConfiguring the Oracle ASM library driver.This will configure the on-boot properties of the Oracle ASM li... 阅读全文

摘要： X$BH Fixed Table Buffer Cache DiagramColumn Type Description~~~~~~ ~~~~~ ~~~~~~~~~~~ADDR RAW(4) Hex address of the Buffer Header.INDX NUMBER Buffer Header numberBUF# NUMBE... 阅读全文