date:20030905

- Original Message - 


 dollar cost of that. I remind you folks that Oracle is a for profit venture.
 It's not Oracle's responsibility to make anything affordable. It's the
 responsibility of Oracle to generate revenue, it is the expectation of
 Oracle shareholders (of which I am one) that Oracle will do such a thing. I
 don't care if Larry is the 6th richest guy in the universe, so what? Why
 does that compel him to give you anything?

I'm a shareholder too and I expect its value to go up.  If Oracle has a 
predatory attitude and a bad image in the market, their long term future and 
value for me as a shareholder is damaged.  I don't give a rat's arse about 
initiatives that deal with short term profit grabbing, if I know they'll damage 
the company (and my share value) in the long term.  

It's got nothing to do with Oracle being a charity or not.  It's got EVERYTHING 
to do with their shares RETAINING their value in the long term.  Which I as a 
shareholder demand.  I'm not interested in bubbles.

 It's all pure market driven. If people stop signing up for classes or OCP
 exams, Oracle will in quick fashion figure out why and change things. 

They have: they created the masters.  MOTS.

 If
 people keep signing up for classes and taking the OCP, then viola, 

no.  voila.  viola is a musical instrument.

 they have
 hit the sweet spot and will generate some revenue too. 
 

Exactly how big is that revenue and how much of it goes to
third party organisations instead of Oracle shareholders is what 
I want to know.


 Socialism doesn't work folks, let's face it. 

What's share value got to do with socialism?


 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.
In the meantime, the shareholder value is eroded.  Since no one
in his right mind will want any part of a company that can't get
it right.


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: Oracle Masters exam

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

RE: get sid (session id) and serial#?

2003-09-05 Thread Ron Rogers

On our production database there is the ability for the users to query
the database with some long running, date intensive queries. We came up
with a method of having the user kill is't own process if needed. 
We user roles to allow the users acces to the data. Granted select on
V_$MYSTAT  AND V_$SESSION to the role. 
Created a special ID that has the ability to kill the sessions.
When needed the application will select the session_id and serial# and
pass it on the the special ID and it will kill the session.
Works great and the users do not have access to anything except what is
granted in the role.
Ron

 [EMAIL PROTECTED] 09/05/03 04:09AM 
A good response Arup, gave me food for thought, now for some food for
my stomach!

Thanks

John

-Original Message-
Sent: 01 September 2003 18:14
To: Multiple recipients of list ORACLE-L


It's hardly illogical. The purpose of this view is not to provide the
SID of
the current session, but to show statistics, some of which the DBA may
not
want a user to know in all cases. Therefore the view is granted to a
role
SELECT_CATALOG_ROLE, similar to most other dictionary views. Any user
with
that role can see the view.

However, granting the role SELECT_CATALOG_ROLE to all users is not
advisable
at all. If a user needs it, a very simple grant select on v_$mystat
to
username can be issued which will resolve the problem. At a
development
site, or a site where the security for this view is not quite
pronounced,
you can issue the follwing which will make everyone see this view.

grant select on v_$mystat to public;

This will make the view visible to even the users created after this
command. The decision to hide this view from normal users is
deliberate; but
breaking that lock is not hard either using a simple grant as shown.

Going back to the discussion on why it has been so hard for a user to
know
his/her SID - why does a user need to know the SID? To alter the DBA
for
some monitoring action and seeing the SID will help the DBA see that
in
V$SESSION? In that case, the proper technique is to set the client
identifier using DBMS_APPLICATION_INFOR.SET_IDENTIFIER procedure. The
value
shows up in v$session, no need to know the SID.

What else? In a web app maintain state between pages using SID? this
approach is fraight with errors. First, SID is not guaranteed to be
unique;
SID and SERIAL# combination is. To guarantee a unique identifier, use
the
function DBMS_SESSION.UNIQUE_SESSION_ID to get an id that is unique in
a
session and use it to maintain state.

If it is necessary that the user must know the SID, then the V$MYSTAT
can be
queried.

Hope this helps.

Arup Nanda

- Original Message - 
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Monday, September 01, 2003 4:54 AM


 It does seem illogical than Oracle provide a view called mystat
which
tells you about your own statistics, including SID and yet a normal
user
does not have access to that view unless specifically given.

 John

 -Original Message-
 Sent: 30 August 2003 15:04
 To: Multiple recipients of list ORACLE-L


  But the user need select access to v$mystat

 connect as sysdba and grant select on v_$mystat to user;

 HTH
 GovindanK

  Thanks all for the input.
 
  the script is select sid,serial# from v$session where sid=(select
