Tips

  • SearchOracle.com Lessons Learned

    SearchOracle.com has identified your FAQs and compiled applicable expert answers in an easy-to-follow format.

  • Ten ways to maximize data storage usage

    Ever wonder how all that storage you purchase is being used? You're not alone. Many organizations find it difficult to understand their soaring storage budgets. This is usually due to the lack of...

  • Top five data management buzzwords

    We know the alphabet soup of IT acronyms can get confusing, so we've gathered a short list of the top data management terms you need to know: customer data integration, corporate performance manage...

  • Oracle instance tuning techniques

    Oracle professionals know that you must optimize your database by tuning global parameters before detailed application tuning can proceed. This excerpt from the best-selling book "Oracle Tuning: Th...

  • SQL analytics: A self-service model

    SQL analytics is one of the best-kept secrets of the Oracle database. It represents the latest advancement in the evolution of delivering powerful analytic capabilities to end users. This article ...

  • Oracle RAC performance tuning

    Oracle's Real Application Clusters (RAC) is the most robust and complex of all Oracle environments, and the inter-instance communications makes RAC tuning especially challenging. This book excerpt ...

  • Mike Ault's Oracle "good practices": System security

    Mike Ault provides "good practices" for Oracle system security, including tips for auditing, passwords and roles.

  • Oracle "good practices": Backup, failover and disaster

    Mike Ault provides "good practices" for your Oracle backup, failover and disaster recovery strategy, including using a hot site, RMAN and mirroring.

  • Mike Ault's Oracle "good practices": Performance tuning

    Mike Ault offers "good practices" for Oracle performance management and tuning, including implementing proactive database monitoring, building in alert mechanisms and more.

  • Mike Ault's Oracle "good practices": Oracle coding

    Mike Ault offers "good practices" for Oracle coding, including using array processing, placing code within stored procedures and using proper variable types for variable declaration.

  • Mike Ault's Oracle "good practices": Oracle design

    Mike Ault provides "good practices" for Oracle database and project design, including using Dr. Codd's normal forms, source control and naming conventions.

  • Mike Ault's Oracle "good practices": Oracle environment

    Mike Ault provides "good practices" for working with the Oracle environment, such as using Optimal Flexible Architecture (OFA) standards to lay out your database and verifying proper operating syst...

  • Mike Ault's Oracle "good practices"

    In this six-part tip, Mike Ault offers Oracle "good practices" in categories including the Oracle environment; backup, failover and disaster recovery; system security; design; coding; and performan...

  • Performance tuning RMAN backup and recovery operations

    If you have used RMAN before Oracle Database 10g, you will find some changes to the performance-related commands, which make the tuning process easier to understand. This chapter from Oracle Database...

  • High-availability architecture and clusters

    In today's super-fast world, data and application availability can make or break a business. Extremely high levels of disaster tolerance must allow the business to continue in the face of a disaster, without...

  • PL/SQL programming: Assignments, initializations and NU

    This excerpt from "Easy Oracle PL/SQL Programming: Get Started Fast with Working PL/SQL Code Examples" covers how to work with assignments, initializations and NULLs.

  • Oracle 10g expert SQL tuning techniques

    This book excerpt focuses on real-world techniques for improving the speed of SQL queries with a focus on new Oracle 10g features. The topics include the new Oracle parameters that affect SQL perfo...

  • Database down! Bring it back alive!

    This excerpt from "Everyday Oracle DBA" explains what to do in the event that your database goes down and you're under pressure from your managers to get it back up as soon as possible.

  • Recovering from user errors

    This book excerpt explains how to recover a dropped table using Flashback technology, manage the recycle bin, perform a Flashback Table operation, recover from user errors using Flashback Versions ...

  • Recover Oracle databases

    This book excerpt explains how to recover from the loss of a controlfile, redo log file or system-critical or nonsystem-critical datafile.