Oracle and Sybase
Database Administration -
Analysis - Architecture

CONTACT

News

New articles, scripts, news, announcements....

02/08/06: New DevX Article: Write Time Zone Aware code in Oracle

Another new article on DevX.com. "Oracle 9i introduced data types and support to handle time zones. Use these data types to make your Oracle code time zone aware." Covers everything you need to know to get started using time zones in your database and code.

01/20/06: New DevX article: The Oracle 10g Data Pump API Speeds Up the ETL Process

I've got a new article up on DevX.com. Quote, "How can you keep slow extract, transform, and load operations from bogging down your production instance? Oracle 10g's Data Pump API offers a great solution." Check it out!

01/16/06: New OraFAQ article: 10gR2 New Features: RAC Enhancements

Oracle introduced a bevy of RAC improvements and new features in 10gR2. Read this article and find out about them.

12/02/05: New OraFAQ article: Monitoring Open and Cached Cursors

ORA-1000 errors, "Maxiumum Open Cursors Exceeded," are one of the most common problems to plauge DBAs. Learn the difference between OPEN_CURSORS and SESSION_CACHED_CURSORS and how to tune and monitor both parameters.

11/18/05: New article on DevX.com: COM Automation in PL/SQL

Oracle provides a simple PL/SQL API that lets developers interact with Microsoft COM objects directly from PL/SQL. Learn how to install the COM option in your database and get started in this article.

11/08/05: New OraFAQ article: Power-user SQL*Plus Scripting

New article on OraFAQ.com that'll help you take your Oracle SQL*Plus scripts to the next level. Most DBAs have a rudimentary grasp of how to use substitution variables -- those '&' things -- in SQL*Plus. Few know that you can do much more with SQL*Plus variables, including read values into them from the database, perform numerical calculations on variables, etc. Read all about SQL*Plus variables here, and transform your DBA scripts from long lists of SQL statements to a key tool in your DBA toolkit.

10/26/05: New Toolkit script: Deleting dupes

I've posted a new article on how to delete duplicates from a table in my Toolkit. There's an Oracle-specific trick which makes this common data integration / data cleansing task very easy.

10/14/05: New Toolkit script: Scheduling jobs

I've posted a new article on DBMS_SCHEDULER in my Toolkit. DBMS_SCHEDULER is Oracle's replacement for DBMS_JOB, which many DBAs found clunky and hard to use. DBMS_SCHEDULER has a lot of great new features, like much-improved semantics, the ability to combine, minus and intersect schedules, and the ability to run OS jobs from within Oracle.

10/10/05: New OraFAQ article: Asynchronous Commit

New article on a 10gR2 new feature, Asynchronous Commit, on OraFAQ.com. This has to be my least favorite Oracle new feature of all time.