DBASupport
Oracle Reports for DBAs
As an Oracle DBA you might think that Oracle Reports have nothing to do with you, and you might be missing out on a simple means of generating reports to identify a source file, create an external table, write an SQL script and more.
Oracle: MOVE vs SHRINK Commands
This article discusses re-organizing a table using the move and shrink commands, then compares how the rows are compacted within Oracle blocks and how row chaining is resolved.
DBA Insider - Useful PL/SQL Packages
Oracle supplies quite a large complement of pl/sql stored procedures, packages, and functions, which can help with some of a DBA's day-to-day needs. This article looks at some of the useful ones that we can add to our DBA or Developer toolbox.
Hands-on Oracle: Backup and Recovery Games - Creating Datafiles
Learn how to recover from the loss of a datafile, when you don't have a backup of that file.
Looking at Memory Usage for Oracle Processes
When an Oracle instance starts, or an application uses the Oracle database, the associated Oracle processes are allocated and consume memory. Learn how to use the V$PROCESS view and V$PROCESS_MEMORY to look at this memory usage.
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.
»
More Features...
Receive articles via our XML/RSS feed
 
DBASupport News
Oracle Launches Oracle Access Management Suite
Oracle today unveiled Oracle(r) Access Management Suite, a comprehensive offering for next generation access management.
Oracle Counters SQL-Injection Holes With Update
There were an additional seven patches for PeopleSoft and J.D. Edwards applications, seven for the recently acquired BEA product suite, and six for Oracle E-Business Suite.
Oracle updates its enterprise performance management system, details Hyperion integration
Oracle unveils a number of enhancements to its enterprise performance management system and detailed its Hyperion integration efforts in a lengthy and wide-ranging Internet press conference.
Oracle WebLogic Apache Connector Lets Remote Users Execute Arbitrary Code
A vulnerability was reported in Oracle WebLogic in the Apache Connector. A remote user can execute arbitrary code on the target system.
Oracle Patches 45 Vulnerabilities
BEA joins the quarterly roundup of Oracle critical patch updates.
iDefense confirms the existence of three vulnerabilities in Oracle products
iDefense confirms the existence of two vulnerabilities in Oracle Corp.'s Oracle Database product and one vulnerability in Oracle Corp.'s Oracle Internet Directory.
Oracle expands application testing support
Oracle has expanded support for previous releases of Oracle Database to help organizations institute hardware and software changes, including upgrades to Oracle Database 11g.
Oracle still top dog in tough database market
However, open source offerings are nipping at its heels.
Oracle Critical Patch Update Pre-Release Announcement - July 2008
Oracle announces the pre-release of 45 security fixes.
Oracle Backports Real Application Testing to Speed Upgrades to Database 11g
Oracle officials hope extending support for the Real Application Testing feature to Oracle 10g and 9i Release 2 databases will help with the uptake of 11g.
On Exceptions and Rules
Best practices for where, when, and how to handle exceptions.
Oracle and Enterprise 2.0
Its a key part of the focus as the vendor outlines the integration roadmap around its acquisition of BEA.
nCipher to provide encryption key management for Oracle Database 11g
nCipher plc today announced its nShield and netHSM key management solutions are now integrated with Transparent Data Encryption...
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.
»
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...
|
Featured in the
