DBMS_JOB problem

2002-11-11 Thread mac
I have a job:
DECLARE
myjob NUMBER;
BEGIN
 dbms_job.submit(myjob,
  'FWHI.Fwh_Gen_Txt.GENALLFILES ( ''||@||'', 1 );',
SYSDATE,
   'sysdate+10*60/24*60*60');
commit;
END ;

PL/SQL procedure successfully completed

the 
job_queue_processes 4
job_queue_interval  60

If I force the execution is generating the right number of txt files, 74, if 
I wait to be triggered it generates just 8 files and it stops.
Why?

Ciprian Maftei



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

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



RE: Oracle SAN Experiences?

2002-11-11 Thread Mark Brooks
Guess I wasn't clear with my earlier post. Here is the information from the
SA's when confronted with the results of some I/O tests.

Configuration on system 1 ( poor IO performance ):

Large filesystem -- device driver -- hardware controller -- SAN
switch -- SAN Server



Configuration on system 2 ( better IO performance ):

filesystem1 -- device driver --
|
filesystem2 -- device driver   -- hardware controller -- SAN switch --
SAN Server
|
filesystem3 -- device driver --


In configuration 1 the system was bottlenecked in the device driver, the SAN
hardware was running fine.

In configuration 2 the system was able to spread IO over multiple device
drivers and gave better performance.

Hope this clears things up. Might have been a deficiency in the volume
manager software. Point I was trying to make was that when you switch to SAN
storage you still have to be aware of the limitations of the host systems IO
subsystems and look at tuning / configuration on both the SAN hardware and
your host system.


-Original Message-
Sent: Saturday, November 09, 2002 3:19 PM
To: Multiple recipients of list ORACLE-L


It would be extremely surprising if there was a static relationship between
the number of file-systems and the number of I/O controllers used by each.
Sounds more like a mis-configuration, a mis-interpretation of the symptoms,
or (most likely) a cover-up story to redirect blame.

There is no awareness of controllers or other devices (other than logical
volumes a.k.a. raw devices) in file-systems.  This is a configuration
issue for the SAN controller hardware/firmware/software, although I believe
that the Veritas VxVM software can perform dynamic multi-pathing, so it
could be performed at the LVM (logical volume manager) layer as well...

Load-balancing and failover amongst I/O controller devices is common in SAN
environments.  It doesn't make sense to allow $200.00 controller cards to be
either a bottleneck or a single-point-of-failure in an I/O subsystem costing
millions of dollars...

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


One observation I have made at sites running SAN storage for Oracle is a
tendency for the SA's to present the disk to the database server as a small
number of large filesystems. On some OS platforms this can create a
bottleneck on the host as all data to this large filesystem is routed
through a single device driver. Solution is to present more filesystems and
therefore have more channels from the OS perspective to access the disk.
-Original Message-
Sent: Friday, November 08, 2002 6:59 AM
To: Multiple recipients of list ORACLE-L


The Sys. Admin. team wants to consolidate storage (and probably get a new
toy too) on all of our servers, so they are evaluating a SAN (LSI  Logic
E4600).  The DBA team is doing some research to determine the pros and cons
of doing this, and I’d like to hear any of your experiences (good and bad)
using SAN with Oracle.

My understanding is that all of our database servers would remain intact,
but the attached disk storage would move into the SAN.  So, we still have
the Production, Test, and App. servers with their processors and memory,
Oracle homes, etc.  The SAN will hold database files from Production, Test,
Apps., staging, ODS,data warehouse, etc.

Their arguments:
-the SAN is very scalable (500 GB – 40 TB)
-easy to manage disks in one central location
-fancy statistics collection on all SAN disks
-much higher throughput on the fiber SAN connections than with locally
attached disk arrays
-capable of using mixed RAID levels (0, 1, 1+0, 5, etc.)
-can partition sets of disks in the SAN for specific server access
-Snapshot backup capability is very fast in the SAN (much faster than
traditional Oracle backups)

DBA arguments:
-How will this affect database performance?
-What are the drawbacks, if any, with the pre-fetch of data performed by the
SAN (i.e., SAN cache)
-How tunable is the SAN
-Fast, small disks are better for performance and less wasted space than the
typical huge disks in a SAN (it’s possible to use smaller disks in the SAN)
-Prove it!


After reading the “Sane SAN” article and a case study about Volvo
implementing a SAN, I believe it’s possible to have a great Oracle/SAN
implementation if it’s setup correctly and tuned.  Other resources that you
can Google are “Using SVA SnapShot with Oracle”, “Performance Benchmark LSI
Logic E4600 (STK D178)”, “SAN Storage for Open Systems Environments”, and of
course check the OraFaq.

Thanks for sharing,

David Wagoner
Oracle DBA





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

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

ORACLE QUERY

2002-11-11 Thread Savita


Hi All,
I want to know about one query.
I have two views and I want to get the sum of count of two view ex
I have a query like
select record_identifier from records where
rownum(40-(select count(*) from customer_view+select count(*) from
unit_view));
But this is not working in oracle.
Is there any other way to do this without writing a function
--
Best Regards
- Savita

Hewlett Packard (India)
+91 80 2051288 (Phone)
847 1288 (HP Telnet)




sqlplus ~no~output

2002-11-11 Thread Markham, Richard
Title: sqlplus ~no~output





for the sake of select * against a pinned table I want row output totally turned off.
in the past I thought set serveroutput off, set termout off, set pagesize 0 was
sufficient, but its still dumping row data on me. What have I forgotten ?


TIA





RE: SQL loader

2002-11-11 Thread John . Hallas
Hello Nirmal,
The FILLER command is available in sqlloader to allow you to miss a field
out
something like 
LOAD
(field 1 ...
field2 ...
dum_rec FILLER,
field3
) 
may work but I am not sure that this will work in  7.3 of Oracle as I think
FILLER came out in 8.0x

However an easy way ( I was going to say  the easiest but I figured someone
would send in a 1 character script to achieve the same thing)
is to use awk to concatanate the fields as in the following example
cat j.txt
a  ccc 
cat j.txt | awk '{print $1,$2 $3,$4 }' 
a ccc 
 
I think that gives you what you want and you just use your loader routine
to load the amended data

HTH

John


-Original Message-
Sent: 10 November 2002 07:33
To: Multiple recipients of list ORACLE-L


Hi list,

LOAD DATA
INFILE 'c:\temp\file2.csv' 
APPEND
INTO TABLE  dc_temp1
FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY ''
(
name, old_po_box, dn, gsm, nregc,
cr_no, new_po_box , remark, ncli)

The above is my control file for loading data.

i need to refer the two columns of data from the datafile
'c:\temp\file2.csv' 
should go into one column(remark) of my table.

Oracle7.3.1. Any ideas pls.

Thanks.
Nirmal.


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

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

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



Re: Adding more space to server

2002-11-11 Thread Yechiel Adar
Title: Adding more space to server



Is the server dedicated to Oracle data files or you 
have more data in it.
We have for each server a lot of data that was loaded in 
the database 
+ a daily export.

I saved a lot of space by compressing the folders for the 
data and the export.

Yechiel AdarMehish

  - Original Message - 
  From: 
  Hussain Ahmed 
  Qadri 
  To: Multiple recipients of list ORACLE-L 
  Sent: Sunday, November 10, 2002 7:03 
  AM
  Subject: Adding more space to 
server
  
  Hi all, We are running out of space on 
  our server and I was going to add another hard disk to it. I had thought about 
  somewhat crude but easy way to go about it. Since I can afford to shutdown my 
  database for a couple of hours tomorrow, I thought that I would shutdown the 
  database, move some datafiles to other partitions, redefine the partitions as 
  to increase their size (WinNT 4 and Oracle 8i) and then move back the 
  datafiles and then start the database. This way I would have more space to 
  accommodate any increase in size of the datafiles and not worry about changing 
  any of the database complexities (plus more space for the archives generated, 
  as the database is in archive mode). Neither the control file nor any of the 
  parameters would have to be changed as no change in location took place. Is 
  there anything wrong in this method? What could be the other options, if any? 
  Anything else that I need to keep in mind? 
  Thanks and regards, 
  Hussain Ahmed Qadri DBA 
  SKMCHRC 


Re: Changing column format

2002-11-11 Thread Yechiel Adar
You do not need to change the primary key unless different user names can
have the same userid.
Just add a unique + not null constraint on the user name column.

Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, November 07, 2002 10:33 PM


 I create a table to store user account information and set userid column
 to be primary key.  I now want to set username to be primary key instead
 of userid, how do I change it?  There are couple hundreds of records in
 table.  Please advise.

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

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

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

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



Re: sqlplus ~no~output

2002-11-11 Thread Stephane Faroult
 Markham, Richard wrote:
 
 for the sake of select * against a pinned table I want row output
 totally turned off.
 in the past I thought set serveroutput off, set termout off, set
 pagesize 0 was
 sufficient, but its still dumping row data on me.  What have I
 forgotten ?
 
 TIA

spool.

-- 
Regards,

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

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



RE: ORACLE QUERY

2002-11-11 Thread Nirmal Kumar Muthu Kumaran



select 
record_identifier from records where rownum(
select 40-count(*) 
from
(select1 from 
customer_view
union all
select2 from unit_view)
); 

Just a thought, 
HTH.

Nirmal.

  -Original Message-From: Savita 
  [mailto:[EMAIL PROTECTED]]Sent: Monday, November 11, 2002 11:13 
  AMTo: Multiple recipients of list ORACLE-LSubject: 
  ORACLE QUERYHi All, 
  I want to know about one query. 
  I have two views and I want to get the sum of count of two view ex I 
  have a query like 
  select record_identifier from records where 
  rownum(40-(select count(*) from customer_view+select count(*) 
  from unit_view)); 
  But this is not working in oracle. 
  Is there any other way to do this without writing a function -- 
  Best Regards - Savita 
   Hewlett Packard 
  (India) +91 80 2051288 (Phone) 847 1288 (HP Telnet) 
    



Re: Oracle 10i new releases

2002-11-11 Thread Nicolai Tufar
I used Oracle V3 on an old Unisys x86-based server.
When I said that to a local Oracle representative he
did not believe that.

So, did anyone use V2 on this list? If so do you
still have the tapes and is there a
way to revive this beast on a PDP-11 emulator?




- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Saturday, November 09, 2002 2:03 AM


 i did use some version 5 on 386 PC :)

 joe


 John Kanagaraj wrote:

 Move over Joe and Tim. I used 5.1.17 on a propreitary *nix box way back
in
 '89! I do know there are a few on this list that do go back farther than
 that!
 
 John
 
 
 
 -Original Message-
 From: Johnston, Tim [mailto:TJohnston;quallaby.com]
 Sent: Friday, November 08, 2002 2:49 PM
 To: Multiple recipients of list ORACLE-L
 Subject: RE: Oracle 10i new releases
 
 
 Oh...  I'm sure they are many other who back farther then
 that...  But, I do
 remember 6.0.36...  As a matter of fact it was 6.0.36.1.53 on
 IBM VM...  Ah
 the memories...
 
 Tim
 
 -Original Message-
 Sent: Friday, November 08, 2002 4:04 PM
 To: Multiple recipients of list ORACLE-L
 
 
 anyone remember the 6 days, 6.0.36 on sunos :)
 
 joe
 
 
 

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

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


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

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



Oracle daylight saving

2002-11-11 Thread John Dunn
How does Oracle handle daylight saving time changes. presumably it gets its
time from the OS?

John



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

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



RE: Oracle daylight saving

2002-11-11 Thread DENNIS WILLIAMS
John
   Yep, Oracle gets whatever the server has. Under Oracle9i, the new time
zone features offer more possibilities to consider.

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


-Original Message-
Sent: Monday, November 11, 2002 6:59 AM
To: Multiple recipients of list ORACLE-L


How does Oracle handle daylight saving time changes. presumably it gets its
time from the OS?

John



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

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

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



Re: Oracle 10i new releases

2002-11-11 Thread M Rafiq
Wow! I used Version 4  5  under Dos(286 and 386) and Ver 5 under Xenix
with 386(16 Mhz). All with 4MB ram...Basically we developed Fianacial 
Accounting package using Sqlplus, Sqlforms and sql Report(rpt). It was 1988.

Regards
Rafiq











Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Date: Mon, 11 Nov 2002 02:58:25 -0800

I used Oracle V3 on an old Unisys x86-based server.
When I said that to a local Oracle representative he
did not believe that.

So, did anyone use V2 on this list? If so do you
still have the tapes and is there a
way to revive this beast on a PDP-11 emulator?




- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Saturday, November 09, 2002 2:03 AM


 i did use some version 5 on 386 PC :)

 joe


 John Kanagaraj wrote:

 Move over Joe and Tim. I used 5.1.17 on a propreitary *nix box way back
