| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: SOS - the day after migrating to Oracle 9.2
First of all, thanks everyone for your comments.
To the vmware.
It's running on vmware ESX Server latest version and patches.
SLES 8.
Server consolidation is the reason the hardware &system guys are
starting to migrate most of the 120 servers in this direction.
So, we're not the first server, but the first major DB.
I'm trying to track the problems from both sides:
Outside -> IN ( vmware to oracle) and the other way round.
We did not have any problem to open a tar with oracle an receive a patch for a lgwr issue - so much for the support.
But I would like to get back to the original question - the posted statspack, for that's my part of the puzzle.
We did a lot of testing and tuning in advance because the data model slightly changed and some major tables where enhanced by some columns.
The top SQL hasn't changed, the top waits and latches besides the cpu and latch free (which went down by half today) are pretty much the same.
All the ratios are the same.
I'm worried bout the 'cache buffers chains' and these parts, were I'm not sure what action to take, if any at all.
Thanks again for your valuable comments!
Alex
PS: I'll get my head tested, as soon as I get out of this trouble, but it looks like a cheap weekend :-)
questionable sections:
Top 5 Logical Reads per Segment for DB: XXXX Instance: XXXX Snaps:
14 -15
-> End Segment Logical Reads Threshold: 10000
Subobject Obj.
Logical
Owner Tablespace Object Name Name Type
Reads %Total
---------- ---------- -------------------- ---------- ----- ------------ ------- MCCAPP USR OPMAIN TABLE 371,440 18.01 MCCAPP INDX DOFFELDER_COMB INDEX 222,768 10.80 MCCAPP INDX I_BEBGZ_BE INDEX 141,056 6.84 MCCAPP INDX I_OPP_OPREFNR INDEX 112,512 5.46 MCCAPP USR OPPOPPLAN TABLE106,912 5.18
Subobject Obj.
Physical
Owner Tablespace Object Name Name Type
Reads %Total
---------- ---------- -------------------- ---------- ----- ------------ ------- MCCAPP INDX DTZDTZUORDNUNG_COMB INDEX 429 19.69 MCCAPP USR HOHOSPITALISATION TABLE 286 13.13 MCCAPP USR PAPATIENT TABLE 175 8.03 MCCAPP USR DTZDTZUORDNUNG TABLE 173 7.94 MCCAPP INDX I_HO_AUFN INDEX173 7.94
Top 5 Buf. Busy Waits per Segment for DB: XXXX Instance: XXXX
Snaps: 14 -15
-> End Segment Buffer Busy Waits Threshold: 100
Buffer
Subobject Obj.
Busy
Owner Tablespace Object Name Name Type
Waits %Total
---------- ---------- -------------------- ---------- ----- ------------ ------- MCCAPP INDX I_EVERF INDEX 3 60.00 MCCAPP USR BEWBEWEGUNG TABLE 1 20.00 MCCAPP USR HOHOSPITALISATION TABLE1 20.00
Row
Subobject Obj.
Lock
Owner Tablespace Object Name Name Type
Waits %Total
---------- ---------- -------------------- ---------- ----- ------------ ------- MCCAPP INDX PK_HO INDEX 17 48.57 MCCAPP INDX PK_EV INDEX 6 17.14 MCCAPP INDX OPMAIN_COMB INDEX 4 11.43 MCCAPP INDX PK_PA INDEX 3 8.57 MCCAPP INDX I_HOPAREFNR INDEX2 5.71
Dictionary Cache Stats for DB: XXXX Instance: XXXX Snaps: 14 -15
->"Pct Misses" should be very low (< 2% in most cases)
->"Cache Usage" is the number of cache entries being used
->"Pct SGA" is the ratio of usage to allocated size for that
cache
Get Pct Scan Pct Mod
Final
Cache Requests Miss Reqs Miss Reqs
Usage
------------------------- ------------ ------ ------- ----- -------- ---------- dc_histogram_data 1,310 0.0 0 0 139 dc_histogram_defs 5,993 6.8 0 0 3,734 dc_object_ids 17,264 0.0 0 0 1,102 dc_objects 1,179 3.4 0 0 867 dc_profiles 61 0.0 0 0 1 dc_rollback_segments 135 0.0 0 0 41 dc_segments 3,684 0.1 0 1 1,117 dc_sequences 16 0.0 0 16 5 dc_table_scns 79 0.0 0 0 2 dc_tablespace_quotas 1 0.0 0 1 1 dc_tablespaces 856 0.0 0 0 9 dc_user_grants 1,100 0.0 0 0 19 dc_usernames 304 0.0 0 0 7 dc_users 3,598 0.0 0 021
 |
 |