Return-Path: <oracle-l-bounce@freelists.org>
Delivered-To: 2-oracle-l@orafaq.com
Received: (qmail 19606 invoked from network); 3 Dec 2007 14:16:48 -0600
Received: from freelists-180.iquest.net (HELO turing.freelists.org) (206.53.239.180)
  by 69.64.49.119 with SMTP; 3 Dec 2007 14:16:41 -0600
Received: from localhost (localhost [127.0.0.1])
 by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 1B6EC7CD980;
 Mon,  3 Dec 2007 14:34:34 -0500 (EST)
Received: from turing.freelists.org ([127.0.0.1])
 by localhost (turing.freelists.org [127.0.0.1]) (amavisd-new, port 10024)
 with ESMTP id 15556-03; Mon, 3 Dec 2007 14:34:33 -0500 (EST)
Received: from turing (localhost [127.0.0.1])
 by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 8B3567CD427;
 Mon,  3 Dec 2007 14:34:33 -0500 (EST)
Received: with ECARTIS (v1.0.0; list oracle-l); Mon, 03 Dec 2007 13:47:37 -0500 (EST)
Received: from localhost (localhost [127.0.0.1])
 by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 478D87CCF1B
 for <oracle-l@freelists.org>; Mon,  3 Dec 2007 13:47:37 -0500 (EST)
Received: from turing.freelists.org ([127.0.0.1])
 by localhost (turing.freelists.org [127.0.0.1]) (amavisd-new, port 10024)
 with ESMTP id 10638-02 for <oracle-l@freelists.org>;
 Mon, 3 Dec 2007 13:47:37 -0500 (EST)
Received: from Jaxsmtp01.crowley.com (outbound.crowley.com [12.24.152.45])
 by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 63E917CC6C2
 for <oracle-l@freelists.org>; Mon,  3 Dec 2007 13:47:05 -0500 (EST)
Received: from JAXMSG01.crowley.com ([10.70.10.141]) by Jaxsmtp01.crowley.com with Microsoft SMTPSVC(5.0.2195.6713);
	 Mon, 3 Dec 2007 13:46:56 -0500
X-MimeOLE: Produced By Microsoft Exchange V6.5
Content-class: urn:content-classes:message
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01C835DC.E0FBD3A4"
Subject: ls and rm command
Date: Mon, 3 Dec 2007 13:46:55 -0500
Message-ID: <0684DA55864E404F8AD2E2EBDFD557DA60067D@JAXMSG01.crowley.com>
X-MS-Has-Attach: 
X-MS-TNEF-Correlator: 
Thread-Topic: ls and rm command
From: <Joel.Patterson@crowley.com>
To: <oracle-l@freelists.org>
X-OriginalArrivalTime: 03 Dec 2007 18:46:56.0700 (UTC) FILETIME=[E12D9FC0:01C835DC]
X-archive-position: 3680
X-ecartis-version: Ecartis v1.0.0
Sender: oracle-l-bounce@freelists.org
Errors-to: oracle-l-bounce@freelists.org
X-original-sender: Joel.Patterson@crowley.com
Precedence: normal
Reply-to: Joel.Patterson@crowley.com
List-help: <mailto:ecartis@freelists.org?Subject=help>
List-unsubscribe: <oracle-l-request@freelists.org?Subject=unsubscribe>
List-software: Ecartis version 1.0.0
List-Id: oracle-l <oracle-l.freelists.org>
X-List-ID: oracle-l <oracle-l.freelists.org>
List-subscribe: <oracle-l-request@freelists.org?Subject=subscribe>
List-owner: <mailto:steve.adams@ixora.com.au>
List-post: <mailto:oracle-l@freelists.org>
List-archive: <http://www.freelists.org/archives/oracle-l>
X-list: oracle-l
X-Virus-Scanned: Debian amavisd-new at localhost.localdomain
------_=_NextPart_001_01C835DC.E0FBD3A4
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

This happened using mtime and atime.   I list everything older than X
days, then rm them, then use the same list command again, except that
now all the remaing files list?  Solaris 5.8.

This does not happen with -exec but -exec is slower, and it doesn't
happen with {} \;  - see below.   Anyone have any tips?

