Re: How can I troubleshoot without informations ?

It looks like you are using 235 Megs for the db block buffers (4096 * 60,000 /(1024*1024)) and 25 megs for SGA which used to be 30 megs. Also if everyone is sorting at the same time you would have just under 200 megs allocated to sorting. (800 * 258048/(1024*1024)) To me that adds up to 235+30+200=465 say 500 megs of RAM being used by Oracle not counting the RAM allocated for each thread for other than sorting.

They should be able to run perfmon on the NT box and monitor, free memory, % swap file usage. This should show how much memory is available. I would not decrease the SGA (25 megs is pretty small) Put it back to 30 megs and decrease the db_block_buffers by 35 megs. (51200).

Yes, and move the control files to seperate disks as you pointed out.

Jim

"Dusan Bolek" <pagesflames_at_usa.net> wrote in message news:1e8276d6.0112110821.5d46128e_at_posting.google.com...
> We have problem on one of our servers. Everything is more complicated
> because this server is NT box and I can get in, because of security
> policies.
> So I've tried to do troubleshooting with information from second
> (maybe third) hand. I love this situation.
> Clients have got well-known ORA-12500 error. This Oracle 8.0.5.1.1
> server need to handle 800 concurrent connections in dedicated mode,
> which is something not very good for NT platform. The problem is
> probably in insufficient memory. However, I cannot tell this for sure,
> because some clever head decided to switch off logging of listener
> actions. So there is no listener.log, which is one of my favourite
> Oracle log files. :-(
> Server has 2GB of physical RAM, but it seems that Oracle is using only
> 1GB of it. That's strange because there is a lot of free memory
> available. The only way how they can achieve eliminating ORA-12500s is
> decrease of SGA which left more memory available for PGA. However
> performance trade-offs are very serious (nothing suprising).
> My situation is pretty bad, because I can get my hands on that very
> server, I'm not very confident about capabilities of DBA taking care
> about it and I do not know NT environment very well, especially in
> memory allocation limits.
> I know that there should be 2GB limit for user processes in NT, but
> 1GB seems for me too low value to has problems.
> If someone can help me, it will be appreciated.
>
> Some interesting parameters from init.ora:
> control_files =

(E:\OraCtrl\DB10\ctrl_DB10_01.odf,E:\OraCtrl\DB10\ctrl_DB10_02.odf,E:\OraCtr l\DB10\ctrl_DB10_03.odf)
> <- very good idea having
> all control files together. :-(
> db_block_buffers = 60000
> db_block_size = 4096
> db_files = 254
> dml_locks = 500
> log_buffer = 163840
> log_checkpoint_interval = 25000
> open_cursors = 200
> processes = 1600 <- was 2000
> shared_pool_size = 25000000 <- was 30000000 then 15000000
> sort_area_size = 258048
> MTS disabled, all running in dedicated mode
>
>
>
> P.S. In alert log is nothing interesting. However I'm not sure if I
> have the log from that time. :-(
>
> --
> _________________________________________
>
> Dusan Bolek, Ing.
> Oracle team leader
>
> Note: pagesflames_at_usa.net has been cancelled due to changes (maybe we
> can call it an overture to bankruptcy) on that server. I'm still using
> this email to prevent SPAM. Maybe one day I will change it and have a
> proper mail even for news, but right now I can be reached by this
> email.
Received on Tue Dec 11 2001 - 12:11:08 CST