RE: SQL puzzle - using where (a, b, c) in select (a, b, c from...

2002-11-18 Thread Nirmal Kumar Muthu Kumaran 
Title: SQL puzzle - using where (a, b, c) in select (a, b, c from...) and columns can be null



SQL> edWrote file 
afiedt.buf
 
  1  select * from 
widgets_copy  2* order by 1,2,3SQL> /
 
    
ID   COST   
SELL-- -- 
-- 
1 
10 
20 
1 
10 
20 
1 
10 
30 
1 
10 
30 
1 
10 
1 
10 
1 1
 
8 rows selected.
 
SQL> delete widgets_copy where 
rowid not in (select min(rowid)  2  from widgets_copy group by id, 
cost,sell);
 
4 rows deleted.
 
SQL> select * from 
widgets_copy  2  order by 1,2,3  3  /
 
    
ID   COST   
SELL-- -- 
-- 
1 
10 
20 
1 
10 
30 
1 
10 1
 
SQL> 
 
HTH,
Rgds,
Nirmal.

  -Original Message-From: Jacques Kilchoer 
  [mailto:[EMAIL PROTECTED]]Sent: Tuesday, November 19, 2002 
  6:04 AMTo: Multiple recipients of list ORACLE-LSubject: 
  SQL puzzle - using where (a, b, c) in select (a, b, c from...) 
  an
  Maybe there is a simple solution, but I'm too tired to think 
  of one now. 
  I have two tables, widgets and widgets_copy. Each table has 
  columns that can contain null values. 
  SQL> select id, cost, sell from widgets order by 1, 2, 3 
  ; 
     
  ID  COST  
  SELL - - -     
  1    
  10    20     
  1    10     1 
  SQL> select 'ROW' || to_char (rownum) as row_num, 
    2 id, 
  cost, sell   3  from widgets_copy 
    4  order by 2, 3, 4 ; 
  ROW_NUM   
  ID  COST  
  SELL -- - - - 
  ROW3   
  1    
  10    20 ROW6   
  1    
  10    20 ROW7   
  1    
  10    30 ROW8   
  1    
  10    30 ROW2   
  1    10 ROW5   
  1    10 ROW1   
  1 ROW4   
  1 
  SQL> 
  I want to delete from widgets_copy all duplicates of rows that 
  are present in widgets. Meaning I want to - delete either ROW3 or ROW6 from 
  widgets_copy, since (1, 10, 20) is also in widgets;
  - delete either ROW2 or ROW5 from widgets_copy, since (1, 10, 
  null) is also in widgets; - and delete either ROW1 or 
  ROW4 from widgets_copy, since (1, null, null) is also in widgets. 
  The statement below will only delete ROW3 or ROW6 from 
  widgets_copy. The "where (id, cost, sell) in (select 
  id, cost, sell ..." only works when the columns do not contain nulls. 
  
  -- only works when none of the columns are null 
  delete from widgets_copy where rowid 
  in  (   select min 
  (rowid) from widgets_copy x   where (x.id, 
  x.cost, x.sell) in    (select y.id, y.cost, 
  y.sell from widgets y)   group by x.id, x.cost, 
  x.sell  ) ; 
  How can I write my statement? a) I 
  don't want to use nvl because this is supposed to be a general purpose 
  solution, and I don't know what the possible values can be in the 
  table.
  b) I could do several deletes, considering cases (a, b, c) not 
  null, only a is null, only b is null, etc... but that would be hard to 
  generalize to a case of a table with 4, 5 or more columns.
  P.S. SQL to build the sample test case: create table widgets   (id number, cost 
  number, sell number) ; insert into widgets (id, cost, 
  sell)  values (1, null, null) ; insert into widgets (id, cost, sell)  values (1, 10, null) ; insert into 
  widgets (id, cost, sell)  values (1, 10, 20) 
  ; create table widgets_copy  as select * from widgets ; insert into 
  widgets_copy select * from widgets_copy ; insert into 
  widgets_copy (id, cost, sell)   values (1, 10, 
  30) ; insert into widgets_copy (id, cost, sell) 
    values (1, 10, 30) ; commit 
  ;

RE: SQL puzzle - using where (a, b, c) in select (a, b, c from...) an

2002-11-18 Thread Naveen Nahata 
Title: SQL puzzle - using where (a, b, c) in select (a, b, c from...) and columns can be null



Since Id, Cost and Sell are all NUMBERs, so they cannot 
contain CHARs, which makes a perfect case for decode. You can use CHARs to 
substitute for NULLs in DECODE.
 
Following is the query I wrote:
 
DELETE FROM Widgets_Copy aWHERE (DECODE(a.Id, NULL, 'X', a.Id), DECODE(a.Cost, 
NULL, 'X', a.Cost), DECODE(a.Sell, NULL, 'X', a.Sell)) 
IN
( 

    
SELECT DECODE(b.Id, NULL, 
'X', b.Id), DECODE(b.Cost, NULL, 'X', b.Cost), DECODE(b.Sell, NULL, 'X', b.Sell) 

    
FROM Widgets 
b
    )AND a.Rowid !=(
    
SELECT MIN(c.Rowid) FROM Widgets_Copy c 
    
WHERE (    
DECODE(c.Id, NULL, 'X', c.Id), 
    
DECODE(c.Cost, NULL, 
'X', c.Cost), 

    
DECODE(c.Sell, NULL, 
'X', c.Sell)
    
) IN    
( SELECT DECODE(d.Id, NULL, 'X', d.Id), 
 
DECODE(d.Cost, NULL, 
'X', d.Cost), 

 
DECODE(d.Sell, NULL, 
'X', d.Sell) FROM Widgets d)AND 
DECODE(c.Id, NULL, 'X', c.Id) = DECODE(a.Id, NULL, 'X', a.Id)    
AND DECODE(c.Cost, NULL, 
'X', c.Cost) = DECODE(a.Cost, NULL, 'X', a.Cost)
AND 
DECODE(c.Sell, NULL, 'X', c.Sell) = DECODE(a.Sell, NULL, 'X', a.Sell)    
);
 
SQL> select id, cost, sell from widgets order by 1, 
2, 3 ; 
 
    
ID   COST   
SELL-- -- 
-- 
1 
10 
20 
1 
10 
1
 
SQL> select 'ROW' || to_char (rownum) as 
row_num,  2   
id, cost, sell  3    from widgets_copy  
4    order by 2, 3, 4  5  
/
 
ROW_NUM 
ID   COST   
SELL--- -- -- 
--ROW3 
1 
10 
20ROW6 
1 
10 
20ROW7 
1 
10 
30ROW8 
1 
10 
30ROW2 
1 
10ROW5 
1 
10ROW1 
1ROW4 
1
 
8 rows selected.
 
SQL> DELETE FROM Widgets_Copy a  2  
WHERE (DECODE(a.Id, NULL, 'X', a.Id), DECODE(a.Cost, NULL, 'X', a.Cost), 
DECODE(a.Sell, NULL, 'X', a.Sell)) IN  3  
(   4  SELECT 
DECODE(b.Id, NULL, 'X', b.Id), DECODE(b.Cost, NULL, 'X', b.Cost), DECODE(b.Sell, 
NULL, 'X', b.Sell)   
5  FROM Widgets b  
6  )  7  AND a.Rowid 
!=    (  
8  
SELECT MIN(c.Rowid) FROM Widgets_Copy c   
9  
WHERE (    DECODE(c.Id, NULL, 'X', c.Id), 
 10  
DECODE(c.Cost, NULL, 'X', c.Cost), 
 11  
DECODE(c.Sell, NULL, 'X', 
c.Sell) 12  
) 
IN 13  
( SELECT DECODE(d.Id, NULL, 'X', d.Id), 
 14   
DECODE(d.Cost, NULL, 'X', d.Cost), 
 15   
DECODE(d.Sell, NULL, 'X', d.Sell) FROM Widgets 
d) 16  
AND DECODE(c.Id, NULL, 'X', c.Id) = DECODE(a.Id, NULL, 'X', 
a.Id) 17  
AND DECODE(c.Cost, NULL, 'X', c.Cost) = DECODE(a.Cost, NULL, 'X', 
a.Cost) 18  
AND DECODE(c.Sell, NULL, 'X', c.Sell) = DECODE(a.Sell, NULL, 'X', 
a.Sell) 19  
);
 
3 rows deleted.
 
SQL> select 'ROW' || to_char (rownum) as 
row_num,  2   
id, cost, sell  3    from widgets_copy  
4    order by 2, 3, 4  5  
/
 
ROW_NUM 
ID   COST   
SELL--- -- -- 
--ROW3 
1 
10 
20ROW4 
1 
10 
30ROW5 
1 
10 
30ROW2 
1 
10ROW1 
1
 
SQL> 
 
Regards
Naveen

RE: sys.aud$ - auditing user activities? - follow up

2002-11-18 Thread Dana . Mueller 
Tim / All.

I figured it out.

Basically assign users SYSDBA privies and track accordingly. 

-Original Message-
Sent: Monday, November 18, 2002 7:44 PM
To: Multiple recipients of list ORACLE-L


please be a little more specific?  what exactly is it that oracle won't do?

- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Monday, November 18, 2002 7:58 PM


> Tim - Thanks for the well worded response.  Very, very helpful.
>
> So my next question:  Are there any 3rd party applications available to do
> what Oracle won't?
>
> -Original Message-
> Sent: Monday, November 18, 2002 4:29 PM
> To: Multiple recipients of list ORACLE-L
>
>
> SYSDBA activities are not logged to the SYS.AUD$ table, even in Oracle9i
> with the AUDIT_SYS_OPERATIONS parameter set to TRUE.  SYSDBA operations
are
> always logged to the OS audit trail, including access/modifications to the
> SYS.AUD$ table...
>
> The reason that these records are only logged to the audit trail (previous
> to Oracle9i, only connections as SYSDBA were logged) is because that is
the
> only way to protect the audit records review and (especially!) alteration
> from people with SYSDBA privilege.  Someone with SYSDBA could alway muck
> with the contents of the SYS.AUD$ table, but they would not necessarily
have
> OS permissions to alter the audit records sent to the OS.
>
> ..which is why the command CONNECT INTERNAL went away with Oracle9i, to
> remove the last necessity for DBAs to be members of the OSDBA and OSOPER
> groups in the OS.  Now, with 9i and CONNECT ... AS SYSDBA commands, you
can
> "lock down" the OS account and account-group that owns the Oracle software
> away from those with SYSDBA privileges, thus protecting the software
> distribution files, log files, trace files, and audit files from casual
> modification, if desired...
>
> - Original Message -
> To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
> Sent: Monday, November 18, 2002 12:46 PM
>
>
> > Hello All,
> >
> > Do any of you have suggestions for a good way to monitor sysdba user
> > activities on the sys.aud$ table?  Or, in terms of logging everything,
> what
> > would be the keypoints to log scrub on?
> >
> > Any suggestions would be wonderful.
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author:
> >   INET: [EMAIL PROTECTED]
> >
> > Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> > San Diego, California-- Mailing list and web hosting services
> > -
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from).  You may
> > also send the HELP command for other information (like subscribing).
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Tim Gorman
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (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 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (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 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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 O

How to compile Java code Pro*Cobol.

2002-11-18 Thread M Ramesh Indonet -hyd 

Dear Friends,


How to compile Java and Pro*Cobol from Windows flot form.

thanks






*
*
 +++
*+M Ramesh +
* Indonet  
*  +++CMC.Ltd  +++
*   ++PH. 040-4751169  ++
*+4750371-6,ext: 251-4 +
* ++
*

**


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

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

SUMMARY: SQL*Net Message to client/SQL*Net more data to client

2002-11-18 Thread Stephen Andert 
Well, I thought I'd let everyone know what we came up with.

First of all many thanks to all who helped,  Cary, Jared, Dennis, Anjo
and others.  Everyone gave me more ammo to point the finger outside the
database and some of the suggestions started a better dialogue between
our different groups here.

The best information I got was from Cary and company at hotsos.com who
helped me see how to effectively use a 10046 trace file.  The slowest
job we had (that was impacting us the most) had a 1-1 parse to execute
ratio and had nearly 90% of the trace time spent in SQL*Net wait. 
Simply by improving the parse to execute ratio, we should eliminate
close to half of the waiting time.  

We did some research into why the application was parsing once per
execute and convinced the developers to use the HOLD_CURSORS parameter
in the Pro*C compilation.  (I had asked a few months before and they
said "no need").  Some of the programs worked without a problem, but
others had problems due to attempting to reuse "implicit cursors".  They
are investigating that further and changed it where possible.  

We also turned on a second nic and changed the tnsnames.ora to use that
nic for this db.  

Those actions together returned us to a reasonable performance, though
I still feel that further work on the appdev side is needed to make
significant performance improvements.

Thanks again to all.

Stephen

>>> [EMAIL PROTECTED] 10/30/02 08:14AM >>>

For what it's worth, we had the same thing going on here recently and
have
not resolved it.  In our case, it is a visual basic app running what
is
essentially a batch job (don't ask me why a batch job was written as a
VB
app; I just work here).  The client is a PC, and the database is on
Tru64
(again ... I just work here).  Three different PC's were tried.  It
appears
that the tcp_nodelay parameter worked on two of them but not the third
(which, as you might guess, is the production box and the one on which
it
NEEDS to run faster ... Of course!).  All the PC's are on the same
subnet,
going through same routers to get to the same database.

If you get the problem resolved, I will be most interested in your
solution.
Thus far, we have only been able to attribute it either to sunspots or
something about the W2K OS on the PC ... both of which, as we all know,
are
responsible for a lot of unexplained behavior.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com 
-- 
Author: Stephen Lee
  INET: [EMAIL PROTECTED] 

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

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

Re: sys.aud$ - auditing user activities? - follow up

2002-11-18 Thread Tim Gorman 
please be a little more specific?  what exactly is it that oracle won't do?

- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Monday, November 18, 2002 7:58 PM


> Tim - Thanks for the well worded response.  Very, very helpful.
>
> So my next question:  Are there any 3rd party applications available to do
> what Oracle won't?
>
> -Original Message-
> Sent: Monday, November 18, 2002 4:29 PM
> To: Multiple recipients of list ORACLE-L
>
>
> SYSDBA activities are not logged to the SYS.AUD$ table, even in Oracle9i
> with the AUDIT_SYS_OPERATIONS parameter set to TRUE.  SYSDBA operations
are
> always logged to the OS audit trail, including access/modifications to the
> SYS.AUD$ table...
>
> The reason that these records are only logged to the audit trail (previous
> to Oracle9i, only connections as SYSDBA were logged) is because that is
the
> only way to protect the audit records review and (especially!) alteration
> from people with SYSDBA privilege.  Someone with SYSDBA could alway muck
> with the contents of the SYS.AUD$ table, but they would not necessarily
have
> OS permissions to alter the audit records sent to the OS.
>
> ..which is why the command CONNECT INTERNAL went away with Oracle9i, to
> remove the last necessity for DBAs to be members of the OSDBA and OSOPER
> groups in the OS.  Now, with 9i and CONNECT ... AS SYSDBA commands, you
can
> "lock down" the OS account and account-group that owns the Oracle software
> away from those with SYSDBA privileges, thus protecting the software
> distribution files, log files, trace files, and audit files from casual
> modification, if desired...
>
> - Original Message -
> To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
> Sent: Monday, November 18, 2002 12:46 PM
>
>
> > Hello All,
> >
> > Do any of you have suggestions for a good way to monitor sysdba user
> > activities on the sys.aud$ table?  Or, in terms of logging everything,
> what
> > would be the keypoints to log scrub on?
> >
> > Any suggestions would be wonderful.
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author:
> >   INET: [EMAIL PROTECTED]
> >
> > Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> > San Diego, California-- Mailing list and web hosting services
> > -
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from).  You may
> > also send the HELP command for other information (like subscribing).
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Tim Gorman
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (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 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (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 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Cognos Reporting Tool

2002-11-18 Thread paquette stephane 
On DW project, we have used Cognos Impromptu and
Powerplay tool in 1998-1999. We used the client-server
version as Powerplay for the web was a tool bought
from another company and was not quite integrated with
the other Cognos products. 

The main drawback were that the Powerplay part to
build the cubes was not scaling when using a multi-cpu
box. There was no framework to guide the end-users
with all the cubes we were producing. We had to
develop one. Beside that, Cognos offer good products.

In 2001-2002, when working at a different client, the
team selecting the reporting tool for the
datawarehouse choose Business Objects saying that
Cognos did not even make it to the short list. The
runner-up was Brio 

 --- Rodd Holman <[EMAIL PROTECTED]> a écrit : >
Good afternoon listers.
> I just found out that I will be meeting with the
> sales "dog and pony"
> folks from Cognos on Tuesday.  Have any of you
> worked with this
> product?  What should I be aware of?  What
> plusses/minuses should I look
> for?  Any suggestions would be welcome.
> 
> Thanks
> 
> Rodd Holman
> 
> 
> -- 
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> -- 
> Author: Rodd Holman
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051
> http://www.fatcity.com
> San Diego, California-- Mailing list and web
> hosting services
>
-
> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of
> 'ListGuru') and in
> the message BODY, include a line containing: UNSUB
> ORACLE-L
> (or the name of mailing list you want to be removed
> from).  You may
> also send the HELP command for other information
> (like subscribing). 

=
Stéphane Paquette
DBA Oracle et DB2, consultant entrepôt de données
Oracle and DB2 DBA, datawarehouse consultant
[EMAIL PROTECTED]

__
Lèche-vitrine ou lèche-écran ?
magasinage.yahoo.ca
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: =?iso-8859-1?q?paquette=20stephane?=
  INET: [EMAIL PROTECTED]

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

2002-11-18 Thread Dana . Mueller 
Tim - Thanks for the well worded response.  Very, very helpful.

So my next question:  Are there any 3rd party applications available to do
what Oracle won't?

-Original Message-
Sent: Monday, November 18, 2002 4:29 PM
To: Multiple recipients of list ORACLE-L


SYSDBA activities are not logged to the SYS.AUD$ table, even in Oracle9i
with the AUDIT_SYS_OPERATIONS parameter set to TRUE.  SYSDBA operations are
always logged to the OS audit trail, including access/modifications to the
SYS.AUD$ table...

The reason that these records are only logged to the audit trail (previous
to Oracle9i, only connections as SYSDBA were logged) is because that is the
only way to protect the audit records review and (especially!) alteration
from people with SYSDBA privilege.  Someone with SYSDBA could alway muck
with the contents of the SYS.AUD$ table, but they would not necessarily have
OS permissions to alter the audit records sent to the OS.

...which is why the command CONNECT INTERNAL went away with Oracle9i, to
remove the last necessity for DBAs to be members of the OSDBA and OSOPER
groups in the OS.  Now, with 9i and CONNECT ... AS SYSDBA commands, you can
"lock down" the OS account and account-group that owns the Oracle software
away from those with SYSDBA privileges, thus protecting the software
distribution files, log files, trace files, and audit files from casual
modification, if desired...

- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Monday, November 18, 2002 12:46 PM


> Hello All,
>
> Do any of you have suggestions for a good way to monitor sysdba user
> activities on the sys.aud$ table?  Or, in terms of logging everything,
what
> would be the keypoints to log scrub on?
>
> Any suggestions would be wonderful.
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author:
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).

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

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

SQL puzzle - using where (a, b, c) in select (a, b, c from...) an

2002-11-18 Thread Jacques Kilchoer 
Title: SQL puzzle - using where (a, b, c) in select (a, b, c from...) and columns can be null





Maybe there is a simple solution, but I'm too tired to think of one now.


I have two tables, widgets and widgets_copy. Each table has columns that can contain null values.


SQL> select id, cost, sell from widgets order by 1, 2, 3 ;


   ID  COST  SELL
- - -
    1    10    20
    1    10
    1


SQL> select 'ROW' || to_char (rownum) as row_num,
  2 id, cost, sell
  3  from widgets_copy
  4  order by 2, 3, 4 ;


ROW_NUM   ID  COST  SELL
-- - - -
ROW3   1    10    20
ROW6   1    10    20
ROW7   1    10    30
ROW8   1    10    30
ROW2   1    10
ROW5   1    10
ROW1   1
ROW4   1


SQL> 


I want to delete from widgets_copy all duplicates of rows that are present in widgets. Meaning I want to - delete either ROW3 or ROW6 from widgets_copy, since (1, 10, 20) is also in widgets;

- delete either ROW2 or ROW5 from widgets_copy, since (1, 10, null) is also in widgets;
- and delete either ROW1 or ROW4 from widgets_copy, since (1, null, null) is also in widgets.


The statement below will only delete ROW3 or ROW6 from widgets_copy.
The "where (id, cost, sell) in (select id, cost, sell ..." only works when the columns do not contain nulls.


-- only works when none of the columns are null
delete from widgets_copy
where rowid in
 (
  select min (rowid) from widgets_copy x
  where (x.id, x.cost, x.sell) in
   (select y.id, y.cost, y.sell from widgets y)
  group by x.id, x.cost, x.sell
 ) ;


How can I write my statement?
a) I don't want to use nvl because this is supposed to be a general purpose solution, and I don't know what the possible values can be in the table.

