Re: Solaris 8 Question

2001-07-24 Thread Sam Roberts

This happened to me today: Solaris 5.8
we have a large data load exercise going on and the archive log directory
filled - database stopped of course.
but after I had moved all the archive logs to another location the system
still hung - I tried manual switching of log file ,still hung.
I had to stop and start instance - I was surprised. did I miss something ?

sam


- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Friday, July 20, 2001 2:15 PM


If it's / or /tmp, then yes, your machine could well become unusable
until it gets some free space. If your archive log disk fills, Oracle
will refuse transactions until there is free space. Read the man page
for 'quota' to help you limit the possibility of this. And think about
switching autoextend off.

Cheers,

g


-Original Message-
Sent: Thursday, July 19, 2001 4:10 PM
To: Multiple recipients of list ORACLE-L


Hi all,
A friend of mine is having a problem so I thought I would ask
all of you
experts a quick question.  On a Solaris 8 box running 8.1.7, if a
partition
fills up, will it crash the box?  I know that on NT this is very
possible
depending on pagefile and what file is filling up the partition.  But I
don't know anything about Sun.  Thanks alot:)

Sincerely,
Kevin Kostyszyn
DBA
Dulcian, Inc
www.dulcian.com
[EMAIL PROTECTED]

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Kevin Kostyszyn
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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.com
--
Author: Guy Hammond
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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.com
-- 
Author: Sam Roberts
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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).



Re: Solaris 8 Question

2001-07-24 Thread MHately



Sam,
you may find that you need to issue archive log stop and archive log start
to force the database to start archiving again.
Once it's failed to archive a log it seems to lose heart and give up until you
nudge it. Ironically the ARCHIVER will keep writing to the alert log to say that
it's still trying. But it isn't. No doubt it's a feature.
I've seen this on AIX, HP, Solaris, you name it.

Regards,
Mike Hately



|+
||  Sam Roberts   |
||  rabbit@emirat|
||  es.net.ae|
|||
||  07/24/01 04:05|
||  PM|
||  Please respond|
||  to ORACLE-L   |
|||
|+
  |
  ||
  |   To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]  |
  |   cc: (bcc: Mike Hately/ETECH) |
  |   Subject: Re: Solaris 8 Question  |
  |




This happened to me today: Solaris 5.8
we have a large data load exercise going on and the archive log directory
filled - database stopped of course.
but after I had moved all the archive logs to another location the system
still hung - I tried manual switching of log file ,still hung.
I had to stop and start instance - I was surprised. did I miss something ?

sam







-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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).



Re: Solaris 8 Question

2001-07-24 Thread Richard Ji

You should try to query the archive destination

select * from v$archive_dest

see if it says ERROR

And do

alter system archive log stop followed by alter system archive log start

This will fix the broken archive process.

Richard Ji

 [EMAIL PROTECTED] 07/24/01 11:05AM 
This happened to me today: Solaris 5.8
we have a large data load exercise going on and the archive log directory
filled - database stopped of course.
but after I had moved all the archive logs to another location the system
still hung - I tried manual switching of log file ,still hung.
I had to stop and start instance - I was surprised. did I miss something ?

sam


- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Friday, July 20, 2001 2:15 PM


If it's / or /tmp, then yes, your machine could well become unusable
until it gets some free space. If your archive log disk fills, Oracle
will refuse transactions until there is free space. Read the man page
for 'quota' to help you limit the possibility of this. And think about
switching autoextend off.

Cheers,

g


-Original Message-
Sent: Thursday, July 19, 2001 4:10 PM
To: Multiple recipients of list ORACLE-L


Hi all,
A friend of mine is having a problem so I thought I would ask
all of you
experts a quick question.  On a Solaris 8 box running 8.1.7, if a
partition
fills up, will it crash the box?  I know that on NT this is very
possible
depending on pagefile and what file is filling up the partition.  But I
don't know anything about Sun.  Thanks alot:)

Sincerely,
Kevin Kostyszyn
DBA
Dulcian, Inc
www.dulcian.com 
[EMAIL PROTECTED] 

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com 
--
Author: Kevin Kostyszyn
  INET: [EMAIL PROTECTED] 

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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.com 
--
Author: Guy Hammond
  INET: [EMAIL PROTECTED] 

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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.com 
-- 
Author: Sam Roberts
  INET: [EMAIL PROTECTED] 

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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.com
--
Author: Richard Ji
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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).



RE: Solaris 8 Question

2001-07-20 Thread Guy Hammond

If it's / or /tmp, then yes, your machine could well become unusable
until it gets some free space. If your archive log disk fills, Oracle
will refuse transactions until there is free space. Read the man page
for 'quota' to help you limit the possibility of this. And think about
switching autoextend off.

Cheers,

g


-Original Message-
Sent: Thursday, July 19, 2001 4:10 PM
To: Multiple recipients of list ORACLE-L


Hi all,
A friend of mine is having a problem so I thought I would ask
all of you
experts a quick question.  On a Solaris 8 box running 8.1.7, if a
partition
fills up, will it crash the box?  I know that on NT this is very
possible
depending on pagefile and what file is filling up the partition.  But I
don't know anything about Sun.  Thanks alot:)

