[Orca-users] Re: Oracle Stats
Edgard Dapás
edapas at telecompersonal.com.ar
Mon Sep 9 11:03:00 PDT 2002
Hi Adam !!!
I was testing yours script, but I have a problem, When I run the script
I've Got the followin message
# /usr/local/bin/perl /opt/orca-0.26/bin/orca -gifs -o -v /opt/orca-0.26/orcallator/orcallator.cfg
Orca version 0.264 using RRDs version 1.000331 at Mon Sep 9 14:43:14 2002.
Loading state from `/usr/local/rrdtool-1.0.33/orcallator/orca.state'.
Creating orca.gif.
Creating rrdtool.gif.
Finding files and setting up data structures at Mon Sep 9 14:43:15 2002.
/opt/orca-0.26/bin/orca: warning: cannot find date `timestamp' in `/usr/users/oracle/admin/OASIS/userfiles/db_graph.log.20020904'.
1031166118
/opt/orca-0.26/bin/orca: warning: cannot process `/usr/users/oracle/admin/OASIS/userfiles/db_graph.log.20020904'.
/opt/orca-0.26/bin/orca: warning: no first_line for `/usr/users/oracle/admin/OASIS/userfiles/db_graph.log.20020905' yet.
/opt/orca-0.26/bin/orca: warning: cannot process `/usr/users/oracle/admin/OASIS/userfiles/db_graph.log.20020905'.
/opt/orca-0.26/bin/orca: warning: no first_line for `/usr/users/oracle/admin/OASIS/userfiles/db_graph.log.20020906' yet.
/opt/orca-0.26/bin/orca: warning: cannot process `/usr/users/oracle/admin/OASIS/userfiles/db_graph.log.20020906'.
/opt/orca-0.26/bin/orca: warning: cannot find date `timestamp' in `/usr/users/oracle/admin/OASIS/userfiles/db_graph.log.20020907'.
1031393401 36 0 7237643 978 961 489361544 305486 69.9 .8 .4 98.3 4082 3339 99.9 .1 95 833295561
/opt/orca-0.26/bin/orca: warning: cannot process `/usr/users/oracle/admin/OASIS/userfiles/db_graph.log.20020907'.
/opt/orca-0.26/bin/orca: warning: no first_line for `/usr/users/oracle/admin/OASIS/userfiles/db_graph.log.20020908' yet.
/opt/orca-0.26/bin/orca: warning: cannot process `/usr/users/oracle/admin/OASIS/userfiles/db_graph.log.20020908'.
/opt/orca-0.26/bin/orca: warning: cannot find date `timestamp' in `/usr/users/oracle/admin/OASIS/userfiles/db_graph.log.20020909'.
1031540402 18 0 971316 99 95 142243349 17159 66 .4 .1 99.3 178 148 99.9 0 23 162895369
/opt/orca-0.26/bin/orca: warning: cannot process `/usr/users/oracle/admin/OASIS/userfiles/db_graph.log.20020909'.
RSS VSZ %MEM TIME USER PID COMMAND
16784 17576 0.4 1:17 root 18239 /usr/local/bin/perl
Current running time is 1:26 minutes.
Loading new data from group orcallator for ccpi11.
Read 2 data points from `/opt/orca-0.26/orcallator/ccpi11/percol-2002-09-09-003'.
Flushing new data and updating GIFs from ccpi11.
Saving state into `/usr/local/rrdtool-1.0.33/orcallator/orca.state'.
Updating GIFs.
Creating HTML files in `/usr/local/apache/htdocs/'.
RSS VSZ %MEM TIME USER PID COMMAND
36472 44456 0.9 3:02 root 18239 /usr/local/bin/perl
Current running time is 4:15 minutes.
Orca has completed.
I don't Know waht's the problem but I don't have the file
$OUT_FILES/db_metrics_header.txt
Could you send me that file?
Thanks
Adam Levin <alevin at audible.com> con fecha 23/08/2002 09:43:08
Por favor, responda a orca-users at yahoogroups.com
Destinatarios: orca-users at yahoogroups.com
CC:
Asunto: Re: [orca-users] Oracle Stats
On Thu, 22 Aug 2002, markzander61 wrote:
> We would like to start using Orca to monitor our Oracle instances. I
> have looked through the archives here and at orca-discuss and have
> seen people asking how to do this, but haven't seen anything the
> really tells how.
Our database guy wrote a little shell script that writes out some DB
metrics to a log file. I then use that log file in a separate Orca group
called oracle. It contains stuff like user counts, requests, scans, file
i/o, blocking locks, redo waits, fetches, etc. It looks like it's a
continuous counter, but I imagine that with a little script massaging and
some state control, you could do the numbers as incremental rather than
cumulative.
Scripts are attached.
The cron call is:
## ORCA Database Metrics every 5 minutes, 7x24
0,5,10,15,20,25,30,35,40,45,50,55 * * * *
/opt/oracle/admin/OASIS/unix_scripts/db_metrics.sh
The orcallator.cfg stuff is as follows:
group oracle {
find_files /opt/audible/logs/oracle/userfiles/db_graph.log.
\d{4}\d{2}\d{2}
column_description first_line
date_source column_name timestamp
interval 300
reopen 1
}
#users # of users
plot {
title %g Oracle Users
source oracle
data users
legend Users
y_legend Users
}
#locks # Blocking Locks
plot {
title %g Blocking Locks
source oracle
data locks
legend Locks
y_legend Blocking Locks
}
#file_io
plot {
title %g File I/O
source oracle
data file_io
legend File I/O
y_legend File I/O
}
#redo_waits
plot {
title %g Redo Waits
source oracle
data redo_waits
legend Redo Waits
y_legend Redo Waits
}
#retries
plot {
title %g Retries
source oracle
data retries
legend Retries
y_legend Retries
}
#fetches
plot {
title %g Fetches
source oracle
data fetches
legend Fetches
y_legend Fetches
}
#scans
plot {
title %g Scans
source oracle
data scans
legend Scans
y_legend Scans
}
#cursors
plot {
title %g Cursors
source oracle
data cursors
legend Cursors
y_legend Cursors
}
#reloads
plot {
title %g Reloads
source oracle
data reloads
legend Reloads
y_legend Reloads
}
#data_dict
plot {
title %g Data Dictionary
source oracle
data data_dict
legend Data Dictionary
y_legend Data Dictionary
}
#cache_hit
plot {
title %g Cache Hit
source oracle
data cache_hit
legend Cache Hit
y_legend Cache Hit
}
#buffers
plot {
title %g Buffers
source oracle
data buffers
legend Buffers
y_legend Buffers
}
#waits
plot {
title %g Waits
source oracle
data waits
legend Waits
y_legend Waits
}
#lru_hit
plot {
title %g LRU Hits
source oracle
data lru_hit
legend LRU Hits
y_legend LRU Hits
}
#wait_get
plot {
title %g Wait Get
source oracle
data wait_get
legend Wait Get
y_legend Wait Get
}
#undo_waits
plot {
title %g Undo Waits
source oracle
data undo_waits
legend Undo Waits
y_legend Undo Waits
}
#requests
plot {
title %g Requests
source oracle
data requests
legend Requests
y_legend Requests
}
Adam Levin, Senior Unix Systems Administrator | http://www.audible.com/
Audible, Inc.
Wayne, NJ, 07470 All tribal myths are true, for a given
973-837-2797 value of "true".
Yahoo! Groups Sponsor
ADVERTISEMENT
[IMAGE]
(See attached file: db_metrics_change.sh)
(See attached file: db_metrics.sh)
-------------- next part --------------
A non-text attachment was scrubbed...
Name: db_metrics_change.sh
Type: application/octet-stream
Size: 444 bytes
Desc: not available
URL: </pipermail/orca-users/attachments/20020909/a5a3adac/attachment.obj>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: db_metrics.sh
Type: application/octet-stream
Size: 2111 bytes
Desc: not available
URL: </pipermail/orca-users/attachments/20020909/a5a3adac/attachment-0001.obj>
More information about the Orca-users
mailing list