> 文章列表 / Page 331

Oracle8 has introduced a change with the data block cache header format. The basic idea is that incarnation and sequence numbers stored in the cache header have been replaced with an SCN number and se...

Script: select 'session_cached_cursors' parameter, lpad(value, 5) value, decode(value, 0, ' n/a', to_char(100 * used / value, '990') || '%') usage from ( select max(s.value) used from v$statname n, v$...

This script prepares a SQL*Loader control file for a table already existing in the database. The script accepts the table name and automatically creates a file with the table name and extension 'ctl'....