f



Lag Time Between Log File Switch and Archive Log File

Colleagues:

Has anyone experienced lag times after an automatic log switch happens
and the time the archive log file appears in the archive log directory?
 I am running Oracle9i (9.2) on Solaris/UNIX.

For additional information, below are SQL results of time differences
between when the log switch happened and when the archive log file was
written to disk.

I welcome all ideas at your earliest convenience on this and thanks in
advance.

Donna



           BYTES NEXT_TIME            COMPLETION_TIME             LAG
---------------- -------------------- -------------------- ----------
   1,048,568,320 JUN-13-2006 00:28:20 JUN-13-2006 01:45:54         77
   1,048,573,440 JUN-13-2006 01:11:11 JUN-13-2006 01:46:27         35
   1,048,574,976 JUN-13-2006 01:26:43 JUN-13-2006 01:47:06         20
   1,048,574,976 JUN-13-2006 01:29:18 JUN-13-2006 01:47:40         18
   1,048,574,976 JUN-13-2006 01:41:32 JUN-13-2006 01:48:12          6
   1,048,574,976 JUN-13-2006 01:45:54 JUN-13-2006 01:48:28          2
   1,048,572,928 JUN-13-2006 02:08:46 JUN-13-2006 03:07:04         58
   1,048,574,976 JUN-13-2006 02:23:27 JUN-13-2006 03:07:50         44
   1,048,569,856 JUN-13-2006 02:38:10 JUN-13-2006 03:08:19         30
   1,048,566,784 JUN-13-2006 02:42:02 JUN-13-2006 03:09:01         26
   1,048,571,392 JUN-13-2006 03:04:52 JUN-13-2006 03:09:33          4
   1,048,570,368 JUN-13-2006 03:44:33 JUN-13-2006 07:48:41        244
     347,355,136 JUN-13-2006 04:44:29 JUN-13-2006 07:47:54        183
       2,733,056 JUN-13-2006 05:44:28 JUN-13-2006 07:47:54        123
       2,704,896 JUN-13-2006 06:44:28 JUN-13-2006 07:47:54         63
      45,496,832 JUN-13-2006 07:44:30 JUN-13-2006 07:47:55          3
       6,064,640 JUN-13-2006 08:44:35 JUN-13-2006 11:34:38        170
       3,440,128 JUN-13-2006 09:44:33 JUN-13-2006 11:34:38        110
       7,715,840 JUN-13-2006 10:44:34 JUN-13-2006 11:34:38         50
       2,077,696 JUN-13-2006 11:32:58 JUN-13-2006 11:34:38          1
             512 JUN-13-2006 11:32:58 JUN-13-2006 11:34:38          1
      88,776,192 JUN-13-2006 12:32:58 JUN-13-2006 13:39:56         66
      25,733,632 JUN-13-2006 13:32:58 JUN-13-2006 13:39:57          6
     687,235,584 JUN-13-2006 14:32:58 JUN-13-2006 16:41:49        128
      10,010,112 JUN-13-2006 15:32:58 JUN-13-2006 16:41:05         68
   1,048,574,976 JUN-13-2006 16:30:14 JUN-13-2006 16:42:46         12
   1,048,572,416 JUN-13-2006 16:33:58 JUN-13-2006 16:42:59          9
   1,048,572,928 JUN-13-2006 16:37:33 JUN-13-2006 16:43:59          6
   1,048,574,976 JUN-13-2006 16:41:21 JUN-13-2006 16:44:15          2
   1,048,572,416 JUN-13-2006 16:46:43 JUN-13-2006 17:07:35         20
   1,048,574,464 JUN-13-2006 16:50:30 JUN-13-2006 17:07:32         17
   1,048,574,464 JUN-13-2006 16:54:28 JUN-13-2006 17:09:16         14
   1,048,574,976 JUN-13-2006 16:58:48 JUN-13-2006 17:08:53         10
   1,048,573,440 JUN-13-2006 17:03:01 JUN-13-2006 17:10:07          7
   1,048,574,976 JUN-13-2006 17:07:40 JUN-13-2006 17:10:16          2

0
6/14/2006 3:20:48 AM
comp.databases.oracle.server 22978 articles. 1 followers. Post Follow

5 Replies
1018 Views

Similar Articles

[PageSpeed] 22

dhoffman0917@yahoo.com wrote:
> Colleagues:
>
> Has anyone experienced lag times after an automatic log switch happens
> and the time the archive log file appears in the archive log directory?
>  I am running Oracle9i (9.2) on Solaris/UNIX.
>
> For additional information, below are SQL results of time differences
> between when the log switch happened and when the archive log file was
> written to disk.
>
> I welcome all ideas at your earliest convenience on this and thanks in
> advance.
>
> Donna
>
>
>
>            BYTES NEXT_TIME            COMPLETION_TIME             LAG
> ---------------- -------------------- -------------------- ----------
>    1,048,568,320 JUN-13-2006 00:28:20 JUN-13-2006 01:45:54         77
>    1,048,573,440 JUN-13-2006 01:11:11 JUN-13-2006 01:46:27         35
>    1,048,574,976 JUN-13-2006 01:26:43 JUN-13-2006 01:47:06         20
>    1,048,574,976 JUN-13-2006 01:29:18 JUN-13-2006 01:47:40         18
>    1,048,574,976 JUN-13-2006 01:41:32 JUN-13-2006 01:48:12          6
>    1,048,574,976 JUN-13-2006 01:45:54 JUN-13-2006 01:48:28          2
>    1,048,572,928 JUN-13-2006 02:08:46 JUN-13-2006 03:07:04         58
>    1,048,574,976 JUN-13-2006 02:23:27 JUN-13-2006 03:07:50         44
>    1,048,569,856 JUN-13-2006 02:38:10 JUN-13-2006 03:08:19         30
>    1,048,566,784 JUN-13-2006 02:42:02 JUN-13-2006 03:09:01         26
>    1,048,571,392 JUN-13-2006 03:04:52 JUN-13-2006 03:09:33          4
>    1,048,570,368 JUN-13-2006 03:44:33 JUN-13-2006 07:48:41        244
>      347,355,136 JUN-13-2006 04:44:29 JUN-13-2006 07:47:54        183
>        2,733,056 JUN-13-2006 05:44:28 JUN-13-2006 07:47:54        123
>        2,704,896 JUN-13-2006 06:44:28 JUN-13-2006 07:47:54         63
>       45,496,832 JUN-13-2006 07:44:30 JUN-13-2006 07:47:55          3
>        6,064,640 JUN-13-2006 08:44:35 JUN-13-2006 11:34:38        170
>        3,440,128 JUN-13-2006 09:44:33 JUN-13-2006 11:34:38        110
>        7,715,840 JUN-13-2006 10:44:34 JUN-13-2006 11:34:38         50
>        2,077,696 JUN-13-2006 11:32:58 JUN-13-2006 11:34:38          1
>              512 JUN-13-2006 11:32:58 JUN-13-2006 11:34:38          1
>       88,776,192 JUN-13-2006 12:32:58 JUN-13-2006 13:39:56         66
>       25,733,632 JUN-13-2006 13:32:58 JUN-13-2006 13:39:57          6
>      687,235,584 JUN-13-2006 14:32:58 JUN-13-2006 16:41:49        128
>       10,010,112 JUN-13-2006 15:32:58 JUN-13-2006 16:41:05         68
>    1,048,574,976 JUN-13-2006 16:30:14 JUN-13-2006 16:42:46         12
>    1,048,572,416 JUN-13-2006 16:33:58 JUN-13-2006 16:42:59          9
>    1,048,572,928 JUN-13-2006 16:37:33 JUN-13-2006 16:43:59          6
>    1,048,574,976 JUN-13-2006 16:41:21 JUN-13-2006 16:44:15          2
>    1,048,572,416 JUN-13-2006 16:46:43 JUN-13-2006 17:07:35         20
>    1,048,574,464 JUN-13-2006 16:50:30 JUN-13-2006 17:07:32         17
>    1,048,574,464 JUN-13-2006 16:54:28 JUN-13-2006 17:09:16         14
>    1,048,574,976 JUN-13-2006 16:58:48 JUN-13-2006 17:08:53         10
>    1,048,573,440 JUN-13-2006 17:03:01 JUN-13-2006 17:10:07          7
>    1,048,574,976 JUN-13-2006 17:07:40 JUN-13-2006 17:10:16          2

