Article-ID:         <Note:67104.1>
Circulation:        PUBLISHED (EXTERNAL)
Folder:             Support.Systems.ML2.Templates
Platform:           GENERIC  Generic issue
Topic:              Servers
Subject:            Bulletins Template for Oracle Server Enterprise Edition - 
                    Generic
Modified-Date:      03-FEB-1999 13:18:11
Document-Type:      BULLETIN
Content-Type:       TEXT/X-HTML
Impact:             MEDIUM

ORACLE8 CONCEPTS

• Application Failover CR 181872
• Application Server Partitioning and Partition CR 181877
• Basics of the Object Option CR 181874
• Checkpoint Algorithm CR 181870
• Cost Based Optimizer ("CBO") Enhancements CR 181871
• NET8 CR 181875
• New Rowid Format CR 181880
• Oracle8 introduces a new multiple buffer pool CR 181869
• Parallel DML (Insert, Update, Delete CR 181878
• Partitioning CR 181876
• Reverse Key Indexes CR 181879
• Useful Alter Commands in Oracle8 CR 181868

ADMINISTRATION

• How To Make A Copy Of A Database On The Same Unix Machine Note 18070.1
• Copying an Oracle7 database on OpenVMS Note 30349.1
• Causes And Solutions To Ora-1555 "Snapshot Too Old" Note 40689.1
• LKdbname - The MOUNT Lock File Note 50594.1
• SQL DIAG- Determining Dependency Information (Oracle7) Note 30485.1
• SQL DBA - Manually Coalescing Free Space Note 31116.1
• Foreign Keys - Table & Index Dependencies Note 39392.1
• Retrieving Data from the Database Note 39383.1
• Delete_commit Procedure Note 37777.1
• Capturing Index_Stat Information Note 35492.1
• Diagnosing Database Hanging Issues Note 61552.1
• Read-Only Tablespaces Note 33402.1
• Recreating Database Objects Note 30910.1
• Rollback Segment Needs Recovery Note 28812.1
• Truncate Command in 7.1 Note 28722.1

  Corruption:

• DBVERIFY - Database file Verification Utility (7.3.2 onwards) Note 35512.1
• ORA-1578 and Data Block Corruption Note 28814.1
• ORA-1578 Checklist Note 61624.1
• Handling Data Block Corruption (ORA-1578) in Oracle 7 Note 34371.1

  Locking:

• TX Transaction locks - Example wait scenarios Note 62354.1
• What to do with "ORA-60 Deadlock Detected" Errors Note 62365.1
• ORA-1575 Timeout waiting for Space Management Enqueue Note 33567.1
• Example Table Locks During Referential Integrity Enforcement Note 38373.1
• (V7) Referential Integrity And Locking Note 33453.1

  Memory:

• Fundamentals of the Large Pool Note 62140.1
• Internal Latch Contention Note 22908.1
• Shared Pool Calculation Note 61340.1

  Security:

• Identifying PC Clients in V$SESSION Note 39333.1
• DBA (Connect Internal) Privilege on Oracle7 Note 18089.1
• SYSDBA and SYSOPER Privileges in Oracle8 and Oracle7 Note 50507.1
• Role Restrictions Note 11740.1

BACKUP/RECOVERY

Archiving:

• Archiver Best Practices Note 45042.1

  Recovery:

• QREF Hot backups from OS MIRRORS Note 47422.1
• Recovering a Dropped Table from a Full Database Backup Note 15475.1
• Incomplete Media Recovery On Parallel Server Note 16575.1
• How To Recover A Database Having Added A Datafile Since The Last Backup Note 29430.1
• Recovering A Dropped Table From A Full Database Backup Note 61330.1

  Standby:

• Switchover Between Primary and Standby Databases Note 39673.1
• Hot Standby DB info in 7.3 Note 33236.1
• Standby Database Prior to 7.3 Note 31406.1

  Recovery Manager (RMAN):

• Parallelizing Backups using Legato Storage Manager & Recovery Manager Note Note 60952.1
• Testing Legato Storage Manager and Recovery Manager without a tape device Note 60967.1
• Getting started with Server-Managed Recovery (SMR) and RMAN Note 50875.1
• Parallel Features with Server-Managed Recovery (SMR) and Recovery Manager(RMAN) Note 52576.1
• RMAN: Restore and Recovery of a NOARCHIVELOG database Note 61801.1

  Enterprise Backup Utility (EBU):

• Migrating to Recovery Manager from EBU Note 47423.1

DISTRIBUTED/REPLICATION

Replication:

• Creating a Replication Environment in Oracle 8.0.X Note 62398.1
• 7.3 Synchronous Data Propagation Example Note 43029.1
• SQL Sample script to setup repadmin user DBA synonyms Note 43001.1
• Sample setup scripts - Setting up Replication Note 34548.1
• Print Out Arguments of Errored Transactions 8.0.x Note 62491.1
• Interoperability between the Replication Releases V7 and V8 Note 60927.1
• Print Out Arguments of Errored Transactions in 7.3.x Note 62088.1
• Upgrading Replication Databases from v7.3. x to v7.3.x Note 50573.1
• Diagnosis of Replication Setup Problems Note 33515.1
• Using Replication Manager with v8.0.4. Note 62396.1
• Top Issues For Symmetric Replication Note 47813.1
• 7.3 DBMS_RECTIFIER_DIFF Package Example Note 43033.1
• SQL Script to extract Defcall transaction/arguments RDBMS 8.0.3 Note 47693.1
• SQL Script to extract Defcall transaction/arguments RDBMS 7.3 Note 42961.1
• Conflict Resolution Example - Minimum Value Note 43024.1
• Conflict Resolution Example - Latest Timestamp Note 43010.1
• Procedural Replication Setup Example Note 43009.1

  Snapshots:

• Top Issues For Read-Only Snapshots Note 47811.1
• Frequently Asked Questions For Read-Only Snapshots Note 47810.1

NLS

• Code Pages For We8iso8859p9 Character Set Note 16559.1
• Nlsrtl 2.3 Supported Character Sets Note 16128.1
• How Computers Process Different Languages Note 15383.1
• Export/Import And NLS Considerations Note 15095.1
• Code Pages For We8iso8859p1 Character Set Note 14786.1
• NLS_Lang/Cde Production 3 For Ms- Windows Note 14325.1
• Oracle And Unicode Q&A Note 14079.1
• NLS Sort Characteristics CR 88679
• NLS Language Dependent Features CR 88678
• NLS Port Specific Supported Character Sets Note 13971.1
• NLS Supported Languages And Territories Note 13881.1
• Linguistic Sorting Of Data In Oracle7 Note 13882.1
• NLS Supported Message Files Oracle7 Note 13883.1
• Dump Sql Command For NLS Debugging Note 13854.1
• NLS 7-Bit/8-Bit Conversion Note 13855.1
• NLS On Dos Vs.Windows Note 13853.1
• National Language Support CR 58762

OTHERS

Context:

• Oracle ConText Option Note 43474.1

  Migration:

• Upgrading to Oracle 7.3 - Important things to check Note 61975.1
• Oracle 8.X -> 8.X Upgrade scripts to run Note 62291.1
• Oracle 7.X -> 7.X Upgrade scripts to run Note 33318.1
• Checklist for Migrating from Oracle7 to Oracle8 on UNIX Note 47290.1

  Parameters:

• PARAMETER INIT.ORA DB_DOMAIN () Note 30710.1
• PARAMETER INIT.ORA LOG_ARCHIVE_DEST () Note 30748.1

  Misc:

• Locating Resursive Sessions Note 62003.1
• Caching Oracle Sequences Note 62002.1
• ORA-1647 in Oracle 7.x Note 61995.1
• Oracle Mutating Table Problem CR 104200

  Partitions:

• Introduction to Partition Views in Oracle 7.3 () Note 33593.1
• Partition views in 7.3 Note 43194.1
• Partition Views and the use of indexes (7. 1 & 7.2) Note 28426.1

PERFORMANCE/TUNING

Performance:

• Library Cache And Shared Pool Tuning Note 61623.1
• Systemwide Tuning using UTLESTAT Reports in Oracle7/8 Note 62161.1
• Main issues affecting the Shared Pool on Oracle 7 and 8 Note 62143.1
• Issues affecting the Buffer Cache and DBWR in Oracle7/8 Note 62172.1
• Introduction to Tuning Oracle7 / Oracle8 Note 61998.1

  Sql Tuning:

• Interpreting Explain plan Note 46234.1
• Hints and Subqueries Note 62364.1
• Using Use_Concat Hint To Override A Full Table Scan With In/Or Statements Note 17214.1
• Setting SQL Trace in the Oracle Tools Note 15160.1
• Interpreting Raw SQL_TRACE and DBMS_SUPPORT.START_TRACE output () Note 39817.1
• Determining the execution plan for a distributed query Note 33838.1
• SQL DIAG - Select to show Optimizer Statistics for CBO Note 31412.1
• SQL Tuning FAQ Note 47736. 1
• Cost Based Optimizer - Common Misconceptions and Problems Note 35934.1
• Index Space usage Note 33343.1
• SQL Tuning TOP 20 Issues Note 47742.1
• Automatic Explain Plan Note 39341.1

SERVER TOOLS

Exp/Import:

• ORA-904 when exporting a 7.3.3 database Note 62322.1
• Export/Import And Nls Considerations Note 15656.1
• V7. Exporting Procedures, Packages and Triggers Note 17839.1
• QREF Export/Import/SQL*Load large files in Unix - Quick Reference Note 30528.1
• Exporting/Importing From Multiple Tapes Note 2035.1
• Exporting to tape on unix system Note 30428.1
• Unix Script: IMPSHOW2SQL - Extracting SQL from an EXPORT file Note 29765.1

  SqlLoader:

• NT/95 Loading Binary Files With Sql* Loader Note 61713.1
• NT/95 Loading Text Files With Sql*Loader Note 61714.1
• SQL*Loader FAQ Note 48718. 1

  Server Manager:

• Server Manager --- TOP 20 Issues Note 47842.1

• 2Gb or Not 2Gb - File limits in Oracle Note 62427.1
• SQL DIAG- Who owns TEMP Segments in V7 Note 40758.1
• How Oracle Allocates Extents when altering PCTINCREASE Note 15251.1
• ALERT Using UNLIMITED Extent Format Note 50380.1
• ALERT Failed Operations may leave TEMPORARY Segments Note 38388.1
• Removing `stray` TEMPORARY Segments Note 35513.1

TALES OF THE SCRIPTS

Disclaimer:
===========
These scripts are provided for educational purposes only. They are NOT supported
by Oracle World Wide Technical Support. The scripts have been tested and appear
to work as intended. However, you should always test any script before
relying on it.

PROOFREAD THIS SCRIPT PRIOR TO USING IT!
Due to differences in the way text editors, email packages and operating systems
handle text formatting (spaces, tabs and carriage returns), this script may not be in
an executable state when you first receive it. Check over the script to ensure that
errors of this type are corrected. Thank you.


---

SCRIPT AREAS

Constraints	Object_Creation	DBA_Information	Performance	Export/Import	Privileges/Profiles
Index	Rollback_Segments	Job_Queue	Space_Management	Locking	Utilities

---

Constraints Scripts

• Script For Capturing Table Constraints CR 95170
• Script To Generate A Delete Cascade Report CR 95171
• Check For Foreign Key Locking Issues CR 120470
• Script To Report Constraints For A User CR 100840
• Script To Eliminate Non-Unique Rows CR 103420
• Script to Create SQL to Enable/Disable Table Constraints CR 104476
• Script To Locate Tables W/O Primary Keys CR 106838
• Report Table Constraints CR 125124
• Generate List Of Table Dependencies CR 116486
• Determine An Object's Dependencies CR 120474

DBA Information Scripts

• Script For Creating A Data Base Schema Summary CR 95165
• Script To Drop Some Or All Objects From Schema CR 95169
• Script To Obtain Session Information CR 125122
• Script To Produce A Database Summary Report CR 95175
• Script To Provide Databaseperformance Overview CR 95176
• Script To Show Audit Options/Audit Trail CR 95178
• Report Dispatcher & Process Mapping Using Mts CR 109908
• Script To Report Instance Parameters CR 135839
• Script To List Programs For A User CR 104890
• Verify Stored Procedures CR 135840
• Report Sequence Values CR 125125
• Report Redo Log Information CR 125126
• List Inactive Users CR 121100
• Script To Fully Describe A Table CR 135845
• Script To Provide Listing Of All Database Files CR 10837
• Script to Report Large Segments CR 103425
• Create View To Display All Open Pipes CR 116590
• Script To Monitor Session Idle Times CR 135860
• Delete Commit Procedure CR 125129
• Determining Connect Time Properly CR 111790
• Report All Events Set In Session CR 135863

Export/Import Scripts

• Script To Export Data To Fixed- Width Text CR 101494
• Script To Generate Sql*Loader Control File CR 101495
• Script To Export User Definitions CR 95180
• Script To Report Object Owners In Database CR 103419

Index Scripts

• Script To Show Data Selectivity For A Column CR 97899
• Script To Report Information On Indexes CR 97904
• Script To Describe All Indexes In A Schema CR 95167

Job Queue Scripts

• Script To List Running Jobs CR 108528
• Script To List Submitted Jobs CR 135859

Locking Scripts

• Fully Decoded Locking Script CR 121094
• Display Locks And Give Sid And Serial # To Kill CR 116589
• Script To Return Medium Detail Locking Info CR 100949
• Low Complexity Locking Info CR 121095
• Display Sql Text From Locks CR 120473
• Script To Display User Lock Information CR 135843
• Report Sessions Waiting For Locks CR 116591

Object Creation Scripts

• Script To Generate Db Link Script CR 103426
• Generate Object Priv Grant Script CR 135848
• Generate System Priv Grant Script CR 106840
• Generate Role Creation Script CR 135849
• Generate Synonym Creation Script CR 111786
• Generate Create Tablespace Script CR 135850
• Generate Index Creation Script CR 135851
• Script To Create A Basic Replicated Environment CR 104484
• View To Show Parallel Instance Number CR 108532

Performance Scripts

• Mstat -- System Statistics /Tuning Script CR 106834
• Script To Report The Instance Statistics CR 97900
• Report Table's Rows Per Datafile CR 125123
• Script To Provide Latch Performance Information CR 96728
• Script To Report File I/O Statistics CR 135834
• Script To Simplify The Use Of Explain Plan CR 135835
• Script To Report Dictionary Cache Effectiveness CR 93729
• Script To Report Sga Buffer Summary CR 96730
• Report Session & System WaIts CR 125127
• Report Statistics For A Table CR 125128
• Rstat -- Reactive Performance Utility CR 103423
• Script To Show Sga Parameters & Statistics CR 135844
• Estimate Shared Pool Utilization CR 111787
• Report Various Db Statistics CR 116488
• Script To Check Tables For Statistics CR 135855
• Create Stats For All Tables In Schema CR 135856
• Formatted Select Of Explain Plan Table CR 135858

Privileges/Profiles Scripts

• Script To Report Roles Granted To Users CR 95174
• Script To Show System & Object Privs For User CR 121099
• Report User Role And Profile Info CR 111785
• Report Privs Granted To A User CR 116485
• Create View To Show All User Privs CR 135861

Rollback Segments Scripts

• Script For Displaying Active Transactions In Roll CR 95168
• Script To Obtain Rollback Segment Information CR 95173
• Script To Display Wrap Time For Rollback Segs CR 103421
• Script for Creating Rollback Segments CR 58851

Space Management Scripts

• Script To Move Sys.Aud$ Table Out Of System Table CR 135831
• Script To Force Coalesce Of Contiguous Free Extents CR 95164
• Script To Create Database Extents Summary CR 95166
• Script To Create Tablespace Block Map CR 95172
• Script To Show Table Extents & Storage Parameters CR 101492
• Script To Report On Tablespace Storage Parameters CR 135832
• Script To Calculate Table Row Size CR 101493
• Script To Show Tables Which Cannot Extend CR 95179
• Script To Remove Chained Rows From A Table CR 95181
• Script To Calculate Blocks Needed By A Table CR 97898
• Script To Report Tablespace Free And Fragmentation CR 97902
• Script To Print Block Map Of Entire Database CR 100944
• Script To Report Tablespace Use By Segment Type CR 99197
• Script To Show Tablespace Use By User CR 100945
• Script To Print Map Of All Database Files CR 135837
• Script To Report Table Fragmentation CR 135838
• Script For Data & Index Block Distribution CR 100946
• Script To Report Segments in a Datafile CR 98901
• Script To Report Tables Approaching Maxextents CR 97903
• Script To Report On Segment Extents CR 120472
• Script To Report Segment Storage Parameters CR 100948
• Script To Report Users And # Of Objects In Tables CR 104477
• Script To Show Extents For A Given Segment CR 104478
• Script To Report # Of User Objects Per Tablespace CR 106839
• Script To List Tablespace, Files And Free Space CR 135841
• Check Tables For Backup Status CR 135842
• Get Row Count For All Tables In A Schema CR 121101
• Script To Report Free Space In Database CR 103424
• Script To Report The Largest Segments In The Data CR 103425
• Script To Report Tables Which Should Be Dropped CR 135846
• Report Tables With Many Extents CR 135847
• Report On Space In Tablespaces CR 124824
• Script To Detect Tablespace Fragmentation CR 135852
• User Segment/Extent Report CR 116487
• Count How Many Of Each Object Users Have CR 135853
• Report Db Space Usage By User CR 135854
• Report Size Of Stored Objects CR 109916
• Report Size Of Stored Objects CR 135862

Utility Scripts

• Script For Decimal To Hexadecimal Conversion CR 97897
• Script To Calculate Business Days Between Two Dat CR 100942
• Convert Mm/Dd/Yyyy Hh:Mi:Ss To Redo Dump Time CR 108530
• Convert Redo Dump Time To Mm/Dd/Yyyy Hh:Mi:Ss CR 108531
• Determine Segment Order Of Columns CR 108533
This page was last updated 3-February-1999.