Oracle Scripts

Are you an Oracle Contractor?
Register FREE in our DATABASE

You think our free scripts are good? It stands to reason our products are even better! - It costs nothing to find out what you're missing.
Download a fully functional trial version TODAY!

PDQOUT
Used together with Oracle's SQL*Loader, will achieve in minutes, what would take hours with Oracle's exp/imp. For example, on a DEC4100, a 70Mb 250,000 row table can be downloaded and reloaded through a pipe in under 8 mins. A 600Mb, 6,000,000 row table takes only 40 mins on a DEC8400. PDQOUT price compares favorably with the leading third-party product. Additionally, as PDQOUT makes use of the Oracle Call Interface, it can work across SQL*Net or download a view, saving a lot of processing when preparing data for a datamart.

SIMULOAD
Is a load simulator designed to simulate realistic production activity on a test database. It allows you to simulate both OLTP and batch programs - and the interactions between the two, with any number of concurrent users and enables you to predict with confidence, whether your current hardware configuration and programs can serve a larger number of Oracle users and/or processes.

ORISNOOP
Monitors all SQL jobs, pinpointing the statements which consume the largest proportion of resources. It provides detailed information (execution plan, indexes, statistics, etc.), about those statements and the tables involved, allowing any competent SQL programmer to achieve dramatic performance improvements very quickly.

ALERTHAWK
Will e-mail the DBA whenever an error situation is detected. This means that the DBA is alerted and provided with accurate information about any malfunction before the user calls, even when there are dozens of databases to monitor.

WEBSQL (FREE) and WEBSQLPLUS ($30)
Allow you instantly to generate HTML formatted output from SQL scripts. They are NOT BROWSER-BASED INTERACTIVE INTERFACES to an Oracle database; they are essentially 'batch' programs, usable inside a CGI script, making it possible for you to rejuvenate all 'legacy' SQL scripts written in your installation over the years.

