Given that for a 9i db...
Temporary tablespace is 629 MB.
Sort_area_size = 65536
sort extent pool = 30042
sort (rows) = 72,982,957
sort(memory) = 105,504
sort (disk) = 444
What is an initial recommendation?
Printable View
Given that for a 9i db...
Temporary tablespace is 629 MB.
Sort_area_size = 65536
sort extent pool = 30042
sort (rows) = 72,982,957
sort(memory) = 105,504
sort (disk) = 444
What is an initial recommendation?
WORKAREA_SIZE_POLICY = AUTO
PGA_AGGREGATE_TARGET = as much RAM as you can spare after allowing for SGA and O/S requirements without swapping.
John
The temporary tablespace on the system is showing 99% used for 2 - TEMP_CNTBS & TEMP_HKTBS. Any idea why ?
Status Tablespace Name TS Type Ext. Mgt. Seg. Mgt. Tablespace Size Free (in bytes) Used (in bytes) Pct. Used
ONLINE TEMP_CNTBS TEMPORARY LOCAL MANUAL 5,368,709,120 1,048,576 5,367,660,544 99 %
ONLINE TEMP_HKTBS TEMPORARY LOCAL MANUAL 12,884,901,888 1,048,576 12,883,853,312 99 %
ONLINE TEMP_IDTBS TEMPORARY LOCAL MANUAL 2,147,483,648 1,861,222,400 286,261,248 13 %
ONLINE TEMP_TBS TEMPORARY LOCAL MANUAL 2,147,483,648 1,708,130,304 439,353,344 20 %
ONLINE TEMP_THTBS TEMPORARY LOCAL MANUAL 8,589,934,592 3,263,168,512 5,326,766,080 62 %
-------------------- -------------------- --------------------
Hi
Well extents allocated by oracle in the temporary tablespaces would never be deallocated .
Thats the way oracle works..i dont think so its a reason to worry at all.
regards
Hrishy