in
 '89! I do know there are a few on this list that do go back farther than
 that!
 
 John
 
 
 
 -Original Message-
 From: Johnston, Tim [mailto:TJohnston;quallaby.com]
 Sent: Friday, November 08, 2002 2:49 PM
 To: Multiple recipients of list ORACLE-L
 Subject: RE: Oracle 10i new releases
 
 
 Oh...  I'm sure they are many other who back farther then
 that...  But, I do
 remember 6.0.36...  As a matter of fact it was 6.0.36.1.53 on
 IBM VM...  Ah
 the memories...
 
 Tim
 
 -Original Message-
 Sent: Friday, November 08, 2002 4:04 PM
 To: Multiple recipients of list ORACLE-L
 
 
 anyone remember the 6 days, 6.0.36 on sunos :)
 
 joe
 
 
 

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

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


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

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


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

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

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


RE: Oracle 10i new releases

2002-11-11 Thread Gogala, Mladen
I remember Oracle 4 on 3 5.25 floppies on a PC/XT with 640kb RAM
(who would ever need more then that?). It had UFI, RPT/RPF,
IAP/IAG (no IAD) and a utility called oralink which was supposed to
function like SQL*Net, but I couldn't get it to work. Oracle 5
was on a decent machine (mVAX 3900 with incredible 16M RAM) and VMS 4.7
(the last one with NULL.COM and NULL process). It was all happening  in 
the late jurassic, anno domini 1988.

 -Original Message-
 From: MacGregor, Ian A. [mailto:ian;SLAC.Stanford.EDU]
 Sent: Friday, November 08, 2002 7:28 PM
 To: Multiple recipients of list ORACLE-L
 Subject: RE: Oracle 10i new releases
 
 
 Ha I remember Oracle 5 on VM.  Ah the joys of minidisks.  I 
 started with Oracle on VMS in 1984, but I cannot recall the 
 exact version.  BI files, IOR, UFI, RPT and RPF,  IAP and IAG 
 when IAP was completely text driven.  I was Dba'ing before 
 there was SQL*NET.  
 
 Back in those days one was the DBA, the developer etc.  The 
 advantage was one fixed one's own mistakes.  Sometimes People 
 query, How did you know what happened?, they think I'm a 
 genius. Little do they know, they made the same blunder I did 
 in 1986. 
 
 Ian MacGregor
 Stanford Linear Accelerator Center
 [EMAIL PROTECTED] 
 
 
 
 -Original Message-
 Sent: Friday, November 08, 2002 2:49 PM
 To: Multiple recipients of list ORACLE-L
 
 
 Oh...  I'm sure they are many other who back farther then 
 that...  But, I do remember 6.0.36...  As a matter of fact it 
 was 6.0.36.1.53 on IBM VM...  Ah the memories...
 
 Tim
 
 -Original Message-
 Sent: Friday, November 08, 2002 4:04 PM
 To: Multiple recipients of list ORACLE-L
 
 
 anyone remember the 6 days, 6.0.36 on sunos :)
 
 joe
 
 
 Mercadante, Thomas F wrote:
 
 Robert,
 
 I guess what you say makes sense.  But why the need to move 
 the release 
 level from 8, to 8i, to 9i to 10i all within 5 years?  
 Granted, there 
 were huge improvements from 8 to 9i.  I guess what I'm 
 arguing for is - 
 lets
 stay
 at 9i for awhile.  There is nothing wrong with 9i release 1 
 thru 15.  
 Are the new features that will be available in 10i really 
 that radical 
 that justifies a major release?  Give the rest of us a 
 chance to catch 
 up to 9i.
 
 
 My feeling is that Oracle will get hurt sooner or later - 
 people will 
 just plain not move to the newer release, just to face 
 migrating again 
 in just a few months.  Makes no sense to me.
 
 Tom Mercadante
 Oracle Certified Professional
 
 
 -Original Message-
 Sent: Friday, November 08, 2002 2:09 PM
 To: Multiple recipients of list ORACLE-L
 
 
 Is it that Oracle's business model is pushing these releases 
 or is it 
 the rapid pace of technology change and the demand of the user for 
 features?
 The
 push to the web, XML, Java, and new feature requests (rename column, 
 fk's , drop column, etc...). Then there is competition too 
 that has to 
 be considered. If Oracle doesn't keep up with the Joneses 
 as it were, 
 what kind of market share will it have 5 and 10 years down the line.
 
 So, in my opinion, Oracle really has no choice but to pursue 
 the course
 that
 it is. I think they have learned some lessons down the road, and I'm
 willing
 to bet that 10.0.1 (or whatever) will be far more stable than 9.0.1 
 was.
 
 RF
 
 Robert G. Freeman - Oracle OCP
 Oracle Database Architect
 CSX Midtier Database Administration
 Author of several Oracle books you can find on Amazon.com!
 
 Londo Mollari: Ah, arrogance and stupidity all in the same 
 package. How 
 efficient of you.
 
  
 
 
 
 -Original Message-
 Sent: Friday, November 08, 2002 12:54 PM
 To: Multiple recipients of list ORACLE-L
 
 
 does this bother anybody else as much as it bothers me?  
 just what is 
 Oracle's business model for pushing these release's out this 
 fast?  are 
 there that many new features, or a market to capture, that justifies 
 this?
 
 makes no sense to me.  the shelf life of an oracle release 
 is now about 
 a year and a half.
 
 Tom Mercadante
 Oracle Certified Professional
 
 
 -Original Message-
 Sent: Friday, November 08, 2002 11:44 AM
 To: Multiple recipients of list ORACLE-L
 
 
 Heard from Tom Kyte that 10i should be out by Dec'03. He 
 also said that 
 the code is already frozen and beta testing is going on.
 
 Prakash
 
 -Original Message-
 Sent: Thursday, November 07, 2002 14:09
 To: Multiple recipients of list ORACLE-L
 
 
 The day we all finish upgrading our databases to 9i.
 
 Sunil Nookala
 DBA
 Dell Corp.
 
 
 
 -Original Message-
 Sent: Thursday, November 07, 2002 12:09 PM
 To: Multiple recipients of list ORACLE-L
 
 
 Has anyone heard when Oracle will be releasing version 10i?
 
   
 
 
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: Joe Testa
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- 858-538-5051 http://www.fatcity.com
 San Diego, California-- Mailing list and web hosting services
 

RE: When will Oracle 10i be out?

2002-11-11 Thread Gogala, Mladen


In colloquial English, they are out 
of their @#$%! mind.
 -Original Message- From: Rachel Carmichael 
[mailto:[EMAIL PROTECTED]] Sent: 
Friday, November 08, 2002 4:34 PM To: Multiple recipients of list 
ORACLE-L Subject: RE: When will Oracle 10i be out? I believe, in the 
manufacturing world, it's called "planned 
obselescence"


RE: ORACLE-Function problem

2002-11-11 Thread Babette Turner-Underwood



Had a 
similar problem recently where characterset on database differed than 
client.
We had 
to add NLS_CHARSET.zip (or was it .jar?) to the CLASSPATH.

- 
Babette Turner-Underwood

  -Original Message-From: [EMAIL PROTECTED] 
  [mailto:[EMAIL PROTECTED]]On Behalf Of SavitaSent: Monday, 
  November 11, 2002 2:33 AMTo: Multiple recipients of list 
  ORACLE-LSubject: ORACLE-Function problemHi 
  All, 
  I have a problem executing the function in oracle through JDBC. 
  I have written a select statement inside which I am calling a function. 
  The query is something like 
  select OSP_CRM_EXCHANGE_CASE_VIEW.OS_CASE_ID as 
  CASE_MSG__OS_CASE_ID, OSP_CRM_EXCHANGE_CASE_VIEW.OS_CUSTOMER_ID as 
  CASE_MSG__OS_CUSTOMER_ID, OSP_CRM_EXCHANGE_CASE_VIEW.OS_CUSTOMER_ID as 
  CASE_MSG__OS_CUST_ID, OSP_CRM_EXCHANGE_CASE_VIEW.OS_UNIT_ID as 
  CASE_MSG__OS_UNIT_ID, OSP_CRM_EXCHANGE_CASE_VIEW.CREATED_DATE as 
  CASE_MSG__CREATED_DATE, 'OS_1' as 
  CASE_MSG__UPDATED_BY FROM 
  OSP_CRM_EXCHANGE_CASE_VIEW WHERE 
  ROWNUM lt;=(40 - 
  OSP_CRM_EXCHANGE_getMaxDataId(2)) ORDER BY 
  to_number(OSP_CRM_EXCHANGE_CASE_VIEW.OS_CASE_ID); 
  here OSP_CRM_EXCHANGE_getMaxDataId(2) is 
  the function. 
  When I execute this query in command prompt Itis 
  working fine,but when I use it insied a executeQueryStatement(query) in JDBC I 
  am getting following error ORA-00911: 
  invalid character 
  I am not able to figure out how to modify 
  this. 
  Any help will be highly appriciated. 
  -- Best Regards - Savita 
   Hewlett Packard 
  (India) +91 80 2051288 (Phone) 847 1288 (HP Telnet) 
    



how to avoid mutating table error in triggers

2002-11-11 Thread Magaliff, Bill
Good day all,

Have the following setup -

Oracle 8.1.7.2 on solaris

parent-child realtionship between 2 tables:

table p1 has primary key pk1
table f1 has foreign key p1pk1 back to table p1.

Table p1 also has a field haschild number(1), used to indicate if there
are ANY child records in table f1. 
Any insert into table F1 sets the haschild field in the corresponding row in
table P1 to 1 (true).

Trying to write an on delete trigger for table f1 that will set that
boolean to 0 when there are now more child rows.

Came up with this:

create or replace trigger nochildtrg
after delete on f1
for each row
declare
tv_count number;
begin
select count(*) into tv_count
from f1
where p1pk1 = :old.p1pk1;
if tv_count = 0 then
update p1
set haschild = 0
where pk1 = :old.old.p1pk1;
end if;
commit;
end;
/

This plays right into the no-no's that produce the mutating table error on
table f1 - selecting against it as part of a trigger.

Does anyone have any kind of workaround?  I could implement a counter
trigger, that increments a count on the parent table for each new row in the
child, and decrements the count for each deleted row, but I wanted to see if
there was another way.

thanks

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

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



RE: Oracle SAN Experiences?

2002-11-11 Thread Babette Turner-Underwood
Title: The Sys



A 
client site that I was supporting a while ago had big problems with their 
NAS.
While 
doing Oracle backups to tape, the application would drop connections. 

In a 
SAN environment, there might also be similar problems.

-Original Message-From: 
[EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of David 
WagonerSent: Friday, November 08, 2002 9:59 AMTo: Multiple 
recipients of list ORACLE-LSubject: Oracle  SAN 
Experiences?

  
  The 
  Sys. Admin. team wants to consolidate storage (and probably get a new toy too) 
  on all of our servers, so they are evaluating a SAN (LSI Logic E4600). The DBA team is doing some research to 
  determine the pros and cons of doing this, and I’d like to hear any of your 
  experiences (good and bad) using SAN with 
  Oracle.
  
  My 
  understanding is that all of our database servers would remain intact, but the 
  attached disk storage would move into the SAN. So, we still have the Production, 
  Test, and App. servers with their processors and memory, Oracle homes, 
  etc. The SAN will hold database 
  files from Production, Test, Apps., staging, ODS,data warehouse, 
  etc.
  
  Their 
  arguments:
  -the 
  SAN is very scalable (500 GB – 40 TB)
  -easy 
  to manage disks in one central location
  -fancy 
  statistics collection on all SAN disks
  -much 
  higher throughput on the fiber SAN connections than with locally attached disk 
  arrays
  -capable 
  of using mixed RAID levels (0, 1, 1+0, 5, 
  etc.)
  -can 
  partition sets of disks in the SAN for specific server 
  access
  -Snapshot 
  backup capability is very fast in the SAN (much faster than traditional Oracle 
  backups)
  
  DBA 
  arguments:
  -How 
  will this affect database performance?
  -What 
  are the drawbacks, if any, with the pre-fetch of data performed by the SAN 
  (i.e., SAN cache)
  -How 
  tunable is the SAN
  -Fast, 
  small disks are better for performance and less wasted space than the typical 
  huge disks in a SAN (it’s possible to use smaller disks in the 
  SAN)
  -Prove 
  it!
  
  
  After 
  reading the “Sane SAN” article and a case study about Volvo implementing a 
  SAN, I believe it’s possible to have a great Oracle/SAN implementation if it’s 
  setup correctly and tuned. Other 
  resources that you can Google are “Using SVA SnapShot with Oracle”, 
  “Performance Benchmark LSI Logic E4600 (STK D178)”, “SAN Storage for Open 
  Systems Environments”, and of course check the 
  OraFaq.
  
  Thanks 
  for sharing,
  
  David 
  Wagoner
  Oracle 
  DBA
  
  
  
  


RE: What's your opinion: ALL_ROWS vs. FIRST_ROWS **CLOSED**

2002-11-11 Thread Armstead, Michael A
Thanks everyone.

I did decide on CHOOSE. 

It seemed like the best choice considering most of our queries aren't run
interactively through tools like SQL*Plus. In fact it should become an even
better choice as our applications are becoming more and more browser based.
ALL_ROWS also looked like it would be the best choice considering our batch
reporting requirements.

Michael Armstead
Principal Database Administrator, OCP-Certified
World Wide Corporate IT Database Administration
GlaxoSmithKline

 -Original Message-
 From: John Kanagaraj [SMTP:[EMAIL PROTECTED]]
 Sent: Monday, November 04, 2002 3:39 PM
 To:   Multiple recipients of list ORACLE-L
 Subject:  RE: What's your opinion: ALL_ROWS vs. FIRST_ROWS
 
 Hi Mike,
 
  Your article was very good in describing RBO vs. CBO. I hope 
  you don't mind
  me using it to help better describe why we're switching from 
  RBO to CBO to
  my team.
 
 I forgot to mention this before, but you should also look at Tim Gorman's
 excellent paper on the CBO at http://www.evdbt.com - search in the
 library.
  
  On the other hand it didn't help me much in practical use of ALL_ROWS
  (CHOOSE) vs. FIRST_ROWS. I understand this was out of the scope of the
  paper.
 
 Yes, but we can always discuss this here in the list :) The problem I have
 with the FIRST_ROWS is that _all_ queries would default to use this mode.
 While this may be good for a specific interactive query, it certainly
 would
 perform poorly for batch jobs, more so when the table joins larger tables.
 IMHO, you are better off leaving it to default to CHOOSE and control
 specific modes. This can be done via a variety of methods, including login
 triggers, Outlines, anf finally the code itself.
  
  Note: When leaving your web page I was notified that my IP address was
  captured. I didn't like that.
 
 My web page is served by Yahoo! Geocities, and I obtained that when it was
 free (and still is free). I suppose that they capture some info and do
 manipulate cookies. This is the first time, though that I have come across
 such a message. I will need to investigate further...
 
 Hth,
 John Kanagaraj
 Oracle Applications DBA
 DBSoft Inc
 (W): 408-970-7002
 
 What would you see if you were allowed to look back at your life at the
 end
 of your journey in this earth?
 
 ** The opinions and statements above are entirely my own and not those of
 my
 employer or clients **
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 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.com
-- 
Author: Armstead, Michael A
  INET: [EMAIL PROTECTED]

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



RE: Oracle SAN Experiences?

2002-11-11 Thread DENNIS WILLIAMS
Babette - Sounds like a problem I wrestled with for a long time. Turns out
that RMAN opens quite a few connections and the NAS isn't usually set up for
that many connections. Of course, instead of an error message, it just
hangs.



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

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


A client site that I was supporting a while ago had big problems with their
NAS.
While doing Oracle backups to tape, the application would drop connections. 
In a SAN environment, there might also be similar problems.
 
-Original Message-
Sent: Friday, November 08, 2002 9:59 AM
To: Multiple recipients of list ORACLE-L



The Sys. Admin. team wants to consolidate storage (and probably get a new
toy too) on all of our servers, so they are evaluating a SAN (LSI  Logic
E4600).  The DBA team is doing some research to determine the pros and cons
of doing this, and I'd like to hear any of your experiences (good and bad)
using SAN with Oracle.

 

My understanding is that all of our database servers would remain intact,
but the attached disk storage would move into the SAN.  So, we still have
the Production, Test, and App. servers with their processors and memory,
Oracle homes, etc.  The SAN will hold database files from Production, Test,
Apps., staging, ODS,data warehouse, etc.

 

Their arguments:

-the SAN is very scalable (500 GB - 40 TB)

-easy to manage disks in one central location

-fancy statistics collection on all SAN disks

-much higher throughput on the fiber SAN connections than with locally
attached disk arrays

-capable of using mixed RAID levels (0, 1, 1+0, 5, etc.)

-can partition sets of disks in the SAN for specific server access

-Snapshot backup capability is very fast in the SAN (much faster than
traditional Oracle backups)

 

DBA arguments:

-How will this affect database performance?

-What are the drawbacks, if any, with the pre-fetch of data performed by the
SAN (i.e., SAN cache)

-How tunable is the SAN

-Fast, small disks are better for performance and less wasted space than the
typical huge disks in a SAN (it's possible to use smaller disks in the SAN)

-Prove it!

 

 

After reading the Sane SAN article and a case study about Volvo
implementing a SAN, I believe it's possible to have a great Oracle/SAN
implementation if it's setup correctly and tuned.  Other resources that you
can Google are Using SVA SnapShot with Oracle, Performance Benchmark LSI
Logic E4600 (STK D178), SAN Storage for Open Systems Environments, and of
course check the OraFaq.

 

Thanks for sharing,

 

David Wagoner

Oracle DBA

 

 

 

 

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

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



Is nothing sacred? (Oracle vs The Experts)

2002-11-11 Thread Jesse, Rich
So, there I am, on 8.1.7.2 (and .4) on HP/UX 11.0, with a process that runs
20 minutes out of every hour of the day (despite my protests to it's
design).  After it starts having problems (go figure), it becomes a priority
to speed it up.

Thanks to a 10046 trace, we see that the query taking the most elapsed time
does FTSs on each of two very small tables (1 block and 4 blocks -- 8K
blocksize).  These tables are not indexed, as per the official Oracle
recommendation.  After reading the excellent Hotsos paper When to index a
table (THANKS, CARY!), I added an index to reduce elapsed time on this
query by 50% (150 to 75 seconds in test), proving to me that the paper is
valid.  And I've only read to page four!

OK, first I'm taught by Oracle to look at Buffer Cache Hit Ratios as a
measure of performance, then told (and thoroughly convinced) by experts that
this is bunk.  Now, I found out that the 15% (or 10% or whatever, depending
on version) ratio of rows returned to total rows in determining when to use
an index in a query is garbage.

1)  Why is this?

2)  What other pearls of performance wisdom from Oracle Corp should I
completely disregard as false?

