date:20030826

Title: Message



Well, 
that is because of your understanding of the word "failover". Don't be confused, 
there are other words
in 
desperate need of redefinition, too. One of them is "unbreakable". 

To 
make the long story short, "FAILOVER=ON"  makes possible for Oracle*Net to 
skip the non-functioning
TNS 
descriptor, not that the application should simply fail over and continue from 
another node. The application
will 
simply fail, without the desired "over", unless it's written using OCI, which is 
the only means for an 
application to resume on one of the surviving nodes. In other words, it 
is the TNS descriptor that "fails over", 
not 
your application. I hope that things are clearer now.
 
 
--Mladen GogalaOracle DBA 

  
  -Original Message-From: 
  [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of laura 
  penaSent: Tuesday, August 26, 2003 5:49 PMTo: Multiple 
  recipients of list ORACLE-LSubject: RAC - setting up failover and 
  load_balance
  So I have RAC setup ( Solaris 2.8 , Veritas DBE/AC 3.5 MP1 and HDS disks 
  if you are interested) and I am attempting to setup my failover and 
  loadbalancing from a client.
   
   
  I brought down VLDBN1 
  and  Thought I should fail over to VLDB2 ... but I did not.
   
   
  Here is what I have in my tnsnames.ora:
   
  VLDB =(DESCRIPTION =    
  (FAILOVER=ON)    (LOAD_BALANCE = yes)    
  (ADDRESS_LIST =  (ADDRESS = (PROTOCOL = 
  TCP)(HOST = 10.10.250.25)(PORT = 1521))  
  (ADDRESS = (PROTOCOL = TCP)(HOST = 10.10.250.26)(PORT = 
  1521))    )    (CONNECT_DATA 
  =  (SERVER = 
  DEDICATED)  (SERVICE_NAME = 
  VLDBN2)       
  (FAILOVER_MODE=     
  (BACKUP=SECONDAY)      
  (TYPE=select)      
  (METHOD=basic)      
  (RETRIES=5)      
  (DELAY=5)       )    
  ))
  SECONDARY =(DESCRIPTION =  (ADDRESS 
  = (PROTOCOL = TCP)(HOST = 10.10.250.26)(PORT = 1521))    
   (CONNECT_DATA =  
    (SERVICE_NAME = VLDBN2)    ))
   
  Any ideas?
  
  
  Do you Yahoo!?Yahoo! 
  SiteBuilder - Free, easy-to-use web site design 
software
 
Note:
This message is for the named person's use only.  It may contain 
confidential, proprietary or legally privileged information.  No 
confidentiality or privilege is waived or lost by any mistransmission.  If 
you receive this message in error, please immediately delete it and all 
copies of it from your system, destroy any hard copies of it and notify the 
sender.  You must not, directly or indirectly, use, disclose, distribute, 
print, or copy any part of this message if you are not the intended 
recipient. Wang Trading 
LLC and any of its subsidiaries each reserve the right to 
monitor all e-mail communications through its networks.  Any views 
expressed in this message are those of the individual sender, except where the 
message states otherwise and the sender is authorized to state them to be the 
views of any such entity.

RAC - setting up failover and load_balance

2003-08-26 Thread laura pena

So I have RAC setup ( Solaris 2.8 , Veritas DBE/AC 3.5 MP1 and HDS disks if you are interested) and I am attempting to setup my failover and loadbalancing from a client.
 
 
I brought down VLDBN1 
and  Thought I should fail over to VLDB2 ... but I did not.
 
 
Here is what I have in my tnsnames.ora:
 
VLDB =(DESCRIPTION =    (FAILOVER=ON)    (LOAD_BALANCE = yes)    (ADDRESS_LIST =  (ADDRESS = (PROTOCOL = TCP)(HOST = 10.10.250.25)(PORT = 1521))  (ADDRESS = (PROTOCOL = TCP)(HOST = 10.10.250.26)(PORT = 1521))    )    (CONNECT_DATA =  (SERVER = DEDICATED)  (SERVICE_NAME = VLDBN2)       (FAILOVER_MODE=     (BACKUP=SECONDAY)      (TYPE=select)      (METHOD=basic)      (RETRIES=5)      (DELAY=5)       )    ))
SECONDARY =(DESCRIPTION =  (ADDRESS = (PROTOCOL = TCP)(HOST = 10.10.250.26)(PORT = 1521))     (CONNECT_DATA =    (SERVICE_NAME = VLDBN2)    ))
 
Any ideas?
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software

tkprof issues - was Performance Problem

Title: Message



unable to allocate space of size 48 (couple of time 
50).
 
run as root too so no ulimits ...
 
Raj
 
Rajendra dot Jamadagni at nospamespn dot 
com All Views expressed in this email 
are strictly personal. QOTD: Any clod 
can have facts, having an opinion is an art ! 

  -Original Message-From: Mladen Gogala 
  [mailto:[EMAIL PROTECTED]Sent: Tuesday, August 26, 2003 5:50 
  PMTo: Multiple recipients of list ORACLE-LSubject: RE: 
  Performance Problem
  Nope, you're the first. What happened? Segmentation violation? If that 
  is so, I'd like to know, because
  not 
  all of my trace files are small.
   
   
  --Mladen GogalaOracle DBA 
  

-Original Message-From: 
[EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of 
Jamadagni, RajendraSent: Tuesday, August 26, 2003 4:54 
PMTo: Multiple recipients of list ORACLE-LSubject: RE: 
Performance Problem
Funny ... 
I have tkprof give up analyzing a 4.2G tracefile on a 64bit 
platform. anyone else experienced this?? 
Raj  
Rajendra dot Jamadagni at nospamespn dot com 
All Views expressed in this email are strictly 
personal. QOTD: Any clod can have facts, having an 
opinion is an art ! 
-Original Message- From: 
Cary Millsap [mailto:[EMAIL PROTECTED]] 
Sent: Tuesday, August 26, 2003 4:24 PM To: Multiple recipients of list ORACLE-L Subject: RE: Performance Problem 
Laura, 
You might find the problem by checking the things you plan 
to check, and by following the advice of the book 
you're using. But the odds are very good that you 
will not. At least not for a long time... 
Any application program on your system can tell you where it 
is spending its time. Let it tell you. Take a 10046 
level-12 trace of *any* important, slow application 
program. Read http://www.hotsos.com/dnloads/1/timing-data/Oracle%20Operational%20Timin 
g%20Data.pdf, or ask the list for details if you need some 
help. 
Cary Millsap Hotsos Enterprises, 
Ltd. http://www.hotsos.com 
Upcoming events: - Hotsos Clinic 101 
in Sydney - Hotsos Symposium 2004, March 7-10 
Dallas - Visit www.hotsos.com for schedule 
details... 
-Original Message- Burton, 
Laura Sent: Tuesday, August 26, 2003 2:30 PM 
To: Multiple recipients of list ORACLE-L 
No, I had read not to analyze the sys tables in the 'TIP' 
section of the book I am using as a reference 
(Oracle Performance Tuning/Tips & Techniques).  As I stated earlier, I also made sure that I 
analyzed all the tables and indexes that were 
involved, because I had read that leaving a table 
'un'analyzed would cause a performance hit. 
Someone earlier had suggested doing the analyze during an 
'off' time. This I did not do.  It was done 
while everything was going on, so maybe that is why 
everything came to a standstill.  Anyway I want to try it 
again after I upgrade and do so when others are not 
on. 
If you know of any other gotcha's, please let me know.  
I may not have picked up on it in my 
research. 
Someone else had responded about looking at systemic things 
before attacking the code.  I had already done 
this and found that I needed to enlarge my sort area 
because the disk read ratio was a little high.  I also enlarged my shared pool size.  The stats I have been 
running since then to keep track of this are staying 
between 98 and 99% so I do not think this is my 
problem now.  Those changes did not make any difference 
to the users.  Even though the disk/memory read was 
not above 95%, it was at 92% so that is probably why 
no performance gain was noticed.  We are using 
PL/SQL procedures heavily.  The stats on the Library Cache 
looked good though.  
I read something this weekend about how using 'logical' 
drives to separate the different files can cause a 
performance hit.  I am using logical 
disks,  and I plan to change when I can, but I'm not sure yet 
how much that will help.  I have redistributed some of 
the rollback segments so that they are not all 
located on the same disk.  However since some 
of the drives are logical, that may not have done any good. I've rebuilt indexes, changed extent sizes to reduce the amount 
of extents, added rollback segments, etc.  In 
lieu of this, code is next... 
Thanks, Laura 
-Original Message- Sent: 
Tuesday, August 26, 2003 1:29 PM To: Multiple 
recipients of list ORACLE-L 
Did you analyze the sys  schema by mistake.  This 
can stop the fastest database.  We had a 
contractor do that to an 8.0.5 database once, and only once. 
Ruth 
-- Please see the official ORA

RE: Hey Jared!!

2003-08-26 Thread Goulet, Dick

I sure hope so.  Then he/she should be publicly tarred & Feathered.

Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA

-Original Message-
Sent: Tuesday, August 26, 2003 4:45 PM
To: Multiple recipients of list ORACLE-L


I doubt they will ever find the real guy behind this. 

Tanel.

- Original Message - 
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Tuesday, August 26, 2003 10:19 PM


> For all you virus/worm lovers out there, justice do come:
> 
> FBI Subpoenas Arizona ISP In Sobig Probe
> Easynews says it's cooperating with the bureau to find the person 
> who uploaded the virus to a Usenet group it hosts.
> informationweek.com/story/showArticle.jhtml?articleID=13800091
> 
> 
> 
> Dick Goulet
> Senior Oracle DBA
> Oracle Certified 8i DBA
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: Goulet, Dick
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> 

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

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

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

Re: SQL HELP!!!


Viktor,

By using an inline view, count_web does indeed become a column.

Did you try the query?

Jared








Viktor <[EMAIL PROTECTED]>
 08/26/2003 01:29 PM

        
        To:        [EMAIL PROTECTED], [EMAIL PROTECTED]
        cc:        
        Subject:        Re: SQL HELP!!!


Jared,
 
Thanks for your fast reply! Sorry if I didn't explain myself clear enough. Unfortunately count_web is not a column, id||yr||seq_no||ck is a combination of 4 columns that make up a primary key. if seq_no >4000, in a id||yr||seq_no||ck row, it's a "web row", if not then it's not. what I would like to see is:
 
ID  Received_date   Non-web count       Web_count
AR 2003-01            0                           4
AR 2003-02            0                           6
AR 2003-0              1                           8
and so forth.
 
Again thanks for any suggestions you may have!
 
Thanks very much!
 
 


[EMAIL PROTECTED] wrote:

I'm not sure I entirely understand the result you are trying to achieve. 

Perhaps this will help 

select received_date, msno, sum(count_web), hardcopy 
from ( 
select id ,
         to_char(received_date, '-mm') received_date,
         id||yr||seq_no||ck MSNO
         CASE WHEN seq_no > 4000 then count(seq_no) ELSE 0 end Count_WEB,
         CASE WHEN seq_no <=4000 then count(seq_no) ELSE 0   END  HARDCOPY 
 from t
where received_date between '01/01/2003' and '12/31/2003'
group by id,
  ; to_char(received_date, '-mm'), 
   sequence_no,
  id||yr||seq_no||ck 
) 
group by received_date, msno, hardcopy 
/ 







Viktor <[EMAIL PROTECTED]> 
Sent by: [EMAIL PROTECTED] 
 08/26/2003 01:59 PM 
 Please respond to ORACLE-L 
        
        To:        Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> 
        cc:         
        Subject:        SQL HELP!!!



Hello, 
  
I was wondering if someone can help me with a report. I am stuck figuring out what I can do to complete it. Here is what I need to do: 
  
for a given date range, i..e. start_date - end_date ('01/01/2003',  '12/31/2003'), I need to count all "web", and "non-web" recor ds. If seq_no > 4000, then it's web, otherwise non-web. seq_no is not unique. So it's like 2 different where claused in a single select. Could I somehow use CASE or decode to accomplish this. Here is what I am trying to do in select: 
  
select id ,
         to_char(received_date, '-mm'),
         id||yr||seq_no||ck MSNO
         CASE WHEN seq_no > 4000 then count(seq_no) ELSE 0 end Count_WEB,
         CASE WHEN seq_no <=4000 then count(seq_no) ELSE 0   END  HARDCOPY 
 from t
where received_date between '01/01/2003' and '12/31/2003'
group by id,
  to_char(received_date, '-mm'), 
   sequence_no,
  id||yr||seq_no||ck < BR>/ 
  
AR 2003-01 AR030023T         0              1
AR 2003-01 AR0200302         0              1
AR 2003-01 AR020047K         0              1
AR 2003-01 AR020077N         0              1 
  
I would like to show Year-Month once and count all instances of  id||yr||seq_no||ck (primary_key) for that Year-Month, but not to break on it, and unfortunaley it won't let me do it without grouping on seq_no 
  
Please advise!!! 
  
Any help is greatly appreciated! 
  
  

Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software 

Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software

Re: SQL HELP!!!

2003-08-26 Thread Dave Hau

select id, received_date,
count(count_non_web) non_web_count,
count(count_web) web_count
from
(select id, to_char(received_date, '-mm') received_date,
(case when seq_no <= 4000 then 1 else null end) count_non_web,
(case_when seq_no > 4000 then 1 else null end) count_web
from t
where received_date between '01/01/2003' and '12/31/2003')
group by id,
received_date
HTH,
Dave


[EMAIL PROTECTED] wrote:
Jared,
 
Thanks for your fast reply! Sorry if I didn't explain myself clear 
enough. Unfortunately count_web is not a column, id||yr||seq_no||ck is a 
combination of 4 columns that make up a primary key. if seq_no >4000, in 
a id||yr||seq_no||ck row, it's a "web row", if not then it's not. what I 
would like to see is:
 
ID  Received_date   Non-web count   Web_count
AR 2003-010   4
AR 2003-020   6
AR 2003-0  1   8
and so forth.
 
Again thanks for any suggestions you may have!
 
Thanks very much!

 

 



[EMAIL PROTECTED] wrote:

I'm not sure I entirely understand the result you are trying to
achieve.
Perhaps this will help

select received_date, msno, sum(count_web), hardcopy
from (
select id ,
 to_char(received_date, '-mm') received_date,
 id||yr||seq_no||ck MSNO
 CASE WHEN seq_no > 4000 then count(seq_no) ELSE 0 end
Count_WEB,
 CASE WHEN seq_no <=4000 then count(seq_no) ELSE 0   END
 HARDCOPY
 from t
where received_date between '01/01/2003' and '12/31/2003'
group by id,
&nbs! p; to_char(received_date, '-mm'),
   sequence_no,
  id||yr||seq_no||ck
)
group by received_date, msno, hardcopy
/


Viktor <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
 08/26/2003 01:59 PM
 Please respond to ORACLE-L
   
To:Multiple recipients of list ORACLE-L
<[EMAIL PROTECTED]>
cc:
Subject:SQL HELP!!!



Hello,
 
I was wondering if someone can help me with a report. I am stuck
figuring out what I can do to complete it. Here is what I need to do:
 
for a given date range, i..e. start_date - end_date ('01/01/2003',
 '12/31/2003'), I need to count all "web", and "non-web" reco! rds.
If seq_no > 4000, then it's web, otherwise non-web. seq_no is not
unique. So it's like 2 different where claused in a single select.
Could I somehow use CASE or decode to accomplish this. Here is what
I am trying to do in select:
 
select id ,
 to_char(received_date, '-mm'),
 id||yr||seq_no||ck MSNO
 CASE WHEN seq_no > 4000 then count(seq_no) ELSE 0 end
Count_WEB,
 CASE WHEN seq_no <=4000 then count(seq_no) ELSE 0   END
 HARDCOPY
 from t
where received_date between '01/01/2003' and '12/31/2003'
group by id,
  to_char(received_date, '-mm'),
   sequence_no,
  id||yr||seq_no||ck !
/
 
AR 2003-01 AR030023T 0  1
AR 2003-01 AR0200302 0  1
AR 2003-01 AR020047K 0  1
AR 2003-01 AR020077N 0  1
 
I would like to show Year-Month once and count all instances of
 id||yr||seq_no||ck (primary_key) for that Year-Month, but not to
break on it, and unfortunaley it won't let me do it without grouping
on seq_no
 
Please advise!!!  
Any help is greatly appreciated!
 
 


Do you Yahoo!?
Yahoo! SiteBuilder
 -
Free, easy-to-use web site design software

Do you Yahoo!?
Yahoo! SiteBuilder 
 - Free, 
easy-to-use web site design software


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


No need to do it quite the way you are attempting.

c:>  namesctl dump_tnsnames c:\temp\tnsnames.txt

worked fine for me.   The default server is ns_ns1

Had I wanted to do this from another server, say ns2, I would
have gone directly into namesctl, then issued the command
'set server ns_ns2'

Jared







"Bob Metelsky" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
 08/26/2003 03:04 PM
 Please respond to ORACLE-L

        
        To:        Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
        cc:        
        Subject:        RE: Onames and various connections scenarios


No doubt im in the wrong ball field here but this is what I have

Windows 2k
Server1 Ns1 on 8.1.7.4
Server2 Ns2 on 9.2.0.1.0

[server1]
C:\> start \\server1\bin\namesctl dump_tnsnames C:\mytnsnames.txt
It creates an empty file on my (remote) machine

>From the server C:\> namesctl  dump_tnsnames C:\mytnsnames.txt it creats
an empty C:\mytnsnames.txt


[server2]
C:\> start \\server2\bin\namesctl dump_tnsnames C:\mytnsnames.txt
And it creates an empty file on my (remote) machine

>From the server itself it creats a full C:\mytnsnames.txt file with all
the connect discriptors

How is this supposed to be called?

Thanks!

> Bob,
> 
> I understand what you are saying (and your pain). My 
> suggestion would be to use the 'namesctl dump_tnsnames' 
> command to dump out the current Onames repository to the PC's 
> $TNS_ADMIN dir via a login script or SMS. You might want o 
> rename the current TNSNAMES.ORA file just prior to that as 
> dump_tnsnames adds to the end of the current one and doesn't 
> handle changes very well.
> 
> Hth,
> John Kanagaraj
> DB Soft Inc
> Phone: 408-970-7002 (W)
> 
> Grace - Getting something we do NOT deserve
> Mercy - NOT getting something we DO deserve
> Click on 'http://www.needhim.org' for Grace and Mercy that is 
> freely available!
> 
> ** The opinions and facts contained in this message are 
> entirely mine and do not reflect those of my employer or customers **
> 
> -Original Message-
> Sent: Tuesday, August 26, 2003 6:44 AM
> To: Multiple recipients of list ORACLE-L
> 
> 
> Hello All
> 
>                  Im back from the trenches to post a quick request for 
> help
> 
> Ive setup onames on 2 servers and standard applications, (our app and
> sqlplus) connect just fine, a problem situation manifests itself when:
> 
> 1 users need to connect (add a database) to dba studio. They 
> get a error to the effect "cant resolve host name" And the 
> other 2. Users connect to remote databases (via vpn) that are 
> in our onames but many  of these vpn connections once made do 
> not allow access to
> *our* network resources.
> 
> So basically almost all of oour users have one or more of 
> these secenarios which means they will need to maintain a 
> tnsnames file as well.
> 
> I'm managing about 70+ connect discriptors And I was 
> hoping onames could be a centralised answer
> 
> Is this common? Or is there a workaround?
> 
> Thanks!
> bob
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: Bob Metelsky
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
> San Diego, California        -- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 
> and in the message BODY, include a line containing: UNSUB 
> ORACLE-L (or the name of mailing list you want to be removed 
> from).  You may also send the HELP command for other 
> information (like subscribing).
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: John Kanagaraj
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
> San Diego, California        -- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 
> and in the message BODY, include a line containing: UNSUB 
> ORACLE-L (or the name of mailing list you want to be removed 
> from).  You may also send the HELP command for other 
> information (like subscribing).
> 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Bob Metelsky
  INET: [EMAIL PROTECTED]

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

Re: SQL HELP!!!

Jared,
 
I had a temporary brain freeze :), thanks much! I have modified it a bit, and it seems to be working fine! One other small thing. Is there a quick wahy to calculate percentage of web/non-web and vice-versa in the same select after the column "sums"?
 
select distinct id, received_date,  sum(count_web), sum(count_hardcopy)from (select distinct id , to_char(received_date, '-mm') received_date, id||yr||seq_no||ck MSNO, CASE WHEN seq_no > 4000 then count(*) ELSE 0 end Count_WEB, CASE WHEN seq_no <=4000 then count(*) ELSE 0 END Count_HARDCOPYfrom twhere id = 'AC'and received_date between '01/01/2003' and '12/31/2003'group by id, to_char(received_date, '-mm'),
 seq_no, id||yr||seq_no||ck)group by id, received_date
 
Thanks again![EMAIL PROTECTED] wrote:
Viktor, By using an inline view, count_web does indeed become a column. Did you try the query? Jared 




Viktor <[EMAIL PROTECTED]> 
 08/26/2003 01:29 PM 
                To:        [EMAIL PROTECTED], [EMAIL PROTECTED]         cc:                 Subject:        Re: SQL HELP!!!Jared,   Thanks for your fast reply! Sorry if I didn't explain myself clear enough. Unfortunately count_web is not a column, id||yr||seq_no||ck is a combination of 4 columns that make up a primary key. if seq_no >4000, in a id||yr||seq_no||ck row, it's a "web row", if not then it's not. what I would like to see is:   ID  Received_date   Non-web count       Web_count AR 2003-01            0                           4AR 2003-02            0                           6AR 2003-0              1                           8 and so forth.   Again thanks for any suggestions you may have!   Thanks very much! 
 
 
[EMAIL PROTECTED] wrote: I'm not sure I entirely understand the result you are trying to achieve. Perhaps this will help select received_date, msno, sum(count_web), hardcopy from ( select id ,        to_char(received_date, '-mm') received_date,        id||yr||seq_no||ck MSNO        CASE WHEN seq_no > 4000 then count(seq_no) ELSE 0 end Count_WEB,        CASE WHEN seq_no <=4000 then count(seq_no) ELSE 0   END  HARDCOPY from twhere received_date bet!
ween
 '01/01/2003' and '12/31/2003'group by id, ; to_char(received_date, '-mm'),   sequence_no, id||yr||seq_no||ck ) group by received_date, msno, hardcopy / 




Viktor <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 
 08/26/2003 01:59 PM Please respond to ORACLE-L 
               To:        Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>        cc:                Subject:        SQL HELP!!!Hello,  I was wondering if someone can help me with a report. I am stuck figuring out what I can do to complete it. Here is what I need to do:  for a given date range, i..e. start_date - end_date ('01/01/2003',  '12/31/2003'), I need to count all "web", and "non-web" recor ds. If seq_no > 4000, then it's web, otherwise non-web. seq_no is not !
unique.
 So it's like 2 different where claused in a single select. Could I somehow use CASE or decode to accomplish this. Here is what I am trying to do in select:  select id ,        to_char(received_date, '-mm'),        id||yr||seq_no||ck MSNO        CASE WHEN seq_no > 4000 then count(seq_no) ELSE 0 end Count_WEB,        CASE WHEN seq_no <=4000 then count(seq_no) ELSE 0   END  HARDCOPY from twhere received_date between '01/01/2003' and '12/31/2003'group by id, to_char(received_date, '-mm'),   sequence_no, id||yr||seq_no||ck < BR>/  AR 2003-01 AR030023T         0              1AR 2003-01 AR0200302         0              1AR 2003-01 AR020047K         0  !
  
          1AR 2003-01 AR020077N         0              1  I would like to show Year-Month once and count all instances of  id||yr||seq_no||ck (primary_key) for that Year-Month, but not to break on it, and unfortunaley it won't let me do it without grouping on seq_no  Please advise!!!  Any help is greatly appreciated!    


Do you Yahoo!?Yahoo! SiteBuilder - Free, easy-to-use web site design software 


Do you Yahoo!?Yahoo! SiteBuilder - Free, easy-to-use web site design software 


Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software

RE: tkprof issues - was Performance Problem

Title: Message

Are
you sure that your swap space is sufficient?
--Mladen GogalaOracle DBA

-Original Message-From:
[EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of
Jamadagni, RajendraSent: Tuesday, August 26, 2003 5:59
PMTo: Multiple recipients of list ORACLE-LSubject:
tkprof issues - was Performance Problem
unable to allocate space of size 48 (couple of time
50).
run as root too so no ulimits ...
Raj

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

-Original Message-From: Mladen Gogala
[mailto:[EMAIL PROTECTED]Sent: Tuesday, August 26, 2003
5:50 PMTo: Multiple recipients of list
ORACLE-LSubject: RE: Performance Problem
Nope, you're the first. What happened? Segmentation violation? If
that is so, I'd like to know, because
not all of my trace files are small.
--Mladen GogalaOracle DBA

No, I had read not to analyze the sys tables in the 'TIP'
section of the book I am using as a reference
(Oracle Performance Tuning/Tips & Techniques). As I stated earlier, I also made sure that I
analyzed all the tables and indexes that were
involved, because I had read that leaving a table
'un'analyzed would cause a performance hit.
Someone earlier had suggested doing the analyze during an
'off' time. This I did not do. It was done
while everything was going on, so maybe that is
why everything came to a standstill. Anyway I want to try it
again after I upgrade and do so when others are not
on.
If you know of any other gotcha's, please let me
know. I may not have picked up on it in my
research.
Someone else had responded about looking at systemic
things before attacking the code. I had
already done this and found that I needed to enlarge my sort area because the disk read ratio was a little
high. I also enlarged my shared pool
size. The stats I have been running since then to keep track of this are staying between 98 and 99% so I do
not think this is my problem now. Those
changes did not make any difference to the
users. Even though the disk/memory read was not above 95%, it
was at 92% so that is probably why no performance gain
was noticed. We are using PL/SQL procedures
heavily. The stats on the Library Cache looked good though.
I read something this weekend about how using 'logical'
drives to separate the different files can cause a
performance hit. I am using logical
disks, and I plan to change when I can, but I'm not sure yet
how much that will help. I have redistributed some
of the rollback segments so that they are not all
located on the same disk. However since some
of the drives are logical, that may not ha

RE: Hey Jared!!

2003-08-26 Thread Orr, Steve

You're MUCH too merciful! We should start by infecting him or her with
worms and viruses of the biologic type.  :-)


-Original Message-
Sent: Tuesday, August 26, 2003 4:09 PM
To: Multiple recipients of list ORACLE-L


I sure hope so.  Then he/she should be publicly tarred & Feathered.

Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA

-Original Message-
Sent: Tuesday, August 26, 2003 4:45 PM
To: Multiple recipients of list ORACLE-L


I doubt they will ever find the real guy behind this. 

Tanel.

- Original Message - 
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Tuesday, August 26, 2003 10:19 PM


> For all you virus/worm lovers out there, justice do come:
> 
> FBI Subpoenas Arizona ISP In Sobig Probe
> Easynews says it's cooperating with the bureau to find the person
> who uploaded the virus to a Usenet group it hosts.
> informationweek.com/story/showArticle.jhtml?articleID=13800091
> 
> 
> 
> Dick Goulet
> Senior Oracle DBA
> Oracle Certified 8i DBA
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: Goulet, Dick
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in 
> the message BODY, include a line containing: UNSUB ORACLE-L (or the 
> name of mailing list you want to be removed from).  You may also send 
> the HELP command for other information (like subscribing).
> 

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

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

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

Re: SQL HELP!!!

2003-08-26 Thread Dave Hau

select id, received_date,
count(count_non_web) non_web_count,
count(count_web) web_count,
(count(count_non_web) / count(*) * 100) non_web_count_percent,
(count(count_web) / count(*) * 100) web_count_percent
from
(select id, to_char(received_date, '-mm') received_date,
(case when seq_no <= 4000 then 1 else null end) count_non_web,
(case_when seq_no > 4000 then 1 else null end) count_web
from t
where received_date between '01/01/2003' and '12/31/2003')
group by id,
received_date
HTH,
Dave


[EMAIL PROTECTED] wrote:
Dave,
 
Thanks much! I appreciate your help. One other thing I might have 
forgotten is there a way to calculate non_web_count - to - total  %
and web_count - to total %
 
so in this way:
 
output would be like:
ID  YEAR  NON WEB  % WEB   %NON-WEB
 
AC 2003-014798   67.632.4
AC 2003-0226   112
AC 2003-0357   121
AC 2003-0440   124
 
And so forth...
 
Thanks Dave and evryone else for your help!

Dave Hau <[EMAIL PROTECTED]> wrote:

select id, received_date,
count(count_non_web) non_web_count,
count(count_web) web_count
from
(select id, to_char(received_date, '-mm') received_date,
(case when seq_no <= 4000 then 1 else null end) count_non_web,
(case_when seq_no > 4000 then 1 else null end) count_web
from t
where received_date between '01/01/2003' and '12/31/2003')
group by id,
received_date
HTH,
Dave


[EMAIL PROTECTED] wrote:
 > Jared,
 >
 > Thanks for your fast reply! Sorry if I didn't explain myself clear
 > enough. Unfortunately count_web is not a column,
id||yr||seq_no||ck is a
 > combination of 4 columns that make up a primary key. if seq_no
 >4000, in
 > a id||yr||seq_no||ck row, it's a "web row", if not then it's not.
what I
 > would like to see is:
 >
 > ID Received_date No! n-web count Web_count
 > AR 2003-01 0 4
 > AR 2003-02 0 6
 > AR 2003-0 1 8
 > and so forth.
 >
 > Again thanks for any suggestions you may have!
 >
 > Thanks very much!
 >
 >
 >
 >
 >
 >
 >
 > [EMAIL PROTECTED] wrote:
 >
 >
 > I'm not sure I entirely understand the result you are trying to
 > achieve.
 >
 > Perhaps this will help
 >
 > select received_date, msno, sum(count_web), hardcopy
 > from (
 > select id ,
 > to_char(received_date, '-mm') received_date,
 > id||yr||seq_no||ck MSNO
 > CASE WHEN seq_no > 4000 then count(seq_no) ELSE 0 end
 > Count_WEB,
 > CASE WHEN seq_no <=4000 then count(seq_no) ELSE 0 END
 > HARDCOPY
 > from t
 > where received_date between '01/01/2003' and '12/31/2003'
 > group by id,
 > &nbs! p; to_char(received_date, '-mm'),
 > sequence_no,
 > id||yr||seq_no||ck
 > )
 > group by received_date, msno, hardcopy
 > /
 >
 >
 >
 >
 > Viktor
 > Sent by: [EMAIL PROTECTED]
 >
 > 08/26/2003 01:59 PM
 > Please respond to ORACLE-L
 >
 >
 > To: Multiple recipients of list ORACLE-L
 >
 > cc:
 > Subject: SQL HELP!!!
 >
 >
 >
 >
 > Hello,
 >
 > I was wondering if someone can help me with a report. I am stuck
 > figuring out what I can do to complete it. Here is what I need to do:
 >
 > for a given date range, i..e. start_date - end_date ('01/01/2003',
 > '12/31/2003'), I need to count all "web", and "non-web" reco! rds.
 > If seq_no > 4000, then it's web, otherwise non-web. seq_no is not
 > unique. So it's like 2 different where claused in a single select.
 > Could I somehow use CASE or ! decode to accomplish this. Here is what
 > I am trying to do in select:
 >
 > select id ,
 > to_char(received_date, '-mm'),
 > id||yr||seq_no||ck MSNO
 > CASE WHEN seq_no > 4000 then count(seq_no) ELSE 0 end
 > Count_WEB,
 > CASE WHEN seq_no <=4000 then count(seq_no) ELSE 0 END
 > HARDCOPY
 > from t
 > where received_date between '01/01/2003' and '12/31/2003'
 > group by id,
 > to_char(received_date, '-mm'),
 > sequence_no,
 > id||yr||seq_no||ck !
 > /
 >
 > AR 2003-01 AR030023T 0 1
 > AR 2003-01 AR0200302 0 1
 > AR 2003-01 AR020047K 0 1
 > AR 2003-01 AR020077N 0 1
 >
 > I would like to show Year-Month once and count all instances of
 > id||yr||seq_no||ck (primary_key) for that Year-Month, but not to
 > break on it, and unfortunaley it won't let me do it without grouping
 > on seq_no
 >
 > Please advise!!!
 > Any help is g! reatly appreciated!
 >
 >
 >
 >

 > Do you Yahoo!?
 > Yahoo! SiteBuilder
 > -
 > Free, easy-to-use web site design software
 >
 >
--

RE: NEXT_EXTENT and PCT_INCREASE

2003-08-26 Thread Roger Xu


Why the table was created with initial extent as 1700M,
but dba_extents says the first extent is 8M only?

SQL> select initial_extent from dba_tables where table_name='BSIS';
1782579200

SQL> select bytes from dba_extents where segment_name='BSIS' and extent_id=1;
   8388608

SQL> select bytes,count(*) from dba_extents where segment_name='BSIS' group by bytes;
   8388608113
  67108864137

-Original Message-
Sent: Tuesday, August 26, 2003 3:14 PM
To: Multiple recipients of list ORACLE-L


Roger, 

1. Space management can be specified for a tablespace, not a segment. Create
ASSM tablespace and alter table ... move there.

2. Locally managed tablespace, I guess. Oracle doesn't need NEXT_EXTENT and
PCT_INCREASE then.

HTH
Vadim

-Original Message-
Sent: Tuesday, August 26, 2003 3:59 PM
To: Multiple recipients of list ORACLE-L


Hi,

I have the following output when I querying dba_tables.

Question 1: This table is created using manual management method, right?
What do I do in order to turn it to Automatic segment-space
management?

Question 2: How come there are no values for NEXT_EXTENT and PCT_INCREASE?

Thanks,

Roger Xu


  PCT_FREE   PCT_USED  INI_TRANS  MAX_TRANS
-- -- -- --
10 40  1255

INITIAL_EXTENT NEXT_EXTENT MIN_EXTENTS MAX_EXTENTS PCT_INCREASE
-- --- --- --- 
 527491072   1  2147483645

 FREELISTS FREELIST_GROUPS
-- ---
 1   1

LOGGING BACKED_UP   NUM_ROWS
--- - --
YES N  216122635

BLOCKS EMPTY_BLOCKS  AVG_SPACE  CHAIN_CNT
--  -- --
   7651115 4307319  0


AVG_ROW_LEN AVG_SPACE_FREELIST_BLOCKS NUM_FREELIST_BLOCKS
--- - ---
254  4496   2

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

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

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

For technical support please email [EMAIL PROTECTED] or you can
call (972)721-8257. 
This email has been scanned for all viruses by the MessageLabs Email Security System.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Roger Xu
  INET: [EMAIL PROTECTED]

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

Title: Message

Nope,
you're the first. What happened? Segmentation violation? If that is so, I'd like
to know, because
not
all of my trace files are small.
--Mladen GogalaOracle DBA

-Original Message-From:
[EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of
Jamadagni, RajendraSent: Tuesday, August 26, 2003 4:54
PMTo: Multiple recipients of list ORACLE-LSubject: RE:
Performance Problem
Funny ...
I have tkprof give up analyzing a 4.2G tracefile on a 64bit
platform. anyone else experienced this??
Raj
Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal.
QOTD: Any clod can have facts, having an opinion is an art
!
-Original Message- From: Cary
Millsap [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, August 26, 2003 4:24 PM To: Multiple recipients of list ORACLE-L Subject: RE: Performance Problem
Laura,
You might find the problem by checking the things you plan to
check, and by following the advice of the book you're
using. But the odds are very good that you will not.
At least not for a long time...
Any application program on your system can tell you where it
is spending its time. Let it tell you. Take a 10046
level-12 trace of *any* important, slow application
program. Read http://www.hotsos.com/dnloads/1/timing-data/Oracle%20Operational%20Timin
g%20Data.pdf, or ask the list for details if you need some
help.
Cary Millsap Hotsos Enterprises,
Ltd. http://www.hotsos.com
Upcoming events: - Hotsos Clinic 101
in Sydney - Hotsos Symposium 2004, March 7-10
Dallas - Visit www.hotsos.com for schedule
details...
-Original Message- Burton,
Laura Sent: Tuesday, August 26, 2003 2:30 PM
To: Multiple recipients of list ORACLE-L
No, I had read not to analyze the sys tables in the 'TIP'
section of the book I am using as a reference (Oracle
Performance Tuning/Tips & Techniques). As I
stated earlier, I also made sure that I analyzed all the tables and indexes that were involved, because I had read
that leaving a table 'un'analyzed would cause a
performance hit.
Someone earlier had suggested doing the analyze during an
'off' time. This I did not do. It was done while
everything was going on, so maybe that is why
everything came to a standstill. Anyway I want to try it
again after I upgrade and do so when others are not
on.
If you know of any other gotcha's, please let me know. I
may not have picked up on it in my research.

Someone else had responded about looking at systemic things
before attacking the code. I had already done
this and found that I needed to enlarge my sort area
because the disk read ratio was a little high. I also enlarged my shared pool size. The stats I have been running
since then to keep track of this are staying between
98 and 99% so I do not think this is my problem
now. Those changes did not make any difference to the users. Even though the disk/memory read was not above 95%,
it was at 92% so that is probably why no performance
gain was noticed. We are using PL/SQL procedures
heavily. The stats on the Library Cache looked
good though.
I read something this weekend about how using 'logical' drives
to separate the different files can cause a
performance hit. I am using logical disks,
and I plan to change when I can, but I'm not sure yet how much that will help. I have redistributed some of the
rollback segments so that they are not all located on
the same disk. However since some of the drives
are logical, that may not have done any good. I've
rebuilt indexes, changed extent sizes to reduce the amount of extents, added rollback segments, etc. In lieu of this, code is
next...
Thanks, Laura
-Original Message- Sent:
Tuesday, August 26, 2003 1:29 PM To: Multiple
recipients of list ORACLE-L
Did you analyze the sys schema by mistake. This
can stop the fastest database. We had a
contractor do that to an 8.0.5 database once, and only once.
Ruth
-- Please see the official ORACLE-L
FAQ: http://www.orafaq.net --
Author: Burton, Laura
INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego,
California -- Mailing list and web
hosting services -
To REMOVE yourself from this mailing list, send an E-Mail
message to: [EMAIL PROTECTED] (note EXACT spelling
of 'ListGuru') and in the message BODY, include a line
containing: UNSUB ORACLE-L (or the name of mailing
list you want to be removed from). You may also
send the HELP command for other information (like subscribing).

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

RE: Onames and various connections scenarios

2003-08-26 Thread Bob Metelsky

No doubt im in the wrong ball field here but this is what I have

Windows 2k
Server1 Ns1 on 8.1.7.4
Server2 Ns2 on 9.2.0.1.0

[server1]
C:\> start \\server1\bin\namesctl dump_tnsnames C:\mytnsnames.txt
It creates an empty file on my (remote) machine

>From the server C:\> namesctl  dump_tnsnames C:\mytnsnames.txt it creats
an empty C:\mytnsnames.txt


[server2]
C:\> start \\server2\bin\namesctl dump_tnsnames C:\mytnsnames.txt
And it creates an empty file on my (remote) machine

>From the server itself it creats a full C:\mytnsnames.txt file with all
the connect discriptors

How is this supposed to be called?

Thanks!

> Bob,
> 
> I understand what you are saying (and your pain). My 
> suggestion would be to use the 'namesctl dump_tnsnames' 
> command to dump out the current Onames repository to the PC's 
> $TNS_ADMIN dir via a login script or SMS. You might want o 
> rename the current TNSNAMES.ORA file just prior to that as 
> dump_tnsnames adds to the end of the current one and doesn't 
> handle changes very well.
> 
> Hth,
> John Kanagaraj
> DB Soft Inc
> Phone: 408-970-7002 (W)
> 
> Grace - Getting something we do NOT deserve
> Mercy - NOT getting something we DO deserve
> Click on 'http://www.needhim.org' for Grace and Mercy that is 
> freely available!
> 
> ** The opinions and facts contained in this message are 
> entirely mine and do not reflect those of my employer or customers **
> 
> -Original Message-
> Sent: Tuesday, August 26, 2003 6:44 AM
> To: Multiple recipients of list ORACLE-L
> 
> 
> Hello All
> 
>   Im back from the trenches to post a quick request for 
> help
> 
> Ive setup onames on 2 servers and standard applications, (our app and
> sqlplus) connect just fine, a problem situation manifests itself when:
> 
> 1 users need to connect (add a database) to dba studio. They 
> get a error to the effect "cant resolve host name" And the 
> other 2. Users connect to remote databases (via vpn) that are 
> in our onames but many  of these vpn connections once made do 
> not allow access to
> *our* network resources.
> 
> So basically almost all of oour users have one or more of 
> these secenarios which means they will need to maintain a 
> tnsnames file as well.
> 
> I'm managing about 70+ connect discriptors And I was 
> hoping onames could be a centralised answer
> 
> Is this common? Or is there a workaround?
> 
> Thanks!
> bob
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: Bob Metelsky
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 
> and in the message BODY, include a line containing: UNSUB 
> ORACLE-L (or the name of mailing list you want to be removed 
> from).  You may also send the HELP command for other 
> information (like subscribing).
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: John Kanagaraj
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 
> and in the message BODY, include a line containing: UNSUB 
> ORACLE-L (or the name of mailing list you want to be removed 
> from).  You may also send the HELP command for other 
> information (like subscribing).
> 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Bob Metelsky
  INET: [EMAIL PROTECTED]

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

RE: Re: OT - Linux books ??

Define "based"?

--
Mladen Gogala
Oracle DBA 



-Original Message-
Tanel Poder
Sent: Tuesday, August 26, 2003 4:44 PM
To: Multiple recipients of list ORACLE-L


AFAIK, Apples unix is based on [Open|Free]BSD as well.

Tanel.





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

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

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

Re: SQL HELP!!!

Dave,
 
Thanks much! I appreciate your help. One other thing I might have forgotten is there a way to calculate non_web_count - to - total  %
and web_count - to total % 
 
so in this way:
 
output would be like:
ID  YEAR  NON WEB  % WEB   %NON-WEB
 
AC 2003-01    47    98   67.6    32.4AC 2003-02    26   112AC 2003-03    57   121AC 2003-04    40   124
 
And so forth...
 
Thanks Dave and evryone else for your help!Dave Hau <[EMAIL PROTECTED]> wrote:
select id, received_date,count(count_non_web) non_web_count,count(count_web) web_countfrom(select id, to_char(received_date, '-mm') received_date,(case when seq_no <= 4000 then 1 else null end) count_non_web,(case_when seq_no > 4000 then 1 else null end) count_webfrom twhere received_date between '01/01/2003' and '12/31/2003')group by id,received_dateHTH,Dave[EMAIL PROTECTED] wrote:> Jared,> > Thanks for your fast reply! Sorry if I didn't explain myself clear > enough. Unfortunately count_web is not a column, id||yr||seq_no||ck is a > combination of 4 columns that make up a primary key. if seq_no >4000, in > a id||yr||seq_no||ck row, it's a "web row", if not then it's not. what I > would like to see is:> > ID Received_date No!
n-web
 count Web_count> AR 2003-01 0 4> AR 2003-02 0 6> AR 2003-0 1 8> and so forth.> > Again thanks for any suggestions you may have!> > Thanks very much!> > > > > > > > [EMAIL PROTECTED] wrote:> > > I'm not sure I entirely understand the result you are trying to> achieve.> > Perhaps this will help> > select received_date, msno, sum(count_web), hardcopy> from (> select id ,> to_char(received_date, '-mm') received_date,> id||yr||seq_no||ck MSNO> CASE WHEN seq_no > 4000 then count(seq_no) ELSE 0 end> Count_WEB,> CASE WHEN seq_no <=4000 then count(seq_no) ELSE 0 END> HARDCOPY> from t> where received_date between '01/01/2003' and '12/31/2003'> group by id,> &nbs! p; to_char(received_date, '-mm'),>
 sequence_no,> id||yr||seq_no||ck> )> group by received_date, msno, hardcopy> /> > > > > Viktor <[EMAIL PROTECTED]>> Sent by: [EMAIL PROTECTED]> > 08/26/2003 01:59 PM> Please respond to ORACLE-L> > > To: Multiple recipients of list ORACLE-L> <[EMAIL PROTECTED]>> cc: > Subject: SQL HELP!!!> > > > > Hello,> > I was wondering if someone can help me with a report. I am stuck> figuring out what I can do to complete it. Here is what I need to do:> > for a given date range, i..e. start_date - end_date ('01/01/2003',> '12/31/2003'), I need to count all "web", and "non-web" reco! rds.> If seq_no > 4000, then it's web, otherwise non-web. seq_no is not> unique. So it's like 2 different where claused in a single select.> Could I somehow use CASE or !
decode to
 accomplish this. Here is what> I am trying to do in select:> > select id ,> to_char(received_date, '-mm'),> id||yr||seq_no||ck MSNO> CASE WHEN seq_no > 4000 then count(seq_no) ELSE 0 end> Count_WEB,> CASE WHEN seq_no <=4000 then count(seq_no) ELSE 0 END> HARDCOPY> from t> where received_date between '01/01/2003' and '12/31/2003'> group by id,> to_char(received_date, '-mm'),> sequence_no,> id||yr||seq_no||ck !> /> > AR 2003-01 AR030023T 0 1> AR 2003-01 AR0200302 0 1> AR 2003-01 AR020047K 0 1> AR 2003-01 AR020077N 0 1> > I would like to show Year-Month once and count all instances of> id||yr||seq_no||ck (primary_key) for that Year-Month, but not to> break on it, and unfortunaley it won't let me do it without grouping> on seq_no> > Please advise!!! > Any help is g!
reatly
 appreciated!> > > > > Do you Yahoo!?> Yahoo! SiteBuilder> -> Free, easy-to-use web site design software> > > Do you Yahoo!?> Yahoo! SiteBuilder > - Free, > easy-to-use web site design software-- Please see the official ORACLE-L FAQ: http://www.orafaq.net-- Author: Dave HauINET: [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).
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software

Re: SQL HELP!!!

Jared,
 
Thanks for your fast reply! Sorry if I didn't explain myself clear enough. Unfortunately count_web is not a column, id||yr||seq_no||ck is a combination of 4 columns that make up a primary key. if seq_no >4000, in a id||yr||seq_no||ck row, it's a "web row", if not then it's not. what I would like to see is:
 
ID  Received_date   Non-web count   Web_count
AR 2003-01    0   4AR 2003-02    0   6AR 2003-0  1   8
and so forth.
 
Again thanks for any suggestions you may have!
 
Thanks very much!
 
 
[EMAIL PROTECTED] wrote:
I'm not sure I entirely understand the result you are trying to achieve. Perhaps this will help select received_date, msno, sum(count_web), hardcopy from ( select id ,         to_char(received_date, '-mm') received_date,         id||yr||seq_no||ck MSNO         CASE WHEN seq_no > 4000 then count(seq_no) ELSE 0 end Count_WEB,         CASE WHEN seq_no <=4000 then count(seq_no) ELSE 0   END  HARDCOPY  from twhere received_date between '01/01/2003' and '12/31/2003'group by id,&nbs!
p;
 to_char(received_date, '-mm'),    sequence_no,  id||yr||seq_no||ck ) group by received_date, msno, hardcopy / 




Viktor <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 
 08/26/2003 01:59 PM  Please respond to ORACLE-L 
                To:        Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>         cc:                 Subject:        SQL HELP!!!Hello,   I was wondering if someone can help me with a report. I am stuck figuring out what I can do to complete it. Here is what I need to do:   for a given date range, i..e. start_date - end_date ('01/01/2003',  '12/31/2003'), I need to count all "web", and "non-web" reco!
rds. If
 seq_no > 4000, then it's web, otherwise non-web. seq_no is not unique. So it's like 2 different where claused in a single select. Could I somehow use CASE or decode to accomplish this. Here is what I am trying to do in select:   select id ,         to_char(received_date, '-mm'),         id||yr||seq_no||ck MSNO         CASE WHEN seq_no > 4000 then count(seq_no) ELSE 0 end Count_WEB,         CASE WHEN seq_no <=4000 then count(seq_no) ELSE 0   END  HARDCOPY  from twhere received_date between '01/01/2003' and '12/31/2003'group by id,  to_char(received_date, '-mm'),    sequence_no,  id||yr||seq_no||ck !
/   AR 2003-01 AR030023T         0              1AR 2003-01 AR0200302         0              1AR 2003-01 AR020047K         0              1AR 2003-01 AR020077N         0              1   I would like to show Year-Month once and count all instances of  id||yr||seq_no||ck (primary_key) for that Year-Month, but not to break on it, and unfortunaley it won't let me do it without grouping on seq_no   Please advise!!!   Any help is greatly appreciated!     


Do you Yahoo!?Yahoo! SiteBuilder - Free, easy-to-use web site design software 


Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software

Re: Query results to .csv/use of dblinks

Hi!

In one migration of about 600GB DB I used 2 dblinks (loading different
partitions in parallel with separate statements), then added 3rd link after
what the bottleneck seemed to be the network. (I saw full network
utilization from perfmon on windows, wasn't too much of a wait interface
user back then). But your mileage may vary.

So, full hardware utilization is definitely good, at least during
migrations, but before thinking about that, you have to put together an
optimal migration path and methodology.

Tanel.

- Original Message - 
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Tuesday, August 26, 2003 10:54 PM


> Tanel,
>
> A quick question? How many open dblinks you have used at one time without
> any issues? Default setting in init.ora is 4(if I am not wrong) and I
never
> used it more than that. If Dennis wants to use more than 4 dblinks at one
> time, he should modify this param(open_dblinks) in init.ora, right.
>
> Regards
> Rafiq
>
>
>
>
>
>
>
>
> Reply-To: [EMAIL PROTECTED]
> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> Date: Tue, 26 Aug 2003 09:14:26 -0800
>
> Hi!
>
> What is your goal? To finish data transfer in the shortest time or keep
> hardware utilization maximum during transfer?
> I think you should concentrate on keeping the time for doing data transfer
> low.
>
> Depending on your network - in case of gigabit (or 10 Gb) you could look
at
> enabling jumbo frames, which enable ethernet packets up to 9000 bytes.
Also
> set (SDU=32768) in your listener and tnsnames.oras (you can set it with
> normal 1500 byte frames as well).
>
> About parallellism, you might want to run several bulk inserts over dblink
> to fully utilize your network (fill the "gaps" when one session is busy
> inserting, thus not using the network). But if your source disk array (or
> CPUs) are slow then they might be the bottleneck.
> If you got SAN and a temporary spare server, do a BCV copy or mirror
split,
> open up several clones of a database and copy data from all of them.
>
> Also, when you have SAN, there's no need for network transfer at all - you
> just mount the filesystem with dump/exportfiles on target database and do
> the load from there. If your operating systems are different, then just
dump
> to raw device, with pipe and tar for example, or completely raw,
remembering
> your data sizes. Note that in some (older) operating systems there were
few
> blocks in beginning of device which were used (and written) by operating
> system (Tru64 had the largest I know - 64k). Thus you had to make sure you
> didn't write anything there (oseek=65536 for dd for example).
>
> If downtime isn't an issue for you, it might not be worth trying above
> recommendations, but in RVLDBs (really very large databases) all of this
can
> help a lot.
>
> Tanel.
> - Original Message -
> To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
> Sent: Tuesday, August 26, 2003 5:54 PM
>
>
>  > Taniel, Binley
>  >Thanks for the excellent suggestions.
>  >At this point we have been testing with two smaller test systems,
> moving
>  > a single table at a time, but initial indications are that the
> performance
>  > order is:
>  > 1. Perl dump to CSV / ftp / SQL*Loader
>  > 2. Copy across database link
>  > 3. Export/ ftp / import
>  >
>  > I need to re-run the tests once the target production system is
available
> to
>  > re-confirm which is faster. I am pretty confident in the ability to run
>  > multiple SQL*Loader and import sessions simultaneously. I am a little
>  > nervous about the ability of the database link to scale to enough
>  > simultaneous sessions to keep the RAID sets maxed out on the target
> system.
>  > Several years ago when I was doing a large conversion I hit that limit.
> Some
>  > days I wonder if we are the beneficiary or victim of our prior
> experience.
>  > Oh well thanks for all the good suggestions, on to testing, testing,
>  > testing.
>  >
>  > Dennis Williams
>  > DBA, 80%OCP, 100% DBA
>  > Lifetouch, Inc.
>  > [EMAIL PROTECTED]
>  >
>  >
>  > -Original Message-
>  > Sent: Monday, August 25, 2003 7:09 PM
>  > To: Multiple recipients of list ORACLE-L
>  >
>  >
>  > Hi!
>  >
>  > What about several insert /*+ APPEND NOLOGGING */ commands over
database
>  > link run in parallel? (Possibly over dedicated network). This is fast
and
> is
>  > easier (in case you don't hit any compatibility problems). If you
happen
> to
>  > be running on Windows for some reason, you could try to use named pipes
>  > network protocol instead of TCP as well.
>  >
>  > Tanel.
>  >
>  > - Original Message -
>  > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
>  > Sent: Monday, August 25, 2003 11:04 PM
>  >
>  >
>  > > Thanks Tanel
>  > >   We will undoubtedly use export/import for the many small tables. We
> are
>  > > looking for alternatives that will perform even faster. The insert
> phase
>  > > seems to be the slowest part

Re: SQL HELP!!!


I'm not sure I entirely understand the result you are trying to achieve.

Perhaps this will help

select received_date, msno, sum(count_web), hardcopy
from (
select id ,
          to_char(received_date, '-mm') received_date,
          id||yr||seq_no||ck MSNO
          CASE WHEN seq_no > 4000 then count(seq_no) ELSE 0 end Count_WEB,
          CASE WHEN seq_no <=4000 then count(seq_no) ELSE 0   END  HARDCOPY
 from t
where received_date between '01/01/2003' and '12/31/2003'
group by id,
   to_char(received_date, '-mm'),
   sequence_no,
   id||yr||seq_no||ck
)
group by received_date, msno, hardcopy
/








Viktor <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
 08/26/2003 01:59 PM
 Please respond to ORACLE-L

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


Hello,
 
I was wondering if someone can help me with a report. I am stuck figuring out what I can do to complete it. Here is what I need to do:
 
for a given date range, i..e. start_date - end_date ('01/01/2003',  '12/31/2003'), I need to count all "web", and "non-web" records. If seq_no > 4000, then it's web, otherwise non-web. seq_no is not unique. So it's like 2 different where claused in a single select. Could I somehow use CASE or decode to accomplish this. Here is what I am trying to do in select:
 
select id ,
          to_char(received_date, '-mm'),
          id||yr||seq_no||ck MSNO
          CASE WHEN seq_no > 4000 then count(seq_no) ELSE 0 end Count_WEB,
          CASE WHEN seq_no <=4000 then count(seq_no) ELSE 0   END  HARDCOPY
 from t
where received_date between '01/01/2003' and '12/31/2003'
group by id,
   to_char(received_date, '-mm'),
   sequence_no,
   id||yr||seq_no||ck
/
 
AR 2003-01 AR030023T         0              1
AR 2003-01 AR0200302         0              1
AR 2003-01 AR020047K         0              1
AR 2003-01 AR020077N         0              1
 
I would like to show Year-Month once and count all instances of  id||yr||seq_no||ck (primary_key) for that Year-Month, but not to break on it, and unfortunaley it won't let me do it without grouping on seq_no
 
Please advise!!!
 
Any help is greatly appreciated!
 
 

Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software

Re: Query results to .csv

Hi!

What do you customers care about? Usability and uptime of their app or
utilization of your server?

If you use direct exp and imp method:
1) you read data from disk (server process from oracle datafiles)
2) you write data to disk (expfile)
3) you read data from disk (ftp reading expfile)
4) you send data over network (quite efficient if using ftp)
5) you write data to disk
6) you read data from disk (imp process reading expfile)
7) you write data to disk (DBWR in background
8) you write data to LGWR too since there is no direct or nologging imp
method

