RE: Urgent: Number of Cursors Open Error

[Sam P. Roberts (ZADCO ITIS)]

no of cursors per session - can be way high like 7500, affects nothing

-Original Message-
Sent: Saturday, February 03, 2001 7:50 AM
To: Multiple recipients of list ORACLE-L


I believe this refers to the number of cursors that can be opened during one
transaction.  Not sure how to determine the number of cursors currently
open.

Bryan

- Original Message -
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Sent: Wednesday, January 24, 2001 12:12 PM


>
> My database is 8.1.6. and I would like to know how to verify the number of
> cursors that are currently open?
> This database's default  open cursors = 50. Does this value mean that this
> is the maximum
> number of cursors opened per connection or maximum number of cursors
opened
> per instance?
>
> Can this value be changed while the database is opened, if so, how?
>
> Thank you in advance.
>
> Larry
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Larry Taylor
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
>

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Sam P. Roberts (ZADCO ITIS)
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: ORA-00200 (control file creation error)

[Sam P. Roberts (ZADCO ITIS)]

reuse

-Original Message-
Sent: Friday, February 02, 2001 6:51 PM
To: Multiple recipients of list ORACLE-L




I am trying to create a new database OPS database/instance. While running 
the script using SVRMGRL get the following messages..

ORA-01501: CREATE DATABASE failed
ORA-00200: controlfile could not be created
ORA-00202: controlfile: '/dev/disk/dsk19a'
ORA-27038: skgfrcre: file exists

Any ideas, the sys ops say everything is OK.


Regards,

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

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Sam P. Roberts (ZADCO ITIS)
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Sending e-mail from unix machine

[bipin sahani]

Hi Gurus,

Can I send e-mail from Unix server using oracle 
PL/SQL.I'm having HP-Unix 10.2 and oracle7.1.6
and PL/SQL 2.1

Does anyone have tried it??
Or know how to do it??/


Thankx and regards
Bipin




Do You Yahoo!?
Get your free @yahoo.co.in address at http://mail.yahoo.co.in
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: =?iso-8859-1?q?bipin=20sahani?=
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Analyze Question -- How CBO uses column statistics for non-in

[Sam P. Roberts (ZADCO ITIS)]

I missed out on original e-mail regarding this subject so I hope I'm on the
right track, but I assume that the CBO will use non-indexed columns in its
algorithms.  I know DB2 would use non-indexed columns, maybe because DB2 is
a more advanced optimizer(only because IBM have been doing it a lot longer
than Oracle). 

I can see one use for the optimizer to use column stats - when a non leading
column of a composite index is used in a where.okay yes it is still part of
the index but it would probably use the info from analyze in tab_column.
There is probably plenty more with the new features like star joins where
the optimizer builds tables on the fly.

Sam

p.s. if I missed the boat on this topic ,please ignore

-Original Message-
Sent: Friday, February 02, 2001 5:51 PM
To: Multiple recipients of list ORACLE-L
non-indexed columns


Steve,

Thanks for taking the time to reply.

My initial thought was that the stats would be of no use, but, the thing
that still makes me wonder is why would a simple "analyze table compute
statistics" gather statistics on *all* columns. For this to be the default
behavior, there could be a reason. That's why I threw the question out to
the list, trying to see if I was overlooking something obvious. I see your
answer below, but, one scenario hit me this morning and I thought I would
run it by you and the list and let people take shots at it.

Assume I have an SQL query joining two tables equal in size and the CBO
views the cost of an FTS against either as being the same, and, there is an
index supporting joining the tables. In addition to the join criteria,
criteria against *non-indexed* columns in each of the two tables are
specified. No *indexed* columns criteria, other than the join itself, is
specified. So, the CBO needs to choose one of the tables as the "driving"
table, doing an FTS, and, needs to decide whether to use an NL, MJ, or HJ
between the two. Does it make sense, in this case, that the column stats for
the non-indexed column could influence the choice of the driving table
and/or the join method, that a generalized selectivity would be construed
based on the number of distinct values captured for the columns? Sure, an
FTS on at least one table would still be required, but, stats on the
non-indexed columns could influence which table to drive by and which join
method to use?

My "gut" feeling is that in a case such as the one just described, stats on
non-indexed columns could influence the access path and join method
determined by the CBO. I picked up info on event 10053 from your site. I'll
play around with that this weekend.

Regards,

Larry G. Elkins
[EMAIL PROTECTED]
-Original Message-
Sent: Thursday, February 01, 2001 9:48 PM
To: larry elkins; Multiple recipients of list ORACLE-L

Hi Larry,

I think that the answer is that the statistics are of no use to the CBO
until an
index is created.

@   Regards,
@   Steve Adams

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Sam P. Roberts (ZADCO ITIS)
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: V$log Status

[Sam P. Roberts (ZADCO ITIS)]

This is happening because you are flooding the  cpu with requests, the
queues are growing, the knee of the curve on the CPU has gone asymptotic.
Schedule this job for an off peak time, or split it somehow.

Sam

-Original Message-
Sent: Friday, February 02, 2001 4:26 PM
To: Multiple recipients of list ORACLE-L


Hi All,

I am doing a batch update which updates around 100,000 rows. While this
updating is in progress, the system slows down all in a sudden for few
minutes before it continue to work normally.

The archive log is enabled and I have 5 online groups with each 10 MB size.
If I check the V$log while updation in progress, I find the status is in
ACTIVE even after the archive file written for that log. This sequence
continues until all the log files except current one in ACTIVE state. After
couple of minutes all the ACTIVE status getting changed to INACTIVE.

Any Idea what could be the reason for this? I got 8.1.6 undex solaris.

TIA

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Sam P. Roberts (ZADCO ITIS)
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: OT ? for people who know other databases besides Oracle

[Michael Sun]

Linda,

I'd like take a stab at your problem.

Disclaimer first, I started out as an Oracle DBA/Developer
years ago, now I work on front end OO development (Java)
as well. Yes, I went through the somewhat painful experience to
change my mindset from a relational world to an object one,
and now I am at peace with both.

As you have already stated, one of the design goals is to be able to
port your application to other RDBMS in the future, it appears
to me that the obvious choice to put as little business/application
logic into the database as possible. In stead, you should rely
on a much more portable language, like Java, to implement
those logics. Does that make sense?

If so, triggers are out, stored procesdures are definitely out
(unless you want to keep two copies, one in PL/SQL, the other in
Transact SQL). I will just rely on application layer pass in
in-line SQL (ANSI standard) to achieve the maximum
portability.

Now that portability has been achieved, you may ask about
performance. We may have to open another thread
just to deal with this issue alone.

In any case, I am proud of being a Java developer that knows
about db schema and SQL tuning. So, guys, no flames, plz.

Michael

- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Wednesday, January 31, 2001 3:32 PM


If you find where it can get set either in init.ora or in another session
(i.e. I'd like to set it against a running Java connection), please let me
know!

Thanks!

Linda

-Original Message-
Sent: Wednesday, January 31, 2001 10:16 AM
To: Multiple recipients of list ORACLE-L


Thanks Jared,

I knew it was there somewhere.
Unfortunately the fips flagging is at the session
level only in Oracle 816.
Do you remember if it was at the database level on
early Oracle 7 version ?


--- [EMAIL PROTECTED] a écrit : >
> Look in the Oracle SQL Reference Manual for 'FIPS'.
> It's in the
> index.  This will give you the info on maintaining
> compatibility
> with ANSI standard SQL.
>
> Jared
>
> On Tue, 30 Jan 2001, Seley, Linda wrote:
>
> > Our Java users are concerned that there may be a
> possibility that their code
> > may have to work on top of a variety of databases.
>  We use Oracle in-house
> > but we, theoretically, may sell our product to
> another company that uses
> > something else besides Oracle.  Our product would
> then have to talk with
> > their database.  What, then, are the advantages
> and disadvantages of using
> > views, procedures, triggers, etc.  What would buy
> us the most portability?
> > What headaches might we just have to deal with
> because there is no way
> > around it?
> >
> > Any insights would be greatly welcomed.  Feel free
> to email me privately at
> > [EMAIL PROTECTED]
> >
> > Thanks!
> >
> > Linda
> > --
> > Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> > --
> > Author: Seley, Linda
> >   INET: [EMAIL PROTECTED]
> >
> > Fat City Network Services-- (858) 538-5051
> FAX: (858) 538-5051
> > San Diego, California-- Public Internet
> access / Mailing Lists
> >
>

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

> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of
> 'ListGuru') and in
> the message BODY, include a line containing: UNSUB
> ORACLE-L
> (or the name of mailing list you want to be removed
> from).  You may
> also send the HELP command for other information
> (like subscribing).


=
Stephane Paquette
DBA Oracle
[EMAIL PROTECTED]

__
Get personalized email addresses from Yahoo! Mail - only $35
a year!  http://personal.mail.yahoo.com/
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: =?iso-8859-1?q?paquette=20stephane?=
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be remove

Re: Urgent: Number of Cursors Open Error

[Bryan Sirtosky]

I believe this refers to the number of cursors that can be opened during one
transaction.  Not sure how to determine the number of cursors currently
open.

Bryan

- Original Message -
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Sent: Wednesday, January 24, 2001 12:12 PM


>
> My database is 8.1.6. and I would like to know how to verify the number of
> cursors that are currently open?
> This database's default  open cursors = 50. Does this value mean that this
> is the maximum
> number of cursors opened per connection or maximum number of cursors
opened
> per instance?
>
> Can this value be changed while the database is opened, if so, how?
>
> Thank you in advance.
>
> Larry
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Larry Taylor
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
>

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: Thanks and another book request

[Dan Mills]

Rachel,

Having witnessed my mother rise to the top of the Professional Genealogist
field, being published countless times along the way, and never having any
spending money growing up, I can say that she was not in it for the money,
and nor are the majority of the non-fiction writers.

Some things are more rewarding than money.

dgm

- Original Message -
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Sent: Friday, February 02, 2001 8:05 PM


> well, let's do the math.
>
> let's say I get $5 for each book that is sold (I don't, and the royalties
> change depending on if the book has sold at full price or from a discount
> house)  but the $5 makes the math easier
> (and it's less than minimum wage in the US!)
>
>
> let's round the numbers, and say that an independent DBA consultant can
earn
> $150/hr in New York, where I live. (That's an average, some make more,
some
> less)
>
> and 150/5 = 30  so I'd have to work 30 times as many hours writing books
as
> I would as a consultant to make the same amount of money
>
> Most personnel departments assume that there are 200 workdays in a year
> (vacation, weekends and holidays excluded), and that a workday is 8 hours
> long. Yes, I know no DBA works a 40 hour week, this is just an example.
>
> so 200*8 = 1600 hours work in a year.
>
> 1600/500= 3.2 books a year and 1600*5=$8000 a year
>
> 1600*150=$240,000
>
> don't know about you, I'd rather be a consultant!
>
> I repeat -- you don't make money writing books, and if that is why you are
> writing them, you'd be better off just consulting. Even if you write in
your
> "spare time", you lose -- I worked evenings, and all day all weekend
> writing. I didn't see my friends or family for the time I was writing.
>
>
> Oh, and since my name does show up when my messages post, so it's easy to
> see how it is spelled
>
> it's Rachel, not Rachael
>
>
> >From: "orclbabu" <[EMAIL PROTECTED]>
> >Reply-To: [EMAIL PROTECTED]
> >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> >Subject: Re: Thanks and another book request
> >Date: Fri, 02 Feb 2001 12:32:11 -0800
> >
> >Rachael
> >
> > > consultant for that number of hours Not profitable to write one.
> >
> >The very fact that you often repeat this in response to mails that refer
to
> >your books, makes us think otherwise $$$
> >
> >;-)
> >
> >babu
> >
> >--
> >Please see the official ORACLE-L FAQ: http://www.orafaq.com
> >--
> >Author: orclbabu
> >   INET: [EMAIL PROTECTED]
> >
> >Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> >San Diego, California-- Public Internet access / Mailing Lists
> >
> >To REMOVE yourself from this mailing list, send an E-Mail message
> >to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> >the message BODY, include a line containing: UNSUB ORACLE-L
> >(or the name of mailing list you want to be removed from).  You may
> >also send the HELP command for other information (like subscribing).
>
> _
> Get your FREE download of MSN Explorer at http://explorer.msn.com
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Rachel Carmichael
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Pondering Question of the Day-RESPECT

[Weaver, Walt]

But, but... you da man, Lisa.

I just button down everything. The only people in the universe that know the
db passwords are me and my 11-year-old daughter, because my company is too
damn cheap to hire a backup for me. I told my daughter that if I die, log in
and delete every database in sight. Bend over, fart, nice to know ya.

Button down everything and just sit tight. 

The duhvelopers will come to you on bended knees.

If your company is like the several I have worked for, your CTO, CIO, VP,
Middle Manager, and Janitor (they're all the same) don't have a clue what
you're doing. They're too damn busy trying to save their own jobs.

You have much political leverage. Use it.

Damn, I wish I was still working at my old job. When I was an air traffic
controller, it was so simple. I fucked up, someone died (never happened).
Being a DBA, it doesn't matter how well you do your job. People still use
you as the whipping boy.

Once again, you're at the strong end of the lever. Figure out how to use it.

--Walt Weaver
  Bozeman, Montana, USA 

>From: "Koivu, Lisa" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: Pondering Question of the Day-RESPECT
>Date: Fri, 02 Feb 2001 07:20:24 -0800
>
>"Hello Oracle Guru"
>
>Now why is it that I get more respect on the Internet than I do in my
>workplace.  ??
>
>How many of you have this problem?  It's like an ongoing fight with
>developers, they want carte blanche in the production database, and
they do
>whatever they want EVEN THOUGH I tell them NO, let's do something
different
>that won't affect production.  I go to the CTO because this is like the
3rd
>time this has happened, and he sends out a
>let's-be-sure-not-to-offend-anyone email.  But the developer(s) will go
>ahead and do what they want ANYWAY.  I'm waiting for the first
user-mistake
>recovery to say STOP, I've had ENOUGH and this is how it's going to be,
no
>ifs, ands or buts.
>
>My last job may have been a sweatshop, but at least people respected my
>authority.  Here, it's a free for all no matter what I do.  Even when I

>say,
>Dude, I own the database.  If there's a problem, I have to fix it.
>Therefore I say what happens in production and what doesn' t happen in
>production.
>
>And yes, I am looking for another position.  I can only take this
>dba/developer/janitor role for so long.
>
>I'M SO GLAD IT'S FRIDAY...  Bring on the Captain Morgan!  It's noon
>somewhere...
>
>Lisa Rutland Koivu
>Oracle Database Administrator
>Qode.com
>4850 North State Road 7
>Suite G104
>Fort Lauderdale, FL  33319
>
>V: 954.484.3191, x174
>F: 954.484.2933
>C: 954.658.5849
>http://www.qode.com
>
>"The information contained herein does not express the opinion or
position
>of Qode.com and cannot be attributed to or made binding upon Qode.com."
>

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

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Weaver, Walt
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: OT- Oracle Training

[Dan Mills]

Eric et al,

I appreciate the responses, both public and private, and have gained a
better understanding of the situation as a result.

First, let me say that I do not determine or influence the course of action
of my employer. Either the work arounds or work withins that have been
identified thus far are being weighed and measured by the individuals who
have the dog in the fight. I don't have a clue when it comes to business
law. I am just a curious dba.

Having said that it would seem to me that the intellectual rights (reverse
engineering, proprietary secrets, etc) arguments may not hold true in this
case and at this point in time.

Has everyone who has written an oracle technologies book in the last ten
years been published through Oracle Press? Do they pay license fees to
Oracle for the proprietary technologies detailed within? And who has
benefited the most from the volumes of detailed publications from third
parties and the resulting phenomenal increase in market share resulting from
the self-trained developers and dbas who bought these books, sought out
third-party training, and based their careers on Oracle software?

 After having spent many hours in book store, perusing everything Oracle,
and having taught and/or studied my employers' course materials, I can say
that there is nothing in them that is not readily available in a combination
of all the third parties' Oracle books. Just common knowledge and personal
experience.

thanks again and for those who don't have to work

Have a great weekend,

For those that do...Hopefully you'll get Monday off like me ;)

dgm

ps. I don't have the career history to base this comment on, but from what I
understand Oracle had the better marketing team. Maybe sometimes the end
does justify the means. Can't argue with success. And several other cliches.








- Original Message -
To: <[EMAIL PROTECTED]>
Sent: Friday, February 02, 2001 7:13 PM


> Dan,
>
> Thanks, that was very interesting. Based on your latest comments, my
> preliminary suspicions about Oracle acting like ruthless/greedy
> b*st*rds would seem to be confirmed. :) Assuming the above is true, I
> would encourage you to continue to document and publicise this in the
> user community so that pressure will be brought on Oracle to act in a
> more altruistic, and/or socially responsible manner in the future.
>
> Assuming that such a course of actions fails, again, the question is,
> for the good of the community, will the dba corp., or some of its
> members, try to "work around" the bizarre antics and obstacles that
> Oracle seems to be putting up?
>
> regards,
> ep
>
> On 2 Feb 2001, at 3:55, Dan Mills wrote:
>
> Date sent:  Fri, 02 Feb 2001 03:55:48 -0800
> To: Multiple recipients of list ORACLE-L
<[EMAIL PROTECTED]>
> From:   "Dan Mills" <[EMAIL PROTECTED]>
> Subject:Re: OT- Oracle Training
>
> > Eric,
> >
> > Thank you for the feedback. And I would like to address your points
further
> > for the benefit of all.
> >
> > 1. My employer is contracted to teach for the local University and will
do
> > so till summer. They also have an Oracle license which they are allowed
to
> > continue their training under, depending on whose lawyer you speak to I
> > guess. One point was that this is a new clause in Oracle licenses which
is
> > trying to be enforced retroactively in an attempt to halt future Oracle
> > classes under the current license. They can also contiue to contract
with
> > companies and train under each companies' license. The school of course
is
> > primarily interested in the discounted Oracle licenses.
> >
> > 2. The relationship has definitely been win-win from all perspectives
the
> > way I see it. The oracle market in this are has benefited by having more
and
> > better trained developers and dbas to fill the ever growing needs of the
> > companies here. The only loser here is Microsoft/sqlserver, as I have
seen
> > many make the jump to the Oracle side. And my employers are astute
> > capitalists, always making hay while the sun is shining. No losers here.
> >
> > 3. A major reason this program has been successful is because Oracle's
> > training is prohibitively expensive for small companies and individuals
> > moving into the Oracle world. When my employer started training the
ratio of
> > Microsoft developers to Oracle developers was in the neighborhood of
10:1.
> > Now I hear its down to 3:1. I have personally witnessed developers and
dbas
> > make this major career move based on our training and their own dollars.
And
> > they would not have been able to afford the time off or dollars it would
> > have taken through Oracle Education.
> >
> > 4. I'm not certain that with Oracle's core database and tools software
> > Division, Oracle Applications, and Oracle Consulting, that Oracle
University
> > is the largest piece of their pie. If you know the numbers, please let
me
> > know, but I would guess that it is near last.
> >
> > I am sure that th

Re: Thanks and another book request

[Rachel Carmichael]

Pat,

I love you :)   and I sympathize even more with you -- you worked on your 
husband's stuff and didn't get paid!

let's elaborate on the work that no one sees:

the way marlene and I wrote was:

we divided the chapters, she wrote some, I wrote others, I did the copy-edit 
and pageproofing

So for each chapter:

1) either I wrote it or I read what Marlene wrote (and she did the same for 
me, we edited each other's work before we even sent the 1st draft in to the 
publisher)

2) send the chapter to the tech editor

3) review the tech editor's comments and incorporate suggested changes

4) send the chapter in to the publisher for copy-edit

5) review the copy editor's changes and either change things back or accept 
them

6) read the initial set of page proofs (yes, copy on paper of what the page 
will look like) and find and correct all errors

7) because I am anal about errors, and my editors know this, I get a final 
set of page proofs to review and catch anything I missed the first time

8) get a bound copy of the book and look through it one last time


So, not only do I spend hours writing a chapter, once it's written I have to 
see it over and over and over and OVER again until I am deathly sick of the 
chapter and convinced that what we have on the page is garbage that no one 
will want to read.


Rachel



>From: Pat Hildebrand <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: Re: Thanks and another book request
>Date: Fri, 02 Feb 2001 13:10:08 -0800
>
>
> >
> > Rachael
> >
> > > consultant for that number of hours Not profitable to write one.
> >
> > The very fact that you often repeat this in response to mails that refer 
>to
> > your books, makes us think otherwise $$$
> >
>
>I have not written any Oracle books but I have had enough experience
>with publishers that I really have to step in here. My husband
>happened to be one of three authors on a monograph that had enough
>popularity to stick around for quite awhile now. Want to guess his
>share of the yearly royalties (split equally between the three of
>them)? Approximately $100. Okay over twenty years that's a couple
>thousand. He repeatly said that the only reason to write a book was
>because you got mad at what was available; it certainly wasn't for the
>money. The monograph was not something that would need to be updated
>all the time the way an Oracle book would be.
>
>The need for new editions opens up the book to driving your life. I
>did some work on supplemental work for my husband's textbooks and
>trying that with a full time job is something I would not wish on my
>worst enemy. Impossible deadlines still need to be met by you but
>don't count on getting things back when promised - your time to make
>the changes is just squeezed.
>
>If Rachael is one of the really limited number of people who make what
>might be considered a reasonable return on her time, I say more power
>to her. However, it is more likely that she has to repeat because
>people don't believe her.
>
>
>
>   Pat
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Pat Hildebrand
>   INET: [EMAIL PROTECTED]
>
>Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
>San Diego, California-- Public Internet access / Mailing Lists
>
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from).  You may
>also send the HELP command for other information (like subscribing).

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

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: Thanks and another book request

[Rachel Carmichael]

well, let's do the math.

let's say I get $5 for each book that is sold (I don't, and the royalties 
change depending on if the book has sold at full price or from a discount 
house)  but the $5 makes the math easier
(and it's less than minimum wage in the US!)


let's round the numbers, and say that an independent DBA consultant can earn 
$150/hr in New York, where I live. (That's an average, some make more, some 
less)

and 150/5 = 30  so I'd have to work 30 times as many hours writing books as 
I would as a consultant to make the same amount of money

Most personnel departments assume that there are 200 workdays in a year 
(vacation, weekends and holidays excluded), and that a workday is 8 hours 
long. Yes, I know no DBA works a 40 hour week, this is just an example.

so 200*8 = 1600 hours work in a year.

1600/500= 3.2 books a year and 1600*5=$8000 a year

1600*150=$240,000

don't know about you, I'd rather be a consultant!

I repeat -- you don't make money writing books, and if that is why you are 
writing them, you'd be better off just consulting. Even if you write in your 
"spare time", you lose -- I worked evenings, and all day all weekend 
writing. I didn't see my friends or family for the time I was writing.


Oh, and since my name does show up when my messages post, so it's easy to 
see how it is spelled

it's Rachel, not Rachael


>From: "orclbabu" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: Re: Thanks and another book request
>Date: Fri, 02 Feb 2001 12:32:11 -0800
>
>Rachael
>
> > consultant for that number of hours Not profitable to write one.
>
>The very fact that you often repeat this in response to mails that refer to
>your books, makes us think otherwise $$$
>
>;-)
>
>babu
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: orclbabu
>   INET: [EMAIL PROTECTED]
>
>Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
>San Diego, California-- Public Internet access / Mailing Lists
>
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from).  You may
>also send the HELP command for other information (like subscribing).

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

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: Thanks and another book request

[Eric D. Pierce]

are there some envious little weenies out there, or what? :)

my mom (retired writer/politician & amateur horticulturalist)
and dad (retired pilot/engineer & amateur photographer) 
wrote a pocket guide book to speciality gardens & arboretums
in northern california, and it cost them about $10,000 in 
production expenses (travel, photography equipment/supplies,
and so forth). They made that back and about another $10,000
of profit (I think that represented either 2 or 3 printings
total). aprx 6 months of work.

regards,
ep

On 2 Feb 2001, at 13:10, Pat Hildebrand wrote:

Date sent:  Fri, 02 Feb 2001 13:10:08 -0800
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>

> > 
> > The very fact that you often repeat this in response to mails that refer to
> > your books, makes us think otherwise $$$
> > 
> 
> I have not written any Oracle books but I have had enough experience
> with publishers that I really have to step in here. My husband
> happened to be one of three authors on a monograph that had enough
> popularity to stick around for quite awhile now. Want to guess his
> share of the yearly royalties (split equally between the three of
> them)? Approximately $100. Okay over twenty years that's a couple
> thousand. He repeatly said that the only reason to write a book was
> because you got mad at what was available; it certainly wasn't for the
> money. 

...

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Who wants to build a tablespace...

[Gary Weber]

3 Gb 
is not all that big. What platform is this on, can it handle larger files? Why 
is 3 Gb chosen as size below, as opposed to 2 or 4? What is your backup window, 
if any, and required recovery time? 
 
Fwiw, 
I have one of the databases (DW) on HPUX 64bit with 4 and 6 Gb datafiles, 
residing happily on EMC Symmetrix...
 
Gary 
Weber
 
-Original Message-From: [EMAIL PROTECTED] 
[mailto:[EMAIL PROTECTED]]On Behalf Of Rocky WelchSent: Friday, 
February 02, 2001 4:20 PMTo: Multiple recipients of list 
ORACLE-LSubject: Who wants to build a 
tablespace...
The question is...One BIG datafile (3 gig) or multiple smaller datafiles.
You still have audience or phone a friend...your final answer?
-Rocky


Do You Yahoo!?- Get personalized email addresses from Yahoo! Mail Personal Address - only 
$35 a year!

Re[2]:NLS and ORA-03106: fatal two-task communication protoc

[dgoulet]

Cherie,

What is this PRO*C bashing day or something?  Sheesh!!!