I know there's an Oracle Fallacy website somewhere...

It just looks bad on me, our department, and Oracle when, once again,
something I've been preaching to our developers as gospel turns out to be
completely false.

Maybe I'm grumpy because it's snowing on my leaves right now...  sigh


Rich


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

Disclaimer:  I only said the Packers would be 12-4 this year -- I never said
that they couldn't do better!  WOO-HOO!  :)
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jesse, Rich
  INET: [EMAIL PROTECTED]

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



Re: Join vs. Subselect

2002-11-11 Thread Thomas Day

I'll leave it to others to explain why but it's sometimes faster to do an
outer join with a not null:

select whatever from table1, table2+
where table2.whatever is not null;

I've had selects of that form run in seconds where the sub-select or the
straight join form took hours.



   

Carle,

William TTo: Multiple recipients of list ORACLE-L 
[EMAIL PROTECTED]   
(Bill),  cc:   

ALCAS   Subject: Join vs. Subselect   

wcarle

@att.com  

Sent by: root  

   

   

11/11/2002 

11:23 AM   

Please 

respond to 

ORACLE-L   

   

   





Hi,

Here is the situation. The application coded a query that looks like
this:

select * from table1
where objid in (select objid from table2);

There is an index on objid in table 1 that isn't being used. An explain
shows it is using this system view vw_nso_1 that is used to transform an IN
subquery to a join. If you recode the query to:

select a.* from table1 a, table2 b
where a.objid = b.objid;

Then it will use the index. My question is: shouldn't it use the index
in both cases. I know the join is a better way to code it and I have told
the application that, but I would think that the first way would use an
index anyway. Ideas?

Bill Carle
ATT
Database Administrator
816-995-3922
[EMAIL PROTECTED]

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Carle, William T (Bill), ALCAS
  INET: [EMAIL PROTECTED]

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




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



combine or not combine into one database?

2002-11-11 Thread Tao_Zuo
Hi all,

I would like to know any advantage and disadvantage to combine the 
following databases into one:

Finance in Lawson
HR in Lawson
OEM repository and historical database

Any comments are very appreciated.



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

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



RE: Is nothing sacred? (Oracle vs The Experts)

2002-11-11 Thread Fink, Dan
Find Cary's paper about misunderstanding Oracle index internals. It spells
out the % Of Rows Returned fallacy. The key issue is that Oracle does not
read rows, it reads blocks. If 10% of the rows of interest are scattered
among 95% of the blocks, is it better to index or use FTS? If 25% of the
rows of interest are clustered in 5% of the blocks, an index is more
attractive. 

There is also an excellent presentation 'How to Improve Performance with
Full Table Scans' by Jeff Maresh that can be located on www.evdbt.com. 

Dan Fink
-Original Message-
Sent: Monday, November 11, 2002 9:58 AM
To: Multiple recipients of list ORACLE-L


So, there I am, on 8.1.7.2 (and .4) on HP/UX 11.0, with a process that runs
20 minutes out of every hour of the day (despite my protests to it's
design).  After it starts having problems (go figure), it becomes a priority
to speed it up.

Thanks to a 10046 trace, we see that the query taking the most elapsed time
does FTSs on each of two very small tables (1 block and 4 blocks -- 8K
blocksize).  These tables are not indexed, as per the official Oracle
recommendation.  After reading the excellent Hotsos paper When to index a
table (THANKS, CARY!), I added an index to reduce elapsed time on this
query by 50% (150 to 75 seconds in test), proving to me that the paper is
valid.  And I've only read to page four!

OK, first I'm taught by Oracle to look at Buffer Cache Hit Ratios as a
measure of performance, then told (and thoroughly convinced) by experts that
this is bunk.  Now, I found out that the 15% (or 10% or whatever, depending
on version) ratio of rows returned to total rows in determining when to use
an index in a query is garbage.

1)  Why is this?

2)  What other pearls of performance wisdom from Oracle Corp should I
completely disregard as false?

I know there's an Oracle Fallacy website somewhere...

It just looks bad on me, our department, and Oracle when, once again,
something I've been preaching to our developers as gospel turns out to be
completely false.

Maybe I'm grumpy because it's snowing on my leaves right now...  sigh


Rich


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

Disclaimer:  I only said the Packers would be 12-4 this year -- I never said
that they couldn't do better!  WOO-HOO!  :)
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jesse, Rich
  INET: [EMAIL PROTECTED]

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

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



Re: Is nothing sacred? (Oracle vs The Experts)

2002-11-11 Thread Jeffery Stevenson
Well, besides the paper you found, Jonathan Lewis has a myths section with
his site:
http://www.jlcomp.demon.co.uk/myths.html

Gaja also has a good myths article:
http://www.quest-pipelines.com/newsletter-v3/0302_F.htm

Rachel, weren't you doing a presentation on Oracle myths (or did you just
put that in DBA 101)?

Jeffery Stevenson
Chief Databeast Slayer
Medical Present Value, Inc.
Austin, TX

- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Monday, November 11, 2002 10:58 AM


 So, there I am, on 8.1.7.2 (and .4) on HP/UX 11.0, with a process that
runs
 20 minutes out of every hour of the day (despite my protests to it's
 design).  After it starts having problems (go figure), it becomes a
priority
 to speed it up.

 Thanks to a 10046 trace, we see that the query taking the most elapsed
time
 does FTSs on each of two very small tables (1 block and 4 blocks -- 8K
 blocksize).  These tables are not indexed, as per the official Oracle
 recommendation.  After reading the excellent Hotsos paper When to index a
 table (THANKS, CARY!), I added an index to reduce elapsed time on this
 query by 50% (150 to 75 seconds in test), proving to me that the paper is
 valid.  And I've only read to page four!

 OK, first I'm taught by Oracle to look at Buffer Cache Hit Ratios as a
 measure of performance, then told (and thoroughly convinced) by experts
that
 this is bunk.  Now, I found out that the 15% (or 10% or whatever,
depending
 on version) ratio of rows returned to total rows in determining when to
use
 an index in a query is garbage.

 1)  Why is this?

 2)  What other pearls of performance wisdom from Oracle Corp should I
 completely disregard as false?

 I know there's an Oracle Fallacy website somewhere...

 It just looks bad on me, our department, and Oracle when, once again,
 something I've been preaching to our developers as gospel turns out to be
 completely false.

 Maybe I'm grumpy because it's snowing on my leaves right now...  sigh


 Rich


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

 Disclaimer:  I only said the Packers would be 12-4 this year -- I never
said
 that they couldn't do better!  WOO-HOO!  :)
 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 --
 Author: Jesse, Rich
   INET: [EMAIL PROTECTED]

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



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

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



NETWORK Performance how?

2002-11-11 Thread Seema Singh
Hi
I want to check network perforamce between app servers and DB servers. How 
to check ? Is netstat/tracert help or there is another command which could 
help to find out?
Thx
-Seema





_
Add photos to your e-mail with MSN 8. Get 2 months FREE*. 
http://join.msn.com/?page=features/featuredemail

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

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