Sincerely,
Kevin Kostyszyn
DBA
Dulcian, Inc
www.dulcian.com
[EMAIL PROTECTED]

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Kevin Kostyszyn
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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.com
--
Author: Guy Hammond
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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).



Re: Solaris 8 Question

2001-07-19 Thread Thater, William

Kevin Kostyszyn wrote:
 
 Hi all,
 A friend of mine is having a problem so I thought I would ask all of you
 experts a quick question.  On a Solaris 8 box running 8.1.7, if a partition
 fills up, will it crash the box?  I know that on NT this is very possible

a disk partition or a tablespace partition?

i don't think either will crash the box, but they both will cause oracle
problems.


--
Bill Shrek Thater   Certifiable ORACLE DBA
Telergy, Inc.[EMAIL PROTECTED]
~~
You gotta program like you don't need the money,
You gotta compile like you'll never get hurt,
You gotta run like there's nobody watching,
It's gotta come from the heart if you want it to work.
~~
If a program is useful, it must be changed.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Thater, William
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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).



RE: Solaris 8 Question

2001-07-19 Thread Kevin Kostyszyn

Shrek,
It's a disk partition.
KK

-Original Message-
William
Sent: Thursday, July 19, 2001 11:55 AM
To: Multiple recipients of list ORACLE-L


Kevin Kostyszyn wrote:

 Hi all,
 A friend of mine is having a problem so I thought I would ask all
of you
 experts a quick question.  On a Solaris 8 box running 8.1.7, if a
partition
 fills up, will it crash the box?  I know that on NT this is very possible

a disk partition or a tablespace partition?

i don't think either will crash the box, but they both will cause oracle
problems.


--
Bill Shrek Thater   Certifiable ORACLE DBA
Telergy, Inc.[EMAIL PROTECTED]
~~
You gotta program like you don't need the money,
You gotta compile like you'll never get hurt,
You gotta run like there's nobody watching,
It's gotta come from the heart if you want it to work.
~~
If a program is useful, it must be changed.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Thater, William
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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.com
-- 
Author: Kevin Kostyszyn
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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).



RE: Solaris 8 Question

2001-07-19 Thread Richard Ji

It depends.  If a root partition fills up then it could crash the box.  Otherwise, if 
it's for the database, it might crash the database depends on what's on that partition.
 
HTH
 
Richard Ji

-Original Message-
Sent: Thursday, July 19, 2001 11:55 AM
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]



Kevin Kostyszyn wrote: 
 
 Hi all, 
 A friend of mine is having a problem so I thought I would ask all of you 
 experts a quick question.  On a Solaris 8 box running 8.1.7, if a partition 
 fills up, will it crash the box?  I know that on NT this is very possible 

a disk partition or a tablespace partition? 

i don't think either will crash the box, but they both will cause oracle 
problems. 


   
Bill Shrek Thater   Certifiable ORACLE DBA 
Telergy, Inc.[EMAIL PROTECTED] 
~~ 
You gotta program like you don't need the money, 
You gotta compile like you'll never get hurt, 
You gotta run like there's nobody watching, 
It's gotta come from the heart if you want it to work. 
~~ 
If a program is useful, it must be changed. 
   
Please see the official ORACLE L FAQ: http://www.orafaq.com 
   
Author: Thater, William 
  INET: [EMAIL PROTECTED] 

Fat City Network Services   (858) 538 5051  FAX: (858) 538 5051 
San Diego, California   Public Internet access / Mailing Lists 
 
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.com
--
Author: Richard Ji
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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).



Re: Solaris 8 Question

2001-07-19 Thread Seema Singh

If Database will be running in archived log mode then in most cases oracle 
db crash otherwise Database operation will hang up and user will not able to 
enter any transaction.
-Seema


From: Thater, William [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: Re: Solaris 8 Question
Date: Thu, 19 Jul 2001 07:55:25 -0800

Kevin Kostyszyn wrote:
 
  Hi all,
  A friend of mine is having a problem so I thought I would ask 
all of you
  experts a quick question.  On a Solaris 8 box running 8.1.7, if a 
partition
  fills up, will it crash the box?  I know that on NT this is very 
possible

a disk partition or a tablespace partition?

i don't think either will crash the box, but they both will cause oracle
problems.


--
Bill Shrek Thater   Certifiable ORACLE DBA
Telergy, Inc.[EMAIL PROTECTED]
~~
You gotta program like you don't need the money,
You gotta compile like you'll never get hurt,
You gotta run like there's nobody watching,
It's gotta come from the heart if you want it to work.
~~
If a program is useful, it must be changed.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Thater, William
   INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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).


_
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Seema Singh
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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).



Re: Solaris 8 Question

2001-07-19 Thread Thater, William

Kevin Kostyszyn wrote:
 
 Shrek,
 It's a disk partition.
 KK

OK, if the partition hits 100% then nothing can get written to the
disk.  if it has something like /var/temp on it that's bad.  but i've
had them hit 100% with datafiles on them and the database keep going
because of the way oracle writes out it's datafiles.  not sure of the
details, but it looks to the OS like it's a full file even if it has
empty blocks in it.