ORIOLE CORPORATION ORACLE SCRIPTS
	File name	Comments
	`admmenu`	Shell menu to run easily sql scripts (now orimenu)
	`after_run.sql`	Collect vital tuning statistics (use with before_run.sql)
	`ALERTHAWK.*`	ALERTHAWK data sheet
	`analyze_parallel.kh`	Analyze your tables in parallel (NT users see at_parallel_NT_110.zip below)
	`at_parallel_NT_110.zip`	Analyze your tables in parallel (UNIX users see analyze_parallel.kh above)
	`autoextend_off.sql`	Turn auto-extend off for all tablespaces
	`become.sql`	Become another user when you're a DBA
	`before_run.sql`	Collect vital tuning statistics (use with after_run.sql)
	`bufgets.sql`	Measure of buffers accessed when running queries
	`cancel_hotbackup.sql`	Return to normal in case of hotbackup failure
	`circ_fk.sql`	List foreign keys which loop
	`clean_2pc_tx.sql`	BEWARE XXX (HARD!)
	`concols.sql`	Function required by tabcons.sql
	`create_user_as.sql`	Patterns a new Oracle account on an existing one
	`current_tx.sql`	What are those long-running transactions doing?
	`dataxfer.zip`	Migrate your data to a new DB © Paul Baumgartel, Adept Computers Associates Inc. (see dataxfer.doc in the library section).
	`daxplan.sql`	'Day After' explain plan - explain the last query run
	`dbup.ksh`	See at one glance whether your databases are up or down © 2000 Dejan Ilic - Oracle Consultant
	`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
	`deactivate_db_links.sql`	Beware of database links when cloning a production database for test purposes!
	`desc.sql`	Advanced description of tables
	`desc8.sql`	Advanced description of tables (Oracle 8 update)
	`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
	`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.
	`expand_ts.sql`	Automate data file addition.
	`fix_storage.sql`	Resets to reasonable values the storage of segments created with the default values.
	`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. (see also gendata.sql)
	`gendata.sql`	Generate random test data. (see also gen.sql)
	`genrs.sql`	Information on rollback segments
	`genshpkeep.sql`	Keep in memory often reloaded packages
	`genshpool.sql`	List most reloaded packages
	`genshpool8.sql`	List most reloaded packages for Oracle8i
	`growth_history.zip`	Growth monitoring package
	`hotbackup.sql`	Always up-to-date hot backup script
	`hxtoch.sql`	Utility function : conversion to characters of an hexadecimal string. Unprintable characters are replaced by dots. (reqd. by repdump.sql)
	`idxaudit.sql`	Check if your database is properly indexed
	`insfrag.70.sql`	View installation) (pre 7.2)
	`insio.70.sql`	View installation (pre7.2) for IO monitoring
	`instbsto.70.sql`	View installation (pre 7.2) for table storage monitoring
	`inswait.sql`	Installation for waits monitoring
	`inswait8.sql`	Installation for waits monitoring (Oracle8)
	`invalid_objects.sql`	Lists which are the invalid objects ... AND WHY!
	`ixcols.sql`	Function required by tabix.sql
	`monlocks.sql`	Locks monitoring
	`monsess.sql`	Session monitoring
	`monwaits.sql`	Waits 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
	`objacc7.sql`	List who can access given objects and how (v7)
	`objacc8.sql`	List who can access given objects and how (v8)
	`oraproc.ksh`	Find out what the Oracle processes which are hogging the CPU are doing
	`oriclean.sql`	BEWARE XXX (VERY HARD!)
	`oriole_ind_columns.sql`	You are using function-based indexes? Then you should use ORIOLE_IND_COLUMNS instead of USER_IND_COLUMNS.
	`ORISNOOP_*.tar.Z`	ORISNOOP data sheet
	`oritrace.ksh`	BEWARE XXX (HARD!)
	`orview.tar.Z`	A complete full screen Oracle dictionary viewer and monitoring tool. Contributed by Ron A. Schmidt © 2000 Georgia Pacific Corporation.
	`patchdmp.c`	Patch Oracle export files to retain accentuated letters from pre 7.2 US7ASCII databases
	`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
	`PDQOUT_*.tar.Z`	PDQOUT data sheet
	`ps.sql`	See your Oracle sessions the Unix-way. © Vladimir Begun 1999.
	`raj_tab_analyze.sh`	Analyze tables in parallel using the new DBMS_STATS package. © Raj Sakthi 2001.
	`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)
	`relocate_indexes.sql`	Move misplaced indexes
	`rename_user.ksh`	BEWARE XXX (VERY HARD!)
	`repdest.sql`	Replication destinations
	`repdump.sql`	Dump user data in replication queue (Requires hxtoch.sql)
	`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
	`resize_log.sql`	BEWARE XXX (VERY HARD!)
	`resize_rs.sql`	BEWARE XXX (HARD!)
	`schema7.sql`	'desc.sql' extended to all the tables in a schema
	`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 for Oracle8i
	`showcode.sql`	See where in the package the compilation error occurs © Vladimir Begun 1999.
	`show_line.sql`	Visualise lines from stored objects - even triggers or views
	`SIMULOAD_*.tar.Z`	SIMULOAD data sheet
	`suspend_all_jobs.sql`	Stop jobs when preparing a test database from prod.
	`tabcons.sql`	Let a user list constraints on his/her tables (uses concols.sql)
	`tabix.sql`	Let a user list indexes on his/her tables (uses ixcols.sql)
	`tnsparse.c`	A utility to parse your tnsnames.ora file - and play with the result (see comments in the file)
	`tsusage.70.sql`	Tablespace filling level (pre 7.2)
	`tsusage.72.sql`	Tablespace filling level (post 7.2)
	`unchain.sql`	BEWARE XXX (HARD!)
	`update_pk.sql`	Update primary keys - even when they are referenced
	`upload.ksh`	Upload tables in parallel (see download.ksh)
	`uptime.sql`	How long has the instance being running?
	`very_dirty.sql`	BEWARE XXX (VERY HARD!)
	`WebSql`	Instantly convert output from SELECTs to HTML WEBSQL data sheet
	`websql_pkg.sql`	Customise WebSql output. Conditionally highlight values and draw histograms.
	`WebSqlPlus`	Instantly convert output from SQL*Plus statements to HTML - (cost $30) WEBSQL data sheet
	`whocan.sql`	Check who can either SEE (i.e. SELECT from) or MODIFY (INSERT, UPDATE or DELETE) a given table or view.
	`Y2K.sql`	Y2K script (Update Version 1.1 March 1999)

Last modified: Friday, October 10, 2003

ORIOLE CORPORATION ORACLE SCRIPTS