jump to navigation

Baixar 10g r2 Setembro 27, 2007

Posted by heliodias in Uncategorized.
add a comment

http://www.oracle.com/technology/software/products/database/oracle10g/htdocs/10201winsoft.html

Lista de blogs Setembro 25, 2007

Posted by heliodias in Uncategorized.
add a comment

http://www.orablogs.com/orablogs/

Analise HL Setembro 25, 2007

Posted by heliodias in Uncategorized.
add a comment

db file sequential read 15675073     23789635

db file scattered read 18204840      30829325

STARTUP_

——–

24/09/07

Data Guard Setembro 24, 2007

Posted by heliodias in Uncategorized.
add a comment

Oracle Data Guard Concepts and Administration

http://download.oracle.com/docs/cd/B19306_01/server.102/b14239/rac_support.htm#sthref2196

http://download.oracle.com/docs/cd/B19306_01/server.102/b14239/troubleshooting.htm#g643918

Localiza – Locacao de veiculos Setembro 22, 2007

Posted by heliodias in Uncategorized.
add a comment

http://www.localiza.com/reservas/reserva/Passo1.aspx?CodPais=0055

Escritorio virtual Setembro 22, 2007

Posted by heliodias in Uncategorized.
add a comment

http://www.espaco2d.com.br/planos.htm

Good notes from metalink Setembro 19, 2007

Posted by heliodias in Uncategorized.
add a comment
Recommended Method for Obtaining 10046 trace for Tuning
10g: BIGFILE Type Tablespaces Versus SMALLFILE Type
SCRIPT TO PROVIDE DATABASE PERFORMANCE HEALTHCHECK and RECOMMENDATIONS
SQL Parsing Flow Diagram
Tkprof Interpretation
QREF: TKPROF Usage – Quick Reference
Interpreting Raw SQL_TRACE and DBMS_SUPPORT.START_TRACE output
OPTIMIZING ORACLE7.1 DATABASE PERFORMANCE
How to Identify The Segment Associated with Buffer Busy Waits
Performance Improvement Tips for Oracle on UNIX
How to Identify Resource Intensive SQL for Tuning
Why do uncommitted transactions get written to the Redo Log?
Diagnosing excessive redo generation
Using Stored Outlines
Statistics Package (STATSPACK) Guide
Oracle Multiple Buffer Pools Feature
STATISTIC “cache hit ratio” – Reference Note
EVENT: 10046 “enable SQL statement tracing (including binds/waits)”
How to get a Trace for And Begin to Analyze a Performance Issue
How to Avoid Common Flaws and Errors Using Passwordfile
Recommended Method for Obtaining 10046 trace for Tuning
10g: BIGFILE Type Tablespaces Versus SMALLFILE Type
SCRIPT TO PROVIDE DATABASE PERFORMANCE HEALTHCHECK and RECOMMENDATIONS
SQL Parsing Flow Diagram
Tkprof Interpretation
QREF: TKPROF Usage – Quick Reference
Interpreting Raw SQL_TRACE and DBMS_SUPPORT.START_TRACE output
OPTIMIZING ORACLE7.1 DATABASE PERFORMANCE
How to Identify The Segment Associated with Buffer Busy Waits
Performance Improvement Tips for Oracle on UNIX
How to Identify Resource Intensive SQL for Tuning
Why do uncommitted transactions get written to the Redo Log?
Diagnosing excessive redo generation
Using Stored Outlines
Statistics Package (STATSPACK) Guide
Oracle Multiple Buffer Pools Feature
STATISTIC “cache hit ratio” – Reference Note
EVENT: 10046 “enable SQL statement tracing (including binds/waits)”
How to get a Trace for And Begin to Analyze a Performance Issue
How to Avoid Common Flaws and Errors Using Passwordfile

 

