Re: OT: user CGI-BIN directories

[Peter . McLarty]

With Apache it is fairly easy but why you would do it is beyond me as they 
will then run anything in those directories and that is how you mess with 
a web server by allowing users to freely run cgi scripts. This is why most 
free websites don't give you access to CGI stuff or other server side 
capabilities. Most of there sites would have been hacked by now with this 
enabled.

You need to modify the a Location section

Read up the Apache doco on this as it will explain how a user can use this 
to create exploits on the server

Cheers


--
=
Peter McLarty   E-mail: [EMAIL PROTECTED]
Technical ConsultantWWW: http://www.mincom.com
APAC Technical Services Phone: +61 (0)7 3303 3461
Brisbane,  AustraliaMobile: +61 (0)402 094 238
Facsimile: +61 (0)7 3303 3048
=
A great pleasure in life is doing what people say you cannot do.

- Walter Bagehot (1826-1877 British Economist)
=
Mincom "The People, The Experience, The Vision"

=

This transmission is for the intended addressee only and is confidential 
information. If you have received this transmission in error, please 
delete it and notify the sender. The contents of this e-mail are the 
opinion of the writer only and are not endorsed by the Mincom Group of 
companies unless expressly stated otherwise. 






"Alroy Mascranghe" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
14-08-2002 05:13 PM
Please respond to ORACLE-L

 
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc: 
Fax to: 
Subject:OT:  user CGI-BIN directories


To execute the cgi scripts thru web/HTML forms we had to put them in the
common cgi-bin directory. But is there a way to have these scripts in a
user's home directory and still call them thru web/HTML forms?

TIA


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

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

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



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

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

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

startup shutdown steps

[kommareddy sreenivasa]

Hello All,

I am curious to know what are the executables that are
used when we say startup/shutdown of oracle database
on Sun box.

I think it is $ORACLE_HOME/bin/oracle

are there any other executables/kernel files
(important) in bin or in anyother areas.

Can somebody throw somelight ??/

Thanks in advance,
Srinivas

__
Do You Yahoo!?
HotJobs - Search Thousands of New Jobs
http://www.hotjobs.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: kommareddy sreenivasa
  INET: [EMAIL PROTECTED]

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

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

OT: user CGI-BIN directories

[Alroy Mascranghe]

To execute the cgi scripts thru web/HTML forms we had to put them in the
common cgi-bin directory. But is there a way to have these scripts in a
user's home directory and still call them thru web/HTML forms?

TIA


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

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

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

Context indexes

[kommareddy sreenivasa]

Hello All,

Can somebody help me in changing the parameters/re-org
of context indexes:

I have 10 context indexes in my database. I want 

1) to move these indexes to different tablespace
2) change storage clause 
3) Want to get the DDL for these indexes ( for
re-organization)


PS: I guess the move to new tablespace and storage
change can be done in single shot.(like normal
indexes) 

This is really urgent and needs to be done in
production by tomorrow.

Thanks in advance
Srinivas 
 


__
Do You Yahoo!?
HotJobs - Search Thousands of New Jobs
http://www.hotjobs.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: kommareddy sreenivasa
  INET: [EMAIL PROTECTED]

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

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

Multi-level passwords

[Manavendra Gupta]

Hi,

How do I implement multi-level passwords for access (connecting via Oracle
thin client for java, SQL*Plus) to Oracle?

With Warm Regards,
Manav.


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

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

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

RE: It took more than an hour to update 10,000 records

[Deshpande, Kirti]

Is the instance running in archive log mode? If so, Was the archiver stuck?
We run into similar 'slow' response issues once in a while, when the
automated archived log directory maintenance job falls behind the rate of
archive log generation. 

- Kirti  

-Original Message-
Sent: Tuesday, August 13, 2002 8:43 PM
To: Multiple recipients of list ORACLE-L


His problem is not reducing 60 sec to 20 seconds but why an hour or more was
taken to update 10,000 rows.

It's obvious there are other things (which I indicated in my email) that
need to be sorted out to reduce the hour to few minutes.

Regards,

Waleed
 
-Original Message-
Sent: Tuesday, August 13, 2002 9:08 PM
To: Multiple recipients of list ORACLE-L


David,

You don't yet know why it's slow.

Why not turn tracing on for the session doing the inserts and then
run tkprof on the trace file?

Since the inserts seem to be taking so long, you should also
be able to join v$session_wait with v$session to catch the
waits in action and determine exactly what they are.

You should also join v$session and v$session_event while
the insert job is running.

Actually, using bind variables will probably help.  The insert
statements will be less resource intensive and run much faster,
and this will result in less contention for other sessions.

My tests of insert statements with and without bind variables
show that using bind variables resulted in an insert job 
of 27k rows running in 15 seconds and < 1/100 sec of parse time.

Not using bind variables required 60 seconds, 20 of which were
CPU parse time. 

The increased run time also resulted in 3x as many buffer busy
waits for other sessions trying to hit the same table.

HTH

Jared








"Nguyen, David M" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
08/13/2002 01:34 PM
Please respond to ORACLE-L

 
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc: 
Subject:RE: It took more than an hour to update 10,000
records


Is there a parameter that I can tune in init.ora file to improve this
process?

Thanks,
David

-Original Message-
Sent: Tuesday, August 13, 2002 2:00 PM
To: Multiple recipients of list ORACLE-L


Bind variables will not buy you anything. The time taken is mainly 
dependent
on the execution plan and the cardinality of the indexes being used. Also
any overhead like updating a column that's part of an index, triggers,
referential constraints, etc.

Waleed 

-Original Message-
Sent: Tuesday, August 13, 2002 2:35 PM
To: Multiple recipients of list ORACLE-L


I run it on the server.  How do I use bind variables?

Thanks,
David

-Original Message-
Sent: Tuesday, August 13, 2002 1:13 PM
To: Multiple recipients of list ORACLE-L


>From the look of your sql statements it seems that each
statement will be hard parsed because the values are different.
If you will use bind variables you can save a lot of time.

Is the script runs on the server or from another computer?
If you run the script from another computer you also have the
network time added.

Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Sent: Tuesday, August 13, 2002 6:24 PM


> Hi all,
>
> I write a script to update 10,000 records in my database and noticed it
took
> more than an hour to update 10,000 records.  The script just includes
10,000
> SQL update commands as shown below.  Is the time too long to update 
10,000
> records?  Is it a way to improve the update task to run faster.  Please
> advise.
>
> *** A portion of my update script is shown below:
>
> update dbimpl.npa_nxx set ported_flag = 1 where nxx_id = 206 and npa_id 
=
> 201 and lata_id = 224;
>
> update dbimpl.npa_nxx set ported_flag = 1 where nxx_id = 207 and npa_id 
=
> 201 and lata_id = 224;
>
>
> Thanks,
> David
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Nguyen, David M
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).

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

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

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

RE: It took more than an hour to update 10,000 records

[Jacques Kilchoer]

Title: RE: It took more than an hour to update 10,000 records





Actually, since the statement that is slow is an update, I would suggest also sending the execution plan to the list for suggestions.

In SQL*Plus:
a) if necessary, create the plan_table using $ORACLE_HOME/rdbms/admin/utlxplan.sql
b) set autotrace traceonly statistics
c) type in update statement


> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> 
> You don't yet know why it's slow.
> 
> Why not turn tracing on for the session doing the inserts and then
> run tkprof on the trace file?
> 
> Since the inserts seem to be taking so long, you should also
> be able to join v$session_wait with v$session to catch the
> waits in action and determine exactly what they are.
> 
> You should also join v$session and v$session_event while
> the insert job is running.
> 
> Actually, using bind variables will probably help.  The insert
> statements will be less resource intensive and run much faster,
> and this will result in less contention for other sessions.
> 
> My tests of insert statements with and without bind variables
> show that using bind variables resulted in an insert job 
> of 27k rows running in 15 seconds and < 1/100 sec of parse time.
> 
> Not using bind variables required 60 seconds, 20 of which were
> CPU parse time. 
> 
> The increased run time also resulted in 3x as many buffer busy
> waits for other sessions trying to hit the same table.
> 
> --
> "Nguyen, David M" <[EMAIL PROTECTED]>
> - Original Message -
> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> Sent: Tuesday, August 13, 2002 6:24 PM
> 
> > I write a script to update 10,000 records in my database 
> and noticed it
> took
> > more than an hour to update 10,000 records.  The script 
> just includes
> 10,000
> > SQL update commands as shown below.  Is the time too long to update 
> 10,000
> > records?  Is it a way to improve the update task to run 
> faster.  Please
> > advise.
> >
> > *** A portion of my update script is shown below:
> >
> > update dbimpl.npa_nxx set ported_flag = 1 where nxx_id = 
> 206 and npa_id 
> =
> > 201 and lata_id = 224;
> >
> > update dbimpl.npa_nxx set ported_flag = 1 where nxx_id = 
> 207 and npa_id 
> =
> > 201 and lata_id = 224;

RE: Dba tools on NT

[Jacques Kilchoer]

Title: RE: Dba tools on NT





But... but... in my defense, can I point to the subject line of the request? "on NT"


> -Original Message-
> From: Ron Thomas [mailto:[EMAIL PROTECTED]]
> 
> >Actually I like this little text editor:
> >http://www.fixedsys.com/context/
> >One of its advantages is its syntax highlighting. And it's free!
> Disadvantage is it's windows only...

RE: It took more than an hour to update 10,000 records

[Khedr, Waleed]

His problem is not reducing 60 sec to 20 seconds but why an hour or more was
taken to update 10,000 rows.

It's obvious there are other things (which I indicated in my email) that
need to be sorted out to reduce the hour to few minutes.

Regards,

Waleed
 
-Original Message-
Sent: Tuesday, August 13, 2002 9:08 PM
To: Multiple recipients of list ORACLE-L


David,

You don't yet know why it's slow.

Why not turn tracing on for the session doing the inserts and then
run tkprof on the trace file?

Since the inserts seem to be taking so long, you should also
be able to join v$session_wait with v$session to catch the
waits in action and determine exactly what they are.

You should also join v$session and v$session_event while
the insert job is running.

Actually, using bind variables will probably help.  The insert
statements will be less resource intensive and run much faster,
and this will result in less contention for other sessions.

My tests of insert statements with and without bind variables
show that using bind variables resulted in an insert job 
of 27k rows running in 15 seconds and < 1/100 sec of parse time.

Not using bind variables required 60 seconds, 20 of which were
CPU parse time. 

The increased run time also resulted in 3x as many buffer busy
waits for other sessions trying to hit the same table.

HTH

Jared








"Nguyen, David M" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
08/13/2002 01:34 PM
Please respond to ORACLE-L

 
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc: 
Subject:RE: It took more than an hour to update 10,000
records


Is there a parameter that I can tune in init.ora file to improve this
process?

Thanks,
David

-Original Message-
Sent: Tuesday, August 13, 2002 2:00 PM
To: Multiple recipients of list ORACLE-L


Bind variables will not buy you anything. The time taken is mainly 
dependent
on the execution plan and the cardinality of the indexes being used. Also
any overhead like updating a column that's part of an index, triggers,
referential constraints, etc.

Waleed 

-Original Message-
Sent: Tuesday, August 13, 2002 2:35 PM
To: Multiple recipients of list ORACLE-L


I run it on the server.  How do I use bind variables?

Thanks,
David

-Original Message-
Sent: Tuesday, August 13, 2002 1:13 PM
To: Multiple recipients of list ORACLE-L


>From the look of your sql statements it seems that each
statement will be hard parsed because the values are different.
If you will use bind variables you can save a lot of time.

Is the script runs on the server or from another computer?
If you run the script from another computer you also have the
network time added.

Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Sent: Tuesday, August 13, 2002 6:24 PM


> Hi all,
>
> I write a script to update 10,000 records in my database and noticed it
took
> more than an hour to update 10,000 records.  The script just includes
10,000
> SQL update commands as shown below.  Is the time too long to update 
10,000
> records?  Is it a way to improve the update task to run faster.  Please
> advise.
>
> *** A portion of my update script is shown below:
>
> update dbimpl.npa_nxx set ported_flag = 1 where nxx_id = 206 and npa_id 
=
> 201 and lata_id = 224;
>
> update dbimpl.npa_nxx set ported_flag = 1 where nxx_id = 207 and npa_id 
=
> 201 and lata_id = 224;
>
>
> Thanks,
> David
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Nguyen, David M
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).

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

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

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

Fat City Network Services-- (858) 538-5051  FAX: (858) 5

RE: Dba tools on NT

[Jacques Kilchoer]

Title: RE: Dba tools on NT





Mr. Gupta is very wise. The Quest set of tools is the best.


> -Original Message-
> From: Manavendra Gupta [mailto:[EMAIL PROTECTED]]
> 
> Quest software (www.quest.com) provides a nice array of tools.

RE: c_USER#

[Jacques Kilchoer]

Title: RE: c_USER#





Good catch! I guess that might be another reason for heavy use of c_user#. If user X has a quota on tablespace Y, then anytime user X allocates/deallocates extents in tablespace Y, sys.tsq$ will be updated to reflect user X's usage in tablespace Y.

-Original Message-
From: Khedr, Waleed [mailto:[EMAIL PROTECTED]]
 
If the cluster contains also the current disk usage as part of table TSQ$ then this means that Oracle has to keep updating the cluster everytime a user adds or releases disk space, right?

 
-Original Message-
From: Jacques Kilchoer [mailto:[EMAIL PROTECTED]]


SYS.C_USER# is the name of the cluster that contains the USER$ table (list of usernames in the database) and the TSQ$ table (list of tablespace quotas for each user). ...

RE: It took more than an hour to update 10,000 records

[Jared . Still]

David,

You don't yet know why it's slow.

Why not turn tracing on for the session doing the inserts and then
run tkprof on the trace file?

Since the inserts seem to be taking so long, you should also
be able to join v$session_wait with v$session to catch the
waits in action and determine exactly what they are.

You should also join v$session and v$session_event while
the insert job is running.

Actually, using bind variables will probably help.  The insert
statements will be less resource intensive and run much faster,
and this will result in less contention for other sessions.

My tests of insert statements with and without bind variables
show that using bind variables resulted in an insert job 
of 27k rows running in 15 seconds and < 1/100 sec of parse time.

Not using bind variables required 60 seconds, 20 of which were
CPU parse time. 

The increased run time also resulted in 3x as many buffer busy
waits for other sessions trying to hit the same table.

HTH

Jared








"Nguyen, David M" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
08/13/2002 01:34 PM
Please respond to ORACLE-L

 
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc: 
Subject:RE: It took more than an hour to update 10,000 records


Is there a parameter that I can tune in init.ora file to improve this
process?

Thanks,
David

-Original Message-
Sent: Tuesday, August 13, 2002 2:00 PM
To: Multiple recipients of list ORACLE-L


Bind variables will not buy you anything. The time taken is mainly 
dependent
on the execution plan and the cardinality of the indexes being used. Also
any overhead like updating a column that's part of an index, triggers,
referential constraints, etc.

Waleed 

-Original Message-
Sent: Tuesday, August 13, 2002 2:35 PM
To: Multiple recipients of list ORACLE-L


I run it on the server.  How do I use bind variables?

Thanks,
David

-Original Message-
Sent: Tuesday, August 13, 2002 1:13 PM
To: Multiple recipients of list ORACLE-L


>From the look of your sql statements it seems that each
statement will be hard parsed because the values are different.
If you will use bind variables you can save a lot of time.

Is the script runs on the server or from another computer?
If you run the script from another computer you also have the
network time added.

Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Sent: Tuesday, August 13, 2002 6:24 PM


> Hi all,
>
> I write a script to update 10,000 records in my database and noticed it
took
> more than an hour to update 10,000 records.  The script just includes
10,000
> SQL update commands as shown below.  Is the time too long to update 
10,000
> records?  Is it a way to improve the update task to run faster.  Please
> advise.
>
> *** A portion of my update script is shown below:
>
> update dbimpl.npa_nxx set ported_flag = 1 where nxx_id = 206 and npa_id 
=
> 201 and lata_id = 224;
>
> update dbimpl.npa_nxx set ported_flag = 1 where nxx_id = 207 and npa_id 
=
> 201 and lata_id = 224;
>
>
> Thanks,
> David
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Nguyen, David M
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).

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

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

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

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

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

RE: Dba tools on NT

[Ron Thomas]

>Actually I like this little text editor:
>http://www.fixedsys.com/context/
>One of its advantages is its syntax highlighting. And it's free!
Disadvantage is it's windows only...

Ron Thomas
Hypercom, Inc
[EMAIL PROTECTED]
If A = B and B = C, then A = C, except where void or prohibited by law. -- Roy Santoro


   
 
  [EMAIL PROTECTED] 
 
   To:   [EMAIL PROTECTED]  
 
  08/13/02 05:08 PMcc: 
 
  Please respond toSubject:  RE: Dba tools on NT   
 
  ORACLE-L 
 
   
 
   
 




> -Original Message-
> [EMAIL PROTECTED]
>
> Scripting: Perl, because it can do anything you ask of it.
> Editor:  Vim - www.vim.org - same reason


Actually I like this little text editor:
http://www.fixedsys.com/context/
One of its advantages is its syntax highlighting. And it's free!







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

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

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

RE: c_USER#

[Khedr, Waleed]

Title: RE: c_USER#



Good 
point!
 
