RE: DECODE AND SELECT

[Kevin Lange]

 One thing you could consider is to make functions out of each of the sql
statements in the case.  Then, in your decode statement you could call the
correct function based on the value of X.  Either that or put the entire
logic into a function that has all the case statement broken down into
individual IF tests .

-Original Message-
To: Multiple recipients of list ORACLE-L
Sent: 7/11/03 11:39 PM

Hi

I am in urgent need of backporting oracle9i pl/sql to
oracle8i.I have encountered some case satements like
this

CASE 
when x>0 then (select y from deptno)
else
(select Z from emp)
end

i need to convert them to decode statements.Can
anybody tell me how to write a select statement within
decode.

regards
Hrishy


Want to chat instantly with your online friends?  Get the FREE Yahoo!
Messenger http://uk.messenger.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: =?iso-8859-1?q?hrishy?=
  INET: [EMAIL PROTECTED]

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

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

Re: DECODE AND SELECT

[Mladen Gogala]

You are lucky! My sinuses are getting better. Decode is
a function which is to be called within a SQL statement,
not the other way round. What do you translate a "CASE"
statement into? That's elementary, my dear Hrishy: a sequence
of "if ... then ... else ... end if" commands.
On 2003.07.12 00:39, hrishy wrote:
Hi

I am in urgent need of backporting oracle9i pl/sql to
oracle8i.I have encountered some case satements like
this
CASE
when x>0 then (select y from deptno)
else
(select Z from emp)
end
i need to convert them to decode statements.Can
anybody tell me how to write a select statement within
decode.
regards
Hrishy

Want to chat instantly with your online friends?  Get the FREE Yahoo!
Messenger http://uk.messenger.yahoo.com/
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: =?iso-8859-1?q?hrishy?=
  INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
--
Mladen Gogala
Oracle DBA
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Mladen Gogala
 INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

DECODE AND SELECT

[hrishy]

Hi

I am in urgent need of backporting oracle9i pl/sql to
oracle8i.I have encountered some case satements like
this

CASE 
when x>0 then (select y from deptno)
else
(select Z from emp)
end

i need to convert them to decode statements.Can
anybody tell me how to write a select statement within
decode.

regards
Hrishy


Want to chat instantly with your online friends?  Get the FREE Yahoo!
Messenger http://uk.messenger.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: =?iso-8859-1?q?hrishy?=
  INET: [EMAIL PROTECTED]

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

RE: Sparky auth file

[Cary Millsap]

Barb,

Hi, I wrote Sparky, but it's been so long that it's going to take me a
little time to catch up with my own code. We have some users running fine on
OpenVMS, so there's certainly hope :).

Would you mind privately sending me your whole trcfiled.log file? We can
take it offline from here until we figure out the answer, and then one of us
can post the list.


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

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


-Original Message-
Barbara Baker
Sent: Friday, July 11, 2003 6:35 PM
To: Multiple recipients of list ORACLE-L

Ok, this is a  REAL reach.
But does anyone out there know how to specify the dump
directory in the auth file for sparky
  ...  wait
  ...  I'm not there yet
on an OpenVMS system?

OpenVMS 7.2-1
Oracle 8.1.7.4
Perl 5.6.1

The background dump desitnation from v$parameter is
ORA_DUMP.  The system logical ORA_DUMP equates to
disk$dbtest11:[db_amdev.trace].
Sparky wants to append the trace name file to the end
of this.  I've tried both ORA_DUMP: and
disk$dbtest11:[db_amdev.trace] in the aut file. They
don't work.

if I use diskname:

Authorized directory 'disk$dbtest11:[DB_AMDEV.TRACE]':
16 of 16 '*.trc' files are readable
Fri Jul 11 16:20:48 2003 REQ  10.39.8.253
version
Fri Jul 11 16:20:48 2003 ACK  10.39.8.253
0 3.04
Fri Jul 11 16:21:30 2003 REQ  10.39.8.253
trcname 'ORA_DUMP', '20c02d0a', 'AMDEV', '16'
Fri Jul 11 16:21:30 2003 ACK  10.39.8.253
1 not authorized to
read 'ORA_DUMP' (trcfiled.pl v3.04 line 536)

if I use ORA_DUMP

Fri Jul 11 16:18:34 2003 INFO
spid('[.ORA_DUMP]drax11_amdev_fg_oracle_016.trc')='-1'
Fri Jul 11 16:18:34 2003 WSVR
can't read '[.ORA_DUMP]drax11_amdev_fg_oracle_017.trc'
(no such file or directory)

I get the error message "trace file server daemon has
denied your request.  Check the trcfiled logfile on
'DRAX11' (ip) at port 2297 for details.

I'd be most grateful for any ideas.

Thanks!!
Barb




__
Do you Yahoo!?
SBC Yahoo! DSL - Now only $29.95 per month!
http://sbc.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Barbara Baker
  INET: [EMAIL PROTECTED]

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

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

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

RE: Do Not Call

[Rich Holland]

I think the backend is probably just /dev/null.  It's much faster than
Oracle, and requires a lot less space to store those 10,000,000 phone
numbers!  Besides, then they don't have any pesky follow-up issues.
"You registered?  Sorry, we don't have a record of that... Please
register again..."
--
Rich Holland(913) 645-1950SAP Technical Consultant
print unpack("u","92G5S\=\"!A;F]T:&5R(\'!Ehttp://www.orafaq.net
-- 
Author: Rich Holland
  INET: [EMAIL PROTECTED]

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

RE: LISTENER ON LINUX

[Rich Holland]

Try 'lsof -i |egrep "(TCP|UDP)" to see what's got the address bound.
Lsof is a freely available tool that should be installed on all unix
boxes, IMHO.  :-)
-- 
Rich Holland(913) 645-1950SAP Technical Consultant
print unpack("u","92G5S\=\"!A;F]T:&5R(\'!E -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On 
> Behalf Of Seema Singh
> Sent: Wednesday, July 02, 2003 2:36 PM
> To: Multiple recipients of list ORACLE-L
> Subject: LISTENER ON LINUX
> 
> 
> Hi,
> When I am trying to start listener on Linux box ,getting error
> TNS-12542: TNS:address already in use
> TNS-12560: TNS:protocol adapter error
>   TNS-00512: Address already in use
>Linux Error: 98: Address already in use
> I checked no process fro listener and no port used by another 
> process. Let me know how to fix that pl thx -Seema
> 
> _
> Help STOP SPAM with the new MSN 8 and get 2 months FREE*  
> http://join.msn.com/?page=features/junkmail
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: Seema Singh
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 
> and in the message BODY, include a line containing: UNSUB 
> ORACLE-L (or the name of mailing list you want to be removed 
> from).  You may also send the HELP command for other 
> information (like subscribing).
> 

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

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

Re: Oracle security question

[Guang Mei]

select * from all_users;

to get all users, then change their oracle passwords so that no body can
log in except you. This way you know you are the only one who can change
the data. Next step is see what application can make the data change.


Hope this helps.

Guang




On Fri, 11 Jul 2003, Don Yu wrote:

> Dennis
>
> Thank you very much. My data in that database is changed three times. The first
> is whole data being delete. The second is over ten thousands records being
> added. The third is whole data related to a month being deleted. I know my
> working environment is very complicated. For this report application, I write
> shell scripts and C/C++ program to parsing Apache web server access log file
> (www.welch.jhu.edu) in order to get client ip, access date, and host ip, which
> are associated with the special pattern as "ntlinktrack.cgi", which is
> associated with Library E-Book,E-Journal, and E-database. Then I need to
> schedule a solaris cron job to process access log daily and load parsed data
> into database. Also I create some log files for saving intermediate information
> from my program. Then I create some ColdFusion pages to post these results into
> website. In my database there are over million records. Oracle DBA is new duty
> for me since I had found that my data was missing. This is the  reason I post my
> question on Oracle user group. Now I am trying to read as much as I can but I do
> not have much time. I want to make sure my database is secure as early as I can.
> So what do you think of my reason?
> Thank you very much!
>
>
> Don
>
>
> DENNIS WILLIAMS wrote:
>
> > Don
> > SYS is the owner of the Oracle dictionary tables. It is a username with
> > DBA privilege, so someone who logs in can change data. If you have changed
> > its password, then you are assured that nobody is using that username right
> > now. If you've changed its password, then I wouldn't worry about it right
> > now.
> > Since it sounds as if you are the only person that accesses this
> > database, then you may want to change the username that owns your tables.
> > Hopefully this username is not SYSTEM or SYS.
> > After that, unless you know of other usernames someone might use to
> > access your Oracle database, don't make any more security changes for
> > awhile. Go back to trying to figure out why your data is changing without
> > your changing it. It may well be there is an innocent reason that has
> > nothing to do with someone else. I've had that happen to me when I've
> > started using an unfamiliar system.
> > And don't forget to buy a good Oracle DBA book like the one I suggested.
> >
> > Dennis Williams
> > DBA, 80%OCP, 100% DBA
> > Lifetouch, Inc.
> > [EMAIL PROTECTED]
> >
> >
> >
> > -Original Message-
> > Sent: Friday, July 11, 2003 3:49 PM
> > To: Multiple recipients of list ORACLE-L
> >
> > Dennis:
> >
> > Thanks for your message. Now I have changed sys password by the following
> > command:
> > alter user sys identified by xxx
> > But when I try to login from sql plus window by using sys, I cannot
> > successfully
> > login. Also I get an error message. The message is something like
> > "connection to
> > sys should be as sysdba or sysoper". So my question is what sys for?
> > Thank you very much!
> >
> > Don
> >
> > DENNIS WILLIAMS wrote:
> >
> > > Don
> > >If only you can make updates to your Oracle database, then you must
> > enter
> > > all the data ;-)
> > >From the tone of your posting, I'm going to assume that you are pretty
> > > new to Oracle. You may want to get a good basic administration book like
> > > Oracle9i DBA 101.
> > >
> > http://www.amazon.com/exec/obidos/tg/detail/-/0072224746/qid=1057949734/sr=8
> > > -1/ref=sr_8_1/104-2287688-5574335?v=glance&s=books&n=507846
> > > It is also a good idea to always mention your Oracle version and platform
> > > (Unix, NT, etc.) in your posts.
> > > First, log in with the SYSTEM username. Then change the password for
> > SYSTEM
> > > and SYS with the command:
> > > ALTER USER SYSTEM IDENTIFIED BY x;
> > > Where x is your new password.
> > > You should be able to make these changes without affecting any end users.
> > > Next you should identify your groups of users and how they access Oracle.
> > > Basically you need to identify what their access requirements are and then
> > > audit the usernames they use to ensure the privileges granted are just
> > what
> > > is required. This is also a good time to see about changing passwords, but
> > > first buy the book and read up on the basics of Oracle security.
> > >
> > > Dennis Williams
> > > DBA, 80%OCP, 100% DBA
> > > Lifetouch, Inc.
> > > [EMAIL PROTECTED]
> > >
> > > -Original Message-
> > > Sent: Friday, July 11, 2003 2:45 PM
> > > To: Multiple recipients of list ORACLE-L
> > >
> > > Hi,
> > >
> > > I have a security question about Oracle database. Recently I have taken
> > > full control an Oracle database in my department. Now I would l

Re: Security, private vs. public synonyms and contention data di

[Jared Still]

And put it in a trigger in case the schema must be changed
or duplicated.

Or just to work around duhvelopers.

Jared

On Friday 11 July 2003 14:19, Tanel Poder wrote:
> RE: Security, private vs. public synonyms and contention data dictionaryA
> lot of people have posted messages like: "I have several applications in my
> DB, but I can't create new public synonyms for my new app, because public
> synonym with that name already exists!". So, this should be one major
> reason why not to use public synonyms,
>
> But yes, check ixora, there is a very good explanation about impact of
> synonyms. Generally, public synonums are worst performance wise, private
> synonyms aren't that good either, referencing to tables directly in your
> SQL would be the fastest way (talking about parsing speed). Since from
> developers point of view hardcoding the schema names would be quite bad,
> there's an alternate solution of not hardcoding schema names to SQL, but
> using alter session set currecnt_schema in your application to set which
> schema should be used (of course in multi-schema environments you won't get
> away with that easily).
>
> Tanel.
>
>   - Original Message -
>   From: Stephane Paquette
>   To: Multiple recipients of list ORACLE-L
>   Sent: Friday, July 11, 2003 10:49 PM
>   Subject: RE: Security, private vs. public synonyms and contention data di
>
>
>   I think I remember Steve Adams posting something about performance and
> public synonyms, you may want to check its web site www.ixora.com.au
>
>   Stephane Paquette
>   Administrateur de bases de donnees
>
>   Database Administrator
>
>   Standard Life
>
>   www.standardlife.ca
>
>   Tel. (514) 499-7999 7470 and (514) 925-7187
>
>   [EMAIL PROTECTED]
>
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of
> [EMAIL PROTECTED] Sent: Friday, July 11, 2003 3:35 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: Security, private vs. public synonyms and contention data
> di
>
>
> Question:
>
> Are private versus public synonyms preferred for security?
> Are private syn. worse administration?
> Do 1,000 users with private syn. cause data dictionary contention?

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

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

Re: RE: utl_file on Redhat Linux Oracle 9 standard engine

[Jared Still]

On Wednesday 09 July 2003 09:59, Matthew Zito wrote:

> Plus the syntax is much more flexible (read: lazier) than C, so it saves
> time.  Interestingly enough, there are organizations that are starting
> to decide that the perl's syntactical flexibility is a negative - look
> at Yahoo's choice of PHP for its long-term application platform.  They
> said, among other things, that they were concerned about enforcing
> coding standards in a Perl environment.

Weenies.

Jared

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

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

Re: RE: full usefullness of CURRENT OF ???

[Jared Still]

On Friday 11 July 2003 13:19, [EMAIL PROTECTED] wrote:
> So while you are selecting data and before you update, the record could
> change. This means someone else could update it and youc ould update over
> it without knowing it. This is a bad idea in the database world and is
> known as 'disapearing updates'. So you lock the row when you select it. Not
> when the actual update is processed.

No, you don't lock a row when you select it.

There's no need for a read lock of a row in Oracle to maintain consistency. 
If Oracle can't produce a consistent row, it throws an ORA-1555.

Jared

>
> Updating inside of cursors is generally a bad idea. Its more code and its
> MUCH slower than a straight update statement. Ive seen some publications
> stating that it can before to do this way, but Ive tested every case I can
> think of and not once was it even close.
>
>
> what is the update statement you want to put inside the cursor?
>
> > From: MaryAnn Atkinson <[EMAIL PROTECTED]>
> > Date: 2003/07/11 Fri PM 04:09:25 EDT
> > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> > Subject: RE: full usefullness of CURRENT OF  ???
> >
> > --- Chris Stephens <[EMAIL PROTECTED]> wrote:
> > > Also, the CURRENT OF locks the table so that no one can modify (or
> > > even read) it while the transaction is taking place.  This guarantees
> > > nothing is  changing between retrieving values from the cursor and
> > > updating the table based on those values.
> >
> > OK, fair enough.
> >
> > > The second example has to run the update statement seperately.
> > > CURRENT OF can go directly to the row(s) affected.  CURRENT OF
> > > still has to modify each block header in the table to lock which
> > > is a small performance hit.
> >
> > So CURRENT OF has to lock, so its slower, right?
> > Does it have any advantages after all?
> >
> > >To prevent that you could update by rowid
> >
> > How? How can I update by ROWID? I was thinking to update
> > by PRIMARY_KEY...
> >
> > > and avoid the header updates.
> >
> > ... what "header" updates?
> >
> > thx
> > maa
> >
> > __
> > Do you Yahoo!?
> > SBC Yahoo! DSL - Now only $29.95 per month!
> > http://sbc.yahoo.com
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > --
> > Author: MaryAnn Atkinson
> >   INET: [EMAIL PROTECTED]
> >
> > Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> > San Diego, California-- Mailing list and web hosting services
> > -
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from).  You may
> > also send the HELP command for other information (like subscribing).

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

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

Fwd: Re: Sparky auth file

[Barbara Baker]

Well, what I actually thought you meant from your
first answer was to change the init file from a
logical to a hard-coded drive name, then that will
match the auth file.

Something I hadn't thought of until I read your
e-mail.

So you might have stumbled upon the answer after all.

Anyhow, I'm going to give it a shot!

Barb

