- Database info: Oracle8i Enterprise Edition Release 8.1.6.0.0 (running on Windows 2000 Advanced Server)
- MTS settings:
*
Requires Free Membership to View
mts_circuits 445* mts_dispatchers(protocol=tcp) (dispatchers=1)
* mts_max_dispatchers 8
* mts_max_servers 14
* mts_multiple_listeners FALSE
* mts_servers 8
* mts_sessions 440
- Memory settings
POOL NAME BYTES
----------- -------------------------- ----------
java pool free memory 20758528
memory in use 212992
*********** ----------
sum 20971520
large pool free memory 38122284
session heap 3820756
*********** ----------
sum 41943040
shared pool DML locks 226896
KGFF heap 56104
KGK heap 34728
KQLS heap 663700
PL/SQL DIANA 278484
PL/SQL MPCODE 175516
PLS non-lib hp 2096
State objects 563144
VIRTUAL CIRCUITS 718888
db_block_buffers 38080000
db_block_hash_buckets 5004424
db_files 724544
db_handles 200000
dictionary cache 769800
distributed_transactions- 180152
enqueue_resources 286272
event statistics per sess 1495200
fixed allocation callback 640
free memory 33183696
joxs heap init 432
ktlbk state objects 209292
library cache 33081864
message pool freequeue 231152
miscellaneous 2984320
partitioning d 16980
processes 320000
sessions 948740
sql area 190006756
table columns 17668
table definiti 2056
transaction_branches 368000
transactions 436188
trigger defini 13996
trigger inform 460
*********** ----------
sum 311282188
db_block_buffers 2293760000
fixed_sga 70924
log_buffer 1638400
*********** ----------
sum 2295469324
I have no idea what causes the problem.
This sounds like bug #2622690. This bug is fixed in Oracle10g.
This was first published in February 2004
Join the conversationComment
Share
Comments
Results
Contribute to the conversation