Using dblinks
1) you read data from disk (server process from oracle datafiles)
2) you transfer data over nework (not so efficient that ftp if untuned)
3) you write data to disk (server process doing direct writes when using
append hint)

Nothing more because of append & nologging hint no redo has to be generated
(provided that you build indexes on tables afterwards)

So yes, since dblink transfer can me much more efficient, it won't probably
utilize your servers so much. But you always can do the job 10 times in a
row, or just start compressing ambigous big files on the same disk, then
your utilization should be acceptable as well.

Btw, these silly Oracle methods can provide you valuable knowledge how
Oracle works and they don't cost you money - only some time for learning.
And learning time, as we all (hopefully) know, isn't wasted time.

Tanel.


- Original Message - 
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Tuesday, August 26, 2003 10:44 PM


> Tanel
>Thanks for the ideas. My simple mind says that by fully utilizing the
> hardware I can minimize the overall time. But today we were on a
conference
> call with the application vendor and they were touting their utility for
> handling this. Everyone around the table seemed pretty impressed, so maybe
I
> shouldn't be worrying about all these silly Oracle methods. Anyway I said
> that I would test their utility, but since we don't have the server ready,
> that is all a little way off.
>
> Dennis Williams
> DBA, 80%OCP, 100% DBA
> Lifetouch, Inc.
> [EMAIL PROTECTED]
>
>
> -Original Message-
> Sent: Tuesday, August 26, 2003 12:14 PM
> To: Multiple recipients of list ORACLE-L
>
>
> Hi!
>
> What is your goal? To finish data transfer in the shortest time or keep
> hardware utilization maximum during transfer?
> I think you should concentrate on keeping the time for doing data transfer
> low.
>
> Depending on your network - in case of gigabit (or 10 Gb) you could look
at
> enabling jumbo frames, which enable ethernet packets up to 9000 bytes.
Also
> set (SDU=32768) in your listener and tnsnames.oras (you can set it with
> normal 1500 byte frames as well).
>
> About parallellism, you might want to run several bulk inserts over dblink
> to fully utilize your network (fill the "gaps" when one session is busy
> inserting, thus not using the network). But if your source disk array (or
> CPUs) are slow then they might be the bottleneck.
> If you got SAN and a temporary spare server, do a BCV copy or mirror
split,
> open up several clones of a database and copy data from all of them.
>
> Also, when you have SAN, there's no need for network transfer at all - you
> just mount the filesystem with dump/exportfiles on target database and do
> the load from there. If your operating systems are different, then just
dump
> to raw device, with pipe and tar for example, or completely raw,
remembering
> your data sizes. Note that in some (older) operating systems there were
few
> blocks in beginning of device which were used (and written) by operating
> system (Tru64 had the largest I know - 64k). Thus you had to make sure you
> didn't write anything there (oseek=65536 for dd for example).
>
> If downtime isn't an issue for you, it might not be worth trying above
> recommendations, but in RVLDBs (really very large databases) all of this
can
> help a lot.
>
> Tanel.
> - Original Message - 
> To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
> Sent: Tuesday, August 26, 2003 5:54 PM
>
>
> > Taniel, Binley
> >Thanks for the excellent suggestions.
> >At this point we have been testing with two smaller test systems,
> moving
> > a single table at a time, but initial indications are that the
performance
> > order is:
> > 1. Perl dump to CSV / ftp / SQL*Loader
> > 2. Copy across database link
> > 3. Export/ ftp / import
> >
> > I need to re-run the tests once the target production system is
available
> to
> > re-confirm which is faster. I am pretty confident in the ability to run
> > multiple SQL*Loader and import sessions simultaneously. I am a little
> > nervous about the ability of the database link to scale to enough
> > simultaneous sessions to keep the RAID sets maxed out on the target
> system.
> > Several years ago when I was doing a large conversion I hit that limit.
> Some
> > days I wonder if we are the beneficiary or victim of our prior
experience.

