, 2003 6:53
PM
Subject: Database tracking
All, I would like
to track the performance of my production databases by
running the same SQL statement against each database every 5 minutes or
so and recording the results. For example:
sql> set timing
on;
sql> select
Title: RE: Database tracking
Yes.
Stay tuned... about 2-3 months.
-Original Message-From: Leonard, George
[mailto:[EMAIL PROTECTED]]Sent: Friday, January 17, 2003
2:24 AMTo: Multiple recipients of list ORACLE-LSubject:
RE: Database tracking
Are you willing to
Title: RE: Database tracking
Are you willing to share the solution with
us ?
George
George
Leonard
Oracle Database
Administrator
Dimension Data (Pty) Ltd
(Reg. No. 1987/006597/07)
Cell: (+27) 82 655 2466
Tel: (+27 11) 575
0573
cc:
Sent by: Subject: RE: Database tracking
root@fatcity.
Title: RE: Database tracking
I concur, I have used MRTG for this in the past, now I
have an Access database that I connect to via ODBC and get my graphs. They
are very handy for trending and analysis, If someone says I had a problem
yesterday around 3 pm I go look at the charts and I
Title: RE: Database tracking
I concur with the recommendation to use STATSPACK but you might want to augment it. I take STATSPACK snapshots every 15 minutes and if there's a performance problem caused by a few bad queries I can usually isolate the offenders. But constant fined-gr
Title: RE: Database tracking
Steve,
Oh ... we use a nomonitor script ... the resident script-kiddies (aka Unix SAs) love that stuff. But to give you an idea, I am paying T-Mobile $2.99 extra per month so my monthly text message limit is 550 messages. The email goes to my Outlook and phone
Pardon me, but I don't think I have got the full version of what Ethan sent.
(See below..)
Also, when my yesterday's post appeared in the list, the text from 'begin'
onwards was missing.
Is it possible that 'begin' is a keyword for the mail server?
Thanks & regards,
Charu
-Original Message-
at a former employer per damagement direction... we had a perl script named
pageme which was called by our monitoring scripts whenever they detected and
event that required the on-call DBA be paged. the author of pageme had the
forethought to add a nopage feature. it looked for a file called nop
Title: RE: Database tracking
We were thinking of an automated message calling all damager types ... especially in the middle of the night ...
in a very thick voice ... "Hello .. this is your heartbeat calling, we have a problem !!"
As none of us had our résumé's ready
Title: RE: Database tracking
Wow!
That definitely is one simple and elegant
solution, Raj.
I wonder what you call when the alarm goes off,
"heart-broken"? :)
Arup
- Original Message -
From:
Jamadagni, Rajendra
To: Multiple recipients of list ORACLE-L
ha ha, done.
-Original Message-
Sent: Wednesday, January 15, 2003 3:46 PM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Importance: High
The worlds smallest perfmon could be 11 bytes smaller
if you changed 'while true loop' to 'loop'
Jared
--
Please see the official ORACLE-L FAQ:
s of list ORACLE-L <[EMAIL PROTECTED]>
cc:
Subject:RE: Database tracking
-- worlds_smallest_perfmon
--
-- Monitors wait time and logs information to database alert logs.
--
-- p_interval = # of minutes to wait between checks
-- p_alert = # of seconds per minute spent in w
tractor) (DAASC)" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
01/15/2003 09:53 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:
Subject:Database tracking
All, I would like to track the perfor
errian, Tom
(Contractor) To: Multiple recipients
of list ORACLE-L <[EMAIL PROTECTED]>
(DAASC)" cc:
<[EMAIL PROTECTED]Subject: Database tracking
a.mil>
Title: RE: Database tracking
Tom,
This is what we do ...
We have a schema called "heartbeat" ... owns a table called rhythm (one column time_stamp data type date);
1. Using a perl program, we log on to instance, insert a row in the table with value sysdate.
2. Use dbms_lock.slee
Title: Message
Yes I
understand your point. Thanks
-Original Message-From: Mercadante,
Thomas F [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January
15, 2003 3:11 PMTo: '[EMAIL PROTECTED]'Cc:
'[EMAIL PROTECTED]'Subject: RE: Database
tracking
T
a user.
just
my 2 cents but, good luck!
Tom Mercadante Oracle Certified Professional
-Original Message-From: Terrian, Tom (Contractor)
(DAASC) [mailto:[EMAIL PROTECTED]]Sent: Wednesday, January 15,
2003 1:59 PMTo: Multiple recipients of list
ORACLE-LSubject: RE: Database tracking
Ok, thanks
-Original Message-
Sent: Wednesday, January 15, 2003 2:10 PM
To: Multiple recipients of list ORACLE-L
Tom - I'll provide an example of what we do and maybe it will give you some
ideas. On one database, the users have identified a certain process that has
marginal performance a
as
good as another?
-Original Message-From: Jamadagni,
Rajendra [mailto:[EMAIL PROTECTED]] Sent: Wednesday,
January 15, 2003 1:09 PMTo: Multiple recipients of list
ORACLE-LSubject: RE: Database tracking
Statspack ??
cc:
<[EMAIL PROTECTED] Subject: Database tracking
Tom - I'll provide an example of what we do and maybe it will give you some
ideas. On one database, the users have identified a certain process that has
marginal performance at best, and when anything gets out of whack it gets
bad real fast. So the developers have added a logging feature in the
app
ssage-From: Terrian, Tom (Contractor)
(DAASC) [mailto:[EMAIL PROTECTED]]Sent: Wednesday, January 15,
2003 10:54 AMTo: Multiple recipients of list
ORACLE-LSubject: Database tracking
All, I would like
to track the performance of my production databases by
running the same SQL stat
, but
having an opinion is an art!
-Original Message-From: Terrian, Tom (Contractor)
(DAASC) [mailto:[EMAIL PROTECTED]]Sent: Wednesday, January 15,
2003 12:54 PMTo: Multiple recipients of list
ORACLE-LSubject: Database tracking
All, I would like
to track the performance
Title: Message
All, I would like to
track the performance of my production databases by running the same
SQL statement against each database every 5 minutes or so and
recording the results. For example:
sql> set timing
on;
sql> select
count(*) from dba_tables;
That was I would
know if t
25 matches
Mail list logo
