Re: Dead locks how ?

2003-09-05 Thread Mladen Gogala
Harvey Deitel: Operating Systems.
Andrew Tannenbaum: Modern Operating Systems
Avi Silbershatz: Operating System Concepts


On 2003.09.06 00:14, Veeraraju_Mareddi wrote:
What is a dead lock ? Does oracle manages with a dead lock or DBA has to
involve ? What are other locks , latches A DBA has to take care of. Any
examples, docs, notes will be helpful.
Thanks
Rajuveera
**
This email (including any attachments) is intended for the sole use of the
intended recipient/s and may contain material that is CONFIDENTIAL AND
PRIVATE COMPANY INFORMATION. Any review or reliance by others or copying or
distribution or forwarding of any or all of the contents in this message is
STRICTLY PROHIBITED. If you are not the intended recipient, please contact
the sender by email and delete all copies; your cooperation in this regard
is appreciated.
**
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Veeraraju_Mareddi
  INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
--
Mladen Gogala
Oracle DBA
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Mladen Gogala
 INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).


Re: Off Topic - Norton Internet Security 2003 Software

2003-09-05 Thread KENNETH JANUSZ
Jonathan:

Sounds like the same problem I'm having.  I have gotten a lot of help from
their help desk people, but nothing works.  Still the same problems.  I have
one more suggestion from them to try and then I'll return the CDROM.  Do you
use anything on your PC's now for internet security?

Thanks much,
Ken Janusz, CPIM



- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Friday, September 05, 2003 9:49 PM


> KJ> I have had this PC with Norton 2002 virus software on it
> KJ> since I bought it over a year ago. I recently decided to
> KJ> upgrade to Internet Security 2003 Prof. Ed. Installation
> KJ> has been a mess. Has anyone attempted to install this on
> KJ> XP Prof.? If so have you had any problems? If so, any
> KJ> solutions?
>
> Last year I tried to install Internet Security on a Windows
> 98 PC. It was one of the most horrific installation
> processes, if you can call it a process, that I've ever been
> through. I never did get the software working. I was so
> frustrated, I was ready to beat my head against the wall. In
> the end, I sent the CD back to Symantec with a letter taking
> them up on the "satisfaction guaranteed or your money back"
> in their license agreement. They never even replied.
>
> Oddly enough given all the grief I had with that one product
> of theirs, I'm quite happy with Norton Anti-virus, and I use
> it on all my PCs.
>
> Best regards,
>
> Jonathan Gennick --- Brighten the corner where you are
> http://Gennick.com * 906.387.1698 * mailto:[EMAIL PROTECTED]
>
> Join the Oracle-article list and receive one
> article on Oracle technologies per month by
> email. To join, visit
http://four.pairlist.net/mailman/listinfo/oracle-article,
> or send email to [EMAIL PROTECTED] and
> include the word "subscribe" in either the subject or body.
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Jonathan Gennick
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
>

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

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).


Re: COBOL to Oracle

2003-09-05 Thread GovindanK
I wonder how the code generator is going to take care of Multiple
Record Types , Redefines clauses , Renames clause, GO to statements,
Perform Thru , Declaratives?  That would be interesting.

GovindanK


> Hi List,
>
> Does anyone know of tools, or have had experience using tools, that will
> quickly convert COBOL code to Oracle.  Any information you can provide
> would be
> greatly appreciated.
>
> Thanks in advance.
>
> Rick
>

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

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).


Dead locks how ?

2003-09-05 Thread Veeraraju_Mareddi
What is a dead lock ? Does oracle manages with a dead lock or DBA has to
involve ? What are other locks , latches A DBA has to take care of. Any
examples, docs, notes will be helpful.

Thanks
Rajuveera
** 
This email (including any attachments) is intended for the sole use of the
intended recipient/s and may contain material that is CONFIDENTIAL AND
PRIVATE COMPANY INFORMATION. Any review or reliance by others or copying or
distribution or forwarding of any or all of the contents in this message is
STRICTLY PROHIBITED. If you are not the intended recipient, please contact
the sender by email and delete all copies; your cooperation in this regard
is appreciated.
**
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Veeraraju_Mareddi
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).


SGA allocation?

2003-09-05 Thread Veeraraju_Mareddi
Dear Friends,

Good Morning, Have just read(in some book) that Oracle allocates SGA in
virtual memory of the server.

My understanding is that Oracle first try to allocate in real memory because
it is relatively faster for accessing. 

Please clarify, any case studies , scenarios would explain this well , I
hope.

Thanks a lot.

Rajuveera

** 
This email (including any attachments) is intended for the sole use of the
intended recipient/s and may contain material that is CONFIDENTIAL AND
PRIVATE COMPANY INFORMATION. Any review or reliance by others or copying or
distribution or forwarding of any or all of the contents in this message is
STRICTLY PROHIBITED. If you are not the intended recipient, please contact
the sender by email and delete all copies; your cooperation in this regard
is appreciated.
**
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Veeraraju_Mareddi
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).


Re: Off Topic - Norton Internet Security 2003 Software

2003-09-05 Thread Jonathan Gennick
KJ> I have had this PC with Norton 2002 virus software on it
KJ> since I bought it over a year ago. I recently decided to
KJ> upgrade to Internet Security 2003 Prof. Ed. Installation
KJ> has been a mess. Has anyone attempted to install this on
KJ> XP Prof.? If so have you had any problems? If so, any
KJ> solutions?

Last year I tried to install Internet Security on a Windows
98 PC. It was one of the most horrific installation
processes, if you can call it a process, that I've ever been
through. I never did get the software working. I was so
frustrated, I was ready to beat my head against the wall. In
the end, I sent the CD back to Symantec with a letter taking
them up on the "satisfaction guaranteed or your money back"
in their license agreement. They never even replied.

Oddly enough given all the grief I had with that one product
of theirs, I'm quite happy with Norton Anti-virus, and I use
it on all my PCs.

Best regards,

Jonathan Gennick --- Brighten the corner where you are
http://Gennick.com * 906.387.1698 * mailto:[EMAIL PROTECTED]

Join the Oracle-article list and receive one
article on Oracle technologies per month by 
email. To join, visit http://four.pairlist.net/mailman/listinfo/oracle-article, 
or send email to [EMAIL PROTECTED] and 
include the word "subscribe" in either the subject or body.

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

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).


Re: Offshore threat

2003-09-05 Thread Nuno Souto
- Original Message - 
> 
> A - This is social engineering at its finest.
> 
> B - There is no security without PHYSICAL security
> 
> C - If you don't check up on your outsourcer, then you can apparently
> get the shirt stolen off your back...
> 
>  

what scares me is these guys KNEW which boxes to go to to get the secret info. 
IOW, they KNEW the site internally, they have a plan and it's proceeding. 
I think I'm gonna cancel the holiday, September is here...

PS: who is the IDIOT that leaves this stuff unencrypted and open to stealing?
My laptop has no secret stuff, but because I work in a military installation 
EVERYTHING in it is encrypted, it has boot manager hard passwords, XP hard passwords,
no diskette drive and God only knows what else I could cram in it.  It takes me a 
few minutes to go through all the security every morning.  And there is nothing 
wrong with that! This is what these idiots get for outsourcing to irresponsible 
outsourcers.

Cheers
Nuno Souto
[EMAIL PROTECTED]

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

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).


Re: question for internals experts

2003-09-05 Thread Ryan
we publish from the same staging server daily to our master server. So we
update our staging server to change the name. Then do the export. We thought
about changing the export file, but its in binary and we couldnt make it
work.
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Friday, September 05, 2003 9:24 PM


> ... A stupid solution might be to prefix the name of each tablespace
> with the name of the database it was created in ... you might have to
> play with users' quotas to allow them to create tables in the
> tablespaces you have plugged in but it is infinitely better than
> updating SYS tables ... I have done it in the past but always after a
> very very careful study of the situation and only because I really was
> cornered (and had a good backup).
>
> Jacques Kilchoer wrote:
> >
> > I think this would be the perfect time for you, as DBA, to explain to
the Powers That Be that updating SYS.TS$ is a BAD idea and that the
transportable tablespace plan has to change. You have damning evidence at
this point in time. You will be doing yourself and your successors a big
favour.
> >
> > -Original Message-
> >
> > not my call. i posted this on here before. was done that way before i
got here. Its part of the transportable tablespace plan since you cant have
multiple tablespaces with the same name in one instance.
> >
> > ... However, for the second time flushing the shared pool has not
worked. ...
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > --
> > Author: Jacques Kilchoer
> >   INET: [EMAIL PROTECTED]
> >
> > Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> > San Diego, California-- Mailing list and web hosting services
> > -
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from).  You may
> > also send the HELP command for other information (like subscribing).
>
> --
> Regards,
>
> Stephane Faroult
> Oriole Software
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Stephane Faroult
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
>

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

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).


Re: question for internals experts

2003-09-05 Thread Stephane Faroult
... A stupid solution might be to prefix the name of each tablespace
with the name of the database it was created in ... you might have to
play with users' quotas to allow them to create tables in the
tablespaces you have plugged in but it is infinitely better than
updating SYS tables ... I have done it in the past but always after a
very very careful study of the situation and only because I really was
cornered (and had a good backup).

Jacques Kilchoer wrote:
> 
> I think this would be the perfect time for you, as DBA, to explain to the Powers 
> That Be that updating SYS.TS$ is a BAD idea and that the transportable tablespace 
> plan has to change. You have damning evidence at this point in time. You will be 
> doing yourself and your successors a big favour.
> 
> -Original Message-
> 
> not my call. i posted this on here before. was done that way before i got here. Its 
> part of the transportable tablespace plan since you cant have multiple tablespaces 
> with the same name in one instance.
> 
> ... However, for the second time flushing the shared pool has not worked. ...
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Jacques Kilchoer
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).

-- 
Regards,

Stephane Faroult
Oriole Software
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Stephane Faroult
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).


Re: COBOL to Oracle

2003-09-05 Thread Stephane Faroult
[EMAIL PROTECTED] wrote:
> 
> Hi List,
> 
> Does anyone know of tools, or have had experience using tools, that
> will quickly convert COBOL code to Oracle.  Any information you can
> provide would be greatly appreciated.
> 
> Thanks in advance.
> 
> Rick

What do you mean by converting Cobol to Oracle ? One one side you have a
programming language, and on the other side a subsystem to handle data
without having to open files, read, blahblah. Would you dream of
concerting VB to Excel ?
I presume that what you wan to do is to replace your Cobol file accesses
to ISAM files or the like to access to relational tables. The forget
about the QUICK, because you will have to rethink everything if you want
the effort to be worthwhile.
 FYI there used to be and should still be a product napmed PRO*Cobol
allowing to embed SQL statements in Cobol code (SQL statements replaced
by library calls by a preprocessor). This is the direction I would take.

-- 
Regards,

Stephane Faroult
Oriole Software
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Stephane Faroult
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).


Re: question for internals experts

2003-09-05 Thread Ryan
nah, we can afford to rebuild the instances. its just for staging anyway. Im
now more curious what is going on.

 I dont think its in the datafile. I think there is more going on in memory
than Oracle is releasing.

- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Friday, September 05, 2003 9:04 PM


> I think this would be the perfect time for you, as DBA, to explain to the
Powers That Be that updating SYS.TS$ is a BAD idea and that the
transportable tablespace plan has to change. You have damning evidence at
this point in time. You will be doing yourself and your successors a big
favour.
>
> -Original Message-
>
> not my call. i posted this on here before. was done that way before i got
here. Its part of the transportable tablespace plan since you cant have
multiple tablespaces with the same name in one instance.
>
> ... However, for the second time flushing the shared pool has not worked.
..
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Jacques Kilchoer
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).

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

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).


RE: question for internals experts

2003-09-05 Thread Jacques Kilchoer
I think this would be the perfect time for you, as DBA, to explain to the Powers That 
Be that updating SYS.TS$ is a BAD idea and that the transportable tablespace plan has 
to change. You have damning evidence at this point in time. You will be doing yourself 
and your successors a big favour.

-Original Message-

not my call. i posted this on here before. was done that way before i got here. Its 
part of the transportable tablespace plan since you cant have multiple tablespaces 
with the same name in one instance. 

... However, for the second time flushing the shared pool has not worked. ...
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jacques Kilchoer
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).


RE: question for internals experts

2003-09-05 Thread Jacques Kilchoer
Or unless you have Oracle 10G. rgaffuri, are you still updating TS$, you rascal?
You could try the following:
set long 100
spool c:\temp\views.log
select
   a.view_name, a.text
 from
   dba_views a
 where
   a.owner = 'SYS'
   and a.view_name like 'DBA\_%' escape '\'
   and exists (select * from dba_tab_columns b
where b.owner = a.owner
  and b.table_name = a.view_name
  and upper (b.column_name) like '%TABLESPACE%') ;

Then read the file, figure out which views are showing tablespace name and from which 
SYS table the tablespace name comes from.

Or you could modify your code to be independent of tablespace name, which would be the 
better solution.

-Original Message-

Sounds like you want to rename a tablespace. 

Not recommended without approval from Oracle support. 

<[EMAIL PROTECTED]> 

Does oracle store the tablespace_name or any data about a tablespace anywhere else 
accept TS$? 

Im looking for base data dictionary tables. Not views. Are there any documents out 
there about how oracle stores information in the data dictionary tables other than 
what Steve Adams has in his book or on his website? Has anyone else published on this? 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jacques Kilchoer
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).


RE: COBOL to Oracle

2003-09-05 Thread Jacques Kilchoer
Do you mean that the COBOL code would be translated to PL/SQL packages, or that the 
COBOL I/O would be changed to SQL insert/update/select using Pro*COBOL instead of READ 
and WRITE?

Or do you mean that the COBOL programs would be automagically transformed into an 
Oracle database? One datafile for each program source code file? The mind boggles.


-Original Message-

Does anyone know of tools, or have had experience using tools, that will quickly 
convert COBOL code to Oracle.  Any information you can provide would be greatly 
appreciated.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jacques Kilchoer
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).


Re: question for internals experts

2003-09-05 Thread Ryan



not my call. i posted this on here before. was done 
that way before i got here. Its part of the transportable tablespace plan since 
you cant have multiple tablespaces with the same name in one instance. 

 
I found some interesting(and troublesome things). I 
think Oracle may not be telling us the whole truth with how flushing the shared 
pool works and/or how the data dictionary data is stored in memory. 

 
We update TS$ to rename a tablespace. Normally we 
have no problems. Occasionally we have to flush the shared pool in order to 
alter the tablespace to read only. It doesnt recognize the new name. We check 
TS$ and the new name is there. My best guess at what is happening is that the 
data in the dictionary cache has the old name and the data in the system 
datafile has the new name. We can query the data dictionary and this queries the 
actually datafile and does not flush the dictionary cache. 
 
We flush the shared pool and everything works. 
However, for the second time flushing the shared pool has not worked. 
Interesting thing is that we can take the OLD tablespace name to read only, but 
not the new. We had everyone log out of the instance since we were wondering 
whether Oracle cached some data dictionary info in the PGA. We were able to 
bring the tablespace back online using its new name. 
 
We then logged out and back in. Didnt work this 
time. Flushed the shared pool. Didnt work. So we bounced the instance and 
everything works. This leads me to the following conclusions.
 
1. Updating TS$ does not cascade to other tables. 
If that was so, bouncing the database should not have fixed our 
problem.
2. Flushing the shared pool does not 'necessarily' 
flush all of the data from the shared pool. Since Alter tablespace still 
recognized the old name of the tablespace.
3. Or Oracle is storing part of the data dictionary 
information in other parts of memory that it is abstracting from us and not 
releasing. 
 
This was almost long enough to be an article... 
Anyone play around with this stuff? I know Steve Adams reads this forum 
periodically? you play with it? Some of you worked for Oracle, have you gotten 
and good inside info? 
 
In spite of the problem, it is fairly interesting 
to see that Oracle isnt telling us everything. Makes you wonder what else they 
are 'abstracting' from us in the documentation. 

  - Original Message - 
  From: 
  [EMAIL PROTECTED] 
  To: [EMAIL PROTECTED] 
  Cc: [EMAIL PROTECTED] 
  Sent: Friday, September 05, 2003 7:22 
  PM
  Subject: Re: question for internals 
  experts
  Sounds like you want to rename 
  a tablespace. Not recommended 
  without approval from Oracle support. Jared 
  


  
  <[EMAIL PROTECTED]> 
Sent by: [EMAIL PROTECTED] 
 09/05/2003 01:09 PM 
 Please respond to ORACLE-L 
                  To:     
   Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> 
        cc:   
        
      Subject:        question for 
internals expertsDoes oracle store the tablespace_name or any data 
  about a tablespace anywhere else accept TS$? Im looking for base data 
  dictionary tables. Not views. Are there any documents out there about how 
  oracle stores information in the data dictionary tables other than what Steve 
  Adams has in his book or on his website? Has anyone else published on this? 
  -- Please see the official ORACLE-L FAQ: 
  http://www.orafaq.net-- Author: <[EMAIL PROTECTED] INET: 
  [EMAIL PROTECTED]Fat City Network Services    -- 858-538-5051 
  http://www.fatcity.comSan Diego, California        -- 
  Mailing list and web hosting 
  services-To 
  REMOVE yourself from this mailing list, send an E-Mail messageto: 
  [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message 
  BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing 
  list you want to be removed from).  You mayalso send the HELP command 
  for other information (like 
subscribing).


Re: No more Oracle development here

2003-09-05 Thread Joe Testa
I agree, mysql is kinda like oracle v6.

joe

[EMAIL PROTECTED] wrote:

So they're getting SQL Server for free?

Why not use MySQL or PostreSQL?

Jared





*Gabriel Aragon <[EMAIL PROTECTED]>*
Sent by: [EMAIL PROTECTED]
 09/05/2003 03:24 PM
 Please respond to ORACLE-L
	   
To:Multiple recipients of list ORACLE-L 
<[EMAIL PROTECTED]>
cc:
Subject:No more Oracle development here



My company it's moving all the development efforts to
SQL Server because the customers don't want to pay
Oracle licenses anymore..
Gabriel



__
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software
http://sitebuilder.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Gabriel Aragon
 INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

--
Joseph S Testa
Chief Technology Officer
Data Management Consulting
614-791-9000
It's all about the "CACHE"
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Joe Testa
 INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).


Re: question for internals experts

2003-09-05 Thread Jared . Still

Sounds like you want to rename a tablespace.

Not recommended without approval from Oracle support.

Jared








<[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
 09/05/2003 01:09 PM
 Please respond to ORACLE-L

        
        To:        Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
        cc:        
        Subject:        question for internals experts


Does oracle store the tablespace_name or any data about a tablespace anywhere else accept TS$? 

Im looking for base data dictionary tables. Not views. Are there any documents out there about how oracle stores information in the data dictionary tables other than what Steve Adams has in his book or on his website? Has anyone else published on this? 

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

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).




Re: No more Oracle development here

2003-09-05 Thread Jared . Still

So they're getting SQL Server for free?

Why not use MySQL or PostreSQL?

Jared








Gabriel Aragon <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
 09/05/2003 03:24 PM
 Please respond to ORACLE-L

        
        To:        Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
        cc:        
        Subject:        No more Oracle development here


My company it's moving all the development efforts to
SQL Server because the customers don't want to pay
Oracle licenses anymore.. 

Gabriel



__
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software
http://sitebuilder.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Gabriel Aragon
  INET: [EMAIL PROTECTED]

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).




COBOL to Oracle

2003-09-05 Thread JRicard982
Hi List,

Does anyone know of tools, or have had experience using tools, that will quickly convert COBOL code to Oracle.  Any information you can provide would be greatly appreciated.

Thanks in advance.

Rick


RE: Oracle World - Listers get together (proposed Tuesday Sep 9)

2003-09-05 Thread Steve McClure
I will try to be there as well.  Possibly two of us, Alec Macdonell who
lurks about this list as well.

Steve McClure

-Original Message-
John Kanagaraj
Sent: Wednesday, September 03, 2003 2:54 PM
To: Multiple recipients of list ORACLE-L


Hi all,

We talked about this earlier and I wanted to get this mail out before
everyone participating departs for OOW. I would propose a Lister's
get-together on the evening of Tuesday Sep 9. Monday is the first day, Wed
has the 'OracleWorld Appreciation day' in the evening and I am assuming
there will be felicatations for Arup and Mogens at this time... (and Thu
ends it all).

I have the following that have responded (in no particular order): Arup
Nanda, Jonathan Gennick, Matthew Adams, Brian McGraw, Ari Kaplan, Cary
Millsap (+ other Gurus - Cary brought along Tom Kyte and Kyle Hailey last
time?), Connor McDonald (all the way from Down under!), Greg Loughmiller,
Matthew Zito, Molina Gerardo and self.

We will meet over Dinner at a restaurant across the street from Moscone
Center - probably from about 6:30PM? The address is:

Chevy's
201 3rd Street (corner of 3rd and Howard)
San Francisco, CA 94105
415-543-8060

I will send out a reminder email closer to that time (like Monday :) Let me
know if there are additional numbers...

John Kanagaraj
DB Soft Inc
Phone: 408-970-7002 (W)

Disappointment is inevitable, but Discouragement is optional!

