Monday Sep 24, 2012

Announcing: General Availability of Demantra 7.3.1.4!

Announcing: General Availability of Demantra 7.3.1.4!

This new release brings important usability upgrades and key requested customer enhancements.

Key features released in Demantra 7.3.1.4:
- Improved user interface
- Improved mobile support
- Embed Demantra-Anywhere in Advanced Planning Command Center
- Aggregate work orders for Asset Intensive Planning

Additionally:
- Demantra 7.3.1.4 is certified with VCP 12.1.3.8 only.

Availability via patch 14405087.

Wednesday Sep 19, 2012

Demantra Engine Failure Hanging Error Not Starting Debugging INstall and Configuration Checklist

There is a new Demantra engine configuration checklist to ensure that your enginge setup and configuration is correct.  These are the questions that

development will ask should your issue turn into a bug.   See the following MyOracleSupport note:

Demantra Engine on Linux or Unix Failure Hanging Error Not Starting Debugging Install and Configuration Checklist Note ID 1086704.1

Friday Sep 14, 2012

Introducing the new Demantra Guided Resolutions!

There is a new method to find your solution called guided resolution or search helper.

Currently, we cover 5 specific topical areas:

Oracle Demantra 7.x and Above Data Loading Guided Resolution Note 1461899.1

Oracle Demantra Load Data Issues Not Necessarily Error Code Related Guided Resolution Note 1468884.1

Oracle Demantra 7.x and Above Workflow Issues Guided Resolution Note 1353217.1

Oracle Demantra 7.x and Above Worksheet Related Guided Resolution Note 1486639.1

Oracle Demantra 7.x and Above Engine Related Guided Resolution Note 1486634.1


The guides will be updated with the latest proven solutions on a regular basis, keeping the contect relevant.


What is a guided resolution?   What is the best practice using a guided resolution?

How to Use the Demantra Guided Resolution, a Proactive Services Tutorial.  Note 1473992.1

Thursday Sep 06, 2012

Using DB_PARAMS to Tune the EP_LOAD_SALES Performance

The DB_PARAMS table can be used to tune the EP_LOAD_SALES performance.  The
AWR report supplied shows 16 CPUs so I imaging that you can run with 8 or more
parallel threads.  This can be done by setting the following DB_PARAMS
parameters.  Note that most of parameter changes are just changing a 2 or 4 into an 8:

DBHintEp_Load_SalesUseParallel = TRUE
DBHintEp_Load_SalesUseParallelDML = TRUE
DBHintEp_Load_SalesInsertErr = + parallel(@T_SRC_SALES@ 8) full(@T_SRC_SALES@)
DBHintEp_Load_SalesInsertLd  = + parallel(@T_SRC_SALES@ 8)
DBHintEp_Load_SalesMergeSALES_DATA = + parallel(@T_SRC_SALES_LD@ 8) full(@T_SRC_SALES_LD@)
DBHintMdp_AddUpdateIs_Fictive0SD = + parallel(s 8 )
DBHintMdp_AddUpdateIs_Fictive2SD = + parallel(s 8 )

AWR Performance Report and Read by Other Session Waits

For the questions regarding "read by other session" and its relation to "db file sequential/scattered read",
the logic is like this:


When a "db file sequential/scattered read" is done, the blocks are either already in the cache or on the disk.  Since any operation on blocks is done in the cache and since and the issue is "read by other session" I will relate to the case the blocks are on the disk.

Process A is reading the needed block from the disk to the cache.  During that time, if process B (and C and others) need the same block, it will wait on "read by other session".  A and B can be threads of the same process running in parallel or unrelated processes.  For example two processes doing full table scan on mdp_matrix etc.

Solutions for that can be lowering the number of processes competing on the same blocks, increasing PCTFREE.  If it is a full table scan, maybe an index is missing that can result in less blocks being read from the cache and so on.

About

This blog delivers the latest information regarding performance and install/upgrade. Comments welcome

Search

Archives
« September 2012 »
SunMonTueWedThuFriSat
      
1
2
3
4
5
7
8
9
10
11
12
13
15
16
17
18
20
21
22
23
25
26
27
28
29
30
      
Today