New_To_Oracle_7912 wrote:You are running Windows 2003 on a machine with only 2gb of ram? I didn't know you could even purchase such a machine any more. Good grief! LAPTOPS come standard with 4gb, and mine has 8gb. Servers typically have much more.
I am using standard edition 1 (Oracle Edition) , Minimum 40+ members are going to be connected into that database.
But we are facing the problem,
1. Daily once the database gets slow,
for this issue, we are restarting the server so that the problem is getting solved temporarily.
Current Hardware spec:
OS: Server 2003
So please suggest me the Permanent solution for this problem
So please suggest me the Permanent solution for this problemWhat is/are your SGA_TARGET / SGA_MAX_SIZE / MEMORY_TARGET / MEMORY_MAX_SIZE / PGA_AGGREGATE_TARGET ?