30 Oracle tips in 30 minutes

This tips collection is brought to you by the International Oracle Users Group (IOUG). It is excerpted from "60 Oracle tips in 60 minutes," originally presented at the IOUG Live! 2002 by Kenny Smith. Become a member of the IOUG to access the paper referenced here and a repository of technical content created for Oracle users by Oracle users.

Overview by the author

Table of contents

Application development tips
[ Return to Table of Contents ]

• Interpolate when an export/import/refresh will finish
• Confirm the model equals the schema
• Deploy schema changes from your modeling tool
• Compile all invalid code with one command
• Trigger on a materialized view (snapshot) table
• Show the time at the SQL prompt

Database ...

Digg This!     StumbleUpon     Del.icio.us

RELATED CONTENT Oracle database administrator Understanding SQL string functions What is the difference between a database engineer, architect and administrator? Import on one table from dump file Error during RMAN backup Can I drop a column in SYS schema? STATSPACK tool: transaction vs. execution measurement Should I port from Microsoft Access? How can I find statistics on total memory usage and database connections? Installing multiple Oracle homes Modifying SYS password in a RAC environment

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

administration tips
[ Return to Table of Contents ]

• Connecting as internal in SQL*Plus, export and import
• Find and remove duplicate rows using constraint exceptions
• Import from a Unix pipe
• Manage the Windows tnsnames.ora file location
• Set the default temporary tablespace in Oracle9i

Performance tuning tips
[ Return to Table of Contents ]

• Load up on latches
• Tune the application SQL in the database
• Tune SQL with SQL*Plus autotrace
• Use IPC for local connections

Backup and recovery tips
[ Return to Table of Contents ]

• Try this simple cold backup script
• Try this simple hot backup script
• Create a database clone using an open backup
• Perform capacity planning using LogMiner
• Backup a primary database via the standby

Recovery Manager tips
[ Return to Table of Contents ]

• Deploy redundant recovery catalogs
• Explore your date options with RMAN
• Make redundant RMAN archive log backups
• Create a standby database with RMAN
• Perform tablespace recovery with RMAN
• Configure a retention policy in RMAN 9i

Database extras
[ Return to Table of Contents ]

• Use Remote Diagnostic Agent (RDA) when calling support
• Roll forward versus roll back
• Monitor RMAN operations
• Configure the Recovery Manager MML

About the author: Kenny Smith has been working with Oracle technology on HP servers for over a decade. He specializes in Oracle database architecture, database administration and development. He has presented at numerous Oracle conferences on two continents. He has published many articles describing Oracle solutions and has co-authored "Oracle Backup and Recovery 101" from Oracle Press.

IOUG: Become a member of the IOUG to access the paper referenced here and a repository of technical content created for Oracle users by Oracle users.

Rate this Tip To rate tips, you must be a member of SearchOracle.com. Register now to start rating these tips. Log in if you are already a member. Submit a Tip DISCLAIMER: Our Tips Exchange is a forum for you to share technical advice and expertise with your peers and to learn from other enterprise IT professionals. TechTarget provides the infrastructure to facilitate this sharing of information. However, we cannot guarantee the accuracy or validity of the material submitted. You agree that your use of the Ask The Expert services and your reliance on any questions, answers, information or other materials received through this Web site is at your own risk.