(Jeffrey Hunter) This script is used to report on overall redo log contention for the instance since the instance was last started. (script)
Tag: Oracle
Will Fusion satisfy JDE and PeopleSoft customers?
(Luke Meredith and Matt Stansberry) It might not be the panacea J.D. Edwards (JDE) and PeopleSoft customers were looking for, but Oracle Corp. hopes that they see its newly branded Fusion Middleware as a start. (R)
Database Interaction with PL/SQL, part 2
(Jagadish Chatarji) This article picks up where part one left off. You will learn more about how to use %ROWTYPE and %TYPE, and be introduced to TYPE, RECORD, and TABLE declarations in PL/SQL.
Oracle Block Sizes
(Howard J. Rogers) What is a good Oracle Block Size?
Using Caches in Multi-Tier Applications: Best Practices
(Andrei Cioroianu) Multi-tier architectures help make complex enterprise applications manageable and scalable. Yet, as the number of servers and tiers increases, so does the communication among them, which can degrade overall application performance.
Oracle Bug Database Susceptible to ‘Metalink Hacking’
(Lisa Vaas) The Oracle security research firm Red Database Security GmbH has found 42 bugs, some serious, in Oracle Corp.’s Metalink knowledge base, and determined that it’s possible to search Oracle’s bug database for customer e-mails, used configurations, test cases and other sensitive information
Hot backup script
(Ravi Nookala) This UNIX shell script will facilitate a hot backup of one Oracle database. It has been tested on 7x, 8x and 9x, and was developed using parametric cursors to be more compact. You must edit this file to replace the relevant variables and paths to suit your environment. (R)
Getting Cumulative Sum
(Chacravarthi Ramasami) This code gives a cumulative sum for a column. This example uses the SAL column in the standard EMP table.
Oracle 10g PL/SQL Enhancements, Part 1: DBMS_CRYPTO, DBMS_MONITOR, and DBMS_SERVER_ALERT
(Jim Czuprynski) With the addition of over fifty new PL/SQL packages as well as enhancements to a majority of existing DBMS packages, Oracle 10g has added a plethora of new tools to every Oracle DBA’s tool belt. This article – the first is a series — explores some of the more intriguing packages an
The Sorcerer of OO, Part 3
(Lewis R Cunningham) In Part 1 of this series, we talked about how Oracle objects compare to Java and how to create Oracle Objects. In Part 2, I covered we covered object comparison and type inheritance. Today, we’ll talk about polymorphism and type evolution.
