HelloDBA [中文]
Search Internet Search HelloDBA
  Oracle Technology Site. email: fuyuncat@gmail.com  MSN: fuyuncat@hotmail.com Add to circle  acoug  acoug 

 

        Introduce a SQL tuning tool

 

When we tune a SQL, we need to spend a lot of time to analyze the SQL, find out the performance bottleneck first, then utilize the tuning rules or our own experience to take action to tune the SQL. SQL Tuning is complex task. The junior developers or DBAs may even don't know from where to start when they are facing a poor performance SQL. It's also a time-consuming task for those experienced DBA. I ever tuned a ton of SQLs, and I always hope I can get a SQL Tuning tool to help me find out the top SQL quickly, then analyzes the SQL automatically, and eventually gives me tuning suggestions. This will definitely take off those time-consuming steps from me, helps me to tune the SQL efficiently, and gives me more time to do other works. Yes, SQLBooster is what I am looking for!
[Read]

 

 

New Articles

 

 

  • Introduce a SQL tuning tool
  • 12.1.0.2 bug ORA-00600: internal error code, arguments: [rwoirw: check ret val]
  • Security View Merge in 12c --- Bug or Improvment
  • 12.1.0.2Bug --- SQL_FULLTEXT in v$sql become messy when the length of raw SQL text larger than 131072
  • Oracle 12.2 SQL Parsing bug
  • Oracle 12c new SQL Hints
  • Flashback Snapshot of Schema
  • Consistent Gets may not tell the truth
  • Oracle 12c Hybrid Histogram
  • Oracle 12c TOP-N Frequency Histogram
  • Rescue data in the worst situation (2)
  • Rescue data in the worst situation (1)
  • Understand Buffer Cache in further --- Build up queryable Buffer Cache Chain data
  • Oracle SQL Hints --- Contents
  • Oracle SQL Hints --- Other Hints
  • Oracle SQL Hints --- Model Query And Partition Hints
  • Oracle SQL Hints --- Distributed Query And Parallel Query Hints
  • Oracle SQL Hints --- Hierarchy Query And XML Query Hints
  • Oracle SQL Hints --- Run Time And Data Maniplulation Hints
  • Oracle SQL Hints --- Statistics Data And Optimizer Hints
  • Oracle SQL Hints --- Quert Transformation Hints
  • Oracle SQL Hints --- Outline Data Hints
  • Oracle SQL Hints --- Join Hints
  • Oracle SQL Hints --- Access Path Hints
  • Oracle SQL Hints --- Abstraction
  • Coming Soon ...
  • Recover Truncated Data utilizing PLSQL
  • Oracle 11g Direct IO Auto Tune
  • Test Around Small Table Threshold
  • Oracle Sorting Algorithm
  • Approximate NDV based on hash algorithm in Oracle 11g
  • Distinct Aggregate Transformation
  • NULL or NOT NULL --- NOT NULL constraint impacts on execution plan and performance
  • Current Mode and Consistent Gets (2)
  • Current Mode and Consistent Gets
  • Select For Update and performance
  • Look Oracle from inside (tracing internal calls) --- Latches
  • Look Oracle from inside (tracing internal calls) --- Lock (Enqueue)
  • Look Oracle from inside (tracing internal calls) --- Logical IOs
  • Look Oracle from inside (tracing internal calls) --- Execution Plan
  • Query Execution Call Stack Trace
  • Execution Plan process analysis
  • SQL Rolling Invalidation
  • Bloom Filter
  • All about oracle sorting
  • TIPS: Build OUTLINE agilely
  • Adjusted MBRC formual in CBO
  • CBO Cost estimation
  • NULL IS NOT NULL in execution plan
  • CBO Statistics data gathering and internal arithmetic analysis -- Sampling
  • CBO Statistics data gathering and internal arithmetic analysis -- Calculating NDV and Density
  • CBO Statistics data gathering and internal arithmetic analysis -- Converting to endpoint value
  • CBO Statistics data gathering and internal arithmetic analysis -- Frequency or Height Balanaced?
  • CBO Statistics data gathering and internal arithmetic analysis -- when will gather histogram data
  • TIPS: How to get physical size of objects
  • [En] Oracle Row Shipping
  • Oracle Redo Strand
  • HowTo: Trace the statistics data gathtering
  • Oracle In Memory Undo
  • Secret of oracle logical IO: Index Scan
  • Secret of oracle logic IO: Sorting
  • Secret of oracle logic IO: Current Mode
  • Secret of oracle logic IO: Consistent Gets
  • Secret of oracle logic IO: Full Table Scan: Part 3
  • Secret of oracle logic IO: Full Table Scan: Part 2
  • Secret of oracle logic IO: Full Table Scan: Part 1
  • Transaction Enqueue analysis --- Other Contentions
  • Transaction Enqueue analysis --- Foreign Key
  • Transaction Enqueue analysis --- Bitmap Index Mantanence
  • Transaction Enqueue analysis --- Unique Constraint
  • Transaction Enqueue analysis --- Index Contention
  • Transaction Enqueue analysis --- ITL Contention
  • B*Tree Index block split --- Wait Events
  • B*Tree Index block split --- Block Allocation
  • B*Tree Index block split --- Split Transaction
  • B*Tree Index block split --- Storage Parameters
  • B*Tree Index block split --- Tree Growth
  • B*Tree Index block split --- How to split
  • Build "High" index in 10g
  • Q&A: Why there is not value peeked in 10053 trace file.
  • Transaction Enqueue analysis --- Row Lock
  • 11g new feature --- more flexible partition strategy
  • Row Movement impact
  • Q&A: Relationship between Table and Segment
  • 11g new feature --- Index Invisible
  • TIPS: ROWID Convertion
  • TIPS: Get lock wait in RAC
  • Full Table Scan cost formula cracking(1)
  • Full Table Scan cost formula cracking(2)
  • Full Table Scan cost formula cracking(3)
  • Full Table Scan cost formula cracking(4)
  • Full Table Scan cost formula cracking(5)
  • Full Table Scan cost formula cracking(6)
  • Q&A --- Multiple Buffer Cache
  • Consistent Reads And Buffer Cache
  • Performance trap of ROWNUM
  • analysis parallel process via Parallel Trace
  • Parallel your SQL --- Huge data update performance tuning
  • Oracle IO analysis(1)
  • Oracle IO analysis(2)
  • Oracle IO analysis(3)
  • Oracle IO analysis(4)
  • Oracle IO analysis(5)
  • Oracle IO analysis(6)
  • Oracle IO analysis(7)
  • Oracle IO analysis(8)
  • Oracle IO analysis(9)
  • Oracle IO analysis(10)
  • New hint in Oracle 10gR2 --- opt_param
  • Oracle SCN explanation
  • Tips of Oracle ROWNUM
  • Merge Join Cartesian in Execution Plan
  • How to capture the long operations
  • How to monitor the index usage
  • Capture top SQLs and their execution plans using statspack
  • Oracle bug --- zero date
  • Oracle 11g New features
  • Oracle Memory Management analysis(1)
  • Oracle Memory Management analysis(2)
  • Oracle Memory Management analysis(3)
  • Oracle Memory Management analysis(4)
  • Oracle Memory Management analysis(51)
  • Oracle Memory Management analysis(6)
  • Oracle Memory Management analysis(7)
  • Oracle Memory Management analysis(8)
  • Oracle Memory Management analysis(9)
  • Oracle Memory Management analysis(10)
  • Oracle Memory Management analysis(11)
  • Oracle Memory Management analysis(12)
  • When will bind variable peeking draw back performance?
  • How to calculate Cardinality in execution plan
  • Transaction Lock
  • Build personal desktop search engine utilizing Ultra Search
  • Install and configure ultra search
  • Dual table tuning
  • Testing cases and analys about operations on data block in transaction(1)
  • Testing cases and analys about operations on data block in transaction(2)
  • Testing cases and analys about operations on data block in transaction(3)
  • Study Oracle temporary table cache
  • Oracle streams replication between Oracle and SQL Server(1)
  • Oracle streams replication between Oracle and SQL Server(2)
  • Build logic stand by database
  • Create a trigger to monitor table
  • Configure load balance and failover in RAC
  • Oracle Hints(1)
  • Oracle Hints(2)
  • Oracle Hints(3)
  • Oracle Hints(4)
  • Oracle Hints(5)
  • Oracle Hash Join
  • Comparation of Normal Table Temporary Table and Table function
  • Rewrite SQL
  • Oracle 10g New feature --- Regular Expression
  • Oracle 10g New feature --- Code Wrap
  • Oracle 10g New feature --- Chooseful Compile
  • Oracle 10G New feature --- ADDM and SQL Tuning Advisor
  • Oracle 10G New feature --- Materialized View
  • Oracle 10G New feature --- Tablespace Management
  • Oracle 10G New feature --- Flashback
  • Oracle 10G New feature --- Connect By clause enhancement
  • Oracle 10G New feature --- RMAN
  • Oracle 10G New feature --- SQL*Plus
  • Oracle 10G New feature --- AWR
  • Oracle 10G New feature --- Audit
  • Oracle 10G New feature --- Waits
  • Oracle10g ADDM Guideline(1)
  • Oracle10g ADDM Guideline(2)
  • Oracle10g ADDM Guideline(3)
  • Tune SQL via Oracle 10g SQL Tuning Assistant (STA) (1)
  • Tune SQL via Oracle 10g SQL Tuning Assistant (STA) (2)
  • Tune SQL via Oracle 10g SQL Tuning Advisor (STA) (3)
  • Skip Scan Index
  • Configure Rotating in hacmp5.2
  • Oracle XML DB
  • How to identify lock type
  • ORA-01555 analysis(1)
  • ORA-01555 analysis(2)
  • ORA-01555 analysis(3)
  • Data Segment Compression
  •  


     

    Top

    Copyright ©2005, HelloDBA.Com All reseverd.

    Declaration
    by fuyuncat