Automatic PGA Memory Managment in 9i and 10g
Database Scripts Library Index
How to Modify the statistics collection by MMON for AWR repository
V$BUFFER_POOL_STATISTICS COLUMN DEFINITIONS NOT IN DOCUMENTATION
Technical Overview: Oracle Text version 9.2.0
UNIX: How to Create An 8i Database Manually in the UNIX Environment
DBMS_REDEFINITION ONLINE REORGANIZATION OF TABLES
How to Re-Organize a Table Online
Check which database objects are candidates for the keep buffer cache
WIN: Checklist for Resolving CONNECT AS SYSDBA Issues
What is “v$bh”? How should it be used?
WIN: OS Authentication – CONNECT AS SYSDBA Without a Password
How to specify non-default location of password file
NT: Migrate to 7.2 or 7.3: ORA-1031, Insufficient Privileges
SYSDBA and SYSOPER Privileges in Oracle
Oracle9i New Feature: Flashback
Cost Based Optimizer (CBO) Overview
Handling Oracle Block Corruptions in Oracle7/8/8i/9i/10g
Tuning the Redolog Buffer Cache and Resolving Redo Latch Contention
How to restore the old data using flashback queries?
Introduction to Tuning Oracle7 / Oracle8 / 8i / 9i
Cost Based Optimizer – Common Misconceptions and Issues
Tracing sessions: waiting on an enqueue
What Is Worst Case If You Run Out Of Disk Space For Alertlog, Core Dump Or Tracefiles
SCRIPT TO PROVIDE DATABASE PERFORMANCE HEALTHCHECK
WAITEVENT: “db file sequential read” Reference Note
Troubleshooting Performance Issues Relating to the Database and Core/MFG MRP
Performance Tuning – Some Stats and Ratios
How to Log a Good Performance Service Request
Script: Tree Walking Examples
WAITEVENT: “enqueue” Reference Note
Tuning I/O-related waits
Database Performance FAQ
TX Transaction locks – Example wait scenarios
Checkpoint Tuning and Troubleshooting Guide
Gathering Data Dictionary Statistics
SCRIPT: FULLY DECODED LOCKING
Script: Display SQL text from Locked Transactions
The Performance Impact of Deadlock Detection
FAQ about Detecting and Resolving Locking Conflicts
Potential reasons for “WAITED TOO LONG FOR A ROW CACHE ENQUEUE LOCK! “
TROUBLESHOOTING GUIDE: Common Performance Tuning Issues
QREF: SQL Statement HINTS
Query Tuning Best Practices
START HERE> Diagnosing Query Tuning Problems
All about Bitmap Indexes
Explained: Star Query Processing in the Oracle Server
How To Determine The Amount of Space Used by an IOT
Interpreting Histogram Information
How to View High Water Mark – Step-by-Step Instructions
Differences Between Standard Edition and Enterprise Edition in 8i
System Statistics: Collect and Display System Statistics (CPU and IO) for CBO usage
[9.0.1.0] Generic Server README for Oracle9i
TROUBLESHOOTING: Tuning a New Query
Database Instance Tuning Knowledge Browser Product Page
Oracle9i: Recovering lost data through Flashback Query
How To Identify a Hot Block Within The Database Buffer Cache.
Case Study: The Case of the Stubborn Cost Based Optimizer
Trace Analyzer TRCANLZR – Interpreting Raw SQL Traces with Binds and/or Waits generated by EVENT 10046
CKE Database/Server

 

Overview of SQL Statement Processing Phases
FAQ- Statspack Complete Reference
How to Determine an Optimal SORT_AREA_SIZE
Security Alert 59 – Buffer Overflow in Oracle Binaries
Top 8 init.ora Parameters Affecting Performance
Best Practices for Avoiding and Detecting Corruption
Checklist for Resolving CONNECT AS SYSDBA (INTERNAL) Issues
DBVERIFY – Database file Verification Utility (7.3.2 – 10.2)
Query Tuning Overview
Interpreting Explain plan
TROUBLESHOOTING: Possible Causes of Poor SQL Performance
Database Architecture Knowledge Browser Product Page
Archiver Best Practices
Gathering Information for RDBMS Performance Tuning issue
Increasing Usable Address Space for Oracle on 32-bit Linux
HOW TO USE DBMS_ROWID PROCEDURE AND FUNCTIONS
What are the Export/Import parameters used when exporting/importing from the RAU

Statistics Descriptions Setembro 19, 2007

Posted by heliodias in Uncategorized.
add a comment

http://download-west.oracle.com/docs/cd/B19306_01/server.102/b14237/stats002.htm

Livros para comprar Setembro 19, 2007

Posted by heliodias in Uncategorized.
add a comment

http://www.rampant-books.com/book_2006_1_plsql_tune.htm

Verificar Setembro 19, 2007

Posted by heliodias in Uncategorized.
add a comment

http://blogs.oracle.com/