date:20010626


Lee,

In my case (please see my previous post on the subject) I had proposed a
change that was rejected.  In short I wanted to move a datafile during a
maintenance down day from one drive to another where there would be more room
for expansion.  OK, so management rejected the change for dumb reasons (did not
want to see IO spread out too far across mount points) and a week or so later
the old cannot extend message appeared at 3AM (when else) with the mount point
at 100% utilization.  The line techs declared a line down situation  I did
what I had wanted earlier, but as an emergency change.  Total down time for the
assembly line was 3 hours at $1000 per minute.  At the post-mortem meeting later
in the day I had a pile of fun rubbing the disapproved change request in
someone's face in front of their management.  Boy do I love it when a damagement
person puts the egg on his/her own face!!!  Can you say change of policy!!

Dick Goulet

Reply Separator
Author: Robertson Lee - lerobe [EMAIL PROTECTED]
Date:   6/26/2001 12:15 AM

Excuse me but you are a little presumptious and rude with that last mail. If
a process is put in place that requires a form to be signed and
authorisation to be given before action can be taken then I would be going
totally against the grain and would get into trouble for not adhering to the
company guidelines (as some of the UNIX S.A's did when they went in and made
changes without filling out the necessary paperwork !!). On the contrary to
your mail, I am a good DBA and I do take pride in my work and prior to the
ridiculous rules that were put in place all work was done proactively and we
never suffered because of it. What the managers (and Quality Team, who had
no bloody idea what their process would do to us) failed to realise was
exactly how well I was doing my job, in that they were never bothered in the
past. Once the mistakes were made and there was reactive form filling
processes for certain things put in place, then things went back to normal.

I think thats whats called a bite on my behalf!!


-Original Message-
Sent: 25 June 2001 18:16
To: Multiple recipients of list ORACLE-L


I say that if you wait until you database has an error you really
aren't proving much except that you are not proactive in your job.
Which, in my book, makes you not a very good DBA.  Dealing with a
dumb process is one thing (we have our fair share on this account) 
but I take to much pride in my work to let things fail because I
need to fill in a piece of paper.

-Original Message-
Sent: Monday, June 25, 2001 9:43 AM
To: Multiple recipients of list ORACLE-L


Wahey !!! The answer I was going to provide. We started calling the manager
up quite frequently at home to authorise changes - he eventually saw sense.
Not quite as bad as 2am in the morning but inconvenient enough for him to
put a stop to it.

Best of Luck.


-Original Message-
Sent: 25 June 2001 17:07
To: Multiple recipients of list ORACLE-L


Jay;
  I have had to go thru the same thing a couple times on a previous job with
Auditors.  Every time those kind of restrictions were placed on us it
brought things to a snails pace or, in some conditions, a complete halt.
Sooner or later they realized that it was unreasonable and lifted them.  But
it was a pain until they did it.

It took them a while to realize that we HAD to work the way we did in order
to keep things running smoothly.

I personally think that you should wait with resizing any of your production
data files until you get oracle errors saying that things can not extend.
At that time, call up the Sr. VP at 2 am in the morning and tell him that
you have a crisis but you can not proceed until you get his permission
because of the restrictions placed on you by the Auditors.   Repeat this
process as many times as neccessary for them to lift the restrictions.

Kevin

-Original Message-
Sent: Monday, June 25, 2001 9:32 AM
To: Multiple recipients of list ORACLE-L


We've been through an internal audit and I was just wondering if anyone else
has to deal with the rather ludicrous requirements I now have.  In order to
add or resize a datafile I now need to fill out a form and get Senior VP
approval and the alert logs must be reviewed every day by a non-DBA in order
to be certain that I didn't make any database changes without such approval.
The auditors were horrified to discover that not only did I do such things
whenever I thought them necessary but that we didn't have a non-DBA review
everything I did after an Oracle upgrade to ensure I didn't install any
other software.
Fortunately I managed to convince them that yes, I really did need a Unix
login (they were skeptical).

So, any similar horror stories?

Jay Miller
Sr. Oracle DBA
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Miller, Jay
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051

RE: which initSID?

2001-06-26 Thread nlzanen1



Hi

I always have my init files in the OFA locations so I'm guessing here.
Isn't the startup command listed in the alertlog if  you use the pfile
command?
Sounds like a good one to be in there.

Jack


   
  
Ravinder_Bahadur@singapore 
  
air.com.sg   To: Multiple recipients of 
list ORACLE-L [EMAIL PROTECTED] 
Sent by: [EMAIL PROTECTED]cc: (bcc: Jack van 
Zanen/nlzanen1/External/MEY/NL)  
 Subject: RE: which initSID?   
  
   
  
26-06-2001 08:25   
  
Please respond to ORACLE-L 
  
   
  
   
  




Well the best way. If you are using a UNIX box. go to the $ORACLE_HOME/bin
and view the file dbstart. Here you will find the locaton of you
initSID.ora file.  This is only true if you use the dbstart for starting
your database or you use the /etc/oratab file to startup the database at
boot up.

Regards

Ravinder



jaimin

jaimin@roltaTo: Multiple recipients of
list ORACLE-L
.com[EMAIL PROTECTED]

Sent by: cc:

root@fatcity.Subject: RE: which initSID?

com



26-Jun-2001

12:05 PM

Please

respond to

ORACLE-L


Sender Info:

No Sender

Info found in

the address

Book







This will not give you solution. As backup of controlfile to trace will not
give initSID.ora file path.

Actually as per my knowledge there is no table which gives path of
initSID.ora file. What you can do is find all init parameter files in your
system. Then check SID part of your filename. If you have any doubt then
also count SGA of each initSID.ora and your database SGA.

This is not 100 percent correct and also seems to be some what tedious but
you can try this for your database.

Regards,
Jaimin.


-Original Message-
Michael (TEM)
Sent: Tuesday, June 26, 2001 3:51 AM
To: Multiple recipients of list ORACLE-L


Can't you do it indirectly with an 'alter database backup controlfile to
trace' command?  I seem to recall that there's a path to the initSID.ora
file there.  'Course, it could be just the generic path...I never tried
changing it to see...

HTH,
Mike

---
===
Michael P. Vergara  | I've got a PBS mind in an MTV world
Oracle DBA  |
Guidant Corporation |


-Original Message-
Sent: Monday, June 25, 2001 2:51 PM
To: Multiple recipients of list ORACLE-L


Seema,
There is no way to find that out.
Unless, the init.ora uses ifile option and the file pointed to by ifile
contains all the parameters. In that case you can query v$parameter view to
see what ifile points to.
By default Oracle looks for it in the $ORACLE_HOME/dbs directory.

HTH,

- Kirti Deshpande
  Verizon Information Services
   http://www.superpages.com

 -Original Message-
 From: Seema Singh [SMTP:[EMAIL PROTECTED]]
 Sent: Monday, June 25, 2001 2:09 PM
 To:   Multiple recipients of list ORACLE-L
 Subject:   which initSID?

 Hi gurus
 How we know which initSID.ora file are in use in running instance if disk
 is
 not designed as OFA?
 Where can I found referenced tables name menas which Data dictionary
 table?
 Thanks
 -Seema

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Vergara, Michael (TEM)
  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

RE: NOLOGGING

2001-06-26 Thread Ramon Estevez


As I am concerned, the only redo information it generates is related
to the system tablespace, the one refering to the manage of the extents.


Ramon Estevez 



*809-565-3121 x 225

 

* [EMAIL PROTECTED]

 



-Mensaje original-
De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]En nombre de Gaja Krishna
Vaidyanatha
Enviado el: Monday, 25 June, 2001 9:10 PM
Para: Multiple recipients of list ORACLE-L
Asunto: RE: NOLOGGING


Ramon,

That is not true. Setting NOLOGGING at the object
level only reduces the amount of redo generated for
bulk INSERT operations with the /*+ APPEND */ hint,
certain partition administration operations and of
course during the creation of the object itself. It
does not eliminate generation of redo during a delete
operation.

Attached is a sample output from a couple of delete
commands, one with LOGGING and the other with
NOLOGGING:

Cheers,

Gaja

--- Ramon Estevez [EMAIL PROTECTED]
wrote:
 Hi Greg,
 
 Yes, you should get a improve performance due to the
 nologging option in the
 delete wont write redo log information.
 
 
 
 Ramsn Estivez
 
 
 
 *809-565-3121 x 225
 
 
 
 * [EMAIL PROTECTED]
 
 
 
 
 
 -Mensaje original-
 De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]En
 nombre de Greg Solomon
 Enviado el: Monday, 25 June, 2001 9:23 AM
 Para: Multiple recipients of list ORACLE-L
 Asunto: NOLOGGING
 
 
 Hi All
 
 If I have a delete which I know I never want to roll
 back, can I get a
 performance gain by using the nologging option ?
 
 Delete nologging is not, to the best of my
 knowledge, documented on 8.1.6
 ... but the query executes OK.
 
 However, when I used autotrace, the delete with
 nologging seemed to give the
 same or worse results than a normal delete.
 
 Greg
 --
 Please see the official ORACLE-L FAQ:
 http://www.orafaq.com
 --
 Author: Greg Solomon
   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: Ramon Estevez
   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).


=
Gaja Krishna Vaidyanatha
Director, Storage Management Products,
Quest Software, Inc.
Co-author - Oracle Performance Tuning 101

__
Do You Yahoo!?
Get personalized email addresses from Yahoo! Mail
http://personal.mail.yahoo.com/

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ramon Estevez
  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[2]: OT RE: 24 x 7 on NT?


HUMM,  Our last unscheduled Unix down was due to the local power utility whereas
the last unscheduled down on NT was due to the Blue screen of death (Ok, so
the screen is Black on 2000).

Reply Separator
Author: Thater; William [EMAIL PROTECTED]
Date:   6/26/2001 5:25 AM

On Mon, 25 Jun 2001,Mohan, Ross scribbled on the wall in glitter crayon:

-I agree with His Chrisness on this one.
-
-If the avg(NT Admin)  avg(Unix Admin), we'd
-all be reading this mail on Window's boxes.
-Er.what I mean to say is..
-
-sly grin
-
-but, in all seriousnesswhen there is a way
-to find a *very good* NT admin out of all the
-Wendy's employees, then NT boxes will be up
-4 or 5 nines, easy.
-
-Besides guys, five nines means you're down
-about FIVE MINUTES a year.
-
-Now, how many of the Unix boxes on this list
-have done that this year?  I bet less than
-one percent.

well, then there must be a whole lot of unix boxes out there because we've got
40 of them right here.  i'd say all of my 32 databases have been up that much
too, but i've only had 25 of them up a whole year.;-)  yup, i know i've been
lucky.

--
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.
~~
Expert systems are built to embody the knowledge of human experts.  - Kulawiec

-- 
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: 
  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: QUERY HELP

2001-06-26 Thread Larry Elkins


Nirmal,

You said I need this in reports. If you mean Oracle Reports, there are a
few ways to do it. If not Oracle Reports, skip down to the SQL part.

1) Create a placeholder column outside query (or use a package variable,
whatever floats your boat).
2) Create a formula column within the group. In it's PL/SQL:
   a) Compare the value against the value in the placeholder and setup the
return value.
   b) Set the placeholder column equal to the current value.
   c) Return the value derived in step a.

Following is example PL/SQL for the formula column where CP_1 is the
placeholder column and STEP is the value we are comparing for gaps:

function CF_1Formula return Char is
  v_out varchar2(2);
begin
  If :CP_1 is not null Then
 If :CP_1  :step-1 Then
v_out := '**';
 else
v_out := null;
 End if;
  End if;
  :CP_1 := :step;
  return(v_out);
end;

There might be a more efficient way to do this in Oracle Reports, but, this
is the first thing that popped to mind.

SQL

A method that avoids a self join.

