Tips

Tips

  • 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 performance, the use of hints to change SQL execution ...  Continue Reading

  • 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.  Continue Reading

  • A bit wiser with Oracle technology

    Learn how to use a metadata repository to identify a "source of truth" for each customer attribute in a data warehouse. This tip explains how to use the base-two numbering values of the primary key in the data source reference table and bitwise ...  Continue Reading

  • 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 Query and perform transaction-level recovery using ...  Continue Reading

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close