** The opinions and facts contained in this message are entirely mine and do
not reflect those of my employer or customers **
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: John Kanagaraj
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).


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

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).


offshoring article

2003-09-05 Thread Ryan
Here is a link to an article from McKinsey & Co. My favorite positive is
that offshoring IT jobs frees Americans up to do other jobs. Now they dont
say 'what' jobs, but we are free to do them.

If you dont know these are the guys who payed Chelsea Clinton 100k/year
right out of college with no experience. If you explore their website they
are more interested in where you went to school than anything else(notice
how university comes before experience).

who hires these guys?

http://www.mckinsey.com/knowledge/mgi/offshore/

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

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).


RE: Oracle Masters exam

2003-09-05 Thread Steve McClure
I am getting ready to bite the bullet and do this.  I have procured a copy
of Linux Advanced server to install at home, I have a couple of machines I
am going to set up to handle the RAC portions.  This is tough for me,
because I am one of the largest RAC skeptics about.  Of course I had to be
dragged kicking and screaming into the Windows world, so what do I know.  My
employer wants wants me to get the certification, they want the entire IT
department to be certified at least as Oralce Developers.  I told them I had
quite some ways to go, and that the next level of certification required two
expensive courses, and an expensive test as well.  That didn't seem to
dampen their desire to have me acquire the certification.  I got a raise for
completing the OCP program.  I am gonna see if I can get them to dangle a
carrot for me to pass this as well, although their footing the bill for the
education requirements is pretty darned nice.  Not to mention the Solaris
system administrator certification, that self study guide just arrived the
other day, and the Veritas backup administrator certification stuff I got
the other day.  This is getting to be like college.

Steve McClure

-Original Message-
Pete Sharman
Sent: Wednesday, September 03, 2003 3:39 PM
To: Multiple recipients of list ORACLE-L


And having sat through the beta of the masters exam, let me reiterate
what Reichert said in the article.  You really do have to have the hands
on experience to pass it.  I've been using Oracle for something like 15
years now, and training others in the DBA world for 11 or so of those 12
years, and this was the hardest exam I've ever sat through.


Pete

"Controlling developers is like herding cats."
Kevin Loney, Oracle DBA Handbook

"Oh no, it's not.  It's much harder than that!"
Bruce Pihlamae, long term Oracle DBA.



-Original Message-
Boivin, Patrice J
Sent: Thursday, September 04, 2003 6:45 AM
To: Multiple recipients of list ORACLE-L


Oracle Mag has something about the Oracle Masters program...

http://otn.oracle.com/oramag/oracle/03-sep/o53news.html

Patrice.

--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Boivin, Patrice J
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the
message BODY, include a line containing: UNSUB ORACLE-L (or the name of
mailing list you want to be removed from).  You may also send the HELP
command for other information (like subscribing).

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

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).


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

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).


Re: Oracle Masters exam

2003-09-05 Thread Tanel Poder
Hi!

I think the "new" certification is Oracle Certified Master, but the old one
was just Oracle Master title. I personally spent over $6000 on OCM exam
which I took last year (the first public exam). I had to fly to Chicago from
other side of the world, because there were no exams available elsewhere. I
believe Oracle is still having problems with setting up additional test
environments in other locations...
If you ask, was it worth to spend the money - my personal opinion is: yes it
was.

Tanel.

- Original Message - 
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Friday, September 05, 2003 10:59 PM


> Just to clarify, the "old" Oracle Masters was only an indication that
> you had attended a series of relevant training courses.  There was no
> test, no measure of how well you could perform the role of a DBA.  The
> "new" Oracle Masters definitely addresses that issue.
>
>
> Pete
>
> "Controlling developers is like herding cats."
> Kevin Loney, Oracle DBA Handbook
>
> "Oh no, it's not.  It's much harder than that!"
> Bruce Pihlamae, long term Oracle DBA.
>
>
>
> -Original Message-
> Ron Rogers
> Sent: Friday, September 05, 2003 10:39 PM
> To: Multiple recipients of list ORACLE-L
>
>
> I have a certificate suitable for framing that states that I am a
> "Database Administrator Oracle 7 Oracle Master". Does this new Oracle
> Master negate my current  "Oracle Master" certification? Is there and
> upgrade path available? Does it really matter? Every thing that I have
> accomplished I have done for myself. I use the tests as a yard stick
> against what I feel I want to accomplish. Does it matter that I have
> one, or two, or three, or four "suitable for framing" papers on the
> wall? With only a few years to go before I retire for the second time, I
> think that I will concentrate my efforts on my grand kids rather that
> getting paper for my walls.
> Ron mª¿ªm
>
> >>> [EMAIL PROTECTED] 09/05/03 08:20AM >>>
> - Original Message - 
>
> >
> > It's too bad.  It seems like it would be fun.
>
> What for?  Make the employer shell out another BIG bunch of notes? To
> get a piece of paper that says on that date and with that hardware
> one could perform a backup and a restore?
>
> What does that say about the ability to lead a group of developers, or
> design the strategy for database access or solve a really nasty
> performance problem without forcing re-development or re-tooling? Or any
> of a million other tasks truly knowledgeable people get asked to
> perform?
>
> No wonder TK doesn't want to talk about it: it's laughable,
> and he prides himself in being a serious expert.
>
> The single fact the masters was created is the perfect admission at long
> last the OCP was nothing but a sham.  Everyone knows it, some just
> insist on continuing the good old PC stuff (go with the flow,
>
> let it ride, etc). It is the simple truth: its value as a
> "certification" was and always will be nill.
>
> That the masters is being sold as the new "be-all-end-all" is even more
>
> demeaning.
>
>
> > Chris
> >
> > -Original Message-
> > Sent: Thursday, September 04, 2003 10:20 AM
> > To: Multiple recipients of list ORACLE-L
> >
> > So, it's nothing like OCP where you get the certification when you
> spew out
> > certain amount of the green stuff? I wonder how long will it take
> before
> > seeing
> > oracle masters who don't know how to take a hot backup.
>
> They'll be able to take a hot backup, rest assured.
> With milk and two sugars, please.
>
> Cheers
> Nuno Souto
> [EMAIL PROTECTED]
>
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: Nuno Souto
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the
> message BODY, include a line containing: UNSUB ORACLE-L (or the name of
> mailing list you want to be removed from).  You may also send the HELP
> command for other information (like subscribing).
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: Ron Rogers
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the
> message BODY, include a line containing: UNSUB ORACLE-L (or the name of
> mailing list you want to be removed from).  You may also send the HELP
> command for other information (like subscribing).
>
> -- 
> Please see the official ORACLE-L FAQ: http://www.o

Re: No more Oracle development here

2003-09-05 Thread Ryan
what is the difference in cost between sql server and oracle? oracle claims
its similiar due to sql server needing more hard ware. now that is probably
bull in low end system, but is it accurate in high end systems?


- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Friday, September 05, 2003 6:24 PM


> My company it's moving all the development efforts to
> SQL Server because the customers don't want to pay
> Oracle licenses anymore..
>
> Gabriel
>
>
>
> __
> Do you Yahoo!?
> Yahoo! SiteBuilder - Free, easy-to-use web site design software
> http://sitebuilder.yahoo.com
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Gabriel Aragon
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).

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

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).


RE: Another great respone from Oracle support (not really Friday

2003-09-05 Thread Mladen Gogala
Title: Message



Well, that's obviously Oracle Support 
version of the old Latin: Idis redibis nunquam in bello peribis.
 
 
--Mladen GogalaOracle DBA 

  
  -Original 
  Message-From: [EMAIL PROTECTED] 
  [mailto:[EMAIL PROTECTED] On Behalf Of John ShawSent: 
  Friday, September 05, 2003 6:44 PMTo: Multiple recipients of list 
  ORACLE-LSubject: Another great respone from Oracle support (not 
  really Friday
  I filed a tar to get all the steps needed to do a new install of 9ias and 
  bring up to the current patch release 9.0.2.3. 
  This is their detailed list of instructions:
  "
  After applying 9iAS 9.0.2.0.1, you can/should apply 9.0.2.3 
  directly..There are some things you need to do first..upgrade 
  iasdb to 9.0.1.4, etc."
   
  I love the etc.
 
Note:
This message is for the named person's use only.  It may contain 
confidential, proprietary or legally privileged information.  No 
confidentiality or privilege is waived or lost by any mistransmission.  If 
you receive this message in error, please immediately delete it and all 
copies of it from your system, destroy any hard copies of it and notify the 
sender.  You must not, directly or indirectly, use, disclose, distribute, 
print, or copy any part of this message if you are not the intended 
recipient. Wang Trading 
LLC and any of its subsidiaries each reserve the right to 
monitor all e-mail communications through its networks.  Any views 
expressed in this message are those of the individual sender, except where the 
message states otherwise and the sender is authorized to state them to be the 
views of any such entity.
 
 



Another great respone from Oracle support (not really Friday

2003-09-05 Thread John Shaw



I filed a tar to get all the steps needed to do a new install of 9ias and 
bring up to the current patch release 9.0.2.3. 
This is their detailed list of instructions:
"
After applying 9iAS 9.0.2.0.1, you can/should apply 9.0.2.3 
directly..There are some things you need to do first..upgrade 
iasdb to 9.0.1.4, etc."
 
I love the etc.


Re: Oracle Masters exam

2003-09-05 Thread Daniel Fink
Let's just cut the crap and start our own Oracle-L Masters (OLM).

Qualifications
1) Willingness to answer questions
2) Willingness to ask questions, after RTFM
3) Willingness to publicly admit mistakes and offer corrections
4) Demonstration of advanced knowledge of Oracle
5) Able to back up comments with logic and tests, not regurgitate the
latest articles/books



begin:vcard 
n:Fink;Daniel
x-mozilla-html:FALSE
org:Sun Microsystems, Inc.
adr:;;
version:2.1
title:Lead, Database Services
x-mozilla-cpt:;9168
fn:Daniel  W. Fink
end:vcard


RE: DB2 has a foot in the door

2003-09-05 Thread Mladen Gogala
I believe that the answer to Stephane's question is obvious:
Oracle 10g will cost 10 grands/ CPU. That's where the letter "g" 
is coming from.

--
Mladen Gogala
Oracle DBA 



-Original Message-
DENNIS WILLIAMS
Sent: Friday, September 05, 2003 5:30 PM
To: Multiple recipients of list ORACLE-L


Stephane
We've been very excited about Oracle Standard Edition. Helped stave off
the interest in MS SQL. Given the budget pressures at many organizations,
I'm surprised we don't hear more about this alternative.

Dennis Williams
DBA, 80%OCP, 100% DBA
Lifetouch, Inc.
[EMAIL PROTECTED] 


-Original Message-
Sent: Friday, September 05, 2003 4:09 PM
To: Multiple recipients of list ORACLE-L


Hi all,

We're an Oracle shop, over 140 Oracle instances.
Today, architecture has chosen IBM DB2 for BI projects.
The next step I guessed will be to choose DB2 for the new transactionnal
applications also.

IBM offers DB2 at 25% less than Oracle.

I wonder if Oracle 10G will come with a new pricing structure ?


Stephane Paquette
Administrateur de bases de donnees
Database Administrator
Standard Life
www.standardlife.ca
Tel. (514) 499-7999 7470 and (514) 925-7187
[EMAIL PROTECTED] 




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

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the
message BODY, include a line containing: UNSUB ORACLE-L (or the name of
mailing list you want to be removed from).  You may also send the HELP
command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: DENNIS WILLIAMS
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the
message BODY, include a line containing: UNSUB ORACLE-L (or the name of
mailing list you want to be removed from).  You may also send the HELP
command for other information (like subscribing).



Note:
This message is for the named person's use only.  It may contain confidential, 
proprietary or legally privileged information.  No confidentiality or privilege is 
waived or lost by any mistransmission.  If you receive this message in error, please 
immediately delete it and all copies of it from your system, destroy any hard copies 
of it and notify the sender.  You must not, directly or indirectly, use, disclose, 
distribute, print, or copy any part of this message if you are not the intended 
recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to 
monitor all e-mail communications through its networks.
Any views expressed in this message are those of the individual sender, except where 
the message states otherwise and the sender is authorized to state them to be the 
views of any such entity.

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

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).


No more Oracle development here

2003-09-05 Thread Gabriel Aragon
My company it's moving all the development efforts to
SQL Server because the customers don't want to pay
Oracle licenses anymore.. 

Gabriel



__
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software
http://sitebuilder.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Gabriel Aragon
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).


Re: external procedure as not-oracle on OS

2003-09-05 Thread Jared . Still

You would need to have extproc run as some user other than oracle.

The suggested user on unix systems is 'nobody', with rather
limited privileges.

Setting it to root might prove dangerous.

Jared







"Henry Poras" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
 09/05/2003 01:29 PM
 Please respond to ORACLE-L

        
        To:        Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
        cc:        
        Subject:        external procedure as not-oracle on OS


In order to run some OS commands from within the database we have set up a
few external procedures. One of the functions we need to accomplish is to
change the permissions of a file owned by a user other than oracle. As the
external procedure is executed by Oracle, this is a problem. I tried
changing the ownership of the .so file to the other user, setting the setuid
bit, and granting oracle execute permissions on this file. That didn't work.
Our next thought is to have the .so file call a C executable (set with the
setuid bit) which will run chmod. The thought of one person here is that
setuid is strictly for executables and .so is more of a
library/collection-of-code, not strictly an exe. I'm not too clear on this
differentiation. It's also an ugly solution, but that's the direction in
which we are moving.

Has anyone come up with any other alternatives?

Thanks.

Henry

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

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).




RE: Oracle Masters exam

2003-09-05 Thread April Wells
Title: RE: Oracle Masters exam





Well, at least all of the Oracle employees can eventually claim to be masters... maybe some of them will filter over and improve the analyst stock.

April Wells
Oracle DBA/Oracle Apps DBA
Corporate Systems
Amarillo Texas
  /\
 /   \
/ \
\ /
  \/
  >\<
 \
 >\<
 \
Few people really enjoy the simple pleasure of flying a kite
Adam Wells age 11




-Original Message-
From: Thater, William [mailto:[EMAIL PROTECTED]]
Sent: Friday, September 05, 2003 4:24 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: Oracle Masters exam



Pete Sharman  scribbled on the wall in glitter crayon:


> Funny, I found my cost (free) was acceptable ...   :)


hey, can i help it of Oracle wouldn't hire me?;-)


--
Bill "Shrek" Thater ORACLE DBA  BAARF Party member #25
    [EMAIL PROTECTED]

IBM: Indigestion Bothers Me
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Thater, William
  INET: [EMAIL PROTECTED]


Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California    -- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).



The information contained in this communication, including attachments, is strictly 
confidential and for the intended use of the addressee only; it may also contain 
proprietary, price sensitive, or legally privileged information. Notice is hereby given that 
any disclosure, distribution, dissemination, use, or copying of the information by anyone 
other than the intended recipient is strictly prohibited and may be illegal. If you have 
received this communication in error, please notify the sender immediately by reply e-mail, 
delete this communication, and destroy all copies.
 

Corporate Systems, Inc. has taken reasonable precautions to ensure that any attachment to 
this e-mail has been swept for viruses. We specifically disclaim all liability and will 
accept no responsibility for any damage sustained as a result of software viruses and advise 
you to carry out your own virus checks before opening any attachment.


RE: Oracle Masters exam

2003-09-05 Thread Pete Sharman
Don't worry, nor do most Oracle employees.  I was asked to be a beta
tester of the masters exam, and in return for my review ( we actually
spent three days doing the exam because of the amount of time discussing
whether questions were valid, how they should be marked and so on), I
got to sit the exam for free.  I think (though I could be wrong) that
normally (like in the OCP) Oracle employees will be charged a somewhat
reduced rate for the masters exam.  

But anyway, doesn't IBM pay for you to do these sorts of things?  :)


Pete

"Controlling developers is like herding cats."
Kevin Loney, Oracle DBA Handbook

"Oh no, it's not.  It's much harder than that!"
Bruce Pihlamae, long term Oracle DBA.



-Original Message-
[EMAIL PROTECTED]
Sent: Saturday, September 06, 2003 7:29 AM
To: Multiple recipients of list ORACLE-L



Free? Vat is dis Free? All of us don't work for Oracle (at least not
directly) so we don't get that perk. But thanks for sharing.

RWB




Reginald W. Bailey
IBM Global Services - ETS SW GDSD - Database Management
Your Friendly Neighborhood DBA
713-216-7703 (Office) 281-798-5474 (Mobile) 713-415-5410 (Pager)
[EMAIL PROTECTED] [EMAIL PROTECTED]




 

peter.sharman@

oracle.com   To: [EMAIL PROTECTED]

Sent by: cc:

[EMAIL PROTECTED]   Subject: RE: Oracle Masters
exam
ity.com

 

 

09/05/2003

03:44 PM

Please respond

to ORACLE-L

 

 





Funny, I found my cost (free) was acceptable ...   :)


Pete

"Controlling developers is like herding cats."
Kevin Loney, Oracle DBA Handbook

"Oh no, it's not.  It's much harder than that!"
Bruce Pihlamae, long term Oracle DBA.



-Original Message-
Thater, William
Sent: Saturday, September 06, 2003 6:24 AM
To: Multiple recipients of list ORACLE-L


Pete Sharman  scribbled on the wall in glitter crayon:

> Just to clarify, the "old" Oracle Masters was only an indication that 
> you had attended a series of relevant training courses.  There was no 
> test, no measure of how well you could perform the role of a DBA.  The

> "new" Oracle Masters definitely addresses that issue.

all true, but still priced out of line for many of us that would like to
take it and would find it useful.

>
>
> Pete
>
> "Controlling developers is like herding cats."
> Kevin Loney, Oracle DBA Handbook
>
> "Oh no, it's not.  It's much harder than that!"
> Bruce Pihlamae, long term Oracle DBA.

"Remember automatic weapons are a good thing."
me ;-)

--
Bill "Shrek" Thater ORACLE DBA  BAARF Party member #25
[EMAIL PROTECTED]

The cosmological constant warps space-time the other way so that bodies
move apart. - Stephen Hawking on Einstein
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Thater, William
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the
message BODY, include a line containing: UNSUB ORACLE-L (or the name of
mailing list you want to be removed from).  You may also send the HELP
command for other information (like subscribing).

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

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the
message BODY, include a line containing: UNSUB ORACLE-L (or the name of
mailing list you want to be removed from).  You may also send the HELP
command for other information (like subscribing).



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

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the
message BODY, include a line containing: UNSUB 

RE: Oracle Masters exam

2003-09-05 Thread DENNIS WILLIAMS
Mladen
   I'm dubious whether Oracle will make much money from this one. Maybe
someone with better connections to the exam can clarify that one. The payoff
on anything is the amount of revenue minus the cost to create. If fewer
people take the Masters, then the revenue may not offset the cost.
   I would propose an alternative theory. Was the Masters created in
response to criticism of the OCP? Many people have savaged the OCP because
it doesn't mean you are an expert. But did Oracle ever consider it a stamp
of expertise or merely a certificate of qualification? Is it possible that
in response to the criticism, Oracle, ever eager to please the customer,
created a true qualification of expertise (Masters)?

Dennis Williams
DBA, 80%OCP, 100% DBA
Lifetouch, Inc.
[EMAIL PROTECTED] 


-Original Message-
Sent: Friday, September 05, 2003 4:25 PM
To: Multiple recipients of list ORACLE-L


Well, let's look at it from the purely commercial point of view:

1) Is it likely that my company will ever foot the bill for masters exam?
   Me thinks not. Even OCP was frowned upon, because it was looked upon as
   acquiring a technical certification that will make it easier for me to
   leave the company. Justifiedly so. Masters exam would be totally out of
   the question.
2) Is it likely that I pay for the exam myself as I did with OCP? Nope. I'd 
   have to take vacation to be on those two courses, I'd have to pay
exorbitant 
   amount of money for courses and exams, which makes it highly unlikely
that
   I ever will do so, unless I win the lottery.

So, what's going to happen? It is likely that this certification is the
latest 
cash cow for the Oracle Corp. because the OCP has worn out a bit. The way it
is
described, there is simply no possible market for this. If they want to make
money,
they'll have to offer it to the general public the usual way, through
Thompson Learning
or some other education mass marketing organization. That means that the
success rate 
will have to be around 80%, the price will go down, as well as the meaning
or
significance of the course. Nope, I believe that I can satisfy the HR drones

with OCP and that I don't need to invest few grands into something that will

either be very short lived  or become yet another meaningless paper and be
replaced by the "oracle hypermaster to the fifth degree" or "oracle jedi" in

two years or so. Who will acquire it? Oracle employees and owners of the
small 
consulting companies, in order to improve their marketability. Not being one
of them, I'll do what I usually do: sit back and have a good laugh.


--
Mladen Gogala
Oracle DBA 



-Original Message-
Sharman
Sent: Friday, September 05, 2003 4:45 PM
To: Multiple recipients of list ORACLE-L


Funny, I found my cost (free) was acceptable ...   :)


Pete

"Controlling developers is like herding cats."
Kevin Loney, Oracle DBA Handbook

"Oh no, it's not.  It's much harder than that!"
Bruce Pihlamae, long term Oracle DBA.



-Original Message-
Thater, William
Sent: Saturday, September 06, 2003 6:24 AM
To: Multiple recipients of list ORACLE-L