If the 
cluster contains also the current disk usage as part of table TSQ$ 
then this means that Oracle has to keep updating the cluster everytime a 
user adds or releases disk space, right?
 
 
Waleed 

  -Original Message-From: Jacques Kilchoer 
  [mailto:[EMAIL PROTECTED]]Sent: Tuesday, August 13, 2002 
  7:48 PMTo: Multiple recipients of list ORACLE-LSubject: 
  RE: c_USER#
  >-Original Message- >From: BigP [mailto:[EMAIL PROTECTED]] 
  > >I am finding SYS.C_USER# as 
  one of the hot blocks . > I dont find any 
  documentation about it , can somebody shed > some 
  light on it . why it is contention ? 
  SYS.C_USER# is the name of the cluster that contains the USER$ 
  table (list of usernames in the database) and the TSQ$ table (list of 
  tablespace quotas for each user). See below for information from the database 
  showing how those tables are related. Are you adding users / changing 
  tablespace quotas at an unusual rate?
  SQL> select owner, table_name from dba_tables 
    2  where cluster_owner = 'SYS' and cluster_name = 
  'C_USER#' ; 
  OWNER  
  TABLE_NAME -- 
  -- SYS    
  USER$ SYS    
  TSQ$ 
  SQL> set long 6000 SQL> select 
  view_name, text   2  from dba_views 
    3  where owner = 'SYS' and view_name in 
  ('DBA_USERS', 'DBA_TS_QUOTAS') ; 
  VIEW_NAME -- TEXT 
   
  DBA_TS_QUOTAS select ts.name, 
  u.name,    q.blocks 
  * ts.blocksize,    
  decode(q.maxblocks, -1, -1, q.maxblocks * ts.blocksize),    q.blocks, q.maxblocks 
  from sys.tsq$ q, sys.ts$ ts, sys.user$ u where q.ts# = ts.ts#   and q.user# = 
  u.user#   and q.maxblocks != 0 
  DBA_USERS select u.name, u.user#, 
  u.password,    
  m.status,    
  decode(u.astatus, 4, u.ltime,  
  5, u.ltime,  
  6, u.ltime,  
  8, u.ltime,  
  9, u.ltime,  
  10, u.ltime, to_date(NULL)),    decode(u.astatus,   
  1, u.exptime,   
  2, u.exptime,   
  5, u.exptime,   
  6, u.exptime,   
  9, u.exptime,   
  10, u.exptime,   
  decode(u.ptime, '', to_date(NULL),     
  decode(pr.limit#, 2147483647, to_date(NULL),  
  decode(pr.limit#, 0,    
  decode(dp.limit#, 2147483647, to_date(NULL), u.ptime +  
  dp.limit#/86400),    
  u.ptime + pr.limit#/86400,    dts.name, tts.name, u.ctime, 
  p.name, u.defschclass, u.ext_username    from sys.user$ u, sys.ts$ dts, 
  sys.ts$ tts, sys.profname$ p,     
  sys.user_astatus_map m, sys.profile$ pr, sys.profile$ dp    where u.datats# = dts.ts# 
     and u.resource$ = 
  p.profile#    and 
  u.tempts# = tts.ts#    and u.astatus = m.status# 
     and u.type# = 1 
     and u.resource$ = 
  pr.profile#    and 
  dp.profile# = 0    
  and dp.type#=1    
  and dp.resource#=1    and pr.type# = 1    and pr.resource# = 1 
  SQL> 

RE: Dba tools on NT

[Jacques Kilchoer]

Title: RE: Dba tools on NT





> -Original Message-
> [EMAIL PROTECTED]
> 
> Scripting: Perl, because it can do anything you ask of it.
> Editor:  Vim - www.vim.org - same reason


Actually I like this little text editor:
http://www.fixedsys.com/context/
One of its advantages is its syntax highlighting. And it's free!

RE: c_USER#

[Jacques Kilchoer]

Title: RE: c_USER#





>-Original Message-
>From: BigP [mailto:[EMAIL PROTECTED]]
>
>I am finding SYS.C_USER# as one of the hot blocks .
> I dont find any documentation about it , can somebody shed
> some light on it . why it is contention ?



SYS.C_USER# is the name of the cluster that contains the USER$ table (list of usernames in the database) and the TSQ$ table (list of tablespace quotas for each user). See below for information from the database showing how those tables are related. Are you adding users / changing tablespace quotas at an unusual rate?

SQL> select owner, table_name from dba_tables
  2  where cluster_owner = 'SYS' and cluster_name = 'C_USER#' ;


OWNER  TABLE_NAME
-- --
SYS    USER$
SYS    TSQ$


SQL> set long 6000
SQL> select view_name, text
  2  from dba_views
  3  where owner = 'SYS' and view_name in ('DBA_USERS', 'DBA_TS_QUOTAS') ;


VIEW_NAME
--
TEXT

DBA_TS_QUOTAS
select ts.name, u.name,
   q.blocks * ts.blocksize,
   decode(q.maxblocks, -1, -1, q.maxblocks * ts.blocksize),
   q.blocks, q.maxblocks
from sys.tsq$ q, sys.ts$ ts, sys.user$ u
where q.ts# = ts.ts#
  and q.user# = u.user#
  and q.maxblocks != 0


DBA_USERS
select u.name, u.user#, u.password,
   m.status,
   decode(u.astatus, 4, u.ltime,
 5, u.ltime,
 6, u.ltime,
 8, u.ltime,
 9, u.ltime,
 10, u.ltime, to_date(NULL)),
   decode(u.astatus,
  1, u.exptime,
  2, u.exptime,
  5, u.exptime,
  6, u.exptime,
  9, u.exptime,
  10, u.exptime,
  decode(u.ptime, '', to_date(NULL),
    decode(pr.limit#, 2147483647, to_date(NULL),
 decode(pr.limit#, 0,
   decode(dp.limit#, 2147483647, to_date(NULL), u.ptime +
 dp.limit#/86400),
   u.ptime + pr.limit#/86400,
   dts.name, tts.name, u.ctime, p.name, u.defschclass, u.ext_username
   from sys.user$ u, sys.ts$ dts, sys.ts$ tts, sys.profname$ p,
    sys.user_astatus_map m, sys.profile$ pr, sys.profile$ dp
   where u.datats# = dts.ts#
   and u.resource$ = p.profile#
   and u.tempts# = tts.ts#
   and u.astatus = m.status#
   and u.type# = 1
   and u.resource$ = pr.profile#
   and dp.profile# = 0
   and dp.type#=1
   and dp.resource#=1
   and pr.type# = 1
   and pr.resource# = 1


SQL> 

RE: 10046 trace restart?

[Cary Millsap]

Yes you can.


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

Upcoming events:
- Hotsos Clinic, Oct 1-3 San Francisco, Oct 15-17 Dallas, Dec 9-11
Honolulu
- 2003 Hotsos Symposium on OracleR System Performance, Feb 9-12 Dallas
- Next event: NCOAUG Training Day, Aug 16 Chicago



-Original Message-
Barbara
Sent: Tuesday, August 13, 2002 5:06 PM
To: Multiple recipients of list ORACLE-L


Can I stop and then restart a 10046 level 12 trace while the process is
continuing to run?

(After running for 1 hour, my dump file has reached it's limit, and I
haven't hit the bad code yet.  This version of OS/Oracle will not let me
set
dump file unlimited. It's a bug/feature.)

I'd like to just stop the trace, delete the dump file, and restart the
trace
without killing the job and starting over (thereby losing the hour of
processing I've already incurred.)

I started the trace in svrmgrl with 
oradebug setorapid 10
oradebug event 10046 trace name context forever, level 12

OpenVMS 7.2-1
Oracle 7.3.4.4
Thanks for any help.

Barb

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

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

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

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

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

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

Re:RE: Dba tools on NT

[dgoulet]

I'll agree with Jared.  Given any programming or scripting language and there's
some duhveloper out there who can make a completely obfuscated mess out of it. 
I was once told that it was impossible under Ada, boy did that ever get
retracted by the author in a hurry!!

Dick Goulet

Reply Separator
Author: "Grabowy; Chris" <[EMAIL PROTECTED]>
Date:   8/13/2002 2:06 PM

DOH  Ouch...(limping along)...come on now.  Perl has won "awards" for
it's "readability" and "maintainability".  I'm not slamming Perl, it has
saved my behind on W2K platforms, which has no real scripting language.  And
I did advance order a copy of your book.  Not that I want to be a
Duhveloper...



-Original Message-
Sent: Tuesday, August 13, 2002 4:42 PM
To: [EMAIL PROTECTED]
Cc: Grabowy, Chris


> And it's difficult to write, looks like scrambled eggs when your done, 
and
> impossible to maintain...

Of course, you can say this about any programming or scripting language.

It all depends on the ability of the programmer.

Jared






"Grabowy, Chris" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
08/13/2002 10:24 AM
Please respond to ORACLE-L

 
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc: 
Subject:RE: Dba tools on NT


And it's difficult to write, looks like scrambled eggs when your done, and
impossible to maintain...

On the other hand, you could write the entire Windows XP operating system 
in
one line of Perl...including Internet Explorer.

-Original Message-
Sent: Tuesday, August 13, 2002 12:49 PM
To: Multiple recipients of list ORACLE-L


Without a doubt - perl - get it free from www.activestate.com. Why use it?
Well, it is so flexible compared to other NT/DOS scripting tools you'll
wonder why you never had it before! It's also portable meaning all those
scripts you write should work on multi platforms with just a little tweak!

Lewis Bishop
---
Barclays Enable/ISS/OPTS - Oracle OCP Database Consultant
Phone - 020 8298 3418
Mobile - 07950 380857
Email - [EMAIL PROTECTED]


-Original Message-
Sent: 13 August 2002 17:25
To: Multiple recipients of list ORACLE-L

This header confirms that this email message has been swept for the
presence of computer viruses. 

Corporate IT
THE WOOLWICH
--

Hello all

We are looking on programming and scripting tools
 for DBA team on NT.

Can you, oracle DBA's on NT, tell me off the list 
what tools you are using for these functions 
and, if you be so kind, why you choose them.

TIA

Yechiel Adar
Mehish

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

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

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


The information, attachments and opinions contained in this message are
those of its author only and do not necessarily represent those of The
Woolwich and or any other members of the Barclays Group and are intended
solely for the use of the individual or entity to whom they are addressed.
The sender may not be authorised to give financial advice, and nothing in
this message should be construed as offering such advice.

The message may contain privileged and confidential information and you 
may
not copy, distribute or take any action in reliance on it. If you have
received this email in error please notify the Information Security 
Manager
at [EMAIL PROTECTED]

Replies to this email may be monitored for operational or business 
reasons.

Woolwich plc. Registered in England Number : 3295699.

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

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

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

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

RE: Apple rack-mounted servers

[Scott . Shafer]

Cool.  Sound like it may be worth checking out, at least for home use.

Scott Shafer
San Antonio, TX
210-581-6217


> -Original Message-
> From: Jacques Kilchoer [SMTP:[EMAIL PROTECTED]]
> Sent: Tuesday, August 13, 2002 5:06 PM
> To:   Multiple recipients of list ORACLE-L
> Subject:  RE: Apple rack-mounted servers
> 
> From my Mac OS X Advanced Quickpro guide: it's a combination of the Mach
> kernel and FreeBSD. 
> 
> > -Original Message- 
> > From: [EMAIL PROTECTED] 
> > 
> > mach kernel, IIRC.  The old NeXTStep unix. 
> > 
> > 
> > > -Original Message- 
> > > From:   Grabowy, Chris [SMTP:[EMAIL PROTECTED]] 
> > > 
> > > It is based on some *NIX variant...was it FreeBSD? 
> 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

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

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

nextval increments by 2 in pl/sql procedure

[Danny Hughes]

hello all, 

I have a pl/sql procedure that selects the nextval from a sequence.  The problem is 
that it incrrements the sequence by 2 in a pl/sql procedure.  If I select the nextval 
from a sqlplus session, it works fine.

here is partial code that I am using.

PROCEDURE NEWTRANSACTION (v_storyid IN story.story_id%type,
v_transid OUT 
story_transaction.trans_id%type ) IS

BEGIN
  select story_transaction_seq.nextval into v_transid from dual;
.
END

for debugging purposes, I made that code look like...

PROCEDURE NEWTRANSACTION (v_storyid IN story.story_id%type,
v_transid OUT 
story_transaction.trans_id%type ) IS

v_value1 NUMBER; --debug code
v_value2 NUMBER; --debug code

BEGIN
  select story_transaction_seq.currval into v_value1 from dual; --debug code
  select story_transaction_seq.nextval into v_transid from dual;
  select story_transaction_seq.currval into v_value2 from dual; --debug code

.
END


when I ran this, v_value1 had a 200, v_transid had a 201, and v_value2 had a 202

taking the debug code out and hitting that procedure with a web page will increment 
the v_transid by 2 each refresh of the page.

am i doing something wrong?  I can't find any information on the web related to this 
issue.

TIA


Danny Hughes
DBA
Knobias.com
601-978-3399 x103
[EMAIL PROTECTED]
www.knobias.com

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

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

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

RE: Dba tools on NT

[Grabowy, Chris]

DOH  Ouch...(limping along)...come on now.  Perl has won "awards" for
it's "readability" and "maintainability".  I'm not slamming Perl, it has
saved my behind on W2K platforms, which has no real scripting language.  And
I did advance order a copy of your book.  Not that I want to be a
Duhveloper...



-Original Message-
Sent: Tuesday, August 13, 2002 4:42 PM
To: [EMAIL PROTECTED]
Cc: Grabowy, Chris


> And it's difficult to write, looks like scrambled eggs when your done, 
and
> impossible to maintain...

Of course, you can say this about any programming or scripting language.

It all depends on the ability of the programmer.

Jared






"Grabowy, Chris" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
08/13/2002 10:24 AM
Please respond to ORACLE-L

 
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc: 
Subject:RE: Dba tools on NT


And it's difficult to write, looks like scrambled eggs when your done, and
impossible to maintain...

On the other hand, you could write the entire Windows XP operating system 
in
one line of Perl...including Internet Explorer.

-Original Message-
Sent: Tuesday, August 13, 2002 12:49 PM
To: Multiple recipients of list ORACLE-L


Without a doubt - perl - get it free from www.activestate.com. Why use it?
Well, it is so flexible compared to other NT/DOS scripting tools you'll
wonder why you never had it before! It's also portable meaning all those
scripts you write should work on multi platforms with just a little tweak!

Lewis Bishop
---
Barclays Enable/ISS/OPTS - Oracle OCP Database Consultant
Phone - 020 8298 3418
Mobile - 07950 380857
Email - [EMAIL PROTECTED]


-Original Message-
Sent: 13 August 2002 17:25
To: Multiple recipients of list ORACLE-L

This header confirms that this email message has been swept for the
presence of computer viruses. 

Corporate IT
THE WOOLWICH
--

Hello all

We are looking on programming and scripting tools
 for DBA team on NT.

Can you, oracle DBA's on NT, tell me off the list 
what tools you are using for these functions 
and, if you be so kind, why you choose them.

TIA

Yechiel Adar
Mehish

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

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

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


The information, attachments and opinions contained in this message are
those of its author only and do not necessarily represent those of The
Woolwich and or any other members of the Barclays Group and are intended
solely for the use of the individual or entity to whom they are addressed.
The sender may not be authorised to give financial advice, and nothing in
this message should be construed as offering such advice.

The message may contain privileged and confidential information and you 
may
not copy, distribute or take any action in reliance on it. If you have
received this email in error please notify the Information Security 
Manager
at [EMAIL PROTECTED]

Replies to this email may be monitored for operational or business 
reasons.

Woolwich plc. Registered in England Number : 3295699.

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

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

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

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

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

Re: SAN

[Babu . Nagarajan]

But inside a Oracle datafile a table may not lie in contigious blocks. so I
you are doing a full table scan 2 extents can lie next to each other than
then the remaining 2 can sit at the end of the datafile. Will the
non-Oracle process be able to decipher this and do a read ahead of those
two extents? Probably not...

Babu




Yechiel Adar <[EMAIL PROTECTED]>@fatcity.com on 08/13/2002 01:50:15 PM

Please respond to [EMAIL PROTECTED]

Sent by:[EMAIL PROTECTED]


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



You wrote:
>
> Will the "smarter algorithm" look inside the contents of a file before
> reading it? If it does not, then how will it be able to "intelligently"
> read ahead what data Oracle wants from inside its datafile? If it does,
how
> does it decipher the Oracle's way of storage?
>

How about using a variation of the algorithm ADABAS (database) is using for
sequential user reads:
1) Return the block requested.
2) If the next block is requested in a short period read the next 5 blocks
to the
controller cache.
3) If those are read in order and request come for the next block read each
time 10 blocks.

This is just from the top of my head but will assist greatly for full
table scan of big tables. Also remember that in Oracle before 9i blocks
used in FTS are put at the end of lru so are great candidates to be
overwritten
and you will read them again and again.

Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Sent: Tuesday, August 13, 2002 5:30 PM


>
> Tim, Jared and Kirti
>
> Jared, Kirti : Thanks a lot for your input. and yes, I read the Sane SAN
> paper.
>
> Tim : Many thanks to you for pointing out some of the big
"mis"assumptions
> I had made.  I have corrected most of the stuff you had mentioned except
> for these
>
> >.* I'm less clear on whether SANs themselves perform read-ahead and
> the
> > conditions under which they do so.  I'm pretty sure that they are
smarter
> > about it than what you describe;  usually read-ahead mechanisms are
> > triggered by detected patterns of usage, not algorithms as simple as
> > described...
>
> Will the "smarter algorithm" look inside the contents of a file before
> reading it? If it does not, then how will it be able to "intelligently"
> read ahead what data Oracle wants from inside its datafile? If it does,
how
> does it decipher the Oracle's way of storage?
>
> > * your example about "read-ahead" conflicts makes some invalid
> > assumptions, namely about space being allocated in blocks not extents
> (when
> > does *that* ever happen?) and about "read-ahead being set to 3 blocks"
> > (again, when does *that* ever happen?).
>
> It does not happen. However I am going to be talking to a bunch of
> non-Oracle folks and management so I want to keep it as simple as
possible.
>
> > Altogether, empirical evidence (i.e. many successful SAN
implementations
> > under Oracle over several years) does not lend credence to your basic
> > assertion that "SAN and Oracle don't go well together".  It is a fact
> that
> > they do...
>
> I am not trying to make a statement "SAN and Oracle dont go well
together".
> I am trying to convince my management that buying a SAN does not mean
that
> we never need to worry about IO any more. Even a SAN needs to be
> configured. Currently they are under the impression that there are no IO
> problems but my database IO waits are 50% of the total response time. All
> my index, table data are scattered all over the disks -  many on the same
> disk and the answer I get is "No, we are not tasking the SAN at all.
There
> are no IO issues"
>
>
> Thanks a lot
>
> Babu
>
>
>
>
>
> Tim Gorman <[EMAIL PROTECTED]>@fatcity.com on 08/13/2002 07:58:29 AM
>
> Please respond to [EMAIL PROTECTED]
>
> Sent by:[EMAIL PROTECTED]
>
>
> To:Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> cc:
>
>
>
> Babu,
>
> Is it possible that you are confusing the term "SAN" with the term "NAS"?
> As I read through your email, I couldn't help thinking that you
discussing
> "network-attached storage" rather than "storage-area networks".  If so,
> some
> of my comments below might change slightly, but not much...
>
> ---
>
> Most of your major assumptions are correct, but there are important
> errors...
>
> * DBWR only does RW, never RR or SR.  Mostly Oracle server processes
do
> RR and SR, but ARCH also does SR, as do backup processes (whatever they
> are);  everyone always forgets to add backup processes to the mix...
>
> * SW is characteristic of LGWR and ARCH, but also of processes
> performing sorting (i.e. "direct writes" wait-event).  I think you'll
agree
> that databases generating a lot of redo (and archived redo) and
performing
> lots of sorting are not necessarily "misconfigured".  The amount of redo
> generated is really a characteristic of the application itself, not the
> database configuration.  High amounts of sorting can possibly be tu

10046 trace restart?

[Baker, Barbara]

Can I stop and then restart a 10046 level 12 trace while the process is
continuing to run?

(After running for 1 hour, my dump file has reached it's limit, and I
haven't hit the bad code yet.  This version of OS/Oracle will not let me set
dump file unlimited. It's a bug/feature.)

I'd like to just stop the trace, delete the dump file, and restart the trace
without killing the job and starting over (thereby losing the hour of
processing I've already incurred.)

I started the trace in svrmgrl with 
oradebug setorapid 10
oradebug event 10046 trace name context forever, level 12

OpenVMS 7.2-1
Oracle 7.3.4.4
Thanks for any help.

Barb

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

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

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

RE: Apple rack-mounted servers

[Jacques Kilchoer]

Title: RE: Apple rack-mounted servers





From my Mac OS X Advanced Quickpro guide: it's a combination of the Mach kernel and FreeBSD.


> -Original Message-
> From: [EMAIL PROTECTED]
> 
> mach kernel, IIRC.  The old NeXTStep unix.
> 
> 
> > -Original Message-
> > From:   Grabowy, Chris [SMTP:[EMAIL PROTECTED]]
> > 
> > It is based on some *NIX variant...was it FreeBSD?

Re: Index - To use OR Not ?

[Greg Moore]

Title: process size limitation on HP-UX



>> Qs. How is the Number of Block Visitations to be 
Found for Both the Index Scan & Full Table Scan ?
 
You 
could use Autotrace.  That will show blocks read, indicating logical and 
physical reads.  You could also use TKPROF.

  - Original Message - 
  From: 
  VIVEK_SHARMA 
  To: Multiple recipients of list ORACLE-L 
  Sent: Tuesday, August 13, 2002 6:33 
  AM
  Subject: Index - To use OR Not ?
  
  Gaja 
  Wrote in his Book 101 Performance Tuning
   
  "When Running an SQL Query Avoid using Indexes 
  when an index scan performs More Block Visitations Than a Full Table 
  Scan"
   
  Qs. How is the Number of Block Visitations to 
  be Found for Both the Index Scan & Full Table Scan ?
   
   

RE: Dba tools on NT

[Jared . Still]

> And it's difficult to write, looks like scrambled eggs when your done, 
and
> impossible to maintain...

Of course, you can say this about any programming or scripting language.

It all depends on the ability of the programmer.

Jared






"Grabowy, Chris" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
08/13/2002 10:24 AM
Please respond to ORACLE-L

 
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc: 
Subject:RE: Dba tools on NT


And it's difficult to write, looks like scrambled eggs when your done, and
impossible to maintain...

On the other hand, you could write the entire Windows XP operating system 
in
one line of Perl...including Internet Explorer.

-Original Message-
Sent: Tuesday, August 13, 2002 12:49 PM
To: Multiple recipients of list ORACLE-L


Without a doubt - perl - get it free from www.activestate.com. Why use it?
Well, it is so flexible compared to other NT/DOS scripting tools you'll
wonder why you never had it before! It's also portable meaning all those
scripts you write should work on multi platforms with just a little tweak!

Lewis Bishop
---
Barclays Enable/ISS/OPTS - Oracle OCP Database Consultant
Phone - 020 8298 3418
Mobile - 07950 380857
Email - [EMAIL PROTECTED]


-Original Message-
Sent: 13 August 2002 17:25
To: Multiple recipients of list ORACLE-L

This header confirms that this email message has been swept for the
presence of computer viruses. 

Corporate IT
THE WOOLWICH
--

Hello all

We are looking on programming and scripting tools
 for DBA team on NT.

Can you, oracle DBA's on NT, tell me off the list 
what tools you are using for these functions 
and, if you be so kind, why you choose them.

TIA

Yechiel Adar
Mehish

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

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

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


The information, attachments and opinions contained in this message are
those of its author only and do not necessarily represent those of The
Woolwich and or any other members of the Barclays Group and are intended
solely for the use of the individual or entity to whom they are addressed.
The sender may not be authorised to give financial advice, and nothing in
this message should be construed as offering such advice.

The message may contain privileged and confidential information and you 
may
not copy, distribute or take any action in reliance on it. If you have
received this email in error please notify the Information Security 
Manager
at [EMAIL PROTECTED]

Replies to this email may be monitored for operational or business 
reasons.

Woolwich plc. Registered in England Number : 3295699.

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

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

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

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

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



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

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

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

RE: Error while invoking Email from PL/SQL

[Rodrigues, Bryan]

K.

Do you have java virtual machine installed? The package in the error it is
looking for dbms_java is created during the initjvm.sql script. It looks
like either jvm is not installed or failed during the install.

Bryan

-Original Message-
Sent: Monday, August 12, 2002 12:13 PM
To: Multiple recipients of list ORACLE-L


Hi All,

I am trying to send an Email using PL/SQL. (Oracle 8.1.7 and Solaris 5.8).

I tried to run the initplsj.sql and got the following error.

Can you guys tell me what should I do to correct this? 


SQL> @initplsj.sql
call dbms_java.set_output(1)
   *
ERROR at line 1:
ORA-06576: not a valid function or procedure name


call dbms_java.loadjava('-resolve plsql/jlib/plsql.jar')
   *
ERROR at line 1:
ORA-06576: not a valid function or procedure name
 

And then I tried to run 
loadjava -user sys/*** plsql.jar, again to no avail

Thanks in advance

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

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

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

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

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

RE: OPS 7.3.4 - how to ?

[Baker, Barbara]

We have been successfully running 7.3.4 OPS for some time.
It's been a rock-solid version for us.
The only extra script we ran was ora_rdbms:catparr.sql

(We're on Alpha/OpenVMS )

Good luck!
Barb


> > -Original Message-
> > Sent: Monday, August 12, 2002 1:08 PM
> > To: Multiple recipients of list ORACLE-L
> >
> > Dear gurus !
> > I have to create an OPS 7.3.4 database (yes, there are still Oracle7
> > installations out there).
> > Actually we are migrating our current OPS DB to another storage (EMC).
> > So , the software is installed , i just need to create the DB.
> > I can not find which scripts to run after the "create database" (i.e.
> > catproc.sql , catexp.sql).
> > Does anyone have a list of such scripts to run for OPS , please?
> > Also , are there any known gotchas for OPS 7.3.4 setup ? I plan to
> export
> > the exisiting DB, to create the new DB (with the same name of the DB and
> the
> > instances as the original ones) and then to import.
> > Is it OK ?
> >
> > TIA.
> >
> > DBAndrey
> >
> > * 03-9254520
> > * 058-548133
> > * mailto:[EMAIL PROTECTED]
> >
> >
> >
> >
> > --
> 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Baker, Barbara
  INET: [EMAIL PROTECTED]

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

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

RE: Urgent : UTL file problem

[Lord, David - CSG]

Rings a bell.  Is the directory/file writable by the ORACLE user?

--
David Lord

> -Original Message-
> From: Vijaya Chander V.S [mailto:[EMAIL PROTECTED]]
> Sent: 21 June 2002 12:58
> To: Multiple recipients of list ORACLE-L
> Subject: Urgent : UTL file problem
> 
> 
> my prog looks like this (utl_file_dir=* is present in 
> initSID.ora file):
> 
> DECLARE
> fileHandler UTL_FILE.FILE_TYPE;
> BEGIN
> dbms_output.put_line('1');
> fileHandler := UTL_FILE.FOPEN('/users/vijay', 
> 'myoutput.lst', 'W');
> dbms_output.put_line('2');
> UTL_FILE.PUTF(fileHandler, 'hai vijay \n');
> UTL_FILE.FCLOSE(fileHandler);
> EXCEPTION
> WHEN utl_file.invalid_path THEN
> raise_application_error(-2, 'ERROR: Invalid path 
> for file.');
> END;
> 
> and when i am running this script i am getting a message like this:
> 
> 1
> DECLARE
> *
> ERROR at line 1:
> ORA-06510: PL/SQL: unhandled user-defined exception
> ORA-06512: at "SYS.UTL_FILE", line 101
> ORA-06512: at "SYS.UTL_FILE", line 157
> ORA-06512: at line 5
> 
> what can be the problem...
> 
> regards,
> vijay
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Vijaya Chander V.S
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> 


**
This message (including any attachments) is confidential and may be 
legally privileged.  If you are not the intended recipient, you should 
not disclose, copy or use any part of it - please delete all copies 
immediately and notify the Hays Group Email Helpdesk at
[EMAIL PROTECTED]
Any information, statements or opinions contained in this message
(including any attachments) are given by the author.  They are not 
given on behalf of Hays unless subsequently confirmed by an individual
other than the author who is duly authorised to represent Hays.
 
A member of the Hays plc group of companies.
Hays plc is registered in England and Wales number 2150950.
Registered Office Hays House Millmead Guildford Surrey GU2 4HJ.
**

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

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

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

RE: BHR 100% -- we're perfect!

[Fink, Dan]

100%? Not good enough. Management won't be satisfied until the BCHR is
giving 115% like the rest of us!

-Original Message-
Sent: Tuesday, August 13, 2002 11:05 AM
To: Multiple recipients of list ORACLE-L



> Look.  Our buffer hit ratio is 100%!
> 
> DATE: August 13, 2002  Buffer Cache Ratio for  AMDEV
> 
>LOGICAL_READS PHYSICAL_READS  HIT_RATIO
>  -- --
>1,919,442,737564,223100
> 
> ('course, the fact that a single sql statement did nearly 2 billion
> logical reads isn't important.  What's important is that it did it all
> from memory!!!)
> 
>From Tim Gorman's TOP_STMT:

Date: 08/13/02 08:48:24Page1
Database startup: 08/07/02 23:52:23
First load time:  2002-08-12/16:53:15
.
SQL Statement Text
--
0 SELECT /*+ INDEX(CDT PK_CDT) */  ROWID,CDT_KEY,REC_TYPE,CATEGORY
1 ,NEW_CATEGORY,LST_TRANS,OPEN_BF,CUST_TELE_AREA,CUST_TELE_EXCHANG
2 E,CUST_TELE_LOCAL,CUST_TELE_EXT,RISK_CODE,DUNN_BRAD_RATING,BILL_
...

: Disk Buffer  Load
: Reads  Gets SortsRuns Loads
Factor
: --- - -
--
:   164,600 1,901,376,073 0 103,929 2
1917836.1
: (29.174%) (99.722%)

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

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

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

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

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

Re: It took more than an hour to update 10,000 records

[Igor Neyman]

I knew, it'll come down to this:

run_sql_faster = true :-)

Igor Neyman, OCP DBA
[EMAIL PROTECTED]



- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Tuesday, August 13, 2002 4:34 PM


> Is there a parameter that I can tune in init.ora file to improve this
> process?
>
> Thanks,
> David
>
> -Original Message-
> Sent: Tuesday, August 13, 2002 2:00 PM
> To: Multiple recipients of list ORACLE-L
>
>
> Bind variables will not buy you anything. The time taken is mainly
dependent
> on the execution plan and the cardinality of the indexes being used. Also
> any overhead like updating a column that's part of an index, triggers,
> referential constraints, etc.
>
> Waleed
>
> -Original Message-
> Sent: Tuesday, August 13, 2002 2:35 PM
> To: Multiple recipients of list ORACLE-L
>
>
> I run it on the server.  How do I use bind variables?
>
> Thanks,
> David
>
> -Original Message-
> Sent: Tuesday, August 13, 2002 1:13 PM
> To: Multiple recipients of list ORACLE-L
>
>
> From the look of your sql statements it seems that each
> statement will be hard parsed because the values are different.
> If you will use bind variables you can save a lot of time.
>
> Is the script runs on the server or from another computer?
> If you run the script from another computer you also have the
> network time added.
>
> Yechiel Adar
> Mehish
> - Original Message -
> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> Sent: Tuesday, August 13, 2002 6:24 PM
>
>
> > Hi all,
> >
> > I write a script to update 10,000 records in my database and noticed it
> took
> > more than an hour to update 10,000 records.  The script just includes
> 10,000
> > SQL update commands as shown below.  Is the time too long to update
10,000
> > records?  Is it a way to improve the update task to run faster.  Please
> > advise.
> >
> > *** A portion of my update script is shown below:
> >
> > update dbimpl.npa_nxx set ported_flag = 1 where nxx_id = 206 and npa_id
=
> > 201 and lata_id = 224;
> >
> > update dbimpl.npa_nxx set ported_flag = 1 where nxx_id = 207 and npa_id
=
> > 201 and lata_id = 224;
> >
> >
> > Thanks,
> > David
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: Nguyen, David M
> >   INET: [EMAIL PROTECTED]
> >
> > Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> > San Diego, California-- Public Internet access / Mailing Lists
> > 
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from).  You may
> > also send the HELP command for other information (like subscribing).
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Yechiel Adar
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Nguyen, David M
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Khedr, Waleed
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> --
> Please see the official ORACLE-L FAQ: http://www.

RE: Dba tools on NT

[Cary Millsap]

Amen.


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

Upcoming events:
- Hotsos Clinic, Oct 1-3 San Francisco, Oct 15-17 Dallas, Dec 9-11
Honolulu
- 2003 Hotsos Symposium on OracleR System Performance, Feb 9-12 Dallas
- Next event: NCOAUG Training Day, Aug 16 Chicago



-Original Message-
[EMAIL PROTECTED]
Sent: Tuesday, August 13, 2002 1:50 PM
To: Multiple recipients of list ORACLE-L

Scripting: Perl, because it can do anything you ask of it.
Editor:  Vim - www.vim.org - same reason

Jared






"Yechiel Adar" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
08/13/2002 09:24 AM
Please respond to ORACLE-L

 
To: Multiple recipients of list ORACLE-L
<[EMAIL PROTECTED]>
cc: 
Subject:Dba tools on NT


Hello all

We are looking on programming and scripting tools
 for DBA team on NT.

Can you, oracle DBA's on NT, tell me off the list 
what tools you are using for these functions 
and, if you be so kind, why you choose them.

TIA

Yechiel Adar
Mehish

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

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

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



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

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

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

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

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

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

How To grant execute to user on DBMS_LOGMNR package

[johanna . doran]

Hi,
 
    I 
would like to grant the ability to a user to run logminer.  I tried 
granting execute on both dbms_logmnr and dbms_logmnr_d to the user to no 
avail.  SQLPlus still requests for it to be declared (Ie. its not seeing 
it). I have even tried qualifying the package Ie. sys.dbms_logmnr when trying to 
execute?
 
    
All the documentation I see and all things on the net all run it as SYS.  
Any suggestions?
 
Thanks,
    

    
Hannah

Oracle9i DB Release 9.2.0.1.0

[KENNETH JANUSZ]

I just received my CD pack for 9.2.  There are some CD's 
in the pack for Oracle Pure Name & Address - North America, North America - 
Geocode, Latin America, etc.  Any idea what these are used for?  I 
didn't get these with my 9.1 release.
 
Thanks,
Ken Janusz, CPIM

RE: It took more than an hour to update 10,000 records

[Nguyen, David M]

Is there a parameter that I can tune in init.ora file to improve this
process?

Thanks,
David

-Original Message-
Sent: Tuesday, August 13, 2002 2:00 PM
To: Multiple recipients of list ORACLE-L


Bind variables will not buy you anything. The time taken is mainly dependent
on the execution plan and the cardinality of the indexes being used. Also
any overhead like updating a column that's part of an index, triggers,
referential constraints, etc.

Waleed 

-Original Message-
Sent: Tuesday, August 13, 2002 2:35 PM
To: Multiple recipients of list ORACLE-L


I run it on the server.  How do I use bind variables?

Thanks,
David

-Original Message-
Sent: Tuesday, August 13, 2002 1:13 PM
To: Multiple recipients of list ORACLE-L


>From the look of your sql statements it seems that each
statement will be hard parsed because the values are different.
If you will use bind variables you can save a lot of time.

Is the script runs on the server or from another computer?
If you run the script from another computer you also have the
network time added.

Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Sent: Tuesday, August 13, 2002 6:24 PM


> Hi all,
>
> I write a script to update 10,000 records in my database and noticed it
took
> more than an hour to update 10,000 records.  The script just includes
10,000
> SQL update commands as shown below.  Is the time too long to update 10,000
> records?  Is it a way to improve the update task to run faster.  Please
> advise.
>
> *** A portion of my update script is shown below:
>
> update dbimpl.npa_nxx set ported_flag = 1 where nxx_id = 206 and npa_id =
> 201 and lata_id = 224;
>
> update dbimpl.npa_nxx set ported_flag = 1 where nxx_id = 207 and npa_id =
> 201 and lata_id = 224;
>
>
> Thanks,
> David
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Nguyen, David M
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).

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

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

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

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

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

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

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

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

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

RE: Apple rack-mounted servers

[Scott . Shafer]

mach kernel, IIRC.  The old NeXTStep unix.

Scott Shafer
San Antonio, TX
210-581-6217


> -Original Message-
> From: Grabowy, Chris [SMTP:[EMAIL PROTECTED]]
> Sent: Tuesday, August 13, 2002 1:13 PM
> To:   Multiple recipients of list ORACLE-L
> Subject:  RE: Apple rack-mounted servers
> 
> It is based on some *NIX variant...was it FreeBSD?
> 
> -Original Message-
> Sent: Tuesday, August 13, 2002 1:45 PM
> To: Multiple recipients of list ORACLE-L
> 
> 
> No longer OT!  Oracle says 9I will run on Apple's new servers?
> 
> http://www.apple.com/xserve/reaction.html
> 
> Regards,
> Patrice Boivin
> Systems Analyst (Oracle Certified DBA)
> 
> Systems Admin & Operations | Admin. et Exploit. des systèmes
> Technology Services| Services technologiques
> Informatics Branch | Direction de l'informatique 
> Maritimes Region, DFO  | Région des Maritimes, MPO
> 
> E-Mail: [EMAIL PROTECTED]
> 
> 
>  -Original Message-
> Sent: Tuesday, August 13, 2002 12:45 PM
> To:   '[EMAIL PROTECTED]'
> Subject:  OT:  Apple rack-mounted servers
> 
> My brother just sent me this link...
> 
> http://www.apple.com/xserve/
> 
> Regards,
> Patrice Boivin
> Systems Analyst (Oracle Certified DBA)
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Boivin, Patrice J
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Grabowy, Chris
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
  INET: [EMAIL PROTECTED]

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

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

RE: Apple rack-mounted servers

[Ji, Richard]

When Larry tried the Network Computer concept again a couple of years
ago, they switched to Linux, StarOffice etc instead of the FreeBSD, NetBSD,
Oracle's own HatTrick Office Suite.

Richard

-Original Message-
Sent: Tuesday, August 13, 2002 3:44 PM
To: Multiple recipients of list ORACLE-L


First?  Are you implying the next generation will be something else?  Just
curious.  I believe Apple's decision to go with UNIX is an excellent one.
For once, I am tempted to buy an Apple.  And after all these years Apple's
graphics are still better then MSs.

-Original Message-
Sent: Tuesday, August 13, 2002 3:29 PM
To: Multiple recipients of list ORACLE-L


The first generation of Oracle's Network Computer are based on FreeBSD
and NetBSD.

Richard

-Original Message-
Sent: Tuesday, August 13, 2002 2:50 PM
To: Multiple recipients of list ORACLE-L


Yes, FreeBSD...

Since when do Oracle products work on FreeBSD?

-Joe

--- "Grabowy, Chris" <[EMAIL PROTECTED]> wrote:
> It is based on some *NIX variant...was it FreeBSD?


__
Do You Yahoo!?
HotJobs - Search Thousands of New Jobs
http://www.hotjobs.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Joe Raube
  INET: [EMAIL PROTECTED]

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

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

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

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

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

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

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

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

RE: SAN

[Smith, Ron L.]

Nice to see someone who knows what ADABAS is.

Ron S.

-Original Message-
Sent: Tuesday, August 13, 2002 1:50 PM
To: Multiple recipients of list ORACLE-L


You wrote:
>
> Will the "smarter algorithm" look inside the contents of a file before
> reading it? If it does not, then how will it be able to "intelligently"
> read ahead what data Oracle wants from inside its datafile? If it does,
how
> does it decipher the Oracle's way of storage?
>

How about using a variation of the algorithm ADABAS (database) is using for
sequential user reads:
1) Return the block requested.
2) If the next block is requested in a short period read the next 5 blocks
to the
controller cache.
3) If those are read in order and request come for the next block read each
time 10 blocks.

This is just from the top of my head but will assist greatly for full
table scan of big tables. Also remember that in Oracle before 9i blocks
used in FTS are put at the end of lru so are great candidates to be
overwritten
and you will read them again and again.

Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Sent: Tuesday, August 13, 2002 5:30 PM


>
> Tim, Jared and Kirti
>
> Jared, Kirti : Thanks a lot for your input. and yes, I read the Sane SAN
> paper.
>
> Tim : Many thanks to you for pointing out some of the big "mis"assumptions
> I had made.  I have corrected most of the stuff you had mentioned except
> for these
>
> >.* I'm less clear on whether SANs themselves perform read-ahead and
> the
> > conditions under which they do so.  I'm pretty sure that they are
smarter
> > about it than what you describe;  usually read-ahead mechanisms are
> > triggered by detected patterns of usage, not algorithms as simple as
> > described...
>
> Will the "smarter algorithm" look inside the contents of a file before
> reading it? If it does not, then how will it be able to "intelligently"
> read ahead what data Oracle wants from inside its datafile? If it does,
how
> does it decipher the Oracle's way of storage?
>
> > * your example about "read-ahead" conflicts makes some invalid
> > assumptions, namely about space being allocated in blocks not extents
> (when
> > does *that* ever happen?) and about "read-ahead being set to 3 blocks"
> > (again, when does *that* ever happen?).
>
> It does not happen. However I am going to be talking to a bunch of
> non-Oracle folks and management so I want to keep it as simple as
possible.
>
> > Altogether, empirical evidence (i.e. many successful SAN implementations
> > under Oracle over several years) does not lend credence to your basic
> > assertion that "SAN and Oracle don't go well together".  It is a fact
> that
> > they do...
>
> I am not trying to make a statement "SAN and Oracle dont go well
together".
> I am trying to convince my management that buying a SAN does not mean that
> we never need to worry about IO any more. Even a SAN needs to be
> configured. Currently they are under the impression that there are no IO
> problems but my database IO waits are 50% of the total response time. All
> my index, table data are scattered all over the disks -  many on the same
> disk and the answer I get is "No, we are not tasking the SAN at all. There
> are no IO issues"
>
>
> Thanks a lot
>
> Babu
>
>
>
>
>
> Tim Gorman <[EMAIL PROTECTED]>@fatcity.com on 08/13/2002 07:58:29 AM
>
> Please respond to [EMAIL PROTECTED]
>
> Sent by:[EMAIL PROTECTED]
>
>
> To:Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> cc:
>
>
>
> Babu,
>
> Is it possible that you are confusing the term "SAN" with the term "NAS"?
> As I read through your email, I couldn't help thinking that you discussing
> "network-attached storage" rather than "storage-area networks".  If so,
> some
> of my comments below might change slightly, but not much...
>
> ---
>
> Most of your major assumptions are correct, but there are important
> errors...
>
> * DBWR only does RW, never RR or SR.  Mostly Oracle server processes
do
> RR and SR, but ARCH also does SR, as do backup processes (whatever they
> are);  everyone always forgets to add backup processes to the mix...
>
> * SW is characteristic of LGWR and ARCH, but also of processes
> performing sorting (i.e. "direct writes" wait-event).  I think you'll
agree
> that databases generating a lot of redo (and archived redo) and performing
> lots of sorting are not necessarily "misconfigured".  The amount of redo
> generated is really a characteristic of the application itself, not the
> database configuration.  High amounts of sorting can possibly be tuned,
but
> that too is more a characteristic of the application and users usage of it
> than database configuration...
>
> * I'm not sure what your conclusions regarding RAID5 chunks or RAID0
> stripes are, but I suspect they are incorrect.  Oracle DB_BLOCK_SIZE
should
> not come close to matching RAID5 chunksize of RAID0 stripesize;  even
> "(DB_BLOCK_SIZE * DB_FILE_MUL

[no subject]

[Santiago Argibay Molina]

Hello All, 
We are trying to install Oracle9i on RED HAT linux 7.2
and getting following message: 

THE JAVA RUNTIME ENVIRONMENT WAS NOT FOUND AT
TEMP/BIN/JAVA 

THE ORACLE UNIVERSAL INSTALLER CAN NOT BE RUN.

I have looked through metalink but could not find
anything satisfying. I would like to hear from someone
who has an idea about overcoming this error. 

Thanks.

Santiago. 


Ahora podés usar Yahoo! Messenger desde tu celular. Aprendé cómo hacerlo en Yahoo! 
Móvil: http://ar.mobile.yahoo.com/sms.html
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: =?iso-8859-1?q?Santiago=20Argibay=20Molina?=
  INET: [EMAIL PROTECTED]

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

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

RE: Is there a way to create NOLOG Sequences?

[Nick Wagner]

Hannah, 
 
Increase the cache value.  The only time a sequence change get's 
recorded in the redo logs is when it goes to grab another set of values.  
If you look at the sys.seq$ table, that's only updated when you run out 
of cache values, and oracle needs to grab another one.  

 
Nick
 
-Original Message-From: [EMAIL PROTECTED] 
[mailto:[EMAIL PROTECTED]]Sent: Tuesday, August 13, 2002 8:30 
AMTo: Multiple recipients of list ORACLE-LSubject: Is 
there a way to create NOLOG Sequences?
Hi,
 
    
Having an issue where some code is constantly hitting a sequence (yes, I know... 
this will be fixed also). But in the meanwhile, is there a way to NOT log 
sequences to the redo log
 
Thanks,
 
    
Hannah

RE: Apple rack-mounted servers

[Grabowy, Chris]

First?  Are you implying the next generation will be something else?  Just
curious.  I believe Apple's decision to go with UNIX is an excellent one.
For once, I am tempted to buy an Apple.  And after all these years Apple's
graphics are still better then MSs.

-Original Message-
Sent: Tuesday, August 13, 2002 3:29 PM
To: Multiple recipients of list ORACLE-L


The first generation of Oracle's Network Computer are based on FreeBSD
and NetBSD.

Richard

-Original Message-
Sent: Tuesday, August 13, 2002 2:50 PM
To: Multiple recipients of list ORACLE-L


Yes, FreeBSD...

Since when do Oracle products work on FreeBSD?

-Joe

--- "Grabowy, Chris" <[EMAIL PROTECTED]> wrote:
> It is based on some *NIX variant...was it FreeBSD?


__
Do You Yahoo!?
HotJobs - Search Thousands of New Jobs
http://www.hotjobs.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Joe Raube
  INET: [EMAIL PROTECTED]

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

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

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

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

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

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

RE: Apple rack-mounted servers

[ltiu]

Hey Tom,

You mention that you are replacing 10 macOS servers. I did not know that MacOS
'had' servers before MacOS X came out.

What OS are these running?

ltiu

Quoting Tom Schruefer <[EMAIL PROTECTED]>:

> 
> Interesting.  Has anyone purchased and/or installed one of these X Servers?
> Being essentially UNIX, I'd prefer one of these over a MacOS server or
> WinXX.
> 
> Background, we are looking to replace about 10 MacOS servers in our High
> Schools right now.
> 
> 
> > -Original Message-
> > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Boivin,
> > Patrice J
> > Sent: Tuesday, August 13, 2002 1:45 PM
> > To: Multiple recipients of list ORACLE-L
> > Subject: RE: Apple rack-mounted servers
> >
> >
> > No longer OT!  Oracle says 9I will run on Apple's new servers?
> >
> > http://www.apple.com/xserve/reaction.html
> >
> > Regards,
> > Patrice Boivin
> > Systems Analyst (Oracle Certified DBA)
> >
> > Systems Admin & Operations | Admin. et Exploit. des systèmes
> > Technology Services| Services technologiques
> > Informatics Branch | Direction de l'informatique
> > Maritimes Region, DFO  | Région des Maritimes, MPO
> >
> > E-Mail: [EMAIL PROTECTED]
> >
> >
> >  -Original Message-
> > Sent:   Tuesday, August 13, 2002 12:45 PM
> > To: '[EMAIL PROTECTED]'
> > Subject:OT:  Apple rack-mounted servers
> >
> > My brother just sent me this link...
> >
> > http://www.apple.com/xserve/
> >
> > Regards,
> > Patrice Boivin
> > Systems Analyst (Oracle Certified DBA)
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: Boivin, Patrice J
> >   INET: [EMAIL PROTECTED]
> >
> > Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> > San Diego, California-- Public Internet access / Mailing Lists
> > 
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from).  You may
> > also send the HELP command for other information (like subscribing).
> >
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Tom Schruefer
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> 




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

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

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

c_USER#

[BigP]

Hi list ,
I am finding SYS.C_USER# as one of the hot blocks . 
I dont find any documentation about it , can somebody shed some light on it . 
why it is contention ?
 
Thanks ,
Bp

RE: Apple rack-mounted servers

[Grabowy, Chris]

(shrug)  Hey, Oracle gets to notch another OS on it's belt.  And the PR
people get to rub it into IBM's and MS's face.

-Original Message-
Sent: Tuesday, August 13, 2002 2:50 PM
To: Multiple recipients of list ORACLE-L


Yes, FreeBSD...

Since when do Oracle products work on FreeBSD?

-Joe

--- "Grabowy, Chris" <[EMAIL PROTECTED]> wrote:
> It is based on some *NIX variant...was it FreeBSD?


__
Do You Yahoo!?
HotJobs - Search Thousands of New Jobs
http://www.hotjobs.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Joe Raube
  INET: [EMAIL PROTECTED]

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

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

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

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

RE: DB Link Error - More Info

[Kirsh, Gary]

Kevin,

I've seen this problem when the global_name and db_domain don't match.  I've
been able to solve it one of two ways:

1.  Create another db link, this one with using the domain instead of
.WORLD, i.e. "create database link a.dallashq using ...".  Don't drop the
original link otherwise selects won't work.

2.  Change the global_name, i.e.
"alter database rename global_name to GETDATAP.DALLASHQ"

HTH,
Gary

-Original Message-
Sent: Friday, August 09, 2002 6:48 PM
To: Multiple recipients of list ORACLE-L


I thought of those myself

On DB A:
GLOBAL_NAME = GETDATAP.WORLD
DB_DOMAIN   = DALLASHQ

On DB B:
GLOBAL_NAME = NXTP.WORLD
DB_DOMAIN   = DALLASHQ

-Original Message-
Sent: Friday, August 09, 2002 4:39 PM
To: Multiple recipients of list ORACLE-L


Kevin,

I might have a solution.  On each machine, can you tell me what you get when
you do the following:

select * from global_name;
show parameter db_domain

Gary

Gary Kirsh
Next Extent Consulting

-Original Message-
Sent: Friday, August 09, 2002 5:13 PM
To: Multiple recipients of list ORACLE-L


They both failed.   The describe is not the important part.  That was just
something I found out.

The thing I really need to have running is the copy.

-Original Message-
Sent: Friday, August 09, 2002 3:43 PM
To: Multiple recipients of list ORACLE-L



What failed, the describe or the copy?
Here's a work-around for the describe bug (I think from Tom on this list.)
Perhaps give it a try and see if the link works at all??




/*
 produces output similar to the 'desc' command over a db_link
 takes two parameters
   1. the table to be described
   2. the name of the db_link (with @ sign)
*/
-- t. day  9-25-01
set verify off
select column_name, data_type, data_length from all_tab_COLUMNS&&2
where table_name = upper('&&1') order by 1
/


> --
> From: Kevin Lange[SMTP:[EMAIL PROTECTED]]
> Reply To: [EMAIL PROTECTED]
> Sent: Friday, August 09, 2002 2:03 PM
> To:   Multiple recipients of list ORACLE-L
> Subject:  RE: DB Link Error - More Info
> 
> I ran the copy using SQLPLUS from 8.0.5 trying to copy between 2 8.0.5
> databases and it still failed.  
> 
> Any further suggestions Jared ?
> 
> -Original Message-
> Sent: Friday, August 09, 2002 9:38 AM
> To: Multiple recipients of list ORACLE-L
> 
> 
> OK.  I am using an 8i client here.   Let me try and do it thru the 8.0.5
> SQLPLUS.
> 
> Thanks
> 
> -Original Message-
> Sent: Thursday, August 08, 2002 6:21 PM
> To: [EMAIL PROTECTED]
> Cc: [EMAIL PROTECTED]
> 
> 
> Kevin,
> 
> This is a bug in sqlplus.  You are using two different releases Oracle,
> and when you are using the 8i version of sqlplus and trying to describe
> a table on a lower version of Oracle through a dblink, you will get this 
> error.
> 
> The work around is:  Don't do that.  Seriously.  It's not fixed, nor will 
> it
> be fixed.  You can find details on MetaLink.
> 
> Jared
> 
> 
> 
> 
> 
> Kevin Lange <[EMAIL PROTECTED]>
> Sent by: [EMAIL PROTECTED]
> 08/08/2002 04:04 PM
> Please respond to ORACLE-L
> 
>  
> To: Multiple recipients of list ORACLE-L
> <[EMAIL PROTECTED]>
> cc: 
> Subject:RE: DB Link Error - More Info
> 
> 
> Sorry for the lack of info.   Her it all is:
>  
>   1) I have tns entries on both database machines that point to each 
> other.
>   2) I have global_names set to false on both machines.
>   3) I have the same ID defined with the same password on both machines.
>   4) We do not use Oracle Names.
>  
> On machine A: 
>   I created a link :
> create database link b using 'b.world';
>  
> On machine B:
>   I created a link :
> create database link a using 'a.world';
>  
> Here are the results:
>  
>   1. I can select data back and fourth between both machines wit no 
> errors.
>   2. When I try to describe a table accross the link I get the ORA-0219 
> error.
>   3. When I try to use the plsql copy command (ultimately what I want to 
> do) , on machine B, I get an error stating that I am trying to Fetch out 
> of sequence.   On machine A I get an unknow error that can not be 
> interpreted   a long string of numbers as the error number.
>  
>  
> So, thats it.Currently I am resorting to small selects accross the 
> working part of the links.  But, eventually I need to get to the copy 
> commands because they have the commits in them.
>  
> Any help is greatly appreciated.
>  
> Kevin
> -Original Message-
> Sent: Thursday, August 08, 2002 5:29 PM
> To: Multiple recipients of list ORACLE-L
> 
> 1)are you using global_names = true?  do the link names match the 
> global names?
>  
> 2)is there a local tns entry on the machine with database A that 
> points to database B?  we had a problem like then that was traced to our 
> using Oracle Names without local tns files.
>  
> -bill
> -Original Message-
> Sent: Thursday, August 08, 2002 6:05 PM
> To: Multiple recipients of 