Hi Donna,

That may extraordinarily slow I/O, would be my guess.  On what kind of
devices are the archived redo logs stored?  Trace the archiver process
to what waits it is experiencing and post back.

Regards,

Steve

0
stevedhoward (759)
6/14/2006 3:34:07 PM
dhoffman0917@yahoo.com wrote:
> Colleagues:
>
> Has anyone experienced lag times after an automatic log switch happens
> and the time the archive log file appears in the archive log directory?
>  I am running Oracle9i (9.2) on Solaris/UNIX.

You are likely experiencing I/O contention during times of high
transaction activity.  You are generating a gigabyte of logs every 4
minutes.  Those logs are being copied by the archiver and taking up to
an hour to do so.  Oracle is probably starting up additional archiving
processes to handle the load.  Each log switch requires a checkpoint -
perhaps they are colliding with each other as one starts before the
previous finishes.  So I would start by looking at these things:

How many archiver processes are there?  How active are they?  Run top
and see what it thinks.  Is the checkpoint process going bonkers?
cpu's maxed out?  How many cpu's and what sort of disk do you have,
anyways?
What is the system waiting on?  Look at the wait tables for a clue.  If
you have OEM, there are a couple of very interesting displays.  In
particular, see if your log buffers are having fits.  How big are your
log buffers?
Have you considered having more redo logs?  Some might think a switch
every few minutes to be excessive.
How big is your SGA?  While it is less of a big deal than in times
past, at your transaction volume you may be dealing with the checkpoint
trying to clean up hot blocks and just not being able to do it in time.
 Do you have hot blocks?
What sort of file system/controller are your archives going through?  A
gross configuration error would be if they are on RAID-5 and I/O is
colliding with, say, undo files.  Archiving logs is a serial
write-intensive process and the device they are going to should reflect
that.  If you have your redo and archiving on the same controller that
could make the archiver feel like it is going up the crowded down
escalator.
Are there any messages in the alert log?  Checkpoint not complete,
perhaps?
Are you using a journalled file system?  SAME?
Is your code stupid?  Sometimes huge redo can be generated for no good
reason and some simple fixes make all the difference.
What kind of backups do you use?  Tablespaces left in hot backup (not
RMAN) can generate "excessive" redo.
Are you loading data during these heavy times?  Steps can be taken to
reduce that, for example, you can load the data unrecoverably then take
a backup afterwards.  I mean, 1-3AM and after 4:30PM what are you
really doing... if you are loading data while taking hot backups,
ooooops.

As you can see, such a symptom can range from simple not-enough-redo to
advanced dba work to sysadmin issues.  Just throwing hardware at it
wouldn't be smart.

It is also important to give exact versions of everything.

>
> For additional information, below are SQL results of time differences
> between when the log switch happened and when the archive log file was
> written to disk.
>
> I welcome all ideas at your earliest convenience on this and thanks in
> advance.
>
> Donna
>
>
>
>            BYTES NEXT_TIME            COMPLETION_TIME             LAG
> ---------------- -------------------- -------------------- ----------
>    1,048,568,320 JUN-13-2006 00:28:20 JUN-13-2006 01:45:54         77
>    1,048,573,440 JUN-13-2006 01:11:11 JUN-13-2006 01:46:27         35
>    1,048,574,976 JUN-13-2006 01:26:43 JUN-13-2006 01:47:06         20
>    1,048,574,976 JUN-13-2006 01:29:18 JUN-13-2006 01:47:40         18
>    1,048,574,976 JUN-13-2006 01:41:32 JUN-13-2006 01:48:12          6
>    1,048,574,976 JUN-13-2006 01:45:54 JUN-13-2006 01:48:28          2
>    1,048,572,928 JUN-13-2006 02:08:46 JUN-13-2006 03:07:04         58
>    1,048,574,976 JUN-13-2006 02:23:27 JUN-13-2006 03:07:50         44
>    1,048,569,856 JUN-13-2006 02:38:10 JUN-13-2006 03:08:19         30
>    1,048,566,784 JUN-13-2006 02:42:02 JUN-13-2006 03:09:01         26
>    1,048,571,392 JUN-13-2006 03:04:52 JUN-13-2006 03:09:33          4
>    1,048,570,368 JUN-13-2006 03:44:33 JUN-13-2006 07:48:41        244
>      347,355,136 JUN-13-2006 04:44:29 JUN-13-2006 07:47:54        183
>        2,733,056 JUN-13-2006 05:44:28 JUN-13-2006 07:47:54        123
>        2,704,896 JUN-13-2006 06:44:28 JUN-13-2006 07:47:54         63
>       45,496,832 JUN-13-2006 07:44:30 JUN-13-2006 07:47:55          3
>        6,064,640 JUN-13-2006 08:44:35 JUN-13-2006 11:34:38        170
>        3,440,128 JUN-13-2006 09:44:33 JUN-13-2006 11:34:38        110
>        7,715,840 JUN-13-2006 10:44:34 JUN-13-2006 11:34:38         50
>        2,077,696 JUN-13-2006 11:32:58 JUN-13-2006 11:34:38          1
>              512 JUN-13-2006 11:32:58 JUN-13-2006 11:34:38          1
>       88,776,192 JUN-13-2006 12:32:58 JUN-13-2006 13:39:56         66
>       25,733,632 JUN-13-2006 13:32:58 JUN-13-2006 13:39:57          6
>      687,235,584 JUN-13-2006 14:32:58 JUN-13-2006 16:41:49        128
>       10,010,112 JUN-13-2006 15:32:58 JUN-13-2006 16:41:05         68
>    1,048,574,976 JUN-13-2006 16:30:14 JUN-13-2006 16:42:46         12
>    1,048,572,416 JUN-13-2006 16:33:58 JUN-13-2006 16:42:59          9
>    1,048,572,928 JUN-13-2006 16:37:33 JUN-13-2006 16:43:59          6
>    1,048,574,976 JUN-13-2006 16:41:21 JUN-13-2006 16:44:15          2
>    1,048,572,416 JUN-13-2006 16:46:43 JUN-13-2006 17:07:35         20
>    1,048,574,464 JUN-13-2006 16:50:30 JUN-13-2006 17:07:32         17
>    1,048,574,464 JUN-13-2006 16:54:28 JUN-13-2006 17:09:16         14
>    1,048,574,976 JUN-13-2006 16:58:48 JUN-13-2006 17:08:53         10
>    1,048,573,440 JUN-13-2006 17:03:01 JUN-13-2006 17:10:07          7
>    1,048,574,976 JUN-13-2006 17:07:40 JUN-13-2006 17:10:16          2