b) I could do several deletes, considering cases (a, b, c) not null, only a is null, only b is null, etc... but that would be hard to generalize to a case of a table with 4, 5 or more columns.

P.S. SQL to build the sample test case:
create table widgets
  (id number, cost number, sell number) ;
insert into widgets (id, cost, sell)
 values (1, null, null) ;
insert into widgets (id, cost, sell)
 values (1, 10, null) ;
insert into widgets (id, cost, sell)
 values (1, 10, 20) ;
create table widgets_copy
 as select * from widgets ;
insert into widgets_copy select * from widgets_copy ;
insert into widgets_copy (id, cost, sell)
  values (1, 10, 30) ;
insert into widgets_copy (id, cost, sell)
  values (1, 10, 30) ;
commit ;

RE: raw versus Mounted File Systems

2002-11-18 Thread VIVEK_SHARMA 

I have framed a Basic Doc on RAW Versus CFS , Mounted FS 

I will send it directly to any who seek it for review , perusal .

Thanks to all who helped in making the same 

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

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

Re[2]:RE: New development in Cobol or PL/SQL - please help

2002-11-18 Thread dgoulet 
Gene,

Well at least I'm not the only one who got tossed out of the frypan into the
fire!!

Dick Goulet

Reply Separator
Author: "Gene Sais" <[EMAIL PROTECTED]>
Date:   11/18/2002 7:27 AM

I disagree with your last statement.  Since IBM purchased informix, we are in
battle with their so-called concurrent licensing ripoff. 

>>> [EMAIL PROTECTED] 11/17/02 09:43PM >>>
Ron,

Thankyou, I appreciate it.  And for the individual who proposed that it
might be better to do it in Pro*Cobol for database independence.  We have had
the thought of dumping Oracle for it's DB/2 competitor, until we found out that
DB/2 was no cheaper than Oracle in the end run.  Probably the only benefit is
that IBM is more slack on enforcing their licenses.

Dick Goulet

Reply Separator
Author: Ron/Sarah Yount <[EMAIL PROTECTED]>
Date:   11/16/2002 2:53 PM

In the "for what it is worth" department:

In addition to Dick's comments (with which I agree)

Be careful how you approach this situation.  If you wish to succeed, it
may be key to let the powers that be know that you are not proposing
bleeding edge solutions, and that looking down the road towards total
cost of ownership and supporting the application, it may behoove them to
consider something more mainstream.

Nobody ever truly wins a discussion by starting an argument with someone
in a higher level of authority.

Perhaps you should inquire about the "why" of the decisions so you
understand the key issues to address to propose a better one.

Good Luck,

Yep, even technical decisions require us to exercise high levels of
diplomacy :-)

-Ron-

-Original Message-
[EMAIL PROTECTED] 
Sent: Saturday, November 16, 2002 3:13 PM
To: Multiple recipients of list ORACLE-L


Babette,

This is one of those "from this old turd to that old fart" messages.
I've been around Oracle since 1985 & I love it too.  But it sounds like
the director has a serious problem with new technology.  Doing anything
in COBOL today?  Even PeopleSoft is busy re-writing their code in C++.
Seesh his age is seriously showing.  Oracle already has an adapter to MQ
series, why re-invent the wheel when someone else has already done a
better job of it.  Then code the business logic in PL/SQL so that not
only can this application use it, but any other that comes around.  I
believe it's known as code reuse.  Another old term.  You might start
off by handing him a copy of Oracle 8i new features & functions.  BTW:
add a copy of the 9i edition as well.

Dick Goulet

Reply Separator
Author: "Babette Turner-Underwood" <[EMAIL PROTECTED]>
Date:   11/15/2002 2:24 PM

I just found out today that we have a major development initiative that
is starting and they are planning on using Pro*Cobol to develop the
application. (my head is still shaking in disbelief!!!)

So we will have a Java front-end, invoking MQ series that will go across
to the mainframe for MQ series to invoke Pro*Cobol programs that will
then do the processing (accessing data and doing calculations) and then
return data.

If anyone has been in this or a similar situation, please help. I need
some really good arguments as to why we should put the business logic
into PL/SQL instead of Pro*Cobol.

I understand the reason we are using Oracle is that the director has 15
years experience with it and loves it.  Aaargh!!!

thanks
Babette

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

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

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

Re: sys.aud$ - auditing user activities?

2002-11-18 Thread Tim Gorman 
SYSDBA activities are not logged to the SYS.AUD$ table, even in Oracle9i
with the AUDIT_SYS_OPERATIONS parameter set to TRUE.  SYSDBA operations are
always logged to the OS audit trail, including access/modifications to the
SYS.AUD$ table...

The reason that these records are only logged to the audit trail (previous
to Oracle9i, only connections as SYSDBA were logged) is because that is the
only way to protect the audit records review and (especially!) alteration
from people with SYSDBA privilege.  Someone with SYSDBA could alway muck
with the contents of the SYS.AUD$ table, but they would not necessarily have
OS permissions to alter the audit records sent to the OS.

...which is why the command CONNECT INTERNAL went away with Oracle9i, to
remove the last necessity for DBAs to be members of the OSDBA and OSOPER
groups in the OS.  Now, with 9i and CONNECT ... AS SYSDBA commands, you can
"lock down" the OS account and account-group that owns the Oracle software
away from those with SYSDBA privileges, thus protecting the software
distribution files, log files, trace files, and audit files from casual
modification, if desired...

- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Monday, November 18, 2002 12:46 PM


> Hello All,
>
> Do any of you have suggestions for a good way to monitor sysdba user
> activities on the sys.aud$ table?  Or, in terms of logging everything,
what
> would be the keypoints to log scrub on?
>
> Any suggestions would be wonderful.
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author:
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).

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

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

2002-11-18 Thread dgoulet 
Platform please??

Dick Goulet

Reply Separator
Author: "sultan" <[EMAIL PROTECTED]>
Date:   11/18/2002 3:53 AM

Hi,

How can I complie PRO*C code.Please

Thnks









Hi,
 
How can I complie PRO*C code.Please
 
Thnks
 

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

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

RE: How to make ORACLE Developer 6i understand ORACLE 8i client?

2002-11-18 Thread Sherman, Paul R. 
Hello,

Well, I believe that it just wants to use part of the Oracle 8.0.5 client,
and during the install, you can direct the 8.0.5 files to a non-invasive
folder. Having said that, you will have to modify your env path to put your
8i bin path ahead of the Designer bin path (unless of course, you like
having DOS sessions open up other DOS sessions if/when you execute anything
in DOS, and fun stuff like that). I went through this process about 3 months
ago, and did not have 8.0.5, but rather 8.1.7 client on my PC (NT 4.0), so
you should be able to do the same thing. I installed Designer to its own
drive. You prob. will need to copy your tnsnames.ora down to Net80/admin
under the Designer folder. I did not have to make any registry changes. Good
luck!

Thank you,

