Manage Learn to apply best practices and optimize your operations.

30 Oracle tips in 30 minutes

An IOUG guide to 30 practical tips and tricks to make an Oracle database administrator's and developer's job easier.

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

I have been working with Oracle products for a decade now -- primarily as a development DBA. In that time, I've come across some valuable goodies I'd like to pass around. Also, I've run across misunderstandings of Oracle terms and functionality. Many of these misconceptions, I've had myself. Below, you'll get a boatload of tips and tricks you'll find helpful at your office. We'll also talk about several important Oracle concepts that need clarification. I hope to:

  • Provide a database administrator and database developer with practical tips to make your job easier.
  • Expose common myths and misunderstandings with useful SQL and explanations.
  • Load you up with so many tips, your head will bust.

  • Table of contents


       Application development
       Database administration
       Performance tuning
       Backup and recovery
       Recovery Manager
       Database extras


    Application development tips
    [ Return to Table of Contents ]


    Database administration tips
    [ Return to Table of Contents ]


    Performance tuning tips
    [ Return to Table of Contents ]


    Backup and recovery tips
    [ Return to Table of Contents ]


    Recovery Manager tips
    [ Return to Table of Contents ]


    Database extras
    [ Return to Table of Contents ]


    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.

    This was last published in December 2003

    Dig Deeper on Oracle DBA jobs, training and certification

    Start the conversation

    Send me notifications when other members comment.

    Please create a username to comment.

    -ADS BY GOOGLE

    SearchDataManagement

    SearchBusinessAnalytics

    SearchSAP

    SearchSQLServer

    TheServerSide.com

    SearchDataCenter

    SearchContentManagement

    SearchHRSoftware

    Close