Arquivo da categoria: BUFFERS

FREELISTS and FREELIST GROUPS

FREELISTS and FREELIST GROUPS ============================= The following bulletin is comprised of several parts: 1. Introduction to Oracle data block organization 2. Free List Overview 3. Free List Types 4. Considerations for Optimizing Space Management 5. Algorithms 6. FreeLists in Oracle … Continuar lendo

Publicado em BUFFERS, FREELISTS, PLSQL SCRIPTS, PLSQL TUNING, SGA | Marcado com , , | Deixe um comentário

Pre-Loading Oracle Text indexes into Memory

Pre-Loading Oracle Text indexes into Memory Introduction Oracle Text indexes are stored in Oracle Database relational tables. These tables normally reside on disk. Systems with large memory configurations generally benefit greatly from Oracle caching – a second or subsequent search … Continuar lendo

Publicado em BUFFERS, INDEX TUNING, PLSQL SCRIPTS, PLSQL TUNING, SGA | Marcado com | Deixe um comentário

Database Performance FAQ

Database Performance FAQ INVESTIGATING A DATABASE PERFORMANCE ISSUE DIAGNOSTICS AWR reports/Statspack reports 10046 Trace Querying V$Session_wait System State Dumps Errorstack PSTACK PLSQL Profiler Hanganalyze INTERPRETING THE RESULTS/TRACES TOP DATABASE PERFORMANCE ISSUES/PROBLEMS AND HOW TO RESOLVE THEM Library Cache/Shared Pool Latch … Continuar lendo

Publicado em AWR, BUFFERS, FAST DIAG, PLSQL SCRIPTS, TRACE | Marcado com | Deixe um comentário

Problemas comuns de performance

TROUBLESHOOTING GUIDE Common Performance Tuning Issues Table of Contents 1. Introduction 2. Shared Pool and Library Cache Performance Tuning 3. Buffer Cache Performance Tuning 4. Latch Contention 5. Redo Log Buffer Performance Tuning 6. Rollback Segment Performance Tuning 7. Temporary … Continuar lendo

Publicado em BUFFERS, PLSQL SCRIPTS, PLSQL TUNING, RECOMENDAÇÕES, SGA | Marcado com | Deixe um comentário

Understanding and Tuning the Shared Pool

Understanding and Tuning the Shared Pool 1.            Introduction The aim of this article is to introduce the key issues involved in tuning the shared pool in Oracle 7 through 9. The notes here are particularly important if your system shows … Continuar lendo

Publicado em BUFFERS, PLSQL SCRIPTS, SGA | Deixe um comentário

PINNING ORACLE APPLICATIONS OBJECTS INTO THE SHARED POOL

Pinning Oracle Applications Objects into the shared pool Scope: Oracle Applications DBAs who want to improve database performance by pinning packages into shared pool. Why pinning objects into the shared pool? Oracle Applications requires space in the ORACLE System Global … Continuar lendo

Publicado em BUFFERS, ORACLE EBS, PLSQL SCRIPTS, PLSQL TUNING, SGA | Deixe um comentário

How to measure the performance of 1.processes, 2.open_cursors 3.java_pool_size 4.large_pool_size

How to measure the performance of the following parameters. 1.processes, 2.open_cursors 3.java_pool_size 4.large_pool_size is there any quries to measure the performance of the parameters like cache hit ratio for db_cache_size parameter. How to know whether i have to increase the … Continuar lendo

Publicado em BUFFERS, PARAMETROS, PLSQL TUNING, SGA | Marcado com , | Deixe um comentário

ow to Automate Pinning Objects in Shared Pool at Database Startup

How to Automate Pinning Objects in the Shared Pool at Database Startup: ======================================================================= ******************************************************** 1/ Create the procedures to be executed by the triggers ******************************************************** a. Create a table to store the names of packages and procedures that had to … Continuar lendo

Publicado em BUFFERS, PLSQL TUNING, SGA | Deixe um comentário

