DBASupport
Oracle Database 11g: Database Replay, Part 3
The final article in this series illustrates how to use Oracle Database 11gR1's new Database Replay (DBR) features to capture and prepare a workload from a current Oracle 10gR2 single-instance database environment and then replay that identical workload in an Oracle 11gR1 Real Application Clusters (RAC) testing environment.
Product Review Toad Data Modeler 3
Quest Software has hit the ball out of the park with its Toad Data Modeler 3 (TDM) application. Ease of use, a huge amount of functionality, and an outstanding support base all combine to make TDM a superb product. Read on to learn more...
Oracle Automatic Storage Management
ASM provides many benefits, but also requires learning new concepts, commands, utilities, and administration tasks. Sean Hull examines what ASM solves, and what it takes to manage and weigh the pros and cons.
Oracle Applications Reference Books
Aside from Oracle's own documentation covering Oracle Apps and a few books covering specific modules, the published books landscape regarding EBS is fairly barren. There are two notable generalist coverage books available that can help you get a good jump on learning Oracle Applications.
Oracle Database 11g Common Background Processes
To understand Oracle background processes is to understand how Oracle works--offering opportunity to tune effectively. Learn about the processes that are typically running after a fresh, common, and basic installation.
Oracle Database 11g: Database Replay, Part 2
Part 2 of this series - demonstrates how Oracle 11g Database Replay can be used to capture and prepare a workload from a current Oracle 11g production database environment (P+0) and then replay that identical workload in an Oracle 11g testing environment that represents the next iteration (P+1) of the database system.
Oracle DBA in an Oracle Applications World Part 2
Steve Callan presents a simple but effective means of replicating your production environment for the first time on a new machine.
Oracle 10g Cloning Guide: A Small County Government Approach
This document offers one approach to database refreshes for Oracle 10g databases on Windows 32 and 64 bit servers.
Oracle Warehouse Builder Automated ETL Processing
Steve Callan offers a high level overview of what it takes to automate a load, covering each and every project item you need to address for this to work.
Multi Table Loop
This article examines how to loop through multiple tables to process the data.
Programming, Perl + Oracle
Perl is a powerful scripting language that can meet your day-to-day scripting needs as a database administrator, and if used prudently, and responsibly, as a language to build large web-based applications. Here's a quick introduction to using Perl with Oracle.
Create your own reports with Oracles Snapshot Information
If you are tired of running the same old Oracle AWR reports, not getting to the data quickly, or just need to write your own, then this article will get you started.
Oracle Database 11g: Database Replay, Part 1
This article provides a primer for using Oracle 11g Database Replay to effectively predict the performance of rapidly changing applications within increasingly fluid database environments.
Oracle DBA in an Oracle Applications World
Steve Callan takes a look at what is behind the smoke, mirrors, and curtains of Oracle Applications.
Oracle Indexing - What, Where, When?
If you are new to databases, or perhaps new to Oracle, you may find the discussion on indexes and indexing strategy complicated. Don't fret. To get started it's fairly straightforward, and as long as you pay attention to the options relevant to day-to-day DBA needs, it should remain fairly simple.
»
More Features...
Receive articles via our XML/RSS feed
 
DBASupport News
Sybase-to-Oracle Migration Accelerated By ANTs Software
ANTs software inc. introduces the Sybase-to-Oracle Accelerator Program, a new promotional offering that complements Oracles current Sybase Safe Switch Program...Sybase-to-Oracle Migration Accelerated By ANTs Software...
Oracle Updates Entire Family of Oracle Berkeley DB Embeddable Databases
Oracle announces new releases of Oracle Berkeley DB, Oracle Berkeley DB XML and Oracle Berkeley DB Java Edition.
Oracle Still Top Dog in Tough Database Market
The leading database vendor retained strong market share in 2007, but faces increasing competition from low-cost, open source alternatives.
Cache Payback
Oracle Data Provider for .NET (ODP.NET) enables you to take advantage of features exposed by the underlying Oracle Call Interface. One such feature new in Oracle Database 11g Release 1 and Oracle Database 11g Release 1 Client is the client result cache.
HP Blade Latest to Run Oracle Warehouse
Gestation period's over for the newest business intelligence product on the block.
Accelerating Data Warehouses
Oracle OLAP 11g brings high-performance data warehouse features to Oracle Database 11g.
Oracle Buys Skywire Software
Oracle today announced that it has agreed to acquire Skywire Software's application software business.
What will Oracle's price hikes mean for Oracle customers?
Oracle's decision to raise its list prices by 15% to 20% is cause for concern for both existing and prospective customers. But there are opportunities to offset those hikes, according to industry analysts.
Confio adds Oracle Explain Plans to DB monitoring
Confio Ignite for Oracle adds Top Plans and Top Objects to Database Monitoring Dimensions.
Oracle sets middleware lineup following BEA deal
Six weeks after closing its buyout of BEA Systems Inc., Oracle has prioritized its middleware lineup.
Making Database Connections
Connect to Oracle and third-party databases from Oracle SQL Developer.
Explore Oracle 10g's updated sample schemas
Each new release of Oracle database brings with it new features to explore. It can be a challenge to create adequate sample tables to play with a given feature.
Integrating Oracle's Hyperion Essbase - System 9 with Oracle Business Intelligence
A step-by-step guide to using Oracle's Hyperion Essbase System 9 as a back end for Oracle Business Intelligence Suite Enterprise Edition. From Oracle ACE Director Mark Rittman.
Enterprise 2.0: Oracle Plans New Business Apps, With A Social Twist
The forthcoming apps from Oracle mirror the look and feel of Web 2.0 social networking services -- including MySpace and Facebook.
Oracle Unveils Oracle Demand Signal Repository
Oracle Demand Signal Repository captures, cleanses and harmonizes large volumes of external demand data to give users insight to consumer and supply chain behavior.
»
More News...
Receive news via our XML/RSS feed
Hierarchial Loop III
This script displays all of the employees working under a particular employee in a string, separated by a '|' as delimiter. To achieve this I created a function and then used the function to display all the employees working under a particular employee (Top down hierarchial traversal).
Backup in Noarchivelog in RMAN
This script will backup in noarchivelog using RMAN.
Measure the Buffercache Hit Ratio for User Wise
This script allows you to see the bufferhit ratio of all application users, when all application users are running on the server, so that you can measure individual performance.
Check Free Shared Pool and Flush
This script checks the free space in the shared pool and when the size is very small executes an alter system flush shared pool.
Hierarchial Loop II
This script displays all of the employees in SCOTT.EMP table, with all of the bosses they report to, in a hierarchial loop, along with their level in the hierarchy.
»
More Scripts...
|