Re: Is nothing sacred? (Oracle vs The Experts)

2002-11-11 Thread Rachel Carmichael
Marlene and I did exploding the myths a while back and Jeremiah
Wilton did a myths presentation at OOW last year as well.

Rachel

--- Jeffery Stevenson [EMAIL PROTECTED] wrote:
 Well, besides the paper you found, Jonathan Lewis has a myths section
 with
 his site:
 http://www.jlcomp.demon.co.uk/myths.html
 
 Gaja also has a good myths article:
 http://www.quest-pipelines.com/newsletter-v3/0302_F.htm
 
 Rachel, weren't you doing a presentation on Oracle myths (or did you
 just
 put that in DBA 101)?
 
 Jeffery Stevenson
 Chief Databeast Slayer
 Medical Present Value, Inc.
 Austin, TX
 
 - Original Message -
 To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
 Sent: Monday, November 11, 2002 10:58 AM
 
 
  So, there I am, on 8.1.7.2 (and .4) on HP/UX 11.0, with a process
 that
 runs
  20 minutes out of every hour of the day (despite my protests to
 it's
  design).  After it starts having problems (go figure), it becomes a
 priority
  to speed it up.
 
  Thanks to a 10046 trace, we see that the query taking the most
 elapsed
 time
  does FTSs on each of two very small tables (1 block and 4 blocks --
 8K
  blocksize).  These tables are not indexed, as per the official
 Oracle
  recommendation.  After reading the excellent Hotsos paper When to
 index a
  table (THANKS, CARY!), I added an index to reduce elapsed time on
 this
  query by 50% (150 to 75 seconds in test), proving to me that the
 paper is
  valid.  And I've only read to page four!
 
  OK, first I'm taught by Oracle to look at Buffer Cache Hit Ratios
 as a
  measure of performance, then told (and thoroughly convinced) by
 experts
 that
  this is bunk.  Now, I found out that the 15% (or 10% or whatever,
 depending
  on version) ratio of rows returned to total rows in determining
 when to
 use
  an index in a query is garbage.
 
  1)  Why is this?
 
  2)  What other pearls of performance wisdom from Oracle Corp should
 I
  completely disregard as false?
 
  I know there's an Oracle Fallacy website somewhere...
 
  It just looks bad on me, our department, and Oracle when, once
 again,
  something I've been preaching to our developers as gospel turns out
 to be
  completely false.
 
  Maybe I'm grumpy because it's snowing on my leaves right now... 
 sigh
 
 
  Rich
 
 
  Rich Jesse   System/Database Administrator
  [EMAIL PROTECTED]  Quad/Tech International,
 Sussex, WI
 USA
 
  Disclaimer:  I only said the Packers would be 12-4 this year -- I
 never
 said
  that they couldn't do better!  WOO-HOO!  :)
  --
  Please see the official ORACLE-L FAQ: http://www.orafaq.com
  --
  Author: Jesse, Rich
INET: [EMAIL PROTECTED]
 
  Fat City Network Services-- 858-538-5051 http://www.fatcity.com
  San Diego, California-- Mailing list and web hosting
 services
 
 -
  To REMOVE yourself from this mailing list, send an E-Mail message
  to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
  the message BODY, include a line containing: UNSUB ORACLE-L
  (or the name of mailing list you want to be removed from).  You may
  also send the HELP command for other information (like
 subscribing).
 
 
 
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: Jeffery Stevenson
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- 858-538-5051 http://www.fatcity.com
 San Diego, California-- Mailing list and web hosting services
 -
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).


__
Do you Yahoo!?
U2 on LAUNCH - Exclusive greatest hits videos
http://launch.yahoo.com/u2
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rachel Carmichael
  INET: [EMAIL PROTECTED]

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



Re: Is nothing sacred? (Oracle vs The Experts)

2002-11-11 Thread Stephane Faroult
Jesse, Rich wrote:
 
 So, there I am, on 8.1.7.2 (and .4) on HP/UX 11.0, with a process that runs
 20 minutes out of every hour of the day (despite my protests to it's
 design).  After it starts having problems (go figure), it becomes a priority
 to speed it up.
 
 Thanks to a 10046 trace, we see that the query taking the most elapsed time
 does FTSs on each of two very small tables (1 block and 4 blocks -- 8K
 blocksize).  These tables are not indexed, as per the official Oracle
 recommendation.  After reading the excellent Hotsos paper When to index a
 table (THANKS, CARY!), I added an index to reduce elapsed time on this
 query by 50% (150 to 75 seconds in test), proving to me that the paper is
 valid.  And I've only read to page four!
 
 OK, first I'm taught by Oracle to look at Buffer Cache Hit Ratios as a
 measure of performance, then told (and thoroughly convinced) by experts that
 this is bunk.  Now, I found out that the 15% (or 10% or whatever, depending
 on version) ratio of rows returned to total rows in determining when to use
 an index in a query is garbage.
 
 1)  Why is this?

  This ratio is something I have taught (with 'about') in version 5
days. This was a time when a 500M database was considered to be
reasonably big. The bigger the table, the smaller the ratio - you see
the problem with a 50 million row table. Add to this that there was
nothing such as parallel queries nor partitioning, hash join, etc, etc,
which have strongly improved full scan performance and further tipped
the balance. You have a lot of numbers around which once were valid but
have never been updated.

 2)  What other pearls of performance wisdom from Oracle Corp should I
 completely disregard as false?

  Anything preached by somebody, including myself, who did a thorough
benchmark 12 years ago and didnt't retry it recently  _may_ be false
today. Oracle evolves, that's the trouble.
 
 I know there's an Oracle Fallacy website somewhere...
 
 It just looks bad on me, our department, and Oracle when, once again,
 something I've been preaching to our developers as gospel turns out to be
 completely false.

 You'd better get accustomed to it :-). 

-- 
Regards,

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

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



Re: NETWORK Performance how?

2002-11-11 Thread Ray Stell
On Mon, Nov 11, 2002 at 10:48:57AM -0800, Seema Singh wrote:
 Hi
 I want to check network perforamce between app servers and DB servers. How 
 to check ? Is netstat/tracert help or there is another command which could 
 help to find out?

ttcp 

http://ftp.arl.mil/~mike/ttcp.html

http://www.pcausa.com/Utilities/pcattcp.htm

cisco had it hidden on some of their gear, if you can get the 
ne guys to help:

http://www.cisco.com/warp/public/471/ttcp.html




 Thx
 -Seema
 
 
 
 
 
 _
 Add photos to your e-mail with MSN 8. Get 2 months FREE*. 
 http://join.msn.com/?page=features/featuredemail
 
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: Seema Singh
  INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- 858-538-5051 http://www.fatcity.com
 San Diego, California-- Mailing list and web hosting services
 -
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).

-- 
===
Ray Stell   [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ray Stell
  INET: [EMAIL PROTECTED]

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

2002-11-11 Thread DENNIS WILLIAMS
Tao - If I understand your situation, you currently have 3 separate
databases, 2 separate Lawson databases and another OEM database?
You can combine your two Lawson databases, but you'll need to
develop a careful project plan. Right now your Lawson HR database probably
sends data to your Lawson GL system, so that needs looked at before you do
the combination. There is a Lawson email list that can answer that question
in more detail.
Is the OEM repository and historical database more of a data
warehouse or OLTP system? Data warehouses tend to have spikey usage and
don't play well with OLTP databases such as your Lawson system. I would tend
to keep it separate just based on the limited information you've provided.

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


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


Hi all,

I would like to know any advantage and disadvantage to combine the 
following databases into one:

Finance in Lawson
HR in Lawson
OEM repository and historical database

Any comments are very appreciated.



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

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

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



RE: Is nothing sacred? (Oracle vs The Experts)

2002-11-11 Thread DENNIS WILLIAMS
Rich - Actually, if you took an Oracle Performance Tuning class from Oracle
Education right now, you would find the BHR mentioned little and Oracle
waits emphasized a great deal. I took that class about a month ago and the
instructor described how Cary had prevailed in convincing the people at
Oracle that counted and the class materials were being rewritten for the
next class after mine. 
   Well, being a computer professional is a hard burden, what with the
underlying assumption ever changing. Actually, given the extensive
discussions we've had on this forum about BHR vs. waits, I'm surprised it
caught you unawares. This was where I'd first heard about the new emphasis
on waits. Of course, with waits becoming the conventional wisdom, Cary and
others will have to find another windmill to tilt at. Cary - anything lined
up?
Dennis Williams
DBA, 40%OCP
Lifetouch, Inc.
[EMAIL PROTECTED] 


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


So, there I am, on 8.1.7.2 (and .4) on HP/UX 11.0, with a process that runs
20 minutes out of every hour of the day (despite my protests to it's
design).  After it starts having problems (go figure), it becomes a priority
to speed it up.

Thanks to a 10046 trace, we see that the query taking the most elapsed time
does FTSs on each of two very small tables (1 block and 4 blocks -- 8K
blocksize).  These tables are not indexed, as per the official Oracle
recommendation.  After reading the excellent Hotsos paper When to index a
table (THANKS, CARY!), I added an index to reduce elapsed time on this
query by 50% (150 to 75 seconds in test), proving to me that the paper is
valid.  And I've only read to page four!

OK, first I'm taught by Oracle to look at Buffer Cache Hit Ratios as a
measure of performance, then told (and thoroughly convinced) by experts that
this is bunk.  Now, I found out that the 15% (or 10% or whatever, depending
on version) ratio of rows returned to total rows in determining when to use
an index in a query is garbage.

1)  Why is this?

2)  What other pearls of performance wisdom from Oracle Corp should I
completely disregard as false?

I know there's an Oracle Fallacy website somewhere...

It just looks bad on me, our department, and Oracle when, once again,
something I've been preaching to our developers as gospel turns out to be
completely false.

Maybe I'm grumpy because it's snowing on my leaves right now...  sigh


Rich


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

Disclaimer:  I only said the Packers would be 12-4 this year -- I never said
that they couldn't do better!  WOO-HOO!  :)
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jesse, Rich
  INET: [EMAIL PROTECTED]

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

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



Character Sets - 2 different kinds, same server

2002-11-11 Thread Eric Richmond
Is it possible to have two different databases on the same server using two
different kinds of character sets (one would be UTF8 NCHAR and the other would
be US7ASCII)?   How do you create the databases with two different character
sets (is it an init parameter)?  If that is not possible and Oracle binaries
were installed with US7ASCII, how can you convert it to UTF8 without having to
reinstall everything?  This is Oracle 8.1.7.3 on Solaris.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Eric Richmon
  INET: [EMAIL PROTECTED]

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



RE: Is nothing sacred? (Oracle vs The Experts)

2002-11-11 Thread Jesse, Rich
Actually, I did know about the BHR thing, primarily from this list, just as
you did.  It was the indexing one that cought me off-guard.  I was just
using the former as a reference.

Speaking of which, your Don Quixote reference is priceless!  Facts are the
enemy of truth.  :D

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

 -Original Message-
 From: DENNIS WILLIAMS [mailto:DWILLIAMS;LIFETOUCH.COM]
 Sent: Monday, November 11, 2002 2:04 PM
 To: Multiple recipients of list ORACLE-L
 Subject: RE: Is nothing sacred? (Oracle vs The Experts)
 
 
 Rich - Actually, if you took an Oracle Performance Tuning 
 class from Oracle
 Education right now, you would find the BHR mentioned little 
 and Oracle
 waits emphasized a great deal. I took that class about a 
 month ago and the
 instructor described how Cary had prevailed in convincing the 
 people at
 Oracle that counted and the class materials were being 
 rewritten for the
 next class after mine. 
Well, being a computer professional is a hard burden, what with the
 underlying assumption ever changing. Actually, given the extensive
 discussions we've had on this forum about BHR vs. waits, I'm 
 surprised it
 caught you unawares. This was where I'd first heard about the 
 new emphasis
 on waits. Of course, with waits becoming the conventional 
 wisdom, Cary and
 others will have to find another windmill to tilt at. Cary - 
 anything lined
 up?
 Dennis Williams
 DBA, 40%OCP
 Lifetouch, Inc.
 [EMAIL PROTECTED] 
 
 
 -Original Message-
 Sent: Monday, November 11, 2002 10:58 AM
 To: Multiple recipients of list ORACLE-L
 
 
 So, there I am, on 8.1.7.2 (and .4) on HP/UX 11.0, with a 
 process that runs
 20 minutes out of every hour of the day (despite my protests to it's
 design).  After it starts having problems (go figure), it 
 becomes a priority
 to speed it up.
 
 Thanks to a 10046 trace, we see that the query taking the 
 most elapsed time
 does FTSs on each of two very small tables (1 block and 4 blocks -- 8K
 blocksize).  These tables are not indexed, as per the official Oracle
 recommendation.  After reading the excellent Hotsos paper 
 When to index a
 table (THANKS, CARY!), I added an index to reduce elapsed 
 time on this
 query by 50% (150 to 75 seconds in test), proving to me that 
 the paper is
 valid.  And I've only read to page four!
 
 OK, first I'm taught by Oracle to look at Buffer Cache Hit Ratios as a
 measure of performance, then told (and thoroughly convinced) 
 by experts that
 this is bunk.  Now, I found out that the 15% (or 10% or 
 whatever, depending
 on version) ratio of rows returned to total rows in 
 determining when to use
 an index in a query is garbage.
 
 1)  Why is this?
 
 2)  What other pearls of performance wisdom from Oracle Corp should I
 completely disregard as false?
 
 I know there's an Oracle Fallacy website somewhere...
 
 It just looks bad on me, our department, and Oracle when, once again,
 something I've been preaching to our developers as gospel 
 turns out to be
 completely false.
 
 Maybe I'm grumpy because it's snowing on my leaves right 
 now...  sigh
 
 
 Rich
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jesse, Rich
  INET: [EMAIL PROTECTED]

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



