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
No comments:
Post a Comment