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