--- Mladen Gogala <[EMAIL PROTECTED]> wrote:
> Date: Fri, 11 Jul 2003 16:04:24 -0800
> To: Multiple recipients of list ORACLE-L
> <[EMAIL PROTECTED]>
> From: Mladen Gogala <[EMAIL PROTECTED]>
> Subject: Re: Sparky auth file
> 
> Oooops! I haven't read the whole post before
> answering.
> Sorry, I blew it. 
> On 2003.07.11 19:34, Barbara Baker wrote:
> > Ok, this is a  REAL reach.
> > But does anyone out there know how to specify the
> dump
> > directory in the auth file for sparky
> >   ...  wait
> >   ...  I'm not there yet
> > on an OpenVMS system?
> > 
> > OpenVMS 7.2-1
> > Oracle 8.1.7.4
> > Perl 5.6.1
> > 
> > The background dump desitnation from v$parameter
> is
> > ORA_DUMP.  The system logical ORA_DUMP equates to
> > disk$dbtest11:[db_amdev.trace].
> > Sparky wants to append the trace name file to the
> end
> > of this.  I've tried both ORA_DUMP: and
> > disk$dbtest11:[db_amdev.trace] in the aut file.
> They
> > don't work.
> > 
> > if I use diskname:
> > 
> > Authorized directory
> 'disk$dbtest11:[DB_AMDEV.TRACE]':
> > 16 of 16 '*.trc' files are readable
> > Fri Jul 11 16:20:48 2003 REQ  10.39.8.253
> > version
> > Fri Jul 11 16:20:48 2003 ACK  10.39.8.253
> > 0 3.04
> > Fri Jul 11 16:21:30 2003 REQ  10.39.8.253
> > trcname 'ORA_DUMP', '20c02d0a', 'AMDEV', '16'
> > Fri Jul 11 16:21:30 2003 ACK  10.39.8.253
> > 1 not authorized to
> > read 'ORA_DUMP' (trcfiled.pl v3.04 line 536)
> > 
> > if I use ORA_DUMP
> > 
> > Fri Jul 11 16:18:34 2003 INFO
> >
>
spid('[.ORA_DUMP]drax11_amdev_fg_oracle_016.trc')='-1'
> > Fri Jul 11 16:18:34 2003 WSVR
> > can't read
> '[.ORA_DUMP]drax11_amdev_fg_oracle_017.trc'
> > (no such file or directory)
> > 
> > I get the error message "trace file server daemon
> has
> > denied your request.  Check the trcfiled logfile
> on
> > 'DRAX11' (ip) at port 2297 for details.
> > 
> > I'd be most grateful for any ideas.
> > 
> > Thanks!!
> > Barb
> > 
> > 
> > 
> > 
> > __
> > Do you Yahoo!?
> > SBC Yahoo! DSL - Now only $29.95 per month!
> > http://sbc.yahoo.com
> > --
> > Please see the official ORACLE-L FAQ:
> http://www.orafaq.net
> > --
> > Author: Barbara Baker
> >   INET: [EMAIL PROTECTED]
> > 
> > Fat City Network Services-- 858-538-5051
> http://www.fatcity.com
> > San Diego, California-- Mailing list and
> web hosting services
> >
>
-
> > To REMOVE yourself from this mailing list, send an
> E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of
> 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB
> ORACLE-L
> > (or the name of mailing list you want to be
> removed from).  You may
> > also send the HELP command for other information
> (like subscribing).
> > 
> 
> -- 
> Mladen Gogala
> Oracle DBA
> -- 
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.net
> -- 
> Author: Mladen Gogala
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051
> http://www.fatcity.com
> San Diego, California-- Mailing list and web
> hosting services
>
-
> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of
> 'ListGuru') and in
> the message BODY, include a line containing: UNSUB
> ORACLE-L
> (or the name of mailing list you want to be removed
> from).  You may
> also send the HELP command for other information
> (like subscribing).


__
Do you Yahoo!?
SBC Yahoo! DSL - Now only $29.95 per month!
http://sbc.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Barbara Baker
  INET: [EMAIL PROTECTED]

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

Re: [PMX:##] Re: cannot disable or drop the ON DATABASE trigger !

[Jared Still]

It's also in 8i.

Jared

On Friday 04 July 2003 11:29, Mladen Gogala wrote:
> Parameter to disable database triggers is:
>
> _system_trig_enabled = FALSE
>
> This is 9i parameter. Alternatively, if you start the database up in the
> "migrate" mode, system triggers will be disable ("startup migrate" is what
> you need)
>
> On 2003.07.04 10:54, "Jamadagni, Rajendra" wrote:
> > This will teach you that you should be _very_ careful when dealing with
> > sys schema.
> >
> > what's that parameter to disable sys triggers ??
> >
> > 1. Call OWS
> > 2. If this is production DB, keep your resume ready.
> >
> > Raj
> >
> > -Original Message-
> > Sent: Thursday, July 03, 2003 1:39 PM
> > To: Multiple recipients of list ORACLE-L
> > 
> >
> >
> > At first glance it appears that you have created a self referencing
> > trigger.
> >
> > You can't drop it, because dropping it fires the trigger.
> >
> > Check metalink, open a TAR, etc.
> >
> > Jared
> >
> >
> >
> >
> >
> > "rahul sharma" <[EMAIL PROTECTED]>
> > Sent by: [EMAIL PROTECTED]
> >  07/03/2003 03:40 AM
> >  Please respond to ORACLE-L
> >
> >
> > To: Multiple recipients of list ORACLE-L
> > <[EMAIL PROTECTED]> cc:
> > Subject:cannot disable or drop the ON DATABASE trigger
> > 
> >
> >
> > Help list... i have created the following in 8.1.5 instance
> >
> > CREATE OR REPLACE TRIGGER DDL_TRIGGER BEFORE
> > CREATE OR ALTER OR DROP ON DATABASE
> >
> > BEGIN
> > null;
> > END;
> > /
> >
> > and now i cannot drop or disable this trigger 
> >
> > ERROR at line 1:
> > ORA-04045: errors during recompilation/revalidation of SYS.DDL_TRIGGER
> >
> >
> > i'm loggin into svrmgrl and connecting as internal to try drop or
> > disable..
> > is this a bug ??
> >
> > TIA
> >
> > Rahul..
> >
> >
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > --
> > Author: rahul sharma
> >   INET: [EMAIL PROTECTED]
> >
> > Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> > San Diego, California-- Mailing list and web hosting services
> > -
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from).  You may
> > also send the HELP command for other information (like subscribing).
> >
> >
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > --
> > Author:
> >   INET: [EMAIL PROTECTED]
> >
> > Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> > San Diego, California-- Mailing list and web hosting services
> > -
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from).  You may
> > also send the HELP command for other information (like subscribing).
> >
> >
> > This
> > e-mail message is confidential, intended only for the named recipient(s)
> > above and may contain information that is privileged, attorney work
> > product or exempt from disclosure under applicable law. If you have
> > received this message in error, or are not the named recipient(s), please
> > immediately notify corporate MIS at (860) 766-2000 and delete this e-mail
> > message from your computer, Thank you.
> > *2

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

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

Re: RAC system Calls

[Mladen Gogala]

I've seen a problem with CLIC interface, which are, for some
reason, not used by oracle. It is a bug (Oxford is on HP-UX)
and there is a specific one-off patch. This was OPS, not RAC.
The symptoms are very similar: one of the processes was spinning
like crazy in the kernel mode. However, RAC != OPS and I don't have
any experience with RAC.


On 2003.07.11 20:24, Ravi Kulkarni wrote:
I have tested using cluster_interconnects parameter.
Oradebug IPC dump shows it chooses first IP correctly,
recognizes the 2nd interconnect, but with a wrong IP -
0.0.0.0. Looks like a bug.. Has anyone seen this
earlier?
(I understand there is a bug in HP with similar
behaviour - we are on Solaris)
SSKGXPT 0x3066b00 flags info for network 0
socket no 9 IP 164.22.21.1 UDP 61635
sflags SSKGXPT_UP
info for network 1
socket no 12IP 0.0.0.0  UDP 61636
sflags SSKGXPT_UP
Is there a workaround to make Oracle choose the
correct IP for the interconnect?
TIA,
Ravi.
--- "Jamadagni, Rajendra"
<[EMAIL PROTECTED]> wrote:
> Yup, we have 2 private interconnects and one public
> ... can't display the
> ips though ...
>
> Raj
>

> 
> Rajendra dot Jamadagni at nospamespn dot com
> All Views expressed in this email are strictly
> personal.
> QOTD: Any clod can have facts, having an opinion is
> an art !
>
>
> -Original Message-
> Sent: Friday, July 11, 2003 4:19 PM
> To: Multiple recipients of list ORACLE-L
>
>
> Do you use 1 or 2 interconnects? Does your oradebug
> ipc dump show both IPs? For me shows:
>
> SSKGXPT 0x3066b00 flags info for network 0
> socket no 9 IP 172.168.193.2 UDP 41143
> sflags SSKGXPT_UPinfo for network 1
> socket no 0 IP 0.0.0.0   UDP 0
> sflags SSKGXPT_DOWN
>
> Even 172.168.193.2 is not one of the (2) IPs we have
> for interconnect.
>
> Thanks,
> Ravi.
>
> --- "Jamadagni, Rajendra"
> <[EMAIL PROTECTED]> wrote:
> > We don't use cluster_interconnects (it is null)
> ...
> > but for us, the RAC is
> > using the fat private interconnects without any
> > problems.
> >
> > Raj
> >
>

> > 
> > Rajendra dot Jamadagni at nospamespn dot com
> > All Views expressed in this email are strictly
> > personal.
> > QOTD: Any clod can have facts, having an opinion
> is
> > an art !
> >
> >
> > -Original Message-
> > Sent: Friday, July 11, 2003 3:34 PM
> > To: Multiple recipients of list ORACLE-L
> >
> >
> > Correct. Looks like we need to configure
> > CLUSTER_INTERCONNECTS parameter. Automatic
> > configuration (Sun Cluster3.0/RAC) did not choose
> > the
> > (correct) IP(s) for interconnect. KG noticed it. I
> > have sent netstat -ai, oradebug IPC dump, ping -s
> > info
> > to him. If you are interested, I can paste it
> here.
> >
> > -Thanks,
> > Ravi.
> > >
>
This
> > e-mail message is confidential, intended only for
> > the named recipient(s) above and may contain
> > information that is privileged, attorney work
> > product or exempt from disclosure under applicable
> > law. If you have received this message in error,
> or
> > are not the named recipient(s), please immediately
> > notify corporate MIS at (860) 766-2000 and delete
> > this e-mail message from your computer, Thank
> >
>
you.*2
> >
>
>
> __
> Do you Yahoo!?
> SBC Yahoo! DSL - Now only $29.95 per month!
> http://sbc.yahoo.com
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.net
> --
> Author: Ravi Kulkarni
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- 858-538-5051
> http://www.fatcity.com
> San Diego, California-- Mailing list and web
> hosting services
>
-
> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of
> 'ListGuru') and in
> the message BODY, include a line containing: UNSUB
> ORACLE-L
> (or the name of mailing list you want to be removed
> from).  You may
> also send the HELP command for other information
> (like subscribing).
>
> >
This
> e-mail message is confidential, intended only for
> the named recipient(s) above and may contain
> information that is privileged, attorney work
> product or exempt from disclosure under applicable
> law. If you have received this message in error, or
> are not the named recipient(s), please immediately
> notify corporate MIS at (860) 766-2000 and delete
> this e-mail message from your computer, Thank
>
you.*2
>
__
Do you Yahoo!?
SBC Yahoo! D

RE: RAC system Calls

[Ravi Kulkarni]

I have tested using cluster_interconnects parameter.
Oradebug IPC dump shows it chooses first IP correctly,
recognizes the 2nd interconnect, but with a wrong IP -
0.0.0.0. Looks like a bug.. Has anyone seen this
earlier? 
(I understand there is a bug in HP with similar
behaviour - we are on Solaris)

SSKGXPT 0x3066b00 flags info for network 0
socket no 9 IP 164.22.21.1 UDP 61635
sflags SSKGXPT_UP
info for network 1
socket no 12IP 0.0.0.0  UDP 61636
sflags SSKGXPT_UP

Is there a workaround to make Oracle choose the
correct IP for the interconnect?

TIA,
Ravi.


--- "Jamadagni, Rajendra"
<[EMAIL PROTECTED]> wrote:
> Yup, we have 2 private interconnects and one public
> ... can't display the
> ips though ...
> 
> Raj
>

> 
> Rajendra dot Jamadagni at nospamespn dot com
> All Views expressed in this email are strictly
> personal.
> QOTD: Any clod can have facts, having an opinion is
> an art !
> 
> 
> -Original Message-
> Sent: Friday, July 11, 2003 4:19 PM
> To: Multiple recipients of list ORACLE-L
> 
> 
> Do you use 1 or 2 interconnects? Does your oradebug
> ipc dump show both IPs? For me shows:
> 
> SSKGXPT 0x3066b00 flags info for network 0
> socket no 9 IP 172.168.193.2 UDP 41143
> sflags SSKGXPT_UPinfo for network 1
> socket no 0 IP 0.0.0.0   UDP 0
> sflags SSKGXPT_DOWN
> 
> Even 172.168.193.2 is not one of the (2) IPs we have
> for interconnect.
> 
> Thanks,
> Ravi.
> 
> --- "Jamadagni, Rajendra"
> <[EMAIL PROTECTED]> wrote:
> > We don't use cluster_interconnects (it is null)
> ...
> > but for us, the RAC is
> > using the fat private interconnects without any
> > problems.
> > 
> > Raj
> >
>

> > 
> > Rajendra dot Jamadagni at nospamespn dot com
> > All Views expressed in this email are strictly
> > personal.
> > QOTD: Any clod can have facts, having an opinion
> is
> > an art !
> > 
> > 
> > -Original Message-
> > Sent: Friday, July 11, 2003 3:34 PM
> > To: Multiple recipients of list ORACLE-L
> > 
> > 
> > Correct. Looks like we need to configure
> > CLUSTER_INTERCONNECTS parameter. Automatic
> > configuration (Sun Cluster3.0/RAC) did not choose
> > the
> > (correct) IP(s) for interconnect. KG noticed it. I
> > have sent netstat -ai, oradebug IPC dump, ping -s
> > info
> > to him. If you are interested, I can paste it
> here.
> > 
> > -Thanks,
> > Ravi.
> > >
>
This
> > e-mail message is confidential, intended only for
> > the named recipient(s) above and may contain
> > information that is privileged, attorney work
> > product or exempt from disclosure under applicable
> > law. If you have received this message in error,
> or
> > are not the named recipient(s), please immediately
> > notify corporate MIS at (860) 766-2000 and delete
> > this e-mail message from your computer, Thank
> >
>
you.*2
> > 
> 
> 
> __
> Do you Yahoo!?
> SBC Yahoo! DSL - Now only $29.95 per month!
> http://sbc.yahoo.com
> -- 
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.net
> -- 
> Author: Ravi Kulkarni
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051
> http://www.fatcity.com
> San Diego, California-- Mailing list and web
> hosting services
>
-
> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of
> 'ListGuru') and in
> the message BODY, include a line containing: UNSUB
> ORACLE-L
> (or the name of mailing list you want to be removed
> from).  You may
> also send the HELP command for other information
> (like subscribing).
> 
> >
This
> e-mail message is confidential, intended only for
> the named recipient(s) above and may contain
> information that is privileged, attorney work
> product or exempt from disclosure under applicable
> law. If you have received this message in error, or
> are not the named recipient(s), please immediately
> notify corporate MIS at (860) 766-2000 and delete
> this e-mail message from your computer, Thank
>
you.*2
> 


__
Do you Yahoo!?
SBC Yahoo! DSL - Now only $29.95 per month!
http://sbc.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Ravi Kulkarni
  INET: [EMAIL PROTECTED]

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

Re: Sparky auth file

[Mladen Gogala]

Oooops! I haven't read the whole post before answering.
Sorry, I blew it. 
On 2003.07.11 19:34, Barbara Baker wrote:
Ok, this is a  REAL reach.
But does anyone out there know how to specify the dump
directory in the auth file for sparky
  ...  wait
  ...  I'm not there yet
on an OpenVMS system?
OpenVMS 7.2-1
Oracle 8.1.7.4
Perl 5.6.1
The background dump desitnation from v$parameter is
ORA_DUMP.  The system logical ORA_DUMP equates to
disk$dbtest11:[db_amdev.trace].
Sparky wants to append the trace name file to the end
of this.  I've tried both ORA_DUMP: and
disk$dbtest11:[db_amdev.trace] in the aut file. They
don't work.
if I use diskname:

Authorized directory 'disk$dbtest11:[DB_AMDEV.TRACE]':
16 of 16 '*.trc' files are readable
Fri Jul 11 16:20:48 2003 REQ  10.39.8.253
version
Fri Jul 11 16:20:48 2003 ACK  10.39.8.253
0 3.04
Fri Jul 11 16:21:30 2003 REQ  10.39.8.253
trcname 'ORA_DUMP', '20c02d0a', 'AMDEV', '16'
Fri Jul 11 16:21:30 2003 ACK  10.39.8.253
1 not authorized to
read 'ORA_DUMP' (trcfiled.pl v3.04 line 536)
if I use ORA_DUMP

Fri Jul 11 16:18:34 2003 INFO
spid('[.ORA_DUMP]drax11_amdev_fg_oracle_016.trc')='-1'
Fri Jul 11 16:18:34 2003 WSVR
can't read '[.ORA_DUMP]drax11_amdev_fg_oracle_017.trc'
(no such file or directory)
I get the error message "trace file server daemon has
denied your request.  Check the trcfiled logfile on
'DRAX11' (ip) at port 2297 for details.
I'd be most grateful for any ideas.

Thanks!!
Barb


__
Do you Yahoo!?
SBC Yahoo! DSL - Now only $29.95 per month!
http://sbc.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Barbara Baker
  INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
--
Mladen Gogala
Oracle DBA
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Mladen Gogala
 INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: Sparky auth file