jg
--
@home.com is bogus.
"You guys f--- it up.  Stop covering your a-- and figure it out."
US Representative Bob Filner to Veterans Administration officials in
public news conference.

0
joel-garry (4553)
6/14/2006 9:58:34 PM
Steve,

Thanks very much for your thoughts.  I suspected it was an I/O problem
as well but the problem is recently due to a very large data migration
project that is happening.  The storage system is an EMC with dedicated
drives for REDO and ARCHIVE logs.  I will check the waits closer.

Thanks again.

Steve Howard wrote:
> dhoffman0917@yahoo.com wrote:
> > Colleagues:
> >
> > Has anyone experienced lag times after an automatic log switch happens
> > and the time the archive log file appears in the archive log directory?
> >  I am running Oracle9i (9.2) on Solaris/UNIX.
> >
> > For additional information, below are SQL results of time differences
> > between when the log switch happened and when the archive log file was
> > written to disk.
> >
> > I welcome all ideas at your earliest convenience on this and thanks in
> > advance.
> >
> > Donna
> >
> >
> >
> >            BYTES NEXT_TIME            COMPLETION_TIME             LAG
> > ---------------- -------------------- -------------------- ----------
> >    1,048,568,320 JUN-13-2006 00:28:20 JUN-13-2006 01:45:54         77
> >    1,048,573,440 JUN-13-2006 01:11:11 JUN-13-2006 01:46:27         35
> >    1,048,574,976 JUN-13-2006 01:26:43 JUN-13-2006 01:47:06         20
> >    1,048,574,976 JUN-13-2006 01:29:18 JUN-13-2006 01:47:40         18
> >    1,048,574,976 JUN-13-2006 01:41:32 JUN-13-2006 01:48:12          6
> >    1,048,574,976 JUN-13-2006 01:45:54 JUN-13-2006 01:48:28          2
> >    1,048,572,928 JUN-13-2006 02:08:46 JUN-13-2006 03:07:04         58
> >    1,048,574,976 JUN-13-2006 02:23:27 JUN-13-2006 03:07:50         44
> >    1,048,569,856 JUN-13-2006 02:38:10 JUN-13-2006 03:08:19         30
> >    1,048,566,784 JUN-13-2006 02:42:02 JUN-13-2006 03:09:01         26
> >    1,048,571,392 JUN-13-2006 03:04:52 JUN-13-2006 03:09:33          4
> >    1,048,570,368 JUN-13-2006 03:44:33 JUN-13-2006 07:48:41        244
> >      347,355,136 JUN-13-2006 04:44:29 JUN-13-2006 07:47:54        183
> >        2,733,056 JUN-13-2006 05:44:28 JUN-13-2006 07:47:54        123
> >        2,704,896 JUN-13-2006 06:44:28 JUN-13-2006 07:47:54         63
> >       45,496,832 JUN-13-2006 07:44:30 JUN-13-2006 07:47:55          3
> >        6,064,640 JUN-13-2006 08:44:35 JUN-13-2006 11:34:38        170
> >        3,440,128 JUN-13-2006 09:44:33 JUN-13-2006 11:34:38        110
> >        7,715,840 JUN-13-2006 10:44:34 JUN-13-2006 11:34:38         50
> >        2,077,696 JUN-13-2006 11:32:58 JUN-13-2006 11:34:38          1
> >              512 JUN-13-2006 11:32:58 JUN-13-2006 11:34:38          1
> >       88,776,192 JUN-13-2006 12:32:58 JUN-13-2006 13:39:56         66
> >       25,733,632 JUN-13-2006 13:32:58 JUN-13-2006 13:39:57          6
> >      687,235,584 JUN-13-2006 14:32:58 JUN-13-2006 16:41:49        128
> >       10,010,112 JUN-13-2006 15:32:58 JUN-13-2006 16:41:05         68
> >    1,048,574,976 JUN-13-2006 16:30:14 JUN-13-2006 16:42:46         12
> >    1,048,572,416 JUN-13-2006 16:33:58 JUN-13-2006 16:42:59          9
> >    1,048,572,928 JUN-13-2006 16:37:33 JUN-13-2006 16:43:59          6
> >    1,048,574,976 JUN-13-2006 16:41:21 JUN-13-2006 16:44:15          2
> >    1,048,572,416 JUN-13-2006 16:46:43 JUN-13-2006 17:07:35         20
> >    1,048,574,464 JUN-13-2006 16:50:30 JUN-13-2006 17:07:32         17
> >    1,048,574,464 JUN-13-2006 16:54:28 JUN-13-2006 17:09:16         14
> >    1,048,574,976 JUN-13-2006 16:58:48 JUN-13-2006 17:08:53         10
> >    1,048,573,440 JUN-13-2006 17:03:01 JUN-13-2006 17:10:07          7
> >    1,048,574,976 JUN-13-2006 17:07:40 JUN-13-2006 17:10:16          2
>
> Hi Donna,
>
> That may extraordinarily slow I/O, would be my guess.  On what kind of
> devices are the archived redo logs stored?  Trace the archiver process
> to what waits it is experiencing and post back.
> 
> Regards,
> 
> Steve

0
6/15/2006 1:38:57 AM
Joel,

Thanks for your tips.  My first thoughts were an archiver that can no
longer keep up with the demand.  I will check for hot spots during high
volume processing and repost.

