Submitted by sriram717 on Wed, 2007-02-21 03:25
Automatic Work Load Management
Application workloads can be defined as services so that they can be individually managed and controlled.
We can control and monitor which processing resources are allocated to each service during both normal operations and in response to failures.
Performance metrics are tracked by service and thresholds set to automatically generate alerts should these thresholds be crossed.
CPU resource allocations and resource consumption controls are managed for services using Resource Manager.
we deifne rules to automatically allocate processing resources to services. Oracle RAC 10g instances can be allocated to process individual services or multiple services as needed.
Submitted by rleishman on Sun, 2007-02-18 03:31
Benjamin Disraeli, circa 1870 wrote:
Never complain and never explain.
Disraeli was a lot of things, but Oracle Programmer was not amongst them. To be fair, perhaps he wasn't talking about Explain Plan?
SQL is a goal-oriented language. Unlike procedural languages, we tell the database what we want rather than how to get it. Oracle's Cost Based Optimizer comes up with an execution plan that is hopefully the most efficient way to resolve the query, but for many reasons it will often choose a sub-optimal plan.
Submitted by cbruhn2 on Wed, 2007-02-14 08:59
When you setup statspack with level 6 you can have information on the sql_plan associated with a sql. (statpack on oracle db version >=9i)
Submitted by Miladin Modrakovic on Mon, 2007-02-12 11:21
How does one change Oracle's SYS password without having to login into the database? Is it possible?
The answer is, YES! All you need is a binary fiile editor and some knowledge of Oracle's internals.
This document is to be used only for testing purposes and should not be used in a production environment. The purpose is to show the audience how hackers can gain access to your system without knowing it - and how to prevent it.
Submitted by rleishman on Thu, 2007-02-08 23:48
A common complaint in SQL is that "it runs in 5 seconds in SQL*Plus, but takes hours in Production. Why?"
The reason is because SQL*Plus and most GUI SQL tools display rows as soon as they are fetched. In this way, you can
SELECT * FROM big_big_table and it will display the first 20 or so rows in the table in a fraction of a second, then go back for more. The SQL is not really finishing in seconds; if you timed how long it took to retrieve every row, you'd see that it takes just as long as in Production.
Submitted by ariton on Thu, 2007-02-08 03:35
This article provides several comparative methods to avoid primary key conflicts across multiple sites.
Submitted by cbruhn2 on Wed, 2007-02-07 04:58
When you setup statspack with level 6 you can have information on the sql_plan associated with a sql.
Submitted by rleishman on Sun, 2007-02-04 04:06
I'm not really an "early-adopter" of technology. Don't get me wrong; I love it, I just don't want to feed the addiction. When I do
get a new piece of technology though, it's like a fever; I can't concentrate on anything
until I've read the manual from cover to cover and found out everything it can do, every built-in gizmo, and every trashy piece of after-market merchandise that can be plugged into it.
Submitted by rleishman on Sun, 2007-01-28 00:21
Where were you in 1990? Nelson Mandela was being freed from Victor Verster Prison after 26 years behind bars, Saddam Hussein was starting the Gulf War by invading Kuwait, and Tim Berners-Lee was inventing the World-Wide-Web at CERN in Geneva. Me? In 1990, I was writing an insurance system in Oracle SQL*Forms v2.3.
Submitted by tarundua on Sat, 2007-01-20 12:53
Well, just for a briefing, since 1966, most of the United States has observed Daylight Saving Time from at 2:00 a.m. on the first Sunday of April to 2:00 a.m. on the last Sunday of October. But in 2007, most of the U.S. will begin Daylight Saving Time at 2:00 a.m. on the second Sunday in March and revert to standard time on the first Sunday in November.
So, Oracle has released patches to adapt these Daylight saving time changes. The databases that are using the following will be impacted…
1. Databases using TIMESTAMP WITH TIME ZONE and TIMESTAMP WITH LOCAL TIME ZONE data types and TZ_OFFSET function as they take their time zone information from Oracle's time zone files.