I would appear from the -1458 error that there is something wrong with the
interface between Pro*C and PL/SQL.  The -1458 indicates that "An attempt was
made to bind or define a variable character string with a buffer length less
than the two byte minimum required."  I've only seen this particular error one
time and that was a long time ago.  Some brainack put a char pointer into the
declare area with an initialized value of NULL and then attempted to select into
it.  Anyway, if your developers want to forward the code and procedure/package
definitions over privately on Monday I'll take a look & see what I can find.

Dick Goulet

PS: Have a good weekend! :-)

Now where did I put that Guinness??

Reply Separator
Author: [EMAIL PROTECTED]
Date:   2/2/2001 1:28 PM

Dick,

In this case, it doesn't appear to be NLS or a network problem.
The developer has replied with the following:

When I ran this code, I got the Oracle -1458 problem:

   EXEC SQL EXECUTE
  BEGIN
  EmployeePackage.GetNextDownloadEmployee;
  :xversion:= CommonGlobalPackage.Employee_Rec.VERSION;
  :xemail_name := CommonGlobalPackage.Employee_Rec.EMAIL_NAME;
  :employee_icn:= CommonGlobalPackage.Employee_Rec.EMP_ICN;
  :xprogram_load_flag  :=
CommonGlobalPackage.Employee_Rec.PROGRAM_LOAD_FLAG;
  :xboot_load_flag := CommonGlobalPackage.Employee_Rec.BOOT_LOAD_FLAG;
  END;
   END-EXEC;

It wasn't clear where the problem occurred in the code since the dbx debugger
doesn't step into the Pro*C code, so I divided the SQL EXECUTE into two parts
and re-ran the program.

   EXEC SQL EXECUTE
  BEGIN
  EmployeePackage.GetNextDownloadEmployee;
  :xversion:= CommonGlobalPackage.Employee_Rec.VERSION;
  :xemail_name := CommonGlobalPackage.Employee_Rec.EMAIL_NAME;
  END;
   END-EXEC;
   dummy = 1;
   EXEC SQL EXECUTE
  BEGIN
  :employee_icn:= CommonGlobalPackage.Employee_Rec.EMP_ICN;
  :xprogram_load_flag  :=
CommonGlobalPackage.Employee_Rec.PROGRAM_LOAD_FLAG;
  :xboot_load_flag := CommonGlobalPackage.Employee_Rec.BOOT_LOAD_FLAG;
  END;
   END-EXEC;

When this version of the code run, I get the Oracle -3106 error.  As far as I
know,
the second version is legal; the compiler gives me no errors or warnings.


Any clues, Dick?

Cherie




[EMAIL PROTECTED] on 02/02/2001 02:24:39 PM

Please respond to [EMAIL PROTECTED]

To:   Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:(bcc: Cherie Machler/GELCO)




Cherie,

NLS_LANG and NLS_DATE_FORMAT.  Things I've seen on this front.

Database created with US7ASCII & end user using
American_america.WE8ISO8859P1

Database set for NLS_DATE_FORMAT='DD-MON-YY'
  and end user with NLS_DATE_FORMAT ='DD-MON-:HH24:MI

But in general 3106 is a catch all.  Generally it means that something happen,
it does not know for sure, so it defaults.  Other possibilities: bad network
cable(s), DNS server oops, router fowl-up, bad network card(s), noisy network
card(s), someone with a fat foot, or my all time favorite Access being used as a
multi user DB.  That last one will send the data packet collision rate through
the ceiling.

Dick Goulet

Reply Separator
Author: [EMAIL PROTECTED]
Date:   2/2/2001 11:41 AM

We're getting this ORA-03106 error on 8.1.5 Oracle on Sun Solaris.

I looked it up on Metalink and there is quite a lot of information
there.  I looked at one document in particular and found lots
of causes for ORA-03106.  I'm going through the possibilities
one at a time and am wondering what one of the items means.

In item number 1 below it says to check for NLS incompatibilities.
Nothing real specific.  Do they mean like the values for NLS_LANG
or something like that?  I'm not sure and I don't have anyone to
follow up with.  Anyone have a clue?  Following is the excerpt:

RDBMS - Troubleshooting two-task common errors
==

1. Check for NLS incompatibilities between the client and server.  This is
   a very popular cause of the ORA-03106 error.

2. Check the alert log and RDBMS trace files for any pertinent information /
   errors that coincide with receiving the ORA-03106 error.

3. Try to get a testcase and reproduce the problem in-house.

4. If a testcase is not possible, ask for SQL*Net trace files, SQL traces, and
   try setting event 3106 to obtain the error stack.

5. In extreme circumstances, this could indicate that a shared memory segment
   used by Oracle is corrupted.  You will have to shut down the database,
   possibly using the abort option.  Make sure all semaphores have been
   released by using the IPCS command on Unix.  Oracle uses semaphores to
   control concurrency between all of the background processes (pmon, smon,
   drwr, lgwr, and oracle shado

Re: OT NT2K vs Unix.

[MTPConsulting]

I'll be interested to see the replies on this one.  We've just embarked on a 
new project that will be using Oracle 8.1.7 on RedHat Linux.  Also using 
Oracle 9i AS (with Java stuff) on Linux as well.  Production is slated for 
July timeframe.  It is for a scheduling system that is at the heart of a 
medium-sized business.  This is our first foray with Linux for a critical 
system.  We do have a small web-based survey system that has been running for 
a year on RedHat Linux with Oracle (just upgraded to 8.1.7) and it's working 
very nicely.

Marc Perkowitz
MTP Systems Consulting

In a message dated 2/2/2001 2:45:53 PM Central Standard Time, 
[EMAIL PROTECTED] writes:

<< But, if you all let me return this thread back to a real discussion.  How 
many
 of you out there are using Linux, particularly RedHat, in a production
 environment preferably with Oracle?  The boss(s) around here are looking for 
a
 more "cost efficient" (read that as $0.00) operating system for some of our 
DB
 stuff.  We may even decide on a more "cost efficient" (same translation) 
rdbms,
 otherwise known as PostGreSQL.
 
 Dick Goulet
  >>
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Oracle shareware web site.

[dieter . oberkofler]

Hi Ron!

You might be looking for my web site
at http://www.materialdreams.com/.
I offer a tool called TabExp that
is able to export oracle data in
several different formats.

Regards

DO

email: [EMAIL PROTECTED]
web:   www.materialdreams.com

-Original Message-
Sent: Thursday, February 01, 2001 6:01 PM
To: Multiple recipients of list ORACLE-L


I'm looking for the web site that has a export utility called something like
TAB/EXT.  Does anyone know the URL for this site?

TIA, Ron

***
Ron Cetnar
Supervising Programmer/Analyst/DBA
State University of New York at Albany
MSC 100
1400 Washington Ave
Albany, NY 1
Email: [EMAIL PROTECTED]
Work: (518) 437-4535
Fax:   (518) 437-4540

***


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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Pondering Question of the Day-RESPECT

[Cherie_Machler]

Lisa,

Yes.  Don't keep us in suspense.  Let us know
how the bet turned out.

Cherie

p.s.  If you lose, that's $50 down the drain




"Steve Orr" <[EMAIL PROTECTED]> on 02/02/2001 03:36:12 PM

Please respond to [EMAIL PROTECTED]

To:   Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:(bcc: Cherie Machler/GELCO)




Sounds like a new white paper titled, "How To Be Fired as a DBA."  :-)

Best of luck... however you're interpreting that.  ;-)

Steve Orr


-Original Message-
[EMAIL PROTECTED]
Sent: Friday, February 02, 2001 11:46 AM
To: Multiple recipients of list ORACLE-L


Lisa,

What?!!  Are you betting against getting fired or for being fired?

Cherie


Oh well. It's Friday and I have a bet going that I'll be fired by the end of
the day.  If I do get fired today I win $500!  Ha!

Have a great weekend everyone
Lisa



-Original Message-
Sent: Friday, February 02, 2001 1:05 PM
To: Multiple recipients of list ORACLE-L


Pondering Question of the Day-RESPECTcome on! give me an user who prefer we,
developers and dbas working in a decent way, instead of
get its job done "rigth now in this moment" and I'll shave my head and paint
it blue.

developers get crazy trying to solve a problem with users on the other side
of the phone yelling!
and that's first reason of messing everything up.
(ok, don't generalize)
users' bosses want the same.

why can't we talk about the complete organization? and why everybody thinks
developers and dbas as
separate things?
If you can't separate responsabilities and duties, well, it's an
organization problem

try to take an equilibrium and you'll be happy

Gabriel Galanternik

- Original Message -
To: Multiple recipients of list ORACLE-L
Sent: Friday, February 02, 2001 1:10 PM


Lisa,
Rather than talking to the CTO about this go to the Dir, VP, or whatever of
the USERS of the system.  In-fact he/she is the actual OWNER of the data in
the system.  Explain to him/her how dangerous and devious the developers are
to the data.  Talk about corruption, system downtime, partial and incomplete
restores.  Use some technical DBA language to make them understand you have
the knowledge, but make sure you keep the message at a manager level of
understanding.  Get them good and scared.  Then when the developers are
asking for the free ride in production you have an advocate in high postion
that can put the CTO in a position of getting a backbone.  When the COO
starts asking why his people can't work, or why the P/L statement is messed
up the CTO will start scrambling for a lockdown on production and more
comprehensive testing of new or enhanced code.  Remember the politics.  We
in the IT field are not the production organization we are the service
organization.  When it comes to power struggles at the Cxx levels the
production/operations guys always beat the IT/IS guys.  It's a mater of $$$
and performance in front of the CEO.

HTH

Rodd Holman
-Original Message-
Sent: Friday, February 02, 2001 9:20 AM
To: Multiple recipients of list ORACLE-L


"Hello Oracle Guru"
Now why is it that I get more respect on the Internet than I do in my
workplace.  ??
How many of you have this problem?  It's like an ongoing fight with
developers, they want carte blanche in the production database, and they do
whatever they want EVEN THOUGH I tell them NO, let's do something different
that won't affect production.  I go to the CTO because this is like the 3rd
time this has happened, and he sends out a
let's-be-sure-not-to-offend-anyone email.  But the developer(s) will go
ahead and do what they want ANYWAY.  I'm waiting for the first user-mistake
recovery to say STOP, I've had ENOUGH and this is how it's going to be, no
ifs, ands or buts.
My last job may have been a sweatshop, but at least people respected my
authority.  Here, it's a free for all no matter what I do.  Even when I say,
Dude, I own the database.  If there's a problem, I have to fix it.
Therefore I say what happens in production and what doesn' t happen in
production.
And yes, I am looking for another position.  I can only take this
dba/developer/janitor role for so long.
I'M SO GLAD IT'S FRIDAY...  Bring on the Captain Morgan!  It's noon
somewhere...
Lisa Rutland Koivu
Oracle Database Administrator
Qode.com
4850 North State Road 7
Suite G104
Fort Lauderdale, FL  33319
V: 954.484.3191, x174
F: 954.484.2933
C: 954.658.5849
http://www.qode.com
"The information contained herein does not express the opinion or position
of Qode.com and cannot be attributed to or made binding upon Qode.com."

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of '

RE: OT- Oracle Training

[Eric D. Pierce]

Yes, exactly.

If you scratch below the surface, and ask "why" (in terms
of social theory), you may come to realize that in american
technical culture there are two broad categories:

 1) populists/populizers 
 (make products that are ugly, but cheap)

 2) technical elites 
 (make products that are beautiful, but expensive)


Basically MS = #1, and Unix/Oracle/etc = #2

Oracle corp.'s "organizational culture" is simply incapable
of acting on "populist logic" because such logic runs
contrary to the "value system" (and/or aesthetic preferences)
of the technical elites.

Neither "position" is inherently more "good" than the other
since they simply represent forms/expressions of different 
perspectives that arise from underlying universal archetypes.

regards,
ep


On 2 Feb 2001, at 10:39, Nikolay Kumanov wrote:

Date sent:  Fri, 02 Feb 2001 10:39:50 -0800
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>

> After many years of working for the financial sector, please don't be too
> angry at me for stating my opinion in financial terms:
...

> 
> IMHO, probably company B has better technology, but A has better marketing
> strategy and market development. And I am very sad to see lesser
> technologies come to prosperity. I hope that some wise guy at B would say
> "OK folks, we are opening all the info we have, we want all the young and
> bright people to have the possibility to study our technology, even if they
> have not the means to pay for the information. We are providing an
> affordable way for youngsters to become a B professionals". Could it be a
> wise (and profitable) investment

...


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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Pondering Question of the Day-RESPECT

[Eric D. Pierce]

On 2 Feb 2001, at 8:18, Koivu, Lisa wrote:

> ...  Fire me then.  

Are you *sure* it's not because you are a viking fan? :)
ep

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: How to find USER who locked my row ...

[Janardhana Babu]

Rafiq,

Thanks for the reply. This displays all the users who are accessing the
table, and not giving me the userId who is accessing my row. There are
plenty of users accessing the table in the production environment, it is
important for me to find the user who is accessing my row (row level).

I would like to explain the question in another way. I issued the following
stmt:

select * from  where doc_nbr = '12345' for update nowait;

It comes out with error ORA-54 saying that some other userid is updating the
same row. I would like to know the the userid who locked my row. 

I need to get some info like 'address of the row' from my above stmt. and
get the userid who locked the same row. If I can get the row_wait_row# value
of the above stmt, then, I can use it in the join stmt on row_wait_row#
column of the v$session to get the SID,SERIAL#,USERNAME etc.

I don't know how to get the row_wait_row# value for my above stmt. In
V$session it is displaying numbers such as 8, 12, 16etc. If this gives you
any clue, please try to help me.

Thanks ... Babu

-Original Message-
Sent: Friday, February 02, 2001 12:32 PM
To: Multiple recipients of list ORACLE-L


Babu,

The message "Resource busy' is coming when your code is trying to change 
definition of table or trying to create any index when table is in use not 
for dml but may be somebody running select only.You may use following script

to check which user is accessing this table in case if  any dml is 
invloved.

set linesize 120
select substr(a.os_user_name,1,8) "OS User"
, substr(b.object_name,1,30) "Object Name"
, substr(b.object_type,1,8) "Type"
, substr(c.segment_name,1,10) "RBS"
, e.process "PROCESS"
, substr(d.used_urec,1,8) "# of Records"
from v$locked_object a
, dba_objects b
, dba_rollback_segs c
, v$transaction d
, v$session e
where a.object_id = b.object_id
and a.xidusn = c.segment_id
and a.xidusn = d.xidusn
and a.xidslot = d.xidslot
and d.addr = e.taddr
/

Regards
Rafiq



To: 'Mohammad Rafiq' <[EMAIL PROTECTED]>, [EMAIL PROTECTED]
Date: Fri, 2 Feb 2001 12:17:31 -0800

Rafiq,

You are right. After running the catblock.sql script, I could see the views,
but the output is "no rows selected". This is because the session that is
accessing the locked row comes out with ORA-54 error instead of waiting for
the lock to be released. There is a "nowait" clause at the end of the stmt.
They don't want to session to wait if the row is locked by some other
session, they just want to return ORA-54 error, but at the same time they
want to know what user is locked the row at the time our session is
accessing the row. If you have any other ideas, please let me know.

Thanks ... Babu


-Original Message-
Sent: Friday, February 02, 2001 11:58 AM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]


Babu,

Your system may be missing dba_blockers,dba_waiters views. Please look
for script catblock.sql under $ORACLE_HOME/rdbms/admin and run it as per
guidance given in that script.

Regards
Rafiq


To: "'[EMAIL PROTECTED]'" <[EMAIL PROTECTED]>
CC: 'Mohammad Rafiq' <[EMAIL PROTECTED]>
Date: Fri, 2 Feb 2001 10:59:20 -0800

Rafiq,

I tried to execute the query, It comes out with an error: dba_blockers does
not exist. I verified in all of my Oracle 8i databases and have not found
that view anywhere. Has it been removed in 8i? If not, I don't have any clue
why it is not showing up?

Thanks...Babu

-Original Message-
Sent: Friday, February 02, 2001 9:56 AM
To: Multiple recipients of list ORACLE-L


Babu,

The message you have given pointing that object itself is being used and
some application trying to create index on that table or table definition
itself being changed.
Try following query which might help:

spool holding_session.lst
column object_name justify c heading "Object|Name"  format a32
column usernamejustify c heading "User|Name"format a7
column osuser  justify c heading "OS|User"  format a7
column pid justify c heading "Ora|Proc|ID"  format 999
column serial# justify c heading "Ora|Serial|#" format 99
column sid justify c heading "Holding|Session"  format 999
column spidjustify c heading "Unix|Proc"format a5
column object_id   justify c heading "Obj|ID"   format 9
column lockwaitjustify c heading "Lock|Wait"
column typejustify c heading "Lock|Type"format a4
column lmode   justify c heading "Mode" format 
set pagesize 60 linesize 100
select lck.sid, ses.serial#, pro.pid, pro.spid, obj.object_name,
 obj.object_id, ses.username, ses.osuser,
 lck.type, lck.lmode
from dba_blockers blk, dba_objects obj, v$lock lck,
   v$session ses, v$process pro
where blk.holding_session = ses.sid
and   lck.id1   = obj.object_id
and   lck.sid   = ses.sid
and   ses.paddr = pro.addr
and   ses.username is not NULL
order by obj.object_name, ses.lockwait desc, lck.sid;
spool off
clear columns
/
Regards
Rafiq







Reply-To: [EMAIL PROTECTED]
To: Multiple recip

Re: temp tablespace

[Mitchell]

Rafiq

I think I means not 'PERMANENT' but 'TEMPORARY'. in my case.
After I alter tablespace mytemptablespace coalesce; it is still the same. No
any extent released.
I am not sure I can take temp tablespace offline or should  I add another
one and off./on the old one
since we operate at 7/24.

Mitchell



- Original Message -
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Sent: Friday, February 02, 2001 11:45 AM


>
> Alex,
> Yes you are right if temp tablespace is 'TEMPORARY'. The situation he has
> described is pointing that temp tablespace is 'PERMANENT' and thats why
> his extents were not released/coalesced.
>
> Besides , with temp TEMPORARY tablespace , there are problems that space
is
> not completely released even after bouncing database and you have to
> offline and online temp tablespace to get release used space upto 99%.
> I am talking about 7GB+ tempspace on 7.3.4.4(1999) NCR UNIX 3.02 and that
> was my personal experience at that time.
>
> Regards
> Rafiq
>
>
>
> Reply-To: [EMAIL PROTECTED]
> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> Date: Thu, 01 Feb 2001 14:12:31 -0800
>
> I disagree. pctincrease should be 0, you do not need to coalesce
tablespace
> if it is temporary. Segments in temporary tablespace are not dropped after
> SQL statement execution ends. But if you want to drop all segments from
> temporary tablespace the easiest way is:
>
> alter tablespace  pctincrease  pctincrease>
>
> Alex Hillman
>
> -Original Message-
> Sent: Thursday, February 01, 2001 2:12 PM
> To: Multiple recipients of list ORACLE-L
>
>
> To resolve it now:
> alter tablespace temp coalesce;
>
> for all the time set pctincrease to 1 (if 0) of temp tablespace
>
> alter tablespace temp default storage(pctincrease 1);
>
> Regards
> Rafiq
>
>
> Reply-To: [EMAIL PROTECTED]
> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> Date: Thu, 01 Feb 2001 08:07:48 -0800
>
> Hi.
>
> I have my daily routine to check segmetn whose next extent will not fit in
> the single largest free extent in the tablespace.
> This morning I found the my temporary tablespace is on the list .
>
> We have 1624M assigned for the temp tablespace. As my understatd temp
> tablespace will extend itself as necessary and drop itself when operation
is
> done.
>
> I just wonder I should increase the size or wait to see  because we just
> have our application updated.
>
>
> Mitchell
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Mitchell
> INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
>
> _
> Get your FREE download of MSN Explorer at http://explorer.msn.com
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Mohammad Rafiq
>INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
>
> _
> Get your FREE download of MSN Explorer at http://explorer.msn.com
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Mohammad Rafiq
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
>

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

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

RE: How to find USER who locked my row ...

[Janardhana Babu]

Ferris,

Thanks for your help. I also modified the script, but couldn't get the
result that I wanted. Iam getting all userIds that are accessing at the
table level. I would like to explain the question in another way. I issued
the following stmt:

select * from  where doc_nbr = '12345' for update nowait;

It comes out with error ORA-54 saying that some other userid is updating the
same row. I would like to know the the userid who locked my row. 

I need to get some info like 'address of the row' from my above stmt. and
get the userid who locked the same row. If I can get the row_wait_row# value
of the above stmt, then, I can use it in the join stmt on row_wait_row#
column of the v$session to get the SID,SERIAL#,USERNAME etc.

I don't know how to get the row_wait_row# value for my above stmt. In
V$session it is displaying numbers such as 8, 12, 16etc. If this gives you
any clue, please try to help me.

Thanks...Babu

-Original Message-
Sent: Friday, February 02, 2001 12:55 PM
To: 'Janardhana Babu'
Importance: Low


Try this.. (tailor as necessary)

column sid format 9 heading 'SID'
column osuser  format a9heading 'OS-User'
column typeformat a14   heading 'Type'
column lmode   format a14   heading 'Line Mode'
column request format a15   heading 'Request'
set termout on
rem spool lock.lis

select A.sid,  osuser, A.type,
   decode(lmode, 2,'Row Share', 3,'Row Excl', 4,'Share',
 5,'Row Share Excl',6,'Table Excl', lmode) lmode,
   decode(request, 2,'Row Share', 3,'Row Excl', 4,'Share',
   5,'Row Share Excl', 6,'Table Excl', request) request
from   sys.v_$lock A, sys.v_$session B
where  A.sid = B.sid
andosuser is not null
order  by A.sid
/

HTH
Shawn M Ferris
Oracle DBA - Time Warner Telecom 

> -Original Message-
> From: Janardhana Babu [mailto:[EMAIL PROTECTED]]
> Sent: Friday, February 02, 2001 1:33 PM
> To: 'Ferris, Shawn'
> Subject: RE: How to find USER who locked my row ...
> 
> 
> Ferris,
> 
> Thanks for your help. I ran catblock.sql and also 
> utllockt.sql. I could see
> the views now. But the output of utllockt.sql is "no rows 
> selected" as no
> session is waiting. There is a session that locked the row. If another
> session tries to access the same row of the same table, it 
> comes out with
> error ORA-54 as this session is accessing with NOWAIT 
> specified. NOWAIT is a
> requirement in the application. In other words, I just want 
> to know who
> locked the row. My session just doesn't like to wait if the 
> row is being
> accessed by someone. I just would like to return my stmt with 
> ORA-54, but I
> would like to know who locked the row because of which Iam 
> kicked out with
> ORA-54. Please let me know if there are any ideas.
> 
> Thanks ... Babu 
> 
> -Original Message-
> From: Ferris, Shawn [mailto:[EMAIL PROTECTED]]
> Sent: Friday, February 02, 2001 11:46 AM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: How to find USER who locked my row ...
> 
> 
> You'll need to run catblock.sql, located in 
> $ORACLE_HOME/rdbms/admin. This
> will give you the views that you'll want. utllockt.sql will 
> give a "tree
> view" of waiters and their blockers too. (catblock.sql required for
> utllockt.sql)
> 
> HTH
> Shawn M Ferris
> Oracle DBA - Time Warner Telecom 
> 
> > -Original Message-
> > From: Janardhana Babu [mailto:[EMAIL PROTECTED]]
> > Sent: Friday, February 02, 2001 12:00 PM
> > To: Multiple recipients of list ORACLE-L
> > Subject: RE: How to find USER who locked my row ...
> > 
> > 
> > Rafiq,
> > 
> > I tried to execute the query, It comes out with an error: 
> > dba_blockers does
> > not exist. I verified in all of my Oracle 8i databases and 
> > have not found
> > that view anywhere. Has it been removed in 8i? If not, I 
> > don't have any clue
> > why it is not showing up?
> > 
> > Thanks...Babu
> > 
> > -Original Message-
> > Sent: Friday, February 02, 2001 9:56 AM
> > To: Multiple recipients of list ORACLE-L
> > 
> > 
> > Babu,
> > 
> > The message you have given pointing that object itself is 
> > being used and 
> > some application trying to create index on that table or 
> > table definition
> > itself being changed.
> > Try following query which might help:
> > 
> > spool holding_session.lst
> > column object_name justify c heading "Object|Name"  format a32
> > column usernamejustify c heading "User|Name"format a7
> > column osuser  justify c heading "OS|User"  format a7
> > column pid justify c heading "Ora|Proc|ID"  format 999
> > column serial# justify c heading "Ora|Serial|#" format 99
> > column sid justify c heading "Holding|Session"  format 999
> > column spidjustify c heading "Unix|Proc"format a5
> > column object_id   justify c heading "Obj|ID"   format 9
> > column lockwaitjustify c heading "Lock|Wait"
> > column typejustify c heading "Lock|Type"format a4
> > column lmode 

Re: Who wants to build a tablespace...

[Mohammad Rafiq]

I shall prefer to have 6 files of 500MB spliting on 6 mount points on 
different controllers.

Regards
Rafiq


Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Date: Fri, 02 Feb 2001 13:20:12 -0800


The question is...One BIG datafile (3 gig) or multiple smaller datafiles.

You still have audience or phone a friend...your final answer?

-Rocky



-
Do You Yahoo!?
- Get personalized email addresses from Yahoo! Mail Personal Address  - only 
$35 a year!

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

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: RE: RE: OT NT2K vs Unix.

[jkstill]

No, we just have different definitions of fun.

Writing a great piece of code, designing a database
that I feel good about, solving a sticky problem; I
find those things fun.

My friends say I'm wierd.

But I get paid for having fun, and I make
more than they do. ;)

Jared

On Fri, 2 Feb 2001, Kevin Kostyszyn wrote:

> my apologies, I think I might have slipped up and had some fun for a second.
> Guess that's the end of that.
> Have a good weekend.
>
> -Original Message-
> [EMAIL PROTECTED]
> Sent: Friday, February 02, 2001 3:37 PM
>  To: Multiple recipients of list ORACLE-L
>
>
> Jared,
>
> Wish I could say the same thing.  Anyone know of a fast way to get rid
> of a
> resident young adult???
>
> But, if you all let me return this thread back to a real discussion.  How
> many
> of you out there are using Linux, particularly RedHat, in a production
> environment preferably with Oracle?  The boss(s) around here are looking for
> a
> more "cost efficient" (read that as $0.00) operating system for some of our
> DB
> stuff.  We may even decide on a more "cost efficient" (same translation)
> rdbms,
> otherwise known as PostGreSQL.
>
> Dick Goulet
>
> Reply Separator
> Author: Jeffery Stevenson <[EMAIL PROTECTED]>
>  Date:   2/2/2001 12:16 PM
>
>   You'd probably notice...advances in software would probably slow down
> because not too many software teams out there can push the envelope of what
> can be done on a computer as well as game development can (although there
> are some that I can think of).  Heck, I wouldn't be surprised if the code
> for some database query optimizers trace back to some gaming AI code.   :)
>
> Jeffery Stevenson
> Chief Databeast Tamer
> Medical Present Value, Inc.
> Austin, TX
>
> -Original Message-
> Sent: Friday, February 02, 2001 10:19 AM
>  To: Multiple recipients of list ORACLE-L
>
>
> On Thu, 1 Feb 2001, Kevin Kostyszyn wrote:
>
> > What about Mechwarrior or Quake II, can I run that on Unix and will it run
> > smoothly?  This is a fun debate, but I do agree there will never be a
> > winner.
>
> If all gaming software disappeared tomorrow, I would never notice.
>
> Jared
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author:
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Jeffery Stevenson
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author:
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Kevin Kostyszyn
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
>

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

RE: Who wants to build a tablespace...

[Scott . Shafer]

Correct answer is D.  "It depends..."


> -Original Message-
> From: Rocky Welch [SMTP:[EMAIL PROTECTED]]
> Sent: Friday, February 02, 2001 3:20 PM
> To:   Multiple recipients of list ORACLE-L
> Subject:  Who wants to build a tablespace...
> 
> The question is...One BIG datafile (3 gig) or multiple smaller datafiles.
> 
> You still have audience or phone a friend...your final answer?
> 
> -Rocky
> 
> 
> 
>   _  
> 
> Do You Yahoo!?
> - Get personalized email addresses from Yahoo! Mail Personal Address
>  - only $35 a year!
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Pondering Question of the Day-RESPECT

[Steve Orr]

Sounds like a new white paper titled, "How To Be Fired as a DBA."  :-)

Best of luck... however you're interpreting that.  ;-)

Steve Orr


-Original Message-
[EMAIL PROTECTED]
Sent: Friday, February 02, 2001 11:46 AM
To: Multiple recipients of list ORACLE-L


Lisa,

What?!!  Are you betting against getting fired or for being fired?

Cherie


Oh well. It's Friday and I have a bet going that I'll be fired by the end of
the day.  If I do get fired today I win $500!  Ha!

Have a great weekend everyone
Lisa



-Original Message-
Sent: Friday, February 02, 2001 1:05 PM
To: Multiple recipients of list ORACLE-L


Pondering Question of the Day-RESPECTcome on! give me an user who prefer we,
developers and dbas working in a decent way, instead of
get its job done "rigth now in this moment" and I'll shave my head and paint
it blue.

developers get crazy trying to solve a problem with users on the other side
of the phone yelling!
and that's first reason of messing everything up.
(ok, don't generalize)
users' bosses want the same.

why can't we talk about the complete organization? and why everybody thinks
developers and dbas as
separate things?
If you can't separate responsabilities and duties, well, it's an
organization problem

try to take an equilibrium and you'll be happy

Gabriel Galanternik

- Original Message -
To: Multiple recipients of list ORACLE-L
Sent: Friday, February 02, 2001 1:10 PM


Lisa,
Rather than talking to the CTO about this go to the Dir, VP, or whatever of
the USERS of the system.  In-fact he/she is the actual OWNER of the data in
the system.  Explain to him/her how dangerous and devious the developers are
to the data.  Talk about corruption, system downtime, partial and incomplete
restores.  Use some technical DBA language to make them understand you have
the knowledge, but make sure you keep the message at a manager level of
understanding.  Get them good and scared.  Then when the developers are
asking for the free ride in production you have an advocate in high postion
that can put the CTO in a position of getting a backbone.  When the COO
starts asking why his people can't work, or why the P/L statement is messed
up the CTO will start scrambling for a lockdown on production and more
comprehensive testing of new or enhanced code.  Remember the politics.  We
in the IT field are not the production organization we are the service
organization.  When it comes to power struggles at the Cxx levels the
production/operations guys always beat the IT/IS guys.  It's a mater of $$$
and performance in front of the CEO.

HTH

Rodd Holman
-Original Message-
Sent: Friday, February 02, 2001 9:20 AM
To: Multiple recipients of list ORACLE-L


"Hello Oracle Guru"
Now why is it that I get more respect on the Internet than I do in my
workplace.  ??
How many of you have this problem?  It's like an ongoing fight with
developers, they want carte blanche in the production database, and they do
whatever they want EVEN THOUGH I tell them NO, let's do something different
that won't affect production.  I go to the CTO because this is like the 3rd
time this has happened, and he sends out a
let's-be-sure-not-to-offend-anyone email.  But the developer(s) will go
ahead and do what they want ANYWAY.  I'm waiting for the first user-mistake
recovery to say STOP, I've had ENOUGH and this is how it's going to be, no
ifs, ands or buts.
My last job may have been a sweatshop, but at least people respected my
authority.  Here, it's a free for all no matter what I do.  Even when I say,
Dude, I own the database.  If there's a problem, I have to fix it.
Therefore I say what happens in production and what doesn' t happen in
production.
And yes, I am looking for another position.  I can only take this
dba/developer/janitor role for so long.
I'M SO GLAD IT'S FRIDAY...  Bring on the Captain Morgan!  It's noon
somewhere...
Lisa Rutland Koivu
Oracle Database Administrator
Qode.com
4850 North State Road 7
Suite G104
Fort Lauderdale, FL  33319
V: 954.484.3191, x174
F: 954.484.2933
C: 954.658.5849
http://www.qode.com
"The information contained herein does not express the opinion or position
of Qode.com and cannot be attributed to or made binding upon Qode.com."

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re:NLS and ORA-03106: fatal two-task communication protocol

[Cherie_Machler]

Dick,

In this case, it doesn't appear to be NLS or a network problem.
The developer has replied with the following:

When I ran this code, I got the Oracle -1458 problem:

   EXEC SQL EXECUTE
  BEGIN
  EmployeePackage.GetNextDownloadEmployee;
  :xversion:= CommonGlobalPackage.Employee_Rec.VERSION;
  :xemail_name := CommonGlobalPackage.Employee_Rec.EMAIL_NAME;
  :employee_icn:= CommonGlobalPackage.Employee_Rec.EMP_ICN;
  :xprogram_load_flag  :=
CommonGlobalPackage.Employee_Rec.PROGRAM_LOAD_FLAG;
  :xboot_load_flag := CommonGlobalPackage.Employee_Rec.BOOT_LOAD_FLAG;
  END;
   END-EXEC;

It wasn't clear where the problem occurred in the code since the dbx debugger
doesn't step into the Pro*C code, so I divided the SQL EXECUTE into two parts
and re-ran the program.

   EXEC SQL EXECUTE
  BEGIN
  EmployeePackage.GetNextDownloadEmployee;
  :xversion:= CommonGlobalPackage.Employee_Rec.VERSION;
  :xemail_name := CommonGlobalPackage.Employee_Rec.EMAIL_NAME;
  END;
   END-EXEC;
   dummy = 1;
   EXEC SQL EXECUTE
  BEGIN
  :employee_icn:= CommonGlobalPackage.Employee_Rec.EMP_ICN;
  :xprogram_load_flag  :=
CommonGlobalPackage.Employee_Rec.PROGRAM_LOAD_FLAG;
  :xboot_load_flag := CommonGlobalPackage.Employee_Rec.BOOT_LOAD_FLAG;
  END;
   END-EXEC;

When this version of the code run, I get the Oracle -3106 error.  As far as I
know,
the second version is legal; the compiler gives me no errors or warnings.


Any clues, Dick?

Cherie




[EMAIL PROTECTED] on 02/02/2001 02:24:39 PM

Please respond to [EMAIL PROTECTED]

To:   Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:(bcc: Cherie Machler/GELCO)




Cherie,

NLS_LANG and NLS_DATE_FORMAT.  Things I've seen on this front.

Database created with US7ASCII & end user using
American_america.WE8ISO8859P1

Database set for NLS_DATE_FORMAT='DD-MON-YY'
  and end user with NLS_DATE_FORMAT ='DD-MON-:HH24:MI

But in general 3106 is a catch all.  Generally it means that something happen,
it does not know for sure, so it defaults.  Other possibilities: bad network
cable(s), DNS server oops, router fowl-up, bad network card(s), noisy network
card(s), someone with a fat foot, or my all time favorite Access being used as a
multi user DB.  That last one will send the data packet collision rate through
the ceiling.

Dick Goulet

Reply Separator
Author: [EMAIL PROTECTED]
Date:   2/2/2001 11:41 AM

We're getting this ORA-03106 error on 8.1.5 Oracle on Sun Solaris.

I looked it up on Metalink and there is quite a lot of information
there.  I looked at one document in particular and found lots
of causes for ORA-03106.  I'm going through the possibilities
one at a time and am wondering what one of the items means.

In item number 1 below it says to check for NLS incompatibilities.
Nothing real specific.  Do they mean like the values for NLS_LANG
or something like that?  I'm not sure and I don't have anyone to
follow up with.  Anyone have a clue?  Following is the excerpt:

RDBMS - Troubleshooting two-task common errors
==

1. Check for NLS incompatibilities between the client and server.  This is
   a very popular cause of the ORA-03106 error.

2. Check the alert log and RDBMS trace files for any pertinent information /
   errors that coincide with receiving the ORA-03106 error.

3. Try to get a testcase and reproduce the problem in-house.

4. If a testcase is not possible, ask for SQL*Net trace files, SQL traces, and
   try setting event 3106 to obtain the error stack.

5. In extreme circumstances, this could indicate that a shared memory segment
   used by Oracle is corrupted.  You will have to shut down the database,
   possibly using the abort option.  Make sure all semaphores have been
   released by using the IPCS command on Unix.  Oracle uses semaphores to
   control concurrency between all of the background processes (pmon, smon,
   drwr, lgwr, and oracle shadow processes).  Semaphores are also used to
   control Two-Task communication between the user process and the shadow
   process.

6. Try and narrow down the code that may be causing it.  For example it might
   have started to happen after increasing the number of parameters in a PL/SQL
   block or when using certain values for bind variables, etc.

7. If we still do not make headway, file a bug under RDBMS, but we still may
   need some or all of the above information as indicated above.

Thanks,

Cherie Machler
Gelco Information Network


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

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

To REMOVE yourself from this mailin

Tool to convert from Sybase to Oracle

[Viktor]

Hello All,

Is there a freeware tool that can convert pretty
simple Sybase queries to Oracle?

Thanks.

__
Get personalized email addresses from Yahoo! Mail - only $35 
a year!  http://personal.mail.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Viktor
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

OTN info

[Mohammad Rafiq]

Just for info of list members:





OTN Expert Advice Marketplace

Expert Advice provides an opportunity for developers to get answers to 
questions beyond Oracle Technology. Where as OTN discussion forums provide 
instant access to Oracle specific technology experts, Expert Advice provides 
instant access to experts who have knowledge that are beyond Oracle like 
operating systems, languages, networking, hardware, graphics, application 
software and web development software.

Experts Exchange is a leader in IT professional collaboration network. It 
provides a platform for developers to share knowledge quickly and 
efficiently and has more than million validated IT solutions in its 
knowledge bank and is actively supported by over 400,000 members and 70,000 
experts.

Join the community and benefit from shared knowledge.

Enjoy,

Regards
Rafiq


Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Date: Fri, 02 Feb 2001 08:10:59 -0800


Glenn,

dba_temp_files will be populated when you create a temporary tablespace.

e.g.  create temporary tablespace temp tempfile '/oradata/temp01.dbf' size 
1000m;

Jared

On Thu, 1 Feb 2001, Glenn Travis wrote:

 > What is usually in dba_temp_files?  Mine has zero rows (all day).  If you
 > shutdown and restart Oracle, will this table be empty?
 >
 > > -Original Message-
 > > From: Igor Polishchuk [mailto:[EMAIL PROTECTED]]
 > > Sent: Tuesday, January 30, 2001 9:38 PM
 > > To: 'Glenn Travis'; Woody Mckay; [EMAIL PROTECTED];
 > > [EMAIL PROTECTED]
 > > Subject: RE: How to drop a database
 > >
 > >
 > > Hi Glenn
 > > You missed temporary files, that may be associated with database
 > > Velow is my script that creates script for database deleting and 
includes
 > > temporary files too. But it is necessary to be careful with it :)
 > >
 > > #  This script shutdown current database and delete all files for
 > > #c #  this
 > > database
 > > #
 > > #
 > > sqlplus -s internal << EOF
 > > spool _rm_files.sh
 > > set head off feedback off pages 0
 > >
 > > select 'rm '|| file_name
 > > from dba_data_files;
 > >
 > > select 'rm '|| file_name
 > > from dba_temp_files;
 > >
 > > select 'rm '|| name
 > > from v\$controlfile;
 > >
 > > select 'rm '|| member
 > >  from v\$logfile;
 > >
 > > prompt rm $ORACLE_HOME/dbs/orapw$ORACLE_SID
 > >
 > > spool off
 > >
 > > shutdown abort
 > >
 > > EOF
 > >
 > > chmod u+x ./_rm_files.sh
 > >
 > > #./_rm_files.sh
 > >
 > >
 > >
 > > Igor Polishchuk
 > > IT department
 > > DigitalThink
 > > (415) 625 4285
 > > e-mail: [EMAIL PROTECTED]
 > >
 > >
 > > -Original Message-
 > > From: Glenn Travis [mailto:[EMAIL PROTECTED]]
 > > Sent: Tuesday, January 30, 2001 11:06 AM
 > > To: Woody Mckay; [EMAIL PROTECTED]; [EMAIL PROTECTED]
 > > Subject: RE: How to drop a database
 > >
 > >
 > > Here's a script I wrote to list all the files associated with the
 > > database.
 > > List, did I miss any?
 > > ___
 > > break on today
 > > column today noprint new_value xdate
 > > select substr(to_char(sysdate,'fmMonth DD,  HH:MI:SS
 > > P.M.'),1,35) today
 > > from dual;
 > > column name noprint new_value dbname
 > > column created noprint new_value dbcreated
 > > column host_name noprint new_value hostname
 > > select name,created from v$database;
 > > select host_name from v$instance;
 > >
 > > spool &dbname..&hostname..databasefiles.out
 > >
 > > prompt Date:  &xdate
 > > prompt DATABASE:  &dbname
 > > prompt HOST:  &hostname
 > > prompt Created:   &dbcreated
 > > prompt
 > > prompt 
 > > prompt *  Database Files  *
 > > prompt 
 > > prompt
 > >
 > > set head off echo off pagesize 0 trimspool on feed off linesize 132
 > >
 > > clear columns
 > > col ftype format a15
 > > col tbspc format a20
 > > col fname format a50
 > >
 > > select 'Controlfile' ftype, name fname , ' ' tbspc
 > >   from SYS.V_$CONTROLFILE
 > > union
 > > select 'Logfile' ftype, member fname, ' ' tbspc
 > >   from SYS.V_$LOGFILE
 > > union
 > > select 'Tablespace' ftype, file_name fname,
 > > '('||tablespace_name||')' tbspc
 > >   from DBA_DATA_FILES
 > > order by 2;
 > >
 > > spool off
 > > prompt
 > > prompt Output in &dbname..&hostname..databasefiles.out
 > > prompt
 > > quit
 > > _
 > >
 > >
 > > > -Original Message-
 > > > From: Ruth Gramolini [mailto:[EMAIL PROTECTED]]
 > > > Sent: Tuesday, January 30, 2001 1:08 PM
 > > > To: Woody Mckay; [EMAIL PROTECTED]; [EMAIL PROTECTED]
 > > > Subject: Re: How to drop a database
 > > >
 > > >
 > > > There  is not command to drop a database.  You just have to
 > > remove all of
 > > > the files associated with that database: control files, datafiles, 
etc.
 > > >
 > > > Ruth
 > > > - Original Message -
 > > > From: "Woody Mckay" <[EMAIL PROTECTED]>
 > > > To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
 > > > Sent: Tue

Re: Thanks and another book request

[Pat Hildebrand]

> 
> Rachael
> 
> > consultant for that number of hours Not profitable to write one.
> 
> The very fact that you often repeat this in response to mails that refer to
> your books, makes us think otherwise $$$
> 

I have not written any Oracle books but I have had enough experience
with publishers that I really have to step in here. My husband
happened to be one of three authors on a monograph that had enough
popularity to stick around for quite awhile now. Want to guess his
share of the yearly royalties (split equally between the three of
them)? Approximately $100. Okay over twenty years that's a couple
thousand. He repeatly said that the only reason to write a book was
because you got mad at what was available; it certainly wasn't for the
money. The monograph was not something that would need to be updated
all the time the way an Oracle book would be.

The need for new editions opens up the book to driving your life. I
did some work on supplemental work for my husband's textbooks and
trying that with a full time job is something I would not wish on my
worst enemy. Impossible deadlines still need to be met by you but
don't count on getting things back when promised - your time to make
the changes is just squeezed.

If Rachael is one of the really limited number of people who make what
might be considered a reasonable return on her time, I say more power
to her. However, it is more likely that she has to repeat because
people don't believe her.



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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Who wants to build a tablespace...

[Rocky Welch]

The question is...One BIG datafile (3 gig) or multiple smaller datafiles.
You still have audience or phone a friend...your final answer?
-RockyDo You Yahoo!?
- Get personalized email addresses from Yahoo! Mail Personal Address  - only $35 
a year!

RE: RE: RE: OT NT2K vs Unix.

[Kevin Kostyszyn]

my apologies, I think I might have slipped up and had some fun for a second.
Guess that's the end of that.
Have a good weekend.

-Original Message-
[EMAIL PROTECTED]
Sent: Friday, February 02, 2001 3:37 PM
To: Multiple recipients of list ORACLE-L


Jared,

Wish I could say the same thing.  Anyone know of a fast way to get rid
of a
resident young adult???

But, if you all let me return this thread back to a real discussion.  How
many
of you out there are using Linux, particularly RedHat, in a production
environment preferably with Oracle?  The boss(s) around here are looking for
a
more "cost efficient" (read that as $0.00) operating system for some of our
DB
stuff.  We may even decide on a more "cost efficient" (same translation)
rdbms,
otherwise known as PostGreSQL.

Dick Goulet

Reply Separator
Author: Jeffery Stevenson <[EMAIL PROTECTED]>
Date:   2/2/2001 12:16 PM

  You'd probably notice...advances in software would probably slow down
because not too many software teams out there can push the envelope of what
can be done on a computer as well as game development can (although there
are some that I can think of).  Heck, I wouldn't be surprised if the code
for some database query optimizers trace back to some gaming AI code.   :)

Jeffery Stevenson
Chief Databeast Tamer
Medical Present Value, Inc.
Austin, TX

-Original Message-
Sent: Friday, February 02, 2001 10:19 AM
To: Multiple recipients of list ORACLE-L


On Thu, 1 Feb 2001, Kevin Kostyszyn wrote:

> What about Mechwarrior or Quake II, can I run that on Unix and will it run
> smoothly?  This is a fun debate, but I do agree there will never be a
> winner.

If all gaming software disappeared tomorrow, I would never notice.

Jared

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Jeffery Stevenson
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: How to find USER who locked my row ...

[Mohammad Rafiq]

Babu,

The message "Resource busy' is coming when your code is trying to change 
definition of table or trying to create any index when table is in use not 
for dml but may be somebody running select only.You may use following script 
to check which user is accessing this table in case if  any dml is 
invloved.

set linesize 120
select substr(a.os_user_name,1,8) "OS User"
, substr(b.object_name,1,30) "Object Name"
, substr(b.object_type,1,8) "Type"
, substr(c.segment_name,1,10) "RBS"
, e.process "PROCESS"
, substr(d.used_urec,1,8) "# of Records"
from v$locked_object a
, dba_objects b
, dba_rollback_segs c
, v$transaction d
, v$session e
where a.object_id = b.object_id
and a.xidusn = c.segment_id
and a.xidusn = d.xidusn
and a.xidslot = d.xidslot
and d.addr = e.taddr
/

Regards
Rafiq



To: 'Mohammad Rafiq' <[EMAIL PROTECTED]>, [EMAIL PROTECTED]
Date: Fri, 2 Feb 2001 12:17:31 -0800

Rafiq,

You are right. After running the catblock.sql script, I could see the views,
but the output is "no rows selected". This is because the session that is
accessing the locked row comes out with ORA-54 error instead of waiting for
the lock to be released. There is a "nowait" clause at the end of the stmt.
They don't want to session to wait if the row is locked by some other
session, they just want to return ORA-54 error, but at the same time they
want to know what user is locked the row at the time our session is
accessing the row. If you have any other ideas, please let me know.

Thanks ... Babu


-Original Message-
Sent: Friday, February 02, 2001 11:58 AM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]


Babu,

Your system may be missing dba_blockers,dba_waiters views. Please look
for script catblock.sql under $ORACLE_HOME/rdbms/admin and run it as per
guidance given in that script.

Regards
Rafiq


To: "'[EMAIL PROTECTED]'" <[EMAIL PROTECTED]>
CC: 'Mohammad Rafiq' <[EMAIL PROTECTED]>
Date: Fri, 2 Feb 2001 10:59:20 -0800

Rafiq,

I tried to execute the query, It comes out with an error: dba_blockers does
not exist. I verified in all of my Oracle 8i databases and have not found
that view anywhere. Has it been removed in 8i? If not, I don't have any clue
why it is not showing up?

Thanks...Babu

-Original Message-
Sent: Friday, February 02, 2001 9:56 AM
To: Multiple recipients of list ORACLE-L


Babu,

The message you have given pointing that object itself is being used and
some application trying to create index on that table or table definition
itself being changed.
Try following query which might help:

spool holding_session.lst
column object_name justify c heading "Object|Name"  format a32
column usernamejustify c heading "User|Name"format a7
column osuser  justify c heading "OS|User"  format a7
column pid justify c heading "Ora|Proc|ID"  format 999
column serial# justify c heading "Ora|Serial|#" format 99
column sid justify c heading "Holding|Session"  format 999
column spidjustify c heading "Unix|Proc"format a5
column object_id   justify c heading "Obj|ID"   format 9
column lockwaitjustify c heading "Lock|Wait"
column typejustify c heading "Lock|Type"format a4
column lmode   justify c heading "Mode" format 
set pagesize 60 linesize 100
select lck.sid, ses.serial#, pro.pid, pro.spid, obj.object_name,
 obj.object_id, ses.username, ses.osuser,
 lck.type, lck.lmode
from dba_blockers blk, dba_objects obj, v$lock lck,
   v$session ses, v$process pro
where blk.holding_session = ses.sid
and   lck.id1   = obj.object_id
and   lck.sid   = ses.sid
and   ses.paddr = pro.addr
and   ses.username is not NULL
order by obj.object_name, ses.lockwait desc, lck.sid;
spool off
clear columns
/
Regards
Rafiq







Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Date: Fri, 02 Feb 2001 09:16:19 -0800

Steve,

Unfortunately, I can't take out NOWAIT as it is part of the application
design. They don't want the query to hang for some other user to unlock the
record. There are plenty of users accessing the same table and the same row
at the same time. We want the query to return with ORA-54, but at the same
time we would like to know the the user/user details who locked the record
of the table. This is part of the requirement of this application here.

Is there a way to find the details that we need? Please let me know if there
is any solution.

Thanks ... Babu

-Original Message-
Sent: Thursday, February 01, 2001 6:51 PM
To: Multiple recipients of list ORACLE-L


Hi Babu,

Take out the NOWAIT temporarily so that the session will wait, and then look
in
V$LOCK to see which TX lock you are waiting for and who is holding it.

@   Regards,
@   Steve Adams
@   http://www.ixora.com.au/
@   http://www.christianity.net.au/


-Original Message-
Sent: Friday, 2 February 2001 9:50
To: Multiple recipients of list ORACLE-L


Dear list,

I am simulating an error generated by an appli

Re: Thanks and another book request

[orclbabu]

Rachael

> consultant for that number of hours Not profitable to write one.

The very fact that you often repeat this in response to mails that refer to
your books, makes us think otherwise $$$

;-)

babu

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re:RE: RE: OT NT2K vs Unix.

[dgoulet]

Jared,

Wish I could say the same thing.  Anyone know of a fast way to get rid of a
resident young adult???

But, if you all let me return this thread back to a real discussion.  How many
of you out there are using Linux, particularly RedHat, in a production
environment preferably with Oracle?  The boss(s) around here are looking for a
more "cost efficient" (read that as $0.00) operating system for some of our DB
stuff.  We may even decide on a more "cost efficient" (same translation) rdbms,
otherwise known as PostGreSQL.

Dick Goulet

Reply Separator
Author: Jeffery Stevenson <[EMAIL PROTECTED]>
Date:   2/2/2001 12:16 PM

  You'd probably notice...advances in software would probably slow down
because not too many software teams out there can push the envelope of what
can be done on a computer as well as game development can (although there
are some that I can think of).  Heck, I wouldn't be surprised if the code
for some database query optimizers trace back to some gaming AI code.   :)

Jeffery Stevenson
Chief Databeast Tamer
Medical Present Value, Inc.
Austin, TX

-Original Message-
Sent: Friday, February 02, 2001 10:19 AM
To: Multiple recipients of list ORACLE-L