WITH XARGS
jaxlawdw > find . -name "access_log.*" -atime +245 | xargs ls -lt
-rw-r--r--   1 oracle   dba       746678 Apr  2  2007
./access_log.20070401_0643
jaxlawdw > find . -name "access_log.*" -atime +245 | xargs rm   =20
jaxlawdw > find . -name "access_log.*" -atime +245 | xargs ls -lt
total 442776
-rw-r--r--   1 oracle   dba       444643 Dec  3 13:31 access_log
-rw-r--r--   1 oracle   dba        42519 Dec  3 11:38 event_log
drwxr-----   2 oracle   dba         1536 Dec  3 08:39 archive
-rw-r--r--   1 oracle   dba       925017 Dec  3 00:00
access_log.20071202_0000
-rw-r--r--   1 oracle   dba       925017 Dec  2 00:00
access_log.20071201_0000
-rw-r--r--   1 oracle   dba       925017 Dec  1 00:00
access_log.20071130_0000
............... about 250 lines.


WITH -EXEC
jaxlawdw > find . -name "access_log.*" -atime +243 -exec ls -lt {} \;
-rw-r--r--   1 oracle   dba       924990 Apr  3  2007
./access_log.20070402_0000
-rw-r--r--   1 oracle   dba       924990 Apr  4  2007
./access_log.20070403_0000
jaxlawdw > find . -name "access_log.*" -atime +243 -exec rm {} \;   =20
jaxlawdw > find . -name "access_log.*" -atime +243 -exec ls -lt {} \;


jaxlawdw > find . -name "access_log.*" -atime +240 | xargs ls -lt {} \;

{}: No such file or directory
;: No such file or directory
-rw-r--r--   1 oracle   dba       924990 Apr  7  2007
./access_log.20070406_0000
-rw-r--r--   1 oracle   dba       924990 Apr  6  2007
./access_log.20070405_0000
-rw-r--r--   1 oracle   dba       924990 Apr  5  2007
./access_log.20070404_0000
jaxlawdw > find . -name "access_log.*" -atime +240 | xargs rm {} \;   =20
{}: No such file or directory
;: No such file or directory
jaxlawdw > find . -name "access_log.*" -atime +240 | xargs ls -lt {} \;
{}: No such file or directory
;: No such file or directory


Joel Patterson
Database Administrator
joel.patterson@crowley.com
x72546
904  727-2546


------_=_NextPart_001_01C835DC.E0FBD3A4
Content-Type: text/html; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Dus-ascii">
<META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version =
6.5.7651.59">
<TITLE>ls and rm command</TITLE>
</HEAD>
<BODY>
<!-- Converted from text/rtf format -->

<P ALIGN=3DLEFT><SPAN LANG=3D"en-us"><FONT SIZE=3D2 FACE=3D"Courier =
New">This happened using mtime and atime.&nbsp;&nbsp; I list everything =
older than X days, then rm them, then use the same list command again, =
except that now all the remaing files list?</FONT></SPAN><SPAN =
LANG=3D"en-us"></SPAN><SPAN LANG=3D"en-us"><FONT SIZE=3D2 =
FACE=3D"Courier New">&nbsp; Solaris 5.8.</FONT></SPAN><SPAN =
LANG=3D"en-us"></SPAN><SPAN LANG=3D"en-us"></SPAN></P>