Thanks again.
joel garry wrote:
> dhoffman0917@yahoo.com wrote:
> > Colleagues:
> >
> > Has anyone experienced lag times after an automatic log switch happens
> > and the time the archive log file appears in the archive log directory?
> >  I am running Oracle9i (9.2) on Solaris/UNIX.
>
> You are likely experiencing I/O contention during times of high
> transaction activity.  You are generating a gigabyte of logs every 4
> minutes.  Those logs are being copied by the archiver and taking up to
> an hour to do so.  Oracle is probably starting up additional archiving
> processes to handle the load.  Each log switch requires a checkpoint -
> perhaps they are colliding with each other as one starts before the
> previous finishes.  So I would start by looking at these things:
>
> How many archiver processes are there?  How active are they?  Run top
> and see what it thinks.  Is the checkpoint process going bonkers?
> cpu's maxed out?  How many cpu's and what sort of disk do you have,
> anyways?
> What is the system waiting on?  Look at the wait tables for a clue.  If
> you have OEM, there are a couple of very interesting displays.  In
> particular, see if your log buffers are having fits.  How big are your
> log buffers?
> Have you considered having more redo logs?  Some might think a switch
> every few minutes to be excessive.
> How big is your SGA?  While it is less of a big deal than in times
> past, at your transaction volume you may be dealing with the checkpoint
> trying to clean up hot blocks and just not being able to do it in time.
>  Do you have hot blocks?
> What sort of file system/controller are your archives going through?  A
> gross configuration error would be if they are on RAID-5 and I/O is
> colliding with, say, undo files.  Archiving logs is a serial
> write-intensive process and the device they are going to should reflect
> that.  If you have your redo and archiving on the same controller that
> could make the archiver feel like it is going up the crowded down
> escalator.
> Are there any messages in the alert log?  Checkpoint not complete,
> perhaps?
> Are you using a journalled file system?  SAME?
> Is your code stupid?  Sometimes huge redo can be generated for no good
> reason and some simple fixes make all the difference.
> What kind of backups do you use?  Tablespaces left in hot backup (not
> RMAN) can generate "excessive" redo.
> Are you loading data during these heavy times?  Steps can be taken to
> reduce that, for example, you can load the data unrecoverably then take
> a backup afterwards.  I mean, 1-3AM and after 4:30PM what are you
> really doing... if you are loading data while taking hot backups,
> ooooops.
>
> As you can see, such a symptom can range from simple not-enough-redo to
> advanced dba work to sysadmin issues.  Just throwing hardware at it
> wouldn't be smart.
>
> It is also important to give exact versions of everything.
>
> >
> > For additional information, below are SQL results of time differences
> > between when the log switch happened and when the archive log file was
> > written to disk.
> >
> > I welcome all ideas at your earliest convenience on this and thanks in
> > advance.
> >
> > Donna
> >
> >
> >
> >            BYTES NEXT_TIME            COMPLETION_TIME             LAG
> > ---------------- -------------------- -------------------- ----------
> >    1,048,568,320 JUN-13-2006 00:28:20 JUN-13-2006 01:45:54         77
> >    1,048,573,440 JUN-13-2006 01:11:11 JUN-13-2006 01:46:27         35
> >    1,048,574,976 JUN-13-2006 01:26:43 JUN-13-2006 01:47:06         20
> >    1,048,574,976 JUN-13-2006 01:29:18 JUN-13-2006 01:47:40         18
> >    1,048,574,976 JUN-13-2006 01:41:32 JUN-13-2006 01:48:12          6
> >    1,048,574,976 JUN-13-2006 01:45:54 JUN-13-2006 01:48:28          2
> >    1,048,572,928 JUN-13-2006 02:08:46 JUN-13-2006 03:07:04         58
> >    1,048,574,976 JUN-13-2006 02:23:27 JUN-13-2006 03:07:50         44
> >    1,048,569,856 JUN-13-2006 02:38:10 JUN-13-2006 03:08:19         30
> >    1,048,566,784 JUN-13-2006 02:42:02 JUN-13-2006 03:09:01         26
> >    1,048,571,392 JUN-13-2006 03:04:52 JUN-13-2006 03:09:33          4
> >    1,048,570,368 JUN-13-2006 03:44:33 JUN-13-2006 07:48:41        244
> >      347,355,136 JUN-13-2006 04:44:29 JUN-13-2006 07:47:54        183
> >        2,733,056 JUN-13-2006 05:44:28 JUN-13-2006 07:47:54        123
> >        2,704,896 JUN-13-2006 06:44:28 JUN-13-2006 07:47:54         63
> >       45,496,832 JUN-13-2006 07:44:30 JUN-13-2006 07:47:55          3
> >        6,064,640 JUN-13-2006 08:44:35 JUN-13-2006 11:34:38        170
> >        3,440,128 JUN-13-2006 09:44:33 JUN-13-2006 11:34:38        110
> >        7,715,840 JUN-13-2006 10:44:34 JUN-13-2006 11:34:38         50
> >        2,077,696 JUN-13-2006 11:32:58 JUN-13-2006 11:34:38          1
> >              512 JUN-13-2006 11:32:58 JUN-13-2006 11:34:38          1
> >       88,776,192 JUN-13-2006 12:32:58 JUN-13-2006 13:39:56         66
> >       25,733,632 JUN-13-2006 13:32:58 JUN-13-2006 13:39:57          6
> >      687,235,584 JUN-13-2006 14:32:58 JUN-13-2006 16:41:49        128
> >       10,010,112 JUN-13-2006 15:32:58 JUN-13-2006 16:41:05         68
> >    1,048,574,976 JUN-13-2006 16:30:14 JUN-13-2006 16:42:46         12
> >    1,048,572,416 JUN-13-2006 16:33:58 JUN-13-2006 16:42:59          9
> >    1,048,572,928 JUN-13-2006 16:37:33 JUN-13-2006 16:43:59          6
> >    1,048,574,976 JUN-13-2006 16:41:21 JUN-13-2006 16:44:15          2
> >    1,048,572,416 JUN-13-2006 16:46:43 JUN-13-2006 17:07:35         20
> >    1,048,574,464 JUN-13-2006 16:50:30 JUN-13-2006 17:07:32         17
> >    1,048,574,464 JUN-13-2006 16:54:28 JUN-13-2006 17:09:16         14
> >    1,048,574,976 JUN-13-2006 16:58:48 JUN-13-2006 17:08:53         10
> >    1,048,573,440 JUN-13-2006 17:03:01 JUN-13-2006 17:10:07          7
> >    1,048,574,976 JUN-13-2006 17:07:40 JUN-13-2006 17:10:16          2
>
> jg
> --
> @home.com is bogus.
> "You guys f--- it up.  Stop covering your a-- and figure it out."
> US Representative Bob Filner to Veterans Administration officials in
> public news conference.

