Oracle和MySQL - 博客园

DBMS_REPAIR example

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

posted @ 2013-03-19 00:32 Oracle和MySQL 阅读(334) 评论(0) 推荐(0)

Materialized Views and Dimensions

摘要： Materialized Views and Refresh TypesThis practice will familiarize you with the various features and privileges to ensure successful creation of a materialized view from a base table.1) Grant the nece... 阅读全文

posted @ 2013-03-19 00:32 Oracle和MySQL 阅读(193) 评论(0) 推荐(0)

Function Based Indexes and Global Temporary Tables

摘要： A nonunique index can be used to enforce a primary key or unique constraint.In Oracle8i indexes can be rebuilt without locking the table.The DROP COLUMN option of the ALTER TABLE command is restartabl... 阅读全文

posted @ 2013-03-19 00:32 Oracle和MySQL 阅读(142) 评论(0) 推荐(0)

Known Oracle Internal Stack Call Meaning

摘要： ksedmp # KSE: dump the process state ksfdmp # Call relevant dump routine kgeasi # Raise an error on an ASSERTION failure (IGNORE) ktcrab KTC: Kernel Tr... 阅读全文

posted @ 2013-03-19 00:32 Oracle和MySQL 阅读(181) 评论(0) 推荐(0)

Practice:Demonstrating the Key TCP/IP Protocols

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

posted @ 2013-03-19 00:32 Oracle和MySQL 阅读(119) 评论(0) 推荐(0)

Practice:Demonstrating Database User Objects, Roles and Permissions

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

posted @ 2013-03-19 00:32 Oracle和MySQL 阅读(159) 评论(0) 推荐(0)

Practice:Demonstrating Oracle AUDIT Concepts and Procedures

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

posted @ 2013-03-19 00:32 Oracle和MySQL 阅读(148) 评论(0) 推荐(0)

Know about Oracle Network Security

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

posted @ 2013-03-19 00:32 Oracle和MySQL 阅读(394) 评论(0) 推荐(0)

Rollback Segment Utilization:Extent, Wrap and Shrink

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

posted @ 2013-03-19 00:32 Oracle和MySQL 阅读(160) 评论(0) 推荐(0)

EVENT:10210 check data block integrity

摘要： Event:10210 See for similar events / parameters~~~~~~~~~~~Version/Use: 7.0 - 8.1.7 Check data block integrity after each modification 9.0+ This event is no longer valid. U... 阅读全文

posted @ 2013-03-19 00:32 Oracle和MySQL 阅读(145) 评论(0) 推荐(0)

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