[Mladen Gogala]

user_dump_dest=dua3:[oracle.admin.SID.udump]
You can use whatever device sou have instead of "dua3". My last
VMS experience was in 1995, with OpenVMS 5.5-2, on a VAX 4400, so
it might be just a little bit rusty. Allegedly, there is a wonderful
new OS, created by David Cutler, the creator of VMS 5, that is easier to
master. Given the financial might of the company which is selling it,
I wouldn't quite dismiss the claim that the whole world will be running it
very soon. 

On 2003.07.11 19:34, Barbara Baker wrote:
Ok, this is a  REAL reach.
But does anyone out there know how to specify the dump
directory in the auth file for sparky
  ...  wait
  ...  I'm not there yet
on an OpenVMS system?
OpenVMS 7.2-1
Oracle 8.1.7.4
Perl 5.6.1
The background dump desitnation from v$parameter is
ORA_DUMP.  The system logical ORA_DUMP equates to
disk$dbtest11:[db_amdev.trace].
Sparky wants to append the trace name file to the end
of this.  I've tried both ORA_DUMP: and
disk$dbtest11:[db_amdev.trace] in the aut file. They
don't work.
if I use diskname:

Authorized directory 'disk$dbtest11:[DB_AMDEV.TRACE]':
16 of 16 '*.trc' files are readable
Fri Jul 11 16:20:48 2003 REQ  10.39.8.253
version
Fri Jul 11 16:20:48 2003 ACK  10.39.8.253
0 3.04
Fri Jul 11 16:21:30 2003 REQ  10.39.8.253
trcname 'ORA_DUMP', '20c02d0a', 'AMDEV', '16'
Fri Jul 11 16:21:30 2003 ACK  10.39.8.253
1 not authorized to
read 'ORA_DUMP' (trcfiled.pl v3.04 line 536)
if I use ORA_DUMP

Fri Jul 11 16:18:34 2003 INFO
spid('[.ORA_DUMP]drax11_amdev_fg_oracle_016.trc')='-1'
Fri Jul 11 16:18:34 2003 WSVR
can't read '[.ORA_DUMP]drax11_amdev_fg_oracle_017.trc'
(no such file or directory)
I get the error message "trace file server daemon has
denied your request.  Check the trcfiled logfile on
'DRAX11' (ip) at port 2297 for details.
I'd be most grateful for any ideas.

Thanks!!
Barb


__
Do you Yahoo!?
SBC Yahoo! DSL - Now only $29.95 per month!
http://sbc.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Barbara Baker
  INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
--
Mladen Gogala
Oracle DBA
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Mladen Gogala
 INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: walked around: 8.1.7.4 doesn't take stirped raw LVs for redo and

[Mladen Gogala]

Looks like you have a 32-bit version of oracle. 4GB is a typical number
to hit.
On 2003.07.11 16:59, Jessica Mao wrote:
maybe nobody cares. but anyway, more experiments show as long as striped raw
LV is bigger than 4092MB (4K block size), oracle datafile size could only be
several MB or something, not even close to 1000MB. seems like there's some
kind of overflow here.
problem went away after loaded 9.2.0.3.
again there was no problem w/ 8.1.7.0 either.
so i think there's a bug in 8.1.7.4.
-Original Message-
Sent: Thursday, July 10, 2003 1:45 PM
To: Multiple recipients of list ORACLE-L
HPUX
can anyone please help?

errors like below when any of the redo or rollback raw LVs are created using
stripe:
CREATE TABLESPACE RBS DATAFILE '/dev/vgrbs/rrbs01.dbf' SIZE 8000M REUSE
AUTOEXTEND OFF MINIMUM EXTENT 512K DEFAULT STORAGE ( INITIAL 512K NEXT 512K
MINEXTENTS 8 MAXEXTENTS UNLIMITED )
*
ORA-01119: error in creating database file '/dev/vgrbs/rrbs01.dbf'
ORA-27042: not enough space on raw partition to fullfill request
Additional information: 2
same statement got processed when LVs were recreated w/o stripe. didn't
change size settings.
8.1.7.0 did take striped raw LVs for redo and rollback.
user tablespaces can ALWAYS be created using striped raw LVs.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Jessica Mao
  INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Jessica Mao
  INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
--
Mladen Gogala
Oracle DBA
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Mladen Gogala
 INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Sparky auth file

[Barbara Baker]

Ok, this is a  REAL reach.
But does anyone out there know how to specify the dump
directory in the auth file for sparky
  ...  wait
  ...  I'm not there yet
on an OpenVMS system?

OpenVMS 7.2-1
Oracle 8.1.7.4
Perl 5.6.1

The background dump desitnation from v$parameter is
ORA_DUMP.  The system logical ORA_DUMP equates to
disk$dbtest11:[db_amdev.trace].
Sparky wants to append the trace name file to the end
of this.  I've tried both ORA_DUMP: and
disk$dbtest11:[db_amdev.trace] in the aut file. They
don't work.

if I use diskname:

Authorized directory 'disk$dbtest11:[DB_AMDEV.TRACE]':
16 of 16 '*.trc' files are readable
Fri Jul 11 16:20:48 2003 REQ  10.39.8.253
version
Fri Jul 11 16:20:48 2003 ACK  10.39.8.253
0 3.04
Fri Jul 11 16:21:30 2003 REQ  10.39.8.253
trcname 'ORA_DUMP', '20c02d0a', 'AMDEV', '16'
Fri Jul 11 16:21:30 2003 ACK  10.39.8.253
1 not authorized to
read 'ORA_DUMP' (trcfiled.pl v3.04 line 536)

if I use ORA_DUMP

Fri Jul 11 16:18:34 2003 INFO
spid('[.ORA_DUMP]drax11_amdev_fg_oracle_016.trc')='-1'
Fri Jul 11 16:18:34 2003 WSVR
can't read '[.ORA_DUMP]drax11_amdev_fg_oracle_017.trc'
(no such file or directory)

I get the error message "trace file server daemon has
denied your request.  Check the trcfiled logfile on
'DRAX11' (ip) at port 2297 for details.

I'd be most grateful for any ideas.

Thanks!!
Barb




__
Do you Yahoo!?
SBC Yahoo! DSL - Now only $29.95 per month!
http://sbc.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Barbara Baker
  INET: [EMAIL PROTECTED]

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

Re: Unique constraint violation question.

[Mladen Gogala]

Well, DBMS_RTFM package is a package on double secret probation,
accessible only to people who ask questions like "how to get records which 
have the same unique key as a record that I'm trying to insert".
I usually pull out references like that when Jupiter is in the 7th house and 
Venus lines up with Mars or, alternatively, when the weather is humid,
I'm suffering from alergies and I encounter a question like the one above.

On 2003.07.11 10:21, Ron Rogers wrote:
Mladen,
 I looked through all of the manuals and online with a google search
for the "dbms_rtfm.database_concepts" and was not able to find it. Would
you please ,PLEASE, PAAALLLEEEASE list your references?  YEA RIGHT.
I like to review the web sites for potential openings when I read some
of the questions . The answers are also thought provoking with a tongue
in cheek approach.
Ron mª¿ªm
>>> [EMAIL PROTECTED] 07/11/03 12:44AM >>>
There is a way, but you have to master the Tao first. When you
do, you will not ask questions like that. Short of that,
you could try selecting the record(s) from the table which
have the same unique key as the record you're trying to insert.
Truncate table will also rid you of the problems with duplicate
keys.
begin
dbms_rtfm.database_concepts;
end;
/


On 2003.07.11 00:29, [EMAIL PROTECTED] wrote:
> Hi, All,
>
> When an unique constraint is violated, is there any way to know which
record
> cause this problem?
>
> TIA,
>
> Chuan
> Important: This transmission is intended only for the use of the
addressee
> and may contain confidential or legally privileged information.  If
you are
> not the intended recipient, you are notified that any use or
dissemination
> of this communication is strictly prohibited.  If you receive this
> transmission in error please notify the author immediately by
telephone and
> delete all copies of this transmission together with any
attachments.
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author:
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting
services
>
-
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
>
--
Mladen Gogala
Oracle DBA
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Mladen Gogala
  INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Ron Rogers
  INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
--
Mladen Gogala
Oracle DBA
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Mladen Gogala
 INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: installed users

[Jacques Kilchoer]

ctxsys - intermedia text (the old Context text cartridge)
ordsys - intermedia data types for storing of audio and video data
mdsys - data types for storing of spatial data

I think that in 9.0 and 9.2, by default those users are created with expired and 
locked logins.

> -Original Message-
> From: Rachel Carmichael [mailto:[EMAIL PROTECTED]
> 
> I've started a project to review all users in all our databases and
> remove unused/unnecessary users or at the very least restrict the
> privileges they have to the minimal ones they need. In several of the
> databases there are both ORDSYS and CTXSYS. From what I've 
> been able to
> find out by running the above procedures, ORDSYS is for Intermedia. I
> could have sworn CTXSYS was the Intermedia account. So... is there a
> manual I've missed that tells me exactly which of these two I have to
> have in my databases and why?
> 
> In addition, I know you have to install Spatial Option as part of an
> Oracle installation, even if you don't want to use it. Some of these
> databases also have the account MDSYS, some don't. All but one are
> 9iR2. We don't use Spatial. The two databases that have this account
> (8.1.7.4 and 9.2.0.2) both use Intermedia. Does that have something to
> do with it? I don't want to remove an account I need, but I don't want
> to leave ones I don't need in the databases.
> 
> Let's not even begin to talk about the fact that just about EVERY user
> seems to have "unlimited tablespace" priv. 
> 
> This is not going to be pretty, easy or clean. But I will have secure
> databases. Except of course, every app has a configuration file in
> which they hard-code the passwords. Sigh
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jacques Kilchoer
  INET: [EMAIL PROTECTED]

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

RE: Oracle security question

[Jacques Kilchoer]

In addition to what Dennis said:
if Orace init parameter O7_DICTIONARY_ACCESSIBILITY = FALSE (the default in 9.0 and 
9.2)
then to connect as user SYS you need to specify the connect string like this:
connect SYS/password AS SYSDBA

The reason the user SYS is more protected than the user SYSTEM is because:
a) the user SYS is the owner of the data dictionary - the set of tables that are used 
by Oracle to store internal information about the objects in the database;
b) the user SYS is the one you use for tasks such as starting up or shutting down the 
database.

SYSTEM is s DBA user created along with the database.

In general, you should do the following:
only sign on as SYS to startup and shutdown the database, or for recovery.
create another DBA user and sign on as that other user for any DBA tasks.
I hardly ever use the SYSTEM account except for creation of some Oracle-related 
objects (like a public PLAN_TABLE or the PRODUCT_USER_PROFILE table.)

> -Original Message-
> From: Don Yu [mailto:[EMAIL PROTECTED]
> Sent: vendredi, 11. juillet 2003 13:49
> To: Multiple recipients of list ORACLE-L
> Subject: Re: Oracle security question
> 
> 
> Dennis:
> 
> Thanks for your message. Now I have changed sys password by 
> the following
> command:
> alter user sys identified by xxx
> But when I try to login from sql plus window by using sys, I 
> cannot successfully
> login. Also I get an error message. The message is something 
> like "connection to
> sys should be as sysdba or sysoper". So my question is what sys for?
> Thank you very much!
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jacques Kilchoer
  INET: [EMAIL PROTECTED]

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

RE: Recommended Init File for Standby

[Kevin Lange]

Thanks Dennis.  THat is what I have been doing .   Guess I will continue.

Kevin

-Original Message-
Sent: Friday, July 11, 2003 5:09 PM
To: Multiple recipients of list ORACLE-L


Kevin
   Sounds like a trial-and-error to me. Someone else's settings probably
wouldn't help you because maybe they only have 12 standby databases. My
guess is that your objective is to minimize the memory usage. Some thoughts:
  - Try reducing the settings until the database won't run, or fails
frequently enough to be annoying (like 4031 errors).
  - Monitor how far behind production the standby lags.
  - Too much reduction may be self-defeating. For example, making
DB_BLOCK_BUFFERS too small might cause the same blocks to be continually
reloaded, increasing I/O.
This sounds like most DBA work - make a pass or two at it, then move on to
the next fire.

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


-Original Message-
Sent: Friday, July 11, 2003 4:35 PM
To: Multiple recipients of list ORACLE-L


 I knew I would be providing more information.

1. Other standby databases (14).
2. Disaster Recovery.  Automatic process applying logs only.
3. Bare essentials.  When/If we have to turn to it we will replace the init
file with the production init file.

I am looking for exactly what you said.  A bare essential init file.  

-Original Message-
Sent: Friday, July 11, 2003 4:19 PM
To: Multiple recipients of list ORACLE-L


Hi Kevin,

I guess all I have is more questions:

1) What else do you have running on the server that has your standby
database?

2) What is the purpose of the standby database (disaster recovery or
reporting)?

3) If it is for disaster recovery, shouldn't the settings 
on the standby reflect the settings for your non standby database or are you
looking at handling bare essentials and not your normal capacity?

Maybe some of the answers to these questions will help answer your question
to the settings.

Bryan Rodrigues


-Original Message-
Sent: Friday, July 11, 2003 3:55 PM
To: Multiple recipients of list ORACLE-L


Evening folks;
  Does anyone happen to have any recommended init file settings for a
standby database ??

We are running Oracle 8.1.7.4 on a Solaris system.  I think that we may have
the settings on the standbys too high and are therefore wasting resources.

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

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

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

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

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

Re: Oracle security question

[Don Yu]

Dennis

Thank you very much. My data in that database is changed three times. The first
is whole data being delete. The second is over ten thousands records being
added. The third is whole data related to a month being deleted. I know my
working environment is very complicated. For this report application, I write
shell scripts and C/C++ program to parsing Apache web server access log file
(www.welch.jhu.edu) in order to get client ip, access date, and host ip, which
are associated with the special pattern as "ntlinktrack.cgi", which is
associated with Library E-Book,E-Journal, and E-database. Then I need to
schedule a solaris cron job to process access log daily and load parsed data
into database. Also I create some log files for saving intermediate information
from my program. Then I create some ColdFusion pages to post these results into
website. In my database there are over million records. Oracle DBA is new duty
for me since I had found that my data was missing. This is the  reason I post my
question on Oracle user group. Now I am trying to read as much as I can but I do
not have much time. I want to make sure my database is secure as early as I can.
So what do you think of my reason?
Thank you very much!


Don


DENNIS WILLIAMS wrote:

> Don
> SYS is the owner of the Oracle dictionary tables. It is a username with
> DBA privilege, so someone who logs in can change data. If you have changed
> its password, then you are assured that nobody is using that username right
> now. If you've changed its password, then I wouldn't worry about it right
> now.
> Since it sounds as if you are the only person that accesses this
> database, then you may want to change the username that owns your tables.
> Hopefully this username is not SYSTEM or SYS.
> After that, unless you know of other usernames someone might use to
> access your Oracle database, don't make any more security changes for
> awhile. Go back to trying to figure out why your data is changing without
> your changing it. It may well be there is an innocent reason that has
> nothing to do with someone else. I've had that happen to me when I've
> started using an unfamiliar system.
> And don't forget to buy a good Oracle DBA book like the one I suggested.
>
> Dennis Williams
> DBA, 80%OCP, 100% DBA
> Lifetouch, Inc.
> [EMAIL PROTECTED]
>
>
>
> -Original Message-
> Sent: Friday, July 11, 2003 3:49 PM
> To: Multiple recipients of list ORACLE-L
>
> Dennis:
>
> Thanks for your message. Now I have changed sys password by the following
> command:
> alter user sys identified by xxx
> But when I try to login from sql plus window by using sys, I cannot
> successfully
> login. Also I get an error message. The message is something like
> "connection to
> sys should be as sysdba or sysoper". So my question is what sys for?
> Thank you very much!
>
> Don
>
> DENNIS WILLIAMS wrote:
>
> > Don
> >If only you can make updates to your Oracle database, then you must
> enter
> > all the data ;-)
> >From the tone of your posting, I'm going to assume that you are pretty
> > new to Oracle. You may want to get a good basic administration book like
> > Oracle9i DBA 101.
> >
> http://www.amazon.com/exec/obidos/tg/detail/-/0072224746/qid=1057949734/sr=8
> > -1/ref=sr_8_1/104-2287688-5574335?v=glance&s=books&n=507846
> > It is also a good idea to always mention your Oracle version and platform
> > (Unix, NT, etc.) in your posts.
> > First, log in with the SYSTEM username. Then change the password for
> SYSTEM
> > and SYS with the command:
> > ALTER USER SYSTEM IDENTIFIED BY x;
> > Where x is your new password.
> > You should be able to make these changes without affecting any end users.
> > Next you should identify your groups of users and how they access Oracle.
> > Basically you need to identify what their access requirements are and then
> > audit the usernames they use to ensure the privileges granted are just
> what
> > is required. This is also a good time to see about changing passwords, but
> > first buy the book and read up on the basics of Oracle security.
> >
> > Dennis Williams
> > DBA, 80%OCP, 100% DBA
> > Lifetouch, Inc.
> > [EMAIL PROTECTED]
> >
> > -Original Message-
> > Sent: Friday, July 11, 2003 2:45 PM
> > To: Multiple recipients of list ORACLE-L
> >
> > Hi,
> >
> > I have a security question about Oracle database. Recently I have taken
> > full control an Oracle database in my department. Now I would like to
> > make sure that no other people except myself can update data in that
> > database. Can somebody tell me what it is necessary steps to do that?
> > Any comments are highly appreciated. Thanks!
> >
> > Don
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > --
> > Author: Don Yu
> >   INET: [EMAIL PROTECTED]
> >
> > Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> > San Diego, California-- Mailing list and web hosting services
> > --