<P ALIGN=3DLEFT><SPAN LANG=3D"en-us"><FONT SIZE=3D2 FACE=3D"Courier =
New">This does not happen with</FONT></SPAN><SPAN =
LANG=3D"en-us"></SPAN><SPAN LANG=3D"en-us"> <FONT SIZE=3D2 =
FACE=3D"Courier New">&#8211;</FONT></SPAN><SPAN =
LANG=3D"en-us"></SPAN><SPAN LANG=3D"en-us"><FONT SIZE=3D2 =
FACE=3D"Courier New">exec</FONT></SPAN><SPAN LANG=3D"en-us"></SPAN><SPAN =
LANG=3D"en-us"><FONT SIZE=3D2 FACE=3D"Courier New"></FONT></SPAN><SPAN =
LANG=3D"en-us"></SPAN><SPAN LANG=3D"en-us"> <FONT SIZE=3D2 =
FACE=3D"Courier New">but</FONT></SPAN><SPAN LANG=3D"en-us"></SPAN><SPAN =
LANG=3D"en-us"> <FONT SIZE=3D2 FACE=3D"Courier =
New">&#8211;</FONT></SPAN><SPAN LANG=3D"en-us"></SPAN><SPAN =
LANG=3D"en-us"><FONT SIZE=3D2 FACE=3D"Courier New">exec is slower, and =
it doesn</FONT></SPAN><SPAN LANG=3D"en-us"></SPAN><SPAN =
LANG=3D"en-us"><FONT SIZE=3D2 FACE=3D"Courier =
New">&#8217;</FONT></SPAN><SPAN LANG=3D"en-us"></SPAN><SPAN =
LANG=3D"en-us"><FONT SIZE=3D2 FACE=3D"Courier New">t happen with {} =
\;&nbsp;</FONT></SPAN><SPAN LANG=3D"en-us"></SPAN><SPAN LANG=3D"en-us"> =
<FONT SIZE=3D2 FACE=3D"Courier New">&#8211;</FONT></SPAN><SPAN =
LANG=3D"en-us"></SPAN><SPAN LANG=3D"en-us"><FONT SIZE=3D2 =
FACE=3D"Courier New"> see below</FONT></SPAN><SPAN =
LANG=3D"en-us"></SPAN><SPAN LANG=3D"en-us"><FONT SIZE=3D2 =
FACE=3D"Courier New">.&nbsp;&nbsp; Anyone have any =
tips?</FONT></SPAN><SPAN LANG=3D"en-us"></SPAN><SPAN =
LANG=3D"en-us"></SPAN></P>

<P ALIGN=3DLEFT><SPAN LANG=3D"en-us"><FONT SIZE=3D2 FACE=3D"Courier =
New">WITH XARGS</FONT></SPAN><SPAN LANG=3D"en-us"></SPAN><SPAN =
LANG=3D"en-us"></SPAN></P>

<P ALIGN=3DLEFT><SPAN LANG=3D"en-us"><FONT SIZE=3D2 FACE=3D"Courier =
New">jaxlawdw &gt; find . -name &quot;access_log.*&quot; -atime +245 | =
xargs ls -lt</FONT></SPAN></P>

<P ALIGN=3DLEFT><SPAN LANG=3D"en-us"><FONT SIZE=3D2 FACE=3D"Courier =
New">-rw-r--r--&nbsp;&nbsp; 1 oracle&nbsp;&nbsp; =
dba&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 746678 Apr&nbsp; 2&nbsp; 2007 =
./access_log.20070401_0643</FONT></SPAN></P>

<P ALIGN=3DLEFT><SPAN LANG=3D"en-us"><FONT SIZE=3D2 FACE=3D"Courier =
New">jaxlawdw &gt; find . -name &quot;access_log.*&quot; -atime +245 | =
xargs rm&nbsp;&nbsp;&nbsp; </FONT></SPAN></P>

<P ALIGN=3DLEFT><SPAN LANG=3D"en-us"><FONT SIZE=3D2 FACE=3D"Courier =
New">jaxlawdw &gt; find . -name &quot;access_log.*&quot; -atime +245 | =
xargs ls -lt</FONT></SPAN></P>

<P ALIGN=3DLEFT><SPAN LANG=3D"en-us"><FONT SIZE=3D2 FACE=3D"Courier =
New">total 442776</FONT></SPAN></P>

<P ALIGN=3DLEFT><SPAN LANG=3D"en-us"><FONT SIZE=3D2 FACE=3D"Courier =
New">-rw-r--r--&nbsp;&nbsp; 1 oracle&nbsp;&nbsp; =
dba&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 444643 Dec&nbsp; 3 13:31 =
access_log</FONT></SPAN></P>

<P ALIGN=3DLEFT><SPAN LANG=3D"en-us"><FONT SIZE=3D2 FACE=3D"Courier =
New">-rw-r--r--&nbsp;&nbsp; 1 oracle&nbsp;&nbsp; =
dba&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 42519 Dec&nbsp; 3 11:38 =
event_log</FONT></SPAN></P>

<P ALIGN=3DLEFT><SPAN LANG=3D"en-us"><FONT SIZE=3D2 FACE=3D"Courier =
New">drwxr-----&nbsp;&nbsp; 2 oracle&nbsp;&nbsp; =
dba&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1536 Dec&nbsp; 3 =
08:39 archive</FONT></SPAN></P>