RE: Performance Problem

Laura, I really believe that you should take the 10046 and then contact
Hotsos.
It may and probably will save you some time and aggravation. They're not
very expensive,
around $50 per file analyzed. 

--
Mladen Gogala
Oracle DBA 



-Original Message-
Burton, Laura
Sent: Tuesday, August 26, 2003 3:30 PM
To: Multiple recipients of list ORACLE-L


No, I had read not to analyze the sys tables in the 'TIP' section of the
book I am using as a reference (Oracle Performance Tuning/Tips &
Techniques).  As I stated earlier, I also made sure that I analyzed all the
tables and indexes that were involved, because I had read that leaving a
table 'un'analyzed would cause a performance hit.

Someone earlier had suggested doing the analyze during an 'off' time. This I
did not do.  It was done while everything was going on, so maybe that is why
everything came to a standstill.  Anyway I want to try it again after I
upgrade and do so when others are not on.

If you know of any other gotcha's, please let me know.  I may not have
picked up on it in my research.

Someone else had responded about looking at systemic things before attacking
the code.  I had already done this and found that I needed to enlarge my
sort area because the disk read ratio was a little high.  I also enlarged my
shared pool size.  The stats I have been running since then to keep track of
this are staying between 98 and 99% so I do not think this is my problem
now.  Those changes did not make any difference to the users.  Even though
the disk/memory read was not above 95%, it was at 92% so that is probably
why no performance gain was noticed.  We are using PL/SQL procedures
heavily.  The stats on the Library Cache looked good though.  

I read something this weekend about how using 'logical' drives to separate
the different files can cause a performance hit.  I am using logical disks,
and I plan to change when I can, but I'm not sure yet how much that will
help.  I have redistributed some of the rollback segments so that they are
not all located on the same disk.  However since some of the drives are
logical, that may not have done any good. I've rebuilt indexes, changed
extent sizes to reduce the amount of extents, added rollback segments, etc.
In lieu of this, code is next...

Thanks,
Laura

-Original Message-
Sent: Tuesday, August 26, 2003 1:29 PM
To: Multiple recipients of list ORACLE-L

Did you analyze the sys  schema by mistake.  This can stop the fastest
database.  We had a contractor do that to an 8.0.5 database once, and only
once.

Ruth


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

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



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

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

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

RE: Onames and various connections scenarios


dump_tnsnames can take a path/filename arg

ie. namesctl dump_tnsnames $ORACLE_HOME/network/admin/tmpnames.txt







John Kanagaraj <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
 08/26/2003 12:29 PM
 Please respond to ORACLE-L

        
        To:        Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
        cc:        
        Subject:        RE: Onames and various connections scenarios


Bob,

I understand what you are saying (and your pain). My suggestion would be to
use the 'namesctl dump_tnsnames' command to dump out the current Onames
repository to the PC's $TNS_ADMIN dir via a login script or SMS. You might
want o rename the current TNSNAMES.ORA file just prior to that as
dump_tnsnames adds to the end of the current one and doesn't handle changes
very well.

Hth,
John Kanagaraj
DB Soft Inc
Phone: 408-970-7002 (W)

Grace - Getting something we do NOT deserve
Mercy - NOT getting something we DO deserve
Click on 'http://www.needhim.org' for Grace and Mercy that is freely
available!

** The opinions and facts contained in this message are entirely mine and do
not reflect those of my employer or customers **

-Original Message-
Sent: Tuesday, August 26, 2003 6:44 AM
To: Multiple recipients of list ORACLE-L


Hello All

                 Im back from the trenches to post a quick request for
help

Ive setup onames on 2 servers and standard applications, (our app and
sqlplus) connect just fine, a problem situation manifests itself when:

1 users need to connect (add a database) to dba studio. They get a error
to the effect "cant resolve host name"
And the other
2. Users connect to remote databases (via vpn) that are in our onames
but many  of these vpn connections once made do not allow access to
*our* network resources.

So basically almost all of oour users have one or more of these
secenarios which means they will need to maintain a tnsnames file as
well.

I'm managing about 70+ connect discriptors And I was hoping onames
could be a centralised answer

Is this common? Or is there a workaround?

Thanks!
bob
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Bob Metelsky
  INET: [EMAIL PROTECTED]

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

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

Yes starting from db version 8.1.7 for 11i. For 8.1.6 there was no such
requirement IIRC.
I tried to be smart and ignored the recommendation once when upgrading to
8.1.7 - the result, some queries which were using a view (which name I don't
remember anymore) got extremely slow. I learned a lesson.

Tanel.


- Original Message - 
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Tuesday, August 26, 2003 8:54 PM


> Just fyi - it seems that Oracle had realized this in advance and has
> specifically instructed the Oracle Applications 11i installations to set
> this to 2000.
>
> John Kanagaraj
> DB Soft Inc
> Phone: 408-970-7002 (W)
>
> Listen to great, commercial-free christian music 24x7x365 at
> http://www.klove.com
>
> ** The opinions and facts contained in this message are entirely mine and
do
> not reflect those of my employer or customers **
>
> -Original Message-
> Sent: Tuesday, August 26, 2003 8:55 AM
> To: Multiple recipients of list ORACLE-L
>
>
> One thing that the docs don't mention is that '8'
> (the default in 8) is also a special boundary value.
> Anything less than 80,000 changes some of ways the
> optimizer does it work, ie, its not just a reduction
> in permutations.
>
> Can't remember the specifics - join orders spring to
> mind but there is a metalink note about it.
>
> Because of this, there's a school of thought that even
> on 8i, adopting the (9i default) value of 2000 will
> improve the "general" optimizer performance (ie the
> quality of the decisions it makes).
>
> Cheers
> Connor
>
>  --- "Boivin, Patrice J" <[EMAIL PROTECTED]>
> wrote: > Has anyone worked with this one?
> >
> >
>
http://download-west.oracle.com/docs/cd/A87860_01/doc/server.817/a76961/ch11
> > 23.htm#81357
> >
>
 > 123.htm#81357>
> >
> > Patrice.
> >
>
> =
> Connor McDonald
> web: http://www.oracledba.co.uk
> web: http://www.oaktable.net
> email: [EMAIL PROTECTED]
>
> "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"
>
> 
> Want to chat instantly with your online friends?  Get the FREE Yahoo!
> Messenger http://uk.messenger.yahoo.com/
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: =?iso-8859-1?q?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.net
> -- 
> Author: John Kanagaraj
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
>


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

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

RE: Query results to .csv/use of dblinks

2003-08-26 Thread M Rafiq

Thanks for your input. Discussion here is to keep maximum use of dblinks for 
data load/transfer from one server to another.

Regards
Rafiq






Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Date: Tue, 26 Aug 2003 12:49:27 -0800
You can also close the dblink to avoid having many open idle sessions on the
remote database.
alter session close database link dblink;
Stephane Paquette
Administrateur de bases de donnees
Database Administrator
Standard Life
www.standardlife.ca
Tel. (514) 499-7999 7470 and (514) 925-7187
[EMAIL PROTECTED] 


-Original Message-
Rafiq
Sent: Tuesday, August 26, 2003 3:54 PM
To: Multiple recipients of list ORACLE-L
Tanel,

A quick question? How many open dblinks you have used at one time without
any issues? Default setting in init.ora is 4(if I am not wrong) and I never
used it more than that. If Dennis wants to use more than 4 dblinks at one
time, he should modify this param(open_dblinks) in init.ora, right.
Regards
Rafiq






Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Date: Tue, 26 Aug 2003 09:14:26 -0800
Hi!

What is your goal? To finish data transfer in the shortest time or keep
hardware utilization maximum during transfer?
I think you should concentrate on keeping the time for doing data transfer
low.
Depending on your network - in case of gigabit (or 10 Gb) you could look at
enabling jumbo frames, which enable ethernet packets up to 9000 bytes. Also
set (SDU=32768) in your listener and tnsnames.oras (you can set it with
normal 1500 byte frames as well).
About parallellism, you might want to run several bulk inserts over dblink
to fully utilize your network (fill the "gaps" when one session is busy
inserting, thus not using the network). But if your source disk array (or
CPUs) are slow then they might be the bottleneck.
If you got SAN and a temporary spare server, do a BCV copy or mirror split,
open up several clones of a database and copy data from all of them.
Also, when you have SAN, there's no need for network transfer at all - you
just mount the filesystem with dump/exportfiles on target database and do
the load from there. If your operating systems are different, then just dump
to raw device, with pipe and tar for example, or completely raw, remembering
your data sizes. Note that in some (older) operating systems there were few
blocks in beginning of device which were used (and written) by operating
system (Tru64 had the largest I know - 64k). Thus you had to make sure you
didn't write anything there (oseek=65536 for dd for example).
If downtime isn't an issue for you, it might not be worth trying above
recommendations, but in RVLDBs (really very large databases) all of this can
help a lot.
Tanel.
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Tuesday, August 26, 2003 5:54 PM
 > Taniel, Binley
 >Thanks for the excellent suggestions.
 >At this point we have been testing with two smaller test systems,
moving
 > a single table at a time, but initial indications are that the
performance
 > order is:
 > 1. Perl dump to CSV / ftp / SQL*Loader
 > 2. Copy across database link
 > 3. Export/ ftp / import
 >
 > I need to re-run the tests once the target production system is 
available
to
 > re-confirm which is faster. I am pretty confident in the ability to run
 > multiple SQL*Loader and import sessions simultaneously. I am a little
 > nervous about the ability of the database link to scale to enough
 > simultaneous sessions to keep the RAID sets maxed out on the target
system.
 > Several years ago when I was doing a large conversion I hit that limit.
Some
 > days I wonder if we are the beneficiary or victim of our prior
experience.
 > Oh well thanks for all the good suggestions, on to testing, testing,
 > testing.
 >
 > Dennis Williams
 > DBA, 80%OCP, 100% DBA
 > Lifetouch, Inc.
 > [EMAIL PROTECTED]
 >
 >
 > -Original Message-
 > Sent: Monday, August 25, 2003 7:09 PM
 > To: Multiple recipients of list ORACLE-L
 >
 >
 > Hi!
 >
 > What about several insert /*+ APPEND NOLOGGING */ commands over database
 > link run in parallel? (Possibly over dedicated network). This is fast 
