|
|||||
|
Applies to: Oracle Server – Enterprise Edition – Version: 10.1.0.2 to 11.2.0.2 Information in this document applies to any platform. Checked for any broken links, none has been found .. 18-Jan-2010 Goal This article provide a very fast method to setup streams environment, we will use set of scripts provided already under DBMS_STREAMS_ADM package, those . . . → Read More: How to setup Streams replication using DBMS_STREAMS_ADM.MAINTAIN_* set of procedures PURPOSE ——- This bulletin explains how to interpret the DBA_TABLES.EMPTY_BLOCKS value and DBMS_SPACE.UNUSED_SPACE information regarding FREELIST and BMB (Bit Mapped Block) segments in 9i. SCOPE & APPLICATION ——————- The following examples should help the DBAs not to misunderstand the values returned by different sources of information regarding the space used within blocks. *** ***************** *** . . . → Read More: BMB versus Freelist Segment: DBMS_SPACE.UNUSED_SPACE and DBA_TABLES.EMPTY_BLOCKS Applies to: Oracle Server – Enterprise Edition – Version: 10.1.0.0 to 11.1 Information in this document applies to any platform. Purpose Starting with Oracle10g, the DBMS_STATS package offers the AUTO_INVALIDATE option for the NO_INVALIDATE parameter of its GATHER_xxx_STATS and DELETE_xxx_STATS procedures. This parameter allows the user to specify when to invalidate dependent cursors i.e. cursors . . . → Read More: Rolling Cursor Invalidations with DBMS_STATS in Oracle10g |
|
||||
|
Copyright © 2012 Oracle Clinic – Maclean Liu的个人技术博客 - All Rights Reserved |
|||||
最新评论