nectarsoft
Active Member
I am attaching the complete Illustraive of case. Include JDE.INI and Oracle Databse .ORA File
Machine Configuration:
OS: Sun Solaris V440
CPU: 4
RAM: 8 GB
Hard Disk: 200 GB
JDE Configuration
Release: XE
Service Pack : SP21
Update 7 (XU7)
This Server act as ES and Database Box.
We have tuned the Solaris Server with the latest patches and it seems to be work fine except when it comes to database.
Oracle 9.2.0.7 is the database.
I am attaching the screen shot of Oracle Memory Tuning.
The strange thing is when we went to provide Buffer Size of 2 GB it shows the value in negative. But .ora file shows the correct value with 2 GB
Time factor:
1 Installing enterprise Server CD – took 1 day per pathcode. Hence it took 4 day to complete Enterprise Server Cd part.
2. Full Pkg- Client full pkg completes in 3 hrs, but Server full pkg took around 36 hrs to complete. It was gbrspec paktotam process that was running only. Rest all process finished in 3 hrs at server too.
3. Now when we are applying Update 7 XU7 – it again taking 12 hrs per pathcode.
All this things are really distrurbing a lot as my server configuration is too good.
My oracle utilize only 2 to 4 % of CPU.
In Windows the Same process took almost a day.
Is there any Tuning of Oracle Server on Solaris?
or any suggestion to improve oracle performace?
Machine Configuration:
OS: Sun Solaris V440
CPU: 4
RAM: 8 GB
Hard Disk: 200 GB
JDE Configuration
Release: XE
Service Pack : SP21
Update 7 (XU7)
This Server act as ES and Database Box.
We have tuned the Solaris Server with the latest patches and it seems to be work fine except when it comes to database.
Oracle 9.2.0.7 is the database.
I am attaching the screen shot of Oracle Memory Tuning.
The strange thing is when we went to provide Buffer Size of 2 GB it shows the value in negative. But .ora file shows the correct value with 2 GB
Time factor:
1 Installing enterprise Server CD – took 1 day per pathcode. Hence it took 4 day to complete Enterprise Server Cd part.
2. Full Pkg- Client full pkg completes in 3 hrs, but Server full pkg took around 36 hrs to complete. It was gbrspec paktotam process that was running only. Rest all process finished in 3 hrs at server too.
3. Now when we are applying Update 7 XU7 – it again taking 12 hrs per pathcode.
All this things are really distrurbing a lot as my server configuration is too good.
My oracle utilize only 2 to 4 % of CPU.
In Windows the Same process took almost a day.
Is there any Tuning of Oracle Server on Solaris?
or any suggestion to improve oracle performace?