Re: perl dbi dbd

[Mladen Gogala]

HP has pretty good customer service. They have usenet discussion
forums on which they readily help. I'm sure that a question like
would not take HP long time to answer.
On 2003.10.03 00:34, "Jesse, Rich" wrote:
Well, it's not at http://hpux.cs.utah.edu/, so I'm not sure where you can
get it.  Are you sure you can't build it?  It'll build with the icky
non-ANSI cc that comes with HP/UX (I think).  Or d/l a gcc binary depot from
the above site and compile it with that.
There is at least one major caveat with DBI/DBD::Oracle on HP/UX.  You must
have compiled Perl to use threads in order to use DBI.  Also, you may need
to define LD_PRELOAD in order to avoid runtime problems.  OK, so that's
two...  Anyway, see the DBI/DBD::Oracle docs and a Google search for hints
on these.
Hope you get a binary running!  GL!

Rich

Rich Jesse   System/Database Administrator
[EMAIL PROTECTED]  Quad/Tech Inc, Sussex, WI USA
-Original Message-
Sent: Thursday, October 02, 2003 5:40 PM
To: Multiple recipients of list ORACLE-L
where can I get binaries for perl DBI and DBD for hp-ux 9000 . I dont have
pre requisite for building binaries from source .
Thanks,
-ak
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Jesse, Rich
  INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
--
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: perl dbi dbd

[Jesse, Rich]

Well, it's not at http://hpux.cs.utah.edu/, so I'm not sure where you can
get it.  Are you sure you can't build it?  It'll build with the icky
non-ANSI cc that comes with HP/UX (I think).  Or d/l a gcc binary depot from
the above site and compile it with that.

There is at least one major caveat with DBI/DBD::Oracle on HP/UX.  You must
have compiled Perl to use threads in order to use DBI.  Also, you may need
to define LD_PRELOAD in order to avoid runtime problems.  OK, so that's
two...  Anyway, see the DBI/DBD::Oracle docs and a Google search for hints
on these.

Hope you get a binary running!  GL!

Rich

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

-Original Message-
Sent: Thursday, October 02, 2003 5:40 PM
To: Multiple recipients of list ORACLE-L


where can I get binaries for perl DBI and DBD for hp-ux 9000 . I dont have
pre requisite for building binaries from source .
 
Thanks,
-ak
 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jesse, Rich
  INET: [EMAIL PROTECTED]

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

Re: RE: Hiding passwords

[Nuno Pinto do Souto]

> Bob Metelsky <[EMAIL PROTECTED]> wrote:
> That's very interesting... Thank you. Do you know how that can be set
> in
> an env variable? Or how the hidden variable can be passed around?
> Eg
> C:\ads>set var= Or
> C:\ads>set var=more Echo %var%
> C:\ads> echo is on
> ???

This works in XP Pro, dunno about older versions:

Y:\>echo password >file.txt:pwd
Y:\>type file.txt
Y:\>more more zot.txt
Y:\>type zot.txt
password
Y:\>for /F "usebackq" %i in (`type zot.txt`) do @set zot=%i
^^

Y:\>set
yaddayaddayadda...
windir=C:\WINDOWS
ZOT=password
Y:>del zot.txt

Assuming you do this within "setlocal", you should be fine.
HTH
Cheers
Nuno Souto
[EMAIL PROTECTED]
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Nuno Pinto do Souto
  INET: [EMAIL PROTECTED]

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

Re: Seems odd to me....(bug?)

[Wolfgang Breitling]

scott> @connect system/manager

system> create table employee_role (a number);

Table created.

system> grant all on employee_role to scott;

Grant succeeded.

system> @connect scott/tiger
Connected.
scott> create synonym employee_role for system.employee_role;

Synonym created.

scott> select * from employee_role;

no rows selected

scott> @connect system/manager
Connected.
system> revoke all on employee_role from scott;

Revoke succeeded.

system>  @connect scott/tiger
Connected.
scott> INSERT INTO EMPLOYEE_ROLE VALUES ('C', 'CSR',NULL);
INSERT INTO EMPLOYEE_ROLE VALUES ('C', 'CSR',NULL)
*
ERROR at line 1:
ORA-00942: table or view does not exist
scott>

Do a "select * from user_objects where object_name = 'EMPLOYEE_ROLE' "
At 04:39 PM 10/2/2003, you wrote:
Oracle EE 8.1.7.2
HP-UX 11
Can anyone explain this?

1* INSERT INTO EMPLOYEE_ROLE VALUES ('C', 'CSR',NULL)

SQL> /

INSERT INTO EMPLOYEE_ROLE VALUES ('C', 'CSR',NULL)

*

ERROR at line 1:

ORA-00604: error occurred at recursive SQL level 1

ORA-00942: table or view does not exist

  1* select count(*) from user_tables where table_name='EMPLOYEE_ROLE'
SQL> /
  COUNT(*)
--
 1
SQL> CREATE TABLE EMPLOYEE_ROLE AS SELECT * FROM USER_TABLES;

CREATE TABLE EMPLOYEE_ROLE AS SELECT * FROM USER_TABLES

 *

ERROR at line 1:

ORA-00955: name is already used by an existing object



Any ideas?

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

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

Translations needed into Spanish, German, French, Mandarin, Thai

[Ferenc Mantfeld]

Hi All

I am looking for a bunch of messages, field names and labels to be
translated into German, French, Spanish, Mandarin and Thai.

There are about 150 values, and if you are experienced at this stuff (have
developed software or codes specifically in any of the languages listed
above), please email me privately. It is a quick once-off job that I am
willing to pay for.

Regards:

Ferenc Mantfeld
Dreaming costs you nothing. Not dreaming costs you everything.

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

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Create Table..As Select: Number formats

[Mark Richard]

I'm perhaps a little late replying, but have you looked at using

"alter table xxx modify (column number(1,2));" for example to modify the
number format after creating the partition.  I'm expecting there to be
limits but it sounds like you are only trying to increase the number type
size not decrease it.  Also, you might wear some table scans while it
inspects data depending on the change but might be acceptable depending on
volumes and timeframes.



   
   
  [EMAIL PROTECTED]
   
  isys.co.uk   To:   Multiple recipients of list 
ORACLE-L <[EMAIL PROTECTED]>  
  Sent by: cc: 
   
  [EMAIL PROTECTED]Subject:  RE: RE: Create Table..As 
Select: Number formats  
  .com 
   
   
   
   
   
  02/10/2003 03:09 
   
  Please respond to
   
  ORACLE-L 
   
   
   
   
   




Thanks to everyone who responded to this thread -

Option A is now to persuade the designers to remove the Number formatting
from the parttioned table,
Option B is to pre-create the working table and populate it with Truncate
and Insert /* Append */

Option B will be slower, I think, due to the extra redo/undo generated
despite my best efforts to persuade it otherwise.  I've done enough tests
with changing the format of the number columns to convince myself that
that the calculated Number columns are the only remaining issue.

Cheers
Simon Anderson

>>I'm trying to create a table using 'Create
>>Table...As Select...'
...
>  Are you sure that it comes from the NUMBER() columns? Reminds me of the
problem when you have a NULL in a UNION,
> which must be explicitly cast with a to_number(), to_date() or
to_char(). Might it come from some NULL in your CREATE > TABLE AS SELECT
... ?
>
> Regards,
>
> Stephane Faroult
> Oriole

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



<<>>
   Privileged/Confidential information may be contained in this message.
  If you are not the addressee indicated in this message
   (or responsible for delivery of the message to such person),
you may not copy or deliver this message to anyone.
In such case, you should destroy this message and kindly notify the sender
   by reply e-mail or by telephone on (61 3) 9612-6999.
   Please advise immediately if you or your employer does not consent to
Internet e-mail for messages of this kind.
Opinions, conclusions and other information in this message
  that do not relate to the official business of
 Transurban City Link Ltd
 shall be understood as neither given nor endorsed by it.
<<<>




<<>>
Privileged/Confidential information may be contained in this message.
If you are not the addressee indicated in this message (or responsible fo

Re: exam

[bulbultyagi]

 The exam was well made.  They were very keen on
1.  the exact values of the various hit ratios
2.  deadlocks.
All in all I would say that the preparation for this exam is a lot more
tougher than the exam itself.  Performance tuning course is VAST.  But I
could be wrong about the exam, because frankly the exam is all blurred in my
memory.   I don't remember the questions , all I remember is that as soon as
the paper started I found that all the v$ synonyms stopped making sense to
me.  Had to read the words in the questions much more carefully in this exam
than in any other exam.  Most of the answers are so close to being correct
till you zero in on that one word in the answer which makes the answer
either totally wrong or "the one".  Performance tuning exam , well all I can
say is that I am glad that its over.  Now I can actually start studying
performance tuning.
Still have my sql exam left though.

- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Wednesday, October 01, 2003 20:29


> Congrats!
>
> How did you find the exam, Easy? Tough? Ambigous?
>
> Regards
> Naveen
>
> >>>-Original Message-
> >>>From: [EMAIL PROTECTED]
> >>>[mailto:[EMAIL PROTECTED]
> >>>Sent: Wednesday, October 01, 2003 7:55 PM
> >>>To: Multiple recipients of list ORACLE-L
> >>>Subject: exam
> >>>
> >>>
> >>>List , thanks to you all I passed my oracle 9i performance
> >>>tuning exam today
> >>>with good marks.
> >>>Thank you
> >>>
> >>>
> >>>--
> >>>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).
> >>>
>
>
> DISCLAIMER:
> This message (including attachment if any) is confidential and may be
privileged. Before opening attachments please check them for viruses and
defects. MindTree Consulting Private Limited (MindTree) will not be
responsible for any viruses or defects or any forwarded attachments
emanating either from within MindTree or outside. If you have received this
message by mistake please notify the sender by return  e-mail and delete
this message from your system. Any unauthorized use or dissemination of this
message in whole or in part is strictly prohibited.  Please note that
e-mails are susceptible to change and MindTree shall not be liable for any
improper, untimely or incomplete transmission.
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Naveen Nahata
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (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: exam

[bulbultyagi]

> Congratulations.

Thanks

>Do you feel you learned anything from this exam?

My initial answer was :  If there is one thing that I have learnt from this
exam , its that "studying for an exam is different from studying".  This
principle doesn't seem to apply so much to "backup and recovery" ,
"adminstration fundamentals" ,etc.

However now that I have had a day to think about your question I have the
following to say.
I have spent all this time ( while I was preparing for this exam)
complaining and being nervous.  I was wrong to complain.  Its only when we
have a deadline to meet that we sit down and devote time to something.  If
nothing else this exam made me sit down and give time to studying and
learning.  I am glad that this exam is a part of ocp.  Because of this exam
I came into contact with so many wonderful new things and concepts.  Granted
that the very fact that I had a deadline to meet meant that I only learnt
their names and did not get to know them well but I learnt that the rabbit
hole really goes deep .   This exam has taught me to respect performance
tuning.  If i did not have to give this exam , I would have remained
oblivious to my ignorance.  Now I feel more humble and at the same time
eager to learn.
Thanks list, I am lucky to learn from you all.


>
>
>
> Dennis Williams
> DBA, 80%OCP, 100% DBA
> Lifetouch, Inc.
> [EMAIL PROTECTED]
>
>
> -Original Message-
>
> List , thanks to you all I passed my oracle 9i performance tuning exam
today
> with good marks.
> Thank you
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: DENNIS WILLIAMS
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
>

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

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

RE: Physical I/O and databases other than oracle

[Grant Allen]

> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 
> Sent: Friday, October 03, 2003 3:15 AM
> To: Multiple recipients of list ORACLE-L
> Subject: Re: Physical I/O and databases other than oracle
> 
> 
> my email states that in oracle this isnt true. HOWEVER, what 
> about other databases? 

At the risk of trivialising things, there are basically no differences
with other databases.  It's a question of how quickly the DBA community
for a given database has woken up to the fact that BCHR is a
rarely-useful measure.

For instance, the DB2 people worked this out a long time ago (though
they still focus heavily on buffer pool tuning, as many of them
genuinely have physical i/o issues with the huge batch jobs they run).
As for the SQL Server people, the light is only just starting to dawn.
90% or more of the performance posts to the sql2k list (see
www.sswug.com) start with "My windoze box has 2GB of RAM, and my
instance has 99.999% hit ratio, but performance is still a dog.
Help me add more memory".  Gentle attempts at suggesting they attempt to
find the real culprit, rather than guess, are howled down in the stamped
of the hit ratio mob.

Ciao for now
Fuzzy
(It's good to be back)
-- 
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).

Can't order XMLAGG()

[Debian User]

Hello,
I am trying to order my xmlagg function in oracle and the documented
query doesn't work.

SELECT XMLELEMENT("Department",
   XMLAGG( XMLELEMENT("Employee", e.job_id||' '||e.last_name)
  ORDER BY last_name))
  as "Dept_list" 
   FROM employees e
   WHERE e.department_id = 30;

Disconnected from Oracle9i Enterprise Edition Release 9.2.0.1.0 -
Production
With the OLAP and Oracle Data Mining options
JServer Release 9.2.0.1.0 - Production

Any ideas would be a great help.
Thanks,
Jake

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

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

[Mark Richard]

I've seen similar problems where public synonyms exist.  You would think
that nothing would appear in user tables though.  Perhaps check all_tables
and look for the owners.  Also, try "desc table" and "desc owner.table" to
see if the result is the same.

Like I said - I hit similar problems in test schema's when the table
doesn't exist but there is a public synonym to the table in another schema
with only read access.

Regards,
  Mark.



   
   
  Chris Stephens   
   
  <[EMAIL PROTECTED]To:   Multiple recipients of list 
ORACLE-L <[EMAIL PROTECTED]>  
  fina.com>cc: 
   
  Sent by: Subject:  Seems odd to me(bug?) 
   
  [EMAIL PROTECTED]
   
  .com 
   
   
   
   
   
  03/10/2003 08:39 
   
  Please respond to
   
  ORACLE-L 
   
   
   
   
   




Oracle EE 8.1.7.2
HP-UX 11

Can anyone explain this?

1* INSERT INTO EMPLOYEE_ROLE VALUES ('C', 'CSR',NULL)

SQL> /

INSERT INTO EMPLOYEE_ROLE VALUES ('C', 'CSR',NULL)

*

ERROR at line 1:

ORA-00604: error occurred at recursive SQL level 1

ORA-00942: table or view does not exist


  1* select count(*) from user_tables where table_name='EMPLOYEE_ROLE'
SQL> /

  COUNT(*)
--
 1

SQL> CREATE TABLE EMPLOYEE_ROLE AS SELECT * FROM USER_TABLES;

CREATE TABLE EMPLOYEE_ROLE AS SELECT * FROM USER_TABLES

 *

ERROR at line 1:

ORA-00955: name is already used by an existing object




Any ideas?


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

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



<<>>
   Privileged/Confidential information may be contained in this message.
  If you are not the addressee indicated in this message
   (or responsible for delivery of the message to such person),
you may not copy or deliver this message to anyone.
In such case, you should destroy this message and kindly notify the sender
   by reply e-mail or by telephone on (61 3) 9612-6999.
   Please advise immediately if you or your employer does not consent to
Internet e-mail for messages of this kind.
Opinions, conclusions and other information in this message
  that do not relate to the official business of
 Transurban City Link Ltd
 shall be understood as neither given nor endorsed by it.
<<<>




<<>>
Privileged/Confidential information may be contained in this message.
If you are not the addressee indicated in this message (or responsible for delivery of 
the message to such person), you may not copy or deliver this message to anyone.
In such a case, you should destroy this message and kindly n

RE: how to send mail from windows command prompt?

[Ari, Rama]

Title: RE: how to send mail from windows command prompt?





Murali,


I am using blat and it is working great. You could download necessary software from www.blat.net


Thanks,


Rama Ari
Database Administrator
[EMAIL PROTECTED]
610.964.5128



-Original Message-
From: Murali_Pavuloori/[EMAIL PROTECTED]
[mailto:Murali_Pavuloori/[EMAIL PROTECTED]]
Sent: Thursday, October 02, 2003 6:15 PM
To: Multiple recipients of list ORACLE-L
Subject: how to send mail from windows command prompt?




Hello All:


I have setup some scripts that would export the db every day. Instead of
looking through the logs manually every morning, is there a way to tail
(windoze equivalent?) the file and send and email (mailx equivalent on
windows?) I know this can be implemented in Perl, but I don't know perl so
I am looking for help on Windoze...PLEASE!


I really appreciate your help in this matter.


Thanks,
Murali.



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


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

[Khedr, Waleed]

Could it be that the table has a trigger and it's trying to insert into
another table that does not exist?

Can you read from the table?

Waleed

-Original Message-
Sent: Thursday, October 02, 2003 6:40 PM
To: Multiple recipients of list ORACLE-L


Oracle EE 8.1.7.2
HP-UX 11

Can anyone explain this?  

1* INSERT INTO EMPLOYEE_ROLE VALUES ('C', 'CSR',NULL)

SQL> /

INSERT INTO EMPLOYEE_ROLE VALUES ('C', 'CSR',NULL)

*

ERROR at line 1:

ORA-00604: error occurred at recursive SQL level 1

ORA-00942: table or view does not exist

 
  1* select count(*) from user_tables where table_name='EMPLOYEE_ROLE'
SQL> /

  COUNT(*)
--
 1
 
SQL> CREATE TABLE EMPLOYEE_ROLE AS SELECT * FROM USER_TABLES;

CREATE TABLE EMPLOYEE_ROLE AS SELECT * FROM USER_TABLES

 *

ERROR at line 1:

ORA-00955: name is already used by an existing object

 

 
Any ideas?


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

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

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

Deterministic Functions: am I missing something?

[Khedr, Waleed]

drop table test_det; 
create table test_det (c1 date); 
create or replace function f2 (p1 in number, p2 in number) return number
deterministic is
pragma autonomous_transaction;
begin
 insert into test_det values (sysdate);
 commit;
return(p1 * p2);
end; 
/
 select f2 (1,3) from dual where f2 (1,3) = 3; 
F2(1,3)
--
3 
 select * from test_det; 
C1
-
02-OCT-03
02-OCT-03
It did not save an execution even in the same sql call!
Oracle 9.2.0.2 Solaris 2.8
Regards,

Waleed

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

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

Seems odd to me....(bug?)

[Chris Stephens]

Oracle EE 8.1.7.2
HP-UX 11

Can anyone explain this?  

1* INSERT INTO EMPLOYEE_ROLE VALUES ('C', 'CSR',NULL)

SQL> /

INSERT INTO EMPLOYEE_ROLE VALUES ('C', 'CSR',NULL)

*

ERROR at line 1:

ORA-00604: error occurred at recursive SQL level 1

ORA-00942: table or view does not exist

 
  1* select count(*) from user_tables where table_name='EMPLOYEE_ROLE'
SQL> /

  COUNT(*)
--
 1
 
SQL> CREATE TABLE EMPLOYEE_ROLE AS SELECT * FROM USER_TABLES;

CREATE TABLE EMPLOYEE_ROLE AS SELECT * FROM USER_TABLES

 *

ERROR at line 1:

ORA-00955: name is already used by an existing object

 

 
Any ideas?


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

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

perl dbi dbd

[AK]

where can I get binaries for perl DBI and DBD for 
hp-ux 9000 . I dont have pre requisite for building binaries from source 
.
 
Thanks,
-ak
 

RE: locally managed autoallocate (was: Separate Indexes and Data)

[Jesse, Rich]

Well, sort of.  If I had a 9i DB to play with, I'd try this myself...

1)  Create an SMT.
2)  Create 50 tables in that TS.
3)  Drop every even table just created.
4)  Extend one of the remaining tables until you can't.