<P ALIGN=3DLEFT><SPAN LANG=3D"en-us"><FONT SIZE=3D2 FACE=3D"Courier =
New">-rw-r--r--&nbsp;&nbsp; 1 oracle&nbsp;&nbsp; =
dba&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 925017 Dec&nbsp; 3 00:00 =
access_log.20071202_0000</FONT></SPAN></P>

<P ALIGN=3DLEFT><SPAN LANG=3D"en-us"><FONT SIZE=3D2 FACE=3D"Courier =
New">-rw-r--r--&nbsp;&nbsp; 1 oracle&nbsp;&nbsp; =
dba&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 925017 Dec&nbsp; 2 00:00 =
access_log.20071201_0000</FONT></SPAN></P>

<P ALIGN=3DLEFT><SPAN LANG=3D"en-us"><FONT SIZE=3D2 FACE=3D"Courier =
New">-rw-r--r--&nbsp;&nbsp; 1 oracle&nbsp;&nbsp; =
dba&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 925017 Dec&nbsp; 1 00:00 =
access_log.20071130_0000</FONT></SPAN><SPAN LANG=3D"en-us"></SPAN><SPAN =
LANG=3D"en-us"></SPAN></P>

<P ALIGN=3DLEFT><SPAN LANG=3D"en-us"><FONT SIZE=3D2 FACE=3D"Courier =
New">&#8230;&#8230;&#8230;</FONT></SPAN><SPAN =
LANG=3D"en-us"></SPAN><SPAN LANG=3D"en-us"><FONT SIZE=3D2 =
FACE=3D"Courier New">&#8230;&#8230;</FONT></SPAN><SPAN =
LANG=3D"en-us"></SPAN><SPAN LANG=3D"en-us"><FONT SIZE=3D2 =
FACE=3D"Courier New"> about 250 lines.</FONT></SPAN><SPAN =
LANG=3D"en-us"></SPAN><SPAN LANG=3D"en-us"></SPAN></P>
<BR>

<P ALIGN=3DLEFT><SPAN LANG=3D"en-us"><FONT SIZE=3D2 FACE=3D"Courier =
New">WITH -EXEC</FONT></SPAN></P>

<P ALIGN=3DLEFT><SPAN LANG=3D"en-us"><FONT SIZE=3D2 FACE=3D"Courier =
New">jaxlawdw &gt; find . -name &quot;access_log.*&quot; -atime +243 =
-exec ls -lt {} \;</FONT></SPAN></P>

<P ALIGN=3DLEFT><SPAN LANG=3D"en-us"><FONT SIZE=3D2 FACE=3D"Courier =
New">-rw-r--r--&nbsp;&nbsp; 1 oracle&nbsp;&nbsp; =
dba&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 924990 Apr&nbsp; 3&nbsp; 2007 =
./access_log.20070402_0000</FONT></SPAN></P>

<P ALIGN=3DLEFT><SPAN LANG=3D"en-us"><FONT SIZE=3D2 FACE=3D"Courier =
New">-rw-r--r--&nbsp;&nbsp; 1 oracle&nbsp;&nbsp; =
dba&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 924990 Apr&nbsp; 4&nbsp; 2007 =
./access_log.20070403_0000</FONT></SPAN></P>

<P ALIGN=3DLEFT><SPAN LANG=3D"en-us"><FONT SIZE=3D2 FACE=3D"Courier =
New">jaxlawdw &gt; find . -name &quot;access_log.*&quot; -atime +243 =
-exec rm {} \;&nbsp;&nbsp;&nbsp; </FONT></SPAN></P>

<P ALIGN=3DLEFT><SPAN LANG=3D"en-us"><FONT SIZE=3D2 FACE=3D"Courier =
New">jaxlawdw &gt; find . -name &quot;access_log.*&quot; -atime +243 =
-exec ls -lt {} \;</FONT></SPAN><SPAN LANG=3D"en-us"></SPAN><SPAN =
LANG=3D"en-us"></SPAN></P>
<BR>

<P ALIGN=3DLEFT><SPAN LANG=3D"en-us"><FONT SIZE=3D2 FACE=3D"Courier =
New">jaxlawdw &gt; find . -name &quot;access_log.*&quot; -atime +240 | =
xargs ls -lt {} \;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </FONT></SPAN></P>

<P ALIGN=3DLEFT><SPAN LANG=3D"en-us"><FONT SIZE=3D2 FACE=3D"Courier =
New">{}: No such file or directory</FONT></SPAN></P>