IOUG Papers

2002-11-11 Thread Stephen Andert
Does anyone know what the expected time-frame is for the IOUG paper
seletion committee to select papers?

I submitted a couple and am on pins and needles.

Thanks
Stephen Andert

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

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



RE: Need Help on Operational Data Store

2002-11-11 Thread Jared . Still
Gee Dennis, you make it sound glamorous.

Will your next career be one as a spin doctor?  :)

Jared






DENNIS WILLIAMS [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
 11/10/2002 05:38 PM
 Please respond to ORACLE-L

 
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc: 
Subject:RE: Need Help on Operational Data Store


Jared
   And just think, if you'd given it a snappy name like ODS, you'd be
jetting around to big conventions and big corporate clients, hosting the
greatest technical advice line on the Internet . . . oh, wait you already 
do
those things. Never mind!

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


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


Dennis,

Well, as a matter of fact, I do prefer Kimball to Inmon.

I was unaware of their disagreement on ODS, which makes
sense I guess, since I've read little of Inmon.

My thoughts on ODS were based on discussions with former
colleagues.  We did have something at BlueCross that we expended
a lot of energy in designing, though we didn't call it an ODS.

Jared





DENNIS WILLIAMS [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
 11/08/2002 11:24 AM
 Please respond to ORACLE-L

 
To: Multiple recipients of list ORACLE-L 
[EMAIL PROTECTED]
cc: 
Subject:RE: Need Help on Operational Data Store


Jared
   Oh, I wouldn't let Bill Inmon hear you say that. He coined the term
Operational Data Store. I do not purport to be a data warehouse expert at
the least, but several years ago I studied the literature quite a bit and
tried to keep on top of the topics. And the subject has evolved some since
then. At that time, there tended to be two separate camps, followers of
Ralph Kimball's ideas and followers of Bill Inmon's ideas. Well, 
truthfully
there was a third group, the rabid Fifth Normal Form advocates that 
insisted
on fully normalizing their DW model. 
   The issue that split the Inmon and Kimball camps was the ODS. The two
titans of the industry even had some head-to-head debates at large
conferences. Ralph always claimed that the ODS was no big deal, you 
probably
had a loading area somewhere and if you had to give it a name, fine call 
it
an ODS. Bill insisted very strongly that the ODS was THE crucial concept 
in
data warehousing and if you didn't design that part correctly your data
warehouse was sure to fail. 
   Since I could easily read and understand Ralph's articles and I could
never figure out what Bill was saying, I tended to follow Ralph's advice.
Given your statements, Jared you sound like a classic Kimball follower as
well.
   But the world moves on, and since the hot topic has been real-time 
data
warehouses, so I assume the ODS controversy is now moot. Today Inmon's 
big
topic is the Corporate Information Factory.

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

-Original Message-
Sent: Friday, November 08, 2002 11:20 AM
To: Multiple recipients of list ORACLE-L



Dennis,

I think you got it wrong right off when you stated that there's  a
lot of confusion in ODS vs. DW .

It isn't that issue at all.  No two people can agree on what an ODS
is at all, much less compare it to a DW.

To me for instance, an ODS is a place to stage data for the final
stages of some other process, be it a DW, or anything else.

An ODS is a rather generic term, and therefor whatever you 
want it to be.

Jared

On Friday 08 November 2002 07:59, [EMAIL PROTECTED] wrote:
 Greetings -
 I need some help with building an Operational Data Store. I know there 
are
 a lot of confusion in ODS vs. DW but I belong to the camp of 'ODS should
be
 used only for operational reporting, not decision support'. So while
 Kimball talks a lot about building a DW in his books, he does not cover
ODS
 much. Are there any books/websites/third parties that deal with building
an
 ODS?

 TIA


 Dennis Meng
 Database Administrator
 Focal Communications Corp.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
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.com
-- 
Author: DENNIS WILLIAMS
  INET: [EMAIL PROTECTED]

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

Re: ORACLE QUERY

2002-11-11 Thread Mark Richard
Savita,

I assume the problem is the subquery...

You can't add the two select count(*) queries together like that.  A valid
option is to use a sum function like this:

select record_identifier from records where rownum(40-(select sum(num)
from (select count(*) num from customer_view union all select count(*) from
unit view)));

The union all is important incase two counts are the same (union on its
own would halve the result).  The alias num is given to the first column
so that there is something to enter in the sum clause.

Regards,
 Mark.

PS:  There are other ways of doing this also.



   

Savita 

savita@india.   To: Multiple recipients of list ORACLE-L 
[EMAIL PROTECTED]   
hp.com  cc:   

Sent by: Subject: ORACLE QUERY 

[EMAIL PROTECTED] 

om 

   

   

11/11/2002 

19:13  

Please respond 

to ORACLE-L

   

   





Hi All,


I want to know about one query.


I have two views and I want to get the sum of count of two view ex
I have a query like


select record_identifier from records where rownum(40-(select count(*)
from customer_view+select count(*) from
unit_view));


But this is not working in oracle.


Is there any other way to do this without writing a function
--
Best Regards
- Savita

Hewlett Packard (India)
+91 80 2051288 (Phone)
847 1288 (HP Telnet)









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


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

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

2002-11-11 Thread Veronica Levin
smitty pdam  (PCI SCSI Disk Array Manager)

That is what I used to configure our IBM 2104-TU3 disk array, the menu lets
you select the type of raid you want to configure.

Hope this helps!

Saludos,
Veronica Levin Enriquez
Compañía Cervecera de Nicaragua


-Mensaje original-
De: chao_ping [mailto:chao_ping;vip.163.com]
Enviado el: Sunday, November 10, 2002 1:13 AM
Para: Multiple recipients of list ORACLE-L
Asunto: Re: OT: RAID 7137 configutation on AIX


Rahul,
smit ssaraid, if it is ssa disk array like 7133. I am not
sure whether it works for your 1737 disk array, just try:).
Hope it helps.



Regards
zhu chao
Eachnet DBA
86-21-32174588-667
[EMAIL PROTECTED]
www.happyit.net


=== 2002-11-07 23:43:00 ,you wrote£º===

 list, 
 we are trying to install the external disk array IBM 1737 to our J50
 rs/6000
 we do not have any documents/manuals .. this disk array can be configured
 as raid5 
 or raid0, but how to configure it ?? anyone ? 
 
 TIA
 Rahul
 
 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rahul
  INET: [EMAIL PROTECTED]

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

= = = = = = = = = = = = = = = = = = = =




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

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

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



RE: Oracle daylight saving

2002-11-11 Thread Jared . Still
 Under Oracle9i, the new time
 zone features offer more possibilities to consider.

And much more confusion.

http://otn.oracle.com/oramag/oracle/02-nov/o62sql.html

Jared






DENNIS WILLIAMS [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
 11/11/2002 05:43 AM
 Please respond to ORACLE-L

 
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc: 
Subject:RE: Oracle daylight saving


John
   Yep, Oracle gets whatever the server has. Under Oracle9i, the new time
zone features offer more possibilities to consider.

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


-Original Message-
Sent: Monday, November 11, 2002 6:59 AM
To: Multiple recipients of list ORACLE-L


How does Oracle handle daylight saving time changes. presumably it gets 
its
time from the OS?

John




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

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



RE: Partition Question

2002-11-11 Thread Veronica Levin
I agree too, 
You have to know what is best for you,
I just partitioned several tables by date value... left the historic
records in one partition (let's say date  Jan 2002) and the rest of the
records in another partition.but that was because it was the best for
us, some users generate historic reports, and other users just update the
transactions of the day and generate reports of that day... 
Hope this helps,

Saludos,
Veronica Levin Enriquez
Compañía Cervecera de Nicaragua


-Mensaje original-
De: Mark Richard [mailto:mrichard;transurban.com.au]
Enviado el: Tuesday, November 05, 2002 4:09 PM
Para: Multiple recipients of list ORACLE-L
Asunto: Re: Partition Question


I agree...

What are you trying to accomplish with partitioning?  Partitioning by year
/ month / day / whatever can make it easy to truncate / archive old data.
The only trick is to create new partitions before they are required.

Another goal of partitioning may be query execution.  You might partition a
table by a certain column what is frequently stored in a where clause.
This might restrict the query to a partition rather than the entire table
and (depending on the query) could give a performance gain.

If you are lucky partitioning will achieve both, if you are unlucky
partitioning will just introduce a maintenance hassle.  Think about why you
want to partition the table and what you expect to gain by doing it.
Whatever you do, don't partition simply because you can.

Regards,
 Mark.



 

Don Jerman

[EMAIL PROTECTED]   To: Multiple recipients of
list ORACLE-L [EMAIL PROTECTED]   
ate.nc.uscc:

Sent by:  Subject: Re: Partition
Question   
[EMAIL PROTECTED]

m

 

 

05/11/2002

05:54

Please respond

to ORACLE-L

 

 





It depends on your reason for partitioning -- if you mean to drop a
partition in
the future (to roll off the 1999 data or whatever) then the ID range is
potentially a valid approach, as long as ID is serial.  If you just want to
put
chunks on different disk volumes, you could use the type or even a hash
partitioning scheme.  It's down to what you're trying to accomplish, and
what is
good for one partition key is probably bad or neutral for the other.


Hamid Alavi wrote:

 Hi List,

 I have a question regarding partitioning: If I want to partition a table
 which strategy is better, like do i have to use a value which from first
day
 of using this table all those partion is using or just using first
partion,
 then second etc.
 E.G:
 If I do partion tableA based on ID range 1000, so for few month the
only
 first partion of this table will be used then second partion, but if I
 partion it on Type (1,2,3,4,5) any record can be any of these type and
from
 first day all of the partions will be used.
 Just want to check with you guys which way is better for performance?
 THanks for HELP

 Hamid Alavi
 Office 818 737-0526
 Cell818 416-5095

 === Confidentiality Statement ===
 The information contained in this message and any attachments is
 intended only for the use of the individual or entity to which it is
 addressed, and may contain information that is PRIVILEGED, CONFIDENTIAL
 and exempt from disclosure under applicable law.  If you have received
 this message in error, you are prohibited from copying, distributing, or
 using the information.  Please contact the sender immediately by return
 e-mail and delete the original message from your system.
 = End Confidentiality Statement =

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

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




   Privileged/Confidential information may be contained in this message.
  If you are not the addressee indicated in this message
   (or responsible for delivery of the message to such person),
you may not copy or deliver this message to anyone.
In such case, you should destroy this message and kindly notify the sender
   by reply e-mail or by telephone on (61 3) 9612-6999.
   Please advise immediately if you or your employer does not consent to
  

RE: Is nothing sacred? (Oracle vs The Experts)

2002-11-11 Thread Connor McDonald
I like to think of it this way:

If a table is defined as small when it does not need
to be indexed, then there is no such thing as a small
table

Others didn't mention - but you may want to look at
using IOT's for some of the cases you've mentioned

Cheers
Connor

 --- Jesse, Rich [EMAIL PROTECTED] wrote: 
Actually, I did know about the BHR thing, primarily
 from this list, just as
 you did.  It was the indexing one that cought me
 off-guard.  I was just
 using the former as a reference.
 
 Speaking of which, your Don Quixote reference is
 priceless!  Facts are the
 enemy of truth.  :D
 
 Rich Jesse   System/Database
 Administrator
 [EMAIL PROTECTED]  Quad/Tech
 International, Sussex, WI USA
 
  -Original Message-
  From: DENNIS WILLIAMS
 [mailto:DWILLIAMS;LIFETOUCH.COM]
  Sent: Monday, November 11, 2002 2:04 PM
  To: Multiple recipients of list ORACLE-L
  Subject: RE: Is nothing sacred? (Oracle vs The
 Experts)
  
  
  Rich - Actually, if you took an Oracle Performance
 Tuning 
  class from Oracle
  Education right now, you would find the BHR
 mentioned little 
  and Oracle
  waits emphasized a great deal. I took that class
 about a 
  month ago and the
  instructor described how Cary had prevailed in
 convincing the 
  people at
  Oracle that counted and the class materials were
 being 
  rewritten for the
  next class after mine. 
 Well, being a computer professional is a hard
 burden, what with the
  underlying assumption ever changing. Actually,
 given the extensive
  discussions we've had on this forum about BHR vs.
 waits, I'm 
  surprised it
  caught you unawares. This was where I'd first
 heard about the 
  new emphasis
  on waits. Of course, with waits becoming the
 conventional 
  wisdom, Cary and
  others will have to find another windmill to tilt
 at. Cary - 
  anything lined
  up?
  Dennis Williams
  DBA, 40%OCP
  Lifetouch, Inc.
  [EMAIL PROTECTED] 
  
  
  -Original Message-
  Sent: Monday, November 11, 2002 10:58 AM
  To: Multiple recipients of list ORACLE-L
  
  
  So, there I am, on 8.1.7.2 (and .4) on HP/UX 11.0,
 with a 
  process that runs
  20 minutes out of every hour of the day (despite
 my protests to it's
  design).  After it starts having problems (go
 figure), it 
  becomes a priority
  to speed it up.
  
  Thanks to a 10046 trace, we see that the query
 taking the 
  most elapsed time
  does FTSs on each of two very small tables (1
 block and 4 blocks -- 8K
  blocksize).  These tables are not indexed, as per
 the official Oracle
  recommendation.  After reading the excellent
 Hotsos paper 
  When to index a
  table (THANKS, CARY!), I added an index to reduce
 elapsed 
  time on this
  query by 50% (150 to 75 seconds in test), proving
 to me that 
  the paper is
  valid.  And I've only read to page four!
  
  OK, first I'm taught by Oracle to look at Buffer
 Cache Hit Ratios as a
  measure of performance, then told (and thoroughly
 convinced) 
  by experts that
  this is bunk.  Now, I found out that the 15% (or
 10% or 
  whatever, depending
  on version) ratio of rows returned to total rows
 in 
  determining when to use
  an index in a query is garbage.
  
  1)  Why is this?
  
  2)  What other pearls of performance wisdom from
 Oracle Corp should I
  completely disregard as false?
  
  I know there's an Oracle Fallacy website
 somewhere...
  
  It just looks bad on me, our department, and
 Oracle when, once again,
  something I've been preaching to our developers as
 gospel 
  turns out to be
  completely false.
  
  Maybe I'm grumpy because it's snowing on my leaves
 right 
  now...  sigh
  
  
  Rich
 -- 
 Please see the official ORACLE-L FAQ:
 http://www.orafaq.com
 -- 
 Author: Jesse, Rich
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- 858-538-5051
 http://www.fatcity.com
 San Diego, California-- Mailing list and web
 hosting services

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

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

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

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

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

OT: Day 1: OracleWorld

2002-11-11 Thread Connor McDonald
So far strike rate of 0 for 3.

ie

3 presentations, all of which were fluff and no
reasonable technical content to speak of...

Positives so far: The internet access PCs are nice and
quick.

If you're here in SF - come check out the OakTable

Cheers
Connor

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

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

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

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



Oracle 8i DB, 9i DB and 9iAS on same Unix box, refused

2002-11-11 Thread Don Malzahn

All,

Environment:
HP-UX 11i
We had Oracle 8i (8.1.7) running successfully on our one host. This host
also has Oracle 9i AS already
too.

Then we installed Oracle 9i R2 (9.2.0.1) on the same host (to run RMAN
backup and recovery on another host).
Since then our one application (FAMIS from PRISM) is having problems
taking connections through the web (9i AS).

One person here did some research and says perhaps when 9i DB was
installed (to support doing RMAN backups for a 9i DB system on another
box), it overlaid the prior version of Apache. Sounds good to me. We
don't have that much experience in the 9iAS, so we can't really say
where the problem is. The database is up and open and I can hit it from
command line sqlplus.

Any ideas what went wrong and how to fix it? Should we have done a reboot
of the host after the Oracle 9i install? We did not.

message:
===
ERROR
The requested URL could not be retrieved

While trying to retrieve the URL:
http://cmms.harper.cc.il.us/pls/ftrn/loc.login

The following error was encountered: 
· Connection Failed 
The system returned: 
(61) Connection refused
The remote host or network may be down. Please try the request again. 

Generated Mon, 11 Nov 2002 19:15:16 GMT by fw3.harper.cc.il.us (Squid/2.2.STABLE5) 


===



Thanks.
-
Don Malzahn, IT/AS, Harper Community College Voice:(847) 925-6829
E-mail: [EMAIL PROTECTED] Web page: http://www.harpercollege.edu
The only limit to our realization of tomorrow will be our doubts of today. - FDR
 



RE: combine or not combine into one database?

2002-11-11 Thread Tao_Zuo
Thanks a lot for you info.  Do you know how I can subscribe the Lawson 
email list?  Thanks again.

-Original Message-
Sent: Monday, November 11, 2002 2:59 PM
To: ORACLE-L


Tao - If I understand your situation, you currently have 3 separate
databases, 2 separate Lawson databases and another OEM database?
You can combine your two Lawson databases, but you'll need to
develop a careful project plan. Right now your Lawson HR database 
probably
sends data to your Lawson GL system, so that needs looked at before you 
do
the combination. There is a Lawson email list that can answer that 
question
in more detail.
Is the OEM repository and historical database more of a data
warehouse or OLTP system? Data warehouses tend to have spikey usage and
don't play well with OLTP databases such as your Lawson system. I would 
tend
to keep it separate just based on the limited information you've 
provided.

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


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


Hi all,

I would like to know any advantage and disadvantage to combine the 
following databases into one:

Finance in Lawson
HR in Lawson
OEM repository and historical database

Any comments are very appreciated.



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

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

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

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

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



Solaris vs Windows 2000

2002-11-11 Thread Jared . Still
Dear List,

Believe me, I am not trying to rehash an old topic, start any
flame wars, nor look for supporting evidence for my admitted
bias toward unix operating systems.

Now that that's out of the way, what I am trying to do is find
objective material comparing the use of MS Windows 2000
Server on Intel HW to Solaris on Sun HW.

This is for an SAP implementation.  We are currently running
SAP 4.0b on MS NT 4.0 SP 6, on Dell 4 CPU Servers. ( I forget
just which server )

As part of our process to upgrade the system to 4.6c and more
recent versions of Oracle ( like 8.1.7 ), we are trying to do a 
comparison of the features, benefits and advantages of using
Win2k Server and Solaris.

Please don't refer me to such sites as www.kirch.net and
www.osdata.com.   The information at www.kirch.net is dated
and applies to NT, not Win2k. 

osdata.com is a nice site, but doesn't really offer comparisons,
just information on each OS. 

There is quite a bit of material available at www.microsoft.com.

Try:  http://www.microsoft.com/windows2000/server/evaluation/compare/

PC Mag has a nice article comparing different platforms for use as a 
webserver: http://www.pcmag.com/article2/0,4149,6615,00.asp

They actually chose IBM running Windows 2000.

Windows 2000 is in use here as a server platform for one database that
is used as the backend to a rather troublesome application.  The Win2k
server is running Oracle 8.1.6.2.  The database has been bounced 2 or
3 times in the last year. 

Once was to clear up a strange but non-fatal problem with Oracle.  That 
was
back in July, the previous system restart had been in December 2001. 
Server
and database were up without interruption for 7 months.

Though I prefer Solaris,  I'm having a difficult time coming up with many 
valid
reasons for recommending it over Win2k.

A few that I do have:

Sun service is superior to Dell service.  They've proven this to us.  ( We 
have other
Sun machines in house )