Paul Sherman
DBAElcom, Inc.
voice -  781-501-4143 (direct #)
fax-  781-278-8341 (secure)
email - [EMAIL PROTECTED]


-Original Message-
Sent: Monday, November 18, 2002 3:14 PM
To: Multiple recipients of list ORACLE-L



We used ORACLE developer 6i on PC.  The ORACLE Developer 6i use ORACLE 8.0.5

client.  We don't have ORACLE 8.0.5 client. Does their has way to make 
ORACLE Developer 6i connect through 8i client?


Thanks.




_
Tired of spam? Get advanced junk mail protection with MSN 8. 
http://join.msn.com/?page=features/junkmail

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

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

RE: how to download all the openworld documents?

2002-11-18 Thread Rachel Carmichael 
Oracle sets it up so that it's impossible to download them all.

and to be honest, when I went out to the site, and looked over the
Database presentations, I only WANTED a few of them. There are only so
many sales pitches I can read, I don't use RAC so I wanted none of the
RAC presentations (and just about half seemed to be RAC)

Be a grown-up, don't whine and download the ones you want. I don't
think Oracle even gives the attendees a CD with all the papers anymore.


--- April Wells <[EMAIL PROTECTED]> wrote:
> ditto.  Even one by one isn't bad if you didn't get to be there
> 
> April Wells
> Oracle DBA 
> Great spirits have always encountered violent opposition from
> mediocre minds
> -- Albert Einstein
> 
> 
> 
> -Original Message-
> Sent: Monday, November 18, 2002 2:49 PM
> To: Multiple recipients of list ORACLE-L
> 
> 
> Well, for myself, I'm glad to have ANY access. So thank you, Gillian,
> and no
> buts about it.
> 
> Dennis Williams
> DBA, 40%OCP
> Lifetouch, Inc.
> [EMAIL PROTECTED] 
> 
> 
> -Original Message-
> Sent: Monday, November 18, 2002 1:38 PM
> To: Multiple recipients of list ORACLE-L
> 
> 
> 
> Thank you, but what I want is download 'ALL' docuemnts NOT one by
> one.
> 
> 
> 
> 
> 
> >From: Gillian <[EMAIL PROTECTED]>
> >Reply-To: [EMAIL PROTECTED]
> >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> >Subject: Re: how to download all the openworld documents?
> >Date: Mon, 18 Nov 2002 10:18:30 -0800
> >
> >
> >Try this link:
>
>http://www.oracle.com/oracleworld/sanfrancisco/conference/ems_search.html
> >I went to openworld.oracle.com , and click my way through to get to
> the 
> >above link.
> >Gillian
> >  [EMAIL PROTECTED] wrote:
> > > Does their has way that can download (or purchase CD) all the
> ORACLE
> > > Openworld documents?
> >
> >Some of the presenters alluded to them being uploaded somewhere, but
> I
> >haven't found it. The presentations I saw, I simply emailed the
> presenter
> >to get a copy. You might try this.
> >
> >HTH,
> >Sean
> >
> >--
> >Please see the official ORACLE-L FAQ: http://www.orafaq.com
> >--
> >Author:
> >INET: [EMAIL PROTECTED]
> >
> >Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> >San Diego, California -- Mailing list and web hosting services
>
>-
> >To REMOVE yourself from this mailing list, send an E-Mail message
> >to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> >the message BODY, include a line containing: UNSUB ORACLE-L
> >(or the name of mailing list you want to be removed from). You may
> >also send the HELP command for other information (like subscribing).
> >
> >
> >-
> >Do you Yahoo!?
> >Yahoo! Web Hosting - Let the expert host your site
> 
> 
> _
> Help STOP SPAM with the new MSN 8 and get 2 months FREE*  
> http://join.msn.com/?page=features/junkmail
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: dist cash
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (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: DENNIS WILLIAMS
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> 
> begin 666 InterScan_Disclaimer.txt
> M5&AE(&EN9F]R;6%T:6]N(&-O;G1A:6YE9"!I;B!T:&ES(&-O;6UU;FEC871I
> M;VXL(&EN8VQU9&EN9R!A='1A8VAM96YT M96YT:6%L(&%N9"!F;W(@=&AE(&EN=&5N9&5D('5S92!O9B!T:&4@861D M2!A;'-O(&-O;G1A:6X@<')O<')I971A M:6-E('-E;G-I=&EV92P@;W(@;&5G86QL>2!P M:6]N+B!.;W1I8V4@:7,@:&5R96)Y(&=I=F5N('1H870@86YY(&1I M M:6YG(&]F('1H92!I;F9O2!A;GEO;F4@;W1H97(@=&AA;B!T
> M:&4@:6YT96YD960@ M86YD(&UA>2!B92!I;&QE9V%L+B!)9B!Y;W4@:&%V92!R96-E:79E9"!T:&ES
> M(&-O;6UU;FEC871I;VX@:6X@97)R;W(L('!L96%S92!N;W1I9GD@=&AE('-E
> M;F1E2!B>2!R97!L>2!E+6UA:6PL(&1E;&5T92!T:&ES
> M(&-O;6UU;FEC871I;VXL(&%N9"!D97-T M;W)P;W)A=&4@4WES=&5M M M:&ES(&4M;6%I;

Re:RE: New development in Cobol or PL/SQL - please help

2002-11-18 Thread dgoulet 
Tom,

IMHO, if Babette's organization "see themselves as *never* leaving the Cobol
arena" then it's time to dust off the resume as that organization will become
extinct.  No one that I know of is learning Cobol anymore and there are no
classes at the local universities on the subject.  Fortran classes and
programmers are also becoming a scarce resource to find which is why we left
ManMan and TurboImage for PeopleSoft and Oracle.

Dick Goulet

Reply Separator
Author: "Mercadante; Thomas F" <[EMAIL PROTECTED]>
Date:   11/18/2002 5:03 AM

Babette,

The decision really comes down to the organization.  If they see themselves
as *never* leaving the Cobol arena, and they have an ample supply of Cobol
programmers, then they should stay with it.

What you could do is to make friends with the applications people, and show
them how PL/SQL works.  What you will find is that they will take to PL/SQL
like a fish to water.  And pretty soon, more and more PL/SQL packages will
be written that are simply called by the Cobol programs.  Cobol would then
be a simple entry point to the database - able to interface nicely with the
operating system (reading and writing flat files, producing reports and
forms), while the majority of the logic may be written in PL/SQL.

Maybe, just maybe, the person making the decision see's no benefit to using
PL/SQL.  And given your local labor market, maybe he's right!

Tom Mercadante
Oracle Certified Professional


-Original Message-
Sent: Sunday, November 17, 2002 1:18 PM
To: Multiple recipients of list ORACLE-L


"Khedr, Waleed" wrote:
> 
> Cobol! Again!:(
> 
> -Original Message-
> Sent: Friday, November 15, 2002 5:24 PM
> To: Multiple recipients of list ORACLE-L
> 
> I just found out today that we have a major development initiative that is
> starting and they are planning on using Pro*Cobol to develop the
> application. (my head is still shaking in disbelief!!!)
> 
> So we will have a Java front-end, invoking MQ series that will go across
to
> the mainframe for MQ series to invoke Pro*Cobol programs that will then do
> the processing (accessing data and doing calculations) and then return
data.
> 
> If anyone has been in this or a similar situation, please help.
> I need some really good arguments as to why we should put the business
logic
> into PL/SQL instead of Pro*Cobol.
> 
> I understand the reason we are using Oracle is that the director has 15
> years experience with it and loves it.  Aaargh!!!
> 
> thanks
> Babette
> 

May I play the devil's advocate? Even if Pro*Cobol seems to be a weird
choice, there may be a case for not coding the logic in PL/SQL :
database portability. I have heard recently of a very, very, very big
company dumping Oracle in favour of DB2. Reason ? Cost. I guess that in
such a case, porting a Pro*Cobol program is easier than PL/SQL.

-- 
Regards,

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

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

2002-11-18 Thread Jared . Still 
Sean,
Mostly the 'too busy' category.

NBU works fine for us so far, not quite done implementing.


It does more than schedule RMAN, NBU keeps a catalog that
tracks which tape a backup is on for a given date, so that
you don't have to.

Jared







"O'Neill, Sean" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
 11/18/2002 02:23 AM
 Please respond to ORACLE-L

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


Is no-one out there using NetBackup???. 

Without wishing to sound rude I'll assume a non-response indicates an
affirmative to that OR that you're all too busy to voice an opinion ;)

-Original Message-
Sent: Thursday, November 14, 2002 15:04
To: 'List, OracleDBA [Fatcity]'


Howdy Folks,

Would appreciate feedback on experiences, positive :) or negative :(, folk
have had using Veritas NetBackup product for DB recovery, especially in DR
scenarios.  There is an Oracle agent but so far all it appears to me to be
is a glorious scheduler of your own RMAN scripted jobs!.  Feedback on
features I may have "missed" with agent would also be appreciated.

-
Seán O' Neill
Organon (Ireland) Ltd.
[subscribed: digest mode] 

This message, including attached files, may contain confidential
information and is intended only for the use by the individual
and/or the entity to which it is addressed. Any unauthorized use,
dissemination of, or copying of the information contained herein is
not allowed and may lead to irreparable harm and damage for which
you may be held liable. If you receive this message in error or if
it is intended for someone else please notify the sender by
returning this e-mail immediately and delete the message.

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

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

2002-11-18 Thread Jonas Rosenthal 
Hi folks,

I have one follow-up question on this.

Suppose you are doing commit work with pl/sql with large amounds of data and
you are limited in rollback size.  The goal being that you wish to fetch
Large amounts of data and use to commit data inserts to an unrelated table.
Of course, you don't want to reparse and increase the db calls.

Fetch data from table a.
Commit fetched data to table b.

Note - Assume nobody is on the system you aren't changing any data from
table a.

My question is which of the following scenarious is the preferred/correct?

1) Open and close the cursor for a data range and commit the data.  Re-open
for the next data range and repeat.  This goes agains implied excess call
principals.  However, my understanding from support many moons ago and and
personal experience is that the cursor is invalidated on the commit causing
the old ora-1555 snapshot too old.  Support indicated the best way to handle
this was opening and closing the data set fetches in ranges, as above, with
data change commits between each data set to avoid the ora-1555.

2)On the other hand, if you keep the cursor open and commit all data on
completion, that's a lot of rollback you may need.

Any thoughts would be appreciated.


Thanks,


Jonas Rosenthal
Oxford Health Plans

-Original Message-
Millsap
Sent: Monday, November 18, 2002 12:24 PM
To: Multiple recipients of list ORACLE-L


Dick,

I think you've misunderstood me. I'm not advocating the case for doing
joins in the client or anything like that. I'm saying only that PL/SQL
makes it too easy to write code that is extremely db-call-inefficient.
Here's an excerpt from a Hotsos-internal document written by Jeff Holt
that is relevant to the issue...

* * *

Here are some working examples of improper and proper use of cursors in
PL/SQL:

IMPROPER: This code uses an implicit cursor to get dummy into x. Each
time this block is executed it opens a cursor, parses 'select dummy from
dual' into the cursor, it executes the cursor, fetches one row into x,
and then closes the cursor. If this code were executed frequently enough
by at least 2 or 3 concurrent sessions, then you'd see library cache
latch contention. set serveroutput on declare
  x varchar2(1);
begin
select dummy into x from dual;
dbms_output.put_line('dummy is ' || x);
end;
/

IMPROPER: This code is does exactly the same thing as the above example
except that it uses explicit cursors. The problem is that repeated calls
to this block still require a parse. The irony is that this is the
preferred method described in many application developer books including
Oracle's.
set serveroutput on declare
  x varchar2(1);
  cursor getd is select dummy from dual;
begin
open getd;
fetch getd into x;
close getd;
dbms_output.put_line('dummy is ' || x);
end;
/

PROPER: Here's the ONLY way to do a good job. It's fully documented in
the file ?/rdbms/admin/dbmssql.sql. You'll also note that there's no
call to dbms_sql.close_cursor. All well written applications won't close
their cursors until they exit.
  create or replace package session_cursors is
  type sesscur_type is table of binary_integer index by binary_integer;
  sesscur sesscur_type;
  getd binary_integer:= 0;
  getd_open boolean  := false;
  getd_text varchar2(22) := 'select dummy from dual';
end session_cursors;
/
show errors
set serveroutput on
declare
  x varchar2(1);
  r number;
  icid binary_integer := session_cursors.getd;
  cid binary_integer;
begin
if session_cursors.getd_open then
cid := session_cursors.sesscur(icid);
else
cid := dbms_sql.open_cursor;
session_cursors.sesscur(icid) := cid;
dbms_sql.parse(cid, session_cursors.getd_text, dbms_sql.native);
session_cursors.getd_open := true;
end if;
/* if you had bind variables then you would bind them before
   the execute */
r := dbms_sql.execute(cid);
dbms_sql.define_column(cid, 1, x, 1);
r := dbms_sql.fetch_rows(cid);
dbms_sql.column_value(cid, 1, x);
dbms_output.put_line('dummy is ' || x);
end;
/

If you execute each of these in SQL*Plus you'll see one parse/execute of
'select dummy from dual' for the first two examples but you'll see only
one parse of 'select dummy from dual' for the last example.

* * *

This is what I meant in my original note.


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

Upcoming events:
- Hotsos Clinic, Dec 9-11 Honolulu
- 2003 Hotsos Symposium on OracleR System Performance, Feb 9-12 Dallas
- Jonathan Lewis' Optimising Oracle, Nov 19-21 Dallas


-Original Message-
[EMAIL PROTECTED]
Sent: Monday, November 18, 2002 5:33 AM
To: Multiple recipients of list ORACLE-L

Cary,

This is one topic I'll disagree with you.  Assume an application
that uses
the database, but is on a machine outside the db server.  Having a
number of
calls that return one or two rows will have a negative network impact
that is
the results of SQL*Net and it's inefficiencies.  It is better in this
case to
encapsulate all of the database i

RE: Too many db calls

2002-11-18 Thread Alex Hillman 
Does anybody knows if it possible to implement something like bulk binds and
bulk collection facilities using VB - like ADO.

Alex Hillman

-Original Message-
McDonald
Sent: Saturday, November 16, 2002 1:19 PM
To: Multiple recipients of list ORACLE-L


With the advent of bulk bind and bulk collection
facilities in PL/SQL, you can get very close to the
"correct" SQL mechanisms...its just that not many
people tend to do it, and you end up with a gazillion
'one-row-at-a-time' applications out there.

Cheers
Connor

 --- Cary Millsap <[EMAIL PROTECTED]> wrote: >
Greg,
>
> That's one case. PL/SQL is a really poor language in
> which to write an
> application. The language tricks you into believing
> that writing a
> scalable application can be accomplished in just a
> few lines of 4GL
> code, but it's really not true. To write scalable
> PL/SQL, you need to
> use DBMS_SQL. The resulting code is even more
> cumbersome than the same
> function written in Pro*C.
>
> Any language can be abused, though. We see a lot of
> Java, Visual Basic,
> and Powerbuilder applications that do stuff like...
>
> 1. Parse inside loops, using literals instead of
> bind variables.
> 2. Parse *twice* for each execute by doing
> describe+parse+execute.
> 3. Manipulate one row at a time instead of using
> array processing
> capabilities on fetches or inserts (this one,
> ironically, raises a
> system's BCHR while it kills response time).
> 4. Join result sets in the application instead of in
> the database.
>
>
> Cary Millsap
> Hotsos Enterprises, Ltd.
> http://www.hotsos.com
>
> Upcoming events:
> - Hotsos Clinic, Dec 9-11 Honolulu
> - 2003 Hotsos Symposium on OracleR System
> Performance, Feb 9-12 Dallas
> - Jonathan Lewis' Optimising Oracle, Nov 19-21
> Dallas
>
>
> -Original Message-
> Sent: Saturday, November 16, 2002 2:38 AM
> To: Multiple recipients of list ORACLE-L
>
> Cary,
>
> Thank you.
>
> Could you elaborate on the issue of excessive
> database calls, which show
> up
> as excessive network traffic?
>
> I can picture a PL/SQL loop, which executes an SQL
> statement over and
> over
> again.  This would produce many database calls, and
> it might be possible
> to
> remove the loop altogether, replacing it with a
> single SQL statement.
> This
> would reduce the database calls.
>
> Is this the "classic" type of situation that
> produces too many db calls?
> Or
> are there other situations I'm missing that are more
> likely to be the
> source
> of this problem?
>
> Thanks again.
>
>
>
> - Original Message -
> To: "Multiple recipients of list ORACLE-L"
> <[EMAIL PROTECTED]>
> Sent: Friday, November 15, 2002 4:13 PM
>
>
> > Greg,
> >
> > I believe that the cultural root cause of the
> excessive LIO problem is
> > the conception that physical I/O is what makes
> databases slow. Disk
> I/O
> > certainly *can* make a system slow, but in about
> 598 of 600 cases
> we've
> > seen in the past three years, it hasn't. ["Why you
> should focus on
> LIOs
> > instead of PIOs" at www.hotsos.com/catalog]
> >
> > The fixation on PIO of course focuses people's
> attention on the
> database
> > buffer cache hit ratio (BCHR) metric for
> evaluating efficiency. The
> > problem is that the BCHR is a metric of INSTANCE
> efficiency, not SQL
> > efficiency. However, many people mistakenly apply
> it as a metric of
> SQL
> > efficiency anyway.
> >
> > Of course, if one's radar equates SQL efficiency
> with the BCHR's
> > proximity to 100%, then a lot of really bad SQL is
> going to show up on
> > your radar wrongly identified as really good SQL.
> ["Why a 99% buffer
> > cache hit ratio is not okay" at
> www.hotsos.com/catalog]
> >
> > One "classic" result is that people go on search
> and destroy missions
> > for all full-table scans. They end up producing
> more execution plans
> > that look like this than they should have:
> >
> >   NESTED LOOPS
> > TABLE ACCESS BY INDEX ROWID
> >   INDEX RANGE SCAN
> > TABLE ACCESS BY INDEX ROWID
> >   INDEX RANGE SCAN
> >
> > This kind of plan produces great hit ratios
> because it tends to
> revisit
> > the same small set of blocks over and over again.
> This kind of plan is
> > of course appropriate in many cases. But sometimes
> it is actually less
> > work in the database to use full-table scans.
> ["When to use an index"
> at
> > www.hotsos.com/catalog.]
> >
> >
> > Cary Millsap
> > Hotsos Enterprises, Ltd.
> > http://www.hotsos.com
> >
> > Upcoming events:
> > - Hotsos Clinic, Dec 9-11 Honolulu
> > - 2003 Hotsos Symposium on OracleR System
> Performance, Feb 9-12 Dallas
> > - Jonathan Lewis' Optimising Oracle, Nov 19-21
> Dallas
> >
> >
> > -Original Message-
> > Sent: Friday, November 15, 2002 4:39 PM
> > To: Multiple recipients of list ORACLE-L
> >
> > A while back someone mentioned that the two main
> causes of slow SQL
> are
> > excesive LIO's and excesscive database calls,
> which show up as
> excessive
> > CPU
> > use and excessive network traffic, respect

Re: Hint-O-The-Day: MetaLink index pages search

2002-11-18 Thread Deborah Lorraine 
Now if you could just save those preferences so they always came up...

Debi

At 11:38 AM 11/18/2002 -0800, Jesse, Rich wrote:

Hey all,

Just a helpful Hint-O-The-Day for quick searching of MetaLink.  I'm sick of
having to weed through every search because the results are flooded with DEC
Rdb links (an issue that Oracle hasn't resolved yet).

Under the Advanced Site Search, I entered:

{library index}

as my Keywords, selected "ConText Syntax", removed "Technical Forum" from
the list of Sources, chose "Single row list" for List type, and Ordered by
"Subject".

This brings up a nice page of (mostly) indexes that seem to be good jumping
points when looking up info on Metalink by generic category (e.g.
Performance or Oracle Context) without having to resort to sorting through
your Metalink bookmarks.

HTH!  :)

Rich


Rich Jesse   System/Database Administrator
[EMAIL PROTECTED]  Quad/Tech International, Sussex, WI USA
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Jesse, Rich
  INET: [EMAIL PROTECTED]

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


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

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

2002-11-18 Thread Brian Dunbar 
-Original Message-
Sent: Monday, November 18, 2002 1:46 PM
To: Multiple recipients of list ORACLE-L


Hi All!
Could some one pointed me to the good source of info about clustering
Win2000 Oracle DB Server?

Thanks.

Greg.


There _are_ some interesting articles from OpenWorld  ...

http://www.oracle.com/oracleworld/sanfrancisco/conference/ems_search.html


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

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

Running/Licensing Hyperthreaded Intel Pentium4 Xeon CPU's on Linu

2002-11-18 Thread Orr, Steve 
OK, I've got this new Dell Linux server with 4 "Hyperthreaded" Pentium4 Xeon
CPU's. There are 4 physical CPU's but with hyperthreading the O/S sees 8
CPU's as is reported in top. I've installed Oracle on this machine and it
seems to run as if there really were 8 CPU's. Could that be true? Is there a
performance gain for Oracle? --As if I really did have 8 CPU's? How does
this work? For init.ora tuning parameters should I count the 4 physical
CPU's or the 8 virtual CPU's? Any reports on running Oracle/Linux on these
hyperthreaded Pentium4 Xeon CPU's? 

I'm afraid to ask Oracle about the licensing since they always answer with
the higher number. ;-) 


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

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

Updated Question (sorry for the spam)

2002-11-18 Thread Dana . Mueller 
Is there a way to log the sysdba account accessing sys.aud table?  In my
reading, I have not found a solution to this yet.

Thanks Again,

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

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

RE: how to download all the openworld documents?

2002-11-18 Thread Brian Dunbar 
-Original Message-
Sent: Monday, November 18, 2002 12:19 PM
To: Multiple recipients of list ORACLE-L


Try this link: 
http://www.oracle.com/oracleworld/sanfrancisco/conference/ems_search.html 
I went to openworld.oracle.com , and click my way through to get to the
above link. 
Gillian

Thanks for the link - the documents I've looked at so far are great.  It
_would_ be nice to get the entire bundle in .pdf format and zipped but I'll
live with this.

Memo 1: to Oracle - there's a bit of revenue you're missing by not charging
a nominal fee for the bundle.
Memo 2: not all of us are enamored of the .doc format  nor do we all
have Word handy.

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

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

Re: Query to predict failure on second extent of segment

2002-11-18 Thread Stephane Faroult 
"Jesse, Rich" wrote:
> 
> OK, once again, this isn't what I'm looking for.  Comparing NEXT_EXTENT*2 to
> the largest free space will only work in some cases.  Consider that a
> segment has NEXT_EXTENT of 30M and there are two 40M free spaces in the TS.
> The segment clearly has enough room to extend twice, but comparing
> NEXT_EXTENT*2 to the largest free space may not see this.
> 
> I've changed the subject back to reflect the original thread that I started.
> 
> Thanks,
> Rich
> 
> Rich Jesse   System/Database Administrator
> [EMAIL PROTECTED]  Quad/Tech International, Sussex, WI USA
> 

http://www.oriole.com/scripts/segtrbl8.sql ?
-- 
Regards,

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

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

2002-11-18 Thread Dana . Mueller 


>  -Original Message-
> From: Dana Mueller  
> Sent: Monday, November 18, 2002 11:45 AM
> To:   '[EMAIL PROTECTED]'
> Subject:  sys.aud$ - auditing user activities?
> 
> Hello All,
> 
> Do any of you have suggestions for a good way to monitor sysdba user
> activities on the sys.aud$ table?  Or, in terms of logging everything,
> what would be the keypoints to log scrub on?
> 
> Any suggestions would be wonderful.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

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

How to make ORACLE Developer 6i understand ORACLE 8i client?

2002-11-18 Thread dist cash 

We used ORACLE developer 6i on PC.  The ORACLE Developer 6i use ORACLE 8.0.5 
client.  We don't have ORACLE 8.0.5 client. Does their has way to make 
ORACLE Developer 6i connect through 8i client?


Thanks.




_
Tired of spam? Get advanced junk mail protection with MSN 8. 
http://join.msn.com/?page=features/junkmail

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

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

sys.aud$ - auditing user activities?

2002-11-18 Thread Dana . Mueller 
Hello All,

Do any of you have suggestions for a good way to monitor sysdba user
activities on the sys.aud$ table?  Or, in terms of logging everything, what
would be the keypoints to log scrub on?

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

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

clustering Win2000 Oracle DB Server

2002-11-18 Thread Greg Faktor 
Hi All!
Could some one pointed me to the good source of info about clustering Win2000 Oracle 
DB Server?

Thanks.

Greg.

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

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

2002-11-18 Thread paquette stephane 
I just went to the DB2 UDB fast track for experienced
DBA at IBM.

If it's 4 days then it should be fine. Our course was
only 2 days and we asked so much questions that we
only saw two third of the topics (and we had done
overtime).

As usual, it depends a lot on who is giving the
course.


 --- Gene Sais <[EMAIL PROTECTED]> a écrit : >
I just inherited responsibility for a set of
> informix databases.  Has anyone taken the Informix
> Training for Oracle DBAs, 4 day crash course given
> by IBM Informix and was it worth it?
> 
> Thanks,
> Gene
> 
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> --
> Author: Gene Sais
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051
> http://www.fatcity.com
> San Diego, California-- Mailing list and web
> hosting services
>
-
> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of
> 'ListGuru') and in
> the message BODY, include a line containing: UNSUB
> ORACLE-L
> (or the name of mailing list you want to be removed
> from).  You may
> also send the HELP command for other information
> (like subscribing). 

=
Stéphane Paquette
DBA Oracle et DB2, consultant entrepôt de données
Oracle and DB2 DBA, datawarehouse consultant
[EMAIL PROTECTED]

__
Lèche-vitrine ou lèche-écran ?
magasinage.yahoo.ca
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: =?iso-8859-1?q?paquette=20stephane?=
  INET: [EMAIL PROTECTED]

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

RE: how to download all the openworld documents?

2002-11-18 Thread Gogala, Mladen 
wget might do the trick.

> -Original Message-
> From: dist cash [mailto:[EMAIL PROTECTED]]
> Sent: Monday, November 18, 2002 2:38 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Re: how to download all the openworld documents?
> 
> 
> 
> Thank you, but what I want is download 'ALL' docuemnts NOT one by one.
> 
> 
> 
> 
> 
> >From: Gillian <[EMAIL PROTECTED]>
> >Reply-To: [EMAIL PROTECTED]
> >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> >Subject: Re: how to download all the openworld documents?
> >Date: Mon, 18 Nov 2002 10:18:30 -0800
> >
> >
> >Try this link:
> >http://www.oracle.com/oracleworld/sanfrancisco/conference/ems
_search.html
>I went to openworld.oracle.com , and click my way through to get to the 
>above link.
>Gillian
>  [EMAIL PROTECTED] wrote:
> > Does their has way that can download (or purchase CD) all the ORACLE
> > Openworld documents?
>
>Some of the presenters alluded to them being uploaded somewhere, but I
>haven't found it. The presentations I saw, I simply emailed the presenter
>to get a copy. You might try this.
>
>HTH,
>Sean
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author:
>INET: [EMAIL PROTECTED]
>
>Fat City Network Services -- 858-538-5051 http://www.fatcity.com
>San Diego, California -- Mailing list and web hosting services
>-
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from). You may
>also send the HELP command for other information (like subscribing).
>
>
>-
>Do you Yahoo!?
>Yahoo! Web Hosting - Let the expert host your site


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

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

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

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

RE: how to download all the openworld documents?

2002-11-18 Thread April Wells 
ditto.  Even one by one isn't bad if you didn't get to be there

April Wells
Oracle DBA 
Great spirits have always encountered violent opposition from mediocre minds
-- Albert Einstein



-Original Message-
Sent: Monday, November 18, 2002 2:49 PM
To: Multiple recipients of list ORACLE-L


Well, for myself, I'm glad to have ANY access. So thank you, Gillian, and no
buts about it.

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


-Original Message-
Sent: Monday, November 18, 2002 1:38 PM
To: Multiple recipients of list ORACLE-L



Thank you, but what I want is download 'ALL' docuemnts NOT one by one.





>From: Gillian <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: Re: how to download all the openworld documents?
>Date: Mon, 18 Nov 2002 10:18:30 -0800
>
>
>Try this link:
>http://www.oracle.com/oracleworld/sanfrancisco/conference/ems_search.html
>I went to openworld.oracle.com , and click my way through to get to the 
>above link.
>Gillian
>  [EMAIL PROTECTED] wrote:
> > Does their has way that can download (or purchase CD) all the ORACLE
> > Openworld documents?
>
>Some of the presenters alluded to them being uploaded somewhere, but I
>haven't found it. The presentations I saw, I simply emailed the presenter
>to get a copy. You might try this.
>
>HTH,
>Sean
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author:
>INET: [EMAIL PROTECTED]
>
>Fat City Network Services -- 858-538-5051 http://www.fatcity.com
>San Diego, California -- Mailing list and web hosting services
>-
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from). You may
>also send the HELP command for other information (like subscribing).
>
>
>-
>Do you Yahoo!?
>Yahoo! Web Hosting - Let the expert host your site


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

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

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

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

begin 666 InterScan_Disclaimer.txt
M5&AE(&EN9F]R;6%T:6]N(&-O;G1A:6YE9"!I;B!T:&ES(&-O;6UU;FEC871I
M;VXL(&EN8VQU9&EN9R!A='1A8VAM96YT2!A;'-O(&-O;G1A:6X@<')O<')I971A2!P2!A;GEO;F4@;W1H97(@=&AA;B!T
M:&4@:6YT96YD960@2!B92!I;&QE9V%L+B!)9B!Y;W4@:&%V92!R96-E:79E9"!T:&ES
M(&-O;6UU;FEC871I;VX@:6X@97)R;W(L('!L96%S92!N;W1I9GD@=&AE('-E
M;F1E2!B>2!R97!L>2!E+6UA:6PL(&1E;&5T92!T:&ES
M(&-O;6UU;FEC871I;VXL(&%N9"!D97-T6]U('1O(&-Ahttp://www.orafaq.com
-- 
Author: April Wells
  INET: [EMAIL PROTECTED]

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

Cognos Reporting Tool

2002-11-18 Thread Rodd Holman 
Good afternoon listers.
I just found out that I will be meeting with the sales "dog and pony"
folks from Cognos on Tuesday.  Have any of you worked with this
product?  What should I be aware of?  What plusses/minuses should I look
for?  Any suggestions would be welcome.

Thanks

Rodd Holman


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

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

2002-11-18 Thread Jesse, Rich 
Yes, this is a nice query, but it doesn't address my original topic.

I've changed the subject to reflect the thread I orginally started.

Thanks,
Rich


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

> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> Sent: Friday, November 15, 2002 5:05 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: How to identify objects that will fail to extend?
> 
> 
> Okay.  Let me try this!
> 
> The largest column will have the biggest extent size that the 
> tablespace can accommodate next time.  You might save this 
> information in a temp. table and have the other query to 
> check against this.
> 
> 
> select substr(a.tablespace_name,1,20) tablespace,
> round(sum(a.total1)/1024/1024, 1) Total,
> round(sum(a.total1)/1024/1024, 
> 1)-round(sum(a.sum1)/1024/1024, 1) used,
> round(sum(a.sum1)/1024/1024, 1) free,
> round(sum(a.sum1)/1024/1024, 
> 1)*100/round(sum(a.total1)/1024/1024, 1) pct_free,
> round(sum(a.maxb)/1024/1024, 1) largest,
> max(a.cnt) fragments
> from
> (select tablespace_name, 0 total1, sum(bytes) sum1,
> max(bytes) MAXB,
> count(bytes) cnt
> from dba_free_space
> group by tablespace_name
> union
> select tablespace_name, sum(bytes) total1, 0, 0, 0 from dba_data_files
> group by tablespace_name) a
> group by a.tablespace_name
> 
> 
> -Original Message-
> Sent: Friday, November 15, 2002 4:54 PM
> To: Multiple recipients of list ORACLE-L
> 
> 
> Nope.  If a segment has a NEXT EXTENT of 20M and the two 
> largest contiguous
> free spaces in it's TS are 30M and 15M, the second extent 
> (i.e. two extends
> to that segment) would fail, but would not show up in the 
> query.  That's
> what spawned the complexity of my SQL.
> 
> Rich
> 
> 
> Rich Jesse   System/Database Administrator
> [EMAIL PROTECTED]  Quad/Tech International, 
> Sussex, WI USA
> 
> > -Original Message-
> > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> > Sent: Friday, November 15, 2002 1:44 PM
> > To: Multiple recipients of list ORACLE-L
> > Subject: RE: How to identify objects that will fail to extend?
> > 
> > 
> > If PCT_INCREASE is set to 0, then can't we simply compare 
> > next_extent*2 > ( sub-query )?
> > 
> > 
> > -Original Message-
> > Sent: Friday, November 15, 2002 12:40 PM
> > To: Multiple recipients of list ORACLE-L
> > 
> > 
> > Thanks, but the next extent is the easy one.  As I mentioned, 
> > I'm already
> > running a similar query hourly.
> > 
> > Rich
> > 
> > 
> > Rich Jesse   System/Database Administrator
> > [EMAIL PROTECTED]  Quad/Tech International, 
> > Sussex, WI USA
> > 
> > > -Original Message-
> > > From: [EMAIL PROTECTED] 
> [mailto:[EMAIL PROTECTED]]
> > > Sent: Friday, November 15, 2002 10:14 AM
> > > To: Multiple recipients of list ORACLE-L
> > > Subject: How to identify objects that will fail to extend?
> > > 
> > > 
> > > List,
> > > 
> > > There was a question as to how to identify objects that will 
> > > fail to extend?
> > > 
> > > This is what we do.
> > > 
> > > SELECT owner, tablespace_name, segment_name, next_extent
> > > FROM dba_segments ds
> > > WHERE tablespace_name != 'TEMP'
> > >   AND next_extent > ( SELECT max(bytes)
> > >   FROM dba_free_space
> > >   WHERE tablespace_name=ds.tablespace_name)
> > > ORDER BY 1, 2;
> > > 
> > > -Original Message-
> > > Sent: Thursday, November 14, 2002 4:54 PM
> > > To: Multiple recipients of list ORACLE-L
> > > 
> > > 
> > > Hi all,
> > > 
> > > Until a whole mass of astrological confluences happen, I'm 
> > stuck with
> > > dictionary-managed tablespaces on 8.1.7 on HP/UX 11.0.  And 
> > > we're having
> > > some space/growth issues right now that I want (need!) to be more
> > > proactive
> > > with.  So, based on several factors -- most political -- I 
> > > want to run a
> > > daily report that tells me when a segment will not be 
> able to extend
> > > twice.
> > > (We're already running the single extent failure hourly.)
> > > 
> > > After looking on the net, I found some queries to do this, 
> > > but all I saw
> > > were severely flawed.  So, I rolled my own.  The only problem 
> > > I can see
> > > with
> > > it for dictionary TSs is when the RANK() has multiple matches 
> > > for first
> > > and
> > > second (e.g. TS "MY_BIG_TS" has it's largest contiguous 
> > free spaces of
> > > 40M,
> > > 10M, and 10M).  Unfortunately, I'm stumped as to how to 
> > prevent this.
> > > 
> > > Anyone care to comment on this load of SQueaL?  Thx!  :)
> > > 
> > > Rich
> > > 
> > > Rich Jesse   System/Database Administrator
> > > [EMAIL PROTECTED]  Quad/Tech International, 
> > > Sussex, WI
> > > USA
> > > 
> > > 
> > > 
> > > SELECT ds.owner, ds.segment_name, ds.segment_type, 
> > ds.tablespace_name,

Hint-O-The-Day: MetaLink index pages search

2002-11-18 Thread Jesse, Rich 
Hey all,

Just a helpful Hint-O-The-Day for quick searching of MetaLink.  I'm sick of
having to weed through every search because the results are flooded with DEC
Rdb links (an issue that Oracle hasn't resolved yet).

Under the Advanced Site Search, I entered:

{library index}

as my Keywords, selected "ConText Syntax", removed "Technical Forum" from
the list of Sources, chose "Single row list" for List type, and Ordered by
"Subject".

This brings up a nice page of (mostly) indexes that seem to be good jumping
points when looking up info on Metalink by generic category (e.g.
Performance or Oracle Context) without having to resort to sorting through
your Metalink bookmarks.

HTH!  :)

Rich


Rich Jesse   System/Database Administrator
[EMAIL PROTECTED]  Quad/Tech International, Sussex, WI USA
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jesse, Rich
  INET: [EMAIL PROTECTED]

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

OT: Informix Training for Oracle DBAs

2002-11-18 Thread Gene Sais 
I just inherited responsibility for a set of informix databases.  Has anyone taken the 
Informix Training for Oracle DBAs, 4 day crash course given by IBM Informix and was it 
worth it?

Thanks,
Gene

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

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

2002-11-18 Thread Jesse, Rich 
OK, once again, this isn't what I'm looking for.  Comparing NEXT_EXTENT*2 to
the largest free space will only work in some cases.  Consider that a
segment has NEXT_EXTENT of 30M and there are two 40M free spaces in the TS.
The segment clearly has enough room to extend twice, but comparing
NEXT_EXTENT*2 to the largest free space may not see this.

I've changed the subject back to reflect the original thread that I started.

Thanks,
Rich


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

> -Original Message-
> From: Ron Rogers [mailto:[EMAIL PROTECTED]]
> Sent: Monday, November 18, 2002 6:49 AM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: How to identify objects that will fail to extend?
> 
> 
> Rich,
>  How about using the next_extent*2 compared with the select max(bytes)
> from dba_free_space where tablespace_name ='tablespace name in
> question';
> That will show you if there is enough free space for two extents or
> more.
> I display sum(bytes) and max(bytes) to give a complete picture of the
> free space and then manually increasing the datafile(if possible) when
> there are multiple datafiles to allow for the needed expantion.
> Ron
> 
> >>> [EMAIL PROTECTED] 11/15/02 06:04PM >>>
> Okay.  Let me try this!
> 
> The largest column will have the biggest extent size that the
> tablespace can accommodate next time.  You might save this information
> in a temp. table and have the other query to check against this.
> 
> 
> select substr(a.tablespace_name,1,20) tablespace,
> round(sum(a.total1)/1024/1024, 1) Total,
> round(sum(a.total1)/1024/1024, 1)-round(sum(a.sum1)/1024/1024, 1)
> used,
> round(sum(a.sum1)/1024/1024, 1) free,
> round(sum(a.sum1)/1024/1024, 1)*100/round(sum(a.total1)/1024/1024, 1)
> pct_free,
> round(sum(a.maxb)/1024/1024, 1) largest,
> max(a.cnt) fragments
> from
> (select tablespace_name, 0 total1, sum(bytes) sum1,
> max(bytes) MAXB,
> count(bytes) cnt
> from dba_free_space
> group by tablespace_name
> union
> select tablespace_name, sum(bytes) total1, 0, 0, 0 from dba_data_files
> group by tablespace_name) a
> group by a.tablespace_name
> 
> 
> -Original Message-
> Sent: Friday, November 15, 2002 4:54 PM
> To: Multiple recipients of list ORACLE-L
> 
> 
> Nope.  If a segment has a NEXT EXTENT of 20M and the two largest
> contiguous
> free spaces in it's TS are 30M and 15M, the second extent (i.e. two
> extends
> to that segment) would fail, but would not show up in the query. 
> That's
> what spawned the complexity of my SQL.
> 
> Rich
> 
> 
> Rich Jesse   System/Database Administrator
> [EMAIL PROTECTED]  Quad/Tech International, Sussex,
> WI USA
> 
> > -Original Message-
> > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> 
> > Sent: Friday, November 15, 2002 1:44 PM
> > To: Multiple recipients of list ORACLE-L
> > Subject: RE: How to identify objects that will fail to extend?
> > 
> > 
> > If PCT_INCREASE is set to 0, then can't we simply compare 
> > next_extent*2 > ( sub-query )?
> > 
> > 
> > -Original Message-
> > Sent: Friday, November 15, 2002 12:40 PM
> > To: Multiple recipients of list ORACLE-L
> > 
> > 
> > Thanks, but the next extent is the easy one.  As I mentioned, 
> > I'm already
> > running a similar query hourly.
> > 
> > Rich
> > 
> > 
> > Rich Jesse   System/Database Administrator
> > [EMAIL PROTECTED]  Quad/Tech International, 
> > Sussex, WI USA
> > 
> > > -Original Message-
> > > From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED]] 
> > > Sent: Friday, November 15, 2002 10:14 AM
> > > To: Multiple recipients of list ORACLE-L
> > > Subject: How to identify objects that will fail to extend?
> > > 
> > > 
> > > List,
> > > 
> > > There was a question as to how to identify objects that will 
> > > fail to extend?
> > > 
> > > This is what we do.
> > > 
> > > SELECT owner, tablespace_name, segment_name, next_extent
> > > FROM dba_segments ds
> > > WHERE tablespace_name != 'TEMP'
> > >   AND next_extent > ( SELECT max(bytes)
> > >   FROM dba_free_space
> > >   WHERE tablespace_name=ds.tablespace_name)
> > > ORDER BY 1, 2;
> > > 
> > > -Original Message-
> > > Sent: Thursday, November 14, 2002 4:54 PM
> > > To: Multiple recipients of list ORACLE-L
> > > 
> > > 
> > > Hi all,
> > > 
> > > Until a whole mass of astrological confluences happen, I'm 
> > stuck with
> > > dictionary-managed tablespaces on 8.1.7 on HP/UX 11.0.  And 
> > > we're having
> > > some space/growth issues right now that I want (need!) to be more
> > > proactive
> > > with.  So, based on several factors -- most political -- I 
> > > want to run a
> > > daily report that tells me when a segment will not be able to
> extend
> > > twice.
> > > (We're already running the single extent failure hourly.)
> > > 
> > > After looking on the net, I fou

RE: how to download all the openworld documents?

2002-11-18 Thread DENNIS WILLIAMS 
Well, for myself, I'm glad to have ANY access. So thank you, Gillian, and no
buts about it.

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


-Original Message-
Sent: Monday, November 18, 2002 1:38 PM
To: Multiple recipients of list ORACLE-L



Thank you, but what I want is download 'ALL' docuemnts NOT one by one.





>From: Gillian <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: Re: how to download all the openworld documents?
>Date: Mon, 18 Nov 2002 10:18:30 -0800
>
>
>Try this link:
>http://www.oracle.com/oracleworld/sanfrancisco/conference/ems_search.html
>I went to openworld.oracle.com , and click my way through to get to the 
>above link.
>Gillian
>  [EMAIL PROTECTED] wrote:
> > Does their has way that can download (or purchase CD) all the ORACLE
> > Openworld documents?
>
>Some of the presenters alluded to them being uploaded somewhere, but I
>haven't found it. The presentations I saw, I simply emailed the presenter
>to get a copy. You might try this.
>
>HTH,
>Sean
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author:
>INET: [EMAIL PROTECTED]
>
>Fat City Network Services -- 858-538-5051 http://www.fatcity.com
>San Diego, California -- Mailing list and web hosting services
>-
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from). You may
>also send the HELP command for other information (like subscribing).
>
>
>-
>Do you Yahoo!?
>Yahoo! Web Hosting - Let the expert host your site


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

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

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

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

Re: how to download all the openworld documents?

2002-11-18 Thread dist cash 

Thank you, but what I want is download 'ALL' docuemnts NOT one by one.






From: Gillian <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Subject: Re: how to download all the openworld documents?
Date: Mon, 18 Nov 2002 10:18:30 -0800


Try this link:
http://www.oracle.com/oracleworld/sanfrancisco/conference/ems_search.html
I went to openworld.oracle.com , and click my way through to get to the 
above link.
Gillian
 [EMAIL PROTECTED] wrote:
> Does their has way that can download (or purchase CD) all the ORACLE
> Openworld documents?

Some of the presenters alluded to them being uploaded somewhere, but I
haven't found it. The presentations I saw, I simply emailed the presenter
to get a copy. You might try this.

HTH,
Sean

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

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


-
Do you Yahoo!?
Yahoo! Web Hosting - Let the expert host your site


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

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

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

2002-11-18 Thread Brian Dunbar 
-Original Message-
Sent: Monday, November 18, 2002 9:59 AM
To: Multiple recipients of list ORACLE-L


>Mark - Thanks very much. You are right, that Cary guy really nails those
>performance issues. The original paper date is 1992. I guess that if you
say
>something about Oracle over 10 years ago and it is still relevant, that
>would have to qualify as a classic.

I submit it is the relevance of UNIX that makes the paper a classic.  If
Oracle existing solely on another OS (Windows?) then this paper would be no
more relevant that a whitepaper on Banyan Vines.

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

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

Re: set arraysize in Pro*C

2002-11-18 Thread Rick_Cale 

I have not done it for a while but look in the precompiler options. There
is an option to increase.

Rick



   
   
Govind.Arumugam@   
   
alltel.com To: Multiple recipients of list 
ORACLE-L   
Sent by:<[EMAIL PROTECTED]> 
   
[EMAIL PROTECTED]   cc: 
   
   Subject: set arraysize in Pro*C 
   
   
   
11/18/2002 11:48   
   
AM 
   
Please respond 
   
to ORACLE-L
   
   
   
   
   




Dear List-Members,

Some of the batch queries can be improved by increasing the arraysize to
1000 ( the default in SQL*Plus is 15);  I would like to find out the
equivalent of this in Pro*C programs.

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

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




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

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

Re: how to download all the openworld documents?

2002-11-18 Thread Gillian 
Try this link:
http://www.oracle.com/oracleworld/sanfrancisco/conference/ems_search.html
I went to openworld.oracle.com , and click my way through to get to the above link.
Gillian
 [EMAIL PROTECTED] wrote:
> Does their has way that can download (or purchase CD) all the ORACLE> Openworld documents?Some of the presenters alluded to them being uploaded somewhere, but I haven't found it. The presentations I saw, I simply emailed the presenter to get a copy. You might try this.HTH,Sean-- Please see the official ORACLE-L FAQ: http://www.orafaq.com-- Author: INET: [EMAIL PROTECTED]Fat City Network Services -- 858-538-5051 http://www.fatcity.comSan Diego, California -- Mailing list and web hosting services-To REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you wan!
!
t to be removed from). You mayalso send the HELP command for other information (like subscribing).Do you Yahoo!?
Yahoo! Web Hosting - Let the expert host your site

Re: Oracle & SAN Experiences?

2002-11-18 Thread Peter Barnett 
Some observations based on experience.

Allocating storage based on the controllers helps if
the database is large enough.  e.g. 1 controller
manages 100G of physical disk.  Use that as a mount
point.  This does improve io somewhat if you can have
mount points in 100G multiples (or whatever your
controller manages).

On board caching can be a problem.  Oracle writes to
disk but the data actually gets cached rather than
physically written to disk.  If a database crashes
before the actual write to disk occurs you lose the
data.  Write through caching helps this but offer no
guarantees.

We found that approximately 60% of our io was actually
from the cache rather than disk.  The cache lru was
holding the data blocks.  This made the reads much
faster.



--- [EMAIL PROTECTED] wrote:
> > The Sys. Admin. team wants to consolidate storage
> (and
> > probably get a new toy too) on all of our servers,
> so they
> > are evaluating a SAN (LSI  Logic E4600).  The DBA
> team is
> > doing some research to determine the pros and cons
> of
> > doing this, and I'd like to hear any of your
> experiences
> > (good and bad) using SAN with Oracle.
> >  
> > My understanding is that all of our database
> servers would
> > remain intact, but the attached disk storage would
> move
> > into the SAN.  So, we still have the Production,
> Test, and
> > App. servers with their processors and memory,
> Oracle
> > homes, etc.  The SAN will hold database files from
> > Production, Test, Apps., staging, ODS,data
> warehouse, etc.
> >  
> > Their arguments:
> > -the SAN is very scalable (500 GB - 40 TB)
> > -easy to manage disks in one central location
> > -fancy statistics collection on all SAN disks
> > -much higher throughput on the fiber SAN
> connections than
> > with locally attached disk arrays
> > -capable of using mixed RAID levels (0, 1, 1+0, 5,
> etc.)
> > -can partition sets of disks in the SAN for
> specific
> > server access -Snapshot backup capability is very
> fast in
> > the SAN (much faster than traditional Oracle
> backups)
> >  
> > DBA arguments:
> > -How will this affect database performance?
> > -What are the drawbacks, if any, with the
> pre-fetch of
> > data performed by the SAN (i.e., SAN cache)
> > -How tunable is the SAN
> > -Fast, small disks are better for performance and
> less
> > wasted space than the typical huge disks in a SAN
> (it's
> > possible to use smaller disks in the SAN) -Prove
> it!
> >  
> >  
> > After reading the "Sane SAN" article and a case
> study
> > about Volvo implementing a SAN, I believe it's
> possible to
> > have a great Oracle/SAN implementation if it's
> setup
> > correctly and tuned.  Other resources that you can
> Google
> > are "Using SVA SnapShot with Oracle", "Performance
> > Benchmark LSI Logic E4600 (STK D178)", "SAN
> Storage for
> > Open Systems Environments", and of course check
> the
> > OraFaq.
> >  
> > Thanks for sharing,
> >  
> > David Wagoner
> > Oracle DBA
> 
> Sounds like you're going through an excellent
> evaluation
> process.  I would suggest to keep in mind Anjo's
> advice to
> also regard I/O in terms of units of throughput
> (i.e. read
> or write rates) instead of Gbytes or Tbytes (i.e.
> static
> capacity).  Helps clarify the discussions...
> 
> The other thing is the idea of co-mingling
> production and
> dev/test.  Of course it is possible and quite
> feasible, but
> if you look at things from the perspective of units
> of
> throughput, you might find a huge disparity or
> conflict. 
> Perhaps the most telling indicator might be
> reviewing
> whether or not your LANs for production and dev/test
> are
> isolated from one another -- many of the rationales
> for
> doing so (or not doing so) might be similar to the
> considerations for your SAN.
> 
> Good luck!
> -- 
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> -- 
> Author: 
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051
> http://www.fatcity.com
> San Diego, California-- Mailing list and web
> hosting services
>
-
> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of
> 'ListGuru') and in
> the message BODY, include a line containing: UNSUB
> ORACLE-L
> (or the name of mailing list you want to be removed
> from).  You may
> also send the HELP command for other information
> (like subscribing).


=
Pete Barnett
Lead Database Administrator
The Regence Group
[EMAIL PROTECTED]

__
Do you Yahoo!?
Yahoo! Web Hosting - Let the expert host your site
http://webhosting.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Peter Barnett
  INET: [EMAIL PROTECTED]

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

Re: set arraysize in Pro*C

2002-11-18 Thread Tim Gorman 
It is implicitly declared by the smallest array used in the EXEC SQL
statement.  Thus, in the EXEC SQL DECLARE section of the PRO*C program, if
one array were declared with 100 elements and another with 50 elements and
both were used in the same EXEC SQL statement, then PRO*C would perform
array operations of 50.  If a scalar variable (i.e. non array) were also
used in the same EXEC SQL statement, then PRO*C would automatically adjust
to one-row-at-a-time, in order to accomodate the scalar variable.

PRO*C has been doing this since v1.x in the 1980s.

- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Monday, November 18, 2002 9:48 AM


Dear List-Members,

Some of the batch queries can be improved by increasing the arraysize to
1000 ( the default in SQL*Plus is 15);  I would like to find out the
equivalent of this in Pro*C programs.

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

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

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

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

2002-11-18 Thread Cary Millsap 
Dick,

I think you've misunderstood me. I'm not advocating the case for doing
joins in the client or anything like that. I'm saying only that PL/SQL
makes it too easy to write code that is extremely db-call-inefficient.
Here's an excerpt from a Hotsos-internal document written by Jeff Holt
that is relevant to the issue...

* * *

Here are some working examples of improper and proper use of cursors in
PL/SQL:

IMPROPER: This code uses an implicit cursor to get dummy into x. Each
time this block is executed it opens a cursor, parses 'select dummy from
dual' into the cursor, it executes the cursor, fetches one row into x,
and then closes the cursor. If this code were executed frequently enough
by at least 2 or 3 concurrent sessions, then you'd see library cache
latch contention. set serveroutput on declare
  x varchar2(1);
begin
select dummy into x from dual;
dbms_output.put_line('dummy is ' || x);
end;
/

IMPROPER: This code is does exactly the same thing as the above example
except that it uses explicit cursors. The problem is that repeated calls
to this block still require a parse. The irony is that this is the
preferred method described in many application developer books including
Oracle's.
set serveroutput on declare
  x varchar2(1);
  cursor getd is select dummy from dual;
begin
open getd;
fetch getd into x;
close getd;
dbms_output.put_line('dummy is ' || x);
end;
/

PROPER: Here's the ONLY way to do a good job. It's fully documented in
the file ?/rdbms/admin/dbmssql.sql. You'll also note that there's no
call to dbms_sql.close_cursor. All well written applications won't close
their cursors until they exit.
  create or replace package session_cursors is
  type sesscur_type is table of binary_integer index by binary_integer;
  sesscur sesscur_type;
  getd binary_integer:= 0;
  getd_open boolean  := false;
  getd_text varchar2(22) := 'select dummy from dual';
end session_cursors;
/
show errors
set serveroutput on
declare
  x varchar2(1);
  r number;
  icid binary_integer := session_cursors.getd;
  cid binary_integer;
begin
if session_cursors.getd_open then
cid := session_cursors.sesscur(icid);
else
cid := dbms_sql.open_cursor;
session_cursors.sesscur(icid) := cid;
dbms_sql.parse(cid, session_cursors.getd_text, dbms_sql.native);
session_cursors.getd_open := true;
end if;
/* if you had bind variables then you would bind them before
   the execute */
r := dbms_sql.execute(cid);
dbms_sql.define_column(cid, 1, x, 1);
r := dbms_sql.fetch_rows(cid);
dbms_sql.column_value(cid, 1, x);
dbms_output.put_line('dummy is ' || x);
end;
/

If you execute each of these in SQL*Plus you'll see one parse/execute of
'select dummy from dual' for the first two examples but you'll see only
one parse of 'select dummy from dual' for the last example.

* * *

This is what I meant in my original note.


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

Upcoming events:
- Hotsos Clinic, Dec 9-11 Honolulu
- 2003 Hotsos Symposium on OracleR System Performance, Feb 9-12 Dallas
- Jonathan Lewis' Optimising Oracle, Nov 19-21 Dallas


-Original Message-
[EMAIL PROTECTED]
Sent: Monday, November 18, 2002 5:33 AM
To: Multiple recipients of list ORACLE-L

Cary,

This is one topic I'll disagree with you.  Assume an application
that uses
the database, but is on a machine outside the db server.  Having a
number of
calls that return one or two rows will have a negative network impact
that is
the results of SQL*Net and it's inefficiencies.  It is better in this
case to
encapsulate all of the database interaction into a package where bind
variables
will be used to return the desired results.  Using DBMS_SQL is a really
BAD
thing to do for stuff like that.  OH, I really think that using DBMS_SQL
is a
whole lot easier, for some things that is, than PRO*C's prepare,
declare, open,
fetch, and close especially if you have to use that unwieldy SQLDA.
Lastly, I
am not a proponent of having the application merge result sets.  Most
times the
merged results are smaller in size than the sum of the source giving
your
network one heck of a headache.

BTW: I don't evaluate applications by their BCHR, but by their
response
time.  Hit the return key, if I get an answer back in 10 seconds from
the
original and 5 seconds from the revised, something was done right.

Dick Goulet

Reply Separator
Author: "Cary Millsap" <[EMAIL PROTECTED]>
Date:   11/16/2002 1:49 AM

Greg,

That's one case. PL/SQL is a really poor language in which to write an
application. The language tricks you into believing that writing a
scalable application can be accomplished in just a few lines of 4GL
code, but it's really not true. To write scalable PL/SQL, you need to
use DBMS_SQL. The resulting code is even more cumbersome than the same
function written in Pro*C.

Any language can be abused, though. We see a lot of Java, Visual Basic,
and Powerbuilder applications that do stuff

RE: move USERS tablespace to locally managed

2002-11-18 Thread Connor McDonald 
One thing my article did not cover was of course the
possibility that you end with up with a miniscule
"extent" size multiple in the bitmap because you have
to existing extent sizes that are close to being
relatively prime.

Will this hurt...dunno really.  I haven't played with
deliberately distorting the bitmaps in this way

hth
connor

 --- "Mercadante, Thomas F" <[EMAIL PROTECTED]>
wrote: > Mark,
> 
> Thanks for the reference.  But it seems to quibble
> with detail that may not
> affect very many people.  My conclusion after
> reading of what was found is
> to go ahead and use the package.  If you experience
> the error reported, then
> the site gives an appropriate work-around.
> 
> It dopes not, however, express any real reservation
> for not using the
> package.
> 
> Tom Mercadante
> Oracle Certified Professional
> 
> 
> -Original Message-
> Sent: Monday, November 18, 2002 9:09 AM
> To: Multiple recipients of list ORACLE-L
> 
> 
> Tom,
> 
> There are actually reasons not to use the package
> Oracle supplies to go
> from DMT to LMT.  For the full details, see Connor
> McDonald's paper on
> http://www.oaktable.net/ .
> 
> -Mark
> 
> On Mon, 2002-11-18 at 08:08, Mercadante, Thomas F
> wrote:
> > John,
> > 
> > Why would you *not* want to use the package
> provided by Oracle?
> > 
> > The answer to your question is to:
> > 
> > 1). create a new USERS tablespace
> > 2). issue ALTER TABLE table_name MOVE
> new_tablespace commands
> > 3). issue ALTER INDEX index_name REBUILD commands.
> > 4). issue ALTER USER username DEFAULT TABLESPACE
> new_tablespace; 
> > 5). drop the old tablespace.
> > 
> > hope this helps.
> > 
> > Tom Mercadante
> > Oracle Certified Professional
> > 
> > 
> > -Original Message-
> > Sent: Monday, November 18, 2002 7:03 AM
> > To: Multiple recipients of list ORACLE-L
> > 
> > 
> > If I want to move my USERS tablespace to locally
> managed(without using
> > dbms_admin.migrate_to_local), what are the steps I
> need to take?
> > 
> > John
> > 
> > 
> > John Dunn
> > Sefas Innovation Ltd
> > 0117 9154267
> > www.sefas.com
> > 
> -- 
> --
> Mark J. Bobak
> Oracle DBA
> [EMAIL PROTECTED]
> "It is not enough to have a good mind.  The main
> thing is to use it
> well."
>   -- Rene Descartes
> -- 
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> -- 
> Author: Mark J. Bobak
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051
> http://www.fatcity.com
> San Diego, California-- Mailing list and web
> hosting services
>
-
> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of
> 'ListGuru') and in
> the message BODY, include a line containing: UNSUB
> ORACLE-L
> (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
> http://www.fatcity.com
> San Diego, California-- Mailing list and web
> hosting services
>
-
> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of
> 'ListGuru') and in
> the message BODY, include a line containing: UNSUB
> ORACLE-L
> (or the name of mailing list you want to be removed
> from).  You may
> also send the HELP command for other information
> (like subscribing). 

