-
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
kavitha
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
|