and
is
 > easier (in case you don't hit any compatibility problems). If you happen
to
 > be running on Windows for some reason, you could try to use named pipes
 > network protocol instead of TCP as well.
 >
 > Tanel.
 >
 > - Original Message -
 > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
 > Sent: Monday, August 25, 2003 11:04 PM
 >
 >
 > > Thanks Tanel
 > >   We will undoubtedly use export/import for the many small tables. We
are
 > > looking for alternatives that will perform even faster. The insert
phase
 > > seems to be the slowest part, and that is where SQL*Loader in direct
path
 > > really shines. Now the next issue is how to produce a CSV file as fast
as
 > > possible, and so far it looks l

RE: Hey Jared!!

He's with Saddam, Mullah Omar and UBL.

--
Mladen Gogala
Oracle DBA 



-Original Message-
Tanel Poder
Sent: Tuesday, August 26, 2003 4:45 PM
To: Multiple recipients of list ORACLE-L


I doubt they will ever find the real guy behind this. 

Tanel.

- Original Message - 
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Tuesday, August 26, 2003 10:19 PM


> For all you virus/worm lovers out there, justice do come:
> 
> FBI Subpoenas Arizona ISP In Sobig Probe
> Easynews says it's cooperating with the bureau to find the person
> who uploaded the virus to a Usenet group it hosts.
> informationweek.com/story/showArticle.jhtml?articleID=13800091
> 
> 
> 
> Dick Goulet
> Senior Oracle DBA
> Oracle Certified 8i DBA
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: Goulet, Dick
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in 
> the message BODY, include a line containing: UNSUB ORACLE-L (or the 
> name of mailing list you want to be removed from).  You may also send 
> the HELP command for other information (like subscribing).
> 

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

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




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

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

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

ROW_ID Hint

2003-08-26 Thread Smith, Ron L.

I have a vendor application that is running slow.  I looked at the code
through a product called SQLab and found that most of the code has a
ROW_ID hint coded in it.  My understanding is that this hint will
prevent the code from using indexes even though the tables and indexes
are analyzed.  I modified the Oracle startup parameters to use optimizer
mode = FIRST_ROWS which favors indexes.  Now when I run the application
the response time is much better.  I am thinking this may be a good fix
but is there any kind of program logic I could be screwing up by using
FIRST_ROWS?

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

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

Hello,
 
I was wondering if someone can help me with a report. I am stuck figuring out what I can do to complete it. Here is what I need to do:
 
for a given date range, i..e. start_date - end_date ('01/01/2003',  '12/31/2003'), I need to count all "web", and "non-web" records. If seq_no > 4000, then it's web, otherwise non-web. seq_no is not unique. So it's like 2 different where claused in a single select. Could I somehow use CASE or decode to accomplish this. Here is what I am trying to do in select:
 
select id ,  to_char(received_date, '-mm'),  id||yr||seq_no||ck MSNO  CASE WHEN seq_no > 4000 then count(seq_no) ELSE 0 end Count_WEB,  CASE WHEN seq_no <=4000 then count(seq_no) ELSE 0   END  HARDCOPY
 from twhere received_date between '01/01/2003' and '12/31/2003'group by id,   to_char(received_date, '-mm'),
   sequence_no,   id||yr||seq_no||ck
/
 
AR 2003-01 AR030023T 0  1AR 2003-01 AR0200302 0  1AR 2003-01 AR020047K 0  1AR 2003-01 AR020077N 0  1
 
I would like to show Year-Month once and count all instances of  id||yr||seq_no||ck (primary_key) for that Year-Month, but not to break on it, and unfortunaley it won't let me do it without grouping on seq_no
 
Please advise!!!
 
Any help is greatly appreciated!
 
 
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software

RE: Query results to .csv/use of dblinks

2003-08-26 Thread Stephane Paquette

You can also close the dblink to avoid having many open idle sessions on the
remote database.
alter session close database link dblink;


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



-Original Message-
Rafiq
Sent: Tuesday, August 26, 2003 3:54 PM
To: Multiple recipients of list ORACLE-L


Tanel,

A quick question? How many open dblinks you have used at one time without
any issues? Default setting in init.ora is 4(if I am not wrong) and I never
used it more than that. If Dennis wants to use more than 4 dblinks at one
time, he should modify this param(open_dblinks) in init.ora, right.

Regards
Rafiq








Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Date: Tue, 26 Aug 2003 09:14:26 -0800

Hi!

What is your goal? To finish data transfer in the shortest time or keep
hardware utilization maximum during transfer?
I think you should concentrate on keeping the time for doing data transfer
low.

Depending on your network - in case of gigabit (or 10 Gb) you could look at
enabling jumbo frames, which enable ethernet packets up to 9000 bytes. Also
set (SDU=32768) in your listener and tnsnames.oras (you can set it with
normal 1500 byte frames as well).

About parallellism, you might want to run several bulk inserts over dblink
to fully utilize your network (fill the "gaps" when one session is busy
inserting, thus not using the network). But if your source disk array (or
CPUs) are slow then they might be the bottleneck.
If you got SAN and a temporary spare server, do a BCV copy or mirror split,
open up several clones of a database and copy data from all of them.

Also, when you have SAN, there's no need for network transfer at all - you
just mount the filesystem with dump/exportfiles on target database and do
the load from there. If your operating systems are different, then just dump
to raw device, with pipe and tar for example, or completely raw, remembering
your data sizes. Note that in some (older) operating systems there were few
blocks in beginning of device which were used (and written) by operating
system (Tru64 had the largest I know - 64k). Thus you had to make sure you
didn't write anything there (oseek=65536 for dd for example).

If downtime isn't an issue for you, it might not be worth trying above
recommendations, but in RVLDBs (really very large databases) all of this can
help a lot.

Tanel.
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Tuesday, August 26, 2003 5:54 PM


 > Taniel, Binley
 >Thanks for the excellent suggestions.
 >At this point we have been testing with two smaller test systems,
moving
 > a single table at a time, but initial indications are that the
performance
 > order is:
 > 1. Perl dump to CSV / ftp / SQL*Loader
 > 2. Copy across database link
 > 3. Export/ ftp / import
 >
 > I need to re-run the tests once the target production system is available
to
 > re-confirm which is faster. I am pretty confident in the ability to run
 > multiple SQL*Loader and import sessions simultaneously. I am a little
 > nervous about the ability of the database link to scale to enough
 > simultaneous sessions to keep the RAID sets maxed out on the target
system.
 > Several years ago when I was doing a large conversion I hit that limit.
Some
 > days I wonder if we are the beneficiary or victim of our prior
experience.
 > Oh well thanks for all the good suggestions, on to testing, testing,
 > testing.
 >
 > Dennis Williams
 > DBA, 80%OCP, 100% DBA
 > Lifetouch, Inc.
 > [EMAIL PROTECTED]
 >
 >
 > -Original Message-
 > Sent: Monday, August 25, 2003 7:09 PM
 > To: Multiple recipients of list ORACLE-L
 >
 >
 > Hi!
 >
 > What about several insert /*+ APPEND NOLOGGING */ commands over database
 > link run in parallel? (Possibly over dedicated network). This is fast and
is
 > easier (in case you don't hit any compatibility problems). If you happen
to
 > be running on Windows for some reason, you could try to use named pipes
 > network protocol instead of TCP as well.
 >
 > Tanel.
 >
 > - Original Message -
 > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
 > Sent: Monday, August 25, 2003 11:04 PM
 >
 >
 > > Thanks Tanel
 > >   We will undoubtedly use export/import for the many small tables. We
are
 > > looking for alternatives that will perform even faster. The insert
phase
 > > seems to be the slowest part, and that is where SQL*Loader in direct
path
 > > really shines. Now the next issue is how to produce a CSV file as fast
as
 > > possible, and so far it looks like Jared's Perl program is the clear
 > winner.
 > >
 > > Dennis Williams
 > > DBA, 80%OCP, 100% DBA
 > > Lifetouch, Inc.
 > > [EMAIL PROTECTED]
 > >
 > >
 > > -Original Message-
 > > Sent: Monday, August 25, 2003 1:05 PM
 > > To: Multiple recipients

RE: Performance Problem

Title: RE: Performance Problem





Funny ...


I have tkprof give up analyzing a 4.2G tracefile on a 64bit platform. anyone else experienced this??


Raj

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



-Original Message-
From: Cary Millsap [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, August 26, 2003 4:24 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: Performance Problem



Laura,


You might find the problem by checking the things you plan to check, and
by following the advice of the book you're using. But the odds are very
good that you will not. At least not for a long time...


Any application program on your system can tell you where it is spending
its time. Let it tell you. Take a 10046 level-12 trace of *any*
important, slow application program. Read
http://www.hotsos.com/dnloads/1/timing-data/Oracle%20Operational%20Timin
g%20Data.pdf, or ask the list for details if you need some help.



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


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



-Original Message-
Burton, Laura
Sent: Tuesday, August 26, 2003 2:30 PM
To: Multiple recipients of list ORACLE-L


No, I had read not to analyze the sys tables in the 'TIP' section of the
book I am using as a reference (Oracle Performance Tuning/Tips &
Techniques).  As I stated earlier, I also made sure that I analyzed all
the tables and indexes that were involved, because I had read that
leaving a table 'un'analyzed would cause a performance hit.


Someone earlier had suggested doing the analyze during an 'off' time.
This I did not do.  It was done while everything was going on, so maybe
that is why everything came to a standstill.  Anyway I want to try it
again after I upgrade and do so when others are not on.


If you know of any other gotcha's, please let me know.  I may not have
picked up on it in my research.


Someone else had responded about looking at systemic things before
attacking the code.  I had already done this and found that I needed to
enlarge my sort area because the disk read ratio was a little high.  I
also enlarged my shared pool size.  The stats I have been running since
then to keep track of this are staying between 98 and 99% so I do not
think this is my problem now.  Those changes did not make any difference
to the users.  Even though the disk/memory read was not above 95%, it
was at 92% so that is probably why no performance gain was noticed.  We
are using PL/SQL procedures heavily.  The stats on the Library Cache
looked good though.  


I read something this weekend about how using 'logical' drives to
separate the different files can cause a performance hit.  I am using
logical disks,  and I plan to change when I can, but I'm not sure yet
how much that will help.  I have redistributed some of the rollback
segments so that they are not all located on the same disk.  However
since some of the drives are logical, that may not have done any good.
I've rebuilt indexes, changed extent sizes to reduce the amount of
extents, added rollback segments, etc.  In lieu of this, code is next...


Thanks,
Laura


-Original Message-
Sent: Tuesday, August 26, 2003 1:29 PM
To: Multiple recipients of list ORACLE-L


Did you analyze the sys  schema by mistake.  This can stop the fastest
database.  We had a contractor do that to an 8.0.5 database once, and
only
once.


Ruth



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


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



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


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



*

Re: Re: OT - Linux books ??

AFAIK, Apples unix is based on [Open|Free]BSD as well.

Tanel.

- Original Message - 
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Tuesday, August 26, 2003 8:24 PM


>
> And of course, there's the other free UNIXes - the BSDs (OpenBSD, FreeBSD,
> NetBSD).  Tragically, none of these run Oracle (FreeBSD can run Oracle in
> Linux emulation mode - which seems backwards at best).  And there's OS X,
> which is Apple's UNIX, and also runs Oracle.
>
> As far as AIX, I couldn't find an article to verify this, but I had
thought
> IBM had announced that AIX would eventually be phased out in favor of
Linux.
> This is not a short-term plan, obviously the existing install base of AIX
> precludes that.  But, eventually...  And if I imagined that announcement,
> I'd still wager money that its going to happen. :)
>
> Thanks,
> Matt
>
>
> --
> Matthew Zito
> GridApp Systems
> Email: [EMAIL PROTECTED]
> Cell: 646-220-3551
> Phone: 212-358-8211 x 359
> http://www.gridapp.com
>
> > -Original Message-
> > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
> > Behalf Of Mladen Gogala
> > Sent: Tuesday, August 26, 2003 12:24 PM
> > To: Multiple recipients of list ORACLE-L
> > Subject: RE: Re: OT - Linux books ??
> >
> >
> > Well, IBM has AIX, a very solid and stable version of unix
> > which works really
> > well. SCO has become very popular lately and using SCO Unix
> > will turn you into the most popular guy on this list. Then
> > there is Irix, made by SGI. HP actually has several unix
> > versions Tru64, HP-UX, Tandem Unix, Ultrix, Apollo Unix and some
> > more exotic operating systems like OpenVMS, MPE, Guardian and
> > alike. If you go with HP, I do advise you to stick with HP-UX.
> >
> > --
> > Mladen Gogala
> > Oracle DBA
> >
> >
> >
> > -Original Message-
> > [EMAIL PROTECTED]
> > Sent: Tuesday, August 26, 2003 10:19 AM
> > To: Multiple recipients of list ORACLE-L
> >
> >
> > so different flavors of linux are more compatible?
> >
> > i thought the only two unix players out there now are HP and
> > Solaris. who else is out there?
> >
> >
> >
> >
> >
> > Note:
> > This message is for the named person's use only.  It may
> > contain confidential, proprietary or legally privileged
> > information.  No confidentiality or privilege is waived or
> > lost by any mistransmission.  If you receive this message in
> > error, please immediately delete it and all copies of it from
> > your system, destroy any hard copies of it and notify the
> > sender.  You must not, directly or indirectly, use, disclose,
> > distribute, print, or copy any part of this message if you
> > are not the intended recipient. Wang Trading LLC and any of
> > its subsidiaries each reserve the right to monitor all e-mail
> > communications through its networks. Any views expressed in
> > this message are those of the individual sender, except where
> > the message states otherwise and the sender is authorized to
> > state them to be the views of any such entity.
> >
> > -- 
> > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > -- 
> > Author: Mladen Gogala
> >   INET: [EMAIL PROTECTED]
> >
> > Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> > San Diego, California-- Mailing list and web hosting services
> > -
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru')
> > and in the message BODY, include a line containing: UNSUB
> > ORACLE-L (or the name of mailing list you want to be removed
> > from).  You may also send the HELP command for other
> > information (like subscribing).
> >
> >
>
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: Matthew Zito
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
>
>


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

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

Re: Hey Jared!!

I doubt they will ever find the real guy behind this. 

Tanel.

- Original Message - 
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Tuesday, August 26, 2003 10:19 PM


> For all you virus/worm lovers out there, justice do come:
> 
> FBI Subpoenas Arizona ISP In Sobig Probe
> Easynews says it's cooperating with the bureau to find the person 
> who uploaded the virus to a Usenet group it hosts.
> informationweek.com/story/showArticle.jhtml?articleID=13800091
> 
> 
> 
> Dick Goulet
> Senior Oracle DBA
> Oracle Certified 8i DBA
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: Goulet, Dick
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> 

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

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

Re: new server + RAID = ???

Title: Message



The current situation is that some rebels still 
suggest storing your database on non-protected storage and come ask for help 
here when their entire database (including last 3 months archivelogs) crashes 
with this single disk..
 
Tanel.
 

  - Original Message - 
  From: 
  Ruth Gramolini 
  To: Multiple recipients of list ORACLE-L 
  
  Sent: Tuesday, August 26, 2003 6:14 
  PM
  Subject: RE: new server + RAID = 
???
  
  What 
  was the final outcome?  
   
  Thanks,
  Ruth
  
-Original Message-From: [EMAIL PROTECTED] 
[mailto:[EMAIL PROTECTED]On Behalf Of Tanel 
PoderSent: Monday, August 25, 2003 9:19 PMTo: Multiple 
recipients of list ORACLE-LSubject: Re: new server + RAID = 
???
I thought the BANRD was over, after 
successfully completed the battle against non-redundant 
disks?
 
Tanel.

  - Original Message - 
  From: 
  Binley 
  Lim 
  To: Multiple recipients of list 
  ORACLE-L 
  Sent: Tuesday, August 26, 2003 2:59 
  AM
  Subject: Re: new server + RAID = 
  ???
  
  Since the DB is 40GB, one 70GB drive will do. 
  All the OS, Oracle binaries as well as the DB should fit in nicely. And no 
  BAARF problems either ;-)
  
- Original Message - 
From: 
Matthew 
Zito 
To: Multiple recipients of list 
ORACLE-L 
Sent: Tuesday, August 26, 2003 
10:29 AM
Subject: RE: new server + RAID = 
???

 
What type of storage?  How much? 
 
Matt
--Matthew ZitoGridApp SystemsEmail: [EMAIL PROTECTED]Cell: 
646-220-3551Phone: 212-358-8211 x 359http://www.gridapp.com 

  
  -Original Message-From: [EMAIL PROTECTED] 
  [mailto:[EMAIL PROTECTED] On Behalf Of Fedock, John 
  (KAM.RHQ)Sent: Monday, August 25, 2003 5:25 
  PMTo: Multiple recipients of list 
  ORACLE-LSubject: new server + RAID = 
  ???
  I know 
  this topic is brought up often (BAARF, I believe) . but I just 
  found out we have a new server arriving, and I have the luxury of 
  setting up the database from scratch.  I never had the chance to 
  offer input into the disk layouts, so can anyone point out some white 
  papers or offer any other advice?
   
  This will 
  be an HP-UX 11i o/s, database will need to be 8.1.7.4 due to some 
  application limitations.  I would classify it as more batch than 
  OLTP and will start out around 40GB.
   
  TIA.
   
  John
   
   
  John Fedock "K" Line America, 
  Inc. www.kline.com  * 
  [EMAIL PROTECTED]

Re: Re: OT - Linux books ??

Liunx was initially meant to be a posix standard and minix compatible OS
running on 386 for hackers and computer enthusiasts. Even Linus himself
didn't predict it's growth and current status at first. At first it wasn't
even completely independent, it used minix formatted filesystems etc..
But eventually it become clear that in order to evolve, the compatibility
with minix had to be dropped. That was a good decision indeed.

Tanel.


- Original Message - 
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Tuesday, August 26, 2003 8:39 PM


> i thought linux was just unix designed to run on a PC. how different is
the kernel?
> >
> > From: "Matthew Zito" <[EMAIL PROTECTED]>
> > Date: 2003/08/26 Tue PM 01:24:26 EDT
> > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> > Subject: RE: Re: OT - Linux books ??
> >
> >
> > And of course, there's the other free UNIXes - the BSDs (OpenBSD,
FreeBSD,
> > NetBSD).  Tragically, none of these run Oracle (FreeBSD can run Oracle
in
> > Linux emulation mode - which seems backwards at best).  And there's OS
X,
> > which is Apple's UNIX, and also runs Oracle.
> >
> > As far as AIX, I couldn't find an article to verify this, but I had
thought
> > IBM had announced that AIX would eventually be phased out in favor of
Linux.
> > This is not a short-term plan, obviously the existing install base of
AIX
> > precludes that.  But, eventually...  And if I imagined that
announcement,
> > I'd still wager money that its going to happen. :)
> >
> > Thanks,
> > Matt
> >
> >
> > --
> > Matthew Zito
> > GridApp Systems
> > Email: [EMAIL PROTECTED]
> > Cell: 646-220-3551
> > Phone: 212-358-8211 x 359
> > http://www.gridapp.com
> >
> > > -Original Message-
> > > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
> > > Behalf Of Mladen Gogala
> > > Sent: Tuesday, August 26, 2003 12:24 PM
> > > To: Multiple recipients of list ORACLE-L
> > > Subject: RE: Re: OT - Linux books ??
> > >
> > >
> > > Well, IBM has AIX, a very solid and stable version of unix
> > > which works really
> > > well. SCO has become very popular lately and using SCO Unix
> > > will turn you into the most popular guy on this list. Then
> > > there is Irix, made by SGI. HP actually has several unix
> > > versions Tru64, HP-UX, Tandem Unix, Ultrix, Apollo Unix and some
> > > more exotic operating systems like OpenVMS, MPE, Guardian and
> > > alike. If you go with HP, I do advise you to stick with HP-UX.
> > >
> > > --
> > > Mladen Gogala
> > > Oracle DBA
> > >
> > >
> > >
> > > -Original Message-
> > > [EMAIL PROTECTED]
> > > Sent: Tuesday, August 26, 2003 10:19 AM
> > > To: Multiple recipients of list ORACLE-L
> > >
> > >
> > > so different flavors of linux are more compatible?
> > >
> > > i thought the only two unix players out there now are HP and
> > > Solaris. who else is out there?
> > >
> > >
> > >
> > >
> > >
> > > Note:
> > > This message is for the named person's use only.  It may
> > > contain confidential, proprietary or legally privileged
> > > information.  No confidentiality or privilege is waived or
> > > lost by any mistransmission.  If you receive this message in
> > > error, please immediately delete it and all copies of it from
> > > your system, destroy any hard copies of it and notify the
> > > sender.  You must not, directly or indirectly, use, disclose,
> > > distribute, print, or copy any part of this message if you
> > > are not the intended recipient. Wang Trading LLC and any of
> > > its subsidiaries each reserve the right to monitor all e-mail
> > > communications through its networks. Any views expressed in
> > > this message are those of the individual sender, except where
> > > the message states otherwise and the sender is authorized to
> > > state them to be the views of any such entity.
> > >
> > > -- 
> > > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > > -- 
> > > Author: Mladen Gogala
> > >   INET: [EMAIL PROTECTED]
> > >
> > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> > > San Diego, California-- Mailing list and web hosting services
> > > -
> > > To REMOVE yourself from this mailing list, send an E-Mail message
> > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru')
> > > and in the message BODY, include a line containing: UNSUB
> > > ORACLE-L (or the name of mailing list you want to be removed
> > > from).  You may also send the HELP command for other
> > > information (like subscribing).
> > >
> > >
> >
> > -- 
> > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > -- 
> > Author: Matthew Zito
> >   INET: [EMAIL PROTECTED]
> >
> > Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> > San Diego, California-- Mailing list and web hosting services
> > -
> > To REMOVE yourself from this mailing list, sen

RE: Performance Problem

2003-08-26 Thread Cary Millsap

Laura,

You might find the problem by checking the things you plan to check, and
by following the advice of the book you're using. But the odds are very
good that you will not. At least not for a long time...

Any application program on your system can tell you where it is spending
its time. Let it tell you. Take a 10046 level-12 trace of *any*
important, slow application program. Read
http://www.hotsos.com/dnloads/1/timing-data/Oracle%20Operational%20Timin
g%20Data.pdf, or ask the list for details if you need some help.


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

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


-Original Message-
Burton, Laura
Sent: Tuesday, August 26, 2003 2:30 PM
To: Multiple recipients of list ORACLE-L

No, I had read not to analyze the sys tables in the 'TIP' section of the
book I am using as a reference (Oracle Performance Tuning/Tips &
Techniques).  As I stated earlier, I also made sure that I analyzed all
the tables and indexes that were involved, because I had read that
leaving a table 'un'analyzed would cause a performance hit.

Someone earlier had suggested doing the analyze during an 'off' time.
This I did not do.  It was done while everything was going on, so maybe
that is why everything came to a standstill.  Anyway I want to try it
again after I upgrade and do so when others are not on.

If you know of any other gotcha's, please let me know.  I may not have
picked up on it in my research.

Someone else had responded about looking at systemic things before
attacking the code.  I had already done this and found that I needed to
enlarge my sort area because the disk read ratio was a little high.  I
also enlarged my shared pool size.  The stats I have been running since
then to keep track of this are staying between 98 and 99% so I do not
think this is my problem now.  Those changes did not make any difference
to the users.  Even though the disk/memory read was not above 95%, it
was at 92% so that is probably why no performance gain was noticed.  We
are using PL/SQL procedures heavily.  The stats on the Library Cache
looked good though.  

I read something this weekend about how using 'logical' drives to
separate the different files can cause a performance hit.  I am using
logical disks,  and I plan to change when I can, but I'm not sure yet
how much that will help.  I have redistributed some of the rollback
segments so that they are not all located on the same disk.  However
since some of the drives are logical, that may not have done any good.
I've rebuilt indexes, changed extent sizes to reduce the amount of
extents, added rollback segments, etc.  In lieu of this, code is next...

Thanks,
Laura

-Original Message-
Sent: Tuesday, August 26, 2003 1:29 PM
To: Multiple recipients of list ORACLE-L

Did you analyze the sys  schema by mistake.  This can stop the fastest
database.  We had a contractor do that to an 8.0.5 database once, and
only
once.

Ruth


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

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


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

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

RE: NEXT_EXTENT and PCT_INCREASE

2003-08-26 Thread Gorbounov,Vadim

Roger, 

1. Space management can be specified for a tablespace, not a segment. Create
ASSM tablespace and alter table ... move there.

2. Locally managed tablespace, I guess. Oracle doesn't need NEXT_EXTENT and
PCT_INCREASE then.

HTH
Vadim

-Original Message-
Sent: Tuesday, August 26, 2003 3:59 PM
To: Multiple recipients of list ORACLE-L


Hi,

I have the following output when I querying dba_tables.

Question 1: This table is created using manual management method, right?
What do I do in order to turn it to Automatic segment-space
management?

Question 2: How come there are no values for NEXT_EXTENT and PCT_INCREASE?

Thanks,

Roger Xu


  PCT_FREE   PCT_USED  INI_TRANS  MAX_TRANS
-- -- -- --
10 40  1255

INITIAL_EXTENT NEXT_EXTENT MIN_EXTENTS MAX_EXTENTS PCT_INCREASE
-- --- --- --- 
 527491072   1  2147483645

 FREELISTS FREELIST_GROUPS
-- ---
 1   1

LOGGING BACKED_UP   NUM_ROWS
--- - --
YES N  216122635

BLOCKS EMPTY_BLOCKS  AVG_SPACE  CHAIN_CNT
--  -- --
   7651115 4307319  0


AVG_ROW_LEN AVG_SPACE_FREELIST_BLOCKS NUM_FREELIST_BLOCKS
--- - ---
254  4496   2

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

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

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

2003-08-26 Thread Stephane Paquette




I was 
not getting result from set_ev because I used set_ev(sid,serial,10046,8,null) 
instead of set_ev(sid,serial,10046,8,'')
 
I 
thought that null and '' can be used without 
difference.
 
 
 


Stephane Paquette
Administrateur 
de bases de donnees
Database 
Administrator
Standard 
Life
www.standardlife.ca
Tel. 
(514) 499-7999 7470 and (514) 925-7187
[EMAIL PROTECTED]
 
 
-Original Message-From: [EMAIL PROTECTED] 
[mailto:[EMAIL PROTECTED]On Behalf Of Cary MillsapSent: 
Monday, August 25, 2003 6:00 PMTo: Multiple recipients of list 
ORACLE-LSubject: RE: About trcanlzr

  
  FWIW, set_ev has 
  produced over 2,000 trace files on Oracle8i that I’ve seen… Using DBMS_SUPPORT 
  is probably a better idea anyway, though. Note, however, that the procedures 
  in DBMS_SUPPORT just make calls to SET_EV.
   
  
  Cary 
  MillsapHotsos 
  Enterprises, Ltd.http://www.hotsos.comUpcoming 
  events:- Hotsos 
  Clinic 101 in Sydney- Hotsos Symposium 2004 
  March 7–10 Dallas- Visit www.hotsos.com for schedule 
  details...
  -Original 
  Message-From: 
  [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Stephane 
  PaquetteSent: Monday, August 
  25, 2003 1:25 PMTo: Multiple 
  recipients of list ORACLE-LSubject: About trcanlzr
   
  
  Hi,
  
   
  
  
  I just start testing the 
  trcanlzr scripts (metalink 224270.1)
  
  I did not remember seeing any 
  traffic on that utility on oracle-l , that's why I went on orafaq where 
  there is only a post by Jamadagni Rajendra .
  
   
  
  I just open a tar to get the 
  dbms_support script to enable 10046 tracing in other session as 
  dbms_system.set_ev is not working here (8172 aix) but Oracle says it is only 
  legitimate to use it on 9i.
  
   
  
  So, any feedback on trcanlzr 
  scripts and is it normal that dbms_system.set_ev is not working on 
  8172 ?
  
  Any workaround 
  ?
  
   
  
  I've 9i relaease 2 on my pc, 
  I guess I can copy the dbmssup.sql and prvtsupp.plb over the 8172/aix 
  databases, yes/no ?
  
   
  
   
  
   
  
  
  
  
  Stephane 
  Paquette
  Administrateur 
  de bases de donnees
  Database 
  Administrator
  Standard 
  Life
  www.standardlife.ca
  Tel. 
  (514) 499-7999 7470 and (514) 925-7187
  [EMAIL PROTECTED]

NEXT_EXTENT and PCT_INCREASE

2003-08-26 Thread Roger Xu

Hi,

I have the following output when I querying dba_tables.

Question 1: This table is created using manual management method, right?
What do I do in order to turn it to Automatic segment-space management?

Question 2: How come there are no values for NEXT_EXTENT and PCT_INCREASE?

Thanks,

Roger Xu


  PCT_FREE   PCT_USED  INI_TRANS  MAX_TRANS
-- -- -- --
10 40  1255

INITIAL_EXTENT NEXT_EXTENT MIN_EXTENTS MAX_EXTENTS PCT_INCREASE
-- --- --- --- 
 527491072   1  2147483645

 FREELISTS FREELIST_GROUPS
-- ---
 1   1

LOGGING BACKED_UP   NUM_ROWS
--- - --
YES N  216122635

BLOCKS EMPTY_BLOCKS  AVG_SPACE  CHAIN_CNT
--  -- --
   7651115 4307319  0


AVG_ROW_LEN AVG_SPACE_FREELIST_BLOCKS NUM_FREELIST_BLOCKS
--- - ---
254  4496   2

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

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

2003-08-26 Thread M Rafiq

Tanel,

A quick question? How many open dblinks you have used at one time without 
any issues? Default setting in init.ora is 4(if I am not wrong) and I never 
used it more than that. If Dennis wants to use more than 4 dblinks at one 
time, he should modify this param(open_dblinks) in init.ora, right.

Regards
Rafiq






Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Date: Tue, 26 Aug 2003 09:14:26 -0800
Hi!

What is your goal? To finish data transfer in the shortest time or keep
hardware utilization maximum during transfer?
I think you should concentrate on keeping the time for doing data transfer
low.
Depending on your network - in case of gigabit (or 10 Gb) you could look at
enabling jumbo frames, which enable ethernet packets up to 9000 bytes. Also
set (SDU=32768) in your listener and tnsnames.oras (you can set it with
normal 1500 byte frames as well).
About parallellism, you might want to run several bulk inserts over dblink
to fully utilize your network (fill the "gaps" when one session is busy
inserting, thus not using the network). But if your source disk array (or
CPUs) are slow then they might be the bottleneck.
If you got SAN and a temporary spare server, do a BCV copy or mirror split,
open up several clones of a database and copy data from all of them.
Also, when you have SAN, there's no need for network transfer at all - you
just mount the filesystem with dump/exportfiles on target database and do
the load from there. If your operating systems are different, then just dump
to raw device, with pipe and tar for example, or completely raw, remembering
your data sizes. Note that in some (older) operating systems there were few
blocks in beginning of device which were used (and written) by operating
system (Tru64 had the largest I know - 64k). Thus you had to make sure you
didn't write anything there (oseek=65536 for dd for example).
If downtime isn't an issue for you, it might not be worth trying above
recommendations, but in RVLDBs (really very large databases) all of this can
help a lot.
Tanel.
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Tuesday, August 26, 2003 5:54 PM
> Taniel, Binley
>Thanks for the excellent suggestions.
>At this point we have been testing with two smaller test systems,
moving
> a single table at a time, but initial indications are that the 
performance
> order is:
> 1. Perl dump to CSV / ftp / SQL*Loader
> 2. Copy across database link
> 3. Export/ ftp / import
>
> I need to re-run the tests once the target production system is available
to
> re-confirm which is faster. I am pretty confident in the ability to run
> multiple SQL*Loader and import sessions simultaneously. I am a little
> nervous about the ability of the database link to scale to enough
> simultaneous sessions to keep the RAID sets maxed out on the target
system.
> Several years ago when I was doing a large conversion I hit that limit.
Some
> days I wonder if we are the beneficiary or victim of our prior 
experience.
> Oh well thanks for all the good suggestions, on to testing, testing,
> testing.
>
> Dennis Williams
> DBA, 80%OCP, 100% DBA
> Lifetouch, Inc.
> [EMAIL PROTECTED]
>
>
> -Original Message-
> Sent: Monday, August 25, 2003 7:09 PM
> To: Multiple recipients of list ORACLE-L
>
>
> Hi!
>
> What about several insert /*+ APPEND NOLOGGING */ commands over database
> link run in parallel? (Possibly over dedicated network). This is fast and
is
> easier (in case you don't hit any compatibility problems). If you happen
to
> be running on Windows for some reason, you could try to use named pipes
> network protocol instead of TCP as well.
>
> Tanel.
>
> - Original Message -
> To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
> Sent: Monday, August 25, 2003 11:04 PM
>
>
> > Thanks Tanel
> >   We will undoubtedly use export/import for the many small tables. We
are
> > looking for alternatives that will perform even faster. The insert 
phase
> > seems to be the slowest part, and that is where SQL*Loader in direct
path
> > really shines. Now the next issue is how to produce a CSV file as fast
as
> > possible, and so far it looks like Jared's Perl program is the clear
> winner.
> >
> > Dennis Williams
> > DBA, 80%OCP, 100% DBA
> > Lifetouch, Inc.
> > [EMAIL PROTECTED]
> >
> >
> > -Original Message-
> > Sent: Monday, August 25, 2003 1:05 PM
> > To: Multiple recipients of list ORACLE-L
> >
> >
> > Hi!
> >
> > Spooling from sqlplus is VERY slow.
> > Is the source database Oracle? Then use export/import
> > If not, is there an ODBC driver for source database? Then use Oracle
> > heterogenous services and do your transfer directly, without any
> > intermediate files.
> > Or use some very expensive software for doing this simple job...
> >
> > Tanel.
> > P.S. if you definitely want to spool to textfile fast, Sparky could be
> what
> > you want...
> >
> > - Original Message -

RE: Query results to .csv

2003-08-26 Thread DENNIS WILLIAMS

Tanel
   Thanks for the ideas. My simple mind says that by fully utilizing the
hardware I can minimize the overall time. But today we were on a conference
call with the application vendor and they were touting their utility for
handling this. Everyone around the table seemed pretty impressed, so maybe I
shouldn't be worrying about all these silly Oracle methods. Anyway I said
that I would test their utility, but since we don't have the server ready,
that is all a little way off. 

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


-Original Message-
Sent: Tuesday, August 26, 2003 12:14 PM
To: Multiple recipients of list ORACLE-L


Hi!

What is your goal? To finish data transfer in the shortest time or keep
hardware utilization maximum during transfer?
I think you should concentrate on keeping the time for doing data transfer
low.

Depending on your network - in case of gigabit (or 10 Gb) you could look at
enabling jumbo frames, which enable ethernet packets up to 9000 bytes. Also
set (SDU=32768) in your listener and tnsnames.oras (you can set it with
normal 1500 byte frames as well).

About parallellism, you might want to run several bulk inserts over dblink
to fully utilize your network (fill the "gaps" when one session is busy
inserting, thus not using the network). But if your source disk array (or
CPUs) are slow then they might be the bottleneck.
If you got SAN and a temporary spare server, do a BCV copy or mirror split,
open up several clones of a database and copy data from all of them.

Also, when you have SAN, there's no need for network transfer at all - you
just mount the filesystem with dump/exportfiles on target database and do
the load from there. If your operating systems are different, then just dump
to raw device, with pipe and tar for example, or completely raw, remembering
your data sizes. Note that in some (older) operating systems there were few
blocks in beginning of device which were used (and written) by operating
system (Tru64 had the largest I know - 64k). Thus you had to make sure you
didn't write anything there (oseek=65536 for dd for example).

If downtime isn't an issue for you, it might not be worth trying above
recommendations, but in RVLDBs (really very large databases) all of this can
help a lot.

Tanel.
- Original Message - 
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Tuesday, August 26, 2003 5:54 PM


> Taniel, Binley
>Thanks for the excellent suggestions.
>At this point we have been testing with two smaller test systems,
moving
> a single table at a time, but initial indications are that the performance
> order is:
> 1. Perl dump to CSV / ftp / SQL*Loader
> 2. Copy across database link
> 3. Export/ ftp / import
>
> I need to re-run the tests once the target production system is available
to
> re-confirm which is faster. I am pretty confident in the ability to run
> multiple SQL*Loader and import sessions simultaneously. I am a little
> nervous about the ability of the database link to scale to enough
> simultaneous sessions to keep the RAID sets maxed out on the target
system.
> Several years ago when I was doing a large conversion I hit that limit.
Some
> days I wonder if we are the beneficiary or victim of our prior experience.
> Oh well thanks for all the good suggestions, on to testing, testing,
> testing.
>
> Dennis Williams
> DBA, 80%OCP, 100% DBA
> Lifetouch, Inc.
> [EMAIL PROTECTED]
>
>
> -Original Message-
> Sent: Monday, August 25, 2003 7:09 PM
> To: Multiple recipients of list ORACLE-L
>
>
> Hi!
>
> What about several insert /*+ APPEND NOLOGGING */ commands over database
> link run in parallel? (Possibly over dedicated network). This is fast and
is
> easier (in case you don't hit any compatibility problems). If you happen
to
> be running on Windows for some reason, you could try to use named pipes
> network protocol instead of TCP as well.
>
> Tanel.
>
> - Original Message - 
> To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
> Sent: Monday, August 25, 2003 11:04 PM
>
>
> > Thanks Tanel
> >   We will undoubtedly use export/import for the many small tables. We
are
> > looking for alternatives that will perform even faster. The insert phase
> > seems to be the slowest part, and that is where SQL*Loader in direct
path
> > really shines. Now the next issue is how to produce a CSV file as fast
as
> > possible, and so far it looks like Jared's Perl program is the clear
> winner.
> >
> > Dennis Williams
> > DBA, 80%OCP, 100% DBA
> > Lifetouch, Inc.
> > [EMAIL PROTECTED]
> >
> >
> > -Original Message-
> > Sent: Monday, August 25, 2003 1:05 PM
> > To: Multiple recipients of list ORACLE-L
> >
> >
> > Hi!
> >
> > Spooling from sqlplus is VERY slow.
> > Is the source database Oracle? Then use export/import
> > If not, is there an ODBC driver for source database? Then use Oracle
> > heterogenous services and do your transfer directly, without any
> > intermediate

RE: Onames and various connections scenarios

2003-08-26 Thread John Kanagaraj

Bob,

I understand what you are saying (and your pain). My suggestion would be to
use the 'namesctl dump_tnsnames' command to dump out the current Onames
repository to the PC's $TNS_ADMIN dir via a login script or SMS. You might
want o rename the current TNSNAMES.ORA file just prior to that as
dump_tnsnames adds to the end of the current one and doesn't handle changes
very well.

Hth,
John Kanagaraj
DB Soft Inc
Phone: 408-970-7002 (W)

Grace - Getting something we do NOT deserve
Mercy - NOT getting something we DO deserve
Click on 'http://www.needhim.org' for Grace and Mercy that is freely
available!

** The opinions and facts contained in this message are entirely mine and do
not reflect those of my employer or customers **

-Original Message-
Sent: Tuesday, August 26, 2003 6:44 AM
To: Multiple recipients of list ORACLE-L


Hello All

Im back from the trenches to post a quick request for
help

Ive setup onames on 2 servers and standard applications, (our app and
sqlplus) connect just fine, a problem situation manifests itself when:

1 users need to connect (add a database) to dba studio. They get a error
to the effect "cant resolve host name"
And the other
2. Users connect to remote databases (via vpn) that are in our onames
but many  of these vpn connections once made do not allow access to
*our* network resources.

So basically almost all of oour users have one or more of these
secenarios which means they will need to maintain a tnsnames file as
well.

I'm managing about 70+ connect discriptors And I was hoping onames
could be a centralised answer

Is this common? Or is there a workaround?

Thanks!
bob
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Bob Metelsky
  INET: [EMAIL PROTECTED]

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

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

2003-08-26 Thread Burton, Laura

No, I had read not to analyze the sys tables in the 'TIP' section of the
book I am using as a reference (Oracle Performance Tuning/Tips &
Techniques).  As I stated earlier, I also made sure that I analyzed all
the tables and indexes that were involved, because I had read that
leaving a table 'un'analyzed would cause a performance hit.

Someone earlier had suggested doing the analyze during an 'off' time.
This I did not do.  It was done while everything was going on, so maybe
that is why everything came to a standstill.  Anyway I want to try it
again after I upgrade and do so when others are not on.

If you know of any other gotcha's, please let me know.  I may not have
picked up on it in my research.

Someone else had responded about looking at systemic things before
attacking the code.  I had already done this and found that I needed to
enlarge my sort area because the disk read ratio was a little high.  I
also enlarged my shared pool size.  The stats I have been running since
then to keep track of this are staying between 98 and 99% so I do not
think this is my problem now.  Those changes did not make any difference
to the users.  Even though the disk/memory read was not above 95%, it
was at 92% so that is probably why no performance gain was noticed.  We
are using PL/SQL procedures heavily.  The stats on the Library Cache
looked good though.  

I read something this weekend about how using 'logical' drives to
separate the different files can cause a performance hit.  I am using
logical disks,  and I plan to change when I can, but I'm not sure yet
how much that will help.  I have redistributed some of the rollback
segments so that they are not all located on the same disk.  However
since some of the drives are logical, that may not have done any good.
I've rebuilt indexes, changed extent sizes to reduce the amount of
extents, added rollback segments, etc.  In lieu of this, code is next...

Thanks,
Laura

-Original Message-
Sent: Tuesday, August 26, 2003 1:29 PM
To: Multiple recipients of list ORACLE-L

Did you analyze the sys  schema by mistake.  This can stop the fastest
database.  We had a contractor do that to an 8.0.5 database once, and
only
once.

Ruth


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

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

2003-08-26 Thread Michael Boligan





This would be alot of extra work and downtime compared to export/import but...

1)  upgrade to AIX 4.3.3  You might want to think about using AIX 64 bit here
(you can still run Oracle on 32 bit if you want).

2)  upgrade to 8.1.7.4

3)  AIX 4.3.3 is binary compatable with 5.1, so you _could do a cp.

4)  If you are using LPAR you may want to go to 5.2 because you can use dynamic
reconfig.

HTH,
Mike


   
 
  <[EMAIL PROTECTED]   
   
  idence.org> To:   Multiple recipients of 
list ORACLE-L <[EMAIL PROTECTED]> 
  Sent by:cc:  
 
  [EMAIL PROTECTED]Subject:  Migration Suggestion. 
  
  m
 
   
 
   
 
  08/26/2003 01:39 PM  
 
  Please respond to
 
  ORACLE-L 
 
   
 
   
 




I am looking for some expert suggestions for the migration of 300GB database to
different hardware. Currently database is 816 OPS on AIX 4.1 nodes. Database is
32bit and performance on this system is really slow. Export for 2GB table takes
2 hours. All the data is on EMC symmetric.
We are planning to migrate this database to AIX5.1 Oracle 8174 32Bit.
Oracle 816 on AIX5.1 is not supported.
'Cause OS is different we cannot use redirect restore and apply archive logs to
bring the database up.
Any suggestion regarding migration.

Thanks



DISCLAIMER:
This message is intended for the sole use of the individual to whom it is
addressed, and may contain information that is privileged, confidential and
exempt from disclosure under applicable law. If you are not the addressee you
are hereby notified that you may not use, copy, disclose, or distribute to
anyone the message or any information contained in the message. If you have
received this message in error, please immediately advise the sender by reply
email and delete this message.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: <[EMAIL PROTECTED]
  INET: [EMAIL PROTECTED]

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



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

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

Hey Jared!!

2003-08-26 Thread Goulet, Dick

For all you virus/worm lovers out there, justice do come:

FBI Subpoenas Arizona ISP In Sobig Probe
Easynews says it's cooperating with the bureau to find the person 
who uploaded the virus to a Usenet group it hosts.
informationweek.com/story/showArticle.jhtml?articleID=13800091



Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Goulet, Dick
  INET: [EMAIL PROTECTED]

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

RE: Re: OT - Linux books ??

linux from unix? 

> 
> From: "Mladen Gogala" <[EMAIL PROTECTED]>
> Date: 2003/08/26 Tue PM 02:34:28 EDT
> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> Subject: RE: Re: OT - Linux books ??
> 
> Different from what? It's very different from NT kernel.
> 
> --
> Mladen Gogala
> Oracle DBA 
> 
> 
> 
> -Original Message-
> [EMAIL PROTECTED]
> Sent: Tuesday, August 26, 2003 1:40 PM
> To: Multiple recipients of list ORACLE-L
> 
> 
> i thought linux was just unix designed to run on a PC. how different is the
> kernel? 
> > 
> > From: "Matthew Zito" <[EMAIL PROTECTED]>
> > Date: 2003/08/26 Tue PM 01:24:26 EDT
> > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> > Subject: RE: Re: OT - Linux books ??
> > 
> > 
> > And of course, there's the other free UNIXes - the BSDs (OpenBSD, 
> > FreeBSD, NetBSD).  Tragically, none of these run Oracle (FreeBSD can 
> > run Oracle in Linux emulation mode - which seems backwards at best).  
> > And there's OS X, which is Apple's UNIX, and also runs Oracle.
> > 
> > As far as AIX, I couldn't find an article to verify this, but I had 
> > thought IBM had announced that AIX would eventually be phased out in 
> > favor of Linux. This is not a short-term plan, obviously the existing 
> > install base of AIX precludes that.  But, eventually...  And if I 
> > imagined that announcement, I'd still wager money that its going to 
> > happen. :)
> > 
> > Thanks,
> > Matt
> > 
> > 
> > --
> > Matthew Zito
> > GridApp Systems
> > Email: [EMAIL PROTECTED]
> > Cell: 646-220-3551
> > Phone: 212-358-8211 x 359
> > http://www.gridapp.com
> > 
> > > -Original Message-
> > > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
> > > Behalf Of Mladen Gogala
> > > Sent: Tuesday, August 26, 2003 12:24 PM
> > > To: Multiple recipients of list ORACLE-L
> > > Subject: RE: Re: OT - Linux books ??
> > > 
> > > 
> > > Well, IBM has AIX, a very solid and stable version of unix
> > > which works really 
> > > well. SCO has become very popular lately and using SCO Unix 
> > > will turn you into the most popular guy on this list. Then 
> > > there is Irix, made by SGI. HP actually has several unix 
> > > versions Tru64, HP-UX, Tandem Unix, Ultrix, Apollo Unix and some 
> > > more exotic operating systems like OpenVMS, MPE, Guardian and 
> > > alike. If you go with HP, I do advise you to stick with HP-UX.
> > > 
> > > --
> > > Mladen Gogala
> > > Oracle DBA
> > > 
> > > 
> > > 
> > > -Original Message-
> > > [EMAIL PROTECTED]
> > > Sent: Tuesday, August 26, 2003 10:19 AM
> > > To: Multiple recipients of list ORACLE-L
> > > 
> > > 
> > > so different flavors of linux are more compatible?
> > > 
> > > i thought the only two unix players out there now are HP and
> > > Solaris. who else is out there? 
> > > 
> > > 
> > > 
> > > 
> > > 
> > > Note:
> > > This message is for the named person's use only.  It may
> > > contain confidential, proprietary or legally privileged 
> > > information.  No confidentiality or privilege is waived or 
> > > lost by any mistransmission.  If you receive this message in 
> > > error, please immediately delete it and all copies of it from 
> > > your system, destroy any hard copies of it and notify the 
> > > sender.  You must not, directly or indirectly, use, disclose, 
> > > distribute, print, or copy any part of this message if you 
> > > are not the intended recipient. Wang Trading LLC and any of 
> > > its subsidiaries each reserve the right to monitor all e-mail 
> > > communications through its networks. Any views expressed in 
> > > this message are those of the individual sender, except where 
> > > the message states otherwise and the sender is authorized to 
> > > state them to be the views of any such entity.
> > > 
> > > --
> > > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > > -- 
> > > Author: Mladen Gogala
> > >   INET: [EMAIL PROTECTED]
> > > 
> > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> > > San Diego, California-- Mailing list and web hosting services
> > > 
> > > -
> > > To REMOVE yourself from this mailing list, send an E-Mail message
> > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 
> > > and in the message BODY, include a line containing: UNSUB 
> > > ORACLE-L (or the name of mailing list you want to be removed 
> > > from).  You may also send the HELP command for other 
> > > information (like subscribing).
> > > 
> > > 
> > 
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > -- 
> > Author: Matthew Zito
> >   INET: [EMAIL PROTECTED]
> > 
> > Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> > San Diego, California-- Mailing list and web hosting services
> > -
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: [EMAIL PROTECTED]