=
Connor McDonald
http://www.oracledba.co.uk
http://www.oaktable.net

"GIVE a man a fish and he will eat for a day. But TEACH him how to fish, and...he will 
sit in a boat and drink beer all day"

__
Do You Yahoo!?
Everything you'll ever need on one web page
from News and Sport to Email and Music Charts
http://uk.my.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: =?iso-8859-1?q?Connor=20McDonald?=
  INET: [EMAIL PROTECTED]

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

[Q] ORACLE 9i fast_start_mttr_target and log_checkpoint_interval parameter?

2002-11-18 Thread dist cash 



I saw a document mention if log_checkpoint_interval define on ORACLE 9i,
the fast_start_mttr_target parameter will be ignore.  My question is:

1. we have following on init.ora file:

   log_checkpoint_interval = 1
   log_checkpoint_timeout = 1800
   log_checkpoints_to_alert = true

   fast_start_mttr_target=300

Do I need remove all the log_checkpoint*  on init.ora file?

2. what kind of benefit that fast_start_mttr_target better than
log_checkpoint*  ?


Thanks



_
The new MSN 8: smart spam protection and 2 months FREE*  
http://join.msn.com/?page=features/junkmail

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

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

set arraysize in Pro*C

2002-11-18 Thread Govind . Arumugam 
Dear List-Members,

