December 6th, 2010
You are currently browsing the articles from Techno Oracle written on December 6th, 2010.
SGA_TARGET Specifies the total size of all SGA components. If SGA_TARGET is specified, then the buffer cache (DB_CACHE_SIZE), Java pool (JAVA_POOL_SIZE), large pool (LARGE_POOL_SIZE), and shared pool (SHARED_POOL_SIZE) memory pools are automatically sized.Before you increase the size of your SGA, you must understand the effects on the physical memory of your system. If you increase [...]
Written by admin on December 6th, 2010 with comments disabled.
Read more articles on Oracle Tuning.
The init.ora file in oracle database determines Oracle operating system environment attributes, such as memory allocated for statements, memory allocated for data,and other crucial performance-related parameters. In Oracle 10g there are now 1381 different initialization parameters .We will focuses on the key parameters that affect database performance. The key to an optimized Oracle database is [...]
Written by admin on December 6th, 2010 with comments disabled.
Read more articles on Oracle Tuning.
When creating tables and indexes, note the following: 1. Specify automatic segment-space management for tablespaces This allows Oracle to automatically manage segment space for best performance. 2.Set storage options carefully Applications should carefully set storage options for the intended use of the table or index. This includes setting the value for PCTFREE. Note that using [...]
Written by admin on December 6th, 2010 with comments disabled.
Read more articles on Oracle Tuning.