Wednesday, 12 June 2013

Oracle 10g New Features



ORACLEm
DATABASE


Objective Expose you to some of the database features available in 10g and compare them to the lengthy workarounds that were used in previous Oracle versions.


10g provides better ways to administer your database.
Very Nice features for DBA’s


Oracle 9i = More effort and Less Enjoy
Oracle 10g = Less effort and More Enjoy


Automatic Shared Memory Management (ASMM)
Data Pump
SQL Tuning Advisor
Flashback Database
RMAN - Backupset Compression
Good Features


Automatic Shared Memory
Management (ASMM)
8i method for automating SGA management
There is no method.
Workaround
You have to shutdown the database and manually change the values. This could be done programmatically with multiple init<SID>.ora files. Each file containing different values for the SGA parameters and automated via shell and Cron/Autosys.


Automatic Shared Memory
Management (ASMM)
9i method for automating SGA management.
Still not doable, however, you can dynamically change many of the values without shutting down the database.
Workaround
You have to use the alter system/session commands and also
rely on the v$shared_pool_advice and db_cache_advice views for proper settings. Manual / programmatic effort is required if the behavior of your database changes and SGA changes are needed. Cron and Autosys to automate.


Automatic Shared Memory
Management (ASMM)
10g method for automating SGA management.
alter system set sga_target=‘xyz’;


Automatic Shared Memory
Management (ASMM)
sga_target -- This parameter is new in Oracle Database 10g and reflects the total size of memory an SGA can consume.
Shared pool
Buffer cache
Java Pool
Large Pool


Online Users
Automatic Shared Memory Management (ASMM)
Buffer Cache
SQL Cache
SGA Pool
PGA Pool sort
Large Batch Buffer Cache
Jobs
Java Pool
Large Pool Large Pool
SQL Cache
Java Pool
sort
• Automatically adapts to workload changes
• Maximizes memory utilization
• Single Parameter makes it easier to use
• Helps eliminate out of memory errors

• Can help improve performance

Popular Posts