Re: Dump Max Reached

Fyi...

I couldn't find oradebug. Is this available on my platform , Solaris 8 Oracle 8.1.6.2 ?

Anyway, we were able to alter the init.ora max parm , but it was apparently too late. Smon still would not dump to it.

So, we did an Oracle restart and the weird _TEMP_ tables owned by SYS went away and so di the problem (for now anyway). There is a long description of this problem we are hitting when ... doing this from memory ... star_transformation = true ... is set in the init.ora .

Anyway, in Metalink there is a description of what do when hitting this ... really weird... doing a drop of a SYS owned "_TEMP_" table . That is not the entire name of the temp table, it changes every time. That is why we needed the trace dump of smon.

Another "DBA" set this up and thinks he really needs it... I don't know and don't have time to argue about and this database is going away later this year anyway.

Thanks.

"Sybrand Bakker" <gooiditweg_at_nospam.demon.nl> wrote in message news:gq2v6vc2hh8unlb1qchnc571fr6vf96o4i_at_4ax.com...
> On Wed, 12 Mar 2003 13:29:31 -0600, "JustAnotherDBA"
> <burttemp1REMOVETHIS_at_bellsouth.net> wrote:
>
> >Anyone know of a way to get smon to dump what it is trying to dump into a
> >trace file that has reached the max size? Of course, looking for
something
> >short of shutdown/startup...
>
> If so, you better forget about it.
> Frankly, I have *never* seen the smon trace file reach 5M (which is
> the default max_dump_file_size) within one month, so you must have
> some really serious problems, which you would better rather address
> than figthing symptoms.
>
> If you are really audacious you can use the oradebug facility to
> change the max_dump_file_size to unlimited.
> Oradebug help shows the available commands
> you'd typically first need to issue
> oradebug setospid <pid of the smon process>
> oradebug tracefile unlimited
>
> IIRC, however, tracing isn't resumed or with problems.
>
>
> Sybrand Bakker, Senior Oracle DBA
>
> To reply remove -verwijderdit from my e-mail address
Received on Sat Mar 15 2003 - 12:11:22 CST