Some of the batch queries can be improved by increasing the arraysize to 1000 ( the 
default in SQL*Plus is 15);  I would like to find out the equivalent of this in Pro*C 
programs.

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

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

RE: raw versus Mounted File Systems ...

2002-11-18 Thread Khedr, Waleed 
1)It's your choice. Both could be done.
2)No


-Original Message-
Sent: Monday, November 18, 2002 10:19 AM
To: Multiple recipients of list ORACLE-L



Qs.Using Veritas for Striping across Raw Devices ,creates a RAW partition or
Mounted Filesystem?

Qs Like Filesysem Block Size (e.g. 8K) , is there a Concept of Block-size on
raw devices / partitions ?


-Original Message-
Sent: Monday, November 18, 2002 1:03 PM
To: Multiple recipients of list ORACLE-L


EMC has hardware (raw) striping now. Also could be done by Veritas.

Waleed

-Original Message-
Sent: Sunday, November 17, 2002 9:53 PM
To: Multiple recipients of list ORACLE-L



Is it possible to STRIPE a File Across a Set of RAW Devices/Disks (like RAID
0) to give IO/Load Balancing ?

If so how ?

Thanks

P.S. Links , Docs on raw versus Mounted FS also needed.

To:   <[EMAIL PROTECTED]>, <[EMAIL PROTECTED]>,
  <[EMAIL PROTECTED]>
cc:



Any Good Docs , Links , sources ?

Need to present a paper to the Managers

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

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

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

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

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

RE: raw versus Mounted File Systems

2002-11-18 Thread DENNIS WILLIAMS 
Mark - Thanks very much. You are right, that Cary guy really nails those
performance issues. The original paper date is 1992. I guess that if you say
something about Oracle over 10 years ago and it is still relevant, that
would have to qualify as a classic.

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


-Original Message-
Sent: Monday, November 18, 2002 8:04 AM
To: Multiple recipients of list ORACLE-L


Dennis,

I think the paper you ae thinking of is "Makingthe decision to use raw
devices", and it's MetaLink Doc ID 29676.1.  It was written by this guy
named Cary Millsap, who seems to think he knows a thing or two about
Oracle performance tuning;-)

-Mark

On Mon, 2002-11-18 at 08:28, DENNIS WILLIAMS wrote:
> Vivek - There used to be a good paper on Oracle's website. The paper asked
> the question: "If benchmarks show raw to be faster that file systems, why
> don't you see a difference in production?" The answer the paper provided
is
> that on a well-tuned OLTP system, disk isn't the bottleneck. There are
many
> users performing many different tasks simultaneously, and not everyone is
> sitting around waiting for disk. I looked around on Oracle's Web site, but
I
> can't find the paper there now. Maybe someone else will recall this paper.
> 
> Dennis Williams
> DBA, 40%OCP
> Lifetouch, Inc.
> [EMAIL PROTECTED] 
> 
> 
> -Original Message-
> Sent: Saturday, November 16, 2002 12:08 PM
> To: Multiple recipients of list ORACLE-L
> 
> 
> There is an (older) paper on www.jlcomp.demon.co.uk,
> and some very good info on www.ixora.com.au
> 
> hth
> connor
> 
>  --- VIVEK_SHARMA <[EMAIL PROTECTED]> wrote: > 
> > Any Good Docs , Links , sources ?
> > 
> > Need to present a paper to the Managers
> > 
> > Thanks
> > 
> > 
> > --
> > Please see the official ORACLE-L FAQ:
> > http://www.orafaq.com
> > --
> > Author: VIVEK_SHARMA
> >   INET: [EMAIL PROTECTED]
> > 
> > Fat City Network Services-- 858-538-5051
> > http://www.fatcity.com
> > San Diego, California-- Mailing list and web
> > hosting services
> >
> -
> > To REMOVE yourself from this mailing list, send an
> > E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of
> > 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB
> > ORACLE-L
> > (or the name of mailing list you want to be removed
> > from).  You may
> > also send the HELP command for other information
> > (like subscribing). 
> 
> =
> Connor McDonald
> http://www.oracledba.co.uk
> http://www.oaktable.net
> 
> "GIVE a man a fish and he will eat for a day. But TEACH him how to fish,
> and...he will sit in a boat and drink beer all day"
> 
> __
> Do You Yahoo!?
> Everything you'll ever need on one web page
> from News and Sport to Email and Music Charts
> http://uk.my.yahoo.com
-- 
--
Mark J. Bobak
Oracle DBA
[EMAIL PROTECTED]
"It is not enough to have a good mind.  The main thing is to use it
well."
-- Rene Descartes
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Mark J. Bobak
  INET: [EMAIL PROTECTED]

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

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

Re:RE: New development in Cobol or PL/SQL - please help

2002-11-18 Thread Gene Sais 
I disagree with your last statement.  Since IBM purchased informix, we are in battle 
with their so-called concurrent licensing ripoff. 

>>> [EMAIL PROTECTED] 11/17/02 09:43PM >>>
Ron,

Thankyou, I appreciate it.  And for the individual who proposed that it
might be better to do it in Pro*Cobol for database independence.  We have had
the thought of dumping Oracle for it's DB/2 competitor, until we found out that
DB/2 was no cheaper than Oracle in the end run.  Probably the only benefit is
that IBM is more slack on enforcing their licenses.

Dick Goulet

Reply Separator
Author: Ron/Sarah Yount <[EMAIL PROTECTED]>
Date:   11/16/2002 2:53 PM

In the "for what it is worth" department:

In addition to Dick's comments (with which I agree)

Be careful how you approach this situation.  If you wish to succeed, it
may be key to let the powers that be know that you are not proposing
bleeding edge solutions, and that looking down the road towards total
cost of ownership and supporting the application, it may behoove them to
consider something more mainstream.

Nobody ever truly wins a discussion by starting an argument with someone
in a higher level of authority.

Perhaps you should inquire about the "why" of the decisions so you
understand the key issues to address to propose a better one.

Good Luck,

Yep, even technical decisions require us to exercise high levels of
diplomacy :-)

-Ron-

-Original Message-
[EMAIL PROTECTED] 
Sent: Saturday, November 16, 2002 3:13 PM
To: Multiple recipients of list ORACLE-L


Babette,

This is one of those "from this old turd to that old fart" messages.
I've been around Oracle since 1985 & I love it too.  But it sounds like
the director has a serious problem with new technology.  Doing anything
in COBOL today?  Even PeopleSoft is busy re-writing their code in C++.
Seesh his age is seriously showing.  Oracle already has an adapter to MQ
series, why re-invent the wheel when someone else has already done a
better job of it.  Then code the business logic in PL/SQL so that not
only can this application use it, but any other that comes around.  I
believe it's known as code reuse.  Another old term.  You might start
off by handing him a copy of Oracle 8i new features & functions.  BTW:
add a copy of the 9i edition as well.

Dick Goulet

Reply Separator
Author: "Babette Turner-Underwood" <[EMAIL PROTECTED]>
Date:   11/15/2002 2:24 PM

I just found out today that we have a major development initiative that
is starting and they are planning on using Pro*Cobol to develop the
application. (my head is still shaking in disbelief!!!)

So we will have a Java front-end, invoking MQ series that will go across
to the mainframe for MQ series to invoke Pro*Cobol programs that will
then do the processing (accessing data and doing calculations) and then
return data.

If anyone has been in this or a similar situation, please help. I need
some really good arguments as to why we should put the business logic
into PL/SQL instead of Pro*Cobol.

I understand the reason we are using Oracle is that the director has 15
years experience with it and loves it.  Aaargh!!!

thanks
Babette

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

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

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

FW: Export from Previous Release

2002-11-18 Thread John Weatherman 
I didn't see this show up this morning, so I'm asking again...

-Original Message-

Hi all,

My developers are using a 9iR2 client and need to run exports
against a 9iR1 instance.  Has anyone seen anything like this?
I seem to remember a descussion at one point saying that it
was possible to run the catexp from a later version in an
earlier release and have this work.  We would not need to use
the 9iR2 exp/imp utilities, just the 9iR2 ones.  I am in a 
Solaris8/Veritas Clustered environment, so I am trying to avoid
having to install multiple clients (I need the 9iR2 client for
access to OEM).

TIA,

John P Weatherman
Database Administrator
Replacements Ltd.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: John Weatherman
  INET: [EMAIL PROTECTED]

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

2002-11-18 Thread VIVEK_SHARMA 

Qs.Using Veritas for Striping across Raw Devices ,creates a RAW partition or Mounted 
Filesystem?

Qs Like Filesysem Block Size (e.g. 8K) , is there a Concept of Block-size on raw 
devices / partitions ?


-Original Message-
Sent: Monday, November 18, 2002 1:03 PM
To: Multiple recipients of list ORACLE-L


EMC has hardware (raw) striping now. Also could be done by Veritas.

Waleed

-Original Message-
Sent: Sunday, November 17, 2002 9:53 PM
To: Multiple recipients of list ORACLE-L



Is it possible to STRIPE a File Across a Set of RAW Devices/Disks (like RAID
0) to give IO/Load Balancing ?

If so how ?

Thanks

P.S. Links , Docs on raw versus Mounted FS also needed.

To:   <[EMAIL PROTECTED]>, <[EMAIL PROTECTED]>,
  <[EMAIL PROTECTED]>
cc:



Any Good Docs , Links , sources ?

Need to present a paper to the Managers

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

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

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

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

RE: Anyone using Net appliance near store r100

2002-11-18 Thread DENNIS WILLIAMS 
Joe - We have a Net Appliance on our test system. It works well for that
purpose, but I wouldn't use it for a critical production application. What
are they planning to use it for? We have had ours for maybe a year - have
they made some improvements since then? How are you planning to hook it in -
fiber?


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

-Original Message-
Sent: Monday, November 18, 2002 8:49 AM
To: Multiple recipients of list ORACLE-L


I've got a new client thats just about sold on it but they are looking for
third party verification of anyone using it and if it works as stated.
 
thanks, joe
 

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

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

RE: Oracle on MVS able to submit JCL ??

2002-11-18 Thread Mirsky, Greg 
Babette,

If you are on a UNIX platfrom you can ftp the JCL directly to the JES reader
to submit a job on the mainframe. You need to set the parameter "site
filetype=JES". On my web site (http://www.oracle-developer.us/code.htm) I
have code posted to allow Oracle 8i or greater to FTP directly from Oracle.

Here is an example using just UNIX:

HOW TO SUBMIT A MAINFRAME BATCH JOB FROM UNIX

STEP ONE: Create your jcl in a unix file. remember to use all upper case!

EXAMPLE: iefbr14.jcl

//M33TEST1 JOB (HRP,TEST),M33,CLASS=V,MSGCLASS=X,NOTIFY=M33
//STEP01  EXEC PGM=IEFBR14
//DD1   DD DSN=M33.TEST.FILE2,
// UNIT=HRSDA,
// SPACE=(CYL,(1,1),RLSE),
// DCB=(RECFM=FB,LRECL=080,BLKSIZE=27920,DSORG=PS),
// DISP=(NEW,CATLG,DELETE)
//SYSPRINT DD SYSOUT=*
//SYSOUT   DD SYSOUT=*
//*

STEP TWO: Create a job script to FTP your JCL to the mainframe. 
  192.6.1.79 is the address of the mainframe for this example.
  'uid' should be replaced with your user id.
  'password' should be replaced with your password.
  'iefbr14.jcl' is the file that we created in step one.
  Remember to grant execute rights to the job script using chmod.