RE: It took more than an hour to update 10,000 records

[Smith, Ron L.]

I was wondering how many rows are in the table being updated?  Do you have
an index on the columns in
the where clause?  Could be doing a full table scan to find all the rows.
Also, if there a lot of
indexes on the table it could add a lot of time to the update.

Ron S.

-Original Message-
Sent: Tuesday, August 13, 2002 12:55 PM
To: Multiple recipients of list ORACLE-L


Hmm... are there any triggers on the table that fire?

Raj
__
Rajendra Jamadagni  MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot com
Any opinion expressed here is personal and doesn't reflect that of ESPN Inc.

QOTD: Any clod can have facts, but having an opinion is an art!


-Original Message-
Sent: Tuesday, August 13, 2002 1:37 PM
To: Multiple recipients of list ORACLE-L


Do you have a unique index on nxx_id, npa_id, and lata_id?

Waleed

-Original Message-
Sent: Tuesday, August 13, 2002 12:25 PM
To: Multiple recipients of list ORACLE-L


Hi all,

I write a script to update 10,000 records in my database and noticed it took
more than an hour to update 10,000 records.  The script just includes 10,000
SQL update commands as shown below.  Is the time too long to update 10,000
records?  Is it a way to improve the update task to run faster.  Please
advise.

*** A portion of my update script is shown below:

