Using Oracle Alerts
We take a look at some of the alerting concepts and settings available within Oracle Database 11g.
Exploring Oracle GoldenGate - Creating Dump Files
In addition to performing replication, GoldenGate can also be used to dump the contents of a table into a formatted file.
Looking at Real-Time Database Performance
Oracle Enterprise Manger (OEM) is a good place to begin when addressing performance issues.
Learning Oracle GoldenGate
Steve Callan takes a look at configuring Oracle GoldenGate and discusses what takes place within Oracle GoldenGate in terms of how data gets from the source database to the target database.
Flashback Vs. Recovery in Oracle Database
If you consider "normal" recovery as anything having to do with RMAN (and what it replaced), then you're actually limiting yourself in terms of what Oracle has to offer. Recovery - in the traditional sense - isn't just recovery anymore, but more like recovery plus various flashback options.
Top 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...
Top 5 Basic Concept Job Interview Questions for Oracle Database PL/SQL Developers
James Koopman discusses how to give/take/study for an Oracle Database PL/SQL developer position, with a look at the top five questions he would ask potential Oracle Database PL/SQL Developers to help assess his/her basic knowledge.
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.
»
More Features...
Receive articles via our XML/RSS feed
 
Oracle Unveils Database Firewall
The new Oracle Database Firewall defends databases against SQL injection and other database attacks.
Steamline DBA and Developer Tasks with Embarcadero Tools
A new toolset from Embarcadero helps DBAs and developers perform common and complex tasks for Oracle databases.
New Oracle Manager Certification and Oracle DBA Training Courses
Netwind Learning Center is now offering online Oracle training courses and live boot camp classes to provide training for Oracle certification.
New Releases in Oracle Data Integration Product Line
New releases of Oracle's foundational products, Oracle GoldenGate 11g and Oracle Data Integrator Enterprise Edition 11g, now available.
Oracle BI Best Practices and Assessments from Velaris
Overlooking Business Intelligence planning or losing track of the knowledge in that plan is not the best approach to handling a BI system. Learn how VElaris' Health Check assessment and report for the Oracle BI environment can help.
Live Webcast Introducing Oracle Data Integrator and Oracle GoldenGate
Oracle will introduce Oracle Data Integrator 11g and Oracle GoldenGate 11g in a live webcast; showcasing how Oracle data integration provides complete, integrated, and open solutions.
Master Oracle Database's Results Cache - Webinar
Dean Richards will lead a detailed presentation about leveraging Results Cache to improve database and application performance.
ReportsMaestro + Your Data = Interactive Dashboards
Create and share interactive customizable dashboards with ReportsMaestro. a web report and chart builder.
Free Step-by-Step Guide for Oracle 11g for Solaris
Database Specialists will be releasing a step-by-step installation guide for Oracle 11g for Solaris in September 2010.
Migrate to SQL Server with Free Download Tools
Microsoft releases the latest set of tools for users who wish to switch from MySQL, Access, Oracle and Sybase to a SQL based Server.
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.
Stellar Phoenix Oracle Recovery 2.0 Available
Oracle Recovery 2.0 now supports Oracle 10g and 11g 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.
Oracle and Cloud Databases Join the Quest Online Resource Community
Called OraDBPedia and CloudDBPedia, both will contain helpful videos, podcasts, blogs, and community-run wikis.
Easily Merge Data from SQL Server, Oracle, Access and More into Reports
Veera Business Intelligence Software can take data from various formats such as Excel, Access, SQL Server, Oracle, MySQL, and text then quickly change it into reports and analytic datasets.
»
More News...
Receive news via our XML/RSS feed
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.
»
More Scripts...
|