Sun scales better.  At least on 32 bits.  We're at 4 CPU's.  If we need to 
go past that
I would think we should go with Sun.  I don't know about Win2k Advanced 
Server, as it
is a 64 bit platform, and I think the licensing would go up quite a bit.

I welcome all objective comparisons of Solaris and Win2k Server, whether 
your own
thoughts, or a link or links to articles you are aware of.

Thanks,

Jared






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

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



Re: Oracle 8i DB, 9i DB and 9iAS on same Unix box, refused

2002-11-11 Thread Jared . Still
Don,

Oracle 8.1.7 RDBMS, 9iAS and 9.2 RDBMS should all be installed in separate
ORACLE_HOME's.  If may be that the 9.2 database install went to the same 
ORACLE_HOME as the 9iAS install. 

If so, you will likely need to reinstall both 9iAS and 9iR2.

Jared






Don Malzahn [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
 11/11/2002 02:44 PM
 Please respond to ORACLE-L

 
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc: 
Subject:Oracle 8i DB, 9i DB and 9iAS on same Unix box, refused


All,

Environment:
HP-UX 11i
We had Oracle 8i (8.1.7) running successfully on our one host. This host 
also has Oracle 9i AS already too. 

Then we installed Oracle 9i R2 (9.2.0.1) on the same host (to run RMAN 
backup and recovery on another host).
Since then our one application (FAMIS from PRISM) is having problems 
taking connections through the web (9i AS).

One person here did some research and says perhaps when 9i DB was 
installed (to support doing RMAN backups for a 9i DB system on another 
box), it overlaid the prior version of Apache. Sounds good to me. We don't 
have  that much experience in the 9iAS, so we can't really say where the 
problem is. The database is up and open and I can hit it from command line 
sqlplus.

Any ideas what went wrong and how to fix it? Should we have done a reboot 
of the host after the Oracle 9i install? We did not.

message:
===
ERROR
The requested URL could not be retrieved

While trying to retrieve the URL: http://cmms.harper.cc.il.us/pls/ftrn/loc.login 
The following error was encountered: 
· Connection Failed 
The system returned: 
(61) Connection refused
The remote host or network may be down. Please try the request again. 

Generated Mon, 11 Nov 2002 19:15:16 GMT by fw3.harper.cc.il.us (Squid/2.2.STABLE5) 


===



Thanks.
-
Don Malzahn, IT/AS, Harper Community College   Voice:(847) 925-6829
E-mail: [EMAIL PROTECTED]Web page: http://www.harpercollege.edu
The only limit to our realization of tomorrow will be our doubts of 
today. - FDR
 


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

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



Solaris 2.7/8.1.6.3/Listener

2002-11-11 Thread Vergara, Michael (TEM)
Hi Everyone:

I currently have two instances on a machine.  Since one is used
little if at all, I want to roll the active schema into the other
instance, which is used more.

Is there a way that I can fool the listener so that when a 
connection request comes in for the DB I want to shut down it
will connect to the other one?

If you have an RTFM suggestion, please indicate the FM to R.

Thanks,
Mike

---
===
Michael P. Vergara
Oracle DBA
Guidant Corporation

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Vergara, Michael (TEM)
  INET: [EMAIL PROTECTED]

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



Re: ORACLE-Function problem

2002-11-11 Thread Justin Cave
At 12:33 AM 11/11/2002, you wrote:


select
OSP_CRM_EXCHANGE_CASE_VIEW.OS_CASE_ID  as CASE_MSG__OS_CASE_ID,
OSP_CRM_EXCHANGE_CASE_VIEW.OS_CUSTOMER_ID  as CASE_MSG__OS_CUSTOMER_ID,
OSP_CRM_EXCHANGE_CASE_VIEW.OS_CUSTOMER_ID  as CASE_MSG__OS_CUST_ID,
OSP_CRM_EXCHANGE_CASE_VIEW.OS_UNIT_ID  as CASE_MSG__OS_UNIT_ID,
OSP_CRM_EXCHANGE_CASE_VIEW.CREATED_DATE as CASE_MSG__CREATED_DATE,
'OS_1' as CASE_MSG__UPDATED_BY
FROM OSP_CRM_EXCHANGE_CASE_VIEW
WHERE
ROWNUM lt;=(40 - OSP_CRM_EXCHANGE_getMaxDataId(2))
ORDER BY to_number(OSP_CRM_EXCHANGE_CASE_VIEW.OS_CASE_ID);


Do you intend for the lt; to be in the query?  I'm not sure what you 
expect this to do, but I suspect that's your illegal character.


here OSP_CRM_EXCHANGE_getMaxDataId(2) is the function.

When I execute this query in command prompt Itis working fine,but when I 
use it insied a executeQueryStatement(query) in JDBC I am getting 
following error
ORA-00911: invalid character

I am not able to figure out how to modify this.

Any help will be highly appriciated.

--
Best Regards
- Savita

Hewlett Packard (India)
+91 80 2051288 (Phone)
847 1288 (HP Telnet)



Justin Cave
Distributed Database Consulting

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

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

2002-11-11 Thread Muru
Thanks a lot guys! I really appreciate your input.
FYI...we are already in the process of webifying the
system, I wanted a solution until we complete that
project.

Muru


--- DENNIS WILLIAMS [EMAIL PROTECTED] wrote:
 Muru - I agree with Richard. This is the time to
 investigate a Web interface
 for this application. Otherwise you're just starting
 down the path of a long
 headache that will only get worse with time. As to
 your direct question, the
 only interface that I am aware of that bypasses the
 SQL*Net interface is
 JDBC thin client. And in my limited experience, I've
 seen zero problems when
 JDBC thin client is used (have heard others on this
 list have experienced
 some), but a lot of problems with the Microsoft ADO
 interface. Now you just
 have to figure out how to interface VC++ and Java.
 But, I would expect that
 Microsoft has some code that will cause the PC to
 self-destruct if you
 attempt it.
 
 Dennis Williams
 DBA, 40%OCP
 Lifetouch, Inc.
 [EMAIL PROTECTED] 
 
 -Original Message-
 Sent: Friday, November 08, 2002 9:18 PM
 To: Multiple recipients of list ORACLE-L
 
 
 Hrm.  But that's why everyone is doing
 web-based(three-tier) applications
 to avoid doing that kind of thing.  Even if you
 manage to include Oracle
 client into your app, you will still face the
 challenge of rolling
 your app on 1000 PCs.  Plus subsequent fixes, new
 versions.
 
 -Original Message-
 Sent: Friday, November 08, 2002 5:14 PM
 To: Multiple recipients of list ORACLE-L
 
 
 Hello Gurus,
 
 I would like to program our VC++ application to
 directly connect to Oracle database using OO4O or
 OCI.
 But the problem is this VC++ app is gonna run on
 1000s
 of desktops where we may have to install Oracle
 client
 which will be a time consuming in-efficient process.
 I
 am trying to see if the required client dlls and
 other
 files can be combined in the VC++ package itself and
 
 delivered to those 1000s of desktops.
 
 Can any of you give some insight into this, please?
 
 Any help would be highly appreciated.
 
 Thanks,
 Muru
  
 
 __
 Do you Yahoo!?
 U2 on LAUNCH - Exclusive greatest hits videos
 http://launch.yahoo.com/u2
 -- 
 Please see the official ORACLE-L FAQ:
 http://www.orafaq.com
 -- 
 Author: Muru
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- 858-538-5051
 http://www.fatcity.com
 San Diego, California-- Mailing list and web
 hosting services

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

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

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


__
Do you Yahoo!?
U2 on LAUNCH - Exclusive greatest hits videos
http://launch.yahoo.com/u2
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Muru
  INET: [EMAIL PROTECTED]

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

Re: Solaris vs Windows 2000

2002-11-11 Thread Lyndon Tiu
Linux Rulz!!!

On Monday 11 November 2002 03:13 pm, [EMAIL PROTECTED] wrote:
 Dear List,

 Believe me, I am not trying to rehash an old topic, start any
 flame wars, nor look for supporting evidence for my admitted
 bias toward unix operating systems.

 Now that that's out of the way, what I am trying to do is find
 objective material comparing the use of MS Windows 2000
 Server on Intel HW to Solaris on Sun HW.

 This is for an SAP implementation.  We are currently running
 SAP 4.0b on MS NT 4.0 SP 6, on Dell 4 CPU Servers. ( I forget
 just which server )

 As part of our process to upgrade the system to 4.6c and more
 recent versions of Oracle ( like 8.1.7 ), we are trying to do a
 comparison of the features, benefits and advantages of using
 Win2k Server and Solaris.

 Please don't refer me to such sites as www.kirch.net and
 www.osdata.com.   The information at www.kirch.net is dated
 and applies to NT, not Win2k.

 osdata.com is a nice site, but doesn't really offer comparisons,
 just information on each OS.

 There is quite a bit of material available at www.microsoft.com.

 Try:  http://www.microsoft.com/windows2000/server/evaluation/compare/

 PC Mag has a nice article comparing different platforms for use as a
 webserver: http://www.pcmag.com/article2/0,4149,6615,00.asp

 They actually chose IBM running Windows 2000.

 Windows 2000 is in use here as a server platform for one database that
 is used as the backend to a rather troublesome application.  The Win2k
 server is running Oracle 8.1.6.2.  The database has been bounced 2 or
 3 times in the last year.

 Once was to clear up a strange but non-fatal problem with Oracle.  That
 was
 back in July, the previous system restart had been in December 2001.
 Server
 and database were up without interruption for 7 months.

 Though I prefer Solaris,  I'm having a difficult time coming up with many
 valid
 reasons for recommending it over Win2k.

 A few that I do have:

 Sun service is superior to Dell service.  They've proven this to us.  ( We
 have other
 Sun machines in house )

 Sun scales better.  At least on 32 bits.  We're at 4 CPU's.  If we need to
 go past that
 I would think we should go with Sun.  I don't know about Win2k Advanced
 Server, as it
 is a 64 bit platform, and I think the licensing would go up quite a bit.

 I welcome all objective comparisons of Solaris and Win2k Server, whether
 your own
 thoughts, or a link or links to articles you are aware of.

 Thanks,

 Jared

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

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