Depending on the size of the TS created and the blocksize, you could have a
situation where there's enough freespace in the TS, but not contiguous.
Thus, fragmentation.

Granted, this is isn't a typical case, but over a year or two, I could see
it happening here.

Maybe I'll install 9iR2 at home tonite to try this...


Rich

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


> -Original Message-
> From: Niall Litchfield [mailto:[EMAIL PROTECTED]
> Sent: Thursday, October 02, 2003 5:10 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: locally managed autoallocate (was: Separate Indexes and
> Data)
> 
> 
> > > -Original Message-
> > > From: Jesse, Rich
> > > Sent: Wednesday, October 01, 2003 9:49 AM
> > > To: Multiple recipients of list ORACLE-L
> > > Subject: RE: locally managed autoallocate (was: Separate 
> Indexes and
> > > Data)
> > > 
> > > Theoritically, perhaps, but what if an existing table needs
> > > to auto-extend
> > > at 1M and all that's left in the table is 16 (or whatever) 
> > 
> > (blush)  Obviously, that's supposed to say "left in the tableSPACE".
> 
> 9.0.1 'unable to allocate extent'
> 
> C:\Documents and Settings\Niall>sqlplus niall/niall
> 
> SQL*Plus: Release 9.2.0.1.0 - Production on Thu Oct 2 21:59:45 2003
> 
> Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.
> 
> 
> Connected to:
> Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
> With the Partitioning, OLAP and Oracle Data Mining options
> JServer Release 9.2.0.1.0 - Production
> 
> SQL> create tablespace test_auto
>   2  datafile 'c:\oracle\oradata\home9i\test_auto.dbf' size 1152k
>   3  extent management local;
> 
> Tablespace created.
> 
> SQL> create table t1(n number,charcol char(200))
>   2  tablespace test_auto
>   3  ;
> 
> Table created.
> 
> SQL> select count(*) from dba_extents where segment_name='T1';
> 
>   COUNT(*)
> --
>  1
>
 
[snip]
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jesse, Rich
  INET: [EMAIL PROTECTED]

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

RE: ORA-06401 NETCMN INVALID DRIVER

[Ramón Estevez]

Problem solved, had to include the domain name in the hostname

Hostname.domain:1521:orcl

Tks anyway

Ramon E. Estevez
[EMAIL PROTECTED]
809-535-8994



-Original Message-
Sent: Thursday, October 02, 2003 4:15 PM
To: Multiple recipients of list ORACLE-L


Hi list,

I just installed 9IAS R2, the J2EE and Web Cache option.  Before creating a DAD I'm 
trying to connect to a DB 
in a linux server, from the APP Server, with SQL Plus using host:port:orcl and get 
this error.  

In metalink direct me to modify the TNSNAMES.ORA file but the installation didn't 
created it, 

Do I need it a TNSNAMES.ORA to connect using this method?

What should I do ?

TIA

Ramon E. Estevez
[EMAIL PROTECTED]
809-535-8994


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: =?iso-8859-1?Q?Ram=F3n_Estevez?=
  INET: [EMAIL PROTECTED]

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

how to send mail from windows command prompt?

[Murali_Pavuloori/Claritas]

Hello All:

I have setup some scripts that would export the db every day. Instead of
looking through the logs manually every morning, is there a way to tail
(windoze equivalent?) the file and send and email (mailx equivalent on
windows?) I know this can be implemented in Perl, but I don't know perl so
I am looking for help on Windoze...PLEASE!

I really appreciate your help in this matter.

Thanks,
Murali.


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

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: locally managed autoallocate (was: Separate Indexes and Data)

[Niall Litchfield]

> > -Original Message-
> > From: Jesse, Rich
> > Sent: Wednesday, October 01, 2003 9:49 AM
> > To: Multiple recipients of list ORACLE-L
> > Subject: RE: locally managed autoallocate (was: Separate Indexes and
> > Data)
> > 
> > Theoritically, perhaps, but what if an existing table needs
> > to auto-extend
> > at 1M and all that's left in the table is 16 (or whatever) 
> 
> (blush)  Obviously, that's supposed to say "left in the tableSPACE".

9.0.1 'unable to allocate extent'

C:\Documents and Settings\Niall>sqlplus niall/niall

SQL*Plus: Release 9.2.0.1.0 - Production on Thu Oct 2 21:59:45 2003

Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.


Connected to:
Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.1.0 - Production

SQL> create tablespace test_auto
  2  datafile 'c:\oracle\oradata\home9i\test_auto.dbf' size 1152k
  3  extent management local;

Tablespace created.

SQL> create table t1(n number,charcol char(200))
  2  tablespace test_auto
  3  ;

Table created.

SQL> select count(*) from dba_extents where segment_name='T1';

  COUNT(*)
--
 1

SQL> begin
  2  for i in 1..14 loop
  3  execute immediate 'alter table t1 allocate extent';
  4  end loop;
  5  end;
  6  /

PL/SQL procedure successfully completed.

SQL> analyze table t1 compute statistics;

Table analyzed.

SQL> select count(*) from dba_extents where segment_name='T1';

  COUNT(*)
--
15

SQL> alter table t1 allocate extent;

Table altered.

SQL> select count(*) from dba_extents where segment_name='T1';

  COUNT(*)
--
16

SQL> alter table t1 allocate extent;
alter table t1 allocate extent
*
ERROR at line 1:
ORA-01653: unable to extend table NIALL.T1 by 128 in tablespace
TEST_AUTO


SQL> select bytes from dba_free_space where tablespace_name='TEST_AUTO';

 BYTES
--
 65536

SQL> create table tX(n number,charcol char(200))
  2  tablespace test_auto;

Table created.


Niall 

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

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

[Tim Gorman]

Title: Re: Oracle Client for Macintosh



There are no downloadable clients.  Only the server v9201, which is all character-mode (yay!)...


on 10/1/03 8:24 PM, [EMAIL PROTECTED] at [EMAIL PROTECTED] wrote:


I've searched TechNet and MetaLink but can't find a downloadable 8i, 9i, anything Oracle Client for Apple Macintosh - OS 9 or OS X.  What am I missing?  Is it not available?  Some docs on MetaLink mention it, but the versions seem related to SQL*Net, not the RDBMS.  I'm clueless when it comes to Macs, so I probably don't know the right keywords. 

Could someone point me in the right direction? 

Thanks.

Jack C. Applewhite
Database Administrator
Austin Independent School District
Austin, Texas
512.414.9715 (wk)
512.935.5929 (pager, [EMAIL PROTECTED])
[EMAIL PROTECTED]

RE: SQLServer resources

[Paula_Stankus]

Title: Message



Okay,
 
There 
are some e-mail lists.  There is also books online that comes with SQL 
Server which goes over production support issues as you have named.  Where 
I work they user Veritas Backupexec which is pretty easy to use so I don't know 
about SQL Server's backups.  I prefer RMAN/scripting in the Oracle World 
but in SQL Server I am thinking Veritas is good for backing things up.  

 
Here 
is a list:
 
SQL 
Server 2k List
 
I hope 
that helps.  There is also the sql server user's group.  

 
Hey, 
maybe we should start a list for Oracle/SQL Server DBA's.  

 
BTW, 
on the SQL Server site there is a pretty interesting document on SQL Server for 
Oracle DBA's and presentation (it is not completely accurate on the Oracle side 
- but I am sure you will know exactly what I mean) - however, the comparison is 
still useful.

  -Original Message-From: Cunningham, Gerald 
  [mailto:[EMAIL PROTECTED]Sent: Thursday, October 02, 2003 
  2:10 PMTo: Multiple recipients of list ORACLE-LSubject: 
  OT: SQLServer resources
  Hi 
  all,
   
  Can anybody point 
  me to a mailing list such as this for SQLServer? (I would be suprised if 
  there's something of ORACLE-L's quality, but you never know!). Or, any other 
  resources on the web? I'm particularly interested in production support 
  (performance tuning, security, backup/recovery, etc.)
   
  Thank you very 
  much!
   
  - 
  Jerry
   

Re: UNIX : script help/input

[Jared . Still]

I would be tempted to use Java for this rather than C.

Much more portable than external procedures, an important distinction
in a heterogenous shop.

Jared







Vladimir Begun <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
 10/02/2003 12:34 PM
 Please respond to ORACLE-L

        
        To:        Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
        cc:        
        Subject:        Re: UNIX : script help/input


Jamadagni, Rajendra wrote:
> unfortunately we _had_ to do it in pl/sql ... it is part of the 
> encrypted feed that we send out to our clients ... it is decoded by a chip.
>  
> Oh well  I am back to array of references ...

I'd suggest to consider external C function -- it's faster, it's
easier to write especially when you need to work with bits, shifts
etc.. I've recently implemented crc32 for some internal project --
works well, obviously faster than SQL, PL/SQL and native comp of
PL/SQL code. Native comp. is also good to consider, if it's 9i.
Sure, it depends...
-- 
Vladimir Begun
The statements and opinions expressed here are my own and
do not necessarily represent those of Oracle Corporation.

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

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

[Cunningham, Gerald]

Title: Message



Thanks, everybody, for the SQL Server info...

  
  -Original Message-From: Farnsworth, Dave 
  [mailto:[EMAIL PROTECTED] Sent: Thursday, October 
  02, 2003 2:40 PMTo: Multiple recipients of list 
  ORACLE-LSubject: RE: SQLServer resources
  Try 
  this site;
   
  http://ls.sswug.org/cgi-bin/lyris.pl?site=sswug&page=topic&topic=sql_server&text_mode=0&lang=english
   
  And 
  pick which listserver you want.  The sql2k is a very good list to use as 
  a resource.
   
  Dave
  
-Original Message-From: Cunningham, Gerald 
[mailto:[EMAIL PROTECTED]Sent: Thursday, October 02, 
2003 1:10 PMTo: Multiple recipients of list 
ORACLE-LSubject: OT: SQLServer resources
Hi 
all,
 
Can anybody 
point me to a mailing list such as this for SQLServer? (I would be suprised 
if there's something of ORACLE-L's quality, but you never know!). Or, any 
other resources on the web? I'm particularly interested in production 
support (performance tuning, security, backup/recovery, 
etc.)
 
Thank you very 
much!
 
- 
Jerry
 

Re: AIX ODBC driver from Oracle

[Jared . Still]

http://www.unixodbc.org/








Gene Gurevich <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
 10/02/2003 01:04 PM
 Please respond to ORACLE-L

        
        To:        Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
        cc:        
        Subject:        AIX ODBC driver from Oracle


Hi all:

A developer has installed some software from IBM,
which is using an ODBC driver from Merant to connect
to a remote database. And it also doesn't seem to
work.
So they are asking whether there is a Oracle ODBC
driver for AIX which they can try instead. Does anyone
know where do I start to look for that driver? I never
had to deal with that stuff before.

Thanks

Gene

__
Do you Yahoo!?
The New Yahoo! Shopping - with improved product search
http://shopping.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Gene Gurevich
  INET: [EMAIL PROTECTED]

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

FW: ORA-06401 NETCMN INVALID DRIVER

[Ramón Estevez]

> Hi list,
> 
> I just installed 9IAS R2, the J2EE and Web Cache option.  Before creating a DAD I'm 
> trying to connect to a DB 
> in a linux server, from the APP Server, with SQL Plus using host:port:orcl and get 
> this error.  
> 
> In metalink direct me to modify the TNSNAMES.ORA file but the installation didn't 
> created it, 
> 
> Do I need it a TNSNAMES.ORA to connect using this method?
> 
> What should I do ?
> 
> TIA
> 
> Ramon E. Estevez
> [EMAIL PROTECTED]
> 809-535-8994
> 
> 
<>

RE: AIX ODBC driver from Oracle

[Stephane Paquette]

I`ve used Merant ODBC driver on Sun. It worked pretty well.
I'm surprised that you have problem with it.


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-
Gene Gurevich
Sent: Thursday, October 02, 2003 4:05 PM
To: Multiple recipients of list ORACLE-L


Hi all:

A developer has installed some software from IBM,
which is using an ODBC driver from Merant to connect
to a remote database. And it also doesn't seem to
work.
So they are asking whether there is a Oracle ODBC
driver for AIX which they can try instead. Does anyone
know where do I start to look for that driver? I never
had to deal with that stuff before.

Thanks

Gene

__
Do you Yahoo!?
The New Yahoo! Shopping - with improved product search
http://shopping.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Gene Gurevich
  INET: [EMAIL PROTECTED]

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

[Kevin Toepke]

Gene

No, oracle does not have an ODBC driver for AIX. However, I have set up
several database connections to SQL Server using the Merant Driver. It works
very well and is more than fast enough for our application.

My first piece of advice is to watch your case. The Oracle and the Merant
driver seem to be very case sensitive. The case of the SID in the
tnsnames.ora file must match that in the init.ora filename in
$OH/hs/admin. The value of HS_FDS_CONNECT_INFO line in the init.ora file
must match the case in the $ODBCHOME/odbc.ini file.

HTH
Kevin T.

-Original Message-
Sent: Thursday, October 02, 2003 4:05 PM
To: Multiple recipients of list ORACLE-L


Hi all:

A developer has installed some software from IBM,
which is using an ODBC driver from Merant to connect
to a remote database. And it also doesn't seem to
work.
So they are asking whether there is a Oracle ODBC
driver for AIX which they can try instead. Does anyone
know where do I start to look for that driver? I never
had to deal with that stuff before.

Thanks

Gene

__
Do you Yahoo!?
The New Yahoo! Shopping - with improved product search
http://shopping.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Gene Gurevich
  INET: [EMAIL PROTECTED]

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

[Mladen Gogala]

http://www.unixodbc.org/

On Thu, 2003-10-02 at 16:04, Gene Gurevich wrote:
> Hi all:
> 
> A developer has installed some software from IBM,
> which is using an ODBC driver from Merant to connect
> to a remote database. And it also doesn't seem to
> work.
> So they are asking whether there is a Oracle ODBC
> driver for AIX which they can try instead. Does anyone
> know where do I start to look for that driver? I never
> had to deal with that stuff before.
> 
> Thanks
> 
> Gene
> 
> __
> Do you Yahoo!?
> The New Yahoo! Shopping - with improved product search
> http://shopping.yahoo.com
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net




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

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

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

Re: UNIX : script help/input

[Jared . Still]

This database is 8i.

I would probably still use the package, as it does octal, hex and binary
as well as base 36 and 64.  

Jared








Vladimir Begun <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
 10/02/2003 12:24 PM
 Please respond to ORACLE-L

        
        To:        Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
        cc:        
        Subject:        Re: UNIX : script help/input


[EMAIL PROTECTED] wrote:
> Left pad with zeroes, take a substring, feed it to the handy-dandy
> hex/oct/bin/dec converter package - much easier.

Jared, what Oracle edition do you use? I'm asking because you might
want to consider not to use 'handy-dandy' hex/oct/bin/dec converter
package, but TO_CHAR/TO_NUMBER in case it's >= 8i -- it would work
faster.

SELECT TO_NUMBER(SUBSTR('0x50AA', -6), 'FM0X') dec
      , '0x' || TO_CHAR(170, 'FM0X') hex
   FROM dual
/
-- 
Vladimir Begun
The statements and opinions expressed here are my own and
do not necessarily represent those of Oracle Corporation.

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

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

[Jared . Still]

Here's one way:

define delete_date_format = 'dd/mm/yy'

col old_nls_date_format noprint new_value old_nls_date_format

select value old_nls_date_format
from nls_session_parameters
where parameter = 'NLS_DATE_FORMAT'
/

alter session set nls_date_format = '&&delete_date_format';

accept delete_date date prompt "Please Enter the Delete-To Date in DD/MM/YY Format:"

begin
   delete_commit('delete from xyz where timestamp <= to_date(''&&delete_date'',''&&delete_date_format'')',1000);
end;
/

alter session set nls_date_format = '&&old_nls_date_format';

HTH

Jared








"Malik, Fawzia" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
 10/02/2003 04:49 AM
 Please respond to ORACLE-L

        
        To:        Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
        cc:        
        Subject:        Help with procedure.



Hi Guys,

I have the following delete-commit procedure (see below). The way it is
called is as follows :

exec delete_commit('delete from xyz where timestamp <=
to_date(''24/05/03'',''dd/mm/yy'')',1000)

Is there a way I can pass the date (timestamp)as a variable so that the
script doesnt have to be physically modified each time this procedure is
executed??

Any help/advice would be greatly appreciated!!!

Rgds

Fawzia

Procedure:

CREATE OR REPLACE procedure delete_commit
( p_statement                   in varchar2,
  p_commit_batch_size   in number default 1)
is
        cid                             integer;
        changed_statement               varchar2(2000);
        finished                        boolean;
        nofrows                         integer;
        lrowid                          rowid;
        rowcnt                          integer;
        errpsn                          integer;
        sqlfcd                          integer;
        errc                            integer;
        errm                            varchar2(2000);
begin
        /* If the actual statement contains a WHERE clause, then append a
           rownum < n clause after that using AND, else use WHERE
           rownum < n clause */
        if ( upper(p_statement) like '% WHERE %') then
                changed_statement := p_statement||' AND rownum < '
                           ||to_char(p_commit_batch_size + 1);
        else
                changed_statement := p_statement||' WHERE rownum < '
                           ||to_char(p_commit_batch_size + 1);
        end if;
        begin
                cid := dbms_sql.open_cursor; -- Open a cursor for the task
                dbms_sql.parse(cid,changed_statement, dbms_sql.native);
                        -- parse the cursor. Pleae note that in Oracle 7.2.2
                        -- parsing does a execute too. But that does not
                        -- pose a problem here as we want that.
                rowcnt := dbms_sql.last_row_count;
                        -- store for some future reporting
        exception
                when others then
                     errpsn := dbms_sql.last_error_position;
                        -- gives the error position in the changed sql
                        -- delete statement if anything happens
                     sqlfcd := dbms_sql.last_sql_function_code;
                        -- function code can be found in the OCI manual
                     lrowid := dbms_sql.last_row_id;
                        -- store all these values for error reporting.
However
                        -- all these are really useful in a stand-alone proc
                        -- execution for dbms_output to be successful, not
                        -- possible when called from a form or front-end
tool.
                     errc := SQLCODE;
                     errm := SQLERRM;
                     dbms_output.put_line('Error '||to_char(errc)||
                                        ' Posn '||to_char(errpsn)||
                                        ' SQL fCode '||to_char(sqlfcd)||
                                        ' rowid '||rowidtochar(lrowid));
                     raise_application_error(-2,errm);
                        -- this will ensure the display of atleast the error
                        -- message if someething happens, even in a frontend
                        -- tool.
        end;
        finished := FALSE;
        while not (finished)
        loop -- keep on executing the cursor till there is no more to
process.
                begin
                        nofrows := dbms_sql.execute(cid);
                        rowcnt := dbms_sql.last_row_count;
                exception
                        when others then
                                errpsn := dbms_sql.last_error_position;
                                sqlfcd := dbms_sql.last_sql_function_code;
                                lrowid := dbms_sql.last_row_id;
                                errc := SQLCODE;
                                errm := SQLERRM;
                                dbms_output.put_line('Erro

ORA-06401 NETCMN INVALID DRIVER

[Ramón Estevez]

Hi list,

I just installed 9IAS R2, the J2EE and Web Cache option.  Before creating a DAD I'm 
trying to connect to a DB 
in a linux server, from the APP Server, with SQL Plus using host:port:orcl and get 
this error.  

In metalink direct me to modify the TNSNAMES.ORA file but the installation didn't 
created it, 

Do I need it a TNSNAMES.ORA to connect using this method?

What should I do ?

TIA

Ramon E. Estevez
[EMAIL PROTECTED]
809-535-8994


<>

RE: ORA-03120

[Odland, Brad]

Remove Ora817 and go back to 816 client.
The OCI is probaly different between them.

Or you need to recompile your application with 8.1.7 client in place.

Brad

-Original Message-
Sent: Thursday, October 02, 2003 1:00 PM
To: Multiple recipients of list ORACLE-L


Hi,
I have been running DB v8.1.6.0.0 on sun box and applictaion on netra 
without any error.recently I installed linux client with 8.1.7.0.0 . I have 
been noticing following error when linux client is trying to connect to 
DB.I'm assuming its net8 layer problem.let me suggest what to do to fix this

problem.

"Error: ora8.c:2161:ora_get_row: error in `OCILobRead ()': ORA-03120: 
two-task conversion routine: integer overflow "
Thx
-Seema

_
Get McAfee virus scanning and cleaning of incoming attachments.  Get Hotmail

Extra Storage!   http://join.msn.com/?PAGE=features/es

-- 
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: Odland, Brad
  INET: [EMAIL PROTECTED]

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

AIX ODBC driver from Oracle

[Gene Gurevich]

Hi all:

A developer has installed some software from IBM,
which is using an ODBC driver from Merant to connect
to a remote database. And it also doesn't seem to
work.
So they are asking whether there is a Oracle ODBC
driver for AIX which they can try instead. Does anyone
know where do I start to look for that driver? I never
had to deal with that stuff before.

Thanks

Gene

__
Do you Yahoo!?
The New Yahoo! Shopping - with improved product search
http://shopping.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Gene Gurevich
  INET: [EMAIL PROTECTED]

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

[Jamadagni, Rajendra]

Title: RE: UNIX : script help/input






it was actually "C" code ... but because data is going on a modem, the pl/sql speed is acceptable (in fact we have to _wait_ after sending out each message). Had fun doing that though ... it is critical, tied to our SLA ... so must be up all the time. I'd rather handle exceptions in pl/sql than in "C".

Raj


-Original Message-
From: Vladimir Begun [mailto:[EMAIL PROTECTED]]
Sent: Thursday, October 02, 2003 3:35 PM
To: Multiple recipients of list ORACLE-L
Subject: Re: UNIX : script help/input



Jamadagni, Rajendra wrote:
> unfortunately we _had_ to do it in pl/sql ... it is part of the 
> encrypted feed that we send out to our clients ... it is decoded by a chip.
>  
> Oh well  I am back to array of references ...


I'd suggest to consider external C function -- it's faster, it's
easier to write especially when you need to work with bits, shifts
etc.. I've recently implemented crc32 for some internal project --
works well, obviously faster than SQL, PL/SQL and native comp of
PL/SQL code. Native comp. is also good to consider, if it's 9i.
Sure, it depends...
-- 
Vladimir Begun
The statements and opinions expressed here are my own and
do not necessarily represent those of Oracle Corporation.


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


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

[K Gopalakrishnan]

Murali:

Other than init parameter changes, you need to turn the RAC components off
from the oracle binaries. Otherwise RAC will be still running in the oracle
irrespective of init parameter.

TO Disable RAC.. follow these steps;

1. Shutdown  ALL instances on that oracle home
2. Go to $OH/rdbms/lib
3. Use the make command to relink the oracle binaries without RAC
Components..
i.e. make -f ins_rdbms.mk rac_off
4. Relink the binaries
i.e make -f ins_rdbms.mk ioracle.

Thats all !!!
Now you have Oracle Binaries without RAC.


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

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

[Mladen Gogala]

At my previous company, I managed an OPS database ver. 8.1.7.1 
with ALL tablespaces locally managed (auto allocate) and on the raw
devices.There were no problems, if we disregard the famous "Philamae
comparison".
On Thu, 2003-10-02 at 15:14, Louis Avrami wrote:
> Hi all,
> 
> I just inherited an 8.1.7.4 database running on Solaris 2.8,
> 16 k block size, using raw devices for database datafiles.  The
> raw slices all appear to be a uniform size, 200 meg each.  As
> part of my initial site survey, I noticed that the tablespaces
> are all dictionary managed.
> 
> Would it be optimal to convert the existing application data
> and index tablespaces to locally managed tablespaces?
> 
> Does anyone know of any issues/problems when using locally managed
> tablespaces with raw devices?
> 
> Another question that I do have concerns the proper sizing of
> datafiles for new tablespaces.  I have only utilized locally
> managed tablespaces on OS filesystems.  With OS-level datafiles
> I usually create datafiles as a multiple of the OS filesystem
> block size + 64K for the bitmap header and metadata blocks. 
> For example:
> 
>  OS block size   datafile size
>  -   -
>8k256 meg + 64k
> 
> 
> With raw disk slices, the OS filesystem is bypassed.  What then
> should be the optimal "formula" when creating new datafiles?
> 
> Thanks,
> Lou Avrami
> 
> 
> 
> 
> 
> 
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net




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

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

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

Re: ORACLE CLIENT V816

[Govindan K]

AFAIK in Solaris V8.1.6, the client is part of EE download itself. When you invoke OUI
just choose the Client option and install it in a different Oracle Home. May it is same in 
Linux. Just check.
 
HTH
GovindanK
<-Original Message->



 
 
From: Seema SinghSent: 10/2/2003 12:00:38 PMTo: [EMAIL PROTECTED]Subject: Re: ORACLE CLIENT V816 Hi Does any one know exact URL from where I can download Linux oracle client V8.1.6 ? thx -seema _ High-speed Internet access as low as $29.95/month (depending on the local service providers in your area). Click here. https://broadband.msn.com -- 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). . 

___Get Your 10MB account for FREE at http://mail.arabia.com !Access MILLIONS of JOBS NOW!

Relink Error 9.2.0.4 Patch HP/UX

[Odland, Brad]

Is anyone running 9.2.0.4 on HP/UX? 11.0

HP9000

I had 9.2.0.2 running and downoaded and installed the 9.2.0.4 patch and now
I can't relink.

Unsatisfied symbol in "kkxfcab" in file
/usr/oracle/9.2.0/lib//libserver9.a[kwqa.o]


I have a tar in process but wondering if anyone else has 9.2.0.4 running or
run into this problem




Brad O.

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

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

RE: Steps to convert a RAC to a single instance.

[Murali_Pavuloori/Claritas]

Raj,

we have a java application that connects to the datawarehouse that is
currently setup on RAC but if for some reason one node fails, then we need
to recycle the whole application server as the connection pool goes
staleOracle product development stated that db links can't be failed
over.

No use beating the dead fish (or is it the cat..anyway). I have argued and
irated some folks here. we have made a decision and management wants to
move forward with it.

I really appreciate any help you could provide on converting RAC to a
single instance.

Thanks,
Murali.





|-+->
| |   "Jamadagni,   |
| |   Rajendra" |
| |  |
| |   Sent by:  |
| |   [EMAIL PROTECTED]|
| |   com   |
| | |
| | |
| |   10/02/2003 03:14  |
| |   PM|
| |   Please respond to |
| |   ORACLE-L  |
| | |
|-+->
  
>--|
  |
  |
  |   To:   Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>   
   |
  |   cc:  
  |
  |   Subject:  RE: Steps to convert a RAC to a single instance.   
  |
  
>--|




our (forms) application doesn't fail over, but then we look at RAC for HA
.. the logic is like this ... if once instance goes down, then instead of
making all 1000 users unhappy, I just make 500 (estimate) of them unhappy,
and they can log back in and will work fine because 2nd instance is still
servicing. And luckily each instance can handle the load without breaking a
sweat.


Get my point?
Raj


-Original Message-
[mailto:Murali_Pavuloori/[EMAIL PROTECTED]
Sent: Thursday, October 02, 2003 2:35 PM
To: Multiple recipients of list ORACLE-L






Hello All:


We had purchased RAC to provide high availability of datawarehouse to our
customers. We later discovered that the way our application is designed,
and because database links are not failed over in the RAC environment, we
have decided to abondon RAC - atleast temporarily.


Could you please list all the steps required to convert RAC to a single
instance.


My understanding is that all we need to do is modify the initSID.ora to
comment out RAC specific parameters like
cluseter_database_instance
cluster_database
SID.instance_name
SID.instance_number
SID.thread
SID.remote_listener


What about the Oracle software? any changes required there?





Appreciate you help and suggestions in this matter.


Thanks,
Murali.





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


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








ESPN_Disclaimer.txt
Description: Binary data

Re: UNIX : script help/input

[Vladimir Begun]

Jamadagni, Rajendra wrote:
unfortunately we _had_ to do it in pl/sql ... it is part of the 
encrypted feed that we send out to our clients ... it is decoded by a chip.
 
Oh well  I am back to array of references ...
I'd suggest to consider external C function -- it's faster, it's
easier to write especially when you need to work with bits, shifts
etc.. I've recently implemented crc32 for some internal project --
works well, obviously faster than SQL, PL/SQL and native comp of
PL/SQL code. Native comp. is also good to consider, if it's 9i.
Sure, it depends...
--
Vladimir Begun
The statements and opinions expressed here are my own and
do not necessarily represent those of Oracle Corporation.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Vladimir Begun
 INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: UNIX : script help/input

[Vladimir Begun]

[EMAIL PROTECTED] wrote:
Left pad with zeroes, take a substring, feed it to the handy-dandy
hex/oct/bin/dec converter package - much easier.
Jared, what Oracle edition do you use? I'm asking because you might
want to consider not to use 'handy-dandy' hex/oct/bin/dec converter
package, but TO_CHAR/TO_NUMBER in case it's >= 8i -- it would work
faster.
SELECT TO_NUMBER(SUBSTR('0x50AA', -6), 'FM0X') dec
 , '0x' || TO_CHAR(170, 'FM0X') hex
  FROM dual
/
--
Vladimir Begun
The statements and opinions expressed here are my own and
do not necessarily represent those of Oracle Corporation.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Vladimir Begun
 INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Steps to convert a RAC to a single instance.

[Jamadagni, Rajendra]

Title: RE: Steps to convert a RAC to a single instance.





our (forms) application doesn't fail over, but then we look at RAC for HA ... the logic is like this ... if once instance goes down, then instead of making all 1000 users unhappy, I just make 500 (estimate) of them unhappy, and they can log back in and will work fine because 2nd instance is still servicing. And luckily each instance can handle the load without breaking a sweat.

Get my point?
Raj


-Original Message-
From: Murali_Pavuloori/[EMAIL PROTECTED]
[mailto:Murali_Pavuloori/[EMAIL PROTECTED]]
Sent: Thursday, October 02, 2003 2:35 PM
To: Multiple recipients of list ORACLE-L
Subject: Steps to convert a RAC to a single instance.




Hello All:


We had purchased RAC to provide high availability of datawarehouse to our
customers. We later discovered that the way our application is designed,
and because database links are not failed over in the RAC environment, we
have decided to abondon RAC - atleast temporarily.


Could you please list all the steps required to convert RAC to a single
instance.


My understanding is that all we need to do is modify the initSID.ora to
comment out RAC specific parameters like
cluseter_database_instance
cluster_database
SID.instance_name
SID.instance_number
SID.thread
SID.remote_listener


What about the Oracle software? any changes required there?



Appreciate you help and suggestions in this matter.


Thanks,
Murali.



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


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

[Ruth Gramolini]

We use 8192 on AIX and have no problems.  The AIX block size is 512 so I
know it is advisable to have a multiple of 512, other than that I know of no
other caveat.

Ruth
  -Original Message-
  From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of
  Hans de Git
  Sent: Wednesday, October 01, 2003 4:24 AM
  To: Multiple recipients of list ORACLE-L
  Subject: blocksize on AIX


  Hi all,

  I've read on ixora.com.au and other sites that the optimal block size for
  AIX is 4K, because JFS pages are 4K also.

  Has anyone of you ever experienced performance problems on AIX due to a
  larger blocksize? What exactly are the 'read ahead' issues and
  cpu problems
  regarding double buffering etc. Are there any alternatives, other than
  moving to raw volumes?

  HTH,
  Hans

  _
  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: Ruth Gramolini
  INET: [EMAIL PROTECTED]

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

Locally managed tablespaces and raw devices

[Louis Avrami]

Hi all,

I just inherited an 8.1.7.4 database running on Solaris 2.8,
16 k block size, using raw devices for database datafiles.  The
raw slices all appear to be a uniform size, 200 meg each.  As
part of my initial site survey, I noticed that the tablespaces
are all dictionary managed.

Would it be optimal to convert the existing application data
and index tablespaces to locally managed tablespaces?

Does anyone know of any issues/problems when using locally managed
tablespaces with raw devices?

Another question that I do have concerns the proper sizing of
datafiles for new tablespaces.  I have only utilized locally
managed tablespaces on OS filesystems.  With OS-level datafiles
I usually create datafiles as a multiple of the OS filesystem
block size + 64K for the bitmap header and metadata blocks. 
For example:

 OS block size   datafile size
 -   -
   8k256 meg + 64k


With raw disk slices, the OS filesystem is bypassed.  What then
should be the optimal "formula" when creating new datafiles?

Thanks,
Lou Avrami







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

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Describe privilege on procedures & packages

[Govindan K]

Here we go:
 
http://www.geocities.com/dba_assist/scripts/show_procedure.html
 
HTH
GovindanK
<-Original Message->



 
 
From: Jamadagni, Rajendra;Jamadagni, RajendraSent: 10/1/2003 1:25:33 PMTo: [EMAIL PROTECTED]Subject: RE: Describe privilege on procedures & packages 

all_arguments
 
Raj

-Original Message-From: Govindan K [mailto:[EMAIL PROTECTED]Sent: Wednesday, October 01, 2003 4:00 PMTo: Multiple recipients of list ORACLE-LSubject: Re: Describe privilege on procedures & packages
Hi Pete
 
I see another restriction (as i choose to put it) with my code. In OUR setup, we use Packages
"Extensively" (front end being Java).  We use RefCursors to send result set to Java.
When you describe such a package ORACLE describes the structure
of the Ref Cursor too which i could not get using user_arguments.   If someone in the list has the time 
and inclination extend my code it would be useful. 
 
Here are some examples. (For Ref cursor as output)
PROCEDURE P_GET_AGENT Argument Name  Type    In/Out Default? -- --- --  I_AGENT_ID NUMBER  IN I_BUSINESS_NAME    VARCHAR2    IN I_TEL_NO !
;! ;  VARCHAR2    IN O_AGENT_DET    REF CURSOR  OUT    RECORD  OUT AGENT_ID   NUMBER(6)   OUT AGENT_NM   !
&nb! sp;   VARCHAR2(50)    OUT AGENT_PHONE_NO VARCHAR2(10)    OUT ADR_SYS_NO NUMBER(10)  OUT ADR_STREET VARCHAR2(50)    OUT ADR_LINE_2 VARCHAR2(50)   !
 OUT&! nbsp;    ADR_CITY   VARCHAR2(30)    OUT ADR_COUNTRY    VARCHAR2(20)    OUT ADR_ZIP    VARCHAR2(5) OUT ADR_ZIP_PLUS   VARCHAR2(4) OUT AG_REPORTING_PERIOD_FL VARCHAR2(1)!
  &nb! sp;  OUT AG_PRS_CONTACT_NM  VARCHAR2(75)    OUT O_ERR_CODE NUMBER  OUT O_ERR_MESG VARCHAR2    OUT
 
I am wondering where to get the details of O_AGENT_DET from? (which dba_view).  
 
 
HTH
GovindanK<-Original Message->



 
 
From: Pete FinniganSent: 10/1/2003 4:02:29 AMTo: [EMAIL PROTECTED]Subject: Re: Describe privilege on procedures & packages Hi Govindan Good thought!!, I was going to suggest the same idea, just to go and get the description of the package / procedure / function from the dictionary and then grant access to the dictionary views needed. One slight flaw with your code though, you have selected from user_% views but the OP wanted to be able to let another user describe *his* procedures and packages, you would need to use dba_% views as if the "other" person had not been granted access to the OP's procedures then they wouldn't be in ALL_% for him or in user_% views. kind regards Pete In article , Govindan K <[EMAIL PROTECTED]>writes >This was the closest i could get. > >set pagesize 60; >set linesize 180; >column position noprint; >column sequence noprint; >break on object_type skip 1; >break on package_name skip 1; >break on object_name skip 1; >column object_type format A15 wrap; >column package_name format A30 wrap; >column object_name format A30 wrap; >column argument_name format A30 wrap; >column in_out format A10 wrap; >column data_type format A15 wrap; >column default_value format A10 wrap; >column type_name format A10 wrap; >column type_subname format A10 wrap; >select > b.object_type > ,a.package_name > ,a.object_name > ,a.argument_name > ,a.position > ,a.sequence > ,a.in_out > ,a.data_type > ,a.default_value > ,a!
.t! ype_name > ,a.type_subname > from user_arguments a > ,user_objects b > where a.position > 0 > and b.object_id = a.object_id > order by > b.object_type > ,a.package_name > ,a.object_name > , a.position >/ > >Create a procedure which will dbms_output this and grant execute >priviliges on it. > ><-Original Message-> > > From: Gary Jackson >Sent: 9/30/2003 9:31:29 AM >To: [EMAIL PROTECTED] > >(Reposting from yesterday morning since I had no takers! :) > >Hello, >I wanted to give another user access to view my procedures & packages >(just >DESC capability), but it seems that the only way for him to be able to >DESC >them is for me to grant execute. Is this correct?? (I guess I have never >had this situation before, it just seems surprising if the!
re i! s no way >to >grant a read-only privilege). > >Thanks! > >_ > >Author: Gary Jackson >INET: [EMAIL PROTECTED] > >. > > >___ >Get Your 10MB account for FREE at http://mail.arabia.com ! >Access MILLIONS of JOBS NOW! > -- Pete Finnigan email:

RE: UNIX : script help/input

[Jamadagni, Rajendra]

unfortunately we _had_ to do it in pl/sql ... it is part of the encrypted 
feed that we send out to our clients ... it is decoded by a 
chip.
 
Oh 
well  I am back to array of references ...
 
Raj

  -Original Message-From: [EMAIL PROTECTED] 
  [mailto:[EMAIL PROTECTED]Sent: Thursday, October 02, 2003 
  2:20 PMTo: Multiple recipients of list ORACLE-LSubject: 
  RE: UNIX : script help/inputRaj, I did consider doing 
  it this way, but the thought of writing stuff to the bit level for a prototype was just too painful. 
  Left pad with zeroes, take a substring, 
  feed it to the handy-dandy hex/oct/bin/dec converter package - much easier. Jared 
  


  
  "Jamadagni, Rajendra" 
<[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 
 10/02/2003 05:54 AM 
 Please respond to ORACLE-L 
                  To:     
   Multiple recipients of list ORACLE-L 
<[EMAIL PROTECTED]>         cc:       
        
  Subject:        RE: UNIX : script 
help/inputXOR  that gives me some painful memories in recent days ... xor is 
  possible in pl/sql but needs a little work. I migrated a "C" encryption code 
  to pl/sql  and then use utl_tcp to sent it to our router which feeds the 
  modem banks. 
  This is how I worked on it ... but I 
  was working on character by character ... 
  xor(a,b) is r_a := utl_raw.cast_to_raw(chr(a)); r_b := utl_raw.cast_to_raw(chr(b)); n_xor := to_number(utl_raw.bit_xor(r_a,r_b),''); 
  
  Of course the manual doesn't tell you 
  this ... 
  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: Wednesday, October 01, 2003 6:29 PM To: Multiple recipients of list ORACLE-L 
  
  > Good! The more the merrier! 
  Welcome to the club. 
  Oh most definitely. 
  As I just finished writing a prototype 
  package for assigning MAC 
  addresses ( we make network 
  stuff - that's a technical term ), I have endured the 
  agonies of doing hex math in PL/SQL. 
  I finally bit the bullet and used 
  string manipulation to convert 
  hex to decimal and do what I 
  needed that way.  Couldn't get BITAND to work properly on 
  very large integers. Besides, doing XOR with BITAND in PL/SQL is very painful. 
  UTL_RAW has an XOR, but it requires RAW 
  values and I didn't feel 
  like messing with 
  it. 
  This is all very simple in 
  Perl. 
  Given a MAC of 5AA, with a 
  fixed portion of 500, 
  it is very easy to determine 
  the variable portion of the address 
  via $x = 0x5AA ^ 
  500. 
  Not quite so simple in 
  PL/SQL. 
  Jared 
  
  

ORACLE CLIENT V816

[Seema Singh]

Hi
Does any one know exact URL from where I can download Linux oracle client 
V8.1.6 ?
thx
-seema

_
High-speed Internet access as low as $29.95/month (depending on the local 
service providers in your area). Click here.   https://broadband.msn.com

--
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: OT: SQLServer resources

[Seema Singh]

here u go
http://vyaskn.tripod.com

From: "Cunningham, Gerald" <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Subject: OT: SQLServer resources
Date: Thu, 02 Oct 2003 10:09:40 -0800
Hi all,

Can anybody point me to a mailing list such as this for SQLServer? (I
would be suprised if there's something of ORACLE-L's quality, but you
never know!). Or, any other resources on the web? I'm particularly
interested in production support (performance tuning, security,
backup/recovery, etc.)
Thank you very much!

- Jerry

_
Instant message during games with MSN Messenger 6.0. Download it now FREE!  
http://msnmessenger-download.com

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

[Rothouse, Michael]

Title: Message



I use 
the sites below when necessary.  You can search Google ("sql server" +list) 
for mailing lists.
 
http://www.sqlservercentral.com/
http://www.sqlsecurity.com/
http://www.sql-server-performance.com/
 

  
  -Original Message-From: Cunningham, 
  Gerald [mailto:[EMAIL PROTECTED] Sent: Thursday, October 
  02, 2003 2:10 PMTo: Multiple recipients of list 
  ORACLE-LSubject: OT: SQLServer resources
  Hi 
  all,
   
  Can anybody point 
  me to a mailing list such as this for SQLServer? (I would be suprised if 
  there's something of ORACLE-L's quality, but you never know!). Or, any other 
  resources on the web? I'm particularly interested in production support 
  (performance tuning, security, backup/recovery, etc.)
   
  Thank you very 
  much!
   
  - 
  Jerry
   

Re: Huge optimization costs with 9.2

[Joan Hsieh]

Hi Govind,
I tested it. no luck. I killed the session.
SQL> alter session set sql_trace=true
  2  ;

Session altered.

SQL> alter session set "_UNNEST_SUBQUERY" = FALSE;

Session altered.

SQL> alter session set "_ORDERED_NESTED_LOOP" = FALSE;

Session altered.

SQL> alter session set "_ALWAYS_SEMI_JOIN" = off;

Session altered.


"pr_view3.prf" 733 lines, 38147 characters

Rows Execution Plan
---  ---
  0  INSERT STATEMENT   GOAL: CHOOSE
  0   LOAD AS SELECT
   1420NESTED LOOPS (OUTER)
   1420 NESTED LOOPS (OUTER)
   1420  NESTED LOOPS (OUTER)
   1420   NESTED LOOPS (OUTER)
   1420TABLE ACCESS   GOAL: ANALYZED (FULL) OF 'PR_IDENTITY'
 96VIEW PUSHED PREDICATE
 96 HASH JOIN
 96  NESTED LOOPS
 96   TABLE ACCESS   GOAL: ANALYZED (BY INDEX ROWID)
  OF 'PR_MED'
 96INDEX   GOAL: ANALYZED (UNIQUE SCAN) OF
   'PR_MED_UNIQUE_TRUNK' (UNIQUE)
 96   TABLE ACCESS   GOAL: ANALYZED (BY INDEX ROWID)
  OF 'PR_DEPARTMENTS'
 96INDEX   GOAL: ANALYZED (UNIQUE SCAN) OF
   'PR_DEPARTMENTS_PK' (UNIQUE)


Rows Execution Plan
---  ---
  0  INSERT STATEMENT   GOAL: CHOOSE
  0   LOAD AS SELECT
   1420NESTED LOOPS (OUTER)
   1420 NESTED LOOPS (OUTER)
   1420  NESTED LOOPS (OUTER)
   1420   NESTED LOOPS (OUTER)
   1420TABLE ACCESS   GOAL: ANALYZED (FULL) OF 'PR_IDENTITY'
 96VIEW PUSHED PREDICATE
 96 HASH JOIN
 96  NESTED LOOPS
 96   TABLE ACCESS   GOAL: ANALYZED (BY INDEX ROWID)
  OF 'PR_MED'
 96INDEX   GOAL: ANALYZED (UNIQUE SCAN) OF
   'PR_MED_UNIQUE_TRUNK' (UNIQUE)
 96   TABLE ACCESS   GOAL: ANALYZED (BY INDEX ROWID)
  OF 'PR_DEPARTMENTS'
 96INDEX   GOAL: ANALYZED (UNIQUE SCAN) OF
   'PR_DEPARTMENTS_PK' (UNIQUE)
 361536  VIEW OF 'PR_ADMINS'
 361536   UNION-ALL
 361536HASH JOIN
 361536 NESTED LOOPS
 361536  VIEW
 361536   UNION-ALL
  0HASH JOIN
  0 TABLE ACCESS   GOAL: ANALYZED (FULL)
OF 'PR_DEPARTMENTS'
  0 TABLE ACCESS   GOAL: ANALYZED (FULL)
OF 'PR_HR'
 361536HASH JOIN
   2688 TABLE ACCESS   GOAL: ANALYZED (FULL)
OF 'PR_DEPARTMENTS'
 361536 TABLE ACCESS   GOAL: ANALYZED (FULL)
OF 'PR_MED'
 361536  INDEX   GOAL: ANALYZED (UNIQUE SCAN) OF
 'PR_ADMIN_TYPES_PK' (UNIQUE)
   2304 TABLE ACCESS   GOAL: ANALYZED (FULL) OF
'PR_ADMIN_GROUPS'
  0NESTED LOOPS
1298400 HASH JOIN
   2304  TABLE ACCESS   GOAL: ANALYZED (FULL) OF
 'PR_ADMIN_GROUPS'
1298400  HASH JOIN
1298400   TABLE ACCESS   GOAL: ANALYZED (FULL) OF
  'PR_SIS'
   1824   TABLE ACCESS   GOAL: ANALYZED (FULL) OF
  'PR_SIS_MAPAUCOLLEGES'
  0 INDEX   GOAL: ANALYZED (UNIQUE SCAN) OF
'PR_ADMIN_TYPES_PK' (UNIQUE)
  0HASH JOIN
  0 TABLE ACCESS   GOAL: ANALYZED (FULL) OF
'PR_ADMIN_GROUPS'
  0 MERGE JOIN (CARTESIAN)
  0  TABLE ACCESS   GOAL: ANALYZED (FULL) OF
 'PR_AFFILIATE'
  0  BUFFER (SORT)
  0   INDEX   GOAL: ANALYZED (FULL SCAN) OF
  'PR_ADMIN_TYPES_PK' (UNIQUE)
  1   VIEW PUSHED PREDICATE
  1HASH JOIN
  1 NESTED LOOPS (OUTER)
  1  TABLE ACCESS   GOAL: ANALYZED (BY INDEX ROWID) OF
 'PR_AFFILIATE'
  1   INDEX   GOAL: ANALYZED (UNIQUE SCAN) OF
  'PR_AFFILIATE_PK' (UNIQUE)
  1  TABLE ACCESS   GOAL: ANALYZED (BY INDEX ROWID) OF
 'PR_DEPARTMENTS'
  1   INDEX   GOAL: ANALYZED (UNIQUE SCAN) OF
  'PR_DEPARTMENTS_PK' (UNIQUE)
481 VIEW OF 'PR_ADMINS'
481  UNION-ALL
  0   HASH JOIN
  0NESTED LOOPS
  0 VIEW
  0  UNION-ALL
  0   HASH JOIN
  0TABLE ACCESS   GOAL: ANALYZED (FULL)
   OF 'PR_DEPARTMENTS'
  0TABLE ACCESS   GOAL: ANALYZED (FULL)
   OF 'PR_HR'
  0   HASH JOIN
  0TABLE ACCESS   GOAL: ANALYZED (FULL)
  

RE: SQLServer resources

[Farnsworth, Dave]

Title: Message



Try 
this site;
 
http://ls.sswug.org/cgi-bin/lyris.pl?site=sswug&page=topic&topic=sql_server&text_mode=0&lang=english
 
And 
pick which listserver you want.  The sql2k is a very good list to use as a 
resource.
 
Dave

  -Original Message-From: Cunningham, Gerald 
  [mailto:[EMAIL PROTECTED]Sent: Thursday, October 02, 2003 
  1:10 PMTo: Multiple recipients of list ORACLE-LSubject: 
  OT: SQLServer resources
  Hi 
  all,
   
  Can anybody point 
  me to a mailing list such as this for SQLServer? (I would be suprised if 
  there's something of ORACLE-L's quality, but you never know!). Or, any other 
  resources on the web? I'm particularly interested in production support 
  (performance tuning, security, backup/recovery, etc.)
   
  Thank you very 
  much!
   
  - 
  Jerry
   

Steps to convert a RAC to a single instance.

[Murali_Pavuloori/Claritas]

Hello All:

We had purchased RAC to provide high availability of datawarehouse to our
customers. We later discovered that the way our application is designed,
and because database links are not failed over in the RAC environment, we
have decided to abondon RAC - atleast temporarily.

Could you please list all the steps required to convert RAC to a single
instance.

My understanding is that all we need to do is modify the initSID.ora to
comment out RAC specific parameters like
cluseter_database_instance
cluster_database
SID.instance_name
SID.instance_number
SID.thread
SID.remote_listener

What about the Oracle software? any changes required there?


Appreciate you help and suggestions in this matter.

Thanks,
Murali.


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

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

[Jared . Still]

Please visit orapub.com, download the 'Ratio Modeling' paper for capacity planning.

It's a quick and dirty method for estimating system capacity, be it CPU, RAM, disk, whatever.

Keep in mind that 'quick and dirty' is a relative term.

In addition, I highly recommend Craig's Capacity Planning course.

Craig Shalahamer is the owner of OraPub.

Jared








Newhouse Eric A HQ AFMC/ITON <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
 10/02/2003 05:27 AM
 Please respond to ORACLE-L

        
        To:        Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
        cc:        
        Subject:        Sun/Oracle harware sizing tool


I am looking for a hardware sizing tool to determine adequate hardware for
our application that will soon be expanding from 25,000 active users, to
85,000 active users. At any given time I suspect I will not have anymore
than 500 users logged in at any one time, with 200 being a median . 
Is there some equation for calculating the number of users that an
application serving tier can handle based on the processing power/number of
CPU's and memory? 
We are currently using Sun Solaris 2.5.9, RDBMS 9.2.02, Oracle applications
11.5.7, HR only. 
I am maintaining 4 instances , (3 copies of PROD generate little DB
activity) , on a Sun Sunfire 280R, dual processor, 8gb ram, and alot of SAN
based storage for my DB tier. 
I have a middle tier for each Instance on another Sunfire 280R , 2
processors, 8gb ram, application server discoverer etc... 
For the pupose of covering the increased load, we are contemplating
acquiring 2 Sun 880Rs , 2-4 processors, and some multiple of 8gb ram for
memory, and clustering them for the DB tier requirements. 
For our middle tier, we are planning using our existing s280r's , and
implementing load balancing... if that approach is still appropriate. We
have 3 now. 
Any gotcha's with 9i RAC? 
Oracle Applications requirements for this environment? 
What would be a recommended migration path/approach? 
Thanks All! 

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Newhouse Eric A HQ AFMC/ITON
  INET: [EMAIL PROTECTED]

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

[Jared . Still]

Another useless use of cat.

Where's Randal Schwartz when you need him.







Don Yu <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
 10/02/2003 07:59 AM
 Please respond to ORACLE-L

        
        To:        Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
        cc:        
        Subject:        Re: Questiuon about unix


Try this as following:

cat yourfile | awk -F; ' ( $4 == "") { print $0 }'   # $4 means your field number from beginning; $0 means whole line.

Good luck!

Don


[EMAIL PROTECTED] wrote:

> Hallo everybody,
>
> anyone whom can tell me what the command  is to search for an empty field in a unix file.
>
> for instance if you want to find the empty spacelines if some lines looklike:
>
> 1;100;Name;;
> 2;200;Test;45;
> 3;300;Name;;
>
> I would like to find out line nr 1 and 3 here above. Anyone whom could suggest any good?
>
> Maybe this sounds simple but I have tried with /;; and cant find it. If iI use that command then I will get lines with ;; and i just want lines with two ;;
>
> Thanks in advance
>
> Roland
>
> --
> 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).

-- 
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: Oracle and nfs mounted devices.

[Murali_Pavuloori/Claritas]

Thank you guys. I was finally able to create the tablespace on the mapped
drive.

I do realize that placing datafiles on network devices is not the right
thing and is not supported by oracle.

Thanks again for the help. You are the best!

Murali.



|-+>
| |   Branimir Petrovic|
| |   <[EMAIL PROTECTED]|
| |   om>  |
| |   Sent by: |
| |   [EMAIL PROTECTED]|
| |   .com |
| ||
| ||
| |   10/02/2003 12:39 |
| |   PM   |
| |   Please respond to|
| |   ORACLE-L |
| ||
|-+>
  
>--|
  |
  |
  |   To:   Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>   
   |
  |   cc:  
  |
  |   Subject:  RE: Oracle and nfs mounted devices.
  |
  
>--|






>
> I have been asked to create datafiles (create tablespace) on
> disk drives
> that are mapped ( internal disk - attached to remote servers)
>
> When I tried creating tablespace...I get  the following error message:
>
>
> ERROR at line 1:
> ORA-01119: error in creating database file
> 'd:\oracle\oradata\mmstest\test.dbf'
> ORA-27040: skgfrcre: create error, unable to create file
> OSD-04002: unable to open file
> O/S-Error: (OS 3) The system cannot find the path specified.
>

I firmly believe that placing database files across the network is
one very bad idea indeed, however your problem most likely comes
from the fact that Oracle service runs as local (Windows) system
account and as such across the network it has exactly the level
of rights it deserves - none whatsoever. If you set the Oracle
service to run as recognized network user that have read/right
permissions on mapped drive - it might work, but it would still
be a bad-bad idea to go ahead and actually do so (teeny tiny
network 'hick up', and find yourself practicing recovery scenarios).

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

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





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

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

[Jared . Still]

Raj,

I did consider doing it this way, but the thought of writing stuff to the
bit level for a prototype was just too painful.

Left pad with zeroes, take a substring, feed it to the handy-dandy
hex/oct/bin/dec converter package - much easier.

Jared








"Jamadagni, Rajendra" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
 10/02/2003 05:54 AM
 Please respond to ORACLE-L

        
        To:        Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
        cc:        
        Subject:        RE: UNIX : script help/input


XOR  that gives me some painful memories in recent days ... xor is possible in pl/sql but needs a little work. I migrated a "C" encryption code to pl/sql  and then use utl_tcp to sent it to our router which feeds the modem banks.
This is how I worked on it ... but I was working on character by character ... 
xor(a,b) is 
r_a := utl_raw.cast_to_raw(chr(a)); 
r_b := utl_raw.cast_to_raw(chr(b)); 
n_xor := to_number(utl_raw.bit_xor(r_a,r_b),''); 

Of course the manual doesn't tell you this ... 
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: Wednesday, October 01, 2003 6:29 PM 
To: Multiple recipients of list ORACLE-L 

> Good! The more the merrier! Welcome to the club. 
Oh most definitely. 
As I just finished writing a prototype package for assigning MAC 
addresses ( we make network stuff - that's a technical term ), I 
have endured the agonies of doing hex math in PL/SQL. 
I finally bit the bullet and used string manipulation to convert 
hex to decimal and do what I needed that way.  Couldn't get BITAND 
to work properly on very large integers. Besides, doing XOR with 
BITAND in PL/SQL is very painful. 
UTL_RAW has an XOR, but it requires RAW values and I didn't feel 
like messing with it. 
This is all very simple in Perl. 
Given a MAC of 5AA, with a fixed portion of 500, 
it is very easy to determine the variable portion of the address 
via $x = 0x5AA ^ 500. 
Not quite so simple in PL/SQL. 
Jared 

OT: SQLServer resources

[Cunningham, Gerald]

Title: Message



Hi 
all,
 
Can anybody point me 
to a mailing list such as this for SQLServer? (I would be suprised if there's 
something of ORACLE-L's quality, but you never know!). Or, any other resources 
on the web? I'm particularly interested in production support (performance 
tuning, security, backup/recovery, etc.)
 
Thank you very 
much!
 
- 
Jerry
 

Re: Re: Physical I/O and databases other than oracle

[rgaffuri]

i guess my question wasnt clear. What Im getting at is do other databases have wait 
interfaces? Is there architecture such that Physical I/Os are a serious concern. Far 
more than other bottlenecks. Or is this book just garbage... 
> 
> From: Daniel Fink <[EMAIL PROTECTED]>
> Date: 2003/10/02 Thu PM 01:09:36 EDT
> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> Subject: Re: Physical I/O and databases other than oracle
> 
> This is not an issue of answering the question, but pointing out that the question 
> is not correct.
> 
> Why do databases exist (aside to make Larry money)? To 'permanently' store data. As 
> this storage must survive a system failure, we choose to place the data on a 
> non-volatile medium (disk, paper, stone tablets). In order to save and retrieve this 
> data, we need to perform some sort of physical action (write/read). Let's take the 
> telephone system as an example. If we need to look up a phone number, we open the 
> phone book and do a search for the right entry. This can be rather time consuming, 
> especially if we don't know the person's last name or business name. Let's assume we 
> do know the last name, we can get to the proper entry
> fairly quickly, but it still takes some time. Once we have retrieved the information 
> into our memory, we can dial the phone fairly quickly. In this case, the bottleneck 
> is indeed physical i/o. Of course, if we get a busy signal, we can access our memory 
> to redial, completely bypassing the phone book. However, if we are using an old 
> rotary dial phone and we have to make a long distance call, it may take longer to 
> dial the phone than look up the number.
> 
> The real question should be "What is the primary bottleneck in presenting data to 
> the user?"  In my recent projects, I have found that the database is rarely the 
> bottleneck. I have seen bad code, cpu-starvation, spooling to RAID-5 devices, 
> cartesian products.
> 
> Did I mention that I once got an A on an essay test because I argued that the 
> question asked was itself invalid?
> 
> Dan
> 
> Mladen Gogala wrote:
> 
> > On Thu, 2003-10-02 at 11:44, Garry Gillies wrote:
> > > > Im reading an academic book on databases and it states that Physical I/O
> >
> > > Eh?
> > > What IS the primary bottleneck in tuning Oracle?
> >
> > Cache hit ratio. You tune the buffer cache hit ratio (BCHR) and your job
> > is done. Database with 99.9% BCHR must be OK.
> >
> > Note:
> > This message is for the named person's use only.  It may contain confidential, 
> > proprietary or legally privileged information.  No confidentiality or privilege is 
> > waived or lost by any mistransmission.  If you receive this message in error, 
> > please immediately delete it and all copies of it from your system, destroy any 
> > hard copies of it and notify the sender.  You must not, directly or indirectly, 
> > use, disclose, distribute, print, or copy any part of this message if you are not 
> > the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve 
> > the right to monitor all e-mail communications through its networks.
> > Any views expressed in this message are those of the individual sender, except 
> > where the message states otherwise and the sender is authorized to state them to 
> > be the views of any such entity.
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > --
> > Author: Mladen Gogala
> >   INET: [EMAIL PROTECTED]
> >
> > Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> > San Diego, California-- Mailing list and web hosting services
> > -
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from).  You may
> > also send the HELP command for other information (like subscribing).
> 
> 

-- 
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[2]: Physical I/O and databases other than oracle

[Robert Eskridge]

Mladen,

Thursday, October 2, 2003, 12:39:32 PM, you wrote:

M> I do accept your suggestion but I've just received Cary's book
M> and I'm enjoying myself very much. I do humbly apologize for any
M> confusion. To make is perfectly clear to anyone, BCHR is no longer
M> very relevant indicator. My last sentence ("database with BCHR 99.9%
M> must be OK") was formulated in that way as an allusion to Cary Milsap's
M> known article "Why 99% Database Buffer Cache Hit Ratio is NOT Ok".
M> I was just poking little harmless fun at the "silver bullet" approach.

So I drink Coors Light while I'm looking at my BCHR, there's no reason
to poke fun at me

-rje


[oh and here's the :-) ]

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

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

[Jared . Still]

You might try this:  http://www.oracle.com/start/apple/intro.html?src="">








[EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
 10/01/2003 08:24 PM
 Please respond to ORACLE-L

        
        To:        Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
        cc:        
        Subject:        Oracle Client for Macintosh



I've searched TechNet and MetaLink but can't find a downloadable 8i, 9i, anything Oracle Client for Apple Macintosh - OS 9 or OS X.  What am I missing?  Is it not available?  Some docs on MetaLink mention it, but the versions seem related to SQL*Net, not the RDBMS.  I'm clueless when it comes to Macs, so I probably don't know the right keywords. 

Could someone point me in the right direction? 

Thanks.

Jack C. Applewhite
Database Administrator
Austin Independent School District
Austin, Texas
512.414.9715 (wk)
512.935.5929 (pager, [EMAIL PROTECTED])
[EMAIL PROTECTED]

RE: Physical I/O and databases other than oracle

[Khedr, Waleed]

Title: RE: Physical I/O and databases other than oracle



So to look good, 
I should unplug all the CPU boards except one or two to end up with CPU 
limitation :)
 
Regards,
 
Waleed

  -Original Message-From: David Wagoner 
  [mailto:[EMAIL PROTECTED]Sent: Thursday, October 02, 
  2003 12:35 PMTo: Multiple recipients of list 
  ORACLE-LSubject: RE: Physical I/O and databases other than 
  oracle
  According to one recently published source*, in a well-tuned 
  database system, the server should be CPU-limited.  The reasoning here is 
  that in a perfectly tuned system, the other bottlenecks of I/O, network, etc. 
  have been eliminated, so the system is then limited by the speed and number of 
  CPUs.
  This is an ideal system, of course, and we all know that it is 
  common to have less than ideal numbers of disks or I/O controllers to spread 
  the load.
  * "The Art and Science of Oracle Performance Tuning", 
  Christopher Lawson, 2003, p.184.   
  Best regards, 
  David B. Wagoner Database 
  Administrator Arsenal Digital Solutions 
  Web: http://www.arsenaldigital.com 
  "the most trusted source for     
  STORAGE MANAGEMENT SERVICES" 
  The contents of this e-mail message may be privileged and/or 
  confidential. If you are not the intended recipient, any review, 
  dissemination, copying, distribution or other use of the contents of this 
  message or any attachment by you is strictly prohibited. If you receive this 
  communication in error, please notify us immediately by return e-mail or by 
  telephone (919-466-6700), and please delete this message and all attachments 
  from your system. 
  Thank you. 

ORA-03120

[Seema Singh]

Hi,
I have been running DB v8.1.6.0.0 on sun box and applictaion on netra 
without any error.recently I installed linux client with 8.1.7.0.0 . I have 
been noticing following error when linux client is trying to connect to 
DB.I'm assuming its net8 layer problem.let me suggest what to do to fix this 
problem.

"Error: ora8.c:2161:ora_get_row: error in `OCILobRead ()': ORA-03120: 
two-task conversion routine: integer overflow "
Thx
-Seema

_
Get McAfee virus scanning and cleaning of incoming attachments.  Get Hotmail 
Extra Storage!   http://join.msn.com/?PAGE=features/es

--
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: STAT from trace

[Henry Poras]

No little minds at this place, maybe just hobgoblins. Certainly no
consistency. I tried again this morning and everything worked. (of course I
don't know what has changed behind the scenes:Oracle patches, OS
patches???). Jane, stop this crazy thing.

Thanks for the suggestions. Next time I'll spool my commands immediately so
they'll be some record.

Henry


-Original Message-
Cary Millsap
Sent: Wednesday, October 01, 2003 6:14 PM
To: Multiple recipients of list ORACLE-L


If you exited the Oracle session without deactivating the trace, then
you should probably see a XCTEND as well, right? If you see the XCTEND
but no STAT lines, then I think you've found a bug.


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

Upcoming events:
- Performance Diagnosis 101: 10/28 Phoenix, 11/19 Sydney
- Hotsos Symposium 2004: March 7-10 Dallas
- Visit www.hotsos.com for schedule details...


-Original Message-
Henry Poras
Sent: Wednesday, October 01, 2003 4:45 PM
To: Multiple recipients of list ORACLE-L

Wolfgang,

I'll give level 9 a try. Yes I get PARSE, EXEC, FETCH, WAIT. My platform
is
AIX 5.1

For now I've run sql_trace = true and 10046 level 8 and looked at two
seperate trace files. I've had this working before, but I can't remember
if
it was on 5.1 or when we still were at AIX 4.

Thanks for the suggestions.

Henry


-Original Message-
Wolfgang Breitling
Sent: Wednesday, October 01, 2003 3:45 PM
To: Multiple recipients of list ORACLE-L


Do you get the PARSE, EXEC and FETCH entries for the sql?

You gave us your Oracle version, but what is your platform?
Would you care to try the following: since sql_trace = true corresponds
to
"event 10046, level 1", why not set event 10046 at level 9. Maybe
that'll
do the trick.

At 12:59 PM 10/1/2003, you wrote:
>Tried that. Also queried on open_cursors in a parallel session.
>
>Henry
>
>-Original Message-
>From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of
>Daniel Fink
>Sent: Wednesday, October 01, 2003 1:59 PM
>To: Multiple recipients of list ORACLE-L
>Subject: Re: STAT from trace
>
>Henry,
>
>What happens if you issue another query after the query of interest?
>(something like "select 1 from dual;") STAT should be emitted when the
>cursor is closed.
>
>Daniel
>
>
>Henry Poras wrote:
>>  Thanks. I tried both disabling the trace and quitting from the
session.
>> No luck with 10046, just sql_trace.Henry
>>-Original Message-
>>From: [EMAIL PROTECTED]
>>[mailto:[EMAIL PROTECTED] Behalf
Of
>>Jamadagni, Rajendra
>>Sent: Wednesday, October 01, 2003 10:25 AM
>>To: Multiple recipients of list ORACLE-L
>>Subject: RE: STAT from trace
>>
>>I get STAT lines no matter how I enable the trace. Make sure you
wither
>>close the session or stop the trace so that all pending STAT lines
will
>>be written to the file.
>>
>>Raj
>>
>>-Original Message-
>>From: Henry Poras
[mailto:[EMAIL PROTECTED]
>>Sent: Wednesday, October 01, 2003 9:34 AM
>>To: Multiple recipients of list ORACLE-L
>>Subject: STAT from trace
>>
>>I was creating some trace files yesterday and came across one of these
>>problems that shows up occasionally (then I forget about it).
>>
>>When I ran my query using ALTER SESSION SET sql_trace=true (sqlplus;
>>8.1.7.4), I got the STAT line in the trace and the associated 'row
source'
>>information after running tkprof.
>>
>>When I ran my query using ALTER SESSION SET EVENTS '10046 trace name
context
>>forever, level 8' (or with dbms_system.set_ev), there were no STAT
entries
>>for my query. There were some for some of the recursive queries.
>>
>>Everything else was identical.
>>
>>What's up?
>>
>>Henry
>
>Wolfgang Breitling
>Oracle7, 8, 8i, 9i OCP DBA
>Centrex Consulting Corporation
>http://www.centrexcc.com


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

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

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

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

RE: logg error line in unix

[Henry Poras]

A separated semi-colon sounds like a quarter to me. Unfortunately Oracle
docs cost more than a quarter so I would check the free version on-line. The
information isn't too tough to digest.

Henry


-Original Message-
[EMAIL PROTECTED]
Sent: Thursday, October 02, 2003 9:35 AM
To: Multiple recipients of list ORACLE-L


Hallo again,

I would like to get some help on this.
 I have a script called let us say test.sh and that script runs an sqlloader
script, which loads semicolonseparated data into an oracle table.
I would like to have an example on how to log an error when trying to insert
the data intothe table.
I want the error to be both the error message and also tell me which line
that is wrong in the file.

So both errormessage and also complete line which is the error line.


Thanks in advance


Roland




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

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

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

Re: Physical I/O and databases other than oracle

[Mladen Gogala]

I do accept your suggestion but I've just received Cary's book
and I'm enjoying myself very much. I do humbly apologize for any
confusion. To make is perfectly clear to anyone, BCHR is no longer
very relevant indicator. My last sentence ("database with BCHR 99.9%
must be OK") was formulated in that way as an allusion to Cary Milsap's
known article "Why 99% Database Buffer Cache Hit Ratio is NOT Ok".
I was just poking little harmless fun at the "silver bullet" approach.

On Thu, 2003-10-02 at 12:49, Thomas Day wrote:
> How about a tongue-in-cheek smiley (>) to indicate that the following
> advice is offered ironically and is not to be followed.  Sort of like the
> hidden parameter _SET_RUN_FASTER=TRUE.  We are always getting new members
> and they may not be aware of previous threads.
> 
> 
> 
>  
>   
>   Mladen Gogala  
>   
>ORACLE-L <[EMAIL PROTECTED]>
>   @wangtrading.com cc:   
>   
>   >Subject: Re: Physical I/O and 
> databases other than oracle   
>   Sent by:   
>   
>   ml-errors  
>   
>  
>   
>  
>   
>   10/02/2003 12:34   
>   
>   PM 
>   
>   Please respond 
>   
>   to ORACLE-L
>   
>  
>   
>  
>   
> 
> 
> 
> 
> On Thu, 2003-10-02 at 11:44, Garry Gillies wrote:
> > > Im reading an academic book on databases and it states that Physical
> I/O
> 
> > Eh?
> > What IS the primary bottleneck in tuning Oracle?
> 
> Cache hit ratio. You tune the buffer cache hit ratio (BCHR) and your job
> is done. Database with 99.9% BCHR must be OK.
> 
> 
> 
> 
> Note:
> This message is for the named person's use only.  It may contain
> confidential, proprietary or legally privileged information.  No
> confidentiality or privilege is waived or lost by any mistransmission.  If
> you receive this message in error, please immediately delete it and all
> copies of it from your system, destroy any hard copies of it and notify the
> sender.  You must not, directly or indirectly, use, disclose, distribute,
> print, or copy any part of this message if you are not the intended
> recipient. Wang Trading LLC and any of its subsidiaries each reserve the
> right to monitor all e-mail communications through its networks.
> Any views expressed in this message are those of the individual sender,
> except where the message states otherwise and the sender is authorized to
> state them to be the views of any such entity.
> 
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Mladen Gogala
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> 
> 
> 
> 
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net




Note:
This message is for the named person's use only.  It may contain confidential, 
proprietary or legally privileged information.  No confidentiality or privilege is 
wai

RE: Hiding passwords

[Bob Metelsky]

That's very interesting... Thank you. Do you know how that can be set in
an env variable? Or how the hidden variable can be passed around?

Eg

C:\ads>set var=set var=more echo is on

???

Thanks
Bob

>In Windows2000 you can encrypt a file... Not sure how well that would
work
>though, since if you install your software as local administrator (not
good
>practice) then anyone else who logs in as administrator would be able
to see
>/ run the file too...
 


Here is a little known trick of NTFS file systems.
It's called "data streams".

D:\>del file.txt
D:\>echo Some stuff > file.txt
D:\>echo and its password >file.txt:pwd
D:\>dir
 Volume in drive D is OS
 Volume Serial Number is A4BA-68F3
 Directory of D:\
24/09/2003  11:19p  13 file.txt
(note the file size!)
D:\>type file.txt
Some stuff
D:\>type file.txt:pwd
The filename, directory name, or volume label syntax is incorrect.
D:\>more 

I'm sure there are some interesting uses to be explored here
to hide Oracle passwords!  ;)
Note: the hidden data stream name can be ANY filename string and is
subject
to security.  This was used initially in NTFS to support the Mac
resource 
fork file format in file servers.  It is still there and won't go away
any 
time soon as IIS uses it.

MS Knowledge base article 105763 discusses this in detail.
You can also search google for some details.  Use "alternate data
streams".
Careful: this is used by some virus writers!!!

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

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

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

[Jared . Still]

A search on 'cygwin perl dbi oracle' revealed a number of URL's that may be helpful.

This one looked promising:

http://sources.redhat.com/ml/cygwin/2002-08/msg00923.html

Jared







Stefan Jahnke <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
 10/02/2003 03:49 AM
 Please respond to ORACLE-L

        
        To:        Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
        cc:        
        Subject:        AW: UNIX : script help/input


Hi

Speaking of Perl, ... maybe somebody (Jared) can help out with some Perl /
Windows problems:
I'm using ActiveState 5.6 with DBI module, which works fine. Now, since I
basically work within a CygWin environment on my laptop, I installed perl
there, but there are no DBI modules. The basic problem is, that in order to
get the DBI stuff compiled within cygwin, you would need a unix/cygwin
wrapper for the OCI dlls, which are common windows dlls coming with the
Oracle client (9.2.0.4) in order to import OCI stuff correctly, which is
needed by DBI (at least I think so). The dlltool doesn't really help me
here, since the dlls supplied by Oracle seem to be stripped (at least,
dlltool can't find any symbols). If I try:

$ nm oci.dll | grep ' T _' | sed 's/.* T _//' >> oci.def

I only get:

nm: oci.dll: no symbols

Does anybody have an idea how to use the windows oci (or any other Oracle
dll) from cygwin ?
Otherwise I can also go ahead and toss out cygwin, since accessing Oracle is
basically all I need it for.

Regards,
Stefan

-Ursprüngliche Nachricht-
Von: Jared Still [mailto:[EMAIL PROTECTED]
Gesendet: Donnerstag, 2. Oktober 2003 00:29
An: Multiple recipients of list ORACLE-L
Betreff: RE: UNIX : script help/input


> Good! The more the merrier! Welcome to the club.

Oh most definitely.

As I just finished writing a prototype package for assigning MAC
addresses ( we make network stuff - that's a technical term ), I
have endured the agonies of doing hex math in PL/SQL.

I finally bit the bullet and used string manipulation to convert
hex to decimal and do what I needed that way.  Couldn't get BITAND
to work properly on very large integers. Besides, doing XOR with
BITAND in PL/SQL is very painful.

UTL_RAW has an XOR, but it requires RAW values and I didn't feel
like messing with it.

This is all very simple in Perl.

Given a MAC of 5AA, with a fixed portion of 500,
it is very easy to determine the variable portion of the address
via $x = 0x5AA ^ 500.

Not quite so simple in PL/SQL.

Jared





On Wed, 2003-10-01 at 14:44, Mladen Gogala wrote:
> On Wed, 2003-10-01 at 14:34, Jamadagni, Rajendra wrote:
> > Funny .. I am currently sitting in a Perl class, so I can actually
> > read what MG has written. I'll be soon Perl-literate ...
> >  
> > Raj
> 

> 
> 
> 
> 
> Note:
> This message is for the named person's use only.  It may contain
confidential, proprietary or legally privileged information.  No
confidentiality or privilege is waived or lost by any mistransmission.  If
you receive this message in error, please immediately delete it and all
copies of it from your system, destroy any hard copies of it and notify the
sender.  You must not, directly or indirectly, use, disclose, distribute,
print, or copy any part of this message if you are not the intended
recipient. Wang Trading LLC and any of its subsidiaries each reserve the
right to monitor all e-mail communications through its networks.
> Any views expressed in this message are those of the individual sender,
except where the message states otherwise and the sender is authorized to
state them to be the views of any such entity.
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: Mladen Gogala
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
> San Diego, California        -- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> 


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


 
-- 
Please see the officia

Re: Oracle and nfs mounted devices.

[Daniel Fink]

IIRC, you will also need to change who is the running owner of the oracle
process. In WinNT/2k, this defaults to SYSTEM. You need to create an
ORACLE user on each system and change the instance owner to ORACLE. Then deal
with the normal permissions stuff. There should be a note on metalink on how to
accomplish this, along with a warning that this is not a supported
configuration.

Daniel


Yechiel Adar wrote:

> I think that you need to check the sharing options on the remote computer.
>
> Make sure that the user that run the create database has full control on
> oracle in the remote server.
>
> Yechiel Adar
> Mehish
> - Original Message -
> To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
> Sent: Thursday, October 02, 2003 5:44 PM
>
> >
> > Hello Gurus:
> >
> > I have been asked to create datafiles (create tablespace) on disk drives
> > that are mapped ( internal disk - attached to remote servers)
> >
> > When I tried creating tablespace...I get  the following error message:
> >
> >
> > ERROR at line 1:
> > ORA-01119: error in creating database file
> > 'd:\oracle\oradata\mmstest\test.dbf'
> > ORA-27040: skgfrcre: create error, unable to create file
> > OSD-04002: unable to open file
> > O/S-Error: (OS 3) The system cannot find the path specified.
> >
> >
> > My opinion is Oracle does not support this operation.
> >
> > However I do not fully understand the internals of it...Is oracle not able
> > to obtain locks on the device?
> >
> > Please Help.
> >
> > Thanks,
> > Murali.
> >
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > --
> > Author:
> >   INET: Murali_Pavuloori/[EMAIL PROTECTED]
> >
> > Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> > San Diego, California-- Mailing list and web hosting services
> > -
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (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: Yechiel Adar
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (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
x-mozilla-html:FALSE
org:Sun Microsystems, Inc.
adr:;;
version:2.1
title:Lead, Database Services
x-mozilla-cpt:;9168
fn:Daniel  W. Fink
end:vcard

Re: Re: Physical I/O and databases other than oracle

[rgaffuri]

my email states that in oracle this isnt true. HOWEVER, what about other databases? 
> 
> From: Mladen Gogala <[EMAIL PROTECTED]>
> Date: 2003/10/02 Thu PM 12:34:33 EDT
> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> Subject: Re: Physical I/O and databases other than oracle
> 
> On Thu, 2003-10-02 at 11:44, Garry Gillies wrote:
> > > Im reading an academic book on databases and it states that Physical I/O 
> 
> > Eh?
> > What IS the primary bottleneck in tuning Oracle?
> 
> Cache hit ratio. You tune the buffer cache hit ratio (BCHR) and your job
> is done. Database with 99.9% BCHR must be OK.
> 
> 
> 
> 
> Note:
> This message is for the named person's use only.  It may contain confidential, 
> proprietary or legally privileged information.  No confidentiality or privilege is 
> waived or lost by any mistransmission.  If you receive this message in error, please 
> immediately delete it and all copies of it from your system, destroy any hard copies 
> of it and notify the sender.  You must not, directly or indirectly, use, disclose, 
> distribute, print, or copy any part of this message if you are not the intended 
> recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to 
> monitor all e-mail communications through its networks.
> Any views expressed in this message are those of the individual sender, except where 
> the message states otherwise and the sender is authorized to state them to be the 
> views of any such entity.
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: Mladen Gogala
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> 

-- 
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: Physical I/O and databases other than oracle

[Daniel Fink]

This is not an issue of answering the question, but pointing out that the question is 
not correct.

Why do databases exist (aside to make Larry money)? To 'permanently' store data. As 
this storage must survive a system failure, we choose to place the data on a 
non-volatile medium (disk, paper, stone tablets). In order to save and retrieve this 
data, we need to perform some sort of physical action (write/read). Let's take the 
telephone system as an example. If we need to look up a phone number, we open the 
phone book and do a search for the right entry. This can be rather time consuming, 
especially if we don't know the person's last name or business name. Let's assume we 
do know the last name, we can get to the proper entry
fairly quickly, but it still takes some time. Once we have retrieved the information 
into our memory, we can dial the phone fairly quickly. In this case, the bottleneck is 
indeed physical i/o. Of course, if we get a busy signal, we can access our memory to 
redial, completely bypassing the phone book. However, if we are using an old rotary 
dial phone and we have to make a long distance call, it may take longer to dial the 
phone than look up the number.

The real question should be "What is the primary bottleneck in presenting data to the 
user?"  In my recent projects, I have found that the database is rarely the 
bottleneck. I have seen bad code, cpu-starvation, spooling to RAID-5 devices, 
cartesian products.

Did I mention that I once got an A on an essay test because I argued that the question 
asked was itself invalid?

Dan

Mladen Gogala wrote:

> On Thu, 2003-10-02 at 11:44, Garry Gillies wrote:
> > > Im reading an academic book on databases and it states that Physical I/O
>
> > Eh?
> > What IS the primary bottleneck in tuning Oracle?
>
> Cache hit ratio. You tune the buffer cache hit ratio (BCHR) and your job
> is done. Database with 99.9% BCHR must be OK.
>
> Note:
> This message is for the named person's use only.  It may contain confidential, 
> proprietary or legally privileged information.  No confidentiality or privilege is 
> waived or lost by any mistransmission.  If you receive this message in error, please 
> immediately delete it and all copies of it from your system, destroy any hard copies 
> of it and notify the sender.  You must not, directly or indirectly, use, disclose, 
> distribute, print, or copy any part of this message if you are not the intended 
> recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to 
> monitor all e-mail communications through its networks.
> Any views expressed in this message are those of the individual sender, except where 
> the message states otherwise and the sender is authorized to state them to be the 
> views of any such entity.
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Mladen Gogala
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
begin:vcard 
n:Fink;Daniel
x-mozilla-html:FALSE
org:Sun Microsystems, Inc.
adr:;;
version:2.1
title:Lead, Database Services
x-mozilla-cpt:;9168
fn:Daniel  W. Fink
end:vcard

RE: Oracle Client for Macintosh

[Goulet, Dick]

Matt,

As far as I'm concerned all that a MAC is good for is as a paper weight.  And 
that's pretty bad since I was an Apple fan for many a year.

Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA

-Original Message-
Sent: Thursday, October 02, 2003 12:40 PM
To: Multiple recipients of list ORACLE-L



And actually, at oracleworld there was a huge booth from Apple showing
Oracle database, 9iAS, and applications running on Oracle.  I've got on my
computer here the developer release of 9i for OS X...haven't installed it
yet as I'm waiting for my new mac laptop.

Thanks,
Matt

--
Matthew Zito
GridApp Systems
Email: [EMAIL PROTECTED]
Cell: 646-220-3551
Phone: 212-358-8211 x 359
http://www.gridapp.com

> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On 
> Behalf Of Jesse, Rich
> Sent: Thursday, October 02, 2003 11:19 AM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: Oracle Client for Macintosh
> 
> 
> Erm, that's the Motorola 68K CPUs.  They are as dead as my 
> beloved Amiga (well almost: 
> http://www.freiburg.linux.de/~uae/).  As far as Gx Apples, 
> I've been trying OTN, but all I get is "Error: Timeout occurred while
> retrieving page meta data."   
> 
> Rich
> 
> Rich Jesse   System/Database Administrator
> [EMAIL PROTECTED]  Quad/Tech Inc, Sussex, WI USA
> 
> 
> -Original Message-
> Sent: Thursday, October 02, 2003 10:00 AM
> To: Multiple recipients of list ORACLE-L
> 
> 
> MAC's are DEAD from Oracle's point of view.  See  Note:61797.1 
> 
> Dick Goulet
> Senior Oracle DBA
> Oracle Certified 8i DBA 
> -Original Message- [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, October 01, 2003 11:24 PM
> To: Multiple recipients of list ORACLE-L
> 
> 
> 
> I've searched TechNet and MetaLink but can't find a 
> downloadable 8i, 9i, anything Oracle Client for Apple 
> Macintosh - OS 9 or OS X.  What am I missing?  Is it not 
> available?  Some docs on MetaLink mention it, but the 
> versions seem related to SQL*Net, not the RDBMS.  I'm 
> clueless when it comes to Macs, so I probably don't know the 
> right keywords. 
> 
> Could someone point me in the right direction? 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: Jesse, Rich
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 
> and in the message BODY, include a line containing: UNSUB 
> ORACLE-L (or the name of mailing list you want to be removed 
> from).  You may also send the HELP command for other 
> information (like subscribing).
> 

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

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

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

What is the best way to download the Metalink Notes

[Mandal, Ashoke]

Hi All,

I need to add some Metalink notes to one of my project document. When I copy the text 
of the metalink note and paste it in a word document the formatting gets messed up.

Is there any other way to download this metalink note without messing the formatting.


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

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Physical I/O and databases other than oracle

[Thomas Day]

How about a tongue-in-cheek smiley (>) to indicate that the following
advice is offered ironically and is not to be followed.  Sort of like the
hidden parameter _SET_RUN_FASTER=TRUE.  We are always getting new members
and they may not be aware of previous threads.



   

  Mladen Gogala

  
  @wangtrading.com cc: 

  >Subject: Re: Physical I/O and databases 
other than oracle   
  Sent by: 

  ml-errors

   

   

  10/02/2003 12:34 

  PM   

  Please respond   

  to ORACLE-L  

   

   





On Thu, 2003-10-02 at 11:44, Garry Gillies wrote:
> > Im reading an academic book on databases and it states that Physical
I/O

> Eh?
> What IS the primary bottleneck in tuning Oracle?

Cache hit ratio. You tune the buffer cache hit ratio (BCHR) and your job
is done. Database with 99.9% BCHR must be OK.




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

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

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





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

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

[Matthew Zito]

And actually, at oracleworld there was a huge booth from Apple showing
Oracle database, 9iAS, and applications running on Oracle.  I've got on my
computer here the developer release of 9i for OS X...haven't installed it
yet as I'm waiting for my new mac laptop.

Thanks,
Matt

--
Matthew Zito
GridApp Systems
Email: [EMAIL PROTECTED]
Cell: 646-220-3551
Phone: 212-358-8211 x 359
http://www.gridapp.com

> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On 
> Behalf Of Jesse, Rich
> Sent: Thursday, October 02, 2003 11:19 AM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: Oracle Client for Macintosh
> 
> 
> Erm, that's the Motorola 68K CPUs.  They are as dead as my 
> beloved Amiga (well almost: 
> http://www.freiburg.linux.de/~uae/).  As far as Gx Apples, 
> I've been trying OTN, but all I get is "Error: Timeout occurred while
> retrieving page meta data."   
> 
> Rich
> 
> Rich Jesse   System/Database Administrator
> [EMAIL PROTECTED]  Quad/Tech Inc, Sussex, WI USA
> 
> 
> -Original Message-
> Sent: Thursday, October 02, 2003 10:00 AM
> To: Multiple recipients of list ORACLE-L
> 
> 
> MAC's are DEAD from Oracle's point of view.  See  Note:61797.1 
> 
> Dick Goulet
> Senior Oracle DBA
> Oracle Certified 8i DBA 
> -Original Message- [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, October 01, 2003 11:24 PM
> To: Multiple recipients of list ORACLE-L
> 
> 
> 
> I've searched TechNet and MetaLink but can't find a 
> downloadable 8i, 9i, anything Oracle Client for Apple 
> Macintosh - OS 9 or OS X.  What am I missing?  Is it not 
> available?  Some docs on MetaLink mention it, but the 
> versions seem related to SQL*Net, not the RDBMS.  I'm 
> clueless when it comes to Macs, so I probably don't know the 
> right keywords. 
> 
> Could someone point me in the right direction? 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: Jesse, Rich
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 
> and in the message BODY, include a line containing: UNSUB 
> ORACLE-L (or the name of mailing list you want to be removed 
> from).  You may also send the HELP command for other 
> information (like subscribing).
> 

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

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

[Branimir Petrovic]

> 
> I have been asked to create datafiles (create tablespace) on 
> disk drives
> that are mapped ( internal disk - attached to remote servers)
> 
> When I tried creating tablespace...I get  the following error message:
> 
> 
> ERROR at line 1:
> ORA-01119: error in creating database file
> 'd:\oracle\oradata\mmstest\test.dbf'
> ORA-27040: skgfrcre: create error, unable to create file
> OSD-04002: unable to open file
> O/S-Error: (OS 3) The system cannot find the path specified.
> 

I firmly believe that placing database files across the network is 
one very bad idea indeed, however your problem most likely comes 
from the fact that Oracle service runs as local (Windows) system 
account and as such across the network it has exactly the level 
of rights it deserves - none whatsoever. If you set the Oracle 
service to run as recognized network user that have read/right
permissions on mapped drive - it might work, but it would still
be a bad-bad idea to go ahead and actually do so (teeny tiny 
network 'hick up', and find yourself practicing recovery scenarios).

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

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

Re: Physical I/O and databases other than oracle

[Mladen Gogala]

On Thu, 2003-10-02 at 11:44, Garry Gillies wrote:
> > Im reading an academic book on databases and it states that Physical I/O 

> Eh?
> What IS the primary bottleneck in tuning Oracle?

Cache hit ratio. You tune the buffer cache hit ratio (BCHR) and your job
is done. Database with 99.9% BCHR must be OK.




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

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

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

RE: Physical I/O and databases other than oracle

[David Wagoner]

Title: RE: Physical I/O and databases other than oracle





According to one recently published source*, in a well-tuned database system, the server should be CPU-limited.  The reasoning here is that in a perfectly tuned system, the other bottlenecks of I/O, network, etc. have been eliminated, so the system is then limited by the speed and number of CPUs.

This is an ideal system, of course, and we all know that it is common to have less than ideal numbers of disks or I/O controllers to spread the load.


* "The Art and Science of Oracle Performance Tuning", Christopher Lawson, 2003, p.184.
 


Best regards,


David B. Wagoner
Database Administrator
Arsenal Digital Solutions
Web: http://www.arsenaldigital.com


"the most trusted source for
    STORAGE MANAGEMENT SERVICES"



The contents of this e-mail message may be privileged and/or confidential. If you are not the intended recipient, any review, dissemination, copying, distribution or other use of the contents of this message or any attachment by you is strictly prohibited. If you receive this communication in error, please notify us immediately by return e-mail or by telephone (919-466-6700), and please delete this message and all attachments from your system. 

Thank you.

Re: Oracle and nfs mounted devices.

[Mladen Gogala]

On Thu, 2003-10-02 at 11:44, Murali_Pavuloori/[EMAIL PROTECTED]
wrote:
> Hello Gurus:
> 
> I have been asked to create datafiles (create tablespace) on disk drives
> that are mapped ( internal disk - attached to remote servers)
> 
> When I tried creating tablespace...I get  the following error message:

Murali, the answer is: generally speaking, you cannot have datafiles on 
NFS mounted filesystems. There are examples to the contrary (NetApp) but
they're highly dependent upon the particular implementation. For the
details, contact your friendly neighborhood oracle representative .You
can, however, have read-only tablespace on NFS server. To do that, you
do the following: 
1) Copy read-only tablespace from a local filesystem to the NFS mounted
   one.
2) Check protection and make sure oracle can read it.
3) alter database rename file --> NFS mounted one.
4) Verify from V$DATAFILE that your datafile indeed is what it should
   be.
5) Remove the original file.

The very same procedure applies when creating a read-only tablespace on
a CD. 




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

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

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

Books on Oracle Workflow????

[Paulo Gomes]

Title: Mensagem



Hi, guys
I'm trying to find some good 
readings in Oracle Workflow. Something like Osborne, Oracle press. Can someone 
give some hints??
Thanks in 
advance
Regards
PG

Re: Oracle and nfs mounted devices.

[Yechiel Adar]

I think that you need to check the sharing options on the remote computer.

Make sure that the user that run the create database has full control on
oracle in the remote server.

Yechiel Adar
Mehish
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Thursday, October 02, 2003 5:44 PM


>
> Hello Gurus:
>
> I have been asked to create datafiles (create tablespace) on disk drives
> that are mapped ( internal disk - attached to remote servers)
>
> When I tried creating tablespace...I get  the following error message:
>
>
> ERROR at line 1:
> ORA-01119: error in creating database file
> 'd:\oracle\oradata\mmstest\test.dbf'
> ORA-27040: skgfrcre: create error, unable to create file
> OSD-04002: unable to open file
> O/S-Error: (OS 3) The system cannot find the path specified.
>
>
> My opinion is Oracle does not support this operation.
>
> However I do not fully understand the internals of it...Is oracle not able
> to obtain locks on the device?
>
> Please Help.
>
> Thanks,
> Murali.
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author:
>   INET: Murali_Pavuloori/[EMAIL PROTECTED]
>
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (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: Yechiel Adar
  INET: [EMAIL PROTECTED]

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

[Bob Metelsky]

I am not a guru (as any one here can attest...  but

The last line tell you what the problem is
" O/S-Error: (OS 3) The system cannot find the path specified."

Oracle cant find the path, you probably need to pass it something like

\\server_name\d$\oracle\oradata\mmstest\test.dbf
providing the oracle on d is shared out

bob

Hello Gurus:

I have been asked to create datafiles (create tablespace) on disk drives
that are mapped ( internal disk - attached to remote servers)

When I tried creating tablespace...I get  the following error message:


ERROR at line 1:
ORA-01119: error in creating database file
'd:\oracle\oradata\mmstest\test.dbf'
ORA-27040: skgfrcre: create error, unable to create file
OSD-04002: unable to open file
O/S-Error: (OS 3) The system cannot find the path specified.


My opinion is Oracle does not support this operation.

However I do not fully understand the internals of it...Is oracle not
able
to obtain locks on the device?

Please Help.

Thanks,
Murali.


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

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

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

[Gudmundur Josepsson]

Cary Millsap <[EMAIL PROTECTED]> wrote :

> /;;[^;]

That has to be the strangest smiley I've ever seen :)

Gudmundur

Þessi póstur var sendur með vefpósti mi, http://www.mi.is


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

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

[Stefick Ronald S Contr ESC/HRIDD]

Title: RE: logg error line in unix





Log=/log/file/name


-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] 
Sent: Thursday, October 02, 2003 9:45 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: logg error line in unix




Please give me an example on this.



Roland






   

  Jack van Zanen   

  <[EMAIL PROTECTED]    To:   Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>   

  S.NL>    cc: 

  Sent by: Subject:  RE: logg error line in unix   

  [EMAIL PROTECTED]    

  .com 

   

   

  2003-10-02 15:54 

  Please respond to    

  ORACLE-L 

   

   




Bad records go to bad file
Logfile can be turned on with log parameter


Jacob A. van Zanen
Oracle DBA
Quant Systems Europe b.v.
Tel : +31 (0) 251 - 268 268
Mobile: +31 (0) 6 51308813
Fax: +31 (0) 251 - 268 269
E-mail: mailto:[EMAIL PROTECTED]
Visit our web site at http://www.quantsystems.nl/




-Original Message-
Sent: Thursday, October 02, 2003 3:35 PM
To: Multiple recipients of list ORACLE-L



Hallo again,


I would like to get some help on this.
 I have a script called let us say test.sh and that script runs an sqlloader script, which loads semicolonseparated data into an oracle table. I would like to have an example on how to log an error when trying to insert the data intothe table. I want the error to be both the error message and also tell me which line that is wrong in the file.

So both errormessage and also complete line which is the error line.



Thanks in advance



Roland





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

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


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

Re: logg error line in unix

[Daniel Fink]

I prefer to tell BAD data to go sit in the corner and think about why it is
BAD. After a suitable time, I'll let the BAD data out of the corner and it can
rejoin the rest of the data, as long as it agrees to play nice and not upset
the other data.


Yechiel Adar wrote:

> Have you tried to run sqlldr with BAD data?
>
> Yechiel Adar
> Mehish
> - Original Message -
> To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
> Sent: Thursday, October 02, 2003 4:44 PM
>
> >
> > Please give me an example on this.
> >
> >
> > Roland
> >
> >
> >
> >
> >
> >
> >   Jack van Zanen
> >   <[EMAIL PROTECTED]To:   Multiple
> recipients of list ORACLE-L <[EMAIL PROTECTED]>
> >   S.NL>cc:
> >   Sent by: Subject:  RE: logg error
> line in unix
> >   [EMAIL PROTECTED]
> >   .com
> >
> >
> >   2003-10-02 15:54
> >   Please respond to
> >   ORACLE-L
> >
> >
> >
> >
> >
> >
> > Bad records go to bad file
> > Logfile can be turned on with log parameter
> >
> > Jacob A. van Zanen
> > Oracle DBA
> > Quant Systems Europe b.v.
> > Tel : +31 (0) 251 - 268 268
> > Mobile: +31 (0) 6 51308813
> > Fax: +31 (0) 251 - 268 269
> > E-mail: mailto:[EMAIL PROTECTED]
> > Visit our web site at http://www.quantsystems.nl/
> >
> >
> >
> > -Original Message-
> > Sent: Thursday, October 02, 2003 3:35 PM
> > To: Multiple recipients of list ORACLE-L
> >
> >
> > Hallo again,
> >
> > I would like to get some help on this.
> >  I have a script called let us say test.sh and that script runs an
> sqlloader
> > script, which loads semicolonseparated data into an oracle table. I would
> > like to have an example on how to log an error when trying to insert the
> > data intothe table. I want the error to be both the error message and also
> > tell me which line that is wrong in the file.
> >
> > So both errormessage and also complete line which is the error line.
> >
> >
> > Thanks in advance
> >
> >
> > Roland
> >
> >
> >
> >
> > --
> > 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).
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > --
> > Author: Jack van Zanen
> >   INET: [EMAIL PROTECTED]
> >
> > Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> > San Diego, California-- Mailing list and web hosting services
> > -
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (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).
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Yechiel Adar
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (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
x-mozilla-html:FALSE
org:

Oracle and nfs mounted devices.

[Murali_Pavuloori/Claritas]

Hello Gurus:

I have been asked to create datafiles (create tablespace) on disk drives
that are mapped ( internal disk - attached to remote servers)

When I tried creating tablespace...I get  the following error message:


ERROR at line 1:
ORA-01119: error in creating database file
'd:\oracle\oradata\mmstest\test.dbf'
ORA-27040: skgfrcre: create error, unable to create file
OSD-04002: unable to open file
O/S-Error: (OS 3) The system cannot find the path specified.


My opinion is Oracle does not support this operation.

However I do not fully understand the internals of it...Is oracle not able
to obtain locks on the device?

Please Help.

Thanks,
Murali.


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

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

[Wolfgang Breitling]

What is the block size of the database. Also, is the AVG_ROW_LEN of almost 
5000 bytes evenly distributed, i.e. are ALL rows more or less 5000 bytes 
long, or are there many rows that are a lot smaller and then some that are 
really big?

At 11:49 PM 10/1/2003, you wrote:
Here are the stats if you're interested. I can't run dbms_space on the 
table because it will lock up the application. This table is accessed ALL 
the time. It grabbed another 100M today! Extent management is LOCAL with 
UNIFORM SIZE of 100M.

24th Sep 2003

OWNE 
SEGMENT_NAME  TABLESPACE_NAMEKB 
NEXTKB EXT[MAX]  % Inc
 -   
  --
CCA  CONNECT_TASK[T]   CC_TASK_TABS3,891,200 
   102,400 38[2147483645]0
CCA  CONNECT_TASK_CONNECTID[I] CC_TASK_IDXS  102,400 
   102,400 1[2147483645] 0
CCA  CONNECT_TASK_CRN[I]   CC_TASK_IDXS  102,400 
   102,400 1[2147483645] 0
CCA  PK_CONNECT_TASK[I]CC_TASK_IDXS  102,400 
   102,400 1[2147483645] 0

OWNE TABLE_NAME   NUM_ROWS AVG_ROW_LEN BLOCKS 
EMPTY_BLOCKS  CHAIN_CNT
 -- -- --- -- 
 --
CCA  CONNECT_TASK   1855834898 484189 
   2210   1445



2nd Oct 2003

OWNERSEGMENT_NAME  TABLESPACE_NAME 
   KB   NEXTKB EXT[MAX]
 - 
   
CCA  CONNECT_TASK[T]   CC_TASK_TABS 
4,198,400  102,400 41[2147483645]
CCA  CONNECT_TASK_CONNECTID[I] CC_TASK_IDXS 
  102,400  102,400 1[2147483645]
CCA  CONNECT_TASK_CRN[I]   CC_TASK_IDXS 
  102,400  102,400 1[2147483645]
CCA  PK_CONNECT_TASK[I]CC_TASK_IDXS 
  102,400  102,400 1[2147483645]

OWNE TABLE_NAME   NUM_ROWS AVG_ROW_LEN BLOCKS 
EMPTY_BLOCKS  CHAIN_CNT
 -- -- --- -- 
 --
CCA  CONNECT_TASK   1841134958 512699 
  12100   1528




 From: "Sinardy Xing" <[EMAIL PROTECTED]>
 Date: Wed, 1 Oct 2003 14:51:40 +0800
 Subject: RE: Table not reusing deleted space
Hi Kaing,

Have you check the degree of fragmentation?

have you check your extent size?

Sinardy

--
Leng Kaing
Email: [EMAIL PROTECTED]
Phone: +61-3-9203-7589
Mobile: +61-417-371-348
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Kaing, Leng
  INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
Wolfgang Breitling
Oracle7, 8, 8i, 9i OCP DBA
Centrex Consulting Corporation
http://www.centrexcc.com 

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

Re: Physical I/O and databases other than oracle

[Garry Gillies]

> Im reading an academic book on databases and it states that Physical I/O 
is often the > primary bottleneck in tuning. Its not the case in Oracle. 
Is this statement correct
> with sybase, sql server, or DB2? or maybe mysql? 

Eh?
What IS the primary bottleneck in tuning Oracle?
I go along with Jonathan Lewis in his book Practical Oracle 8i
"Although it is possible to create a few problems with network traffic,
excess CPU usage and process contention, ultimately the only significant
threat to a database system is physical I/O". (page 38)


CONFIDENTIAL:

The information contained in this email (including any attachments)
is confidential, subject to copyright and for the use of the
intended recipient only. If you are not the intended recipient
please delete this message after notifying the sender. Unauthorised
retention, alteration or distribution of this email is forbidden
and may be actionable.

Attachments are opened at your own risk and you are advised to scan
incoming email for viruses before opening any attached files. We
give no guarantee that any communication is virus-free and accept
no responsibility for virus contamination or other system loss or
damage of any kind.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Garry Gillies
  INET: [EMAIL PROTECTED]

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

[Yechiel Adar]

Have you tried to run sqlldr with BAD data?

Yechiel Adar
Mehish
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Thursday, October 02, 2003 4:44 PM


>
> Please give me an example on this.
>
>
> Roland
>
>
>
>
>
>
>   Jack van Zanen
>   <[EMAIL PROTECTED]To:   Multiple
recipients of list ORACLE-L <[EMAIL PROTECTED]>
>   S.NL>cc:
>   Sent by: Subject:  RE: logg error
line in unix
>   [EMAIL PROTECTED]
>   .com
>
>
>   2003-10-02 15:54
>   Please respond to
>   ORACLE-L
>
>
>
>
>
>
> Bad records go to bad file
> Logfile can be turned on with log parameter
>
> Jacob A. van Zanen
> Oracle DBA
> Quant Systems Europe b.v.
> Tel : +31 (0) 251 - 268 268
> Mobile: +31 (0) 6 51308813
> Fax: +31 (0) 251 - 268 269
> E-mail: mailto:[EMAIL PROTECTED]
> Visit our web site at http://www.quantsystems.nl/
>
>
>
> -Original Message-
> Sent: Thursday, October 02, 2003 3:35 PM
> To: Multiple recipients of list ORACLE-L
>
>
> Hallo again,
>
> I would like to get some help on this.
>  I have a script called let us say test.sh and that script runs an
sqlloader
> script, which loads semicolonseparated data into an oracle table. I would
> like to have an example on how to log an error when trying to insert the
> data intothe table. I want the error to be both the error message and also
> tell me which line that is wrong in the file.
>
> So both errormessage and also complete line which is the error line.
>
>
> Thanks in advance
>
>
> Roland
>
>
>
>
> --
> 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).
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Jack van Zanen
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (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).

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

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

[Jack van Zanen]

Sqlldr help=y from the command line.
or
D:\oracle\ora92\rdbms\demo
Lookup the ulcase*.ctl files

jack



-Original Message-
Sent: Thursday, October 02, 2003 4:45 PM
To: Multiple recipients of list ORACLE-L



Please give me an example on this.


Roland





 

  Jack van Zanen

  <[EMAIL PROTECTED]To:   Multiple recipients
of list ORACLE-L <[EMAIL PROTECTED]>   
  S.NL>cc:

  Sent by: Subject:  RE: logg error line
in unix   
  [EMAIL PROTECTED]

  .com

 

 

  2003-10-02 15:54

  Please respond to

  ORACLE-L

 

 





Bad records go to bad file
Logfile can be turned on with log parameter

Jacob A. van Zanen
Oracle DBA
Quant Systems Europe b.v.
Tel : +31 (0) 251 - 268 268
Mobile: +31 (0) 6 51308813
Fax: +31 (0) 251 - 268 269
E-mail: mailto:[EMAIL PROTECTED]
Visit our web site at http://www.quantsystems.nl/



-Original Message-
Sent: Thursday, October 02, 2003 3:35 PM
To: Multiple recipients of list ORACLE-L


Hallo again,

I would like to get some help on this.
 I have a script called let us say test.sh and that script runs an sqlloader
script, which loads semicolonseparated data into an oracle table. I would
like to have an example on how to log an error when trying to insert the
data intothe table. I want the error to be both the error message and also
tell me which line that is wrong in the file.

So both errormessage and also complete line which is the error line.


Thanks in advance


Roland




--
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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Jack van Zanen
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the
message BODY, include a line containing: UNSUB ORACLE-L (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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jack van Zanen
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Sql query : select max timestamp value from table

[Rothouse, Michael]

Title: Message



select 
ip, max(timestamp) from table
group 
by ip;

  
  -Original Message-From: Johan Muller 
  [mailto:[EMAIL PROTECTED] Sent: Thursday, October 02, 2003 10:45 
  AMTo: Multiple recipients of list ORACLE-LSubject: Sql 
  query : select max timestamp value from table
  I have multiple timestamps values  for single ip in a table, I need 
  the max(timestamp)  for each ip I select out. 
  example:
  timestamp  
  ip
  2003-09-29 13:20:23    68.209.182.42003-09-29 
  13:20:44    68.209.182.42003-10-02 
  12:53:38    68.209.182.42003-10-02 
  12:35:06    68.75.94.1582003-10-02 
  12:52:03    68.97.33.69
  Thus
  select distinct ip, max(timestamp) from table
  group by ip, timestamp;
   
  returns every timestamp value per ip.
  Any ideas on how to get only the max(timestamp) for each ip?
   

Trace File cursor waits

[Daniel Fink]

I have a logon trigger set up for a user. In examining the trace
file, I see the expected logon pl/sql action at the beginning
along with the normal NLS parm set ups.
The next action is a select with the usual
parse/bind/exec/wait/fetch/wait/stat emissions. After the stat
for Cursor #1, there are 264 waits in 132 pairs (1 for each
named cursor) of SQL*Net to/from.

The next activity is parsing of cursor #132, with the associated
activity (in fact, this cursor is reused quite heavily). Then
#127 is parsed and normal activity, then #128, then #17, etc.

I'm not quite certain how to intrepet this sequence of events in
the trace file. Any assistance is greatly appreciated.

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

RE: Oracle Client for Macintosh

[Jesse, Rich]

Erm, that's the Motorola 68K CPUs.  They are as dead as my beloved Amiga
(well almost: http://www.freiburg.linux.de/~uae/).  As far as Gx Apples,
I've been trying OTN, but all I get is "Error: Timeout occurred while
retrieving page meta data."   

Rich

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


-Original Message-
Sent: Thursday, October 02, 2003 10:00 AM
To: Multiple recipients of list ORACLE-L


MAC's are DEAD from Oracle's point of view.  See  Note:61797.1 

Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA 
-Original Message-
[mailto:[EMAIL PROTECTED]
Sent: Wednesday, October 01, 2003 11:24 PM
To: Multiple recipients of list ORACLE-L



I've searched TechNet and MetaLink but can't find a downloadable 8i, 9i,
anything Oracle Client for Apple Macintosh - OS 9 or OS X.  What am I
missing?  Is it not available?  Some docs on MetaLink mention it, but the
versions seem related to SQL*Net, not the RDBMS.  I'm clueless when it comes
to Macs, so I probably don't know the right keywords. 

Could someone point me in the right direction? 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jesse, Rich
  INET: [EMAIL PROTECTED]

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

RE: Sql query : select max timestamp value from table

[Melanie Caffrey]

Johann,

 

Take the timestamp out of your group by.

 

Cheers,

Melanie

 



***

Melanie Caffrey

Proximo Consulting
Services, Inc.

[EMAIL PROTECTED]

(212) 686-6004 Ext. 32



-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Johan
Muller
Sent: Thursday, October 02, 2003
10:45 AM
To: Multiple recipients of list
ORACLE-L
Subject: Sql query
: select max timestamp value from table

 

I have multiple timestamps values  for single ip
in a table, I need the max(timestamp)  for each ip I select out. 

example:

timestamp 
ip

2003-09-29 13:20:23    68.209.182.4
2003-09-29 13:20:44    68.209.182.4
2003-10-02 12:53:38    68.209.182.4
2003-10-02 12:35:06    68.75.94.158
2003-10-02 12:52:03    68.97.33.69

Thus

select distinct ip, max(timestamp) from table

group by ip, timestamp;

 

returns every timestamp value per ip.

Any ideas on how to get only the max(timestamp) for
each ip?

 

RE: Sql query : select max timestamp value from table

[Whittle Jerome Contr NCI]

Title: RE: Sql query : select max timestamp value from table







  select ip, max(timestamp) from table

  group by ip;


Jerry Whittle

ASIFICS DBA

NCI Information Systems Inc.

[EMAIL PROTECTED]

618-622-4145


-Original Message-

From:   Johan Muller [SMTP:[EMAIL PROTECTED]


I have multiple timestamps values  for single ip in a table, I need the max(timestamp)  for each ip I select out. 


example:


timestamp  ip


2003-09-29 13:20:23    68.209.182.4
2003-09-29 13:20:44    68.209.182.4
2003-10-02 12:53:38    68.209.182.4
2003-10-02 12:35:06    68.75.94.158
2003-10-02 12:52:03    68.97.33.69


Thus


select distinct ip, max(timestamp) from table

group by ip, timestamp;


returns every timestamp value per ip.


Any ideas on how to get only the max(timestamp) for each ip?

RE: Sql query : select max timestamp value from table

[Khedr, Waleed]

select ip, max(timestamp) from table
group by ip;

  -Original Message-From: Johan Muller 
  [mailto:[EMAIL PROTECTED]Sent: Thursday, October 02, 2003 10:45 
  AMTo: Multiple recipients of list ORACLE-LSubject: Sql 
  query : select max timestamp value from table
  I have multiple timestamps values  for single ip in a table, I need 
  the max(timestamp)  for each ip I select out. 
  example:
  timestamp  
  ip
  2003-09-29 13:20:23    68.209.182.42003-09-29 
  13:20:44    68.209.182.42003-10-02 
  12:53:38    68.209.182.42003-10-02 
  12:35:06    68.75.94.1582003-10-02 
  12:52:03    68.97.33.69
  Thus
  select distinct ip, max(timestamp) from table
  group by ip, timestamp;
   
  returns every timestamp value per ip.
  Any ideas on how to get only the max(timestamp) for each ip?
   

Re: Questiuon about unix

[Don Yu]

Try this as following:

cat yourfile | awk -F; ' ( $4 == "") { print $0 }'   # $4 means your field number from 
beginning; $0 means whole line.

Good luck!

Don


[EMAIL PROTECTED] wrote:

> Hallo everybody,
>
> anyone whom can tell me what the command  is to search for an empty field in a unix 
> file.
>
> for instance if you want to find the empty spacelines if some lines looklike:
>
> 1;100;Name;;
> 2;200;Test;45;
> 3;300;Name;;
>
> I would like to find out line nr 1 and 3 here above. Anyone whom could suggest any 
> good?
>
> Maybe this sounds simple but I have tried with /;; and cant find it. If iI use that 
> command then I will get lines with ;; and i just want lines with two ;;
>
> Thanks in advance
>
> Roland
>
> --
> 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).

-- 
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: Sql query : select max timestamp value from table

[Daniel Fink]

Johan,

First, you don't need the distinct. The proper query will return
1 row per ip.  Second, take the max(timestamp) out of the group
by. That is causing the problem.

Daniel

Johan Muller wrote:

> I have multiple timestamps values  for single ip in a table, I
> need the max(timestamp)  for each ip I select out.
>
> example:
>
> timestamp  ip
>
> 2003-09-29 13:20:2368.209.182.4
> 2003-09-29 13:20:4468.209.182.4
> 2003-10-02 12:53:3868.209.182.4
> 2003-10-02 12:35:0668.75.94.158
> 2003-10-02 12:52:0368.97.33.69
>
> Thus
>
> select distinct ip, max(timestamp) from table
>
> group by ip, timestamp;
>
>
>
> returns every timestamp value per ip.
>
> Any ideas on how to get only the max(timestamp) for each ip?
>
>
begin:vcard 
n:Fink;Daniel
x-mozilla-html:FALSE
org:Sun Microsystems, Inc.
adr:;;
version:2.1
title:Lead, Database Services
x-mozilla-cpt:;9168
fn:Daniel  W. Fink
end:vcard

RE: Oracle Client for Macintosh

[Goulet, Dick]

MAC's 
are DEAD from Oracle's point of view.  See  Note:61797.1 

 
Dick GouletSenior Oracle DBAOracle Certified 8i 
DBA 

  -Original Message-From: 
  [EMAIL PROTECTED] 
  [mailto:[EMAIL PROTECTED]Sent: Wednesday, October 
  01, 2003 11:24 PMTo: Multiple recipients of list 
  ORACLE-LSubject: Oracle Client for 
  MacintoshI've searched 
  TechNet and MetaLink but can't find a downloadable 8i, 9i, anything Oracle 
  Client for Apple Macintosh - OS 9 or OS X.  What am I missing?  Is 
  it not available?  Some docs on MetaLink mention it, but the versions 
  seem related to SQL*Net, not the RDBMS.  I'm clueless when it comes to 
  Macs, so I probably don't know the right keywords. Could someone point me in the right direction? 
  Thanks.Jack C. 
  ApplewhiteDatabase AdministratorAustin Independent School 
  DistrictAustin, Texas512.414.9715 (wk)512.935.5929 (pager, 
  [EMAIL PROTECTED])[EMAIL PROTECTED]

Oracle 9i Rac scripts

[Jack van Zanen]

Hi All

Since I'm new to 9iRAC (as are a lot of people I guess) I need some help.
I'm working my way through the (tuning) docs and have compiled this set of
sql's for monitoring the Cluster. Could the people that have experience with
the 9i RAC cluster look at it and tell me what is missing or what is
absolute garbage. 

TIA


Jack







9iRAC.sql
Description: Binary data