Re: Materialized View

From: Mladen Gogala <gogala.mladen_at_gmail.com>
Date: Sat, 19 May 2012 17:53:02 +0000 (UTC)
Message-ID: <pan.2012.05.19.17.53.02_at_gmail.com>

On Fri, 18 May 2012 15:31:12 -0700, John Hurley wrote:

> Don't use adrcl much except for some automated purging of stuff that I
> don't want to keep around anymore.

I must say that I like it. Typing is a drag.

tail -f $ORACLE_BASE/diag/rdbms/O11/O11/trace/alert_O11.log

Also, listing tracefiles is very convenient:

[oracle_at_medo ~]$ adrci

ADRCI: Release 11.2.0.3.0 - Production on Sat May 19 13:51:02 2012

Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.

ADR base = "/oracle"
adrci> show tracefile %lgwr%

     diag/rdbms/o11/O11/trace/O11_lgwr_31810.trc
     diag/rdbms/o11/O11/trace/O11_lgwr_6001.trc
     diag/rdbms/o11/O11/trace/O11_lgwr_11502.trc

Of course, purging is also convenient.

-- 

http://mgogala.byethost5.com

Received on Sat May 19 2012 - 12:53:02 CDT