2002-11-11 Thread Ron/Sarah Yount
Character set are defined the database level.  If you have two different
databases, then you can have any two different character sets you wish.
This is generally defined at the time you run the create database...
statement.

Understand of course that in your scenario there would be limits on
sharing data between the two databases.  The UTF8 database could handle
anything stored in the USASCII database because it is a superset, but
you could not necessarily share data the other direction.

-Ron-

-Original Message-
Richmond
Sent: Monday, November 11, 2002 2:14 PM
To: Multiple recipients of list ORACLE-L


Is it possible to have two different databases on the same server using
two different kinds of character sets (one would be UTF8 NCHAR and the
other would
be US7ASCII)?   How do you create the databases with two different
character
sets (is it an init parameter)?  If that is not possible and Oracle
binaries were installed with US7ASCII, how can you convert it to UTF8
without having to reinstall everything?  This is Oracle 8.1.7.3 on
Solaris.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Eric Richmon
  INET: [EMAIL PROTECTED]

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

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

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



RE: Solaris vs Windows 2000

2002-11-11 Thread Stephen Lee

-Original Message-
Now that that's out of the way, what I am trying to do is find
objective material comparing the use of MS Windows 2000
Server on Intel HW to Solaris on Sun HW.


My personal bias against Windows is based mostly on three things.

1.  Incompatibility with everything else.  Microsoft makes its products as
incompatible as it can get away with so that once you start going down the
Microsoft path, you become more and more locked into that path.

2.  It is a single-user operating system.  Microsoft has done a pretty good
job of making it look otherwise by tacking on some multi-user extensions;
but it is, in fact, NOT a multi-user OS.  Just try creating a general user
so that user can install, upgrade, and maintain their application without
having administrator privilege.  It ain't gonna happen.  And that brings up
the main problem with this arrangement: Every user that must support an
application on the box must have administrator privilege.  This, of course,
presents a completely insecure environment.

3.  In its normal form, there is an amazing lack of the kind of support
and scripting utilities the are normal on Unix.  True, if one wants to spend
the time, many of the utilities can be set up on NT; but that involves
additional setup and maintenance time -- which your NT admins might not be
inclined to do if the bureaucracy of your organization requires that they do
it.  If your scripting abilities are substantial, then you, no doubt,
automate many things with scripts.  If you have built these scripts with a
non-standard environment, then you have built your house on shifting sand.
(By the way, this is why I do not fully support Linux.)

I must agree that I do like the Dell Poweredge stuff.  I was using it years
ago, and the value is certainly compelling.  It's too bad that Sun did the
same thing with Solaris on Intel that IBM did to OS/2 (got very stuck up
about it and over-priced the crap out of everything until it was too late).
But the Sun hardware (and IBM too) ain't all that shabby either.  And my
past experience -- when I was a sys admin work -- with Sun customer support
was very positive. IBM  eh, so-so ... maybe.

Perhaps another thing to consider: If you have ever tried to upgrade the OS
on a NT box supporting third-party applications, I suspect you discovered
that it can be an excrutiatingly painful experience ... If you even
succeeded at all.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Stephen Lee
  INET: [EMAIL PROTECTED]

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



Re: Solaris vs Windows 2000

2002-11-11 Thread Lyndon Tiu
Seriously now.

I know you are trying to evaluate Solaris and Windows, but ...

Linux is the way to go. Sun's are expensive machines.

NT/2K are cheap(er) but locks you into an expensive software upgrade cycle.

Linux costs very little and runs on cheap hardware.

--
Lyndon Tiu

On Monday 11 November 2002 06:58 pm, Stephen Lee wrote:
 -Original Message-
 Now that that's out of the way, what I am trying to do is find
 objective material comparing the use of MS Windows 2000
 Server on Intel HW to Solaris on Sun HW.
 

 My personal bias against Windows is based mostly on three things.

 1.  Incompatibility with everything else.  Microsoft makes its products as
 incompatible as it can get away with so that once you start going down the
 Microsoft path, you become more and more locked into that path.

 2.  It is a single-user operating system.  Microsoft has done a pretty good
 job of making it look otherwise by tacking on some multi-user extensions;
 but it is, in fact, NOT a multi-user OS.  Just try creating a general user
 so that user can install, upgrade, and maintain their application without
 having administrator privilege.  It ain't gonna happen.  And that brings up
 the main problem with this arrangement: Every user that must support an
 application on the box must have administrator privilege.  This, of course,
 presents a completely insecure environment.

 3.  In its normal form, there is an amazing lack of the kind of support
 and scripting utilities the are normal on Unix.  True, if one wants to
 spend the time, many of the utilities can be set up on NT; but that
 involves additional setup and maintenance time -- which your NT admins
 might not be inclined to do if the bureaucracy of your organization
 requires that they do it.  If your scripting abilities are substantial,
 then you, no doubt, automate many things with scripts.  If you have built
 these scripts with a non-standard environment, then you have built your
 house on shifting sand. (By the way, this is why I do not fully support
 Linux.)

 I must agree that I do like the Dell Poweredge stuff.  I was using it years
 ago, and the value is certainly compelling.  It's too bad that Sun did the
 same thing with Solaris on Intel that IBM did to OS/2 (got very stuck up
 about it and over-priced the crap out of everything until it was too late).
 But the Sun hardware (and IBM too) ain't all that shabby either.  And my
 past experience -- when I was a sys admin work -- with Sun customer support
 was very positive. IBM  eh, so-so ... maybe.

 Perhaps another thing to consider: If you have ever tried to upgrade the OS
 on a NT box supporting third-party applications, I suspect you discovered
 that it can be an excrutiatingly painful experience ... If you even
 succeeded at all.

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

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

2002-11-11 Thread Mark Richard
You have to understand that different people / organisations have different
requirements.

Some companies will pay huge amount of cash for the peace of mind that they
can ring Sun and have someone onsite at 4:00am Sunday morning (or whatever
time people hate working at) when required.  They might require extremely
expensive hardware with guaranteed uptimes, or they might require massive
hardware (RAM / CPU) to get the job done in the available time frame.

Some companies (especially some universities) might already have licensing
deals with Microsoft which make configuring an additional Win2K server
effectively free.  Or perhaps they have 50 support staff that are skilled
in Microsoft and very weak *nix skills.

Unless the organisation is a startup there is probably some kind of
existing infrastructure to fit within, and this can have a significant
impact on both availability and cost.  Buying the actual OS is probably one
of the cheapest costs.

How can anyone here propose that Solaris beats Win2K, or vice versa,
without knowing the specific requirements or existing environment?

Regards,
 Mark.

PS:  Yes, I've worked at both ends of the spectrum (from desktop PC's being
used as servers with no redundancy, etc to obscene amount of Solaris
hardware in secure data centre type environments).  In both situations I
thought the hardware was appropriate for the environment.



   

Lyndon Tiu 

[EMAIL PROTECTED]   To: Multiple recipients of list ORACLE-L 
[EMAIL PROTECTED]   
fu.ca   cc:   

Sent by: Subject: Re: Solaris vs Windows 2000  

[EMAIL PROTECTED] 

om 

   

   

12/11/2002 

14:34  

Please respond 

to ORACLE-L

   

   





Seriously now.

I know you are trying to evaluate Solaris and Windows, but ...

Linux is the way to go. Sun's are expensive machines.

NT/2K are cheap(er) but locks you into an expensive software upgrade cycle.

Linux costs very little and runs on cheap hardware.

--
Lyndon Tiu

On Monday 11 November 2002 06:58 pm, Stephen Lee wrote:
 -Original Message-
 Now that that's out of the way, what I am trying to do is find
 objective material comparing the use of MS Windows 2000
 Server on Intel HW to Solaris on Sun HW.
 

 My personal bias against Windows is based mostly on three things.

 1.  Incompatibility with everything else.  Microsoft makes its products
as
 incompatible as it can get away with so that once you start going down
the
 Microsoft path, you become more and more locked into that path.

 2.  It is a single-user operating system.  Microsoft has done a pretty
good
 job of making it look otherwise by tacking on some multi-user extensions;
 but it is, in fact, NOT a multi-user OS.  Just try creating a general
