|
-
Improving response. In order to do that, first you need to find where you have the response problem ? It could be
Memory contention - Look in to SGA components and are sufficient
Redolog contention - See the log size is sufficient
RBS contention - See the RBS sizing is ok
I/O contention - See Data and Index, SYSTEM, RBS tablespaces are distributed on different file systems.
Here Iam talking about DBA Perspective. BEfore looking into this have a look at the application queries(SQL) and get some statistics using explain plan/tkprof/statspack/utlbstat.sql and utlestat.sql.
Just ideas from where you can start diggin...
After analyzing the table using ANALYZE command select CHAIN_CNT column from DBA_TABLES view which gives number od chained/migrated rows.
Reddy,Sam
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|