Pete Sharman  scribbled on the wall in glitter crayon:

> Just to clarify, the "old" Oracle Masters was only an indication that
> you had attended a series of relevant training courses.  There was no 
> test, no measure of how well you could perform the role of a DBA.  The

> "new" Oracle Masters definitely addresses that issue.

all true, but still priced out of line for many of us that would like to
take it and would find it useful.

> 
> 
> Pete
> 
> "Controlling developers is like herding cats."
> Kevin Loney, Oracle DBA Handbook
> 
> "Oh no, it's not.  It's much harder than that!"
> Bruce Pihlamae, long term Oracle DBA.

"Remember automatic weapons are a good thing."
me ;-)

--
Bill "Shrek" Thater ORACLE DBA  BAARF Party member #25
[EMAIL PROTECTED]

The cosmological constant warps space-time the other way so that bodies move
apart. - Stephen Hawking on Einstein 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Thater, William
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the
message BODY, include a line containing: UNSUB ORACLE-L (or the name of
mailing list you want to be removed from).  You may also send the HELP
command for other information (like subscribing).

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

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services

RE: Oracle Masters exam

2003-09-05 Thread Reginald . W . Bailey

Free? Vat is dis Free? All of us don't work for Oracle (at least not
directly) so we don't get that perk. But thanks for sharing.

RWB



Reginald W. Bailey
IBM Global Services - ETS SW GDSD - Database Management
Your Friendly Neighborhood DBA
713-216-7703 (Office) 281-798-5474 (Mobile) 713-415-5410 (Pager)
[EMAIL PROTECTED]
[EMAIL PROTECTED]



   
  
peter.sharman@ 
  
oracle.com   To: [EMAIL PROTECTED] 
   
Sent by: cc:   
  
[EMAIL PROTECTED]   Subject: RE: Oracle Masters exam   
 
ity.com
  
   
  
   
  
09/05/2003 
  
03:44 PM   
  
Please respond 
  
to ORACLE-L
  
   
  
   
  




Funny, I found my cost (free) was acceptable ...   :)


Pete

"Controlling developers is like herding cats."
Kevin Loney, Oracle DBA Handbook

"Oh no, it's not.  It's much harder than that!"
Bruce Pihlamae, long term Oracle DBA.



-Original Message-
Thater, William
Sent: Saturday, September 06, 2003 6:24 AM
To: Multiple recipients of list ORACLE-L


Pete Sharman  scribbled on the wall in glitter crayon:

> Just to clarify, the "old" Oracle Masters was only an indication that
> you had attended a series of relevant training courses.  There was no
> test, no measure of how well you could perform the role of a DBA.  The

> "new" Oracle Masters definitely addresses that issue.

all true, but still priced out of line for many of us that would like to
take it and would find it useful.

>
>
> Pete
>
> "Controlling developers is like herding cats."
> Kevin Loney, Oracle DBA Handbook
>
> "Oh no, it's not.  It's much harder than that!"
> Bruce Pihlamae, long term Oracle DBA.

"Remember automatic weapons are a good thing."
me ;-)

--
Bill "Shrek" Thater ORACLE DBA  BAARF Party member #25
[EMAIL PROTECTED]

The cosmological constant warps space-time the other way so that bodies
move apart. - Stephen Hawking on Einstein
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Thater, William
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the
message BODY, include a line containing: UNSUB ORACLE-L (or the name of
mailing list you want to be removed from).  You may also send the HELP
command for other information (like subscribing).

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

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).



-- 
Please se

RE: DB2 has a foot in the door

2003-09-05 Thread DENNIS WILLIAMS
Stephane
We've been very excited about Oracle Standard Edition. Helped stave off
the interest in MS SQL. Given the budget pressures at many organizations,
I'm surprised we don't hear more about this alternative.

Dennis Williams
DBA, 80%OCP, 100% DBA
Lifetouch, Inc.
[EMAIL PROTECTED] 


-Original Message-
Sent: Friday, September 05, 2003 4:09 PM
To: Multiple recipients of list ORACLE-L


Hi all,

We're an Oracle shop, over 140 Oracle instances.
Today, architecture has chosen IBM DB2 for BI projects.
The next step I guessed will be to choose DB2 for the new transactionnal
applications also.

IBM offers DB2 at 25% less than Oracle.

I wonder if Oracle 10G will come with a new pricing structure ?


Stephane Paquette
Administrateur de bases de donnees
Database Administrator
Standard Life
www.standardlife.ca
Tel. (514) 499-7999 7470 and (514) 925-7187
[EMAIL PROTECTED] 




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

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: DENNIS WILLIAMS
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).


RE: Oracle Masters exam

2003-09-05 Thread Mladen Gogala
Well, let's look at it from the purely commercial point of view:

1) Is it likely that my company will ever foot the bill for masters exam?
   Me thinks not. Even OCP was frowned upon, because it was looked upon as
   acquiring a technical certification that will make it easier for me to
   leave the company. Justifiedly so. Masters exam would be totally out of
   the question.
2) Is it likely that I pay for the exam myself as I did with OCP? Nope. I'd 
   have to take vacation to be on those two courses, I'd have to pay
exorbitant 
   amount of money for courses and exams, which makes it highly unlikely
that
   I ever will do so, unless I win the lottery.

So, what's going to happen? It is likely that this certification is the
latest 
cash cow for the Oracle Corp. because the OCP has worn out a bit. The way it
is
described, there is simply no possible market for this. If they want to make
money,
they'll have to offer it to the general public the usual way, through
Thompson Learning
or some other education mass marketing organization. That means that the
success rate 
will have to be around 80%, the price will go down, as well as the meaning
or
significance of the course. Nope, I believe that I can satisfy the HR drones

with OCP and that I don't need to invest few grands into something that will

either be very short lived  or become yet another meaningless paper and be
replaced by the "oracle hypermaster to the fifth degree" or "oracle jedi" in

two years or so. Who will acquire it? Oracle employees and owners of the
small 
consulting companies, in order to improve their marketability. Not being one
of them, I'll do what I usually do: sit back and have a good laugh.


--
Mladen Gogala
Oracle DBA 



-Original Message-
Sharman
Sent: Friday, September 05, 2003 4:45 PM
To: Multiple recipients of list ORACLE-L


Funny, I found my cost (free) was acceptable ...   :)


Pete

"Controlling developers is like herding cats."
Kevin Loney, Oracle DBA Handbook

"Oh no, it's not.  It's much harder than that!"
Bruce Pihlamae, long term Oracle DBA.



-Original Message-
Thater, William
Sent: Saturday, September 06, 2003 6:24 AM
To: Multiple recipients of list ORACLE-L


Pete Sharman  scribbled on the wall in glitter crayon:

> Just to clarify, the "old" Oracle Masters was only an indication that
> you had attended a series of relevant training courses.  There was no 
> test, no measure of how well you could perform the role of a DBA.  The

> "new" Oracle Masters definitely addresses that issue.

all true, but still priced out of line for many of us that would like to
take it and would find it useful.

> 
> 
> Pete
> 
> "Controlling developers is like herding cats."
> Kevin Loney, Oracle DBA Handbook
> 
> "Oh no, it's not.  It's much harder than that!"
> Bruce Pihlamae, long term Oracle DBA.

"Remember automatic weapons are a good thing."
me ;-)

--
Bill "Shrek" Thater ORACLE DBA  BAARF Party member #25
[EMAIL PROTECTED]

The cosmological constant warps space-time the other way so that bodies move
apart. - Stephen Hawking on Einstein 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Thater, William
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the
message BODY, include a line containing: UNSUB ORACLE-L (or the name of
mailing list you want to be removed from).  You may also send the HELP
command for other information (like subscribing).

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

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the
message BODY, include a line containing: UNSUB ORACLE-L (or the name of
mailing list you want to be removed from).  You may also send the HELP
command for other information (like subscribing).



Note:
This message is for the named person's use only.  It may contain confidential, 
proprietary or legally privileged information.  No confidentiality or privilege is 
waived or lost by any mistransmission.  If you receive this message in error, please 
immediately delete it and all copies of it from your system, destroy any hard copies 
of it and notify the sender.  You must not, directly or indirectly, use, disclose, 
distribute, print, or copy any part of this message if you are not the int

RE: Oracle Masters exam

2003-09-05 Thread Thater, William
Pete Sharman  scribbled on the wall in glitter crayon:

> Funny, I found my cost (free) was acceptable ...   :)

hey, can i help it of Oracle wouldn't hire me?;-)

--
Bill "Shrek" Thater ORACLE DBA  BAARF Party member #25
[EMAIL PROTECTED]

IBM: Indigestion Bothers Me
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Thater, William
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).


DB2 has a foot in the door

2003-09-05 Thread Stephane Paquette
Hi all,

We're an Oracle shop, over 140 Oracle instances.
Today, architecture has chosen IBM DB2 for BI projects.
The next step I guessed will be to choose DB2 for the new transactionnal
applications also.

IBM offers DB2 at 25% less than Oracle.

I wonder if Oracle 10G will come with a new pricing structure ?


Stephane Paquette
Administrateur de bases de donnees
Database Administrator
Standard Life
www.standardlife.ca
Tel. (514) 499-7999 7470 and (514) 925-7187
[EMAIL PROTECTED] 




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

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).


RE: Oracle Masters exam

2003-09-05 Thread Thater, William
DENNIS WILLIAMS  scribbled on the wall in glitter crayon:

> Pete, Bill
> Just think though. If we'd been smart and acted like it was a
> terrific thing and anyone with an Oracle Masters was top notch, then
> maybe we wouldn't have to take all these darned tests.

damn!  NOW you tell me.;-)


--
Bill "Shrek" Thater ORACLE DBA  BAARF Party member #25
[EMAIL PROTECTED]

The significant problems we face today cannot be solved at the same level of
thinking we were at when we created them. - Albert Einstein
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Thater, William
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).


RE: Oracle Masters exam

2003-09-05 Thread Pete Sharman
Funny, I found my cost (free) was acceptable ...   :)


Pete

"Controlling developers is like herding cats."
Kevin Loney, Oracle DBA Handbook

"Oh no, it's not.  It's much harder than that!"
Bruce Pihlamae, long term Oracle DBA.



-Original Message-
Thater, William
Sent: Saturday, September 06, 2003 6:24 AM
To: Multiple recipients of list ORACLE-L


Pete Sharman  scribbled on the wall in glitter crayon:

> Just to clarify, the "old" Oracle Masters was only an indication that 
> you had attended a series of relevant training courses.  There was no 
> test, no measure of how well you could perform the role of a DBA.  The

> "new" Oracle Masters definitely addresses that issue.

all true, but still priced out of line for many of us that would like to
take it and would find it useful.

> 
> 
> Pete
> 
> "Controlling developers is like herding cats."
> Kevin Loney, Oracle DBA Handbook
> 
> "Oh no, it's not.  It's much harder than that!"
> Bruce Pihlamae, long term Oracle DBA.

"Remember automatic weapons are a good thing."
me ;-)

--
Bill "Shrek" Thater ORACLE DBA  BAARF Party member #25
[EMAIL PROTECTED]

The cosmological constant warps space-time the other way so that bodies
move apart. - Stephen Hawking on Einstein 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Thater, William
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the
message BODY, include a line containing: UNSUB ORACLE-L (or the name of
mailing list you want to be removed from).  You may also send the HELP
command for other information (like subscribing).

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

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).


Re: external procedure as not-oracle on OS

2003-09-05 Thread rgaffuri
you can do this all easily with a java stored procedure. alot less code. also, it will 
run as the DBA group on unix. 
there is an example in tom kytes book. Really short code. You can call any OS script 
with it. Might be on his website too. 

you then create a chmod script in unix that oracle has permissions to execute. That 
script will have permission to effect the users script.

Sound abstraction. Then Oracle can only effect the users script through your 
intermediary. 

> 
> From: "Henry Poras" <[EMAIL PROTECTED]>
> Date: 2003/09/05 Fri PM 04:29:26 EDT
> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> Subject: external procedure as not-oracle on OS
> 
> In order to run some OS commands from within the database we have set up a
> few external procedures. One of the functions we need to accomplish is to
> change the permissions of a file owned by a user other than oracle. As the
> external procedure is executed by Oracle, this is a problem. I tried
> changing the ownership of the .so file to the other user, setting the setuid
> bit, and granting oracle execute permissions on this file. That didn't work.
> Our next thought is to have the .so file call a C executable (set with the
> setuid bit) which will run chmod. The thought of one person here is that
> setuid is strictly for executables and .so is more of a
> library/collection-of-code, not strictly an exe. I'm not too clear on this
> differentiation. It's also an ugly solution, but that's the direction in
> which we are moving.
> 
> Has anyone come up with any other alternatives?
> 
> Thanks.
> 
> Henry
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: Henry Poras
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> 

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

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).


RE: Oracle Masters exam

2003-09-05 Thread DENNIS WILLIAMS
Pete, Bill
Just think though. If we'd been smart and acted like it was a terrific thing
and anyone with an Oracle Masters was top notch, then maybe we wouldn't have
to take all these darned tests.

Dennis Williams
DBA, 80%OCP, 100% DBA
Lifetouch, Inc.
[EMAIL PROTECTED] 


-Original Message-
Sent: Friday, September 05, 2003 3:24 PM
To: Multiple recipients of list ORACLE-L


Pete Sharman  scribbled on the wall in glitter crayon:

> Just to clarify, the "old" Oracle Masters was only an indication that
> you had attended a series of relevant training courses.  There was no
> test, no measure of how well you could perform the role of a DBA.  The
> "new" Oracle Masters definitely addresses that issue.

all true, but still priced out of line for many of us that would like to
take it and would find it useful.

> 
> 
> Pete
> 
> "Controlling developers is like herding cats."
> Kevin Loney, Oracle DBA Handbook
> 
> "Oh no, it's not.  It's much harder than that!"
> Bruce Pihlamae, long term Oracle DBA.

"Remember automatic weapons are a good thing."
me ;-)

--
Bill "Shrek" Thater ORACLE DBA  BAARF Party member #25
[EMAIL PROTECTED]

The cosmological constant warps space-time the other way so that bodies move
apart. - Stephen Hawking on Einstein 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Thater, William
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: DENNIS WILLIAMS
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).


RE: question for internals experts

2003-09-05 Thread Mladen Gogala
There are many references to TS# all over the place. If I were you, I
wouldn't 
try renaming it, without being in reallly dire straits.

--
Mladen Gogala
Oracle DBA 



-Original Message-
[EMAIL PROTECTED]
Sent: Friday, September 05, 2003 4:09 PM
To: Multiple recipients of list ORACLE-L


Does oracle store the tablespace_name or any data about a tablespace
anywhere else accept TS$? 

Im looking for base data dictionary tables. Not views. Are there any
documents out there about how oracle stores information in the data
dictionary tables other than what Steve Adams has in his book or on his
website? Has anyone else published on this? 

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

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the
message BODY, include a line containing: UNSUB ORACLE-L (or the name of
mailing list you want to be removed from).  You may also send the HELP
command for other information (like subscribing).




Note:
This message is for the named person's use only.  It may contain confidential, 
proprietary or legally privileged information.  No confidentiality or privilege is 
waived or lost by any mistransmission.  If you receive this message in error, please 
immediately delete it and all copies of it from your system, destroy any hard copies 
of it and notify the sender.  You must not, directly or indirectly, use, disclose, 
distribute, print, or copy any part of this message if you are not the intended 
recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to 
monitor all e-mail communications through its networks.
Any views expressed in this message are those of the individual sender, except where 
the message states otherwise and the sender is authorized to state them to be the 
views of any such entity.

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

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).


RE: Oracle Script Documentation

2003-09-05 Thread Jay Wade
Sounds like a project, I'll see if I can try to get each files brief 
definiation and then what it's calling scripts are.  Should be interesting 
to see that the dependencies are.


From: DENNIS WILLIAMS <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Subject: RE: Oracle Script Documentation
Date: Fri, 05 Sep 2003 07:24:29 -0800
Jay
   Here is your chance to join the big league and become an expert in your
own area. One thing I've noticed in tracing the scripts is that many of the
scripts call each other. Something like catproc must call dozens of the
other scripts. Not that much need to understand every low-level script. But
then there are probably some overlooked gems that we aren't aware of.
Dennis Williams
DBA, 80%OCP, 100% DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Friday, September 05, 2003 9:45 AM
To: Multiple recipients of list ORACLE-L
Hi Jay,

I know this is obvious but each script generally has a short description
at the top of each file. Some of these are pretty short one liners bear
in mind but it is a start!.
If you do find a complete list let us know it sounds like it could be
useful to know where a list for the future.
hth

kind regards

Pete
--
Pete Finnigan
email:[EMAIL PROTECTED]
Web site: http://www.petefinnigan.com - Oracle security audit specialists
Book:Oracle security step-by-step Guide - see http://store.sans.org for
details.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Pete Finnigan
  INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: DENNIS WILLIAMS
  INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
_
Send and receive larger attachments with Hotmail Extra Storage.   
http://join.msn.com/?PAGE=features/es

--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Jay Wade
 INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).


external procedure as not-oracle on OS

2003-09-05 Thread Henry Poras
In order to run some OS commands from within the database we have set up a
few external procedures. One of the functions we need to accomplish is to
change the permissions of a file owned by a user other than oracle. As the
external procedure is executed by Oracle, this is a problem. I tried
changing the ownership of the .so file to the other user, setting the setuid
bit, and granting oracle execute permissions on this file. That didn't work.
Our next thought is to have the .so file call a C executable (set with the
setuid bit) which will run chmod. The thought of one person here is that
setuid is strictly for executables and .so is more of a
library/collection-of-code, not strictly an exe. I'm not too clear on this
differentiation. It's also an ugly solution, but that's the direction in
which we are moving.

Has anyone come up with any other alternatives?

Thanks.

Henry

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

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).


RE: Oracle Masters exam

2003-09-05 Thread Thater, William
Pete Sharman  scribbled on the wall in glitter crayon:

> Just to clarify, the "old" Oracle Masters was only an indication that
> you had attended a series of relevant training courses.  There was no
> test, no measure of how well you could perform the role of a DBA.  The
> "new" Oracle Masters definitely addresses that issue.

all true, but still priced out of line for many of us that would like to
take it and would find it useful.

> 
> 
> Pete
> 
> "Controlling developers is like herding cats."
> Kevin Loney, Oracle DBA Handbook
> 
> "Oh no, it's not.  It's much harder than that!"
> Bruce Pihlamae, long term Oracle DBA.

"Remember automatic weapons are a good thing."
me ;-)

--
Bill "Shrek" Thater ORACLE DBA  BAARF Party member #25
[EMAIL PROTECTED]

The cosmological constant warps space-time the other way so that bodies move
apart. - Stephen Hawking on Einstein 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Thater, William
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).


question for internals experts

2003-09-05 Thread rgaffuri
Does oracle store the tablespace_name or any data about a tablespace anywhere else 
accept TS$? 

Im looking for base data dictionary tables. Not views. Are there any documents out 
there about how oracle stores information in the data dictionary tables other than 
what Steve Adams has in his book or on his website? Has anyone else published on this? 

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

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).


RE: Oracle Masters exam

2003-09-05 Thread Pete Sharman
Just to clarify, the "old" Oracle Masters was only an indication that
you had attended a series of relevant training courses.  There was no
test, no measure of how well you could perform the role of a DBA.  The
"new" Oracle Masters definitely addresses that issue.


Pete

"Controlling developers is like herding cats."
Kevin Loney, Oracle DBA Handbook

"Oh no, it's not.  It's much harder than that!"
Bruce Pihlamae, long term Oracle DBA.



-Original Message-
Ron Rogers
Sent: Friday, September 05, 2003 10:39 PM
To: Multiple recipients of list ORACLE-L


I have a certificate suitable for framing that states that I am a
"Database Administrator Oracle 7 Oracle Master". Does this new Oracle
Master negate my current  "Oracle Master" certification? Is there and
upgrade path available? Does it really matter? Every thing that I have
accomplished I have done for myself. I use the tests as a yard stick
against what I feel I want to accomplish. Does it matter that I have
one, or two, or three, or four "suitable for framing" papers on the
wall? With only a few years to go before I retire for the second time, I
think that I will concentrate my efforts on my grand kids rather that
getting paper for my walls. 
Ron mª¿ªm

>>> [EMAIL PROTECTED] 09/05/03 08:20AM >>>
- Original Message - 

> 
> It's too bad.  It seems like it would be fun.

What for?  Make the employer shell out another BIG bunch of notes? To
get a piece of paper that says on that date and with that hardware
one could perform a backup and a restore?   

What does that say about the ability to lead a group of developers, or
design the strategy for database access or solve a really nasty 
performance problem without forcing re-development or re-tooling? Or any
of a million other tasks truly knowledgeable people get asked to
perform?

No wonder TK doesn't want to talk about it: it's laughable,
and he prides himself in being a serious expert.

The single fact the masters was created is the perfect admission at long
last the OCP was nothing but a sham.  Everyone knows it, some just
insist on continuing the good old PC stuff (go with the flow,

let it ride, etc). It is the simple truth: its value as a
"certification" was and always will be nill.

That the masters is being sold as the new "be-all-end-all" is even more

demeaning.


