Rafiq,
If we had a slot for you I'd probably recommend you submitting a resume. As
it is we're full up on DBA's. I have not had a major, or minor problem for that
matter, in years. In this company keeping things running smoothly is a recipe for
success. And proactive monitoring is the key.
Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA
-----Original Message-----
Sent: Wednesday, July 02, 2003 5:01 PM
To: Multiple recipients of list ORACLE-L
I totally agree with Dick...The person who si saying not to bother these two
,must be a sleeping DBA waiting for trouble to come and then jump and this
is the right strategy in US market. I lost my job because I kept my
production databases so smooth and trouble free (with proactive
monitoring)that gave impression to my management that I am totally free all
day.
Regards
Rafiq
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Date: Wed, 02 Jul 2003 10:36:16 -0800
Kirti,
I will kinda agree with your Very Senior DBA. Make TEMP an LMT with
uniform extents, of type temp and with a tempfile & your most likely not to
have a problem there that will have any lasting effect. It's one of those
things that you have to accept end user complaints on to determine if there
has been a problem, otherwise the problem clears as fast as it happens.
Now RollBack can get top be a problem if & when you run out of space due to
some LONG running transaction that should have been killed 2 days ago.
Consequently I watch rollback.
Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA
-----Original Message-----
Sent: Wednesday, July 02, 2003 2:16 PM
To: Multiple recipients of list ORACLE-L
After we rolled out our own scripts to monitor TS usage (de-Installing BMC
Patrol) following is a
line from a Very Senior DBA's email sent to us
(not-so-senior-DBA-team-members) yesterday:
"I don't think the script should monitor ROLLBACK or TEMP tablespace for
space issues - these
normally resolve themselves"
(I will surely get in trouble when my co-workers see this post, but what the
heck.. We will get
outsourced soon anyway);) BTW, the VSDBA supports 8.1.7.4 databases.
- Kirti
--- "Goulet, Dick" <[EMAIL PROTECTED]> wrote:
> That's OK, I know a couple who never heard of optimal and/or
"organization index" either.
>
> Dick Goulet
> Senior Oracle DBA
> Oracle Certified 8i DBA
>
> -----Original Message-----
> Sent: Tuesday, July 01, 2003 7:14 PM
> To: Multiple recipients of list ORACLE-L
>
>
> I saw a "Sr. DBA" few years ago, who claimed he had worked with Oracle
since
> V4.0, and he didn't have a clue what PCTINCREASE is...
>
> Tanel.
> ----- Original Message -----
> To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
> Sent: Tuesday, July 01, 2003 11:51 PM
>
>
> > What about ones that you don't know?
> >
> > Mladen Gogala
> > Oracle DBA
> > Phone:(203) 459-6855
> > Email:[EMAIL PROTECTED]
> >
> >
> > -----Original Message-----
> > Sent: Tuesday, July 01, 2003 4:11 PM
> > To: Multiple recipients of list ORACLE-L
> >
> >
> > PCTINCREASE is a bad good thing. Every DBA that I know of hunts down
> > objects with a pctincrease other than 0 and resets them.
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > --
> > Author: Gogala, Mladen
> > INET: [EMAIL PROTECTED]
> >
__________________________________
Do you Yahoo!?
SBC Yahoo! DSL - Now only $29.95 per month!
http://sbc.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Kirtikumar Deshpande
INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Goulet, Dick
INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
_________________________________________________________________
Add photos to your messages with MSN 8. Get 2 months FREE*.
http://join.msn.com/?page=features/featuredemail
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: M Rafiq
INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Goulet, Dick
INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).