RE: Recommended Init File for Standby

[DENNIS WILLIAMS]

Kevin
   Sounds like a trial-and-error to me. Someone else's settings probably
wouldn't help you because maybe they only have 12 standby databases. My
guess is that your objective is to minimize the memory usage. Some thoughts:
  - Try reducing the settings until the database won't run, or fails
frequently enough to be annoying (like 4031 errors).
  - Monitor how far behind production the standby lags.
  - Too much reduction may be self-defeating. For example, making
DB_BLOCK_BUFFERS too small might cause the same blocks to be continually
reloaded, increasing I/O.
This sounds like most DBA work - make a pass or two at it, then move on to
the next fire.

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


-Original Message-
Sent: Friday, July 11, 2003 4:35 PM
To: Multiple recipients of list ORACLE-L


 I knew I would be providing more information.

1. Other standby databases (14).
2. Disaster Recovery.  Automatic process applying logs only.
3. Bare essentials.  When/If we have to turn to it we will replace the init
file with the production init file.

I am looking for exactly what you said.  A bare essential init file.  

-Original Message-
Sent: Friday, July 11, 2003 4:19 PM
To: Multiple recipients of list ORACLE-L


Hi Kevin,

I guess all I have is more questions:

1) What else do you have running on the server that has your standby
database?

2) What is the purpose of the standby database (disaster recovery or
reporting)?

3) If it is for disaster recovery, shouldn't the settings 
on the standby reflect the settings for your non standby database or are you
looking at handling bare essentials and not your normal capacity?

Maybe some of the answers to these questions will help answer your question
to the settings.

Bryan Rodrigues


-Original Message-
Sent: Friday, July 11, 2003 3:55 PM
To: Multiple recipients of list ORACLE-L


Evening folks;
  Does anyone happen to have any recommended init file settings for a
standby database ??

We are running Oracle 8.1.7.4 on a Solaris system.  I think that we may have
the settings on the standbys too high and are therefore wasting resources.

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

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

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

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

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

Database benchmark

[DENNIS WILLIAMS]

The last published database benchmark was the one by eWeek over a year ago.
The following article provides some insights into why database benchmarking
is such a tricky business. 
http://www.eweek.com/article2/0,3959,1186144,00.asp

Since the benchmark showed great performance by Oracle, the article mainly
discusses why certain seemingly insignificant factors caused MS SQL and DB2
to perform poorly.

Dennis Williams
DBA, 80%OCP, 100% DBA
Lifetouch, Inc.
[EMAIL PROTECTED] 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: DENNIS WILLIAMS
  INET: [EMAIL PROTECTED]

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

RE: Recommended Init File for Standby

[Kevin Lange]

 I knew I would be providing more information.

1. Other standby databases (14).
2. Disaster Recovery.  Automatic process applying logs only.
3. Bare essentials.  When/If we have to turn to it we will replace the init
file with the production init file.

I am looking for exactly what you said.  A bare essential init file.  

-Original Message-
Sent: Friday, July 11, 2003 4:19 PM
To: Multiple recipients of list ORACLE-L


Hi Kevin,

I guess all I have is more questions:

1) What else do you have running on the server that has your standby
database?

2) What is the purpose of the standby database (disaster recovery or
reporting)?

3) If it is for disaster recovery, shouldn't the settings 
on the standby reflect the settings for your non standby database or are you
looking at handling bare essentials and not your normal capacity?

Maybe some of the answers to these questions will help answer your question
to the settings.

Bryan Rodrigues


-Original Message-
Sent: Friday, July 11, 2003 3:55 PM
To: Multiple recipients of list ORACLE-L


Evening folks;
  Does anyone happen to have any recommended init file settings for a
standby database ??

We are running Oracle 8.1.7.4 on a Solaris system.  I think that we may have
the settings on the standbys too high and are therefore wasting resources.

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

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

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

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

RE: Oracle security question

[DENNIS WILLIAMS]

Oops. I meant to say that you might consider changing the PASSWORD of the
username that owns your tables.

-Original Message-
Sent: Friday, July 11, 2003 4:14 PM
To: Multiple recipients of list ORACLE-L


Don 
SYS is the owner of the Oracle dictionary tables. It is a username with
DBA privilege, so someone who logs in can change data. If you have changed
its password, then you are assured that nobody is using that username right
now. If you've changed its password, then I wouldn't worry about it right
now. 
Since it sounds as if you are the only person that accesses this
database, then you may want to change the username that owns your tables.
Hopefully this username is not SYSTEM or SYS.
After that, unless you know of other usernames someone might use to
access your Oracle database, don't make any more security changes for
awhile. Go back to trying to figure out why your data is changing without
your changing it. It may well be there is an innocent reason that has
nothing to do with someone else. I've had that happen to me when I've
started using an unfamiliar system.
And don't forget to buy a good Oracle DBA book like the one I suggested.

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

 

-Original Message-
Sent: Friday, July 11, 2003 3:49 PM
To: Multiple recipients of list ORACLE-L


Dennis:

Thanks for your message. Now I have changed sys password by the following
command:
alter user sys identified by xxx
But when I try to login from sql plus window by using sys, I cannot
successfully
login. Also I get an error message. The message is something like
"connection to
sys should be as sysdba or sysoper". So my question is what sys for?
Thank you very much!


Don


DENNIS WILLIAMS wrote:

> Don
>If only you can make updates to your Oracle database, then you must
enter
> all the data ;-)
>From the tone of your posting, I'm going to assume that you are pretty
> new to Oracle. You may want to get a good basic administration book like
> Oracle9i DBA 101.
>
http://www.amazon.com/exec/obidos/tg/detail/-/0072224746/qid=1057949734/sr=8
> -1/ref=sr_8_1/104-2287688-5574335?v=glance&s=books&n=507846
> It is also a good idea to always mention your Oracle version and platform
> (Unix, NT, etc.) in your posts.
> First, log in with the SYSTEM username. Then change the password for
SYSTEM
> and SYS with the command:
> ALTER USER SYSTEM IDENTIFIED BY x;
> Where x is your new password.
> You should be able to make these changes without affecting any end users.
> Next you should identify your groups of users and how they access Oracle.
> Basically you need to identify what their access requirements are and then
> audit the usernames they use to ensure the privileges granted are just
what
> is required. This is also a good time to see about changing passwords, but
> first buy the book and read up on the basics of Oracle security.
>
> Dennis Williams
> DBA, 80%OCP, 100% DBA
> Lifetouch, Inc.
> [EMAIL PROTECTED]
>
> -Original Message-
> Sent: Friday, July 11, 2003 2:45 PM
> To: Multiple recipients of list ORACLE-L
>
> Hi,
>
> I have a security question about Oracle database. Recently I have taken
> full control an Oracle database in my department. Now I would like to
> make sure that no other people except myself can update data in that
> database. Can somebody tell me what it is necessary steps to do that?
> Any comments are highly appreciated. Thanks!
>
> Don
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Don Yu
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: DENNIS WILLIAMS
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).

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

Fat City Network Services-- 858-538-5051 ht

RE: Recommended Init File for Standby

[Rodrigues, Bryan]

Hi Kevin,

I guess all I have is more questions:

1) What else do you have running on the server that has your standby
database?

2) What is the purpose of the standby database (disaster recovery or
reporting)?

3) If it is for disaster recovery, shouldn't the settings 
on the standby reflect the settings for your non standby database or are you
looking at handling bare essentials and not your normal capacity?

Maybe some of the answers to these questions will help answer your question
to the settings.

Bryan Rodrigues


-Original Message-
Sent: Friday, July 11, 2003 3:55 PM
To: Multiple recipients of list ORACLE-L


Evening folks;
  Does anyone happen to have any recommended init file settings for a
standby database ??

We are running Oracle 8.1.7.4 on a Solaris system.  I think that we may have
the settings on the standbys too high and are therefore wasting resources.

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

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

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

Re: Security, private vs. public synonyms and contention data di

[Tanel Poder]

Title: RE: Security, private vs. public synonyms and contention data dictionary



A lot of people have posted messages like: "I have 
several applications in my DB, but I can't create new public synonyms for my new 
app, because public synonym with that name already exists!".
So, this should be one major reason why not to use 
public synonyms,
 
But yes, check ixora, there is a very good 
explanation about impact of synonyms.
Generally, public synonums are worst performance 
wise, private synonyms aren't that good either, referencing to tables directly 
in your SQL would be the fastest way (talking about parsing speed). Since from 
developers point of view hardcoding the schema names would be quite bad, there's 
an alternate solution of not hardcoding schema names to SQL, but using alter 
session set currecnt_schema in your application to set which schema should be 
used (of course in multi-schema environments you won't get away with that 
easily).
 
Tanel.
 

  - Original Message - 
  From: 
  Stephane Paquette 
  To: Multiple recipients of list ORACLE-L 
  
  Sent: Friday, July 11, 2003 10:49 
PM
  Subject: RE: Security, private vs. public 
  synonyms and contention data di
  
  I 
  think I remember Steve Adams posting something about performance and public 
  synonyms, you may want to check its web site www.ixora.com.au
   
  
  
  
  Stephane 
  Paquette
  Administrateur 
  de bases de donnees
  Database 
  Administrator
  Standard 
  Life
  www.standardlife.ca
  Tel. 
  (514) 499-7999 7470 and (514) 925-7187
  [EMAIL PROTECTED]
  
-Original Message-From: [EMAIL PROTECTED] 
[mailto:[EMAIL PROTECTED]On Behalf Of 
[EMAIL PROTECTED]Sent: Friday, July 11, 2003 3:35 
PMTo: Multiple recipients of list ORACLE-LSubject: RE: 
Security, private vs. public synonyms and contention data 
di
Question: 
Are private versus public synonyms preferred for 
security? Are private syn. worse 
administration? Do 1,000 users with private syn. 
cause data dictionary contention? 

Re: full usefullness of CURRENT OF ???

[Tanel Poder]

Hi!

> Actually, it is the FOR UPDATE that locks the table.

No, for update still locks *only the rows* selected with for update clause.
All other parts of table are available for both reading AND writing (of
course if other transactions don't have locks on some rows).
And you can read the whole table, despite any insert, delete, update or for
update clauses.

So, don't give false information here.

There's an exception (as usual), if you have set ROW_LOCKING init parameter
to INTENT, then the whole table is locked during update clauses. Also, you
can use lock table command to lock tables if needed, but this goes beyond
scope of this posting...

Tanel.


>
> >How? How can I update by ROWID? I was thinking to update
> >by PRIMARY_KEY...
>
> DECLARE
>
>CURSOR  EmpCursor  IS
>SELECT  rowid, 
>FROMEmp;
> BEGIN
>  FOR EmpRec IN EmpCursor LOOP
>  UPDATE EMP
>  SETSALARY = SALARY * 1.08
>  WHERE  rowid = EmpRec.rowid;
>  END LOOP;
> END;
>
> Kevin
> -Original Message-
> Sent: Friday, July 11, 2003 4:09 PM
> To: Multiple recipients of list ORACLE-L
>
>
> --- Chris Stephens <[EMAIL PROTECTED]> wrote:
> > Also, the CURRENT OF locks the table so that no one can modify (or
> > even read) it while the transaction is taking place.  This guarantees
> > nothing is  changing between retrieving values from the cursor and
> > updating the table based on those values.
>
> OK, fair enough.
>
>
> > The second example has to run the update statement seperately.
> > CURRENT OF can go directly to the row(s) affected.  CURRENT OF
> > still has to modify each block header in the table to lock which
> > is a small performance hit.
>
> So CURRENT OF has to lock, so its slower, right?
> Does it have any advantages after all?
>
> >To prevent that you could update by rowid
> How? How can I update by ROWID? I was thinking to update
> by PRIMARY_KEY...
>
> > and avoid the header updates.
>
> .. what "header" updates?
>
> thx
> maa
>
> __
> Do you Yahoo!?
> SBC Yahoo! DSL - Now only $29.95 per month!
> http://sbc.yahoo.com
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: MaryAnn Atkinson
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Kevin Toepke
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
>


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

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

RE: Oracle security question

[DENNIS WILLIAMS]

Don 
SYS is the owner of the Oracle dictionary tables. It is a username with
DBA privilege, so someone who logs in can change data. If you have changed
its password, then you are assured that nobody is using that username right
now. If you've changed its password, then I wouldn't worry about it right
now. 
Since it sounds as if you are the only person that accesses this
database, then you may want to change the username that owns your tables.
Hopefully this username is not SYSTEM or SYS.
After that, unless you know of other usernames someone might use to
access your Oracle database, don't make any more security changes for
awhile. Go back to trying to figure out why your data is changing without
your changing it. It may well be there is an innocent reason that has
nothing to do with someone else. I've had that happen to me when I've
started using an unfamiliar system.
And don't forget to buy a good Oracle DBA book like the one I suggested.

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

 

-Original Message-
Sent: Friday, July 11, 2003 3:49 PM
To: Multiple recipients of list ORACLE-L


Dennis:

Thanks for your message. Now I have changed sys password by the following
command:
alter user sys identified by xxx
But when I try to login from sql plus window by using sys, I cannot
successfully
login. Also I get an error message. The message is something like
"connection to
sys should be as sysdba or sysoper". So my question is what sys for?
Thank you very much!


Don


DENNIS WILLIAMS wrote:

> Don
>If only you can make updates to your Oracle database, then you must
enter
> all the data ;-)
>From the tone of your posting, I'm going to assume that you are pretty
> new to Oracle. You may want to get a good basic administration book like
> Oracle9i DBA 101.
>
http://www.amazon.com/exec/obidos/tg/detail/-/0072224746/qid=1057949734/sr=8
> -1/ref=sr_8_1/104-2287688-5574335?v=glance&s=books&n=507846
> It is also a good idea to always mention your Oracle version and platform
> (Unix, NT, etc.) in your posts.
> First, log in with the SYSTEM username. Then change the password for
SYSTEM
> and SYS with the command:
> ALTER USER SYSTEM IDENTIFIED BY x;
> Where x is your new password.
> You should be able to make these changes without affecting any end users.
> Next you should identify your groups of users and how they access Oracle.
> Basically you need to identify what their access requirements are and then
> audit the usernames they use to ensure the privileges granted are just
what
> is required. This is also a good time to see about changing passwords, but
> first buy the book and read up on the basics of Oracle security.
>
> Dennis Williams
> DBA, 80%OCP, 100% DBA
> Lifetouch, Inc.
> [EMAIL PROTECTED]
>
> -Original Message-
> Sent: Friday, July 11, 2003 2:45 PM
> To: Multiple recipients of list ORACLE-L
>
> Hi,
>
> I have a security question about Oracle database. Recently I have taken
> full control an Oracle database in my department. Now I would like to
> make sure that no other people except myself can update data in that
> database. Can somebody tell me what it is necessary steps to do that?
> Any comments are highly appreciated. Thanks!
>
> Don
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Don Yu
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: DENNIS WILLIAMS
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).

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

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

full usefullness of CURRENT OF ???

[Maryann Atkinson]

Could anyone give us an idea as to the full usefullness
of CURRENT OF?  Here are my two separate examples:
/*   1  this one has a CURRENT OF  */

DECLARE

   CURSOR  EmpCursor  IS
   SELECT  *
   FROMEmp
   FOR UPDATE;
BEGIN
FOR EmpRec IN EmpCursor LOOP
UPDATE EMP
SETSALARY = SALARY * 1.08
WHERE  CURRENT OF EmpCursor
END LOOP;

END;

/*   2 same as above, except without the CURRENT OF   */
DECLARE
  CURSOR  EmpCursor  IS
  SELECT  *
  FROMEmp
  FOR UPDATE;
BEGIN
FOR EmpRec IN EmpCursor LOOP
UPDATE EMP
SETSALARY = SALARY * 1.08
WHERE  EMP_ID = EmpRec.Emp_ID;
END LOOP;

END;
/
Is one more efficient than the other? If I could have done
business without the CURRENT OF, then why did oracle made
it available?
thx
maa
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Maryann Atkinson
 INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

walked around: 8.1.7.4 doesn't take stirped raw LVs for redo and

[Jessica Mao]

maybe nobody cares. but anyway, more experiments show as long as striped raw LV is 
bigger than 4092MB (4K block size), oracle datafile size could only be several MB or 
something, not even close to 1000MB. seems like there's some kind of overflow here.

problem went away after loaded 9.2.0.3.
again there was no problem w/ 8.1.7.0 either. 
so i think there's a bug in 8.1.7.4.

-Original Message-
Sent: Thursday, July 10, 2003 1:45 PM
To: Multiple recipients of list ORACLE-L
HPUX 


can anyone please help?

