Oriole Corporation

Products

Free Oracle Scripts for Database Administrators

The software has been grouped into themes to help you to go straight to the free scripts and free demo versions of Oriole products which are most relevant to you.

Download them now and see for yourself the benefits you can get.

The free scripts (available under the terms of the GNU license) are yours to keep with no obligation.

When you have evaluated the demo versions (working products with reduced functionality) and want to unlock the product's full potential, all you'll need is a software key in the form of a string of digits and letters. This will be forwarded to you on receipt of your payment.

Choose the theme which most interests you or browse the full listing of scripts.

Oriole Themes:-

Monitoring

Optimization

Space Management

Security

Migration

Odds & Ends

Monitoring

File name	Comments
`current_tx.sql`	What are those long-running transactions doing?
`insfrag.70.sql`	View installation) (pre 7.2)
`insio.70.sql`	View installation (pre 7.2) for IO monitoring
`perfhit.sql`	Hit-ratios
`perfio.70.sql`	IO monitoring (pre 7.2)
`perfio.72.sql`	IO monitoring (post 7.2)
`perfnet.sql`	MTS monitoring
`segtrbl.sql`	List segments which can no longer grow
`tsusage.70.sql`	Tablespace filling level (pre 7.2)

Optimization

File name	Comments
`insio.70.sql`	View installation (pre7.2) for IO monitoring
`inswait.sql`	Installation for waits monitoring
`monlocks.sql`	Locks monitoring
`monsess.sql`	Session monitoring
`monwaits.sql`	Waits monitoring
`perfhit.sql`	Hit-ratios
`perfio.70.sql`	IO monitoring (pre 7.2)
`perfio.72.sql`	IO monitoring (post 7.2)
`bufgets.sql`	Measure of buffers accessed when running queries
`ALERTHAWK.*`	ALERTHAWK data sheet

Space Management

File name	Comments
`drop_user_objects.sql`	Drop all of a user's objects before reimporting
`genrs.sql`	Information on rollback segments
`instbsto.70.sql`	View installation (pre 7.2) for table storage monitoring
`segbig.70.sql`	Biggest segments (pre 7.2)
`segbig.72.sql`	Biggest segments (post 7.2)
`PDQOUT_*.tar.Z`	PDQOUT data sheet

Security

File name	Comments
`become.sql`	Become another user when you're a DBA

Case Study:- Oracle passwords : a few not too well known facts

Migration

Putting aside all the hype around object orientation, the most interesting features in Oracle8 revolve around its ability, at last, to handle very large databases - such as incremental physical backup and, on the faster-queries side, the use of partitioned tables.

Unfortunately, if you want your datawarehouse to take advantage of partitioned tables, running the migrate.bsq script will not be enough - you'll have to recreate the tables, the really big ones at least, which implies moving the data in these huge tables of yours out and in again - better to forget about imp, unless all your users are ready to take their holidays together for a few weeks. It's time to consider the PDQOUT and sqlldr combination!

Odds & Ends

File name	Comments
`orimenu`	Shell menu to run easily sql scripts
`desc.sql`	Advanced description of tables (Oracle 7 only)
`desc8.sql`	Advanced description of tables (Oracle 8 update)
`foerr.c`	A much faster oerr !