On Thu, 1 Feb 2001, Kevin Kostyszyn wrote:

> What about Mechwarrior or Quake II, can I run that on Unix and will it run
> smoothly?  This is a fun debate, but I do agree there will never be a
> winner.

If all gaming software disappeared tomorrow, I would never notice.

Jared

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jeffery Stevenson
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re:RE: Pondering Question of the Day-RESPECT

[dgoulet]

OH, I see: $50 to the SA if you stay, $500 in your pocket and your gone.  Sounds
like one of those win/win scenarios. (NYUCK,NYUCK,NYUCK)

Dick Goulet


Reply Separator
Author: "Koivu; Lisa" <[EMAIL PROTECTED]>
Date:   2/2/2001 12:05 PM

I have a bet going with our SA that I WILL be fired.  He thinks I won't.  10
to 1.  
Come on, laugh, it's funny! 


-Original Message-
Sent: Friday, February 02, 2001 2:46 PM
To: Multiple recipients of list ORACLE-L


Lisa,

What?!!  Are you betting against getting fired or for being fired?

Cherie


Oh well. It's Friday and I have a bet going that I'll be fired by the end of
the day.  If I do get fired today I win $500!  Ha!

Have a great weekend everyone
Lisa



-Original Message-
Sent: Friday, February 02, 2001 1:05 PM
To: Multiple recipients of list ORACLE-L


Pondering Question of the Day-RESPECTcome on! give me an user who prefer we,
developers and dbas working in a decent way, instead of
get its job done "rigth now in this moment" and I'll shave my head and paint
it blue.

developers get crazy trying to solve a problem with users on the other side
of the phone yelling!
and that's first reason of messing everything up.
(ok, don't generalize)
users' bosses want the same.

why can't we talk about the complete organization? and why everybody thinks
developers and dbas as
separate things?
If you can't separate responsabilities and duties, well, it's an
organization problem

try to take an equilibrium and you'll be happy

Gabriel Galanternik

- Original Message -
To: Multiple recipients of list ORACLE-L
Sent: Friday, February 02, 2001 1:10 PM


Lisa,
Rather than talking to the CTO about this go to the Dir, VP, or whatever of
the USERS of the system.  In-fact he/she is the actual OWNER of the data in
the system.  Explain to him/her how dangerous and devious the developers are
to the data.  Talk about corruption, system downtime, partial and incomplete
restores.  Use some technical DBA language to make them understand you have
the knowledge, but make sure you keep the message at a manager level of
understanding.  Get them good and scared.  Then when the developers are
asking for the free ride in production you have an advocate in high postion
that can put the CTO in a position of getting a backbone.  When the COO
starts asking why his people can't work, or why the P/L statement is messed
up the CTO will start scrambling for a lockdown on production and more
comprehensive testing of new or enhanced code.  Remember the politics.  We
in the IT field are not the production organization we are the service
organization.  When it comes to power struggles at the Cxx levels the
production/operations guys always beat the IT/IS guys.  It's a mater of $$$
and performance in front of the CEO.

HTH

Rodd Holman
-Original Message-
Sent: Friday, February 02, 2001 9:20 AM
To: Multiple recipients of list ORACLE-L


"Hello Oracle Guru"
Now why is it that I get more respect on the Internet than I do in my
workplace.  ??
How many of you have this problem?  It's like an ongoing fight with
developers, they want carte blanche in the production database, and they do
whatever they want EVEN THOUGH I tell them NO, let's do something different
that won't affect production.  I go to the CTO because this is like the 3rd
time this has happened, and he sends out a
let's-be-sure-not-to-offend-anyone email.  But the developer(s) will go
ahead and do what they want ANYWAY.  I'm waiting for the first user-mistake
recovery to say STOP, I've had ENOUGH and this is how it's going to be, no
ifs, ands or buts.
My last job may have been a sweatshop, but at least people respected my
authority.  Here, it's a free for all no matter what I do.  Even when I say,
Dude, I own the database.  If there's a problem, I have to fix it.
Therefore I say what happens in production and what doesn' t happen in
production.
And yes, I am looking for another position.  I can only take this
dba/developer/janitor role for so long.
I'M SO GLAD IT'S FRIDAY...  Bring on the Captain Morgan!  It's noon
somewhere...
Lisa Rutland Koivu
Oracle Database Administrator
Qode.com
4850 North State Road 7
Suite G104
Fort Lauderdale, FL  33319
V: 954.484.3191, x174
F: 954.484.2933
C: 954.658.5849
http://www.qode.com
"The information contained herein does not express the opinion or position
of Qode.com and cannot be attributed to or made binding upon Qode.com."

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or th

Oracle pricing eclipses Sun users

[Glenn Travis]

http://www.vnunet.com/News/1117113

More pricing fodder for discussion. Some interesting quotes;
"It's the nature of capacity-based pricing. Doubling processor speed means
doubling the price of Oracle licences, but doesn't mean twice the
performance," he explained.

Their big example was that Sun's top line server (E1) runs half as fast
as the IBM top line server (p680), but costs twice as much to run Oracle on
(due to the UPU ratings).  Hmmm.


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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: RE: OT NT2K vs Unix.

[Jeffery Stevenson]

  You'd probably notice...advances in software would probably slow down
because not too many software teams out there can push the envelope of what
can be done on a computer as well as game development can (although there
are some that I can think of).  Heck, I wouldn't be surprised if the code
for some database query optimizers trace back to some gaming AI code.   :)

Jeffery Stevenson
Chief Databeast Tamer
Medical Present Value, Inc.
Austin, TX

-Original Message-
Sent: Friday, February 02, 2001 10:19 AM
To: Multiple recipients of list ORACLE-L


On Thu, 1 Feb 2001, Kevin Kostyszyn wrote:

> What about Mechwarrior or Quake II, can I run that on Unix and will it run
> smoothly?  This is a fun debate, but I do agree there will never be a
> winner.

If all gaming software disappeared tomorrow, I would never notice.

Jared

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jeffery Stevenson
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re:NLS and ORA-03106: fatal two-task communication protocol

[dgoulet]

Cherie,

NLS_LANG and NLS_DATE_FORMAT.  Things I've seen on this front.

Database created with US7ASCII & end user using
American_america.WE8ISO8859P1

Database set for NLS_DATE_FORMAT='DD-MON-YY'
  and end user with NLS_DATE_FORMAT ='DD-MON-:HH24:MI

But in general 3106 is a catch all.  Generally it means that something happen,
it does not know for sure, so it defaults.  Other possibilities: bad network
cable(s), DNS server oops, router fowl-up, bad network card(s), noisy network
card(s), someone with a fat foot, or my all time favorite Access being used as a
multi user DB.  That last one will send the data packet collision rate through
the ceiling.

Dick Goulet

Reply Separator
Author: [EMAIL PROTECTED]
Date:   2/2/2001 11:41 AM

We're getting this ORA-03106 error on 8.1.5 Oracle on Sun Solaris.

I looked it up on Metalink and there is quite a lot of information
there.  I looked at one document in particular and found lots
of causes for ORA-03106.  I'm going through the possibilities
one at a time and am wondering what one of the items means.

In item number 1 below it says to check for NLS incompatibilities.
Nothing real specific.  Do they mean like the values for NLS_LANG
or something like that?  I'm not sure and I don't have anyone to
follow up with.  Anyone have a clue?  Following is the excerpt:

RDBMS - Troubleshooting two-task common errors
==

1. Check for NLS incompatibilities between the client and server.  This is
   a very popular cause of the ORA-03106 error.

2. Check the alert log and RDBMS trace files for any pertinent information /
   errors that coincide with receiving the ORA-03106 error.

3. Try to get a testcase and reproduce the problem in-house.

4. If a testcase is not possible, ask for SQL*Net trace files, SQL traces, and
   try setting event 3106 to obtain the error stack.

5. In extreme circumstances, this could indicate that a shared memory segment
   used by Oracle is corrupted.  You will have to shut down the database,
   possibly using the abort option.  Make sure all semaphores have been
   released by using the IPCS command on Unix.  Oracle uses semaphores to
   control concurrency between all of the background processes (pmon, smon,
   drwr, lgwr, and oracle shadow processes).  Semaphores are also used to
   control Two-Task communication between the user process and the shadow
   process.

6. Try and narrow down the code that may be causing it.  For example it might
   have started to happen after increasing the number of parameters in a PL/SQL
   block or when using certain values for bind variables, etc.

7. If we still do not make headway, file a bug under RDBMS, but we still may
   need some or all of the above information as indicated above.

Thanks,

Cherie Machler
Gelco Information Network


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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: How to find USER who locked my row ...

[Janardhana Babu]

Rafiq,

You are right. After running the catblock.sql script, I could see the views,
but the output is "no rows selected". This is because the session that is
accessing the locked row comes out with ORA-54 error instead of waiting for
the lock to be released. There is a "nowait" clause at the end of the stmt.
They don't want to session to wait if the row is locked by some other
session, they just want to return ORA-54 error, but at the same time they
want to know what user is locked the row at the time our session is
accessing the row. If you have any other ideas, please let me know.

Thanks ... Babu
 

-Original Message-
Sent: Friday, February 02, 2001 11:58 AM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]


Babu,

Your system may be missing dba_blockers,dba_waiters views. Please look
for script catblock.sql under $ORACLE_HOME/rdbms/admin and run it as per
guidance given in that script.

Regards
Rafiq


To: "'[EMAIL PROTECTED]'" <[EMAIL PROTECTED]>
CC: 'Mohammad Rafiq' <[EMAIL PROTECTED]>
Date: Fri, 2 Feb 2001 10:59:20 -0800

Rafiq,

I tried to execute the query, It comes out with an error: dba_blockers does
not exist. I verified in all of my Oracle 8i databases and have not found
that view anywhere. Has it been removed in 8i? If not, I don't have any clue
why it is not showing up?

Thanks...Babu

-Original Message-
Sent: Friday, February 02, 2001 9:56 AM
To: Multiple recipients of list ORACLE-L


Babu,

The message you have given pointing that object itself is being used and
some application trying to create index on that table or table definition
itself being changed.
Try following query which might help:

spool holding_session.lst
column object_name justify c heading "Object|Name"  format a32
column usernamejustify c heading "User|Name"format a7
column osuser  justify c heading "OS|User"  format a7
column pid justify c heading "Ora|Proc|ID"  format 999
column serial# justify c heading "Ora|Serial|#" format 99
column sid justify c heading "Holding|Session"  format 999
column spidjustify c heading "Unix|Proc"format a5
column object_id   justify c heading "Obj|ID"   format 9
column lockwaitjustify c heading "Lock|Wait"
column typejustify c heading "Lock|Type"format a4
column lmode   justify c heading "Mode" format 
set pagesize 60 linesize 100
select lck.sid, ses.serial#, pro.pid, pro.spid, obj.object_name,
obj.object_id, ses.username, ses.osuser,
lck.type, lck.lmode
from dba_blockers blk, dba_objects obj, v$lock lck,
  v$session ses, v$process pro
where blk.holding_session = ses.sid
and   lck.id1   = obj.object_id
and   lck.sid   = ses.sid
and   ses.paddr = pro.addr
and   ses.username is not NULL
order by obj.object_name, ses.lockwait desc, lck.sid;
spool off
clear columns
/
Regards
Rafiq







Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Date: Fri, 02 Feb 2001 09:16:19 -0800

Steve,

Unfortunately, I can't take out NOWAIT as it is part of the application
design. They don't want the query to hang for some other user to unlock the
record. There are plenty of users accessing the same table and the same row
at the same time. We want the query to return with ORA-54, but at the same
time we would like to know the the user/user details who locked the record
of the table. This is part of the requirement of this application here.

Is there a way to find the details that we need? Please let me know if there
is any solution.

Thanks ... Babu

-Original Message-
Sent: Thursday, February 01, 2001 6:51 PM
To: Multiple recipients of list ORACLE-L


Hi Babu,

Take out the NOWAIT temporarily so that the session will wait, and then look
in
V$LOCK to see which TX lock you are waiting for and who is holding it.

@   Regards,
@   Steve Adams
@   http://www.ixora.com.au/
@   http://www.christianity.net.au/


-Original Message-
Sent: Friday, 2 February 2001 9:50
To: Multiple recipients of list ORACLE-L


Dear list,

I am simulating an error generated by an application.

select * from XXX where fdoc_nbr = '12345'  for update nowait;

It returns with error:
ORA-00054 Resource busy acquire with nowait specified.

I need to findout who(SID,SERIAL#,USERNAME) locked the same ROW (not table).
There are many users who are locking different rows of the same table at the
same time. I need to find the one who locked my row.

I would appreciate if someone could help me with this.

TIA,
-- Babu

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY

RE: Pondering Question of the Day-RESPECT

[Koivu, Lisa]

Title: RE: Pondering Question of the Day-RESPECT





I have a bet going with our SA that I WILL be fired.  He thinks I won't.  10 to 1.  
Come on, laugh, it's funny! 



-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Friday, February 02, 2001 2:46 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: Pondering Question of the Day-RESPECT



Lisa,


What?!!  Are you betting against getting fired or for being fired?


Cherie



Oh well. It's Friday and I have a bet going that I'll be fired by the end of
the day.  If I do get fired today I win $500!  Ha!


Have a great weekend everyone
Lisa




-Original Message-
Sent: Friday, February 02, 2001 1:05 PM
To: Multiple recipients of list ORACLE-L



Pondering Question of the Day-RESPECTcome on! give me an user who prefer we,
developers and dbas working in a decent way, instead of
get its job done "rigth now in this moment" and I'll shave my head and paint
it blue.


developers get crazy trying to solve a problem with users on the other side
of the phone yelling!
and that's first reason of messing everything up.
(ok, don't generalize)
users' bosses want the same.


why can't we talk about the complete organization? and why everybody thinks
developers and dbas as
separate things?
If you can't separate responsabilities and duties, well, it's an
organization problem


try to take an equilibrium and you'll be happy


Gabriel Galanternik


- Original Message -
To: Multiple recipients of list ORACLE-L
Sent: Friday, February 02, 2001 1:10 PM



Lisa,
Rather than talking to the CTO about this go to the Dir, VP, or whatever of
the USERS of the system.  In-fact he/she is the actual OWNER of the data in
the system.  Explain to him/her how dangerous and devious the developers are
to the data.  Talk about corruption, system downtime, partial and incomplete
restores.  Use some technical DBA language to make them understand you have
the knowledge, but make sure you keep the message at a manager level of
understanding.  Get them good and scared.  Then when the developers are
asking for the free ride in production you have an advocate in high postion
that can put the CTO in a position of getting a backbone.  When the COO
starts asking why his people can't work, or why the P/L statement is messed
up the CTO will start scrambling for a lockdown on production and more
comprehensive testing of new or enhanced code.  Remember the politics.  We
in the IT field are not the production organization we are the service
organization.  When it comes to power struggles at the Cxx levels the
production/operations guys always beat the IT/IS guys.  It's a mater of $$$
and performance in front of the CEO.


HTH


Rodd Holman
-Original Message-
Sent: Friday, February 02, 2001 9:20 AM
To: Multiple recipients of list ORACLE-L



"Hello Oracle Guru"
Now why is it that I get more respect on the Internet than I do in my
workplace.  ??
How many of you have this problem?  It's like an ongoing fight with
developers, they want carte blanche in the production database, and they do
whatever they want EVEN THOUGH I tell them NO, let's do something different
that won't affect production.  I go to the CTO because this is like the 3rd
time this has happened, and he sends out a
let's-be-sure-not-to-offend-anyone email.  But the developer(s) will go
ahead and do what they want ANYWAY.  I'm waiting for the first user-mistake
recovery to say STOP, I've had ENOUGH and this is how it's going to be, no
ifs, ands or buts.
My last job may have been a sweatshop, but at least people respected my
authority.  Here, it's a free for all no matter what I do.  Even when I say,
Dude, I own the database.  If there's a problem, I have to fix it.
Therefore I say what happens in production and what doesn' t happen in
production.
And yes, I am looking for another position.  I can only take this
dba/developer/janitor role for so long.
I'M SO GLAD IT'S FRIDAY...  Bring on the Captain Morgan!  It's noon
somewhere...
Lisa Rutland Koivu
Oracle Database Administrator
Qode.com
4850 North State Road 7
Suite G104
Fort Lauderdale, FL  33319
V: 954.484.3191, x174
F: 954.484.2933
C: 954.658.5849
http://www.qode.com
"The information contained herein does not express the opinion or position
of Qode.com and cannot be attributed to or made binding upon Qode.com."


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


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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other informati

RE: How to find USER who locked my row ...

[Mohammad Rafiq]

Babu,

Your system may be missing dba_blockers,dba_waiters views. Please look
for script catblock.sql under $ORACLE_HOME/rdbms/admin and run it as per
guidance given in that script.

Regards
Rafiq


To: "'[EMAIL PROTECTED]'" <[EMAIL PROTECTED]>
CC: 'Mohammad Rafiq' <[EMAIL PROTECTED]>
Date: Fri, 2 Feb 2001 10:59:20 -0800

Rafiq,

I tried to execute the query, It comes out with an error: dba_blockers does
not exist. I verified in all of my Oracle 8i databases and have not found
that view anywhere. Has it been removed in 8i? If not, I don't have any clue
why it is not showing up?

Thanks...Babu

-Original Message-
Sent: Friday, February 02, 2001 9:56 AM
To: Multiple recipients of list ORACLE-L


Babu,

The message you have given pointing that object itself is being used and
some application trying to create index on that table or table definition
itself being changed.
Try following query which might help:

spool holding_session.lst
column object_name justify c heading "Object|Name"  format a32
column usernamejustify c heading "User|Name"format a7
column osuser  justify c heading "OS|User"  format a7
column pid justify c heading "Ora|Proc|ID"  format 999
column serial# justify c heading "Ora|Serial|#" format 99
column sid justify c heading "Holding|Session"  format 999
column spidjustify c heading "Unix|Proc"format a5
column object_id   justify c heading "Obj|ID"   format 9
column lockwaitjustify c heading "Lock|Wait"
column typejustify c heading "Lock|Type"format a4
column lmode   justify c heading "Mode" format 
set pagesize 60 linesize 100
select lck.sid, ses.serial#, pro.pid, pro.spid, obj.object_name,
obj.object_id, ses.username, ses.osuser,
lck.type, lck.lmode
from dba_blockers blk, dba_objects obj, v$lock lck,
  v$session ses, v$process pro
where blk.holding_session = ses.sid
and   lck.id1   = obj.object_id
and   lck.sid   = ses.sid
and   ses.paddr = pro.addr
and   ses.username is not NULL
order by obj.object_name, ses.lockwait desc, lck.sid;
spool off
clear columns
/
Regards
Rafiq







Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Date: Fri, 02 Feb 2001 09:16:19 -0800

Steve,

Unfortunately, I can't take out NOWAIT as it is part of the application
design. They don't want the query to hang for some other user to unlock the
record. There are plenty of users accessing the same table and the same row
at the same time. We want the query to return with ORA-54, but at the same
time we would like to know the the user/user details who locked the record
of the table. This is part of the requirement of this application here.

Is there a way to find the details that we need? Please let me know if there
is any solution.

Thanks ... Babu

-Original Message-
Sent: Thursday, February 01, 2001 6:51 PM
To: Multiple recipients of list ORACLE-L


Hi Babu,

Take out the NOWAIT temporarily so that the session will wait, and then look
in
V$LOCK to see which TX lock you are waiting for and who is holding it.

@   Regards,
@   Steve Adams
@   http://www.ixora.com.au/
@   http://www.christianity.net.au/


-Original Message-
Sent: Friday, 2 February 2001 9:50
To: Multiple recipients of list ORACLE-L


Dear list,

I am simulating an error generated by an application.

select * from XXX where fdoc_nbr = '12345'  for update nowait;

It returns with error:
ORA-00054 Resource busy acquire with nowait specified.

I need to findout who(SID,SERIAL#,USERNAME) locked the same ROW (not table).
There are many users who are locking different rows of the same table at the
same time. I need to find the one who locked my row.

I would appreciate if someone could help me with this.

TIA,
-- Babu

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Janardhana Babu
INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing

RE: V$log Status

[Mohammad Rafiq]

Then , definately requires changes in code. Please ask developers/owner of 
application code to inroduce some commit size or if parallel inserts are 
involved then reduce size of parallel degree. If any table is being created 
during batch process then use unrecoverable/nologging clause.
One thing is sure that there are lot of dml generated by batch job.
Regards
Rafiq



Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Date: Fri, 02 Feb 2001 10:39:49 -0800

I tried by increasing the log size to 100M with 10 groups. Still I am facing
the same problem.

-Original Message-
Sent: 02 February 2001 17:11
To: Multiple recipients of list ORACLE-L


Check your alert log messages specially 'check point not completed' or
requires archiving...If yes you have to increase size of your log
files...10MB size looks small...
Regards
Rafiq




Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Date: Fri, 02 Feb 2001 04:25:37 -0800

Hi All,

I am doing a batch update which updates around 100,000 rows. While this
updating is in progress, the system slows down all in a sudden for few
minutes before it continue to work normally.

The archive log is enabled and I have 5 online groups with each 10 MB size.
If I check the V$log while updation in progress, I find the status is in
ACTIVE even after the archive file written for that log. This sequence
continues until all the log files except current one in ACTIVE state. After
couple of minutes all the ACTIVE status getting changed to INACTIVE.

Any Idea what could be the reason for this? I got 8.1.6 undex solaris.

TIA

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

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

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Raj Gopalan
   INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

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

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Index move

[Kevin Kostyszyn]

Thanks for all of the help guys and gals, that made it much easier.
Kevin

-Original Message-
[EMAIL PROTECTED]
Sent: Friday, February 02, 2001 12:51 PM
To: Multiple recipients of list ORACLE-L



How about:

set pages 0
set termout off
set feedback off
spool temp.sql
select 'alter index '||owner||'.'||index_name||' rebuild tablespace '
||tablespace_name||'_idx;'
from dba_indexes
spool off

Ana E. Choto
Systems Programmer
American University
e-Operations
Phone (202) 885-2275
Fax  (202) 885-2224




"Kevin
Kostyszyn"   To: Multiple recipients of list
ORACLE-L <[EMAIL PROTECTED]>
   Subject: Index move
Sent by:
root@fatcity.
com


02/02/01
11:30 AM
Please
respond to
ORACLE-L






Has anyone ever written a script or something that moved indexes to a
different tablespace?  One of our schemas has indexes in the wrong
tablespace and instead of going throught hem one by one I was wondering if
it was possible to move all of them at once?  Any ideas, am I out of my
mind?

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

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).




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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: How to find USER who locked my row ...

[Ferris, Shawn]

You'll need to run catblock.sql, located in $ORACLE_HOME/rdbms/admin. This
will give you the views that you'll want. utllockt.sql will give a "tree
view" of waiters and their blockers too. (catblock.sql required for
utllockt.sql)

HTH
Shawn M Ferris
Oracle DBA - Time Warner Telecom 

> -Original Message-
> From: Janardhana Babu [mailto:[EMAIL PROTECTED]]
> Sent: Friday, February 02, 2001 12:00 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: How to find USER who locked my row ...
> 
> 
> Rafiq,
> 
> I tried to execute the query, It comes out with an error: 
> dba_blockers does
> not exist. I verified in all of my Oracle 8i databases and 
> have not found
> that view anywhere. Has it been removed in 8i? If not, I 
> don't have any clue
> why it is not showing up?
> 
> Thanks...Babu
> 
> -Original Message-
> Sent: Friday, February 02, 2001 9:56 AM
> To: Multiple recipients of list ORACLE-L
> 
> 
> Babu,
> 
> The message you have given pointing that object itself is 
> being used and 
> some application trying to create index on that table or 
> table definition
> itself being changed.
> Try following query which might help:
> 
> spool holding_session.lst
> column object_name justify c heading "Object|Name"  format a32
> column usernamejustify c heading "User|Name"format a7
> column osuser  justify c heading "OS|User"  format a7
> column pid justify c heading "Ora|Proc|ID"  format 999
> column serial# justify c heading "Ora|Serial|#" format 99
> column sid justify c heading "Holding|Session"  format 999
> column spidjustify c heading "Unix|Proc"format a5
> column object_id   justify c heading "Obj|ID"   format 9
> column lockwaitjustify c heading "Lock|Wait"
> column typejustify c heading "Lock|Type"format a4
> column lmode   justify c heading "Mode" format 
> set pagesize 60 linesize 100
> select lck.sid, ses.serial#, pro.pid, pro.spid, obj.object_name,
>obj.object_id, ses.username, ses.osuser,
>lck.type, lck.lmode
> from dba_blockers blk, dba_objects obj, v$lock lck,
>  v$session ses, v$process pro
> where blk.holding_session = ses.sid
> and   lck.id1   = obj.object_id
> and   lck.sid   = ses.sid
> and   ses.paddr = pro.addr
> and   ses.username is not NULL
> order by obj.object_name, ses.lockwait desc, lck.sid;
> spool off
> clear columns
> /
> Regards
> Rafiq
> 
> 
> 
> 
> 
> 
> 
> Reply-To: [EMAIL PROTECTED]
> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> Date: Fri, 02 Feb 2001 09:16:19 -0800
> 
> Steve,
> 
> Unfortunately, I can't take out NOWAIT as it is part of the 
> application
> design. They don't want the query to hang for some other user 
> to unlock the
> record. There are plenty of users accessing the same table 
> and the same row
> at the same time. We want the query to return with ORA-54, 
> but at the same
> time we would like to know the the user/user details who 
> locked the record
> of the table. This is part of the requirement of this 
> application here.
> 
> Is there a way to find the details that we need? Please let 
> me know if there
> is any solution.
> 
> Thanks ... Babu
> 
> -Original Message-
> Sent: Thursday, February 01, 2001 6:51 PM
> To: Multiple recipients of list ORACLE-L
> 
> 
> Hi Babu,
> 
> Take out the NOWAIT temporarily so that the session will 
> wait, and then look
> in
> V$LOCK to see which TX lock you are waiting for and who is holding it.
> 
> @   Regards,
> @   Steve Adams
> @   http://www.ixora.com.au/
> @   http://www.christianity.net.au/
> 
> 
> -Original Message-
> Sent: Friday, 2 February 2001 9:50
> To: Multiple recipients of list ORACLE-L
> 
> 
> Dear list,
> 
> I am simulating an error generated by an application.
> 
> select * from XXX where fdoc_nbr = '12345'  for update nowait;
> 
> It returns with error:
> ORA-00054 Resource busy acquire with nowait specified.
> 
> I need to findout who(SID,SERIAL#,USERNAME) locked the same 
> ROW (not table).
> There are many users who are locking different rows of the 
> same table at the
> same time. I need to find the one who locked my row.
> 
> I would appreciate if someone could help me with this.
> 
> TIA,
> -- Babu
> 
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Steve Adams
>INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> --
> Please see the official ORACLE-L FAQ: http://ww

RE: Pondering Question of the Day-RESPECT

[Cherie_Machler]

Lisa,

What?!!  Are you betting against getting fired or for being fired?

Cherie


Oh well. It's Friday and I have a bet going that I'll be fired by the end of
the day.  If I do get fired today I win $500!  Ha!

Have a great weekend everyone
Lisa



-Original Message-
Sent: Friday, February 02, 2001 1:05 PM
To: Multiple recipients of list ORACLE-L


Pondering Question of the Day-RESPECTcome on! give me an user who prefer we,
developers and dbas working in a decent way, instead of
get its job done "rigth now in this moment" and I'll shave my head and paint
it blue.

developers get crazy trying to solve a problem with users on the other side
of the phone yelling!
and that's first reason of messing everything up.
(ok, don't generalize)
users' bosses want the same.

why can't we talk about the complete organization? and why everybody thinks
developers and dbas as
separate things?
If you can't separate responsabilities and duties, well, it's an
organization problem

try to take an equilibrium and you'll be happy

Gabriel Galanternik

- Original Message -
To: Multiple recipients of list ORACLE-L
Sent: Friday, February 02, 2001 1:10 PM


Lisa,
Rather than talking to the CTO about this go to the Dir, VP, or whatever of
the USERS of the system.  In-fact he/she is the actual OWNER of the data in
the system.  Explain to him/her how dangerous and devious the developers are
to the data.  Talk about corruption, system downtime, partial and incomplete
restores.  Use some technical DBA language to make them understand you have
the knowledge, but make sure you keep the message at a manager level of
understanding.  Get them good and scared.  Then when the developers are
asking for the free ride in production you have an advocate in high postion
that can put the CTO in a position of getting a backbone.  When the COO
starts asking why his people can't work, or why the P/L statement is messed
up the CTO will start scrambling for a lockdown on production and more
comprehensive testing of new or enhanced code.  Remember the politics.  We
in the IT field are not the production organization we are the service
organization.  When it comes to power struggles at the Cxx levels the
production/operations guys always beat the IT/IS guys.  It's a mater of $$$
and performance in front of the CEO.

HTH

Rodd Holman
-Original Message-
Sent: Friday, February 02, 2001 9:20 AM
To: Multiple recipients of list ORACLE-L


"Hello Oracle Guru"
Now why is it that I get more respect on the Internet than I do in my
workplace.  ??
How many of you have this problem?  It's like an ongoing fight with
developers, they want carte blanche in the production database, and they do
whatever they want EVEN THOUGH I tell them NO, let's do something different
that won't affect production.  I go to the CTO because this is like the 3rd
time this has happened, and he sends out a
let's-be-sure-not-to-offend-anyone email.  But the developer(s) will go
ahead and do what they want ANYWAY.  I'm waiting for the first user-mistake
recovery to say STOP, I've had ENOUGH and this is how it's going to be, no
ifs, ands or buts.
My last job may have been a sweatshop, but at least people respected my
authority.  Here, it's a free for all no matter what I do.  Even when I say,
Dude, I own the database.  If there's a problem, I have to fix it.
Therefore I say what happens in production and what doesn' t happen in
production.
And yes, I am looking for another position.  I can only take this
dba/developer/janitor role for so long.
I'M SO GLAD IT'S FRIDAY...  Bring on the Captain Morgan!  It's noon
somewhere...
Lisa Rutland Koivu
Oracle Database Administrator
Qode.com
4850 North State Road 7
Suite G104
Fort Lauderdale, FL  33319
V: 954.484.3191, x174
F: 954.484.2933
C: 954.658.5849
http://www.qode.com
"The information contained herein does not express the opinion or position
of Qode.com and cannot be attributed to or made binding upon Qode.com."

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).


Title: RE: Pondering Question of the Day-RESPECT





Gabriel, I agree.  In the past it hasn't been us vs. them.  It just has gotten worse in the last few months.  Why can't we just all get along?  Sure, it's quiet when I don't insist upon proper procedures.  

I DID change the passwords, this morning, after someone left the company yesterday.  That's what caused th

NLS and ORA-03106: fatal two-task communication protocol error

[Cherie_Machler]

We're getting this ORA-03106 error on 8.1.5 Oracle on Sun Solaris.

I looked it up on Metalink and there is quite a lot of information
there.  I looked at one document in particular and found lots
of causes for ORA-03106.  I'm going through the possibilities
one at a time and am wondering what one of the items means.

In item number 1 below it says to check for NLS incompatibilities.
Nothing real specific.  Do they mean like the values for NLS_LANG
or something like that?  I'm not sure and I don't have anyone to
follow up with.  Anyone have a clue?  Following is the excerpt:

RDBMS - Troubleshooting two-task common errors
==

1. Check for NLS incompatibilities between the client and server.  This is
   a very popular cause of the ORA-03106 error.

2. Check the alert log and RDBMS trace files for any pertinent information /
   errors that coincide with receiving the ORA-03106 error.

3. Try to get a testcase and reproduce the problem in-house.

4. If a testcase is not possible, ask for SQL*Net trace files, SQL traces, and
   try setting event 3106 to obtain the error stack.

5. In extreme circumstances, this could indicate that a shared memory segment
   used by Oracle is corrupted.  You will have to shut down the database,
   possibly using the abort option.  Make sure all semaphores have been
   released by using the IPCS command on Unix.  Oracle uses semaphores to
   control concurrency between all of the background processes (pmon, smon,
   drwr, lgwr, and oracle shadow processes).  Semaphores are also used to
   control Two-Task communication between the user process and the shadow
   process.

6. Try and narrow down the code that may be causing it.  For example it might
   have started to happen after increasing the number of parameters in a PL/SQL
   block or when using certain values for bind variables, etc.

7. If we still do not make headway, file a bug under RDBMS, but we still may
   need some or all of the above information as indicated above.

Thanks,

Cherie Machler
Gelco Information Network


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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: RE: OT NT2K vs Unix.

[Rachel Carmichael]

me either... so many other, more interesting things to do :) (at least, more 
interesting to me..)


>From: [EMAIL PROTECTED]
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: RE: RE: OT  NT2K vs Unix.
>Date: Fri, 02 Feb 2001 08:18:53 -0800
>
>On Thu, 1 Feb 2001, Kevin Kostyszyn wrote:
>
> > What about Mechwarrior or Quake II, can I run that on Unix and will it 
>run
> > smoothly?  This is a fun debate, but I do agree there will never be a
> > winner.
>
>If all gaming software disappeared tomorrow, I would never notice.
>
>Jared
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author:
>   INET: [EMAIL PROTECTED]
>
>Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
>San Diego, California-- Public Internet access / Mailing Lists
>
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from).  You may
>also send the HELP command for other information (like subscribing).

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

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: How to find USER who locked my row ...