errors like below when any of the redo or rollback raw LVs are created using stripe: 

CREATE TABLESPACE RBS DATAFILE '/dev/vgrbs/rrbs01.dbf' SIZE 8000M REUSE AUTOEXTEND OFF 
MINIMUM EXTENT 512K DEFAULT STORAGE ( INITIAL 512K NEXT 512K MINEXTENTS 8 MAXEXTENTS 
UNLIMITED ) 
* 
ORA-01119: error in creating database file '/dev/vgrbs/rrbs01.dbf' 
ORA-27042: not enough space on raw partition to fullfill request 
Additional information: 2 

same statement got processed when LVs were recreated w/o stripe. didn't change size 
settings. 

8.1.7.0 did take striped raw LVs for redo and rollback. 
user tablespaces can ALWAYS be created using striped raw LVs.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jessica Mao
  INET: [EMAIL PROTECTED]

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

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

installed users

[Rachel Carmichael]

Okay, I have, as Mladen suggested, been running the following

begin
dbms_rtfm.database_concepts;
end;
/

and even the lesser_known one of dbms_websearch.metalink

to find out exactly which installed user is for what Oracle option.

I've started a project to review all users in all our databases and
remove unused/unnecessary users or at the very least restrict the
privileges they have to the minimal ones they need. In several of the
databases there are both ORDSYS and CTXSYS. From what I've been able to
find out by running the above procedures, ORDSYS is for Intermedia. I
could have sworn CTXSYS was the Intermedia account. So... is there a
manual I've missed that tells me exactly which of these two I have to
have in my databases and why?

In addition, I know you have to install Spatial Option as part of an
Oracle installation, even if you don't want to use it. Some of these
databases also have the account MDSYS, some don't. All but one are
9iR2. We don't use Spatial. The two databases that have this account
(8.1.7.4 and 9.2.0.2) both use Intermedia. Does that have something to
do with it? I don't want to remove an account I need, but I don't want
to leave ones I don't need in the databases.

Let's not even begin to talk about the fact that just about EVERY user
seems to have "unlimited tablespace" priv. 

This is not going to be pretty, easy or clean. But I will have secure
databases. Except of course, every app has a configuration file in
which they hard-code the passwords. Sigh

Rachel



__
Do you Yahoo!?
SBC Yahoo! DSL - Now only $29.95 per month!
http://sbc.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Rachel Carmichael
  INET: [EMAIL PROTECTED]

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

Re: Oracle security question

[Don Yu]

Dennis:

Thanks for your message. Now I have changed sys password by the following
command:
alter user sys identified by xxx
But when I try to login from sql plus window by using sys, I cannot successfully
login. Also I get an error message. The message is something like "connection to
sys should be as sysdba or sysoper". So my question is what sys for?
Thank you very much!


Don


DENNIS WILLIAMS wrote:

> Don
>If only you can make updates to your Oracle database, then you must enter
> all the data ;-)
>From the tone of your posting, I'm going to assume that you are pretty
> new to Oracle. You may want to get a good basic administration book like
> Oracle9i DBA 101.
> http://www.amazon.com/exec/obidos/tg/detail/-/0072224746/qid=1057949734/sr=8
> -1/ref=sr_8_1/104-2287688-5574335?v=glance&s=books&n=507846
> It is also a good idea to always mention your Oracle version and platform
> (Unix, NT, etc.) in your posts.
> First, log in with the SYSTEM username. Then change the password for SYSTEM
> and SYS with the command:
> ALTER USER SYSTEM IDENTIFIED BY x;
> Where x is your new password.
> You should be able to make these changes without affecting any end users.
> Next you should identify your groups of users and how they access Oracle.
> Basically you need to identify what their access requirements are and then
> audit the usernames they use to ensure the privileges granted are just what
> is required. This is also a good time to see about changing passwords, but
> first buy the book and read up on the basics of Oracle security.
>
> Dennis Williams
> DBA, 80%OCP, 100% DBA
> Lifetouch, Inc.
> [EMAIL PROTECTED]
>
> -Original Message-
> Sent: Friday, July 11, 2003 2:45 PM
> To: Multiple recipients of list ORACLE-L
>
> Hi,
>
> I have a security question about Oracle database. Recently I have taken
> full control an Oracle database in my department. Now I would like to
> make sure that no other people except myself can update data in that
> database. Can somebody tell me what it is necessary steps to do that?
> Any comments are highly appreciated. Thanks!
>
> Don
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Don Yu
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: DENNIS WILLIAMS
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).

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

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

RE: full usefullness of CURRENT OF ???

[Chris Stephens]

Title: RE: full usefullness of CURRENT OF  ???





Locking if something oracle is very good at.  It happens all over the place and it happens quickly...there is very little overhead to it.

Block headers.  ...each block in the affected table.


By updating the table by rowid, you get the best of both worlds assuming no one is re-orging the table (or somehow altering rowid to row value relationship) and that there is no need prevent users from touching the table while you are doing the update.

Cursor c_crud is select rowid, col1 from t_crud;


For v_crud in c_crud loop


Update t_crud 
Set col1=whatever
where rowid = v_crud.rowid;


End loop;




(I remember reading about this in Guy Harrison's SQL tuning book...if you have a copy, I'd check that outbecause I am very prone to memory recall error :) )

-Original Message-
From: MaryAnn Atkinson [mailto:[EMAIL PROTECTED]] 
Sent: Friday, July 11, 2003 3:09 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: full usefullness of CURRENT OF ???


--- Chris Stephens <[EMAIL PROTECTED]> wrote: 
> Also, the CURRENT OF locks the table so that no one can modify (or
> even read) it while the transaction is taking place.  This guarantees
> nothing is  changing between retrieving values from the cursor and 
> updating the table based on those values.


OK, fair enough.


 
> The second example has to run the update statement seperately. 
> CURRENT OF can go directly to the row(s) affected.  CURRENT OF 
> still has to modify each block header in the table to lock which 
> is a small performance hit. 


So CURRENT OF has to lock, so its slower, right? 
Does it have any advantages after all? 


>To prevent that you could update by rowid 
How? How can I update by ROWID? I was thinking to update 
by PRIMARY_KEY...


> and avoid the header updates.


... what "header" updates? 


thx
maa


__
Do you Yahoo!?
SBC Yahoo! DSL - Now only $29.95 per month!
http://sbc.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: MaryAnn Atkinson
  INET: [EMAIL PROTECTED]


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

RE: RAC system Calls

[Jamadagni, Rajendra]

Title: RE: RAC system Calls





Yup, we have 2 private interconnects and one public .. can't display the ips though ...


Raj

Rajendra dot Jamadagni at nospamespn dot com
All Views expressed in this email are strictly personal.
QOTD: Any clod can have facts, having an opinion is an art !



-Original Message-
From: Ravi Kulkarni [mailto:[EMAIL PROTECTED]]
Sent: Friday, July 11, 2003 4:19 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: RAC system Calls



Do you use 1 or 2 interconnects? Does your oradebug
ipc dump show both IPs? For me shows:


SSKGXPT 0x3066b00 flags info for network 0
    socket no 9 IP 172.168.193.2 UDP 41143
    sflags SSKGXPT_UP    info for network 1
    socket no 0 IP 0.0.0.0   UDP 0
    sflags SSKGXPT_DOWN


Even 172.168.193.2 is not one of the (2) IPs we have
for interconnect.


Thanks,
Ravi.


--- "Jamadagni, Rajendra"
<[EMAIL PROTECTED]> wrote:
> We don't use cluster_interconnects (it is null) ..
> but for us, the RAC is
> using the fat private interconnects without any
> problems.
> 
> Raj
>

> 
> Rajendra dot Jamadagni at nospamespn dot com
> All Views expressed in this email are strictly
> personal.
> QOTD: Any clod can have facts, having an opinion is
> an art !
> 
> 
> -Original Message-
> Sent: Friday, July 11, 2003 3:34 PM
> To: Multiple recipients of list ORACLE-L
> 
> 
> Correct. Looks like we need to configure
> CLUSTER_INTERCONNECTS parameter. Automatic
> configuration (Sun Cluster3.0/RAC) did not choose
> the
> (correct) IP(s) for interconnect. KG noticed it. I
> have sent netstat -ai, oradebug IPC dump, ping -s
> info
> to him. If you are interested, I can paste it here.
> 
> -Thanks,
> Ravi.
> >
This
> e-mail message is confidential, intended only for
> the named recipient(s) above and may contain
> information that is privileged, attorney work
> product or exempt from disclosure under applicable
> law. If you have received this message in error, or
> are not the named recipient(s), please immediately
> notify corporate MIS at (860) 766-2000 and delete
> this e-mail message from your computer, Thank
>
you.*2
> 



__
Do you Yahoo!?
SBC Yahoo! DSL - Now only $29.95 per month!
http://sbc.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Ravi Kulkarni
  INET: [EMAIL PROTECTED]


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



This e-mail 
message is confidential, intended only for the named recipient(s) above and may 
contain information that is privileged, attorney work product or exempt from 
disclosure under applicable law. If you have received this message in error, or are 
not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 
and delete this e-mail message from your computer, Thank 
you.*2

Re: Oracle security question

[Don Yu]

Stephane,

Thanks for your message. The reason I ask this question is that now I am
responsible for creating some reports based upon this database. But I have found
that there are unaccountable data in my database, which is not from my insert
script or my cron job program. Thanks!


Don


Stephane Paquette wrote:

> Change the password of all Oracle related users (sys, system,...)
> Revoke access from all other users or make sure all other users have select
> only privilege on data.
>
> What is the use of such databases ?
>
> Stephane Paquette
> Administrateur de bases de donnees
> Database Administrator
> Standard Life
> www.standardlife.ca
> Tel. (514) 499-7999 7470 and (514) 925-7187
> [EMAIL PROTECTED] 
>
> -Original Message-
> Don Yu
> Sent: Friday, July 11, 2003 3:45 PM
> To: Multiple recipients of list ORACLE-L
>
> Hi,
>
> I have a security question about Oracle database. Recently I have taken
> full control an Oracle database in my department. Now I would like to
> make sure that no other people except myself can update data in that
> database. Can somebody tell me what it is necessary steps to do that?
> Any comments are highly appreciated. Thanks!
>
> Don
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Don Yu
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Stephane Paquette
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).

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

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

Re: RE: full usefullness of CURRENT OF ???

[rgaffuri]

when you update inside of a cursor you have two steps. 

Fetch data into the cursor
Update the table based on what you selected. 

So while you are selecting data and before you update, the record could change. This 
means someone else could update it and youc ould update over it without knowing it. 
This is a bad idea in the database world and is known as 'disapearing updates'. So you 
lock the row when you select it. Not when the actual update is processed. 

Updating inside of cursors is generally a bad idea. Its more code and its MUCH slower 
than a straight update statement. Ive seen some publications stating that it can 
before to do this way, but Ive tested every case I can think of and not once was it 
even close. 


what is the update statement you want to put inside the cursor? 
> 
> From: MaryAnn Atkinson <[EMAIL PROTECTED]>
> Date: 2003/07/11 Fri PM 04:09:25 EDT
> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> Subject: RE: full usefullness of CURRENT OF  ???
> 
> --- Chris Stephens <[EMAIL PROTECTED]> wrote: 
> > Also, the CURRENT OF locks the table so that no one can modify (or
> > even read) it while the transaction is taking place.  This guarantees
> > nothing is  changing between retrieving values from the cursor and 
> > updating the table based on those values.
> 
> OK, fair enough.
> 
>  
> > The second example has to run the update statement seperately. 
> > CURRENT OF can go directly to the row(s) affected.  CURRENT OF 
> > still has to modify each block header in the table to lock which 
> > is a small performance hit. 
> 
> So CURRENT OF has to lock, so its slower, right? 
> Does it have any advantages after all? 
> 
> >To prevent that you could update by rowid 
> How? How can I update by ROWID? I was thinking to update 
> by PRIMARY_KEY...
> 
> > and avoid the header updates.
> 
> ... what "header" updates? 
> 
> thx
> maa
> 
> __
> Do you Yahoo!?
> SBC Yahoo! DSL - Now only $29.95 per month!
> http://sbc.yahoo.com
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: MaryAnn Atkinson
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> 

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

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

RE: full usefullness of CURRENT OF ???

[Kevin Toepke]

>> Also, the CURRENT OF locks the table so that no one can modify (or
>> even read) it while the transaction is taking place.  This guarantees
>> nothing is  changing between retrieving values from the cursor and 
>> updating the table based on those values.

Actually, it is the FOR UPDATE that locks the table.

>How? How can I update by ROWID? I was thinking to update 
>by PRIMARY_KEY...

DECLARE

   CURSOR  EmpCursor  IS
   SELECT  rowid, 
   FROMEmp;
BEGIN
 FOR EmpRec IN EmpCursor LOOP
 UPDATE EMP
 SETSALARY = SALARY * 1.08
 WHERE  rowid = EmpRec.rowid;
 END LOOP;
END;

Kevin
-Original Message-
Sent: Friday, July 11, 2003 4:09 PM
To: Multiple recipients of list ORACLE-L


--- Chris Stephens <[EMAIL PROTECTED]> wrote: 
> Also, the CURRENT OF locks the table so that no one can modify (or
> even read) it while the transaction is taking place.  This guarantees
> nothing is  changing between retrieving values from the cursor and 
> updating the table based on those values.

OK, fair enough.

 
> The second example has to run the update statement seperately. 
> CURRENT OF can go directly to the row(s) affected.  CURRENT OF 
> still has to modify each block header in the table to lock which 
> is a small performance hit. 

So CURRENT OF has to lock, so its slower, right? 
Does it have any advantages after all? 

>To prevent that you could update by rowid 
How? How can I update by ROWID? I was thinking to update 
by PRIMARY_KEY...

> and avoid the header updates.

.. what "header" updates? 

thx
maa

__
Do you Yahoo!?
SBC Yahoo! DSL - Now only $29.95 per month!
http://sbc.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: MaryAnn Atkinson
  INET: [EMAIL PROTECTED]

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

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

Re: full usefullness of CURRENT OF ???

[Daniel Fink]

Repeat after me...readers never block writers...writers never block readers...

The update will lock the row(s) of the result set, but it will not block anyone from 
reading the data. However, they may not read the modifications made by the update 
until it is committed.


MaryAnn Atkinson wrote:
> 
> --- Chris Stephens <[EMAIL PROTECTED]> wrote:
> > Also, the CURRENT OF locks the table so that no one can modify (or
> > even read) it while the transaction is taking place.  This guarantees
> > nothing is  changing between retrieving values from the cursor and
> > updating the table based on those values.
> 
> OK, fair enough.
> 
> 
> > The second example has to run the update statement seperately.
> > CURRENT OF can go directly to the row(s) affected.  CURRENT OF
> > still has to modify each block header in the table to lock which
> > is a small performance hit.
> 
> So CURRENT OF has to lock, so its slower, right?
> Does it have any advantages after all?
> 
> >To prevent that you could update by rowid
> How? How can I update by ROWID? I was thinking to update
> by PRIMARY_KEY...
> 
> > and avoid the header updates.
> 
> ... what "header" updates?
> 
> thx
> maa
> 
> __
> Do you Yahoo!?
> SBC Yahoo! DSL - Now only $29.95 per month!
> http://sbc.yahoo.com
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: MaryAnn Atkinson
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).begin:vcard 
n:Fink;Daniel
tel;cell:303.808.3282
tel;work:303.272.3225
x-mozilla-html:TRUE
adr:;;
version:2.1
email;internet:[EMAIL PROTECTED]
title:DB Services Lead
x-mozilla-cpt:;-4832
fn:Daniel Fink
end:vcard

RE: RAC system Calls

[Ravi Kulkarni]

Do you use 1 or 2 interconnects? Does your oradebug
ipc dump show both IPs? For me shows:

SSKGXPT 0x3066b00 flags info for network 0
socket no 9 IP 172.168.193.2 UDP 41143
sflags SSKGXPT_UPinfo for network 1
socket no 0 IP 0.0.0.0   UDP 0
sflags SSKGXPT_DOWN

Even 172.168.193.2 is not one of the (2) IPs we have
for interconnect.

Thanks,
Ravi.

--- "Jamadagni, Rajendra"
<[EMAIL PROTECTED]> wrote:
> We don't use cluster_interconnects (it is null) ...
> but for us, the RAC is
> using the fat private interconnects without any
> problems.
> 
> Raj
>

> 
> Rajendra dot Jamadagni at nospamespn dot com
> All Views expressed in this email are strictly
> personal.
> QOTD: Any clod can have facts, having an opinion is
> an art !
> 
> 
> -Original Message-
> Sent: Friday, July 11, 2003 3:34 PM
> To: Multiple recipients of list ORACLE-L
> 
> 
> Correct. Looks like we need to configure
> CLUSTER_INTERCONNECTS parameter. Automatic
> configuration (Sun Cluster3.0/RAC) did not choose
> the
> (correct) IP(s) for interconnect. KG noticed it. I
> have sent netstat -ai, oradebug IPC dump, ping -s
> info
> to him. If you are interested, I can paste it here.
> 
> -Thanks,
> Ravi.
> >
This
> e-mail message is confidential, intended only for
> the named recipient(s) above and may contain
> information that is privileged, attorney work
> product or exempt from disclosure under applicable
> law. If you have received this message in error, or
> are not the named recipient(s), please immediately
> notify corporate MIS at (860) 766-2000 and delete
> this e-mail message from your computer, Thank
>
you.*2
> 


