Re: Temp table in Procedure

Mark C. Stock wrote:

> "Frank van Bortel" <fvanbortel_at_netscape.net> wrote in message

> | Well - that's about a temporary as you want it. The DDL is expensive,
> | performance wise, so I would be against it - besides, it sounds like
> | SQL Server...
> | On the other hand - bugs in 9i make GTTs slower than their permanent
> | counterparts, so it's to the OP to decide - the greater context is
> | not known.
> |
> | --
> |
> | Regards,
> | Frank van Bortel
> |
>
> interesting -- can you provide a brief synopsis of the bugs? version?
> version fixed? work-arounds? how much slower?
>
> ;-{ mcs
>
>

Bug 2874489 (fixed in 9.2.0.5, believed to affect all version < 10G, confirmed in 9.2.0.4), regarding excessive redo with insert as select from...

Sometimes, an on commit delete gtt will generate ora-600's (bug 2405861 - same story as above)

On the figures: I believe Jonathan provided these some 3 weeks ago in this ng - google is your friend. Else I could come up with some, but it's late now, and the mrs is grumpy already :-|
Got 9204 as well as 1001 on the same box, similar setup, so it should compare.

Now only I need to download 9205... tomorrow? nah!

-- 

Regards,
Frank van Bortel