HelloDBA [中文]
Searcg Internet Search HelloDBA
Home Tech Doc Training Cases Tools Favorite
  Oracle Technology Site. email: fuyuncat@gmail.com  MSN: fuyuncat@hotmail.com Add to circle
New ArticlesWelcome
Oracle 11g Direct IO Auto Tune...(2012-01-04) [Doc]
Test Around Small Table Threshold...(2011-12-29) [Doc]
Oracle Sorting Algorithm...(2011-11-16) [Doc]
Approximate NDV based on hash algorithm in Oracle 11g...(2011-09-15) [Doc]
Distinct Aggregate Transformation...(2011-08-31) [Doc]
FyDB becomes an open source project...(2011-08-09) [Tool]
NULL or NOT NULL --- NOT NULL constraint impacts on execution plan and performance...(2011-07-21) [Doc]
FyDB --- a distributed in-memory no-SQL DB...(2011-07-11) [Doc]
Current Mode and Consistent Gets (2)...(2011-05-03) [Doc]
Current Mode and Consistent Gets...(2011-05-03) [Doc]
Hot ArticlesWelcome
CBO Cost estimation... [Doc]
Unwrap 10, 11G wrapped PLSQL... [Tool]
An Oracle Call Tracer For Windows(32)... [Tool]
Full Table Scan cost formula cracking(1)... [Doc]
Oracle Memory Management analysis(1)... [Doc]
Oracle IO analysis(1)... [Doc]
"Tips of Oracle ROWNUM" PDF download... [Tool]
Build "High" index in 10g... [Doc]
B*Tree Index block split --- Storage Parameters... [Doc]
Secret of oracle logic IO: Full Table Scan: Part 1... [Doc]
Links
acoug Oracle
AskTom Microsoft
CSDN Oracle OTN
more...
About
Declaration

Self Introduction

Logo:
HelloDBA Logo
 
 
 Hello DBA

    We share orignial technology articles, tools and cases about Oracle. Everybody can download, link, refer and utilize any resource in this site if you promise to highligh author and source. We do not primise to provide tech support for the tools downloaded from this size.
 
 

c d e

 Oracle 11g Direct IO Auto Tune

 by fuyuncat

Generally, Direct IO faster than Read into Cache because it does not require to allocate memory. In 11g, Oracle intruduced a new feature --- Direct IO Auto Tuning --- to improve performance of reading/writing large size objects. It will determine whether to read data blocks directly from disk bypassing buffer cache or not, basing on the size of object and size of buffer cache.
[Full]



  Execution plan problem caused by unbalanced partition and bind variable peeking

 by fuyuncat

    A case: Execution plan problem caused by unbalanced partition and bind variable peeking
[Full]

 

 FyDB becomes an open source project

 by fuyuncat

FyDB opens source, now. If you want to join this project, please contact me by: fuyuncat@gmail.com
[Full]

 

Top

Copyright @ 2005 HelloDBA.Com All reseverd.

粤ICP备06083407号

申明
by fuyuncat