DBASupportTop 5 SQL Questions for an Oracle Database PL/SQL Job Interview
Interviewing for a PL/SQL developer position may turn into a quiz, specifically about writing SQL and extracting information from a set of tables. The following questions are actual questions the author has been asked when interviewing for both a DBA position and a PL/SQL developer position.
New Features for Oracle Database 11g Table Partitioning
Table partitioning can help DBAs key database performance areas including i/o balancing, contention reduction, SQL statement performance improvements and even data availability. New table partitioning methods found in Oracle Database 11g can be implemented to help to achieve some of these goals.
Oracle Business Intelligence, Past and Present
Oracle Business Intelligence 11g has been available since August 14 and many people are digging into the new features. Rather than repeating what is readily available elsewhere, this article looks at a history of the product, comparing the 11g version with the 10g version, so that you can better appreciate the changes.
Oracle Database I/O Performance Tuning: Capturing Extra-Database I/O Performance Metrics
It's important to understand how well the underlying I/O architecture is performing versus its expected I/O rates, before tuning an Oracle Database 11g Release 2 (11gR2) for optimal I/O performance. Jim Czuprynski discusses how to implement a suitable extra-database I/O performance test and then capture the actual I/O performance results.
Top 9 Database Object Tips You Need to Know for Your Next PLSQL Job Interview
Interviewing for a PL/SQL developer position ultimately will turn towards talking about database structures and objects. This article goes beyond the basic table and index questions that you might expect and offers a tip or two designed to impress the interviewer.
What's New in Oracle Warehouse Builder
Oracle Warehouse Builder (OWB) has seen many changes lately. Keeping up with new features in the Oracle RDBMS is challenging enough, and when you add changes to products, well, you may have your work cut out for you. This article looks at some updates in OWB for Oracle Database 11gR2 (plus some of the changes between 10g and 11g).
Understanding SQL Plan Baselines in Oracle Database 11g
SQL Plan Baselines are a new feature in Oracle Database 11g that helps to prevent repeatedly used SQL statements from regressing because a newly generated execution plan is less effective than what was originally in the library cache. Read on to learn more...
Examining 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?
Compare and Synchronize Oracle Databases with dbForge
Devart's dbForge Data Compare for Oracle is easy to use with a thoroughly designed graphical interface and wizards that provide quick, clear tools for fully controlling comparison and synchronization of Oracle databases.
SQL Server Migration Assistant for MySQL Available
SQL Server Migration Assistant (SSMA) for MySQL has been released! The existing Assistants for Oracle, Sybase, and Access have been updated to version 4.2.
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.
