Performace Tuning (DB/EBS)

perf


My Posts    Tuning (WIP)-Private


Oracle SQL Plan Changed?
Configuring Oracle SGA/PGA ?

( Still Writing Notes for below..)
What is Table Fragmentation in Oracle ? ( Finding & Removing)
What is Oracle Partitioning – ( Why ?,How ? &Benefits)
OS Watcher-OSWbb/RDA-Remote Diagnostics Agent/ORAchk – Health Checks
Locks vs Latch/Enqueues & Its Types 


Database Performance ( Article Collection)


Oracle Statistics (All About)>An Excellent Article about end to end to Statistics for DB/SCHEAMA/object level
DBMS_ADVISOR–>Details of How to execute SQL access advisor (DBMS_ADVISOR)?
DB Performance Toolkit –> Overview of Performance tools (AWR/ADDM/ASH,SQLT & SQLHC) & What data you need to collect for Performance Issues for Oracle SR?
Performace Tuning DB level->Collection of articles related to DB Time,Hints ,Execution plans,Shared pool,WAIT EVENTS,Latch Issues & Sql Trace & Autotrace

================ Newly Added on 01-JAN-2019=================== (Gavin Soorma(Oracle ACE) Articles)

Oracle Wait Events Causes And Resolutions->Just going through
Why Do My Execution Plans Not Change After Gathering Statistics?->Just going through
Performance Tuning Tips And Techniques->Just going through
ASH And AWR Performance Tuning Scripts->Just going through
Using The Awr History Tables To Compare Performance – Part 1->Just going through
Using The Awr History Tables To Compare Performance – Part 2>->Just going through
LOB’S – SOME PERFORMANCE TUNING CONSIDERATIONS>->Just going through
DBMS_ADVANCED_REWRITE – TUNING WITHOUT TOUCHING THE CODE>->Just going through


EBS Performance ( Article Collection)


Gathering EBS Database Statistics
Recommended Database Parameters for EBS
Approach to Performance Tuning Oracle Apps
Webcast:EBS performance tuning
Troubleshooting Performance Issues??
Debugging ??
Database Partitioning-EBS
Tuning the EBS Database Layer
Tuning All Layers of EBS
Queries for Troubleshooting Adv Typologies
Pinning Objects to Improve Apps Performance
SR Data for Perf Issue

#tuning

1 thought on “Performace Tuning (DB/EBS)

  1. Srinivasu Nalla Post author

    Added Some of Articles from Gavin Soorma Blog-https://gavinsoorma.com/category/performance-tuning/

    Oracle Wait Events Causes And Resolutions
    Why Do My Execution Plans Not Change After Gathering Statistics?
    Performance Tuning Tips And Techniques
    ASH And AWR Performance Tuning Scripts
    Using The Awr History Tables To Compare Performance – Part 1
    Using The Awr History Tables To Compare Performance – Part 2
    LOB’S – SOME PERFORMANCE TUNING CONSIDERATIONS
    DBMS_ADVANCED_REWRITE – TUNING WITHOUT TOUCHING THE CODE

    Like

    Reply

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s