DBASupportExamining the Oracle Database 10053 Trace Event Dump File
Ever wonder what the Oracle Database Cost Based Optimizer (CBO) was doing behind the scenes or how it comes up with an execution plan? While other tools or settings show us WHAT the CBO comes up with, the 10053 trace event setting tells us HOW the CBO came to its decision (the final execution plan).
I/O Performance Tuning Tools for Oracle Database 11gR2
Oracle Database 11g Release 2 (11gR2) makes it easier than ever to isolate and identify potential root causes of poor I/O performance. This article focuses on the various Oracle and non-Oracle tools to generate sample workloads to provide sufficient metrics for detection and eventual resolution of performance bottlenecks within the databases underlying input/output (I/O) subsystem.
Solve Database Performance Tuning Problems by Monitoring CPU Resource Consumption
Constantly watching CPU utilization is critical to a database administrator's understanding of their database system. The sar utility, while seemingly small and insignificant can and should be used to help initially determine if any high-level CPU resource usage is out of balance, potentially signaling a database performance tuning problem.
Purchasing Oracle Database Support for your Own Use
Oracle's software is freely available for personal use but you'll have to pay for access to technical notes, patches, and other specialized content. Plus, there's a technical/legal catch; you can't use My Own Support to find database articles under a different product license. In terms of compliance, you really need a database product. Enter Oracle Database Personal Edition.
Oracle Database 11gR2 I/O Performance Tuning: A Primer
Tuning the performance of Oracle Database 11gR2 is still just as much of an art as it is a science. Jim Czuprynski focuses on the detection and analysis of performance bottlenecks within the database's underlying input/output (I/O) subsystem.
Installing Oracle Database Sample Schemas using Data Pump
Having a re-usable dump file for installing Oracle Database Sample Schemas is much more convenient than the current method. Would you rather download a compressed file containing one (or several) dump files, including a parameter file suitable for use during an import session or job or use the Oracle Universal Installer?
Getting Oracle VM VirtualBox Ready for an Oracle Database
Everyone wants to go virtual, but getting started with Oracles VM VirtualBox can be tricky. James Koopmann takes a quick look at installing Oracle VM VirtualBox 3.2.4, covering some of the features you as a database administrator or database developer might run across while trying to install an operating system or Oracle database.
PL/SQL Records for Oracle Database Administrators
It can be hard, as an Oracle Database administrator, to expand your PL/SQL skills due to a lack of good examples, not to mention that lines upon lines of syntax definitions can be somewhat of a turn-off. Steve Callan shows how using PL/SQL records can simplify what you have to code - and they're easy to use too.
Leveraging ACFS Snapshots and Cluster Infrastructure in Oracle Database 11gR2
Jim Czuprynski illustrates how to upgrade an Oracle Database 11gR1 quickly and efficiently to Oracle Database 11gR2 and place its database files within ASM-managed storage, including a brief demonstration of how ACFS snapshots can be used to recover quickly from human error when crucial components of an Oracle home are damaged or destroyed.
Oracle Database's ADRCI: the Extended Commands
Oracle's ADRCI extended commands provide valuable scripting and file viewing options, with about two dozen commands that you can use to look at and manage diagnostic information.. ADR is the future of Oracle diagnostics and it's essential that database administrators understand it.
Oracle Text - Expanding Your String Searching Capabilities in Oracle Database
Searching for text within a database can be like searching for the proverbial needle in a haystack. Users depend on the database administrator to solve complex text search requirements. Do you respond with clever methods such as LIKE, regular expressions and function-based indexes? Is there something more available to you and your users?
Oracle Database Experts: Share Your Story
Just a couple weeks left to get your Oracle database or application abstract in for review to the UKOUG Conference Series.
Oracle has Released Oracle Business Intelligence 11g
Oracle has now released its Oracle Business Intelligence 11g, a complete suite of products providing business intelligence capabilities from enterprise reporting to scorecards and ad hoc queries.
Bulk File Edit
This script will go through each file with the *.dat extension in a directory and fill the 3rd pattern "<>" in the line that contains a specified directory, with a specified path.
FULL OUTER JOIN LOOP
This script displays matched records from two tables when constraints prevent a full outer join.
IF EXISTS/IF NOT EXISTS
This script creates a user, if the user does not exist in the db and drops the user, if the user exists in the db.
Killing Sessions
Use this script to kill a job and re-run it fter incorporating HINTS.
Debugging Column Length
This script debugs column length mismatch in Oracle tables and joins the matching rows through an equi join.