> Chris
> 
> -Original Message-
> Sent: Thursday, September 04, 2003 10:20 AM
> To: Multiple recipients of list ORACLE-L
> 
> So, it's nothing like OCP where you get the certification when you
spew out 
> certain amount of the green stuff? I wonder how long will it take
before
> seeing
> oracle masters who don't know how to take a hot backup.

They'll be able to take a hot backup, rest assured.  
With milk and two sugars, please.

Cheers
Nuno Souto
[EMAIL PROTECTED] 

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

Fat City Network Services-- 858-538-5051 http://www.fatcity.com 
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the
message BODY, include a line containing: UNSUB ORACLE-L (or the name of
mailing list you want to be removed from).  You may also send the HELP
command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Ron Rogers
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the
message BODY, include a line containing: UNSUB ORACLE-L (or the name of
mailing list you want to be removed from).  You may also send the HELP
command for other information (like subscribing).

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

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).


RE: Net App Filer

2003-09-05 Thread DENNIS WILLIAMS
Binley - Yes, I probably didn't phrase that too well. My understanding is
that when you create an index on a table, Oracle has to scan the table at
least once, then write to the index. My point was that if both the table and
the index are on the NetApp, your performance might be lower. Thanks for the
tips you posted on the network configuration changes you may want to make to
increase performance. It was a couple of years ago when we acquired the
NetApp, and if we had the advice you provided it may have made a better
impression. I doubt if gigabit was available back then anyway.

Dennis Williams
DBA, 80%OCP, 100% DBA
Lifetouch, Inc.
[EMAIL PROTECTED] 


-Original Message-
Sent: Friday, September 05, 2003 11:50 AM
To: Multiple recipients of list ORACLE-L


That is a misconception - you do not reduce bidirectional traffic because
you are still reading/writing from the Filer.

However, you are mostly like to be seeing the effects of the different
levels of caching on the Filer itself, which translates through to a better
performance from your perspective.

- Original Message -

> For example, if I am building indexes it is useful to move the table to
attached disk and
> then build the index on the NetApp to reduce bidirectional traffic.
>


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

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: DENNIS WILLIAMS
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).


RE: Urgent INFO needed.

2003-09-05 Thread DENNIS WILLIAMS
Maria
   I just wanted to thank you for posting your views on the DBA situation
from your perspective. I always feel better informed when I have an
opportunity to hear opinions from people whose situation is different from
mine. And I agree with you that this is a valuable forum where people with a
staggering amount of expertise are willing to spend a few moments helping
you.

Dennis Williams
DBA, 80%OCP, 100% DBA
Lifetouch, Inc.
[EMAIL PROTECTED] 


-Original Message-
Sent: Friday, September 05, 2003 12:14 AM
To: Multiple recipients of list ORACLE-L


Yes, in your experience...and maybe most of the other lister's
experience...majority of the time its true...
That's because you people are the best DBAs I've seen...
Your experiences...10...15 years...some of you have a little over 3 years
and are
already experts...
Of course a lot of other people are less skilled than you are...
But I am not sure if you represent the rest of the US DBAs...or if I
represent the
rest of the 3rd world DBAs...
Again, as I have said...some peopler are just better than others...that's my
opinion...obviously, yours is a lot different than mine...

I don't know you, Joe, well enough to judge you.
So I won't call you names.

Joe Testa wrote:

> Fact of the matter is the majority of the time its true, like it or
> not.  Those of you who know me, know I DON'T do politically correct, I
> call a spade a spade.
>
> Its true at the officer level in a company(and I'm there in the company
> I'm in now), its all about dollars and cents, especially today.   Thats
> why you see it as much as you do.
>
> My example:  I worked for an online training company, they were paying
> me $25/hr to do online tutoring or web based oracle DBA classes., I was
> with them from the beginning just like alot of other tutors from around
> th world.  We were told in early/mid 2002, we've decided to outsource
> all tutoring to India, so if you're interested in teaching your
> replacements, we'll keep you on board for a little extra time.  The end
> was near and someone had asked me how long I'd been doing it, how long I
> was a DBA and how long did I plan on doing it, i gave them the truthful
> answer, about 4 yrs, 10 years as a DBA and not much longer since it was
> all being outsourced to India, got my a$$ fired from the job before my
> time was up.   Basically the concept was: "we can go to India and pay
> $2.50, 10% of what we pay you and we really dont care about the quality
> because they will pick up their English language from previous answers
> you and others have submitted to students throughout the years.".
>
> You tell me I  shouldn't have an attitude, you're as full of garbage as
> them.
>
> Joe
>
> PS: for those who want to know the company, email me direct, i'll be
> glad to share.
>
> Maria Aurora de la Vega wrote:
>
> > Its quite unfair for DBAs to blame their job loss/fear of job loss to
> > DBAs in India or some other countries with cheaper labor.
> > And to say that "you get what you pay for" or insinuating that cheaper
> > labor means less quality...is definitely out of line...
> > some people are just better than others...that's it...it has nothing
> > to do with geography or nationality...
> > some of the best DBAs...or IT professionals in general...are in fact
> > indians...
> > Point is its not the indians' fault jobs just come knocking at their
> > doors...
> > we all want better jobs and better pay...if it comes to me i'll grab
> > it no doubt... would I think about other DBAs who were taken off to
> > accomodate me? of course not. I have nothing to do with their decision
> > to outsource...and even if I stress myself worrying about it...can I
> > do anything about it? no...so, what do I do...I'd take advantage of
> > course...
> > I've come to believe no one is indispensable...even if you've served
> > 5, 10, 15 years in a company...there's always a reason to take you out
> > no matter how good you are...
> > And sometimes companies think...do I really need someone that good and
> > costs a lot more? or can we do with someone quite average but can get
> > the job done and costs a lot less?
> >
> > Tony Johnson wrote:
> >
> >>  All I know about it is that for every new job in India one more DBA
> >> is out of work here in the United States.
> >>
> >> -Original Message-
> >> *From:* Ora DBA [mailto:[EMAIL PROTECTED]
> >> *Sent:* Wednesday, September 03, 2003 5:30 AM
> >> *To:* Multiple recipients of list ORACLE-L
> >> *Subject:* Urgent INFO needed.
> >>
> >> Dear Friends,
> >>
> >> One of my friends has got the offer from CSC india ltd. Please
> >> respond this mail if any one from CSC india ltd? just to know
> >> some info , thats it.
> >>
> >> Any info regarding this is appreciated. Please give me your mail
> >> id and contacts..
> >>
> >> Thanks a lot.
> >>
> >> Regards
> >>
> >> Oracle DBA
> >>
> >>
-

Teenie Tiny 9iR2 Install Client Wanted

2003-09-05 Thread Odland, Brad
I want to get a 9iR2 client configured that trims all the flab

Oracle is mum on the subject and are quite satisfied at installing a gig of
client.

Even the min of 300MB is too much when it come to pushing several hundered
clients out...

ANyone have any thoughts, feelings, documents, links to some info on
this...?

Thnaks

BradO.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Odland, Brad
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).


Re: Oracle Script Documentation

2003-09-05 Thread Joe Testa
wish i still have some of that stuff but i did receive a patch set for 
oracle 7 on hpux that the developer forgot to turn off debugging for, 
something in it core dumped and the .trc file had C source code in it, 
back in my days of doing ALOT of C, i spoke to a developer and pointed 
out where a piece of the code had gone wacko(outside boundary of the 
array) and core dumped.

to this day i wish I'd kept that trace file.

joe

[EMAIL PROTECTED] wrote:

SQL.BSQ file that creates the data dictionary is neat. Its good for getting into arguments. Since alot of DBAs like to correct you when you say 'v$ view', they insist 'v$ table', you open sql.bsq and its 'create or replace view v_$'

There is alot of neat stuff in sql.bsq. Notes that were placed in years ago. Nothing insanely useful(though I havent exactly scoured it). 

The Standard package in sql.bsq is interesting because you see how oracle overloads the operatings like 'is not null'. Fairly similiar to how its done in 'C'. 

catalog scripts for creating the data dictionary views were boring and already well documented. I didnt find anything in there that I cant get off of the data dictionary doc on OTN or out of the source in DBA_VIEWS. 

Catproc files were somewhat useful. Though most of what is in the headers are on OTN. I heard that before Oracle 7.0, Oracle didnt encrypt the PL/SQL packages and you could actually read all the source code. 

anyone have a copy of that source code lying around? Id like a copy. 

 

From: DENNIS WILLIAMS <[EMAIL PROTECTED]>
Date: 2003/09/05 Fri AM 11:24:29 EDT
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Subject: RE: Oracle Script Documentation
Jay 
  Here is your chance to join the big league and become an expert in your
own area. One thing I've noticed in tracing the scripts is that many of the
scripts call each other. Something like catproc must call dozens of the
other scripts. Not that much need to understand every low-level script. But
then there are probably some overlooked gems that we aren't aware of.

Dennis Williams
DBA, 80%OCP, 100% DBA
Lifetouch, Inc.
[EMAIL PROTECTED] 

-Original Message-
Sent: Friday, September 05, 2003 9:45 AM
To: Multiple recipients of list ORACLE-L
Hi Jay,

I know this is obvious but each script generally has a short description
at the top of each file. Some of these are pretty short one liners bear
in mind but it is a start!.
If you do find a complete list let us know it sounds like it could be
useful to know where a list for the future.
hth

kind regards

Pete
--
Pete Finnigan
email:[EMAIL PROTECTED]
Web site: http://www.petefinnigan.com - Oracle security audit specialists
Book:Oracle security step-by-step Guide - see http://store.sans.org for
details.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Pete Finnigan
 INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: DENNIS WILLIAMS
 INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
   

 

--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Joe Testa
 INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).


Re: RE: Oracle Script Documentation

2003-09-05 Thread rgaffuri
SQL.BSQ file that creates the data dictionary is neat. Its good for getting into 
arguments. Since alot of DBAs like to correct you when you say 'v$ view', they insist 
'v$ table', you open sql.bsq and its 'create or replace view v_$'

There is alot of neat stuff in sql.bsq. Notes that were placed in years ago. Nothing 
insanely useful(though I havent exactly scoured it). 

The Standard package in sql.bsq is interesting because you see how oracle overloads 
the operatings like 'is not null'. Fairly similiar to how its done in 'C'. 

catalog scripts for creating the data dictionary views were boring and already well 
documented. I didnt find anything in there that I cant get off of the data dictionary 
doc on OTN or out of the source in DBA_VIEWS. 

Catproc files were somewhat useful. Though most of what is in the headers are on OTN. 
I heard that before Oracle 7.0, Oracle didnt encrypt the PL/SQL packages and you could 
actually read all the source code. 

anyone have a copy of that source code lying around? Id like a copy. 


> 
> From: DENNIS WILLIAMS <[EMAIL PROTECTED]>
> Date: 2003/09/05 Fri AM 11:24:29 EDT
> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> Subject: RE: Oracle Script Documentation
> 
> Jay 
>Here is your chance to join the big league and become an expert in your
> own area. One thing I've noticed in tracing the scripts is that many of the
> scripts call each other. Something like catproc must call dozens of the
> other scripts. Not that much need to understand every low-level script. But
> then there are probably some overlooked gems that we aren't aware of.
> 
> Dennis Williams
> DBA, 80%OCP, 100% DBA
> Lifetouch, Inc.
> [EMAIL PROTECTED] 
> 
> 
> -Original Message-
> Sent: Friday, September 05, 2003 9:45 AM
> To: Multiple recipients of list ORACLE-L
> 
> 
> Hi Jay,
> 
> I know this is obvious but each script generally has a short description
> at the top of each file. Some of these are pretty short one liners bear
> in mind but it is a start!.
> 
> If you do find a complete list let us know it sounds like it could be
> useful to know where a list for the future.
> 
> hth
> 
> kind regards
> 
> Pete
> -- 
> Pete Finnigan
> email:[EMAIL PROTECTED]
> Web site: http://www.petefinnigan.com - Oracle security audit specialists
> Book:Oracle security step-by-step Guide - see http://store.sans.org for
> details.
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: Pete Finnigan
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: DENNIS WILLIAMS
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> 

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

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).


RE: How to get the source code of the trigger without using

2003-09-05 Thread Mladen Gogala
Title: Message



Or, 
you can set event 10046, level 12 and look into the trace file. All SQL 
statements in the trigger should be in there,
which 
should give you a pretty good idea about what's in the trigger 
itself.
 
Or, 
you could do a systemdump level 10 and extract the trigger text from the shared 
pool dump.
 
Or, 
you could do full export and get the trigger text by using the "strings" 
command.
 
Or you 
could get the whole system tablespace in a hex viewer/editor and find your 
trigger. I recommend doing that on 
a live 
production database which is not in the archive log mode.
 
