TUNING URGENT

[kavithared]

Hiii,friends i am very worrying about my db performance,
I was migrate the 8i database to 9i database by using dblinks.
Now My db performance is very worrest,like cach hit ratio 69%,every thing is worriest,even i compared extents in both dbases.

ex--
tablename ABC
in 8iphysical structure
TABLESPACE TOOLS
PCTFREE 10
PCTUSED 40
INITRANS 1
MAXTRANS 255
STORAGE (
INITIAL 74618880
NEXT 37285888
PCTINCREASE 50
MINEXTENTS 1
MAXEXTENTS 121
FREELISTS 1 FREELIST GROUPS 1 )
NOCACHE;

same table in 9i ABC
TABLESPACE TOOLS
PCTFREE 10
PCTUSED 40
INITRANS 1
MAXTRANS 255
STORAGE (
INITIAL 65536
MINEXTENTS 1
MAXEXTENTS 2147483645
FREELISTS 1 FREELIST GROUPS 1 )
NOCACHE;

IN 9I there is no next extent ,
each table is look like above.
So how to overcome this problem?
any one give good suggestion to adjust the extents and tuning.
thanks
kavitha

[grjohnson]

kavithared, it really looks like you've either

a). Being thrown in the deep end of Oracle DB administration and told to "learn it"

or

b). Simply want everyone else to do your job for you without actually learning for yourself.

You really need to read some 9i documentation.

Sorry,

[kavithared]

Hiii,I know man,
just i was asked regading extents.
thanks

[hrishy]

Hello

I suggest you read about Locally Managed Tablespaces and make your extent sizes uniform .

Well its very difficult to say why your hit ratio has gone down drastically.I think you should be using statspack to gather statistics to come to a find the problem first.


Just a sugesstion did you analyze all your tables and indexes after moving to 9i ?why dont you do an analyze first and check ?

regards
Hrishy

[grjohnson]

Your Cache hit ratio could be down early if you've recently added alot more new tables etc. It becasue they've not been cached before. Alternatively, it could be becasue you cache is to small. Or, maybe you've just restarted the instance and the stats haven't average out yet (again, re-caching blocks)

[kavithared]

ok many thanks for all
if any advisees give me

[hrishy]

Hi Kavitha

I think you should gather some statistics and paste them here before any one of us here comes up with some worthwhile advice ;-D

regards
Hrishy

[SANJAY_G]

Hi Kavitha

I think you should gather some statistics and paste them here before any one of us here comes up with some worthwhile advice ;-D

regards
Hrishy

Be ready with the answer.. "How to gather statistics?"

Take it easy..

Sanjay

[hrishy]

Hi SanjayG

I am off to read the oRacle manuals on how to gather statistics maybe i could impress Kavitha with the answer ;-D


Hope Kavitha comesback with the question and the trick works LOL ;-D

regards
Hrishy