jining-han.blogspot.com

oracle-performance.blogspot.com

Oracle Performance: How many DBWR processes?

http://oracle-performance.blogspot.com/2007/11/how-many-dbwr-processes.html

This site contains Oracle performance tips. Thursday, November 15, 2007. How many DBWR processes? Http:/ download.oracle.com/docs/cd/B19306 01/server.102/b14211/instance tune.htm#sthref1000. How many DBWR processes?

oracle-performance.blogspot.com

Oracle Performance: April 2006

http://oracle-performance.blogspot.com/2006_04_01_archive.html

This site contains Oracle performance tips. Friday, April 07, 2006. 8i and earlier: don't do it! 9i: optional. Supported in 9.2, and recommended if optimizer dynamic sampling is 2 or more at the instance level. 10g: since it's CBO only, should do. Subscribe to: Posts (Atom).

oracle-performance.blogspot.com

Oracle Performance: January 2006

http://oracle-performance.blogspot.com/2006_01_01_archive.html

This site contains Oracle performance tips. Tuesday, January 31, 2006. Who is fragmenting Shared Pool? Understanding and Tuning the Shared Pool. To determine what large PL/SQL objects are currently loaded in the shared pool. And are not marked 'kept' and therefore may cause a problem, execute the. Select name, sharable mem. From v$db object cache. Where sharable mem 10000. And (type = 'PACKAGE' or type = 'PACKAGE BODY' or type = 'FUNCTION'. Or type = 'PROCEDURE'). And kept = 'NO';. SQL Not using variables.

oracle-performance.blogspot.com

Oracle Performance: November 2007

http://oracle-performance.blogspot.com/2007_11_01_archive.html

This site contains Oracle performance tips. Thursday, November 15, 2007. How many DBWR processes? Http:/ download.oracle.com/docs/cd/B19306 01/server.102/b14211/instance tune.htm#sthref1000. Subscribe to: Posts (Atom). How many DBWR processes?

oracle-performance.blogspot.com

Oracle Performance: Multi-blocksizes in a database

http://oracle-performance.blogspot.com/2006/01/multi-blocksizes-in-database.html

This site contains Oracle performance tips. Saturday, January 28, 2006. Multi-blocksizes in a database. Here's how to create a 32K blocksize tablespace. Often this is benefitial because. Large index blocksizes reduce I/O. Allocate a 32k cache buffer - Start by creating a region of RAM for a 32k data cache. Alter system set db 32k cache size = 100m;. Create tablespace index ts 32k blocksize 23k;. Who is fragmenting Shared Pool? Multi-blocksizes in a database.

oracle-performance.blogspot.com

Oracle Performance: Stats on SYS/SYSTEM?

http://oracle-performance.blogspot.com/2006/04/stats-on-syssystem.html

This site contains Oracle performance tips. Friday, April 07, 2006. 8i and earlier: don't do it! 9i: optional. Supported in 9.2, and recommended if optimizer dynamic sampling is 2 or more at the instance level. 10g: since it's CBO only, should do.

oracle-performance.blogspot.com

Oracle Performance: December 2005

http://oracle-performance.blogspot.com/2005_12_01_archive.html

This site contains Oracle performance tips. Wednesday, December 21, 2005. How to check db cache advice. COLUMN size for estimate FORMAT 999,999,999,999 heading 'Cache Size (MB)'. COLUMN buffers for estimate FORMAT 999,999,999 heading 'Buffers'. COLUMN estd physical read factor FORMAT 999.90 heading 'Estd Phys Read Factor'. COLUMN estd physical reads FORMAT 999,999,999 heading 'Estd Phys Reads'. SELECT size for estimate,. Buffers for estimate,. Estd physical read factor,. Estd physical reads FROM. Is appl...

oracle-performance.blogspot.com

Oracle Performance: What do these hints do?

http://oracle-performance.blogspot.com/2005/12/what-do-these-hints-do.html

This site contains Oracle performance tips. Saturday, December 17, 2005. What do these hints do? SQL Statement Hints - A Summary See Note 35934.1 for CBO issues. Hints always force the use of the cost based optimizer (Except RULE). Use ALIASES for the tablenames in the hints. Ensure tables are analyzed. Syntax: /* HINT HINT . */ (In PLSQL the space between the ' ' and. The first letter of the hint is vital. So /* ALL ROWS */ is fine. But /* ALL ROWS */ will cause problems. RULE Force Rule if possible.

oracle-performance.blogspot.com

Oracle Performance: December 2007

http://oracle-performance.blogspot.com/2007_12_01_archive.html

This site contains Oracle performance tips. Monday, December 03, 2007. Automatic Work Load Management and High Availability. Http:/ www.orafaq.com/node/1434. Submitted by sriram717 on Wed, 2007-02-21 09:25. RDBMS Server. Automatic Work Load Management. Application workloads can be defined as services so that they can be individually managed and controlled. We can control and monitor which processing resources are allocated to each service during both normal operations and in response to failures. Middle ...