0
6/15/2006 1:43:25 AM
dhoffman0917@yahoo.com wrote:
> Joel,
>
> Thanks for your tips.  My first thoughts were an archiver that can no
> longer keep up with the demand.  I will check for hot spots during high
> volume processing and repost.
>
> Thanks again.

Another thought now that we know you are using EMC:  Are you using
mirroring to backup on the EMC, then perhaps breaking and resilvering
in the early morning hours?  That might explain such an egregious I/O
delay...

I'm sure some lurkers would like to know if you are using a particular
version of Solaris and what sort of I/O options you are using.

jg
--
@home.com is bogus.
"Next time I'll use a different needle." - President Bush, apologizing
for needling a reporter about wearing sunglasses.  The reporter has
macular degeneration.

0
joel-garry (4553)
6/15/2006 2:00:17 PM
Reply:

Similar Artilces:

Archive logs files accumulating on my Oracle log mode Database
>From what I understand is that an Oracle log mode Database is the recommended configuration for a production database. However, the problem we have is that Archive Logs files in the ..\RDBMS\ directory are accumulating daily which has implications when you have limited disk space. How should these Archive log files be maintained? ie when should they be deleted from the system? is there an automated procedure which will remove the log files on a weekly basis? I understand that there are two ways for performing a backup of the oracle database, 1) cold backup (requires the oracle database to be shutdown) 2) hot backup Should either of the above backup procedures automatically remove the archive log files once backup has been completed? Thanks in advance. James Osso wrote: >>From what I understand is that an Oracle log mode Database is the > recommended configuration for a production database. However, the Not for all production systems... Data ware houses usually are easier rebuilt than restored. Of course, apply common sense and *your* requirements. > problem we have is that Archive Logs files in the ..\RDBMS\ directory You can configure that - pfile, or spfile - depending on version. > are accumulating daily which has implications when you have limited > disk space. > > How should these Archive log files be maintained? ie when should they > be deleted from the system? is there an automated procedure which will > remove the log file...

Very high 'log file sync' wait time with no 'log file parallel write' wait time
Oracle 10.2.0.2 SE on Windows 2003 SP1 The following trace file section is from a very slow import session which is importing 9 Million rows into the database. COMMIT call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 0 0.00 0.00 0 0 0 0 Execute 179802 4.90 474.73 0 0 0 0 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 179802 4.90 474.73 0 0 0 0 Misses in library cache during parse: 0 Parsing user id: 21 (recursive depth: 1) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ log file sync 179077 0.53 468.19 ******************************************************************************** ***Snipped*** ******************************************************************************** OVERALL TOTALS FOR ALL NON-RECURSIVE STATEMENTS call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 0 0.00 ...

Oracle database instance shutdown without logging in log file
oracle database instance shutdown without logging in log file. we have Oracle 10g(10.2.0.1)(HP DL380) databse server from Windows 2003 R2 for test/simulation purpose, we found that its shutting down the database sometimes unusally without any error/warning message in the SID alert log file. we observerd that the OS service for oracle is not starting the datbase server completely. Just after hitting start icon inside the services panel it displays the status "Starting", instead of "Started" and database is not in the "Open" state. So the method adopted to start the database from services as well using the "Startup" command from server manager utility. Why does this happen? On Apr 17, 12:19 pm, 7guru <7...@naver.com> wrote: > oracle database instance shutdown without logging in log file. > > we have Oracle 10g(10.2.0.1)(HP DL380) databse server from Windows > 2003 R2 for test/simulation purpose, > we found that its shutting down the database sometimes unusally > without any error/warning message in the SID alert log file. > > we observerd that the OS service for oracle is not starting the > datbase server completely. > Just after hitting start icon inside the services panel it displays > the status "Starting", instead of "Started" > and database is not in the "Open" state. > > So the method adopted to start the database from services as well > using t...

Restore of database file and log file
Hi, I have a Sybase Adaptive Server Anywhere 7 database running. I have a database file that is dated june 12, 2003 I have the database log file from yesterday. The backupsoftware have not backed up the database file since june 12 because it did not back up open files. So, can i merge my database file frome june 12 and my logfile from yesterday and have all the changes since june 12 committed ? If, so how do i do it ? Can't see any tools in the Sybase Central that can help me out... This is a library database and my librarian is not happy at the moment..... Hiya, If the transaction log has not been truncated since, I'd say you can apply the log file. Otherwise you can force the log using dbtran and translate it to SQL and apply the SQL to the database. This is a bit risky, you may miss a lot of transactions since the last checkpoint until the time this log got created. Cheers, Willy -- Posted via http://dbforums.com ...

Choosing log file destination in logging configuration file
Hey, I have a sort of petty-neurotic question, I'm kinda pedantic and like to keep my log directories clean, and this thing is bothering me to the point of actually posting a question (couldn't find any post about this..). My application has two types of components: daemons and regular ones that are run every on crontab. Because the log structure is very similar, I want both to use the same logging configuration file. For clarity, I want all of the files to have the date as part of the filename. The TimedRotatingFileHandler has it built in (once it rotates), and I found a dirty hack...

