Re: select and redo logging

From: Peter Sharman <psharman_at_us.oracle.com>
Date: Wed, 10 Mar 1999 13:05:20 -0800
Message-ID: <36E6DE90.DF447F0A@us.oracle.com>

One thing I forgot to mention was the delayed block cleanout functionality that came with 7.3. This is another possibility. There was a whole thread on this some time back that it might be worthwhile looking through.

HTH. Pete

Peter Sharman wrote:

> Darren
>
> No, queries themselves aren't logged. Other users may of course be doing things
> that are logged. Alternatively, what do you know of the app? Is it possible
> that it's creating temporary tables, inserting information into them, ...?
>
> HTH.
>
> Pete
>
> dallen_at_fns.com.au wrote:
>
> > do queries get logged ? I have an app that is doing logs of queries and seems
> > to be hitting logs alot !
> >
> > any thoughts greatly appreciated
> >
> > darren
> >
> > -----------== Posted via Deja News, The Discussion Network ==----------
> > http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
>
> --
>
> Regards
>
> Pete
>
> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
> Peter Sharman Email: psharman_at_us.oracle.com
> WISE Course Development Manager Phone: +1.650.607.0109 (int'l)
> Worldwide Internal Services Education (650)607 0109 (local)
> San Francisco
>
> SQL> select standard_disclaimer, witty_remark
> 2 from company_requirements;
>
> Opinions are mine and do not necessarily reflect those of Oracle
> Corporation
>
> "Controlling application developers is like herding cats."
> Kevin Loney, ORACLE DBA Handbook
> "Oh no it's not! It's much harder than that!"
> Bruce Pihlamae, long term ORACLE DBA
> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
>
> ------------------------------------------------------------------------
> Name: psharman.vcf
> psharman.vcf Type: VCard (text/x-vcard)
> Encoding: 7bit
> Description: Card for Peter Sharman

Regards

Pete

Peter Sharman                             Email: psharman_at_us.oracle.com
WISE Course Development Manager           Phone: +1.650.607.0109 (int'l)
Worldwide Internal Services Education            (650)607 0109 (local)

San Francisco

SQL> select standard_disclaimer, witty_remark 2 from company_requirements;

Opinions are mine and do not necessarily reflect those of Oracle Corporation

"Controlling application developers is like herding cats." Kevin Loney, ORACLE DBA Handbook
"Oh no it's not! It's much harder than that!" Bruce Pihlamae, long term ORACLE DBA

Received on Wed Mar 10 1999 - 15:05:20 CST