### ftp a job to be submitted on the mainframe

ftp -vn 192.6.1.79

RE: move USERS tablespace to locally managed

2002-11-18 Thread Mercadante, Thomas F 
Mark,

Thanks for the reference.  But it seems to quibble with detail that may not
affect very many people.  My conclusion after reading of what was found is
to go ahead and use the package.  If you experience the error reported, then
the site gives an appropriate work-around.

It dopes not, however, express any real reservation for not using the
package.

Tom Mercadante
Oracle Certified Professional


-Original Message-
Sent: Monday, November 18, 2002 9:09 AM
To: Multiple recipients of list ORACLE-L


Tom,

There are actually reasons not to use the package Oracle supplies to go
from DMT to LMT.  For the full details, see Connor McDonald's paper on
http://www.oaktable.net/ .

-Mark

On Mon, 2002-11-18 at 08:08, Mercadante, Thomas F wrote:
> John,
> 
> Why would you *not* want to use the package provided by Oracle?
> 
> The answer to your question is to:
> 
> 1). create a new USERS tablespace
> 2). issue ALTER TABLE table_name MOVE new_tablespace commands
> 3). issue ALTER INDEX index_name REBUILD commands.
> 4). issue ALTER USER username DEFAULT TABLESPACE new_tablespace; 
> 5). drop the old tablespace.
> 
> hope this helps.
> 
> Tom Mercadante
> Oracle Certified Professional
> 
> 
> -Original Message-
> Sent: Monday, November 18, 2002 7:03 AM
> To: Multiple recipients of list ORACLE-L
> 
> 
> If I want to move my USERS tablespace to locally managed(without using
> dbms_admin.migrate_to_local), what are the steps I need to take?
> 
> John
> 
> 
> John Dunn
> Sefas Innovation Ltd
> 0117 9154267
> www.sefas.com
> 
-- 
--
Mark J. Bobak
Oracle DBA
[EMAIL PROTECTED]
"It is not enough to have a good mind.  The main thing is to use it
well."
-- Rene Descartes
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Mark J. Bobak
  INET: [EMAIL PROTECTED]

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

RE: AIX vs Solaris

2002-11-18 Thread Gogala, Mladen 