[Jacques Kilchoer]

Title: RE: How to find USER who locked my row ...





> -Original Message-
> From: Janardhana Babu [mailto:[EMAIL PROTECTED]]
> Sent: vendredi, 2. février 2001 11:00
> 
> I tried to execute the query, It comes out with an error: 
> dba_blockers does
> not exist. I verified in all of my Oracle 8i databases and 
> have not found
> that view anywhere. Has it been removed in 8i? If not, I 
> don't have any clue
> why it is not showing up?



The view will be created if you run
$ORACLE_HOME/rdbms/admin/catblock.sql


--
any ignorant comments made are the sole responsibility of J. R. Kilchoer and should not reflect adversely upon my employer.

 
Jacques R. Kilchoer
(949) 754-8816
Quest Software, Inc.
8001 Irvine Center Drive
Irvine, California 92618
U.S.A.
http://www.quest.com

Re:RE: Pondering Question of the Day-RESPECT

[dgoulet]

Regina,

Then move into a larger company where all of the errors, mistakes, slowness,
etc... are the databases fault (AKA the DBA).

Dick Goulet

Reply Separator
Author: Regina Harter <[EMAIL PROTECTED]>
Date:   2/2/2001 10:39 AM

You are exactly correct.  I as a developer am usually the first line of 
blame when something doesn't work even when it is because the sys admin 
decided to add a service pack or to tweak some parameters to optimize 
something else, or the network guys decided to improve the firewalls or the 
DBA decided to clean up the database without bothering to find out if those 
tables were actually being used.

We are a pretty small shop compared to most of you guys, nobody is on call, 
and sometimes the DBA is not available or is busy with something else, so I 
need to be able to stop and start the listener, create and move tables, 
recreate indexes, drop and add users and privileges.  On the plus side for 
the DBA, I am responsible for fixing my own mistakes, the most he has to do 
for me is load the backup tape.