RE: Re: OT - Linux books ??

Different from what? It's very different from NT kernel.

--
Mladen Gogala
Oracle DBA 



-Original Message-
[EMAIL PROTECTED]
Sent: Tuesday, August 26, 2003 1:40 PM
To: Multiple recipients of list ORACLE-L


i thought linux was just unix designed to run on a PC. how different is the
kernel? 
> 
> From: "Matthew Zito" <[EMAIL PROTECTED]>
> Date: 2003/08/26 Tue PM 01:24:26 EDT
> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> Subject: RE: Re: OT - Linux books ??
> 
> 
> And of course, there's the other free UNIXes - the BSDs (OpenBSD, 
> FreeBSD, NetBSD).  Tragically, none of these run Oracle (FreeBSD can 
> run Oracle in Linux emulation mode - which seems backwards at best).  
> And there's OS X, which is Apple's UNIX, and also runs Oracle.
> 
> As far as AIX, I couldn't find an article to verify this, but I had 
> thought IBM had announced that AIX would eventually be phased out in 
> favor of Linux. This is not a short-term plan, obviously the existing 
> install base of AIX precludes that.  But, eventually...  And if I 
> imagined that announcement, I'd still wager money that its going to 
> happen. :)
> 
> Thanks,
> Matt
> 
> 
> --
> Matthew Zito
> GridApp Systems
> Email: [EMAIL PROTECTED]
> Cell: 646-220-3551
> Phone: 212-358-8211 x 359
> http://www.gridapp.com
> 
> > -Original Message-
> > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
> > Behalf Of Mladen Gogala
> > Sent: Tuesday, August 26, 2003 12:24 PM
> > To: Multiple recipients of list ORACLE-L
> > Subject: RE: Re: OT - Linux books ??
> > 
> > 
> > Well, IBM has AIX, a very solid and stable version of unix
> > which works really 
> > well. SCO has become very popular lately and using SCO Unix 
> > will turn you into the most popular guy on this list. Then 
> > there is Irix, made by SGI. HP actually has several unix 
> > versions Tru64, HP-UX, Tandem Unix, Ultrix, Apollo Unix and some 
> > more exotic operating systems like OpenVMS, MPE, Guardian and 
> > alike. If you go with HP, I do advise you to stick with HP-UX.
> > 
> > --
> > Mladen Gogala
> > Oracle DBA
> > 
> > 
> > 
> > -Original Message-
> > [EMAIL PROTECTED]
> > Sent: Tuesday, August 26, 2003 10:19 AM
> > To: Multiple recipients of list ORACLE-L
> > 
> > 
> > so different flavors of linux are more compatible?
> > 
> > i thought the only two unix players out there now are HP and
> > Solaris. who else is out there? 
> > 
> > 
> > 
> > 
> > 
> > Note:
> > This message is for the named person's use only.  It may
> > contain confidential, proprietary or legally privileged 
> > information.  No confidentiality or privilege is waived or 
> > lost by any mistransmission.  If you receive this message in 
> > error, please immediately delete it and all copies of it from 
> > your system, destroy any hard copies of it and notify the 
> > sender.  You must not, directly or indirectly, use, disclose, 
> > distribute, print, or copy any part of this message if you 
> > are not the intended recipient. Wang Trading LLC and any of 
> > its subsidiaries each reserve the right to monitor all e-mail 
> > communications through its networks. Any views expressed in 
> > this message are those of the individual sender, except where 
> > the message states otherwise and the sender is authorized to 
> > state them to be the views of any such entity.
> > 
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > -- 
> > Author: Mladen Gogala
> >   INET: [EMAIL PROTECTED]
> > 
> > Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> > San Diego, California-- Mailing list and web hosting services
> > 
> > -
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 
> > and in the message BODY, include a line containing: UNSUB 
> > ORACLE-L (or the name of mailing list you want to be removed 
> > from).  You may also send the HELP command for other 
> > information (like subscribing).
> > 
> > 
> 
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: Matthew Zito
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in 
> the message BODY, include a line containing: UNSUB ORACLE-L (or the 
> name of mailing list you want to be removed from).  You may also send 
> the HELP command for other information (like subscribing).
> 
> 

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

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

RE: Migration Suggestion.

If you cannot recover the database, you *** CAN *** take a cold backup
and open it elsewhere, on a 5.2 box, for example. You only have to make sure

that you loaded the right post_wait extensions. I advise you to use the ones
from 9.2. Boot the machine in 32 bit mode. No migration is necessary, cold 
backup actually works in 32 bit mode. IBM went to great lengths to ensure
the
compatibility. I'll risk extreme unpopularity with IBM-bashers, but they did
an admirable job. I tried things with AIX 4.3 and the 8.1.7.1 database and
it
worked.

--
Mladen Gogala
Oracle DBA 



-Original Message-
[EMAIL PROTECTED]
Sent: Tuesday, August 26, 2003 1:39 PM
To: Multiple recipients of list ORACLE-L


I am looking for some expert suggestions for the migration of 300GB database
to different hardware. Currently database is 816 OPS on AIX 4.1 nodes.
Database is 32bit and performance on this system is really slow. Export for
2GB table takes 2 hours. All the data is on EMC symmetric. 
We are planning to migrate this database to AIX5.1 Oracle 8174 32Bit. Oracle
816 on AIX5.1 is not supported. 'Cause OS is different we cannot use
redirect restore and apply archive logs to bring the database up. Any
suggestion regarding migration.

Thanks



DISCLAIMER:
This message is intended for the sole use of the individual to whom it is
addressed, and may contain information that is privileged, confidential and
exempt from disclosure under applicable law. If you are not the addressee
you are hereby notified that you may not use, copy, disclose, or distribute
to anyone the message or any information contained in the message. If you
have received this message in error, please immediately advise the sender by
reply email and delete this message.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: <[EMAIL PROTECTED]
  INET: [EMAIL PROTECTED]

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



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

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

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

RE: Performance Problem

2003-08-26 Thread Ruth Gramolini

Did you analyze the sys  schema by mistake.  This can stop the fastest
database.  We had a contractor do that to an 8.0.5 database once, and only
once.

Ruth

> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of
> Burton, Laura
> Sent: Monday, August 25, 2003 4:49 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Performance Problem
>
>
> We currently have an application we are trying to speed up.  In
> researching rule/cost based optimizers, I read that the cost based
> optimizer was the way to go (although rule had its moments) because that
> is where Oracle would be focusing any upgrades, enhancements, etc.
>
> So I analyzed all tables and indexes.  It brought our application to a
> stand still!!  I then deleted the statistics and the application ran
> like before...slow.  I know that I must have missed something although
> it seemed so straight forward.  I verified that all tables were analyzed
> because I read that this would cause an extra step if all the tables
> were not analyzed.
>
> The database is Oracle 8.0.5.  This weekend I will be upgrading to
> 8.1.7.  The operating system is NT 4.0.  Does anyone know something that
> could point me in the right direction?  Thank you for your help.
>
> Laura
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Burton, Laura
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
>

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

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

RE: buffer overflow

Turn off the machine.

--
Mladen Gogala
Oracle DBA 



-Original Message-
Sent: Tuesday, August 26, 2003 1:34 PM
To: Multiple recipients of list ORACLE-L


Hi Gang ,
I have some upgrade script from vendor ( no source code ) which calling some
procs . Now I am getting "buffer overflow, limit of 100 bytes" error
from it . Looks like they are spitting out debug statmts out with
dbms_output . How can I stop this to happen without touching source code =



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

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

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

Re: RE: buffer overflow

2003-08-26 Thread AK

looks like internally from proc its setting dbms_output.enable();

-ak

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


> talk about unprofessional... this stuff should never go into production.
which vendor is it? ill aviod?
>
> cant you juse set serveroutput off? to turn off the output?
>
> >
> > From: Kevin Toepke <[EMAIL PROTECTED]>
> > Date: 2003/08/26 Tue PM 01:44:42 EDT
> > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> > Subject: RE: buffer overflow
> >
> > contact the vendor and ask them to remove the dbms_output calls?
> >
> > -Original Message-
> > Sent: Tuesday, August 26, 2003 1:34 PM
> > To: Multiple recipients of list ORACLE-L
> >
> >
> > Hi Gang ,
> > I have some upgrade script from vendor ( no source code ) which calling
some
> > procs . Now I am getting "buffer overflow, limit of 100 bytes" error
> > from it . Looks like they are spitting out debug statmts out with
> > dbms_output . How can I stop this to happen without touching source code
> > -- 
> > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > -- 
> > Author: Kevin Toepke
> >   INET: [EMAIL PROTECTED]
> >
> > Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> > San Diego, California-- Mailing list and web hosting services
> > -
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from).  You may
> > also send the HELP command for other information (like subscribing).
> >
>
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: <[EMAIL PROTECTED]
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
>
>
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: AK
  INET: [EMAIL PROTECTED]

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

2003-08-26 Thread Kevin Toepke

Forgot the smiley!

And, to make up for that, I ran a simple test and found that 'set
serveroutput off' solves the problem.

My code:
BEGIN
dbms_output.put_line('sysdate: ' || sysdate);
END;
/

with serveroutput on started dumping data to the screen in about 5 seconds.
With serveroutput off I had to kill the session.

Kevin

-Original Message-
Sent: Tuesday, August 26, 2003 2:04 PM
To: Multiple recipients of list ORACLE-L


talk about unprofessional... this stuff should never go into production.
which vendor is it? ill aviod?

cant you juse set serveroutput off? to turn off the output? 

> 
> From: Kevin Toepke <[EMAIL PROTECTED]>
> Date: 2003/08/26 Tue PM 01:44:42 EDT
> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> Subject: RE: buffer overflow
> 
> contact the vendor and ask them to remove the dbms_output calls?
> 
> -Original Message-
> Sent: Tuesday, August 26, 2003 1:34 PM
> To: Multiple recipients of list ORACLE-L
> 
> 
> Hi Gang ,
> I have some upgrade script from vendor ( no source code ) which calling
some
> procs . Now I am getting "buffer overflow, limit of 100 bytes" error
> from it . Looks like they are spitting out debug statmts out with
> dbms_output . How can I stop this to happen without touching source code 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: Kevin Toepke
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> 

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

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

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

RE: Re: OT - Linux books ??

2003-08-26 Thread Matthew Zito


The SCO Linux litigation that is raging right now is such a nightmare of FUD
and absurd legal process.  For starters, SCO's UNIX implementation is dead
in the water - not only was it the worst UNIX I've ever worked with, but
even SCO has no plans to aggresively continue development on it.  Only the
Linux stuff is even moving forward, and that's all about the legal issues
going on now.

The issue at question is SCO's ownership of the original AT&T UNIX copyright
and licensing.  SCO is claiming several things, the core bits being that its
"proprietary" code has made its way into Linux in violation of its licensing
agreement with IBM.  IBM, for their part, claims that the suit is invalid on
its face and is countersuing.  SCO yanked IBM's license to distribute UNIX,
which IBM claims is not even possible.  The lawyers are hard at work.

As best as anyone has been able to determine, all of the code SCO has
revealed as being in question was licensed freely to the community by
Caldera before Caldera's acquisition/merger with SCO.  Beyond that, some of
the disputed code dates back to System 4 UNIX and is available in USENET
archives - hardly very proprietary.

While IANAL, I would be shocked if SCO won any piece of this litigation.  It
appears as though SCO expected to get settlements out of IBM and other major
players, and instead is going to get destroyed in court by IBM.  Remember,
IBM fought the US Government in court and actually wore them down (the
example I keep hearing is the brief IBM filed that was 4 filing cabinets in
size and took two years for the government to read - possibly apocryphal).
SCO should lose, and good riddance to them.

*climbs off his soapbox*

Thanks,
Matt

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

> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On 
> Behalf Of Mladen Gogala
> Sent: Tuesday, August 26, 2003 1:44 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: Re: OT - Linux books ??
> 
> 
> AIX phased out in favor of Linux? I believe that SCO asked 
> for injunction to prevent IBM from distributing AIX, and 
> there is a whole saga around SCO and Linux. According to some, 
> Unix variants are like higlanders: there can be only one. If 
> you ask Mr. Darl McBride, 
> it's going to be SCO. Hopefully, MR. McBride will not lose his head.
> 
> --
> Mladen Gogala
> Oracle DBA 
> 
> 
> 
> -Original Message-
> Matthew Zito
> Sent: Tuesday, August 26, 2003 1:24 PM
> To: Multiple recipients of list ORACLE-L
> 
> 
> 
> And of course, there's the other free UNIXes - the BSDs 
> (OpenBSD, FreeBSD, NetBSD).  Tragically, none of these run 
> Oracle (FreeBSD can run Oracle in Linux emulation mode - 
> which seems backwards at best).  And there's OS X, which is 
> Apple's UNIX, and also runs Oracle.
> 
> As far as AIX, I couldn't find an article to verify this, but 
> I had thought IBM had announced that AIX would eventually be 
> phased out in favor of Linux. This is not a short-term plan, 
> obviously the existing install base of AIX precludes that.  
> But, eventually...  And if I imagined that announcement, I'd 
> still wager money that its going to happen. :)
> 
> Thanks,
> Matt
> 
> 
> --
> Matthew Zito
> GridApp Systems
> Email: [EMAIL PROTECTED]
> Cell: 646-220-3551
> Phone: 212-358-8211 x 359
> http://www.gridapp.com
> 
> > -Original Message-
> > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 
> On Behalf 
> > Of Mladen Gogala
> > Sent: Tuesday, August 26, 2003 12:24 PM
> > To: Multiple recipients of list ORACLE-L
> > Subject: RE: Re: OT - Linux books ??
> > 
> > 
> > Well, IBM has AIX, a very solid and stable version of unix 
> which works 
> > really well. SCO has become very popular lately and using SCO Unix
> > will turn you into the most popular guy on this list. Then 
> > there is Irix, made by SGI. HP actually has several unix 
> > versions Tru64, HP-UX, Tandem Unix, Ultrix, Apollo Unix and some 
> > more exotic operating systems like OpenVMS, MPE, Guardian and 
> > alike. If you go with HP, I do advise you to stick with HP-UX.
> > 
> > --
> > Mladen Gogala
> > Oracle DBA
> > 
> > 
> > 
> > -Original Message-
> > [EMAIL PROTECTED]
> > Sent: Tuesday, August 26, 2003 10:19 AM
> > To: Multiple recipients of list ORACLE-L
> > 
> > 
> > so different flavors of linux are more compatible?
> > 
> > i thought the only two unix players out there now are HP 
> and Solaris. 
> > who else is out there?
> > 
> > 
> > 
> > 
> > 
> > Note:
> > This message is for the named person's use only.  It may contain 
> > confidential, proprietary or legally privileged information.  No 
> > confidentiality or privilege is waived or lost by any 
> mistransmission.  
> > If you receive this message in error, please immediately 
> delete it and 
> > all copies of it from your system, destroy any hard copies 
> of it and 
> > notify the sender.  You must not, di

Re: buffer overflow

2003-08-26 Thread AK

I am sure you will pissed of , if I turn off your machine . ;)


- Original Message - 
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Tuesday, August 26, 2003 10:44 AM


> Turn off the machine.
>
> --
> Mladen Gogala
> Oracle DBA
>
>
>
> -Original Message-
> Sent: Tuesday, August 26, 2003 1:34 PM
> To: Multiple recipients of list ORACLE-L
>
>
> Hi Gang ,
> I have some upgrade script from vendor ( no source code ) which calling
some
> procs . Now I am getting "buffer overflow, limit of 100 bytes" error
> from it . Looks like they are spitting out debug statmts out with
> dbms_output . How can I stop this to happen without touching source code =
>
>
>
> Note:
> This message is for the named person's use only.  It may contain
confidential, proprietary or legally privileged information.  No
confidentiality or privilege is waived or lost by any mistransmission.  If
you receive this message in error, please immediately delete it and all
copies of it from your system, destroy any hard copies of it and notify the
sender.  You must not, directly or indirectly, use, disclose, distribute,
print, or copy any part of this message if you are not the intended
recipient. Wang Trading LLC and any of its subsidiaries each reserve the
right to monitor all e-mail communications through its networks.
> Any views expressed in this message are those of the individual sender,
except where the message states otherwise and the sender is authorized to
state them to be the views of any such entity.
>
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: Mladen Gogala
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
>
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: AK
  INET: [EMAIL PROTECTED]

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

talk about unprofessional... this stuff should never go into production. which vendor 
is it? ill aviod?

cant you juse set serveroutput off? to turn off the output? 

> 
> From: Kevin Toepke <[EMAIL PROTECTED]>
> Date: 2003/08/26 Tue PM 01:44:42 EDT
> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> Subject: RE: buffer overflow
> 
> contact the vendor and ask them to remove the dbms_output calls?
> 
> -Original Message-
> Sent: Tuesday, August 26, 2003 1:34 PM
> To: Multiple recipients of list ORACLE-L
> 
> 
> Hi Gang ,
> I have some upgrade script from vendor ( no source code ) which calling some
> procs . Now I am getting "buffer overflow, limit of 100 bytes" error
> from it . Looks like they are spitting out debug statmts out with
> dbms_output . How can I stop this to happen without touching source code 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: Kevin Toepke
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> 

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

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

RE: optimizer_max_permutations

2003-08-26 Thread John Kanagaraj

Just fyi - it seems that Oracle had realized this in advance and has
specifically instructed the Oracle Applications 11i installations to set
this to 2000.

John Kanagaraj
DB Soft Inc
Phone: 408-970-7002 (W)

Listen to great, commercial-free christian music 24x7x365 at
http://www.klove.com

** The opinions and facts contained in this message are entirely mine and do
not reflect those of my employer or customers **

-Original Message-
Sent: Tuesday, August 26, 2003 8:55 AM
To: Multiple recipients of list ORACLE-L

One thing that the docs don't mention is that '8'
(the default in 8) is also a special boundary value. 
Anything less than 80,000 changes some of ways the
optimizer does it work, ie, its not just a reduction
in permutations.  

Can't remember the specifics - join orders spring to
mind but there is a metalink note about it.

Because of this, there's a school of thought that even
on 8i, adopting the (9i default) value of 2000 will
improve the "general" optimizer performance (ie the
quality of the decisions it makes).

Cheers
Connor

 --- "Boivin, Patrice J" <[EMAIL PROTECTED]>
wrote: > Has anyone worked with this one?
>  
>
http://download-west.oracle.com/docs/cd/A87860_01/doc/server.817/a76961/ch11
> 23.htm#81357
>
 123.htm#81357> 
>  
> Patrice.
>  

=
Connor McDonald
web: http://www.oracledba.co.uk
web: http://www.oaktable.net
email: [EMAIL PROTECTED]

"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"

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

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

RE: Re: OT - Linux books ??

2003-08-26 Thread Matthew Zito


The Linux kernel is totally different, though you will find some code in it
that is from System 4 UNIX.

Linux is technically not a UNIX, thought it looks and feels and acts like
one.  It's also worth noting that all of the UNIXes have, at this point,
significant differences in terms of their internals.  There's even two whole
styles of UNIX - System V and BSD with entirely different core codebases.   

Thanks,
Matt

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

> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On 
> Behalf Of [EMAIL PROTECTED]
> Sent: Tuesday, August 26, 2003 1:40 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: Re: OT - Linux books ??
> 
> 
> i thought linux was just unix designed to run on a PC. how 
> different is the kernel? 
> > 
> > From: "Matthew Zito" <[EMAIL PROTECTED]>
> > Date: 2003/08/26 Tue PM 01:24:26 EDT
> > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> > Subject: RE: Re: OT - Linux books ??
> > 
> > 
> > And of course, there's the other free UNIXes - the BSDs (OpenBSD, 
> > FreeBSD, NetBSD).  Tragically, none of these run Oracle 
> (FreeBSD can 
> > run Oracle in Linux emulation mode - which seems backwards 
> at best).  
> > And there's OS X, which is Apple's UNIX, and also runs Oracle.
> > 
> > As far as AIX, I couldn't find an article to verify this, but I had 
> > thought IBM had announced that AIX would eventually be 
> phased out in 
> > favor of Linux. This is not a short-term plan, obviously 
> the existing 
> > install base of AIX precludes that.  But, eventually...  And if I 
> > imagined that announcement, I'd still wager money that its going to 
> > happen. :)
> > 
> > Thanks,
> > Matt
> > 
> > 
> > --
> > Matthew Zito
> > GridApp Systems
> > Email: [EMAIL PROTECTED]
> > Cell: 646-220-3551
> > Phone: 212-358-8211 x 359
> > http://www.gridapp.com
> > 
> > > -Original Message-
> > > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
> > > Behalf Of Mladen Gogala
> > > Sent: Tuesday, August 26, 2003 12:24 PM
> > > To: Multiple recipients of list ORACLE-L
> > > Subject: RE: Re: OT - Linux books ??
> > > 
> > > 
> > > Well, IBM has AIX, a very solid and stable version of unix
> > > which works really 
> > > well. SCO has become very popular lately and using SCO Unix 
> > > will turn you into the most popular guy on this list. Then 
> > > there is Irix, made by SGI. HP actually has several unix 
> > > versions Tru64, HP-UX, Tandem Unix, Ultrix, Apollo Unix and some 
> > > more exotic operating systems like OpenVMS, MPE, Guardian and 
> > > alike. If you go with HP, I do advise you to stick with HP-UX.
> > > 
> > > --
> > > Mladen Gogala
> > > Oracle DBA
> > > 
> > > 
> > > 
> > > -Original Message-
> > > [EMAIL PROTECTED]
> > > Sent: Tuesday, August 26, 2003 10:19 AM
> > > To: Multiple recipients of list ORACLE-L
> > > 
> > > 
> > > so different flavors of linux are more compatible?
> > > 
> > > i thought the only two unix players out there now are HP and
> > > Solaris. who else is out there? 
> > > 
> > > 
> > > 
> > > 
> > > 
> > > Note:
> > > This message is for the named person's use only.  It may
> > > contain confidential, proprietary or legally privileged 
> > > information.  No confidentiality or privilege is waived or 
> > > lost by any mistransmission.  If you receive this message in 
> > > error, please immediately delete it and all copies of it from 
> > > your system, destroy any hard copies of it and notify the 
> > > sender.  You must not, directly or indirectly, use, disclose, 
> > > distribute, print, or copy any part of this message if you 
> > > are not the intended recipient. Wang Trading LLC and any of 
> > > its subsidiaries each reserve the right to monitor all e-mail 
> > > communications through its networks. Any views expressed in 
> > > this message are those of the individual sender, except where 
> > > the message states otherwise and the sender is authorized to 
> > > state them to be the views of any such entity.
> > > 
> > > --
> > > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > > -- 
> > > Author: Mladen Gogala
> > >   INET: [EMAIL PROTECTED]
> > > 
> > > Fat City Network Services-- 858-538-5051 
> http://www.fatcity.com
> > > San Diego, California-- Mailing list and web 
> hosting services
> > > 
> 
> > > -
> > > To REMOVE yourself from this mailing list, send an E-Mail message
> > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 
> > > and in the message BODY, include a line containing: UNSUB 
> > > ORACLE-L (or the name of mailing list you want to be removed 
> > > from).  You may also send the HELP command for other 
> > > information (like subscribing).
> > > 
> > > 
> > 
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > -- 
> > Author: Matth

RE: Re: OT - Linux books ??

2003-08-26 Thread Thater, William

Mladen Gogala  scribbled on the wall in glitter crayon:

> AIX phased out in favor of Linux? I believe that SCO asked for
> injunction to prevent IBM
> from distributing AIX, and there is a whole saga around SCO and Linux.
> According to some,
> Unix variants are like higlanders: there can be only one. If you ask
> Mr. Darl McBride,
> it's going to be SCO. Hopefully, MR. McBride will not lose his head.

hopefully he will.;-)

--
Bill "Shrek" Thater ORACLE DBA  BAARF Party member #25
[EMAIL PROTECTED]

All our wanting comes from needs, thus we continiously suffer. The intellect
teaches free will, free from suffering. - Arthur Schopenhauer
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Thater, William
  INET: [EMAIL PROTECTED]

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

2003-08-26 Thread Kevin Toepke

contact the vendor and ask them to remove the dbms_output calls?

-Original Message-
Sent: Tuesday, August 26, 2003 1:34 PM
To: Multiple recipients of list ORACLE-L


Hi Gang ,
I have some upgrade script from vendor ( no source code ) which calling some
procs . Now I am getting "buffer overflow, limit of 100 bytes" error
from it . Looks like they are spitting out debug statmts out with
dbms_output . How can I stop this to happen without touching source code 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Kevin Toepke
  INET: [EMAIL PROTECTED]

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

RE: Re: OT - Linux books ??

AIX phased out in favor of Linux? I believe that SCO asked for injunction to
prevent IBM
from distributing AIX, and there is a whole saga around SCO and Linux.
According to some, 
Unix variants are like higlanders: there can be only one. If you ask Mr.
Darl McBride, 
it's going to be SCO. Hopefully, MR. McBride will not lose his head.

--
Mladen Gogala
Oracle DBA 



-Original Message-
Matthew Zito
Sent: Tuesday, August 26, 2003 1:24 PM
To: Multiple recipients of list ORACLE-L



And of course, there's the other free UNIXes - the BSDs (OpenBSD, FreeBSD,
NetBSD).  Tragically, none of these run Oracle (FreeBSD can run Oracle in
Linux emulation mode - which seems backwards at best).  And there's OS X,
which is Apple's UNIX, and also runs Oracle.

As far as AIX, I couldn't find an article to verify this, but I had thought
IBM had announced that AIX would eventually be phased out in favor of Linux.
This is not a short-term plan, obviously the existing install base of AIX
precludes that.  But, eventually...  And if I imagined that announcement,
I'd still wager money that its going to happen. :)

