> 文章列表 / Page 326

This practice uses common UNIX and Windows NT utilities to visualize key TCP/IP protocols. You will: See IP information using the IPCONFIG utility. Understand and overcome IP fault situations using th...

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 tabl...

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'....