Oracle Script Archive

Oriole Corporation Script Archive

These free scripts are made available under the terms of the GNU license

Last modified: Friday, April 05, 2002

Oriole Corporation Script Archive

Backup & Recovery	Comments
`cancel_hotbackup.sql`	Return to normal in case of hotbackup failure
`hotbackup.sql`	Always up-to-date hot backup script

Oriole Corporation Script Archive

Scripts for developers	Comments
`concols.sql`	Function required by tabcons.sql
`daxplan.sql`	'Day After' explain plan - explain the last query run
`ixcols.sql`	Function required by tabix.sql
`tabcons.sql`	Let a user list constraints on his/her tables
`tabix.sql`	Let a user list indexes on his/her tables

free Oriole toolkit

Oriole Corporation Script Archive

Management of objects	Comments
`circ_fk.sql`	List foreign keys which loop
`dbupgrade.tar.Z` `dbupgrade.zip`	Check and correct schema discrepancies between databases - a utility designed and developed by Simon Maxen, © 1999 Martin Wilkinson. (16K .tar.Z for unix) - (13K .zip for NT) DB Upgrade data sheet
`desc.sql`	Advanced description of tables (Oracle 7 only)
`desc8.sql`	Advanced description of tables (Oracle 8 update)
`disaball.sql`	Disable/re-enable all foreign keys and triggers
`drop_user_objects.sql`	Drop all of a user's objects before reimporting
`idxaudit.sql`	Check if your database is properly indexed
`invalid_objects.sql`	Lists which are the invalid objects ... AND WHY!
`recompile_all_V7.sql`	Recompile invalidated stored objects (v7).
`recompile_all_V8.sql`	Recompile invalidated stored objects (v8).
`recreate_sequences.sql`	Recreate sequences (useful for data transfers)
`RECREATOR`	(approx 160K download)
`schema7.sql`	'desc.sql' extended to all the tables in a schema

Oriole Corporation Script Archive

Management of transactions	Comments
`bufgets.sql`	Measure of buffers accessed when running queries
`current_tx.sql`	What are those long-running transactions doing?
`genrs.sql`	Information on rollback segments
`inswait.sql`	Installation for waits monitoring
`inswait8.sql`	Installation for waits monitoring (Oracle8)
`monsess.sql`	Session monitoring
`monwaits.sql`	Waits monitoring
`ps.sql`	See your Oracle sessions the Unix-way, © Vladimir Begun 1999.

Oriole Corporation Script Archive

Network Management	Comments
`perfnet.sql`	MTS monitoring

Oriole Corporation Script Archive

Security Management	Comments
`become.sql`	Become another user when you're a DBA
`create_user_as.sql`	Patterns a new Oracle account on an existing one
`objacc7.sql`	List who can access given objects and how (v7)
`objacc8.sql`	List who can access given objects and how (v8)

Oriole Corporation Script Archive

Space Management	Comments
`analyze_parallel.kh`	Analyze your tables in parallel © Peter Lomax
`at_parallel_NT_110.zip`	Analyze your tables in parallel (for NT) © Adrian Popescu
`dataxfer.zip`	Migrate your data to a new DB © Paul Baumgartel, Adept Computers Associates Inc. (see dataxfer.doc in the library section).
`disaball.sql`	Disable/re-enable all foreign keys and triggers
`download.ksh`	Download tables in parallel
`drop_user_objects.sql`	Drop all of a user's objects before reimporting
`expand_ts.sql`	Automate data file addition
`fix_storage.sql`	Resets to reasonable values the storage of segments created with the default values.
`genrs.sql`	Information on rollback segments
`growth_history.zip`	Growth monitoring package
`insfrag.70.sql`	View installation) (pre 7.2)
`instbsto.70.sql`	View installation (pre 7.2) for table storage monitoring
`need_reorg.sql`	List tables which need to be reorganized
`non_standard_objects.sql`	Generate DDL for non-standard SYS objects which are not exported
`non_standard_privs.sql`	Generate special GRANTS on SYS objects such as V$ views
`PDQOUT`	(approx 70K download)
`raj_tab_analyze.sh`	Analyze tables in parallel using the new DBMS_STATS package. © Raj Sakthi
`RECREATOR`	(approx 160K download)
`relocate_indexes.sql`	Move misplaced indexes
`segbig.70.sql`	Biggest segments (pre 7.2)
`segbig.72.sql`	Biggest segments (post 7.2)
`segtrbl.sql`	List segments which can no longer grow
`segtrbl8.sql`	List segments which can no longer grow (8i)
`tsusage.70.sql`	Tablespace filling level (pre 7.2)
`tsusage.72.sql`	Tablespace filling level (post 7.2)
`upload.ksh`	Upload tables in parallel (see download.ksh)

