Gaurav,
Actually I want to know the areas where I should look into related to
database only.
Like Since the number of Orders to be placed on application based on
Oracle8i will increase significantly my focus should be on: Shared pool
size,data file sizes
Should the number of redoologs be increased
What about the rollback segment and undo tablespace.
Please can you provide me some info on these kind of databse parameters
where my focus should be.
Regards,
Saurabh
-----Original Message-----
From: Gaurav Shrivastava
[mailto:oracledba-ezmlmshield-x63186322.[Email address protected]
Sent: Thursday, June 28, 2007 6:55 PM
To: LazyDBA Discussion
Subject: RE: Performance check
Saurabh, You need to give more information on this like
Operating system, Ram on the machine, your SGA size, the way your table
are organized etc.
Gaurav
-----Original Message-----
From: Saurabh Verma
[mailto:oracledba-ezmlmshield-x48957049.[Email address protected]
Sent: Thursday, June 28, 2007 8:35 AM
To: LazyDBA Discussion
Subject: RE: Performance check
Please can anyone help on this
-----Original Message-----
From: Saurabh Verma
[mailto:oracledba-ezmlmshield-x7738284.[Email address protected]
Sent: Thursday, June 28, 2007 5:12 PM
To: LazyDBA Discussion
Subject: Performance check
Hi,
Our application is based on Oracle8i.Currently the application handles
50,000 orders per day.
Now the client wants it to handle 200,000 orders per day.
Please help me in identifying what all database changes need to be
looked into.
Regards,
Saurabh Verma
========================================================================
====================================================
Disclaimer:
This message and the information contained herein is proprietary and
confidential and subject to the Tech Mahindra policy statement, you may
review the policy at <a
href="http://www.techmahindra.com/Disclaimer.html">http://www.techmahind
ra.com/Disclaimer.html</a> externally and <a
href="http://tim.techmahindra.com/Disclaimer.html">http://tim.techmahind
ra.com/Disclaimer.html</a> internally within Tech Mahindra.
========================================================================
====================================================
---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
========================================================================
====================================================
Disclaimer:
This message and the information contained herein is proprietary and
confidential and subject to the Tech Mahindra policy statement, you may
review the policy at <a
href="http://www.techmahindra.com/Disclaimer.html">http://www.techmahind
ra.com/Disclaimer.html</a> externally and <a
href="http://tim.techmahindra.com/Disclaimer.html">http://tim.techmahind
ra.com/Disclaimer.html</a> internally within Tech Mahindra.
========================================================================
====================================================
---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
============================================================================================================================
Disclaimer:
This message and the information contained herein is proprietary and confidential and subject to the Tech Mahindra policy statement, you may review the policy at <a href="http://www.techmahindra.com/Disclaimer.html">http://www.techmahindra.com/Disclaimer.html</a> externally and <a href="http://tim.techmahindra.com/Disclaimer.html">http://tim.techmahindra.com/Disclaimer.html</a> internally within Tech Mahindra.
============================================================================================================================
Oracle LazyDBA home page