-
temp extent size for DMT
I read Oracle Doc recommendation that the best extent size for TEMP tablespace (DMT) is sort_area_size (or multiple) + db_block_size. When i applied this to my DB 5 minutes later it hit an error.. unable to extent tablespace TEMP.... when i change back to original extent sizinh which is 520k, the db running with no error.
DB 8.1.7 on Solaris
Any idea on this?
The man called Zorro
-
So what size did you change it to?
-
changed to sort_area_size + db_block_size
first time
524288*2 + 8192 = 1056768 <- hit error
second time
524288 + 8192 = 532480 <- also hit error
now init 520k next 520k..
so far 2 week runnign without any problem... any idea slimdave?
Last edited by zainalj; 04-16-2004 at 02:32 AM.
The man called Zorro
-
i suspect if you may have specified 1056768 K or M?
funky...
"I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."
"Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"
-
Originally posted by abhaysk
i suspect if you may have specified 1056768 K or M?
i did't specify anything.. where it should be on bytes.
The man called Zorro
-
-
Just try giving
524288*1 + 8192 = 532480
-nagarjuna
-
Originally posted by nagarjuna
Just try giving
524288*1 + 8192 = 532480
??? if you read my msg above.. i did tried this formula and hit error
anybody may explain why?
The man called Zorro
-
Uhhh I don't remember mentioning that to you.
Oracle it's not just a database it's a lifestyle!
--------------
BTW....You need to get a girlfriend who's last name isn't .jpg
-
Originally posted by zainalj
??? if you read my msg above.. i did tried this formula and hit error
anybody may explain why?
I am sorry.. I missed it out. Try the following..
initial ==> 524288*1 + 8192 = 532480
next ==> 524288
-nagarjuna
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
|