log file sync , log file parallel write
Hi , my top wait list shows 2 events , log file sync and log file parallel write in 1 hour. During this time , the db server created 370,594 bytes redo per second. the docs say that high value of both log file sync and log file parallel write indicates io problem . How can we decide whether below numbers are close to each other or not? If it is not possible to change the application and eliminate the unnecessary commits (such as sap) , how can lg file sync be decreased? Kind Regards Load Profile ~~~~~~~~~~~~ Per Second Per Transaction --------------- --------------- Redo size: 370,594.95 2,966.21 Logical reads: 39,925.48 319.56 Block changes: 2,447.17 19.59 Physical reads: 67.83 0.54 Physical writes: 433.47 3.47 User calls: 880.52 7.05 Parses: 275.49 2.21 Hard parses: 1.92 0.02 Sorts: 553.98 4.43 Logons: 0.29 0.00 Executes: 5,303.67 42.45 Transactions: 124.94 % Blocks changed per Read: 6.13 Recursive Call %: 89.20 Rollback per transaction %: 0.68 Rows per Sort: 11.52 Instance Efficiency Percentages (Tar...

log file sync vs log file parallel write
Hello all, While investigating performance problems in a database I discovered that the 'log file sync' wait event is almost always in the top 5. (I am looking at the statspack datat) Calculating the ratio of the average wait time of the 'log file sync' and the 'log file parallel write' gives a ratio of 10. Does someone know why this may happen? Regards Hans-Peter On 3 okt, 12:31, HansP <hans-peter.sl...@atosorigin.com> wrote: > Hello all, > > While investigating performance problems in a database I discovered > that the 'log file sync' wait event is almost always in the top 5. > (I am looking at the statspack datat) > > Calculating the ratio of the average wait time of the 'log file sync' > and the 'log file parallel write' =A0gives =A0a ratio of 10. > > Does someone know why this may happen? > > Regards Hans-Peter First of all, 'Log file sync' is associated with commit. If you see this event in the top 5, you are committing way too often (maybe for every individual record) and it is developer beating time!!! They don't know what a transaction is, and they need to be whipped for that. Secondly 'log file parallel write' obviously deals with flushing out the redo log buffer to disk. This means your disks are too slow, or you have an I/O bottleneck. Please note there is plethora of resources on 'log file sync' online, particularly in this very forum. Pl...

Data/Transaction log files for two databases have same file name
We have two db's. One live and one test. When I right click on the live one in SQL Enterprise Manager and select properties -> Data Files -> File Name is LIVE.MDF Location is F:\Data\LIVE.MDF When I right click on the test one in SQL Enterprise Manager and select properties -> Data Files -> File Name is LIVE.MDF Location is F:\Data\TEST.MDF Same thing applies to Transaction log files too. My concern is File Name is same in both the above cases even though the location is different. What are the consequences of this. Thanks for your help GVV Girish (kattukuyil@hotmail.co...

log file sync vs log file parallel write probably not bug 2669566
This is a continuation of a previous thread about =91log file sync=92 and =91log file parallel write=92 events. Version : 9.2.0.8 Platform : Solaris Application : Oracle Apps The number of commits per second ranges between 10 and 30. When querying statspack performance data the calculated average wait time on the event =91log file sync=92 is on average 10 times the wait time for the =91log file parallel write=92 event. Below just 2 samples where the ratio is even about 20. "snap_time" " log file parallel write avg" "log file sync avg" "ratio 11/05/2008 10:38:26 8,142 156,343 19.20 11/05/2008 10:08:23 8,434 201,915 23.94 So the wait time for a =91log file sync=92 is 10 times the wait time for a =91log file parallel write=92. First I thought that I was hitting bug 2669566. But then Jonathan Lewis is blog pointed me to Tanel Poder=92s snapper tool. And I think that it proves that I am NOT hitting this bug. Below is a sample of the output for the log writer. -- End of snap 3 HEAD,SID, SNAPSHOT START ,SECONDS,TYPE,STATISTIC , DELTA, DELTA/SEC, HDELTA, HDELTA/SEC DATA, 4, 20081105 10:35:41, 30, STAT, messages sent , 1712, 57, 1.71k, 57.07 DATA, 4, 20081105 10:35:41, 30, STAT, messages received , 866, 29, 866, 28.87 DATA, 4, 20081105 10:35:41, 30, STAT, background timeouts , 10, 0, ...

LOG FILES inonconfig file
Hi all, I am new to informix. I would like to know how to calculate the rootdbs 1) Is it (Logfiles x log size) + (PHYsical log) + some schemas ? 2) Can i have a small value of Log file log size and physical log during initialization and increase after the initialization by just restarting the server.( i will increase the rootdbs by adding a large chunk from other disk) 3) i have a part of roodbs on one LV (logicalvolume) and other on ther LV and VG also. 4)If i add a new chunk to rootdbs ,do i need to make any change to onconfig file Thanks. doitman wrote: > Hi all, > > I am new to informix. > > I would like to know how to calculate the rootdbs > > 1) Is it (Logfiles x log size) + (PHYsical log) + some schemas? Unless you want to place your logical and physical logs in one or more separate dbspaces - which is recommended BTW - that's about right. If you will be moving the logs after initialization to different dbspaces you only have to allocate space for the initial 6 logical logs and the default physical log. > 2) Can i have a small value of Log file log size and physical log > during initialization and increase after the initialization by just > restarting the server.( i will increase the rootdbs by adding a large > chunk from other disk) Yes, you need a minimum of 3 logical logs in order to initialize the server and the default/sample ONCONFIG file creates six for you if y...

Log Files and Results Files
I am seeking an opinion on what goes in each file in an automated test environment. I have two types of data: 1. Test Execution Outcomes, Case Data Values, etc. i.e. the outcome of the test and enough data to repeat the test. (quite a bit of data) 2. Detailed test execution data that would be used to investigate failures and unexpected incidents but that is not referred to if the tests pass. (Lots and lots of data) I have two files: a. Log file. b. Results file. What data set goes into what file? I am asking to help resolve a "discussion" in the office. Thanks Glenn ...

log file sync vs log file parallel write probably not bug 2669566 #3
This is a continuation of a previous thread about =91log file sync=92 and =91log file parallel write=92 events. Version : 9.2.0.8 Platform : Solaris Application : Oracle Apps The number of commits per second ranges between 10 and 30. When querying statspack performance data the calculated average wait time on the event =91log file sync=92 is on average 10 times the wait time for the =91log file parallel write=92 event. Below just 2 samples where the ratio is even about 20. "snap_time" " log file parallel write avg" "log file sync avg" "ratio 11/05/2008 10:38:26 8,142 156,343 19.20 11/05/2008 10:08:23 8,434 201,915 23.94 So the wait time for a =91log file sync=92 is 10 times the wait time for a =91log file parallel write=92. First I thought that I was hitting bug 2669566. But then Jonathan Lewis is blog pointed me to Tanel Poder=92s snapper tool. And I think that it proves that I am NOT hitting this bug. Below is a sample of the output for the log writer. -- End of snap 3 HEAD,SID, SNAPSHOT START ,SECONDS,TYPE,STATISTIC , DELTA, DELTA/SEC, HDELTA, HDELTA/SEC DATA, 4, 20081105 10:35:41, 30, STAT, messages sent , 1712, 57, 1.71k, 57.07 DATA, 4, 20081105 10:35:41, 30, STAT, messages received , 866, 29, 866, 28.87 DATA, 4, 20081105 10:35:41, 30, STAT, background timeouts , 10, 0, ...