<P ALIGN=3DLEFT><SPAN LANG=3D"en-us"><FONT SIZE=3D2 FACE=3D"Courier =
New">;: No such file or directory</FONT></SPAN></P>

<P ALIGN=3DLEFT><SPAN LANG=3D"en-us"><FONT SIZE=3D2 FACE=3D"Courier =
New">-rw-r--r--&nbsp;&nbsp; 1 oracle&nbsp;&nbsp; =
dba&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 924990 Apr&nbsp; 7&nbsp; 2007 =
./access_log.20070406_0000</FONT></SPAN></P>

<P ALIGN=3DLEFT><SPAN LANG=3D"en-us"><FONT SIZE=3D2 FACE=3D"Courier =
New">-rw-r--r--&nbsp;&nbsp; 1 oracle&nbsp;&nbsp; =
dba&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 924990 Apr&nbsp; 6&nbsp; 2007 =
./access_log.20070405_0000</FONT></SPAN></P>

<P ALIGN=3DLEFT><SPAN LANG=3D"en-us"><FONT SIZE=3D2 FACE=3D"Courier =
New">-rw-r--r--&nbsp;&nbsp; 1 oracle&nbsp;&nbsp; =
dba&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 924990 Apr&nbsp; 5&nbsp; 2007 =
./access_log.20070404_0000</FONT></SPAN></P>

<P ALIGN=3DLEFT><SPAN LANG=3D"en-us"><FONT SIZE=3D2 FACE=3D"Courier =
New">jaxlawdw &gt; find . -name &quot;access_log.*&quot; -atime +240 | =
xargs rm {} \;&nbsp;&nbsp;&nbsp; </FONT></SPAN></P>

<P ALIGN=3DLEFT><SPAN LANG=3D"en-us"><FONT SIZE=3D2 FACE=3D"Courier =
New">{}: No such file or directory</FONT></SPAN></P>

<P ALIGN=3DLEFT><SPAN LANG=3D"en-us"><FONT SIZE=3D2 FACE=3D"Courier =
New">;: No such file or directory</FONT></SPAN></P>

<P ALIGN=3DLEFT><SPAN LANG=3D"en-us"><FONT SIZE=3D2 FACE=3D"Courier =
New">jaxlawdw &gt; find . -name &quot;access_log.*&quot; -atime +240 | =
xargs ls -lt {} \;</FONT></SPAN></P>

<P ALIGN=3DLEFT><SPAN LANG=3D"en-us"><FONT SIZE=3D2 FACE=3D"Courier =
New">{}: No such file or directory</FONT></SPAN></P>

<P ALIGN=3DLEFT><SPAN LANG=3D"en-us"><FONT SIZE=3D2 FACE=3D"Courier =
New">;: No such file or directory</FONT></SPAN><SPAN =
LANG=3D"en-us"></SPAN><SPAN LANG=3D"en-us"></SPAN></P>
<BR>

<P ALIGN=3DLEFT><SPAN LANG=3D"en-us"></SPAN><A NAME=3D""><SPAN =
LANG=3D"en-us"><FONT SIZE=3D2 FACE=3D"Arial">Joel =
Patterson</FONT></SPAN></A></P>

<P ALIGN=3DLEFT><SPAN LANG=3D"en-us"><FONT SIZE=3D2 =
FACE=3D"Arial">Database Administrator</FONT></SPAN></P>

<P ALIGN=3DLEFT><SPAN LANG=3D"en-us"><FONT SIZE=3D2 =
FACE=3D"Arial">joel.patterson@crowley.com</FONT></SPAN></P>

<P ALIGN=3DLEFT><SPAN LANG=3D"en-us"><FONT SIZE=3D2 =
FACE=3D"Arial">x72546</FONT></SPAN></P>

<P ALIGN=3DLEFT><SPAN LANG=3D"en-us"><FONT SIZE=3D2 =
FACE=3D"Arial">904&nbsp; 727-2546</FONT></SPAN><SPAN =
LANG=3D"en-us"></SPAN><SPAN LANG=3D"en-us"></SPAN><SPAN =
LANG=3D"en-us"></SPAN></P>

<P ALIGN=3DLEFT><SPAN LANG=3D"en-us"></SPAN></P>

</BODY>
</HTML>
------_=_NextPart_001_01C835DC.E0FBD3A4--
--
http://www.freelists.org/webpage/oracle-l


