My estimate right now is about a 500GB instance(but could grow). There are several
complexities.
1. high transaction system, but also will have alot of long running queries
2. We deliver data daily and rebuild large parts of the database nightly with loads.
Im not certain I have the window to
Inline...
[EMAIL PROTECTED] wrote:
My estimate right now is about a 500GB instance(but could grow). There are several
complexities.
1. high transaction system, but also will have alot of long running queries
Hello, 1555s! I think you will be plagued by these, even with a high number/size
At 13:14 22-12-03 -0800, you wrote:
I think you are on the right track. If you can turn on tracing with a
logon trigger, you should be able to get some/most(?) of the sql and the
order in which they are performed. Strip out the extraneous info and you
have a test script. James Morle of the Oak
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Monday, December 22, 2003 4:14 PM
Inline...
[EMAIL PROTECTED] wrote:
My estimate right now is about a 500GB instance(but could grow). There
are several complexities.
1. high transaction
see my responses below...
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Monday, December 22, 2003 4:14 PM
Inline...
[EMAIL PROTECTED] wrote:
My estimate right now is about a 500GB instance(but could grow). There
are several complexities.
Since you are on 9i, have you considered monitoring the tables?
( alter/create table monitor )
This would reduce the need to collect statistics so often.
Jared
On Mon, 2003-12-22 at 12:19, [EMAIL PROTECTED] wrote:
My estimate right now is about a 500GB instance(but could grow). There are