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

摘要： Good network security is accomplished by utilizing port and protocol screening with routers, firewalls,and Intrusion Detection Systems.Port and protocol screening with routers, firewalls,and Intrusion... 阅读全文

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

摘要： Error: ORA 10061Text: disable SMON from cleaning temp segment-------------------------------------------------------------------------------Explanation: This is NOT an error but is a special... 阅读全文