Hi All,
I need to write a report on the health of a database.
Please send if any of us have a scripts and any report format for the health
of the database.
Thanks in advance
Praveen
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Praveen Sahni
INET: [EMAIL PROTECTED]
man kill
Scott Shafer
San Antonio, TX
210-581-6217
-Original Message-
From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]]
Sent: Wednesday, April 24, 2002 9:29 AM
To: Multiple recipients of list ORACLE-L
Subject: Cronjob
Anyone whom can tell me how to delete a job that is
Waleed,
That's interesting. I just looked at the emc site and
still do not see anything that would lead me to
believe that they support hardware striping except for
the IBM Sequential Data Striping.
This was for the Symetrix 3000, 5000 8000 line.
I would be keenly interested to know as we
Look at the attached email message. There was a thread of discussion about
this a month ago.
Anyway I am going to test it on a small scale in one of my projects.
I was told that 1MB (one track) stripe size is the smallest efficient size
we should have b/c EMC will read 1MB anyway (one track)
Do a search on Google -- you'll find plenty.
-Joe
--- Praveen Sahni [EMAIL PROTECTED] wrote:
Hi All,
I need to write a report on the health of a database.
Please send if any of us have a scripts and any report format for
the health
of the database.
Thanks in advance
Praveen
--
Please
Try this link:
https://powerlink.emc.com/MediumFreq/21110_Symmetrix_3930_5930_Installation_
Manual.pdf
starting from page 155
Waleed
Any views or opinions presented in this email are solely those of the
author and do not necessarily represent those of the company
-Original Message-
crontab -r
...
[EMAIL PROTECTED]
Hello Yechiel,
Not sure what you mean...I was referring to the cache
buffers chains latch in my note NOT the library cache
load lock.
Gaja
--- Yechiel Adar [EMAIL PROTECTED] wrote:
Hello Gaja
I checked the report from YAPP and library cache
load lock accounts
only to 0.75% of the wait
It's interesting that you should have heard that.
My first interpretation of the optimizer_index_cost_adj
was that it was an estimate of the table logical I/O that
would become physical I/O (and ignore the fact that
this was allowed to go above 100%) - which brings
it into line, somewhat, with
Title: RE: Currval and buffer gets
On
HP-UX:
model
= 9000/800/N4000-55OS release level= B.11.11processor count = 8clock
speed = 550
MHzmemory = 16384
Mb
SQL set serveroutput on size
1;SQL @test.sql27 /run time using view x_$dual
in centiseconds=600run time using table dual in
Personally, I think that many folks go a bit overboard when
it comes to checking the health of a database.
These are the things I like to check for:
* is the database up? this is the most important tech check
* status of jobs in DBA_JOBS
* space issues. Will a table be able to extend N times
sqlplus / as sysdba EOF
select 'Database is healthy!!!' from dual;
shutdown abort
prompt 'Database needs Clarinex'
EOF
-Original Message-
From: Praveen Sahni [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 24, 2002 3:24 PM
To: Multiple recipients of list ORACLE-L
Subject: Any
Thats fine for expensive sql...but waits can be a
whole lot more than that...
Agreed. I'm just asking about db file scattered read and db file
sequential read. What's the purpose of using the wait interface to
investigate these two events?
The accounts I've read of drilling down through the
Can you post this script inline as the list strips attachments.
-Original Message-
From: Sergey V Dolgov [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 24, 2002 2:58 AM
To: Multiple recipients of list ORACLE-L
Subject: Re: Memory?
Hello Clinton,
Here is script for
Robert,
Jonathan Lewis posted this security issue last week.
Jared
Freeman, Robert [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
04/24/2002 10:23 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:
crontab -e is bad!
1000 points if you can figure out why.
( guess I'm watching too much 'Whose Line Is It Anyway? )
Jared
Alex [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
04/24/2002 10:07 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L [EMAIL
I'm trying to evaluate tools for pl/sql coding/debugging - main options seem
to be toad, sql navigator (both from quest) and rapid sql (from
embarcadero).
One nice thing I noticed about the embarcadero product is the ability to
debug anonymous blocks . . .but haven't looked seriously into other
I don't remember the rest
Was that because of the water in Tijuana?? :-))
Sorry I missed out on that, but I got otherwise
involved in something.
RF
-Original Message-
Sent: Wednesday, April 24, 2002 3:28 PM
To: Multiple recipients of list ORACLE-L
please
n
One I know was bring a
Ahhh I was at IOUG-A and didn't see itDon't
remember seeing it in the MOUNTAIN (!) of messages
posted here while I was gone...
But anyway, just trying to do my duty as a good
Oracle citizen of the world! :-))
RF
-Original Message-
Sent: Wednesday, April 24, 2002 4:17 PM
To:
Agreed! No arguments there. I am all for designing and
writing scalable code from the starting block and
avoiding wastage of resources. But sometimes the
problem is much more complex. I am sure you have
inherited bad application design or bad code
enough times, and may I add Not by choice. Add to
Hello all,
Again I am sending this to the list because people on the list in the past
have asked me for job leads in Florida. Jared, If this is not welcome,
please let me know.
I was just contacted about a job posting in Boca Raton for a
Peoplesoft/Oracle DBA. Here's the description:
They
On ORACLE 8163/Win2K , I got some interesting results
though...
ONE SESSION ONLY
SYS@ZETA@RSAKTHI
run time using table dual in centiseconds=400
PL/SQL procedure successfully completed.
Elapsed: 00:00:03.75
SYS@ZETA@RSAKTHI
SYS@ZETA@RSAKTHI
TWO CONCURRENT SESSIONS
SYS@ZETA@RSAKTHI/
run time
Title: RE: Cronjob
A wrong keystroke could blow away the entire crontab file by accident. %:|
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 24, 2002 5:19 PM
To: Multiple recipients of list ORACLE-L
Subject: Re: Cronjob
crontab -e is
Hello:
I would like to know if the Oracle Express feature of Financial Function
Calculators
are available with Oracle enterprise Edition 9.0.1.0.0.
If my memory serves me correctly , I think Oracle has incorporated OLAP
services as part of
the 9i database enterprise edition. But I am not
So you wipe out a few jobs in the crontab. Big deal! It just means your
sysadmin has to stay up late explaining my backups and payroll didn't run.
Thank You
Stephen P. Karniotis
Product Architect
Compuware Corporation
Direct: (248) 865-4350
Mobile: (248) 408-2918
Email: [EMAIL PROTECTED]
You'll lose your entire crontab if you do a crontab -e when /var is full?
(I've had this happen to me on HP-UX...)
Marc Cure
Oracle DBA, OCP 8i
-Original Message-
[EMAIL PROTECTED]
Sent: Wednesday, April 24, 2002 5:19 PM
To: Multiple recipients of list ORACLE-L
crontab -e is bad!
love it! - this gets my vote -
-Original Message-
Sent: Wednesday, April 24, 2002 4:58 PM
To: Multiple recipients of list ORACLE-L
sqlplus / as sysdba EOF
select 'Database is healthy!!!' from dual;
shutdown abort
prompt 'Database needs Clarinex'
EOF
-Original Message-
-e Edit the current crontab using the editor specified by the
VISUAL or EDITOR environment variables. The specified editor must
edit the file in place; any editor that unlinks the file and
recreates it cannot be used. After you exit from the editor, the
modified crontab will be installed
If you crontab -e and a job is scheduled to run during the time that you are
editing, then the job doesn't execute while you are editing. No jobs will
execute while you're in crontab -e. Even if you :w your changes. No cronjobs
will execute while the editor is open so don't forget to close that
Greg,
You wrote:
If your goal is to find SQL that does a lot of physical reads, why
not
forget about these two events? Just go to v$sql and sort by
physical reads.
Now you have a comprehensive picture of what's going on.
One of the problems with that is that you assume that 100 I/Os are always
Thanks all who replied to my E-mail.
Right now I am still leaning toward having a centralized monitoring script
running in a admin database because -
1. Ease of administration
2. We don't need anything fancy, don't need application level monitorin, so
the requirements for different databases are
db file scattered read (associated with FULL
table scans) and db file sequential
read (associated with indexed scans)
But see, Tuning 101, p. 35, where a db file sequential read is
investigated and the waits are found to be reads from a *table*.
And other examples elsewhere, where db file
www.evdbt.com/library.htm has a health check script
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Greg Moore
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access /
Jared,
You owe me 1000 points. And I know someone who did a crontab -r (so far from
'e' and yet so close!); lots of fun after that deletion.
I always usecrontab -l crontab.mmdd
Thank you,
Paul Sherman
DBA
voice - 781-501-4143 (office)
fax- 781-278-8341 (office)
email - [EMAIL
-e Edit the current crontab using the editor specified by the
VISUAL or EDITOR environment variables. The specified editor must
edit the file in place; any editor that unlinks the file and
recreates it cannot be used. After you exit from the editor, the
modified crontab will be installed
Come on, Jared, its more fun to:
crontab /dev/null
Scott Shafer
San Antonio, TX
210-581-6217
-Original Message-
From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]]
Sent: Wednesday, April 24, 2002 4:19 PM
To: Multiple recipients of list ORACLE-L
Subject: Re: Cronjob
Let's see, I do recall that changes made with crontab -e aren't always
applied (think this was Solaris 2.5).
[EMAIL PROTECTED] wrote:
crontab -e is bad!
1000 points if you can figure out why.
( guess I'm watching too much 'Whose Line Is It Anyway? )
Jared
Alex [EMAIL PROTECTED]
Hello Seema,
It seems you are trying to run REFRESH every minute (1) instead of very
hour..
Use
start with sysdate next sysdate+ 1/24
Instead of
start with sysdate next sysdate+ 1/(24*60)
HTH
Nikunj
From: Seema Singh [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients
been there done that.
crontab -l /tmp/c.c
vi /tmp/c.c
crontab /tmp/c.c
joe
Marc Cure wrote:
You'll lose your entire crontab if you do a crontab -e when /var is full?
(I've had this happen to me on HP-UX...)
Marc Cure
Oracle DBA, OCP 8i
-Original Message-
[EMAIL PROTECTED]
SORRY
crontab -e
Ivan Llamoca
I see a couple of folks who want to
know how to flush the pool or are looking
for a script to do it automatically.
Shouldn't we be asking what is causing
the behavior that got us to this quandry
in the first place ?
Just a stupid question .. I know !
Peace !
Mike
--
Please see the
no, the Tijuana trip we were very careful not to drink the water (hm,
that left only alcohol!)
I just didn't write them down, was having too much fun just listening
to them
--- Freeman, Robert [EMAIL PROTECTED] wrote:
I don't remember the rest
Was that because of the water in Tijuana??
Hi,
I've tried to load data into a table with a data type number(5,3). For any reason, the system just rounded off the decimal number. It inserted the number 2 into the table instead of 1.5. Please direct me how to fix my problem. Your help is greatly appreciated.
Thanks in advance.
TrangDo You
Friend :
In my opinion, if you will use the ltrim(rtrim(column_char)) , i hope you
solve the problem.
Am i wrong ?
Eriovaldo
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Monday, April 22, 2002 7:12 PM
Is there any overhead (ie. internal
I am in the process of loading some image data, and would like to pack the
data as best I can.
Version 8.1.7.2.0
Locally managed tablespace with a 3Mb extent.
pctfree=1
pctused=95
After I do an analyze table I get the following results
num_rows*avg_row_len=28896420
bytes by segment=34603008
Hi Glenn :
I just finished to do it today.
I just deleted the temp files, and after it the Universal Installer showed
for me the list of products.
Regards
Eriovaldo
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Monday, April 22, 2002 5:51
The naming of these two wait-events is unfortunate in that they are
counter-intuitive. You would normally think that the phrase sequential
implied one thing and the phrase scattered implied the opposite. They do,
but not the way one would guess...
Db file scattered read is the wait-event for
Greg,
As one who has been using the (now (un)officially named) OWI since I read
Anjo's paper in '98, I can speak for its' value. I believe we are
approaching the same problem from two sides, and there is merit for each
approach. The Wait interface provides invaluable information from a
Well, Tim did say he was making a long story short.
scattered reads = multiblock reads which are typically
associated with tablescans, but can be index fast full
scans.
sequential reads = single block reads which are typically
associated with index block reads, table blocks
begin rant -
It's *ALWAYS* a good idea to try to understand the underlying causes, for
any and every situation. Too often people attempt to attack new problems
with the same approach that they used before (or heard some guru advise),
in a different context, in a different environment,
hm, I wonder if someone will do a top 20 Unix mistakes presentation
:)
--- Joe Testa [EMAIL PROTECTED] wrote:
been there done that.
crontab -l /tmp/c.c
vi /tmp/c.c
crontab /tmp/c.c
joe
Marc Cure wrote:
You'll lose your entire crontab if you do a crontab -e when /var is
I've got it on my list of things I'd like to do (i.e. understand
DBMS_STATS.GATHER_SYSTEM_STATS), but I don't see any time to do it anytime
soon. :-(
It makes sense that the use of this procedure should obsolesce both
OPTIMIZER_INDEX_ parameters...
- Original Message -
To: Multiple
Anjo,
You wrote:
The problem in Oracle is that wait events are
not broken down per SQL statement (only on the instance and session level).
There are products that out there that do this for you, but that would be
completely different post ;-)
I'll bite. Which products do
this?
Do
Rachel,
I will be doing some of that on the 'big boat' next week ;) but from the
DBA's viewpoint.
Sounds like a good idea for the next IOUGA (or UKOUG, or both)... :)
Thanks.
- Kirti
-Original Message-
Sent: Wednesday, April 24, 2002 9:18 PM
To: Multiple recipients of list ORACLE-L
I wrote a paper/presentation (entitled SQL Tuning for DBAs) in 1996,
presenting it at several user groups and at Open World Australasia in late
1997. I still have it on my website (www.evdbt.com/library.htm). It
advocated examining the SQL Area on one side (to find bad SQL statements)
and
I think an excellent Oracle kernel enhancement would be to bias in the
LRU scheme against SQL that uses literals, just like the buffer cache
algorithm biases against blocks that are read via full-table scan. Think
about it... What's the likelihood that a SQL statement that's filthy
with literal
Its telling you to stop signing in as sys.
-Original Message-
Dolgov
Sent: Wednesday, April 24, 2002 2:58 AM
To: Multiple recipients of list ORACLE-L
Hello ORACLE-L,
I'm connecting to oracle using TOAD under sys account - all works
well. I can select from sys' tables and views,
Check out Jeff Holt's Why are Oracle's Read Events 'Named Backwards'?
(www.hotsos.com/dnloads/1.Holt2000.02.01-Backwards.pdf) for a
description of why these events are named the way they are.
Cary Millsap
Hotsos Enterprises, Ltd.
[EMAIL PROTECTED]
http://www.hotsos.com
-Original
Hi Bill
Thanks for your reply.
In fact when I try following SQL i get result (few records available in
table DEPT)
select * from dept@softek1
I could not understand the meaning of your statement You can pull the clear
text
password out of sys.link$ for this puspose.. Please clarify and help.
John,
Agreed.
My comments were specifically about two events, db file scattered read and
db file sequential read.
I'm just a beginner at waits, so maybe I don't get it. My understanding is,
all you need to do is three back flips, a few drill downs, interpret P1 and
P2, analyze what STATE
That's what the SA's are for. Restore please. They should have never
let /var get full:-)
-Original Message-
Sent: Wednesday, April 24, 2002 3:09 PM
To: Multiple recipients of list ORACLE-L
You'll lose your entire crontab if you do a crontab -e when /var is full?
(I've had this
Help needed,
what is the difference with these software.
Legato Networker Module for Oracle, separate product which has to be
purchased from Legato.
And then Legato Software coming with Oracle CD.
BR
keijo
__
Ota itsellesi luotettava kotimainen email http://www.jippii.fi/
Tutustu samalla
Dear Gurus,
I'm beginning to get into 'Experimenting' - would like to create a
test-bench, measure statistics, develop benchmarks etc.
Specifically, I would like to develop an area where the cost and
other stats values of executing a statement/transaction can be
measured without being
Yeah, logged in as root from someone else's workstation,
and no one is watching.
Jared
On Wednesday 24 April 2002 15:08, [EMAIL PROTECTED] wrote:
Come on, Jared, its more fun to:
crontab /dev/null
Scott Shafer
San Antonio, TX
210-581-6217
-Original Message-
From:
Well, no, it isn't.
I didn't realize that particular peculiarity of -e.
The problem with crontab -e is that it's too easy to
remove jobs accidentally, with no record of it.
Myself, I use:
co -l crontab.txt
crontab -l test.txt
diff crontab.txt test.txt # proceed if there are no
101 - 165 of 165 matches
Mail list logo