expect-tcl logging with date time stamp on each line of the log file how ???
I have a expect/tcl script which logs into a router and execute some cmds on it. I want to log the expect interaction to a log file, i use log_file -a filename.log to log all of the expect cmds executions. a. with log_file -a, i can log only spwan process, how do i log o/p form "exec" execution? eg: exec bash -c "(ls -al)" in the same log file as filename.log?? b. I want to add date time stamp before start of each log line of filename.log, is there a way to do this setting some options of log_file or any other way to do this ?? -hanu Guys any thoughts ??? no1 is able to gv me a solution ??? :( On Jul 1, 9:32=A0pm, hanu_blr <hanu_...@yahoo.com> wrote: > Guys any thoughts ??? no1 is able to gv me a solution ??? :( ok, this is wat i hv thought.... 1. i start logging using log_file -a file1.log 2. Open a new file say stamp.log 3. read line by line from file1.log and append timestamp: lines of file1.log for each line and write it to stamp.log 4. onces all lines are over, stop writing to stamp.log wat will the script looks like ??? any idea ? ...

log file sync vs log file parallel write probably not bug 2669566 #2
This is a continuation of a previous thread about =91log file sync=92 and =91log file parallel write=92 events. Version : 9.2.0.8 Platform : Solaris Application : Oracle Apps The number of commits per second ranges between 10 and 30. When querying statspack performance data the calculated average wait time on the event =91log file sync=92 is on average 10 times the wait time for the =91log file parallel write=92 event. Below just 2 samples where the ratio is even about 20. "snap_time" " log file parallel write avg" "log file sync avg" "ratio 11/05/2008 10:38:26 8,142 156,343 19.20 11/05/2008 10:08:23 8,434 201,915 23.94 So the wait time for a =91log file sync=92 is 10 times the wait time for a =91log file parallel write=92. First I thought that I was hitting bug 2669566. But then Jonathan Lewis is blog pointed me to Tanel Poder=92s snapper tool. And I think that it proves that I am NOT hitting this bug. Below is a sample of the output for the log writer. -- End of snap 3 HEAD,SID, SNAPSHOT START ,SECONDS,TYPE,STATISTIC , DELTA, DELTA/SEC, HDELTA, HDELTA/SEC DATA, 4, 20081105 10:35:41, 30, STAT, messages sent , 1712, 57, 1.71k, 57.07 DATA, 4, 20081105 10:35:41, 30, STAT, messages received , 866, 29, 866, 28.87 DATA, 4, 20081105 10:35:41, 30, STAT, background timeouts , 10, 0, ...

redo log file on Oracle 11g physical database
Parameter 'LOG_FILE_NAME_CONVERT' definition is: " Specify the location of the primary database online redo log files followed by the standby location. This parameter converts the path names of the primary database log files to the path names on the standby database. If the standby database is on the same system as the primary database or if the directory structure where the log files are located on the standby system is different from the primary system, then this parameter is required. Multiple pairs of paths may be specified by this parameter. " As I understand, if the redo log file directory and file name on physical site are the same as on primary site, I don't have to assign any value to this parameter. For example, if '/redo/redo1.log' is one of the redo log files on primary, at the time I create physical db, I just have to create this redo log file as '/redo/redo1.log' on physical site. Correct? Thanks! ...

Increase in 'log file sync' waits while 'log file parallel write' remains unchanged
We have small 9.2.0.8 database on AIX, from time to time it experiences waits on 'log file sync'. I am unable to explain these waits: - There is no increase in the number or size of transaction - While average wait on 'log file sync' increases from 10ms to 124ms average wait on 'log file parallel write' does not change much - approx 0.05 ms. NORMAL PERIOD: Load Profile ~~~~~~~~~~~~ Per Second Per Transaction --------------- --------------- Redo size: 30,016.82 1,384.01 Logical reads: 10,273.75 473.70 Block changes: 179.17 8.26 Physical reads: 5.36 0.25 Physical writes: 6.98 0.32 User calls: 139.45 6.43 Parses: 152.69 7.04 Hard parses: 0.11 0.01 Sorts: 81.40 3.75 Logons: 0.01 0.00 Executes: 587.69 27.10 Transactions: 21.69 PERIOD WITH WAITS ON LOG FILE SYNC Load Profile ~~~~~~~~~~~~ Per Second Per Transaction --------------- --------------- Redo size: 29,366.27 1,385.22 Logical reads: ...

tailing multiple files in to log file
I have over 60 seporate files that I would like to tail the last 10 lines of and ,erge in to one file. i would like to write a shell script to do this but am having fun knowing where to start. i have looked at the manual for tail and can see that it can do muliple files but will i have to name all of the seporate filenames or could i use a dos like switch of *.txt for these files and then tail the output to the file i want. any help gratefully recived a windowz dos freek ! ! "sally.bridges@gmail.com" <sally.bridges@gmail.com> writes: > I have over 60 seporate files that I would like to tail the last 10 > lines of and ,erge in to one file. > > i would like to write a shell script to do this but am having fun > knowing where to start. > > i have looked at the manual for tail and can see that it can do > muliple files but will i have to name all of the seporate filenames > or could i use a dos like switch of *.txt for these files and then > tail the output to the file i want. any help gratefully recived a > windowz dos freek ! ! Why don't you just try it? You'd find that tail -10 *.txt does exactly what you want. -- M�ns Rullg�rd mru@inprovide.com sally.bridges@gmail.com wrote: > i have looked at the manual for tail and can see that it can do muliple > files but will i have to name all of the seporate filenames or could i > use a dos like switch of *.txt for these files and then tail the output > to...

how to recover/restore a database using archive logs & control files 8i
I deleted a tablespace because it was not needed, now when I start up the instance I get the following; ORA-01113: file 12 needs media recovery If i use the command select * from v$datafiles, I can see the file in online mode, now I just want to rollback to yesterday's state We had a crash last night and I think the oringal datafile locked the system we do not have a back since friday, only an export? Can I use this? E etravels wrote: > I deleted a tablespace because it was not needed, now when I start up > the instance I get the following; > > ORA-01113: file 12 needs media recovery > > If i use the command select * from v$datafiles, I can see the file in > online mode, now I just want to rollback to yesterday's state > > We had a crash last night and I think the oringal datafile locked the > system > > we do not have a back since friday, only an export? Can I use this? > > E You don't say what version of Oracle or what OS you're on. That's critical info. You say you 'deleted' a tablespace, but it sounds like you simply deleted the OS file that implemented tha tablespace. Did you actually issue a DROP TABLESPACE command? That's also critical info. Until we know exactly what you did, and on what system, we'd just be guessing. E, your post is not very clear For starters what version of Oracle are you working with. If you are on 10g and have a flashback database area configured then ...

Writing a log file from an obey file
In message <51a5dbfe09news*@Torrens.org.uk> "Richard Torrens (News)" <News+15019@Torrens.org.uk> wrote: > Lua looks attractive, but it's a long learning curve for a single job! Here is the single job then: Write the following in a text file called "writelog": do local var,logfile,err = os.getenv,arg[1],"Cannot open " local log = assert(io.open(logfile,"a+"),err..logfile) log:write("\n", var "Sys$Time"," on ",var "Sys$Date","\n", var "cycle_No&...

How do I pick up the TIME a person Logs on to my server and record it in a text file along with their IP address
I am using Clarionet and want to pick up the TIME and IP address and USER NAME when they logon to the server. When one enters their USER ID and PASSWORD I want to know the time associated with that USER ID and IP address. Is this possible? I know that Clarionet has a txt file that records the time and IP address but I need it to do more. Does anyone have suggestions as to how this might be done. Ron Adams globalcd@infowest.com ...

Relationship between Oracle log file size and Oracle performance
hi, Last day, I cleared our Oracle DB server network listener's log file, which is around 1.7GB. After doing that, I found I/O queue size decrease A =A3=CC=A3=CF=A3=D4, = while 'sar 3 5' shows wio keeps be to higher than 65%. The oracle version is 8.1.7 running on HP-UX 11i. I want to tune DB performance further. So, I want to know whether this relationship between Oracle perfromance and network listener log file size ? Is there any relationship between Oracle performance and redo log file size? (Our current redo log file size is 500MB, there are two redo logfile defined, show I try to increase the size to 1GB ? ) each word will be highly appreciated. Joe On Mar 7, 4:56 pm, "jshen....@gmail.com" <jshen....@gmail.com> wrote: > hi, > > Last day, I cleared our Oracle DB server network listener's log > file, which is around 1.7GB. > > After doing that, I found I/O queue size decrease A =A3=CC=A3=CF=A3=D4= , while 'sar > 3 5' shows wio keeps be to higher than 65%. > > The oracle version is 8.1.7 running on HP-UX 11i. > > I want to tune DB performance further. So, I want to know whether > this relationship between Oracle perfromance and network listener log > file size ? Is there any relationship between Oracle performance and > redo log file size? (Our current redo log file size is 500MB, there > are two redo logfile defined, show I try to increase the s...

detach database, attach database without log file
If I detach a database on a server, then attach the database with a single file only using the data file...will I lose any transactions that were in the original log file? There is a debate going on here at work where some people think that during the detach, transactions in the log file are saved to the data file. Thanks! Hi You will not loose any committed transactions. Uncommitted transactions will normally be rolled back rolled back even if you attached the log file!! If this did happen it would be indicated in the SQL Server log file. John "DBA" <kaylisse@yahoo.com> ...

I try to logging data using cRIO NI 9014 . I make binary file on the Host and convert to LVM file on Windows but Time start(s) is not Zero I'don't know why
I can have LVM from binary but I have a problem in time (x value) I want start at time is Zero . I don't know why my program start at time is 0.682647 please help me &nbsp;Thank you very much windows.png: http://forums.ni.com/attachments/ni/170/343516/1/windows.png cRIO NAI.zip: http://forums.ni.com/attachments/ni/170/343516/2/cRIO NAI.zip host.png: http://forums.ni.com/attachments/ni/170/343516/3/host.png I get my data&nbsp;at this picture LVM.PNG: http://forums.ni.com/attachments/ni/170/343807/1/LVM.PNG Hi&nbsp; KNAI, What is the time set to on your cRIO controller?&nbsp; Check out <a href="http://digital.ni.com/public.nsf/allkb/B9D619C68F7D5F5D86257251007E2491?OpenDocument" target="_blank">this knowledge</a>base on how to set you cRIO time and make sure that you are getting the expected results.&nbsp; If so, then we can do more troubleshooting on your code.&nbsp; Thanks.&nbsp; ...

what /var/log/samba log files means?
I'm a newbie with the linux but I somehow connect XP, Mandrake 9.1, router and ADSL coonection, together. Today I was looking something in a var directory and I found something strange. Could you please tell me what means if my /var/log/samba directory is full of log.differentNames files. For example 2005/07/24 21:36:25, 0] smbd/service.c:make_connection(252) hal9000 (213.202.68.119) couldn't find service c$ 2005/07/24 21:36:25, 0] smbd/service.c:make_connection(252) hal9000 (213.202.68.119) couldn't find service c$ 2005/07/24 21:36:25, 0] smbd/service.c:make_connection(252) hal9000 (213.202.68.119) couldn't find service c$ .... Is it unsuccessfull try of attack on my machine? Mario wrote: > I'm a newbie with the linux but I somehow connect XP, Mandrake 9.1, router > and ADSL coonection, together. > Today I was looking something in a var directory and I found something > strange. Could you please tell me what means if my /var/log/samba directory > is full of log.differentNames files. > For example > > 2005/07/24 21:36:25, 0] smbd/service.c:make_connection(252) > hal9000 (213.202.68.119) couldn't find service c$ > 2005/07/24 21:36:25, 0] smbd/service.c:make_connection(252) > hal9000 (213.202.68.119) couldn't find service c$ > 2005/07/24 21:36:25, 0] smbd/service.c:make_connection(252) > hal9000 (213.202.68.119) couldn't find service c$ > ... > > Is it unsuccessfull try of attack o...

Web resources about - Lag Time Between Log File Switch and Archive Log File - comp.databases.oracle.server

Video Appears to Show Trump Campaign Mgr. Grabbing Protester by Shirt Collar
Video posted by a reporter on Twitter today appears to show Donald Trump campaign manager Corey Lewandowski grabbing a protester by the shirt ...

All 62 aboard Dubai airliner killed in crash in southern Russia
Los Angeles Times All 62 aboard Dubai airliner killed in crash in southern Russia Los Angeles Times A Dubai airliner with 62 people on board ...

Trump: ‘No Tougher Gun Laws Than Paris, France’
(Screen Capture) (CNSNews.com) - At a rally in Fountain Hills, Ariz., today, businessman Donald Trump said that Second Amendment must be protected ...

Gawker could still win Hulk Hogan case despite $115 million verdict: legal experts
The $115 million a Florida jury awarded to Hulk Hogan on Friday may seem like a big blow to the website Gawker, but the media company could ultimately ...

Jessica Cain: Bones discovered during search for missing girl who vanished in 1997
Investigators have found skeletal remains in a field located in south Houston, Texas that could possibly belong to Jessica Cain , who vanished ...

The pope is way more popular than you on Instagram
VATICAN CITY — Pope Francis is expanding his presence on social media with an Instagram account. The pontiff, who has more than 26 million followers ...

[VIDEO] Tyga Grabs Kylie Jenner’s Butt: See Their Major Makeout Sesh At Club - Hollywood Life
Get a room, you two! Kylie Jenner and Tyga weren’t shy about getting totally intimate in a club on a Friday night, and Kylie posted the whole ...

Obama Hopes Cuba Visit Can Be Harbinger of Political Change
New York Times Obama Hopes Cuba Visit Can Be Harbinger of Political Change New York Times WASHINGTON — President Obama and his family will ...

Pamela Smart, Gregg Smart: Sizzling Sex Affair Between Teacher, Teen Student On Reelz’ ‘Murder Made Me ...
Pamela Smart, the Winnacunnet High School teacher who allegedly had her teen lover shoot her newlywed husband, Gregg Smart, to death in their ...

The party of Trump v. Merrick Garland
PHOENIX — In a span of about 12 hours, Americans were given definitive evidence that the Republican Party is now in thrall to its most ideologically ...

Resources last updated: 3/20/2016 1:58:10 AM