if the disk doesn't have anything critical on it, the the box just gives
out errors and keeps going.


--
Bill Shrek  Thater   Certifiable ORACLE DBA
Telergy, Inc[EMAIL PROTECTED]

You gotta program like you don't need the money,
You gotta compile like you'll never get hurt,
You gotta run like there's nobody watching,
It's gotta come from the heart if you want it to work!

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Thater, William
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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).



RE: Solaris 8 Question

2001-07-19 Thread Kevin Kostyszyn

Interesting, sort of the same thing that happens on NT.  Anyway, I am not
sure what is going on at their shop.  Seemingly everything is running fine,
DB, OS, DB in archive log mode, then when they shut it down to do a cold
back up the machine takes a big crap on itself.  I don't know anything about
Sun Solaris or the hardware that they run on, but my guess is that it's an
OS installation problem considering that it's a pretty fresh intall.
KK

-Original Message-
William
Sent: Thursday, July 19, 2001 2:36 PM
To: Multiple recipients of list ORACLE-L


Kevin Kostyszyn wrote:

 Shrek,
 It's a disk partition.
 KK

OK, if the partition hits 100% then nothing can get written to the
disk.  if it has something like /var/temp on it that's bad.  but i've
had them hit 100% with datafiles on them and the database keep going
because of the way oracle writes out it's datafiles.  not sure of the
details, but it looks to the OS like it's a full file even if it has
empty blocks in it.

if the disk doesn't have anything critical on it, the the box just gives
out errors and keeps going.


--
Bill Shrek  Thater   Certifiable ORACLE DBA
Telergy, Inc[EMAIL PROTECTED]

You gotta program like you don't need the money,
You gotta compile like you'll never get hurt,
You gotta run like there's nobody watching,
It's gotta come from the heart if you want it to work!

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Thater, William
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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.com
-- 
Author: Kevin Kostyszyn
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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).



RE: Solaris 8 Question

2001-07-19 Thread Koivu, Lisa
Title: RE: Solaris 8 Question





Seema you are describing a full arclog destination. That isn't a crash. It's just a hung state. Fixing this problem does not require any sort of recovery. It is easy to get out of this situation gracefully. 

Lisa Koivu
Seat Warmer 
Ft. Lauderdale, FL, USA


-Original Message-
From: Seema Singh [SMTP:[EMAIL PROTECTED]]
Sent: Thursday, July 19, 2001 1:30 PM
To: Multiple recipients of list ORACLE-L
Subject: Re: Solaris 8 Question


If Database will be running in archived log mode then in most cases oracle 
db crash otherwise Database operation will hang up and user will not able to 
enter any transaction.
-Seema



From: Thater, William [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: Re: Solaris 8 Question
Date: Thu, 19 Jul 2001 07:55:25 -0800

Kevin Kostyszyn wrote:
 
  Hi all,
  A friend of mine is having a problem so I thought I would ask 
all of you
  experts a quick question. On a Solaris 8 box running 8.1.7, if a 
partition
  fills up, will it crash the box? I know that on NT this is very 
possible

a disk partition or a tablespace partition?

i don't think either will crash the box, but they both will cause oracle
problems.


--
Bill Shrek Thater Certifiable ORACLE DBA
Telergy, Inc. [EMAIL PROTECTED]
~~
You gotta program like you don't need the money,
You gotta compile like you'll never get hurt,
You gotta run like there's nobody watching,
It's gotta come from the heart if you want it to work.
~~
If a program is useful, it must be changed.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Thater, William
 INET: [EMAIL PROTECTED]

Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists

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).



_
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Seema Singh
 INET: [EMAIL PROTECTED]


Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists

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).





Re: Solaris 8 Question

2001-07-19 Thread Ron Rogers

Usually on a Unix system when the file system is created, there is a small percentage 
of space reserved for the root. The disk will fill up and could still function because 
of the space reserved for root. If not taken care of right away the full disk space 
could become a full physical disk and then all bets are off as to the results.
ROR mª¿ªm

 [EMAIL PROTECTED] 07/19/01 02:35PM 
Kevin Kostyszyn wrote:
 
 Shrek,
 It's a disk partition.
 KK

OK, if the partition hits 100% then nothing can get written to the
disk.  if it has something like /var/temp on it that's bad.  but i've
had them hit 100% with datafiles on them and the database keep going
because of the way oracle writes out it's datafiles.  not sure of the
details, but it looks to the OS like it's a full file even if it has
empty blocks in it.

if the disk doesn't have anything critical on it, the the box just gives
out errors and keeps going.


--
Bill Shrek  Thater   Certifiable ORACLE DBA
Telergy, Inc[EMAIL PROTECTED] 

You gotta program like you don't need the money,
You gotta compile like you'll never get hurt,
You gotta run like there's nobody watching,
It's gotta come from the heart if you want it to work!

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com 
-- 
Author: Thater, William
  INET: [EMAIL PROTECTED] 

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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.com
--
Author: Ron Rogers
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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).