Thanks,
Matt


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

> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
> Behalf Of Mladen Gogala
> Sent: Tuesday, August 26, 2003 12:24 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: Re: OT - Linux books ??
> 
> 
> Well, IBM has AIX, a very solid and stable version of unix
> which works really 
> well. SCO has become very popular lately and using SCO Unix 
> will turn you into the most popular guy on this list. Then 
> there is Irix, made by SGI. HP actually has several unix 
> versions Tru64, HP-UX, Tandem Unix, Ultrix, Apollo Unix and some 
> more exotic operating systems like OpenVMS, MPE, Guardian and 
> alike. If you go with HP, I do advise you to stick with HP-UX.
> 
> --
> Mladen Gogala
> Oracle DBA
> 
> 
> 
> -Original Message-
> [EMAIL PROTECTED]
> Sent: Tuesday, August 26, 2003 10:19 AM
> To: Multiple recipients of list ORACLE-L
> 
> 
> so different flavors of linux are more compatible?
> 
> i thought the only two unix players out there now are HP and
> Solaris. who else is out there? 
> 
> 
> 
> 
> 
> Note:
> This message is for the named person's use only.  It may
> contain confidential, proprietary or legally privileged 
> information.  No confidentiality or privilege is waived or 
> lost by any mistransmission.  If you receive this message in 
> error, please immediately delete it and all copies of it from 
> your system, destroy any hard copies of it and notify the 
> sender.  You must not, directly or indirectly, use, disclose, 
> distribute, print, or copy any part of this message if you 
> are not the intended recipient. Wang Trading LLC and any of 
> its subsidiaries each reserve the right to monitor all e-mail 
> communications through its networks. Any views expressed in 
> this message are those of the individual sender, except where 
> the message states otherwise and the sender is authorized to 
> state them to be the views of any such entity.
> 
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: Mladen Gogala
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru')
> and in the message BODY, include a line containing: UNSUB 
> ORACLE-L (or the name of mailing list you want to be removed 
> from).  You may also send the HELP command for other 
> information (like subscribing).
> 
> 

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

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




Note:
This message is for the named person's use only.  It may contain confidential, 
proprietary or legally privileged information.  No confidentiality or privilege is 
waived or lost by any mistransmission.  If you receive this message in error, please 
immediately delete it and all copies of it from your system, destroy any hard copies 
of it and notify the sender.  You must not, directly or indirectly, use, disclose, 
distribute, print, or copy any

RE: Re: OT - Linux books ??

i thought linux was just unix designed to run on a PC. how different is the kernel? 
> 
> From: "Matthew Zito" <[EMAIL PROTECTED]>
> Date: 2003/08/26 Tue PM 01:24:26 EDT
> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> Subject: RE: Re: OT - Linux books ??
> 
> 
> And of course, there's the other free UNIXes - the BSDs (OpenBSD, FreeBSD,
> NetBSD).  Tragically, none of these run Oracle (FreeBSD can run Oracle in
> Linux emulation mode - which seems backwards at best).  And there's OS X,
> which is Apple's UNIX, and also runs Oracle.
> 
> As far as AIX, I couldn't find an article to verify this, but I had thought
> IBM had announced that AIX would eventually be phased out in favor of Linux.
> This is not a short-term plan, obviously the existing install base of AIX
> precludes that.  But, eventually...  And if I imagined that announcement,
> I'd still wager money that its going to happen. :)
> 
> Thanks,
> Matt
> 
> 
> --
> Matthew Zito
> GridApp Systems
> Email: [EMAIL PROTECTED]
> Cell: 646-220-3551
> Phone: 212-358-8211 x 359
> http://www.gridapp.com
> 
> > -Original Message-
> > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On 
> > Behalf Of Mladen Gogala
> > Sent: Tuesday, August 26, 2003 12:24 PM
> > To: Multiple recipients of list ORACLE-L
> > Subject: RE: Re: OT - Linux books ??
> > 
> > 
> > Well, IBM has AIX, a very solid and stable version of unix 
> > which works really 
> > well. SCO has become very popular lately and using SCO Unix 
> > will turn you into the most popular guy on this list. Then 
> > there is Irix, made by SGI. HP actually has several unix 
> > versions Tru64, HP-UX, Tandem Unix, Ultrix, Apollo Unix and some 
> > more exotic operating systems like OpenVMS, MPE, Guardian and 
> > alike. If you go with HP, I do advise you to stick with HP-UX.
> > 
> > --
> > Mladen Gogala
> > Oracle DBA 
> > 
> > 
> > 
> > -Original Message-
> > [EMAIL PROTECTED]
> > Sent: Tuesday, August 26, 2003 10:19 AM
> > To: Multiple recipients of list ORACLE-L
> > 
> > 
> > so different flavors of linux are more compatible? 
> > 
> > i thought the only two unix players out there now are HP and 
> > Solaris. who else is out there? 
> > 
> > 
> > 
> > 
> > 
> > Note:
> > This message is for the named person's use only.  It may 
> > contain confidential, proprietary or legally privileged 
> > information.  No confidentiality or privilege is waived or 
> > lost by any mistransmission.  If you receive this message in 
> > error, please immediately delete it and all copies of it from 
> > your system, destroy any hard copies of it and notify the 
> > sender.  You must not, directly or indirectly, use, disclose, 
> > distribute, print, or copy any part of this message if you 
> > are not the intended recipient. Wang Trading LLC and any of 
> > its subsidiaries each reserve the right to monitor all e-mail 
> > communications through its networks. Any views expressed in 
> > this message are those of the individual sender, except where 
> > the message states otherwise and the sender is authorized to 
> > state them to be the views of any such entity.
> > 
> > -- 
> > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > -- 
> > Author: Mladen Gogala
> >   INET: [EMAIL PROTECTED]
> > 
> > Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> > San Diego, California-- Mailing list and web hosting services
> > -
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 
> > and in the message BODY, include a line containing: UNSUB 
> > ORACLE-L (or the name of mailing list you want to be removed 
> > from).  You may also send the HELP command for other 
> > information (like subscribing).
> > 
> > 
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: Matthew Zito
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> 
> 

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

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

Migration Suggestion.

2003-08-26 Thread Avnish.Rastogi

I am looking for some expert suggestions for the migration of 300GB database to 
different hardware. Currently database is 816 OPS on AIX 4.1 nodes. Database is 32bit 
and performance on this system is really slow. Export for 2GB table takes 2 hours. All 
the data is on EMC symmetric. 
We are planning to migrate this database to AIX5.1 Oracle 8174 32Bit.
Oracle 816 on AIX5.1 is not supported.
'Cause OS is different we cannot use redirect restore and apply archive logs to bring 
the database up.
Any suggestion regarding migration.

Thanks



DISCLAIMER:
This message is intended for the sole use of the individual to whom it is addressed, 
and may contain information that is privileged, confidential and exempt from 
disclosure under applicable law. If you are not the addressee you are hereby notified 
that you may not use, copy, disclose, or distribute to anyone the message or any 
information contained in the message. If you have received this message in error, 
please immediately advise the sender by reply email and delete this message.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: <[EMAIL PROTECTED]
  INET: [EMAIL PROTECTED]

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

buffer overflow

2003-08-26 Thread AK

Hi Gang ,
I have some upgrade script from vendor ( no source code ) which calling some procs . 
Now I am getting "buffer overflow, limit of 100 bytes" error from it . Looks like 
they are spitting out debug statmts out with dbms_output . How can I stop this to 
happen without touching source code

RE: Re: OT - Linux books ??

2003-08-26 Thread Matthew Zito


And of course, there's the other free UNIXes - the BSDs (OpenBSD, FreeBSD,
NetBSD).  Tragically, none of these run Oracle (FreeBSD can run Oracle in
Linux emulation mode - which seems backwards at best).  And there's OS X,
which is Apple's UNIX, and also runs Oracle.

As far as AIX, I couldn't find an article to verify this, but I had thought
IBM had announced that AIX would eventually be phased out in favor of Linux.
This is not a short-term plan, obviously the existing install base of AIX
precludes that.  But, eventually...  And if I imagined that announcement,
I'd still wager money that its going to happen. :)

Thanks,
Matt


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

> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On 
> Behalf Of Mladen Gogala
> Sent: Tuesday, August 26, 2003 12:24 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: Re: OT - Linux books ??
> 
> 
> Well, IBM has AIX, a very solid and stable version of unix 
> which works really 
> well. SCO has become very popular lately and using SCO Unix 
> will turn you into the most popular guy on this list. Then 
> there is Irix, made by SGI. HP actually has several unix 
> versions Tru64, HP-UX, Tandem Unix, Ultrix, Apollo Unix and some 
> more exotic operating systems like OpenVMS, MPE, Guardian and 
> alike. If you go with HP, I do advise you to stick with HP-UX.
> 
> --
> Mladen Gogala
> Oracle DBA 
> 
> 
> 
> -Original Message-
> [EMAIL PROTECTED]
> Sent: Tuesday, August 26, 2003 10:19 AM
> To: Multiple recipients of list ORACLE-L
> 
> 
> so different flavors of linux are more compatible? 
> 
> i thought the only two unix players out there now are HP and 
> Solaris. who else is out there? 
> 
> 
> 
> 
> 
> Note:
> This message is for the named person's use only.  It may 
> contain confidential, proprietary or legally privileged 
> information.  No confidentiality or privilege is waived or 
> lost by any mistransmission.  If you receive this message in 
> error, please immediately delete it and all copies of it from 
> your system, destroy any hard copies of it and notify the 
> sender.  You must not, directly or indirectly, use, disclose, 
> distribute, print, or copy any part of this message if you 
> are not the intended recipient. Wang Trading LLC and any of 
> its subsidiaries each reserve the right to monitor all e-mail 
> communications through its networks. Any views expressed in 
> this message are those of the individual sender, except where 
> the message states otherwise and the sender is authorized to 
> state them to be the views of any such entity.
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: Mladen Gogala
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 
> and in the message BODY, include a line containing: UNSUB 
> ORACLE-L (or the name of mailing list you want to be removed 
> from).  You may also send the HELP command for other 
> information (like subscribing).
> 
> 

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

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

RE: More on Uday & Qusay

2003-08-26 Thread Pardee, Roy E

>From _the Onion_'s what-do-you-think regular feature, when the news
about Uday & Qusay was more recent:

"It's great that we got Uday and Qusay.  But what about the eapons-way
of ass-may estruction-day?"

I'm still laughing at that one...

www.theonion.com

Roy Pardee
Programmer/Analyst/DBA
SWFPAC Lockheed Martin IT
Extension 8487

