Saturday Mar 14, 2015

New Oracle servers and engineered systems annouced.

In December of 2014, Oracle announced new Server models, X5-2 and X5-2L. They're based on the latest processors from Intel - the Xeon® E5-2600 v3 processor family (aka Haswell-EP processors). We've also announced support for high bandwidth NVM Express (NVMe) flash drives on both new servers. Oracle leveraged these updates to engineer new Exadata and ZDLRA appliances. Also new is the Oracle SuperCluster T5 system. The new Exadata X5 Storage Servers are based on the new X5 systems, Oracle eliminated the need for the High performance storage cell and introduced a new Extreme Flash cell, the High Capacity option still available brings a lower cost savings and extreme performance to our customers.

Monday Jun 02, 2014

Exadata - Following up on customer deployments

me Over the last year or so I've been visiting customers who have had Exadata deployed and have been enjoying the benefits the platform has been providing. Benefits include greater performance, consolidating multiple databases, data compression and time to value improvements. Most often I hear my reports run faster. One hospitality company report times that used to take 3 hrs now run in 12 seconds. Another services company reported all their batch reports taking 11hrs now run in 38 mins. Also reported that their transactions post faster, and batch updates run faster. So what does that mean? For most of them it means that now they have a platform that can handle growth. Most are growing 15% organically, but I've also seen 40% growth thru acquisition. Exadata has been keeping up with the additional data demand by customers leveraging compression and the smart storage features.

Wednesday Mar 26, 2014

TEMP use and spilling to disk

I've run across this recently. I think in this case, a batch process need more memory that was allotted by the auto work area size policy.

This is the issue we saw, lots of direct read and writes to temp. Slow

SQL>alter session set workarea_size_policy=manual;

SQL>alter session set workarea_size_policy=manual;

SQL> alter session set hash_area_size=1073741824;

after changing the work area size policy to manual and giving a large amount a ram to sort we then saw all the direct reads and writes to temp disappear. Slow

I think there may be times when measures like this are needed. Anyone else run across a case like this?

Saturday Mar 22, 2014

Database Slowness?

Slow

Slowness could be perceived as taking long and not always what you think. Taking a look at your resource usage, CPU, Memory and I/O can be done with Enterprise Manager. I can view historical data to see where there may have been a high demand for any of these resources. Enterprise Manager will also allow you to drill down into the AWR snapshots and report back on SQL executing at that time. You can locate resource consuming SQL identified by the Automatic Database Diagnostic Monitor (ADDM) which analyzes the AWR data on a regular basis, then locates the root causes of performance problems, provides recommendations for correcting any problems. Sometimes, workloads take longer due to sub optimal execution plans. Something that may have completed in a minutes or seconds may now be taking hours or days due to changes in the plan. Plan is determined by the optimizer and if the data load process did not collect stats or potentially the data was loaded after a stats job runs, you may be a seeing poor cardinality estimates from the optimizer on the stats collected. If you note a big discrepancy between estimated rows and actual rows processed, you have to deal with it by collecting stats. It may required extended stats as well. I would explore using SQL Monitor to look at any SQL have identified as taking longer. Another tool you can use is SQLT available from Oracle support at:

https://support.oracle.com/epmos/faces/DocumentDisplay?id=215187.1

The reports may include some content provided by the Oracle Diagnostic and/or the Oracle Tuning Packs (in particular SQL Tuning Advisor "STA", SQL Tuning Sets "STS", SQL Monitoring and/or Automatic Workload Repository "AWR"). Be aware that using this extended functionality requires a license for the corresponding pack. If you need to disable SQLT access to one of these packages, please execute one of the following commands connected as SQLTXPLAIN: SQL> EXEC sqlt$a.disable_tuning_pack_access; or SQL> EXEC sqlt$a.disable_diagnostic_pack_access;

SQLT was written by Carlos Sierra who worked in Oracle's support division and later moved on to Enketec https://www.enkitec.com/about/bios/carlos.sierra - you can also look for a great book titled "Oracle SQL Tuning with Oracle SQLTXPLAIN, author Stelios Charalambides"

Friday Mar 21, 2014

Oracle Exadata workshop

Engineered Systems

Well, we got off to a rocky start, my car battery was dead first thing in the morning. Ugh, it caused me to be 1 hour late. Then there was a mix up in the conference rooms, but we all got it squared away and by 9:30am we got started. I hope you all got came away from that day with a little more knowledge about Exadata and what it has to offer and a better understanding of what Oracle's Engineered Systems are about. Please feel free to post comments, I'd love to hear from you.

Wednesday Mar 19, 2014

Exadata Workshop / Orlando March 20th

I'll be at the Orlando event on March 20th, hope to see you there.[Read More]

Monday Aug 24, 2009

Commodity Infrastructure Assessment

[Read More]

Database Security Team

[Read More]

Tuesday Apr 29, 2008

Oracle ASM install

[Read More]

Oracle ASM install

[Read More]

Friday Nov 16, 2007

My New Toy, an iPhone

[Read More]

Tuesday Sep 04, 2007

MDA and windows mobile 6

[Read More]

Wednesday May 16, 2007

HP loans me some hardware

[Read More]

Friday Apr 27, 2007

Workshops

[Read More]

Thursday Mar 29, 2007

Enterprise Manager R3 released

[Read More]
About

Senior Solutions Specialist

Search

Top Tags
Archives
« April 2015
SunMonTueWedThuFriSat
   
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
  
       
Today