sid
from
  v$mystat where rownum=1)
 
  But the user need select access to v$mystat
 
  Chuan
 
  -Original Message-
  Sent: Friday, 29 August 2003 15:19
  To: Multiple recipients of list ORACLE-L
 
 
  Hi Chuan,
 
  can v$session help you
 
  this view has information like machine, osuser, username, sid,
program,
  and
  others
 
  SQL desc v$session
 
  SQL select columns,... from v$session where username = 'SCOTT'
and
  machine
  = 'YOUR_HOSTNAME'
 
  if you do telnet you will get 2 rows (if scoot is only use by you)
 
  is not
 
  Sinardy
 
  -Original Message-
  Sent: 29 August 2003 12:34
  To: Multiple recipients of list ORACLE-L
 
 
  DABs,
 
Is there any way in my connection to get the sid and serial# for
my
own
  connection?
 
  Suppose I connect to Oracle db by sqlplus scott/[EMAIL PROTECTED]
  In this connection,
 
  SQL
 
  What shoud I input to get this sid and serial#?
 
  TIA
 
  Chuan
  Important: This transmission is intended only for the use of the
addressee
  and may contain confidential or legally privileged information.  If
you
  are
  not the intended recipient, you are notified that any use or
dissemination
  of this communication is strictly prohibited.  If you receive this
  transmission in error please notify the author immediately by
telephone
  and
  delete all copies of this transmission together with any
attachments.
 
  --
  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

Re: Re: Oracle Masters exam

OCM is about marketing. consulting companies will use that to sell their consultants. 
Ive noticed that alot of employers and co-workers are more likely to listen to someone 
who is certified than someone who isnt. Its one of the reasons, Im getting mine. Makes 
it easier to get people to do what I want. 

I had an interview once and before I talked to the DBA, I talked to HR. I asked the HR 
person how experience the DBA was and such and he responded in an irreverent tone that 
the DBA is an 'Oracle Certified Professional'. Almost in awe... 

Awe is useful when your in a hurry and need people to do what you want. Its not your 
fault other people hold it in such high value. I have no control over them.
 
 From: Nuno Souto [EMAIL PROTECTED]
 Date: 2003/09/05 Fri AM 08:20:13 EDT
 To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
 Subject: Re: Oracle Masters exam
 
 - 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: [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 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).

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: 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 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: 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: Re: Application DBA

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

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

Re: Offshore threat

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

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

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] mailto:[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: 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: 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] mailto:[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: Offshore threat

- 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: 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: 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 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: 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 inand when it finishes 
it changes the segment type to "index". But if it runs out of space trying to 
build the index, itreports 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: 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: 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] 
 mailto:[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 views expressed in 
 this message are those of the individual sender, except where 
 the message states otherwise and the sender is authorized to

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

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: Net App Filer

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

RE: Oracle9iR2 - temporary tablespace usage error

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

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
LLCand 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 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: 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 EOD $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 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

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] 
 mailto:[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

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: 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 
  archivedlogbackups 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 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: How to get the source code of the trigger without using any third party tools?

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

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: 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 LLCand 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 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: 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: How to get the source code of the trigger without using

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: Oracle9iR2 - temporary tablespace usage error

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

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

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

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

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 textby 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 
LLCand any of its subsidiaries each reserve the right to 
monitor all e-mail communications through its networks. Any views

Re: RE: Oracle Script Documentation

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

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: Urgent INFO needed.

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
 
 

  Do you Yahoo!?
  Yahoo! SiteBuilder
  http://us.rd.yahoo.com/evt=10469/*http://sitebuilder.yahoo.com
  - Free, easy-to-use web site

RE: Net App Filer

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

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

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

RE: question for internals experts

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 Masters exam

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: external procedure as not-oracle on OS

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

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] mailto:[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

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

RE: Oracle Masters exam

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 intended 
recipient. Wang Trading

RE: DB2 has a foot in the door

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] mailto:[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 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 see the official ORACLE-L FAQ:

RE: Oracle Masters exam

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 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 ORACLE-L (or the name of
mailing

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

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: DB2 has a foot in the door

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] mailto:[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).

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

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: Another great respone from Oracle support (not really Friday

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 
LLCand 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: No more Oracle development here

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: 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.orafaq.net
 -- 
 Author: Pete Sharman
   INET: [EMAIL PROTECTED]

 Fat City Network Services-- 858-538-5051 http://www.fatcity.com
 San Diego, California

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

offshoring article

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

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

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




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