Demantra Scalability New Features 7.3.0.1

There are many new features in Demantra 7.3.0.1.  We will introduce EP_LOAD new parallel features.

Performance and Scalability: Usage of Database (SQL) Hints, Parallelism and Other Methods
- New system parameters were added to grant users more advanced controls of how Demantra executes specific processes. This will enable implementations to be tuned based on each implementations unique characteristic.  This process relies almost entirely on the expertise of the persons participating, and may, if done incorrectly, cause system issues.  Parameters were added to the DB_PARAMS table to allow for the activation and deactivation of certain low level processes.  For example, the number of commit statements issued during the run of a stored procedure can have adverse affects on performance due to logging and other issues, it could be that reducing the number of commits will provide the performance gain required.

  All 57 parameters, some noted below, were added to and are controlled by setting them in DB_PARAMS table.

  Review the parameters in the Demantra Platform and Solutions Release 7.3.0 Technical Transfer of Information (TOI)
  <document 879014.1>

  * Parameters used with the EP_LOAD_ITEMS procedure.

    Parameter: Ep_Load_ItemsUseParallelDML
    Default value: FALSE

    Description: Two possible values:

    TRUE = use PARALLEL DML on objects that are set as parallel.
    FALSE = do not use PARALLEL DML on objects that are set as parallel.
    Parameter: Ep_Load_ItemsUseParallel
    Default value: TRUE

    Description: Two possible values:

    TRUE = EP_LOAD_ITEMS use parallel hints
    FALSE = EP_LOAD_ITEMS does not use parallel hints
    Parameter: Ep_Load_ItemsUseOneCommit
    Default value: FALSE

    Description: Two possible values:

    TRUE = EP_LOAD_ITEMS use only one commit
    FALSE = EP_LOAD_ITEMS does not use only one commit

Comments:

Post a Comment:
  • HTML Syntax: NOT allowed
About

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

Search

Archives
« April 2014
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