Oracle Database 11g Release 2: Performance Tuning Tips and Techniques (Richard Niemiec)

I've been asked by the publishers to review "Oracle Database 11g Release 2: Performance Tuning Tips and Techniques" by Richard Niemiec of TUSC. Conclusion: it is good but not perfect. This is an extended version of the review I put up on Amazon.

vamsi kasina's picture

R12 - XLA / FAH - Business Events in Create Accounting


The following business events are disabled as default by Oracle.
For any custom process those can be enabled by users. But only extract and postprocessing events will be called in document mode.
Custom code / package can be used as a subscription to the respective business event.

oracle.apps.xla.accounting.preaccounting  - To identify the events, which will be processed by create accounting
oracle.apps.xla.accounting.extract        - To populate the transaction objects only for the events in xla_events_gt

FIne Grained Dependencies in Oracle 11g

Dependency Oracle schema is the place where all the Database objects get stored. This make a room for the entire set of objects under the Category of Data Storage ( Tables, Views) and Data Access (Stored Procedure ,Functions ,Packages and Triggers) .These Objects make a reference across all these objects to form the application.This is known as dependency.

Impact on Packages - Assign permissions directly vs Assign permission via Roles


Document depicts how Roles and Privileges behave for Packages

DB Version:

Users: TESTUSR (Table Owner)
TESTUSR_PKG (Package Onwer)
TESTUSR_APP (Application Owner)


Package: TEST_PKG

Table Text:
create table test_tbl(a number);

Announcing my upcoming Book on Advanced Oracle PL/SQL Concepts (1Z0-146 Preparation handbook)



It gives me great pleasure and honour to announce my upcoming book Oracle Advanced PL/SQL Developer Professional Guide with Pact Publishers. The book 'Oracle Advanced PL/SQL Developer Professional Guide' is focussed on the preparation of OCP (1Z0-146) examination. The book doesn't restricts its scope to the examination but aims to strengthen the advanced concepts in Oracle 11g PL/SQL.

Basics of Partition Tables in Oracle

Basics of Partition Tables

Please use ANSI join syntax


The old Oracle join syntax really should be consigned to history.

vamsi kasina's picture

R12 - XLA / FAH - Useful Notes / GDFs / Patches


Miultiple Entities GDF 9651687
In SLA Not In GL GDF 9481239

FAQ for SLA Upgrade 604893.1
SLA Obsolete Profiles 553229.1
FAQ - FSAH / FAH 729545.1
XLA Setup Diagnostics Test 942252.1

vamsi kasina's picture

R12 - XLA / FAH - After running Validate AAD program, why the XLA dynamic package becomes invalid?


Subledger Accounting / Financials Accounting Hub uses dynamic package to generate the journal entries.
Depending on the rules (AMB Setup and Event Model) the dynamic package will be created, when the Validate Application Accounting Definition program has been run.
The package will be generated with the naming convension XLA_{5DIGIT_APPL_ID}_AAD_{SEED_CUSTOM}_{6DIGIT_AAD_HASH}_PKG.
AAD_HASH value will be found in xla_product_rules_b.product_rule_hash_id.

   SELECT 'XLA_' || lpad(application_id,5,'0') || '_AAD_' || 
          product_rule_type_code || '_' || lpad(product_rule_hash_id,6,'0') || '_PKG'
   FROM xla_product_rules_b
   WHERE application_id = &p_appl_id
   AND amb_context_code = NVL('&amb_context_code','DEFAULT')
   AND product_rule_code = '&aad_code';
Examples for dynamic pakcages:


Subscribe to RSS - blogs