Personally, I opt for the DBA_TRIGGERS or USER_TRIGGERS. Why should I 
make a simple thing
so 
complicated.
 
 
--Mladen GogalaOracle DBA 

  
  -Original Message-From: 
  [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of raju 
  paSent: Friday, September 05, 2003 1:34 PMTo: Multiple 
  recipients of list ORACLE-LSubject: RE: How to get the source code 
  of the trigger without using
  You can ofcourse use enterprise manager. You would have to get the body 
  and other things like triggering event etc.
   
  To use the "Show SQL" option :  one trick to use is a space 
  some place (basically non-change) and hit "Show SQL". That should give 
  you the whole trigger sql. Good luck.
   
  * Jared :  I sent this post earlier but it did not go looks like 
  *
  Mladen Gogala <[EMAIL PROTECTED]> 
  wrote:
  Just 
kidding. --Mladen GogalaOracle DBA 
-Original Message-Wolfgang BreitlingSent: 
Friday, September 05, 2003 12:34 PMTo: Multiple recipients of list 
ORACLE-LWhy is it "far fetched and unnatural" ? In my view that 
is the only way to be sure to get the correct source.At 08:09 AM 
9/5/2003 -0800, you wrote:>Well, the idea of extracting it from 
user_triggers or dba_triggers is a >little far fetched and unnatural, 
but should work.Wolfgang BreitlingOracle7, 8, 8i, 9i OCP 
DBACentrex Consulting 
Corporationhttp://www.centrexcc.com-- Please see the 
official ORACLE-L FAQ: http://www.orafaq.net-- Author: Wolfgang 
BreitlingINET: [EMAIL PROTECTED]Fat City Network Services 
-- 858-538-5051 http://www.fatcity.comSan Diego, California -- Mail! ing 
list and web hosting 
services-To 
REMOVE yourself from this mailing list, send an E-Mail messageto: 
[EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in 
themessage BODY, include a line containing: UNSUB ORACLE-L (or the name 
ofmailing list you want to be removed from). You may also send the 
HELPcommand for other information (like 
subscribing).Note:This message is for the named 
person's use only. It may contain confidential, proprietary or legally 
privileged information. No confidentiality or privilege is waived or lost by 
any mistransmission. If you receive this message in error, please 
immediately delete it and all copies of it from your system, destroy any 
hard copies of it and notify the sender. You must not, directly or 
indirectly, use, disclose, distribute, print, or copy any part of this 
message if you are not the intended recipient. Wang Trading LL! C and any of 
its subsidiaries each reserve the right to monitor all e-mail communications 
through its networks.Any views expressed in this message are those of 
the individual sender, except where the message states otherwise and the 
sender is authorized to state them to be the views of any such 
entity.-- Please see the official ORACLE-L FAQ: 
http://www.orafaq.net-- Author: Mladen GogalaINET: 
[EMAIL PROTECTED]Fat City Network Services -- 858-538-5051 
http://www.fatcity.comSan Diego, California -- Mailing list and web 
hosting 
services-To 
REMOVE yourself from this mailing list, send an E-Mail messageto: 
[EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe 
message BODY, include a line containing: UNSUB ORACLE-L(or the name of 
mailing list you want to be removed from). You mayalso send the HELP 
command for other information (like subscribing).
  
  
  Do you Yahoo!?Yahoo! 
  SiteBuilder - Free, easy-to-use web site design 
software
 
Note:
This message is for the named person's use only.  It may contain 
confidential, proprietary or legally privileged information.  No 
confidentiality or privilege is waived or lost by any mistransmission.  If 
you receive this message in error, please immediately delete it and all 
copies of it from your system, destroy any hard copies of it and notify the 
sender.  You must not, directly or indirectly, use, disclose, distribute, 
print, or copy any part of this message if you are not the intended 
recipient. Wang Trading 
LLC and any of its subsidiaries each reserve the right to 
monitor all e-mail communications through its netwo

RE: Offshore threat

2003-09-05 Thread Wolfe Stephen S GS-11 6 MDSS/SGSI
Very insightful and I agree.

Note that my title is "Data Services Mgr." and in that role I do some
DBAing, need to learn a lot
More Oracle 'basic' keep it in the middle of the road stuff, but where I
make my biggest impact
And consistently win annual awards (I get coins (organizational coins --
big thing in the US military) and good ratings because I deliver data
when they (the 'lusers' who are dumb as a sack of rocks when it comes to
getting data -- as it should be) want it and how they want it.  I
provide them the data they need to 'empower' (one of their favorite
words) them in doing their jobs well -- whatever that may be.

In short, we work for and by the good graces of our respective lusers --
never lose sight of that.

v/r

Stephen S. Wolfe, GS-11, DAFC
Data Services Manager
[EMAIL PROTECTED]
(813) 827-9974  DSN 651-9974



> -Original Message-
> From: Nuno Souto [mailto:[EMAIL PROTECTED] 
> Sent: Friday, September 05, 2003 9:20 AM
> To: Multiple recipients of list ORACLE-L
> Subject: Re: Offshore threat
> 
> 
> - Original Message - 
> 
> 
> > It doesn't work in only one direction. While jobs are bieng lost to 
> > cheaper
> > labor markets, Indian companies now have to compete with 
> frighteningly
> > efficient
> > giants like Nike, Coca Cola, IBM, Microsoft, GM, Union 
> Carbide  and others.
> 
> On IT?  I thought we were talking about that?
> 
> > even with all our PHB's and damagement. How messed up is everybody 
> > else? The
> 
> You do NOT want to know, believe me...
> 
> > non-aggressive gentleman from India. Lawyers do need a killer 
> > instinct, DBAs do
> 
> Well, one of my colleagues likes to call me the "bad cop".  
> He calls himself the "worse cop".  He reckons we do the act 
> to perfection!  ;)
> 
> On the other hand: the BAs that work with me quietly leave 
> the room when I'm in one of my "low-sugar" days.  Let's just 
> say you're not the only 
> big fella: I'm well over 200 myself and most of it is the stuff that 
> can slam a golf ball 300 yards away...  :D  
> 
> But anyways, I'm not just a DBA anymore and that's what I 
> wanted to talk about.
> 
> > Here is our chance.
> > 
> 
> Hmmm, all serious now.  It's been obvious for years that being just a 
> DBA doesn't cut it any longer.  The traditional day-to-day 
> operation of the 
> VAST majority of databases does NOT warrant full employment 
> of a DBA.  
> 
> Note:
> I am NOT saying that a super-DBA isn't needed.  I'm saying that the
> vast majority of sites does NOT need one.  Which leaves a 
> VERY small market 
> for "supers" or "masters".
> 
> Now, markets being what they are and the fact that Indians 
> are a lot more
> than others except Chinese, dictates that for the vast 
> majority of sites out 
> there a junior DBA qualification is MORE than enough. Or even 
> an outsourced one.  
> 
> (there is NOTHING demeaning to Indians or Chinese in what I 
> just said.  
> So please, spare me the usual "offended Surat or Wong" crap.  
> I work with Chinese 
> and Indians and every single one of them knows EXACTLY what I 
> think about this and 
> no one is offended by it: on the contrary.  Glad we cleared 
> that. Let's move on.)
> 
> And it has NOTHING to do with the version of Oracle or how 
> automatic it is, 
> as much as it may pain Larry and his upgrade cycles.  You can 
> make V7.3 as reliable 
> and not needing maintenance as you will 10g and there is 
> nothing Larry can do about that.
> 
> It all depends on what the system is and what the 
> requirements are.  I know of a 
> Peoplesoft HR site that has been running a 7.3 server on NT4 
> for 8 years without 
> missing a beat.  Anyone wants to discuss value for money in this case?
> 
> What I suggest to other DBAs here is based on my own 
> experience in bridging
> the gap to do other things.  
> 
> Two simple key words: spread out.  
> One strategy: capitalise on your strengths.
> 
> Don't waste too long learning the intricacies of all those X$ 
> views: you are NOT 
> Steve Adams nor do you have his motivations and conditions.  
> And your employer 
> doesn't give a royal freakin damn if X$* are performance 
> monitoring views or 
> porn monitoring views.  By all means learn about their 
> existence.  And read
> about them.  But STOP RIGHT THERE.
> 
> Besides if you are truly going to take any advantage of all 
> that jazz, you'll 
> need access to the application code itself.  So you can 
> re-design certain aspects 
> and make them behave properly.  
> 
> Don't fool yourself: just exactly how many times have you 
> succeeded in doing that 
> with SAP OR JDE OR Peoplesoft? Or even that small third party 
> J2EE crap that eats 
> up CPU at a rate that makes Microsoft blush?  See what I 
> mean?  It helps if your 
> employer is a software house, but they are a MINORITY.  Forget it.
> 
> Of course we all like to argue and talk here about details of 
> obscure waits, setting
> event 1009812398901283948 forever on level 8127348 and 
> checking the eff

RE: How to get the source code of the trigger without using

2003-09-05 Thread raju pa
You can ofcourse use enterprise manager. You would have to get the body and other things like triggering event etc.
 
To use the "Show SQL" option :  one trick to use is a space some place (basically non-change) and hit "Show SQL". That should give you the whole trigger sql. Good luck.
 
* Jared :  I sent this post earlier but it did not go looks like *
Mladen Gogala <[EMAIL PROTECTED]> wrote:
Just kidding. --Mladen GogalaOracle DBA -Original Message-Wolfgang BreitlingSent: Friday, September 05, 2003 12:34 PMTo: Multiple recipients of list ORACLE-LWhy is it "far fetched and unnatural" ? In my view that is the only way to be sure to get the correct source.At 08:09 AM 9/5/2003 -0800, you wrote:>Well, the idea of extracting it from user_triggers or dba_triggers is a >little far fetched and unnatural, but should work.Wolfgang BreitlingOracle7, 8, 8i, 9i OCP DBACentrex Consulting Corporationhttp://www.centrexcc.com-- Please see the official ORACLE-L FAQ: http://www.orafaq.net-- Author: Wolfgang BreitlingINET: [EMAIL PROTECTED]Fat City Network Services -- 858-538-5051 http://www.fatcity.comSan Diego, California -- Mail!
ing list
 and web hosting services-To REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in themessage BODY, include a line containing: UNSUB ORACLE-L (or the name ofmailing list you want to be removed from). You may also send the HELPcommand for other information (like subscribing).Note:This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LL!
C and any
 of its subsidiaries each reserve the right to monitor all e-mail communications through its networks.Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity.-- Please see the official ORACLE-L FAQ: http://www.orafaq.net-- Author: Mladen GogalaINET: [EMAIL PROTECTED]Fat City Network Services -- 858-538-5051 http://www.fatcity.comSan Diego, California -- Mailing list and web hosting services-To REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like
 subscribing).
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software

RE: Oracle9iR2 - temporary tablespace usage error

2003-09-05 Thread Mladen Gogala
Title: Message



12913, 0, "Cannot create 
dictionary managed tablespace"// *Cause: Attemp to create dictionary managed 
tablespace in database// 
which has system tablespace as locally managed// *Action: Create a locally 
managed tablespace.
It's a 
feature, not a bug. Why would anyone want to go back to dictionary 
tablespaces?
 
 
--Mladen GogalaOracle DBA 

  
  -Original Message-From: 
  [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of April 
  WellsSent: Friday, September 05, 2003 10:10 AMTo: 
  Multiple recipients of list ORACLE-LSubject: RE: Oracle9iR2 - 
  temporary tablespace usage error 
  you can't have any dictionary managed tablespaces that are open for 
  write operations... dictionary managed read only tablespaces will still 
  work.
   
  I think you're right, temp isn't being freed up... or is something else 
  using it, or is the index creation just that huge?
   
  April Wells Oracle DBA/Oracle Apps DBA Corporate Systems Amarillo Texas   /\  /   \ / \ \ /   \/   >\<  \  >\<  
  \ Few people really enjoy the 
  simple pleasure of flying a kite Adam Wells age 11 
  
-Original Message-From: laura pena 
[mailto:[EMAIL PROTECTED]Sent: Friday, September 05, 
2003 8:59 AMTo: Multiple recipients of list 
ORACLE-LSubject: Oracle9iR2 - temporary tablespace usage error 

HI all,
 
I'm getting the following error when using temporary tablespace on a 
locally managed system tablespace. Seems if my system tablespace is locally 
managed I can not create a dictionary managed tablespace. 
 
Can anyone let me know if it is a bad idea to have system tablespace 
locally managed and why I am getting the following the error on building an 
index:
 
ERROR at line 1:ORA-01652: unable to extend temp segment by 128 in 
tablespace TEMP01
 
Also, I issue the following query and looks like the tempoary 
tablespace is not being free'ed up( or maybe this is not what this v$ tables 
is telling me):
 
select tablespace_name, file_id,bytes_used,bytes_freefrom 
v$temp_space_header;   
SQL> select tablespace_name,file_id,bytes_used,bytes_free   
2  from v$temp_space_header;
TABLESPACE_NAME   
FILE_ID BYTES_USED BYTES_FREE-- -- 
-- 
--TEMP01  
2 2146435072  
0
 
Thanks in advance.
Lizz
 
 


Do you Yahoo!?Yahoo! 
SiteBuilder - Free, easy-to-use web site design software
  


  The information contained in this communication, including attachments, is strictly 
confidential and for the intended use of the addressee only; it may also contain 
proprietary, price sensitive, or legally privileged information. Notice is hereby given that 
any disclosure, distribution, dissemination, use, or copying of the information by anyone 
other than the intended recipient is strictly prohibited and may be illegal. If you have 
received this communication in error, please notify the sender immediately by reply e-mail, 
delete this communication, and destroy all copies.
 

Corporate Systems, Inc. has taken reasonable precautions to ensure that any attachment to 
this e-mail has been swept for viruses. We specifically disclaim all liability and will 
accept no responsibility for any damage sustained as a result of software viruses and advise 
you to carry out your own virus checks before opening any attachment.

 
Note:
This message is for the named person's use only.  It may contain 
confidential, proprietary or legally privileged information.  No 
confidentiality or privilege is waived or lost by any mistransmission.  If 
you receive this message in error, please immediately delete it and all 
copies of it from your system, destroy any hard copies of it and notify the 
sender.  You must not, directly or indirectly, use, disclose, distribute, 
print, or copy any part of this message if you are not the intended 
recipient. Wang Trading 
LLC and any of its subsidiaries each reserve the right to 
monitor all e-mail communications through its networks.  Any views 
expressed in this message are those of the individual sender, except where the 
message states otherwise and the sender is authorized to state them to be the 
views of any such entity.
 
 



RE: How to get the source code of the trigger without using

2003-09-05 Thread Mladen Gogala
Just kidding. 

--
Mladen Gogala
Oracle DBA 



-Original Message-
Wolfgang Breitling
Sent: Friday, September 05, 2003 12:34 PM
To: Multiple recipients of list ORACLE-L


Why is it "far fetched and unnatural" ? In my view that is the only way to 
be sure to get the correct source.

At 08:09 AM 9/5/2003 -0800, you wrote:
>Well, the idea of extracting it from user_triggers or dba_triggers is a 
>little far fetched and unnatural, but should work.

Wolfgang Breitling
Oracle7, 8, 8i, 9i OCP DBA
Centrex Consulting Corporation
http://www.centrexcc.com


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

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the
message BODY, include a line containing: UNSUB ORACLE-L (or the name of
mailing list you want to be removed from).  You may also send the HELP
command for other information (like subscribing).




Note:
This message is for the named person's use only.  It may contain confidential, 
proprietary or legally privileged information.  No confidentiality or privilege is 
waived or lost by any mistransmission.  If you receive this message in error, please 
immediately delete it and all copies of it from your system, destroy any hard copies 
of it and notify the sender.  You must not, directly or indirectly, use, disclose, 
distribute, print, or copy any part of this message if you are not the intended 
recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to 
monitor all e-mail communications through its networks.
Any views expressed in this message are those of the individual sender, except where 
the message states otherwise and the sender is authorized to state them to be the 
views of any such entity.

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

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).


RE: How to get the source code of the trigger without using any t

2003-09-05 Thread Rudy Zung

Select from DBA/ALL/USER_SOURCE; if the source code looks
like a bunch of garbage, then it means the source code has
been "wrapped", which is Oracle's facility of obfuscate it
so that you can't read it.



-Original Message-
Sent: Friday, September 05, 2003 11:35 AM
To: Multiple recipients of list ORACLE-L
party tools?


Hi List,

Could you please help me to  get the source code of
the trigger without using any third party tools?

Thanks in advance,
Raj

__
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software
http://sitebuilder.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Oracle DBA
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Rudy Zung
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).


Re: Net App Filer

2003-09-05 Thread Binley Lim
That is a misconception - you do not reduce bidirectional traffic because
you are still reading/writing from the Filer.

However, you are mostly like to be seeing the effects of the different
levels of caching on the Filer itself, which translates through to a better
performance from your perspective.

- Original Message -

> For example, if I am building indexes it is useful to move the table to
attached disk and
> then build the index on the NetApp to reduce bidirectional traffic.
>


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

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).


RE: Oracle9iR2 - temporary tablespace usage error

2003-09-05 Thread srini . chavali

Mladen,
It's not buggy - I have used it without any side effects on 8.1.6 and 8.1.7. Works as advertised - for a change !
Srini Chavali
Oracle DBA
Cummins Inc







Mladen Gogala <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
09/05/2003 10:34 AM
Please respond to ORACLE-L

        
        To:        Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
        cc:        
        Subject:        RE: Oracle9iR2 - temporary tablespace usage error



You  can always try  DBMS_SPACE_ADMIN.TABLESPACE_MIGRATE_FROM_LOCAL. I've never tried  it,
it  might be buggy, but in theory, the procedure would go like  this:
1)  Create locally managed tablespace
2)  Read the manual/
3)  Migrate the tablespace local -> dictionary.
4)  Start wondering why did you do it.
 
 
--
Mladen Gogala
Oracle DBA 
-Original Message-
From:  [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of April  Wells
Sent: Friday, September 05, 2003 10:10 AM
To:  Multiple recipients of list ORACLE-L
Subject: RE: Oracle9iR2 -  temporary tablespace usage error 


you can't have any dictionary managed tablespaces that are open for  write operations... dictionary managed read only tablespaces will still  work.
 
I think you're right, temp isn't being freed up... or is something else  using it, or is the index creation just that huge?
 

April Wells 
Oracle DBA/Oracle Apps DBA 
Corporate Systems 
Amarillo Texas 
  /\ 
 /   \ 
/ \ 
\ / 
  \/ 
  >\< 
 \ 
 >\< 
   
Few people really enjoy the  simple pleasure of flying a kite 
Adam Wells age 11 
-Original Message-
From: laura pena  [mailto:[EMAIL PROTECTED]
Sent: Friday, September 05,  2003 8:59 AM
To: Multiple recipients of list  ORACLE-L
Subject: Oracle9iR2 - temporary tablespace usage error  


HI all,
 
I'm getting the following error when using temporary tablespace on a  locally managed system tablespace. Seems if my system tablespace is locally  managed I can not create a dictionary managed tablespace. 
 
Can anyone let me know if it is a bad idea to have system tablespace  locally managed and why I am getting the following the error on building an  index:
 
ERROR at line 1:
ORA-01652: unable to extend temp segment by 128 in  tablespace TEMP01
 
Also, I issue the following query and looks like the tempoary  tablespace is not being free'ed up( or maybe this is not what this v$ tables  is telling me):
 
select tablespace_name, file_id,bytes_used,bytes_free
from  v$temp_space_header;   
SQL> select tablespace_name,file_id,bytes_used,bytes_free 
   2  from v$temp_space_header;
TABLESPACE_NAME    FILE_ID BYTES_USED BYTES_FREE
-- --  --  --
TEMP01   2 2146435072   
 
Thanks in advance.
Lizz
 
 



Do you Yahoo!?
Yahoo!  SiteBuilder - Free, easy-to-use web site design software




The information contained in this communication, including attachments, is strictly 
confidential and for the intended use of the addressee only; it may also contain 
proprietary, price sensitive, or legally privileged information. Notice is hereby given that 
any disclosure, distribution, dissemination, use, or copying of the information by anyone 
other than the intended recipient is strictly prohibited and may be illegal. If you have 
received this communication in error, please notify the sender immediately by reply e-mail, 
delete this communication, and destroy all copies.
 

Corporate Systems, Inc. has taken reasonable precautions to ensure that any attachment to 
this e-mail has been swept for viruses. We specifically disclaim all liability and will 
accept no responsibility for any damage sustained as a result of software viruses and advise 
you to carry out your own virus checks before opening any attachment.


 
Note:
This message is for the named person's use only.  It may contain  confidential, proprietary or legally privileged information.  No  confidentiality or privilege is waived or lost by any mistransmission.  If  you receive this message in error, please immediately delete it and all  copies of it from your system, destroy any hard copies of it and notify the  sender.  You must not, directly or indirectly, use, disclose, distribute,  print, or copy any part of this message if you are not the intended  recipient. Wang Trading  LLC and any of its subsidiaries each reserve the right to  monitor all e-mail communications through its networks.  Any views  expressed in this message are those of the individual sender, except where the  message states otherwise and the sender is authorized to state them to be the  views of any such entity.
 
 



RE: How to get the source code of the trigger without using

2003-09-05 Thread Wolfgang Breitling
Why is it "far fetched and unnatural" ? In my view that is the only way to 
be sure to get the correct source.

At 08:09 AM 9/5/2003 -0800, you wrote:
Well, the idea of extracting it from user_triggers or dba_triggers is a
little far fetched
and unnatural, but should work.
Wolfgang Breitling
Oracle7, 8, 8i, 9i OCP DBA
Centrex Consulting Corporation
http://www.centrexcc.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Wolfgang Breitling
 INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).


Re: Net App Filer

2003-09-05 Thread Binley Lim

There are a number of gotchas, but if you are aware of them and configure
your system appropriately, Net App is a cost-effective proposition.

Unlike DAS, it does require DBA/Sysadmins to address issues they did not
have to before, especially MB/s, packets, jumbo frames,  trunking,
auto-negotiate, etc, etc. And be prepared for it to gobble up your CPU
cycles.

And dont' think about connecting older hardware/OS to it - it will work
because of generic NFS, but it will be inconvenient to put it mildly.
Gigabit connection should be minimal requirement.

- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Saturday, September 06, 2003 3:14 AM


> We use the net apps for a number of instances as well.  I'm would not
> recommend them for an IO intensive application.  If you are using a 100
> Mb connection your max aggregate throughput will be about 6MB per
> second, which is very bad.  Try performing backups over this.  If you do
> use them, gigabit connections are mandatory.  The net app docs walk you
> through the recommended setup (hard upd mount points with a set of
> mirrored red logs local).
>
> Regards,
>
> -Daniel
>
> --
> Daniel Harron
> Database Management
> IPsoft, Inc.
> [EMAIL PROTECTED]
> http://www.ip-soft.net/
> Phone: 888.IPSOFT8
> Fax: 801.681.7664
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Daniel Harron
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).

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

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).


RE: Net App Filer

2003-09-05 Thread Spears, Brian
I have TAKEN THE PLUNGE and using it for PRODUCTION...

ENRON used for all their production databases (100+ ) and they were several
hundred gig.

We are using a special Disaster recovery product of Netapps as well.


Brian 

-Original Message-
Sent: Friday, September 05, 2003 11:39 AM
To: Multiple recipients of list ORACLE-L


Daniel
   That was close to my experience. Very useful for test databases where
throughput isn't that important. We find it very useful to clone 100-gig
production databases so the users have a complete data set to perform
staging tests. The NetApp provides a lot of inexpensive storage. But I found
that I had to be careful to avoid overloading the connection. For example,
if I am building indexes it is useful to move the table to attached disk and
then build the index on the NetApp to reduce bidirectional traffic.

Dennis Williams
DBA, 80%OCP, 100% DBA
Lifetouch, Inc.
[EMAIL PROTECTED] 


-Original Message-
Sent: Friday, September 05, 2003 10:15 AM
To: Multiple recipients of list ORACLE-L


We use the net apps for a number of instances as well.  I'm would not
recommend them for an IO intensive application.  If you are using a 100
Mb connection your max aggregate throughput will be about 6MB per
second, which is very bad.  Try performing backups over this.  If you do
use them, gigabit connections are mandatory.  The net app docs walk you
through the recommended setup (hard upd mount points with a set of
mirrored red logs local).  

Regards,

-Daniel

-- 
Daniel Harron
Database Management
IPsoft, Inc.
[EMAIL PROTECTED]
http://www.ip-soft.net/
Phone: 888.IPSOFT8
Fax: 801.681.7664
 

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

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: DENNIS WILLIAMS
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Spears, Brian
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).


RE: How to get the source code of the trigger without using any third party tools?

2003-09-05 Thread Mladen Gogala
Well, the idea of extracting it from user_triggers or dba_triggers is a
little far fetched
and unnatural, but should work.

--
Mladen Gogala
Oracle DBA 



-Original Message-
Oracle DBA
Sent: Friday, September 05, 2003 11:35 AM
To: Multiple recipients of list ORACLE-L
party tools?


Hi List,

Could you please help me to  get the source code of
the trigger without using any third party tools?

Thanks in advance,
Raj

__
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software
http://sitebuilder.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Oracle DBA
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the
message BODY, include a line containing: UNSUB ORACLE-L (or the name of
mailing list you want to be removed from).  You may also send the HELP
command for other information (like subscribing).




Note:
This message is for the named person's use only.  It may contain confidential, 
proprietary or legally privileged information.  No confidentiality or privilege is 
waived or lost by any mistransmission.  If you receive this message in error, please 
immediately delete it and all copies of it from your system, destroy any hard copies 
of it and notify the sender.  You must not, directly or indirectly, use, disclose, 
distribute, print, or copy any part of this message if you are not the intended 
recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to 
monitor all e-mail communications through its networks.
Any views expressed in this message are those of the individual sender, except where 
the message states otherwise and the sender is authorized to state them to be the 
views of any such entity.

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

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).


Re: How to get the source code of the trigger without using any third party tools?

2003-09-05 Thread raju pa
You can use view all_triggers or user_triggers to get the entire text. trigger_body has the trigger text. triggering_event, trigger_type   , REFERENCING_NAMES etc have other details. You can also use enterprise manager to get it. One trick in enterprise manager is to add some spaces somewhere (a non change) in the trigger and hit 'show sql'. that will give u the whole sql. Verify and try it. Good luck. 
Oracle DBA <[EMAIL PROTECTED]> wrote:
Hi List,Could you please help me to get the source code ofthe trigger without using any third party tools?Thanks in advance,Raj__Do you Yahoo!?Yahoo! SiteBuilder - Free, easy-to-use web site design softwarehttp://sitebuilder.yahoo.com-- Please see the official ORACLE-L FAQ: http://www.orafaq.net-- Author: Oracle DBAINET: [EMAIL PROTECTED]Fat City Network Services -- 858-538-5051 http://www.fatcity.comSan Diego, California -- Mailing list and web hosting services-To REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list y!
ou want
 to be removed from). You mayalso send the HELP command for other information (like subscribing).
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software

Re: Oracle Standby Database Backups.

2003-09-05 Thread Arup Nanda



Vivek,
 
The origianl poster inquired on Physical Standby 
(in 8i and 9i) as opposed to logical standby (only in 9i). 
 
In physical standby, you don't have a choice of 
running the standby in noarchivelog mode. The control file is created from the 
primary as "standby controlfile" which is then implanted at the standby site. 
Therefore the LOGMODE is V$DATABASE is always ARCHIVELOG and the 
CONTROLFILE_TYPE is always "STANDBY".
 
I guess you are confused on the potential issue - 
when the logmode is archivelog, whether the standby generates archived log 
files. No, the standby does not generate archived logs since it does not excute 
transactions; it just applies the logs shipped from the primary. When you 
activate the standby to make it the primary, however, the archived logs are 
generated.
 
Hope this clears any confusion. Do let us know if 
you have more questions on this.
 
Arup Nanda
www.proligence.com

  - Original Message - 
  From: 
  VIVEK_SHARMA 
  To: [EMAIL PROTECTED] ; [EMAIL PROTECTED] 
  Cc: [EMAIL PROTECTED] 
  Sent: Friday, September 05, 2003 3:09 
  AM
  Subject: RE: Oracle Standby Database 
  Backups.
  
  
  Arup,Indy, 
  List 
   
  Some 
  Clarifications please
   
  If the Primary 
  Database is in ARCHIVELOG Mode (Physical Standby) & archived files there 
  from are being shipped & applied to the Standby Database, What is the need 
  to run the Standby Database in ARCHIVELOG Mode?
   
  Are you 
  implying 9i Dataguard with a Standby which works on a mechanism Other than 
  Log-shipping?
   
  Please give 
  detail 
   
  Thanks
   
   
   
   
   
  -Original 
  Message-From: Arup Nanda 
  [mailto:[EMAIL PROTECTED] Sent: Thursday, September 
  04, 2003 12:35 
  AMTo: Multiple recipients of list 
  ORACLE-LSubject: Re: Oracle 
  Standby Database Backups.
   
  
  Tom,
  
   
  
  You 
  should perform backups from the Standby database, regular RMAN backups, no 
  need to shutdown the database. Make sure you backup the archived log files 
  from there too. Contrary to what the docs might _imply_, I use the word 
  "imply" rather than "state", since the docs have been kind of ambiguous, the 
  archivedlog backups from the standby are perfectly alright to be used for 
  recoveries..
  
   
  
  You could 
  use the RMAN backup on the primary, but why? You would rather want to offload 
  the CPU cycles for RMAN to the standby database. In case of a failure in the 
  primary, your first option is to get the files from standby and recover them. 
  If standby is down too (as in case of a complete disaster), you would 
  reinstate the standby backup files to primary and you will be 
  ok.
  
   
  
  We are 
  using it to backup out 7 TB OLTP database.
  
   
  
  HTH.
  
   
  
  Arup
  

- 
Original Message - 

From: Mercadante, Thomas F 


To: Multiple recipients of list 
ORACLE-L 

Sent: Wednesday, September 
03, 2003 2:29 
PM

Subject: Oracle Standby 
Database Backups.

 

All,

We are in the 
beginning stages of designing a database with Oracle Standby 
capability.  The initial size of the database will be 600-800 
Gig.  The proposed database will be run on a IBM P690 with a mirrored 
fail-over machine.  Two separate machines with separate 
disk.  We are considering using Oracle Standby to have the 
database available as much as possible.

 

Do I 
need to perform regular backups of the Standby database?  Sounds like a 
silly question, but how do I do this?  Using Rman?  Or do I shut 
it down and perform a cold backup?  I will definitely use Rman on the 
primary database.  Just curious what you all would 
suggest.

 

Thanks 
in advance!
Tom 
Mercadante 
Oracle Certified 
Professional 


   


Re: How to get the source code of the trigger without using

2003-09-05 Thread Wolfgang Breitling
set long 32656
col trigger_body for a80 word
select trigger_body from dba_triggers where owner='xxx' and trigger_name = 
'yyy';

At 07:34 AM 9/5/2003 -0800, you wrote:
Hi List,

Could you please help me to  get the source code of
the trigger without using any third party tools?
Thanks in advance,
Raj
__
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software
http://sitebuilder.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Oracle DBA
  INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
Wolfgang Breitling
Oracle7, 8, 8i, 9i OCP DBA
Centrex Consulting Corporation
http://www.centrexcc.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Wolfgang Breitling
 INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).


