> 文章列表 / Page 330

PURPOSE This document provides an example of DBMS_REPAIR as introduced in Oracle 8i. Oracle provides different methods for detecting and correcting data block corruption - DBMS_REPAIR is one option. W...

PURPOSE ------- The purpose of this article is to explain briefly the structure of the syntax to event-based trace generation. Setting an event: The structure of the trace syntax ---------------------...

Script: -- NAME: RACDIAG.SQL -- SYS OR INTERNAL USER, CATPARR.SQL ALREADY RUN, PARALLEL QUERY OPTION ON -- ------------------------------------------------------------------------ -- AUTHOR: -- Michae...

Oracle9i provides extended date and time support across different time zones with the help of new datetime data types and functions. To understand the working of these data types and functions, it is ...

This practice will demonstrate the concept of extent, wrap and shrink in rollback segment utilization. You will: Use the create rollback segment and alter rollback segment syntax. Examine the V$ROLLST...

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

This practice uses common UNIX and NT Oracle utilities to practice enabling AUDIT on a database. You will: See the procedure to enable and disable Oracle AUDIT on a database. Understand the SQL comman...

This practice uses common UNIX and Windows NT Oracle utilities to review database user objects’ key roles and permissions. You will: 1. See default user objects and their default passwords. 2. Underst...

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