HP-UX 
does support async I/O. /you only need to include /dev/async in the 
kernel.
IBM 
and SUN support async I/O, too. Linux does not.

  -Original Message-From: Rich Holland 
  [mailto:[EMAIL PROTECTED]]Sent: Sunday, November 17, 2002 
  9:19 AMTo: Multiple recipients of list ORACLE-LSubject: 
  RE: AIX vs Solaris
  
  John,
   
  You should be able to 
  tune the SCSI device queue depth; I’ve done this on HP-UX and Solaris systems, 
  but haven’t had to under AIX yet.  I don’t have an AIX system handy to 
  verify this, but I’m 90% sure you can do it.  AIX also supports async I/O 
  where HP-UX doesn’t (not sure about Sun), which is a big win in an Oracle 
  environment.
   
  Rich 
  Holland
  Guidance 
  Technologies, Inc.
   
  
  -Original 
  Message-From: 
  [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of John ShawSent: Wednesday, November 13, 2002 3:06 
  PMTo: Multiple recipients of 
  list ORACLE-LSubject: Re: 
  AIX vs Solaris
   
  We had an aix box and ended 
  sending it back and going with sun - only because we had a hitachi san and 
  there seems to be a bug between ibm and hitachi - something about depth 
  queue.>>> [EMAIL PROTECTED] 11/13/02 12:48PM 
  >>>Hello,What are the major differences between AIX 
  and Solaris regardingoperating system features?We are planning a 
  new machine purchase; currently we are on a Sun machinerunning Solaris, 
  but IBM is making a strong proposal to management(meaning significantly 
  less cost), and we are wondering what would need to bechanged. We use korn 
  shell scripts extensively, and features such ascrontab, background 
  processing, the sqlplus

RE: Query elapsed time

2002-11-18 Thread Shao, Chunning 
V$session_longops only store info for create index, etc, not query.
Oracle use buffer_gets/500 as estimated time, you can get it at v$sql, v$sqlarea

-Original Message-
Sent: Monday, November 18, 2002 3:43 AM
To: Multiple recipients of list ORACLE-L


Dick
V$session_longops has a column elapsed_seconds and a sid column

HTH

John

-Original Message-
Sent: 15 November 2002 18:59
To: Multiple recipients of list ORACLE-L


Quick question,  Does anyone know of a location in the V$ tables where the
elapsed time of the current query is stored??

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

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

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

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

2002-11-18 Thread Charu Joshi 
Try using the 'Home Selector' utility to set the appropriate default home
and then give it a go.

Regards,
Charu.

-Original Message-
Sent: Friday, November 15, 2002 3:49 PM
To: Multiple recipients of list ORACLE-L

We are testing the ORACLE 9iR2 client server connection.  On PC side, we
installed ORACLE ODBC driver 9.2.0.2 and upgrade MS ODBC for ORACLE to
2.573.9001.000.  After configuration, ORACLE ODBC driver work fine, but MS
ODBC for ORACLE have ORA-12154 (TNS name can NOT resolve) error.  I
trouble shooting the problem and found MS ODBC for ORACLE ONLY check
"\orant\network\admin\tnsnames.ora".  The path we installed ORACLE client
on "\oracle\9.2\".  Does anyone know how to fix this problem?

Thanks.

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

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

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

*
Disclaimer

This message (including any attachments) contains 
confidential information intended for a specific 
individual and purpose, and is protected by law. 
If you are not the intended recipient, you should 
delete this message and are hereby notified that 
any disclosure, copying, or distribution of this
message, or the taking of any action based on it, 
is strictly prohibited.

*
Visit us at http://www.mahindrabt.com



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

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

Anyone using Net appliance near store r100

2002-11-18 Thread JOE TESTA 



I've got a new client thats just about sold on it but they are looking for 
third party verification of anyone using it and if it works as stated.
 
thanks, joe
 

Oracle Portal w/Single-signon

2002-11-18 Thread Jeffrey Beckstrom 



Saw demos of Oracle Portal and really liked it.  Have decided to 
implement it.  We are also running Oracle Apps 11i (11.5.3 patched to 
11.5.6+).  
 
From what I have seen it appears that portal must be installed in the 11i 
database.  This just does not seem to make sense.  Why would my 
intranet site have to be controlled by 11i availablilty.  What happens if 
11i is down for patching, etc.
 
Can someone shed some light on this.
 
Jeffrey BeckstromDatabase AdministratorGreater Cleveland Regional 
Transit Authority1240 W. 6th StreetCleveland, Ohio 44113(216) 
781-4204

RE: New development in Cobol or PL/SQL - please help

2002-11-18 Thread Jamadagni, Rajendra 
Title: RE: New development in Cobol or PL/SQL - please help





Rick,


You put BI into db using pl/sql anyways ... (well Java is another thing ..)


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-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Monday, November 18, 2002 9:19 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: New development in Cobol or PL/SQL - please help




Babette,


If they are a Cobol shop then there is nothing wrong with using Pro*Cobol.
I disagree with your statement about using PL/SQL for
the business logic. I personally think you should put as much of that in
the database.


Rick




   
    "Mercadante,   
    Thomas F"  To: Multiple recipients of list ORACLE-L    
    <[EMAIL PROTECTED]    <[EMAIL PROTECTED]> 
    ate.ny.us> cc: 
    Sent by:   Subject: RE: New development in Cobol or PL/SQL - please    
    [EMAIL PROTECTED]    help   
   
   
    11/18/2002 08:03   
    AM 
    Please respond 
    to ORACLE-L    
   
   





Babette,


The decision really comes down to the organization.  If they see themselves
as *never* leaving the Cobol arena, and they have an ample supply of Cobol
programmers, then they should stay with it.


What you could do is to make friends with the applications people, and show
them how PL/SQL works.  What you will find is that they will take to PL/SQL
like a fish to water.  And pretty soon, more and more PL/SQL packages will
be written that are simply called by the Cobol programs.  Cobol would then
be a simple entry point to the database - able to interface nicely with the
operating system (reading and writing flat files, producing reports and
forms), while the majority of the logic may be written in PL/SQL.


Maybe, just maybe, the person making the decision see's no benefit to using
PL/SQL.  And given your local labor market, maybe he's right!


Tom Mercadante
Oracle Certified Professional



-Original Message-
Sent: Sunday, November 17, 2002 1:18 PM
To: Multiple recipients of list ORACLE-L



"Khedr, Waleed" wrote:
>
> Cobol! Again!:(
>
> -Original Message-
> Sent: Friday, November 15, 2002 5:24 PM
> To: Multiple recipients of list ORACLE-L
>
> I just found out today that we have a major development initiative that
is
> starting and they are planning on using Pro*Cobol to develop the
> application. (my head is still shaking in disbelief!!!)
>
> So we will have a Java front-end, invoking MQ series that will go across
to
> the mainframe for MQ series to invoke Pro*Cobol programs that will then
do
> the processing (accessing data and doing calculations) and then return
data.
>
> If anyone has been in this or a similar situation, please help.
> I need some really good arguments as to why we should put the business
logic
> into PL/SQL instead of Pro*Cobol.
>
> I understand the reason we are using Oracle is that the director has 15
> years experience with it and loves it.  Aaargh!!!
>
> thanks
> Babette
>


May I play the devil's advocate? Even if Pro*Cobol seems to be a weird
choice, there may be a case for not coding the logic in PL/SQL :
database portability. I have heard recently of a very, very, very big
company dumping Oracle in favour of DB2. Reason ? Cost. I guess that in
such a case, porting a Pro*Cobol program is easier than PL/SQL.


--
Regards,


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

Re: Event 10046 and Performance

2002-11-18 Thread John Shaw 


I am in the middle of this fight myself. We 
had an Oracle consultant come in to look at our performance problems. He spent a 
3 days examing the sql and coming up with various reasons that our code was 
slow. Then the "BUG" cropped up - one of his reports that had been running great 
all of a sudden started taking forever (3min vs 15min) to come back - His answer 
was to file a tar - which is where I am at now. After several rda runs we still 
don't have and answer.>>> 
[EMAIL PROTECTED] 11/15/02 04:48PM >>>
Okay ... here is a curved ball ... 
This AM an application support person called and 
mentioned that we have a form that has become slow compared to 2 days ago. So we 
saw the slow behavior and then I did a 10046 trace on it.
After analysis, found that one query is taking about 
90% of total time and isolated it to be worked on. 
On our day-old instance (refreshed daily from prod), 
this form runs very fast. After comparing everything, I found that for some test 
we have db_file_multiblock_read_count = 4 whereas it is 32 (don't ask) on 
production.
So after changing this variable in my session to 4 
(on production), I checked the explain plan and it seems to be okay, picking up 
the right indexes etc.
So, I asked the support person to add following line 
in pre-form trigger on the form and run a test 
forms_ddl('alter session set 
db_file_multiblock_read_count=4'); 
ran the form, no change in the performance. So I 
requested following like to be addes as well 
forms_ddl('alter session set events ''10046 trace 
name context forever, level 8'''); 
The form runs as fast as it can. 
So we thought maybe flushing the shared pool might 
help, so we flushed the shared pool (again don't ask, this is prod env, lunch 
time, light load).
Still same, with 10046 event set, the form runs as 
fast as it can, but if I take it out, it slows down. 
I am confused ... does anyone have a plausible 
explanation on why this is happening? 
Oracle 9201, AIX 5l 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!

RE: AIX vs Solaris

2002-11-18 Thread John Shaw 


We had IBM 
come in and try to tune the depth queue - apparently there is some bug between 
their aix box and the hitachi san - they could only get a depth queue of 1 - 
whereas the sun box could go to a depth queue of 32. >>> 
[EMAIL PROTECTED] 11/17/02 08:18AM >>>

John,
 
You should be able to 
tune the SCSI device queue depth; I’ve done this on HP-UX and Solaris systems, 
but haven’t had to under AIX yet.  I don’t have an AIX system handy to 
verify this, but I’m 90% sure you can do it.  AIX also supports async I/O 
where HP-UX doesn’t (not sure about Sun), which is a big win in an Oracle 
environment.
 
Rich 
Holland
Guidance Technologies, 
Inc.
 

-Original 
Message-From: 
[EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On 
Behalf Of John ShawSent: Wednesday, November 13, 2002 3:06 
PMTo: Multiple recipients of 
list ORACLE-LSubject: Re: AIX 
vs Solaris
 
We had an aix box and ended sending 
it back and going with sun - only because we had a hitachi san and there seems 
to be a bug between ibm and hitachi - something about depth 
queue.>>> [EMAIL PROTECTED] 11/13/02 12:48PM 
>>>Hello,What are the major differences between AIX and 
Solaris regardingoperating system features?We are planning a new 
machine purchase; currently we are on a Sun machinerunning Solaris, but IBM 
is making a strong proposal to management(meaning significantly less cost), 
and we are wondering what would need to bechanged. We use korn shell scripts 
extensively, and features such ascrontab, background processing, the sqlplus

RE: Oracle Developer Application Tuning Resources/Guidlines.

2002-11-18 Thread DENNIS WILLIAMS 
You should take a look at the book "Oracle Performance Tuning 101" as a good
foundation.



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

-Original Message-
Sent: Saturday, November 16, 2002 11:23 PM
To: Multiple recipients of list ORACLE-L




Hi All !

I am new to Application Tuning

i have the following queries:

0) where & how to start?? the key areas in application tuning.

1) the tips & techniques..

2)useful tools & scripts

3) othere resources [docs, websites etc]

Best Regards

 




  _  

Do you Yahoo!?
Yahoo!  
Web Hosting - Let the expert host your site

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

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

RE: RMAN backup

2002-11-18 Thread DENNIS WILLIAMS 
Joe - Which type of RMAN backup are you doing? If you are doing RMAN
datafile backups, then the size of your datafiles matter. If you are using
the RMAN backup command, you are creating RMAN backup pieces. RMAN backup
pieces contain parts of several data files, and you can't control that. You
can control the maximum size of each piece.

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


-Original Message-
Sent: Saturday, November 16, 2002 2:33 PM
To: Multiple recipients of list ORACLE-L


Joe & Tim,

It is accurate to state the both full and level 0 have the same impact
on the database, and both backup all used blocks.  It is also accurate
that a full backup cannot be used as a piece of an incremental strategy.
Although there may be rare instances (no pun intended :-) ) when you
want to use a full backup (e.g. separate from your incremental flow) I
never use full backups in RMAN myself.

If you want to reduce the size of your backups:
1) Reduce the size of segments by reorging data (yes, I now this is
stating the obvious)
2) Make any tablespaces containing static data read-only (thereby
skipping them in RMAN after level 0)
3) Use an incremental strategy (level 0, 1...) Of course  you must
balance MTTR.

If you just need to reduce disk space utilized, consider integrating
RMAN with your backup vendor's software (Legato, Veritas...) so the
backups go directly to tape.

HTH,
-Ron-

Joe, nice to see you still contributing to this group.  Hope all is
well.

-Ron-

-Original Message-
Sent: Saturday, November 16, 2002 1:33 PM
To: Multiple recipients of list ORACLE-L


Tim, i'd be glad to hear someone else verify your statement as my 
understanding is the the only difference between full and level 0 is 
that full cannot be used as part of an incremental strategy, other than 
that they both back up the "ever used" blocks.

Anyone else care to jump in on this one?

joe


Tim Gorman wrote:

>How about switching to incremental (from "full") backups?  Even if all 
>you do are level-0 backups?
>
>My understanding of the difference between a "full" and a "level-0" 
>backup (besides the obvious impact on any subsequent level-n 
>incremental backups) is that level-0 backups only back up database 
>blocks that are currently in use, as opposed to "full" backups which 
>back up all database blocks which have ever been used (i.e. no longer 
>"unformatted").
>
>- Original Message -
>To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
>Sent: Friday, November 15, 2002 9:39 PM
>
>
>  
>
>>Hello All,
>>
>>Is resizing the datafiles the only way of reducing the size of an RMAN
>>
>>
>full
>  
>
>>backup? Oracle Version 8.0.6. We take RMAN hot backups to disk, and 
>>the size of the backup has grown considerably. There's one large table

>>which
>>
>>
>we
>  
>
>>were considering truncating. But looks like that would not reduce the 
>>size of the backup. Dropping the table will call for an production 
>>outage.  I
>>
>>
>am
>  
>
>>considering moving the table to another tablespace, and dropping the 
>>existing one. Any ideas?
>>
>>Thanks
>>Raj
>>
>>--
>>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>>--
>>Author:
>>  INET: [EMAIL PROTECTED]
>>
>>Fat City Network Services-- 858-538-5051 http://www.fatcity.com
>>San Diego, California-- Mailing list and web hosting services
>>-
>>To REMOVE yourself from this mailing list, send an E-Mail message
>>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in 
>>the message BODY, include a line containing: UNSUB ORACLE-L (or the 
>>name of mailing list you want to be removed from).  You may also send 
>>the HELP command for other information (like subscribing).
>>
>>
>
>  
>

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

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

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

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

RE: New development in Cobol or PL/SQL - please help

2002-11-18 Thread Rick_Cale 

Babette,

If they are a Cobol shop then there is nothing wrong with using Pro*Cobol.
I disagree with your statement about using PL/SQL for
the business logic. I personally think you should put as much of that in
the database.

Rick



   

"Mercadante,   

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

ate.ny.us> cc: 

Sent by:   Subject: RE: New development in Cobol 
or PL/SQL - please
[EMAIL PROTECTED]help   

   

   

11/18/2002 08:03   

AM 

Please respond 

to ORACLE-L

   

   





Babette,

The decision really comes down to the organization.  If they see themselves
as *never* leaving the Cobol arena, and they have an ample supply of Cobol
programmers, then they should stay with it.

What you could do is to make friends with the applications people, and show
them how PL/SQL works.  What you will find is that they will take to PL/SQL
like a fish to water.  And pretty soon, more and more PL/SQL packages will
be written that are simply called by the Cobol programs.  Cobol would then
be a simple entry point to the database - able to interface nicely with the
operating system (reading and writing flat files, producing reports and
forms), while the majority of the logic may be written in PL/SQL.

Maybe, just maybe, the person making the decision see's no benefit to using
PL/SQL.  And given your local labor market, maybe he's right!

Tom Mercadante
Oracle Certified Professional


-Original Message-
Sent: Sunday, November 17, 2002 1:18 PM
To: Multiple recipients of list ORACLE-L


"Khedr, Waleed" wrote:
>
> Cobol! Again!:(
>
> -Original Message-
> Sent: Friday, November 15, 2002 5:24 PM
> To: Multiple recipients of list ORACLE-L
>
> I just found out today that we have a major development initiative that
is
> starting and they are planning on using Pro*Cobol to develop the
> application. (my head is still shaking in disbelief!!!)
>
> So we will have a Java front-end, invoking MQ series that will go across
to
> the mainframe for MQ series to invoke Pro*Cobol programs that will then
do
> the processing (accessing data and doing calculations) and then return
data.
>
> If anyone has been in this or a similar situation, please help.
> I need some really good arguments as to why we should put the business
logic
> into PL/SQL instead of Pro*Cobol.
>
> I understand the reason we are using Oracle is that the director has 15
> years experience with it and loves it.  Aaargh!!!
>
> thanks
> Babette
>

May I play the devil's advocate? Even if Pro*Cobol seems to be a weird
choice, there may be a case for not coding the logic in PL/SQL :
database portability. I have heard recently of a very, very, very big
company dumping Oracle in favour of DB2. Reason ? Cost. I guess that in
such a case, porting a Pro*Cobol program is easier than PL/SQL.

--
Regards,

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

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

RE: move USERS tablespace to locally managed

2002-11-18 Thread Mark J. Bobak 
Tom,

There are actually reasons not to use the package Oracle supplies to go
from DMT to LMT.  For the full details, see Connor McDonald's paper on
http://www.oaktable.net/ .

-Mark

On Mon, 2002-11-18 at 08:08, Mercadante, Thomas F wrote:
> John,
> 
> Why would you *not* want to use the package provided by Oracle?
> 
> The answer to your question is to:
> 
> 1). create a new USERS tablespace
> 2). issue ALTER TABLE table_name MOVE new_tablespace commands
> 3). issue ALTER INDEX index_name REBUILD commands.
> 4). issue ALTER USER username DEFAULT TABLESPACE new_tablespace; 
> 5). drop the old tablespace.
> 
> hope this helps.
> 
> Tom Mercadante
> Oracle Certified Professional
> 
> 
> -Original Message-
> Sent: Monday, November 18, 2002 7:03 AM
> To: Multiple recipients of list ORACLE-L
> 
> 
> If I want to move my USERS tablespace to locally managed(without using
> dbms_admin.migrate_to_local), what are the steps I need to take?
> 
> John
> 
> 
> John Dunn
> Sefas Innovation Ltd
> 0117 9154267
> www.sefas.com
> 
-- 
--
Mark J. Bobak
Oracle DBA
[EMAIL PROTECTED]
"It is not enough to have a good mind.  The main thing is to use it
well."
-- Rene Descartes
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Mark J. Bobak
  INET: [EMAIL PROTECTED]

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

2002-11-18 Thread Mark J. Bobak 
Dennis,

I think the paper you ae thinking of is "Makingthe decision to use raw
devices", and it's MetaLink Doc ID 29676.1.  It was written by this guy
named Cary Millsap, who seems to think he knows a thing or two about
Oracle performance tuning;-)

-Mark

On Mon, 2002-11-18 at 08:28, DENNIS WILLIAMS wrote:
> Vivek - There used to be a good paper on Oracle's website. The paper asked
> the question: "If benchmarks show raw to be faster that file systems, why
> don't you see a difference in production?" The answer the paper provided is
> that on a well-tuned OLTP system, disk isn't the bottleneck. There are many
> users performing many different tasks simultaneously, and not everyone is
> sitting around waiting for disk. I looked around on Oracle's Web site, but I
> can't find the paper there now. Maybe someone else will recall this paper.
> 
> Dennis Williams
> DBA, 40%OCP
> Lifetouch, Inc.
> [EMAIL PROTECTED] 
> 
> 
> -Original Message-
> Sent: Saturday, November 16, 2002 12:08 PM
> To: Multiple recipients of list ORACLE-L
> 
> 
> There is an (older) paper on www.jlcomp.demon.co.uk,
> and some very good info on www.ixora.com.au
> 
> hth
> connor
> 
>  --- VIVEK_SHARMA <[EMAIL PROTECTED]> wrote: > 
> > Any Good Docs , Links , sources ?
> > 
> > Need to present a paper to the Managers
> > 
> > Thanks
> > 
> > 
> > --
> > Please see the official ORACLE-L FAQ:
> > http://www.orafaq.com
> > --
> > Author: VIVEK_SHARMA
> >   INET: [EMAIL PROTECTED]
> > 
> > Fat City Network Services-- 858-538-5051
> > http://www.fatcity.com
> > San Diego, California-- Mailing list and web
> > hosting services
> >
> -
> > To REMOVE yourself from this mailing list, send an
> > E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of
> > 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB
> > ORACLE-L
> > (or the name of mailing list you want to be removed
> > from).  You may
> > also send the HELP command for other information
> > (like subscribing). 
> 
> =
> Connor McDonald
> http://www.oracledba.co.uk
> http://www.oaktable.net
> 
> "GIVE a man a fish and he will eat for a day. But TEACH him how to fish,
> and...he will sit in a boat and drink beer all day"
> 
> __
> Do You Yahoo!?
> Everything you'll ever need on one web page
> from News and Sport to Email and Music Charts
> http://uk.my.yahoo.com
-- 
--
Mark J. Bobak
Oracle DBA
[EMAIL PROTECTED]
"It is not enough to have a good mind.  The main thing is to use it
well."
-- Rene Descartes
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Mark J. Bobak
  INET: [EMAIL PROTECTED]

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

2002-11-18 Thread Connor McDonald 
select replace(input_val,search_val,replacement_val)
from ...

hth
connor

 --- John Dunn <[EMAIL PROTECTED]> wrote: > I want
to replace any carriage returns and lines
> feeds 'OD0A' and '0A' in
> string, with a  space. Can this be done with
> TRANSLATE, if so how do I code
> this?
> 
> John Dunn
> Sefas Innovation Ltd
> 0117 9154267
> www.sefas.com
> 
> -- 
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> -- 
> Author: John Dunn
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051
> http://www.fatcity.com
> San Diego, California-- Mailing list and web
> hosting services
>
-
> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of
> 'ListGuru') and in
> the message BODY, include a line containing: UNSUB
> ORACLE-L
> (or the name of mailing list you want to be removed
> from).  You may
> also send the HELP command for other information
> (like subscribing). 

=
Connor McDonald
http://www.oracledba.co.uk
http://www.oaktable.net

"GIVE a man a fish and he will eat for a day. But TEACH him how to fish, and...he will 
sit in a boat and drink beer all day"

__
Do You Yahoo!?
Everything you'll ever need on one web page
from News and Sport to Email and Music Charts
http://uk.my.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: =?iso-8859-1?q?Connor=20McDonald?=
  INET: [EMAIL PROTECTED]

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

2002-11-18 Thread Alan Davey 
Hi,

Why not just use the replace function?

select replace('Line1'||chr(10)||'Line2',chr(10),' ') from dual

select replace(my_string,chr(13)||chr(10),' ') from my_table;

HTH,
-- 

Alan Davey
[EMAIL PROTECTED]
212-604-0200  x106


On 11/18/2002 7:18 AM, John Dunn <[EMAIL PROTECTED]> wrote:
>I want to replace any carriage returns and lines feeds 'OD0A' and 
>'0A' in
>string, with a  space. Can this be done with TRANSLATE, if so how 
>do I code
>this?
>
>John Dunn
>Sefas Innovation Ltd
>0117 9154267
>www.sefas.com
>
>-- 
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>-- 
>Author: John Dunn
>  INET: [EMAIL PROTECTED]
>
>Fat City Network Services-- 858-538-5051 http://www.fatcity.com
>San Diego, California-- Mailing list and web hosting services
>-
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and 
>in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(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: Alan Davey
  INET: [EMAIL PROTECTED]

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

2002-11-18 Thread Connor McDonald 
roughly speaking

create new tablespace X
for each table
  alter table move tablespace X
for each index
  alter index rebuild tablespace X

hth
connor

 --- John Dunn <[EMAIL PROTECTED]> wrote: > If I
want to move my USERS tablespace to locally
> managed(without using
> dbms_admin.migrate_to_local), what are the steps I
> need to take?
> 
> John
> 
> 
> John Dunn
> Sefas Innovation Ltd
> 0117 9154267
> www.sefas.com
> 
> -- 
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> -- 
> Author: John Dunn
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051
> http://www.fatcity.com
> San Diego, California-- Mailing list and web
> hosting services
>
-
> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of
> 'ListGuru') and in
> the message BODY, include a line containing: UNSUB
> ORACLE-L
> (or the name of mailing list you want to be removed
> from).  You may
> also send the HELP command for other information
> (like subscribing). 

=
Connor McDonald
http://www.oracledba.co.uk
http://www.oaktable.net

"GIVE a man a fish and he will eat for a day. But TEACH him how to fish, and...he will 
sit in a boat and drink beer all day"

__
Do You Yahoo!?
Everything you'll ever need on one web page
from News and Sport to Email and Music Charts
http://uk.my.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: =?iso-8859-1?q?Connor=20McDonald?=
  INET: [EMAIL PROTECTED]

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

2002-11-18 Thread Ruth Gramolini 



And of course there is the obvious reason, a level 0 also 
backs up the controlfile.  This is essential for point in tijme 
recovery.  
 
Ruth

  - Original Message - 
  From: 
  Tim Gorman 
  
  To: Multiple recipients of list ORACLE-L 
  
  Sent: Saturday, November 16, 2002 1:23 
  PM
  Subject: Re: RMAN backup
  How about switching to incremental (from "full") backups?  
  Even if all youdo are level-0 backups?My understanding of the 
  difference between a "full" and a "level-0" backup(besides the obvious 
  impact on any subsequent level-n incremental backups)is that level-0 
  backups only back up database blocks that are currently inuse, as opposed 
  to "full" backups which back up all database blocks whichhave ever been 
  used (i.e. no longer "unformatted").- Original Message 
  -To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>Sent: 
  Friday, November 15, 2002 9:39 PM> Hello All,>> 
  Is resizing the datafiles the only way of reducing the size of an 
  RMANfull> backup? Oracle Version 8.0.6. We take RMAN hot backups to 
  disk, and the> size of the backup has grown considerably. There's one 
  large table whichwe> were considering truncating. But looks like 
  that would not reduce the size> of the backup. Dropping the table will 
  call for an production outage.  Iam> considering moving the 
  table to another tablespace, and dropping the> existing one. Any 
  ideas?>> Thanks> Raj>> --> Please 
  see the official ORACLE-L FAQ: http://www.orafaq.com> --> 
  Author:>   INET: [EMAIL PROTECTED]>> 
  Fat City Network Services    -- 858-538-5051 http://www.fatcity.com> San Diego, 
  California    -- Mailing list and web 
  hosting services> 
  -> 
  To REMOVE yourself from this mailing list, send an E-Mail message> to: 
  [EMAIL PROTECTED] (note EXACT 
  spelling of 'ListGuru') and in> the message BODY, include a line 
  containing: UNSUB ORACLE-L> (or the name of mailing list you want to be 
  removed from).  You may> also send the HELP command for other 
  information (like subscribing).-- Please see the official ORACLE-L 
  FAQ: http://www.orafaq.com-- 
  Author: Tim Gorman  INET: [EMAIL PROTECTED]Fat City Network 
  Services    -- 858-538-5051 http://www.fatcity.comSan Diego, 
  California    -- Mailing list and web 
  hosting 
  services-To 
  REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT 
  spelling of 'ListGuru') and inthe message BODY, include a line containing: 
  UNSUB ORACLE-L(or the name of mailing list you want to be removed 
  from).  You mayalso send the HELP command for other information (like 
  subscribing).

Re: Netbackup [#2]

2002-11-18 Thread Connor McDonald 
Worked at a place with NetBackup on top of RMAN for
"enterprise" backup ie about 50 servers all going to
mega storage tek tape library.  No problems with
software - just make sure the hardware infrastructure
is up to pace with what you need.  In this case, a
private backup network made a lot of difference

hth
connor

 --- "O'Neill, Sean" <[EMAIL PROTECTED]> wrote: >
Is no-one out there using NetBackup???.  
> 
> Without wishing to sound rude I'll assume a
> non-response indicates an
> affirmative to that OR that you're all too busy to
> voice an opinion ;)
> 
> -Original Message-
> Sent: Thursday, November 14, 2002 15:04
> To: 'List, OracleDBA [Fatcity]'
> 
> 
> Howdy Folks,
> 
> Would appreciate feedback on experiences, positive
> :) or negative :(, folk
> have had using Veritas NetBackup product for DB
> recovery, especially in DR
> scenarios.  There is an Oracle agent but so far all
> it appears to me to be
> is a glorious scheduler of your own RMAN scripted
> jobs!.  Feedback on
> features I may have "missed" with agent would also
> be appreciated.
> 
> -
> Seán O' Neill
> Organon (Ireland) Ltd.
> [subscribed: digest mode] 
>

> This message, including attached files, may contain
> confidential
> information and is intended only for the use by the
> individual
> and/or the entity to which it is addressed. Any
> unauthorized use,
> dissemination of, or copying of the information
> contained herein is
> not allowed and may lead to irreparable harm and
> damage for which
> you may be held liable. If you receive this message
> in error or if
> it is intended for someone else please notify the
> sender by
> returning this e-mail immediately and delete the
> message.
>

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

=
Connor McDonald
http://www.oracledba.co.uk
http://www.oaktable.net

"GIVE a man a fish and he will eat for a day. But TEACH him how to fish, and...he will 
sit in a boat and drink beer all day"

__
Do You Yahoo!?
Everything you'll ever need on one web page
from News and Sport to Email and Music Charts
http://uk.my.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: =?iso-8859-1?q?Connor=20McDonald?=
  INET: [EMAIL PROTECTED]

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

2002-11-18 Thread Mercadante, Thomas F 
Babette,

The decision really comes down to the organization.  If they see themselves
as *never* leaving the Cobol arena, and they have an ample supply of Cobol
programmers, then they should stay with it.

What you could do is to make friends with the applications people, and show
them how PL/SQL works.  What you will find is that they will take to PL/SQL
like a fish to water.  And pretty soon, more and more PL/SQL packages will
be written that are simply called by the Cobol programs.  Cobol would then
be a simple entry point to the database - able to interface nicely with the
operating system (reading and writing flat files, producing reports and
forms), while the majority of the logic may be written in PL/SQL.

Maybe, just maybe, the person making the decision see's no benefit to using
PL/SQL.  And given your local labor market, maybe he's right!

Tom Mercadante
Oracle Certified Professional


-Original Message-
Sent: Sunday, November 17, 2002 1:18 PM
To: Multiple recipients of list ORACLE-L


"Khedr, Waleed" wrote:
> 
> Cobol! Again!:(
> 
> -Original Message-
> Sent: Friday, November 15, 2002 5:24 PM
> To: Multiple recipients of list ORACLE-L
> 
> I just found out today that we have a major development initiative that is
> starting and they are planning on using Pro*Cobol to develop the
> application. (my head is still shaking in disbelief!!!)
> 
> So we will have a Java front-end, invoking MQ series that will go across
to
> the mainframe for MQ series to invoke Pro*Cobol programs that will then do
> the processing (accessing data and doing calculations) and then return
data.
> 
> If anyone has been in this or a similar situation, please help.
> I need some really good arguments as to why we should put the business
logic
> into PL/SQL instead of Pro*Cobol.
> 
> I understand the reason we are using Oracle is that the director has 15
> years experience with it and loves it.  Aaargh!!!
> 
> thanks
> Babette
> 

May I play the devil's advocate? Even if Pro*Cobol seems to be a weird
choice, there may be a case for not coding the logic in PL/SQL :
database portability. I have heard recently of a very, very, very big
company dumping Oracle in favour of DB2. Reason ? Cost. I guess that in
such a case, porting a Pro*Cobol program is easier than PL/SQL.

-- 
Regards,

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

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

2002-11-18 Thread DENNIS WILLIAMS 
Vivek - There used to be a good paper on Oracle's website. The paper asked
the question: "If benchmarks show raw to be faster that file systems, why
don't you see a difference in production?" The answer the paper provided is
that on a well-tuned OLTP system, disk isn't the bottleneck. There are many
users performing many different tasks simultaneously, and not everyone is
sitting around waiting for disk. I looked around on Oracle's Web site, but I
can't find the paper there now. Maybe someone else will recall this paper.

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


-Original Message-
Sent: Saturday, November 16, 2002 12:08 PM
To: Multiple recipients of list ORACLE-L


There is an (older) paper on www.jlcomp.demon.co.uk,
and some very good info on www.ixora.com.au

hth
connor

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

=
Connor McDonald
http://www.oracledba.co.uk
http://www.oaktable.net

"GIVE a man a fish and he will eat for a day. But TEACH him how to fish,
and...he will sit in a boat and drink beer all day"

__
Do You Yahoo!?
Everything you'll ever need on one web page
from News and Sport to Email and Music Charts
http://uk.my.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: =?iso-8859-1?q?Connor=20McDonald?=
  INET: [EMAIL PROTECTED]

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

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

RE: Event 10046 and Performance

2002-11-18 Thread Jamadagni, Rajendra 
Title: RE: Event 10046 and Performance





No, we are 9201 on Test/Prod ... we are getting ready to test 9202 though ...


As Cary suggested ... I am going to watch is today ...let's see ... it would be interesting ..


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-
From: Binley Lim [mailto:[EMAIL PROTECTED]]
Sent: Sunday, November 17, 2002 6:13 PM
To: Multiple recipients of list ORACLE-L
Subject: Re: Event 10046 and Performance




It is not uncommon to find the problem disappearing after switching debugging/tracing on, but in this case I'm wondering if its some feature with 9201? Are your test/prod on the same patch release? or you have already applied 9202 to your test environment?


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: New development in Cobol or PL/SQL - please help

2002-11-18 Thread DENNIS WILLIAMS 

Babette - For some code, PL/SQL will offer significantly better performance.
For other code it may not matter so much. One of an organization's biggest
hidden investments is their code. If they feel COBOL is where they prefer to
invest, that isn't the end of the world. For one thing, it doesn't tie them
as closely to Oracle as coding everything in PL/SQL would. If you want
better reasons not to do this, you need to nose around and find who the
players are and what is their motivation. Arguments succeed much better when
you know your audience.

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


-Original Message-
Sent: Friday, November 15, 2002 4:24 PM
To: Multiple recipients of list ORACLE-L


I just found out today that we have a major development initiative that is
starting and they are planning on using Pro*Cobol to develop the
application. (my head is still shaking in disbelief!!!)

So we will have a Java front-end, invoking MQ series that will go across to
the mainframe for MQ series to invoke Pro*Cobol programs that will then do
the processing (accessing data and doing calculations) and then return data.

If anyone has been in this or a similar situation, please help.
I need some really good arguments as to why we should put the business logic
into PL/SQL instead of Pro*Cobol.

I understand the reason we are using Oracle is that the director has 15
years experience with it and loves it.  Aaargh!!!

thanks
Babette

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

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

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

RE: move USERS tablespace to locally managed

2002-11-18 Thread Mercadante, Thomas F 
John,

Why would you *not* want to use the package provided by Oracle?

The answer to your question is to:

1). create a new USERS tablespace
2). issue ALTER TABLE table_name MOVE new_tablespace commands
3). issue ALTER INDEX index_name REBUILD commands.
4). issue ALTER USER username DEFAULT TABLESPACE new_tablespace; 
5). drop the old tablespace.

hope this helps.

Tom Mercadante
Oracle Certified Professional


-Original Message-
Sent: Monday, November 18, 2002 7:03 AM
To: Multiple recipients of list ORACLE-L


If I want to move my USERS tablespace to locally managed(without using
dbms_admin.migrate_to_local), what are the steps I need to take?

John


John Dunn
Sefas Innovation Ltd
0117 9154267
www.sefas.com

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

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

RE: How to identify objects that will fail to extend?

2002-11-18 Thread Ron Rogers 
Rich,
 How about using the next_extent*2 compared with the select max(bytes)
from dba_free_space where tablespace_name ='tablespace name in
question';
That will show you if there is enough free space for two extents or
more.
I display sum(bytes) and max(bytes) to give a complete picture of the
free space and then manually increasing the datafile(if possible) when
there are multiple datafiles to allow for the needed expantion.
Ron

>>> [EMAIL PROTECTED] 11/15/02 06:04PM >>>
Okay.  Let me try this!

The largest column will have the biggest extent size that the
tablespace can accommodate next time.  You might save this information
in a temp. table and have the other query to check against this.


select substr(a.tablespace_name,1,20) tablespace,
round(sum(a.total1)/1024/1024, 1) Total,
round(sum(a.total1)/1024/1024, 1)-round(sum(a.sum1)/1024/1024, 1)
used,
round(sum(a.sum1)/1024/1024, 1) free,
round(sum(a.sum1)/1024/1024, 1)*100/round(sum(a.total1)/1024/1024, 1)
pct_free,
round(sum(a.maxb)/1024/1024, 1) largest,
max(a.cnt) fragments
from
(select tablespace_name, 0 total1, sum(bytes) sum1,
max(bytes) MAXB,
count(bytes) cnt
from dba_free_space
group by tablespace_name
union
select tablespace_name, sum(bytes) total1, 0, 0, 0 from dba_data_files
group by tablespace_name) a
group by a.tablespace_name


-Original Message-
Sent: Friday, November 15, 2002 4:54 PM
To: Multiple recipients of list ORACLE-L


Nope.  If a segment has a NEXT EXTENT of 20M and the two largest
contiguous
free spaces in it's TS are 30M and 15M, the second extent (i.e. two
extends
to that segment) would fail, but would not show up in the query. 
That's
what spawned the complexity of my SQL.

Rich


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

> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]

> Sent: Friday, November 15, 2002 1:44 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: How to identify objects that will fail to extend?
> 
> 
> If PCT_INCREASE is set to 0, then can't we simply compare 
> next_extent*2 > ( sub-query )?
> 
> 
> -Original Message-
> Sent: Friday, November 15, 2002 12:40 PM
> To: Multiple recipients of list ORACLE-L
> 
> 
> Thanks, but the next extent is the easy one.  As I mentioned, 
> I'm already
> running a similar query hourly.
> 
> Rich
> 
> 
> Rich Jesse   System/Database Administrator
> [EMAIL PROTECTED]  Quad/Tech International, 
> Sussex, WI USA
> 
> > -Original Message-
> > From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]] 
> > Sent: Friday, November 15, 2002 10:14 AM
> > To: Multiple recipients of list ORACLE-L
> > Subject: How to identify objects that will fail to extend?
> > 
> > 
> > List,
> > 
> > There was a question as to how to identify objects that will 
> > fail to extend?
> > 
> > This is what we do.
> > 
> > SELECT owner, tablespace_name, segment_name, next_extent
> > FROM dba_segments ds
> > WHERE tablespace_name != 'TEMP'
> >   AND next_extent > ( SELECT max(bytes)
> >   FROM dba_free_space
> >   WHERE tablespace_name=ds.tablespace_name)
> > ORDER BY 1, 2;
> > 
> > -Original Message-
> > Sent: Thursday, November 14, 2002 4:54 PM
> > To: Multiple recipients of list ORACLE-L
> > 
> > 
> > Hi all,
> > 
> > Until a whole mass of astrological confluences happen, I'm 
> stuck with
> > dictionary-managed tablespaces on 8.1.7 on HP/UX 11.0.  And 
> > we're having
> > some space/growth issues right now that I want (need!) to be more
> > proactive
> > with.  So, based on several factors -- most political -- I 
> > want to run a
> > daily report that tells me when a segment will not be able to
extend
> > twice.
> > (We're already running the single extent failure hourly.)
> > 
> > After looking on the net, I found some queries to do this, 
> > but all I saw
> > were severely flawed.  So, I rolled my own.  The only problem 
> > I can see
> > with
> > it for dictionary TSs is when the RANK() has multiple matches 
> > for first
> > and
> > second (e.g. TS "MY_BIG_TS" has it's largest contiguous 
> free spaces of
> > 40M,
> > 10M, and 10M).  Unfortunately, I'm stumped as to how to 
> prevent this.
> > 
> > Anyone care to comment on this load of SQueaL?  Thx!  :)
> > 
> > Rich
> > 
> > Rich Jesse   System/Database Administrator
> > [EMAIL PROTECTED]  Quad/Tech International, 
> > Sussex, WI
> > USA
> > 
> > 
> > 
> > SELECT ds.owner, ds.segment_name, ds.segment_type, 
> ds.tablespace_name,
> > ds.next_extent/1024 "Next ext", fs2.max_free/1024 "Max Free",
> > fs2.min_free/1024 "2nd Max Free", fs2.free_spaces
> > FROM dba_segments ds,
> > (
> > SELECT tablespace_name, MAX(bytes) max_free, MIN(bytes)
> > min_free,
> > count(*) free_spaces
> > FROM
> > (
> > SELECT tablespace_name, bytes,
> >

RE: Netbackup [#2]

2002-11-18 Thread Naveen Nahata 
Same experiences here too. When restoring to a different node, its a big
proble manually moving all the DataFiles and Control Files out of their
directories.

Yechiel, can you elaborate on how you mark and delete the archive logs? and
how do you run the script from backupexec? Please attach the script if it not
too long.

Regards
Naveen

-Original Message-
Sent: Monday, November 18, 2002 5:13 PM
To: Multiple recipients of list ORACLE-L


Since no one else replied I will give you my experience:
(Backupexec for oracle 816 on NT/2000)

We are working with it and got backup speed up to 300MB per minute.

There are some limitations:

1) Backupexec does not delete archive logs.
We wrote a script that marked all existing archive logs before starting the
backup and delete all the marked logs after the backup.

2) When restoring to a different machine, Backupexec creates a folder for
each tablespace and restore the datafiles to this folder. You need to move
the datafiles to their place in order to start the database.

3) Backupexec does not do recovery. You need to  restore the archive logs
that you think you need and then do recovery yourself.

Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Sent: Monday, November 18, 2002 12:23 PM


Is no-one out there using NetBackup???.

Without wishing to sound rude I'll assume a non-response indicates an
affirmative to that OR that you're all too busy to voice an opinion ;)

-Original Message-
Sent: Thursday, November 14, 2002 15:04
To: 'List, OracleDBA [Fatcity]'


Howdy Folks,

Would appreciate feedback on experiences, positive :) or negative :(, folk
have had using Veritas NetBackup product for DB recovery, especially in DR
scenarios.  There is an Oracle agent but so far all it appears to me to be
is a glorious scheduler of your own RMAN scripted jobs!.  Feedback on
features I may have "missed" with agent would also be appreciated.

-
Seán O' Neill
Organon (Ireland) Ltd.
[subscribed: digest mode]

This message, including attached files, may contain confidential
information and is intended only for the use by the individual
and/or the entity to which it is addressed. Any unauthorized use,
dissemination of, or copying of the information contained herein is
not allowed and may lead to irreparable harm and damage for which
you may be held liable. If you receive this message in error or if
it is intended for someone else please notify the sender by
returning this e-mail immediately and delete the message.

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

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

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

Re:RE: Too many db calls

2002-11-18 Thread Anjo Kolk 

One thing to remember is that not every user call becomes a network 
interaction. It is actually far from that. For example: 

open, parse, bind, define, execute -> is 5 user calls but one sqlnet round 
trip.  (AKA bundled or deferred)

Anjo.


On Monday 18 November 2002 03:33, you wrote:
> Cary,
>
> This is one topic I'll disagree with you.  Assume an application that
> uses the database, but is on a machine outside the db server.  Having a
> number of calls that return one or two rows will have a negative network
> impact that is the results of SQL*Net and it's inefficiencies.  It is
> better in this case to encapsulate all of the database interaction into a
> package where bind variables will be used to return the desired results. 
> Using DBMS_SQL is a really BAD thing to do for stuff like that.  OH, I
> really think that using DBMS_SQL is a whole lot easier, for some things
> that is, than PRO*C's prepare, declare, open, fetch, and close especially
> if you have to use that unwieldy SQLDA.  Lastly, I am not a proponent of
> having the application merge result sets.  Most times the merged results
> are smaller in size than the sum of the source giving your network one heck
> of a headache.
>
> BTW: I don't evaluate applications by their BCHR, but by their response
> time.  Hit the return key, if I get an answer back in 10 seconds from the
> original and 5 seconds from the revised, something was done right.
>
> Dick Goulet
>
> Reply Separator
> Author: "Cary Millsap" <[EMAIL PROTECTED]>
> Date:   11/16/2002 1:49 AM
>
> Greg,
>
> That's one case. PL/SQL is a really poor language in which to write an
> application. The language tricks you into believing that writing a
> scalable application can be accomplished in just a few lines of 4GL
> code, but it's really not true. To write scalable PL/SQL, you need to
> use DBMS_SQL. The resulting code is even more cumbersome than the same
> function written in Pro*C.
>
> Any language can be abused, though. We see a lot of Java, Visual Basic,
> and Powerbuilder applications that do stuff like...
>
> 1. Parse inside loops, using literals instead of bind variables.
> 2. Parse *twice* for each execute by doing describe+parse+execute.
> 3. Manipulate one row at a time instead of using array processing
> capabilities on fetches or inserts (this one, ironically, raises a
> system's BCHR while it kills response time).
> 4. Join result sets in the application instead of in the database.
>
>
> Cary Millsap
> Hotsos Enterprises, Ltd.
> http://www.hotsos.com
>
> Upcoming events:
> - Hotsos Clinic, Dec 9-11 Honolulu
> - 2003 Hotsos Symposium on OracleR System Performance, Feb 9-12 Dallas
> - Jonathan Lewis' Optimising Oracle, Nov 19-21 Dallas
>
>
> -Original Message-
> Sent: Saturday, November 16, 2002 2:38 AM
> To: Multiple recipients of list ORACLE-L
>
> Cary,
>
> Thank you.
>
> Could you elaborate on the issue of excessive database calls, which show
> up
> as excessive network traffic?
>
> I can picture a PL/SQL loop, which executes an SQL statement over and
> over
> again.  This would produce many database calls, and it might be possible
> to
> remove the loop altogether, replacing it with a single SQL statement.
> This
> would reduce the database calls.
>
> Is this the "classic" type of situation that produces too many db calls?
> Or
> are there other situations I'm missing that are more likely to be the
> source
> of this problem?
>
> Thanks again.
>
>
>
> - Original Message -
> To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
> Sent: Friday, November 15, 2002 4:13 PM
>
> > Greg,
> >
> > I believe that the cultural root cause of the excessive LIO problem is
> > the conception that physical I/O is what makes databases slow. Disk
>
> I/O
>
> > certainly *can* make a system slow, but in about 598 of 600 cases
>
> we've
>
> > seen in the past three years, it hasn't. ["Why you should focus on
>
> LIOs
>
> > instead of PIOs" at www.hotsos.com/catalog]
> >
> > The fixation on PIO of course focuses people's attention on the
>
> database
>
> > buffer cache hit ratio (BCHR) metric for evaluating efficiency. The
> > problem is that the BCHR is a metric of INSTANCE efficiency, not SQL
> > efficiency. However, many people mistakenly apply it as a metric of
>
> SQL
>
> > efficiency anyway.
> >
> > Of course, if one's radar equates SQL efficiency with the BCHR's
> > proximity to 100%, then a lot of really bad SQL is going to show up on
> > your radar wrongly identified as really good SQL. ["Why a 99% buffer
> > cache hit ratio is not okay" at www.hotsos.com/catalog]
> >
> > One "classic" result is that people go on search and destroy missions
> > for all full-table scans. They end up producing more execution plans
> > that look like this than they should have:
> >
> >   NESTED LOOPS
> > TABLE ACCESS BY INDEX ROWID
> >   INDEX RANGE SCAN
> > TABLE ACCESS BY INDEX ROWID
> >   INDEX R

RE: move USERS tablespace to locally managed

2002-11-18 Thread Mark Leith 
Hi John,

If the TS contains just tables, and you have enough space, you could simply
create a new users LMT, and "alter table move" the tables to the new
tablespace.

You could also export all of the objects from the DMT, and import them in to
the newly created LMT (the old "reorg" method).

Mark

-Original Message-
Sent: 18 November 2002 12:03
To: Multiple recipients of list ORACLE-L


If I want to move my USERS tablespace to locally managed(without using
dbms_admin.migrate_to_local), what are the steps I need to take?

John


John Dunn
Sefas Innovation Ltd
0117 9154267
www.sefas.com

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

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

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

replace lines feeds in a string

2002-11-18 Thread John Dunn 
I want to replace any carriage returns and lines feeds 'OD0A' and '0A' in
string, with a  space. Can this be done with TRANSLATE, if so how do I code
this?

John Dunn
Sefas Innovation Ltd
0117 9154267
www.sefas.com

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

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

2002-11-18 Thread Yechiel Adar 
Since no one else replied I will give you my experience:
(Backupexec for oracle 816 on NT/2000)

We are working with it and got backup speed up to 300MB per minute.

There are some limitations:

1) Backupexec does not delete archive logs.
We wrote a script that marked all existing archive logs before starting the
backup and delete all the marked logs after the backup.

2) When restoring to a different machine, Backupexec creates a folder for
each tablespace and restore the datafiles to this folder. You need to move
the datafiles to their place in order to start the database.

3) Backupexec does not do recovery. You need to  restore the archive logs
that you think you need and then do recovery yourself.

Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Sent: Monday, November 18, 2002 12:23 PM


Is no-one out there using NetBackup???.

Without wishing to sound rude I'll assume a non-response indicates an
affirmative to that OR that you're all too busy to voice an opinion ;)

-Original Message-
Sent: Thursday, November 14, 2002 15:04
To: 'List, OracleDBA [Fatcity]'


Howdy Folks,

Would appreciate feedback on experiences, positive :) or negative :(, folk
have had using Veritas NetBackup product for DB recovery, especially in DR
scenarios.  There is an Oracle agent but so far all it appears to me to be
is a glorious scheduler of your own RMAN scripted jobs!.  Feedback on
features I may have "missed" with agent would also be appreciated.

-
Seán O' Neill
Organon (Ireland) Ltd.
[subscribed: digest mode]

This message, including attached files, may contain confidential
information and is intended only for the use by the individual
and/or the entity to which it is addressed. Any unauthorized use,
dissemination of, or copying of the information contained herein is
not allowed and may lead to irreparable harm and damage for which
you may be held liable. If you receive this message in error or if
it is intended for someone else please notify the sender by
returning this e-mail immediately and delete the message.

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

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

move USERS tablespace to locally managed

2002-11-18 Thread John Dunn 
If I want to move my USERS tablespace to locally managed(without using
dbms_admin.migrate_to_local), what are the steps I need to take?

John


John Dunn
Sefas Innovation Ltd
0117 9154267
www.sefas.com

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

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

[no subject]

2002-11-18 Thread sultan 



Hi,
 
How can I complie PRO*C code.Please
 
Thnks
 

Re:RE: Too many db calls

2002-11-18 Thread dgoulet 
Cary,

This is one topic I'll disagree with you.  Assume an application that uses
the database, but is on a machine outside the db server.  Having a number of
calls that return one or two rows will have a negative network impact that is
the results of SQL*Net and it's inefficiencies.  It is better in this case to
encapsulate all of the database interaction into a package where bind variables
will be used to return the desired results.  Using DBMS_SQL is a really BAD
thing to do for stuff like that.  OH, I really think that using DBMS_SQL is a
whole lot easier, for some things that is, than PRO*C's prepare, declare, open,
fetch, and close especially if you have to use that unwieldy SQLDA.  Lastly, I
am not a proponent of having the application merge result sets.  Most times the
merged results are smaller in size than the sum of the source giving your
network one heck of a headache.

BTW: I don't evaluate applications by their BCHR, but by their response
time.  Hit the return key, if I get an answer back in 10 seconds from the
original and 5 seconds from the revised, something was done right.

Dick Goulet

Reply Separator
Author: "Cary Millsap" <[EMAIL PROTECTED]>
Date:   11/16/2002 1:49 AM

Greg,

That's one case. PL/SQL is a really poor language in which to write an
application. The language tricks you into believing that writing a
scalable application can be accomplished in just a few lines of 4GL
code, but it's really not true. To write scalable PL/SQL, you need to
use DBMS_SQL. The resulting code is even more cumbersome than the same
function written in Pro*C.

Any language can be abused, though. We see a lot of Java, Visual Basic,
and Powerbuilder applications that do stuff like...

1. Parse inside loops, using literals instead of bind variables.
2. Parse *twice* for each execute by doing describe+parse+execute.
3. Manipulate one row at a time instead of using array processing
capabilities on fetches or inserts (this one, ironically, raises a
system's BCHR while it kills response time).
4. Join result sets in the application instead of in the database.


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

Upcoming events:
- Hotsos Clinic, Dec 9-11 Honolulu
- 2003 Hotsos Symposium on OracleR System Performance, Feb 9-12 Dallas
- Jonathan Lewis' Optimising Oracle, Nov 19-21 Dallas


-Original Message-
Sent: Saturday, November 16, 2002 2:38 AM
To: Multiple recipients of list ORACLE-L

Cary,

Thank you.

Could you elaborate on the issue of excessive database calls, which show
up
as excessive network traffic?

I can picture a PL/SQL loop, which executes an SQL statement over and
over
again.  This would produce many database calls, and it might be possible
to
remove the loop altogether, replacing it with a single SQL statement.
This
would reduce the database calls.

Is this the "classic" type of situation that produces too many db calls?
Or
are there other situations I'm missing that are more likely to be the
source
of this problem?

Thanks again.



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


> Greg,
>
> I believe that the cultural root cause of the excessive LIO problem is
> the conception that physical I/O is what makes databases slow. Disk
I/O
> certainly *can* make a system slow, but in about 598 of 600 cases
we've
> seen in the past three years, it hasn't. ["Why you should focus on
LIOs
> instead of PIOs" at www.hotsos.com/catalog]
>
> The fixation on PIO of course focuses people's attention on the
database
> buffer cache hit ratio (BCHR) metric for evaluating efficiency. The
> problem is that the BCHR is a metric of INSTANCE efficiency, not SQL
> efficiency. However, many people mistakenly apply it as a metric of
SQL
> efficiency anyway.
>
> Of course, if one's radar equates SQL efficiency with the BCHR's
> proximity to 100%, then a lot of really bad SQL is going to show up on
> your radar wrongly identified as really good SQL. ["Why a 99% buffer
> cache hit ratio is not okay" at www.hotsos.com/catalog]
>
> One "classic" result is that people go on search and destroy missions
> for all full-table scans. They end up producing more execution plans
> that look like this than they should have:
>
>   NESTED LOOPS
> TABLE ACCESS BY INDEX ROWID
>   INDEX RANGE SCAN
> TABLE ACCESS BY INDEX ROWID
>   INDEX RANGE SCAN
>
> This kind of plan produces great hit ratios because it tends to
revisit
> the same small set of blocks over and over again. This kind of plan is
> of course appropriate in many cases. But sometimes it is actually less
> work in the database to use full-table scans. ["When to use an index"
at
> www.hotsos.com/catalog.]
>
>
> Cary Millsap
> Hotsos Enterprises, Ltd.
> http://www.hotsos.com
>
> Upcoming events:
> - Hotsos Clinic, Dec 9-11 Honolulu
> - 2003 Hotsos Symposium on OracleR System Performance, Feb 9-12 Dallas
> - Jo

Netbackup [#2]

2002-11-18 Thread O'Neill, Sean 
Is no-one out there using NetBackup???.  

Without wishing to sound rude I'll assume a non-response indicates an
affirmative to that OR that you're all too busy to voice an opinion ;)

-Original Message-
Sent: Thursday, November 14, 2002 15:04
To: 'List, OracleDBA [Fatcity]'


Howdy Folks,

Would appreciate feedback on experiences, positive :) or negative :(, folk
have had using Veritas NetBackup product for DB recovery, especially in DR
scenarios.  There is an Oracle agent but so far all it appears to me to be
is a glorious scheduler of your own RMAN scripted jobs!.  Feedback on
features I may have "missed" with agent would also be appreciated.

-
Seán O' Neill
Organon (Ireland) Ltd.
[subscribed: digest mode] 

This message, including attached files, may contain confidential
information and is intended only for the use by the individual
and/or the entity to which it is addressed. Any unauthorized use,
dissemination of, or copying of the information contained herein is
not allowed and may lead to irreparable harm and damage for which
you may be held liable. If you receive this message in error or if
it is intended for someone else please notify the sender by
returning this e-mail immediately and delete the message.

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

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

Re: how to download all the openworld documents?

2002-11-18 Thread l-oracle 

> Does their has way that can download (or purchase CD) all the ORACLE
> Openworld documents?

Some of the presenters alluded to them being uploaded somewhere, but I 
haven't found it.  The presentations I saw, I simply emailed the presenter 
to get a copy.  You might try this.

HTH,
Sean

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

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

RE: Query elapsed time

2002-11-18 Thread John . Hallas 
Dick
V$session_longops has a column elapsed_seconds and a sid column

HTH

John

-Original Message-
Sent: 15 November 2002 18:59
To: Multiple recipients of list ORACLE-L


Quick question,  Does anyone know of a location in the V$ tables where the
elapsed time of the current query is stored??

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

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

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