Performance Related

From: <bshah_at_hotmail.com>
Date: 1997/10/14
Message-ID: <876751305.21322@dejanews.com>#1/1

Hello!

1> WHat should be SGA size in developement instance where atleast 20 users are logged in through sqlplus and 20 more sessions dong pro*c compilation and another 5-6 FE Developers?
Currently it is,
SVRMGR> show sga

Total System Global Area      13357088 bytes
Fixed Size                       46384 bytes
Variable Size                 12892912 bytes
Database Buffers                409600 bytes
Redo Buffers                      8192 bytes

Connect/desc time is of the order of 50-60 seconds. By increasing shared_pool_size or processes or any other way can i improve responce!?!? Compilation time is in hrs.

2> WHat is the solution for ora-1631? Would like to know how is it actually handled in Production environment?

Please advice
Cheers
Biren

-------------------==== Posted via Deja News ====-----------------------
      http://www.dejanews.com/     Search, Read, Post to Usenet

Received on Tue Oct 14 1997 - 00:00:00 CDT