update dbimpl.npa_nxx set ported_flag = 1 where nxx_id = 206 and npa_id =
201 and lata_id = 224;

update dbimpl.npa_nxx set ported_flag = 1 where nxx_id = 207 and npa_id =
201 and lata_id = 224;


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

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

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

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

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

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

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

RE: Apple rack-mounted servers

[ltiu]

It was mentioned in a different thread that Oracle had the most supported
platforms minus Apple OS and BSD(Free, Open,and Net).

Quoting Joe Raube <[EMAIL PROTECTED]>:

> Yes, FreeBSD...
> 
> Since when do Oracle products work on FreeBSD?
> 
> -Joe
> 
> --- "Grabowy, Chris" <[EMAIL PROTECTED]> wrote:
> > It is based on some *NIX variant...was it FreeBSD?
> 
> 
> __
> Do You Yahoo!?
> HotJobs - Search Thousands of New Jobs
> http://www.hotjobs.com
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Joe Raube
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> 




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

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

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

RE: Apple rack-mounted servers

[Ji, Richard]

The first generation of Oracle's Network Computer are based on FreeBSD
and NetBSD.

Richard

-Original Message-
Sent: Tuesday, August 13, 2002 2:50 PM
To: Multiple recipients of list ORACLE-L


Yes, FreeBSD...

Since when do Oracle products work on FreeBSD?

-Joe

--- "Grabowy, Chris" <[EMAIL PROTECTED]> wrote:
> It is based on some *NIX variant...was it FreeBSD?


__
Do You Yahoo!?
HotJobs - Search Thousands of New Jobs
http://www.hotjobs.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Joe Raube
  INET: [EMAIL PROTECTED]

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

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

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

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

FW: 11i Conc. Manager Question

[Kirsh, Gary]

Jay,
I haven't had a problem lowering the sleep to 15 or 30 seconds on Rels 9 -
11.0, can't imagine 11i would be different.
Gary

Gary Kirsh
Next Extent Consulting

-Original Message-
Sent: Tuesday, August 13, 2002 8:53 AM
To: Multiple recipients of list ORACLE-L


For those of you running Oracle Applications 11i, have you modified the
cache or sleep time for the standard managers?  Ours remains at the default,
which is cache 1 and sleep null (which I think defaults to 60 seconds).  
Users are complaining about the system being "slow."  When I checked it out,
they are just getting impatient waiting for concurrent requests to get
picked up by the managers - sometimes it takes as "long" as 2 minutes.

Thanks,


Jay Hostetter
Oracle DBA
D. & E. Communications
Ephrata, PA  USA



**DISCLAIMER
This e-mail message and any files transmitted with it are intended for the
use of the individual or entity to which they are addressed and may contain
information that is privileged, proprietary and confidential. If you are not
the intended recipient, you may not use, copy or disclose to anyone the
message or any information contained in the message. If you have received
this communication in error, please notify the sender and delete this e-mail
message. The contents do not represent the opinion of D&E except to the
extent that it relates to their official business.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jay Hostetter
  INET: [EMAIL PROTECTED]

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

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

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

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

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

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

RE: Re[2]: Oracle vs. DB2

[Jesse, Rich]

In the immortal words of Moe Syzlak:  Whaaa?!?

I need to ask for more money!  Or was the implication that I have
expensive tastes?   ;)

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

> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, August 13, 2002 9:44 AM
> To: Multiple recipients of list ORACLE-L
> Subject: Re[2]: Oracle vs. DB2
> 
> Oracle people are expensive
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jesse, Rich
  INET: [EMAIL PROTECTED]

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

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

RE: Oracle vs. DB2

[Jesse, Rich]

OK, I can take the subjectiveness of "My DB is better than your DB", but
this statement is nothing short of a marketing lie.

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

