Re: Regarding database hanging problem - Please Help
> Hi,
>
> Any information/suggestion regarding this, Please reply me.
>
> With Regards,
> Raja.
Hi Raja,
you probably have two issues here:
1. temp spaces being filled due to your reports doing large sorts,
group by's etc...
2. Connections from your apps not closing statements/cursors hence
causing excessive virtual memory usage. Check your app conns using
"onstat -g ses", sort it on "total memory" field and post the top 10
here. Also post your hardware specs and SHM params from both
ONCONFIGs.
Cheers
Davorin