DBASupport
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.
Recovering from Loss of All Control Files
Follow these easy steps to restore a database when the control files have been lost.
Measuring Disk I/O-Oracles ORION Tool
Oracles ORION workload tool enables architects to effectively develop a workload that can mimic and stress a storage array in the same manner as planned applications with an Oracle backend database.
Oracle Database 11g: SQL Plan Management, Part 3
The final article in this series illustrates how to use SPM to limit unexpected regression of existing SQL statement performance before those statements first encounter Oracle 11gs cost-based optimizer.
Licensing and Auditing in Oracle
Steve Callan discusses what can take place during the Oracle licensing or renewal process.
Oracle: Unusable Indexes
JP Vijaykumar examines what happens to an index when it becomes unusable.
Remote DBA Services
Remote database administration (DBA) is one of hottest trends in the market these days. Interviews with our respondents have shown that there are many aspects to utilizing remote DBA services. Read on to learn more...
Create a Database Manually - When & Why?
Peering into the Oracle database creation process really pulls back the curtain on the inner workings of the database, allowing us to understand all of the levers, and pieces that make up a running Oracle database.
Hands-on Oracle: Backup & Recovery Games
Learn what happens within the database after the loss of a control file and test it out yourself using a flash drive.
Measuring Disk I/O - A Vendor View
Learn how to compare the workload of a database with the actual mechanical capabilities of individual disks.
»
More Features...
Receive articles via our XML/RSS feed
 
DBASupport News
Oracle creates Web 2.0 division
Oracle is building a global division to offer businesses products, services and best practices for Web 2.0 collaboration.
Is your Oracle database really secure?
While Oracle databases are nowhere near as vulnerable as they were five years ago, there is still a great deal of attention being paid to them by both security professionals and hackers alike.
Oracle Debuts Enhanced Preview of Oracle Fusion Middleware 11g
Building on its November 2007 preview, Oracle today previewed additional planned feature enhancements of Oracle Fusion Middleware 11g.
Oracle: Eating its Own Open Source Food
Oracle's not just into Linux and Xen for the money, is it?
Oncilla Imagine is now Multi-language capable
Oncilla Imagine announces the release of its Oracle database client software version 1.0.1.
Squeezing More Storage Out of Analytics
SRM tools promise greater efficiencies, utilization rates.
Reva Systems Integration Of RFID Data For The Oracle E-Business
Reva Systems recently announced that it is working with Oracle to enable Oracle E-Business Suite customers to capture and utilize high-quality RFID data.
IOUG Welcomes BEA Systems, Inc. to Oracle User Community
The Independent Oracle Users Group (IOUG) would like to be the first to welcome BEA Systems, Oracles recent acquisition, to the Global Oracle user community.
Oracle SQL Developer 1.5.0.53.38
GUI for Oracle database management.
Oracle Completes Acquisition of BEA Systems
Oracle Corporation announced that it had received approval of the European Commission and subsequently completed its acquisition of BEA Systems, Inc.
Oracle Kicks Off Registration for Oracle OpenWorld San Francisco 2008
Oracle announced today that registration for Oracle OpenWorld San Francisco 2008 is now open.
CodeSnip: How to make use of parameterized cursor in Oracle
Often it is convenient to pass a given set of values as input parameter to a cursor. It is very useful where nested cursors are used. Parameterizing the cursor makes it more usable and avoids the limitation of hard coding values in where the clause. In this code snippet, Deepankar examines this technique with the help of the relevant SQL code.
Researcher finds new way to hack Oracle database
Security researcher David Litchfield has released technical details of a new type of attack that could give a hacker access to an Oracle database.
Authorizing Access to Dynamic Spatial-Temporal Data
Authorizing access to individual data objects based on spatial and temporal references is a complex task. Read this case study to learn one feasible approach.
Over 120 Oracle Accelerate Solutions Now Available From Oracle Partners
Momentum continues for Oracle Accelerate as Oracle today announced 33 new Oracle Accelerate partner solutions...
»
More News...
Receive news via our XML/RSS feed
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.
Comma Delimiter Strings
Splitting a Comma separated line.
»
More Scripts...
|