ESTIMATE SHARED POOL UTILIZATION

Estimate Shared Pool Utilization Disclaimer: This script is provided for educational purposes only. It is NOT supported by Oracle World Wide Technical Support. The script has been tested and appears to work as intended. However, you should always test any … Continuar lendo

Publicado em BUFFERS, PLSQL TUNING, SGA | Deixe um comentário

How to Pin SQL Statements in Memory Using DBMS_SHARED_POOL

How to Pin SQL Statements in Memory Using DBMS_SHARED_POOL: =========================================================== Do the following: 1. Issue a SQL statement. For example: SQL>select * from scott.emp; 2. Get the SQL address from V$SQLAREA. SQL> select address, hash_value, sql_text from v$sqlarea where sql_text … Continuar lendo

Publicado em BUFFERS, PLSQL TUNING, SGA, SHARED POOL | Marcado com , , | Deixe um comentário

How to Identify The Segment Associated with Buffer Busy Waits

This note shows how to determine which segment is associated with buffer busy waits found in an AWR / statspack report, or 10046 trace. It is very important to know which segments are affected by buffer busy waits in order … Continuar lendo

Publicado em BUFFERS, WAIT EVENTS | Marcado com | Deixe um comentário

Toolkit for dynamic marking of Library Cache objects as Kept

Instructions Execution Environment: SQL*Plus, iSQL*Plus Access Privileges: Requires SYS Usage: sqlplus “/as sysdba” @PIND_install.sql Instructions: – copy&paste bellow appended script into file and run – make sure startup/shutdown triggers are (“_system_trig_enabled=TRUE” – enabled by default) – make sure the database … Continuar lendo

Publicado em BUFFERS, PLSQL TUNING | Marcado com | Deixe um comentário

RESOLVING INTENSE AND “RANDOM” BUFFER BUSY WAIT PERFORMANCE PROBLEMS

RESOLVING INTENSE AND “RANDOM” BUFFER BUSY WAIT PERFORMANCE PROBLEMS ——————————————————————– This document is composed of two sections; a summary section that broadly discusses the problem and its resolution, and a detailed diagnostics section that shows how to collect and analyze … Continuar lendo

Publicado em BUFFERS, WAIT EVENTS | Marcado com , , , | Deixe um comentário

BUFFER_POOL_KEEP

Reference Note for Init.Ora Parameter “BUFFER_POOL_KEEP”. The information here contains a parameter description from the Oracle9i documentation along with any additional support comments related to this parameter. If the parameter usage is different in Oracle9i to in earlier releases then … Continuar lendo

Publicado em BUFFERS | Marcado com | Deixe um comentário

Can We Tune Row Cache!

PURPOSE ——- To determine what options we have to tune Row Cache in Oracle7 through Oracle9i SCOPE & APPLICATION ——————- This article is intended for Oracle Support Analysts, Oracle Consultants and Database Administrators What is Row Cache? —————— Row Cache … Continuar lendo

Publicado em BUFFERS, STATSPACK | Marcado com , | Deixe um comentário

Monitoring the average value of used buffers per objec

monitoring the average value of used buffers per object hi, i created a view displaying the buffer cache on a per userobject basis. i’m planning to monitor this view over time and build up a time based metric. if there … Continuar lendo

Publicado em BUFFERS, PLSQL TUNING | Deixe um comentário

Multiple BUFFER subcaches

Multiple BUFFER subcaches: What is the Total BUFFER CACHE Size? =============================================================== How do we know that different buffer caches are initialized? ———————————————————— 1. V$BUFFER_POOL is the view that displays the entire buffer cache structure: SQL> select id,name,block_size, current_size,buffers from v$buffer_pool; … Continuar lendo

Publicado em BUFFERS, PERFORMANCE, PLSQL SCRIPTS | Deixe um comentário

Oracle Buffer Busy Waits

Publicado em BUFFERS, VIDEOS, WAIT EVENTS | Marcado com , , | Deixe um comentário