At 10:05 AM 2/2/01 -0800, you wrote:
>Pondering Question of the Day-RESPECTcome on! give me an user who prefer we,
>developers and dbas working in a decent way, instead of
>get its job done "rigth now in this moment" and I'll shave my head and paint
>it blue.
>
>developers get crazy trying to solve a problem with users on the other side
>of the phone yelling!
>and that's first reason of messing everything up.
>(ok, don't generalize)
>users' bosses want the same.
>
>why can't we talk about the complete organization? and why everybody thinks
>developers and dbas as
>separate things?
>If you can't separate responsabilities and duties, well, it's an
>organization problem
>
>try to take an equilibrium and you'll be happy
>
>Gabriel Galanternik
>
>- Original Message -
>To: Multiple recipients of list ORACLE-L
>Sent: Friday, February 02, 2001 1:10 PM
>
>
>Lisa,
>Rather than talking to the CTO about this go to the Dir, VP, or whatever of
>the USERS of the system.  In-fact he/she is the actual OWNER of the data in
>the system.  Explain to him/her how dangerous and devious the developers are
>to the data.  Talk about corruption, system downtime, partial and incomplete
>restores.  Use some technical DBA language to make them understand you have
>the knowledge, but make sure you keep the message at a manager level of
>understanding.  Get them good and scared.  Then when the developers are
>asking for the free ride in production you have an advocate in high postion
>that can put the CTO in a position of getting a backbone.  When the COO
>starts asking why his people can't work, or why the P/L statement is messed
>up the CTO will start scrambling for a lockdown on production and more
>comprehensive testing of new or enhanced code.  Remember the politics.  We
>in the IT field are not the production organization we are the service
>organization.  When it comes to power struggles at the Cxx levels the
>production/operations guys always beat the IT/IS guys.  It's a mater of $$$
>and performance in front of the CEO.
>
>HTH
>
>Rodd Holman
>-Original Message-
>Sent: Friday, February 02, 2001 9:20 AM
>To: Multiple recipients of list ORACLE-L
>
>
>"Hello Oracle Guru"
>Now why is it that I get more respect on the Internet than I do in my
>workplace.  ??
>How many of you have this problem?  It's like an ongoing fight with
>developers, they want carte blanche in the production database, and they do
>whatever they want EVEN THOUGH I tell them NO, let's do something different
>that won't affect production.  I go to the CTO because this is like the 3rd
>time this has happened, and he sends out a
>let's-be-sure-not-to-offend-anyone email.  But the developer(s) will go
>ahead and do what they want ANYWAY.  I'm waiting for the first user-mistake
>recovery to say STOP, I've had ENOUGH and this is how it's going to be, no
>ifs, ands or buts.
>My last job may have been a sweatshop, but at least people respected my
>authority.  Here, it's a free for all no matter what I do.  Even when I say,
>Dude, I own the database.  If there's a problem, I have to fix it.
>Therefore I say what happens in production and what doesn' t happen in
>production.
>And yes, I am looking for another position.  I can only take this
>dba/developer/janitor role for so long.
>I'M SO GLAD IT'S FRIDAY...  Bring on the Captain Morgan!  It's noon
>somewhere...
>Lisa Rutland Koivu
>Oracle Database Administrator
>Qode.com
>4850 North State Road 7
>Suite G104
>Fort Lauderdale, FL  33319
>V: 954.484.3191, x174
>F: 954.484.2933
>C: 954.658.5849
>http://www.qode.com
>"The information contained herein does not express the opinion or position
>of Qode.com and cannot be attributed to or made binding upon Qode.com."
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Gabriel Galanternik
>   INET: [EMAIL PROTECTED]
>
>Fat City Network Services-- (858) 538-5051

RE: Pondering Question of the Day-RESPECT

[Koivu, Lisa]

Title: RE: Pondering Question of the Day-RESPECT





Gabriel, I agree.  In the past it hasn't been us vs. them.  It just has gotten worse in the last few months.  Why can't we just all get along?  Sure, it's quiet when I don't insist upon proper procedures.  

I DID change the passwords, this morning, after someone left the company yesterday.  That's what caused this entire rift!

Oh well. It's Friday and I have a bet going that I'll be fired by the end of the day.  If I do get fired today I win $500!  Ha!

Have a great weekend everyone
Lisa




-Original Message-
From: Gabriel Galanternik [mailto:[EMAIL PROTECTED]]
Sent: Friday, February 02, 2001 1:05 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: Pondering Question of the Day-RESPECT



Pondering Question of the Day-RESPECTcome on! give me an user who prefer we,
developers and dbas working in a decent way, instead of
get its job done "rigth now in this moment" and I'll shave my head and paint
it blue.


developers get crazy trying to solve a problem with users on the other side
of the phone yelling!
and that's first reason of messing everything up.
(ok, don't generalize)
users' bosses want the same.


why can't we talk about the complete organization? and why everybody thinks
developers and dbas as
separate things?
If you can't separate responsabilities and duties, well, it's an
organization problem


try to take an equilibrium and you'll be happy


Gabriel Galanternik


- Original Message -
To: Multiple recipients of list ORACLE-L
Sent: Friday, February 02, 2001 1:10 PM



Lisa,
Rather than talking to the CTO about this go to the Dir, VP, or whatever of
the USERS of the system.  In-fact he/she is the actual OWNER of the data in
the system.  Explain to him/her how dangerous and devious the developers are
to the data.  Talk about corruption, system downtime, partial and incomplete
restores.  Use some technical DBA language to make them understand you have
the knowledge, but make sure you keep the message at a manager level of
understanding.  Get them good and scared.  Then when the developers are
asking for the free ride in production you have an advocate in high postion
that can put the CTO in a position of getting a backbone.  When the COO
starts asking why his people can't work, or why the P/L statement is messed
up the CTO will start scrambling for a lockdown on production and more
comprehensive testing of new or enhanced code.  Remember the politics.  We
in the IT field are not the production organization we are the service
organization.  When it comes to power struggles at the Cxx levels the
production/operations guys always beat the IT/IS guys.  It's a mater of $$$
and performance in front of the CEO.


HTH


Rodd Holman
-Original Message-
Sent: Friday, February 02, 2001 9:20 AM
To: Multiple recipients of list ORACLE-L



"Hello Oracle Guru"
Now why is it that I get more respect on the Internet than I do in my
workplace.  ??
How many of you have this problem?  It's like an ongoing fight with
developers, they want carte blanche in the production database, and they do
whatever they want EVEN THOUGH I tell them NO, let's do something different
that won't affect production.  I go to the CTO because this is like the 3rd
time this has happened, and he sends out a
let's-be-sure-not-to-offend-anyone email.  But the developer(s) will go
ahead and do what they want ANYWAY.  I'm waiting for the first user-mistake
recovery to say STOP, I've had ENOUGH and this is how it's going to be, no
ifs, ands or buts.
My last job may have been a sweatshop, but at least people respected my
authority.  Here, it's a free for all no matter what I do.  Even when I say,
Dude, I own the database.  If there's a problem, I have to fix it.
Therefore I say what happens in production and what doesn' t happen in
production.
And yes, I am looking for another position.  I can only take this
dba/developer/janitor role for so long.
I'M SO GLAD IT'S FRIDAY...  Bring on the Captain Morgan!  It's noon
somewhere...
Lisa Rutland Koivu
Oracle Database Administrator
Qode.com
4850 North State Road 7
Suite G104
Fort Lauderdale, FL  33319
V: 954.484.3191, x174
F: 954.484.2933
C: 954.658.5849
http://www.qode.com
"The information contained herein does not express the opinion or position
of Qode.com and cannot be attributed to or made binding upon Qode.com."


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


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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command 

Re: Vague request

[jkstill]

Lee,

Your query is doing a fair amount of disk IO.

I'm suspicious of the RANGE SCAN on the index ADDRESS_OCCUPANCY_I1.

Perhaps providing the SQL for the query, and the definition for
the indexes will give us a better idea of what's going on.

How many rows are in the table, and how many distinct values
are there for the columns making up the ADDRESS_OCCUPANCY_I1 index?

Could be that a hash join between ADDRESS_OCCUPANCY and
ADDRESS would be helpful.

Jared


On Fri, 2 Feb 2001, lerobe - Lee Robertson wrote:

> All,
>
> Oracle 8.0.5.0.0
> Tru64 4.0f
>
> See trace output below
>
> call count   cpuelapsed   disk  querycurrent
> rows
> --- --   -- -- -- --
> --
> Parse0  0.00   0.00  0  0  0
> 0
> Execute   7056  0.59   0.53  0  0  0
> 3
> Fetch 7056  4.61  66.18  16127  84526  0
> 6973
> --- --   -- -- -- --
> --
> total14112  5.20  66.71  16127  84526  0
> 6976
>
> Misses in library cache during parse: 0
> Optimizer goal: CHOOSE
> Parsing user id: 45  (VM_USER)
>
> Rows Execution Plan
> ---  ---
>   0  SELECT STATEMENT   GOAL: CHOOSE
>   0   SORT (ORDER BY)
>   0NESTED LOOPS
>   0 NESTED LOOPS
>   0  TABLE ACCESS (BY INDEX ROWID) OF 'ADDRESS_OCCUPANCY'
>   0   INDEX (RANGE SCAN) OF 'ADDRESS_OCCUPANCY_I1' (NON-UNIQUE)
>
>   0  TABLE ACCESS (BY INDEX ROWID) OF 'ADDRESS'
>   0   INDEX (UNIQUE SCAN) OF 'ADDRESS_PK' (UNIQUE)
>   0 TABLE ACCESS (BY INDEX ROWID) OF 'POSTCODE_MOSAIC'
>   0  INDEX (UNIQUE SCAN) OF 'POSTCODE_PK' (UNIQUE)
>
> Can anyone see what is going wrong here. I haven't a clue yet performance is
> poor.
>
> PS. my tkprof interpretation skills are very much in their infancy.
>
> TIA
>
> Lee Robertson
> Acxiom
> Tel:0191 525 7344
> Fax:0191 525 7007
> Email: [EMAIL PROTECTED]
>
>
>
>
> The information contained in this communication is
> confidential, is intended only for the use of the recipient
> named above, and may be legally privileged. If the reader
> of this message is not the intended recipient, you are
> hereby notified that any dissemination, distribution or
> copying of this communication is strictly prohibited.
> If you have received this communication in error, please
> re-send this communication to the sender and delete the
> original message or any copy of it from your computer
> system.
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: lerobe - Lee Robertson
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
>

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: How to find USER who locked my row ...

[Janardhana Babu]

Rafiq,

I tried to execute the query, It comes out with an error: dba_blockers does
not exist. I verified in all of my Oracle 8i databases and have not found
that view anywhere. Has it been removed in 8i? If not, I don't have any clue
why it is not showing up?

Thanks...Babu

-Original Message-
Sent: Friday, February 02, 2001 9:56 AM
To: Multiple recipients of list ORACLE-L


Babu,

The message you have given pointing that object itself is being used and 
some application trying to create index on that table or table definition
itself being changed.
Try following query which might help:

spool holding_session.lst
column object_name justify c heading "Object|Name"  format a32
column usernamejustify c heading "User|Name"format a7
column osuser  justify c heading "OS|User"  format a7
column pid justify c heading "Ora|Proc|ID"  format 999
column serial# justify c heading "Ora|Serial|#" format 99
column sid justify c heading "Holding|Session"  format 999
column spidjustify c heading "Unix|Proc"format a5
column object_id   justify c heading "Obj|ID"   format 9
column lockwaitjustify c heading "Lock|Wait"
column typejustify c heading "Lock|Type"format a4
column lmode   justify c heading "Mode" format 
set pagesize 60 linesize 100
select lck.sid, ses.serial#, pro.pid, pro.spid, obj.object_name,
   obj.object_id, ses.username, ses.osuser,
   lck.type, lck.lmode
from dba_blockers blk, dba_objects obj, v$lock lck,
 v$session ses, v$process pro
where blk.holding_session = ses.sid
and   lck.id1   = obj.object_id
and   lck.sid   = ses.sid
and   ses.paddr = pro.addr
and   ses.username is not NULL
order by obj.object_name, ses.lockwait desc, lck.sid;
spool off
clear columns
/
Regards
Rafiq







Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Date: Fri, 02 Feb 2001 09:16:19 -0800

Steve,

Unfortunately, I can't take out NOWAIT as it is part of the application
design. They don't want the query to hang for some other user to unlock the
record. There are plenty of users accessing the same table and the same row
at the same time. We want the query to return with ORA-54, but at the same
time we would like to know the the user/user details who locked the record
of the table. This is part of the requirement of this application here.

Is there a way to find the details that we need? Please let me know if there
is any solution.

Thanks ... Babu

-Original Message-
Sent: Thursday, February 01, 2001 6:51 PM
To: Multiple recipients of list ORACLE-L


Hi Babu,

Take out the NOWAIT temporarily so that the session will wait, and then look
in
V$LOCK to see which TX lock you are waiting for and who is holding it.

@   Regards,
@   Steve Adams
@   http://www.ixora.com.au/
@   http://www.christianity.net.au/


-Original Message-
Sent: Friday, 2 February 2001 9:50
To: Multiple recipients of list ORACLE-L


Dear list,

I am simulating an error generated by an application.

select * from XXX where fdoc_nbr = '12345'  for update nowait;

It returns with error:
ORA-00054 Resource busy acquire with nowait specified.

I need to findout who(SID,SERIAL#,USERNAME) locked the same ROW (not table).
There are many users who are locking different rows of the same table at the
same time. I need to find the one who locked my row.

I would appreciate if someone could help me with this.

TIA,
-- Babu

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Janardhana Babu
   INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

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

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Moha

RE: Async I/O on Windows

[Mohan, Ross]

Title: RE: Async I/O on Windows





Oracle on NT runs as


ONE PROCESS 


with 


MULTIPLE THREADS



for performance reasons (no more
need for shared memorycontext switches
are a LOT less expensive, etc.) 



-Original Message-
From: yong huang [mailto:[EMAIL PROTECTED]]
Sent: Friday, February 02, 2001 12:51 PM
To: Multiple recipients of list ORACLE-L
Subject: Async I/O on Windows



Hi, Mark,


Async I/O is available on Windows, at least NT. It's not an easy topic. If you
think you already know enough about operating systems in general, I suggest you
read David Solomon's "Inside WindowsNT". For a lab test, launch Performance
Monitor on your NT box and look at the counters for Cache.


I'm not sure by "single thread management" whether you mean NT can't have
multiple processes or Oracle on NT runs as one thread. The former is obviously
wrong. The latter is a design issue inside Oracle Corporation and the question
as to why was asked on this forum before without an answer (without an answer I
can remember, that is).


Yong Huang
[EMAIL PROTECTED]


you wrote:


Asynch I/O on a Windowze box? supresses a snigger...


To the best of my knowledge there are no Windows based system that can take
advantage of this, single thread management can be enough a problem
sometimes..


But, I may be wrong.. List?


__
Get personalized email addresses from Yahoo! Mail - only $35 
a year!  http://personal.mail.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: yong huang
  INET: [EMAIL PROTECTED]


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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Anyone out there could tell me the websites

[Tan Ngo]

--_=_NextPart_001_01C08D47.4107D280
Content-Type: text/plain;
charset="ISO-8859-1"

where I may find a list of all Oracle events such as conferences etc..

Or if you guys know any Oracle event will take place in the Sna Francisco
area this year.

Thanks

Tan Ngo
Global Database Services - Ottawa
Tel: (613)763-8575
Fax: (613)765-8174
ESN: 393-8575
[EMAIL PROTECTED]


--_=_NextPart_001_01C08D47.4107D280
Content-Type: text/html;
charset="ISO-8859-1"






Anyone out there could tell me the websites



where I may find a list of all Oracle events such as 
conferences etc..


Or if you guys know any Oracle event will take place in 
the Sna Francisco area this year.


Thanks


Tan Ngo
Global Database Services - 
Ottawa
Tel: (613)763-8575
Fax: (613)765-8174
ESN: 393-8575
[EMAIL PROTECTED]




--_=_NextPart_001_01C08D47.4107D280--
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Tan Ngo
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: OT- Oracle Training

[Nikolay Kumanov]

After many years of working for the financial sector, please don't be too
angry at me for stating my opinion in financial terms:

There is a company A that has some software that it wants to promote.
Therefore, company A considers education and information as a "cost center".
Company A makes (almost) all tech info freely available over Internet.
Everyone is welcome to read and learn. Many young people, especially from
low-income countries (as my country) read, get some skills, get a job in a
higher-developed country and promote the products of company A.

Company B wants to make more money than A. Therefore it makes training and
education a "profit center". It makes it's source of technical info "MetaB"
available only to contract-holders with deep pockets. Most of the seasoned
professionals agree that "B" software is better than "A".  But many young
and bright people find that it's easier and cheaper for them to learn the
(inferior) products of company "A". 

Now the rich investor comes. (S)he knows that B products are technically
superior, but on the market there is A experience, free A support, free A
source of information. Therefore the deep pocketed guy(gal) goes for A.

IMHO, probably company B has better technology, but A has better marketing
strategy and market development. And I am very sad to see lesser
technologies come to prosperity. I hope that some wise guy at B would say
"OK folks, we are opening all the info we have, we want all the young and
bright people to have the possibility to study our technology, even if they
have not the means to pay for the information. We are providing an
affordable way for youngsters to become a B professionals". Could it be a
wise (and profitable) investment



Dr. Nikolay Kumanov

MIS Manager, Zeitungsgruppe Bulgarien GmbH
47, Tsarigradsko chaussee, Sofia 1504, Bulgaria
phone: +(359-2)4339-643, fax: +(359-2)946-1286
mailto:[EMAIL PROTECTED]

"Show me a completely smooth operation and I'll show you someone who's
covering mistakes. Real boats rock." - Frank Herbert, "Chapterhouse: Dune"
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Nikolay Kumanov
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Pondering Question of the Day-RESPECT

[Regina Harter]

You are exactly correct.  I as a developer am usually the first line of 
blame when something doesn't work even when it is because the sys admin 
decided to add a service pack or to tweak some parameters to optimize 
something else, or the network guys decided to improve the firewalls or the 
DBA decided to clean up the database without bothering to find out if those 
tables were actually being used.

We are a pretty small shop compared to most of you guys, nobody is on call, 
and sometimes the DBA is not available or is busy with something else, so I 
need to be able to stop and start the listener, create and move tables, 
recreate indexes, drop and add users and privileges.  On the plus side for 
the DBA, I am responsible for fixing my own mistakes, the most he has to do 
for me is load the backup tape.

At 10:05 AM 2/2/01 -0800, you wrote:
>Pondering Question of the Day-RESPECTcome on! give me an user who prefer we,
>developers and dbas working in a decent way, instead of
>get its job done "rigth now in this moment" and I'll shave my head and paint
>it blue.
>
>developers get crazy trying to solve a problem with users on the other side
>of the phone yelling!
>and that's first reason of messing everything up.
>(ok, don't generalize)
>users' bosses want the same.
>
>why can't we talk about the complete organization? and why everybody thinks
>developers and dbas as
>separate things?
>If you can't separate responsabilities and duties, well, it's an
>organization problem
>
>try to take an equilibrium and you'll be happy
>
>Gabriel Galanternik
>
>- Original Message -
>To: Multiple recipients of list ORACLE-L
>Sent: Friday, February 02, 2001 1:10 PM
>
>
>Lisa,
>Rather than talking to the CTO about this go to the Dir, VP, or whatever of
>the USERS of the system.  In-fact he/she is the actual OWNER of the data in
>the system.  Explain to him/her how dangerous and devious the developers are
>to the data.  Talk about corruption, system downtime, partial and incomplete
>restores.  Use some technical DBA language to make them understand you have
>the knowledge, but make sure you keep the message at a manager level of
>understanding.  Get them good and scared.  Then when the developers are
>asking for the free ride in production you have an advocate in high postion
>that can put the CTO in a position of getting a backbone.  When the COO
>starts asking why his people can't work, or why the P/L statement is messed
>up the CTO will start scrambling for a lockdown on production and more
>comprehensive testing of new or enhanced code.  Remember the politics.  We
>in the IT field are not the production organization we are the service
>organization.  When it comes to power struggles at the Cxx levels the
>production/operations guys always beat the IT/IS guys.  It's a mater of $$$
>and performance in front of the CEO.
>
>HTH
>
>Rodd Holman
>-Original Message-
>Sent: Friday, February 02, 2001 9:20 AM
>To: Multiple recipients of list ORACLE-L
>
>
>"Hello Oracle Guru"
>Now why is it that I get more respect on the Internet than I do in my
>workplace.  ??
>How many of you have this problem?  It's like an ongoing fight with
>developers, they want carte blanche in the production database, and they do
>whatever they want EVEN THOUGH I tell them NO, let's do something different
>that won't affect production.  I go to the CTO because this is like the 3rd
>time this has happened, and he sends out a
>let's-be-sure-not-to-offend-anyone email.  But the developer(s) will go
>ahead and do what they want ANYWAY.  I'm waiting for the first user-mistake
>recovery to say STOP, I've had ENOUGH and this is how it's going to be, no
>ifs, ands or buts.
>My last job may have been a sweatshop, but at least people respected my
>authority.  Here, it's a free for all no matter what I do.  Even when I say,
>Dude, I own the database.  If there's a problem, I have to fix it.
>Therefore I say what happens in production and what doesn' t happen in
>production.
>And yes, I am looking for another position.  I can only take this
>dba/developer/janitor role for so long.
>I'M SO GLAD IT'S FRIDAY...  Bring on the Captain Morgan!  It's noon
>somewhere...
>Lisa Rutland Koivu
>Oracle Database Administrator
>Qode.com
>4850 North State Road 7
>Suite G104
>Fort Lauderdale, FL  33319
>V: 954.484.3191, x174
>F: 954.484.2933
>C: 954.658.5849
>http://www.qode.com
>"The information contained herein does not express the opinion or position
>of Qode.com and cannot be attributed to or made binding upon Qode.com."
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Gabriel Galanternik
>   INET: [EMAIL PROTECTED]
>
>Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
>San Diego, California-- Public Internet access / Mailing Lists
>
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: [EMAIL PROTECTED] (note EXACT spelling of '

RE: V$log Status

[Raj Gopalan]

I tried by increasing the log size to 100M with 10 groups. Still I am facing
the same problem.

-Original Message-
Sent: 02 February 2001 17:11
To: Multiple recipients of list ORACLE-L


Check your alert log messages specially 'check point not completed' or 
requires archiving...If yes you have to increase size of your log 
files...10MB size looks small...
Regards
Rafiq




Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Date: Fri, 02 Feb 2001 04:25:37 -0800

Hi All,

I am doing a batch update which updates around 100,000 rows. While this
updating is in progress, the system slows down all in a sudden for few
minutes before it continue to work normally.

The archive log is enabled and I have 5 online groups with each 10 MB size.
If I check the V$log while updation in progress, I find the status is in
ACTIVE even after the archive file written for that log. This sequence
continues until all the log files except current one in ACTIVE state. After
couple of minutes all the ACTIVE status getting changed to INACTIVE.

Any Idea what could be the reason for this? I got 8.1.6 undex solaris.

TIA

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

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

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Raj Gopalan
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Async I/O on Windows

[yong huang]

Hi, Mark,

Async I/O is available on Windows, at least NT. It's not an easy topic. If you
think you already know enough about operating systems in general, I suggest you
read David Solomon's "Inside WindowsNT". For a lab test, launch Performance
Monitor on your NT box and look at the counters for Cache.

I'm not sure by "single thread management" whether you mean NT can't have
multiple processes or Oracle on NT runs as one thread. The former is obviously
wrong. The latter is a design issue inside Oracle Corporation and the question
as to why was asked on this forum before without an answer (without an answer I
can remember, that is).

Yong Huang
[EMAIL PROTECTED]

you wrote:

Asynch I/O on a Windowze box? supresses a snigger...

To the best of my knowledge there are no Windows based system that can take
advantage of this, single thread management can be enough a problem
sometimes..

But, I may be wrong.. List?

__
Get personalized email addresses from Yahoo! Mail - only $35 
a year!  http://personal.mail.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: yong huang
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Patchset 1 for Dev6i for Linux

[Juan Marra]

Hi all,
 
I´m have some problems with patchset 1 for Dev6i 
for Linux ( RedHat 7 or SuSe 7), when I try to install 
the patch I have the following error:
 

/u01/oracle/product/8.0.5/lib//libplsf.a(spssimb.o): In function 
`pss_gets':spssimb.o(.text+0x2e3): the `gets' function is dangerous and 
should not be used./u01/oracle/product/8.0.5/lib//libgeneric.a(skgfr.o): In 
function `skgfrcre':skgfr.o(.text+0x58e): the `llseek' function may be 
dangerous; use `lseek64' 
instead./u01/oracle/product/8.0.5/lib//libplsf.a(spssimb.o): In function 
`pss_gets':spssimb.o(.text+0x2e3): the `gets' function is dangerous and 
should not be used./u01/oracle/product/8.0.5/lib//libgeneric.a(skgfr.o): In 
function `skgfrcre':skgfr.o(.text+0x58e): the `llseek' function may be 
dangerous; use `lseek64' instead
...
...
 
I haven´t problems with Solaris 2.6 
.
 

Regards,
 
JUAN

Re: Index move

[achoto]

How about:

set pages 0
set termout off
set feedback off
spool temp.sql
select 'alter index '||owner||'.'||index_name||' rebuild tablespace '
||tablespace_name||'_idx;'
from dba_indexes
spool off

Ana E. Choto
Systems Programmer
American University
e-Operations
Phone (202) 885-2275
Fax  (202) 885-2224



   

"Kevin 

Kostyszyn"   To: Multiple recipients of list ORACLE-L 
<[EMAIL PROTECTED]>   
   Subject: Index move   

Sent by:   

root@fatcity.  

com

   

   

02/02/01   

11:30 AM   

Please 

respond to 

ORACLE-L   

   

   





Has anyone ever written a script or something that moved indexes to a
different tablespace?  One of our schemas has indexes in the wrong
tablespace and instead of going throught hem one by one I was wondering if
it was possible to move all of them at once?  Any ideas, am I out of my
mind?

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

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).




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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Pondering Question of the Day-RESPECT

[Gabriel Galanternik]

Pondering Question of the Day-RESPECTcome on! give me an user who prefer we,
developers and dbas working in a decent way, instead of
get its job done "rigth now in this moment" and I'll shave my head and paint
it blue.

developers get crazy trying to solve a problem with users on the other side
of the phone yelling!
and that's first reason of messing everything up.
(ok, don't generalize)
users' bosses want the same.

why can't we talk about the complete organization? and why everybody thinks
developers and dbas as
separate things?
If you can't separate responsabilities and duties, well, it's an
organization problem

try to take an equilibrium and you'll be happy

Gabriel Galanternik

- Original Message -
To: Multiple recipients of list ORACLE-L
Sent: Friday, February 02, 2001 1:10 PM


Lisa,
Rather than talking to the CTO about this go to the Dir, VP, or whatever of
the USERS of the system.  In-fact he/she is the actual OWNER of the data in
the system.  Explain to him/her how dangerous and devious the developers are
to the data.  Talk about corruption, system downtime, partial and incomplete
restores.  Use some technical DBA language to make them understand you have
the knowledge, but make sure you keep the message at a manager level of
understanding.  Get them good and scared.  Then when the developers are
asking for the free ride in production you have an advocate in high postion
that can put the CTO in a position of getting a backbone.  When the COO
starts asking why his people can't work, or why the P/L statement is messed
up the CTO will start scrambling for a lockdown on production and more
comprehensive testing of new or enhanced code.  Remember the politics.  We
in the IT field are not the production organization we are the service
organization.  When it comes to power struggles at the Cxx levels the
production/operations guys always beat the IT/IS guys.  It's a mater of $$$
and performance in front of the CEO.

HTH

Rodd Holman
-Original Message-
Sent: Friday, February 02, 2001 9:20 AM
To: Multiple recipients of list ORACLE-L


"Hello Oracle Guru"
Now why is it that I get more respect on the Internet than I do in my
workplace.  ??
How many of you have this problem?  It's like an ongoing fight with
developers, they want carte blanche in the production database, and they do
whatever they want EVEN THOUGH I tell them NO, let's do something different
that won't affect production.  I go to the CTO because this is like the 3rd
time this has happened, and he sends out a
let's-be-sure-not-to-offend-anyone email.  But the developer(s) will go
ahead and do what they want ANYWAY.  I'm waiting for the first user-mistake
recovery to say STOP, I've had ENOUGH and this is how it's going to be, no
ifs, ands or buts.
My last job may have been a sweatshop, but at least people respected my
authority.  Here, it's a free for all no matter what I do.  Even when I say,
Dude, I own the database.  If there's a problem, I have to fix it.
Therefore I say what happens in production and what doesn' t happen in
production.
And yes, I am looking for another position.  I can only take this
dba/developer/janitor role for so long.
I'M SO GLAD IT'S FRIDAY...  Bring on the Captain Morgan!  It's noon
somewhere...
Lisa Rutland Koivu
Oracle Database Administrator
Qode.com
4850 North State Road 7
Suite G104
Fort Lauderdale, FL  33319
V: 954.484.3191, x174
F: 954.484.2933
C: 954.658.5849
http://www.qode.com
"The information contained herein does not express the opinion or position
of Qode.com and cannot be attributed to or made binding upon Qode.com."

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

PROCESSES parameter

[Djordje Jankovic]

Friends,

Anybody knows for sure what the relation between PROCESSES and SESSIONS
parameters (I am not talking of the SESSIONS=1.1*PROCESSES+5), and the
counts from v$process and v$session views are ?

I guess that once the number of processes in v$processes reaches PROCESSES
parameter value, new sessions are not allowed any more, but I am not sure.  

Docs says that PROCESSES is the "maximum number of operating system user
processes that can simultaneously connect to an oracle server".  Neither
v$session nor v$process count only the "user processes": v$session has
background atop, and v$process have the parallel processes as well.  On the
other hand "operating system processes" more relate to v$process, as this is
where you have OS process ID.

Any thoughts ?

Djordje

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: How to find USER who locked my row ...

[Mohammad Rafiq]

Babu,

The message you have given pointing that object itself is being used and 
some application trying to create index on that table or table definition
itself being changed.
Try following query which might help:

spool holding_session.lst
column object_name justify c heading "Object|Name"  format a32
column usernamejustify c heading "User|Name"format a7
column osuser  justify c heading "OS|User"  format a7
column pid justify c heading "Ora|Proc|ID"  format 999
column serial# justify c heading "Ora|Serial|#" format 99
column sid justify c heading "Holding|Session"  format 999
column spidjustify c heading "Unix|Proc"format a5
column object_id   justify c heading "Obj|ID"   format 9
column lockwaitjustify c heading "Lock|Wait"
column typejustify c heading "Lock|Type"format a4
column lmode   justify c heading "Mode" format 
set pagesize 60 linesize 100
select lck.sid, ses.serial#, pro.pid, pro.spid, obj.object_name,
   obj.object_id, ses.username, ses.osuser,
   lck.type, lck.lmode
from dba_blockers blk, dba_objects obj, v$lock lck,
 v$session ses, v$process pro
where blk.holding_session = ses.sid
and   lck.id1   = obj.object_id
and   lck.sid   = ses.sid
and   ses.paddr = pro.addr
and   ses.username is not NULL
order by obj.object_name, ses.lockwait desc, lck.sid;
spool off
clear columns
/
Regards
Rafiq







Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Date: Fri, 02 Feb 2001 09:16:19 -0800

Steve,

Unfortunately, I can't take out NOWAIT as it is part of the application
design. They don't want the query to hang for some other user to unlock the
record. There are plenty of users accessing the same table and the same row
at the same time. We want the query to return with ORA-54, but at the same
time we would like to know the the user/user details who locked the record
of the table. This is part of the requirement of this application here.

Is there a way to find the details that we need? Please let me know if there
is any solution.

Thanks ... Babu

-Original Message-
Sent: Thursday, February 01, 2001 6:51 PM
To: Multiple recipients of list ORACLE-L


Hi Babu,

Take out the NOWAIT temporarily so that the session will wait, and then look
in
V$LOCK to see which TX lock you are waiting for and who is holding it.

@   Regards,
@   Steve Adams
@   http://www.ixora.com.au/
@   http://www.christianity.net.au/


-Original Message-
Sent: Friday, 2 February 2001 9:50
To: Multiple recipients of list ORACLE-L


Dear list,

I am simulating an error generated by an application.

select * from XXX where fdoc_nbr = '12345'  for update nowait;

It returns with error:
ORA-00054 Resource busy acquire with nowait specified.

I need to findout who(SID,SERIAL#,USERNAME) locked the same ROW (not table).
There are many users who are locking different rows of the same table at the
same time. I need to find the one who locked my row.

I would appreciate if someone could help me with this.

TIA,
-- Babu

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Janardhana Babu
   INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

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

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the messag

locking issue. Please help

[sonia pajerowski]

I have a trigger on a table which deletes data on a
similar table on a remote database. When the delete
operation is performed whole database gets locked and
nothing can be done unless both the local and remote
databases are shutdown. The table also has insert and
update triggers which perform same operation on the
remote db but they seem to work fine.



set linesize 80
 set pagesize 66 
column lmode heading 'Lock|Held' format a4 
column request heading 'Lock|Req.' format a4 
column username format a10 heading "Username" 
column tab format a30 heading "Table Name" 
column LAddr heading "ID1 - ID2" format a16 
column Lockt heading "Lock|Type" format a4 
select nvl(S.USERNAME,'Internal') username, 
decode(command,
0,'None',decode(l.id2,0,U1.NAME||'.'||substr(T1.NAME,1,20),
'Rollback Segment')) tab, 
decode(L.LMODE,1,'NoLk', 2,' RS ', 3,' RX ', 4,' S ',
5,' SRX', 6,' X ','NONE') lmode, 
decode(L.REQUEST,1,'NoLk', 2,' RSh ', 3,' RX ', 4,' S
', 5,' SRX', 6,' X ','NONE') request,
 l.id1||'-'||l.id2 Laddr, l.type Lockt from V$LOCK L,
V$SESSION S, SYS.USER$ U1, SYS.OBJ$ T1 
where L.SID = S.SID and T1.OBJ# =
decode(L.ID2,0,L.ID1,1) and U1.USER# = T1.OWNER# and 
S.TYPE != 'BACKGROUND' order by 1,2,5 
/

 Lock Lock
 Lock
Username   Table Name Held Req.
ID1 - ID2Type
-- --  
 
SMSWEB Rollback SegmentX   NONE
131089-324   TX
SMSWEB SMSWEB.EVENTTIMES   RX  NONE
3846-0   TM
SMSWEB SYS.UNDO$  NoLk NONE
15-0 DX

I also ran this statement and got the following.

elect * from v$lock where type='TX' and lmode>0 ;
ADDR KADDR SID TYPE ID1ID2
  Held   Req.
   - -- --
-- --
 CTIME  BLOCK
-- --
016E2154 016E2228   12 TX131089324
## ##
   653  0 




Thanks 

Sonia P.


__
Get personalized email addresses from Yahoo! Mail - only $35 
a year!  http://personal.mail.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: sonia pajerowski
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: Index move

[Mohammad Rafiq]

Try this. After having spool file , just change tablespace name from x to y.

set echo off linesize 199 pagesize  head off feedback off verify off
spool alter_index_rebuild_&&1

select 'connect system/password' from dual;
select 'alter tablespace &&1 coalesce;' from dual;
select 'connect &&2/&&2' from dual;
select 'set echo on time on timing on' from dual;
select 'spool run_alter_index_rebuild_&&1' from dual;

select 'alter index ' || ind.owner || '.' || ind.index_name ||
   ' rebuild unrecoverable tablespace &&1;'
from dba_indexes ind, dba_segments seg
where ind.index_name = seg.segment_name
and   ind.owner not in ('SYS', 'SYSTEM')
and   ind.tablespace_name = upper ('&&1')
order by ind.owner,seg.bytes asc;

select 'exit' from dual;

undefine 1 2
exit



Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Date: Fri, 02 Feb 2001 08:30:24 -0800

Has anyone ever written a script or something that moved indexes to a
different tablespace?  One of our schemas has indexes in the wrong
tablespace and instead of going throught hem one by one I was wondering if
it was possible to move all of them at once?  Any ideas, am I out of my
mind?

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

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

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

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: Pondering Question of the Day-RESPECT

[Rachel Carmichael]

have you considered changing the production passwords? They can't break what 
they can't access!

Set up another schema that actually OWNS the objects, then grant select etc 
as necessary, create synonyms etc etc...

And whatever you do document what's going on. When the db crashes you 
want to be able to show exactly why and who

Enjoy the drink!

Rachel


>From: "Koivu, Lisa" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: Pondering Question of the Day-RESPECT
>Date: Fri, 02 Feb 2001 07:20:24 -0800
>
>"Hello Oracle Guru"
>
>Now why is it that I get more respect on the Internet than I do in my
>workplace.  ??
>
>How many of you have this problem?  It's like an ongoing fight with
>developers, they want carte blanche in the production database, and they do
>whatever they want EVEN THOUGH I tell them NO, let's do something different
>that won't affect production.  I go to the CTO because this is like the 3rd
>time this has happened, and he sends out a
>let's-be-sure-not-to-offend-anyone email.  But the developer(s) will go
>ahead and do what they want ANYWAY.  I'm waiting for the first user-mistake
>recovery to say STOP, I've had ENOUGH and this is how it's going to be, no
>ifs, ands or buts.
>
>My last job may have been a sweatshop, but at least people respected my
>authority.  Here, it's a free for all no matter what I do.  Even when I 
>say,
>Dude, I own the database.  If there's a problem, I have to fix it.
>Therefore I say what happens in production and what doesn' t happen in
>production.
>
>And yes, I am looking for another position.  I can only take this
>dba/developer/janitor role for so long.
>
>I'M SO GLAD IT'S FRIDAY...  Bring on the Captain Morgan!  It's noon
>somewhere...
>
>Lisa Rutland Koivu
>Oracle Database Administrator
>Qode.com
>4850 North State Road 7
>Suite G104
>Fort Lauderdale, FL  33319
>
>V: 954.484.3191, x174
>F: 954.484.2933
>C: 954.658.5849
>http://www.qode.com
>
>"The information contained herein does not express the opinion or position
>of Qode.com and cannot be attributed to or made binding upon Qode.com."
>

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

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Pondering Question of the Day-RESPECT

[Rachel Carmichael]

Kimberly,

I could say the same thing of course, the other part is that I convinced 
the programmers here that I knew what I was doing by letting them have their 
way in development and watching it die... then converting it to what I 
wanted to do and watching it fly. Now they ask my opinion before they do 
anything.

Rachel


>From: Kimberly Smith <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: RE: Pondering Question of the Day-RESPECT
>Date: Fri, 02 Feb 2001 08:11:03 -0800
>
>I have had that same issue in the past but I don't have it here.  I find
>that
>as long as you have your managements support and the development team
>knows that then life will be much easier.  I am very lucky here in that I
>have good management and a very well trained senior development team
>to work with.  Not that there are never disagreements but comprise is the
>name of the game.  You just got to be picky on what you let them think you
>are
>compromising on:-)  I always have more issues with junior/intermediate
>developers.
>
>-Original Message-
>Sent: Friday, February 02, 2001 7:20 AM
>To: Multiple recipients of list ORACLE-L
>
>
>
>"Hello Oracle Guru"
>
>Now why is it that I get more respect on the Internet than I do in my
>workplace.  ??
>
>How many of you have this problem?  It's like an ongoing fight with
>developers, they want carte blanche in the production database, and they do
>whatever they want EVEN THOUGH I tell them NO, let's do something different
>that won't affect production.  I go to the CTO because this is like the 3rd
>time this has happened, and he sends out a
>let's-be-sure-not-to-offend-anyone email.  But the developer(s) will go
>ahead and do what they want ANYWAY.  I'm waiting for the first user-mistake
>recovery to say STOP, I've had ENOUGH and this is how it's going to be, no
>ifs, ands or buts.
>
>My last job may have been a sweatshop, but at least people respected my
>authority.  Here, it's a free for all no matter what I do.  Even when I 
>say,
>Dude, I own the database.  If there's a problem, I have to fix it.
>Therefore I say what happens in production and what doesn' t happen in
>production.
>
>And yes, I am looking for another position.  I can only take this
>dba/developer/janitor role for so long.
>
>I'M SO GLAD IT'S FRIDAY...  Bring on the Captain Morgan!  It's noon
>somewhere...
>
>Lisa Rutland Koivu
>Oracle Database Administrator
>Qode.com
>4850 North State Road 7
>Suite G104
>Fort Lauderdale, FL  33319
>
>V: 954.484.3191, x174
>F: 954.484.2933
>C: 954.658.5849
>http://www.qode.com 
>
>"The information contained herein does not express the opinion or position
>of Qode.com and cannot be attributed to or made binding upon Qode.com."
>

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

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: V$log Status

[Mohammad Rafiq]

Check your alert log messages specially 'check point not completed' or 
requires archiving...If yes you have to increase size of your log 
files...10MB size looks small...
Regards
Rafiq




Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Date: Fri, 02 Feb 2001 04:25:37 -0800

Hi All,

I am doing a batch update which updates around 100,000 rows. While this
updating is in progress, the system slows down all in a sudden for few
minutes before it continue to work normally.

The archive log is enabled and I have 5 online groups with each 10 MB size.
If I check the V$log while updation in progress, I find the status is in
ACTIVE even after the archive file written for that log. This sequence
continues until all the log files except current one in ACTIVE state. After
couple of minutes all the ACTIVE status getting changed to INACTIVE.

Any Idea what could be the reason for this? I got 8.1.6 undex solaris.

TIA

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

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

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: temp tablespace

[Mohammad Rafiq]

Alex,
Yes you are right if temp tablespace is 'TEMPORARY'. The situation he has
described is pointing that temp tablespace is 'PERMANENT' and thats why
his extents were not released/coalesced.

Besides , with temp TEMPORARY tablespace , there are problems that space is 
not completely released even after bouncing database and you have to
offline and online temp tablespace to get release used space upto 99%.
I am talking about 7GB+ tempspace on 7.3.4.4(1999) NCR UNIX 3.02 and that 
was my personal experience at that time.

Regards
Rafiq



Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Date: Thu, 01 Feb 2001 14:12:31 -0800

I disagree. pctincrease should be 0, you do not need to coalesce tablespace
if it is temporary. Segments in temporary tablespace are not dropped after
SQL statement execution ends. But if you want to drop all segments from
temporary tablespace the easiest way is:

alter tablespace  pctincrease 

Alex Hillman

-Original Message-
Sent: Thursday, February 01, 2001 2:12 PM
To: Multiple recipients of list ORACLE-L


To resolve it now:
alter tablespace temp coalesce;

for all the time set pctincrease to 1 (if 0) of temp tablespace

alter tablespace temp default storage(pctincrease 1);

Regards
Rafiq


Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Date: Thu, 01 Feb 2001 08:07:48 -0800

Hi.

I have my daily routine to check segmetn whose next extent will not fit in
the single largest free extent in the tablespace.
This morning I found the my temporary tablespace is on the list .

We have 1624M assigned for the temp tablespace. As my understatd temp
tablespace will extend itself as necessary and drop itself when operation is
done.

I just wonder I should increase the size or wait to see  because we just
have our application updated.


Mitchell


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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

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

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

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

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: COPY command dieing - help

[Tim Sawmiller]

Did you try leaving off the semi colon?  Like this, for instance:

copy from v55/v55@int to user/pwd@frog create DMF -
using select * from DMF@int
/

Notice that if you have several lines, you need to put a space and hyphen
after each line except the last one.  At least, that has been my experience.



>>> [EMAIL PROTECTED] 02/02/01 11:00AM >>>
On Thu, 1 Feb 2001, Shaw, John B wrote:

> I am attempting to copy a table from a 8.1.6 db to 8.1.7. Most of the tables
> have come across successfully. One table is having a problem.
> The command:
> copy from v55/v55@int to user/pwd@frog create DMF using select * from
> DMF@int;
> This table gives ora-00911 error (invalid character ? where? - this same
> command worked on many other tables).
> I manually created the table in the local db and tried to do an append of
> the data
> copy from v55/v55@int to user/pwd@frog append DMF using select * from
> DMF@int;
>
> This causes sqlplus and sqlworksheet to die (this is on NT0
> anybody have an idea of what's going on?


Maybe a silly question, but do the databases use the same character set?

Jared


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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Index move

[Guidry, Chris]

What about spooling the following output to a file and running it?

SELECT 'ALTER INDEX '||index_name||' REBUILD TABLESPACE '
FROM dba_indexes
WHERE tablespace_name=''

--
Chris J. Guidry  P.Eng.
ATCO Electric, Metering Services
Phone: (780) 420-4142
Fax: (780) 420-3854
Email: [EMAIL PROTECTED]

> -Original Message-
> From: Kevin Kostyszyn [SMTP:[EMAIL PROTECTED]]
> Sent: Friday, February 02, 2001 09:30 AM
> To:   Multiple recipients of list ORACLE-L
> Subject:  Index move
> 
> Has anyone ever written a script or something that moved indexes to a
> different tablespace?  One of our schemas has indexes in the wrong
> tablespace and instead of going throught hem one by one I was wondering if
> it was possible to move all of them at once?  Any ideas, am I out of my
> mind?
> 
> Sincerely,
> Kevin Kostyszyn
> DBA
> Dulcian, Inc
> www.dulcian.com
> [EMAIL PROTECTED]
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Kevin Kostyszyn
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Guidry, Chris
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: ORA-00200 (control file creation error)

[David Barbour]

Delete the existing control file in the referenced directory.

David A. Barbour
Oracle DBA - ConnectSouth
512-681-9438
[EMAIL PROTECTED]


-Original Message-
Sent: Friday, February 02, 2001 8:51 AM
To: Multiple recipients of list ORACLE-L



OS COMPAQ TRU 64 Version 5.1 with OS clustering option enabled
Oracle Version 8.1.7


I am trying to create a new database OPS database/instance. While running 
the script using SVRMGRL get the following messages..

ORA-01501: CREATE DATABASE failed
ORA-00200: controlfile could not be created
ORA-00202: controlfile: '/dev/disk/dsk19a'
ORA-27038: skgfrcre: file exists

Any ideas, the sys ops say everything is OK.


Regards,

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

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: David Barbour
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Visit my web site and give me your sugguestion !!! - www.geoc

[Abdul Aleem]

It looks cool. Plus it has some useful information. I will give it a through
search for OAS.

Aleem

 -Original Message-
Sent:   Friday, February 02, 2001 7:51 AM
To: Multiple recipients of list ORACLE-L
Subject:Re: Visit my web site and give me your sugguestion !!! -
www.geocities.com/trandt

Sorry i'm forgot put my address:

www.geocities.com/trandt

Cheers,

--- Bao Jenny <[EMAIL PROTECTED]> wrote:
> Hello Oracle guru,
> 
> I'm an Oracle fans, just now i builded a personal
> website and would like to share with all of you
> Oracle
> infomation as i knew, please give me your suguestion
> as i'm begining in Web builder.
> 
> Sincrely,
> 
> Tran
> 
> 
> 
> 
> 
> __
> Get personalized email addresses from Yahoo! Mail -
> only $35 
> a year!  http://personal.mail.yahoo.com/
> -- 
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> -- 
> Author: Bao Jenny
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX:
> (858) 538-5051
> San Diego, California-- Public Internet
> access / Mailing Lists
>

> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of
> 'ListGuru') and in
> the message BODY, include a line containing: UNSUB
> ORACLE-L
> (or the name of mailing list you want to be removed
> from).  You may
> also send the HELP command for other information
> (like subscribing).


__
Get personalized email addresses from Yahoo! Mail - only $35 
a year!  http://personal.mail.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Bao Jenny
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Abdul Aleem
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Oracle Browser & SQL Functions

[Charlie Mengler]

Happy Friday Fellow Listers!

This is some what of a repeat to my last post WRT creating a new "global" function.
I have successfully created a new function that is available from SQL*Plus.
However we don't allow most folks here to use SQL*Plus, but provide them with
Oracle Browser to run their ad-hoc queries against the database. Some how/way
Browser "knows" about the Oracle supplied functions (such as RTRIM, MAX, etc.).
AFAIK the SQL Functions are not "real database objects". I have been unable
to find them within DBA_OBJECTS. They seem to be "intrinsic" to the database.

My desire/question is how can I add my newly written function to the list of
functions that Browser will allow folks to use within this utility.

TIA & HAND!

-- 
Charlie Mengler   Maintenance Warehouse  
[EMAIL PROTECTED]  10641 Scripps Summit Ct   
858-831-2229  San Diego, CA 92131
HOME DEPOT - The Big Boy's Toy store!
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Charlie Mengler
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: How to find USER who locked my row ...

[Janardhana Babu]

Steve,

Unfortunately, I can't take out NOWAIT as it is part of the application
design. They don't want the query to hang for some other user to unlock the
record. There are plenty of users accessing the same table and the same row
at the same time. We want the query to return with ORA-54, but at the same
time we would like to know the the user/user details who locked the record
of the table. This is part of the requirement of this application here. 

Is there a way to find the details that we need? Please let me know if there
is any solution.

Thanks ... Babu

-Original Message-
Sent: Thursday, February 01, 2001 6:51 PM
To: Multiple recipients of list ORACLE-L


Hi Babu,

Take out the NOWAIT temporarily so that the session will wait, and then look
in
V$LOCK to see which TX lock you are waiting for and who is holding it.

@   Regards,
@   Steve Adams
@   http://www.ixora.com.au/
@   http://www.christianity.net.au/


-Original Message-
Sent: Friday, 2 February 2001 9:50
To: Multiple recipients of list ORACLE-L


Dear list,

I am simulating an error generated by an application.

select * from XXX where fdoc_nbr = '12345'  for update nowait;

It returns with error:
ORA-00054 Resource busy acquire with nowait specified.

I need to findout who(SID,SERIAL#,USERNAME) locked the same ROW (not table).
There are many users who are locking different rows of the same table at the
same time. I need to find the one who locked my row.

I would appreciate if someone could help me with this.

TIA,
-- Babu

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Janardhana Babu
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Pondering Question of the Day-RESPECT

[Gabriel Galanternik]

Pondering Question of the Day-RESPECTlisa, feel sorry for you, but it's some
of what we discuss the other day about if a developer should tell dba about
creating tables and so.

i think that here, we respect the others based only on technical skills, and
that's the way it should be at work,
and sometimes not.

maybe, just to get some piece of mind, in your place, I would change the
phrase "I own database" for "I'm responsible
to make it work", they means the same but in second case you won't feel they
are hurting you.

this problem is a sign of these days that runs at "internet speed" :-(
when I was in that position, the only thing that helped a little was "zero
tolerance", but maybe you can't.
other position would be, "ok, you break it, I'll fix it" but then you must
write a full report, describing
problem, when, what, who, why and what the solution was, including time you
spend on each of the
tasks, ok?
who will read it? you could try in this order:
- the one who made the mistake and,

- your boss or leader or coordinator
- developer's leader
- project manager
and going up in the organization chart

at least, you can cover you from blaming
best wishes
Gabriel Galanternik

- Original Message -
To: Multiple recipients of list ORACLE-L
Sent: Friday, February 02, 2001 12:20 PM


"Hello Oracle Guru"
Now why is it that I get more respect on the Internet than I do in my
workplace.  ??
How many of you have this problem?  It's like an ongoing fight with
developers, they want carte blanche in the production database, and they do
whatever they want EVEN THOUGH I tell them NO, let's do something different
that won't affect production.  I go to the CTO because this is like the 3rd
time this has happened, and he sends out a
let's-be-sure-not-to-offend-anyone email.  But the developer(s) will go
ahead and do what they want ANYWAY.  I'm waiting for the first user-mistake
recovery to say STOP, I've had ENOUGH and this is how it's going to be, no
ifs, ands or buts.
My last job may have been a sweatshop, but at least people respected my
authority.  Here, it's a free for all no matter what I do.  Even when I say,
Dude, I own the database.  If there's a problem, I have to fix it.
Therefore I say what happens in production and what doesn' t happen in
production.
And yes, I am looking for another position.  I can only take this
dba/developer/janitor role for so long.
I'M SO GLAD IT'S FRIDAY...  Bring on the Captain Morgan!  It's noon
somewhere...
Lisa Rutland Koivu
Oracle Database Administrator
Qode.com
4850 North State Road 7
Suite G104
Fort Lauderdale, FL  33319
V: 954.484.3191, x174
F: 954.484.2933
C: 954.658.5849
http://www.qode.com
"The information contained herein does not express the opinion or position
of Qode.com and cannot be attributed to or made binding upon Qode.com."

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

OFFTOPIC: DBA Humor

[Kirsh, Gary]

This looked vaguely familiar when I received it, my apologies if it has
previously been posted.  It's not great, but I thought it has a few good
lines.

Gary Kirsh
Next Extent, Inc

Genesis of a DBA Universe

In the beginning was the disk array, and all was empty
and raw, and UNIX moved over the face of the platters.
And the DBA said: Let there be Oracle. And there was
Oracle. And the environmental variables were set and
the disks were striped and mirrored and the OFA was
established, and behold spindle was rent asunder from
spindle. And the DBA saw that all was in spec.

And it was day and it was evening of the first day.

And the DBA said: Let there be scripts. And sql.bsq
brought forth myriad crawling things upon the face of
the array. And catalog.sql brought forth all manner of
tables and views that swim unseen beneath the waters.
And catproc.sql brought forth all the built-in
programs and all the hosts of the air, that the users
might be given wings and take fight over the data.

And it was day and it was evening of the second day.

And the DBA said: Let there be tablepaces. And there
were tablespaces. And the network administrator looked
upon the disk array and did see what the tablespaces
had wrought upon the disk arrays, and he did gnash his
teeth and seek a new work upon the Internet with an
engine of search.

And it was day and it was evening of the third day.

And the DBA created users. Male and female he created
them. And he said unto the users: Thou mayest create
tables and views as thou wilt. Yea, though mayest
create even indexes upon the data. Only meddle not
with the system tablespace, for it is a holy place,
and on the day wherein thou treadest upon it, on that
day thy create session shall surely be revoked. And
the serpent crept among the users and whispered to
them, saying: Thine roles shall not be revoked. Taste
ye all of the system tablespace, for ye shall know of
b-trees and hints and ye shall be as DBAs. And the
users heeded the serpent and filled the system
tablespace with crap. And the instance did crash and
the client did wax wroth at the DBA. And the DBA did
gnash his teeth and partake of the fruit of the vine,
for behold the users were permanent employees and the
DBA was but a contractor and could not revoke their
create session.

And it was day and it was evening of the fourth day.

And the DBA did set default tablespaces and temporary
tablespaces and did lock down all that was upon the
face of the array with roles and profiles and all
manner of quotas, yea even from the rollback segments
even unto the archived redo logs.

And it was day and it was evening of the fifth day.

And the DBA created synonyms and links and did tune
the server and apply patches upon the face of the
database.

And it was day and it was evening of the sixth day.

And on the seventh day the DBA did rest from all the
labors of the creation. And his pager did ring and he
ceased from resting and did spend his sabbath on the
telephone with Oracle support. And by the time the DBA
got through to someone who knew wherof they spake 
behold it was day and it was evening of the eighth
day.

And the DBA waxed wroth.


(1/26/01 2:05:31 pm)
Reply:  He wandered from the lighted path

Did the dba not perform the sacred rites in which he
hadst been instructed?

Not cold backups, nor hot backups, nor image copies
(pray they be not false and corrupt), nor consort 
with thy servant rman, nor exports nor transports
of tablespaces to a distant land, nor standby 
database?

Therefore, when the rains come and thine instance
crash mightily, neither fast_start_io_target, nor
recovery parallelism, nor any form of complete or
incomplete recovery, nor resetting nor mining of 
logs, shalt save his soul, and his masters shall
chastise him, and his database shall be as built 
on sand.

Yea, so it shall be written, so it shall be done.
Backup, row well, and live another day. Amen.


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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Pondering Question of the Day-RESPECT

[Koivu, Lisa]

Title: RE: Pondering Question of the Day-RESPECT





Thanks Dick.  Believe it or not I am the 'meanie' in the office because I rule with an iron fist too.  At least I try and it's instead seen as 'mean' because I dare to stand up to people and say NO. 

But you are right.  Fire me then.  I don't want to be stuck in this type of environment. 


-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Friday, February 02, 2001 11:08 AM
To: Koivu; Lisa; Multiple recipients of list ORACLE-L
Subject: Re:Pondering Question of the Day-RESPECT



Lisa,


    Sounds like you've got a problem.  I'll give you my take on this which has
worked pretty well, although not always.


    Developers do not get free reign all over the place.  They do not get DBA
privileges.  They do not get access to other than 'USER%' views into the core
tables.  They get specific access to specific tablespaces in specific instances
only.  They grant object privileges to database roles only.  Grants on objects
to other users is on a case by case basis.  Passwords are changed with some
regularity & are not shared (if I find a case where this is not so, especially
in the production systems, I change the password & their boss has to come & get
it).  I work with the developers as much as possible to insure they don't get
out of hand & I will make backups of production stuff before they make changes
if they ask.  If they don't ask & then break something they're on their own &
the grilling that gets handed out by the "powers that be" is more than enough
incentive.  In some cases I've actually taken over control of the production DB
where the developers have created too much havoc, which isn't much.


    I kind of rule with an "iron" hand, but it's soft iron.  For the most part
if your involved in the beginnings of a project it's easy to keep things in
check.  It also does help to stand up for your opinions, even to the CIO/CTO. 
I've gotten to the point where I really don't care if the upper crust is upset
with me.  If they don't like it they can fire me, there are more than enough
other jobs out there.  Besides, when I did "let them have their own way", I only
spent one evening fixing the mess but the developer ended up spending an entire
day before the "firing squad" upstairs.  Case closed.


Dick Goulet


Reply Separator
Subject:    Pondering Question of the Day-RESPECT
Author: "Koivu; Lisa" <[EMAIL PROTECTED]>
Date:   2/2/2001 7:20 AM


"Hello Oracle Guru"


Now why is it that I get more respect on the Internet than I do in my
workplace.  ??


How many of you have this problem?  It's like an ongoing fight with
developers, they want carte blanche in the production database, and they do
whatever they want EVEN THOUGH I tell them NO, let's do something different
that won't affect production.  I go to the CTO because this is like the 3rd
time this has happened, and he sends out a
let's-be-sure-not-to-offend-anyone email.  But the developer(s) will go
ahead and do what they want ANYWAY.  I'm waiting for the first user-mistake
recovery to say STOP, I've had ENOUGH and this is how it's going to be, no
ifs, ands or buts.  


My last job may have been a sweatshop, but at least people respected my
authority.  Here, it's a free for all no matter what I do.  Even when I say,
Dude, I own the database.  If there's a problem, I have to fix it.
Therefore I say what happens in production and what doesn' t happen in
production.  


And yes, I am looking for another position.  I can only take this
dba/developer/janitor role for so long.


I'M SO GLAD IT'S FRIDAY...  Bring on the Captain Morgan!  It's noon
somewhere...


Lisa Rutland Koivu
Oracle Database Administrator
Qode.com
4850 North State Road 7
Suite G104
Fort Lauderdale, FL  33319


V: 954.484.3191, x174
F: 954.484.2933 
C: 954.658.5849
http://www.qode.com


"The information contained herein does not express the opinion or position
of Qode.com and cannot be attributed to or made binding upon Qode.com."







Pondering Question of the Day-RESPECT




"Hello Oracle Guru"



Now why is it that I get more respect on the
Internet than I do in my workplace.  ??



How many of you have this problem?  It's like
an ongoing fight with developers, they want carte blanche in the production
database, and they do whatever they want EVEN THOUGH I tell them NO, let's do
something different that won't affect production.  I go to the CTO because
this is like the 3rd time this has happened, and he sends out a
let's-be-sure-not-to-offend-anyone email.  But the developer(s) will go
ahead and do what they want ANYWAY.  I'm waiting for the first user-mistake
recovery to say STOP, I've had ENOUGH and this is how it's going to be, no ifs,
ands or buts.  


My last job may have been a sweatshop, but at least
people respected my authority.  Here, it's a free for all no matter what I
do.  Even when I say, Dude, I own the database.  If there's a problem,
I have

Re:Can Pro*C use long datatypes in 8.1.5?

[dgoulet]

Cherie,

This is a rather simple error.  They're passing 'error_number' in as a long
int, but then trying to place that into the 'verror_number' variable that is
declared as a simple int.  Otherwise this looks fine.

Dick Goulet
OLD PRO*C hacker

Reply Separator
Author: [EMAIL PROTECTED]
Date:   2/2/2001 7:20 AM

We are migrating some 7.3.4 databases to 8.1.5.
I thought that long datatypes were desupported in 8.1.5.

Our developers are having trouble with some
of their code that does uploads and downloads.
I really don't know much about Pro*C but see
several uses of long datatypes in their package.

Can someone tell me whether this Pro*C function call
will still work within 8.1.5?

int DATABASE_SYSMSG_Write (char type, long error_number, char *error_msg,
   char *location, char *s1, char *s2, char *s3,
   char *s4, char *s5, char *s6)
{
   int ret = 0;
/* If the arguments include null pointers, set them to something
   so segmentation violation won't occur.
*/
if (! s1) s1 = " ";
if (! s2) s2 = " ";
if (! s3) s3 = " ";
if (! s4) s4 = " ";
if (! s5) s5 = " ";
if (! s6) s6 = " ";

 EXEC SQL BEGIN DECLARE SECTION;
  VARCHAR vtype[2];
  int verror_number;
  VARCHAR verror_msg[81];
  char   *vlocation;
  int vsql_error;
  VARCHAR vsql_msg[81];
  VARCHAR vs1[81];
  VARCHAR vs2[81];
  VARCHAR vs3[81];
  VARCHAR vs4[81];
  VARCHAR vs5[81];
  VARCHAR vs6[81];
   EXEC SQL END DECLARE SECTION;


   vtype.len = 1;
   vtype.arr[0] = type;
   verror_number = error_number;
   vsql_error = DATABASE_sql_num;
   vsql_msg.len = sprintf ((char *)vsql_msg.arr, "%s", DATABASE_sql_msg);
   vlocation = location;
   verror_msg.len = sprintf ((char *)verror_msg.arr, "%s", error_msg);
   vs1.len = sprintf ((char *)vs1.arr, "%s", s1);
   vs2.len = sprintf ((char *)vs2.arr, "%s", s2);
   vs3.len = sprintf ((char *)vs3.arr, "%s", s3);
   vs4.len = sprintf ((char *)vs4.arr, "%s", s4);
   vs5.len = sprintf ((char *)vs5.arr, "%s", s5);
   vs6.len = sprintf ((char *)vs6.arr, "%s", s6);

   EXEC SQL EXECUTE
  BEGIN
  Help_DeskPackage.AddBackendRecord (:vtype, :verror_number, :vsql_msg,
 :vsql_error, :vlocation, :verror_msg,
 :vs1, :vs2, :vs3, :vs4, :vs5, :vs6);
END;
   END-EXEC;

   if (sqlca.sqlcode)
  {
  ret = -1;
  }

   return (ret);
}






Thanks,

Cherie Machler
Gelco Information Network




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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: Netapp

[jkstill]

On Fri, 2 Feb 2001, alex wrote:

> Working with autoraids I have always been suspicious about  their ability to
> decide on witch raid level is best.
^


Some kind of wierd Freudian slip here Alex?

;)

Jared


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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: ORA-00200 (control file creation error)

[Anne Yu]

You need to delete these old control files.

-Original Message-
Sent: Friday, February 02, 2001 8:51 AM
To: Multiple recipients of list ORACLE-L




I am trying to create a new database OPS database/instance. While running 
the script using SVRMGRL get the following messages..

ORA-01501: CREATE DATABASE failed
ORA-00200: controlfile could not be created
ORA-00202: controlfile: '/dev/disk/dsk19a'
ORA-27038: skgfrcre: file exists

Any ideas, the sys ops say everything is OK.


Regards,

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

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Anne Yu
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Pondering Question of the Day-RESPECT

[Kimberly Smith]

Title: Pondering Question of the Day-RESPECT



I have 
had that same issue in the past but I don't have it here.  I find 
that
as 
long as you have your managements support and the development 
team
knows 
that then life will be much easier.  I am very lucky here in that 
I
have 
good management and a very well trained senior development 
team
to 
work with.  Not that there are never disagreements but comprise is 
the
name 
of the game.  You just got to be picky on what you let them think you 
are
compromising on:-)  I always have 
more issues with junior/intermediate 
developers.  

  -Original Message-From: Koivu, Lisa 
  [mailto:[EMAIL PROTECTED]]Sent: Friday, February 02, 2001 7:20 
  AMTo: Multiple recipients of list ORACLE-LSubject: 
  Pondering Question of the Day-RESPECT
  "Hello Oracle Guru" 
  Now why is it that I get more respect on the 
  Internet than I do in my workplace.  ?? 
  How many of you have this problem?  It's like 
  an ongoing fight with developers, they want carte blanche in the production 
  database, and they do whatever they want EVEN THOUGH I tell them NO, let's do 
  something different that won't affect production.  I go to the CTO 
  because this is like the 3rd time this has happened, and he sends out a 
  let's-be-sure-not-to-offend-anyone email.  But the developer(s) will go 
  ahead and do what they want ANYWAY.  I'm waiting for the first 
  user-mistake recovery to say STOP, I've had ENOUGH and this is how it's going 
  to be, no ifs, ands or buts.  
  My last job may have been a sweatshop, but at least 
  people respected my authority.  Here, it's a free for all no matter what 
  I do.  Even when I say, Dude, I own the database.  If there's a 
  problem, I have to fix it.  Therefore I say what happens in production 
  and what doesn' t happen in production.  
  And yes, I am looking for another position.  I 
  can only take this dba/developer/janitor role for so long. 
  I'M SO GLAD IT'S FRIDAY...  Bring on the 
  Captain Morgan!  It's noon somewhere... 
  Lisa Rutland Koivu Oracle Database Administrator Qode.com 4850 North State Road 
  7 Suite G104 Fort Lauderdale, FL  33319 
  V: 954.484.3191, x174 F: 954.484.2933 C: 
  954.658.5849 http://www.qode.com 
  "The information contained herein 
  does not express the opinion or position of Qode.com and cannot be attributed 
  to or made binding upon Qode.com."

RE: RE: OT NT2K vs Unix.

[jkstill]

On Thu, 1 Feb 2001, Kevin Kostyszyn wrote:

> What about Mechwarrior or Quake II, can I run that on Unix and will it run
> smoothly?  This is a fun debate, but I do agree there will never be a
> winner.

If all gaming software disappeared tomorrow, I would never notice.

Jared

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: ORA-00200 (control file creation error)

[Murali Vallath]

Thank you.


Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Date: Fri, 02 Feb 2001 07:41:57 -0800

The /dev/disk/dsk19a should be a character one. Issue a ls -l
/dev/disk/dsk19a and it must appear something like this:

crw-rw.

Regards.


 > -Mensaje original-
 > De:  Murali Vallath [SMTP:[EMAIL PROTECTED]]
 > Enviado el:  viernes 2 de febrero de 2001 15:51
 > Para:Multiple recipients of list ORACLE-L
 > Asunto:  ORA-00200 (control file creation error)
 >
 >
 >
 > I am trying to create a new database OPS database/instance. While running
 > the script using SVRMGRL get the following messages..
 >
 > ORA-01501: CREATE DATABASE failed
 > ORA-00200: controlfile could not be created
 > ORA-00202: controlfile: '/dev/disk/dsk19a'
 > ORA-27038: skgfrcre: file exists
 >
 > Any ideas, the sys ops say everything is OK.
 >
 >
 > Regards,
 >
 > Murali Vallath
 > _
 > Get your FREE download of MSN Explorer at http://explorer.msn.com
 >
 > --
 > Please see the official ORACLE-L FAQ: http://www.orafaq.com
 > --
 > Author: Murali Vallath
 >   INET: [EMAIL PROTECTED]
 >
 > Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 > San Diego, California-- Public Internet access / Mailing Lists
 > 
 > To REMOVE yourself from this mailing list, send an E-Mail message
 > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 > the message BODY, include a line containing: UNSUB ORACLE-L
 > (or the name of mailing list you want to be removed from).  You may
 > also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Trassens, Christian
   INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

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

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: How to drop a database

[jkstill]

Glenn,

dba_temp_files will be populated when you create a temporary tablespace.

e.g.  create temporary tablespace temp tempfile '/oradata/temp01.dbf' size 1000m;

Jared

On Thu, 1 Feb 2001, Glenn Travis wrote:

> What is usually in dba_temp_files?  Mine has zero rows (all day).  If you
> shutdown and restart Oracle, will this table be empty?
>
> > -Original Message-
> > From: Igor Polishchuk [mailto:[EMAIL PROTECTED]]
> > Sent: Tuesday, January 30, 2001 9:38 PM
> > To: 'Glenn Travis'; Woody Mckay; [EMAIL PROTECTED];
> > [EMAIL PROTECTED]
> > Subject: RE: How to drop a database
> >
> >
> > Hi Glenn
> > You missed temporary files, that may be associated with database
> > Velow is my script that creates script for database deleting and includes
> > temporary files too. But it is necessary to be careful with it :)
> >
> > #  This script shutdown current database and delete all files for
> > #c #  this
> > database
> > #
> > #
> > sqlplus -s internal << EOF
> > spool _rm_files.sh
> > set head off feedback off pages 0
> >
> > select 'rm '|| file_name
> > from dba_data_files;
> >
> > select 'rm '|| file_name
> > from dba_temp_files;
> >
> > select 'rm '|| name
> > from v\$controlfile;
> >
> > select 'rm '|| member
> >  from v\$logfile;
> >
> > prompt rm $ORACLE_HOME/dbs/orapw$ORACLE_SID
> >
> > spool off
> >
> > shutdown abort
> >
> > EOF
> >
> > chmod u+x ./_rm_files.sh
> >
> > #./_rm_files.sh
> >
> >
> >
> > Igor Polishchuk
> > IT department
> > DigitalThink
> > (415) 625 4285
> > e-mail: [EMAIL PROTECTED]
> >
> >
> > -Original Message-
> > From: Glenn Travis [mailto:[EMAIL PROTECTED]]
> > Sent: Tuesday, January 30, 2001 11:06 AM
> > To: Woody Mckay; [EMAIL PROTECTED]; [EMAIL PROTECTED]
> > Subject: RE: How to drop a database
> >
> >
> > Here's a script I wrote to list all the files associated with the
> > database.
> > List, did I miss any?
> > ___
> > break on today
> > column today noprint new_value xdate
> > select substr(to_char(sysdate,'fmMonth DD,  HH:MI:SS
> > P.M.'),1,35) today
> > from dual;
> > column name noprint new_value dbname
> > column created noprint new_value dbcreated
> > column host_name noprint new_value hostname
> > select name,created from v$database;
> > select host_name from v$instance;
> >
> > spool &dbname..&hostname..databasefiles.out
> >
> > prompt Date:  &xdate
> > prompt DATABASE:  &dbname
> > prompt HOST:  &hostname
> > prompt Created:   &dbcreated
> > prompt
> > prompt 
> > prompt *  Database Files  *
> > prompt 
> > prompt
> >
> > set head off echo off pagesize 0 trimspool on feed off linesize 132
> >
> > clear columns
> > col ftype format a15
> > col tbspc format a20
> > col fname format a50
> >
> > select 'Controlfile' ftype, name fname , ' ' tbspc
> >   from SYS.V_$CONTROLFILE
> > union
> > select 'Logfile' ftype, member fname, ' ' tbspc
> >   from SYS.V_$LOGFILE
> > union
> > select 'Tablespace' ftype, file_name fname,
> > '('||tablespace_name||')' tbspc
> >   from DBA_DATA_FILES
> > order by 2;
> >
> > spool off
> > prompt
> > prompt Output in &dbname..&hostname..databasefiles.out
> > prompt
> > quit
> > _
> >
> >
> > > -Original Message-
> > > From: Ruth Gramolini [mailto:[EMAIL PROTECTED]]
> > > Sent: Tuesday, January 30, 2001 1:08 PM
> > > To: Woody Mckay; [EMAIL PROTECTED]; [EMAIL PROTECTED]
> > > Subject: Re: How to drop a database
> > >
> > >
> > > There  is not command to drop a database.  You just have to
> > remove all of
> > > the files associated with that database: control files, datafiles, etc.
> > >
> > > Ruth
> > > - Original Message -
> > > From: "Woody Mckay" <[EMAIL PROTECTED]>
> > > To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
> > > Sent: Tuesday, January 30, 2001 12:51 PM
> > > Subject: How to drop a database
> > >
> > >
> > > > Hello all,
> > > >
> > > > Sorry to ask what might be a dumb question, but a friend
> > wants to drop a
> > > > test database (Solaris/Oracle 8.1.7) and I can't seem to find
> > the right
> > > > command(s).
> > > >
> > > > Would it be a series of alter database drop xxx?
> > > >
> > > > Thanks for any help.
> > > >
> > > > Woody
> > > >
> > > >
> > > > 
> > > > Think you know someone who can answer the above question?
> > Forward it to
> > > them!
> > > > to unsubscribe, send a blank email to
> > [EMAIL PROTECTED]
> > > > to subscribe send a blank email to [EMAIL PROTECTED]
> > > > Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl
> > > >
> > >
> > >
> > > 
> > > Think you know someone who can answer the above question? Forward
> > > it to them!
> > > to unsubscribe, send a blank email to [EMAIL PROTECTED]
> > > to subscribe send a blank email to [EMAIL PROTECTED]
> > > Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl
> > >
> >
> >
> > 
> > Think you know someone who can answer the above question? Forward it to
> > them!
> > to

Index move

[Kevin Kostyszyn]

Has anyone ever written a script or something that moved indexes to a
different tablespace?  One of our schemas has indexes in the wrong
tablespace and instead of going throught hem one by one I was wondering if
it was possible to move all of them at once?  Any ideas, am I out of my
mind?

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

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: COPY command dieing - help

[jkstill]

On Thu, 1 Feb 2001, Shaw, John B wrote:

> I am attempting to copy a table from a 8.1.6 db to 8.1.7. Most of the tables
> have come across successfully. One table is having a problem.
> The command:
> copy from v55/v55@int to user/pwd@frog create DMF using select * from
> DMF@int;
> This table gives ora-00911 error (invalid character ? where? - this same
> command worked on many other tables).
> I manually created the table in the local db and tried to do an append of
> the data
> copy from v55/v55@int to user/pwd@frog append DMF using select * from
> DMF@int;
>
> This causes sqlplus and sqlworksheet to die (this is on NT0
> anybody have an idea of what's going on?


Maybe a silly question, but do the databases use the same character set?

Jared


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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Pondering Question of the Day-RESPECT

[Kevin Kostyszyn]

Title: Pondering Question of the Day-RESPECT



Yeah 
Baby!!  Kick some developer butt!!  I am kind of in the same boat with 
you.  People telling me things are supposed to be faster when they 
obviously can't be faster.  Yes, it will query in 0.00 seconds, lets 
just tune it a littel more.  Not to mention constantly trying to convince 
my boss why I am an asset to the company, can't take much more of that!!  
Bring on the Rolling Rock!!

  -Original Message-From: [EMAIL PROTECTED] 
  [mailto:[EMAIL PROTECTED]]On Behalf Of Koivu, LisaSent: 
  Friday, February 02, 2001 10:20 AMTo: Multiple recipients of list 
  ORACLE-LSubject: Pondering Question of the 
  Day-RESPECT
  "Hello Oracle Guru" 
  Now why is it that I get more respect on the 
  Internet than I do in my workplace.  ?? 
  How many of you have this problem?  It's like 
  an ongoing fight with developers, they want carte blanche in the production 
  database, and they do whatever they want EVEN THOUGH I tell them NO, let's do 
  something different that won't affect production.  I go to the CTO 
  because this is like the 3rd time this has happened, and he sends out a 
  let's-be-sure-not-to-offend-anyone email.  But the developer(s) will go 
  ahead and do what they want ANYWAY.  I'm waiting for the first 
  user-mistake recovery to say STOP, I've had ENOUGH and this is how it's going 
  to be, no ifs, ands or buts.  
  My last job may have been a sweatshop, but at least 
  people respected my authority.  Here, it's a free for all no matter what 
  I do.  Even when I say, Dude, I own the database.  If there's a 
  problem, I have to fix it.  Therefore I say what happens in production 
  and what doesn' t happen in production.  
  And yes, I am looking for another position.  I 
  can only take this dba/developer/janitor role for so long. 
  I'M SO GLAD IT'S FRIDAY...  Bring on the 
  Captain Morgan!  It's noon somewhere... 
  Lisa Rutland Koivu Oracle Database Administrator Qode.com 4850 North State Road 
  7 Suite G104 Fort Lauderdale, FL  33319 
  V: 954.484.3191, x174 F: 954.484.2933 C: 
  954.658.5849 http://www.qode.com 
  "The information contained herein 
  does not express the opinion or position of Qode.com and cannot be attributed 
  to or made binding upon Qode.com."

RE: Pondering Question of the Day-RESPECT

[Holman, Rodney]

Title: Pondering Question of the Day-RESPECT



Lisa,
Rather 
than talking to the CTO about this go to the Dir, VP, or whatever of the USERS 
of the system.  In-fact he/she is the actual OWNER of the data in the 
system.  Explain to him/her how dangerous and devious the developers are to 
the data.  Talk about corruption, system downtime, partial and incomplete 
restores.  Use some technical DBA language to make them 
understand you have the knowledge, but make sure you keep the message at 
a manager level of understanding.  Get them good and scared.  
Then when the developers are asking for the free ride in production you have an 
advocate in high postion that can put the CTO in a position of getting a 
backbone.  When the COO starts asking why his people can't work, or why the 
P/L statement is messed up the CTO will start scrambling for a lockdown on 
production and more comprehensive testing of new or enhanced code.  
Remember the politics.  We in the IT field are not the production 
organization we are the service organization.  When it comes to power 
struggles at the Cxx levels the production/operations guys always beat the IT/IS 
guys.  It's a mater of $$$ and performance in front of the 
CEO.
 
HTH
 
Rodd 
Holman

  -Original Message-From: Koivu, Lisa 
  [mailto:[EMAIL PROTECTED]]Sent: Friday, February 02, 2001 9:20 
  AMTo: Multiple recipients of list ORACLE-LSubject: 
  Pondering Question of the Day-RESPECT
  "Hello Oracle Guru" 
  Now why is it that I get more respect on the 
  Internet than I do in my workplace.  ?? 
  How many of you have this problem?  It's like 
  an ongoing fight with developers, they want carte blanche in the production 
  database, and they do whatever they want EVEN THOUGH I tell them NO, let's do 
  something different that won't affect production.  I go to the CTO 
  because this is like the 3rd time this has happened, and he sends out a 
  let's-be-sure-not-to-offend-anyone email.  But the developer(s) will go 
  ahead and do what they want ANYWAY.  I'm waiting for the first 
  user-mistake recovery to say STOP, I've had ENOUGH and this is how it's going 
  to be, no ifs, ands or buts.  
  My last job may have been a sweatshop, but at least 
  people respected my authority.  Here, it's a free for all no matter what 
  I do.  Even when I say, Dude, I own the database.  If there's a 
  problem, I have to fix it.  Therefore I say what happens in production 
  and what doesn' t happen in production.  
  And yes, I am looking for another position.  I 
  can only take this dba/developer/janitor role for so long. 
  I'M SO GLAD IT'S FRIDAY...  Bring on the 
  Captain Morgan!  It's noon somewhere... 
  Lisa Rutland Koivu Oracle Database Administrator Qode.com 4850 North State Road 
  7 Suite G104 Fort Lauderdale, FL  33319 
  V: 954.484.3191, x174 F: 954.484.2933 C: 
  954.658.5849 http://www.qode.com 
  "The information contained herein 
  does not express the opinion or position of Qode.com and cannot be attributed 
  to or made binding upon Qode.com."

DB Tool recommendations

[nstetson]

Hi All,


I was wondering what tools people recommend for performing any of the
following actions:
 - Auditing and comparing the objects in one instance versus another.
 - Auditing and comparing the data in one instance.schema.table versus
another.
 - Good PL/SQL debugger  (Step into stored procedures, triggers, possibly
Java stored procedures.

Any input appreciated!

Thanks a Bunch,
   Nancy


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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: WHERE Clause of Forms Block fails to find record!!!!

[Gabriel Galanternik]

also check the record hasn't any value that fails "Property Palette"
validation.
I mean: if in property palette you have define, for example, in a checkbox
values 'Y' and 'N' and
Mapping of Other Values not specified, then a record with an 'A' in that
column will be rejected silently

Gabriel Galanternik
- Original Message -
To: Multiple recipients of list ORACLE-L
Sent: Friday, February 02, 2001 7:50 AM


Hi,

What was the datatype of the Flock ID ?
 I remember having a similar problem a couple of years ago (it was forms 4.5
if I remember correctly), and the datatype in the form was char (I think),
which then ended up being padded with spaces ...

HTH

Regards
Oweson Flynn
--
Certified Oracle DBA
The Flynn Consultancy
Tel: 082-600-7-006
Fax: (011) 782-9313
EMail: [EMAIL PROTECTED]
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Thursday, February 01, 2001 4:41 PM


> Sorry if this end up being a duplicate posting, but it did not show
> up in either my ORACLE-L digest or my Developer list messages
> yesterday so I assumed the post was "missing in action"..
>
> I'm posting this to both the Database and Developer Lists in the
> hopes that someone has seen this at either the Form or Database
> level.
>
> We have a form in an application (Forms 6.0) designed to allow the
> user to create and update records in a table called FLOCKS. To
> create a new record, the user enters a new Flock ID and is
> presented with a blank record in the form to update and eventually
> save. The user can update an existing FLOCK record by entering
> the desired Flock ID. The form will look up the record and present
> the existing information in the form and allow it to be modified.
>
> Under the hood, the user is actually entering the Flock ID into a
> text item in a CONTROL block. The WHEN-VALIDATE-ITEM
> trigger checks a number of things, including whether or not a
> record for the specified Flock ID already exists. If it exists, the
> variable :GLOBAL.NEW_FLOCK is set to "N", otherwise it is set to
> "Y". After the validation is complete and the variable is set, the
> default block navigation takes the user to the DETAIL block.
>
> The WHEN-NEW-BLOCK-INSTANCE trigger then fires with the
> following code:
>
>
> if :global.new_flock = 'N' then
>   execute_query;
> else
>   clear_block(NO_COMMIT);
> end if;
>
> In the Property Palette of the DETAIL block the Database "Where"
> clause is specified as "FLOCK_ID = :CONTROL.FLOCK_ID" so
> that the EXECUTE_QUERY built-in will populate the block with the
> one (and only one) matching record.
>
> About 2 weeks ago, one of the application users called me to
> report a problem accessing one of the FLOCK records using this
> form. She kept receiving a "FRM-40401: Query returned no
> records." error for one and (so far) only one record in the table.
> Using the debugger, I was able to verify that the WHEN-VALIDATE-
> ITEM trigger was correctly locating the record in question and
> setting the :GLOBAL.NEW_FLOCK record as expected. However,
> when the EXECUTE_QUERY built-in executed, the FRM-40401
> error popped up.
>
> It seemed that the WHERE clause in the Block Properties was
> failing to find the record. SQL*PLUS, as well as several other forms
> were able to locate and display or list the record contents with no
> problem - but they did not use the WHERE clause property of a
> data block. The situation arose on a production database running
> Oracle 8.1.5 Standard Edition on NT 4.0, but the same record
> worked fine on my testbed machine (Personal Oracle 8.0.4 on NT
> Workstation).
>
> Over the last 2 weeks, Oracle Support has come up dry in terms of
> giving me any rational explanation for this. Under pressure to get
> the problem fixed, I discovered that deleting the record and copying
> the same record from my testbed back to the server did not resolve
> the problem, but deleting the record and asking the user to re-enter
> the details worked. Problem solved, but by the time the TAR finally
> made it through the triage process and a knowledgeable Analyst
> started working on it, I could no longer reporoduce the problem.
> The TAR is now soft closed and if the same error happens again, I
> have a short list of things to poke at in the database.
>
> On the Forms side, has anyone had a similar problem appear in
> the WHERE clause of a Block, and on the Database side has
> anyone run into a situation where a query for a record (specifically
> part of a Forms Application) has failed even though the records
> exists?
>
> ---
> Gary Norwell, Database Developer
> Hybrid Turkeys a Division of Nutreco Canada
> 650 Riverbend Drive, Suite "C"
> Kitchener Ontario Canada N2K 3S2
> (519) 578-2740  Fax (519) 578-1870
> ===
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> A

Re:Pondering Question of the Day-RESPECT

[dgoulet]

Lisa,

Sounds like you've got a problem.  I'll give you my take on this which has
worked pretty well, although not always.

Developers do not get free reign all over the place.  They do not get DBA
privileges.  They do not get access to other than 'USER%' views into the core
tables.  They get specific access to specific tablespaces in specific instances
only.  They grant object privileges to database roles only.  Grants on objects
to other users is on a case by case basis.  Passwords are changed with some
regularity & are not shared (if I find a case where this is not so, especially
in the production systems, I change the password & their boss has to come & get
it).  I work with the developers as much as possible to insure they don't get
out of hand & I will make backups of production stuff before they make changes
if they ask.  If they don't ask & then break something they're on their own &
the grilling that gets handed out by the "powers that be" is more than enough
incentive.  In some cases I've actually taken over control of the production DB
where the developers have created too much havoc, which isn't much.

I kind of rule with an "iron" hand, but it's soft iron.  For the most part
if your involved in the beginnings of a project it's easy to keep things in
check.  It also does help to stand up for your opinions, even to the CIO/CTO. 
I've gotten to the point where I really don't care if the upper crust is upset
with me.  If they don't like it they can fire me, there are more than enough
other jobs out there.  Besides, when I did "let them have their own way", I only
spent one evening fixing the mess but the developer ended up spending an entire
day before the "firing squad" upstairs.  Case closed.

Dick Goulet

Reply Separator
Author: "Koivu; Lisa" <[EMAIL PROTECTED]>
Date:   2/2/2001 7:20 AM

"Hello Oracle Guru"

Now why is it that I get more respect on the Internet than I do in my
workplace.  ??

How many of you have this problem?  It's like an ongoing fight with
developers, they want carte blanche in the production database, and they do
whatever they want EVEN THOUGH I tell them NO, let's do something different
that won't affect production.  I go to the CTO because this is like the 3rd
time this has happened, and he sends out a
let's-be-sure-not-to-offend-anyone email.  But the developer(s) will go
ahead and do what they want ANYWAY.  I'm waiting for the first user-mistake
recovery to say STOP, I've had ENOUGH and this is how it's going to be, no
ifs, ands or buts.  

My last job may have been a sweatshop, but at least people respected my
authority.  Here, it's a free for all no matter what I do.  Even when I say,
Dude, I own the database.  If there's a problem, I have to fix it.
Therefore I say what happens in production and what doesn' t happen in
production.  

And yes, I am looking for another position.  I can only take this
dba/developer/janitor role for so long.

I'M SO GLAD IT'S FRIDAY...  Bring on the Captain Morgan!  It's noon
somewhere...

Lisa Rutland Koivu
Oracle Database Administrator
Qode.com
4850 North State Road 7
Suite G104
Fort Lauderdale, FL  33319

V: 954.484.3191, x174
F: 954.484.2933 
C: 954.658.5849
http://www.qode.com

"The information contained herein does not express the opinion or position
of Qode.com and cannot be attributed to or made binding upon Qode.com."






Pondering Question of the Day-RESPECT



"Hello Oracle Guru"


Now why is it that I get more respect on the
Internet than I do in my workplace.  ??


How many of you have this problem?  It's like
an ongoing fight with developers, they want carte blanche in the production
database, and they do whatever they want EVEN THOUGH I tell them NO, let's do
something different that won't affect production.  I go to the CTO because
this is like the 3rd time this has happened, and he sends out a
let's-be-sure-not-to-offend-anyone email.  But the developer(s) will go
ahead and do what they want ANYWAY.  I'm waiting for the first user-mistake
recovery to say STOP, I've had ENOUGH and this is how it's going to be, no ifs,
ands or buts.  

My last job may have been a sweatshop, but at least
people respected my authority.  Here, it's a free for all no matter what I
do.  Even when I say, Dude, I own the database.  If there's a problem,
I have to fix it.  Therefore I say what happens in production and what
doesn' t happen in production.  

And yes, I am looking for another position.  I
can only take this dba/developer/janitor role for so long.


I'M SO GLAD IT'S FRIDAY...  Bring on the
Captain Morgan!  It's noon somewhere...


Lisa Rutland Koivu
Oracle Database Administrator
Qode.com
4850 North State Road 7
Suite G104
Fort Lauderdale, FL  33319


V: 954.484.3191, x174
F: 954.484.2933 
C: 954.658.5849
http://www.qode.com"
TARGET="_blank">http://www.qode.com


"The information contained
herein does not express the opinion or position of Qode.com and cannot be
attributed to 

Re: Pondering Question of the Day-RESPECT

[Cherie_Machler]

Oops, I hate it when I do that.  That was supposed to
go straight to Lisa.  Everyone else can just scratch
their head and wonder.

Cherie


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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: Selecting all columns

[Ruth Gramolini]

Have a look at dba_tab_columns.  That has all of the information you seem to
want.  Do an order by table_name or possibley a print at table_name to get a
report.

Ruth
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Wednesday, January 31, 2001 10:50 PM



What would be the sql needed if possible (in sql*plus) to select all column
names (and respective table) and their column type within a tablespace?

Much appreciated,

renée

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Visit my web site and give me your sugguestion !!!

[Channa, Santhosh, SITS]

Tran,

Your web site looks much better after you adding my web site source to
yours. Thanks for stealing my code.

Click on "Favorite Sites" and that gives you my web site contents.

Santhosh Channa
http://www.geocities.com/csbabu 
(or) http://www.csbabu.com

> -Original Message-
> Sent: Thursday, February 01, 2001 6:30 PM
> To: Multiple recipients of list ORACLE-L
> 
> 
> Hello Oracle guru,
> 
> I'm an Oracle fans, just now i builded a personal
> website and would like to share with all of you Oracle
> infomation as i knew, please give me your suguestion
> as i'm begining in Web builder.
> 
> Sincrely,
> 
> Tran
> 
> 
> 
> 
> 
> __
> Get personalized email addresses from Yahoo! Mail - only $35 
> a year!  http://personal.mail.yahoo.com/
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Bao Jenny
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Kimberly Smith
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Channa, Santhosh, SITS
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Visit my web site and give me your sugguestion !!!

[Channa, Santhosh, SITS]

> Tran,
> 
> Your web site looks much better after you adding my web site source to
> yours. Thanks for stealing my code.
> 
> Click on "Favorite Sites" and that gives you my web site contents.
> 
> Santhosh Channa
> http://www.geocities.com/csbabu 
> (or) http://www.csbabu.com
> 
>   -Original Message-
>   Sent: Thursday, February 01, 2001 6:30 PM
>   To: Multiple recipients of list ORACLE-L
> 
> 
>   Hello Oracle guru,
> 
>   I'm an Oracle fans, just now i builded a personal
>   website and would like to share with all of you Oracle
>   infomation as i knew, please give me your suguestion
>   as i'm begining in Web builder.
> 
>   Sincrely,
> 
>   Tran
> 
> 
> 
> 
> 
>   __
>   Get personalized email addresses from Yahoo! Mail - only $35 
>   a year!  http://personal.mail.yahoo.com/
>   -- 
>   Please see the official ORACLE-L FAQ: http://www.orafaq.com
>   -- 
>   Author: Bao Jenny
> INET: [EMAIL PROTECTED]
> 
>   Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
>   San Diego, California-- Public Internet access / Mailing
> Lists
>   
>   To REMOVE yourself from this mailing list, send an E-Mail message
>   to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
>   the message BODY, include a line containing: UNSUB ORACLE-L
>   (or the name of mailing list you want to be removed from).  You may
>   also send the HELP command for other information (like subscribing).
>   -- 
>   Please see the official ORACLE-L FAQ: http://www.orafaq.com
>   -- 
>   Author: Kimberly Smith
> INET: [EMAIL PROTECTED]
> 
>   Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
>   San Diego, California-- Public Internet access / Mailing
> Lists
>   
>   To REMOVE yourself from this mailing list, send an E-Mail message
>   to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
>   the message BODY, include a line containing: UNSUB ORACLE-L
>   (or the name of mailing list you want to be removed from).  You may
>   also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Channa, Santhosh, SITS
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

ORA-00200 (control file creation error)

[Murali Vallath]

OS COMPAQ TRU 64 Version 5.1 with OS clustering option enabled
Oracle Version 8.1.7


I am trying to create a new database OPS database/instance. While running 
the script using SVRMGRL get the following messages..

ORA-01501: CREATE DATABASE failed
ORA-00200: controlfile could not be created
ORA-00202: controlfile: '/dev/disk/dsk19a'
ORA-27038: skgfrcre: file exists

Any ideas, the sys ops say everything is OK.


Regards,

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

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: Pondering Question of the Day-RESPECT

[Cherie_Machler]

Lisa,

A sweatshop?!  Now that sounds a bit harsh.  .; )
And just yesterday, both Larry and Jeff
complimented me on something nice
some developers said about me.

Last Friday they reorged a bit and now
Leo is Larry's boss.  So basically Development
and our group is under the same umbrella.
They've been spending the last week trying
to get everyone to play nice together.  Now
we're trying to emphasize Service with a Smile.

Cherie


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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).