> -Original Message-
> From: ltiu [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, August 13, 2002 11:08 AM
> To: Multiple recipients of list ORACLE-L
> Subject: Re: Oracle vs. DB2
>
> ...
> Even MS Access can fly to the moon if you have good people working it.
> ...
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jesse, Rich
  INET: [EMAIL PROTECTED]

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

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

Re: It took more than an hour to update 10,000 records

[Manavendra Gupta]

Isn't this exercise more like standing in a field of hay, looking at a straw
and trying to figure out where it came from? Bad analogy, but anyone
responding to this would hardly have any ideas where to begin from! And
indeed, all answers to this are questions in turn.

With Warm Regards,
Manav.

- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Tuesday, August 13, 2002 11:12 AM


> >From the look of your sql statements it seems that each
> statement will be hard parsed because the values are different.
> If you will use bind variables you can save a lot of time.
>
> Is the script runs on the server or from another computer?
> If you run the script from another computer you also have the
> network time added.
>
> Yechiel Adar
> Mehish
> - Original Message -
> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> Sent: Tuesday, August 13, 2002 6:24 PM
>
>
> > Hi all,
> >
> > I write a script to update 10,000 records in my database and noticed it
> took
> > more than an hour to update 10,000 records.  The script just includes
> 10,000
> > SQL update commands as shown below.  Is the time too long to update
10,000
> > records?  Is it a way to improve the update task to run faster.  Please
> > advise.
> >
> > *** A portion of my update script is shown below:
> >
> > update dbimpl.npa_nxx set ported_flag = 1 where nxx_id = 206 and npa_id
=
> > 201 and lata_id = 224;
> >
> > update dbimpl.npa_nxx set ported_flag = 1 where nxx_id = 207 and npa_id
=
> > 201 and lata_id = 224;
> >
> >
> > Thanks,
> > David
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: Nguyen, David M
> >   INET: [EMAIL PROTECTED]
> >
> > Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> > San Diego, California-- Public Internet access / Mailing Lists
> > 
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from).  You may
> > also send the HELP command for other information (like subscribing).
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Yechiel Adar
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
>

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

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

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

Re: Perl and Oracle

[Jared . Still]

The PPD files aren't really meant for viewing in browser anyway.

You don't even need to download them to install the toolkit.

Jared





Steven Lembark <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
08/13/2002 09:48 AM
Please respond to ORACLE-L

 
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc: 
Subject:Re: Perl and Oracle



> though the only browser that appears to
> be a problem is IE.

Any known fixes (before I have Windophiles complain to me
that the stuff is useless)? If not I'll just tell them to
use Opera.

> If you download the toolkit, be *sure* to read the README files.

Egads you ARE a dreamer!

--
Steven Lembark   2930 W. Palmer
Workhorse Computing   Chicago, IL 60647
+1 800 762 1582
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Steven Lembark
  INET: [EMAIL PROTECTED]

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

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



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

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

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

RE: raw devices

[Khedr, Waleed]

But probably there is some other resource that replaces the ST enqueue to
control concurrency in case of LMT tablespaces and the update of the bitmap
headers.

Waleed

-Original Message-
Sent: Tuesday, August 13, 2002 2:35 PM
To: Multiple recipients of list ORACLE-L


On OPS and RAC, the issue is not really the contention for the UET$ and FET$
tables themselves.  It is the contention for the "ST" enqueue/lock which is
global across all instances.  Only one session on one instance can hold "ST"
across all instances in the OPS/RAC database.  Essentially, all dictionary
space-management operations become single-threaded across all instances,
which is avoided by using LMT...

- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Tuesday, August 13, 2002 9:23 AM


> Hello,
>
> Some may not agree with this sentiment, but unless there is an overriding
> reason for your needing to switch from dictionary-based tablespaces to
> locally-managed, I would leave well enough alone. Our OPS started out
doing
> many things wrong, which we straightened out as we got more sophisticated
> about middle tiers, various contention issues, set up better granularity
for
> locks, etc. One thing that we decided to leave in place was the
> dictionary-based tablespaces. We decided that it was more effort to modify
> the production system than would be gained by a small reduction in
> contention for $UET and $FET. If we were creating a new OPS, we would use
> locally-managed. With respect to the raw device allocation, our UNIX guy
set
> up the devices in /dev/vg0x, and the DBAs create links (ln -s) in
> /u01/oradata/DB_name to those devices. When we drop a tablespace, we break
> the links. For a new tablespace, we create new links. This way we have
> client-specific datafile names in /u01/oradata/DB_name. And we created the
> devices based on some growth assumptions, so DBAs do not have to chase
after
> UNIXAdmin every month to add more raw devices.
>
> Thank you,
>
> Paul Sherman
> DBAElcom, Inc.
> email - [EMAIL PROTECTED]
>
>
> -Original Message-
> Sent: Tuesday, August 13, 2002 10:19 AM
> To: Multiple recipients of list ORACLE-L
>
>
>  You do not have to do anything on Unix. Once you drop the Tablespace the
> raw file (device) could be used immediately in a new TS.
>
> Regards,
>
> Waleed
>
> -Original Message-
> To: Multiple recipients of list ORACLE-L
> Sent: 8/13/02 9:38 AM
>
> Hi,
>
> Wondering if anyone can help me with this question. Basically we have a
> parallel server setup (solaris 2.8 oracle 8.1.7.3)and so are using raw
> devices. I am in the process of recreating the tablspaces to be locally
> managed as opposed to dictionary. My question is this: In a filesystem
> environment, I would drop the tablespace in oracle and rm the
> corresponding datafile on the unix level, and then I can go about
> recreating my tablespace. I know that the OS doesnt really "interact"
> with the raw devices as such, but, in this situation would I be able to
> drop the tablespace and recreate it without having to do anything on the
> unix level? Would that corresponding raw device just be overwritten??
>
> Any help would be greatly appreciated
>
> Rgds
>
> Fawzia
>
>
> **
> Information in this email is confidential and may be privileged.
> It is intended for the addressee only. If you have received it in error,
> please notify the sender immediately and delete it from your system.
> You should not otherwise copy it, retransmit it or use or disclose its
> contents to anyone.
> Thank you for your co-operation.
> **
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Khedr, Waleed
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Sherman, Paul R.
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing lis

RE: It took more than an hour to update 10,000 records

[Khedr, Waleed]

Bind variables will not buy you anything. The time taken is mainly dependent
on the execution plan and the cardinality of the indexes being used. Also
any overhead like updating a column that's part of an index, triggers,
referential constraints, etc.

Waleed 

-Original Message-
Sent: Tuesday, August 13, 2002 2:35 PM
To: Multiple recipients of list ORACLE-L


I run it on the server.  How do I use bind variables?

Thanks,
David

-Original Message-
Sent: Tuesday, August 13, 2002 1:13 PM
To: Multiple recipients of list ORACLE-L


>From the look of your sql statements it seems that each
statement will be hard parsed because the values are different.
If you will use bind variables you can save a lot of time.

Is the script runs on the server or from another computer?
If you run the script from another computer you also have the
network time added.

Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Sent: Tuesday, August 13, 2002 6:24 PM


> Hi all,
>
> I write a script to update 10,000 records in my database and noticed it
took
> more than an hour to update 10,000 records.  The script just includes
10,000
> SQL update commands as shown below.  Is the time too long to update 10,000
> records?  Is it a way to improve the update task to run faster.  Please
> advise.
>
> *** A portion of my update script is shown below:
>
> update dbimpl.npa_nxx set ported_flag = 1 where nxx_id = 206 and npa_id =
> 201 and lata_id = 224;
>
> update dbimpl.npa_nxx set ported_flag = 1 where nxx_id = 207 and npa_id =
> 201 and lata_id = 224;
>
>
> Thanks,
> David
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Nguyen, David M
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).

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

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

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

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

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

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

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

Re: SAN

[Yechiel Adar]

You wrote:
>
> Will the "smarter algorithm" look inside the contents of a file before
> reading it? If it does not, then how will it be able to "intelligently"
> read ahead what data Oracle wants from inside its datafile? If it does,
how
> does it decipher the Oracle's way of storage?
>

How about using a variation of the algorithm ADABAS (database) is using for
sequential user reads:
1) Return the block requested.
2) If the next block is requested in a short period read the next 5 blocks
to the
controller cache.
3) If those are read in order and request come for the next block read each
time 10 blocks.

This is just from the top of my head but will assist greatly for full
table scan of big tables. Also remember that in Oracle before 9i blocks
used in FTS are put at the end of lru so are great candidates to be
overwritten
and you will read them again and again.

Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Sent: Tuesday, August 13, 2002 5:30 PM


>
> Tim, Jared and Kirti
>
> Jared, Kirti : Thanks a lot for your input. and yes, I read the Sane SAN
> paper.
>
> Tim : Many thanks to you for pointing out some of the big "mis"assumptions
> I had made.  I have corrected most of the stuff you had mentioned except
> for these
>
> >.* I'm less clear on whether SANs themselves perform read-ahead and
> the
> > conditions under which they do so.  I'm pretty sure that they are
smarter
> > about it than what you describe;  usually read-ahead mechanisms are
> > triggered by detected patterns of usage, not algorithms as simple as
> > described...
>
> Will the "smarter algorithm" look inside the contents of a file before
> reading it? If it does not, then how will it be able to "intelligently"
> read ahead what data Oracle wants from inside its datafile? If it does,
how
> does it decipher the Oracle's way of storage?
>
> > * your example about "read-ahead" conflicts makes some invalid
> > assumptions, namely about space being allocated in blocks not extents
> (when
> > does *that* ever happen?) and about "read-ahead being set to 3 blocks"
> > (again, when does *that* ever happen?).
>
> It does not happen. However I am going to be talking to a bunch of
> non-Oracle folks and management so I want to keep it as simple as
possible.
>
> > Altogether, empirical evidence (i.e. many successful SAN implementations
> > under Oracle over several years) does not lend credence to your basic
> > assertion that "SAN and Oracle don't go well together".  It is a fact
> that
> > they do...
>
> I am not trying to make a statement "SAN and Oracle dont go well
together".
> I am trying to convince my management that buying a SAN does not mean that
> we never need to worry about IO any more. Even a SAN needs to be
> configured. Currently they are under the impression that there are no IO
> problems but my database IO waits are 50% of the total response time. All
> my index, table data are scattered all over the disks -  many on the same
> disk and the answer I get is "No, we are not tasking the SAN at all. There
> are no IO issues"
>
>
> Thanks a lot
>
> Babu
>
>
>
>
>
> Tim Gorman <[EMAIL PROTECTED]>@fatcity.com on 08/13/2002 07:58:29 AM
>
> Please respond to [EMAIL PROTECTED]
>
> Sent by:[EMAIL PROTECTED]
>
>
> To:Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> cc:
>
>
>
> Babu,
>
> Is it possible that you are confusing the term "SAN" with the term "NAS"?
> As I read through your email, I couldn't help thinking that you discussing
> "network-attached storage" rather than "storage-area networks".  If so,
> some
> of my comments below might change slightly, but not much...
>
> ---
>
> Most of your major assumptions are correct, but there are important
> errors...
>
> * DBWR only does RW, never RR or SR.  Mostly Oracle server processes
do
> RR and SR, but ARCH also does SR, as do backup processes (whatever they
> are);  everyone always forgets to add backup processes to the mix...
>
> * SW is characteristic of LGWR and ARCH, but also of processes
> performing sorting (i.e. "direct writes" wait-event).  I think you'll
agree
> that databases generating a lot of redo (and archived redo) and performing
> lots of sorting are not necessarily "misconfigured".  The amount of redo
> generated is really a characteristic of the application itself, not the
> database configuration.  High amounts of sorting can possibly be tuned,
but
> that too is more a characteristic of the application and users usage of it
> than database configuration...
>
> * I'm not sure what your conclusions regarding RAID5 chunks or RAID0
> stripes are, but I suspect they are incorrect.  Oracle DB_BLOCK_SIZE
should
> not come close to matching RAID5 chunksize of RAID0 stripesize;  even
> "(DB_BLOCK_SIZE * DB_FILE_MULTIBLOCK_READ_COUNT)", which denotes the
> largest
> I/O requests (for full-table scans) generated by Oracle should be much
> smaller than RAID5 chunksize or RAID0 s

RE: Apple rack-mounted servers

[Joe Raube]

Yes, FreeBSD...

Since when do Oracle products work on FreeBSD?

-Joe

--- "Grabowy, Chris" <[EMAIL PROTECTED]> wrote:
> It is based on some *NIX variant...was it FreeBSD?


__
Do You Yahoo!?
HotJobs - Search Thousands of New Jobs
http://www.hotjobs.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Joe Raube
  INET: [EMAIL PROTECTED]

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

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

RE: Apple rack-mounted servers

[Tom Schruefer]

Interesting.  Has anyone purchased and/or installed one of these X Servers?
Being essentially UNIX, I'd prefer one of these over a MacOS server or
WinXX.

Background, we are looking to replace about 10 MacOS servers in our High
Schools right now.


> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Boivin,
> Patrice J
> Sent: Tuesday, August 13, 2002 1:45 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: Apple rack-mounted servers
>
>
> No longer OT!  Oracle says 9I will run on Apple's new servers?
>
> http://www.apple.com/xserve/reaction.html
>
> Regards,
> Patrice Boivin
> Systems Analyst (Oracle Certified DBA)
>
> Systems Admin & Operations | Admin. et Exploit. des systèmes
> Technology Services| Services technologiques
> Informatics Branch | Direction de l'informatique
> Maritimes Region, DFO  | Région des Maritimes, MPO
>
> E-Mail: [EMAIL PROTECTED]
>
>
>  -Original Message-
> Sent: Tuesday, August 13, 2002 12:45 PM
> To:   '[EMAIL PROTECTED]'
> Subject:  OT:  Apple rack-mounted servers
>
> My brother just sent me this link...
>
> http://www.apple.com/xserve/
>
> Regards,
> Patrice Boivin
> Systems Analyst (Oracle Certified DBA)
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Boivin, Patrice J
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
>

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

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

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

RE: It took more than an hour to update 10,000 records

[Nguyen, David M]

I run it on the server.  How do I use bind variables?

Thanks,
David

-Original Message-
Sent: Tuesday, August 13, 2002 1:13 PM
To: Multiple recipients of list ORACLE-L


>From the look of your sql statements it seems that each
statement will be hard parsed because the values are different.
If you will use bind variables you can save a lot of time.

Is the script runs on the server or from another computer?
If you run the script from another computer you also have the
network time added.

Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Sent: Tuesday, August 13, 2002 6:24 PM


> Hi all,
>
> I write a script to update 10,000 records in my database and noticed it
took
> more than an hour to update 10,000 records.  The script just includes
10,000
> SQL update commands as shown below.  Is the time too long to update 10,000
> records?  Is it a way to improve the update task to run faster.  Please
> advise.
>
> *** A portion of my update script is shown below:
>
> update dbimpl.npa_nxx set ported_flag = 1 where nxx_id = 206 and npa_id =
> 201 and lata_id = 224;
>
> update dbimpl.npa_nxx set ported_flag = 1 where nxx_id = 207 and npa_id =
> 201 and lata_id = 224;
>
>
> Thanks,
> David
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Nguyen, David M
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).

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

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

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

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

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

RE: Dba tools on NT

[Chaim . Katz]

OEM jobs will also work for you, if you're comfortable with Tcl.

I use OEM jobs
to run rman,
to run exports
to monitor alter logs
to schedule and run some sqlplus copy scripts
to schedule some data-loading and pl/sql routines
to run orakill if needed ...

I usually have no local access to any of the servers so its the only way I
ever get anything done.








"Grabowy, Chris" <[EMAIL PROTECTED]>@fatcity.com on 08/13/2002 01:24:35 PM

Please respond to [EMAIL PROTECTED]

Sent by:[EMAIL PROTECTED]


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



And it's difficult to write, looks like scrambled eggs when your done, and
impossible to maintain...

On the other hand, you could write the entire Windows XP operating system
in
one line of Perl...including Internet Explorer.

-Original Message-
Sent: Tuesday, August 13, 2002 12:49 PM
To: Multiple recipients of list ORACLE-L


Without a doubt - perl - get it free from www.activestate.com. Why use it?
Well, it is so flexible compared to other NT/DOS scripting tools you'll
wonder why you never had it before! It's also portable meaning all those
scripts you write should work on multi platforms with just a little tweak!

Lewis Bishop
---
Barclays Enable/ISS/OPTS - Oracle OCP Database Consultant
Phone - 020 8298 3418
Mobile - 07950 380857
Email - [EMAIL PROTECTED]


-Original Message-
Sent: 13 August 2002 17:25
To: Multiple recipients of list ORACLE-L

This header confirms that this email message has been swept for the
presence of computer viruses.

Corporate IT
THE WOOLWICH
--

Hello all

We are looking on programming and scripting tools
 for DBA team on NT.

Can you, oracle DBA's on NT, tell me off the list
what tools you are using for these functions
and, if you be so kind, why you choose them.

TIA

Yechiel Adar
Mehish

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

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

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


The information, attachments and opinions contained in this message are
those of its author only and do not necessarily represent those of The
Woolwich and or any other members of the Barclays Group and are intended
solely for the use of the individual or entity to whom they are addressed.
The sender may not be authorised to give financial advice, and nothing in
this message should be construed as offering such advice.

The message may contain privileged and confidential information and you may
not copy, distribute or take any action in reliance on it. If you have
received this email in error please notify the Information Security Manager
at [EMAIL PROTECTED]

Replies to this email may be monitored for operational or business reasons.

Woolwich plc. Registered in England Number : 3295699.

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

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

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

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

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




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

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

Re: Dba tools on NT

[Jared . Still]

Scripting: Perl, because it can do anything you ask of it.
Editor:  Vim - www.vim.org - same reason

Jared






"Yechiel Adar" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
08/13/2002 09:24 AM
Please respond to ORACLE-L

 
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc: 
Subject:Dba tools on NT


Hello all

We are looking on programming and scripting tools
 for DBA team on NT.

Can you, oracle DBA's on NT, tell me off the list 
what tools you are using for these functions 
and, if you be so kind, why you choose them.

TIA

Yechiel Adar
Mehish

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

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

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



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

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

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

RE: Oracle9i Installation Error

[Guerra, Abraham J]

Try 
the following 'missing links' if you're 
using HP-UX11.0:
 

ln -s /usr/lib/Motif2.1/libXm.4 
/usr/lib/Motif2.1/libXm.sl
ln -s /usr/lib/libXt.3 
/usr/lib/libXt.sl
ln -s /usr/lib/libX11.3 
/usr/lib/libX11.sl

ln -s /usr/lib/Motif2.1/libXm.4 
/usr/lib/libXm.sl
 
Good 
luck,
 
Abraham 
J. GuerraSenior Oracle DBAAmerican Family Insurance(608) 242-4100 
x32026 
 
 
 
-Original Message-From: [EMAIL PROTECTED] 
[mailto:[EMAIL PROTECTED]]Sent: Tuesday, August 13, 2002 
10:35 AMTo: Multiple recipients of list ORACLE-LSubject: 
Oracle9i Installation ErrorHello All, We are trying to 
install Oracle9i on HP-UX and getting following message:   Error in invoking target install of 
makefile:     
/oracle/product/9.0.1/ctx/lib/ins_ctx.mk I have looked through metalink but could not find anything satisfying. I 
would like to hear from someone who has an idea about overcoming this 
error. Regards. 
M.Emre HANCIOGLUMasterfoods 
Services GmbHISI Application SupportTel : +49 2162 500-576Fax: +49 
2162 41497E-Mail: [EMAIL PROTECTED]

Fwd: Bill Inmon webcast

[Jared . Still]

FYI:

Data Warehouse Guru on the Keys to Success: A FREE Webcast by Hyperion

Bill Inmon, data warehousing expert, outlines the keys to a successful
data warehousing endeavor, including methodology, architecture, the new
role of metadata, maximizing your investment, and tips for technology
selection. Register today for this free webcast sponsored by Hyperion,
delivered live Wednesday, Aug. 14th, and available in replay thereafter.

http://itw.itworld.com/GoNow/a14724a62773a79856347a0


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

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

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

Re: raw devices

[Tim Gorman]

