(Bill Cullen) I am an Oracle9i OCP. How can I implement a RAC application in Oracle Database in my system? Please give me the total steps to implement RAC. (R)
Tag: Oracle
Get Information on Current Queries
(Laurent Leturgez) This script provides information about the queries that are currently using temporary segments.
Oracle to open up on bug severity
(Joris Evers) Oracle plans to add severity ratings to its security bulletins, making the alerts less of a guessing game for customers.
Check out this easy way to find Oracle version information
(Bob Watkins) When an application will be distributed to customers—or even to multiple sites within the same company—version issues may arise. If the program is designed to use features specific to a particular version of Oracle, it will fail when run on earlier versions.
Oracle 10g: A Simple Security Approach – Part 1
(JP Vijaykumar) A detailed discussion on the setup and administration of database access and security is beyond the scope of this document.
Identify Tables That Need Space
(Diwaker Johar) This tip lets you identify tables that need more than a specified amount of space. This example uses a size of 1GB.
Learn Data Warehouse: Defining Goals
(Lewis Cunningham) The first step in any data warehouse project (really any project) is to define your goals. If you don’t know what you want, how will you know if you get it?
Running PL/SQL Code Using SQL Developer
(Sue Harper) I have seen a few questions about running PL/SQL using SQL Developer and what to do when encountering the PL/SQL error message “wrong number or types of arguments in call to ‘||’ ”
Oracle buys data integration company Sunopsis
(James Niccolai) Oracle has acquired French data integration software company Sunopsis for an undisclosed sum, the companies announced.
Create backup controlfile for scripting recovery
(James F. Koopmann) Need to create a backup controlfile for scripting recovery? Often times we are faced, in Oracle, to recover our databases with a backup controlfile. Or worse yet we just need to clone or copy our database to a different system to create a test, QA, or development environment.