-Original Message-
[mailto:[EMAIL PROTECTED]
Sent: Tuesday, August 26, 2003 6:59 AM
To: Multiple recipients of list ORACLE-L


Now that Uday and Qusay have been eliminated, a lot of the lesser-known 
family members are coming to the attention of American authorities.

Among the brothers:

Sooflay ..the restaurateur

Guday... the half-Australian brother
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Pardee, Roy E
  INET: [EMAIL PROTECTED]

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

Hi!

What is your goal? To finish data transfer in the shortest time or keep
hardware utilization maximum during transfer?
I think you should concentrate on keeping the time for doing data transfer
low.

Depending on your network - in case of gigabit (or 10 Gb) you could look at
enabling jumbo frames, which enable ethernet packets up to 9000 bytes. Also
set (SDU=32768) in your listener and tnsnames.oras (you can set it with
normal 1500 byte frames as well).

About parallellism, you might want to run several bulk inserts over dblink
to fully utilize your network (fill the "gaps" when one session is busy
inserting, thus not using the network). But if your source disk array (or
CPUs) are slow then they might be the bottleneck.
If you got SAN and a temporary spare server, do a BCV copy or mirror split,
open up several clones of a database and copy data from all of them.

Also, when you have SAN, there's no need for network transfer at all - you
just mount the filesystem with dump/exportfiles on target database and do
the load from there. If your operating systems are different, then just dump
to raw device, with pipe and tar for example, or completely raw, remembering
your data sizes. Note that in some (older) operating systems there were few
blocks in beginning of device which were used (and written) by operating
system (Tru64 had the largest I know - 64k). Thus you had to make sure you
didn't write anything there (oseek=65536 for dd for example).

If downtime isn't an issue for you, it might not be worth trying above
recommendations, but in RVLDBs (really very large databases) all of this can
help a lot.

Tanel.
- Original Message - 
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Tuesday, August 26, 2003 5:54 PM


> Taniel, Binley
>Thanks for the excellent suggestions.
>At this point we have been testing with two smaller test systems,
moving
> a single table at a time, but initial indications are that the performance
> order is:
> 1. Perl dump to CSV / ftp / SQL*Loader
> 2. Copy across database link
> 3. Export/ ftp / import
>
> I need to re-run the tests once the target production system is available
to
> re-confirm which is faster. I am pretty confident in the ability to run
> multiple SQL*Loader and import sessions simultaneously. I am a little
> nervous about the ability of the database link to scale to enough
> simultaneous sessions to keep the RAID sets maxed out on the target
system.
> Several years ago when I was doing a large conversion I hit that limit.
Some
> days I wonder if we are the beneficiary or victim of our prior experience.
> Oh well thanks for all the good suggestions, on to testing, testing,
> testing.
>
> Dennis Williams
> DBA, 80%OCP, 100% DBA
> Lifetouch, Inc.
> [EMAIL PROTECTED]
>
>
> -Original Message-
> Sent: Monday, August 25, 2003 7:09 PM
> To: Multiple recipients of list ORACLE-L
>
>
> Hi!
>
> What about several insert /*+ APPEND NOLOGGING */ commands over database
> link run in parallel? (Possibly over dedicated network). This is fast and
is
> easier (in case you don't hit any compatibility problems). If you happen
to
> be running on Windows for some reason, you could try to use named pipes
> network protocol instead of TCP as well.
>
> Tanel.
>
> - Original Message - 
> To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
> Sent: Monday, August 25, 2003 11:04 PM
>
>
> > Thanks Tanel
> >   We will undoubtedly use export/import for the many small tables. We
are
> > looking for alternatives that will perform even faster. The insert phase
> > seems to be the slowest part, and that is where SQL*Loader in direct
path
> > really shines. Now the next issue is how to produce a CSV file as fast
as
> > possible, and so far it looks like Jared's Perl program is the clear
> winner.
> >
> > Dennis Williams
> > DBA, 80%OCP, 100% DBA
> > Lifetouch, Inc.
> > [EMAIL PROTECTED]
> >
> >
> > -Original Message-
> > Sent: Monday, August 25, 2003 1:05 PM
> > To: Multiple recipients of list ORACLE-L
> >
> >
> > Hi!
> >
> > Spooling from sqlplus is VERY slow.
> > Is the source database Oracle? Then use export/import
> > If not, is there an ODBC driver for source database? Then use Oracle
> > heterogenous services and do your transfer directly, without any
> > intermediate files.
> > Or use some very expensive software for doing this simple job...
> >
> > Tanel.
> > P.S. if you definitely want to spool to textfile fast, Sparky could be
> what
> > you want...
> >
> > - Original Message - 
> > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
> > Sent: Monday, August 25, 2003 7:24 PM
> >
> >
> > > Jared - Thanks for posting this. At the moment, we are preparing to
move
> > > large database to a new server. Based on the advice you posted several
> > > months ago, we have been testing SQL*Loader and as you predicted, it
is
>
> > > indeed fast. But also as you predicted, using SQL*Plus to create a CSV
> > isn't
> >

DBASSIST HANGS

2003-08-26 Thread Ramon E. Estevez

Title: DBASSIST HANGS






Hi list,


I manage to install 8.1.7 on RH AS 2.1.  From Note 230693.1 I downloaded the jre118_v3 patch from blackdown, applied and the dbassist start, but I'm getting ORACLE NOT AVAILABLE.

No more in metalink.


TIA


Note: Why to deal with Linux is so difficult.

 

Ramon E. Estevez

[EMAIL PROTECTED]

809-535-8994

Re: column level privilege - resolved

2003-08-26 Thread Arup Nanda

Reginald,

No, FGAC (or VPD or RLS, depending on who you ask) is not about columns;
it's about restricting rows. Within the selected rows, all the columns are
visible. Rahul wanted to mask columns without creating views for each user.
This is the only way to do that.

Hope this helps.

Arup



- Original Message - 
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Tuesday, August 26, 2003 12:29 PM


>
> Rahul:
>
> It sounds like your implementation is very similar, in theory, to Oracle's
> Fine Grain Access.  Are you re-inventing the wheel?
>
>
>


>
> Reginald W. Bailey
> IBM Global Services - ETS SW GDSD - Database Management
> Your Friendly Neighborhood DBA
> 713-216-7703 (Office) 281-798-5474 (Mobile) 713-415-5410 (Pager)
> [EMAIL PROTECTED]
> [EMAIL PROTECTED]
>


>
>
>
> [EMAIL PROTECTED]
> .co.id   To: [EMAIL PROTECTED]
> Sent by: cc:
> [EMAIL PROTECTED]   Subject: column level
privilege - resolved
> ity.com
>

>
> 08/26/2003
> 10:44 AM
> Please respond
> to ORACLE-L
>
>
>
>
>
>
> Arun, thanks for suggesting this, this is what i did.
>
> 1. created a table to store table names associated column names
> and a "security level" for a that column
>
> EMP emp_name 3
> EMP emp_sal  5
>
> 2. then i granted every users a security level also,
>
> 3. then i created a view on the name table
>
> select decode(sec_func('EMP','EMP_NAME'),1,emp_name,'x' emp_name),
> decode(sec_func('EMP','EMP_SAL'),1,emp_sal,0 emp_sal)
>
> the sec_func is passed table name and the column name and it checks the
> security_level of that column againet the security level of the user
> quering the table. if the security level is equal or lower, then 1 is
> returned, else 0 is returned, and the decode in the view will do the rest
>
> this way i can show/hide columns based on the security level (or roles
> granted to users) ...
>
> ok, i have only tested it, not implemented it, will it work in a real
> application environment ? has anyone used this type of column privs ?
>
> -TIA
>
>
> =
> On Sun, 24 Aug 2003 16:24:36 -0800, "Arup Nanda" <[EMAIL PROTECTED]>
> wrote :
>
> > This is a multi-part message in MIME format.
> >
> >
> > Rahul,
> >
> > I'm not sure if this is too late; but here is a strategy you could
follow
> to achieve what you want. True, VPD does not have a mechanism to suppress
> columns; and using a view for each user is impractical. Someday, I hope,
> VPD will have that capability; but until then you could try the following.
> >
> > Suppose you have a table called SAVINGS, for savings account holders as
> follows:
> >
> > ACCTNO NUMBER
> > CLEARED_BALANCENUMBER
> > UNCLEARED_BALANCE  NUMBER
> >
> > The records in the table are as follows:
> >
> > ACCTNO CLEARED_BALANCE UNCLEARED_BALANCE
> > -- --- -
> >  11000  1100
> >  21100  1200
> >  31300  1500
> >
> > Cleared balance is the amount the the customer can draw from the bank.
If
> there are checks outstanding, the balance is shown in uncleared. Let's
> start with a simple example - you have users who are allowed to see the
> uncleared balance of the customers and the others are not. Intead of
hiding
> the column completely, which how VPD operates, you would want to show then
> as zero, if not authorized to see that; otherwise the actual value is
> shown.
> >
> > You would create a context as follows:
> >
> > create context sec_ctx using sec_ctx_pkg;
> >
> > The trusted function can be created as:
> >
> >  create procedure sec_ctx_pkg
> >  (
> >  p_attribute_name in varchar2,
> >  p_attribute_value in varchar2
> >  ) is
> >  begin
> >  dbms_session.set_context(
> > 'sec_ctx',
> >  p_attribute_name,
> >  p_attribute_value);
> >  end;
> >  /
> >
> > In the after-login trigger, you would set the context value
automatically
> for user using
> >
> > set_Ctx_pkg ('cleared', 'yes'); or set_Ctx_pkg ('cleared', 'no');
> depending on whether the user is cleared to see the balance or not. In
real
> life, you may have a table that lists all users and whether or not they
are
> cleared. The after-logon trigger could read that table and set the context
> attribute properly.
> >
> > Next, you would craete a view.
> >
> > create or replace view vw_savings
> > as
> > select acctno, cleared_balance,
> > decode(sys_context('sec_ctx','cleared')

export full=y

2003-08-26 Thread Thomas Day



9.2.0.3.0 Enterprise Edition
on Win2K
using the 9.2.0.1.0 client.

export hangs on "exporting object type definitions"

TOAD says that it's trying to 'ALTER TYPE "OE"."ORDER_TYP" COMPILE
SPECIFICATION REUSE SETTINGS'

If I query v$session_wait I get:

   SID   SEQ#
-- --
EVENT

P1TEXT   P1
 --
P1RAWP2TEXT
 
P2 P2RAW
-- 
P3TEXT   P3
 --
P3RAW WAIT_TIME SECONDS_IN_WAIT STATE
 -- --- ---
13 65
null event
 1413697536
54435000
 1 0001
  0
00   -1   0 WAITED KNOWN TIME

 1640
pmon timer
duration300
012C
 0 00
  0
000   0 WAITING

 2735
rdbms ipc message
timeout 300
012C
 0 00
  0
000   3 WAITING

 3   1660
rdbms ipc message
timeout 300
012C
 0 00
  0
000   0 WAITING

 6  5
rdbms ipc message
timeout  18
0002BF20
 0 00
  0
0001792 WAITING

 7370
rdbms ipc message
timeout 500
01F4
 0 00
  0
000   3 WAITING

 4   1465
rdbms ipc message
timeout 300
012C
 0 00
  0
000   0 WAITING

 5160
smon timer
sleep time  300
012C failed
 0 00
  0
000 305 WAITING

 9  31569
library cache load lock
object address   1780751228
6A241B7C lock address
1766095492 69447A84
100*mask+namespace  501
01F5  0   0 WAITING

12   1273
SQL*Net message from client
driver id1413697536
54435000 #bytes
 1 0001
  0
000  19 WAITING

 8235
wakeup time manager
  0
00
 0 00
  0
000  13 WAITING


11 rows selected.

I haven't analyzed the SYS schema and I haven't tried anything other than a
FULL export, mostly because I only want a FULL export.  This looks as if
it's related to Bug:1874468 which says that it's fixed in 9201.  Was it
re-introduced in 9203?


The manual is no help and Metalink is crawling.  I guess that their
unbreakable broke.  Most of the pages that I'm looking for are unavailable.

Did anybody else have this problem and was able to solve it and will to
share the solution?

TIA


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

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

Re: column level privilege - resolved

2003-08-26 Thread Reginald . W . Bailey


Rahul:

It sounds like your implementation is very similar, in theory, to Oracle's
Fine Grain Access.  Are you re-inventing the wheel?




Reginald W. Bailey
IBM Global Services - ETS SW GDSD - Database Management
Your Friendly Neighborhood DBA
713-216-7703 (Office) 281-798-5474 (Mobile) 713-415-5410 (Pager)
[EMAIL PROTECTED]
[EMAIL PROTECTED]



   
  
[EMAIL PROTECTED]  
 
.co.id   To: [EMAIL PROTECTED] 
   
Sent by: cc:   
  
[EMAIL PROTECTED]   Subject: column level privilege - 
resolved  
ity.com
  
   
  
   
  
08/26/2003 
  
10:44 AM   
  
Please respond 
  
to ORACLE-L
  
   
  
   
  




Arun, thanks for suggesting this, this is what i did.

1. created a table to store table names associated column names
and a "security level" for a that column

EMP emp_name 3
EMP emp_sal  5

2. then i granted every users a security level also,

3. then i created a view on the name table

select decode(sec_func('EMP','EMP_NAME'),1,emp_name,'x' emp_name),
decode(sec_func('EMP','EMP_SAL'),1,emp_sal,0 emp_sal)

the sec_func is passed table name and the column name and it checks the
security_level of that column againet the security level of the user
quering the table. if the security level is equal or lower, then 1 is
returned, else 0 is returned, and the decode in the view will do the rest

this way i can show/hide columns based on the security level (or roles
granted to users) ...

ok, i have only tested it, not implemented it, will it work in a real
application environment ? has anyone used this type of column privs ?

-TIA


=
On Sun, 24 Aug 2003 16:24:36 -0800, "Arup Nanda" <[EMAIL PROTECTED]>
wrote :

> This is a multi-part message in MIME format.
>
>
> Rahul,
>
> I'm not sure if this is too late; but here is a strategy you could follow
to achieve what you want. True, VPD does not have a mechanism to suppress
columns; and using a view for each user is impractical. Someday, I hope,
VPD will have that capability; but until then you could try the following.
>
> Suppose you have a table called SAVINGS, for savings account holders as
follows:
>
> ACCTNO NUMBER
> CLEARED_BALANCENUMBER
> UNCLEARED_BALANCE  NUMBER
>
> The records in the table are as follows:
>
> ACCTNO CLEARED_BALANCE UNCLEARED_BALANCE
> -- --- -
>  11000  1100
>  21100  1200
>  31300  1500
>
> Cleared balance is the amount the the customer can draw from the bank. If
there are checks outstanding, the balance is shown in uncleared. Let's
start with a simple example - you have users who are allowed to see the
uncleared balance of the customers and the others are not. Intead of hiding
the column completely, which how VPD operates, you would want to show then
as zero, if not authorized to see that; otherwise the actual value is
shown.
>
> You would create a context as follows:
>
> create context sec_ctx using sec_ctx_pkg;
>
> The trusted function can be created as:
>
>  create procedure sec_ctx_pkg
>  (
>  p_attribute_name in varchar2,
>  p_attribute_value in varchar2
>  )

Re: OT: More on Uday & Qusay

2003-08-26 Thread KENNETH JANUSZ

I'm Polish and I don't find it offensive.  Want some good Polish jokes?

Ken Janusz
Ken Januszewski (prior to 1910)



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


>
> While work related humor has it's place in the workplace and
> on this list, humor for humor's sake should be limited to the
> OT list.
>
> There are a *lot* of reasons for this.  In the case of this
> post, there are folks on this list that will find this offensive.
>
> Thank You,
>
> Jared ( list owner )
>
> On Tue, 2003-08-26 at 06:59, Wolfe Stephen S GS-11 6 MDSS/SGSI wrote:
> > Now that Uday and Qusay have been eliminated, a lot of the lesser-known
> > family members are coming to the attention of American authorities.
> >
> > Among the brothers:
> >
> > Sooflay ..the restaurateur
> >
> > Guday... the half-Australian brother
> >
> > Huray the sports fanatic
> >
> > Bejay..the gay brother
> >
> > Kuntay and Kintay.the twins from the African mother
> >
> > Sayhaythe baseball player
> >
> > Ojaythe stalker / murderer
> >
> > Gulay..the singer / entertainer
> >
> > Ebay...the internet czar
> >
> > Biliray..the country music star
> >
> > Ecksray...the radiologist
> >
> > Puray...the blender factory owner
> >
> > Regay..the half-Jamaican brother
> >
> > Tupay..the one with bad hair:
> >
> >
> >
> > Among the sisters:
> >
> >
> > Pusay...the 'loose' 22 yr old
> >
> > Lattaythe coffee shop owner
> >
> > Bufay.the 300 pound sister
> >
> > Dushay..the clean sister
> >
> > Phayray.the zoo worker in the gorilla house:
> >
> > Sapheway..the grocery store owner:
> >
> > Ollay..the half-mexican sister:
> >
> > Gudlaythe prostitute:
> >
> >
> >
> > More will no doubt be discovered
> >
> >
> > v/r
> >
> > Stephen S. Wolfe, GS-11, DAFC
> > Data Services Manager
> > [EMAIL PROTECTED]
> > (813) 827-9974  DSN 651-9974
> >
> > --
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Jared Still
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
>

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

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

RE: Re: OT - Linux books ??

Well, IBM has AIX, a very solid and stable version of unix which works
really 
well. SCO has become very popular lately and using SCO Unix will turn you
into
the most popular guy on this list. Then there is Irix, made by SGI. HP
actually has
several unix versions Tru64, HP-UX, Tandem Unix, Ultrix, Apollo Unix and
some 
more exotic operating systems like OpenVMS, MPE, Guardian and alike. If you
go with HP,
I do advise you to stick with HP-UX.

--
Mladen Gogala
Oracle DBA 



-Original Message-
[EMAIL PROTECTED]
Sent: Tuesday, August 26, 2003 10:19 AM
To: Multiple recipients of list ORACLE-L


so different flavors of linux are more compatible? 

i thought the only two unix players out there now are HP and Solaris. who
else is out there? 





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

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

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

Re: column level privilege - resolved

2003-08-26 Thread Arup Nanda

Rahul,

Glad to know that it worked for you. Yes, I have implemented that and it
works quite well in production.

Just make sure you understand that the columns are not really hidden, just
"masked" - which means they may convey wrong impressions if not used
properly. In my case, I have avoided using it in number fields; since in
character fields it's easy to put a value like 'XXX', or 'NOT ALLOWED'.
In the number field, a value of 0 may be misconstrued, especially in
aggregation functions. Another options is to use NULLs, but they will lend a
hand in indexing.

So, use this with caution. By the way, it's "Arup", not Arun :)

Arup Nanda
www.proligence.com


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


> Arun, thanks for suggesting this, this is what i did.
>
> 1. created a table to store table names associated column names
> and a "security level" for a that column
>
> EMP emp_name 3
> EMP emp_sal  5
>
> 2. then i granted every users a security level also,
>
> 3. then i created a view on the name table
>
> select decode(sec_func('EMP','EMP_NAME'),1,emp_name,'x' emp_name),
> decode(sec_func('EMP','EMP_SAL'),1,emp_sal,0 emp_sal)
>
> the sec_func is passed table name and the column name and it checks the
> security_level of that column againet the security level of the user
> quering the table. if the security level is equal or lower, then 1 is
> returned, else 0 is returned, and the decode in the view will do the rest
>
> this way i can show/hide columns based on the security level (or roles
> granted to users) ...
>
> ok, i have only tested it, not implemented it, will it work in a real
> application environment ? has anyone used this type of column privs ?
>
> -TIA
>
>
> =
> On Sun, 24 Aug 2003 16:24:36 -0800, "Arup Nanda" <[EMAIL PROTECTED]>
> wrote :
>
> > This is a multi-part message in MIME format.
> >
> >
> > Rahul,
> >
> > I'm not sure if this is too late; but here is a strategy you could
follow
> to achieve what you want. True, VPD does not have a mechanism to suppress
> columns; and using a view for each user is impractical. Someday, I hope,
> VPD will have that capability; but until then you could try the following.
> >
> > Suppose you have a table called SAVINGS, for savings account holders as
> follows:
> >
> > ACCTNO NUMBER
> > CLEARED_BALANCENUMBER
> > UNCLEARED_BALANCE  NUMBER
> >
> > The records in the table are as follows:
> >
> > ACCTNO CLEARED_BALANCE UNCLEARED_BALANCE
> > -- --- -
> >  11000  1100
> >  21100  1200
> >  31300  1500
> >
> > Cleared balance is the amount the the customer can draw from the bank.
If
> there are checks outstanding, the balance is shown in uncleared. Let's
> start with a simple example - you have users who are allowed to see the
> uncleared balance of the customers and the others are not. Intead of
hiding
> the column completely, which how VPD operates, you would want to show then
> as zero, if not authorized to see that; otherwise the actual value is
shown.
> >
> > You would create a context as follows:
> >
> > create context sec_ctx using sec_ctx_pkg;
> >
> > The trusted function can be created as:
> >
> >  create procedure sec_ctx_pkg
> >  (
> >  p_attribute_name in varchar2,
> >  p_attribute_value in varchar2
> >  ) is
> >  begin
> >  dbms_session.set_context(
> > 'sec_ctx',
> >  p_attribute_name,
> >  p_attribute_value);
> >  end;
> >  /
> >
> > In the after-login trigger, you would set the context value
automatically
> for user using
> >
> > set_Ctx_pkg ('cleared', 'yes'); or set_Ctx_pkg ('cleared', 'no');
> depending on whether the user is cleared to see the balance or not. In
real
> life, you may have a table that lists all users and whether or not they
are
> cleared. The after-logon trigger could read that table and set the context
> attribute properly.
> >
> > Next, you would craete a view.
> >
> > create or replace view vw_savings
> > as
> > select acctno, cleared_balance,
> > decode(sys_context('sec_ctx','cleared'),'yes',
> > uncleared_balance, 0) uncleared_balance
> > from savings
> > /
> >
> > Note: there is only ONE view, not one per user. Regardless of how many
> users you have, there will be only one view.
> >
> > Now to test the setup. Assume user RAHUL is allowed to see the
> uncleared_balance. The after-logon trigger will set the context
> attribute "cleared" to "yes" when the user logs in. When the user selects:
> >
> > select * from vw_savings;
> >
> > He sees:
> >
> >ACCTNO CLEARED_BALANCE UNCLEARED_BALANCE
> > - --- -
> > 11000  1100
> > 21100  1

OracleWorld Exam Cram

2003-08-26 Thread Brian McGraw









Is anyone attending the 9i Cram Session on Sunday?  If so,
could you please email me off-list?

 

Thanks,

 

Brian

[EMAIL PROTECTED]

Re: OT: More on Uday & Qusay

2003-08-26 Thread Jared Still

While work related humor has it's place in the workplace and
on this list, humor for humor's sake should be limited to the 
OT list.

There are a *lot* of reasons for this.  In the case of this
post, there are folks on this list that will find this offensive.

Thank You,

Jared ( list owner )

On Tue, 2003-08-26 at 06:59, Wolfe Stephen S GS-11 6 MDSS/SGSI wrote:
> Now that Uday and Qusay have been eliminated, a lot of the lesser-known 
> family members are coming to the attention of American authorities.
> 
> Among the brothers:
> 
> Sooflay ..the restaurateur
> 
> Guday... the half-Australian brother
> 
> Huray the sports fanatic
> 
> Bejay..the gay brother
> 
> Kuntay and Kintay.the twins from the African mother
> 
> Sayhaythe baseball player
> 
> Ojaythe stalker / murderer
> 
> Gulay..the singer / entertainer
> 
> Ebay...the internet czar
> 
> Biliray..the country music star
> 
> Ecksray...the radiologist
> 
> Puray...the blender factory owner
> 
> Regay..the half-Jamaican brother
> 
> Tupay..the one with bad hair:
> 
> 
> 
> Among the sisters:
> 
> 
> Pusay...the 'loose' 22 yr old
> 
> Lattaythe coffee shop owner
> 
> Bufay.the 300 pound sister
> 
> Dushay..the clean sister
> 
> Phayray.the zoo worker in the gorilla house:
> 
> Sapheway..the grocery store owner:
> 
> Ollay..the half-mexican sister:
> 
> Gudlaythe prostitute:
> 
> 
> 
> More will no doubt be discovered
> 
> 
> v/r
> 
> Stephen S. Wolfe, GS-11, DAFC
> Data Services Manager
> [EMAIL PROTECTED]
> (813) 827-9974  DSN 651-9974
> 
> -- 

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

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

Re: optimizer_max_permutations

2003-08-26 Thread Jared Still

Yes, it is required in one of our COTS applications.

Inserts into complex views with instead-f triggers.

The views are quite complex, ridiculously so, one might say.

Before setting optimizer_max_permutations=1000, it took a very
long time to parse those views.

Jared

On Tue, 2003-08-26 at 05:44, Boivin, Patrice J wrote:
> Has anyone worked with this one?
>  
> http://download-west.oracle.com/docs/cd/A87860_01/doc/server.817/a76961/ch11
> 23.htm#81357
>  123.htm#81357> 
>  
> Patrice.

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

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

Re: optimizer_max_permutations

2003-08-26 Thread Connor McDonald

One thing that the docs don't mention is that '8'
(the default in 8) is also a special boundary value. 
Anything less than 80,000 changes some of ways the
optimizer does it work, ie, its not just a reduction
in permutations.  

Can't remember the specifics - join orders spring to
mind but there is a metalink note about it.

Because of this, there's a school of thought that even
on 8i, adopting the (9i default) value of 2000 will
improve the "general" optimizer performance (ie the
quality of the decisions it makes).

Cheers
Connor

 --- "Boivin, Patrice J" <[EMAIL PROTECTED]>
wrote: > Has anyone worked with this one?
>  
>
http://download-west.oracle.com/docs/cd/A87860_01/doc/server.817/a76961/ch11
> 23.htm#81357
>
 123.htm#81357> 
>  
> Patrice.
>  

=
Connor McDonald
web: http://www.oracledba.co.uk
web: http://www.oaktable.net
email: [EMAIL PROTECTED]

"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"

Want to chat instantly with your online friends?  Get the FREE Yahoo!
Messenger http://uk.messenger.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: =?iso-8859-1?q?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: About trcanlzr

2003-08-26 Thread Stephane Paquette

Corrupting would have been sending the damned dbmssupp.sql and its plb file.

Stephane

-Original Message-
Mladen Gogala
Sent: Monday, August 25, 2003 5:49 PM
To: Multiple recipients of list ORACLE-L


I'm corrupting youth.

--
Mladen Gogala
Oracle DBA



-Original Message-
Stephane Paquette
Sent: Monday, August 25, 2003 5:00 PM
To: Multiple recipients of list ORACLE-L


MessageThanks,

I just try it and works well.


Stephane
  -Original Message-
  From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of
Mladen Gogala
  Sent: Monday, August 25, 2003 2:45 PM
  To: Multiple recipients of list ORACLE-L
  Subject: RE: About trcanlzr


  Well, there is always "ORADEBUG SESSION_EVENT".  Granted, it's not as
elegant as "set_ev", but it works.


  --
  Mladen Gogala
  Oracle DBA

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of
Stephane Paquette
Sent: Monday, August 25, 2003 2:25 PM
To: Multiple recipients of list ORACLE-L
Subject: About trcanlzr


Hi,

I just start testing the trcanlzr scripts (metalink 224270.1)
I did not remember seeing any traffic on that utility on oracle-l ,
that's why I went on orafaq where there is only a post by Jamadagni Rajendra



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

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

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

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

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

column level privilege - resolved

2003-08-26 Thread rahul

Arun, thanks for suggesting this, this is what i did.

1. created a table to store table names associated column names
and a "security level" for a that column

EMP emp_name 3
EMP emp_sal  5

2. then i granted every users a security level also,

3. then i created a view on the name table

select decode(sec_func('EMP','EMP_NAME'),1,emp_name,'x' emp_name),
decode(sec_func('EMP','EMP_SAL'),1,emp_sal,0 emp_sal)

the sec_func is passed table name and the column name and it checks the
security_level of that column againet the security level of the user 
quering the table. if the security level is equal or lower, then 1 is 
returned, else 0 is returned, and the decode in the view will do the rest

this way i can show/hide columns based on the security level (or roles 
granted to users) ... 

ok, i have only tested it, not implemented it, will it work in a real 
application environment ? has anyone used this type of column privs ? 

-TIA


=
On Sun, 24 Aug 2003 16:24:36 -0800, "Arup Nanda" <[EMAIL PROTECTED]> 
wrote :

> This is a multi-part message in MIME format.
> 
> 
> Rahul,
> 
> I'm not sure if this is too late; but here is a strategy you could follow 
to achieve what you want. True, VPD does not have a mechanism to suppress 
columns; and using a view for each user is impractical. Someday, I hope, 
VPD will have that capability; but until then you could try the following. 
> 
> Suppose you have a table called SAVINGS, for savings account holders as 
follows:
> 
> ACCTNO NUMBER
> CLEARED_BALANCENUMBER
> UNCLEARED_BALANCE  NUMBER
> 
> The records in the table are as follows:
> 
> ACCTNO CLEARED_BALANCE UNCLEARED_BALANCE
> -- --- -
>  11000  1100
>  21100  1200
>  31300  1500
> 
> Cleared balance is the amount the the customer can draw from the bank. If 
there are checks outstanding, the balance is shown in uncleared. Let's 
start with a simple example - you have users who are allowed to see the 
uncleared balance of the customers and the others are not. Intead of hiding 
the column completely, which how VPD operates, you would want to show then 
as zero, if not authorized to see that; otherwise the actual value is shown.
> 
> You would create a context as follows:
> 
> create context sec_ctx using sec_ctx_pkg;
> 
> The trusted function can be created as:
> 
>  create procedure sec_ctx_pkg
>  (
>  p_attribute_name in varchar2,
>  p_attribute_value in varchar2
>  ) is
>  begin
>  dbms_session.set_context(
> 'sec_ctx',
>  p_attribute_name,
>  p_attribute_value);
>  end;
>  /
> 
> In the after-login trigger, you would set the context value automatically 
for user using 
> 
> set_Ctx_pkg ('cleared', 'yes'); or set_Ctx_pkg ('cleared', 'no'); 
depending on whether the user is cleared to see the balance or not. In real 
life, you may have a table that lists all users and whether or not they are 
cleared. The after-logon trigger could read that table and set the context 
attribute properly.
> 
> Next, you would craete a view. 
> 
> create or replace view vw_savings
> as
> select acctno, cleared_balance,
> decode(sys_context('sec_ctx','cleared'),'yes',
> uncleared_balance, 0) uncleared_balance
> from savings
> /
> 
> Note: there is only ONE view, not one per user. Regardless of how many 
users you have, there will be only one view.
> 
> Now to test the setup. Assume user RAHUL is allowed to see the 
uncleared_balance. The after-logon trigger will set the context 
attribute "cleared" to "yes" when the user logs in. When the user selects:
> 
> select * from vw_savings;
> 
> He sees:
> 
>ACCTNO CLEARED_BALANCE UNCLEARED_BALANCE
> - --- -
> 11000  1100
> 21100  1200
> 31300  1500
> 
> Which is the correct value. Now, user ARUP logs in, who does not have the 
authority to see the uncleared balance. The logon trigger will set the 
attribute to "no" and the same select will now produce:
> 
> ACCTNO CLEARED_BALANCE UNCLEARED_BALANCE
> -- --- -
>  11000 0
>  21100 0
>  31300 0
> 
> Note: How the uncleared balance is 0. 
> 
> This model can be extended to any column and any number of values for the 
attribute "cleared". You could even specify levels of users who are allowed 
to see the balances under certain amount; not above that. In case of 
character values; it's even simpler; just mask it by some value such 
as "", or "NOT CLEARED TO SEE".
> 
> All the users are granted select privileges on the view, not the table. 
The context setting procedure

column level privilege - resolved

2003-08-26 Thread rahul

Arun, thanks for suggesting this, this is what i did.

1. created a table to store table names associated column names
and a "security level" for a that column

EMP emp_name 3
EMP emp_sal  5

2. then i granted every users a security level also,

3. then i created a view on the name table

select decode(sec_func('EMP','EMP_NAME'),1,emp_name,'x' emp_name),
decode(sec_func('EMP','EMP_SAL'),1,emp_sal,0 emp_sal)

the sec_func is passed table name and the column name and it checks the
security_level of that column againet the security level of the user 
quering the table. if the security level is equal or lower, then 1 is 
returned, else 0 is returned, and the decode in the view will do the rest

this way i can show/hide columns based on the security level (or roles 
granted to users) ... 

ok, i have only tested it, not implemented it, will it work in a real 
application environment ? has anyone used this type of column privs ? 

-TIA


=
On Sun, 24 Aug 2003 16:24:36 -0800, "Arup Nanda" <[EMAIL PROTECTED]> 
wrote :

> This is a multi-part message in MIME format.
> 
> 
> Rahul,
> 
> I'm not sure if this is too late; but here is a strategy you could follow 
to achieve what you want. True, VPD does not have a mechanism to suppress 
columns; and using a view for each user is impractical. Someday, I hope, 
VPD will have that capability; but until then you could try the following. 
> 
> Suppose you have a table called SAVINGS, for savings account holders as 
follows:
> 
> ACCTNO NUMBER
> CLEARED_BALANCENUMBER
> UNCLEARED_BALANCE  NUMBER
> 
> The records in the table are as follows:
> 
> ACCTNO CLEARED_BALANCE UNCLEARED_BALANCE
> -- --- -
>  11000  1100
>  21100  1200
>  31300  1500
> 
> Cleared balance is the amount the the customer can draw from the bank. If 
there are checks outstanding, the balance is shown in uncleared. Let's 
start with a simple example - you have users who are allowed to see the 
uncleared balance of the customers and the others are not. Intead of hiding 
the column completely, which how VPD operates, you would want to show then 
as zero, if not authorized to see that; otherwise the actual value is shown.
> 
> You would create a context as follows:
> 
> create context sec_ctx using sec_ctx_pkg;
> 
> The trusted function can be created as:
> 
>  create procedure sec_ctx_pkg
>  (
>  p_attribute_name in varchar2,
>  p_attribute_value in varchar2
>  ) is
>  begin
>  dbms_session.set_context(
> 'sec_ctx',
>  p_attribute_name,
>  p_attribute_value);
>  end;
>  /
> 
> In the after-login trigger, you would set the context value automatically 
for user using 
> 
> set_Ctx_pkg ('cleared', 'yes'); or set_Ctx_pkg ('cleared', 'no'); 
depending on whether the user is cleared to see the balance or not. In real 
life, you may have a table that lists all users and whether or not they are 
cleared. The after-logon trigger could read that table and set the context 
attribute properly.
> 
> Next, you would craete a view. 
> 
> create or replace view vw_savings
> as
> select acctno, cleared_balance,
> decode(sys_context('sec_ctx','cleared'),'yes',
> uncleared_balance, 0) uncleared_balance
> from savings
> /
> 
> Note: there is only ONE view, not one per user. Regardless of how many 
users you have, there will be only one view.
> 
> Now to test the setup. Assume user RAHUL is allowed to see the 
uncleared_balance. The after-logon trigger will set the context 
attribute "cleared" to "yes" when the user logs in. When the user selects:
> 
> select * from vw_savings;
> 
> He sees:
> 
>ACCTNO CLEARED_BALANCE UNCLEARED_BALANCE
> - --- -
> 11000  1100
> 21100  1200
> 31300  1500
> 
> Which is the correct value. Now, user ARUP logs in, who does not have the 
authority to see the uncleared balance. The logon trigger will set the 
attribute to "no" and the same select will now produce:
> 
> ACCTNO CLEARED_BALANCE UNCLEARED_BALANCE
> -- --- -
>  11000 0
>  21100 0
>  31300 0
> 
> Note: How the uncleared balance is 0. 
> 
> This model can be extended to any column and any number of values for the 
attribute "cleared". You could even specify levels of users who are allowed 
to see the balances under certain amount; not above that. In case of 
character values; it's even simpler; just mask it by some value such 
as "", or "NOT CLEARED TO SEE".
> 
> All the users are granted select privileges on the view, not the table. 
The context setting procedure

OT: More on Uday & Qusay

2003-08-26 Thread Wolfe Stephen S GS-11 6 MDSS/SGSI

Now that Uday and Qusay have been eliminated, a lot of the lesser-known 
family members are coming to the attention of American authorities.

Among the brothers:

Sooflay ..the restaurateur

Guday... the half-Australian brother

Huray the sports fanatic

Bejay..the gay brother

Kuntay and Kintay.the twins from the African mother

Sayhaythe baseball player

Ojaythe stalker / murderer

Gulay..the singer / entertainer

Ebay...the internet czar

Biliray..the country music star

Ecksray...the radiologist

Puray...the blender factory owner

Regay..the half-Jamaican brother

Tupay..the one with bad hair:



Among the sisters:


Pusay...the 'loose' 22 yr old

Lattaythe coffee shop owner

Bufay.the 300 pound sister

Dushay..the clean sister

Phayray.the zoo worker in the gorilla house:

Sapheway..the grocery store owner:

Ollay..the half-mexican sister:

Gudlaythe prostitute:



More will no doubt be discovered


v/r

Stephen S. Wolfe, GS-11, DAFC
Data Services Manager
[EMAIL PROTECTED]
(813) 827-9974  DSN 651-9974

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Wolfe Stephen S GS-11 6 MDSS/SGSI
  INET: [EMAIL PROTECTED]

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

2003-08-26 Thread Ruth Gramolini

Title: Message



What 
was the final outcome?  
 
Thanks,
Ruth

  -Original Message-From: [EMAIL PROTECTED] 
  [mailto:[EMAIL PROTECTED]On Behalf Of Tanel PoderSent: 
  Monday, August 25, 2003 9:19 PMTo: Multiple recipients of list 
  ORACLE-LSubject: Re: new server + RAID = ???
  I thought the BANRD was over, after successfully 
  completed the battle against non-redundant disks?
   
  Tanel.
  
- Original Message - 
From: 
Binley 
Lim 
To: Multiple recipients of list ORACLE-L 

Sent: Tuesday, August 26, 2003 2:59 
AM
Subject: Re: new server + RAID = 
???

Since the DB is 40GB, one 70GB drive will do. 
All the OS, Oracle binaries as well as the DB should fit in nicely. And no 
BAARF problems either ;-)

  - Original Message - 
  From: 
  Matthew 
  Zito 
  To: Multiple recipients of list 
  ORACLE-L 
  Sent: Tuesday, August 26, 2003 10:29 
  AM
  Subject: RE: new server + RAID = 
  ???
  
   
  What type of storage?  How much? 
   
  Matt
  --Matthew ZitoGridApp SystemsEmail: [EMAIL PROTECTED]Cell: 
  646-220-3551Phone: 212-358-8211 x 359http://www.gridapp.com 
  

-Original Message-From: [EMAIL PROTECTED] 
[mailto:[EMAIL PROTECTED] On Behalf Of Fedock, John 
(KAM.RHQ)Sent: Monday, August 25, 2003 5:25 PMTo: 
Multiple recipients of list ORACLE-LSubject: new server + 
RAID = ???
I know this 
topic is brought up often (BAARF, I believe) . but I just found out 
we have a new server arriving, and I have the luxury of setting up the 
database from scratch.  I never had the chance to offer input into 
the disk layouts, so can anyone point out some white papers or offer any 
other advice?
 
This will be 
an HP-UX 11i o/s, database will need to be 8.1.7.4 due to some 
application limitations.  I would classify it as more batch than 
OLTP and will start out around 40GB.
 
TIA.
 
John
 
 
John Fedock "K" Line America, 
Inc. www.kline.com  * [EMAIL PROTECTED]

RE: Query results to .csv

2003-08-26 Thread DENNIS WILLIAMS

Taniel, Binley
   Thanks for the excellent suggestions.
   At this point we have been testing with two smaller test systems, moving
a single table at a time, but initial indications are that the performance
order is:
1. Perl dump to CSV / ftp / SQL*Loader
2. Copy across database link
3. Export/ ftp / import

I need to re-run the tests once the target production system is available to
re-confirm which is faster. I am pretty confident in the ability to run
multiple SQL*Loader and import sessions simultaneously. I am a little
nervous about the ability of the database link to scale to enough
simultaneous sessions to keep the RAID sets maxed out on the target system.
Several years ago when I was doing a large conversion I hit that limit. Some
days I wonder if we are the beneficiary or victim of our prior experience.
Oh well thanks for all the good suggestions, on to testing, testing,
testing.

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


-Original Message-
Sent: Monday, August 25, 2003 7:09 PM
To: Multiple recipients of list ORACLE-L


Hi!

What about several insert /*+ APPEND NOLOGGING */ commands over database
link run in parallel? (Possibly over dedicated network). This is fast and is
easier (in case you don't hit any compatibility problems). If you happen to
be running on Windows for some reason, you could try to use named pipes
network protocol instead of TCP as well.

Tanel.

- Original Message - 
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Monday, August 25, 2003 11:04 PM


> Thanks Tanel
>   We will undoubtedly use export/import for the many small tables. We are
> looking for alternatives that will perform even faster. The insert phase
> seems to be the slowest part, and that is where SQL*Loader in direct path
> really shines. Now the next issue is how to produce a CSV file as fast as
> possible, and so far it looks like Jared's Perl program is the clear
winner.
>
> Dennis Williams
> DBA, 80%OCP, 100% DBA
> Lifetouch, Inc.
> [EMAIL PROTECTED]
>
>
> -Original Message-
> Sent: Monday, August 25, 2003 1:05 PM
> To: Multiple recipients of list ORACLE-L
>
>
> Hi!
>
> Spooling from sqlplus is VERY slow.
> Is the source database Oracle? Then use export/import
> If not, is there an ODBC driver for source database? Then use Oracle
> heterogenous services and do your transfer directly, without any
> intermediate files.
> Or use some very expensive software for doing this simple job...
>
> Tanel.
> P.S. if you definitely want to spool to textfile fast, Sparky could be
what
> you want...
>
> - Original Message - 
> To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
> Sent: Monday, August 25, 2003 7:24 PM
>
>
> > Jared - Thanks for posting this. At the moment, we are preparing to move
> > large database to a new server. Based on the advice you posted several
> > months ago, we have been testing SQL*Loader and as you predicted, it is

> > indeed fast. But also as you predicted, using SQL*Plus to create a CSV
> isn't
> > very fast. Am I correct in assuming the dump.sql will not be the best
> choice
> > for large tables? We are installing perl since you mentioned that would
> > probably be much faster.
> >
> > Dennis Williams
> > DBA, 80%OCP, 100% DBA
> > Lifetouch, Inc.
> > [EMAIL PROTECTED]
> >
> >
> > -Original Message-
> > Sent: Monday, August 25, 2003 9:40 AM
> > To: Multiple recipients of list ORACLE-L
> >
> >
> > http://www.cybcon.com/~jkstill/util/dump/dump.html
> >
> > On Mon, 2003-08-25 at 05:39, Imran Ashraf wrote:
> > > Hi,
> > >
> > > Whats the best way to write the results of a SQL query to a CSV file?
> > >
> > > Thanks.
> > >
> > > _
> > > Hotmail messages direct to your mobile phone
> > http://www.msn.co.uk/msnmobile
> > >
> > > -- 
> > > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > > -- 
> > > Author: Imran Ashraf
> > >   INET: [EMAIL PROTECTED]
> > >
> > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> > > San Diego, California-- Mailing list and web hosting services
> > > -
> > > To REMOVE yourself from this mailing list, send an E-Mail message
> > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> > > the message BODY, include a line containing: UNSUB ORACLE-L
> > > (or the name of mailing list you want to be removed from).  You may
> > > also send the HELP command for other information (like subscribing).
> > >
> >
> >
> > -- 
> > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > -- 
> > Author: Jared Still
> >   INET: [EMAIL PROTECTED]
> >
> > Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> > San Diego, California-- Mailing list and web hosting services
> > -
> > To REMOVE yourself fro

Re: optimizer_max_permutations

Title: Message



Hi!
 
Increasing it from it's default won't probaly 
help to get a better execution plan, unless you have 10-way or even more 
complex joins.
However, having a large value of this parameter 
with complex joins can push your parse times (QEP calculations) very 
high!
That's why one has to reduce it from 8 to 2000 
in latest Oracle Apps versions for example.
 
And reducing it in 
regular apps with not-so-complex joins won't kill either, because a 7-way join 
can be evaluated in 7! = 5040 permutations and Oracle uses several optimization 
mechanisms such QEP early elimination, join order intermediate cutoffs, putting 
cartesian joins last in evaluation sequence if there's more tables in join 
than specified by _optimizer_search_limit parameter, etc..
 
I'd say you definitely get the best plan (in CBO 
sense) with optimizer_max_permutations when doint 8-way joins, you probably get 
the best plan even with 9-way joins, and you get near-the-best plan with higher, 
10-12 ones too, thanks to internal optimizations in finding the optimal 
plan.
 
Tanel.

  - Original Message - 
  From: 
  Boivin, Patrice J 
  To: Multiple recipients of list ORACLE-L 
  
  Sent: Tuesday, August 26, 2003 3:44 
  PM
  Subject: optimizer_max_permutations
  
  Has 
  anyone worked with this one?
   
  http://download-west.oracle.com/docs/cd/A87860_01/doc/server.817/a76961/ch1123.htm#81357
   
  Patrice.

RE: Resolved - Row level security and latch waits

Title: RE: Resolved -  Row level security and latch waits





Everyone was right ... RTFM and STFW and listening to people on this list always helps.


We are making a better effort with design of the contexts. The developers have been redirected to appropriate sections on the FM.

Raj

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



-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, August 26, 2003 10:09 AM
To: Multiple recipients of list ORACLE-L
Subject: Re: Resolved - Row level security and latch waits



ah so i was right? wow... with all those posts. I figured i had been mistaken. 
> 
> From: "Jamadagni, Rajendra" <[EMAIL PROTECTED]>
> Date: 2003/08/26 Tue AM 09:49:34 EDT
> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> Subject: Resolved -  Row level security and latch waits
> 
> Thanks everyone for your input, the development email is rewriting their
> code using application contexts.
> 
> your help is greatly appreciated.
> Raj



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

RE: Query results to .csv

2003-08-26 Thread DENNIS WILLIAMS

John - Thanks for the heads-up. My intention is to truncate all tables on
the target system beforehand, so that should reset the HWM. Then I have a
lot of tables to load, so my plan is to load multiple tables simultaneously,
trying for separate RAID sets, but use only a single insert on an individual
table.

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


-Original Message-
Sent: Monday, August 25, 2003 7:54 PM
To: Multiple recipients of list ORACLE-L


One caveat strikes my mind when considering Direct Load... Due to the fact
that the buffer is constructed and written directly, the kernel can perform
INSERTs only *above* the HWM. If the rate at which you perform Direct
INSERTs is high (i.e. multiple runs in a day), then you may have an
artificially large segment, most of which is empty. And your FTS will be
reaching farther and farther... The situation can be compounded by parallel
INSERT where you might acquire different 'start-to-insert' points in
parallel.

All this is from memory - I think it is mentioned in the Concepts/Admin
manual for Direct INSERT - and I might be wrong. Just cross-check this out
before implementing...

John Kanagaraj

-Original Message-
Sent: Monday, August 25, 2003 5:09 PM
To: Multiple recipients of list ORACLE-L

Hi!

What about several insert /*+ APPEND NOLOGGING */ commands over database
link run in parallel? (Possibly over dedicated network). This is fast and is
easier (in case you don't hit any compatibility problems). If you happen to
be running on Windows for some reason, you could try to use named pipes
network protocol instead of TCP as well.

Tanel.

- Original Message - 
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Monday, August 25, 2003 11:04 PM


> Thanks Tanel
>   We will undoubtedly use export/import for the many small tables. We are
> looking for alternatives that will perform even faster. The insert phase
> seems to be the slowest part, and that is where SQL*Loader in direct path
> really shines. Now the next issue is how to produce a CSV file as fast as
> possible, and so far it looks like Jared's Perl program is the clear
winner.
>
> Dennis Williams
> DBA, 80%OCP, 100% DBA
> Lifetouch, Inc.
> [EMAIL PROTECTED]
>
>
> -Original Message-
> Sent: Monday, August 25, 2003 1:05 PM
> To: Multiple recipients of list ORACLE-L
>
>
> Hi!
>
> Spooling from sqlplus is VERY slow.
> Is the source database Oracle? Then use export/import
> If not, is there an ODBC driver for source database? Then use Oracle
> heterogenous services and do your transfer directly, without any
> intermediate files.
> Or use some very expensive software for doing this simple job...
>
> Tanel.
> P.S. if you definitely want to spool to textfile fast, Sparky could be
what
> you want...
>
> - Original Message - 
> To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
> Sent: Monday, August 25, 2003 7:24 PM
>
>
> > Jared - Thanks for posting this. At the moment, we are preparing to move
> > large database to a new server. Based on the advice you posted several
> > months ago, we have been testing SQL*Loader and as you predicted, it is

> > indeed fast. But also as you predicted, using SQL*Plus to create a CSV
> isn't
> > very fast. Am I correct in assuming the dump.sql will not be the best
> choice
> > for large tables? We are installing perl since you mentioned that would
> > probably be much faster.
> >
> > Dennis Williams
> > DBA, 80%OCP, 100% DBA
> > Lifetouch, Inc.
> > [EMAIL PROTECTED]
> >
> >
> > -Original Message-
> > Sent: Monday, August 25, 2003 9:40 AM
> > To: Multiple recipients of list ORACLE-L
> >
> >
> > http://www.cybcon.com/~jkstill/util/dump/dump.html
> >
> > On Mon, 2003-08-25 at 05:39, Imran Ashraf wrote:
> > > Hi,
> > >
> > > Whats the best way to write the results of a SQL query to a CSV file?
> > >
> > > Thanks.
> > >
> > > _
> > > Hotmail messages direct to your mobile phone
> > http://www.msn.co.uk/msnmobile
> > >
> > > -- 
> > > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > > -- 
> > > Author: Imran Ashraf
> > >   INET: [EMAIL PROTECTED]
> > >
> > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> > > San Diego, California-- Mailing list and web hosting services
> > > -
> > > To REMOVE yourself from this mailing list, send an E-Mail message
> > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> > > the message BODY, include a line containing: UNSUB ORACLE-L
> > > (or the name of mailing list you want to be removed from).  You may
> > > also send the HELP command for other information (like subscribing).
> > >
> >
> >
> > -- 
> > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > -- 
> > Author: Jared Still
> >   INET: [EMAIL PROTECTED]
> >
> > Fat City Network Servi

RE: virus info

Title: Message



So 
far, I've had only 2. Everybody hates me and that's the way it should be for a 
real DBA. Makes me all
warm 
and fuzzy inside.
 
 
--Mladen GogalaOracle DBA 

  
  -Original Message-From: 
  [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of April 
  WellsSent: Tuesday, August 26, 2003 9:29 AMTo: Multiple 
  recipients of list ORACLE-LSubject: RE: virus 
  info
  50?  They like me more... I had 250 between Friday at 2 
  pm and Monday at 6 am.  Several appear to have even gotten through our 
  virus scan and come to my mail box as complete attachments.  
  Gives you a warm fuzzy feeling 
  April Wells Oracle DBA/Oracle Apps 
  DBA Corporate Systems Amarillo 
  Texas 
  Few people really enjoy the simple pleasure of flying a 
  kite Adam Wells age 11 
  -Original Message- From: Joe 
  Testa [mailto:[EMAIL PROTECTED]] 
  Sent: Tuesday, August 26, 2003 8:19 AM To: Multiple recipients of list ORACLE-L Subject: virus info 
  If nothing else, i'm getting about 50/day which means i must 
  be on a boatload of address books, "they like me, they 
  really like me", 
  bwahahahahaha. 
  joe 
  -- Joseph S Testa Chief Technology Officer Data Management 
  Consulting p: 614-791-9000 f: 
  614-791-9001 
  -- Please see the official ORACLE-L 
  FAQ: http://www.orafaq.net -- 
  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). 
  


  The information contained in this communication, including attachments, is strictly 
confidential and for the intended use of the addressee only; it may also contain 
proprietary, price sensitive, or legally privileged information. Notice is hereby given that 
any disclosure, distribution, dissemination, use, or copying of the information by anyone 
other than the intended recipient is strictly prohibited and may be illegal. If you have 
received this communication in error, please notify the sender immediately by reply e-mail, 
delete this communication, and destroy all copies.
 

Corporate Systems, Inc. has taken reasonable precautions to ensure that any attachment to 
this e-mail has been swept for viruses. We specifically disclaim all liability and will 
accept no responsibility for any damage sustained as a result of software viruses and advise 
you to carry out your own virus checks before opening any attachment.

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

RE: Re: OT - Linux books ??

2003-08-26 Thread Kevin Toepke

Solaris simply requires you to quote your translates
tr '[A-B]' '[a-b]' 

-Original Message-
Sent: Tuesday, August 26, 2003 10:10 AM
To: Multiple recipients of list ORACLE-L


what got me for about 2 hours recently was the standard:

tr [A-B] [a-b],(it just means make everything upper case, now lower cass,
its a LOWER function in SQL) thats even in the oreilly korn shell book.

no solaris has to get cute and make you do:

tr [:upper:] {:lower:]

what i mean by that is such things as monitoring I/O, etc... Systems Admin
and DBA work overlaps. is it alot different on different unix systems? 
> 
> From: Joe Testa <[EMAIL PROTECTED]>
> Date: 2003/08/26 Tue AM 09:44:33 EDT
> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> Subject: Re: OT - Linux books ??
> 
> administering oracle is not really an issue cause sql*plus is sql*plus 
> regardless, now from the OS side, Solaris can be a pain to bring scripts 
> from other *nixes over to the sun world.  I've written scripts that work 
> flawlessly on linux, port to HP, port to AIX all w/NO changes, move to 
> sun and have to tweak things.
> 
> and ONLY sun put oratab in /var/opt/oracle instead of /etc :)
> 
> joe
> 
> 
> 
> [EMAIL PROTECTED] wrote:
> 
> >how different is it to administer oracle on different flavors of unix? Im
running into some annoying nuassances in syntax between solaris korn shell
and hp-unix korn shell. 
> >
> >is it just little syntax differences or is there alot more to it? 
> >  
> >
> >>From: Dwayne Cox <[EMAIL PROTECTED]>
> >>Date: 2003/08/26 Tue AM 08:54:29 EDT
> >>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> >>Subject: Re: OT - Linux books ??
> >>
> >>Both are good but the second on your list is particularly useful for
> >>admin work.  In my opinion, the first is more of a getting your feet wet
> >>kinda book but still useful as a reference.
> >>
> >>Dwayne
> >>
> >>
> >>Prem Khanna J wrote:
> >>
> >>
> >>>Guys,
> >>>
> >>>...thought of buying a good book for linux system administration.
> >>>i came across the books below.
> >>>which one is good ?
> >>>
> >>>1.Running Linux From O'Reilly
> >>>   - By Matt Welsh, Matthias Kalle Dalheimer, Terry Dawson, Lar Kaufman
> >>>
> >>>2.Linux Administration Handbook From Prentice Hall
> >>>   - By Evi Nemeth, Garth Snyder, Trent Hein
> >>> 
> >>>...any better suggestion Gurus ??
> >>>
> >>>TIA.
> >>>Jp.
> >>>
> >>>
> >>>  
> >>>
> >>-- 
> >>Please see the official ORACLE-L FAQ: http://www.orafaq.net
> >>-- 
> >>Author: Dwayne Cox
> >>  INET: [EMAIL PROTECTED]
> >>
> >>Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> >>San Diego, California-- Mailing list and web hosting services
> >>-
> >>To REMOVE yourself from this mailing list, send an E-Mail message
> >>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> >>the message BODY, include a line containing: UNSUB ORACLE-L
> >>(or the name of mailing list you want to be removed from).  You may
> >>also send the HELP command for other information (like subscribing).
> >>
> >>
> >>
> >
> >  
> >
> 
> -- 
> Joseph S Testa
> Chief Technology Officer 
> Data Management Consulting
> p: 614-791-9000
> f: 614-791-9001
> 
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> 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.net
-- 
Author: <[EMAIL PROTECTED]
  INET: [EMAIL PROTECTED]

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

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

RE: DBAssist hangs

Title: Message



Try 
doing strace -af -o /tmp/strace.out dbassist and see what is it waiting 
for.
 
 
--Mladen GogalaOracle DBA 

  
  -Original Message-From: 
  [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ramon 
  E. EstevezSent: Monday, August 25, 2003 9:54 PMTo: 
  Multiple recipients of list ORACLE-LSubject: DBAssist 
  hangs
  Hi list, 
  I installed 8.1.7 on RH AS 2.1, applied 8.1.7.4 
  patch, the glibc patch and when trying to create a DB dbassist hangs. 
  TIA 
  Ramon E. Estevez [EMAIL PROTECTED] 809-535-8994 
 
Note:
This message is for the named person's use only.  It may contain 
confidential, proprietary or legally privileged information.  No 
confidentiality or privilege is waived or lost by any mistransmission.  If 
you receive this message in error, please immediately delete it and all 
copies of it from your system, destroy any hard copies of it and notify the 
sender.  You must not, directly or indirectly, use, disclose, distribute, 
print, or copy any part of this message if you are not the intended 
recipient. Wang Trading 
LLC and any of its subsidiaries each reserve the right to 
monitor all e-mail communications through its networks.  Any views 
expressed in this message are those of the individual sender, except where the 
message states otherwise and the sender is authorized to state them to be the 
views of any such entity.

Re: Re: OT - Linux books ??

so different flavors of linux are more compatible? 

i thought the only two unix players out there now are HP and Solaris. who else is out 
there? 

so is going between unix flavors like going between databases? 
> 
> From: "Nuno Souto" <[EMAIL PROTECTED]>
> Date: 2003/08/26 Tue AM 09:59:33 EDT
> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> Subject: Re: Re: OT - Linux books ??
> 
> - Original Message -
> 
> > how different is it to administer oracle on different flavors of unix? Im running 
> > into some annoying nuassances in
> syntax between solaris korn shell and hp-unix korn shell.
> >
> > is it just little syntax differences or is there alot more to it?
> > >
> 
> You sure it's HP korn-shell? The default shell looks like korn,
> but it isn't.  Looks like bourne as well, but again: it isn't.
> It is indeed the Posix shell, which is about right between
> the other 2.
> 
> The only shell I've always found is reliable is the old
> bourne shell.  Just about the same everywhere. Once again,
> the default HP one is NOT the bourne shell even though it
> is called "sh".  Of course you lose the niceties of command
> history and such, but if you're writing admin scripts what
> the heck do you need history for?
> 
> Let's not touch the C-shell...
> 
> As for administration of Unix itself: yikes!  Depends
> which was the original Unix flavour: AT&T System V
> or Berkeley BSD.  SunOS was mostly BSD, Solaris got
> a lot of SystemV in it.  HP was mostly BSD, but it got
> a lot of the SV stuff into it until HP decided to become
> Posix-compliant.  Since then, it's been potluck.
> 
> This basically means that features will be very much the same
> in principle, but located in different directory structures,
> used with different utilities, and have slightly different
> parameters.
> 
> Welcome to the joys of Unix incompatibility with itself.
> No wonder people are going Linux.
> Oh!  Hang-on a tick...
> 
> Cheers
> Nuno Souto
> [EMAIL PROTECTED]
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: Nuno Souto
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> 

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

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

Re: Re: OT - Linux books ??

what got me for about 2 hours recently was the standard:

tr [A-B] [a-b],(it just means make everything upper case, now lower cass, its a LOWER 
function in SQL) thats even in the oreilly korn shell book.

no solaris has to get cute and make you do:

tr [:upper:] {:lower:]

what i mean by that is such things as monitoring I/O, etc... Systems Admin and DBA 
work overlaps. is it alot different on different unix systems? 
> 
> From: Joe Testa <[EMAIL PROTECTED]>
> Date: 2003/08/26 Tue AM 09:44:33 EDT
> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> Subject: Re: OT - Linux books ??
> 
> administering oracle is not really an issue cause sql*plus is sql*plus 
> regardless, now from the OS side, Solaris can be a pain to bring scripts 
> from other *nixes over to the sun world.  I've written scripts that work 
> flawlessly on linux, port to HP, port to AIX all w/NO changes, move to 
> sun and have to tweak things.
> 
> and ONLY sun put oratab in /var/opt/oracle instead of /etc :)
> 
> joe
> 
> 
> 
> [EMAIL PROTECTED] wrote:
> 
> >how different is it to administer oracle on different flavors of unix? Im running 
> >into some annoying nuassances in syntax between solaris korn shell and hp-unix korn 
> >shell. 
> >
> >is it just little syntax differences or is there alot more to it? 
> >  
> >
> >>From: Dwayne Cox <[EMAIL PROTECTED]>
> >>Date: 2003/08/26 Tue AM 08:54:29 EDT
> >>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> >>Subject: Re: OT - Linux books ??
> >>
> >>Both are good but the second on your list is particularly useful for
> >>admin work.  In my opinion, the first is more of a getting your feet wet
> >>kinda book but still useful as a reference.
> >>
> >>Dwayne
> >>
> >>
> >>Prem Khanna J wrote:
> >>
> >>
> >>>Guys,
> >>>
> >>>...thought of buying a good book for linux system administration.
> >>>i came across the books below.
> >>>which one is good ?
> >>>
> >>>1.Running Linux From O'Reilly
> >>>   - By Matt Welsh, Matthias Kalle Dalheimer, Terry Dawson, Lar Kaufman
> >>>
> >>>2.Linux Administration Handbook From Prentice Hall
> >>>   - By Evi Nemeth, Garth Snyder, Trent Hein
> >>> 
> >>>...any better suggestion Gurus ??
> >>>
> >>>TIA.
> >>>Jp.
> >>>
> >>>
> >>>  
> >>>
> >>-- 
> >>Please see the official ORACLE-L FAQ: http://www.orafaq.net
> >>-- 
> >>Author: Dwayne Cox
> >>  INET: [EMAIL PROTECTED]
> >>
> >>Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> >>San Diego, California-- Mailing list and web hosting services
> >>-
> >>To REMOVE yourself from this mailing list, send an E-Mail message
> >>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> >>the message BODY, include a line containing: UNSUB ORACLE-L
> >>(or the name of mailing list you want to be removed from).  You may
> >>also send the HELP command for other information (like subscribing).
> >>
> >>
> >>
> >
> >  
> >
> 
> -- 
> Joseph S Testa
> Chief Technology Officer 
> Data Management Consulting
> p: 614-791-9000
> f: 614-791-9001
> 
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> 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.net
-- 
Author: <[EMAIL PROTECTED]
  INET: [EMAIL PROTECTED]

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

Re: Resolved - Row level security and latch waits

ah so i was right? wow... with all those posts. I figured i had been mistaken. 
> 
> From: "Jamadagni, Rajendra" <[EMAIL PROTECTED]>
> Date: 2003/08/26 Tue AM 09:49:34 EDT
> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> Subject: Resolved -  Row level security and latch waits
> 
> Thanks everyone for your input, the development email is rewriting their
> code using application contexts.
> 
> your help is greatly appreciated.
> Raj
> 
> 
> Rajendra dot Jamadagni at nospamespn dot com
> All Views expressed in this email are strictly personal.
> QOTD: Any clod can have facts, having an opinion is an art !
> 
> 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
> 
> 
Title: Resolved -  Row level security and latch waits





Thanks everyone for your input, the development email is rewriting their code using application contexts.


your help is greatly appreciated.
Raj

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

Re: Re: OT - Linux books ??

2003-08-26 Thread Nuno Souto

- Original Message -

> how different is it to administer oracle on different flavors of unix? Im running 
> into some annoying nuassances in
syntax between solaris korn shell and hp-unix korn shell.
>
> is it just little syntax differences or is there alot more to it?
> >

You sure it's HP korn-shell? The default shell looks like korn,
but it isn't.  Looks like bourne as well, but again: it isn't.
It is indeed the Posix shell, which is about right between
the other 2.

The only shell I've always found is reliable is the old
bourne shell.  Just about the same everywhere. Once again,
the default HP one is NOT the bourne shell even though it
is called "sh".  Of course you lose the niceties of command
history and such, but if you're writing admin scripts what
the heck do you need history for?

Let's not touch the C-shell...

As for administration of Unix itself: yikes!  Depends
which was the original Unix flavour: AT&T System V
or Berkeley BSD.  SunOS was mostly BSD, Solaris got
a lot of SystemV in it.  HP was mostly BSD, but it got
a lot of the SV stuff into it until HP decided to become
Posix-compliant.  Since then, it's been potluck.

This basically means that features will be very much the same
in principle, but located in different directory structures,
used with different utilities, and have slightly different
parameters.

Welcome to the joys of Unix incompatibility with itself.
No wonder people are going Linux.
Oh!  Hang-on a tick...

Cheers
Nuno Souto
[EMAIL PROTECTED]

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

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

Resolved - Row level security and latch waits

Title: Resolved -  Row level security and latch waits





Thanks everyone for your input, the development email is rewriting their code using application contexts.


your help is greatly appreciated.
Raj

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



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: OT - Linux books ??

2003-08-26 Thread John Flack

Not just Sun - SCO Unixware puts it there too.

-Original Message-
Sent: Tuesday, August 26, 2003 9:45 AM
To: Multiple recipients of list ORACLE-L


administering oracle is not really an issue cause sql*plus is sql*plus 
regardless, now from the OS side, Solaris can be a pain to bring scripts 
from other *nixes over to the sun world.  I've written scripts that work 
flawlessly on linux, port to HP, port to AIX all w/NO changes, move to 
sun and have to tweak things.

and ONLY sun put oratab in /var/opt/oracle instead of /etc :)

joe

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

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

2003-08-26 Thread Brian McGraw

Wonderful.

I would like to add:  

  10.1.23.1)   After explicitly instructing them not to, have an analyst
from the other side of the world call you at home, @ 3a.m., waking up
spouse and children in the process.

Brian

-Original Message-
Tanel Poder
Sent: Monday, August 25, 2003 6:29 PM
To: Multiple recipients of list ORACLE-L

Hi!

> I don't know enough about Java, can someone describe the differences
between
> the way Tomcat works and OC4J works?

The first difference that comes into my mind is:

Tomcat:
1) you download the software
2) you install it
3) you use it