On OPS and RAC, the issue is not really the contention for the UET$ and FET$
tables themselves.  It is the contention for the "ST" enqueue/lock which is
global across all instances.  Only one session on one instance can hold "ST"
across all instances in the OPS/RAC database.  Essentially, all dictionary
space-management operations become single-threaded across all instances,
which is avoided by using LMT...

- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Tuesday, August 13, 2002 9:23 AM


> Hello,
>
> Some may not agree with this sentiment, but unless there is an overriding
> reason for your needing to switch from dictionary-based tablespaces to
> locally-managed, I would leave well enough alone. Our OPS started out
doing
> many things wrong, which we straightened out as we got more sophisticated
> about middle tiers, various contention issues, set up better granularity
for
> locks, etc. One thing that we decided to leave in place was the
> dictionary-based tablespaces. We decided that it was more effort to modify
> the production system than would be gained by a small reduction in
> contention for $UET and $FET. If we were creating a new OPS, we would use
> locally-managed. With respect to the raw device allocation, our UNIX guy
set
> up the devices in /dev/vg0x, and the DBAs create links (ln -s) in
> /u01/oradata/DB_name to those devices. When we drop a tablespace, we break
> the links. For a new tablespace, we create new links. This way we have
> client-specific datafile names in /u01/oradata/DB_name. And we created the
> devices based on some growth assumptions, so DBAs do not have to chase
after
> UNIXAdmin every month to add more raw devices.
>
> Thank you,
>
> Paul Sherman
> DBAElcom, Inc.
> email - [EMAIL PROTECTED]
>
>
> -Original Message-
> Sent: Tuesday, August 13, 2002 10:19 AM
> To: Multiple recipients of list ORACLE-L
>
>
>  You do not have to do anything on Unix. Once you drop the Tablespace the
> raw file (device) could be used immediately in a new TS.
>
> Regards,
>
> Waleed
>
> -Original Message-
> To: Multiple recipients of list ORACLE-L
> Sent: 8/13/02 9:38 AM
>
> Hi,
>
> Wondering if anyone can help me with this question. Basically we have a
> parallel server setup (solaris 2.8 oracle 8.1.7.3)and so are using raw
> devices. I am in the process of recreating the tablspaces to be locally
> managed as opposed to dictionary. My question is this: In a filesystem
> environment, I would drop the tablespace in oracle and rm the
> corresponding datafile on the unix level, and then I can go about
> recreating my tablespace. I know that the OS doesnt really "interact"
> with the raw devices as such, but, in this situation would I be able to
> drop the tablespace and recreate it without having to do anything on the
> unix level? Would that corresponding raw device just be overwritten??
>
> Any help would be greatly appreciated
>
> Rgds
>
> Fawzia
>
>
> **
> Information in this email is confidential and may be privileged.
> It is intended for the addressee only. If you have received it in error,
> please notify the sender immediately and delete it from your system.
> You should not otherwise copy it, retransmit it or use or disclose its
> contents to anyone.
> Thank you for your co-operation.
> **
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Khedr, Waleed
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Sherman, Paul R.
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).

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

Fat City Network Services-- (858) 538-5051  FA

Re: It took more than an hour to update 10,000 records

[Yechiel Adar]

>From the look of your sql statements it seems that each
statement will be hard parsed because the values are different.
If you will use bind variables you can save a lot of time.

Is the script runs on the server or from another computer?
If you run the script from another computer you also have the
network time added.

Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Sent: Tuesday, August 13, 2002 6:24 PM


> Hi all,
>
> I write a script to update 10,000 records in my database and noticed it
took
> more than an hour to update 10,000 records.  The script just includes
10,000
> SQL update commands as shown below.  Is the time too long to update 10,000
> records?  Is it a way to improve the update task to run faster.  Please
> advise.
>
> *** A portion of my update script is shown below:
>
> update dbimpl.npa_nxx set ported_flag = 1 where nxx_id = 206 and npa_id =
> 201 and lata_id = 224;
>
> update dbimpl.npa_nxx set ported_flag = 1 where nxx_id = 207 and npa_id =
> 201 and lata_id = 224;
>
>
> Thanks,
> David
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Nguyen, David M
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).

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

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

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

RE: Apple rack-mounted servers

[Mercadante, Thomas F]

Patrice,

That's Oracle 9iRAS - not the database itself!

Tom Mercadante
Oracle Certified Professional


-Original Message-
Sent: Tuesday, August 13, 2002 1:45 PM
To: Multiple recipients of list ORACLE-L


No longer OT!  Oracle says 9I will run on Apple's new servers?

http://www.apple.com/xserve/reaction.html

Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)

Systems Admin & Operations | Admin. et Exploit. des systèmes
Technology Services| Services technologiques
Informatics Branch | Direction de l'informatique 
Maritimes Region, DFO  | Région des Maritimes, MPO

E-Mail: [EMAIL PROTECTED]


 -Original Message-
Sent:   Tuesday, August 13, 2002 12:45 PM
To: '[EMAIL PROTECTED]'
Subject:OT:  Apple rack-mounted servers

My brother just sent me this link...

http://www.apple.com/xserve/

Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)

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

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

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

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

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

Re:RE: Apple rack-mounted servers

[dgoulet]

Still "a day late & a dollar short", and my network manager thanks you for the
laugh too!!  Problem is we've had to pick him up off the floor.  Got a little
too far into it. (PS: He's the one who retired the last of the apples for us.)

Dick Goulet

Reply Separator
Author: "Boivin; Patrice J" <[EMAIL PROTECTED]>
Date:   8/13/2002 9:45 AM

No longer OT!  Oracle says 9I will run on Apple's new servers?

http://www.apple.com/xserve/reaction.html

Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)

Systems Admin & Operations | Admin. et Exploit. des systèmes
Technology Services| Services technologiques
Informatics Branch | Direction de l'informatique 
Maritimes Region, DFO  | Région des Maritimes, MPO

E-Mail: [EMAIL PROTECTED]


 -Original Message-
Sent:   Tuesday, August 13, 2002 12:45 PM
To: '[EMAIL PROTECTED]'

My brother just sent me this link...

http://www.apple.com/xserve/

Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)

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

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

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

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

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

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

RE: Apple rack-mounted servers

[Grabowy, Chris]

It is based on some *NIX variant...was it FreeBSD?

-Original Message-
Sent: Tuesday, August 13, 2002 1:45 PM
To: Multiple recipients of list ORACLE-L


No longer OT!  Oracle says 9I will run on Apple's new servers?

http://www.apple.com/xserve/reaction.html

Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)

Systems Admin & Operations | Admin. et Exploit. des systèmes
Technology Services| Services technologiques
Informatics Branch | Direction de l'informatique 
Maritimes Region, DFO  | Région des Maritimes, MPO

E-Mail: [EMAIL PROTECTED]


 -Original Message-
Sent:   Tuesday, August 13, 2002 12:45 PM
To: '[EMAIL PROTECTED]'
Subject:OT:  Apple rack-mounted servers

My brother just sent me this link...

http://www.apple.com/xserve/

Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)

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

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

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

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

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

Re:OT: Apple rack-mounted servers

[dgoulet]

Talk about "a day late & a dollar short"!!  Thanks for the laugh anyway. 8-)

Dick Goulet

Reply Separator
Author: "Boivin; Patrice J" <[EMAIL PROTECTED]>
Date:   8/13/2002 8:48 AM

My brother just sent me this link...

http://www.apple.com/xserve/

Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)

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

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

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

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

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

RE: Dba tools on NT

[Mercadante, Thomas F]

Dan,

You said:
"The one 'gotcha' is that environment variables ($ORACLE_HOME, $ORACLE_SID,
$SCRIPT_LOG, etc.) are not visible inside the Windows versions of SQL*Plus."

You are correct sir!  However, you can generate the sql scripts within the
NT script and use the environmental within that process.  For example:

Within an NT script, I say:

echo spool $SCRIPT_LOG/some_script_file.log > run.sql
echo select * from sysdate; >> run.sql
echo exit >> run.sql

sqlplus user/pw @run.sql

The above would interpret the $SCRIPT_LOG environmental correctly.
I do the above all the time and it works just fine.

Hope this helps.

Tom Mercadante
Oracle Certified Professional


-Original Message-
Sent: Tuesday, August 13, 2002 1:19 PM
To: Multiple recipients of list ORACLE-L


I've used MKS Toolkit and Cygwin for shell scripting. My preference is MKS
Toolkit for features and it runs as the user you are logged in as (i.e.
oracle). Cygwin is free, but it's processes run as the adminstrator. That
being said, it could be I did not configure it properly..

The one 'gotcha' is that environment variables ($ORACLE_HOME, $ORACLE_SID,
$SCRIPT_LOG, etc.) are not visible inside the Windows versions of SQL*Plus.
Instead of using these variables, I used SQL*Plus native variables populated
with a login.sql script. Not a problem. I'm not certain if the same
restriction is present in perl, but it is something to keep in mind. 

Dan Fink

-Original Message-
Sent: Tuesday, August 13, 2002 10:25 AM
To: Multiple recipients of list ORACLE-L


Hello all

We are looking on programming and scripting tools
 for DBA team on NT.

Can you, oracle DBA's on NT, tell me off the list 
what tools you are using for these functions 
and, if you be so kind, why you choose them.

TIA

Yechiel Adar
Mehish

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

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

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

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

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

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

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

RE: Another Transferring data from one table to another fast Q

[Paula_Stankus]

Title: RE: Another Transferring data from one table to another fast Q





Yes, but direct SQL with CTAS is faster.  Of course, could put nologging on table after creation but then need separate ddl script.  Still like CTAS.

-Original Message-
From: Baker, Barbara [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, August 13, 2002 12:34 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: Another Transferring data from one table to another fast Q



You can do it in pl/sql.  


In our table SUB, the field user_area is not just a long, but a long raw.
Do something like this:


pre_create sub_temp


declare
    cursor c_1 is select * from SUB;
begin
for r1 in c_1 loop
insert into DISCUS.SUB_temp (
  RRN    ,
  LOG_DATE_TIME  ,
  TRANS_AREA ,
  USER_AREA  )
Values(
r1.RRN,
r1.LOG_DATE_TIME,
r1.TRANS_AREA,
r1.USER_AREA
);
end loop;
commit;
exception
    when others then
    rollback;
    raise;
end;
/


> --
> From:     Shaw John-P55297[SMTP:[EMAIL PROTECTED]]
> Reply To:     [EMAIL PROTECTED]
> Sent:     Tuesday, August 13, 2002 9:18 AM
> To:   Multiple recipients of list ORACLE-L
> Subject:  Another Transferring data from one table to another fast Q
> 
> How about if your table has (I didn't do it) a LONG column. CTAS doesn't
> work and I don't see the nologging option for the ccopy command - in 8.1.6
> anyway.
> 
>   -Original Message-
>   From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED]]
>   Sent: Monday, August 12, 2002 11:24 AM
>   To: Multiple recipients of list ORACLE-L
>   Subject: RE: Transferring data from one table to another
> 
> 
> 
>   CTAS with nologging.  Could create a simple script to do this. 
> 
>   -Original Message- 
>   From: Peter R [ mailto:[EMAIL PROTECTED]] 
>   Sent: Monday, August 12, 2002 11:18 AM 
>   To: Multiple recipients of list ORACLE-L 
>   Subject: RE: Transferring data from one table to another 
> 
> 
>   Iam planning to copy 18-40Million rows thru CTAS!! My question is
> which one 
>   is efficient, CTAS or using cursor in pl/sql Procedure!! 
> 
>   thanks 
>   peter. 
> 
> 
>   >From: Abdul Aleem <[EMAIL PROTECTED]> 
>   >Reply-To: [EMAIL PROTECTED] 
>   >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> 
>   >Subject: RE: Transferring data from one table to another 
>   >Date: Sun, 11 Aug 2002 23:23:19 -0800 
>   > 
>   >Thank you, Amjad, 
>   >The problem is that then I have to write a procedure for each of
> the 
>   >tables. 
>   >I was looking for something that could be set at database level and
> would 
>   >apply to every table. 
>   > 
>   >Aleem 
>   > 
>   >  -Original Message- 
>   >Sent:  Monday, August 12, 2002 10:43 AM 
>   >To:    Multiple recipients of list ORACLE-L 
>   >Subject:   RE: Transferring data from one table to another 
>   > 
>   >well if u wanna commit after 1000 records u could very well use a
> cursor 
>   >and within the loop keep a counter which will indicate the no. of
> records 
>   >inserted...upon reaching 1000 records just commit and reinitialize
> the 
>   >counter.. 
>   > 
>   >i have written the "Pseudo" code below: 
>   > 
>   >declare 
>   >   cursor c1 is 
>   >   SELECT * from schema2.abc; 
>   >cntr number := 0; 
>   >begin 
>   >   for c1_abc in c1 loop 
>   >   insert into schema1.abc values contained in c1_abc; 
>   >   cntr := cntr +1; 
>   >   if (cntr = 1000)    then 
>   >   cntr := 0; 
>   >   commit; 
>   >   end if; 
>   >   end loop; 
>   >/* the following commit is 4 last set of records that might not b 
>   >commited*/ 
>   >commit; 
>   >end; 
>   > 
>   >rgds, 
>   >Ams. 
>   >www.medicomsoft.com 
>   > 
>   > 
>   > 
>   >-Original Message- 
>   >Sent: Monday, August 12, 2002 8:23 AM 
>   >To: Multiple recipients of list ORACLE-L 
>   > 
>   > 
>   >Hi, 
>   > 
>   >We are transferring data from one table in a schema to another
> table in 
>   >another schema with identical fields using 
>   >INSERT INTO schema1.abc (SELECT * from schema2.abc) 
>   >The source table has 1.6 million records. The tablespace increases
> to 
>   >consume full disk space and yet seems to be demanding more so the
> operation 
>   >doesn't complete. 
>   > 
>   >Is there a possibility to process commit after every 1,000 records?
> 
>   >Is there any other way of doing it? 
>   > 
>   >TIA! 
>   > 
>   >Aleem 
>   >-- 
>   >Please see the official ORACLE-L FAQ: http://www.orafaq.com 
>   >-- 
>   >Author: Abdul Al

Re: Oracle vs. DB2

[Igor Neyman]

Don't take it so "personal".

I agree, unskilled people can bring Oracle down to Access level.
But, there is no such skill, which can make Access perform at Oracle level
:-)

Igor Neyman, OCP DBA
[EMAIL PROTECTED]


- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Tuesday, August 13, 2002 1:13 PM


> But then this is an Oracle email list. What do you know, Oracle is da
Best!!
>
> Quoting Igor Neyman <[EMAIL PROTECTED]>:
>
> > > Even MS Access can fly to the moon if you have good people working it.
> > >
> >
> > I wouldn't bet my money on that :-)
> >
> > Igor Neyman, OCP DBA
> > [EMAIL PROTECTED]
> >
> >
> >
> > - Original Message -
> > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
> > Sent: Tuesday, August 13, 2002 12:08 PM
> >
> >
> > > People like to work(and are more effective) in an environment they are
> > > comfortable with, may it be Cobol Mainframe, RPG AS/400, MS SQL
Server,
> > MySQL,
> > > Oracle or Sybase.
> > >
> > > The point here is not which one is the best database, but which
> > combination of
> > > database and people(talent/skill) can give you the best return on
> > investment.
> > >
> > > Pointless having to use DB2 if your people don't know anything about
DB2
> > -
> > even
> > > if DB2 is the best, you still can't get it off the ground if you do
not
> > have the
> > > poeple to work it. Same goes for the other databases.
> > >
> > > If you need to evaluate which is the best database, evaluate it based
on
> > which
> > > is the best database for you (databse and people included).
> > >
> > > Even MS Access can fly to the moon if you have good people working it.
> > >
> > > ltiu
> > >
> > > Quoting Steven Lembark <[EMAIL PROTECTED]>:
> > >
> > > >
> > > >
> > > > One thing that seems different to me: DBA's at the sites
> > > > we work in with DB2 seem to swear by it more than at it.
> > > > This is the reverse ratio I find at Oracle houses.
> > > >
> > > > --
> > > > Steven Lembark   2930 W. Palmer
> > > > Workhorse Computing   Chicago, IL 60647
> > > > +1 800 762 1582
> > > > --
> > > > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > > > --
> > > > Author: Steven Lembark
> > > >   INET: [EMAIL PROTECTED]
> > > >
> > > > Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> > > > San Diego, California-- Public Internet access / Mailing
Lists
> > > > 
> > > > To REMOVE yourself from this mailing list, send an E-Mail message
> > > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> > > > the message BODY, include a line containing: UNSUB ORACLE-L
> > > > (or the name of mailing list you want to be removed from).  You may
> > > > also send the HELP command for other information (like subscribing).
> > > >
> > >
> > >
> > >
> > >
> > > --
> > > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > > --
> > > Author: ltiu
> > >   INET: [EMAIL PROTECTED]
> > >
> > > Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> > > San Diego, California-- Public Internet access / Mailing Lists
> > > 
> > > To REMOVE yourself from this mailing list, send an E-Mail message
> > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> > > the message BODY, include a line containing: UNSUB ORACLE-L
> > > (or the name of mailing list you want to be removed from).  You may
> > > also send the HELP command for other information (like subscribing).
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: Igor Neyman
> >   INET: [EMAIL PROTECTED]
> >
> > Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> > San Diego, California-- Public Internet access / Mailing Lists
> > 
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from).  You may
> > also send the HELP command for other information (like subscribing).
> >
>
>
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: ltiu
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you wan

RE: 11i Conc. Manager Question

[Kirsh, Gary]

Jay,
I haven't had a problem lowering the sleep to 15 or 30 seconds on Rels 9 -
11.0, can't imagine 11i would be different.
Gary

Gary Kirsh
Next Extent Consulting

-Original Message-
Sent: Tuesday, August 13, 2002 8:53 AM
To: Multiple recipients of list ORACLE-L


For those of you running Oracle Applications 11i, have you modified the
cache or sleep time for the standard managers?  Ours remains at the default,
which is cache 1 and sleep null (which I think defaults to 60 seconds).  
Users are complaining about the system being "slow."  When I checked it out,
they are just getting impatient waiting for concurrent requests to get
picked up by the managers - sometimes it takes as "long" as 2 minutes.

Thanks,


Jay Hostetter
Oracle DBA
D. & E. Communications
Ephrata, PA  USA



**DISCLAIMER
This e-mail message and any files transmitted with it are intended for the
use of the individual or entity to which they are addressed and may contain
information that is privileged, proprietary and confidential. If you are not
the intended recipient, you may not use, copy or disclose to anyone the
message or any information contained in the message. If you have received
this communication in error, please notify the sender and delete this e-mail
message. The contents do not represent the opinion of D&E except to the
extent that it relates to their official business.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jay Hostetter
  INET: [EMAIL PROTECTED]

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

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

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

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

Re:RE: Dba tools on NT

[dgoulet]

Sounds like KSH scripting, maybe I should look into Perl too! 8-)

Personally I like Enterprise Manager, PL/SQL, and Pro*C.

Dick Goulet

Reply Separator
Author: "Grabowy; Chris" <[EMAIL PROTECTED]>
Date:   8/13/2002 9:24 AM

And it's difficult to write, looks like scrambled eggs when your done, and
impossible to maintain...

On the other hand, you could write the entire Windows XP operating system in
one line of Perl...including Internet Explorer.

-Original Message-
Sent: Tuesday, August 13, 2002 12:49 PM
To: Multiple recipients of list ORACLE-L