RE: Offshore threat

2003-09-05 Thread Mladen Gogala
Two IBM mainframes stolen? Boy, the times are changing! To steal only a
single 3090 600J,
one would need a whole infantry division, not just two guys with a dolly. 
I bet they'll end up running Linux and having a ton of Jared's perl scripts
on them.

--
Mladen Gogala
Oracle DBA 



-Original Message-
Wolfe Stephen S GS-11 6 MDSS/SGSI
Sent: Friday, September 05, 2003 11:14 AM
To: Multiple recipients of list ORACLE-L


http://www.smh.com.au/articles/2003/09/04/1062548967124.html

A - This is social engineering at its finest.

B - There is no security without PHYSICAL security

C - If you don't check up on your outsourcer, then you can apparently get
the shirt stolen off your back...

 

v/r

Stephen S. Wolfe, GS-11, DAFC
Data Services Manager
[EMAIL PROTECTED]
(813) 827-9974  DSN 651-9974



> -Original Message-
> From: Stephane Paquette [mailto:[EMAIL PROTECTED]
> Sent: Thursday, September 04, 2003 3:15 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: Offshore threat
> 
> 
> When working at International Air Transport Association
> (IATA), the company moved around 60 jobs from Geneva and 
> London to Montreal because it was cheaper here.
> 
> This is all business as usual.
> 
> 
> 
> Stephane Paquette
> Administrateur de bases de donnees
> Database Administrator
> Standard Life
> www.standardlife.ca
> Tel. (514) 499-7999 7470 and (514) 925-7187
> [EMAIL PROTECTED] 
> 
> 
> 
> 
> -Original Message-
> Mercadante, Thomas F
> Sent: Thursday, September 04, 2003 2:50 PM
> To: Multiple recipients of list ORACLE-L
> 
> 
> This is all very funny and interesting.  Anybody read the
> story in yesterday's NY times?  Mexica has a concern that 
> their textile industry is being "stolen" by China because it 
> is cheaper to make products there than in Mexico. Sound familiar?
> 
> "This is the business we have chosen to be into"  Himen Roth
> (and I know spelled his first name wrong).
> 
> 
> -Original Message-
> Sent: Thursday, September 04, 2003 2:10 PM
> To: Multiple recipients of list ORACLE-L
> 
> 
> It doesn't work in only one direction. While jobs are bieng
> lost to cheaper labor markets, Indian companies now have to 
> compete with frighteningly efficient giants like Nike, Coca 
> Cola, IBM, Microsoft, GM, Union Carbide  and others. Local 
> companies are losing the market and have to reduce their 
> workforce, driving the cost of labor further down and closing 
> the vicious circle. What  is scary is the fact that we are an 
> order of magnitude more efficient then the rest of the world, 
> even with all our PHB's and damagement. How messed up is 
> everybody else? The only difference between a US DBA and a 
> cleaning leady, which has also been replaced by an immigrant 
> a long time ago, is the fact that the DBA has easier access 
> to the DBA mailing lists. If we weren't crying foul then, 
> there is no need to do it now. We will simply have to adjust 
> and do something else. The first thing that comes to mind is 
> becoming a lawyer. When I want to sue somebody, I'd like to 
> be represented by a cutthroat yankee lawyer, not by a very 
> polite and non-aggressive gentleman from India. Lawyers do 
> need a killer instinct, DBAs do not. For those of us who have 
> it, it's more of a hindrance then a useful tool. Lawyers and 
> politicians, fortunately for Indians, will never be 
> outsourced to India. Here is our chance.
> 
> 
> --
> Mladen Gogala
> Oracle DBA
> 
> 
> 
> -Original Message-
> Souto
> Sent: Thursday, September 04, 2003 12:55 PM
> To: Multiple recipients of list ORACLE-L
> 
> 
> LOL!
> 
> Funny how this "globalisation" bull only
> works in one direction, eh?
> 
> Cheers
> Nuno Souto
> [EMAIL PROTECTED]
> - Original Message -
> 
> > ** Another programmer who lost his job to an Indian outsourcer is
> > willing to relocate in India. But Indian officials have 
> told him they
> > don't hire Americans. Read about another politicized IT
> worker in "No
> > Americans Need Apply."
> 
> 
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Nuno Souto
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru')
> and in the message BODY, include a line containing: UNSUB 
> ORACLE-L (or the name of mailing list you want to be removed 
> from).  You may also send the HELP command for other 
> information (like subscribing).
> 
> 
> 
> Note:
> This message is for the named person's use only.  It may
> contain confidential, proprietary or legally privileged 
> information.  No confidentiality or privilege is waived or 
> lost by any mistransmission.  If you receive this message in 
> error, 

RE: RE: URGENT : sql*loader performance problem on partionned tab

2003-09-05 Thread NGUYEN Philippe (Cetelem)
Title: RE: RE: URGENT : sql*loader performance problem on partionned tab





here the trace :
SELECT STATEMENT, GOAL = CHOOSE         2   72  1368    
 FOR UPDATE                     
  FILTER                        
   PARTITION RANGE SINGLE                       
    TABLE ACCESS BY LOCAL INDEX ROWID   FICOM   HREL_FUSION 2   72  1368    
 INDEX RANGE SCAN   FICOM   IDX_HREL_FUSION_P_COD_REL   1   72      
   TABLE ACCESS BY INDEX ROWID  FICOM   PRIMEDI_ENR2_TEMP_FUSION    2   1   32  
    INDEX RANGE SCAN    FICOM   IDX_PRIMCOD_ENR2_TEMP_FUSION    1   1       



TIA


> 
> Philippe Nguyen
> CETELEM - Administration, Architecture Décisionnelle
> Direction Customer Relationship Management
> E-Mail : [EMAIL PROTECTED]
> Tel  : (+33) 1 46 39 92 16 - Fax : (+33) 1 46 39 59 88
> 



-Message d'origine-
De : [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Envoyé : 05 September 2003 00:09
À : Multiple recipients of list ORACLE-L
Objet : RE: RE: URGENT : sql*loader performance problem on partionned
tab



Did you explain plan? I suspect FTS taking place in case of NOT EXISTS.
It must be using Range scan for the non partitioned table.
Can you confirm / post the explain plan.


GovindanK



> Here the informations :
> table HREL_FUSION :
>   63 millions rows
>   3 indexes on columns : nodos_or, nodos_or, numcli <--- too much
> indexes ??
> table primedi_enr2_temp_fusion : 133 000 rows
>   I also took snaps with stastpack, can it help you ?
>   this table is recreated and re-analyze each day, but the hanging
> part of the scritp in located here :
>
> **
> SELECT NULL
> FROM hrel_fusion
> WHERE cod_rel = :b1
>   AND dat_rel = :b2
>   AND NOT EXISTS (SELECT NULL
>   FROM primedi_enr2_temp_fusion
>   WHERE primedi_enr2_temp_fusion.nodos_or =
> hrel_fusion.nodos_or
> AND primedi_enr2_temp_fusion.code_logis =
> hrel_fusion.cod_rel
> AND primedi_enr2_temp_fusion.date_logis =
> hrel_fusion.dat_rel)
> FOR UPDATE
> **
>
> The mostly amazing thing is that the same script work in 12 min on
> non-partitionned table.
>
> Here a subset of the script :
> ***
>
> cat <$maj_histo_rel
>
>
> set serveroutput on;
> DECLARE
>
> vt_code_logis   char(4);
> vt_date_logis   number(4);
> n   number;
>
> cursor curs_code_ctlm is
> select code_logis,date_logis from primedi_temp_fusion
> where exists (select null from $TABLE_RETOURS
> where $TABLE_RETOURS.code_logis=primedi_temp_fusion.code_logis
> and $TABLE_RETOURS.date_logis=primedi_temp_fusion.date_logis
> and $TABLE_RETOURS.code_ficom=primedi_temp_fusion.code_ficom
> )
> ;
>
>
> cursor curs_histo_ctlm1 (vt_code_logis char, vt_date_logis number) is
> select null from HREL_FUSION
> where cod_rel=vt_code_logis
> and dat_rel=vt_date_logis
> and not exists (select null from primedi_enr2_temp_fusion
> where
> primedi_enr2_temp_fusion.nodos_or=HREL_FUSION.nodos_or
> and
> primedi_enr2_temp_fusion.code_logis=HREL_FUSION.cod_rel
> and
> primedi_enr2_temp_fusion.date_logis=HREL_FUSION.dat_rel)
> for update
> ;
>
> BEGIN
> DBMS_OUTPUT.ENABLE(50);
> for curs in curs_code_ctlm
> loop
> n:=0;
>    for enr_histo in curs_histo_ctlm1
> (curs.code_logis,curs.date_logis) loop
>    delete from HREL_FUSION
>    where current of curs_histo_ctlm1;
>    n:=n+1;
>    --if (mod(n,5000) = 0) then
>  --commit;
>    --end if;
>    end loop;
>    --commit;
>    DBMS_OUTPUT.PUT_LINE('Supression de ' || n || ' ligne(s) '
> ||curs.code_logis || curs.date_logis || ' dans l historique HREL_FUSION');
>
>
>    -- update $TABLE_RETOURS
>    -- set DATE_MAJ=to_number(to_char(sysdate,'mmdd'))
>    -- where exists (select null from primedi_temp_fusion
> --  where curs.code_logis=$TABLE_RETOURS.code_logis
> --  and curs.date_logis=$TABLE_RETOURS.date_logis
> --  )
> --;
>
> end loop;
> COMMIT;
>
> END;
> /
> exit;
>
> EOD
> ***
>


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


Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California    -- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROT

RE: How to get the source code of the trigger without using any third party tools?

2003-09-05 Thread Goulet, Dick
User_source or DBA_source for procedures and USER_TRIGGERS or DBA_TRIGGERS for 
triggers.

Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA

-Original Message-
Sent: Friday, September 05, 2003 11:35 AM
To: Multiple recipients of list ORACLE-L
third party tools?


Hi List,

Could you please help me to  get the source code of
the trigger without using any third party tools?

Thanks in advance,
Raj

__
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software
http://sitebuilder.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Oracle DBA
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Goulet, Dick
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).


RE: Oracle9iR2 - temporary tablespace usage error

2003-09-05 Thread Mladen Gogala
Title: Message



You 
can always try  DBMS_SPACE_ADMIN.TABLESPACE_MIGRATE_FROM_LOCAL. I've never tried 
it,
it 
might be buggy, but in theory, the procedure would go like 
this:
1) 
Create locally managed tablespace
2) 
Read the manual/
3) 
Migrate the tablespace local -> dictionary.
4) 
Start wondering why did you do it.
 
 
--Mladen GogalaOracle DBA 

  
  -Original Message-From: 
  [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of April 
  WellsSent: Friday, September 05, 2003 10:10 AMTo: 
  Multiple recipients of list ORACLE-LSubject: RE: Oracle9iR2 - 
  temporary tablespace usage error 
  you can't have any dictionary managed tablespaces that are open for 
  write operations... dictionary managed read only tablespaces will still 
  work.
   
  I think you're right, temp isn't being freed up... or is something else 
  using it, or is the index creation just that huge?
   
  April Wells Oracle DBA/Oracle Apps DBA Corporate Systems Amarillo Texas   /\  /   \ / \ \ /   \/   >\<  \  >\<  
  \ Few people really enjoy the 
  simple pleasure of flying a kite Adam Wells age 11 
  
-Original Message-From: laura pena 
[mailto:[EMAIL PROTECTED]Sent: Friday, September 05, 
2003 8:59 AMTo: Multiple recipients of list 
ORACLE-LSubject: Oracle9iR2 - temporary tablespace usage error 

HI all,
 
I'm getting the following error when using temporary tablespace on a 
locally managed system tablespace. Seems if my system tablespace is locally 
managed I can not create a dictionary managed tablespace. 
 
Can anyone let me know if it is a bad idea to have system tablespace 
locally managed and why I am getting the following the error on building an 
index:
 
ERROR at line 1:ORA-01652: unable to extend temp segment by 128 in 
tablespace TEMP01
 
Also, I issue the following query and looks like the tempoary 
tablespace is not being free'ed up( or maybe this is not what this v$ tables 
is telling me):
 
select tablespace_name, file_id,bytes_used,bytes_freefrom 
v$temp_space_header;   
SQL> select tablespace_name,file_id,bytes_used,bytes_free   
2  from v$temp_space_header;
TABLESPACE_NAME   
FILE_ID BYTES_USED BYTES_FREE-- -- 
-- 
--TEMP01  
2 2146435072  
0
 
Thanks in advance.
Lizz
 
 


Do you Yahoo!?Yahoo! 
SiteBuilder - Free, easy-to-use web site design software
  


  The information contained in this communication, including attachments, is strictly 
confidential and for the intended use of the addressee only; it may also contain 
proprietary, price sensitive, or legally privileged information. Notice is hereby given that 
any disclosure, distribution, dissemination, use, or copying of the information by anyone 
other than the intended recipient is strictly prohibited and may be illegal. If you have 
received this communication in error, please notify the sender immediately by reply e-mail, 
delete this communication, and destroy all copies.
 

Corporate Systems, Inc. has taken reasonable precautions to ensure that any attachment to 
this e-mail has been swept for viruses. We specifically disclaim all liability and will 
accept no responsibility for any damage sustained as a result of software viruses and advise 
you to carry out your own virus checks before opening any attachment.

 
Note:
This message is for the named person's use only.  It may contain 
confidential, proprietary or legally privileged information.  No 
confidentiality or privilege is waived or lost by any mistransmission.  If 
you receive this message in error, please immediately delete it and all 
copies of it from your system, destroy any hard copies of it and notify the 
sender.  You must not, directly or indirectly, use, disclose, distribute, 
print, or copy any part of this message if you are not the intended 
recipient. Wang Trading 
LLC and any of its subsidiaries each reserve the right to 
monitor all e-mail communications through its networks.  Any views 
expressed in this message are those of the individual sender, except where the 
message states otherwise and the sender is authorized to state them to be the 
views of any such entity.
 
 



RE: Net App Filer

2003-09-05 Thread DENNIS WILLIAMS
Daniel
   That was close to my experience. Very useful for test databases where
throughput isn't that important. We find it very useful to clone 100-gig
production databases so the users have a complete data set to perform
staging tests. The NetApp provides a lot of inexpensive storage. But I found
that I had to be careful to avoid overloading the connection. For example,
if I am building indexes it is useful to move the table to attached disk and
then build the index on the NetApp to reduce bidirectional traffic.

Dennis Williams
DBA, 80%OCP, 100% DBA
Lifetouch, Inc.
[EMAIL PROTECTED] 


-Original Message-
Sent: Friday, September 05, 2003 10:15 AM
To: Multiple recipients of list ORACLE-L


We use the net apps for a number of instances as well.  I'm would not
recommend them for an IO intensive application.  If you are using a 100
Mb connection your max aggregate throughput will be about 6MB per
second, which is very bad.  Try performing backups over this.  If you do
use them, gigabit connections are mandatory.  The net app docs walk you
through the recommended setup (hard upd mount points with a set of
mirrored red logs local).  

Regards,

-Daniel

-- 
Daniel Harron
Database Management
IPsoft, Inc.
[EMAIL PROTECTED]
http://www.ip-soft.net/
Phone: 888.IPSOFT8
Fax: 801.681.7664
 

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

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: DENNIS WILLIAMS
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).


How to get the source code of the trigger without using any third party tools?

2003-09-05 Thread Oracle DBA
Hi List,

Could you please help me to  get the source code of
the trigger without using any third party tools?

Thanks in advance,
Raj

__
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software
http://sitebuilder.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Oracle DBA
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).


RE: Oracle Script Documentation

2003-09-05 Thread DENNIS WILLIAMS
Jay 
   Here is your chance to join the big league and become an expert in your
own area. One thing I've noticed in tracing the scripts is that many of the
scripts call each other. Something like catproc must call dozens of the
other scripts. Not that much need to understand every low-level script. But
then there are probably some overlooked gems that we aren't aware of.

Dennis Williams
DBA, 80%OCP, 100% DBA
Lifetouch, Inc.
[EMAIL PROTECTED] 


-Original Message-
Sent: Friday, September 05, 2003 9:45 AM
To: Multiple recipients of list ORACLE-L


Hi Jay,

I know this is obvious but each script generally has a short description
at the top of each file. Some of these are pretty short one liners bear
in mind but it is a start!.

If you do find a complete list let us know it sounds like it could be
useful to know where a list for the future.

hth

kind regards

Pete
-- 
Pete Finnigan
email:[EMAIL PROTECTED]
Web site: http://www.petefinnigan.com - Oracle security audit specialists
Book:Oracle security step-by-step Guide - see http://store.sans.org for
details.

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

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: DENNIS WILLIAMS
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).


RE: Net App Filer

2003-09-05 Thread Rachel Carmichael
NetApp Filer is a "special case" of NFS and is, in fact, supported by
Oracle


--- "Jesse, Rich" <[EMAIL PROTECTED]> wrote:
> I thought that Oracle datafiles over NFS was neither recommended nor
> supported.  Has this changed?
> 
> Rich
> 
> Rich Jesse   System/Database Administrator
> [EMAIL PROTECTED]  Quad/Tech Inc, Sussex, WI USA
> 
> 
> > -Original Message-
> > From: Brian Dunbar [mailto:[EMAIL PROTECTED]
> > Sent: Friday, September 05, 2003 8:30 AM
> > To: Multiple recipients of list ORACLE-L
> > Subject: RE: Net App Filer
> > 
> > 
> > Gunnar Berglund [mailto:[EMAIL PROTECTED] on 
> > Friday, September
> > 05, 2003 5:24 AM said;
> > 
> > > is anyone using Net App Filer -products with Oracle environment.
> > 
> > Yup.  Hosts a horde of databases for a medium sized outfit - 
> > pehaps 3000
> > employees, 24/7 manufacturing.
> > 
> > > What do you think?
> > 
> > I like it but I'm not the DBA.  It works for us, but might 
> > not be right for
> > a bigger company.  That said, most companies in the US ARE 
> > our size .. or
> > smaller.
> > 
> > > Advantages
> > 
> > Snapshot.  Best damn way to backup a box yet.  We 'snap' at 12 hour
> > intervals, it's a breeze to restore.  Off course, we still have
> tapes.
> > 
> > It's Unix, underneath.
> > 
> > Web Mgt interface makes doing admin chores easy.
> > 
> > Just Works - mount the Filer drives as NFS mounts from the host.
> > 
> > Support; Net App knows about problems at the same time we do. 
> >  A few times
> > our POC has gotten to work and found out about potential 
> > problems from a
> > chipper voice mail from Net App.
> > 
> > > Disadvantages
> > 
> > It was difficult getting to know the Filer at first - we had 
> > a difficult
> > time wrapping our heads around the whole idea.  Our DBA was 
> > .. dubious at
> > best about the prospect.  I think we've won him over.
> > 
> > ~brian
> > 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: Jesse, Rich
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).


__
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software
http://sitebuilder.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Rachel Carmichael
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).


RE: Offshore threat

2003-09-05 Thread Wolfe Stephen S GS-11 6 MDSS/SGSI
http://www.smh.com.au/articles/2003/09/04/1062548967124.html

A - This is social engineering at its finest.

B - There is no security without PHYSICAL security

C - If you don't check up on your outsourcer, then you can apparently
get the shirt stolen off your back...

 

v/r

Stephen S. Wolfe, GS-11, DAFC
Data Services Manager
[EMAIL PROTECTED]
(813) 827-9974  DSN 651-9974