__
Do you Yahoo!?
SBC Yahoo! DSL - Now only $29.95 per month!
http://sbc.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Ravi Kulkarni
  INET: [EMAIL PROTECTED]

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

RE: full usefullness of CURRENT OF ???

[MaryAnn Atkinson]

--- Kevin Toepke <[EMAIL PROTECTED]> wrote:
> Yes, using WHERE CURRENT OF is faster. It is the same as saying
> "WHERE rowid = emprec.rowid", just more readable. And accesses by
> rowid are faster than index accesses.
> 
> Also, what happens if you don't have a unique or primary constraint
> on the table and whole rows can be duplicated? Then you pretty much
> need to use WHERE CURRENT OF.
> HTH
> Kevin

I see, its beginning to make sense... 

thx
maa

__
Do you Yahoo!?
SBC Yahoo! DSL - Now only $29.95 per month!
http://sbc.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: MaryAnn Atkinson
  INET: [EMAIL PROTECTED]

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

RE: full usefullness of CURRENT OF ???

[MaryAnn Atkinson]

--- Chris Stephens <[EMAIL PROTECTED]> wrote: 
> Also, the CURRENT OF locks the table so that no one can modify (or
> even read) it while the transaction is taking place.  This guarantees
> nothing is  changing between retrieving values from the cursor and 
> updating the table based on those values.

OK, fair enough.

 
> The second example has to run the update statement seperately. 
> CURRENT OF can go directly to the row(s) affected.  CURRENT OF 
> still has to modify each block header in the table to lock which 
> is a small performance hit. 

So CURRENT OF has to lock, so its slower, right? 
Does it have any advantages after all? 

>To prevent that you could update by rowid 
How? How can I update by ROWID? I was thinking to update 
by PRIMARY_KEY...

> and avoid the header updates.

... what "header" updates? 

thx
maa

__
Do you Yahoo!?
SBC Yahoo! DSL - Now only $29.95 per month!
http://sbc.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: MaryAnn Atkinson
  INET: [EMAIL PROTECTED]

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

RE: Oracle security question

[DENNIS WILLIAMS]

Don
   If only you can make updates to your Oracle database, then you must enter
all the data ;-)
   From the tone of your posting, I'm going to assume that you are pretty
new to Oracle. You may want to get a good basic administration book like
Oracle9i DBA 101.
http://www.amazon.com/exec/obidos/tg/detail/-/0072224746/qid=1057949734/sr=8
-1/ref=sr_8_1/104-2287688-5574335?v=glance&s=books&n=507846
It is also a good idea to always mention your Oracle version and platform
(Unix, NT, etc.) in your posts.
First, log in with the SYSTEM username. Then change the password for SYSTEM
and SYS with the command:
ALTER USER SYSTEM IDENTIFIED BY x;
Where x is your new password.
You should be able to make these changes without affecting any end users.
Next you should identify your groups of users and how they access Oracle.
Basically you need to identify what their access requirements are and then
audit the usernames they use to ensure the privileges granted are just what
is required. This is also a good time to see about changing passwords, but
first buy the book and read up on the basics of Oracle security.

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



-Original Message-
Sent: Friday, July 11, 2003 2:45 PM
To: Multiple recipients of list ORACLE-L


Hi,

I have a security question about Oracle database. Recently I have taken
full control an Oracle database in my department. Now I would like to
make sure that no other people except myself can update data in that
database. Can somebody tell me what it is necessary steps to do that?
Any comments are highly appreciated. Thanks!


Don


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

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

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

RE: Oracle security question

[Stephane Paquette]

Change the password of all Oracle related users (sys, system,...)
Revoke access from all other users or make sure all other users have select
only privilege on data.

What is the use of such databases ?



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





-Original Message-
Don Yu
Sent: Friday, July 11, 2003 3:45 PM
To: Multiple recipients of list ORACLE-L


Hi,

I have a security question about Oracle database. Recently I have taken
full control an Oracle database in my department. Now I would like to
make sure that no other people except myself can update data in that
database. Can somebody tell me what it is necessary steps to do that?
Any comments are highly appreciated. Thanks!


Don


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

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

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

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

RE: Security, private vs. public synonyms and contention data di

[Stephane Paquette]

Title: RE: Security, private vs. public synonyms and contention data dictionary