Oracle iAS
1) you download the software
2) you pay $$$ for the license
3) you try to install it
4) you fail and go to iAS administration training
5) you find out, that advanced administration is the course what you
need
6) if lucky, you can go to advanced administration as well
7) you try to install it
8) you still fail
9) you pay $$$ for support subscription
10) if [ "$your_wife_has_seen_you_home_during_last_five_days" -eq "1" ];
then
10.1)  while [
"$still_hasnt_learned_all_the_small_iAS_installation_issues" -eq "1" ];
do
10.1.1) you try to install it again
10.1.2) you fail miserably again
10.1.3) you contact support and open a TAR
10.1.4) support asks whether your computer is turned on
10.1.5) you tell #$&@!
10.1.6) another analyst from other side of the world contacts you
after
6 hours
10.1.7) he asks which version you are trying to install
10.1.8) you answer your version
10.1.9) the analyst recommends you to use the latest version of
software
10.1.10)   you go out, have a coffee and a cigarette (you gotta buy a
pack
from local store, because you don't smoke)
10.1.11)   you tell the analyst #$&@!
10.1.12)   another analyst from a country where is lunchtime when you
have
05AM digs up some notes and patches
10.1.13)   you try to understand what is meant by "clean your
environment"
in a note
10.1.14)   you fail to understand, get another coffee, go outside and
have 3
cigarettes
10.1.15)   now you don't care anymore and do exactly what is stated in
the
note (at least what you think is stated there)
10.1.16)   the may relieve your issue somewhat, but you bump to another
issue immediately
10.1.17)   you update your TAR in metalink
10.1.18)   after 2 hours an analyst replies and recommends to open
another
TAR
10.1.19) done # while
10.1.20) elsif
10.1.21)   go home
10.1.22)   open your laptop
10.1.23)   work from home
10.1.24)   next morning go back to step 10.0.0
10.1.25) fi
10.1.26) eventually you manage to install the software
10.1.27) you start using the server and find out that you have missed a
tiny
preinstall patch or note (which was released yesterday) in metalink and
have
to go back to step 10, because latter configuration changes aren't
supported
or simply don't work, ocassionally visiting step 9 as well. Going to
each of
the steps also involves a new, dynamic "X" step, which means buying a
pack
of cigarettes from whereever available. Some people even make it to
Z-point
which means cursing and yelling while typing on your keyboard with
extreme
speed.

So, IMHO, these are the minor differences between the two products.

Sincerely,
Tanel.

P.S. Women may replace "your_wife" with "your_husband" in if-construct
and
single people could replace with your_friends, your_bartender or
similar.


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

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



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

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

Onames and various connections scenarios

2003-08-26 Thread Bob Metelsky

Hello All

Im back from the trenches to post a quick request for
help

Ive setup onames on 2 servers and standard applications, (our app and
sqlplus) connect just fine, a problem situation manifests itself when:

1 users need to connect (add a database) to dba studio. They get a error
to the effect "cant resolve host name"
And the other
2. Users connect to remote databases (via vpn) that are in our onames
but many  of these vpn connections once made do not allow access to
*our* network resources.

So basically almost all of oour users have one or more of these
secenarios which means they will need to maintain a tnsnames file as
well.

I'm managing about 70+ connect discriptors And I was hoping onames
could be a centralised answer

Is this common? Or is there a workaround?

Thanks!
bob
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Bob Metelsky
  INET: [EMAIL PROTECTED]

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

Re: OT - Linux books ??

2003-08-26 Thread Joe Testa

administering oracle is not really an issue cause sql*plus is sql*plus 
regardless, now from the OS side, Solaris can be a pain to bring scripts 
from other *nixes over to the sun world.  I've written scripts that work 
flawlessly on linux, port to HP, port to AIX all w/NO changes, move to 
sun and have to tweak things.

and ONLY sun put oratab in /var/opt/oracle instead of /etc :)

joe



[EMAIL PROTECTED] wrote:

how different is it to administer oracle on different flavors of unix? Im running into some annoying nuassances in syntax between solaris korn shell and hp-unix korn shell. 

is it just little syntax differences or is there alot more to it? 
 

From: Dwayne Cox <[EMAIL PROTECTED]>
Date: 2003/08/26 Tue AM 08:54:29 EDT
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Subject: Re: OT - Linux books ??
Both are good but the second on your list is particularly useful for
admin work.  In my opinion, the first is more of a getting your feet wet
kinda book but still useful as a reference.
Dwayne

Prem Khanna J wrote:
   

Guys,

...thought of buying a good book for linux system administration.
i came across the books below.
which one is good ?
1.Running Linux From O'Reilly
- By Matt Welsh, Matthias Kalle Dalheimer, Terry Dawson, Lar Kaufman
2.Linux Administration Handbook From Prentice Hall
- By Evi Nemeth, Garth Snyder, Trent Hein
...any better suggestion Gurus ??

TIA.
Jp.
 

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

 

--
Joseph S Testa
Chief Technology Officer 
Data Management Consulting
p: 614-791-9000
f: 614-791-9001

--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
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).

RE: OT - Linux books ??

2003-08-26 Thread Talbot, Fraser

Red Hat Linux Networking and System Administration from Redhat press is
very good.

Fraser Talbot
M-I  LLC
Database Administrator
Information Technology
832.295.2245
[EMAIL PROTECTED]

-Original Message-
Sent: Tuesday, August 26, 2003 7:54 AM
To: Multiple recipients of list ORACLE-L

Both are good but the second on your list is particularly useful for
admin work.  In my opinion, the first is more of a getting your feet wet
kinda book but still useful as a reference.

Dwayne

Prem Khanna J wrote:
> Guys,
> 
> ...thought of buying a good book for linux system administration.
> i came across the books below.
> which one is good ?
> 
> 1.Running Linux From O'Reilly
>   - By Matt Welsh, Matthias Kalle Dalheimer, Terry Dawson, Lar
Kaufman
> 
> 2.Linux Administration Handbook From Prentice Hall
>   - By Evi Nemeth, Garth Snyder, Trent Hein
>  
> ...any better suggestion Gurus ??
> 
> TIA.
> Jp.
> 
> 

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

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

__
This email is intended solely for the person or entity to which it is addressed and 
may contain confidential and/or privileged information.  Copying, forwarding or 
distributing this message by persons or entities other than the addressee is 
prohibited. If you have received this email in error, please contact the sender 
immediately and delete the material from any computer.  This email may have been 
monitored for policy compliance.  [021216]

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

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

2003-08-26 Thread John Flack

Title: 8.1.7 + redhat AS 2.1 = trouble

There may be the same issues as with 8.1.7 on RH 7.1 - look on Metalink
for those work arounds and try them on your AS 2.1.
Basically, it has to do with 8.1.7 expecting the standard C libraries
from RH 6.2 which were changed for RH 7.1 and later. Red Hat included a
copy of the 6.2 libraries as one of the included rpms, but you have to make
sure that you installed them (some configurations don't install them by
default) and I seem to remember that you have to set an environment variable
(LD_LIBRARY_PATH?) to point Oracle Installer at them instead of the defaults
for later versions of Red Hat Linux. Once Oracle relinks during
installation, you're okay.
Anyway, the work arounds are well documented in Metalink, but you may
have to search by RH 7.1 rather than AS 2.1.
-Original Message-From: Adams, Matthew (GECP, MABG,
088130) [mailto:[EMAIL PROTECTED]Sent: Monday, August 25,
2003 6:00 PMTo: Multiple recipients of list
ORACLE-LSubject: 8.1.7 + redhat AS 2.1 =
trouble
Are there know binutils or other issues when installing
8.1.7 on redhat AS 2.1?
Attempts to run genclntsh keep getting
undefined references in libc.so.6?
I can't find anything on Metalink or google about
running AS 2.1 and 8.1.7 together.
Matt
Matt Adams - GE Appliances -
[EMAIL PROTECTED] Another month has ended.
All Targets Met. All Systems Working. All Customers Satisfied. All Staff Enthusiastic. All Pigs Fed And Ready To Fly.

RE: virus info

2003-08-26 Thread April Wells

Title: RE: virus info





50?  They like me more... I had 250 between Friday at 2 pm and Monday at 6 am.  Several appear to have even gotten through our virus scan and come to my mail box as complete attachments.  

Gives you a warm fuzzy feeling 


April Wells
Oracle DBA/Oracle Apps DBA
Corporate Systems
Amarillo Texas


Few people really enjoy the simple pleasure of flying a kite
Adam Wells age 11




-Original Message-
From: Joe Testa [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, August 26, 2003 8:19 AM
To: Multiple recipients of list ORACLE-L
Subject: virus info



If nothing else, i'm getting about 50/day which means i must be on a 
boatload of address books, "they like me, they really like me",


bwahahahahaha.


joe


-- 
Joseph S Testa
Chief Technology Officer 
Data Management Consulting
p: 614-791-9000
f: 614-791-9001



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
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).



The information contained in this communication, including attachments, is strictly 
confidential and for the intended use of the addressee only; it may also contain 
proprietary, price sensitive, or legally privileged information. Notice is hereby given that 
any disclosure, distribution, dissemination, use, or copying of the information by anyone 
other than the intended recipient is strictly prohibited and may be illegal. If you have 
received this communication in error, please notify the sender immediately by reply e-mail, 
delete this communication, and destroy all copies.
 

Corporate Systems, Inc. has taken reasonable precautions to ensure that any attachment to 
this e-mail has been swept for viruses. We specifically disclaim all liability and will 
accept no responsibility for any damage sustained as a result of software viruses and advise 
you to carry out your own virus checks before opening any attachment.

Re: Re: OT - Linux books ??