Re: Snapshot too old in undo tablespace in 9i?

Daniel, I have just finished reading your document on UNdo Internals and Tims Cats, Dogs and ORA-1555s. Thanks for the documents they were both great. There is something I don't understand and I am not sure about it. You have said below: When a transaction is bound to an undo segment, it

Re: Snapshot too old in undo tablespace in 9i?

Daniel, that make sense , thanks. Stephen Hodgkinson Oracle DBA Total Gas Power Ltd Phone: 01737 27 5564 [EMAIL PROTECTED

Re: 9i - Dynamic SGA - SGA_MAX_SIZE

Oracle have changed there response when I pointed out that ask Tom indicated that different operating systems appear to perform differently Oracle's response is below and from all your replies this would appear to be the case. Thanks, for your help. stephen

9i - Dynamic SGA - SGA_MAX_SIZE

Hi, does anybody have any experience with setting the SGA_MAX_SIZE in 9i. I assumed the purpose of this parameter was that SGA would grow as requested to that limit. Example: You could configure your SGA to be 80M Set the SGA_MAX_SIZE to be 250M. I would have expected oracle to acquire 80M

Re: 9i - Dynamic SGA - SGA_MAX_SIZE

Tanel, I have done this. ipcs -m would not give me the size of the memory acquired on my system so I used ipcs -a I have also looked into the ps vax Which gives more detail: Currently this shows 199M reserved to the SGA EM9I /oracle/app/oracle/product/9.2.0/dbs ps avx|head -1 PID TTY

RE: 9i - Dynamic SGA - SGA_MAX_SIZE

growing or shrinking in SGA size. Stephen Hodgkinson Oracle DBA TotalFina Elf Gas Power Ltd Phone: 01737 27 5564

SQL question - crosstab in oracle

Hi I have a table with the following structure. CHECK_DATE DATE PHYRDS NUMBER(20) PHYWRTSNUMBER(20) PHYBLKRD

RE: Performance

17:00 get there for 17:50 Stephen Hodgkinson Oracle DBA TotalFina Elf Gas Power Ltd Phone: 01737 27 5564 [EMAIL PROTECTED] ** This email contains information which is confidential. It is for the exclusive use