300 free Oracle scripts

Home > Oracle Featured Topic


Featured Topic:	300 free Oracle scripts


	Search our content and thousands of pre-screened sites.

		Advanced Search

Last Updated: Jul 11, 2003

No matter what your Oracle admin dilemma, here you're sure to find a script to help solve it. Dig through our collection of nearly 300 Oracle scripts and tips, starting with the featured tips below. It's all free!
>>	Have your own tip to share? Send it in and you'll be entered into our monthly tips contest!

Oracle Database Administration Tips

(11 Jul 2003)

Looking for just the right tools and techniques to simplify your life as an Oracle DBA? Click here to access our complete collection of nearly 300 time-saving tips and scripts for Oracle.

Read Full Story


ADVICE:
>>	PL/SQL control structures: Best practices TIP :Here are several best practices you should take into account when you work with IF, FOR, WHILE, and GOTO statements in ...
>>	Speed up Oracle index creation TIP :Use this technique for speeding up index creation on large Oracle tables.
>>	Oracle backup and recovery scripts, part I: Cold backup under Unix TIP :Definitive cold backup and recovery scripts for Oracle running under Sun Solaris, HP-UX and AIX.
>>	Oracle segment statistics TIP :The V$SEGMENT_STATISTICS dynamic performance view gives many statistics about each and every segment that is used by the ...
>>	Find out about TEMP/SORT area usage TIP :This script will give you an idea about the existing usage of the TEMP/SORT area.
>>	Application schema checklist TIP :Follow this checklist to make sure your Oracle application schemas are ready to be put into production.
>>	Build a servlet-based application that executes SQL statements against a database TIP :How to use a Java servlet, JSP, and a static Java class to interactively execute any standard SQL statement against a ...
>>	Introduction to Oracle design TIP :An introduction to designing databases on Oracle.
>>	Oracle vs. SQL Server: Why Oracle wins TIP :A brief technical comparison between Oracle 9i and SQL Server 2000. Now with reader feedback.
>>	Cleaning up after Oracle TIP :Oracle uses up lots of disk space and sometimes this space needs to be cleaned out manually. Here's what to look for.
>>	Basic Oracle space monitoring scripts TIP :To keep your Oracle databases running 24x7, you need some basic space monitoring scripts. Here are three useful ones.
>>	Change table ownership and properties in less than a minute TIP :This Oracle procedure cuts the time to move a large table and its properties to less than a minute.
>>	Securing Oracle databases TIP :Here is a checklist of things to do to secure an Oracle database.
>>	Script to run large daily schema exports TIP :This is a script to use on AIX servers to run very large daily schema exports.
>>	Determining the hit ratio of Oracle databases TIP :This script is useful for determining the hit ratio of your Oracle database.

Digg This!

StumbleUpon Toolbar

StumbleUpon

Del.icio.us

RELATED RESOURCES

	2020software.com, trial software downloads for accounting software, ERP software, CRM software and business software systems
	Search Bitpipe.com for the latest white papers and business webcasts
	Whatis.com, the online computer dictionary

>	RDBMS fundamentals
>	Running RAC
>	Database design
>	XML and Oracle
>	Oracle versus SAP
View full list of Featured Topics

Products

About Us | Contact Us | For Advertisers | For Business Partners | Site Index | RSS

SEARCH

TechTarget provides enterprise IT professionals with the information they need to perform their jobs - from developing strategy, to making cost-effective IT purchase decisions and managing their organizations' IT projects - with its network of technology-specific Web sites, events and magazines.


TechTarget Corporate Web Site \| Media Kits \| Reprints \| Site Map All Rights Reserved, Copyright 2003 - 2008, TechTarget \| Read our Privacy Policy