user
 so that user can install, upgrade, and maintain their application without
 having administrator privilege.  It ain't gonna happen.  And that brings
up
 the main problem with this arrangement: Every user that must support an
 application on the box must have administrator privilege.  This, of
course,
 presents a completely insecure environment.

 3.  In its normal form, there is an amazing lack of the kind of support
 and scripting utilities the are normal on Unix.  True, if one wants to
 spend the time, many of the utilities can be set up on NT; but that
 involves additional setup and maintenance time -- which your NT admins
 might not be inclined to do if the bureaucracy of your organization
 requires that they do it.  If your scripting 

RE: Solaris vs Windows 2000

2002-11-11 Thread Reardon, Bruce (CALBBAY)
Jared,
I've never managed a UNIX server, but we do have some VMS servers and some Windows 
servers.

Some thoughts:
Some changes in your Network require a reboot on each server - specifically consider 
the following:
your DNS server changes - AFAIK need a reboot
your WINS server changes - AFAIK need a reboot
Yes, you can get around most of this by using a local hosts file - but that's more 
administration
(and have you ever tired (for example) to do a net send to a server specified by name 
where the name is in a host file
It didn't work for me - maybe a lmhosts file will get around this - don't know.
You want to change the domain the server is in - AFAIK time to reboot

Now, I'm not against Windows servers as such and I know you can run them for long 
uptimes, but it can be frustrating when events external to the administration of that 
box force you to reboot (eg you can't just stop the IP component reconfigure it and 
restart that bit).


Support
Which company (Dell or Sun) will give you (for free) spares to locate on your site to 
allow quick replacements?
Do you get Dell's premier support, or just standard customer support

Out of band remote console
Yes you can use PC Anywhere / VNC / whatever, but doesn't help if it freezes during 
the reboot.
I take it you're aware of Dell's DRAC / ERA (Embedded Remote Assistance) cards that 
provide this.

Have you looked into Dell's IT Assistant for monitoring its servers.


Disk Infrastructure
With the disk infrastructure you are going to be using for your Dell box, can you add 
new disks without rebooting?
It's frustrating to require a reboot just to add another disk.


Oracle support
What's your company's sway with Oracle?
Many big customers seem to be on Unix, meaning that any particular patch may well come 
out first for Solaris.
(Then again the consolidated patch sets that they release for Windows are handy - get 
all the fixes in 1 go (once that patch set is released).

SAP - how many SAP customers have their DB on Unix vs Windows?
ie if you run into a SAP specific Oracle issue, is it more likely to be fixed first on 
Solaris or on Windows?

Scalability - 
Do you get the free Dell Power solutions magazines (articles are also available on 
their web site)?
They've had a few articles on benchmarking on some on migrating Sun based BEA Weblogic 
servers to Dell servers running Red Hat / W2K.
Their cluster special edition in 2002 had an article comparing performance for 2/4/8 
CPUs (admittedly this test was using SQL Server).

Have fun  let us know what you find...

Regards,
Bruce Reardon


-Original Message-
Sent: Tuesday, 12 November 2002 1:59 PM

-Original Message-
Now that that's out of the way, what I am trying to do is find
objective material comparing the use of MS Windows 2000
Server on Intel HW to Solaris on Sun HW.


My personal bias against Windows is based mostly on three things.

1.  Incompatibility with everything else.  Microsoft makes its products as
incompatible as it can get away with so that once you start going down the
Microsoft path, you become more and more locked into that path.

2.  It is a single-user operating system.  Microsoft has done a pretty good
job of making it look otherwise by tacking on some multi-user extensions;
but it is, in fact, NOT a multi-user OS.  Just try creating a general user
so that user can install, upgrade, and maintain their application without
having administrator privilege.  It ain't gonna happen.  And that brings up
the main problem with this arrangement: Every user that must support an
application on the box must have administrator privilege.  This, of course,
presents a completely insecure environment.

3.  In its normal form, there is an amazing lack of the kind of support
and scripting utilities the are normal on Unix.  True, if one wants to spend
the time, many of the utilities can be set up on NT; but that involves
additional setup and maintenance time -- which your NT admins might not be
inclined to do if the bureaucracy of your organization requires that they do
it.  If your scripting abilities are substantial, then you, no doubt,
automate many things with scripts.  If you have built these scripts with a
non-standard environment, then you have built your house on shifting sand.
(By the way, this is why I do not fully support Linux.)

I must agree that I do like the Dell Poweredge stuff.  I was using it years
ago, and the value is certainly compelling.  It's too bad that Sun did the
same thing with Solaris on Intel that IBM did to OS/2 (got very stuck up
about it and over-priced the crap out of everything until it was too late).
But the Sun hardware (and IBM too) ain't all that shabby either.  And my
past experience -- when I was a sys admin work -- with Sun customer support
was very positive. IBM  eh, so-so ... maybe.

Perhaps another thing to consider: If you have ever tried to upgrade the OS
on a NT box supporting third-party 

Re: ORACLE-Function problem

2002-11-11 Thread Savita
Hi justin,

Thanks for the help,actually this query will send to an XML Processore and
lt;
will replaced  with .But my problem was something else.I have resolved that
problem now.

Thanks once again for the help.

Justin Cave wrote:

 At 12:33 AM 11/11/2002, you wrote:

 select
 OSP_CRM_EXCHANGE_CASE_VIEW.OS_CASE_ID  as CASE_MSG__OS_CASE_ID,
 OSP_CRM_EXCHANGE_CASE_VIEW.OS_CUSTOMER_ID  as CASE_MSG__OS_CUSTOMER_ID,
 OSP_CRM_EXCHANGE_CASE_VIEW.OS_CUSTOMER_ID  as CASE_MSG__OS_CUST_ID,
 OSP_CRM_EXCHANGE_CASE_VIEW.OS_UNIT_ID  as CASE_MSG__OS_UNIT_ID,
 OSP_CRM_EXCHANGE_CASE_VIEW.CREATED_DATE as CASE_MSG__CREATED_DATE,
 'OS_1' as CASE_MSG__UPDATED_BY
 FROM OSP_CRM_EXCHANGE_CASE_VIEW
 WHERE
 ROWNUM lt;=(40 - OSP_CRM_EXCHANGE_getMaxDataId(2))
 ORDER BY to_number(OSP_CRM_EXCHANGE_CASE_VIEW.OS_CASE_ID);

 Do you intend for the lt; to be in the query?  I'm not sure what you
 expect this to do, but I suspect that's your illegal character.

 here OSP_CRM_EXCHANGE_getMaxDataId(2) is the function.
 
 When I execute this query in command prompt Itis working fine,but when I
 use it insied a executeQueryStatement(query) in JDBC I am getting
 following error
 ORA-00911: invalid character
 
 I am not able to figure out how to modify this.
 
 Any help will be highly appriciated.
 
 --
 Best Regards
 - Savita
 
 Hewlett Packard (India)
 +91 80 2051288 (Phone)
 847 1288 (HP Telnet)
 
 

 Justin Cave
 Distributed Database Consulting

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

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

--
Best Regards
- Savita

Hewlett Packard (India)
+91 80 2051288 (Phone)
847 1288 (HP Telnet)



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

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

2002-11-11 Thread James J. Morrow
Jared --

I tend to agree with your statements.  Although, personally, I tend to think 
that Windows NT/2000/XP is a wholly inappropriate environment for any enterprise 
database.  The general reasons I tend to choose to back my statements:

1.	Scalability.  (I'm sorry, clustering is an availability solution,
	not a scalability one.  If you can't grow beyond 4 CPUs [Intel's problem
	more than M$FT's, here] and need to, then an Intel platform is not for
	you.)

2.	Managibility.  I can do practically anything I need to on a unix box
	over a 300bps modem, if necessary.  (This omits, of course, inserting
	media and hitting the power switch... oh, and installing oracle now that
	they have this java-based installer... fortunately, that's not *that* 	
	common of an occurance in ordinary maintenance)

3.	Did I mention scalability?  Most *nix platforms scale in a much more
	linear fashion.  (i.e. 2 cpu's are more likely to give you double the
	performance on a RISC-based system than on an x86 based one.)  Note:
	I'm saying only that RISC systems tend to be *more* linear than x86
	ones.

4.	Supportability.  (yeah, I know, not really a word).  I've supported
	Oracle on both (especially Oracle Applications).  Personally, unix
	platforms tend to provide much more useful information when something
	does go wrong.  The standard Microsoft error message of it's broke
	doesn't really tell me anything useful.

5.	Security.  How many security flaws have been found in 'doze?  And don't
	even get me started on M$FT Look-out!  (otherwise known as a security
	hole that occasionally delivers mail).  It's also nice that *nix
	platforms are immune to all of the _really_common_ virii that hit the
	news these days (Melissa, I Love You, etc.).  (Not that *nix is truly
	immune to virii... but the big-bad-ugly-ones you hear about tend to
	exploit flaws in... hows that again?  Right... Windows and Lookout...
	Although it helps somewhat that the *nix security model tends to
	compartmentalize things a bit more than windows does [by default]).

6.	Do you *really* want all of the overhead of a tightly-coupled GUI on a
	_server_?

Admittedly, Windows 2000 does appear to be far more stable than previous 
versions.  And the NT-derivatives don't tend to crash in a wholesale manner like 
the Windows/386 derivatives ('95,'98,ME).  But, personally, I should _NEVER_ 
have to reboot a machine to upgrade/patch a web browser.

-- James

==
James J. Morrow
Nascent Systems, Inc.
Dallas, TX
mailto:jmorrow;warthog.com

[EMAIL PROTECTED] wrote:
Dear List,

Believe me, I am not trying to rehash an old topic, start any
flame wars, nor look for supporting evidence for my admitted
bias toward unix operating systems.

Now that that's out of the way, what I am trying to do is find
objective material comparing the use of MS Windows 2000
Server on Intel HW to Solaris on Sun HW.

This is for an SAP implementation.  We are currently running
SAP 4.0b on MS NT 4.0 SP 6, on Dell 4 CPU Servers. ( I forget
just which server )

As part of our process to upgrade the system to 4.6c and more
recent versions of Oracle ( like 8.1.7 ), we are trying to do a 
comparison of the features, benefits and advantages of using
Win2k Server and Solaris.

Please don't refer me to such sites as www.kirch.net and
www.osdata.com.   The information at www.kirch.net is dated
and applies to NT, not Win2k. 

osdata.com is a nice site, but doesn't really offer comparisons,
just information on each OS. 

There is quite a bit of material available at www.microsoft.com.

Try:  http://www.microsoft.com/windows2000/server/evaluation/compare/

PC Mag has a nice article comparing different platforms for use as a 
webserver: http://www.pcmag.com/article2/0,4149,6615,00.asp

They actually chose IBM running Windows 2000.

Windows 2000 is in use here as a server platform for one database that
is used as the backend to a rather troublesome application.  The Win2k
server is running Oracle 8.1.6.2.  The database has been bounced 2 or
3 times in the last year. 

Once was to clear up a strange but non-fatal problem with Oracle.  That 
was
back in July, the previous system restart had been in December 2001. 
Server
and database were up without interruption for 7 months.

Though I prefer Solaris,  I'm having a difficult time coming up with many 
valid
reasons for recommending it over Win2k.

A few that I do have:

Sun service is superior to Dell service.  They've proven this to us.  ( We 
have other
Sun machines in house )

Sun scales better.  At least on 32 bits.  We're at 4 CPU's.  If we need to 
go past that
I would think we should go with Sun.  I don't know about Win2k Advanced 
Server, as it
is a 64 bit platform, and I think the licensing would go up quite a bit.

I welcome all objective comparisons of Solaris and Win2k Server, whether 
your own
thoughts, or a link or links to articles you are aware of.

Thanks,

Jared








--

URGENT

2002-11-11 Thread dilmohan
Hi,
While trying to compile a procedure i face the error
PLS-00201 - sys.dbms_lock  must be declared

Which script do I need to run for this.

Regards

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

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



Schedule Backup in UNIX

2002-11-11 Thread ASHRAF SALAYMEH
Dear List,

We are working with Oracle 8i Database under UnixWare
Plateform.

My question is How to do Schedule Backup?

I tried to do Schedule backup but it does not work.
I'll show u the steps that I did...

1) I wrote my batch.
2) cd /var/spool/cron/crontabs
3) crontab -e oracle
   it will open a text file.
Oracle-
#
5 14 * * * /usr/oracle/backup.ksh 21 1/dev/null
# 
---

4) cd /usr/oracle

5) I did write backup.ksh like this:
backup.ksh-
#
# This Procedure for ORACLE export
#
exp payroll/pay file=/usr/oracle/pay02.dmp
#
exit
---

Any clues why this is not working ...

regards,

Ashraf 



__
Do you Yahoo!?
U2 on LAUNCH - Exclusive greatest hits videos
http://launch.yahoo.com/u2
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: ASHRAF SALAYMEH
  INET: [EMAIL PROTECTED]

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