I 
think I remember Steve Adams posting something about performance and public 
synonyms, you may want to check its web site www.ixora.com.au
 



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

  -Original Message-From: [EMAIL PROTECTED] 
  [mailto:[EMAIL PROTECTED]On Behalf Of 
  [EMAIL PROTECTED]Sent: Friday, July 11, 2003 3:35 
  PMTo: Multiple recipients of list ORACLE-LSubject: RE: 
  Security, private vs. public synonyms and contention data 
  di
  Question: 
  Are private versus public synonyms preferred for 
  security? Are private syn. worse 
  administration? Do 1,000 users with private syn. cause 
  data dictionary contention? 

Re: Oracle security question

[Stephen Andert]

Don, 

Look at dba_tab_privs.

Stephen

>>> [EMAIL PROTECTED] 07/11/03 12:44PM >>>
Hi,

I have a security question about Oracle database. Recently I have
taken
full control an Oracle database in my department. Now I would like to
make sure that no other people except myself can update data in that
database. Can somebody tell me what it is necessary steps to do that?
Any comments are highly appreciated. Thanks!


Don


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

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


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

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

Recommended Init File for Standby

[Kevin Lange]

Evening folks;
  Does anyone happen to have any recommended init file settings for a
standby database ??

We are running Oracle 8.1.7.4 on a Solaris system.  I think that we may have
the settings on the standbys too high and are therefore wasting resources.

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

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

RE: RAC system Calls

[Jamadagni, Rajendra]

Title: RE: RAC system Calls





We don't use cluster_interconnects (it is null) ... but for us, the RAC is using the fat private interconnects without any problems.

Raj

Rajendra dot Jamadagni at nospamespn dot com
All Views expressed in this email are strictly personal.
QOTD: Any clod can have facts, having an opinion is an art !



-Original Message-
From: Ravi Kulkarni [mailto:[EMAIL PROTECTED]]
Sent: Friday, July 11, 2003 3:34 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: RAC system Calls



Correct. Looks like we need to configure
CLUSTER_INTERCONNECTS parameter. Automatic
configuration (Sun Cluster3.0/RAC) did not choose the
(correct) IP(s) for interconnect. KG noticed it. I
have sent netstat -ai, oradebug IPC dump, ping -s info
to him. If you are interested, I can paste it here.


-Thanks,
Ravi.



This e-mail 
message is confidential, intended only for the named recipient(s) above and may 
contain information that is privileged, attorney work product or exempt from 
disclosure under applicable law. If you have received this message in error, or are 
not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 
and delete this e-mail message from your computer, Thank 
you.*2

RE: full usefullness of CURRENT OF ???

[Kevin Toepke]

Yes, using WHERE CURRENT OF is faster. It is the same as saying "WHERE rowid
= emprec.rowid", just more readable. And accesses by rowid are faster than
index accesses.

Also, what happens if you don't have a unique or primary constraint on the
table and whole rows can be duplicated? Then you pretty much need to use
WHERE CURRENT OF.

HTH
Kevin

-Original Message-
Sent: Friday, July 11, 2003 2:54 PM
To: Multiple recipients of list ORACLE-L


Could anyone give us an idea as to the full usefullness
of CURRENT OF?  Here are my two separate examples:


/*   1  this one has a CURRENT OF  */

DECLARE

CURSOR  EmpCursor  IS
SELECT  *
FROMEmp
FOR UPDATE;

BEGIN
 FOR EmpRec IN EmpCursor LOOP

 UPDATE EMP
 SETSALARY = SALARY * 1.08
 WHERE  CURRENT OF EmpCursor

 END LOOP;

END;


/*   2 same as above, except without the CURRENT OF   */
DECLARE

   CURSOR  EmpCursor  IS
   SELECT  *
   FROMEmp
   FOR UPDATE;

BEGIN
 FOR EmpRec IN EmpCursor LOOP

 UPDATE EMP
 SETSALARY = SALARY * 1.08
 WHERE  EMP_ID = EmpRec.Emp_ID;

 END LOOP;

END;
/


Is one more efficient than the other? If I could have done
business without the CURRENT OF, then why did oracle made
it available?

thx
maa 

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

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

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

Oracle security question

[Don Yu]

Hi,

I have a security question about Oracle database. Recently I have taken
full control an Oracle database in my department. Now I would like to
make sure that no other people except myself can update data in that
database. Can somebody tell me what it is necessary steps to do that?
Any comments are highly appreciated. Thanks!


Don


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

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

RE: RAC system Calls

[Ravi Kulkarni]

Correct. Looks like we need to configure
CLUSTER_INTERCONNECTS parameter. Automatic
configuration (Sun Cluster3.0/RAC) did not choose the
(correct) IP(s) for interconnect. KG noticed it. I
have sent netstat -ai, oradebug IPC dump, ping -s info
to him. If you are interested, I can paste it here.

-Thanks,
Ravi.

--- K Gopalakrishnan <[EMAIL PROTECTED]> wrote:
> RE: RAC system CallsRaj:
> 
> I am discussing this issue with Ravi offline. From
> the initial
> IPC dumps, It looks like the private interconnect is
> not
> properly configured/used for cache fusion. I am
> waiting for
> more details from him..
> 
> 
> 
> Best Regards,
> K Gopalakrishnan
> 
> 
> 
> 
> -Original Message-
> Jamadagni, Rajendra
> Sent: Friday, July 11, 2003 7:34 AM
> To: Multiple recipients of list ORACLE-L
> 
> 
> That may be because with RAC there is more activity
> ... GCS traffic and more
> stats to update ...
> 
> Raj
>

> 
> Rajendra dot Jamadagni at nospamespn dot com
> All Views expressed in this email are strictly
> personal.
> QOTD: Any clod can have facts, having an opinion is
> an art !
> 
> -Original Message-
> Sent: Thursday, July 10, 2003 8:14 PM
> To: Multiple recipients of list ORACLE-L
> 
> 
> 
> Raj,
> Yes. Timed_statistics=true. But I see the 'times'
> even
> in single instance(non-rac)database but relatively
> called negligible number of times.
> -Ravi.
> 
> 


__
Do you Yahoo!?
SBC Yahoo! DSL - Now only $29.95 per month!
http://sbc.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Ravi Kulkarni
  INET: [EMAIL PROTECTED]

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

RE: Security, private vs. public synonyms and contention data di

[Paula_Stankus]

Title: RE:  Security, private vs. public synonyms and contention data dictionary





Question:


Are private versus public synonyms preferred for security?
Are private syn. worse administration?
Do 1,000 users with private syn. cause data dictionary contention?

Re: RE: full usefulness of CURRENT OF ???

[rgaffuri]

using pl/sql with update is very slow. much slower than just sql. so only use if you 
absolutely have to. 

i avoid it at all costs. 
> 
> From: "Jamadagni, Rajendra" <[EMAIL PROTECTED]>
> Date: 2003/07/11 Fri PM 03:09:24 EDT
> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> Subject: RE: full usefulness of CURRENT OF  ???
> 
> Try with a complicated where clause where your where_clause is a page long
> ...
> 
> Raj
> 
> 
> Rajendra dot Jamadagni at nospamespn dot com
> All Views expressed in this email are strictly personal.
> QOTD: Any clod can have facts, having an opinion is an art !
> 
> 
> -Original Message-
> Sent: Friday, July 11, 2003 2:54 PM
> To: Multiple recipients of list ORACLE-L
> 
> 
> Could anyone give us an idea as to the full usefullness
> of CURRENT OF?  Here are my two separate examples:
> 
> 
> /*   1  this one has a CURRENT OF  */
> 
> DECLARE
> 
> CURSOR  EmpCursor  IS
> SELECT  *
> FROMEmp
> FOR UPDATE;
> 
> BEGIN
>  FOR EmpRec IN EmpCursor LOOP
> 
>  UPDATE EMP
>  SETSALARY = SALARY * 1.08
>  WHERE  CURRENT OF EmpCursor
> 
>  END LOOP;
> 
> END;
> 
> 
> /*   2 same as above, except without the CURRENT OF   */
> DECLARE
> 
>CURSOR  EmpCursor  IS
>SELECT  *
>FROMEmp
>FOR UPDATE;
> 
> BEGIN
>  FOR EmpRec IN EmpCursor LOOP
> 
>  UPDATE EMP
>  SETSALARY = SALARY * 1.08
>  WHERE  EMP_ID = EmpRec.Emp_ID;
> 
>  END LOOP;
> 
> END;
> /
> 
> 
> Is one more efficient than the other? If I could have done
> business without the CURRENT OF, then why did oracle made
> it available?
> 
> thx
> maa 
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: Maryann Atkinson
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> 
> 
> *This e-mail 
> message is confidential, intended only for the named recipient(s) above and may 
> contain information that is privileged, attorney work product or exempt from 
> disclosure under applicable law. If you have received this message in error, or are 
> not the named recipient(s), please immediately notify corporate MIS at (860) 
> 766-2000 and delete this e-mail message from your computer, Thank 
> you.*1
> 
> 
Title: RE: full usefulness of CURRENT OF  ???





Try with a complicated where clause where your where_clause is a page long ...


Raj

Rajendra dot Jamadagni at nospamespn dot com
All Views expressed in this email are strictly personal.
QOTD: Any clod can have facts, having an opinion is an art !



-Original Message-
From: Maryann Atkinson [mailto:[EMAIL PROTECTED]]
Sent: Friday, July 11, 2003 2:54 PM
To: Multiple recipients of list ORACLE-L
Subject: full usefullness of CURRENT OF ???



Could anyone give us an idea as to the full usefullness
of CURRENT OF?  Here are my two separate examples:



/*   1  this one has a CURRENT OF  */


DECLARE


    CURSOR  EmpCursor  IS
    SELECT  *
    FROM    Emp
    FOR UPDATE;


BEGIN
 FOR EmpRec IN EmpCursor LOOP


 UPDATE EMP
 SET    SALARY = SALARY * 1.08
 WHERE  CURRENT OF EmpCursor


 END LOOP;


END;



/*   2 same as above, except without the CURRENT OF   */
DECLARE


   CURSOR  EmpCursor  IS
   SELECT  *
   FROM    Emp
   FOR UPDATE;


BEGIN
 FOR EmpRec IN EmpCursor LOOP


 UPDATE EMP
 SET    SALARY = SALARY * 1.08
 WHERE  EMP_ID = EmpRec.Emp_ID;


 END LOOP;


END;
/



Is one more efficient than the other? If I could have done
business without the CURRENT OF, then why did oracle made
it available?


thx
maa 


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


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

RE: full usefulness of CURRENT OF ???

[Mercadante, Thomas F]

Title: RE: full usefulness of CURRENT OF ???



this 
is better than using rowid in the update clause
 
Tom Mercadante Oracle Certified Professional 

  -Original Message-From: Jamadagni, Rajendra 
  [mailto:[EMAIL PROTECTED]Sent: Friday, July 11, 2003 
  3:09 PMTo: Multiple recipients of list ORACLE-LSubject: 
  RE: full usefulness of CURRENT OF ???
  Try with a complicated where clause where your where_clause is 
  a page long ... 
  Raj  
  Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. 
  QOTD: Any clod can have facts, having an opinion is an art 
  ! 
  -Original Message- From: 
  Maryann Atkinson [mailto:[EMAIL PROTECTED]] 
  Sent: Friday, July 11, 2003 2:54 PM To: Multiple recipients of list ORACLE-L Subject: full usefullness of CURRENT OF ??? 
  Could anyone give us an idea as to the full usefullness 
  of CURRENT OF?  Here are my two separate 
  examples: 
  /*   1  this one has a CURRENT OF  
  */ 
  DECLARE 
      CURSOR  EmpCursor  IS 
      
  SELECT  *     
  FROM    Emp     
  FOR UPDATE; 
  BEGIN  FOR 
  EmpRec IN EmpCursor LOOP 
   UPDATE 
  EMP  
  SET    SALARY = SALARY * 1.08  WHERE  CURRENT OF 
  EmpCursor 
   END LOOP; 
  END; 
  /*   2 same as above, except without the CURRENT 
  OF   */ DECLARE 
     CURSOR  EmpCursor  IS    
  SELECT  *    
  FROM    Emp    
  FOR UPDATE; 
  BEGIN  FOR 
  EmpRec IN EmpCursor LOOP 
   UPDATE 
  EMP  
  SET    SALARY = SALARY * 1.08  WHERE  EMP_ID = 
  EmpRec.Emp_ID; 
   END LOOP; 
  END; / 
  Is one more efficient than the other? If I could have 
  done business without the CURRENT OF, then why did 
  oracle made it available? 
  thx maa 
  -- Please see the official ORACLE-L 
  FAQ: http://www.orafaq.net -- Author: Maryann Atkinson   INET: [EMAIL PROTECTED] 
  Fat City Network Services    -- 858-538-5051 http://www.fatcity.com 
  San Diego, 
  California    -- Mailing list and web 
  hosting services - 
  To REMOVE yourself from this mailing list, send an E-Mail 
  message to: [EMAIL PROTECTED] (note EXACT spelling 
  of 'ListGuru') and in the message BODY, include a line 
  containing: UNSUB ORACLE-L (or the name of mailing 
  list you want to be removed from).  You may also 
  send the HELP command for other information (like subscribing). 

RE: full usefullness of CURRENT OF ???

[Chris Stephens]

I believe
(I could be totally wrong here) the reason for the CURRENT OF is both for
performance and consistency.

 

The second example has to run the update statement seperately.  CURRENT
OF can go directly to the row(s) affected.  CURRENT OF still has to modify
each block header in the table to lock which is a small performance hit. 
To prevent that you could update by rowid and avoid the header updates.

 

Also, the CURRENT OF locks the table so that no one can modify (or even
read) it while the transaction is taking place.  This guarantees nothing
is changing between retrieving values from the cursor and updating the table
based on those values.

 

-Original Message-
Sent: Friday, July 11, 2003 1:54 PM
To: Multiple recipients of list ORACLE-L

 

Could anyone give us an idea as to the full usefullness

of CURRENT OF?  Here are my two separate examples:

 

 

/*   1  this one has a CURRENT OF  */

 

DECLARE

 

    CURSOR  EmpCursor  IS

   
SELECT  *

   
FROM    Emp

   
FOR UPDATE;

 

BEGIN

 FOR EmpRec IN EmpCursor LOOP

 

 UPDATE EMP

 SET   
SALARY = SALARY * 1.08

 WHERE  CURRENT OF
EmpCursor

 

 END LOOP;

 

END;

 

 

/*   2 same as above, except without the CURRENT
OF   */

DECLARE

 

   CURSOR  EmpCursor  IS

  
SELECT  *

  
FROM    Emp

  
FOR UPDATE;

 

BEGIN

 FOR EmpRec IN EmpCursor LOOP

 

 UPDATE EMP

 SET   
SALARY = SALARY * 1.08

 WHERE  EMP_ID =
EmpRec.Emp_ID;

 

 END LOOP;

 

END;

/

 

 

Is one more efficient than the other? If I could have done

business without the CURRENT OF, then why did oracle made

it available?

 

thx

maa 

 

-- 

Please see the official ORACLE-L FAQ: http://www.orafaq.net

-- 

Author: Maryann Atkinson

  INET: [EMAIL PROTECTED]

 

Fat City Network Services    -- 858-538-5051
http://www.fatcity.com

San Diego, California    --
Mailing list and web hosting services

-

To REMOVE yourself from this mailing list, send an E-Mail message

to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in

the message BODY, include a line containing: UNSUB ORACLE-L

(or the name of mailing list you want to be removed from).  You
may

also send the HELP command for other information (like subscribing).

RE: full usefulness of CURRENT OF ???

[Jamadagni, Rajendra]

Title: RE: full usefulness of CURRENT OF  ???





Try with a complicated where clause where your where_clause is a page long ...


Raj

Rajendra dot Jamadagni at nospamespn dot com
All Views expressed in this email are strictly personal.
QOTD: Any clod can have facts, having an opinion is an art !



-Original Message-
From: Maryann Atkinson [mailto:[EMAIL PROTECTED]]
Sent: Friday, July 11, 2003 2:54 PM
To: Multiple recipients of list ORACLE-L
Subject: full usefullness of CURRENT OF ???



Could anyone give us an idea as to the full usefullness
of CURRENT OF?  Here are my two separate examples:



/*   1  this one has a CURRENT OF  */


DECLARE


    CURSOR  EmpCursor  IS
    SELECT  *
    FROM    Emp
    FOR UPDATE;


BEGIN
 FOR EmpRec IN EmpCursor LOOP


 UPDATE EMP
 SET    SALARY = SALARY * 1.08
 WHERE  CURRENT OF EmpCursor


 END LOOP;


END;



/*   2 same as above, except without the CURRENT OF   */
DECLARE


   CURSOR  EmpCursor  IS
   SELECT  *
   FROM    Emp
   FOR UPDATE;


BEGIN
 FOR EmpRec IN EmpCursor LOOP


 UPDATE EMP
 SET    SALARY = SALARY * 1.08
 WHERE  EMP_ID = EmpRec.Emp_ID;


 END LOOP;


END;
/



Is one more efficient than the other? If I could have done
business without the CURRENT OF, then why did oracle made
it available?


thx
maa 


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


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



*This e-mail 
message is confidential, intended only for the named recipient(s) above and may 
contain information that is privileged, attorney work product or exempt from 
disclosure under applicable law. If you have received this message in error, or are 
not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 
and delete this e-mail message from your computer, Thank 
you.*1

full usefullness of CURRENT OF ???

[Maryann Atkinson]

Could anyone give us an idea as to the full usefullness
of CURRENT OF?  Here are my two separate examples:
/*   1  this one has a CURRENT OF  */

DECLARE

   CURSOR  EmpCursor  IS
   SELECT  *
   FROMEmp
   FOR UPDATE;
BEGIN
FOR EmpRec IN EmpCursor LOOP
UPDATE EMP
SETSALARY = SALARY * 1.08
WHERE  CURRENT OF EmpCursor
END LOOP;

END;

/*   2 same as above, except without the CURRENT OF   */
DECLARE
  CURSOR  EmpCursor  IS
  SELECT  *
  FROMEmp
  FOR UPDATE;
BEGIN
FOR EmpRec IN EmpCursor LOOP
UPDATE EMP
SETSALARY = SALARY * 1.08
WHERE  EMP_ID = EmpRec.Emp_ID;
END LOOP;

END;
/
Is one more efficient than the other? If I could have done
business without the CURRENT OF, then why did oracle made
it available?
thx
maa 

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

RE: RAC system Calls

[Jamadagni, Rajendra]

Title: RE: RAC system Calls



Hmmm ...
 
Thanks KG
Raj
 
Rajendra dot Jamadagni at nospamespn dot 
com All Views expressed in this email 
are strictly personal. QOTD: Any clod 
can have facts, having an opinion is an art ! 

  -Original Message-From: K Gopalakrishnan 
  [mailto:[EMAIL PROTECTED]Sent: Friday, July 11, 2003 1:14 
  PMTo: Multiple recipients of list ORACLE-LSubject: RE: 
  RAC system Calls
  Raj:
   
  I am 
  discussing this issue with Ravi offline. From the initial
  IPC 
  dumps, It looks like the private interconnect is not
  properly configured/used for cache fusion. I am waiting 
  for
  more 
  details from him..
  Best Regards,K 
Gopalakrishnan
This e-mail 
message is confidential, intended only for the named recipient(s) above and may 
contain information that is privileged, attorney work product or exempt from 
disclosure under applicable law. If you have received this message in error, or are 
not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 
and delete this e-mail message from your computer, Thank 
you.*2

RE: RAC system Calls

[K Gopalakrishnan]

Title: RE: RAC system Calls



Raj:
 
I am 
discussing this issue with Ravi offline. From the initial
IPC 
dumps, It looks like the private interconnect is not
properly configured/used for cache fusion. I am waiting 
for
more 
details from him..
 
 
 
Best Regards,K Gopalakrishnan
-Original Message-From: [EMAIL PROTECTED] 
[mailto:[EMAIL PROTECTED]On Behalf Of Jamadagni, 
RajendraSent: Friday, July 11, 2003 7:34 AMTo: Multiple 
recipients of list ORACLE-LSubject: RE: RAC system 
Calls
That may be because with RAC there is more activity .. GCS 
traffic and more stats to update ... 
Raj  
Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! 
-Original Message- Sent: 
Thursday, July 10, 2003 8:14 PM To: Multiple recipients 
of list ORACLE-L 
Raj, Yes. Timed_statistics=true. But I 
see the 'times' even in single instance(non-rac)database 
but relatively called negligible number of times. 
-Ravi. 

Store and retrieve image from bfile in Oracle 8.1.7.4

[Liu, Jack]

Hi,
I use Oracle 8.1.7.4 to store some images with bfile. After I created a
directory in DB with "create or replace directory MY_FILES as '/mydir' "
and insert one image file with dbms_lob.loadfromfile(), then I found I don't
need to insert other images in that directory. I can retrieve and display
them in Web with dbms_lob.read() after I put some new images in that
directory, whatever the size, format (gif or jpg), even pdf (as long as I
use owa_util.mime_header to set mime type).
My question is: is this fine? I don't need to use ORDSYS.ORDImage and set
properties for them?

Thanks,

Jack

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

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

Re: LISTENER ON LINUX

[Boyle Candi]

ps -efw|grep tns

-Candi

On Fri, 2003-07-11 at 12:19, Seema Singh wrote:
> Hi
> When I try to see listener process on Linux box by ps -ef |grep tns .It 
> doen't show but when I tried to see the status thru lsnrctl status 
> listener_name .its shows service handler.
> How to check whether listener is running or not and how to start that?
> thx
> -seema
> 
> _
> STOP MORE SPAM with the new MSN 8 and get 2 months FREE*  
> http://join.msn.com/?page=features/junkmail
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: Seema Singh
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Boyle Candi
  INET: [EMAIL PROTECTED]

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

RE: LISTENER ON LINUX

[Weaver, Walt]

That's because it's truncating the line. Try ps -eflll instead.

--Walt Weaver
  Bozeman, Montana

> > -Original Message-
> > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf
Of
> > Seema Singh
> > Sent: Friday, July 11, 2003 17:20
> > To: Multiple recipients of list ORACLE-L
> > Subject: LISTENER ON LINUX
> >
> >
> > Hi
> > When I try to see listener process on Linux box by ps -ef
> > |grep tns .It
> > doen't show but when I tried to see the status thru lsnrctl status
> > listener_name .its shows service handler.
> > How to check whether listener is running or not and how to start
that?
> > thx
> > -seema
> >
> > _
> > STOP MORE SPAM with the new MSN 8 and get 2 months FREE*
> > http://join.msn.com/?page=features/junkmail
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > --
> > Author: Seema Singh
> >   INET: [EMAIL PROTECTED]
> >
> > Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> > San Diego, California-- Mailing list and web hosting
services
> >
-
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from).  You may
> > also send the HELP command for other information (like subscribing).
> >
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Grant Allen
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Weaver, Walt
  INET: [EMAIL PROTECTED]

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

RE: RAC system Calls

[Gogala, Mladen]

The "times" call is very cheap and could not possibly consume so much time.
Here is what man page says:

NAME
  times - get process and child process times

 SYNOPSIS
  #include 

  clock_t times(struct tms *buffer);

 DESCRIPTION
  times() fills the structure pointed to by buffer with time-accounting
  information.  The structure defined in  is as follows:

   struct tms {
   clock_t tms_utime;  /* user time */
   clock_t tms_stime;  /* system time */"
   clock_t tms_cutime; /* user time, children */
   clock_t tms_cstime; /* system time, children */
   };

  This information comes from the calling process and each of its
  terminated child processes for which it has executed a wait(),
  wait3(), or waitpid().  The times are in units of 1/CLK_TCK seconds,
  where CLK_TCK is processor dependent The value of CLK_TCK can be
  queried using the sysconf() function (see sysconf(2)).


Your problem is with the preceding "read" call. Try to figure out where is
attempting to read from, is there a process handling the file/device and
to which process is all that kernel CPU time billed. Try with ps -el and
top. Also, try with "netstat -i" to see whether you're retransmitting on
the high speed interconnect.

Mladen Gogala
Oracle DBA
Phone:(203) 459-6855
Email:[EMAIL PROTECTED]


-Original Message-
Sent: Friday, July 11, 2003 12:05 PM
To: Multiple recipients of list ORACLE-L


Mladen, As mentioned earlier, I have lots of "times"
funtion calls, which (my guess) relate to (60-70%)"IPC
send completion sync" waits I got in statspack. Dont
mean to fill your inboxes, but, pasting few truss
lines:
26949:  read(14, "01 O\0\006\0\0\0\0\011 i".., 2064)  
 = 335
26949:  times(0xFFBED228) 
 = 225698576
26949:  times(0xFFBED0D8) 
 = 225698576
26949:  times(0xFFBED228) 
 = 225698576
26949:  times(0xFFBED108) 
 = 225698576
26949:  times(0xFFBED108) 
 = 225698576
26949:  times(0xFFBED108) 
 = 225698577
26949:  times(0xFFBED108) 
 = 225698577
26949:  times(0xFFBECA08) 
 = 225698577
26949:  times(0xFFBECA08) 
 = 225698577
26949:  times(0xFFBECC88) 
 = 225698577
26949:  times(0xFFBECC88) 
 = 225698577
26949:  times(0xFFBED0D8) 
 = 225698577

Thanks,
Ravi.
--- "Gogala, Mladen" <[EMAIL PROTECTED]> wrote:
> Just for fun, have you tried using truss to find out
> which calls
> are being used? That might help you.
> 
> Mladen Gogala
> Oracle DBA
> Phone:(203) 459-6855
> Email:[EMAIL PROTECTED]
> 
> 
> -Original Message-
> Sent: Thursday, July 10, 2003 8:14 PM
> To: Multiple recipients of list ORACLE-L
> 
> 
> Raj,
> Yes. Timed_statistics=true. But I see the 'times'
> even
> in single instance(non-rac)database but relatively
> called negligible number of times.
> -Ravi.
> --- "Jamadagni, Rajendra"
> <[EMAIL PROTECTED]> wrote:
> > You seem to have timed_statistics=TRUE right ?? in
> > RAC you will ALWAYS see
> > GCS pings ... basically as long as
> > cluster_database=true, even if only one
> > node is running, you will still see Oracle trying
> to
> > ping other instances.
> > 
> > My guess is that's what is happening ... but I
> could
> > be very well wrong, I
> > have RAC experience, but never tried to truss the
> > top processes.
> > 
> > Raj
> >
>

> > 
> > Rajendra dot Jamadagni at nospamespn dot com
> > All Views expressed in this email are strictly
> > personal.
> > QOTD: Any clod can have facts, having an opinion
> is
> > an art !
> > 
> > 
> > -Original Message-
> > Sent: Thursday, July 10, 2003 12:30 PM
> > To: Multiple recipients of list ORACLE-L
> > 
> > 
> > Hello List,
> > 
> > We are running Benchmark tests on Solaris 2-Node
> > RAC.
> > Consistently noticed the following :
> > - Very high Kernel usage (averaging 45%) on TOP 
> > - Statspack has "IPC Send Completion sync" waits
> > (70%
> > Total ela time)
> > - On trussing top process, found Oracle to be
> > issuing
> > huge number of "times" system calls in addition to
> > read/writes(which I think are select/inserts).
> > Has anyone noticed this in your environment. I am
> > guessing these to be inter-instance pings, but
> could
> > not get any hits in Doc/Metalink to confirm this.
> > "times" call is clocking lot of CPU. Is this
> normal
> > ? 
> > Any pointers would be helpful ? If this is out of
> > context, is there a separate list for RAC?
> > 
> > Thanks,
> > Ravi.
> > 
> > 
> > 
> > __
> > Do you Yahoo!?
> > SBC Yahoo! DSL - Now only $29.95 per month!
> > http://sbc.yahoo.c

RE: LISTENER ON LINUX

[Grant Allen]

use ps -lax instead

Ciao
Fuzzy
:-)

> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of
> Seema Singh
> Sent: Friday, July 11, 2003 17:20
> To: Multiple recipients of list ORACLE-L
> Subject: LISTENER ON LINUX
> 
> 
> Hi
> When I try to see listener process on Linux box by ps -ef 
> |grep tns .It 
> doen't show but when I tried to see the status thru lsnrctl status 
> listener_name .its shows service handler.
> How to check whether listener is running or not and how to start that?
> thx
> -seema
> 
> _
> STOP MORE SPAM with the new MSN 8 and get 2 months FREE*  
> http://join.msn.com/?page=features/junkmail
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: Seema Singh
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Grant Allen
  INET: [EMAIL PROTECTED]

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

ODS architecture

[Stephane Paquette]

Hi all,

For those having built or working with an ODS, we are in the architecture
phase of building an ODS.

How do check integrity between the source systems and data in the ODS ?
In case of the ODS and the main source systems have lost synchronism, how do
resync the ODS ?

Any other major topics we should planned for ?

Thanks


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


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

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

materialized view log

[Li, Xiangli]

Hi, All
I have a question on how to interpret materialized view log, which has a
field change_vector$$. I think this fields record all the changes on master
table,  I need to understand the updates on the master table so I can
develop my own API to copy the change to a flat file.

Any help would be appreciated.

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

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

LISTENER ON LINUX

[Seema Singh]

Hi
When I try to see listener process on Linux box by ps -ef |grep tns .It 
doen't show but when I tried to see the status thru lsnrctl status 
listener_name .its shows service handler.
How to check whether listener is running or not and how to start that?
thx
-seema

_
STOP MORE SPAM with the new MSN 8 and get 2 months FREE*  
http://join.msn.com/?page=features/junkmail

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

Re: Tech meetings

[Hemant K Chitale]

I agree that Regularly Irregular meetings make more sense for people with
tech jobs.
Makes the meetings less "boring and predictable".
hemant
At 11:39 PM 08-07-03 -0800, you wrote:
I've found both as a manager in
Oracle and in Miracle that if you schedule regular meetings with the guys
(and girls), then they start not showing up after a while, or the
meetings become boring. If you don't hold regular meetings they'll
complain and wish for regular meetings.
So I've come up with this model:
1st meeting
2nd meeting after a week
3rd meeting after two weeks
4th meeting after four weeks
5th meeting after eight weeks (around here or at next iteration they
start complaining...)
6th meeting after a week...
7th meeting after two weeks...
Mvh Mogens
Babette Turner-Underwood wrote:
From
time to time, we go through a series of "show and tell" where
people do about an hour long presentation, question and answer on some
usually technical topic. Occasionally these presentations are business
related (eg explaining how the Canada Pension Plan international
agreements affects the programs we are doing).
 
They die off, then the director resurrects
them by asking for volunteers. Occasionally, people are told to do a
presentation on a specific work -related topic.
 
- 
Babette

-Original Message-
From:
[EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Rudy Zung
Sent: Tuesday, July 01, 2003 3:05 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: Tech meetings

Don't know if what we do in our shop here qualifies for your question or not, but our dev groups do "stand-up meetings." Relatively quick meetings (that can be done standing up; no meeting rooms required) that are usually finished in about 20 minutes. In the stand-ups, we get heads-up for things and specifications that might be coming down the pipeline from the product management and design side. We get a quick update on the state of deployment (what version has rolled into production, what version is in the QA pipeline) and what the next impending set of changes are about to get pushed onto the dev servers. If there's any potential "gotcha"s that have been experienced (especially on the coding front) they get publicized in the stand-ups as well.
 
The main point of our stand-ups are to make sure that all the developers are relatively aware of the scheduling and direction of the product, and to highlight any programming difficulties and workarounds that might arise so that when different developers hit those gotchas, they'll already know that a solution might already.
 
These stand-up meetings are basically within a development team/group. Project leads have their own meetings with the product management group. So essentially, the product manager has his own meetings; then the product manager has meetings with the dev project leads to convey what they want in the next iteration of the product; the project leads then present these to the dev group in a stand-up meeting.
-Original Message-
From: M.Godlewski [mailto:[EMAIL PROTECTED]] 
Sent: Tuesday, July 01, 2003 12:30 PM
To: Multiple recipients of list ORACLE-L
Subject: Tech meetings

List,
 
Just wondering if your organization has tech meetings, and what is discussed and what the goals of the meetings are?
 
I've been asked about this, and was wondering if there is a quick list out there any where.
 
TIA 
 


Hemant K Chitale
Oracle 9i Database Administrator Certified Professional
My personal web site is :  http://hkchital.tripod.com


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

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

RE: RAC system Calls

[Ravi Kulkarni]

Mladen, As mentioned earlier, I have lots of "times"
funtion calls, which (my guess) relate to (60-70%)"IPC
send completion sync" waits I got in statspack. Dont
mean to fill your inboxes, but, pasting few truss
lines:
26949:  read(14, "01 O\0\006\0\0\0\0\011 i".., 2064)  
 = 335
26949:  times(0xFFBED228) 
 = 225698576
26949:  times(0xFFBED0D8) 
 = 225698576
26949:  times(0xFFBED228) 
 = 225698576
26949:  times(0xFFBED108) 
 = 225698576
26949:  times(0xFFBED108) 
 = 225698576
26949:  times(0xFFBED108) 
 = 225698577
26949:  times(0xFFBED108) 
 = 225698577
26949:  times(0xFFBECA08) 
 = 225698577
26949:  times(0xFFBECA08) 
 = 225698577
26949:  times(0xFFBECC88) 
 = 225698577
26949:  times(0xFFBECC88) 
 = 225698577
26949:  times(0xFFBED0D8) 
 = 225698577

Thanks,
Ravi.
--- "Gogala, Mladen" <[EMAIL PROTECTED]> wrote:
> Just for fun, have you tried using truss to find out
> which calls
> are being used? That might help you.
> 
> Mladen Gogala
> Oracle DBA
> Phone:(203) 459-6855
> Email:[EMAIL PROTECTED]
> 
> 
> -Original Message-
> Sent: Thursday, July 10, 2003 8:14 PM
> To: Multiple recipients of list ORACLE-L
> 
> 
> Raj,
> Yes. Timed_statistics=true. But I see the 'times'
> even
> in single instance(non-rac)database but relatively
> called negligible number of times.
> -Ravi.
> --- "Jamadagni, Rajendra"
> <[EMAIL PROTECTED]> wrote:
> > You seem to have timed_statistics=TRUE right ?? in
> > RAC you will ALWAYS see
> > GCS pings ... basically as long as
> > cluster_database=true, even if only one
> > node is running, you will still see Oracle trying
> to
> > ping other instances.
> > 
> > My guess is that's what is happening ... but I
> could
> > be very well wrong, I
> > have RAC experience, but never tried to truss the
> > top processes.
> > 
> > Raj
> >
>

> > 
> > Rajendra dot Jamadagni at nospamespn dot com
> > All Views expressed in this email are strictly
> > personal.
> > QOTD: Any clod can have facts, having an opinion
> is
> > an art !
> > 
> > 
> > -Original Message-
> > Sent: Thursday, July 10, 2003 12:30 PM
> > To: Multiple recipients of list ORACLE-L
> > 
> > 
> > Hello List,
> > 
> > We are running Benchmark tests on Solaris 2-Node
> > RAC.
> > Consistently noticed the following :
> > - Very high Kernel usage (averaging 45%) on TOP 
> > - Statspack has "IPC Send Completion sync" waits
> > (70%
> > Total ela time)
> > - On trussing top process, found Oracle to be
> > issuing
> > huge number of "times" system calls in addition to
> > read/writes(which I think are select/inserts).
> > Has anyone noticed this in your environment. I am
> > guessing these to be inter-instance pings, but
> could
> > not get any hits in Doc/Metalink to confirm this.
> > "times" call is clocking lot of CPU. Is this
> normal
> > ? 
> > Any pointers would be helpful ? If this is out of
> > context, is there a separate list for RAC?
> > 
> > Thanks,
> > Ravi.
> > 
> > 
> > 
> > __
> > Do you Yahoo!?
> > SBC Yahoo! DSL - Now only $29.95 per month!
> > http://sbc.yahoo.com
> > -- 
> > Please see the official ORACLE-L FAQ:
> > http://www.orafaq.net
> > -- 
> > Author: Ravi Kulkarni
> >   INET: [EMAIL PROTECTED]
> > 
> > Fat City Network Services-- 858-538-5051
> > http://www.fatcity.com
> > San Diego, California-- Mailing list and
> web
> > hosting services
> >
>
-
> > To REMOVE yourself from this mailing list, send an
> > E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of
> > 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB
> > ORACLE-L
> > (or the name of mailing list you want to be
> removed
> > from).  You may
> > also send the HELP command for other information
> > (like subscribing).
> > >
>
*This
> > e-mail message is confidential, intended only for
> > the named recipient(s) above and may contain
> > information that is privileged, attorney work
> > product or exempt from disclosure under applicable
> > law. If you have received this message in error,
> or
> > are not the named recipient(s), please immediately
> > notify corporate MIS at (860) 766-2000 and delete
> > this e-mail message from your computer, Thank
> >
>
you.*1
> > 
> 
> 
> __
> Do you Yahoo!?
> SBC Yahoo! DSL - Now only $29.95 per month!
> http://sbc.yahoo.com
> -- 
> Please see the official ORACLE-L FAQ:
> http://www.o

RE: Billing cpu usage on a monthly basis

[DENNIS WILLIAMS]

Hans
I just returned from vacation and thought I'd fallen into the Twilight
Zone and returned to the glory days of time-sharing. My experience is that
you are talking real money here and be sure whatever you build, make it
bulletproof. It sounds as if you're already on the right track by
considering the consequences of aborted sessions. 
You could use the underlying O.S. usage statistics for this. However, if
you use a single instance installed as the "oracle" username, then nearly
all of the resource usage will be tagged to that username, rather than your
customer usernames. One way around that obstacle would be to create a
separate instance for each customer and have Oracle installed separately for
each customer.
That is about as profound as I can get on a Friday just returned from
vacation.

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


-Original Message-
Sent: Wednesday, July 09, 2003 3:04 AM
To: Multiple recipients of list ORACLE-L


Hi,

We're planning to consolidate a large amount of our production
databases into one database. Our customers will be charged based on
their use of the central machine's resources (other suggestions are
very welcome). I saw a method of keeping track of resource usage, by
means of the auditing mechanisms in Oracle:
- build a system trigger which recognises logon and logoff.

I assume that'll work just fine. However, I'm not sure how to charge
our customer for aborted sessions.

Any suggestions are very welcome.

HTH,
Hans de Git

_
MSN Zoeken, voor duidelijke zoekresultaten! http://search.msn.nl

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

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

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

RE: Unique constraint violation question.

[Igor Neyman]

Ron,

It's on Oracle's wishlist of enhancements -:)

Igor Neyman, OCP DBA
[EMAIL PROTECTED]



-Original Message-
Ron Rogers
Sent: Friday, July 11, 2003 9:21 AM
To: Multiple recipients of list ORACLE-L

Mladen,
 I looked through all of the manuals and online with a google search
for the "dbms_rtfm.database_concepts" and was not able to find it. Would
you please ,PLEASE, PAAALLLEEEASE list your references?  YEA RIGHT. 

I like to review the web sites for potential openings when I read some
of the questions . The answers are also thought provoking with a tongue
in cheek approach.
Ron mª¿ªm

>>> [EMAIL PROTECTED] 07/11/03 12:44AM >>>
There is a way, but you have to master the Tao first. When you
do, you will not ask questions like that. Short of that,
you could try selecting the record(s) from the table which
have the same unique key as the record you're trying to insert.
Truncate table will also rid you of the problems with duplicate
keys.

begin
dbms_rtfm.database_concepts;
end;
/




On 2003.07.11 00:29, [EMAIL PROTECTED] wrote:
> Hi, All,
> 
> When an unique constraint is violated, is there any way to know which
record
> cause this problem?
> 
> TIA,
> 
> Chuan
> Important: This transmission is intended only for the use of the
addressee
> and may contain confidential or legally privileged information.  If
you are
> not the intended recipient, you are notified that any use or
dissemination
> of this communication is strictly prohibited.  If you receive this
> transmission in error please notify the author immediately by
telephone and
> delete all copies of this transmission together with any
attachments.
> 
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net 
> --
> Author:
>   INET: [EMAIL PROTECTED] 
> 
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com 
> San Diego, California-- Mailing list and web hosting
services
>
-
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> 

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

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

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


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

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

RE: RAC system Calls

[Jamadagni, Rajendra]

Title: RE: RAC system Calls





That may be because with RAC there is more activity ... GCS traffic and more stats to update ...


Raj

Rajendra dot Jamadagni at nospamespn dot com
All Views expressed in this email are strictly personal.
QOTD: Any clod can have facts, having an opinion is an art !


-Original Message-
Sent: Thursday, July 10, 2003 8:14 PM
To: Multiple recipients of list ORACLE-L



Raj,
Yes. Timed_statistics=true. But I see the 'times' even
in single instance(non-rac)database but relatively
called negligible number of times.
-Ravi.



*This e-mail 
message is confidential, intended only for the named recipient(s) above and may 
contain information that is privileged, attorney work product or exempt from 
disclosure under applicable law. If you have received this message in error, or are 
not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 
and delete this e-mail message from your computer, Thank 
you.*1

Re: Unique constraint violation question.

[Ron Rogers]

Mladen,
 I looked through all of the manuals and online with a google search
for the "dbms_rtfm.database_concepts" and was not able to find it. Would
you please ,PLEASE, PAAALLLEEEASE list your references?  YEA RIGHT. 

I like to review the web sites for potential openings when I read some
of the questions . The answers are also thought provoking with a tongue
in cheek approach.
Ron mª¿ªm

>>> [EMAIL PROTECTED] 07/11/03 12:44AM >>>
There is a way, but you have to master the Tao first. When you
do, you will not ask questions like that. Short of that,
you could try selecting the record(s) from the table which
have the same unique key as the record you're trying to insert.
Truncate table will also rid you of the problems with duplicate
keys.

begin
dbms_rtfm.database_concepts;
end;
/




On 2003.07.11 00:29, [EMAIL PROTECTED] wrote:
> Hi, All,
> 
> When an unique constraint is violated, is there any way to know which
record
> cause this problem?
> 
> TIA,
> 
> Chuan
> Important: This transmission is intended only for the use of the
addressee
> and may contain confidential or legally privileged information.  If
you are
> not the intended recipient, you are notified that any use or
dissemination
> of this communication is strictly prohibited.  If you receive this
> transmission in error please notify the author immediately by
telephone and
> delete all copies of this transmission together with any
attachments.
> 
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net 
> --
> Author:
>   INET: [EMAIL PROTECTED] 
> 
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com 
> San Diego, California-- Mailing list and web hosting
services
>
-
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> 

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

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

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

RE: Copying database from vxfs to ufs

[Gogala, Mladen]

You have to move them to NTFS on SUN first.

Mladen Gogala
Oracle DBA
Phone:(203) 459-6855
Email:[EMAIL PROTECTED]


-Original Message-
Sent: Thursday, July 10, 2003 9:04 PM
To: Multiple recipients of list ORACLE-L


Hi,
I have a database (200GB+ 8.1.7.4 version) on Vxfs file systems on a Sun
server ( Solaris 8), which I need to migrate to Ufs file systems mounted on
same server. To cut the migration time,
can I copy the database files from vxfs to ufs ie across the different
filesystems type. Has anyone done it and noticed any problems.  Is it
supported ?

Thanks in advance.
Manmohan



Get advanced SPAM filtering on Webmail or POP Mail ... Get Lycos Mail!
http://login.mail.lycos.com/r/referral?aid=27005
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Anubha Jalsingh
  INET: [EMAIL PROTECTED]

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

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

RE: RAC system Calls

[Gogala, Mladen]

Just for fun, have you tried using truss to find out which calls
are being used? That might help you.

Mladen Gogala
Oracle DBA
Phone:(203) 459-6855
Email:[EMAIL PROTECTED]


-Original Message-
Sent: Thursday, July 10, 2003 8:14 PM
To: Multiple recipients of list ORACLE-L


Raj,
Yes. Timed_statistics=true. But I see the 'times' even
in single instance(non-rac)database but relatively
called negligible number of times.
-Ravi.
--- "Jamadagni, Rajendra"
<[EMAIL PROTECTED]> wrote:
> You seem to have timed_statistics=TRUE right ?? in
> RAC you will ALWAYS see
> GCS pings ... basically as long as
> cluster_database=true, even if only one
> node is running, you will still see Oracle trying to
> ping other instances.
> 
> My guess is that's what is happening ... but I could
> be very well wrong, I
> have RAC experience, but never tried to truss the
> top processes.
> 
> Raj
>

> 
> Rajendra dot Jamadagni at nospamespn dot com
> All Views expressed in this email are strictly
> personal.
> QOTD: Any clod can have facts, having an opinion is
> an art !
> 
> 
> -Original Message-
> Sent: Thursday, July 10, 2003 12:30 PM
> To: Multiple recipients of list ORACLE-L
> 
> 
> Hello List,
> 
> We are running Benchmark tests on Solaris 2-Node
> RAC.
> Consistently noticed the following :
> - Very high Kernel usage (averaging 45%) on TOP 
> - Statspack has "IPC Send Completion sync" waits
> (70%
> Total ela time)
> - On trussing top process, found Oracle to be
> issuing
> huge number of "times" system calls in addition to
> read/writes(which I think are select/inserts).
> Has anyone noticed this in your environment. I am
> guessing these to be inter-instance pings, but could
> not get any hits in Doc/Metalink to confirm this.
> "times" call is clocking lot of CPU. Is this normal
> ? 
> Any pointers would be helpful ? If this is out of
> context, is there a separate list for RAC?
> 
> Thanks,
> Ravi.
> 
> 
> 
> __
> Do you Yahoo!?
> SBC Yahoo! DSL - Now only $29.95 per month!
> http://sbc.yahoo.com
> -- 
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.net
> -- 
> Author: Ravi Kulkarni
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051
> http://www.fatcity.com
> San Diego, California-- Mailing list and web
> hosting services
>
-
> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of
> 'ListGuru') and in
> the message BODY, include a line containing: UNSUB
> ORACLE-L
> (or the name of mailing list you want to be removed
> from).  You may
> also send the HELP command for other information
> (like subscribing).
> >
*This
> e-mail message is confidential, intended only for
> the named recipient(s) above and may contain
> information that is privileged, attorney work
> product or exempt from disclosure under applicable
> law. If you have received this message in error, or
> are not the named recipient(s), please immediately
> notify corporate MIS at (860) 766-2000 and delete
> this e-mail message from your computer, Thank
>
you.*1
> 


__
Do you Yahoo!?
SBC Yahoo! DSL - Now only $29.95 per month!
http://sbc.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Ravi Kulkarni
  INET: [EMAIL PROTECTED]

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

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