Without a doubt - perl - get it free from www.activestate.com. Why use it?
Well, it is so flexible compared to other NT/DOS scripting tools you'll
wonder why you never had it before! It's also portable meaning all those
scripts you write should work on multi platforms with just a little tweak!

Lewis Bishop
---
Barclays Enable/ISS/OPTS - Oracle OCP Database Consultant
Phone - 020 8298 3418
Mobile - 07950 380857
Email - [EMAIL PROTECTED]


-Original Message-
Sent: 13 August 2002 17:25
To: Multiple recipients of list ORACLE-L

This header confirms that this email message has been swept for the
presence of computer viruses. 

Corporate IT
THE WOOLWICH
--

Hello all

We are looking on programming and scripting tools
 for DBA team on NT.

Can you, oracle DBA's on NT, tell me off the list 
what tools you are using for these functions 
and, if you be so kind, why you choose them.

TIA

Yechiel Adar
Mehish

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

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

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


The information, attachments and opinions contained in this message are
those of its author only and do not necessarily represent those of The
Woolwich and or any other members of the Barclays Group and are intended
solely for the use of the individual or entity to whom they are addressed.
The sender may not be authorised to give financial advice, and nothing in
this message should be construed as offering such advice.

The message may contain privileged and confidential information and you may
not copy, distribute or take any action in reliance on it. If you have
received this email in error please notify the Information Security Manager
at [EMAIL PROTECTED]

Replies to this email may be monitored for operational or business reasons.

Woolwich plc. Registered in England Number : 3295699.

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

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

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

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

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


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

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

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

RE: It took more than an hour to update 10,000 records

[Jamadagni, Rajendra]

Hmm... are there any triggers on the table that fire?

Raj
__
Rajendra Jamadagni  MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot com
Any opinion expressed here is personal and doesn't reflect that of ESPN Inc.

QOTD: Any clod can have facts, but having an opinion is an art!


-Original Message-
Sent: Tuesday, August 13, 2002 1:37 PM
To: Multiple recipients of list ORACLE-L


Do you have a unique index on nxx_id, npa_id, and lata_id?

Waleed

-Original Message-
Sent: Tuesday, August 13, 2002 12:25 PM
To: Multiple recipients of list ORACLE-L


Hi all,

I write a script to update 10,000 records in my database and noticed it took
more than an hour to update 10,000 records.  The script just includes 10,000
SQL update commands as shown below.  Is the time too long to update 10,000
records?  Is it a way to improve the update task to run faster.  Please
advise.

*** A portion of my update script is shown below:

update dbimpl.npa_nxx set ported_flag = 1 where nxx_id = 206 and npa_id =
201 and lata_id = 224;

update dbimpl.npa_nxx set ported_flag = 1 where nxx_id = 207 and npa_id =
201 and lata_id = 224;


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

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

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

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

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



*2

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: Cache' Database

[Ivan_Rivera]

Title: RE: Cache' Database





Thanks guys.


-Original Message-
From: DENNIS WILLIAMS [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, August 13, 2002 12:54 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: Cache' Database



Ivan - This was discussed recently on this list. Here is the discussion for
your convenience.
  
  Support
the Oracle FAQ by supporting our sponsors. Click here! 


RE: RE: Intersystems Cache database


[ Index   ] [
Raw   Message
]



Message-ID:     <[EMAIL PROTECTED]> 


Date:   Fri, 22 Mar 2002 06:43:23 -0800 



I have some past experience with MUMPS - Run like h@#$ and don't look back.


If CACHE=MUMPS it most definitely is false advertising.




Scott Shafer


San Antonio, TX


210-581-6217




"Common sense will not accomplish great things. Simply become insane and


desperate."




> -Original Message-


> From: Norrell, Brian [SMTP:[EMAIL PROTECTED]]


> Sent: Thursday, March 21, 2002 7:23 PM


> To:   Multiple recipients of list ORACLE-L


> Subject:  RE: RE: Intersystems Cache database


> 


> "Hospital" is the key.  Cache was originally developed in the '70 for


> use in medical applications, of course, back then it was known as MUMPS


> before the PR guys got a hold of it.  The UNIX types will tell you that


> any app that has been around for three decades has to have something


> going for it.


> 


> Some of the DBAs around hear played with it, and were not impressed.


> Apparently recovery in the event of any failure was a nightmare.


> 


> -Original Message-


> Sent: Thursday, March 21, 2002 5:14 PM


> To: Multiple recipients of list ORACLE-L


> 


> 


> I've heard of them...  Some guys at the last place I was at had used it


> as


> the back end for a lab results viewer at a hospital in the Boston


> area...


> They loved it...  They kept telling me how great it was but I never saw


> it


> in action...  I took most of it with a grain of salt since they were


> developers...  


> 


> As far as the 4 million users go...  If you consider each hospital


> employee


> a "user"...  Of better yet, each patient a "user"...


> 


> :-)


> 


> -Original Message-


> Sent: Thursday, March 21, 2002 5:19 PM


> To: Multiple recipients of list ORACLE-L


> 


> 


> Anyone else ever hear about them?  According to the web site that have


> '4


> million users'.  Seems that would have left a mark somewhere at that


> level.


> 


> Dick Goulet


> 


> Reply Separator


> Author: "Jesse; Rich" < [EMAIL PROTECTED]
 >


> Date:   3/21/2002 1:58 PM


> 


> Yeah, like that ain't a plug from someone acting like an Oracle DBA.


> 


> 1)  No signature.


> 2)  Generic e-mail account from a generic mail domain.


> 3)  No recent posts to this list.


> 


> Probably just a Cache salesman...


> 


> Rich Jesse   System/Database Administrator


>  [EMAIL PROTECTED] 
Quad/Tech International, 


Sussex, WI


> USA


> 


> 


> -Original Message-


> Sent: Thursday, March 21, 2002 3:23 PM


> To: Multiple recipients of list ORACLE-L


> 


> 


> Hi,


> 


> Does anyone know about the Cache database?  Is it REALLY that


> robust as they claim to be?


> 


>  http://cache.intersys.com/cache/fb/fb_03.html
 


> 


> Thanks.


> -- 


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


> -- 


> Author: Jesse, Rich


>   INET:  [EMAIL PROTECTED]  


> 


> Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051


> San Diego, California    -- Public Internet access / Mailing Lists


> 


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


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


in


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


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


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


> -- 


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


> -- 


> Author: 


>   INET:  [EMAIL PROTECTED]  


> 


> Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051


> San Diego, California    -- Public Internet access / Mailing Lists


> 


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


> to:  [EMAIL PROTECTED]   (note EXACT
spelling of 'ListGu

RE: Oracle9i Installation Error

[Scott . Shafer]

Read your "Release Notes Addendum" from http://technet.oracle.com  - there
are some links in /usr/lib that need to be created (among other things).
Also, ensure that your RAM is sufficient _or_ that the sysadmins have
swapping turned on.  This from Oracle Support:  Remove all references to
ORACLE_HOME from your environment (PATH, LD_LIBRARY_PATH, etc).  Hopefully
this gives you some ideas to try.

Scott Shafer
San Antonio, TX
210-581-6217


> -Original Message-
> From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]]
> Sent: Tuesday, August 13, 2002 10:35 AM
> To:   Multiple recipients of list ORACLE-L
> Subject:  Oracle9i Installation Error
> 
> 
> Hello All, 
> We are trying to install Oracle9i on HP-UX and getting following message: 
> 
>   Error in invoking target install of makefile: 
> /oracle/product/9.0.1/ctx/lib/ins_ctx.mk 
> 
> I have looked through metalink but could not find anything satisfying. I
> would like to hear from someone who has an idea about overcoming this
> error. 
> 
> Regards. 
> 
> 
> M.Emre HANCIOGLU
> Masterfoods Services GmbH
> ISI Application Support
> Tel : +49 2162 500-576
> Fax: +49 2162 41497
> E-Mail: [EMAIL PROTECTED]
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

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

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

RE: Apple rack-mounted servers

[Boivin, Patrice J]

No longer OT!  Oracle says 9I will run on Apple's new servers?

http://www.apple.com/xserve/reaction.html

Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)

Systems Admin & Operations | Admin. et Exploit. des systèmes
Technology Services| Services technologiques
Informatics Branch | Direction de l'informatique 
Maritimes Region, DFO  | Région des Maritimes, MPO

E-Mail: [EMAIL PROTECTED]


 -Original Message-
Sent:   Tuesday, August 13, 2002 12:45 PM
To: '[EMAIL PROTECTED]'
Subject:OT:  Apple rack-mounted servers

My brother just sent me this link...

http://www.apple.com/xserve/

Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)

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

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

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

RE: Who is using a table?

[Khedr, Waleed]

What is wrong in pure auditing using "Audit"?

Waleed

-Original Message-
Sent: Tuesday, August 13, 2002 12:31 PM
To: Multiple recipients of list ORACLE-L


When a developer wants to change a table it helps if
we know who is using it. Sometimes there are applications
that use tables that belong to other applications
and nobody remembers. Than we change the table
and KABOOM 
(as expressed by the Martian that
Bugs Bunny fought and of course according 
to the application people
an earth shuttering KABOOM :-) ).

We need idea how to do it. We thought about auditing
of writing a trigger that will log each access to the
table but we fear the overhead.

Any suggestions, ideas, whatever are welcome.

TIA

Yechiel Adar
Mehish

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

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

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

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

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

RE: Dba tools on NT

[Fink, Dan]

I've used MKS Toolkit and Cygwin for shell scripting. My preference is MKS
Toolkit for features and it runs as the user you are logged in as (i.e.
oracle). Cygwin is free, but it's processes run as the adminstrator. That
being said, it could be I did not configure it properly..

The one 'gotcha' is that environment variables ($ORACLE_HOME, $ORACLE_SID,
$SCRIPT_LOG, etc.) are not visible inside the Windows versions of SQL*Plus.
Instead of using these variables, I used SQL*Plus native variables populated
with a login.sql script. Not a problem. I'm not certain if the same
restriction is present in perl, but it is something to keep in mind. 

Dan Fink

-Original Message-
Sent: Tuesday, August 13, 2002 10:25 AM
To: Multiple recipients of list ORACLE-L


Hello all

We are looking on programming and scripting tools
 for DBA team on NT.

Can you, oracle DBA's on NT, tell me off the list 
what tools you are using for these functions 
and, if you be so kind, why you choose them.

TIA

Yechiel Adar
Mehish

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

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

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

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

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

RE: Dba tools on NT

[Grabowy, Chris]

And it's difficult to write, looks like scrambled eggs when your done, and
impossible to maintain...

On the other hand, you could write the entire Windows XP operating system in
one line of Perl...including Internet Explorer.

-Original Message-
Sent: Tuesday, August 13, 2002 12:49 PM
To: Multiple recipients of list ORACLE-L


Without a doubt - perl - get it free from www.activestate.com. Why use it?
Well, it is so flexible compared to other NT/DOS scripting tools you'll
wonder why you never had it before! It's also portable meaning all those
scripts you write should work on multi platforms with just a little tweak!

Lewis Bishop
---
Barclays Enable/ISS/OPTS - Oracle OCP Database Consultant
Phone - 020 8298 3418
Mobile - 07950 380857
Email - [EMAIL PROTECTED]


-Original Message-
Sent: 13 August 2002 17:25
To: Multiple recipients of list ORACLE-L

This header confirms that this email message has been swept for the
presence of computer viruses. 

Corporate IT
THE WOOLWICH
--

Hello all

We are looking on programming and scripting tools
 for DBA team on NT.

Can you, oracle DBA's on NT, tell me off the list 
what tools you are using for these functions 
and, if you be so kind, why you choose them.

TIA

Yechiel Adar
Mehish

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

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

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


The information, attachments and opinions contained in this message are
those of its author only and do not necessarily represent those of The
Woolwich and or any other members of the Barclays Group and are intended
solely for the use of the individual or entity to whom they are addressed.
The sender may not be authorised to give financial advice, and nothing in
this message should be construed as offering such advice.

The message may contain privileged and confidential information and you may
not copy, distribute or take any action in reliance on it. If you have
received this email in error please notify the Information Security Manager
at [EMAIL PROTECTED]

Replies to this email may be monitored for operational or business reasons.

Woolwich plc. Registered in England Number : 3295699.

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

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

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

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

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

RE: It took more than an hour to update 10,000 records

[Mercadante, Thomas F]

David,

I think an hour to update 10,000 is way too long.

How are you determining the value's for the 'where' clause?  If you are
running
10,000 of these update statements, then you are performing it as slow as is
possible.  You need to look at optimizing the total update into as few sql
statements as possible.

One possible method is to create a stored procedure where you pass in all
the parameter values and repeatedly call the procedure to perform the
updates - this would be faster than what you are currently doing.

Another method would expand on the above depending on how you are getting
the values for the 'where' clause - all using single sql statements.

Provide some more info and we can help.

Tom Mercadante
Oracle Certified Professional


-Original Message-
Sent: Tuesday, August 13, 2002 12:25 PM
To: Multiple recipients of list ORACLE-L


Hi all,

I write a script to update 10,000 records in my database and noticed it took
more than an hour to update 10,000 records.  The script just includes 10,000
SQL update commands as shown below.  Is the time too long to update 10,000
records?  Is it a way to improve the update task to run faster.  Please
advise.

*** A portion of my update script is shown below:

update dbimpl.npa_nxx set ported_flag = 1 where nxx_id = 206 and npa_id =
201 and lata_id = 224;

update dbimpl.npa_nxx set ported_flag = 1 where nxx_id = 207 and npa_id =
201 and lata_id = 224;


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

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

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

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

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

Re: 11i Conc. Manager Question

[Jay Hostetter]

Tim,

  We already have other managers set up.  I was just curious if other folks tweak the 
standard manager.

Thanks,
Jay

>>> [EMAIL PROTECTED] 08/13/02 10:28AM >>>
Jay,

It's a little more complicated than that.  It sounds like you are using the
single default ConcMgr queue (named "standard", if I recall correctly?) and
you really should designate different "jobs" to go to different queues, each
of which is configured (in terms of managers and sleep times) according to
business requirements...

Barb Matthews wrote an excellent paper entitled "Herding Cats" back in 1996
or so.  Definitely pre-R11i, but certainly as relevant today as for R9.4 or
whatever she was running at the time.  The paper can be found online at her
website at http://www.OnCallDBA.com and it should provide some good guidance
on setting up queues for your own particular environment and requirements,
even if the ConcMgr terminology has maybe changed for R11i...

Hope this helps...

-Tim

- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Tuesday, August 13, 2002 6:53 AM


For those of you running Oracle Applications 11i, have you modified the
cache or sleep time for the standard managers?  Ours remains at the default,
which is cache 1 and sleep null (which I think defaults to 60 seconds).
Users are complaining about the system being "slow."  When I checked it out,
they are just getting impatient waiting for concurrent requests to get
picked up by the managers - sometimes it takes as "long" as 2 minutes.

Thanks,


Jay Hostetter
Oracle DBA
D. & E. Communications
Ephrata, PA  USA





**DISCLAIMER
This e-mail message and any files transmitted with it are intended for the use of the 
individual or entity to which they are addressed and may contain information that is 
privileged, proprietary and confidential. If you are not the intended recipient, you 
may not use, copy or disclose to anyone the message or any information contained in 
the message. If you have received this communication in error, please notify the 
sender and delete this e-mail message. The contents do not represent the opinion of 
D&E except to the extent that it relates to their official business.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Jay Hostetter
  INET: [EMAIL PROTECTED]

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

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

RE: It took more than an hour to update 10,000 records

[Khedr, Waleed]

Do you have a unique index on nxx_id, npa_id, and lata_id?

Waleed

-Original Message-
Sent: Tuesday, August 13, 2002 12:25 PM
To: Multiple recipients of list ORACLE-L


Hi all,

I write a script to update 10,000 records in my database and noticed it took
more than an hour to update 10,000 records.  The script just includes 10,000
SQL update commands as shown below.  Is the time too long to update 10,000
records?  Is it a way to improve the update task to run faster.  Please
advise.

*** A portion of my update script is shown below:

update dbimpl.npa_nxx set ported_flag = 1 where nxx_id = 206 and npa_id =
201 and lata_id = 224;

update dbimpl.npa_nxx set ported_flag = 1 where nxx_id = 207 and npa_id =
201 and lata_id = 224;


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

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

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

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

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

Re: Dba tools on NT

[Manavendra Gupta]

Quest software (www.quest.com) provides a nice array of tools.

With Warm Regards,
Manav.

- Original Message - 
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Tuesday, August 13, 2002 9:24 AM


> Hello all
> 
> We are looking on programming and scripting tools
>  for DBA team on NT.
> 
> Can you, oracle DBA's on NT, tell me off the list 
> what tools you are using for these functions 
> and, if you be so kind, why you choose them.
> 
> TIA
> 
> Yechiel Adar
> Mehish
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Yechiel Adar
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> 

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

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

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

Re: Oracle vs. DB2

[ltiu]

But then this is an Oracle email list. What do you know, Oracle is da Best!!

Quoting Igor Neyman <[EMAIL PROTECTED]>:

> > Even MS Access can fly to the moon if you have good people working it.
> >
> 
> I wouldn't bet my money on that :-)
> 
> Igor Neyman, OCP DBA
> [EMAIL PROTECTED]
> 
> 
> 
> - Original Message -
> To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
> Sent: Tuesday, August 13, 2002 12:08 PM
> 
> 
> > People like to work(and are more effective) in an environment they are
> > comfortable with, may it be Cobol Mainframe, RPG AS/400, MS SQL Server,
> MySQL,
> > Oracle or Sybase.
> >
> > The point here is not which one is the best database, but which
> combination of
> > database and people(talent/skill) can give you the best return on
> investment.
> >
> > Pointless having to use DB2 if your people don't know anything about DB2
> -
> even
> > if DB2 is the best, you still can't get it off the ground if you do not
> have the
> > poeple to work it. Same goes for the other databases.
> >
> > If you need to evaluate which is the best database, evaluate it based on
> which
> > is the best database for you (databse and people included).
> >
> > Even MS Access can fly to the moon if you have good people working it.
> >
> > ltiu
> >
> > Quoting Steven Lembark <[EMAIL PROTECTED]>:
> >
> > >
> > >
> > > One thing that seems different to me: DBA's at the sites
> > > we work in with DB2 seem to swear by it more than at it.
> > > This is the reverse ratio I find at Oracle houses.
> > >
> > > --
> > > Steven Lembark   2930 W. Palmer
> > > Workhorse Computing   Chicago, IL 60647
> > > +1 800 762 1582
> > > --
> > > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > > --
> > > Author: Steven Lembark
> > >   INET: [EMAIL PROTECTED]
> > >
> > > Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> > > San Diego, California-- Public Internet access / Mailing Lists
> > > 
> > > To REMOVE yourself from this mailing list, send an E-Mail message
> > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> > > the message BODY, include a line containing: UNSUB ORACLE-L
> > > (or the name of mailing list you want to be removed from).  You may
> > > also send the HELP command for other information (like subscribing).
> > >
> >
> >
> >
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: ltiu
> >   INET: [EMAIL PROTECTED]
> >
> > Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> > San Diego, California-- Public Internet access / Mailing Lists
> > 
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from).  You may
> > also send the HELP command for other information (like subscribing).
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Igor Neyman
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> 




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

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

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

Re: Who is using a table?

[Rachel Carmichael]

the trigger isn't that expensive...

last_update_dt and Last_update_user