> -Original Message-
> From: Stephane Paquette [mailto:[EMAIL PROTECTED] 
> Sent: Thursday, September 04, 2003 3:15 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: Offshore threat
> 
> 
> When working at International Air Transport Association 
> (IATA), the company moved around 60 jobs from Geneva and 
> London to Montreal because it was cheaper here.
> 
> This is all business as usual.
> 
> 
> 
> Stephane Paquette
> Administrateur de bases de donnees
> Database Administrator
> Standard Life
> www.standardlife.ca
> Tel. (514) 499-7999 7470 and (514) 925-7187 
> [EMAIL PROTECTED] 
> 
> 
> 
> 
> -Original Message-
> Mercadante, Thomas F
> Sent: Thursday, September 04, 2003 2:50 PM
> To: Multiple recipients of list ORACLE-L
> 
> 
> This is all very funny and interesting.  Anybody read the 
> story in yesterday's NY times?  Mexica has a concern that 
> their textile industry is being "stolen" by China because it 
> is cheaper to make products there than in Mexico. Sound familiar?
> 
> "This is the business we have chosen to be into"  Himen Roth 
> (and I know spelled his first name wrong).
> 
> 
> -Original Message-
> Sent: Thursday, September 04, 2003 2:10 PM
> To: Multiple recipients of list ORACLE-L
> 
> 
> It doesn't work in only one direction. While jobs are bieng 
> lost to cheaper labor markets, Indian companies now have to 
> compete with frighteningly efficient giants like Nike, Coca 
> Cola, IBM, Microsoft, GM, Union Carbide  and others. Local 
> companies are losing the market and have to reduce their 
> workforce, driving the cost of labor further down and closing 
> the vicious circle. What  is scary is the fact that we are an 
> order of magnitude more efficient then the rest of the world, 
> even with all our PHB's and damagement. How messed up is 
> everybody else? The only difference between a US DBA and a 
> cleaning leady, which has also been replaced by an immigrant 
> a long time ago, is the fact that the DBA has easier access 
> to the DBA mailing lists. If we weren't crying foul then, 
> there is no need to do it now. We will simply have to adjust 
> and do something else. The first thing that comes to mind is 
> becoming a lawyer. When I want to sue somebody, I'd like to 
> be represented by a cutthroat yankee lawyer, not by a very 
> polite and non-aggressive gentleman from India. Lawyers do 
> need a killer instinct, DBAs do not. For those of us who have 
> it, it's more of a hindrance then a useful tool. Lawyers and 
> politicians, fortunately for Indians, will never be 
> outsourced to India. Here is our chance.
> 
> 
> --
> Mladen Gogala
> Oracle DBA
> 
> 
> 
> -Original Message-
> Souto
> Sent: Thursday, September 04, 2003 12:55 PM
> To: Multiple recipients of list ORACLE-L
> 
> 
> LOL!
> 
> Funny how this "globalisation" bull only
> works in one direction, eh?
> 
> Cheers
> Nuno Souto
> [EMAIL PROTECTED]
> - Original Message -
> 
> > ** Another programmer who lost his job to an Indian outsourcer is 
> > willing to relocate in India. But Indian officials have 
> told him they 
> > don't hire Americans. Read about another politicized IT 
> worker in "No 
> > Americans Need Apply."
> 
> 
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Nuno Souto
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 
> and in the message BODY, include a line containing: UNSUB 
> ORACLE-L (or the name of mailing list you want to be removed 
> from).  You may also send the HELP command for other 
> information (like subscribing).
> 
> 
> 
> Note:
> This message is for the named person's use only.  It may 
> contain confidential, proprietary or legally privileged 
> information.  No confidentiality or privilege is waived or 
> lost by any mistransmission.  If you receive this message in 
> error, please immediately delete it and all copies of it from 
> your system, destroy any hard copies of it and notify the 
> sender.  You must not, directly or indirectly, use, disclose, 
> distribute, print, or copy any part of this message if you 
> are not the intended recipient. Wang Trading LLC and any of 
> its subsidiaries each reserve the right to monitor all e-mail 
> communications through its networks. Any vi

RE: Net App Filer

2003-09-05 Thread Daniel Harron
We use the net apps for a number of instances as well.  I'm would not
recommend them for an IO intensive application.  If you are using a 100
Mb connection your max aggregate throughput will be about 6MB per
second, which is very bad.  Try performing backups over this.  If you do
use them, gigabit connections are mandatory.  The net app docs walk you
through the recommended setup (hard upd mount points with a set of
mirrored red logs local).  

Regards,

-Daniel

-- 
Daniel Harron
Database Management
IPsoft, Inc.
[EMAIL PROTECTED]
http://www.ip-soft.net/
Phone: 888.IPSOFT8
Fax: 801.681.7664
 

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

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).


RE: Oracle9iR2 - temporary tablespace usage error

2003-09-05 Thread Hitchman, Peter



Hi,
There 
are a couple of issues here. Firstly you need to know that when you get the 
error about the "temp" segment when building the index, the segment in question 
is the index. It is just that when building the index Oracle creates a temp 
segment to sort the data in and to create the index in and when it finishes 
it changes the segment type to "index". But if it runs out of space trying to 
build the index, it reports the error about the segment without first 
changing the segment type.
 
When 
it comes to the temporary space in a tempfile temporary tablespace, Oracle never 
actually drops the extents that get allocated until the database is shutdown, 
instead they just get marked as being available when the session that first 
created them no longer needs them.
 
Regards
 
Pete

  -Original Message-From: laura pena 
  [mailto:[EMAIL PROTECTED]Sent: 05 September 2003 
  14:59To: Multiple recipients of list ORACLE-LSubject: 
  Oracle9iR2 - temporary tablespace usage error 
  HI all,
   
  I'm getting the following error when using temporary tablespace on a 
  locally managed system tablespace. Seems if my system tablespace is locally 
  managed I can not create a dictionary managed tablespace. 
   
  Can anyone let me know if it is a bad idea to have system tablespace 
  locally managed and why I am getting the following the error on building an 
  index:
   
  ERROR at line 1:ORA-01652: unable to extend temp segment by 128 in 
  tablespace TEMP01
   
  Also, I issue the following query and looks like the tempoary tablespace 
  is not being free'ed up( or maybe this is not what this v$ tables is telling 
  me):
   
  select tablespace_name, file_id,bytes_used,bytes_freefrom 
  v$temp_space_header;   
  SQL> select tablespace_name,file_id,bytes_used,bytes_free   
  2  from v$temp_space_header;
  TABLESPACE_NAME   
  FILE_ID BYTES_USED BYTES_FREE-- -- 
  -- 
  --TEMP01  
  2 2146435072  0
   
  Thanks in advance.
  Lizz
   
   
  
  
  Do you Yahoo!?Yahoo! 
  SiteBuilder - Free, easy-to-use web site design 
software



__

The information contained in this email is confidential and 
intended only for the use of the individual or entity named 
above. 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. Thomson Scientific will accept no responsibility 
or liability in respect to this email other than to the addressee. 
If you have received this communication in error, please 
notify us immediately via email: [EMAIL PROTECTED]
__



RE: Oracle9iR2 - temporary tablespace usage error

2003-09-05 Thread laura pena
Thanks,
Yes I have 200,000 millions row table ... I belive my tempoary tablespace is way too small.
 
-lizzApril Wells <[EMAIL PROTECTED]> wrote:


you can't have any dictionary managed tablespaces that are open for write operations... dictionary managed read only tablespaces will still work.
 
I think you're right, temp isn't being freed up... or is something else using it, or is the index creation just that huge?
 
April Wells Oracle DBA/Oracle Apps DBA Corporate Systems Amarillo Texas   /\  /   \ / \ \ /   \/   >\<  \  >\<  \ Few people really enjoy the simple pleasure of flying a kite Adam W!
ells age
 11 

-Original Message-From: laura pena [mailto:[EMAIL PROTECTED]Sent: Friday, September 05, 2003 8:59 AMTo: Multiple recipients of list ORACLE-LSubject: Oracle9iR2 - temporary tablespace usage error 
HI all,
 
I'm getting the following error when using temporary tablespace on a locally managed system tablespace. Seems if my system tablespace is locally managed I can not create a dictionary managed tablespace. 
 
Can anyone let me know if it is a bad idea to have system tablespace locally managed and why I am getting the following the error on building an index:
 
ERROR at line 1:ORA-01652: unable to extend temp segment by 128 in tablespace TEMP01
 
Also, I issue the following query and looks like the tempoary tablespace is not being free'ed up( or maybe this is not what this v$ tables is telling me):
 
select tablespace_name, file_id,bytes_used,bytes_freefrom v$temp_space_header;   
SQL> select tablespace_name,file_id,bytes_used,bytes_free   2  from v$temp_space_header;
TABLESPACE_NAME   FILE_ID BYTES_USED BYTES_FREE-- -- -- --TEMP01  2 2146435072  0
 
Thanks in advance.
Lizz
 
 


Do you Yahoo!?Yahoo! SiteBuilder - Free, easy-to-use web site design software



The information contained in this communication, including attachments, is strictly 
confidential and for the intended use of the addressee only; it may also contain 
proprietary, price sensitive, or legally privileged information. Notice is hereby given that 
any disclosure, distribution, dissemination, use, or copying of the information by anyone 
other than the intended recipient is strictly prohibited and may be illegal. If you have 
received this communication in error, please notify the sender immediately by reply e-mail, 
delete this communication, and destroy all copies.
 

Corporate Systems, Inc. has taken reasonable precautions to ensure that any attachment to 
this e-mail has been swept for viruses. We specifically disclaim all liability and will 
accept no responsibility for any damage sustained as a result of software viruses and advise 
you to carry out your own virus checks before opening any attachment.

Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software

Re: Oracle Script Documentation

2003-09-05 Thread Pete Finnigan
Hi Jay,

I know this is obvious but each script generally has a short description
at the top of each file. Some of these are pretty short one liners bear
in mind but it is a start!.

If you do find a complete list let us know it sounds like it could be
useful to know where a list for the future.

hth

kind regards

Pete
-- 
Pete Finnigan
email:[EMAIL PROTECTED]
Web site: http://www.petefinnigan.com - Oracle security audit specialists
Book:Oracle security step-by-step Guide - see http://store.sans.org for details.

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

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).


RE: Net App Filer

2003-09-05 Thread Jesse, Rich
I thought that Oracle datafiles over NFS was neither recommended nor
supported.  Has this changed?

Rich

Rich Jesse   System/Database Administrator
[EMAIL PROTECTED]  Quad/Tech Inc, Sussex, WI USA


> -Original Message-
> From: Brian Dunbar [mailto:[EMAIL PROTECTED]
> Sent: Friday, September 05, 2003 8:30 AM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: Net App Filer
> 
> 
> Gunnar Berglund [mailto:[EMAIL PROTECTED] on 
> Friday, September
> 05, 2003 5:24 AM said;
> 
> > is anyone using Net App Filer -products with Oracle environment.
> 
> Yup.  Hosts a horde of databases for a medium sized outfit - 
> pehaps 3000
> employees, 24/7 manufacturing.
> 
> > What do you think?
> 
> I like it but I'm not the DBA.  It works for us, but might 
> not be right for
> a bigger company.  That said, most companies in the US ARE 
> our size .. or
> smaller.
> 
> > Advantages
> 
> Snapshot.  Best damn way to backup a box yet.  We 'snap' at 12 hour
> intervals, it's a breeze to restore.  Off course, we still have tapes.
> 
> It's Unix, underneath.
> 
> Web Mgt interface makes doing admin chores easy.
> 
> Just Works - mount the Filer drives as NFS mounts from the host.
> 
> Support; Net App knows about problems at the same time we do. 
>  A few times
> our POC has gotten to work and found out about potential 
> problems from a
> chipper voice mail from Net App.
> 
> > Disadvantages
> 
> It was difficult getting to know the Filer at first - we had 
> a difficult
> time wrapping our heads around the whole idea.  Our DBA was 
> .. dubious at
> best about the prospect.  I think we've won him over.
> 
> ~brian
> 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jesse, Rich
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).


RE: Oracle9iR2 - temporary tablespace usage error

2003-09-05 Thread April Wells



you can't have any dictionary managed tablespaces that are open for write 
operations... dictionary managed read only tablespaces will still 
work.
 
I think you're right, temp isn't being freed up... or is something else 
using it, or is the index creation just that huge?
 
April Wells Oracle DBA/Oracle Apps DBA Corporate Systems Amarillo Texas   /\  /   \ / \ \ /   \/   
>\<  
\  
>\<  \ 
Few people really enjoy the simple 
pleasure of flying a kite Adam 
Wells age 11 

  -Original Message-From: laura pena 
  [mailto:[EMAIL PROTECTED]Sent: Friday, September 05, 2003 
  8:59 AMTo: Multiple recipients of list ORACLE-LSubject: 
  Oracle9iR2 - temporary tablespace usage error 
  HI all,
   
  I'm getting the following error when using temporary tablespace on a 
  locally managed system tablespace. Seems if my system tablespace is locally 
  managed I can not create a dictionary managed tablespace. 
   
  Can anyone let me know if it is a bad idea to have system tablespace 
  locally managed and why I am getting the following the error on building an 
  index:
   
  ERROR at line 1:ORA-01652: unable to extend temp segment by 128 in 
  tablespace TEMP01
   
  Also, I issue the following query and looks like the tempoary tablespace 
  is not being free'ed up( or maybe this is not what this v$ tables is telling 
  me):
   
  select tablespace_name, file_id,bytes_used,bytes_freefrom 
  v$temp_space_header;   
  SQL> select tablespace_name,file_id,bytes_used,bytes_free   
  2  from v$temp_space_header;
  TABLESPACE_NAME   
  FILE_ID BYTES_USED BYTES_FREE-- -- 
  -- 
  --TEMP01  
  2 2146435072  0
   
  Thanks in advance.
  Lizz
   
   
  
  
  Do you Yahoo!?Yahoo! 
  SiteBuilder - Free, easy-to-use web site design 
software
The information contained in this communication, including attachments, is strictly 
confidential and for the intended use of the addressee only; it may also contain 
proprietary, price sensitive, or legally privileged information. Notice is hereby given that 
any disclosure, distribution, dissemination, use, or copying of the information by anyone 
other than the intended recipient is strictly prohibited and may be illegal. If you have 
received this communication in error, please notify the sender immediately by reply e-mail, 
delete this communication, and destroy all copies.
 

Corporate Systems, Inc. has taken reasonable precautions to ensure that any attachment to 
this e-mail has been swept for viruses. We specifically disclaim all liability and will 
accept no responsibility for any damage sustained as a result of software viruses and advise 
you to carry out your own virus checks before opening any attachment.


Re: Offshore threat

2003-09-05 Thread Nuno Souto
- Original Message -


> forever. Now it's time to wake up and see that IT is becoming a job like
> another where you most hold to your job instead of going to job interview
> just for fun.
>

A lot of people don't believe this when I say it, but when I started in
IT in 1975 what we got now was quite normal.  Minus the foreign outsourcing phenomena.
We had service bureaus then, but they stayed in the same country.  Mostly.

To me, it's all back to normal.  Except I now earn a bucket load more.
Am I truly better off?  Nope: I have two kids, two dogs and a fat cat
to support...

¦Þ

Cheers
Nuno Souto
[EMAIL PROTECTED]

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

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).


RE: Problem querying remote table through a synonym

2003-09-05 Thread Ruth Gramolini
Try creating the synonym as a public synonym.  That will give everyone
privileges to it without granting them explicitly.

Ruth

> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of
> GovindanK
> Sent: Friday, September 05, 2003 4:10 AM
> To: Multiple recipients of list ORACLE-L
> Subject: Re: Problem querying remote table through a synonym
>
>
> Enable Network Tracing and check.
>
> GovindanK
>
> > I'm confused, has anyone ever seen something like this before?
> >
> > This query works as you can see:
> >
> > select count(*)
> > from [EMAIL PROTECTED];
> >
> >   COUNT(*)
> > --
> > 275375
> >
> > We execute the following DDL:
> >
> > DROP SYNONYM MV_USER_ENABLED_DOC_TYPE_PRIVS;
> >
> > CREATE SYNONYM MV_USER_ENABLED_DOC_TYPE_PRIVS
> >FOR [EMAIL PROTECTED];
> >
> > We run the following query:
> > select count(*)
> > from mv_user_enabled_doc_type_privs;
> >
> > The query hangs for over an hour before being killed.  When traced it
> > shows it is waiting for the other side to respond.
> >
> > On the other hand, if I do this you can see it works!
> >
> >   1* select count(*) from [EMAIL PROTECTED]
> > SQL> /
> >
> >   COUNT(*)
> > --
> >  0
> >
> > SQL> create synonym mine for [EMAIL PROTECTED];
> >
> > Synonym created.
> >
> > SQL> select count(*) from mine;
> >
> >   COUNT(*)
> > --
> >  0
> >
> > The hanging behavior is true for every table in the markview schema.
> >> Allan L. Nelson
> >> Oracle DBA
> >> M-I L.L.C.
> >> (832) 295-2238 office
> >> (832) 351-4180 fax
> >> [EMAIL PROTECTED] 
> >>
> >>
> >>
> >
> >
> __
> 
> > This email is intended solely for the person or entity to which it is
> > addressed and may contain confidential and/or privileged information.
> > Copying, forwarding or distributing this message by persons or entities
> > other than the addressee is prohibited. If you have received
> this email in
> > error, please contact the sender immediately and delete the
> material from
> > any computer.  This email may have been monitored for policy compliance.
> > [021216]
> >
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: GovindanK
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
>

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

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).


RE: latch free wait event

2003-09-05 Thread Cary Millsap
Yes. Even with TIMED_STATISTICS=TRUE, relying on *any* statistic with
system-wide scope can waste your time. For a 34-page introduction to the
rationale behind this proposition, see:

 http://www.oreilly.com/catalog/optoraclep/chapter/ch01.pdf


Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com

Upcoming events:
- Hotsos Clinic 101 in Sydney
- Hotsos Symposium 2004, March 7-10 Dallas
- Visit www.hotsos.com for schedule details...


-Original Message-
Wolfgang Breitling
Sent: Thursday, September 04, 2003 6:44 PM
To: Multiple recipients of list ORACLE-L

The number of waits is irrelevant. What matters is the time waited which
in 
your case shows 0, but I assume that is because you have not set 
timed_statistics to true. Without that the data from v$system_event are 
worthless. Cary will probably step in here and tell you that even with 
timed_statistics that data is at best of dubious worth.

At 02:49 PM 9/4/2003 -0800, you wrote:

> System-wide Wait Analysis
>  for current wait events
>
>
Average
>Event Total  SecondsTotal
Wait
>NameWaits  Waiting Timeouts  (in
secs)
>-   -   -   -
>---
>latch free1,4590 1,393
.000
>
>After querying v$system_event my biggest concern is the "latch free"
wait
>event. I understand that latch free is "the process waits for a latch
that
>is currently busy ( held by another process).How can I drill down
and
>find the cause of this?   I have a feeling it is about rollback or redo
>logs.
>
>thanks,
>
>
>
>David Ehresmann
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.net
>--
>Author: Ehresmann, David
>   INET: [EMAIL PROTECTED]
>
>Fat City Network Services-- 858-538-5051 http://www.fatcity.com
>San Diego, California-- Mailing list and web hosting services
>-
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from).  You may
>also send the HELP command for other information (like subscribing).

Wolfgang Breitling
Oracle7, 8, 8i, 9i OCP DBA
Centrex Consulting Corporation
http://www.centrexcc.com


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

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).


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

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).


RE: How can I measure my DB performance.

2003-09-05 Thread Stephane Paquette
15 minutes !

All our production db are set up at 1 hour interval.
A summary of the stats are centralized in 1 db and we keep that 2 months.
We go down to 10-15 minues to investigate problems.

I find a 15 minutes interval very short.

Thanks for the link to yapppack. We do a similar thing using a chart
software.

Stephane Paquette
Administrateur de bases de donnees
Database Administrator
Standard Life
www.standardlife.ca
Tel. (514) 499-7999 7470 and (514) 925-7187
[EMAIL PROTECTED] 



-Original Message-
[EMAIL PROTECTED]
Sent: Thursday, September 04, 2003 4:05 PM
To: Multiple recipients of list ORACLE-L


I too have mine setup to take a snapshot every 15 minutes.
Can you teach me how to automate purges using sppurge.sql ?
Thanks
.

- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Friday, August 29, 2003 06:04


> Start by installing and configuring statspack.
>
> I have mine setup to take a snapshot every 15 minutes.
>
> It collects a lot of data, I am now in the midst of automating a purge
> process.  :)
>
> Then implement YAPPPACK from http://www.miracleas.dk/en/tech.html
> and use the data to create response time charts.
>
> At least, that's one way to do it.
>
> Jared
>
>
>
>
>
>
> Jake Johnson <[EMAIL PROTECTED]>
> Sent by: [EMAIL PROTECTED]
>  08/28/2003 04:59 PM
>  Please respond to ORACLE-L
>
>
> To: Multiple recipients of list ORACLE-L
<[EMAIL PROTECTED]>
> cc:
> Subject:How can I measure my DB performance.
>
>
> Is there a standard query I can run to compare the performance of a db.
> (Kind of like bogomips for unix)
>
> Thanks,
> Jake Johnson
> [EMAIL PROTECTED]
>
> __
> Plutoid - http://www.plutoid.com - Shop Plutoid for the best prices on
> Rims, Tires, and Wheel Packages.
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Jake Johnson
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
>
>
>

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

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

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

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).