Oriole Corporation Script Archive

Tuning	Comments
`bufgets.sql`	Measure of buffers accessed when running queries
`genshpkeep.sql`	Keep in memory often reloaded packages
`genshpool.sql`	List most reloaded packages
`genshpool8.sql`	List most reloaded packages for Oracle8i
`idxaudit.sql`	Check if your database is properly indexed
`insio.70.sql`	View installation (pre7.2) for IO monitoring
`inswait.sql`	Installation for waits monitoring
`inswait8.sql`	Installation for waits monitoring (Oracle8)
`monlocks.sql`	Locks monitoring
`monwaits.sql`	Waits monitoring
`oraproc.ksh`	Find out what the Oracle processes which are hogging the CPU are doing
`ORISNOOP`	(approx 190K download)
`peep.sql`	Find the ugliest statements in the SGA
`perfhit.sql`	Hit-ratios
`perfio.70.sql`	IO monitoring (pre 7.2)
`perfio.72.sql`	IO monitoring (post 7.2)
`perfnet.sql`	MTS monitoring
`ps.sql`	See your Oracle sessions the Unix-way, © Vladimir Begun 1999.

Oriole Corporation Script Archive

Replication Monitoring	Comments
`repdest.sql`	Replication destinations
`repdump.sql`	Dump user data in replication queue (Requires hxtoch.sql - in 'Odds & Ends')
`repempq.sql`	Empty replication queue (must be REPADMIN)
`reperr.sql`	Latest replication errors
`repqstat.sql`	Replication queue state
`repschdp.sql`	Schedule a push every half hour (must be REPADMIN)
`repsched.sql`	Scheduled replication pushes

Oriole Corporation Script Archive

Odds & Ends	Comments
`addmenu`	Shell menu to run easily sql scripts (now orimenu)
`ALERTHAWK`	(approx 100K download)
`become.sql`	Become another user when you're a DBA
`deactivate_db_links.sql`	Beware of database links when cloning a production database for test purposes!
`DUMBAGNT.zip`	"Dumb Agent" file set 12.2KB (includes "readme")
`err.sql`	What is the text for this PL/SQL error code? © Vladimir Begun 1999.
`fk2pk.sql`	Compute relative numbers of foreign keys to primary keys to help in estimating future growth
`foerr.c`	A much faster oerr !
`gen.sql`	Generate random test data.
`gendata.sql`	Generate random test data.
`genshpkeep.sql`	Keep in memory often reloaded packages
`genshpool.sql`	List most reloaded packages
`hxtoch.sql`	Utility function : conversion to characters of an hexadecimal string. Unprintable characters are replaced by dots. (reqd. by repdump.sql)
`insio.70.sql`	View installation (pre7.2) for IO monitoring
`orimenu`	Shell menu to run easily sql scripts (was admmenu)
`patchdmp.c`	Patch Oracle export files to retain accentuated letters from pre 7.2 US7ASCII databases
`schema7.sql`	'desc.sql' extended to all the tables in a schema
`showcode.sql`	See where in the package the compilation error occurs © Vladimir Begun 1999.
`suspend_all_jobs.sql`	Visualise lines from stored objects - even triggers or views
`show_line.sql`	Stop jobs when preparing a test database from prod.
`uptime.sql`	How long has the instance being running?
`Y2K.sql`	Y2K script (Update Version 1.1 March 1999)

Oriole Corporation Script Archive

XXX Scripts BEWARE	Comments
oriclean.sql (28.3K) (V. HARD)	Clean-up your test data without worrying about constraints.
oritrace.ksh (11.7K) (HARD)	Sneak a peek behind the screen! - Works with Oracle7.x & Oracle8.0 (not 8i)
rename_user.ksh (34.3K) (V. HARD)	Rename an Oracle user - Works with Oracle7 & Oracle8.
resize_log.sql (10.1K) (V. HARD)	You quite often encounter 'Checkpoint not completed' in the alert log file? You should increase the size of your redo log files. Input the size you want, it will automatically resize all of them.
resize_rs.sql (4.1K) (HARD)	Automatically resizes all the online rollback segments and sets the optimum size
unchain.sql (12.8K) (HARD)	Improves performance by unchaining chained rows in the current schema.
very_dirty.sql (4.1K) (V. HARD)	Stuck with owner-less segments ? This can help ...
clean_2pc_tx.sql (2.3K) (V. HARD)	Get rid of pending transactions the hard way.