--- Yechiel Adar <[EMAIL PROTECTED]> wrote:
> When a developer wants to change a table it helps if
> we know who is using it. Sometimes there are applications
> that use tables that belong to other applications
> and nobody remembers. Than we change the table
> and KABOOM 
> (as expressed by the Martian that
> Bugs Bunny fought and of course according 
> to the application people
> an earth shuttering KABOOM :-) ).
> 
> We need idea how to do it. We thought about auditing
> of writing a trigger that will log each access to the
> table but we fear the overhead.
> 
> Any suggestions, ideas, whatever are welcome.
> 
> TIA
> 
> Yechiel Adar
> Mehish
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Yechiel Adar
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing
> Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).


__
Do You Yahoo!?
HotJobs - Search Thousands of New Jobs
http://www.hotjobs.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rachel Carmichael
  INET: [EMAIL PROTECTED]

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

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

Re[2]: Oracle vs. DB2

[dgoulet]

Humm,  If you've got Oracle DBA's who are swearing at their databases you might
question the way they do their work.  I've 25 instances & I don't have to swear
at any of them.  Now the users, that's another story.

Dick Goulet

Reply Separator
Author: Steven Lembark <[EMAIL PROTECTED]>
Date:   8/13/2002 7:13 AM



One thing that seems different to me: DBA's at the sites
we work in with DB2 seem to swear by it more than at it.
This is the reverse ratio I find at Oracle houses.

--
Steven Lembark   2930 W. Palmer
Workhorse Computing   Chicago, IL 60647
+1 800 762 1582
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Steven Lembark
  INET: [EMAIL PROTECTED]

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

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

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

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

RE: Dba tools on NT

[Mercadante, Thomas F]

Yechiel,

I use NT scripting (DOS) and Perl.  I use these because:

1) They are free.
2). They are easily transportable from box to box - when I develop and NT
script, I write it in such a way that it can easily be converted to Kshell
on unix.
3). They are free
4). They are free
5). They are free


Did I say they are free? - no hassle with support or licenses for different
servers.  I can freely give them away to whomever I want, and are easy to
support.

Just my opinion.

Tom Mercadante
Oracle Certified Professional


-Original Message-
Sent: Tuesday, August 13, 2002 12:25 PM
To: Multiple recipients of list ORACLE-L


Hello all

We are looking on programming and scripting tools
 for DBA team on NT.

Can you, oracle DBA's on NT, tell me off the list 
what tools you are using for these functions 
and, if you be so kind, why you choose them.

TIA

Yechiel Adar
Mehish

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

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

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

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

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

OT: Apple rack-mounted servers

[Boivin, Patrice J]

My brother just sent me this link...

http://www.apple.com/xserve/

Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)

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

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

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

Re: Oracle vs. DB2

[Igor Neyman]

> Even MS Access can fly to the moon if you have good people working it.
>

I wouldn't bet my money on that :-)

Igor Neyman, OCP DBA
[EMAIL PROTECTED]



- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Tuesday, August 13, 2002 12:08 PM


> People like to work(and are more effective) in an environment they are
> comfortable with, may it be Cobol Mainframe, RPG AS/400, MS SQL Server,
MySQL,
> Oracle or Sybase.
>
> The point here is not which one is the best database, but which
combination of
> database and people(talent/skill) can give you the best return on
investment.
>
> Pointless having to use DB2 if your people don't know anything about DB2 -
even
> if DB2 is the best, you still can't get it off the ground if you do not
have the
> poeple to work it. Same goes for the other databases.
>
> If you need to evaluate which is the best database, evaluate it based on
which
> is the best database for you (databse and people included).
>
> Even MS Access can fly to the moon if you have good people working it.
>
> ltiu
>
> Quoting Steven Lembark <[EMAIL PROTECTED]>:
>
> >
> >
> > One thing that seems different to me: DBA's at the sites
> > we work in with DB2 seem to swear by it more than at it.
> > This is the reverse ratio I find at Oracle houses.
> >
> > --
> > Steven Lembark   2930 W. Palmer
> > Workhorse Computing   Chicago, IL 60647
> > +1 800 762 1582
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: Steven Lembark
> >   INET: [EMAIL PROTECTED]
> >
> > Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> > San Diego, California-- Public Internet access / Mailing Lists
> > 
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from).  You may
> > also send the HELP command for other information (like subscribing).
> >
>
>
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: ltiu
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).

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

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

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

Re: Perl and Oracle

[Steven Lembark]

> though the only browser that appears to
> be a problem is IE.

Any known fixes (before I have Windophiles complain to me
that the stuff is useless)? If not I'll just tell them to
use Opera.

> If you download the toolkit, be *sure* to read the README files.

Egads you ARE a dreamer!

--
Steven Lembark   2930 W. Palmer
Workhorse Computing   Chicago, IL 60647
+1 800 762 1582
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Steven Lembark
  INET: [EMAIL PROTECTED]

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

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

RE: Cache' Database

[DENNIS WILLIAMS]

Ivan - This was discussed recently on this list. Here is the discussion for
your convenience.
  
  Support
the Oracle FAQ by supporting our sponsors. Click here! 

RE: RE: Intersystems Cache database

[ Index   ] [
Raw   Message
]


Message-ID: <[EMAIL PROTECTED]> 

Date:   Fri, 22 Mar 2002 06:43:23 -0800 


I have some past experience with MUMPS - Run like h@#$ and don't look back.

If CACHE=MUMPS it most definitely is false advertising.



Scott Shafer

San Antonio, TX

210-581-6217



"Common sense will not accomplish great things. Simply become insane and

desperate."



> -Original Message-

> From: Norrell, Brian [SMTP:[EMAIL PROTECTED]]

> Sent: Thursday, March 21, 2002 7:23 PM

> To:   Multiple recipients of list ORACLE-L

> Subject:  RE: RE: Intersystems Cache database

> 

> "Hospital" is the key.  Cache was originally developed in the '70 for

> use in medical applications, of course, back then it was known as MUMPS

> before the PR guys got a hold of it.  The UNIX types will tell you that

> any app that has been around for three decades has to have something

> going for it.

> 

> Some of the DBAs around hear played with it, and were not impressed.

> Apparently recovery in the event of any failure was a nightmare.

> 

> -Original Message-

> Sent: Thursday, March 21, 2002 5:14 PM

> To: Multiple recipients of list ORACLE-L

> 

> 

> I've heard of them...  Some guys at the last place I was at had used it

> as

> the back end for a lab results viewer at a hospital in the Boston

> area...

> They loved it...  They kept telling me how great it was but I never saw

> it

> in action...  I took most of it with a grain of salt since they were

> developers...  

> 

> As far as the 4 million users go...  If you consider each hospital

> employee

> a "user"...  Of better yet, each patient a "user"...

> 

> :-)

> 

> -Original Message-

> Sent: Thursday, March 21, 2002 5:19 PM

> To: Multiple recipients of list ORACLE-L

> 

> 

> Anyone else ever hear about them?  According to the web site that have

> '4

> million users'.  Seems that would have left a mark somewhere at that

> level.

> 

> Dick Goulet

> 

> Reply Separator

> Author: "Jesse; Rich" < [EMAIL PROTECTED]
 >

> Date:   3/21/2002 1:58 PM

> 

> Yeah, like that ain't a plug from someone acting like an Oracle DBA.

> 

> 1)  No signature.

> 2)  Generic e-mail account from a generic mail domain.

> 3)  No recent posts to this list.

> 

> Probably just a Cache salesman...

> 

> Rich Jesse   System/Database Administrator

>  [EMAIL PROTECTED] 
Quad/Tech International, 

Sussex, WI

> USA

> 

> 

> -Original Message-

> Sent: Thursday, March 21, 2002 3:23 PM

> To: Multiple recipients of list ORACLE-L

> 

> 

> Hi,

> 

> Does anyone know about the Cache database?  Is it REALLY that

> robust as they claim to be?

> 

>  http://cache.intersys.com/cache/fb/fb_03.html
 

> 

> Thanks.

> -- 

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

> -- 

> Author: Jesse, Rich

>   INET:  [EMAIL PROTECTED]  

> 

> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051

> San Diego, California-- Public Internet access / Mailing Lists

> 

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

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

in

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

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

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

> -- 

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

> -- 

> Author: 

>   INET:  [EMAIL PROTECTED]  

> 

> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051

> San Diego, California-- Public Internet access / Mailing Lists

> 

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

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

in

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

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

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

> -- 

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

> -- 

> Author: Johnston, Tim

BHR 100% -- we're perfect!

[Baker, Barbara]

> Look.  Our buffer hit ratio is 100%!
> 
> DATE: August 13, 2002  Buffer Cache Ratio for  AMDEV
> 
>LOGICAL_READS PHYSICAL_READS  HIT_RATIO
>  -- --
>1,919,442,737564,223100
> 
> ('course, the fact that a single sql statement did nearly 2 billion
> logical reads isn't important.  What's important is that it did it all
> from memory!!!)
> 
>From Tim Gorman's TOP_STMT:

Date: 08/13/02 08:48:24Page1
Database startup: 08/07/02 23:52:23
First load time:  2002-08-12/16:53:15
.
SQL Statement Text
--
0 SELECT /*+ INDEX(CDT PK_CDT) */  ROWID,CDT_KEY,REC_TYPE,CATEGORY
1 ,NEW_CATEGORY,LST_TRANS,OPEN_BF,CUST_TELE_AREA,CUST_TELE_EXCHANG
2 E,CUST_TELE_LOCAL,CUST_TELE_EXT,RISK_CODE,DUNN_BRAD_RATING,BILL_
...

: Disk Buffer  Load
: Reads  Gets SortsRuns Loads
Factor
: --- - -
--
:   164,600 1,901,376,073 0 103,929 2
1917836.1
: (29.174%) (99.722%)

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

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

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

RE: Oracle9i Installation Error

[Vergara, Michael (TEM)]

I haven't started playing with 9i yet, but this message 
sounds
like a message from one of the optional components.  I 
usually
get something like this when I'm applying a patch and 
the
patched component does not exist.
 
Ah HA!  I checked one of my more obscure systems and found 
that
the 'ctx' option is the 'Intermedia Text' 
option.  It sounds 
like this product is not entirely installed, or is 
installed 
incorrectly.
 
If you need it, re-install.  If not, just skip over this 
error
and continue your install.
 
Good Luck!
Mike
 

  -Original Message-From: [EMAIL PROTECTED] 
  [mailto:[EMAIL PROTECTED]]Sent: Tuesday, August 13, 2002 
  8:35 AMTo: Multiple recipients of list ORACLE-LSubject: 
  Oracle9i Installation ErrorHello All, We are trying to 
  install Oracle9i on HP-UX and getting following message:   Error in invoking target install of 
  makefile:     
  /oracle/product/9.0.1/ctx/lib/ins_ctx.mk I have looked through metalink but could not find anything satisfying. 
  I would like to hear from someone who has an idea about overcoming this 
  error. Regards. 
  M.Emre HANCIOGLUMasterfoods 
  Services GmbHISI Application SupportTel : +49 2162 500-576Fax: +49 
  2162 41497E-Mail: 
[EMAIL PROTECTED]

RE: Dba tools on NT

[Bishop Lewis]

Without a doubt - perl - get it free from www.activestate.com. Why use it?
Well, it is so flexible compared to other NT/DOS scripting tools you'll
wonder why you never had it before! It's also portable meaning all those
scripts you write should work on multi platforms with just a little tweak!

Lewis Bishop
---
Barclays Enable/ISS/OPTS - Oracle OCP Database Consultant
Phone - 020 8298 3418
Mobile - 07950 380857
Email - [EMAIL PROTECTED]


-Original Message-
Sent: 13 August 2002 17:25
To: Multiple recipients of list ORACLE-L

This header confirms that this email message has been swept for the
presence of computer viruses. 

Corporate IT
THE WOOLWICH
--

Hello all

We are looking on programming and scripting tools
 for DBA team on NT.

Can you, oracle DBA's on NT, tell me off the list 
what tools you are using for these functions 
and, if you be so kind, why you choose them.

TIA

Yechiel Adar
Mehish

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

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

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


The information, attachments and opinions contained in this message are those of its 
author only and do not necessarily represent those of The Woolwich and or any other 
members of the Barclays Group and are intended solely for the use of the individual or 
entity to whom they are addressed. The sender may not be authorised to give financial 
advice, and nothing in this message should be construed as offering such advice.

The message may contain privileged and confidential information and you may not copy, 
distribute or take any action in reliance on it. If you have received this email in 
error please notify the Information Security Manager at [EMAIL PROTECTED]

Replies to this email may be monitored for operational or business reasons.

Woolwich plc. Registered in England Number : 3295699.

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

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

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

RE: Cache' Database

[Ji, Richard]

Title: Cache' Database



Ivan,
 
Please 
search the archive of this list.  I have post a question about cache 
before and got some
good 
replies.
 
Richard

  -Original Message-From: [EMAIL PROTECTED] 
  [mailto:[EMAIL PROTECTED]]Sent: Tuesday, August 13, 2002 
  11:59 AMTo: Multiple recipients of list ORACLE-LSubject: 
  Cache' Database
  Hello all, 
  I am getting a new contract that will be dealing solely with 
  cache database management.  Does anyone out there have any experiences 
  with cache that they wouldn't mind sharing?  Pro's and con's, good 
  stories, horror stories anything and everything is welcomed. I'd like to see 
  what other oracle dba's have thought about it. I also would like to know if 
  there are any list groups like this for Cache and/or any good websites besides 
  the intersystems site? Thank you all very much. 
Ivan

RE: T3's, NetApps, Tuning, Wife's Opinion and other fun

[Cary Millsap]

Some questions and a couple of comments regarding Dave's note:

1. RE the "tuning from a blue collar DBA perspective," is it accurate to
paraphrase the described method as: "No matter what might be causing the
performance problem, check this List Of Things first, using tools that
vary significantly from one platform to the next." ?

2. Dave is multiplying Oracle's time statistics by 1/1000 (wrong)
instead of 1/100 (correct). Oracle is really reporting 'db file
sequential read' average latencies of .311cs = 0.003s (not 0.0003s), 'db
file scattered read' latencies of .506cs = 0.005s (not 0.0005s), 'db
file parallel write' latencies of 3.036cs = 0.030s (not 0.003s), and so
on. (Dave's I/O subsystem has consumed an average of 30ms for each 'db
file parallel write' call.)

3. Note that it's only because the data are collected system-wide that
it is necessary to ignore the 'SQL*Net%' events. This is a waste,
though, because with properly time-scoped session-level data, the
'SQL*Net%' events constitute probably the easiest way to detect when you
have bad applications code (not the SQL, but the stuff that calls the
SQL).

4. 'db file sequential read' does *not* typically indicate a full-table
scan, because 'db file sequential read' events, since Oracle8.0 are
almost always single-block read calls (before that, the event could
indicate multi-blocks reads of sort segment blocks into a PGA).

5. 'LGWR wait for redo copy' is *not* affected by the archiver not
keeping up. The alert log *is* a better way to detect this (because
'LGWR wait for redo copy' doesn't detect it at all). An even better way
is to look for occurrences of 'log file switch (archiving needed)'.

6. 'latch free' -- Question: Does anybody know what "total_timeouts"
means for the 'latch free' event? I see nothing in v$latch that possibly
corresponds to something that could be called a "timeout." And nothing
in either algorithm that Oracle uses to acquire a latch makes any sense
to call a "timeout." (The two algorithms Oracle uses that I know about
are the spinning algorithm, and the latch wait posting algorithm.)
Consequently, I'm having a hard time coming up with what a high or low
rate of timeout/waits might mean. Thanks...


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

Upcoming events:
- Hotsos Clinic, Oct 1-3 San Francisco, Oct 15-17 Dallas, Dec 9-11
Honolulu
- 2003 Hotsos Symposium on OracleR System Performance, Feb 9-12 Dallas
- Next event: NCOAUG Training Day, Aug 16 Chicago



-Original Message-
Morgan
Sent: Monday, August 12, 2002 9:53 PM
To: Multiple recipients of list ORACLE-L

Hi All,
Well after 6 wekks of testing here is the basic way
to operate SUN T3's  as efficiently as possible.

Be prepared for arguments with High priests from the cult of
SAME.

SUN T3's are fiber attached hardware RAID 5 arrays with
a "modern cache". The hardware engineers argue that if you need
more
I/Os/sec just add another array as a "concatenated volume". The
theory
being the hardware is intelligent enough to use the cache to
increase 
throughput. It actually works as they claim. Never did explain
why
it wasn't a single point of failure in the end though.

My hardware was 3 4810's, each with 4 - 8 cpus, each with 4 -
8GB, 
2 - 4 bricks per machine
 
First insist that multiple bricks be mounted on at least 2 mount
points.
(D2 and D3). DO NOT USE the forcedirectio option. I don't know
why but 
I have been unable to take less than a 40% throughput hit with
it
turned on. And I don't care what other people say, no matter how

much respect I have for them

Insist on at least one JBOD for oracle binaries and configs
Insist on at least one JBOD for redo logs (D1)

This a bare minimum. 

One set of redo on D1
One set of redo on D2
Archive logs, Rollback and Temp on D3
All data files where needed on D2


Next Level up

Add another JBOD for redo and move redo on to it
Move Rollback and Temp to D2

At this point to get more throughput you have to take the
JBOD to raw devices. Or try forcedirectio on these devices :)

If even better performance is needed, more JBOD, for rollback
and redo.
If more disk spaces is needed, get another brick.

Which leads me to the recent discussion on "proper way to tune"

Huh? Why make it so complex?

Tuning from a blue collar DBA perspective:

Assess the machine first

No matter what your ratios or what your waiting for:

sar to see if the machine is ever pinned
vmstat to see your queues and paging 
iostat to see disk activity
top at timed intervals to catch rogue jobs

read your logs and config files

Then talk to the users
Is the "system slow" or is it specific jobs?"

log on 

Re: It took more than an hour to update 10,000 records

[Steven Lembark]

-- "Nguyen, David M" <[EMAIL PROTECTED]>

> Hi all,
>
> I write a script to update 10,000 records in my database and noticed it
> took more than an hour to update 10,000 records.  The script just
> includes 10,000 SQL update commands as shown below.  Is the time too long
> to update 10,000 records?  Is it a way to improve the update task to run
> faster.  Please advise.
>
> *** A portion of my update script is shown below:
>
> update dbimpl.npa_nxx set ported_flag = 1 where nxx_id = 206 and npa_id =
> 201 and lata_id = 224;
>
> update dbimpl.npa_nxx set ported_flag = 1 where nxx_id = 207 and npa_id =
> 201 and lata_id = 224;

If the table is 15TB it might actually be rather fast;
might also be really good if the database were being
restored at the time. Lacking any other info there is
no way to tell.

Have you tried generating an explain plan for one of them?
Does the seem reasonable to you?

How about using a language that supports place holders
(e.g., DBI) or turning on cursor sharing so that the
optimizer isn't called for each iteration?

--
Steven Lembark   2930 W. Palmer
Workhorse Computing   Chicago, IL 60647
+1 800 762 1582
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Steven Lembark
  INET: [EMAIL PROTECTED]

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

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

Who is using a table?

[Yechiel Adar]

When a developer wants to change a table it helps if
we know who is using it. Sometimes there are applications
that use tables that belong to other applications
and nobody remembers. Than we change the table
and KABOOM 
(as expressed by the Martian that
Bugs Bunny fought and of course according 
to the application people
an earth shuttering KABOOM :-) ).

We need idea how to do it. We thought about auditing
of writing a trigger that will log each access to the
table but we fear the overhead.

Any suggestions, ideas, whatever are welcome.

TIA

Yechiel Adar
Mehish

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

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

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