I try to minimize the number of formula's, frames, etc in Oracle Reports.
So, an alternative method using pure (Oracle's) SQL, if on 8.1.6 or higher,
would be to use LAG analytical function. This will allow you to avoid a self
join. Following is an example with multiple columns so that you can see how
the LAG/LEAD functions work. This SQL could be plugged directly into Oracle
Reports, or, used as is. Note the nvl stuff I did to handle the first row
since the lag value for the first row would be null (it could have been
handled many other ways):

SQL l
  1  SELECT
  2 Decode(step-1,nvl_lag_step,null,'**') Flag,
  3 x.step,
  4 x.ename,
  5 x.lag_step,
  6 x.lead_step,
  7 x.nvl_lag_step,
  8 x.nvl_lead_step
  9  FROM (
 10select
 11 step,
 12 ename,
 13 lag(step,1) over (order by step) lag_step,
 14 lead(step,1) over (order by step) lead_step,
 15 nvl(lag(step,1) over (order by step),step-1) nvl_lag_step,
 16 nvl(lead(step,1) over (order by step),step+1) nvl_lead_step
 17from nirmal ) x
 18* order by step
SQL /

FL   STEP ENAMELAG_STEP  LEAD_STEP NVL_LAG_STEP NVL_LEAD_STEP
-- -- -- -- --  -
1 SMITH  20 2
2 ALLEN   1  31 3
3 WARD2  52 5
**  5 JONES   3  73 7
**  7 MARTIN  5  85 8
8 BLAKE   7  97 9
9 CLARK   8 10810
   10 SCOTT   9 15915
** 15 KING   10 16   1016
   16 TURNER 15 21   1521
** 21 ADAMS  16 23   1623
** 23 JAMES  21 25   2125
** 25 FORD   23 28   2328
** 28 MILLER 25  2529

Last but not least, if you are *not* talking about Oracle Reports, and, you
are on a version *earlier* than 8.1.6, get back to me. There are other ways
to approach this -- a self join, a function keeping track of a package
variable, etc.

Regards,

Larry G. Elkins
[EMAIL PROTECTED]
-Original Message-
Muthu Kumaran
Sent: Tuesday, June 26, 2001 8:01 AM
To: Multiple recipients of list ORACLE-L


Dear Guru's,
How can i refer the previous record detail(s), when oracle fetchs the
current row details?.
sql SELECT rownum rnum, empno eno, ename FROM EMP;
RNUMENO ENAME
--
1   7369SMITH
2   7499ALLEN
3   7521WARD
4   7566JONES
7   7782CLARK
8   7788SCOTT
10  7844TURNER
In the above, can i able to put * mark in record 7 and 10, since before
these two records, some records are missing.
Is this possible to do this by query. I need this in reports.
Basically my question is,
How can i refer the previous row detail(s), when oracle fetchs the current
row details?.
Thanks in adv.
REgards,
Nirmal.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Larry Elkins
  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

RE: iAS 1.0.2.2. error during installation (update)

2001-06-26 Thread Boivin, Patrice J


FYI,

I was told that this error occurred because not all Oracle NT services were
stopped during the installation.

Only the origin database's service and the TNS Listener service have to be
running.

Add this to your list of things to do, because the Installer does a bad job
of re-installing iAS components and cleaning up after itself if something
goes wrong during the installation process.  

We cannot tell the OUI to de-install iAS components, there are no checkboxes
to allow this.  Probably because some of the components go into an old
Oracle_home.

I had to go into the registry to remove some of the services that it
initially created.

You will have to reboot your machine.

Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)

Systems Admin  Operations | Admin. et Exploit. des systèmes
Technology Services| Services technologiques
Informatics Branch | Direction de l'informatique 
Maritimes Region, DFO  | Région des Maritimes, MPO

E-Mail: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] 


-Original Message-
From:   Boivin, Patrice J [SMTP:[EMAIL PROTECTED]]
Sent:   Monday, June 25, 2001 4:54 PM
To: Multiple recipients of list ORACLE-L
Subject:iAS 1.0.2.2. error during installation

While installing iAS 1.0.2.2. I get a

Could not initialize NLS Subsystem

Dialog box.

In Metalink there is a similar reference for this error, basically
when
re-starting the forms service oracle cannot locate some .msb files.

How can I fix this for iAS 1.0.2.2.?

I logged a TAR, just curious whether I can get an answer more
quickly here.

TIA
Patrice Boivin
Systems Analyst (Oracle Certified DBA)

Systems Admin  Operations | Admin. et Exploit. des systèmes
Technology Services| Services technologiques
Informatics Branch | Direction de l'informatique 
Maritimes Region, DFO  | Région des Maritimes, MPO

E-Mail: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED]


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Boivin, Patrice J
  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: Boivin, Patrice J
  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: ORA-02270 error during import

2001-06-26 Thread Ron Rogers


Easaw,
It appears that you are trying to import the child table before the parent table 
exists. I think the disabeling the constraint before you export should help. Or break 
the export into smaller parts and export the tables in different dmp files then import 
them in the proper order for the constraints to work.
ROR mª¿ªm

 [EMAIL PROTECTED] 06/26/01 08:20AM 
hi

Error during import: ORA-02270: no matching unique or primary key for this
column-list

i am in the process of migrating my oracle databases from dg/ux to solaris8
OS. at the same time, i am taking the opportunity to resize the tables,
indexes to cater for growth in the near future. 

to do this, i hv created fresh the new database with improved settings
(given the luxury of disk space we hv now), created the tables and indexes
with new sizings, moved the export over to the new machine and reimported
it. the export was a full export. 

on import, i get the above error which means that it cant create a foreign
key constraint becos the primary key constraint for the table has not been
created. this is the case for quite a few of the tables but most of the 400
or so tables were fine.

why should this occur and under what circumstances wld this occur? and how
do i fix this?

almost all the documentation i hv checked including oracle web sites do not
offer a solution and I am not sure the best way forward without a lot of
workaround being done which may not be ideal.

wld any Oracle gurus be kind enough offer any ideas or thoughts on this
except that the export/import utility is probably buggy.

many thanx
Easaw T Mathew
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com 
-- 
Author: Easaw T Mathew
  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).

Re: Common Oracle RDBMS Misconceptions

2001-06-26 Thread Rachel Carmichael

we've had this discussion here a number of times. And I know that Oracle 
teaches how hot backup works, at least in the Server Internals classes

I didn't think it was shocking though :)

From: Joseph S. Testa [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: Re: Common Oracle RDBMS Misconceptions
Date: Tue, 26 Jun 2001 04:00:54 -0800

Well i dont know about everyone else, but i knew thats how the hot
backup worked, but then again, i've not attended oracle education
classes either, just some hard core reading and have gotten all of my
backup/recovery concepts from Rama Velpuri's book.  An excellent book if
you dont have it.

joe

  On Jun 26, 2001 at 01:05:59AM, novicedba wrote:
   Hi everyone,
   I visited Jeremiah Wilton's web page http://www.speakeasy.net/~jwilton
   I was shocked to read Hot backup mode explained
   If this is true then I may be a victim of a disease called
   'Common Oracle RDBMS Misconceptions' . Somebody help me!! (Jim 
carrey-MASK style)
   Please help me. If some one has few more articles like this enlighten 
me

--
Joe Testa  http://www.oracle-dba.com
Performing Remote DBA Services, need some backup DBA support?
For Sale: Oracle-dba.com domain, its not going cheap but feel free to
ask :)
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Joseph S. Testa
   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

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rachel Carmichael
  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: QUERY HELP

2001-06-26 Thread Daemen, Remco

Title: QUERY HELP



Do you 
want a query to return the missing numbers, or do you want a query to return the 
records AFTER some numbers have been skipped ?

The 
first can be done in pl/sql (loop with counter compared to rownum), the latter 
in sql (use "where not exists ...").

HTH, Remco

  -Oorspronkelijk bericht-Van: Nirmal Kumar Muthu 
  Kumaran [mailto:[EMAIL PROTECTED]]Verzonden: dinsdag 26 juni 2001 
  15:01Aan: Multiple recipients of list ORACLE-LOnderwerp: 
  QUERY HELP
  Dear Guru's, 
  How can i refer the previous record detail(s), when 
  oracle fetchs the current row details?. 
  sql SELECT rownum rnum, empno eno, ename FROM 
  EMP; 
  RNUM ENO 
  ENAME -- 1 7369 
  SMITH 2 
  7499 ALLEN 3 7521 
  WARD 4 
  7566 JONES 7 7782 
  CLARK 8 
  7788 SCOTT 10 7844 TURNER 
  
  In the above, can i able to put * mark in record 7 
  and 10, since before these two records, some records are missing. 
  Is this possible to do this by query. I need this 
  in reports. 
  Basically my question is, How can i refer the previous row detail(s), when oracle 
  fetchs the current row details?. 
  Thanks in adv. 
  REgards, Nirmal.

Re[2]: Common Oracle RDBMS Misconceptions


Joe  company,

Jeremiah has it exactly correct.  The only part of the data file that is
un-writable is the datafile header block, which gets frozen until the hot
backup of that tablespace completes.  Look at it this way, when the start
backup command gets issued Oracle is in fact freezing that datafile(s) at that
point in time and assuming that all changes to the datafile(s) have not been
written.  When you restore the file, you then apply redo from your archive logs
(the reason you MUST be in archive mode) from the start of the backup till the
end of the recovery just as if those changes to the file(s) had never been made
in the first place.  In fact Oracle knows the changes were made during the
backup, it just has no idea if the change was written to the file before or
after your backup software copied that portion of the file to tape or wherever. 
Therefore, simple solution assume it was after.  In practice the process is very
simple, does slow the database down a tad, and works as advertised.  (Been
there, done that several times.)

BTW: IMHO, don't waste your money on any of the SAMS books.  They are full of
similar misconceptions.

Dick Goulet

Reply Separator
Author: Joseph S. Testa [EMAIL PROTECTED]
Date:   6/26/2001 4:00 AM

Well i dont know about everyone else, but i knew thats how the hot
backup worked, but then again, i've not attended oracle education
classes either, just some hard core reading and have gotten all of my
backup/recovery concepts from Rama Velpuri's book.  An excellent book if
you dont have it.

joe

 On Jun 26, 2001 at 01:05:59AM, novicedba wrote:
  Hi everyone,
  I visited Jeremiah Wilton's web page http://www.speakeasy.net/~jwilton
  I was shocked to read Hot backup mode explained
  If this is true then I may be a victim of a disease called
  'Common Oracle RDBMS Misconceptions' . Somebody help me!! (Jim carrey-MASK
style)
  Please help me. If some one has few more articles like this enlighten me

-- 
Joe Testa  http://www.oracle-dba.com
Performing Remote DBA Services, need some backup DBA support?
For Sale: Oracle-dba.com domain, its not going cheap but feel free to
ask :)
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Joseph S. Testa
  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: 
  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:RE: RE: RE: 24 x 7 on NT?


Well, I guess so if that was the only occurrence.  I'll never know and I doubt
that they will fess-up.  

At any rate, If one wants to use NT or any other OS for that matter in a 24x7
guaranteed manner then one should look into making as much as possible
redundant.  Back in my Blue Suit days we did a lot of cause and effect analysis,
particularly on Nuclear stuff, to insure that if one component failed there was
a redundant part to take over the tasks of the failed unit.  We also did
analysis to determine what the likelihood of the failure was and what the
cost/benefit of having the redundant part was.  Basically, if you can expect say
1 failure every 8544 hours and it will take less than 1 hour to correct the
failure, is it worth the expense to have redundant hardware for that failure? 
It's one of those things that needs to be evaluated on a case by case basis.  In
the case of NT, you'd need a separate server and be running OPS.  What is the
cost, what is the expected frequency, and is the loss = the cost??

Good questions, but only you can provide the answers.  In the case we have here,
out HP's fail once every 4 years on average over the 10+ years of history we
have with HP.  And each failure takes about 2 hours to fix.  Now at $1000 per
minute of lost revenue that comes to $120,000.  A dual server and OPS
architecture would cost $190,000 just to acquire the  hardware and software. 
Definitely not worth the expense since all of the failures we've had have been
soft ones anyway.


Dick Goulet

Reply Separator
Author: Mohan; Ross [EMAIL PROTECTED]
Date:   6/25/2001 4:56 PM

Wow. They must have known it
was you, Dick! G 

solast Aprilproceeding
scientifically, that's less than
one crash a year...better than 
five nines, right?  

;-

-Original Message-
Sent: Monday, June 25, 2001 4:47 PM
To: Mohan; Ross; Multiple recipients of list ORACLE-L


Ross,

I've had Dell's site crash on me before, last April right in the middle
of
customizing a system.  They apologized, but I went with Gateway anyway.

Dick Goulet

Reply Separator
Author: Mohan; Ross [EMAIL PROTECTED]
Date:   6/25/2001 1:12 PM

Somebody should let Dell know. www.dell.com

They run on NT. When's the last time you heard
about their site being out?

A $40 Billion company can't be all wrong about NT, can it?

-Original Message-
Sent: Monday, June 25, 2001 4:58 PM
To: Multiple recipients of list ORACLE-L


OK, after my vacation, I'll wade back into the fray!!

Ron,

To start with I do not believe it possible to guarantee that NT will be
up
24x7, never mind Oracle.  That is the main reason that we use Oracle ONLY on
Unix (in one flavor or another) here.  All of our NT servers require a
periodic
unscheduled reboot, otherwise they do the unscheduled crash under Murphy's
rules.

Dick Goulet

Reply Separator
Author: Kevin Kostyszyn [EMAIL PROTECTED]
Date:   6/25/2001 12:31 PM

Wow what a can of worms that has just been opened!!!
KK:)

-Original Message-
L.
Sent: Monday, June 25, 2001 4:07 PM
To: Multiple recipients of list ORACLE-L


I have a treasury application that needs to be up 24 x 7 except for
scheduled downtime.  Is there any way to guarantee an app will be available
24 x 7 on NT?  Is anyone faced with this?

Ron Smith
Database Administration
[EMAIL PROTECTED]

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Smith, Ron L.
  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).
-- 
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

RE: Re[2]: OT RE: 24 x 7 on NT?


Well, I betcha the reliability of NT2K and unix is 
very similar, given high level of SA competence and
following good system engineering procedures. 

Anecdotal failure tales ( like Sun on Ebay, or any of the
other Unix failures on NASDAQ, etc. ) are more than
a bit similar to a game of telephone. 

Time will tell, in any case. For my money, NT is a good
operating system, if administered with some seriousness. 



-Original Message-
Sent: Tuesday, June 26, 2001 10:22 AM
To: Multiple recipients of list ORACLE-L


HUMM,  Our last unscheduled Unix down was due to the local power utility
whereas
the last unscheduled down on NT was due to the Blue screen of death (Ok,
so
the screen is Black on 2000).

Reply Separator
Author: Thater; William [EMAIL PROTECTED]
Date:   6/26/2001 5:25 AM

On Mon, 25 Jun 2001,Mohan, Ross scribbled on the wall in glitter crayon:

-I agree with His Chrisness on this one.
-
-If the avg(NT Admin)  avg(Unix Admin), we'd
-all be reading this mail on Window's boxes.
-Er.what I mean to say is..
-
-sly grin
-
-but, in all seriousnesswhen there is a way
-to find a *very good* NT admin out of all the
-Wendy's employees, then NT boxes will be up
-4 or 5 nines, easy.
-
-Besides guys, five nines means you're down
-about FIVE MINUTES a year.
-
-Now, how many of the Unix boxes on this list
-have done that this year?  I bet less than
-one percent.

well, then there must be a whole lot of unix boxes out there because we've
got
40 of them right here.  i'd say all of my 32 databases have been up that
much
too, but i've only had 25 of them up a whole year.;-)  yup, i know i've been
lucky.

--
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.
~~
Expert systems are built to embody the knowledge of human experts.  -
Kulawiec

-- 
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: 
  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: Mohan, Ross
  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: Common Oracle RDBMS Misconceptions

2001-06-26 Thread Holman, Rodney


Yep, that's the way it works.  Whoever started the rumor that the datafiles
were unwriteable hadn't looked into the process deeply enough to understand
it.  The Oracle Ed. class that I took for backup and recovery explained the
process exactly as it is, using the checkpoint, redo, and rollbacks but
still writing to files.

Rodd

 -Original Message-
 From: novicedba [SMTP:[EMAIL PROTECTED]]
 Sent: Tuesday, June 26, 2001 4:06 AM
 To:   Multiple recipients of list ORACLE-L
 Subject:  Common Oracle RDBMS Misconceptions
 
 Hi everyone,
 I visited Jeremiah Wilton's web page http://www.speakeasy.net/~jwilton 
 I was shocked to read Hot backup mode explained
 http://www.speakeasy.org/~jwilton/hot-backup.html
 If this is true then I may be a victim of a disease called 
 'Common Oracle RDBMS Misconceptions' . Somebody help me!! (Jim carrey-MASK
 style)
 Please help me. If some one has few more articles like this enlighten me
 coz
 I am a
 novice
 Oracle Certifiable DBBS
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Holman, Rodney
  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: which initSID?

2001-06-26 Thread Deshpande, Kirti


Really?
Can please you post the results from such an query against your version of
the database? 

Thanks.

- Kirti Deshpande 
  Verizon Information Services
   http://www.superpages.com

 -Original Message-
 From: Saurabh Sharma [SMTP:[EMAIL PROTECTED]]
 Sent: Tuesday, June 26, 2001 12:56 AM
 To:   Multiple recipients of list ORACLE-L
 Subject:  Re: which initSID?
 
 hey,
 
 why don't u querry v$parameter view.
 the parameter ifile gives u the complete path and name of init.ora file.
 
 saurabh
 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Deshpande, Kirti
  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).

No Subject

2001-06-26 Thread Raj




test

RE: Griping about auditing (not the Oracle Kind)

2001-06-26 Thread Michael Kline


When I worked for a large Oracle Office install for the state I was
the technical ops mgr. (Largest distributed Oracle Office install
in the US.)

One of the rules we had in place is every one was given 3 meg of 
storage for email. If you needed more, you had to ask the Oracle
Office Administrator, then the DBA also had to approve the increase
before it could be done. This was politics at its best.

One day one of the commissioners ran out of email space. It took
two days to get his increase of storage, and I believe they took
him to 10 meg. I thought this doesn't seem right for someone who
is like the VP of this state agency.

I calculated the disk space in relation to the 2 gig disk drive.
Mind you, disks were so expensive back then. I also took into
consideration the possible $25-50 per hour for two people to have
to be involved to make this decision. 

It turned out the VP had waited two days to get about $3.45 worth
of disk space and his salary was probably in the $55-75,000 range
back when he was probably one of the highest paid officers in the
agency... The payroll overhead for this $3.45 was probably in the 
$25-50 range. The lost time for the VP may have been $45-75... 

Once this was made public among OUR group, the policy was 
immediately revoked and if you wanted more space, you ask, you got
it, period. 

When politics are involved, often you have to find a kind word
and make the business case. When I had to do the PO's for the 
state, I usually had about a 97% approval factor because I always
made the business case. I included return on investment, cost, 
hidden costs, break even time, savings on maintenance, the works.

Management thinks money(the 2.3 million budget), and anything
that positively affects the bottom line gets their attention.


Michael Kline
ThinkSpark
Richmond, VA
804-744-1545






 -Original Message-
 From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Don
 Granaman
 Sent: Tuesday, June 26, 2001 1:20 AM
 To: Multiple recipients of list ORACLE-L
 Subject: Re: Griping about auditing (not the Oracle Kind)
 
 
 I can supply the commiseration!  You have my sympathies.  I just left my
 last job (also at a major online brokerage) because of exactly the same sort
 of nonsense.  In the good old days things ran fairly smoothly, technical
 people made technical decisions, and the job was great.  Then we got very
 big fast, hordes of new clueless managers and executives came in and
 gradually started insisting on micro-managing everything.  (e.g. Check your
 database files into the configuration management system and update them
 whenever they change.  After some discussion and determining that they
 REALLY meant the database files, not the model, I explained that this was an
 absurd request.  We had 42 production Oracle databases with terabytes of
 datafiles!  Another example, someone had come up with an 40+ page list of
 items that should be documented for every database system.  Not 40+ pages of
 documentation, a 40+ page list of items to be documented!  It included
 everything they had ever heard of, whether even remotely relevant or not.
 Much of it was very specific to IBM mainframes - their previous environment.
 Pages of stuff like CPU temperature was to be statically documented in MS
 Word!  When I started sending them dynamically generated ASCII reports on
 things like space utilization, datafile lists, and the like, I was told that
 the format was unacceptable - it had to be MS Word in the format that they
 had dictated or Power Point (!) also in a format that they dictated.  My
 failure to comply and lack of the teamwork spirit on this insanity was
 duly noted.  It was like Dilbert's worst nightmare.)
(...)
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Michael Kline
  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).

EMN0 process problem

2001-06-26 Thread Seema Singh


Hi Gurus
Some times one of instance is shutdown.When I checked alert log found 
following error message.
Mon Jun 18 09:04:21 2001
Restarting dead background process EMN0
EMN0 started with pid=15
Mon Jun 18 09:04:24 2001
The similar kind of problem I faced when I shutdown the database by shutdown 
immediate option.I couldn't find much information on metalink.Let me know 
what could be problem.Any one have faced similar kind of problem?
Thanks
-Seema
_
Get your FREE download of MSN Explorer at http://explorer.msn.com

-- 
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: Griping about auditing (not the Oracle Kind)

2001-06-26 Thread Kevin Lange


Different situations .  different solutions.  Its all subjective.  What
will work at one location is like using a feather to stop an elephant at
another.  rather useless.  

-Original Message-
Sent: Monday, June 25, 2001 1:31 PM
To: Multiple recipients of list ORACLE-L


Sorry but there are better ways.  

-Original Message-
Sent: Monday, June 25, 2001 11:00 AM
To: Multiple recipients of list ORACLE-L


Well Kimberly, sometimes you have to do what you have to do to get a point
accross.  Depending on the type of employer you have, sometimes you have to
take drastic measures that you would not normally take.

-Original Message-
Sent: Monday, June 25, 2001 12:16 PM
To: Multiple recipients of list ORACLE-L


I say that if you wait until you database has an error you really
aren't proving much except that you are not proactive in your job.
Which, in my book, makes you not a very good DBA.  Dealing with a
dumb process is one thing (we have our fair share on this account) 
but I take to much pride in my work to let things fail because I
need to fill in a piece of paper.

-Original Message-
Sent: Monday, June 25, 2001 9:43 AM
To: Multiple recipients of list ORACLE-L


Wahey !!! The answer I was going to provide. We started calling the manager
up quite frequently at home to authorise changes - he eventually saw sense.
Not quite as bad as 2am in the morning but inconvenient enough for him to
put a stop to it.

Best of Luck.


-Original Message-
Sent: 25 June 2001 17:07
To: Multiple recipients of list ORACLE-L


Jay;
  I have had to go thru the same thing a couple times on a previous job with
Auditors.  Every time those kind of restrictions were placed on us it
brought things to a snails pace or, in some conditions, a complete halt.
Sooner or later they realized that it was unreasonable and lifted them.  But
it was a pain until they did it.

It took them a while to realize that we HAD to work the way we did in order
to keep things running smoothly.

I personally think that you should wait with resizing any of your production
data files until you get oracle errors saying that things can not extend.
At that time, call up the Sr. VP at 2 am in the morning and tell him that
you have a crisis but you can not proceed until you get his permission
because of the restrictions placed on you by the Auditors.   Repeat this
process as many times as neccessary for them to lift the restrictions.

Kevin

-Original Message-
Sent: Monday, June 25, 2001 9:32 AM
To: Multiple recipients of list ORACLE-L


We've been through an internal audit and I was just wondering if anyone else
has to deal with the rather ludicrous requirements I now have.  In order to
add or resize a datafile I now need to fill out a form and get Senior VP
approval and the alert logs must be reviewed every day by a non-DBA in order
to be certain that I didn't make any database changes without such approval.
The auditors were horrified to discover that not only did I do such things
whenever I thought them necessary but that we didn't have a non-DBA review
everything I did after an Oracle upgrade to ensure I didn't install any
other software.
Fortunately I managed to convince them that yes, I really did need a Unix
login (they were skeptical).

So, any similar horror stories?

Jay Miller
Sr. Oracle DBA
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Miller, Jay
  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 Lange
  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).


The information contained in this communication is
confidential, is intended only for the use of the recipient
named above, and may be legally privileged. If the reader 
of this message is not the intended recipient, you are
hereby notified that any dissemination, distribution or
copying of this communication is strictly prohibited.

set autotrace error ??

2001-06-26 Thread ef 8454


We have ORACLE 8.1.6.1 database and I login as DBA and tried to turn on 
autotrace.  I got
following error messages:

SQL set autot on
ERROR:
ORA-00904: invalid column name


SP2-0611: Error enabling EXPLAIN report



Any ideal?

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

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: ef 8454
  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: 24 x 7 on NT?

2001-06-26 Thread Bond Mike A Contr OC-ALC/TILC


We are running Oracle on a clustered Unisys Aquanta system and have had very
few problems.  I can only think of one time this year that I had unplanned
downtime.

The database files are on shared drives and the database software is
installed on two nodes, allowing us to switch to node B in the event of node
A's failure.

I did not pick NT but it has worked out so far.

Mike


-Original Message-
Sent: Tuesday, June 26, 2001 9:06 AM
To: Multiple recipients of list ORACLE-L


Can you explain redundant server/databases?
Ron

-Original Message-
Sent: Monday, June 25, 2001 8:21 PM
To: Multiple recipients of list ORACLE-L


Believe it or not we do run two mission critical 7x24 databases on NT with
few problems.  The one system that is 'life and death' critical we run
redundant servers/databases just in case.

Debbie

-Original Message-
Sent: Monday, June 25, 2001 2:07 PM
To: Multiple recipients of list ORACLE-L


I have a treasury application that needs to be up 24 x 7 except for
scheduled downtime.  Is there any way to guarantee an app will be available
24 x 7 on NT?  Is anyone faced with this?

Ron Smith
Database Administration
[EMAIL PROTECTED]

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Smith, Ron L.
  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: IT - Database (Do Not Use)
  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: Smith, Ron L.
  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: Bond Mike A Contr OC-ALC/TILC
  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: DUPLICATE VALUE CHECK

2001-06-26 Thread Shirish Khapre


i am getting duplicate records if the whole (say XYZ_A_LO_001) value
is repeated without much probs..
but my prob is checking duplication of the last 7 digits..

Shirish Khapre, SE Rolta India Ltd.
Off Ph No. (+91) (022) 832,826,8300568
Ext'n 2730
Minds are like parachutes. They only function when they are open


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Shirish Khapre
  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: Common Oracle RDBMS Misconceptions

2001-06-26 Thread Rodd Holman


Same as in normal operation.  That's where the before image of any data 
changed is stored for undo.  My point was that Oracle operates as you 
would normally expect it to, except the header block of the files are 
frozen at the start backup checkpoint, and you generate more redo as it 
is logging the stuff that needs to be applied when restored (until the 
end backup command).

 Original Message 

On 6/26/01, 11:10:28 AM, Jeremiah Wilton [EMAIL PROTECTED] wrote 
regarding RE: Common Oracle RDBMS Misconceptions:


 Rollbacks?  What's their role in the hot backup mechanism?

 --
 Jeremiah Wilton
 http://www.speakeasy.net/~jwilton

 On Tue, 26 Jun 2001, Holman, Rodney wrote:

  Yep, that's the way it works.  Whoever started the rumor that the 
datafiles
  were unwriteable hadn't looked into the process deeply enough to 
understand
  it.  The Oracle Ed. class that I took for backup and recovery explained 
the
  process exactly as it is, using the checkpoint, redo, and rollbacks but
  still writing to files.
 
   -Original Message-
   From: novicedba [SMTP:[EMAIL PROTECTED]]
  
   I visited Jeremiah Wilton's web page http://www.speakeasy.net/~jwilton
   I was shocked to read Hot backup mode explained
   http://www.speakeasy.org/~jwilton/hot-backup.html
   If this is true then I may be a victim of a disease called
   'Common Oracle RDBMS Misconceptions' . Somebody help me!! (Jim 
carrey-MASK
   style)

 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 --
 Author: Jeremiah Wilton
   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: Rodd Holman
  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).

Script to find space bound objects

2001-06-26 Thread nlzanen1


Hi All,


I thought I had a script to check for space bound objects (can not allocate
next extent for whatever reason) but seem to have misplaced it.

Anybody want to save me the time?

TIA


Jack

=
De informatie verzonden in dit e-mailbericht is vertrouwelijk en is
uitsluitend bestemd voor de geadresseerde. Openbaarmaking,
vermenigvuldiging, verspreiding en/of verstrekking van deze informatie aan
derden is, behoudens voorafgaande schriftelijke toestemming van Ernst 
Young, niet toegestaan. Ernst  Young staat niet in voor de juiste en
volledige overbrenging van de inhoud van een verzonden e-mailbericht, noch
voor tijdige ontvangst daarvan. Ernst  Young kan niet garanderen dat een
verzonden e-mailbericht vrij is van virussen, noch dat e-mailberichten
worden overgebracht zonder inbreuk of tussenkomst van onbevoegde derden.

Indien bovenstaand e-mailbericht niet aan u is gericht, verzoeken wij u
vriendelijk doch dringend het e-mailbericht te retourneren aan de verzender
en het origineel en eventuele kopieën te verwijderen en te vernietigen.

Ernst  Young hanteert bij de uitoefening van haar werkzaamheden algemene
voorwaarden, waarin een beperking van aansprakelijkheid is opgenomen. De
algemene voorwaarden worden u op verzoek kosteloos toegezonden.
=
The information contained in this communication is confidential and is
intended solely for the use of the individual or entity to whom it is
addressed. You should not copy, disclose or distribute this communication
without the authority of Ernst  Young. Ernst  Young is neither liable for
the proper and complete transmission of the information contained in this
communication nor for any delay in its receipt. Ernst  Young does not
guarantee that the integrity of this communication has been maintained nor
that the communication is free of viruses, interceptions or interference.

If you are not the intended recipient of this communication please return
the communication to the sender and delete and destroy all copies.

In carrying out its engagements, Ernst  Young applies general terms and
conditions, which contain a clause that limits its liability. A copy of
these terms and conditions is available on request free of charge.
=





--
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: Common Oracle RDBMS Misconceptions

2001-06-26 Thread Jeremiah Wilton


Rollbacks?  What's their role in the hot backup mechanism?

--
Jeremiah Wilton
http://www.speakeasy.net/~jwilton

On Tue, 26 Jun 2001, Holman, Rodney wrote:

 Yep, that's the way it works.  Whoever started the rumor that the datafiles
 were unwriteable hadn't looked into the process deeply enough to understand
 it.  The Oracle Ed. class that I took for backup and recovery explained the
 process exactly as it is, using the checkpoint, redo, and rollbacks but
 still writing to files.

  -Original Message-
  From:   novicedba [SMTP:[EMAIL PROTECTED]]
 
  I visited Jeremiah Wilton's web page http://www.speakeasy.net/~jwilton
  I was shocked to read Hot backup mode explained
  http://www.speakeasy.org/~jwilton/hot-backup.html
  If this is true then I may be a victim of a disease called
  'Common Oracle RDBMS Misconceptions' . Somebody help me!! (Jim carrey-MASK
  style)

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jeremiah Wilton
  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: OT RE: 24 x 7 on NT?

2001-06-26 Thread Sherman, Edward


Well, my UNIX box would probably run forever except that the DDS3 tape
changer can't seem to last a whole year without breaking. Need to shut the
machine down to replace the tape changer. I'm hoping to get lucky this year.
Only 120 days till victory!

# uptime
 12:09 pm  up 245 days,  1:01,  4 users,  load average: 0.19, 0.48, 0.70

 



-Original Message-
Sent: Tuesday, June 26, 2001 9:26 AM
To: Multiple recipients of list ORACLE-L


On Mon, 25 Jun 2001,Mohan, Ross scribbled on the wall in glitter crayon:

-I agree with His Chrisness on this one.
-
-If the avg(NT Admin)  avg(Unix Admin), we'd
-all be reading this mail on Window's boxes.
-Er.what I mean to say is..
-
-sly grin
-
-but, in all seriousnesswhen there is a way
-to find a *very good* NT admin out of all the
-Wendy's employees, then NT boxes will be up
-4 or 5 nines, easy.
-
-Besides guys, five nines means you're down
-about FIVE MINUTES a year.
-
-Now, how many of the Unix boxes on this list
-have done that this year?  I bet less than
-one percent.

well, then there must be a whole lot of unix boxes out there because we've
got 40 of them right here.  i'd say all of my 32 databases have been up that
much too, but i've only had 25 of them up a whole year.;-)  yup, i know i've
been lucky.

--
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.
~~
Expert systems are built to embody the knowledge of human experts.  -
Kulawiec

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


* * * * * Freedom of Information Act Notice * * * * * 
The information in this email is subject to the record protection mandated
by 5 United States Code 552(b)(4) and relevant judicial opinions. 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Sherman, Edward
  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).

Does OEM affect Oracle performance

2001-06-26 Thread Gene Gurevich


Hi,

We are running Oracle 8.1.6 and are planning to
install
OEM. Are there any issues regarding OEM affecting
oracle negetively (performance or otherwise) that 
the people are aware of?

thanks


g

=


__
Do You Yahoo!?
Get personalized email addresses from Yahoo! Mail
http://personal.mail.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Gene Gurevich
  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: Griping about auditing (not the Oracle Kind)

2001-06-26 Thread Hillman, Alex


Full authority and no responcibility - looks like very much an HMO. I don't
think I would survive in this environment for so long. Maybe if I did not
have where to go and had small children to feed. This is exactly what I
posted. This is no win game and possible only if payd by the hour and payd
very well.

Alex Hillman

-Original Message-
Sent: Tuesday, June 26, 2001 1:20 AM
To: Multiple recipients of list ORACLE-L


I can supply the commiseration!  You have my sympathies.  I just left my
last job (also at a major online brokerage) because of exactly the same sort
of nonsense.  In the good old days things ran fairly smoothly, technical
people made technical decisions, and the job was great.  Then we got very
big fast, hordes of new clueless managers and executives came in and
gradually started insisting on micro-managing everything.  (e.g. Check your
database files into the configuration management system and update them
whenever they change.  After some discussion and determining that they
REALLY meant the database files, not the model, I explained that this was an
absurd request.  We had 42 production Oracle databases with terabytes of
datafiles!  Another example, someone had come up with an 40+ page list of
items that should be documented for every database system.  Not 40+ pages of
documentation, a 40+ page list of items to be documented!  It included
everything they had ever heard of, whether even remotely relevant or not.
Much of it was very specific to IBM mainframes - their previous environment.
Pages of stuff like CPU temperature was to be statically documented in MS
Word!  When I started sending them dynamically generated ASCII reports on
things like space utilization, datafile lists, and the like, I was told that
the format was unacceptable - it had to be MS Word in the format that they
had dictated or Power Point (!) also in a format that they dictated.  My
failure to comply and lack of the teamwork spirit on this insanity was
duly noted.  It was like Dilbert's worst nightmare.)

For almost two years I tried to get them to see the error of their ways.  No
luck.  It only got progressively worse.  Not all, but the majority of
management absolutely insisted on complete authority, but just as adamantly
denied any responsibility.  The concept that the two go together seemed
entirely foreign to them.  A month ago, I decided I couldn't take it
anymore - that even sleeping in a refrigerator box and eating from a
dumpster would be preferable.  Where there is no professional respect and no
accountability, there is no hope.

I am not saying that this is your situation.  I am just saying that what
many others are recommending works only if the decision makers have some
modicum of logical reasoning capability and some sense of responsibility.
Most do, but it is highly dependent on the corporate culture.  Yours
environment sounds a lot like the one I just escaped from was about a year
ago.  Perhaps it is more prevalent in that particular industry.  Brokerages
tend to be a bit stodgy.  Up until last November, we still had a dress code
that included long sleeve dress shirt, preferably white, tie, dress slacks,
polished shoes, ..., etc.  When I started there in 1997, they had a
corporate dress code that included no beards and women can't wear slacks,
only dresses or skirts!  When they wanted to hire me, the major point of
the negotiation was over their insistence that I shave off my beard!  This
negotiation lasted over three weeks!  I refused.  They insisted.  I said I
wasn't interested if it involved shaving.  They called back and upped the
offer.  I still refused.  There were about a dozen rounds of this before
they finally they gave in and hired me anyway.  I guess I did make at least
one significant and lasting change there - they long ago abolished the no
beards for men. no slacks for women policy!  Of course, that was long
before the current management took over!

I never let, and would not recommend letting, a system suffer because of bad
management.  I would just do what actually needed to be done and suffer the
political consequences.  It is the lesser evil by far.

-Don Granaman
[certifiable and temporarily semi-retired OraSaurus]

- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Monday, June 25, 2001 11:06 AM


 Frankly, I can understand the concern about data (we're a brokerage and
have
 lots of customer account information).  But having a non-technical person
 approve adding a datafile?  And then another non-technical person review
 that the adding was done according to an approved form?  Is it obvious
that
 a non-technical person was setting the audit requirements and not
listening
 when I said it was pointless?

 A DBA on another database had his request to increase the next extent size
 on a table refused on the grounds that what if this change causes the
 database to go down?.  His explanation that having a table that was over
 5,000

RE: Common Oracle RDBMS Misconceptions




yeah, 
that is an awesome write up he did.

"Walking on water and developing software from 
a specification are easy if both are frozen." 
Christopher R. Spence Oracle DBA Fuelspot 

  -Original Message-From: novicedba 
  [mailto:[EMAIL PROTECTED]]Sent: Tuesday, June 26, 2001 5:06 
  AMTo: Multiple recipients of list ORACLE-LSubject: 
  Common Oracle RDBMS Misconceptions
  Hi everyone,
  I visited Jeremiah Wilton's web page http://www.speakeasy.net/~jwilton
  I was shocked to read Hot backup mode 
  explained
  If this is true then I may be a victim of a disease called 
  'Common Oracle RDBMS 
  Misconceptions' . Somebody help me!! (Jim carrey-MASK 
  style)
  Please help me. If some one has few more articles 
  like this enlighten me
  cozI am anoviceOracle Certifiable 
  DBBS

RE: Installing forms6i ...


I believe you're hosed if you installed Oracle 8i into the 'DEFAULT_HOME'.
When I do this setup, I install Forms first into the 'DEFAULT_HOME' which is
X:\ORANT.  Then I do the installation of Oracle into a new home, usually
Ora816, this works just fine.  Basically, I believe you need to install
Forms first!!  After a cup of coffee I'll try to remember if I ever did it
the oppisite!!
Kev

-Original Message-
Agrawal
Sent: Tuesday, June 26, 2001 3:15 AM
To: Multiple recipients of list ORACLE-L


Hi All,

The Environment is Windows NT Server 4 SP5 with Oracle 8i Ver 8.1.6
Enterprise edition.

When i am trying to install forms6i it takes the current oracle home and
denies to install it as it is already being used.

Moreover i can not even change the oracle home from this list item of Forms
installer.

At lots of places it is mentioned that we can use multiple oracle home
concept, but unfortunately i couldn't find much material on it.

Pl. suggest how it can be installed.

Bye

- HA







--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Harsh Agrawal
  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: DUPLICATE VALUE CHECK

2001-06-26 Thread Norrell, Brian


Not ins are nasty, try something more like:

create table tmp (
  dup_valule varchar(100),
  keep_row rowid);
create index t1 on tmp(dup_value);
insert into tmp
select my_column_name, max(rowid) from my_table
group by my_column_name 
having count(*)  1);
select my_table.*
from my_table, tmp
where my_column_name = dup_value
and my_table.rowid != keep_row;

Or, if you are just trying to clean up:
delete from my_table_name
where rowid in (
select min(rowid) from my_table
group by my_column_name 
having count(*)  1);
If a duplicate has more than two occurances, this would need to run multiple
times.  Not the best solution for the first case, but will probably be the
fastest for the substring case as you will make a single pass through the
table, performing a single substr on each row.

Brian Norrell
Manager, MPI Development
QuadraMed
511 E John Carpenter Frwy, Su 500
Irving, TX 75062
(972) 831-6600


-Original Message-
Sent: Tuesday, June 26, 2001 10:42 AM
To: Multiple recipients of list ORACLE-L


Hi all

i have one column in my table (in which daily 10 rows are added to the
table) which has values like

XYZ_A_LO_001
XYZ_A_LO_002
XYZ_A_LO_003
XYZ_A_LO_004
XYZ_A_LO_005
XYZ_A_LO_006
XYZ_A_LO_007
XYZ_A_LO_008
XYZ_A_LO_009

i want to check duplicate values.. there are 2 cases of duplication

Case I :- i am using the following query

select from my_table where rowid not in(
select max(rowid) from my_table
group by my_column_name );

i am getting the rows which are duplicate ..

CASE II : - i want to check duplication in last 7 characters(which are
actually nos) in my column like

001
002
003so on

i am using substr function to get this value and i am checking the values
with remaining rows..

but as the table contains nearly 45(present rowcount) the query is
taking lot of time...which i can't afford...
the column has index on it.

plz suggest me what to do??


Shirish Khapre, SE Rolta India Ltd.
Off Ph No. (+91) (022) 832,826,8300568
Ext'n 2730
Minds are like parachutes. They only function when they are open

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Shirish Khapre
  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: Norrell, Brian
  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: which initSID?


Yes, I agree, I was unable to see a path using this view:)?
KK

-Original Message-
Kirti
Sent: Tuesday, June 26, 2001 10:56 AM
To: Multiple recipients of list ORACLE-L


Really?
Can please you post the results from such an query against your version of
the database? 

Thanks.

- Kirti Deshpande 
  Verizon Information Services
   http://www.superpages.com

 -Original Message-
 From: Saurabh Sharma [SMTP:[EMAIL PROTECTED]]
 Sent: Tuesday, June 26, 2001 12:56 AM
 To:   Multiple recipients of list ORACLE-L
 Subject:  Re: which initSID?
 
 hey,
 
 why don't u querry v$parameter view.
 the parameter ifile gives u the complete path and name of init.ora file.
 
 saurabh
 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Deshpande, Kirti
  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: Multiple Oracle Instances on NT



For every SID there will be 2 services in NT - one called
OracleServiceURSID and another OracleStartURSID. If u keep the latter as
start automatically - ur db will come up auto when NT boots up.

Just thought I would mention, that is only for 8.0, 8i has one service:)
Kev
-- 
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: RE: RE: RE: 24 x 7 on NT?


Ross Mohan for president!

Walking on water and developing software from a specification are easy if
both are frozen.

Christopher R. Spence
Oracle DBA
Fuelspot 



-Original Message-
Sent: Tuesday, June 26, 2001 12:27 PM
To: Multiple recipients of list ORACLE-L


I am hearing such amazing storiesrunning for seven years
no failures in 4 years.never any failures except when
the NT administrator brought down the power grid, etc. 

I am not an old hand, nor am I a greenhorn, but in my experience, 
real, live production systems ( e.g. more than 100 users, round 
the clock availability, frequent software updates...hardware adds 
to account for growth, etc. ) just don't run for four years without 
any downtime.  I have never seen this. New systems have bugs shaken
outold systems have legacy MTBF hiccupsall systems need 
occasional hw/sw tweaks to accomodate unplanned business needs. 

Now, if you factor OUT *scheduled* maintenance, then, hell, ANY
system can stay up for months...years...decades.  And, guess what?
If you're NOT upgrading application or system software, or patching
firmware or doing OS upgrades, it's not what I'd call a live
production system. Hell, my HP calculator has been running whenever 
I want it, nonstop, since 1987. 

As for running Nuclear stuff, I would NEVER run Oracle or Unix or NT
for ANYTHING to do with Nuclear stuff ( missiles or power ). Oh My God.
Please don't tell me any more about that. Even Oracle Corp says don't
use our stuff in places where people's lives are directly at stake.

(But that's just me.)

Lastly, this business about being down for one minute costs us 12 Million
dollars is bohunk is most every case. There just isn't the data to support
that. Yea, sure, maybe the a site's average intake is 12 Million during a 
typical one hour outage (that one site out of a million) but how many of 
those spurned customers come back?  Most of them! Me, I can't get my book 
at Amazon, I just do something else and come back. ditto for my memory 
upgrade at Micron, or my tech info at Metalink. This lost business
argument 
is weak or NONEXISTENT in EVERY instantiation I have seen of it. 

Also, a site being down can be anything...network...front line web
servers...'
back end databasesintermediate LDAP serversand the user ( that's you
and I ) have NO WAY OF KNOWING for sure what failed. Ok...Ebay went down, 
repeatedly. They have IIS front end servers (which have not failed) and 
backend oracle databases on Sun E10K (which did). NASDAQ's reconciliation
system just went down a few weeks ago ( Unix ) But that is a case where
I have a mix of good press and backend information. As you note, most
sites won't fess up. 

I happen to work for a government client where we have aging Unix database 
servers of about five or six different flavors ( Siemens, DEC, Sun, Sequent,
etc.) 
that are pushed to their limits, feebly configured, and poorly maintained
(due to 
damagement downtime procedures) but very tightly maintained NT servers
(due to 
my company's downtime procedures ) and know what?   My desktop has gone down
ONCE
in two years. The mail servers for a 1000 user exchange system with 50
Mbytes per 
user mailboxes has NEVER gone down in two years.  The unix boxes have
hiccuped on 
disk...on memory...on oracle bugs.

It's just too easy ( and too wrong ) to say NT Sucks or Solaris Rules
or somesuch. (Not that you are, butsadly, many do)

Bottomline, I agree with you: If Management REALLY wants 24x7, then I just
smile, and explain the costs to them. Before you know it, there are
scheduled
hardware maintenance windows, oracle tuning/patching downtime, etc. 

-Original Message-
Sent: Tuesday, June 26, 2001 9:58 AM
To: Mohan; Ross; Multiple recipients of list ORACLE-L


Well, I guess so if that was the only occurrence.  I'll never know and I
doubt
that they will fess-up.  

At any rate, If one wants to use NT or any other OS for that matter in a
24x7
guaranteed manner then one should look into making as much as possible
redundant.  Back in my Blue Suit days we did a lot of cause and effect
analysis,
particularly on Nuclear stuff, to insure that if one component failed there
was
a redundant part to take over the tasks of the failed unit.  We also did
analysis to determine what the likelihood of the failure was and what the
cost/benefit of having the redundant part was.  Basically, if you can expect
say
1 failure every 8544 hours and it will take less than 1 hour to correct the
failure, is it worth the expense to have redundant hardware for that
failure? 
It's one of those things that needs to be evaluated on a case by case basis.
In
the case of NT, you'd need a separate server and be running OPS.  What is
the
cost, what is the expected frequency, and is the loss = the cost??

Good questions, but only you can provide the answers.  In the case we have
here,
out HP's fail once every 4 years on average over the 10+ years of history we
have with

Re: EMN0 process problem

2001-06-26 Thread Stephane Faroult



 Hi Gurus
 Some times one of instance is shutdown.When I checked alert log found 
 following error message.
 Mon Jun 18 09:04:21 2001
 Restarting dead background process EMN0
 EMN0 started with pid=15
 Mon Jun 18 09:04:24 2001
 The similar kind of problem I faced when I shutdown the database by shutdown 
 immediate option.I couldn't find much information on metalink.Let me know 
 what could be problem.Any one have faced similar kind of problem?
 Thanks
 -Seema

EMN0, of which I had never heard before, is according to V$BGPROCESS an 'even 
monitor process' (guess it's a kind of sub-pmon or sub-smon). It doesn't seem 
to be started by default. If I were you, I would first look in 
background_dump_dest for a trace, because if it died it probably didn't die 
without a last phrase. If the trace file is not clear enough (likely), send it 
to the Oracle Support to keep them busy and in the mean time try to find out 
what makes the b*y EMN0 start and check whether you really need it.

HTH,

Stephane Faroult
Oriole
Corporation

-
Performance tools for Oracle ® 
http://www.oriole.com/


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Stephane Faroult
  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: Common Oracle RDBMS Misconceptions


I think he was shocked by the fact he had a completely different opinion,
and many as well as oracle preach similar opinions.

Walking on water and developing software from a specification are easy if
both are frozen.

Christopher R. Spence
Oracle DBA
Fuelspot 



-Original Message-
[mailto:[EMAIL PROTECTED]]
Sent: Tuesday, June 26, 2001 7:15 AM
To: Multiple recipients of list ORACLE-L



well whats wrong with the article. It is true. It is the way Oracle Handles
the HOT Backup.

Ravinder


 

Vladimir Begun

[EMAIL PROTECTED]To: Multiple recipients
of list ORACLE-L 
crimea.ua   [EMAIL PROTECTED]

Sent by: cc:

[EMAIL PROTECTED] Subject: Re: Common
Oracle RDBMS Misconceptions  
 

 

26-Jun-2001 06:33 PM

Please respond to

ORACLE-L

 

Sender Info:

No Sender Info found

in the address Book

 

 





On Jun 26, 2001 at 01:05:59AM, novicedba wrote:
 Hi everyone,
 I visited Jeremiah Wilton's web page http://www.speakeasy.net/~jwilton
 I was shocked to read Hot backup mode explained
 If this is true then I may be a victim of a disease called
 'Common Oracle RDBMS Misconceptions' . Somebody help me!! (Jim
carrey-MASK style)
 Please help me. If some one has few more articles like this enlighten me

What a help do you need?

--
Vladimir Begun   | The best things in life are for a fee.
http://vbegun.net/   |
http://vbegun.net/wap/   |
[EMAIL PROTECTED]|
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Vladimir Begun
  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).




__

Visit us at www.singaporeair.com.

__

-- 
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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Christopher Spence
  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: Install Database and Developer software on the same machine


What versions, what OS?:)

-Original Message-
Martinez Jimenez
Sent: Tuesday, June 26, 2001 7:01 AM
To: Multiple recipients of list ORACLE-L


Hello List,
I have trying to install both of them (Oracle database software and
Developer software) on the same machine, but it has been completely
impossible for me. Could anybody tell me whether there is or not any way
to do it?
Thanks in advance


-- 
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: Common Oracle RDBMS Misconceptions

2001-06-26 Thread Scott . Shafer


Thank you - I just spewed coffee all over my monitor!  ROFLMAO!!!

Scott Shafer
San Antonio, TX
210-581-6217

Common sense will not accomplish great things. Simply become insane and
desperate.

 -Original Message-
 From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]]
 Sent: Tuesday, June 26, 2001 9:47 AM
 To:   Multiple recipients of list ORACLE-L
 Subject:  Re: Common Oracle RDBMS Misconceptions
 
 I've never found hot backups shocking myself. Is it possible that rather
 than
 visiting Jeremiah's site at www.speakeasy.net poor old novicedba visited
 www.spankeasy.net (I'm not even sure it exists and I'm at work so I won't
 be
 checking).
 If it does exist I'm sure that switching logs means something entirely
 different
 there.
 
 Regards,
 
 Mike
 
 
-- 
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: Common Oracle RDBMS Misconceptions


Bhahahaah

Walking on water and developing software from a specification are easy if
both are frozen.

Christopher R. Spence
Oracle DBA
Fuelspot 



-Original Message-
Sent: Tuesday, June 26, 2001 10:47 AM
To: Multiple recipients of list ORACLE-L




I've never found hot backups shocking myself. Is it possible that rather
than
visiting Jeremiah's site at www.speakeasy.net poor old novicedba visited
www.spankeasy.net (I'm not even sure it exists and I'm at work so I won't be
checking).

If it does exist I'm sure that switching logs means something entirely
different
there.

Regards,

Mike


-- 
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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Christopher Spence
  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: Common Oracle RDBMS Misconceptions

2001-06-26 Thread Rachel Carmichael


Jeremiah,

Marlene and I did an exploding the myths paper very similar to what you 
are doing..

always set pctincrease on your temporary tablespace to 1

and my OOW submission is very very similar to yours.  Not quite, but really 
close.

It will be interesting to see if they choose one, both or neither of our 
papers :)

Rachel

From: Jeremiah Wilton [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: Re: Common Oracle RDBMS Misconceptions
Date: Tue, 26 Jun 2001 09:05:27 -0800

All right folks, I'm collecting misconceptions, of the type held by newbies 
and
oldtimers alike.  My OOW proposal this year is for a presentation and paper 
on a
whole laundry list of these things, similar to what I wrote for hot backup. 
  I
want to share what I have so far and solicit input for your favorites (pet
peeves).  I most certainly will credit individuals and this list for any 
ideas I
glean.

So far my favorite misconceptions are:

* Hot backup stops writing to datafiles
* All network communication is done through the listener
* Always 'switch logfile' after (before, inbetween) hot backups
* Media recovery is required if you crash during backup mode
* Cold backup once a week (just in case, as a 'baseline')
* Export is a good way to back up your database
* Shutdown abort is bad, crash recovery time is as long as 'shutdown 
immediate'
* Listener.log/alert.log clearing confusion
* ORA-1555 can be solved by setting transaction (use specific rollback seg)
* Big batch jobs should use one big RBS
* ORA-600 means you have corruption / just call support for ORA-600
* Lots of extents are bad
* Databases can't be renamed
* Select count (1) is better than count (*).
* Listeners have to be started before the instance
* NOLOGGING turns off logging for all operations
* Oracle Corp. won't support NFS datafiles
* checkpoint not complete - misguided solutions
* Must reinstantiate standby after failover by recopying
* redolog size change requires outage

What's *your* pet misconception?

--
Jeremiah Wilton
http://www.speakeasy.net/~jwilton

On Tue, 26 Jun 2001, novicedba wrote:

  I visited Jeremiah Wilton's web page http://www.speakeasy.net/~jwilton
  I was shocked to read Hot backup mode explained
  If this is true then I may be a victim of a disease called
  'Common Oracle RDBMS Misconceptions' . Somebody help me!! (Jim 
carrey-MASK style)
  Please help me. If some one has few more articles like this enlighten me

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Jeremiah Wilton
   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

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rachel Carmichael
  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: Does OEM affect Oracle performance

2001-06-26 Thread Boivin, Patrice J


Well don't set too many events, remember these are queries.

The more navel-gazing your database does the slower it will be.

: )

Patrice Boivin
Systems Analyst (Oracle Certified DBA)

Systems Admin  Operations | Admin. et Exploit. des systèmes
Technology Services| Services technologiques
Informatics Branch | Direction de l'informatique 
Maritimes Region, DFO  | Région des Maritimes, MPO

E-Mail: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] 

-Original Message-
From:   Gene Gurevich [SMTP:[EMAIL PROTECTED]]
Sent:   Tuesday, June 26, 2001 1:16 PM
To: Multiple recipients of list ORACLE-L
Subject:Does OEM affect Oracle performance

Hi,

We are running Oracle 8.1.6 and are planning to
install
OEM. Are there any issues regarding OEM affecting
oracle negetively (performance or otherwise) that 
the people are aware of?

thanks


g

=


__
Do You Yahoo!?
Get personalized email addresses from Yahoo! Mail
http://personal.mail.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Gene Gurevich
  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: Boivin, Patrice J
  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: Script to find space bound objects

2001-06-26 Thread Mark Leith


Jack,

Here's one that we use..

--

CREATE OR REPLACE VIEW SPACE_BOUND_OBJECTS
  ( TS#,
NAME,
BLOCKSIZE,
MAXFREEBLOCKS,
TOTFREEBLOCKS,
FREEEXTENTS ) AS
select  a.ts#,a.name,a.blocksize,
nvl(max(b.blocks),0),
nvl(sum(b.blocks),0),
nvl(sum(b.blocks/b.blocks),0)
from sys.ts$ a, dba_free_space b
where a.name = b.tablespace_name
group by a.ts#,a.name,a.blocksize

--

SELECT u.name OWNER,
o.name OBJECT,
f.name TABLESPACE,
so.object_type TYPE,
so.object_id OBJ#,
   (s.blocks*f.blocksize)/(1024*1024) OBJMBYTES,
s.extents EXTENTS,
s.iniexts INIEXTS,
s.minexts MINEXTS,
s.maxexts MAXEXTS,
s.extsize NEXTEXTSIZE,
(s.extsize*f.blocksize)/(1024*1024) NEXTEXTMBYTES,
s.extpct EXTPCT,
decode (s.maxexts-s.extents, 0, 'Max Extents Reached',
decode(least(s.extsize,f.totfreeblocks)-s.extsize, 0, 'Fragmented
Free Space', 'Insufficient Free Space')) REASON
 FROM   sys.seg$ s, space_bound_objects f, sys.sys_objects so,
sys.obj$ o, sys.user$ u
 WHERE  (s.extsize  f.maxfreeblocks or (s.extents = s.maxexts and
s.maxexts != 0) ) and
s.ts# = f.ts# and
(s.file#=so.header_file and s.block# = so.header_block and s.type# =
so.segment_type_id) and
so.object_id = o.obj# and
o.owner# = u.user#
--

HTH

Mark

-Original Message-
[EMAIL PROTECTED]
Sent: Tuesday, June 26, 2001 03:31
To: Multiple recipients of list ORACLE-L


Hi All,


I thought I had a script to check for space bound objects (can not allocate
next extent for whatever reason) but seem to have misplaced it.

Anybody want to save me the time?

TIA


Jack

=
De informatie verzonden in dit e-mailbericht is vertrouwelijk en is
uitsluitend bestemd voor de geadresseerde. Openbaarmaking,
vermenigvuldiging, verspreiding en/of verstrekking van deze informatie aan
derden is, behoudens voorafgaande schriftelijke toestemming van Ernst 
Young, niet toegestaan. Ernst  Young staat niet in voor de juiste en
volledige overbrenging van de inhoud van een verzonden e-mailbericht, noch
voor tijdige ontvangst daarvan. Ernst  Young kan niet garanderen dat een
verzonden e-mailbericht vrij is van virussen, noch dat e-mailberichten
worden overgebracht zonder inbreuk of tussenkomst van onbevoegde derden.

Indien bovenstaand e-mailbericht niet aan u is gericht, verzoeken wij u
vriendelijk doch dringend het e-mailbericht te retourneren aan de verzender
en het origineel en eventuele kopieën te verwijderen en te vernietigen.

Ernst  Young hanteert bij de uitoefening van haar werkzaamheden algemene
voorwaarden, waarin een beperking van aansprakelijkheid is opgenomen. De
algemene voorwaarden worden u op verzoek kosteloos toegezonden.
=
The information contained in this communication is confidential and is
intended solely for the use of the individual or entity to whom it is
addressed. You should not copy, disclose or distribute this communication
without the authority of Ernst  Young. Ernst  Young is neither liable for
the proper and complete transmission of the information contained in this
communication nor for any delay in its receipt. Ernst  Young does not
guarantee that the integrity of this communication has been maintained nor
that the communication is free of viruses, interceptions or interference.

If you are not the intended recipient of this communication please return
the communication to the sender and delete and destroy all copies.

In carrying out its engagements, Ernst  Young applies general terms and
conditions, which contain a clause that limits its liability. A copy of
these terms and conditions is available on request free of charge.
=





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

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Mark Leith
  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

RE: Common Oracle RDBMS Misconceptions


Well perhaps you can start writing articles for people.

Walking on water and developing software from a specification are easy if
both are frozen.

Christopher R. Spence
Oracle DBA
Fuelspot 



-Original Message-
Sent: Tuesday, June 26, 2001 8:01 AM
To: Multiple recipients of list ORACLE-L


Well i dont know about everyone else, but i knew thats how the hot
backup worked, but then again, i've not attended oracle education
classes either, just some hard core reading and have gotten all of my
backup/recovery concepts from Rama Velpuri's book.  An excellent book if
you dont have it.

joe

 On Jun 26, 2001 at 01:05:59AM, novicedba wrote:
  Hi everyone,
  I visited Jeremiah Wilton's web page http://www.speakeasy.net/~jwilton
  I was shocked to read Hot backup mode explained
  If this is true then I may be a victim of a disease called
  'Common Oracle RDBMS Misconceptions' . Somebody help me!! (Jim
carrey-MASK style)
  Please help me. If some one has few more articles like this enlighten me

-- 
Joe Testa  http://www.oracle-dba.com
Performing Remote DBA Services, need some backup DBA support?
For Sale: Oracle-dba.com domain, its not going cheap but feel free to
ask :)
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Joseph S. Testa
  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: Christopher Spence
  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: set autotrace error ??

2001-06-26 Thread DBarbour



My ideal is a vast ranch - as far away from technology as I can get.  In
the meantime:

The error enabling EXPLAIN report is your best clue.  You've enabled
autotrace with it's default options, which include executing an EXPLAIN
PLAN.  You probably have not created the PLAN table.  Try running
utlxplan.sql then see if your autotrace works.

David A. Barbour
Oracle DBA, OCP
AISD
512-414-1002


   
   
ef 8454  
   
ef8454@hotmaTo: Multiple recipients of list ORACLE-L 
[EMAIL PROTECTED]  
il.com  cc:   
   
Sent by: Subject: set autotrace error ??   
   
root@fatcity.  
   
com
   
   
   
   
   
06/26/2001 
   
09:30 AM   
   
Please 
   
respond to 
   
ORACLE-L   
   
   
   
   
   




We have ORACLE 8.1.6.1 database and I login as DBA and tried to turn on
autotrace.  I got
following error messages:

SQL set autot on
ERROR:
ORA-00904: invalid column name


SP2-0611: Error enabling EXPLAIN report



Any ideal?

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

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: ef 8454
  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: 
  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: Common Oracle RDBMS Misconceptions

2001-06-26 Thread Terrian, Tom


oh yea baby.

Tom Terrian
Oracle DBA
WPAFB - DAASC
[EMAIL PROTECTED]
937-656-3844 

-Original Message-
Sent: Tuesday, June 26, 2001 10:47 AM
To: Multiple recipients of list ORACLE-L




I've never found hot backups shocking myself. Is it possible that rather than
visiting Jeremiah's site at www.speakeasy.net poor old novicedba visited
www.spankeasy.net (I'm not even sure it exists and I'm at work so I won't be
checking).

If it does exist I'm sure that switching logs means something entirely different
there.

Regards,

Mike


-- 
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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Terrian, Tom
  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: Alter Table Move

2001-06-26 Thread Terry Ball


That is correct.  The move command can not move a table with a LONG
column.  You can try exporting, dropping, recreating in new tablespace and
importing.

Terry

Walter K wrote:

 Hi,

 I'm on 8.1.6 and need to move some tables to a
 different tablespace. The problem is that some of them
 contain LONG or LONG RAW columns. I have tried using
 the LOB clauses as detailed in the docs but I get an
 error message telling me illegal use of LONG
 datatype.

 Is the ALTER TABLE...MOVE... usable with LONGS?

 Thanks!
 -w

 __
 Do You Yahoo!?
 Get personalized email addresses from Yahoo! Mail
 http://personal.mail.yahoo.com/
 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 --
 Author: Walter K
   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: Terry Ball
  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).

Java, Vector, and PLSQL

2001-06-26 Thread Witold . Iwaniec




Hi

In a web application taht I write in java I need to pass a number of parameters
to a PL/SQL stored procedure. Since the number of parameters can be different a
Vector, ArrayList, or HashTable on the java side would be a good choice. Can you
pass a Vector to a PL/SQL stored procedure?

If I have to, I could write the stored procedures in java but PL/SQL is almost
done. A new requirement has come up and it requires a variable number of
parameters.

Thanks

Witold


-- 
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: Monitoring Memory on DYNIX


cheers, Genehope it behaves itself for you!

-Original Message-
Sent: Monday, June 25, 2001 6:03 PM
To: Multiple recipients of list ORACLE-L


Ross,

To this question I have a very straight answer. 
I don't know.  I asked a few people and couldn't
get an answer. Our SAs are not on site so talking
to them is a bit of a hassle, plus -as I said - 
the decision has been made. 

anyway, the changes have been done last weeked. 
I'm monitoring the server now to see what changed.

thanks for you help.
Gene
--- Mohan, Ross [EMAIL PROTECTED] wrote:
 Hey Gene, 
 
 thanks for the response. 
 
 if OS cache hit is at good enough and BUFPCT is
 25%
 why on earth raise it?
 
 -Original Message-
 Sent: Monday, June 25, 2001 4:54 PM
 To: Multiple recipients of list ORACLE-L
 
 
  
  thx...for me, I would tying the IBM
 
 snip, as per ThaterProtocol
 -- 
 Please see the official ORACLE-L FAQ:
 http://www.orafaq.com
 -- 
 Author: Mohan, Ross
   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).


=


__
Do You Yahoo!?
Get personalized email addresses from Yahoo! Mail
http://personal.mail.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Gene Gurevich
  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: Mohan, Ross
  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: Re[2]: OT RE: 24 x 7 on NT?


Mark!

This is cool...you got the bleeding edge so
far out it's amazing

MaximumPC has had some great articles on the Ge3
technology...programmable textures, in hardware...
amazing

having said that, the number one ( and two, and
three and four ) problems with NT is that, in
supporting ten thousand different pieces of
hardware, there are bound to be bad drivers
in the mix. Add to that your purchase of the
absolute latest and greatest andshrug...
you could have expected this. 

I would check with ELSA daily on drivers. They'll
figure it out!

And then, we expect updates on the gaming!

Ross
-Original Message-
Sent: Tuesday, June 26, 2001 12:56 PM
To: Multiple recipients of list ORACLE-L


RANT
WHATEVER you do - DON'T GO ADDING ANY NEW FUNKY HARDWARE!!!

I just got a brand new ELSA GLADIAC 920 graphics card - built on the new
nvidia Geoforce 3 chipset with 64mb on board DDR SDRAM! (I can hear any
gamers going YU)!!

So - slip it in to my (not a year old - PIII800 256M RAM Win2K) PC and the
damn thing wont work - it switches video modes to go in to a game and turns
the screen in to stand by mode  (NOW THERE'S A BLACK SCREEN FOR YA!!)!! DAMN
THING!! You then have to physically turn the machine off!! Support in their
infinite wisdom told me to upgrade my 4in1 drivers for the chipset(VIA), and
flash the BIOS(AWARD)! Not a very inviting solution - as a BIOS flash, if
gone wrong, will fry your BIOS chip, meaning that you'll need a new
motherboard! They then go on to tell me they won't support this. Call up PC
support - any they won't support it either!

So there I am raring to get my hands on the ultimate PC gamer experience,
and decided to do as they recommend - I updated my VIA 4in1, and flashed the
BIOS - and guess what - the f*$^r STILL WONT WORK!!! I installed the NVIDIA
driver - nope.. Installed the Win2K SP2 - nope.. try to tweak the settings
for screen res etc. - nope.. Made sure that there were no conflicts with
IRQ's etc. - nope..

And at this very moment - IT STILL WON'T WORK!!

DON'T GO THROUGH THE HASSLE!!!

/RANT

Totally off-topic I know as you wouldn't dream of playing games on a
database server - but I needed to vent a little there - I've spent hours on
this last night!! And will later I suppose..

Any graphics experts out there? PC support etc.?

Mark (Gonna go and cry now) Leith

-Original Message-
[EMAIL PROTECTED]
Sent: Tuesday, June 26, 2001 03:22
To: Multiple recipients of list ORACLE-L


HUMM,  Our last unscheduled Unix down was due to the local power utility
whereas
the last unscheduled down on NT was due to the Blue screen of death (Ok,
so
the screen is Black on 2000).

trim

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Mark Leith
  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: Mohan, Ross
  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: Ora-1654 Unable to extend index on tablespace

2001-06-26 Thread Mitchell

Title: RE: Ora-1654 Unable to extend index on tablespace



Hi DBAs

Whenever I have the ora-1654, I 
will
1. alter index/table name deallocate unused 

2. alter tablespace name coalescs;
3.runquerys to check dba_free_space and 
dba_data_files

There are total 140 indexes on this tablespace with 
setting init 1024k and next 1024k.
I got confused now thatfor message 'unable to extend by 256'. What is mean for 256 
here?
The free space(byte) must be over 1024k here 
to avoid ora-1654 for each of 140 index segments?

Thanks in advance.

Mitchell




This the query I run today. I only take first 
few lines and last few lines.

compute sum LABEL 'TOTAL of SEGMENTS' of 
totalofsegments on reportselect tablespace_name, bytes free_space, 
count(bytes) segcount,  (bytes * 
count(bytes)) totalofsegments from dba_free_space where 
tablespace_name=UPPER('1')group by tablespace_name, 
bytesorder by tablespace_name, bytes;

TABLESPACE_NAME 
FREE_SPACE SEGCOUNT TOTALOFSEGMENTS-- 
  
IDX_FINC_C70614 
4,096 
1 
4,096IDX_FINC_C70614 
24,576 
6 
147,456IDX_FINC_C70614 
28,672 
1 
28,672IDX_FINC_C70614 
364,544 
1 
364,544IDX_FINC_C70614 
368,640 
2 737,280
IDX_FINC_C70614 
1,396,736 
1 
1,396,736IDX_FINC_C70614 
2,801,664 
1 
2,801,664 
TOTAL of 
SEGMENTS 
913,092,608



- Original Message - 

  From: 
  Koivu, Lisa 
  To: '[EMAIL PROTECTED]' ; '[EMAIL PROTECTED]' 
  Sent: Tuesday, June 26, 2001 8:08 
AM
  Subject: RE: Ora-1654 Unable to extend 
  index on tablespace
  
  Mitchell have you tried coalescing 
  your tablespace? How big are your extents? 
  
-Original Message- From: Mitchell [SMTP:[EMAIL PROTECTED]] 
Sent: Monday, June 25, 2001 5:28 PM To: Multiple recipients of list ORACLE-L Subject: Re: Ora-1654 Unable to extend index on 
tablespace 
 Dear DBAs 
 I have a tablespace for index 
with 5 file with different size from 500mb - 2000 mb.  Total tablespace size is 6g and used 5317mb 
abote 86.13% usage. 
 I got the error today. 
 ora-1654 unable to extend 
indx sechma.indexname by 256 in tablespace tablespacename. 
The following is the query I got for the 
tablespace . 
We can see the index takes 92 extents and 
maxextends setting is 8192. I then set 
autoextend on a datafile then error is gone. 
What is the reason to cause ora-1654 even there 
are 700mb space avai. I also checked the 
tablespace and index setting with both have next extend 1024k, 
maxextend 8092. 
Mitchll 
SEGMENT 
TYP BYTES NEXT_EXTENT 
EXTENTS MAX_EXTENTS --- 
---   
 - 8,192 
C70614.FINC_INFO_ATTRIBUTE_080101_PK 
IND 94,269,440 
1,048,576 
92 8,192 
C70614.FINC_INFO_ATTRIBUTE_090101_PK 
IND 52,457,472 
1,048,576 
51 8,192 

-- Please see 
the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mitchell 
 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: OT RE: 24 x 7 on NT?

2001-06-26 Thread Thater, William


On Tue, 26 Jun 2001,Mohan, Ross scribbled on the wall in glitter crayon:

-well, then there must be a whole lot of unix boxes out there because we've
-got 40 of them right here.  i'd say all of my 32 databases have been up that
-much too, but i've only had 25 of them up a whole year.;-)  yup, i know i've
-been lucky.
-
-||  You've had FORTY databases up for more than a year???  Color me
-incredulous.

nope 40 unix boxen, only 25 databases.

-
-|| What's the story with yer sig?
-
---
-Bill Shrek Thater   Certifiable ORACLE DBA
-***==  Expert systems are built to embody the knowledge of human experts.
-- Kulawiec
-
one of the cookies from my file.  i have a program that shooses one at random and 
inserts it into my .sig.

--
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.
~~
Expert systems are built to embody the knowledge of human experts.  - Kulawiec

-- 
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: Griping about auditing (not the Oracle Kind)

2001-06-26 Thread DBarbour



Rama,

I've also worked with some top-notch consultants and contractors.
Unfortunately, I don't always have input into the hiring and purchasing
process.  Sometimes you get blind-sided.  My job is to make whatever comes
in the door work.  It's tough when you're faced with this kind of lunacy
from a vendor.

David A. Barbour
Oracle DBA, OCP
AISD
512-414-1002


   
   
Rama Malladi   
   
rama@toyota.To: Multiple recipients of list ORACLE-L 
[EMAIL PROTECTED]  
com cc:   
   
Sent by: Subject: Re: Griping about auditing (not 
the Oracle Kind)
root@fatcity.  
   
com
   
   
   
   
   
06/25/2001 
   
06:40 PM   
   
Please 
   
respond to 
   
ORACLE-L   
   
   
   
   
   




David,
This is about what I've come to expect from consultants/contractors in
your mail does not speak very well of
you. Most of the Critical projects that I worked on are/were run by top
consultants and good employees.

 So it is too vague and broad to generalize certain job types. If you hired
an incompetent consultant, fault
also lies with you  in not knowing the stuff that you are hiring ...

Just a thought...
Rama


[EMAIL PROTECTED] wrote:

 One of the ways around this is to have Executive Delegation set up
within
 your change management procedures.  Generally this boils down to
 recognizing that there are some areas where your experts (generally the
 SA and DBA) have more knowledge and need more flexibility than
developers,
 contractors and the like.

 Interestingly enough, I'm proposing a change management procedure for my
 current employer.  This is in response to a contractor who changed the
TEMP
 tablespace on three instances to contents permanent late Thursday night.
 Friday, users started having problems with their reports.  Here was their
 explanation:

  -- [Contractor] says:  [Application]assumes that there is a
 tablespace called temp.
  We create all of our temporary tables there, so that it isn't too
  difficult to clean them out at some point.  This is necessary
because
  Oracle does not support the temporary table concept we use under
  Informix.
  -- So instead of creating temp tables, under Oracle we create
 permanent
  tables in the temp tablespace, then remove them when we are done
  (assuming the program does everything correctly and doesn't crash).
  -- They need to add a tablespace called temp, which should be at
 least
  a few hundred MB (similar to the Informix temp dbspace).
  -- I think you can't specify TEMPORARY when creating the
  tablespace, because Oracle won't allow tables to be created in a
  temporary tablespace.  The size they used may not be large enough;
  normally we allocate 500 MB or more (it needs to be big enough to
hold
  the largest temporary tables that [Application]would ever create).
 Also, they
  should make the next extent size large than 256k because they
could
  run out of extents -- probably something in the 1-5 MB range would
be
  better.

 I don't think their company has an Oracle DBA on staff (Yosi - you
 interested?).  Global Temporary tables notwithstanding, this is about
what
 I've come to expect from consultants/contractors.  My change management
 procedure has under it's Executive Delegation section, the following
 caveats:

 The  Executive can delegate authority to appropriately qualified
people
 (referred  to in this document as the Delegated Authority) to
authorize
 a  change.  The delegation will be documented and will form part of

RE: NOLOGGING

2001-06-26 Thread Jeremiah Wilton

DELETE is not a finction that NOLOGGING has any effect on. You can't reduce the
amount of redo generated in a delete by making the object NOLOGGING. It is a
common misconception :-) that NOLOGGING pertains to all types of DML and DDL.
Please consult the following section of the Concepts Manual:

http://otn.oracle.com/docs/products/oracle8i/doc_library/817_doc/server.817/a76965/c21dlins.htm#4418

--
Jeremiah Wilton
http://www.speakeasy.net/~jwilton

On Tue, 26 Jun 2001, Ramon Estevez wrote:

As I am concerned, the only redo information it generates is related
to the system tablespace, the one refering to the manage of the extents.

-Mensaje original-
De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]En nombre de Gaja Krishna Vaidyanatha

That is not true. Setting NOLOGGING at the object
level only reduces the amount of redo generated for
bulk INSERT operations with the /*+ APPEND */ hint,
certain partition administration operations and of
course during the creation of the object itself. It
does not eliminate generation of redo during a delete
operation.

Attached is a sample output from a couple of delete
commands, one with LOGGING and the other with
NOLOGGING:

--- Ramon Estevez [EMAIL PROTECTED] wrote:

Yes, you should get a improve performance due to the
nologging option in the
delete wont write redo log information.

-Mensaje original-
De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]En

If I have a delete which I know I never want to roll
back, can I get a
performance gain by using the nologging option ?

Delete nologging is not, to the best of my
knowledge, documented on 8.1.6
... but the query executes OK.

However, when I used autotrace, the delete with
nologging seemed to give the
same or worse results than a normal delete.

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Jeremiah Wilton
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).

OT RE: 24 x 7 on NT?


lolI just quote the Groucho Marx line: I wouldn't want
to be in any club that would have people like me as a member.

;-
-Original Message-
Sent: Tuesday, June 26, 2001 1:31 PM
To: Multiple recipients of list ORACLE-L


Ross Mohan for president!

Walking on water and developing software from a specification are easy if
both are frozen.

Christopher R. Spence
Oracle DBA
Fuelspot 



-Original Message-
Sent: Tuesday, June 26, 2001 12:27 PM
To: Multiple recipients of list ORACLE-L


I am hearing such amazing storiesrunning for seven years
no failures in 4 years.never any failures except when
the NT administrator brought down the power grid, etc. 

I am not an old hand, nor am I a greenhorn, but in my experience, 
real, live production systems ( e.g. more than 100 users, round 
the clock availability, frequent software updates...hardware adds 
to account for growth, etc. ) just don't run for four years without 
any downtime.  I have never seen this. New systems have bugs shaken
outold systems have legacy MTBF hiccupsall systems need 
occasional hw/sw tweaks to accomodate unplanned business needs. 

Now, if you factor OUT *scheduled* maintenance, then, hell, ANY
system can stay up for months...years...decades.  And, guess what?
If you're NOT upgrading application or system software, or patching
firmware or doing OS upgrades, it's not what I'd call a live
production system. Hell, my HP calculator has been running whenever 
I want it, nonstop, since 1987. 

As for running Nuclear stuff, I would NEVER run Oracle or Unix or NT
for ANYTHING to do with Nuclear stuff ( missiles or power ). Oh My God.
Please don't tell me any more about that. Even Oracle Corp says don't
use our stuff in places where people's lives are directly at stake.

(But that's just me.)

Lastly, this business about being down for one minute costs us 12 Million
dollars is bohunk is most every case. There just isn't the data to support
that. Yea, sure, maybe the a site's average intake is 12 Million during a 
typical one hour outage (that one site out of a million) but how many of 
those spurned customers come back?  Most of them! Me, I can't get my book 
at Amazon, I just do something else and come back. ditto for my memory 
upgrade at Micron, or my tech info at Metalink. This lost business
argument 
is weak or NONEXISTENT in EVERY instantiation I have seen of it. 

Also, a site being down can be anything...network...front line web
servers...'
back end databasesintermediate LDAP serversand the user ( that's you
and I ) have NO WAY OF KNOWING for sure what failed. Ok...Ebay went down, 
repeatedly. They have IIS front end servers (which have not failed) and 
backend oracle databases on Sun E10K (which did). NASDAQ's reconciliation
system just went down a few weeks ago ( Unix ) But that is a case where
I have a mix of good press and backend information. As you note, most
sites won't fess up. 

I happen to work for a government client where we have aging Unix database 
servers of about five or six different flavors ( Siemens, DEC, Sun, Sequent,
etc.) 
that are pushed to their limits, feebly configured, and poorly maintained
(due to 
damagement downtime procedures) but very tightly maintained NT servers
(due to 
my company's downtime procedures ) and know what?   My desktop has gone down
ONCE
in two years. The mail servers for a 1000 user exchange system with 50
Mbytes per 
user mailboxes has NEVER gone down in two years.  The unix boxes have
hiccuped on 
disk...on memory...on oracle bugs.

It's just too easy ( and too wrong ) to say NT Sucks or Solaris Rules
or somesuch. (Not that you are, butsadly, many do)

Bottomline, I agree with you: If Management REALLY wants 24x7, then I just
smile, and explain the costs to them. Before you know it, there are
scheduled
hardware maintenance windows, oracle tuning/patching downtime, etc. 

-Original Message-
Sent: Tuesday, June 26, 2001 9:58 AM
To: Mohan; Ross; Multiple recipients of list ORACLE-L


Well, I guess so if that was the only occurrence.  I'll never know and I
doubt
that they will fess-up.  

At any rate, If one wants to use NT or any other OS for that matter in a
24x7
guaranteed manner then one should look into making as much as possible
redundant.  Back in my Blue Suit days we did a lot of cause and effect
analysis,
particularly on Nuclear stuff, to insure that if one component failed there
was
a redundant part to take over the tasks of the failed unit.  We also did
analysis to determine what the likelihood of the failure was and what the
cost/benefit of having the redundant part was.  Basically, if you can expect
say
1 failure every 8544 hours and it will take less than 1 hour to correct the
failure, is it worth the expense to have redundant hardware for that
failure? 
It's one of those things that needs to be evaluated on a case by case basis.
In
the case of NT, you'd need a separate server and be running OPS.  What is
the
cost,

RE: Re[2]: Common Oracle RDBMS Misconceptions

2001-06-26 Thread Jenkins, Michael


Sad to say but I suspect that Oracle Education is responsible for the
popular misconception about frozen writes on data files during a hot backup.
It's interesting to me that it doesn't occur to most people that you would
blow out a rollback segment if you had to hold all of those changes to
blocks.  Those dirty blocks have to be saved somewhere!

I took the backup and recovery class when I first became a DBA and I
remember the instructor actually saying in class that the data files had NO
write activity while the tablespace is in hot backup mode.  Since I didn't
know any better I just assumed what he told me was true.  It was only after
reading a white paper on Metalink (go figure!) that I understood the reasons
behind this urban myth.  I still have senior level DBAs argue with me on
this one all the time.  I just point them to the white paper.  I haven't
been able to find it lately though.  Does anybody have a copy?

BTW, Nice thread.

--Michael

-Original Message-
Sent: Tuesday, June 26, 2001 9:46 AM
To: Multiple recipients of list ORACLE-L


Joe  company,

Jeremiah has it exactly correct.  The only part of the data file that is
un-writable is the datafile header block, which gets frozen until the hot
backup of that tablespace completes.  Look at it this way, when the start
backup command gets issued Oracle is in fact freezing that datafile(s) at
that
point in time and assuming that all changes to the datafile(s) have not been
written.  When you restore the file, you then apply redo from your archive
logs
(the reason you MUST be in archive mode) from the start of the backup till
the
end of the recovery just as if those changes to the file(s) had never been
made
in the first place.  In fact Oracle knows the changes were made during the
backup, it just has no idea if the change was written to the file before or
after your backup software copied that portion of the file to tape or
wherever. 
Therefore, simple solution assume it was after.  In practice the process is
very
simple, does slow the database down a tad, and works as advertised.  (Been
there, done that several times.)

BTW: IMHO, don't waste your money on any of the SAMS books.  They are full
of
similar misconceptions.

Dick Goulet

Reply Separator
Author: Joseph S. Testa [EMAIL PROTECTED]
Date:   6/26/2001 4:00 AM

Well i dont know about everyone else, but i knew thats how the hot
backup worked, but then again, i've not attended oracle education
classes either, just some hard core reading and have gotten all of my
backup/recovery concepts from Rama Velpuri's book.  An excellent book if
you dont have it.

joe

 On Jun 26, 2001 at 01:05:59AM, novicedba wrote:
  Hi everyone,
  I visited Jeremiah Wilton's web page http://www.speakeasy.net/~jwilton
  I was shocked to read Hot backup mode explained
  If this is true then I may be a victim of a disease called
  'Common Oracle RDBMS Misconceptions' . Somebody help me!! (Jim
carrey-MASK
style)
  Please help me. If some one has few more articles like this enlighten me

-- 
Joe Testa  http://www.oracle-dba.com
Performing Remote DBA Services, need some backup DBA support?
For Sale: Oracle-dba.com domain, its not going cheap but feel free to
ask :)
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Joseph S. Testa
  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: 
  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: Jenkins, Michael
  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

RE: Common Oracle RDBMS Misconceptions

2001-06-26 Thread Terrian, Tom


Based on Gaja's book, tune based on waits not based on hit ratios.

Tom Terrian
Oracle DBA
WPAFB - DAASC
[EMAIL PROTECTED]
937-656-3844 

-Original Message-
Sent: Tuesday, June 26, 2001 1:05 PM
To: Multiple recipients of list ORACLE-L


All right folks, I'm collecting misconceptions, of the type held by newbies and
oldtimers alike.  My OOW proposal this year is for a presentation and paper on a
whole laundry list of these things, similar to what I wrote for hot backup.  I
want to share what I have so far and solicit input for your favorites (pet
peeves).  I most certainly will credit individuals and this list for any ideas I
glean.

So far my favorite misconceptions are:

* Hot backup stops writing to datafiles
* All network communication is done through the listener
* Always 'switch logfile' after (before, inbetween) hot backups
* Media recovery is required if you crash during backup mode
* Cold backup once a week (just in case, as a 'baseline')
* Export is a good way to back up your database
* Shutdown abort is bad, crash recovery time is as long as 'shutdown immediate'
* Listener.log/alert.log clearing confusion
* ORA-1555 can be solved by setting transaction (use specific rollback seg)
* Big batch jobs should use one big RBS
* ORA-600 means you have corruption / just call support for ORA-600
* Lots of extents are bad
* Databases can't be renamed
* Select count (1) is better than count (*).
* Listeners have to be started before the instance
* NOLOGGING turns off logging for all operations
* Oracle Corp. won't support NFS datafiles
* checkpoint not complete - misguided solutions
* Must reinstantiate standby after failover by recopying
* redolog size change requires outage

What's *your* pet misconception?

--
Jeremiah Wilton
http://www.speakeasy.net/~jwilton

On Tue, 26 Jun 2001, novicedba wrote:

 I visited Jeremiah Wilton's web page http://www.speakeasy.net/~jwilton
 I was shocked to read Hot backup mode explained
 If this is true then I may be a victim of a disease called
 'Common Oracle RDBMS Misconceptions' . Somebody help me!! (Jim carrey-MASK
style)
 Please help me. If some one has few more articles like this enlighten me

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jeremiah Wilton
  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: Terrian, Tom
  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).

Instance up scripts

2001-06-26 Thread Seema Singh


Hi Gurus
I want to check every 5 minutes interval whether instances are up or not.If 
its not up then I will get page.Let me know any one have such scripts.
Thanks
-Seema
_
Get your FREE download of MSN Explorer at http://explorer.msn.com

-- 
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: RE: RE: RE: 24 x 7 on NT?


I am hearing such amazing storiesrunning for seven years
no failures in 4 years.never any failures except when
the NT administrator brought down the power grid, etc. 

I am not an old hand, nor am I a greenhorn, but in my experience, 
real, live production systems ( e.g. more than 100 users, round 
the clock availability, frequent software updates...hardware adds 
to account for growth, etc. ) just don't run for four years without 
any downtime.  I have never seen this. New systems have bugs shaken
outold systems have legacy MTBF hiccupsall systems need 
occasional hw/sw tweaks to accomodate unplanned business needs. 

Now, if you factor OUT *scheduled* maintenance, then, hell, ANY
system can stay up for months...years...decades.  And, guess what?
If you're NOT upgrading application or system software, or patching
firmware or doing OS upgrades, it's not what I'd call a live
production system. Hell, my HP calculator has been running whenever 
I want it, nonstop, since 1987. 

As for running Nuclear stuff, I would NEVER run Oracle or Unix or NT
for ANYTHING to do with Nuclear stuff ( missiles or power ). Oh My God.
Please don't tell me any more about that. Even Oracle Corp says don't
use our stuff in places where people's lives are directly at stake.

(But that's just me.)

Lastly, this business about being down for one minute costs us 12 Million
dollars is bohunk is most every case. There just isn't the data to support
that. Yea, sure, maybe the a site's average intake is 12 Million during a 
typical one hour outage (that one site out of a million) but how many of 
those spurned customers come back?  Most of them! Me, I can't get my book 
at Amazon, I just do something else and come back. ditto for my memory 
upgrade at Micron, or my tech info at Metalink. This lost business
argument 
is weak or NONEXISTENT in EVERY instantiation I have seen of it. 

Also, a site being down can be anything...network...front line web
servers...'
back end databasesintermediate LDAP serversand the user ( that's you
and I ) have NO WAY OF KNOWING for sure what failed. Ok...Ebay went down, 
repeatedly. They have IIS front end servers (which have not failed) and 
backend oracle databases on Sun E10K (which did). NASDAQ's reconciliation
system just went down a few weeks ago ( Unix ) But that is a case where
I have a mix of good press and backend information. As you note, most
sites won't fess up. 

I happen to work for a government client where we have aging Unix database 
servers of about five or six different flavors ( Siemens, DEC, Sun, Sequent,
etc.) 
that are pushed to their limits, feebly configured, and poorly maintained
(due to 
damagement downtime procedures) but very tightly maintained NT servers
(due to 
my company's downtime procedures ) and know what?   My desktop has gone down
ONCE
in two years. The mail servers for a 1000 user exchange system with 50
Mbytes per 
user mailboxes has NEVER gone down in two years.  The unix boxes have
hiccuped on 
disk...on memory...on oracle bugs.

It's just too easy ( and too wrong ) to say NT Sucks or Solaris Rules
or somesuch. (Not that you are, butsadly, many do)

Bottomline, I agree with you: If Management REALLY wants 24x7, then I just
smile, and explain the costs to them. Before you know it, there are
scheduled
hardware maintenance windows, oracle tuning/patching downtime, etc. 

-Original Message-
Sent: Tuesday, June 26, 2001 9:58 AM
To: Mohan; Ross; Multiple recipients of list ORACLE-L


Well, I guess so if that was the only occurrence.  I'll never know and I
doubt
that they will fess-up.  

At any rate, If one wants to use NT or any other OS for that matter in a
24x7
guaranteed manner then one should look into making as much as possible
redundant.  Back in my Blue Suit days we did a lot of cause and effect
analysis,
particularly on Nuclear stuff, to insure that if one component failed there
was
a redundant part to take over the tasks of the failed unit.  We also did
analysis to determine what the likelihood of the failure was and what the
cost/benefit of having the redundant part was.  Basically, if you can expect
say
1 failure every 8544 hours and it will take less than 1 hour to correct the
failure, is it worth the expense to have redundant hardware for that
failure? 
It's one of those things that needs to be evaluated on a case by case basis.
In
the case of NT, you'd need a separate server and be running OPS.  What is
the
cost, what is the expected frequency, and is the loss = the cost??

Good questions, but only you can provide the answers.  In the case we have
here,
out HP's fail once every 4 years on average over the 10+ years of history we
have with HP.  And each failure takes about 2 hours to fix.  Now at $1000
per
minute of lost revenue that comes to $120,000.  A dual server and OPS
architecture would cost $190,000 just to acquire the  hardware and software.

Definitely not worth the expense since all of the failures

Legato NetWorker RMAN: A troublesome pair?

2001-06-26 Thread Ed Bittel


The subject line may be overstating things a bit, but
I'm pretty frustrated at the moment.  

Backups are working fine when I run them manually
(i.e., from a command line or within the RMAN
utility).   The problem is trying to schedule the
Oracle backups through the NetWorker Administration
GUI.  Scheduled filesystem backups work fine. 

Our attempts to schedule a working backup fail without
generating any useful errors in /nsr/logs/messages or
/nsr/logs/daemon.log. Basically, the logs just say
that  the savegroup failed.  Setting the
NSR_SB_DEBUG_FILE in the nsrnmo script hasn't helped
because nothing is being written to the log file.  

The Legato knowledgebase, if you can call it that, has
been of little use (other than to confirm that the
output we have received isn't specific enough to debug
the problem).  What I've seen on MetaLink leads me to
wonder if people who use the Legato NetWorker/RMAN
actually schedule their backups through the
Administration GUI or fall back to good 'ol reliable
cron jobs.   

So, if you use Legato NetWorker for your Oracle
backups:

Do you schedule them through the Admin GUI or through
cron?

Do you know of anything we should check that may not
have been covered in the NetWorker administration
manual?

If you've had similar problems, I love to hear what
the problem was.

TIA for your help.

Ed

=
Ed Bittel, Oracle DBA
Executive Jet Technology Services
~~
If you're in Ohio and work with Oracle 
why not join the Ohio Oracle Users Group?
Visit OOUG on-line at: http://www.ooug.org
~~~

__
Do You Yahoo!?
Get personalized email addresses from Yahoo! Mail
http://personal.mail.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ed Bittel
  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).

OT RE: Common Oracle RDBMS Misconceptions