, 2003 6:53
PM
Subject: Database tracking
All, I would like
to track the performance of my production databases by
runningthesame SQL statementagainst each database every 5 minutes or
so and recording the results. For example:
sql set timing
on;
sql select
count(*) from
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
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
share
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 .. name this is your heartbeat calling, we have a problem !!
As none of us had our résumé's ready, this idea
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
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
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
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-grained
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 Igo look at the charts and I usually
]
s.net cc:
Sent by: Subject: RE: Database tracking
root@fatcity
Title: Message
All, I would like to
track the performance of my production databases by runningthesame
SQL statementagainst 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 they
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 of my production
: 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
runningthesame SQL statementagainst each
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
:
[EMAIL PROTECTED]Subject: Database tracking
a.mil
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 ??
Raj
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
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
I
guess I
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
Tom,
Hate
to say
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.sleep to sleep
]
(DAASC) cc:
[EMAIL PROTECTED]Subject: Database tracking
a.mil
Sent by:
[EMAIL PROTECTED]
01/15/2003 12:53
PM
) [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 performance of my production databases
]
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 wait that triggers alert
--
-- This code
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:
Title: RE: Database tracking
Wow!
Thatdefinitely 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
25 matches
Mail list logo