RE: Oracle Masters exam

2003-09-05 Thread Thater, William
Nuno Souto  scribbled on the wall in glitter crayon:

>> If the OCP Masters credentials
>> are worth the money, then spend it. If they are not, don't spend it.
>> If enough people don't spend the money, then something will happen.
>> Thats how a market driven economy works. 
>> 
> 
> Exactly.  Another "certification" will crop up.  And another.

and, for me anyway since my company won't help pay for any training, if it's
worth it or not i can't afford it.  so if Oracle prices it out of my reach,
they loose.

--
Bill "Shrek" Thater ORACLE DBA  BAARF Party member #25
[EMAIL PROTECTED]

The life of man is the true romance, which when it is valiantly conducted,
will yield the imagination a higher joy than any fiction. - Ralph Waldo
Emerson
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Thater, William
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).


RE: Offshore threat

2003-09-05 Thread Stephane Paquette
By business as usual, I meant that executives always try to save money and
will always do.

Now, IT is targeted. And pepople in IT find that very difficult because the
pay has been very good since 5-7 years and most people thought it would last
forever. Now it's time to wake up and see that IT is becoming a job like
another where you most hold to your job instead of going to job interview
just for fun.

Since Canada is always behind, that offshore thing will start kicking in a
few months here :-(


Stephane

-Original Message-
Nuno Souto
Sent: Friday, September 05, 2003 9:35 AM
To: Multiple recipients of list ORACLE-L


Well, you could find a job in Canada, no?
Can you find one in India too? I don't think so.
So it's not business as usual.
Cheers
Nuno Souto
[EMAIL PROTECTED]
- Original Message -
> When working at International Air Transport Association (IATA), the
company
> moved around 60 jobs from Geneva and London to Montreal because it was
> cheaper here.
>
> This is all business as usual.
>


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

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

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

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).


Oracle9iR2 - temporary tablespace usage error

2003-09-05 Thread laura pena
HI all,
 
I'm getting the following error when using temporary tablespace on a locally managed system tablespace. Seems if my system tablespace is locally managed I can not create a dictionary managed tablespace. 
 
Can anyone let me know if it is a bad idea to have system tablespace locally managed and why I am getting the following the error on building an index:
 
ERROR at line 1:ORA-01652: unable to extend temp segment by 128 in tablespace TEMP01
 
Also, I issue the following query and looks like the tempoary tablespace is not being free'ed up( or maybe this is not what this v$ tables is telling me):
 
select tablespace_name, file_id,bytes_used,bytes_freefrom v$temp_space_header;   
SQL> select tablespace_name,file_id,bytes_used,bytes_free   2  from v$temp_space_header;
TABLESPACE_NAME   FILE_ID BYTES_USED BYTES_FREE-- -- -- --TEMP01  2 2146435072  0
 
Thanks in advance.
Lizz
 
 
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software

Re: Wel it appears the 10g world is coming soon

2003-09-05 Thread John Shaw


I'd love to see what you 
come up with on this one. >>> [EMAIL PROTECTED] 9/4/2003 
11:59:31 AM >>>
During my free time(ha, between developing pages for kid's soccer 
association, redcross instructor and board member, family, work), are 
you all interested in my discoveries when i start trudging thru the 10G 
world?if so i'll pick up the "new features for 10g" series when i 
can get my hands on it.email me direct not to the list 
please.mailto:[EMAIL PROTECTED]joe-- 
Joseph S TestaChief Technology Officer Data Management 
Consultingp: 614-791-9000f: 614-791-9001-- Please see 
the official ORACLE-L FAQ: http://www.orafaq.net-- Author: Joe 
Testa  INET: [EMAIL PROTECTED]Fat City Network 
Services    -- 858-538-5051 http://www.fatcity.comSan Diego, 
California    -- Mailing list and web 
hosting 
services-To 
REMOVE yourself from this mailing list, send an E-Mail messageto: 
[EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message 
BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list 
you want to be removed from).  You mayalso send the HELP command for 
other information (like subscribing).


Re: Offshore threat

2003-09-05 Thread Nuno Souto
Well, you could find a job in Canada, no?
Can you find one in India too? I don't think so.
So it's not business as usual.
Cheers
Nuno Souto
[EMAIL PROTECTED]
- Original Message - 
> When working at International Air Transport Association (IATA), the company
> moved around 60 jobs from Geneva and London to Montreal because it was
> cheaper here.
> 
> This is all business as usual.
> 


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

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).


Re: 600-[25012] on delete of IOT table

2003-09-05 Thread GovindanK
Earlier post did not reach. Hence Reposting.
> Take a look at the Metalink  Note:125149.1
> ALERT: ONLINE Index Rebuild or IOT Table Move can Produce Corrupt Index
> As per the note it affects 8.1.(5/6/7).x
>
> It has the relevant info.
>
> Also take a look at the Docid: 287936.999.
>
> HTH
> GovindanK
>
>> Sun solaris 8/oracle 8.1.7.2 64bit.
>>
>> After some database defrag(via alter table xxx move and alter index xxx
>> rebuild), I got 600-25012 from my delete session and alert file.
>>
>>
>> SQL>  DELETE FROM EOI_PDTLIST WHERE ROWNUM=1;
>>  DELETE FROM EOI_PDTLIST WHERE ROWNUM=1
>>  *
>> ERROR at line 1:
>> ORA-00600: internal error code, arguments: [25012], [15], [32], [], [],
>> [], [],
>> []
>>
>> This is index organized table with overflow segment.
>> Maybe I foget to move that overflow segment, after move overflow segment
>> ,
>> delete is ok.
>>
>> But according to metalink ,maybe there is data corruption. So I ask here
>> if friends in this list has also hit this nasty problem too.
>>
>>
>> Fri Sep  5 04:29:58 2003
>> Errors in file /export/home/oracle/admin/biddb/udump/biddb_ora_3602.trc:
>> ORA-00600: internal error code, arguments: [25012], [15], [32], [], [],
>> [], [], []
>> Fri Sep  5 04:30:33 2003
>> Errors in file /export/home/oracle/admin/biddb/udump/biddb_ora_3602.trc:
>> ORA-00600: internal error code, arguments: [25012], [15], [32], [], [],
>> [], [], []
>> Fri Sep  5 04:36:08 2003
>>
>> I dbved the datafiles of that tablespace , nothing wrong.
>> My account in metalink cannot open Itar now:(
>> Thanks
>>
>> Zhu Chao
>> www.cnoug.org
>>
>> --
>> Please see the official ORACLE-L FAQ: http://www.orafaq.net
>> --
>> Author: chao_ping
>>   INET: [EMAIL PROTECTED]
>>
>> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
>> San Diego, California-- Mailing list and web hosting services
>> -
>> To REMOVE yourself from this mailing list, send an E-Mail message
>> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
>> the message BODY, include a line containing: UNSUB ORACLE-L
>> (or the name of mailing list you want to be removed from).  You may
>> also send the HELP command for other information (like subscribing).
>>
>
>

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

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).


Oracle Script Documentation

2003-09-05 Thread Jay
Hello:

I was wondering if anyone knew of a source that listed what each of the
scripts in RDBMS (catproc, etc) functionality.
So far I have only been able to find a small listing (10 common scripts),
and was hoping someone might have a more complete list.
I know that they are different version to version but I am just looking for
a high level description.

Thanks in advance,
Jay
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jay
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).


Re: Re: "Application DBA"

2003-09-05 Thread Nuno Souto
- Original Message - 

> 
> Degree/OCP achievement doesn't teach f all - in my opinion - though it
> does prove your memory isn't shot. 

I can think of much cheaper and much more reliable and credible ways of 
checking my memory...  :)

> lot. The reason, for example, that I personally prefer graduates to
> non-graduates *experience equal* is that generally graduates are better
> thinkers and problem solvers. 

Agreed 100%.  But OCP is NOT a graduation, and it will NEVER be one.
Until it is part of an official education syllabus.  And not part of
Larry's or any other commercial organization's pockets.  And yes, I'm
against private education.  For a number of reasons that are not
pertinent here.

> is worth it, the certificate probably not. Of course as far as
> recruiters are concerned ensuring your CV includes the words 'I don't
> have an OCP because...' followed by a decent explanation will generally
> get you through all the filters that say OCP required/preferred. Ain't
> software great.

Hehehe!   :D

> 
> On "architects", and at least in the UK, those who advertise themselves
> as such in the IT field are breaking the law
> 
> http://www.hmso.gov.uk/acts/acts1997/97022--f.htm#20

wish it was the same here


Cheers
Nuno Souto
[EMAIL PROTECTED]

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

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).


RE: Net App Filer

2003-09-05 Thread Brian Dunbar
Gunnar Berglund [mailto:[EMAIL PROTECTED] on Friday, September
05, 2003 5:24 AM said;

> is anyone using Net App Filer -products with Oracle environment.

Yup.  Hosts a horde of databases for a medium sized outfit - pehaps 3000
employees, 24/7 manufacturing.

> What do you think?

I like it but I'm not the DBA.  It works for us, but might not be right for
a bigger company.  That said, most companies in the US ARE our size .. or
smaller.

> Advantages

Snapshot.  Best damn way to backup a box yet.  We 'snap' at 12 hour
intervals, it's a breeze to restore.  Off course, we still have tapes.

It's Unix, underneath.

Web Mgt interface makes doing admin chores easy.

Just Works - mount the Filer drives as NFS mounts from the host.

Support; Net App knows about problems at the same time we do.  A few times
our POC has gotten to work and found out about potential problems from a
chipper voice mail from Net App.

> Disadvantages

It was difficult getting to know the Filer at first - we had a difficult
time wrapping our heads around the whole idea.  Our DBA was .. dubious at
best about the prospect.  I think we've won him over.

~brian
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Brian Dunbar
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).


Re: Offshore threat

2003-09-05 Thread Nuno Souto
- Original Message - 


> It doesn't work in only one direction. While jobs are bieng lost to cheaper 
> labor markets, Indian companies now have to compete with frighteningly
> efficient
> giants like Nike, Coca Cola, IBM, Microsoft, GM, Union Carbide  and others.

On IT?  I thought we were talking about that?

> even with all our PHB's and damagement. How messed up is everybody else? The

You do NOT want to know, believe me...

> non-aggressive gentleman from India. Lawyers do need a killer instinct, DBAs
> do

Well, one of my colleagues likes to call me the "bad cop".  He calls himself
the "worse cop".  He reckons we do the act to perfection!  ;)

On the other hand: the BAs that work with me quietly leave the room
when I'm in one of my "low-sugar" days.  Let's just say you're not the only 
big fella: I'm well over 200 myself and most of it is the stuff that 
can slam a golf ball 300 yards away...  :D  

But anyways, I'm not just a DBA anymore and that's what I wanted to talk about.

> Here is our chance. 
> 

Hmmm, all serious now.  It's been obvious for years that being just a 
DBA doesn't cut it any longer.  The traditional day-to-day operation of the 
VAST majority of databases does NOT warrant full employment of a DBA.  

Note:
I am NOT saying that a super-DBA isn't needed.  I'm saying that the
vast majority of sites does NOT need one.  Which leaves a VERY small market 
for "supers" or "masters".

Now, markets being what they are and the fact that Indians are a lot more
than others except Chinese, dictates that for the vast majority of sites out 
there a junior DBA qualification is MORE than enough. Or even an outsourced one.  

(there is NOTHING demeaning to Indians or Chinese in what I just said.  
So please, spare me the usual "offended Surat or Wong" crap.  I work with Chinese 
and Indians and every single one of them knows EXACTLY what I think about this and 
no one is offended by it: on the contrary.  Glad we cleared that. Let's move on.)

And it has NOTHING to do with the version of Oracle or how automatic it is, 
as much as it may pain Larry and his upgrade cycles.  You can make V7.3 as reliable 
and not needing maintenance as you will 10g and there is nothing Larry can do about 
that.

It all depends on what the system is and what the requirements are.  I know of a 
Peoplesoft HR site that has been running a 7.3 server on NT4 for 8 years without 
missing a beat.  Anyone wants to discuss value for money in this case?

What I suggest to other DBAs here is based on my own experience in bridging
the gap to do other things.  

Two simple key words: spread out.  
One strategy: capitalise on your strengths.

Don't waste too long learning the intricacies of all those X$ views: you are NOT 
Steve Adams nor do you have his motivations and conditions.  And your employer 
doesn't give a royal freakin damn if X$* are performance monitoring views or 
porn monitoring views.  By all means learn about their existence.  And read
about them.  But STOP RIGHT THERE.

Besides if you are truly going to take any advantage of all that jazz, you'll 
need access to the application code itself.  So you can re-design certain aspects 
and make them behave properly.  

Don't fool yourself: just exactly how many times have you succeeded in doing that 
with SAP OR JDE OR Peoplesoft? Or even that small third party J2EE crap that eats 
up CPU at a rate that makes Microsoft blush?  See what I mean?  It helps if your 
employer is a software house, but they are a MINORITY.  Forget it.

Of course we all like to argue and talk here about details of obscure waits, setting
event 1009812398901283948 forever on level 8127348 and checking the effect of 
that on X$MXYZPTLK.  However, that has its place and time.

The problem is: if you do that on your company's place and time and you can't come 
up at the end of it with a tangible and LARGE improvement in profitability (stuff 
the performance, profit is where it's at!), you are toast in the eyes of your boss.  
And with good reason: you are an expensive overhead and a pretentious git who thinks 
he's a Steve Adams.  

Sorry to be brutal.  I warned I AM nasty, so there!  :D

Take it from someone who was a "DBA-only" 7 years ago, folks: change.  
Now.

Cheers
Nuno Souto
[EMAIL PROTECTED]

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

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).


Re: Listener problem on one client computer

2003-09-05 Thread GovindanK
Damien
Your gesture is appreciated.  It is a must that such solutions are shared
with the list members.

GovindanK

> Thank you very mutch for your replys,
>
> Today I finally found the problem. The traceroute shows the good route,
> but a Ms Proxy Client installed on the server blocked the request
> apparently. Just disabling it resolve everything.
>
> Damien
>
>
> Damien wrote:
>
>>I have to do netstat -a on the webserver or on the Oracle server?
>>Listener.ora is on the oracle server or on the webserver?
>>
>>I don't have any access on the oracle server and nobody can help on this
>>side.
>>
>>
>>Best regards,
>>
>>Damien
>>
>>- Original Message -
>>To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
>>Sent: Tuesday, September 02, 2003 9:14 PM
>>
>>
>>
>>
The ports are the same, I've checked the tnsnames.ora files
and copied &
pasted the content of the box who work on the web server.
Still same prob.

How can I check if i can open the port? It's a Win2000 server.




>>>To see if your Win2K server listens on port 1521 open MSDOS 'box'
>>>and type:
>>>
>>>C:\>netstat -n
>>>
>>>Among (many) other things you should see something of this sort:
>>>
>>>Active Connections
>>>
>>>  Proto  Local Address  Foreign AddressState
>>>  TCP192.168.200.38:1031192.168.200.38:1521ESTABLISHED
>>>  TCP192.168.200.38:1521192.168.200.38:1031ESTABLISHED
>>>
>>>You could also check contents of LISTENER.ORA file as it should list
>>>host name, protocol and listening port.
>>>
>>>You've mentioned that your problem is inability to acces database
>>>from the web server. Normally web server should be sitting in
>>>"insulated" DMZ environmemt, and there *should* be a firewall betweeen
>>>database and your web server. May be that's the part you are not aware
>>>of and/or not under your control, or it might happen that somebody
>>>changed firewall rules leaving your SQL*Net sessions on "dry".
>>>
>>>If you do have DMZ, you should either have "SQL*Net aware" firewall or
>>>you could force Oracle to use static port (look for Metalink Note:
>>>66382.1) as normally SQL*Net ports are dynamically negotiated, and
>>>only initial connection negotiation starts on port 1521.
>>>
>>>Branimir
>>>
>>>--
>>>Please see the official ORACLE-L FAQ: http://www.orafaq.net
>>>--
>>>Author: Branimir Petrovic
>>>  INET: [EMAIL PROTECTED]
>>>
>>>Fat City Network Services-- 858-538-5051 http://www.fatcity.com
>>>San Diego, California-- Mailing list and web hosting services
>>>-
>>>To REMOVE yourself from this mailing list, send an E-Mail message
>>>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
>>>the message BODY, include a line containing: UNSUB ORACLE-L
>>>(or the name of mailing list you want to be removed from).  You may
>>>also send the HELP command for other information (like subscribing).
>>>
>>>
>>>
>>
>>
>>
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Damien Babilon
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
>

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

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).


RE: Oracle Masters exam

2003-09-05 Thread Chris Stephens
Well, personally, I'm a bit of a scatter brain and enjoy things to work
towards.  When I was just starting out, the OCP stuff was a challenge and I
used it to 'learn' Oracle.  For each test I ended up learning way more than
necessary and got a lot of practical experience.  The Masters exam would
provide another reason to focus again.  Right now, it seems like I just read
books and often feel overwhelmed by how much I could be learning in the
'next' book or manual.  it's a personality thing.  ..i am certainly
not trying to climb the corporate ladder through bs accomplishments.  I
dropped out of a graduate cis program with 1 semester left because I
couldn't stand how fake it was.  Everyone and their mother was cheating and
the teachers were passing people who should have been in high school.  As
soon as I got a job, I stoppedand it was not because it was hard. it
would have gotten me one piece of paper without much more effort.

Different strokes for different folks.

chris

-Original Message-
Sent: Friday, September 05, 2003 7:20 AM
To: Multiple recipients of list ORACLE-L

- Original Message - 

> 
> It's too bad.  It seems like it would be fun.

What for?  Make the employer shell out another BIG bunch of notes?
To get a piece of paper that says on that date and with that hardware
one could perform a backup and a restore?   

What does that say about the ability to lead a group of developers,
or design the strategy for database access or solve a really nasty 
performance problem without forcing re-development or re-tooling?
Or any of a million other tasks truly knowledgeable people get asked
to perform?

No wonder TK doesn't want to talk about it: it's laughable,
and he prides himself in being a serious expert.

The single fact the masters was created is the perfect admission
at long last the OCP was nothing but a sham.  Everyone knows it,
some just insist on continuing the good old PC stuff (go with the flow, 
let it ride, etc). It is the simple truth: its value as a "certification"
was and always will be nill.

That the masters is being sold as the new "be-all-end-all" is even more 
demeaning.


> Chris
> 
> -Original Message-
> Sent: Thursday, September 04, 2003 10:20 AM
> To: Multiple recipients of list ORACLE-L
> 
> So, it's nothing like OCP where you get the certification when you spew
out 
> certain amount of the green stuff? I wonder how long will it take before
> seeing
> oracle masters who don't know how to take a hot backup.

They'll be able to take a hot backup, rest assured.  
With milk and two sugars, please.

Cheers
Nuno Souto
[EMAIL PROTECTED]

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

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Chris Stephens
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).


Re: Oracle Masters exam

2003-09-05 Thread Ron Rogers
I have a certificate suitable for framing that states that I am a
"Database Administrator Oracle 7 Oracle Master". Does this new Oracle
Master negate my current  "Oracle Master" certification? Is there and
upgrade path available? Does it really matter? Every thing that I have
accomplished I have done for myself. I use the tests as a yard stick
against what I feel I want to accomplish. Does it matter that I have
one, or two, or three, or four "suitable for framing" papers on the
wall? With only a few years to go before I retire for the second time, I
think that I will concentrate my efforts on my grand kids rather that
getting paper for my walls. 
Ron mª¿ªm

>>> [EMAIL PROTECTED] 09/05/03 08:20AM >>>
- Original Message - 

> 
> It's too bad.  It seems like it would be fun.

What for?  Make the employer shell out another BIG bunch of notes?
To get a piece of paper that says on that date and with that hardware
one could perform a backup and a restore?   

What does that say about the ability to lead a group of developers,
or design the strategy for database access or solve a really nasty 
performance problem without forcing re-development or re-tooling?
Or any of a million other tasks truly knowledgeable people get asked
to perform?

No wonder TK doesn't want to talk about it: it's laughable,
and he prides himself in being a serious expert.

The single fact the masters was created is the perfect admission
at long last the OCP was nothing but a sham.  Everyone knows it,
some just insist on continuing the good old PC stuff (go with the flow,

let it ride, etc). It is the simple truth: its value as a
"certification"
was and always will be nill.

That the masters is being sold as the new "be-all-end-all" is even more

demeaning.


> Chris
> 
> -Original Message-
> Sent: Thursday, September 04, 2003 10:20 AM
> To: Multiple recipients of list ORACLE-L
> 
> So, it's nothing like OCP where you get the certification when you
spew out 
> certain amount of the green stuff? I wonder how long will it take
before
> seeing
> oracle masters who don't know how to take a hot backup.

They'll be able to take a hot backup, rest assured.  
With milk and two sugars, please.

Cheers
Nuno Souto
[EMAIL PROTECTED] 

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

Fat City Network Services-- 858-538-5051 http://www.fatcity.com 
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Ron Rogers
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).


  1   2   >