|
Action#
|
Action
|
Resource
|
|
1
|
Perform whole database backup
|
DBA
|
|
2
|
Analyze tables for database fragmentation and row
chaining
|
DBA
|
|
3
|
Analyze indexes for fragmentation and validity
|
DBA
|
|
4
|
Move Tables
|
DBA
|
|
5
|
Rebuild indexes
|
DBA
|
|
6
|
Analyze procedures, triggers, functions and
packages for validity
|
DBA
|
|
7
|
Compile all invalid procedures, triggers,
functions and packages
|
DBA
|
|
8
|
Find Top 20 SQL statements
|
DBA
|
|
9
|
Tune Top 20 SQL statements
|
DBA
|
|
10
|
Pin commonly used packages in memory
|
DBA
|
|
11
|
Take database performance snapshot using
STATSPACK
|
DBA
|
|
12
|
Calculate Cache Hit / Miss Ratio
|
DBA
|
|
13
|
Fix
Low Cache Hit Ratio
|
DBA
|
|
14
|
Calculate Library Cache Hit Ratio
|
DBA
|
|
15
|
Fix Low Library Cache Hit Ratio
|
DBA
|
|
16
|
Configure balanced Shared Global Area for better
performance as per recommendation
|
DBA
|
|
17
|
Turn on Database Advisors for future advisory
information
|
DBA
|
|
18
|
Find and Analyze database wait events
|
DBA
|
|
19
|
Find and Fix CPU busy rate
|
DBA
|
|
20
|
Configure Users Data Sort Areas
|
DBA
|
|
21
|
Enable Database Lock Monitoring
|
DBA
|
|
22
|
Enable Performance Statistics gathering
|
DBA
|
|
23
|
Generate Database Performance and Configuration
Report
|
DBA
|
|
24
|
Configure Proactive Tuning Parameters
|
DBA
|
|
25
|
Analyze User Privileges
|
DBA
|
|
26
|
Grant only the required privileges
|
DBA
|
|
27
|
Perform complete database backup
|
DBA
|
Tuesday, May 22, 2012
Database Tuning Activity Tasks
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment