hemantoracledba.blogspot.com

ocdatabases.blogspot.com

Orange Coast Database Associates: CASE expressions

http://ocdatabases.blogspot.com/2012/09/case-expressions.html

Sunday, September 9, 2012. There are times when you want to pick one of several alternatives for a field in your select list. The examples we are going to use are from our bookstore database ( click to download at box.com. CASE selector when expr1 then value1 when expr2 then value2 . when exprN then valueN else value 3. The else clause is optional. The alternative is selected based on the value of the selector. CASE when expr1 then value1 when expr2 then value2 . when exprN then valueN else value 3.

ocdatabases.blogspot.com

Orange Coast Database Associates: Supplier-Parts Database SQL Script

http://ocdatabases.blogspot.com/2012/04/supplier-parts-database-sql-script.html

Saturday, April 14, 2012. Supplier-Parts Database SQL Script. SNUM int NOT NULL PRIMARY KEY,. SNAME varchar(16) NOT NULL UNIQUE,. STATUS int NOT NULL,. CITY varchar(20) NOT NULL. PNUM int NOT NULL PRIMARY KEY,. PNAME varchar(18) NOT NULL,. COLOR varchar(10) NOT NULL,. WEIGHT decimal(4,1) NOT NULL,. CITY varchar(20) NOT NULL,. UNIQUE (PNAME, COLOR, CITY). SNUM int NOT NULL REFERENCES Suppliers,. PNUM int NOT NULL REFERENCES Parts,. QTY int NOT NULL,. PRIMARY KEY (SNUM, PNUM). INSERT INTO SupplierParts VAL...

freekdhooge.wordpress.com

Oracle anounces the Unbreakable DB Appliance | Irrelevant thoughts of an oracle DBA

https://freekdhooge.wordpress.com/2011/09/21/oracle-anounces-the-unbreakable-db-appliance

Irrelevant thoughts of an oracle DBA. Oracle anounces the Unbreakable DB Appliance. 8212; Freek D'Hooge @ 19:33. More then 10 years after Oracle’s first appliance attempt with Raw Iron and 3 years after the release of Exadata, Oracle has now announced the Unbreakable DB Applicance. This cluster in a box consists out of a 4 RU chassis, in which 2 server nodes, 96 GB memory per node, 12 TB raw shared disk storage (24 disks) and 292 GB flash disks has been placed. So far the product launch information.

hemantscribbles.blogspot.com

Hemant's Scribbles: Alzheimers

http://hemantscribbles.blogspot.com/2015/02/alzheimers.html

Faith must be enforced by reason. when faith becomes blind it dies." - Mohandas Gandhi. 08 February, 2015. The movie "Still Alice" is on the topic of early-onset Alzheimers. It is an exploration of the questions the patient and his/her family faces. Do watch the movie if you are in your 50s or have an aged parent. List of Other Sites. My Oracle DBA Blog. The AAP Victory and what the BJP did wrong. View my complete profile.

hemantscribbles.blogspot.com

Hemant's Scribbles: October 2014

http://hemantscribbles.blogspot.com/2014_10_01_archive.html

Faith must be enforced by reason. when faith becomes blind it dies." - Mohandas Gandhi. 29 October, 2014. Update on BOINC Work Credits. So far, the total "Work done" by my BOINC. Account on various projects is :. Einstein@Home : 361,987 Milkyway@Home : 145,099 SETI@home : 100,984 climateprediction.net : 66,582 malariacontrol.net : 33,495 Spinhenge@home : 13,514. List of Other Sites. My Oracle DBA Blog. Update on BOINC Work Credits. View my complete profile.

freekdhooge.wordpress.com

RAC investigations part I | Irrelevant thoughts of an oracle DBA

https://freekdhooge.wordpress.com/2011/08/11/rac-investigations-part-i

Irrelevant thoughts of an oracle DBA. RAC investigations part I. 8212; Freek D'Hooge @ 0:06. 2 node rac with Oracle 11.2.0.2.2. Oracle Linux 5.6 with the Unbreakable Enterprise Kernel (2.6.32-100.36.1.el5uek). Test srv is a service which has both the instance running on node1 and node2 as preferred instances. On node1 the service was manually stopped. Issue a “shutdown abort” on the instance running on node2. Start the instance again. Same test, but this time the service is stopped on all instances.

nigelnoble.wordpress.com

11.2.0.3 v$sqlstats.last_active_time stops changing and breaks AWR | Nigel Noble's Oracle Blog

https://nigelnoble.wordpress.com/2013/03/28/11-2-0-3-vsqlstats-last_active_time-stops-changing-and-breaks-awr

Nigel Noble's Oracle Blog. 11203 v$sqlstats.last active time stops changing and breaks AWR. 8212; Nigel Noble @ 3:18 pm. 8221;…. I thought! Well, I recently discovered that any time a sql statement drops off the 3rd party monitoring tool…… IT STOPS BEING MONITORED IN AWR’s DBA HIST SQLSTAT table as well. Let’s start at the very beginning…. V$sqlstats.last active time can stop changing with multiple child cursors. I wrote the following script to compare v$sqlstats to v$sql. Output looks like this:. I foun...

hourim.wordpress.com

Why Dynamic Sampling has not been used? | Mohamed Houri’s Oracle Notes

https://hourim.wordpress.com/2015/06/12/why-dynamic-sampling-has-not-been-used

Mohamed Houri’s Oracle Notes. June 12, 2015. Why Dynamic Sampling has not been used? 8212; hourim @ 10:15 am. Experienced tuning guys are known for their pronounced sense of looking at details others are very often ignoring. This is why I am always paying attention to their answers in otn and oracle-l list. Last week I have been asked to look at a query performing badly which has been monitored via the following execution plan:. As you can see apart from the optimizer index cost adj. About dynamic sampli...

hourim.wordpress.com

Stressed ASH | Mohamed Houri’s Oracle Notes

https://hourim.wordpress.com/2015/07/09/stressed-ash

Mohamed Houri’s Oracle Notes. July 9, 2015. 8212; hourim @ 5:29 pm. It is well known that any record found in dba hist active session history has inevitably been routed there from v$active session history. If so, then how could we interpret the following cut and past from a running production system? 12,950 snapshots of SQL*Net break/reset to client. And 12,712 snapshots of an enq: TM – contention. Wait events in AWR not found in ASH. How can we interpret this situation? Typically the activity is mainly ...