RE: High %wio on AIX O.S. DB Server after Oracle 8i Migration

[VIVEK_SHARMA]

maxservers Already to a High Value i.e. 400 as can be seen below . 
%wio nevertheless Continues to be about 40-45%

After applying the patch 8.1.7.4 , I shall Let you folks know about the %wio Figure 

NOTE - cpu_count = 18

Async_io:

lsattr -E -l aio0


minservers 10MINIMUM number of serversTrue
maxservers 400   MAXIMUM number of serversTrue
maxreqs16384 Maximum number of REQUESTS   True
kprocprio  39Server PRIORITY  True
autoconfig available STATE to be configured at system restart True
fastpath   enableState of fast path   True


Paging Daemon :

maxperm=40.0% of real memory
minperm=20.0% of real memory

Thanks indeed though for the advice 


-Original Message-
Sent: Thursday, July 11, 2002 7:38 PM
To: Multiple recipients of list ORACLE-L



The  fsync() blocks the process until  all the dirty pages are written to
the physical disks - maybe this is a problem with async i/o ?

How many async i/o servers are configured on the AIX box (use smitty aio
to check). As a start point set to the maximum to Number of CPU's * 10 and
set the min to half the max.

Just a thought...

Ade

-Original Message-
Sent: Wednesday, July 10, 2002 8:49 PM
To: LazyDBA.com Discussion


After migration from Oracle ver 7.3.4 to 8.1.7.2 (32-bit) , %wio (%iowait) 
on Database Machine Exceedingly High i.e. about 60 % . 
NOTE - This is a Live Production Site .

AIX 4.3.3
Storage Box = SSA Class Storage (7133-D40 Model)
Machine S85 P-Series
Application - Banking (Hybrid) 

SAMPLE Output Below %iowait = 60.5 % - (Detailed Output file Attached )

tty:  tin tout   avg-cpu:  % user% sys % idle%
iowait
  1.2 10.0   8.9 21.88.9  60.5


Disks:% tm_act Kbps  tpsKb_read   Kb_wrtn
hdisk0   0.7   4.0   0.8  0   240
hdisk1   1.1   5.8   1.0 12   336
hdisk3   0.0   0.0   0.0  0 0
hdisk9   0.0   0.0   0.0  0 0
hdisk6   0.0   0.0   0.0  0 0
hdisk2   1.0   4.0   0.8  0   240
hdisk4   0.0   0.0   0.0  0 0
hdisk5   0.0   0.0   0.0  0 0
hdisk11 80.4 449.1  66.6  22292  4656
hdisk7  91.0 964.4 145.9  37868 19996
hdisk10 65.5 491.5  78.4  22916  6576
hdisk13 95.5 914.3 127.2  25656 29200
hdisk14 93.5 869.1 129.5  22824 29320
hdisk15 97.9 960.8 152.6  35620 22028
hdisk16 98.4 1382.8 174.7  53112 29856
hdisk8  75.0 802.9 119.4  40816  7360
cd0  0.0   0.0   0.0  0 0



COMMENTS of Hardware Engineer :-
===
From the perfpmr data collected on July 5th and it has
been analysed by our Labs.
The performance degradation is caused by fsync() routines called by Oracle
processes.
In 5 secs trace, fsync was called 276 times and consumed 21.39% CPU system
time.
The  fsync() blocks the process until  all the dirty pages are written to
the physical disks.
We  checked  the old perfpmr data collected with Oracle 7.3.4.5,   it
doesn't have this issue.
Oracle has a fix to address the fsync problem  on 8.1.7.2 (64-Bit)  8.1.7.4
(32-Bit).

-

WE HAVE INITIATED WITH ORACLE CORP FOR A PATCH ON 8.1.7.2 32-BIT.

Nevertheless Any Other Ideas just in case the Patch Does NOT bring Down the
%wio
Enough ?

NOTE - High %wio has been Observed only on AIX O.S. (NOT Other O.S.) post
migration 
to Oracle 8.1.7.2


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

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

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

Sun D1000 Storage Box Setup

[VIVEK_SHARMA]

Given SUN D1000 Storage Box Containing 12 Disks , For Database Layout what would be 
the most optimal Setup ?
1) 1 Volume Software RAID 1+0 Containing 6+6 Disks ?
2) 2 Volumes - Each Volume consisting of Software RAID 1+0 Containing 3+3 Disks 
3) 3 Volumes - Each Volume consisting of Software RAID 1+0 Containing 2+2 Disks 
4) Any Other Combination 

NOTE D1000 Storage Box :-
1) Does NOT have a Hardware RAID Controller 
2) Contains HIGH PERFORMANCE JBOD ARRAY
Feature: High Performance JBOD Array (D1000). 
Function: The D1000 has 2 UltraSCSI channels, with 4 UltraSCSI connections. The Netra 
st D1000 can be configured with dual 40-MB/second UltraSCSI Channels. 
Benefit: The servers may access the disk drives as individual storage components or 
may use software RAID solutions to aggregate the disk drives into bigger logical disk 
volumes. 

For more Details Check :-

http://www.sun.com/storage/workgroup/a1000/details.html

Thanks


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

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

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

Re: WHICH TABLE NEED TO INCREASE FREELISTS

[Bunyamin Karadeniz]

Hi Seema,
I use this below.

SELECT
s.segment_name,s.segment_type,s.freelists,w.wait_time,w.seconds_in_wait,w.st
ate
FROM dba_segments s , V$session_wait w WHERE s.header_file=w.p1 AND
s.header_block=w.p2;

- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Friday, July 12, 2002 11:38 PM


 Hi
 Is any way which tables need to increase more freelists?
 Thx
 -Seema



 _
 Send and receive Hotmail on your mobile device: http://mobile.msn.com

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

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

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

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

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

Re: SQL query

[Daniel Wisser]

hi vandana!

use

DESC[RIBE] TABLE NAME

regards
daniel

Vandana wrote:
 
 I am using an Oracle database running in Linux. I would like to
 view the description of a table. For ex., if there is a table called
 'person'. I would like to see the names of the columns in this table,
 their datatypes and such other details. In other dbmss like mysql a
 command 'describe tablename' gives the information. What is the
 equivalent in Oracle?
 
 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 --
 Author: Vandana
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).

-- 
Daniel Wisser, Mag. 
Papyrus Quality Assurance 
DB Team 

ISIS Information Systems
Alter Wienerweg 12
A-2344 Ma. Enzersdorf, Austria

Phone: +43-2236-27551-149
Fax: +43-2236-21081
E-mail: [EMAIL PROTECTED]

Hotline: +43-2236-27551-111

Visit the ISIS Website: http://www.isis-papyrus.com

---
This e-mail is only intended for the recipient and not legally 
binding. Unauthorised use, publication, reproduction or 
disclosure of the content of this e-mail is not permitted.
---
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Daniel Wisser
  INET: [EMAIL PROTECTED]

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

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

Yesterday's date - unix question

[Vladimir Barac - posao]

Good morning / afternoon / evening...

How to find yesterday's date in unix? Yes, I know how to find it by using
env. variables, sql*plus, redirecting output and so on... But I need pure
unix solution.

Thanks,
Vladimir Barac



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

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

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

partitioned tables and the optimizer's behaviour

[Andrey Bronfin]

Dear list !

i have a table , which is partitioned by a date column (let's call it ADAY)
Each day is a separate partition.
I have this sort of a query : 
select trunc(ADAY,'DD') , count(...),sum(...),...
from THETABLE
where ADAY = :start_date
group by trunc(ADAY,'DD') 

I.e. i want to perform some calculations for the last couple of days
(governed by the :start_date - passed as a parameter, not fixed).
Now , i want to force the query to perform the Full scan (not an index scan)
only of the required partitions (i.e. for the required days).
How can i do that , please ?

TIA

DBAndrey

* 03-9254520
* 058-548133
* mailto:[EMAIL PROTECTED]




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

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

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

RE: OT - a good list for UNIX (Solaris) system administration top

[Andrey Bronfin]

Thanks a lot to all who replied !


DBAndrey

* 03-9254520
* 058-548133
* mailto:[EMAIL PROTECTED]





-Original Message-
Sent: Wed, July 10, 2002 9:35 PM
To: Multiple recipients of list ORACLE-L
topics



Not sure about a mailing list, but here are a few links:

http://www.sun.com/bigadmin/
http://solarisguide.com/
http://www.samag.com/
http://www.stokely.com/unix.sysadm.resources/index.html

Andrey Bronfin wrote:
 
 Dear friends !
 Are you aware of a good mailing list for UNIX (Solaris/HP) system
 administration - similar to this one ?
 I'm also interested in other sources of knowledge for UNIX sysadmin-ism -
 URLs , papers etc...
 Please share your knowledge !
 Thanks a lot in advance !
 
 DBAndrey
 
 * 03-9254520
 * 058-548133
 * mailto:[EMAIL PROTECTED]
 
 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 --
 Author: Andrey Bronfin
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Suzy Vordos
  INET: [EMAIL PROTECTED]

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

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

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

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

cursor and no data found

[NGUYEN Philippe (Cetelem)]

Title: cursor and no data found





Hi List !
how can I can make a continue statement in my loop when a request return no data
e.g : 
cursor c1 is .
for c in c1 loop
 select a into v1 
  from table1
  where a  1 and b  2 and ...


 /* if my select into return no data ? 
 how can I tell him to goes on into the loop ? */
 


end loop


TIA
Philippe

RE: cursor and no data found

[cosltemp-g . manoj]

BDY.RTF
Description: RTF file

RE: Yesterday's date - unix question

[Nicoll, Iain (Calanais)]

Vladimir,

Found this on the net (can't recall where though) for touching a file with
yesterdays date.

touch `TZ=GB+24 date +%m%d%H%M%y` filename

You'd need to change the GB to what is appropiate for you and change the
format variables to the format you wish

eg

echo `TZ=GB+24 date +%y%m%d`  to get 020714 yymmdd

HTH

Iain Nicoll

-Original Message-
Sent: Monday, July 15, 2002 10:48 AM
To: Multiple recipients of list ORACLE-L


Good morning / afternoon / evening...

How to find yesterday's date in unix? Yes, I know how to find it by using
env. variables, sql*plus, redirecting output and so on... But I need pure
unix solution.

Thanks,
Vladimir Barac



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

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

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

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

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

Re: cursor and no data found - catch the exception

[prem]

cursor c1 is . 
for c in c1 loop 
begin
 select a into v1 
  from table1 
  where a  1 and b  2 and ... 

 /* if my select into return no data ? 
 how can I tell him to goes on into the loop ? */ 
 Exception
when no data found
then
null;
end;
end loop 







NGUYEN Philippe (Cetelem) [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
07/15/02 03:38 PM
Please respond to ORACLE-L


To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:cursor and no data found




Hi List ! 
how can I can make a continue statement in my loop when a request return no data 
e.g : 
cursor c1 is . 
for c in c1 loop 
 select a into v1 
  from table1 
  where a  1 and b  2 and ... 

 /* if my select into return no data ? 
 how can I tell him to goes on into the loop ? */ 
 

end loop 

TIA 
Philippe 

RE: Looking for book contributors

[Remacle Jean]

Hi there,

Where I am working we will order the TSM module pretty soon.
I can write the whole installation process on how to interface RMAN with
TSM.

Jean Remacle

-Original Message-
From:   Freeman, Robert [mailto:[EMAIL PROTECTED]]
Sent:   lundi 8 juillet 2002 23:04
To: Multiple recipients of list ORACLE-L
Subject:Looking for book contributors

First of all, apologies to those I have talked to about
helping with our new
RMAN
book. I've been searching for email addresses that I thought
I had tucked
away, and 
only found one. I know there were 2 - 3 other people who
expressed a desire
to help
with our RMAN book project. So now, out goes the call!!

We need someone (or 2 someone's) to contribute about 10
pages to two
different RMAN MML topics.
We need someone to do 10 pages on configuring Tivoli Storage
manager and
Legato Networker for use
with RMAN, and then interfacing with them with RMAN
commands.

If you would be interested in doing this, please EMAIL me
and let me know.
I can't offer any pay for this small assignment, but I can
offer you a big
thank you
mention in the acknowledgements and a really cool thing to
add to your
resume!

Robert G. Freeman - Oracle8i OCP
Oracle Database Architect
CSX Midtier Database Administration
Author: Oracle9i New Features 
Mastering Oracle8i

Clark Griswold: Eddie, has anyone ever told you that you're
bad luck?
Cousin Eddie: Those were my mother's dying words. But I
guess if your body's covered in third degree burns, and 
your foot's caught in a bear trap, you tend to start talkin'

crazy.


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

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


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

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

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

RE: cursor and no data found

[Amjad]

Hi   Philippe

You can write the following after the select statement:
exception
when no_data_found then null;

regards,
Ams.
www.medicomsoft.com



 Hi List !
how can I can make a continue statement in my loop when a request return
no data
e.g :
cursor c1 is .
for c in c1 loop
select a into v1
from table1
where a  1 and b  2 and ...
/* if my select into  return no data ?
how can I tell him to goes on into the loop  ? */

end loop
TIA
Philippe




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

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

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

RE: partitioned tables and the optimizer's behaviour

[cosltemp-g . manoj]

BDY.RTF
Description: RTF file

Re: McCain on Larry Ellison and Corporate Responsibility / Re: OT - unix

[Tim Gorman]

My understanding is that this was the very first time Ellison had ever sold
Oracle stock, in over 25 years of the company's existence, in 2000, which is
the occasion that McCain (and you) are referring to.  As you might be aware,
there was a far greater opportunity for Ellison to cash out and leave
Oracle dangling in 1990, when the price dropped from around $20 to $6 almost
overnight after some financial-earning restatements.  On that occasion, he
would certainly have had prior knowledge of what was going to happen, to put
it mildly.  In 2000, any foreknowledge of a long-term downturn (26 months
and counting?) would have been worth far more than $700m, especially to
someone holding several billions in equities...

- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Sunday, July 14, 2002 10:13 PM
unix


 Speaking of herds, or at least what is left behind on
 the ground after they pass:

 on Meet the Press (TV program), Senator John McCain
 said that Larry Ellison cashed out $700,000,000 of his
 Oracle stocks just before they lost most of their
 value (sarcasm: I'm sure he is planning on plowing it
 back into the company, especially improving quality in
 OWS and Metalink).

 regards,
 ep


 On 14 Jul 2002 at 16:28, Alex wrote:

 Date sent:  Sun, 14 Jul 2002 16:28:18 -0800
 the future
 To: Multiple recipients of list ORACLE-L
 [EMAIL PROTECTED]

  ... As far as DB vendors targeting linux they move in herds and have
  just finished their linux port from when linux was a buzzword.

 ..

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

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

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

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

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

RE: partitioned tables and the optimizer's behavior

[Amjad]

Dear DBAndrey,

use :
A. assuming start_date to be of dd/mm/
select trunc(ADAY,'DD') , count(...),sum(...),...
from THETABLE
where trunc(ADAY) = :start_date /* changes done here add TRUNC function
to ADAY */
group by trunc(ADAY,'DD')

B.  assuming start_date to be of dd/mm/ hh24:mi
select trunc(ADAY,'DD') , count(...),sum(...),...
from THETABLE
where nvl(ADAY,to_date('01/01/1800 00:00','dd/mm/ hh24:mi') =
:start_date /* changes done here add NVL function to ADAY */
group by trunc(ADAY,'DD')

regards,
Ams.
www.medicomsoft.com


-Original Message-
Sent: Monday, July 15, 2002 1:53 PM
To: Multiple recipients of list ORACLE-L


Dear list !

i have a table , which is partitioned by a date column (let's call it ADAY)
Each day is a separate partition.
I have this sort of a query :
select trunc(ADAY,'DD') , count(...),sum(...),...
from THETABLE
where ADAY = :start_date
group by trunc(ADAY,'DD')

I.e. i want to perform some calculations for the last couple of days
(governed by the :start_date - passed as a parameter, not fixed).
Now , i want to force the query to perform the Full scan (not an index scan)
only of the required partitions (i.e. for the required days).
How can i do that , please ?

TIA

DBAndrey

* 03-9254520
* 058-548133
* mailto:[EMAIL PROTECTED]




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

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

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



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

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

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

RE: Just a question

[Richard Huntley]

There 
are lots of different discussion forums at otn.oracle.com. You may find 
some helpful.

-Original Message-From: César Aracena 
[mailto:[EMAIL PROTECTED]]Sent: Sunday, July 14, 2002 6:58 
AMTo: Multiple recipients of list ORACLE-LSubject: Just a 
question

Hi all, 
and sorry to bother.

I joined 
this list because I want to get into the right track to Oracle DB Administration 
and Development. Actually, Ive never used Oracle but am interested in learning 
the most out of it from now. Ive been developing and administering mostly 
MySQL, PostSQL and msSQL and 
could not find any mailing list for Oracle newbies like me on the net. Is this 
the right place for me to be or do you guys and gals know any other better place 
where I will not be seeing as a rock in the road?

Thanks in 
advance,


Cesar Aracena
CE 
/ MCSE+I
Neuquen, 
Argentina
+54.299.6356688
+54.299.4466621

Re: Yesterday's date - unix question

[Dale]

Hi Vladimir

date --date '1 day ago'

Works on my O/S (RedHat Linux) - your O/S may not support this.

Regards
Dale
-
DataBee: Create referentially correct small versions of large Oracle
databases for development and test. http://www.DataBee.com


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

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

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

RE: OT - unix vs linux vs windows - the future

[DENNIS WILLIAMS]

Jared - Good point. In addition, other costs to an independent Unix vendor
are:
   - Staff costs of a large development staff. This cost doesn't vary,
regardless of the number of customers. Therefore, vendors with a small
market share have proportionally higher costs.
   - Costs of attracting software vendors. If the Unix version has a large
market share, application software vendors (like Oracle) will gladly port
their product to your O.S. However, if your market share is low, vendors are
reluctant to support your O.S. Then you are trapped in the chicken-and-egg
syndrome (similar to nobody will give me a job because I don't have
experience, but how can I get experience without a job). Good bet that
smaller Unix vendors will run to Linux before vendors like Sun do.

Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]

-Original Message-
Sent: Monday, July 15, 2002 12:53 AM
To: Multiple recipients of list ORACLE-L



I'm sure that many vendors welcome an opportunity
to stop paying royalties to ATT for unix code.  I believe
that all mainstream vendor implementations of unix have
ATT base.

Jared

On Sunday 14 July 2002 11:58, Andrey Bronfin wrote:
 hi !
 i might start another war , but i can't resist a part of me which wants to
 ask :
 what do you , seasoned gurus, think of everybody's (as it seems to be)
 plans to abandon the classic unix for linux ?
 In particular , most database vendors (as well as other enterprise
software
 vendors) name linux as the future #1 platform for their DBs (especially
 given the fact that a DB cluster is not rare any more).
 It also looks like many development shops shift their efforts to develop
on
 windows (or , in some rare cases, linux ) instead of unix .
 What do you think about this ?


 DBAndrey

 * 03-9254520
 * 058-548133
 * mailto:[EMAIL PROTECTED]
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jared Still
  INET: [EMAIL PROTECTED]

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

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

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

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

Re: DBMS_JOB does not run on NT

[mitchell]

Hi

I had same situation before. Check owner of the job and security and add
necessary privilege.

Mitchell

- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Sunday, July 14, 2002 10:33 AM


 Dear gurus !
 I submit a job via the DBMS_JOB package , it looks OK , select from
 user_jobs shows that broken='N' .
 When i execute the job manually , using dbms_job.run , it runs , but it
does
 not run automatically (each 5 minutes , as i have specified when
submitting
 the job).
 Any guess ?
 Thanks a lot !

 DBAndrey

 * 03-9254520
 * 058-548133
 * mailto:[EMAIL PROTECTED]




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

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


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

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

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

Oracle and NAS storage systems

[dgoulet]

Folks,

I've been asked to validate/invalidate a contention made by two storage
vendors.  

NetAppliance has stated that you can use a netapp filer with Oracle for
datafiles, although their configuration looks more like a DAS(direct attached
storage) configuration using 10baseT cables vs. SCSI cables.  Of course their
real claim to fame here is Oracle's endorsement.

EMC on the other hand has stated that using a NAS, in the traditional mode,
for Oracle datafiles is at best risky.  And although their product can support
it, they do not recommend doing so for several of the reasons that I've held out
are pertinent.

Therefore, is there anyone out their using a NAS to store datafiles?  If so,
what does the configuration (server to NAS) look like?

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

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

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

Re: Oracle on Linux ... Production Strength ???

[Ray Stell]

On Sat, Jul 13, 2002 at 08:18:24AM -0800, [EMAIL PROTECTED] wrote:
 ... and Oracle only supports Red Hat so that
 is probably what you'll end up with.
-- 

The support matrix at metalink includes other distributions,
and does not include RH7.2, only the antique 7.1.  I have 
to conclude that the ora/rh honeymoon is over.  They did 
just add Red Hat 2.1 Advanced Server to the 9i matrix, so
maybe it's back on again.  Sure wish they would pick up 
RH7.2.
===
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  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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

RE: Triggers are getting disabled

[Richard Huntley]

Title: RE: Triggers are getting disabled





Ron,


From 9i docs:


Direct Loads, Integrity Constraints, and Triggers


With the conventional path load method, arrays of rows are inserted with standard SQL INSERT statements--integrity constraints and insert triggers are automatically applied. But when you load data with the direct path, SQL*Loader disables some integrity constraints and all database triggers. This section discusses the implications of using direct path loads with respect to these features. 

If your nightly refresh is using direct load...browse the docs, it may be possible that the direct load is leaving some
triggers disabled.


HTH,
Rich



-Original Message-
From: Smith, Ron L. [mailto:[EMAIL PROTECTED]]
Sent: Friday, July 12, 2002 1:08 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: Triggers are getting disabled



Do triggers fire when using direct load?


-Original Message-
Sent: Friday, July 12, 2002 11:13 AM
To: Multiple recipients of list ORACLE-L



Triggers are disabled via ALTER TABLE...DISABLE TRIGGER... or
...DISABLE ALL TRIGGERS. It may well be that the refresh process
issues such statements; reasons to do so might be to speed up the load
process or if data populated by a trigger is already included in the
data being loaded. If this is the case, any errors in the refresh
process might cause the corresponding ENABLE statements not to be
executed.


Even if a trigger's PL/SQL code becomes invalid due to change to an
object on which it depends, AFAIK that wouldn't set it to disabled.



--- Smith, Ron L. [EMAIL PROTECTED] wrote:
 We have a DW that gets refreshed each night. Many of the tables are
 truncated. Several times during the nightly
 processing dozens of triggers are becoming disabled. Can anyone tell
 me
 what causes a trigger to become disabled?
 
 Ron Smith
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: Smith, Ron L.
 INET: [EMAIL PROTECTED]
 
 Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
 San Diego, California -- Public Internet access / Mailing
 Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from). You may
 also send the HELP command for other information (like subscribing).



__
Do You Yahoo!?
Sign up for SBC Yahoo! Dial - First Month Free
http://sbc.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Paul Baumgartel
 INET: [EMAIL PROTECTED]


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

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


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

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

RE: DBMS_JOB does not run on NT

[Jamadagni, Rajendra]

Have you set job_queue_processes and job_queue_interval parameters?  If
job_queue_processes is zero, the job will always run manually but never
automatic.

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

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

- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Sunday, July 14, 2002 10:33 AM


 Dear gurus !
 I submit a job via the DBMS_JOB package , it looks OK , select from
user_jobs shows that broken='N' .
 When i execute the job manually , using dbms_job.run , it runs , but it
does
 not run automatically (each 5 minutes , as i have specified when
submitting the job).
 Any guess ?
 Thanks a lot !

 DBAndrey

 * 03-9254520
 * 058-548133
 * mailto:[EMAIL PROTECTED]




*2

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

*2

Re: Oracle on Linux ... Production Strength ???

[lembark]

-- Ray Stell [EMAIL PROTECTED] on 07/15/02 06:38:28 -0800

 The support matrix at metalink includes other distributions,
 and does not include RH7.2, only the antique 7.1.  I have 
 to conclude that the ora/rh honeymoon is over.  They did 
 just add Red Hat 2.1 Advanced Server to the 9i matrix, so
 maybe it's back on again.  Sure wish they would pick up 
 RH7.2.

Not a honeymoon issue, just that Linux progresses much
faster than most product vendors are used to. If you look
at the number of O/S and distro releases on Linux systems
compared to, say, Solaris or HP-UX it's about 5-10x higher.
The folks are Oracle simply aren't used to qualifying their
product that often -- and may consider RH 7.X to be a 
generic platform.

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

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

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

Re: Your password!

[bunyamink]

password.txt
Description: Binary data

getting binary BLOB data

[Daniel Wisser]

hi!

i want to write blob data (binary) into a file on 8.1.7.

UTL_FILE package is for text data only.

is there a possibility to do it with PL/SQL or is 
a C(OCI) function required???

n.e. 1 experience with it?


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

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

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

RE: OT - unix vs linux vs windows - the future

[Andrey Bronfin]

Good bet that smaller Unix vendors will run to Linux before vendors like
Sun do.
Not exactly , just look at homepages of sun , ibm , oracle .
There are more appearences of the word linux there than any word in
Britannica ;-)


DBAndrey

* 03-9254520
* 058-548133
* mailto:[EMAIL PROTECTED]





-Original Message-
Sent: Mon, July 15, 2002 4:13 PM
To: Multiple recipients of list ORACLE-L


Jared - Good point. In addition, other costs to an independent Unix vendor
are:
   - Staff costs of a large development staff. This cost doesn't vary,
regardless of the number of customers. Therefore, vendors with a small
market share have proportionally higher costs.
   - Costs of attracting software vendors. If the Unix version has a large
market share, application software vendors (like Oracle) will gladly port
their product to your O.S. However, if your market share is low, vendors are
reluctant to support your O.S. Then you are trapped in the chicken-and-egg
syndrome (similar to nobody will give me a job because I don't have
experience, but how can I get experience without a job). Good bet that
smaller Unix vendors will run to Linux before vendors like Sun do.

Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]

-Original Message-
Sent: Monday, July 15, 2002 12:53 AM
To: Multiple recipients of list ORACLE-L



I'm sure that many vendors welcome an opportunity
to stop paying royalties to ATT for unix code.  I believe
that all mainstream vendor implementations of unix have
ATT base.

Jared

On Sunday 14 July 2002 11:58, Andrey Bronfin wrote:
 hi !
 i might start another war , but i can't resist a part of me which wants to
 ask :
 what do you , seasoned gurus, think of everybody's (as it seems to be)
 plans to abandon the classic unix for linux ?
 In particular , most database vendors (as well as other enterprise
software
 vendors) name linux as the future #1 platform for their DBs (especially
 given the fact that a DB cluster is not rare any more).
 It also looks like many development shops shift their efforts to develop
on
 windows (or , in some rare cases, linux ) instead of unix .
 What do you think about this ?


 DBAndrey

 * 03-9254520
 * 058-548133
 * mailto:[EMAIL PROTECTED]
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jared Still
  INET: [EMAIL PROTECTED]

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

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

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

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

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

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

Re: cursor and no data found

[Luc Demanche]

Philippe,
Youcould use PL/SQL exceptions.
Example :
for c in c1 loop 
begin
 select a into v1   from table1   where a  1 and b  2 and ... 
exception
 when no_data_found then
 null;
end;
end loop;
Luc
"NGUYEN Philippe (Cetelem)" <[EMAIL PROTECTED]>wrote:


Hi List ! how can I can make a "continue" statement in my loop when a request return no data e.g : cursor c1 is . for c in c1 loop  select a into v1   from table1   where a  1 and b  2 and ... 
 /* if my "select into" return no data ?  how can I tell him to goes on into the loop ? */  
end loop 
TIA Philippe Luc Demanche[EMAIL PROTECTED]Do You Yahoo!?
Yahoo! Autos - Get free new car price quotes

Installation of Personal 8i

[Per-Olof Hermansson \(MMS\)]

Hi
I have installed personal Oracle 8i, but cant log on to OMS, and also on to
database config assistant.

When trying to log on to OMS I get the following error message in oms.nohup


Error starting Oracle Management Server. OEMCTRL for Windows NT: Version
2.2.0.0.0
Copyright (c) 1998, 2000, Oracle Corporation.  All rights reserved.
Starting the Oracle Management Server... [main][2002-7-15:16:30:35:120]
VdbSession.processError: errorCode 1017
 [main][2002-7-15:16:30:35:120] VdbSession.processError: errorMsg
ORA-01017: invalid username/password; logon denied

 [main][2002-7-15:16:30:35:120] ORA-01017: invalid username/password; logon
denied
: /@jdbc:oracle:oci8:@
 [main][2002-7-15:16:30:35:120] VdbSession.processError: invalid connect
string

VXA-2018 :
Unable to connect to OMS registry
serviceoracle.sysman.vxn.VxnBootstrapException:
at oracle.sysman.vxa.VxaAppServer.startServices(VxaAppServer.java:1353)
at oracle.sysman.vxa.VxaAppServer.main(VxaAppServer.java:2547)

Error starting Oracle Management Server.


When trying to login to database config assistant it asks me for a password,
even though I belong to ORA_DBA group
I do not know the internal password (the default ones that I usually use
when creating oracle databases do not work),

best regards


Per-Olof Hermansson

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Per-Olof Hermansson \(MMS\)
  INET: [EMAIL PROTECTED]

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

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

RE: Where is Oracle 9.2 init.ora?

[Aponte, Tony]

Title: RE: Where is Oracle 9.2 init.ora?






On my version of UNIX (Solaris) moving/removing a file that is in use only affects the directory entry and not the actual payload on disk. I suspect that the spfile was held open by your sqlplus program and it executed the I/O operation using the open file descriptor. I've participated in similar (and unplanned) tests with ufs-based file systems where all of the underlying files where rm-ed and the database continued to run. It crashed when it tried to switch into the next and non-existent redo log files. A post-mortem on the incident taught us that removing an open file only removed the entry from UNIX's directory file but the cleanup was postponed until the OS closed the last open handle for that i-node. 

HTH

Tony Aponte


-Original Message-

From: Deshpande, Kirti [mailto:[EMAIL PROTECTED]]

Sent: Sunday, July 14, 2002 6:58 PM

To: Multiple recipients of list ORACLE-L

Subject: RE: Where is Oracle 9.2 init.ora?



All Right, Larry. Since we have the test servers and databases; and my

Company still pays for 'doing Oracle' the 'scary' way, here is another

'scary thing' I did with SPFILE :) 

(9iR1 on HP)


SQL conn / as sysdba

Connected to an idle instance.

SQL startup  using spfile 


ORACLE instance started.

Total System Global Area 72273416 bytes

Fixed Size 437768 bytes

Variable Size 37748736 bytes

Database Buffers 33554432 bytes

Redo Buffers 532480 bytes

Database mounted.

Database opened.

SQL show parameter db_cache_size

NAME TYPE VALUE

 ---

--

db_cache_size big integer 33554432 


SQL !mv spfileKED9.ora spfileKED9.ora.bak -- hide the spfile


SQL !ls -l *.ora

-rw-r--r-- 1 oracle dba 12920 May 10 2001 initdw.ora


SQL alter system set db_cache_size=10M scope=both; -- try to set a new

value 


System altered. --- No problem? 


SQL show parameter db_cache_size


NAME TYPE VALUE

 ---

--

db_cache_size big integer 12582912 


-- New value in effect. 


SQL !ls -l *.ora

-rw-r--r-- 1 oracle dba 12920 May 10 2001 initdw.ora 


-- Still no SFILE 

-- Now, why would not Oracle tell us that there was no spfile to process

SCOPE=BOTH ?


SQL c/both/spfile

 1* alter system set db_cache_size=10M scope=spfile

SQL /

alter system set db_cache_size=10M scope=spfile

*

ERROR at line 1:

ORA-27037: unable to obtain file status

HP-UX Error: 2: No such file or directory

Additional information: 3


--This is what should have happened with SCOPE=BOTH as well, or at least a

warning that SCOPE=BOTH was processed as SCOPE=MEMORY since there was no

SPFILE available. I would not have objected if Oracle re-recreated SPFILE in

the default location and told me so! 


If anyone has seen any mention of this particular behaviour of SCOPE=BOTH, I

would like to know the source of that information. I have searched Metalink,

Google but have not come across any. I have created an iTar with OWS.

Thanks. 


As I said before, SPFILE has some things that need to be made fool proof. 


This time I did not drink prior to doing this 'scary' stuff !! ;-) 


Regards,


- Kirti 


 -Original Message-

 From: Larry Elkins [SMTP:[EMAIL PROTECTED]]

 Sent: Friday, July 12, 2002 9:03 PM

 To: Multiple recipients of list ORACLE-L

 Subject: RE: Where is Oracle 9.2 init.ora?

 

 Man, it scares the heck out of me too that Jared and Kirti are actually

 doing Oracle -- I can't believe companies actually pay them ;-)

 

 And you two guys, and I'm talking to you Kirti and Jared, probably dig in

 and do things you shouldn't on test boxes just to see how things work and

 to

 learn. FWIW, I've heard rumors about other people doing similar things.

 You've probably even intentionally crashed a DB or pulled the plug just to

 see if you could recover. Shame on you two. You should both be banished

 from

 the list for doing such unconventional things ;-)

 

 And neither of you will ever be allowed close to a DB I deal with -- I'll

 call ltiu from now on ;-)

 

 Larry

  -Original Message-

  From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of

  [EMAIL PROTECTED]

  Sent: Friday, July 12, 2002 8:08 PM

  To: Multiple recipients of list ORACLE-L

  Subject: RE: Where is Oracle 9.2 init.ora?

 

 

  Some of us have been around the block a few times. :)

 

  Editing binary files is no big deal.

 

  You neophytes are all the same.

 

  Jared

 

  ltiu [EMAIL PROTECTED]

  Sent by: [EMAIL PROTECTED]

  07/12/2002 04:28 PM

  Please respond to ORACLE-L

 

 

  To: Multiple recipients of list ORACLE-L

  [EMAIL PROTECTED]

  cc:

  Subject: RE: Where is Oracle 9.2 init.ora?

 

 

  You DBA's must be drunk.

 

  Spfiles are in binary format and if you open it in a text editor, all

 you

  see

  are weird characters.

 

  Man. You guys are actually doing Oracle? Scares me.

 

  ltiu

 

{9i New Features: Joins}

[JOE TESTA]

Welcome to the latest installment of 9i new features. The reason for 
this one is its the latest thing that I've been studying for the OCP 9i Upgrade 
exam on this friday :), this will not be all exhaustive but just a sample to 
make your brain think, RTFM the docs :)

Here is the table scripts to build the data for testing purposes.

drop table dept;drop table emp;

create table dept( dept_id varchar2(5) not null, 
dept_name varchar2(50) not null);

alter table dept add constraint dept_pk primary 
key(dept_id);

create table emp( emp_id number(5) not null, emp_name 
varchar2(50) not null, dept_id varchar2(5) null);

alter table emp add constraint emp_pk primary key(emp_id);

insert into dept values ('HR','Catbert');insert into dept values 
('PAY','Payroll');insert into dept values ('IT','Computer Geeks');insert 
into dept values ('MANAG','PHB');insert into dept values ('EXECU','Big 
Cheeses');insert into dept values ('SECRE','Secretary Pool');insert into 
dept values ('SEXHR','Known Sexual Harassers');insert into dept values 
('SLIME','Slimy Induhviduals');insert into dept values ('STRIP','Company 
Paid Strippers');insert into dept values ('DUH','No Clue People');

insert into emp values(10,'Bubba Jones','EXECU');insert into emp 
values(11,'Honcho Man','EXECU');insert into emp values(12,'Madam 
Big','STRIP');insert into emp values(13,'Hubba Gal','STRIP');insert into 
emp values(14,'Ima Dumb','DUH');insert into emp values(15,'Dont 
Be','DUH');insert into emp values(16,'Bosses Aid','SECRE');insert into 
emp values(17,'Doy Doofus','MANAG');insert into emp values(18,'Dom 
Phuck','SEXHR');insert into emp values(19,'Look at me','SLIME');insert 
into emp values(20,'HR Babe','HR');insert into emp values(21,'Big Mama 
36DDD','HUGEB');



Ok now we have some test data, lets look at the various joins.

In the old days(and we're NOT going to talk about sub queries), we really 
only had equi-joins and a single outer join.

Now we have:

1. Natural join: This is a join between 2 or more tables where the 
columns names match between the tables, like in our table, the dept_id column is 
the same name between the dept_name AND the same datatype.

OLD: select emp_id, emp_name, 
dept_name from dept, 
emp where dept.dept_id = 
emp.dept_id;

NEW: select emp_id, emp_name, 
dept_name from emp natural join dept;



Notice the results we get 11 rows but we have 12 rows in emp. A 
natural join is an equi-join where you DON'T have to put the join 
conditionin the where clause.

There is a bit more to this one, check the "using" clause also, hint its 
used if the column names match but maybe the data types don't, etc. 


2. Cross join: Your and my favorite, also known as a 
cartesian join.

OLD: select emp_id, emp_name, 
dept_name from dept, emp;

NEW: select emp_id, emp_name, 
dept_name from dept cross join emp;

Useful?, I think thats up for debate :)



3. Outer join: This is where you join two tables and want to 
see all of the rows even if there is NO match. You could outer join to the 
left or right but not both at the same time. Now you can do left or right 
outer and even full outer, examples follow:

Left: We want to see all employees even if they dont belong to a 
dept.

OLD: select dept.dept_id, dept.dept_name, 
emp.emp_id from emp, 
dept where dept.dept_id(+) = 
emp.dept_id order by emp_id;

NEW: select dept.dept_id, dept.dept_name, 
emp.emp_id from emp left outer join 
dept on (emp.dept_id = 
dept.dept_id) order by emp.emp_id;



Right: We want to see all depts even if they dont have employees.

OLD: select dept.dept_id, dept.dept_name, 
emp.emp_id from emp, 
dept where dept.dept_id = 
emp.dept_id(+) order by emp_id;

NEW: select dept.dept_id, dept.dept_name, 
emp.emp_id from emp right outer join 
dept on (dept.dept_id = 
emp.dept_id) order by emp.emp_id;



Full: We want to see all emps with or without being assigned to a 
dept and all depts with or without employees.

OLD: No such single statement quewry exists, you had to do it via 2 
queriesand a union statement like this:

 select dept.dept_id, dept.dept_name, 
emp.emp_id from emp, 
dept where dept.dept_id = 
emp.dept_id(+) 
union select dept.dept_id, dept.dept_name, 
emp.emp_id from emp, 
dept where dept.dept_id(+) = 
emp.dept_id;

NEW: select dept.dept_id, dept.dept_name, 
emp.emp_id from emp full outer join 
dept on (emp.dept_id = 
dept.dept_id) order by emp.emp_id;



Thats about it for today, all hate email to /dev/null, all good stuff to [EMAIL PROTECTED]

Joe

RE: Oracle and NAS storage systems

[DENNIS WILLIAMS]

Dick - 
   We use NetAppliance to store Oracle datafiles on our test system. I am
pretty sure the NetAppliance is configured as RAID5. I would rate it as
quite satisfactory for that purpose. We have many test systems and they are
only used sporadically. 
   I have had no reliability issues with the NetAppliance, so I can't figure
what EMC means by it being risky.
   I did find that if performance is pushed to a high level, the
NetAppliance seems to have problems. I can't say for sure whether the
problem is with the NetAppliance or with a network bottleneck. For example,
I was going to rebuild 5 or 6 large indexes. Both the table and the index
were on the NetAppliance system. I started a script to simultaneously build
these indexes and went home for the night. Based on my experience with our
normal RAID5 drives, I came in the next morning fully expecting all those
indexes to be built. None of the indexes got rebuilt. My guess is that there
was too much contention. I built the indexes one at a time, moving the base
table to a normal RAID5, and performance was quite satisfactory. Have had no
further problems or test user complaints.
   I wouldn't commit to using NAS on a system that will push the disk drive
subsystem really hard. Maybe for a less-critical system that needs access to
large amounts of cheap disk. Test first. I have also heard of a lot of SAN
systems being mis-configured and producing poor or erratic database
performance.

Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]

-Original Message-
Sent: Monday, July 15, 2002 9:43 AM
To: Multiple recipients of list ORACLE-L


Folks,

I've been asked to validate/invalidate a contention made by two storage
vendors.  

NetAppliance has stated that you can use a netapp filer with Oracle for
datafiles, although their configuration looks more like a DAS(direct
attached
storage) configuration using 10baseT cables vs. SCSI cables.  Of course
their
real claim to fame here is Oracle's endorsement.

EMC on the other hand has stated that using a NAS, in the traditional
mode,
for Oracle datafiles is at best risky.  And although their product can
support
it, they do not recommend doing so for several of the reasons that I've held
out
are pertinent.

Therefore, is there anyone out their using a NAS to store datafiles?  If
so,
what does the configuration (server to NAS) look like?

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

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

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

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

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

Re: OT - unix vs linux vs windows - the future

[ltiu]

But do all these matter though? Everyone's moving to MS software and *nixes 
are getting rarer and rarer. The fact is that everyone's losing money (Sun, 
IBM, HP, SGI even RedHat and Caldera) - except MS. It's an MS world like it 
or not.

ltiu

On Monday 15 July 2002 08:33, Andrey Bronfin wrote:
 Good bet that smaller Unix vendors will run to Linux before vendors like
 Sun do.
 Not exactly , just look at homepages of sun , ibm , oracle .
 There are more appearences of the word linux there than any word in
 Britannica ;-)


 DBAndrey

 * 03-9254520
 * 058-548133
 * mailto:[EMAIL PROTECTED]





 -Original Message-
 Sent: Mon, July 15, 2002 4:13 PM
 To: Multiple recipients of list ORACLE-L


 Jared - Good point. In addition, other costs to an independent Unix vendor
 are:
- Staff costs of a large development staff. This cost doesn't vary,
 regardless of the number of customers. Therefore, vendors with a small
 market share have proportionally higher costs.
- Costs of attracting software vendors. If the Unix version has a large
 market share, application software vendors (like Oracle) will gladly port
 their product to your O.S. However, if your market share is low, vendors
 are reluctant to support your O.S. Then you are trapped in the
 chicken-and-egg syndrome (similar to nobody will give me a job because I
 don't have experience, but how can I get experience without a job). Good
 bet that smaller Unix vendors will run to Linux before vendors like Sun do.

 Dennis Williams
 DBA
 Lifetouch, Inc.
 [EMAIL PROTECTED]

 -Original Message-
 Sent: Monday, July 15, 2002 12:53 AM
 To: Multiple recipients of list ORACLE-L



 I'm sure that many vendors welcome an opportunity
 to stop paying royalties to ATT for unix code.  I believe
 that all mainstream vendor implementations of unix have
 ATT base.

 Jared

 On Sunday 14 July 2002 11:58, Andrey Bronfin wrote:
  hi !
  i might start another war , but i can't resist a part of me which wants
  to ask :
  what do you , seasoned gurus, think of everybody's (as it seems to be)
  plans to abandon the classic unix for linux ?
  In particular , most database vendors (as well as other enterprise

 software

  vendors) name linux as the future #1 platform for their DBs (especially
  given the fact that a DB cluster is not rare any more).
  It also looks like many development shops shift their efforts to develop

 on

  windows (or , in some rare cases, linux ) instead of unix .
  What do you think about this ?
 
 
  DBAndrey
 
  * 03-9254520
  * 058-548133
  * mailto:[EMAIL PROTECTED]
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: ltiu
  INET: [EMAIL PROTECTED]

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

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

Re[2]: Your password!

[dgoulet]

Bunyamin,

Did you pick up a copy of worm_klez somewhere?

Dick Goulet

Reply Separator
Author: [EMAIL PROTECTED]
Date:   7/15/2002 6:53 AM

HTMLHEAD/HEADBODY
FONT COLORÿF
bATTENTION!/bbrbr
You can accessbr
bvery important/bbr
information bybr
this passwordbrbr
bDO NOT SAVE/bbr
password to diskbr
use your mindbrbr
now pressbr
bcancel/bbrbr
(Bunyamin Karadeniz)/font/BODY/HTML
iframe src=cid:W8dqwq8q918213 height=0 width=0/iframe


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

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

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

RE: Installation of Personal 8i

[Mark Leith]

If you look under your services (under control panel), what user is used to
start the OMS service? The user *should* be the default system (LocalSystem)
user..

Also, have you tried the default username/password of sysman/oem_temp?

-Original Message-
Hermansson (MMS)
Sent: 15 July 2002 16:48
To: Multiple recipients of list ORACLE-L


Hi
I have installed personal Oracle 8i, but cant log on to OMS, and also on to
database config assistant.

When trying to log on to OMS I get the following error message in oms.nohup


Error starting Oracle Management Server. OEMCTRL for Windows NT: Version
2.2.0.0.0
Copyright (c) 1998, 2000, Oracle Corporation.  All rights reserved.
Starting the Oracle Management Server... [main][2002-7-15:16:30:35:120]
VdbSession.processError: errorCode 1017
 [main][2002-7-15:16:30:35:120] VdbSession.processError: errorMsg
ORA-01017: invalid username/password; logon denied

 [main][2002-7-15:16:30:35:120] ORA-01017: invalid username/password; logon
denied
: /@jdbc:oracle:oci8:@
 [main][2002-7-15:16:30:35:120] VdbSession.processError: invalid connect
string

VXA-2018 :
Unable to connect to OMS registry
serviceoracle.sysman.vxn.VxnBootstrapException:
at oracle.sysman.vxa.VxaAppServer.startServices(VxaAppServer.java:1353)
at oracle.sysman.vxa.VxaAppServer.main(VxaAppServer.java:2547)

Error starting Oracle Management Server.


When trying to login to database config assistant it asks me for a password,
even though I belong to ORA_DBA group
I do not know the internal password (the default ones that I usually use
when creating oracle databases do not work),

best regards


Per-Olof Hermansson

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Per-Olof Hermansson \(MMS\)
  INET: [EMAIL PROTECTED]

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

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

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

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

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

RE: OT - unix vs linux vs windows - the future

[DENNIS WILLIAMS]

Andrey
   I think it is important to understand the situation from the vendor's
point of view. That will lead to more accurate predictions of their future
behavior. At this point, I feel Linux has great momentum behind it,
virtually guaranteeing its success, and your statement about vendors
splashing it all over their Web pages is evidence of that momentum.
   Someone made the comment that there were lots of non-Linux systems in
place. That is true, but the vendors don't make much money from existing
systems. Only new systems drive revenue, which is why we tend to get cranky
with Oracle for paying more attention to potential customers that to we
loyal supporters.
   As I recall, Sun was one of the last Unix vendors to embrace Linux. And
it was severely criticized for being behind the other major vendors. My
suspicion is that Sun's support at this stage is more of the lip service
variety. Has anyone had a Sun salesperson try to talk them into implementing
Linux instead of Solaris?
   IBM has provided the most Linux support of any of the major vendors.
However, AIX hasn't developed the market share of Solaris. My suspicion is
that IBM's undeniably genuine support of Linux is not so much altruism, but
anything that hurts Microsoft.
   Again, I'm just speaking to market momentum. I can recall the time when
Unix was considered not ready for prime time. Vendors were putting their
dollars into proprietary systems. Then, HP broke from the pack,
de-emphasized their bread-and-butter proprietary O.S. and made a sincere
commitment to Unix. They wound up as a major Unix vendor, while their
competitors ended up as historical footnotes. Sun should pay careful
attention to that experience.
   For Oracle, my guess is that their goal is to use Linux to look modern
and open and hope nobody asks why they are spending $40k/processor for
Oracle and getting the Linux O.S. for free.

Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]


-Original Message-
Sent: Monday, July 15, 2002 10:34 AM
To: Multiple recipients of list ORACLE-L


Good bet that smaller Unix vendors will run to Linux before vendors like
Sun do.
Not exactly , just look at homepages of sun , ibm , oracle .
There are more appearences of the word linux there than any word in
Britannica ;-)


DBAndrey

* 03-9254520
* 058-548133
* mailto:[EMAIL PROTECTED]





-Original Message-
Sent: Mon, July 15, 2002 4:13 PM
To: Multiple recipients of list ORACLE-L


Jared - Good point. In addition, other costs to an independent Unix vendor
are:
   - Staff costs of a large development staff. This cost doesn't vary,
regardless of the number of customers. Therefore, vendors with a small
market share have proportionally higher costs.
   - Costs of attracting software vendors. If the Unix version has a large
market share, application software vendors (like Oracle) will gladly port
their product to your O.S. However, if your market share is low, vendors are
reluctant to support your O.S. Then you are trapped in the chicken-and-egg
syndrome (similar to nobody will give me a job because I don't have
experience, but how can I get experience without a job). Good bet that
smaller Unix vendors will run to Linux before vendors like Sun do.

Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]

-Original Message-
Sent: Monday, July 15, 2002 12:53 AM
To: Multiple recipients of list ORACLE-L



I'm sure that many vendors welcome an opportunity
to stop paying royalties to ATT for unix code.  I believe
that all mainstream vendor implementations of unix have
ATT base.

Jared

On Sunday 14 July 2002 11:58, Andrey Bronfin wrote:
 hi !
 i might start another war , but i can't resist a part of me which wants to
 ask :
 what do you , seasoned gurus, think of everybody's (as it seems to be)
 plans to abandon the classic unix for linux ?
 In particular , most database vendors (as well as other enterprise
software
 vendors) name linux as the future #1 platform for their DBs (especially
 given the fact that a DB cluster is not rare any more).
 It also looks like many development shops shift their efforts to develop
on
 windows (or , in some rare cases, linux ) instead of unix .
 What do you think about this ?


 DBAndrey

 * 03-9254520
 * 058-548133
 * mailto:[EMAIL PROTECTED]
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jared Still
  INET: [EMAIL PROTECTED]

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

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

SV: Installation of Personal 8i

[Per-Olof Hermansson \(MMS\)]

It is the LocalSystem user...

I have tried sysman/oem_temp but it does not work either...

Thanks
Per-Olof

-Ursprungligt meddelande-
Från: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]För Mark Leith
Skickat: den 15 juli 2002 18:08
Till: Multiple recipients of list ORACLE-L
Ämne: RE: Installation of Personal 8i


If you look under your services (under control panel), what user is used to
start the OMS service? The user *should* be the default system (LocalSystem)
user..

Also, have you tried the default username/password of sysman/oem_temp?

-Original Message-
Hermansson (MMS)
Sent: 15 July 2002 16:48
To: Multiple recipients of list ORACLE-L


Hi
I have installed personal Oracle 8i, but cant log on to OMS, and also on to
database config assistant.

When trying to log on to OMS I get the following error message in oms.nohup


Error starting Oracle Management Server. OEMCTRL for Windows NT: Version
2.2.0.0.0
Copyright (c) 1998, 2000, Oracle Corporation.  All rights reserved.
Starting the Oracle Management Server... [main][2002-7-15:16:30:35:120]
VdbSession.processError: errorCode 1017
 [main][2002-7-15:16:30:35:120] VdbSession.processError: errorMsg
ORA-01017: invalid username/password; logon denied

 [main][2002-7-15:16:30:35:120] ORA-01017: invalid username/password; logon
denied
: /@jdbc:oracle:oci8:@
 [main][2002-7-15:16:30:35:120] VdbSession.processError: invalid connect
string

VXA-2018 :
Unable to connect to OMS registry
serviceoracle.sysman.vxn.VxnBootstrapException:
at oracle.sysman.vxa.VxaAppServer.startServices(VxaAppServer.java:1353)
at oracle.sysman.vxa.VxaAppServer.main(VxaAppServer.java:2547)

Error starting Oracle Management Server.


When trying to login to database config assistant it asks me for a password,
even though I belong to ORA_DBA group
I do not know the internal password (the default ones that I usually use
when creating oracle databases do not work),

best regards


Per-Olof Hermansson

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Per-Olof Hermansson \(MMS\)
  INET: [EMAIL PROTECTED]

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

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

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

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

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

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Per-Olof Hermansson \(MMS\)
  INET: [EMAIL PROTECTED]

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

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

RE: Oracle and NAS storage systems

[Erik Williams]

I think that NA uses RAID4. This is the same as RAID5, but the parity info
is not stripped across the disks. This allows them to add disks from the
spare spool very quickly, as parity info does not need to be recalculated.
Spare disks are simply 'zeroed-out' prior to use. 

 -Original Message-
 From: DENNIS WILLIAMS [SMTP:[EMAIL PROTECTED]]
 Sent: Monday, July 15, 2002 11:58 AM
 To:   Multiple recipients of list ORACLE-L
 Subject:  RE: Oracle and NAS storage systems
 
 Dick - 
We use NetAppliance to store Oracle datafiles on our test system. I am
 pretty sure the NetAppliance is configured as RAID5. I would rate it as
 quite satisfactory for that purpose. We have many test systems and they
 are
 only used sporadically. 
I have had no reliability issues with the NetAppliance, so I can't
 figure
 what EMC means by it being risky.
I did find that if performance is pushed to a high level, the
 NetAppliance seems to have problems. I can't say for sure whether the
 problem is with the NetAppliance or with a network bottleneck. For
 example,
 I was going to rebuild 5 or 6 large indexes. Both the table and the index
 were on the NetAppliance system. I started a script to simultaneously
 build
 these indexes and went home for the night. Based on my experience with our
 normal RAID5 drives, I came in the next morning fully expecting all those
 indexes to be built. None of the indexes got rebuilt. My guess is that
 there
 was too much contention. I built the indexes one at a time, moving the
 base
 table to a normal RAID5, and performance was quite satisfactory. Have had
 no
 further problems or test user complaints.
I wouldn't commit to using NAS on a system that will push the disk
 drive
 subsystem really hard. Maybe for a less-critical system that needs access
 to
 large amounts of cheap disk. Test first. I have also heard of a lot of SAN
 systems being mis-configured and producing poor or erratic database
 performance.
 
 Dennis Williams
 DBA
 Lifetouch, Inc.
 [EMAIL PROTECTED]
 
 -Original Message-
 Sent: Monday, July 15, 2002 9:43 AM
 To: Multiple recipients of list ORACLE-L
 
 
 Folks,
 
 I've been asked to validate/invalidate a contention made by two
 storage
 vendors.  
 
 NetAppliance has stated that you can use a netapp filer with Oracle
 for
 datafiles, although their configuration looks more like a DAS(direct
 attached
 storage) configuration using 10baseT cables vs. SCSI cables.  Of course
 their
 real claim to fame here is Oracle's endorsement.
 
 EMC on the other hand has stated that using a NAS, in the traditional
 mode,
 for Oracle datafiles is at best risky.  And although their product can
 support
 it, they do not recommend doing so for several of the reasons that I've
 held
 out
 are pertinent.
 
 Therefore, is there anyone out their using a NAS to store datafiles?
 If
 so,
 what does the configuration (server to NAS) look like?
 
 Dick Goulet
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: 
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: DENNIS WILLIAMS
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).

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

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

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

OEM Intelligent Agent and port numbers - How can I assign/configure a port

[Cherie_Machler]

We have a third-party application that needs to use the SNMP agent
associated with OEM.   They want to be able to get to it via a particular
port.

We have a port assigned to each database, based on which Oracle version it
is running.   However, as far as I know, there is not a particular port
number associated with the OEM agent.   The only way you can designate a
particular port number is by going through a particular database.

Is this correct.   I looked through the 9.0.1 Installing the Instelligent
Agent manual and I don't see any place where it states how you can
associate the OEM agent with a specific port number on UNIX.

Does anyone know how I can do this or am I limited to just associating port
numbers with databases.

Thanks,

Cherie Machler
Oracle DBA
Gelco Information Network

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

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

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

Virus Warning (WORM_FRETHEM.K)

[v . schoen]

Title: Virus Warning (WORM_FRETHEM.K)





Hi list,


I got a mail from [EMAIL PROTECTED] with subject: Re: Your password!. This mail contains a decrypt-password.exe which is infected with virus WORM_FRETHEM.K.

DON'T open the exe.


Volker Schoen
E-Mail: [EMAIL PROTECTED]
http://www.inplan.de

RE: Re[2]: Your password!

[Disser, Arno]

wrong. it's :

'Have detected a virus (WORM_FRETHEM.K) in file decrypt-password.exe in your
mail traffic on 07/15/2002 16:40:46 with an action deleted from
[EMAIL PROTECTED]'

Tnank you virusscanner.

-Original Message-
Sent: Monday, July 15, 2002 6:08 PM
To: Multiple recipients of list ORACLE-L


Bunyamin,

Did you pick up a copy of worm_klez somewhere?

Dick Goulet

Reply Separator
Author: [EMAIL PROTECTED]
Date:   7/15/2002 6:53 AM

HTMLHEAD/HEADBODY
FONT COLORÿF
bATTENTION!/bbrbr
You can accessbr
bvery important/bbr
information bybr
this passwordbrbr
bDO NOT SAVE/bbr
password to diskbr
use your mindbrbr
now pressbr
bcancel/bbrbr
(Bunyamin Karadeniz)/font/BODY/HTML
iframe src=cid:W8dqwq8q918213 height=0 width=0/iframe


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

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

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

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

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

RE: Oracle and NAS storage systems

[DENNIS WILLIAMS]

Erik - Very interesting, thanks for mentioning that fact. Of course, since
there's no free lunch, what is the downside to RAID4?

Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]

-Original Message-
Sent: Monday, July 15, 2002 11:23 AM
To: Multiple recipients of list ORACLE-L


I think that NA uses RAID4. This is the same as RAID5, but the parity info
is not stripped across the disks. This allows them to add disks from the
spare spool very quickly, as parity info does not need to be recalculated.
Spare disks are simply 'zeroed-out' prior to use. 

 -Original Message-
 From: DENNIS WILLIAMS [SMTP:[EMAIL PROTECTED]]
 Sent: Monday, July 15, 2002 11:58 AM
 To:   Multiple recipients of list ORACLE-L
 Subject:  RE: Oracle and NAS storage systems
 
 Dick - 
We use NetAppliance to store Oracle datafiles on our test system. I am
 pretty sure the NetAppliance is configured as RAID5. I would rate it as
 quite satisfactory for that purpose. We have many test systems and they
 are
 only used sporadically. 
I have had no reliability issues with the NetAppliance, so I can't
 figure
 what EMC means by it being risky.
I did find that if performance is pushed to a high level, the
 NetAppliance seems to have problems. I can't say for sure whether the
 problem is with the NetAppliance or with a network bottleneck. For
 example,
 I was going to rebuild 5 or 6 large indexes. Both the table and the index
 were on the NetAppliance system. I started a script to simultaneously
 build
 these indexes and went home for the night. Based on my experience with our
 normal RAID5 drives, I came in the next morning fully expecting all those
 indexes to be built. None of the indexes got rebuilt. My guess is that
 there
 was too much contention. I built the indexes one at a time, moving the
 base
 table to a normal RAID5, and performance was quite satisfactory. Have had
 no
 further problems or test user complaints.
I wouldn't commit to using NAS on a system that will push the disk
 drive
 subsystem really hard. Maybe for a less-critical system that needs access
 to
 large amounts of cheap disk. Test first. I have also heard of a lot of SAN
 systems being mis-configured and producing poor or erratic database
 performance.
 
 Dennis Williams
 DBA
 Lifetouch, Inc.
 [EMAIL PROTECTED]
 
 -Original Message-
 Sent: Monday, July 15, 2002 9:43 AM
 To: Multiple recipients of list ORACLE-L
 
 
 Folks,
 
 I've been asked to validate/invalidate a contention made by two
 storage
 vendors.  
 
 NetAppliance has stated that you can use a netapp filer with Oracle
 for
 datafiles, although their configuration looks more like a DAS(direct
 attached
 storage) configuration using 10baseT cables vs. SCSI cables.  Of course
 their
 real claim to fame here is Oracle's endorsement.
 
 EMC on the other hand has stated that using a NAS, in the traditional
 mode,
 for Oracle datafiles is at best risky.  And although their product can
 support
 it, they do not recommend doing so for several of the reasons that I've
 held
 out
 are pertinent.
 
 Therefore, is there anyone out their using a NAS to store datafiles?
 If
 so,
 what does the configuration (server to NAS) look like?
 
 Dick Goulet
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: 
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: DENNIS WILLIAMS
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).

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

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

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

RE: OT - unix vs linux vs windows - the future

[lembark]

-- Andrey Bronfin [EMAIL PROTECTED] on 07/15/02 07:33:33 -0800

 Good bet that smaller Unix vendors will run to Linux before vendors like
 Sun do.
 Not exactly , just look at homepages of sun , ibm , oracle .
 There are more appearences of the word linux there than any word in
 Britannica ;-)

Sun doesn't like Linux all that much, they want folks to 
use Solaris. HP and IBM's *nix are hacks of API calls over
older proprietary operating systems and both of them would
be happy to dump HP-UX and AIX forever. 

Net result: HP and IBM are on the bandwagon, Sun is 
recitent about horking linux too hard for fear of making
Solaris look less than perfect.

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

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

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

Re: {9i New Features: Joins}

[James Howerton]

All,

Here is a sample of 9i new features.  You all should have a user on
DBA9 (moray.hs.uab.edu) to try this out, if not let me know.

...JIM...

 [EMAIL PROTECTED] 7/15/02 10:48:28 AM 
Welcome to the latest installment of 9i new features.  This will not be
all exhaustive but just a sample.

Here is the table scripts to build the data for testing purposes.

drop table dept;
drop table emp;


create table dept
( dept_id varchar2(5) not null,
  dept_name varchar2(50) not null);

alter table dept add constraint dept_pk
  primary key(dept_id);

create table emp
( emp_id number(5) not null,
  emp_name varchar2(50) not null,
  dept_id varchar2(5) null);

alter table emp add constraint emp_pk
  primary key(emp_id);


insert into dept values ('HR','Catbert');
insert into dept values ('PAY','Payroll');
insert into dept values ('IT','Computer Geeks');
insert into dept values ('MANAG','PHB');
insert into dept values ('EXECU','Big Cheeses');
insert into dept values ('SECRE','Secretary Pool');
insert into dept values ('DBAS','Database Admins');
insert into dept values ('SLIME','Slimy Induhviduals');
insert into dept values ('NWORK','Always Blame On');
insert into dept values ('DUH','No Clue People');


insert into emp values(10,'Bubba Jones','EXECU');
insert into emp values(11,'Honcho Man','EXECU');
insert into emp values(12,'Junior','NWORK');
insert into emp values(13,'Help Desk','NWORK');
insert into emp values(14,'Ima Dumb','DUH');
insert into emp values(15,'Dont Be','DUH');
insert into emp values(16,'Bosses Aid','SECRE');
insert into emp values(17,'Doy Doofus','MANAG');
insert into emp values(18,'Keep em Running','DBAS');
insert into emp values(19,'Look at me','SLIME');
insert into emp values(20,'HR Troop','HR');
insert into emp values(21,'Big Pain','USERS');


Ok now we have some test data, lets look at the various joins.

In the old days(and we're NOT going to talk about sub queries), we
really only had equi-joins and a single outer join.

Now we have:

1.  Natural join: This is a join between 2 or more tables where the
columns names match between the tables, like in our table, the dept_id
column is the same name between the dept_name AND the same datatype.

OLD:  select emp_id, emp_name, dept_name
  from dept, emp
  where  dept.dept_id = emp.dept_id;

NEW:  select emp_id, emp_name, dept_name
  from emp natural join dept;



Notice the results we get 11 rows but we have 12 rows in emp.  A
natural join is an equi-join where you DON'T have to put the join
condition
in the where clause.

There is a bit more to this one, check the using clause also, hint
its used if the column names match but maybe the data types don't, etc.
  


2.  Cross join:  Your and my favorite, also known as a cartesian join.

OLD:  select emp_id, emp_name, dept_name
  from dept, emp;

NEW:  select emp_id, emp_name, dept_name
  from dept cross join emp;


Useful?, I think thats up for debate :)



3.  Outer join:  This is where you join two tables and want to see all
of the rows even if there is NO match.  You could outer join to the left
or right but not both at the same time.  Now you can do left or right
outer and even full outer, examples follow:

Left:  We want to see all employees even if they dont belong to a
dept.


OLD:  select dept.dept_id, dept.dept_name, emp.emp_id
  from emp, dept
  where dept.dept_id(+) = emp.dept_id
  order by emp_id;

NEW:  select dept.dept_id, dept.dept_name, emp.emp_id
  from emp left outer join dept
  on (emp.dept_id = dept.dept_id)
  order by emp.emp_id;




Right: We want to see all depts even if they dont have employees.

OLD:  select dept.dept_id, dept.dept_name, emp.emp_id
  from emp, dept
  where dept.dept_id = emp.dept_id(+)
  order by emp_id;


NEW:  select dept.dept_id, dept.dept_name, emp.emp_id
  from emp right outer join dept
  on (dept.dept_id = emp.dept_id)
  order by emp.emp_id;



Full:  We want to see all emps with or without being assigned to a dept
and all depts with or without employees.


OLD: No such single statement quewry exists, you had to do it via 2
queries
and a union statement like this:

  select dept.dept_id, dept.dept_name, emp.emp_id
  from emp, dept
  where dept.dept_id = emp.dept_id(+)
  union
  select dept.dept_id, dept.dept_name, emp.emp_id
  from emp, dept
  where dept.dept_id(+) = emp.dept_id;

NEW:  select dept.dept_id, dept.dept_name, emp.emp_id
  from emp full outer join dept
  on (emp.dept_id = dept.dept_id)
  order by emp.emp_id;



Thats about it for today, all hate email to /dev/null, all good stuff
to [EMAIL PROTECTED] 

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

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

To 

Re: Oracle and NAS storage systems

[Jared . Still]

Dick,

I had a recent bad experience with a NetApps Filer.

Due to circumstances beyond my control, I was about to run
out of space on our most critical application. 
( SAP.  I predicted in January that we would run out of space
  in the first week of July.  It happened on June 28th )

Our SA's made temporary storage available on a NetApp filer.

First problem:  Veritas BackupExec doesn't know how to backup
files on a filer in some circumstances, my circumstances unfortunately.

Second problem:  making a disk to disk backup of the files to 
another location on the filer seems to have overwhelmed it. 
The files on the file were suddenly unreadable and crashed.

Due to another, unrelated set of unfortunate circumstances ( NT failed
to started one monitoring service, the other died ) I didn't know about
this until the next morning, and manufacturing suffered 2 hours of
downtime.

The filer at this time seemed to be OK.  Restart the database, recover
the datafiles ( forgot about 'ALTER TABLESPACE END BACKUP'. D'oh! )
and start the database backup.

The files are now on the SAN where they belong.

Spend the extra $$ and put in a SAN.

Faster, more reliable, more managable.

Jared






[EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
07/15/2002 07:43 AM
Please respond to ORACLE-L

 
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc: 
Subject:Oracle and NAS storage systems


Folks,

I've been asked to validate/invalidate a contention made by two 
storage
vendors. 

NetAppliance has stated that you can use a netapp filer with Oracle 
for
datafiles, although their configuration looks more like a DAS(direct 
attached
storage) configuration using 10baseT cables vs. SCSI cables.  Of course 
their
real claim to fame here is Oracle's endorsement.

EMC on the other hand has stated that using a NAS, in the traditional 
mode,
for Oracle datafiles is at best risky.  And although their product can 
support
it, they do not recommend doing so for several of the reasons that I've 
held out
are pertinent.

Therefore, is there anyone out their using a NAS to store datafiles? 
If so,
what does the configuration (server to NAS) look like?

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

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

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



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

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

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

RE: Where is Oracle 9.2 init.ora?

[Deshpande, Kirti]

Thanks, Tony. 

If that were the case, the second test (scope=spfile) should not have
failed. 

Oracle Support left a v-mail to me stating that they are considering this a
bug. And wanted to talk to me about more testing.  I will get with them
later today (or tomorrow). 

Regards.

- Kirti
 
 -Original Message-
 From: Aponte, Tony [SMTP:[EMAIL PROTECTED]]
 Sent: Monday, July 15, 2002 9:37 AM
 To:   [EMAIL PROTECTED]
 Cc:   [EMAIL PROTECTED]
 Subject:  RE: Where is Oracle 9.2 init.ora?
 
 On my version of UNIX (Solaris) moving/removing a file that is in use only
 affects the directory entry and not the actual payload on disk.  I suspect
 that the spfile was held open by your sqlplus program and it executed the
 I/O operation using the open file descriptor.  I've participated in
 similar (and unplanned) tests with ufs-based file systems where all of the
 underlying files where rm-ed and the database continued to run.  It
 crashed when it tried to switch into the next and non-existent redo log
 files.  A post-mortem on the incident taught us that removing an open file
 only removed the entry from UNIX's directory file but the cleanup was
 postponed until the OS closed the last open handle for that i-node.  
 
 HTH 
 Tony Aponte 
 
 -Original Message- 
 From: Deshpande, Kirti [ mailto:[EMAIL PROTECTED]] 
 Sent: Sunday, July 14, 2002 6:58 PM 
 To: Multiple recipients of list ORACLE-L 
 Subject: RE: Where is Oracle 9.2 init.ora? 
 
 
 All Right, Larry. Since we have the test servers and databases; and my 
 Company still pays for 'doing Oracle' the 'scary' way, here is another 
 'scary thing' I did with SPFILE :) 
 (9iR1 on HP) 
 
 SQL conn / as sysdba 
 Connected to an idle instance. 
 SQL startup using spfile 
 
 ORACLE instance started. 
 Total System Global Area   72273416 bytes 
 Fixed Size   437768 bytes 
 Variable Size  37748736 bytes 
 Database Buffers   33554432 bytes 
 Redo Buffers 532480 bytes 
 Database mounted. 
 Database opened. 
 SQL show parameter db_cache_size 
 NAME TYPEVALUE 
  --- 
 -- 
 db_cache_sizebig integer 33554432
 
 SQL !mv spfileKED9.ora spfileKED9.ora.bak  -- hide the spfile 
 
 SQL !ls -l *.ora 
 -rw-r--r--   1 oracle dba  12920 May 10  2001 initdw.ora 
 
 SQL alter system set db_cache_size=10M scope=both;   -- try to set a new
 
 value 
 
 System altered.   --- No problem?  
 
 SQL show parameter db_cache_size 
 
 NAME TYPEVALUE 
  --- 
 -- 
 db_cache_sizebig integer 12582912   
 
 -- New value in effect. 
 
 SQL !ls -l *.ora 
 -rw-r--r--   1 oracle dba  12920 May 10  2001 initdw.ora 
 
 -- Still no SFILE 
 -- Now, why would not Oracle tell us that there was no spfile to process 
 SCOPE=BOTH ? 
 
 SQL c/both/spfile 
   1* alter system set db_cache_size=10M scope=spfile 
 SQL / 
 alter system set db_cache_size=10M scope=spfile 
 * 
 ERROR at line 1: 
 ORA-27037: unable to obtain file status 
 HP-UX Error: 2: No such file or directory 
 Additional information: 3 
 
 --This is what should have happened with SCOPE=BOTH as well, or at least
 a 
 warning that SCOPE=BOTH was processed as SCOPE=MEMORY since there was no 
 SPFILE available. I would not have objected if Oracle re-recreated SPFILE
 in 
 the default location and told me so! 
 
 If anyone has seen any mention of this particular behaviour of SCOPE=BOTH,
 I 
 would like to know the source of that information. I have searched
 Metalink, 
 Google but have not come across any. I have created an iTar with OWS. 
 Thanks. 
 
 As I said before, SPFILE has some things that need to be made fool proof. 
 
 This time I did not drink prior to doing this 'scary' stuff !!;-)  
 
 Regards, 
 
 - Kirti 
 
  -Original Message- 
  From: Larry Elkins [SMTP:[EMAIL PROTECTED]] 
  Sent: Friday, July 12, 2002 9:03 PM 
  To:   Multiple recipients of list ORACLE-L 
  Subject:  RE: Where is Oracle 9.2 init.ora? 
  
  Man, it scares the heck out of me too that Jared and Kirti are actually 
  doing Oracle -- I can't believe companies actually pay them ;-) 
  
  And you two guys, and I'm talking to you Kirti and Jared, probably dig
 in 
  and do things you shouldn't on test boxes just to see how things work
 and 
  to 
  learn. FWIW, I've heard rumors about other people doing similar things. 
  You've probably even intentionally crashed a DB or pulled the plug just
 to 
  see if you could recover. Shame on you two. You should both be banished 
  from 
  the list for doing such unconventional things ;-) 
  
  And neither of you will ever be allowed close to a DB I deal with --
 I'll 
  call ltiu from now on ;-) 
  
  Larry 
   -Original Message- 
   

Re[2]: {9i New Features: Joins}

[dgoulet]

OOPS, looks like a fat finger!!

Reply Separator
Author: James Howerton [EMAIL PROTECTED]
Date:   7/15/2002 9:24 AM

All,

Here is a sample of 9i new features.  You all should have a user on
DBA9 (moray.hs.uab.edu) to try this out, if not let me know.

...JIM...

 [EMAIL PROTECTED] 7/15/02 10:48:28 AM 
Welcome to the latest installment of 9i new features.  This will not be
all exhaustive but just a sample.

Here is the table scripts to build the data for testing purposes.

drop table dept;
drop table emp;


create table dept
( dept_id varchar2(5) not null,
  dept_name varchar2(50) not null);

alter table dept add constraint dept_pk
  primary key(dept_id);

create table emp
( emp_id number(5) not null,
  emp_name varchar2(50) not null,
  dept_id varchar2(5) null);

alter table emp add constraint emp_pk
  primary key(emp_id);


insert into dept values ('HR','Catbert');
insert into dept values ('PAY','Payroll');
insert into dept values ('IT','Computer Geeks');
insert into dept values ('MANAG','PHB');
insert into dept values ('EXECU','Big Cheeses');
insert into dept values ('SECRE','Secretary Pool');
insert into dept values ('DBAS','Database Admins');
insert into dept values ('SLIME','Slimy Induhviduals');
insert into dept values ('NWORK','Always Blame On');
insert into dept values ('DUH','No Clue People');


insert into emp values(10,'Bubba Jones','EXECU');
insert into emp values(11,'Honcho Man','EXECU');
insert into emp values(12,'Junior','NWORK');
insert into emp values(13,'Help Desk','NWORK');
insert into emp values(14,'Ima Dumb','DUH');
insert into emp values(15,'Dont Be','DUH');
insert into emp values(16,'Bosses Aid','SECRE');
insert into emp values(17,'Doy Doofus','MANAG');
insert into emp values(18,'Keep em Running','DBAS');
insert into emp values(19,'Look at me','SLIME');
insert into emp values(20,'HR Troop','HR');
insert into emp values(21,'Big Pain','USERS');


Ok now we have some test data, lets look at the various joins.

In the old days(and we're NOT going to talk about sub queries), we
really only had equi-joins and a single outer join.

Now we have:

1.  Natural join: This is a join between 2 or more tables where the
columns names match between the tables, like in our table, the dept_id
column is the same name between the dept_name AND the same datatype.

OLD:  select emp_id, emp_name, dept_name
  from dept, emp
  where  dept.dept_id = emp.dept_id;

NEW:  select emp_id, emp_name, dept_name
  from emp natural join dept;



Notice the results we get 11 rows but we have 12 rows in emp.  A
natural join is an equi-join where you DON'T have to put the join
condition
in the where clause.

There is a bit more to this one, check the using clause also, hint
its used if the column names match but maybe the data types don't, etc.
  


2.  Cross join:  Your and my favorite, also known as a cartesian join.

OLD:  select emp_id, emp_name, dept_name
  from dept, emp;

NEW:  select emp_id, emp_name, dept_name
  from dept cross join emp;


Useful?, I think thats up for debate :)



3.  Outer join:  This is where you join two tables and want to see all
of the rows even if there is NO match.  You could outer join to the left
or right but not both at the same time.  Now you can do left or right
outer and even full outer, examples follow:

Left:  We want to see all employees even if they dont belong to a
dept.


OLD:  select dept.dept_id, dept.dept_name, emp.emp_id
  from emp, dept
  where dept.dept_id(+) = emp.dept_id
  order by emp_id;

NEW:  select dept.dept_id, dept.dept_name, emp.emp_id
  from emp left outer join dept
  on (emp.dept_id = dept.dept_id)
  order by emp.emp_id;




Right: We want to see all depts even if they dont have employees.

OLD:  select dept.dept_id, dept.dept_name, emp.emp_id
  from emp, dept
  where dept.dept_id = emp.dept_id(+)
  order by emp_id;


NEW:  select dept.dept_id, dept.dept_name, emp.emp_id
  from emp right outer join dept
  on (dept.dept_id = emp.dept_id)
  order by emp.emp_id;



Full:  We want to see all emps with or without being assigned to a dept
and all depts with or without employees.


OLD: No such single statement quewry exists, you had to do it via 2
queries
and a union statement like this:

  select dept.dept_id, dept.dept_name, emp.emp_id
  from emp, dept
  where dept.dept_id = emp.dept_id(+)
  union
  select dept.dept_id, dept.dept_name, emp.emp_id
  from emp, dept
  where dept.dept_id(+) = emp.dept_id;

NEW:  select dept.dept_id, dept.dept_name, emp.emp_id
  from emp full outer join dept
  on (emp.dept_id = dept.dept_id)
  order by emp.emp_id;



Thats about it for today, all hate email to /dev/null, all good stuff
to [EMAIL PROTECTED] 

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

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

Re: McCain on Larry Ellison and Corporate Responsibility / Re: OT -

[Eric D. Pierce]

Tim,

It is my understanding that Oracle's stocks have gone 
up and down wildly several times.

As you say, the only time I've heard that Larry 
Ellison cashed out before a plunge happened was the 
recent one that McCain brought up.

I'm afraid I fail to see what you think people should 
conclude from all that.

Are you saying that it is ok for stock holding workers 
and investors to get gigantically screwed just because 
Larry Ellison has only done it once?

regards,
ep


On 15 Jul 2002 at 4:53, Tim Gorman wrote:

Date sent:  Mon, 15 Jul 2002 04:53:21 -0800
Corporate Responsibility / Re: OT -
unix
To: Multiple recipients of list ORACLE-L 
[EMAIL PROTECTED]

 My understanding is that this was the very first time Ellison had ever sold
 Oracle stock, in over 25 years of the company's existence, in 2000, which is
 the occasion that McCain (and you) are referring to.  As you might be aware,
 there was a far greater opportunity for Ellison to cash out and leave
 Oracle dangling in 1990, when the price dropped from around $20 to $6 almost
 overnight after some financial-earning restatements.  On that occasion, he
 would certainly have had prior knowledge of what was going to happen, to put
 it mildly.  In 2000, any foreknowledge of a long-term downturn (26 months
 and counting?) would have been worth far more than $700m, especially to
 someone holding several billions in equities...
 
 - Original Message -
 To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
 Sent: Sunday, July 14, 2002 10:13 PM
 unix
 
 
  Speaking of herds, or at least what is left behind on
  the ground after they pass:
 
  on Meet the Press (TV program), Senator John McCain
  said that Larry Ellison cashed out $700,000,000 of his
  Oracle stocks just before they lost most of their
  value (sarcasm: I'm sure he is planning on plowing it
  back into the company, especially improving quality in
  OWS and Metalink).

...


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

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

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

RE: Oracle and NAS storage systems

[Orr, Steve]

How timely! It just so happens that we've got some NetApp sales droids
coming in on Wednesday and we're gonna get an eval box to play with... but
don't tell anybody. ;-) 

NAS toasters (appliances) are implemented with RAID 4 enhancements and
WAFL technology from NetApp.

NetApp wants to claim that NAS is just as fast as RAID or SAN but I'm
skeptical thinking the limitations of NFS are a problem. Ever hear about a
thing called network latency? Even if you make dedicated network connections
there could be problems. NetApp filers now support both NFS version 2 and
NFS version 3 and I think this is key. NFS Version 2 writes are synchronous
requiring the server to flush data to disk before replying to the NFS client
(the Oracle RDBMS) so the client has to wait thus creating a significant
performance limitation. NFS version 3 tries to overcome this speed
limitation by implementing a two phased commit write operation. Version 3
NFS clients can submit async write requests which the server can immediately
acknowledge. But if the NFS v3 server fails some data may not actually be
written to disk and can be lost so it's up to the NFS v3 client to recover.
Upon failure and error notification to the NFS client, the NFS client must
resync/resubmit write requests from cache. So the onus is on the NFS v3
client to coordinate messages from the NFS server and confirm that the data
has been written to disk. How (and how efficiently!) the Oracle/NetApp NFS
client does this is still a mystery to me.

(Anyone go to the NetApp presentation at OOW? What a meltdown!! I never saw
a speaker so challenged and humiliated before... it was painful to watch.
Our friend Jeremiah has a lot of healthy negativity on this. :-)

Here's an old post on the subject:
http://groups.google.com/groups?selm=Pine.OSF.3.95.981013212349.4502A-10
%40gonzo.wolfenet.com


Dick...
 they [EMC] do not recommend doing so [implementing NFS datafiles] for 
 several of the reasons that I've held out.
Spill dude!!  I'm looking for some more ammo for my Wednesday NetApp sales
droid confrontation.:-)   (Back channel OK.) 

AtDhVaAnNkCsE!


Steve Orr
Bozeman, Montana


-Original Message-
Sent: Monday, July 15, 2002 10:23 AM
To: Multiple recipients of list ORACLE-L


I think that NA uses RAID4. This is the same as RAID5, but the parity info
is not stripped across the disks. This allows them to add disks from the
spare spool very quickly, as parity info does not need to be recalculated.
Spare disks are simply 'zeroed-out' prior to use. 

 -Original Message-
 From: DENNIS WILLIAMS [SMTP:[EMAIL PROTECTED]]
 Sent: Monday, July 15, 2002 11:58 AM
 To:   Multiple recipients of list ORACLE-L
 Subject:  RE: Oracle and NAS storage systems
 
 Dick - 
We use NetAppliance to store Oracle datafiles on our test system. I am
 pretty sure the NetAppliance is configured as RAID5. I would rate it as
 quite satisfactory for that purpose. We have many test systems and they
 are
 only used sporadically. 
I have had no reliability issues with the NetAppliance, so I can't
 figure
 what EMC means by it being risky.
I did find that if performance is pushed to a high level, the
 NetAppliance seems to have problems. I can't say for sure whether the
 problem is with the NetAppliance or with a network bottleneck. For
 example,
 I was going to rebuild 5 or 6 large indexes. Both the table and the index
 were on the NetAppliance system. I started a script to simultaneously
 build
 these indexes and went home for the night. Based on my experience with our
 normal RAID5 drives, I came in the next morning fully expecting all those
 indexes to be built. None of the indexes got rebuilt. My guess is that
 there
 was too much contention. I built the indexes one at a time, moving the
 base
 table to a normal RAID5, and performance was quite satisfactory. Have had
 no
 further problems or test user complaints.
I wouldn't commit to using NAS on a system that will push the disk
 drive
 subsystem really hard. Maybe for a less-critical system that needs access
 to
 large amounts of cheap disk. Test first. I have also heard of a lot of SAN
 systems being mis-configured and producing poor or erratic database
 performance.
 
 Dennis Williams
 DBA
 Lifetouch, Inc.
 [EMAIL PROTECTED]
 
 -Original Message-
 Sent: Monday, July 15, 2002 9:43 AM
 To: Multiple recipients of list ORACLE-L
 
 
 Folks,
 
 I've been asked to validate/invalidate a contention made by two
 storage
 vendors.  
 
 NetAppliance has stated that you can use a netapp filer with Oracle
 for
 datafiles, although their configuration looks more like a DAS(direct
 attached
 storage) configuration using 10baseT cables vs. SCSI cables.  Of course
 their
 real claim to fame here is Oracle's endorsement.
 
 EMC on the other hand has stated that using a NAS, in the traditional
 mode,
 for Oracle datafiles is at best risky.  And although their product can
 support
 it, they do not recommend doing so 

Re: OT - unix vs linux vs windows - the future

[ltiu]

Actually they were replaced in my previous company :  Not XP though but W2K 
!!!

On Monday 15 July 2002 09:44, [EMAIL PROTECTED] wrote:
 Oh yes, and mainframes will all be replaced by XP next year as well.





 ltiu [EMAIL PROTECTED]
 Sent by: [EMAIL PROTECTED]
 07/15/2002 09:14 AM
 Please respond to ORACLE-L


 To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
 cc:
 Subject:Re: OT - unix vs linux vs windows - the future


 But do all these matter though? Everyone's moving to MS software and
 *nixes
 are getting rarer and rarer. The fact is that everyone's losing money
 (Sun,
 IBM, HP, SGI even RedHat and Caldera) - except MS. It's an MS world like
 it
 or not.

 ltiu

 On Monday 15 July 2002 08:33, Andrey Bronfin wrote:
  Good bet that smaller Unix vendors will run to Linux before vendors

 like

  Sun do.
  Not exactly , just look at homepages of sun , ibm , oracle .
  There are more appearences of the word linux there than any word in
  Britannica ;-)
 
 
  DBAndrey
 
  * 03-9254520
  * 058-548133
  * mailto:[EMAIL PROTECTED]
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: ltiu
  INET: [EMAIL PROTECTED]

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

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

Re: OT - unix vs linux vs windows - the future

[Jared . Still]

Oh yes, and mainframes will all be replaced by XP next year as well.





ltiu [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
07/15/2002 09:14 AM
Please respond to ORACLE-L

 
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc: 
Subject:Re: OT - unix vs linux vs windows - the future


But do all these matter though? Everyone's moving to MS software and 
*nixes 
are getting rarer and rarer. The fact is that everyone's losing money 
(Sun, 
IBM, HP, SGI even RedHat and Caldera) - except MS. It's an MS world like 
it 
or not.

ltiu

On Monday 15 July 2002 08:33, Andrey Bronfin wrote:
 Good bet that smaller Unix vendors will run to Linux before vendors 
like
 Sun do.
 Not exactly , just look at homepages of sun , ibm , oracle .
 There are more appearences of the word linux there than any word in
 Britannica ;-)


 DBAndrey

 * 03-9254520
 * 058-548133
 * mailto:[EMAIL PROTECTED]





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

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

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

Re:RE: Oracle and NAS storage systems

[dgoulet]

Steve,

The network latency is one of the issues I wish there was a fix for.  That's
the reason they recommend direct connects.  OH, it's also the reason they
recommend a large 'non-volatile' ram cache where the data initially arrives. 
According to the sales droid ( a crowning example of why the current OCP status
is too easy to get) once the data is safely inside the cache the filer can then
reply back to the server that the 'write is complete' even though the data has
not yet made it to disk.  The NetApp WAFL OS guarantees that the data in the
cache will get to disk, sooner or later.  One other thing that bothers me about
NetApp.  As I understand it under WAFL (Write Anywhere File Layout) you never
overwrite a datablock on the disk.  Instead they write the updated data to a new
block and then 'link' the new block into the file as a replacement for the old
block, but they retain the old block as well time/date stamped so that they can
create a point in time picture of the data and consequently their snapshot. 
This seems very wasteful of disk space if you ask me, especially in a very busy
OLTP system.

Dick Goulet

PS: I'm currently in favor of the EMC SAN approach.

Reply Separator
Author: Orr; Steve [EMAIL PROTECTED]
Date:   7/15/2002 10:13 AM

How timely! It just so happens that we've got some NetApp sales droids
coming in on Wednesday and we're gonna get an eval box to play with... but
don't tell anybody. ;-) 

NAS toasters (appliances) are implemented with RAID 4 enhancements and
WAFL technology from NetApp.

NetApp wants to claim that NAS is just as fast as RAID or SAN but I'm
skeptical thinking the limitations of NFS are a problem. Ever hear about a
thing called network latency? Even if you make dedicated network connections
there could be problems. NetApp filers now support both NFS version 2 and
NFS version 3 and I think this is key. NFS Version 2 writes are synchronous
requiring the server to flush data to disk before replying to the NFS client
(the Oracle RDBMS) so the client has to wait thus creating a significant
performance limitation. NFS version 3 tries to overcome this speed
limitation by implementing a two phased commit write operation. Version 3
NFS clients can submit async write requests which the server can immediately
acknowledge. But if the NFS v3 server fails some data may not actually be
written to disk and can be lost so it's up to the NFS v3 client to recover.
Upon failure and error notification to the NFS client, the NFS client must
resync/resubmit write requests from cache. So the onus is on the NFS v3
client to coordinate messages from the NFS server and confirm that the data
has been written to disk. How (and how efficiently!) the Oracle/NetApp NFS
client does this is still a mystery to me.

(Anyone go to the NetApp presentation at OOW? What a meltdown!! I never saw
a speaker so challenged and humiliated before... it was painful to watch.
Our friend Jeremiah has a lot of healthy negativity on this. :-)

Here's an old post on the subject:
http://groups.google.com/groups?selm=Pine.OSF.3.95.981013212349.4502A-10
%40gonzo.wolfenet.com


Dick...
 they [EMC] do not recommend doing so [implementing NFS datafiles] for 
 several of the reasons that I've held out.
Spill dude!!  I'm looking for some more ammo for my Wednesday NetApp sales
droid confrontation.:-)   (Back channel OK.) 

AtDhVaAnNkCsE!


Steve Orr
Bozeman, Montana


-Original Message-
Sent: Monday, July 15, 2002 10:23 AM
To: Multiple recipients of list ORACLE-L


I think that NA uses RAID4. This is the same as RAID5, but the parity info
is not stripped across the disks. This allows them to add disks from the
spare spool very quickly, as parity info does not need to be recalculated.
Spare disks are simply 'zeroed-out' prior to use. 

 -Original Message-
 From: DENNIS WILLIAMS [SMTP:[EMAIL PROTECTED]]
 Sent: Monday, July 15, 2002 11:58 AM
 To:   Multiple recipients of list ORACLE-L
 Subject:  RE: Oracle and NAS storage systems
 
 Dick - 
We use NetAppliance to store Oracle datafiles on our test system. I am
 pretty sure the NetAppliance is configured as RAID5. I would rate it as
 quite satisfactory for that purpose. We have many test systems and they
 are
 only used sporadically. 
I have had no reliability issues with the NetAppliance, so I can't
 figure
 what EMC means by it being risky.
I did find that if performance is pushed to a high level, the
 NetAppliance seems to have problems. I can't say for sure whether the
 problem is with the NetAppliance or with a network bottleneck. For
 example,
 I was going to rebuild 5 or 6 large indexes. Both the table and the index
 were on the NetAppliance system. I started a script to simultaneously
 build
 these indexes and went home for the night. Based on my experience with our
 normal RAID5 drives, I came in the next morning fully expecting all those
 indexes to be built. None of the indexes 

Re[2]: McCain on Larry Ellison and Corporate Responsibility

[dgoulet]

I've no problem with what Uncle Larry did.  Sure he made a pile of money, isn't
that what we're all about?  What in this mess bothers me is that some folks,
like those at Enron, WorldCom, and Tyco, knew their stock was headed for the
crapper on a permanent basis due to the kitchen treatment the books got.  At
least Uncle Larry did not cook the books to get the stock price to tumble and it
has recovered before  I'm sure will again if anyone ever gets confidence in the
stock market back to normal that is.  Now I know this last piece is way off
topic, but I really do not appreciate the idiots that make the bulk of the stock
market decisions.  When your car is not performing well you take it to a
qualified mechanic to find out what is wrong.  But the dummies in the market go
looking for a 'analyst' at an investment bank to explain why their stocks are
not performing, instead of asking the folks at the company.  Nothing like asking
a witch doctor how to handle your money!!

Dick Goulet

PS: I've an old classmate who is one of those analysts.  I would not trust that
guy to watch my dog for the weekend, never mind my life savings!

Reply Separator
Author: Eric D. Pierce [EMAIL PROTECTED]
Date:   7/15/2002 9:43 AM

Tim,

It is my understanding that Oracle's stocks have gone 
up and down wildly several times.

As you say, the only time I've heard that Larry 
Ellison cashed out before a plunge happened was the 
recent one that McCain brought up.

I'm afraid I fail to see what you think people should 
conclude from all that.

Are you saying that it is ok for stock holding workers 
and investors to get gigantically screwed just because 
Larry Ellison has only done it once?

regards,
ep


On 15 Jul 2002 at 4:53, Tim Gorman wrote:

Date sent:  Mon, 15 Jul 2002 04:53:21 -0800
Corporate Responsibility / Re: OT -
unix
To: Multiple recipients of list ORACLE-L 
[EMAIL PROTECTED]

 My understanding is that this was the very first time Ellison had ever sold
 Oracle stock, in over 25 years of the company's existence, in 2000, which is
 the occasion that McCain (and you) are referring to.  As you might be aware,
 there was a far greater opportunity for Ellison to cash out and leave
 Oracle dangling in 1990, when the price dropped from around $20 to $6 almost
 overnight after some financial-earning restatements.  On that occasion, he
 would certainly have had prior knowledge of what was going to happen, to put
 it mildly.  In 2000, any foreknowledge of a long-term downturn (26 months
 and counting?) would have been worth far more than $700m, especially to
 someone holding several billions in equities...
 
 - Original Message -
 To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
 Sent: Sunday, July 14, 2002 10:13 PM
 unix
 
 
  Speaking of herds, or at least what is left behind on
  the ground after they pass:
 
  on Meet the Press (TV program), Senator John McCain
  said that Larry Ellison cashed out $700,000,000 of his
  Oracle stocks just before they lost most of their
  value (sarcasm: I'm sure he is planning on plowing it
  back into the company, especially improving quality in
  OWS and Metalink).

...


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

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

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

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

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

RE: McCain on Larry Ellison and Corporate Responsibility / Re: OT

[Johnson, Michael]

Not defending Ellison for anything, but it appears
McCain is just another politician who is only interested
in his future and he constantly takes on these reform
ideas  and just makes the matter worse.

Everyone should accept the fact that we are in a bear
market and as such all the boats go down.   
Everyone should have been smart enough to sell stocks and
put their money into cash or better yet short stocks
when it was very clear that in the Fall of 2000 after the
initial March 2000 sell off that we were going into
a prolonged Bear market.

Ellison probably took the money and ran when this
became apparent to him and many others.  I know I did.

FWIW. 

Mike

-Original Message-
Sent: Monday, July 15, 2002 5:53 AM
To: Multiple recipients of list ORACLE-L
OT - unix


My understanding is that this was the very first time Ellison had ever sold
Oracle stock, in over 25 years of the company's existence, in 2000, which is
the occasion that McCain (and you) are referring to.  As you might be aware,
there was a far greater opportunity for Ellison to cash out and leave
Oracle dangling in 1990, when the price dropped from around $20 to $6 almost
overnight after some financial-earning restatements.  On that occasion, he
would certainly have had prior knowledge of what was going to happen, to put
it mildly.  In 2000, any foreknowledge of a long-term downturn (26 months
and counting?) would have been worth far more than $700m, especially to
someone holding several billions in equities...

- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Sunday, July 14, 2002 10:13 PM
unix


 Speaking of herds, or at least what is left behind on
 the ground after they pass:

 on Meet the Press (TV program), Senator John McCain
 said that Larry Ellison cashed out $700,000,000 of his
 Oracle stocks just before they lost most of their
 value (sarcasm: I'm sure he is planning on plowing it
 back into the company, especially improving quality in
 OWS and Metalink).

 regards,
 ep


 On 14 Jul 2002 at 16:28, Alex wrote:

 Date sent:  Sun, 14 Jul 2002 16:28:18 -0800
 the future
 To: Multiple recipients of list ORACLE-L
 [EMAIL PROTECTED]

  ... As far as DB vendors targeting linux they move in herds and have
  just finished their linux port from when linux was a buzzword.

 ..

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

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

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

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

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

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

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

Re[2]: Oracle and NAS storage systems

[dgoulet]

Jared,

That is what I believe, but of course the NetApp folks keep telling the
powers that be (PTB) that they can handle it  be cheaper in the long run.  The
EMC folks on the other hand are telling me that it's risky due to the problems
you encountered with filers plus the network delay to get the write confirmation
needed.  Those two could put data files offline at the worst possible time.  I
think one item that works against EMC is the fact that they are our current DAS
storage vendor  the PTB believe they want to keep it that way.

Dick Goulet

Reply Separator
Author: [EMAIL PROTECTED]
Date:   7/15/2002 9:39 AM

Dick,

I had a recent bad experience with a NetApps Filer.

Due to circumstances beyond my control, I was about to run
out of space on our most critical application. 
( SAP.  I predicted in January that we would run out of space
  in the first week of July.  It happened on June 28th )

Our SA's made temporary storage available on a NetApp filer.

First problem:  Veritas BackupExec doesn't know how to backup
files on a filer in some circumstances, my circumstances unfortunately.

Second problem:  making a disk to disk backup of the files to 
another location on the filer seems to have overwhelmed it. 
The files on the file were suddenly unreadable and crashed.

Due to another, unrelated set of unfortunate circumstances ( NT failed
to started one monitoring service, the other died ) I didn't know about
this until the next morning, and manufacturing suffered 2 hours of
downtime.

The filer at this time seemed to be OK.  Restart the database, recover
the datafiles ( forgot about 'ALTER TABLESPACE END BACKUP'. D'oh! )
and start the database backup.

The files are now on the SAN where they belong.

Spend the extra $$ and put in a SAN.

Faster, more reliable, more managable.

Jared






[EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
07/15/2002 07:43 AM
Please respond to ORACLE-L

 
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc: 
Subject:Oracle and NAS storage systems


Folks,

I've been asked to validate/invalidate a contention made by two 
storage
vendors. 

NetAppliance has stated that you can use a netapp filer with Oracle 
for
datafiles, although their configuration looks more like a DAS(direct 
attached
storage) configuration using 10baseT cables vs. SCSI cables.  Of course 
their
real claim to fame here is Oracle's endorsement.

EMC on the other hand has stated that using a NAS, in the traditional 
mode,
for Oracle datafiles is at best risky.  And although their product can 
support
it, they do not recommend doing so for several of the reasons that I've 
held out
are pertinent.

Therefore, is there anyone out their using a NAS to store datafiles? 
If so,
what does the configuration (server to NAS) look like?

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

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

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



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

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

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

RE: Oracle and NAS storage systems

[Erik Williams]

AFAIK, the downside of RAID4 is the same as RAID5. Writes to the disk must
calculate parity data which impacts performance. Also, the parity disks tend
to be the hotspots on these arrays. Any writes must also write data to the
parity disk.

I took a one week course in NetApp filers a while ago. I was impressed by
their products, but not as database storage. They are a great solution if
you are using a heterogeneous environment of CIFS and NFS. The ability to
'snapshot' the file system was also very cool and I used this as a way of
performing QUICK hot backups.

Erik

 -Original Message-
 From: DENNIS WILLIAMS [SMTP:[EMAIL PROTECTED]]
 Sent: Monday, July 15, 2002 12:49 PM
 To:   Multiple recipients of list ORACLE-L
 Subject:  RE: Oracle and NAS storage systems
 
 Erik - Very interesting, thanks for mentioning that fact. Of course, since
 there's no free lunch, what is the downside to RAID4?
 
 Dennis Williams
 DBA
 Lifetouch, Inc.
 [EMAIL PROTECTED]
 
 -Original Message-
 Sent: Monday, July 15, 2002 11:23 AM
 To: Multiple recipients of list ORACLE-L
 
 
 I think that NA uses RAID4. This is the same as RAID5, but the parity info
 is not stripped across the disks. This allows them to add disks from the
 spare spool very quickly, as parity info does not need to be recalculated.
 Spare disks are simply 'zeroed-out' prior to use. 
 
  -Original Message-
  From:   DENNIS WILLIAMS [SMTP:[EMAIL PROTECTED]]
  Sent:   Monday, July 15, 2002 11:58 AM
  To: Multiple recipients of list ORACLE-L
  Subject:RE: Oracle and NAS storage systems
  
  Dick - 
 We use NetAppliance to store Oracle datafiles on our test system. I
 am
  pretty sure the NetAppliance is configured as RAID5. I would rate it as
  quite satisfactory for that purpose. We have many test systems and they
  are
  only used sporadically. 
 I have had no reliability issues with the NetAppliance, so I can't
  figure
  what EMC means by it being risky.
 I did find that if performance is pushed to a high level, the
  NetAppliance seems to have problems. I can't say for sure whether the
  problem is with the NetAppliance or with a network bottleneck. For
  example,
  I was going to rebuild 5 or 6 large indexes. Both the table and the
 index
  were on the NetAppliance system. I started a script to simultaneously
  build
  these indexes and went home for the night. Based on my experience with
 our
  normal RAID5 drives, I came in the next morning fully expecting all
 those
  indexes to be built. None of the indexes got rebuilt. My guess is that
  there
  was too much contention. I built the indexes one at a time, moving the
  base
  table to a normal RAID5, and performance was quite satisfactory. Have
 had
  no
  further problems or test user complaints.
 I wouldn't commit to using NAS on a system that will push the disk
  drive
  subsystem really hard. Maybe for a less-critical system that needs
 access
  to
  large amounts of cheap disk. Test first. I have also heard of a lot of
 SAN
  systems being mis-configured and producing poor or erratic database
  performance.
  
  Dennis Williams
  DBA
  Lifetouch, Inc.
  [EMAIL PROTECTED]
  
  -Original Message-
  Sent: Monday, July 15, 2002 9:43 AM
  To: Multiple recipients of list ORACLE-L
  
  
  Folks,
  
  I've been asked to validate/invalidate a contention made by two
  storage
  vendors.  
  
  NetAppliance has stated that you can use a netapp filer with Oracle
  for
  datafiles, although their configuration looks more like a DAS(direct
  attached
  storage) configuration using 10baseT cables vs. SCSI cables.  Of course
  their
  real claim to fame here is Oracle's endorsement.
  
  EMC on the other hand has stated that using a NAS, in the
 traditional
  mode,
  for Oracle datafiles is at best risky.  And although their product can
  support
  it, they do not recommend doing so for several of the reasons that I've
  held
  out
  are pertinent.
  
  Therefore, is there anyone out their using a NAS to store datafiles?
  If
  so,
  what does the configuration (server to NAS) look like?
  
  Dick Goulet
  -- 
  Please see the official ORACLE-L FAQ: http://www.orafaq.com
  -- 
  Author: 
INET: [EMAIL PROTECTED]
  
  Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
  San Diego, California-- Public Internet access / Mailing Lists
  
  To REMOVE yourself from this mailing list, send an E-Mail message
  to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
  the message BODY, include a line containing: UNSUB ORACLE-L
  (or the name of mailing list you want to be removed from).  You may
  also send the HELP command for other information (like subscribing).
  -- 
  Please see the official ORACLE-L FAQ: http://www.orafaq.com
  -- 
  Author: DENNIS WILLIAMS
INET: [EMAIL PROTECTED]
  
  Fat City Network Services-- (858) 538-5051  

Size of Oracle server processes

[Jos Someone]

I have a question to ask regarding Oracle server process (oracleSID) size. We have just installed Oracle Apps 11i, while monitoring the system using glance, I notice something strange, the oracle server processes - process which has a name oracleSID has a very big RSS size in glance, these processes were associated with the f60webmx processes. I was curious about the size of it, normally these processes are about 2-3M big. I did a quick test by logging on to the database using sqlplus and observe the size of the oracle server process, it showeda size of 2M. So why the oracleSID processes size is so big where they are assoicated with f60webmx, is it something special about them? Or the RSS size shown in glance is doubling up on something?
Jos

SOLD.com.au
- Find yourself a bargain!

Windows 2000/8.1.7.x/Installed Software

[Vergara, Michael (TEM)]

Hi All!  Happy Monday.

When I run the Oracle installer and try to list the installed
software, I get a listing that is miles long and redundant and
repetitious and is way too much information.

Is there any way to:
1)  Get a shorter list?
2)  Parse the list I get into something useable?
3)  some other option?

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  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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

RE: Your password!

[Khedr, Waleed]

It seems this message was sent by my mail server when receiving an infected
email from the list.

Waleed

-Original Message-
Sent: Monday, July 15, 2002 10:53 AM
To: Multiple recipients of list ORACLE-L


[Filename: decrypt-password.exe, Content-Type: audio/x-midi]
This message was generated by Fidelity's virus detection server
VIRMMK100NTS.  The attachment within this message has been blocked and
quarantined because it may contain a virus or malicious code.  If you have
questions please see  http://fnw.fmr.com/issg/virus/emanager.html.  You may
also contact your company's help desk or the CSC at 1-800-525-3274 option 2.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Khedr, Waleed
  INET: [EMAIL PROTECTED]

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

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

Index questions

[CC Harvest]

If we have a column of 'Y','N' values, the index will
not help with CBT(usually most of the values are 'N').

My question is : how about bitmap indexes? Should it
help a lot, or just a little bit?

Thanks,

Chris Harvest

__
Do You Yahoo!?
Yahoo! Autos - Get free new car price quotes
http://autos.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: CC Harvest
  INET: [EMAIL PROTECTED]

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

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

Re: OT - unix vs linux vs windows - the future

[Igor Neyman]

can't wait for replies to this ...

Igor Neyman, OCP DBA
[EMAIL PROTECTED]


- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Monday, July 15, 2002 1:58 PM


 Actually they were replaced in my previous company :  Not XP though but
W2K
 !!!

 On Monday 15 July 2002 09:44, [EMAIL PROTECTED] wrote:
  Oh yes, and mainframes will all be replaced by XP next year as well.
 
 
 
 
 
  ltiu [EMAIL PROTECTED]
  Sent by: [EMAIL PROTECTED]
  07/15/2002 09:14 AM
  Please respond to ORACLE-L
 
 
  To: Multiple recipients of list ORACLE-L
[EMAIL PROTECTED]
  cc:
  Subject:Re: OT - unix vs linux vs windows - the future
 
 
  But do all these matter though? Everyone's moving to MS software and
  *nixes
  are getting rarer and rarer. The fact is that everyone's losing money
  (Sun,
  IBM, HP, SGI even RedHat and Caldera) - except MS. It's an MS world like
  it
  or not.
 
  ltiu
 
  On Monday 15 July 2002 08:33, Andrey Bronfin wrote:
   Good bet that smaller Unix vendors will run to Linux before vendors
 
  like
 
   Sun do.
   Not exactly , just look at homepages of sun , ibm , oracle .
   There are more appearences of the word linux there than any word in
   Britannica ;-)
  
  
   DBAndrey
  
   * 03-9254520
   * 058-548133
   * mailto:[EMAIL PROTECTED]
 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 --
 Author: ltiu
   INET: [EMAIL PROTECTED]

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

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

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

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

RE: OT - unix vs linux vs windows - the future

[Jared . Still]

For Oracle, my guess is that their goal is to use Linux to look 
modern
 and open and hope nobody asks why they are spending $40k/processor for
 Oracle and getting the Linux O.S. for free.

Dennis, 

If you want to purchase heavy duty production ready, SMP capable Linux, it 
ain't free.

RH for examples is $2K+.  Still not a bad price, but not free.  I don't 
know
what IBM's offererings cost.

Jared






DENNIS WILLIAMS [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
07/15/2002 09:23 AM
Please respond to ORACLE-L

 
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc: 
Subject:RE: OT - unix vs linux vs windows - the future


Andrey
   I think it is important to understand the situation from the vendor's
point of view. That will lead to more accurate predictions of their future
behavior. At this point, I feel Linux has great momentum behind it,
virtually guaranteeing its success, and your statement about vendors
splashing it all over their Web pages is evidence of that momentum.
   Someone made the comment that there were lots of non-Linux systems in
place. That is true, but the vendors don't make much money from existing
systems. Only new systems drive revenue, which is why we tend to get 
cranky
with Oracle for paying more attention to potential customers that to we
loyal supporters.
   As I recall, Sun was one of the last Unix vendors to embrace Linux. 
And
it was severely criticized for being behind the other major vendors. My
suspicion is that Sun's support at this stage is more of the lip service
variety. Has anyone had a Sun salesperson try to talk them into 
implementing
Linux instead of Solaris?
   IBM has provided the most Linux support of any of the major vendors.
However, AIX hasn't developed the market share of Solaris. My suspicion is
that IBM's undeniably genuine support of Linux is not so much altruism, 
but
anything that hurts Microsoft.
   Again, I'm just speaking to market momentum. I can recall the time when
Unix was considered not ready for prime time. Vendors were putting their
dollars into proprietary systems. Then, HP broke from the pack,
de-emphasized their bread-and-butter proprietary O.S. and made a sincere
commitment to Unix. They wound up as a major Unix vendor, while their
competitors ended up as historical footnotes. Sun should pay careful
attention to that experience.
   For Oracle, my guess is that their goal is to use Linux to look modern
and open and hope nobody asks why they are spending $40k/processor for
Oracle and getting the Linux O.S. for free.

Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]




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

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

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

RE: McCain on Larry Ellison and Corporate Responsibility / Re: OT

[Alex]

On Mon, 15 Jul 2002, Johnson, Michael  wrote:

 Everyone should have been smart enough to sell stocks and
 put their money into cash or better yet short stocks
 when it was very clear that in the Fall of 2000 after the
 initial March 2000 sell off that we were going into
 a prolonged Bear market.

It's always easy to play monday morning quarterback. I assume you are now
retired because you made so much money from the very clear and prolonged
Bear market you forcasted in Fall 2000.

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

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

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

RE: Windows 2000/8.1.7.x/Installed Software

[Streeter, Lerone A LBX]

there is a log file you can reference it has all the components; it's
something like:
installActions2002-01-08_11-09-21-AM.log
=-=-=-=-=-=-=-=-=-=-=
lerone
=-=-=-=-=-=-=-=-=-=-=

-Original Message-
Sent: Monday, July 15, 2002 2:28 PM
To: Multiple recipients of list ORACLE-L


Hi All!  Happy Monday.

When I run the Oracle installer and try to list the installed
software, I get a listing that is miles long and redundant and
repetitious and is way too much information.

Is there any way to:
1)  Get a shorter list?
2)  Parse the list I get into something useable?
3)  some other option?

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  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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

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

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

Re: Where is Oracle 9.2 init.ora?

[Ramon E. Estevez]

Hi Kirti

I have something to add to the topic.

I could edit the spfile with VI and add a parameter with a value of 20,
later add the same parameter to the init file with a value of 30, bounce the
DB and it worked very fine.

SQL shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL startup

ORACLE instance started.

Total System Global Area  235693104 bytes
Fixed Size   279600 bytes
Variable Size 167772160 bytes
Database Buffers   67108864 bytes
Redo Buffers 532480 bytes
Database mounted.
Database opened.
SQL SHOW PARAMETER JOB

NAME TYPEVALUE
 --- ---
---
job_queue_processes  integer 20   -- spfile


SQL shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL startup
ORACLE instance started.

Total System Global Area  235693104 bytes
Fixed Size   279600 bytes
Variable Size 167772160 bytes
Database Buffers   67108864 bytes
Redo Buffers 532480 bytes
Database mounted.
Database opened.
SQL show parameter job

NAME TYPEVALUE
 --- ---
---
job_queue_processes  integer 30   -- init
SQL
SQL

Could you explain me that ???

Ramon


- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Sunday, July 14, 2002 5:58 PM


 All Right, Larry. Since we have the test servers and databases; and my
 Company still pays for 'doing Oracle' the 'scary' way, here is another
 'scary thing' I did with SPFILE :)
 (9iR1 on HP)

 SQL conn / as sysdba
 Connected to an idle instance.
 SQL startup using spfile

 ORACLE instance started.
 Total System Global Area   72273416 bytes
 Fixed Size   437768 bytes
 Variable Size  37748736 bytes
 Database Buffers   33554432 bytes
 Redo Buffers 532480 bytes
 Database mounted.
 Database opened.
 SQL show parameter db_cache_size
 NAME TYPEVALUE
  ---
 --
 db_cache_sizebig integer 33554432

 SQL !mv spfileKED9.ora spfileKED9.ora.bak  -- hide the spfile

 SQL !ls -l *.ora
 -rw-r--r--   1 oracle dba  12920 May 10  2001 initdw.ora

 SQL alter system set db_cache_size=10M scope=both;   -- try to set a new
 value

 System altered.   --- No problem?

 SQL show parameter db_cache_size

 NAME TYPEVALUE
  ---
 --
 db_cache_sizebig integer 12582912

 -- New value in effect.

 SQL !ls -l *.ora
 -rw-r--r--   1 oracle dba  12920 May 10  2001 initdw.ora

 -- Still no SFILE
 -- Now, why would not Oracle tell us that there was no spfile to process
 SCOPE=BOTH ?

 SQL c/both/spfile
   1* alter system set db_cache_size=10M scope=spfile
 SQL /
 alter system set db_cache_size=10M scope=spfile
 *
 ERROR at line 1:
 ORA-27037: unable to obtain file status
 HP-UX Error: 2: No such file or directory
 Additional information: 3

 --This is what should have happened with SCOPE=BOTH as well, or at least
a
 warning that SCOPE=BOTH was processed as SCOPE=MEMORY since there was no
 SPFILE available. I would not have objected if Oracle re-recreated SPFILE
in
 the default location and told me so!

 If anyone has seen any mention of this particular behaviour of SCOPE=BOTH,
I
 would like to know the source of that information. I have searched
Metalink,
 Google but have not come across any. I have created an iTar with OWS.
 Thanks.

 As I said before, SPFILE has some things that need to be made fool proof.

 This time I did not drink prior to doing this 'scary' stuff !!;-)

 Regards,

 - Kirti

  -Original Message-
  From: Larry Elkins [SMTP:[EMAIL PROTECTED]]
  Sent: Friday, July 12, 2002 9:03 PM
  To: Multiple recipients of list ORACLE-L
  Subject: RE: Where is Oracle 9.2 init.ora?
 
  Man, it scares the heck out of me too that Jared and Kirti are actually
  doing Oracle -- I can't believe companies actually pay them ;-)
 
  And you two guys, and I'm talking to you Kirti and Jared, probably dig
in
  and do things you shouldn't on test boxes just to see how things work
and
  to
  learn. FWIW, I've heard rumors about other people doing similar things.
  You've probably even intentionally crashed a DB or pulled the plug just
to
  see if you could recover. Shame on you two. You should both be banished
  from
  the list for doing such unconventional things ;-)
 
  And neither of you will ever be allowed close to a DB I deal with --
I'll
  call ltiu from now on ;-)
 
  Larry
   -Original Message-
   

[no subject]

[Christopher Royce]

CONFIRM L-ORACLE

Thnx  OK Bye
Instant gratification
takes too long 
 -- Carrie Fisher

Chris Royce
[EMAIL PROTECTED]
[EMAIL PROTECTED]


winmail.dat

[no subject]

[Christopher Royce]

CONFIRM ORACLE-L

Thnx  OK Bye
Instant gratification
takes too long 
 -- Carrie Fisher

Chris Royce
[EMAIL PROTECTED]
[EMAIL PROTECTED]


winmail.dat

[no subject]

[Christopher Royce]

SET ORACLE-L REPRO
END


Thnx  OK Bye
Instant gratification
takes too long 
 -- Carrie Fisher

Chris Royce
[EMAIL PROTECTED]
[EMAIL PROTECTED]


winmail.dat

Re: McCain on Larry Ellison and Corporate Responsibility / Re: OT - unix

[Tim Gorman]

Nope.

I just thought that people are innocent until proven guilty.  One thing
about someone in Ellison's position is that it would be impossible for him
to *ever* sell stock without having the unfounded accusations you've quoted
being hurled at him.  So, are you saying that it is OK to throw such
accusations around, when you don't know anything about anything?  Or is
there further substantiation for what you're saying?  Does that mean he
should never sell stock?  Or should he just live his life and ignore the
critics?

I respect and admire Sen. McCain as much as I respect and admire anyone, but
he is not infallible and he (and his staff) can certainly be off the mark...

- Original Message -
To: Tim Gorman [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Monday, July 15, 2002 10:49 AM
unix


 Tim,

 It is my understanding that Oracle's stocks have gone
 up and down wildly several times.

 As you say, the only time I've heard that Larry
 Ellison cashed out before a plunge happened was the
 recent one that McCain brought up.

 I'm afraid I fail to see what you think people should
 conclude from all that.

 Are you saying that it is ok for stock holding workers
 and investors to get gigantically screwed just because
 Larry Ellison has only done it once?

 regards,
 ep


 On 15 Jul 2002 at 4:53, Tim Gorman wrote:

 Date sent:  Mon, 15 Jul 2002 04:53:21 -0800
 From:   Tim Gorman [EMAIL PROTECTED]
 Subject:Re: McCain on Larry Ellison and
 Corporate Responsibility / Re: OT -
 unix
 To: Multiple recipients of list ORACLE-L
 [EMAIL PROTECTED]

  My understanding is that this was the very first time Ellison had ever
sold
  Oracle stock, in over 25 years of the company's existence, in 2000,
which is
  the occasion that McCain (and you) are referring to.  As you might be
aware,
  there was a far greater opportunity for Ellison to cash out and
leave
  Oracle dangling in 1990, when the price dropped from around $20 to $6
almost
  overnight after some financial-earning restatements.  On that occasion,
he
  would certainly have had prior knowledge of what was going to happen, to
put
  it mildly.  In 2000, any foreknowledge of a long-term downturn (26
months
  and counting?) would have been worth far more than $700m, especially to
  someone holding several billions in equities...
 
  - Original Message -
  To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
  Sent: Sunday, July 14, 2002 10:13 PM
  unix
 
 
   Speaking of herds, or at least what is left behind on
   the ground after they pass:
  
   on Meet the Press (TV program), Senator John McCain
   said that Larry Ellison cashed out $700,000,000 of his
   Oracle stocks just before they lost most of their
   value (sarcasm: I'm sure he is planning on plowing it
   back into the company, especially improving quality in
   OWS and Metalink).

 ..



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

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

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

SPFILE Bug [RE: Where is Oracle 9.2 init.ora?]

[Deshpande, Kirti]

Okay.. Oracle Support just informed me that Bug # 2462605 has been filed
regarding this issue with SPFILE not visible to public yet, but
following text is in my TAR:

--- 
  Called customer lms on vm please call when avail 
  SME did see this.. but did not file a bug on this. 

  15-JUL-02 17:08:16 GMT
  talked with custoemr.. about this.. he would like me to file a bug 
  filing bug 
  15-JUL-02 17:19:47 GMT
  bug was filed 
  2462605

  15-JUL-02 17:29:37 GMT
  Associated bug 2462605 has been updated and has changed status to 10.
-

- Kirti 

 -Original Message-
 From: Deshpande, Kirti [SMTP:[EMAIL PROTECTED]]
 Sent: Monday, July 15, 2002 12:24 PM
 To:   Multiple recipients of list ORACLE-L
 Subject:  RE: Where is Oracle 9.2 init.ora?
 
 Thanks, Tony. 
 
 If that were the case, the second test (scope=spfile) should not have
 failed. 
 
 Oracle Support left a v-mail to me stating that they are considering this
 a
 bug. And wanted to talk to me about more testing.  I will get with them
 later today (or tomorrow). 
 
 Regards.
 
 - Kirti
  
  -Original Message-
  From:   Aponte, Tony [SMTP:[EMAIL PROTECTED]]
  Sent:   Monday, July 15, 2002 9:37 AM
  To: [EMAIL PROTECTED]
  Cc: [EMAIL PROTECTED]
  Subject:RE: Where is Oracle 9.2 init.ora?
  
  On my version of UNIX (Solaris) moving/removing a file that is in use
 only
  affects the directory entry and not the actual payload on disk.  I
 suspect
  that the spfile was held open by your sqlplus program and it executed
 the
  I/O operation using the open file descriptor.  I've participated in
  similar (and unplanned) tests with ufs-based file systems where all of
 the
  underlying files where rm-ed and the database continued to run.  It
  crashed when it tried to switch into the next and non-existent redo log
  files.  A post-mortem on the incident taught us that removing an open
 file
  only removed the entry from UNIX's directory file but the cleanup was
  postponed until the OS closed the last open handle for that i-node.  
  
  HTH 
  Tony Aponte 
  
  -Original Message- 
  From: Deshpande, Kirti [ mailto:[EMAIL PROTECTED]] 
  Sent: Sunday, July 14, 2002 6:58 PM 
  To: Multiple recipients of list ORACLE-L 
  Subject: RE: Where is Oracle 9.2 init.ora? 
  
  
  All Right, Larry. Since we have the test servers and databases; and my 
  Company still pays for 'doing Oracle' the 'scary' way, here is another 
  'scary thing' I did with SPFILE :) 
  (9iR1 on HP) 
  
  SQL conn / as sysdba 
  Connected to an idle instance. 
  SQL startup using spfile 
  
  ORACLE instance started. 
  Total System Global Area   72273416 bytes 
  Fixed Size   437768 bytes 
  Variable Size  37748736 bytes 
  Database Buffers   33554432 bytes 
  Redo Buffers 532480 bytes 
  Database mounted. 
  Database opened. 
  SQL show parameter db_cache_size 
  NAME TYPEVALUE 
   --- 
  -- 
  db_cache_sizebig integer 33554432
  
  SQL !mv spfileKED9.ora spfileKED9.ora.bak  -- hide the spfile 
  
  SQL !ls -l *.ora 
  -rw-r--r--   1 oracle dba  12920 May 10  2001 initdw.ora 
  
  SQL alter system set db_cache_size=10M scope=both;   -- try to set a
 new
  
  value 
  
  System altered.   --- No problem?  
  
  SQL show parameter db_cache_size 
  
  NAME TYPEVALUE 
   --- 
  -- 
  db_cache_sizebig integer 12582912   
  
  -- New value in effect. 
  
  SQL !ls -l *.ora 
  -rw-r--r--   1 oracle dba  12920 May 10  2001 initdw.ora 
  
  -- Still no SFILE 
  -- Now, why would not Oracle tell us that there was no spfile to
 process 
  SCOPE=BOTH ? 
  
  SQL c/both/spfile 
1* alter system set db_cache_size=10M scope=spfile 
  SQL / 
  alter system set db_cache_size=10M scope=spfile 
  * 
  ERROR at line 1: 
  ORA-27037: unable to obtain file status 
  HP-UX Error: 2: No such file or directory 
  Additional information: 3 
  
  --This is what should have happened with SCOPE=BOTH as well, or at
 least
  a 
  warning that SCOPE=BOTH was processed as SCOPE=MEMORY since there was no
 
  SPFILE available. I would not have objected if Oracle re-recreated
 SPFILE
  in 
  the default location and told me so! 
  
  If anyone has seen any mention of this particular behaviour of
 SCOPE=BOTH,
  I 
  would like to know the source of that information. I have searched
  Metalink, 
  Google but have not come across any. I have created an iTar with OWS. 
  Thanks. 
  
  As I said before, SPFILE has some things that need to be made fool
 proof. 
  
  This time I did not drink prior to doing this 'scary' stuff !!;-)  
  
  Regards, 
  
  - Kirti 
  
   -Original 

Re: Index questions

[Greg Moore]

What's CBT?

 If we have a column of 'Y','N' values, the index will
 not help with CBT(usually most of the values are 'N').


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

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

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

RE: Where is Oracle 9.2 init.ora?

[Deshpande, Kirti]

Ramon,
 I can not explain that.   What platform are you on? 
 May be this is another bug with SPFILE. 

- Kirti


 -Original Message-
 From: Ramon E. Estevez [SMTP:[EMAIL PROTECTED]]
 Sent: Monday, July 15, 2002 2:58 PM
 To:   Multiple recipients of list ORACLE-L
 Subject:  Re: Where is Oracle 9.2 init.ora?
 
 Hi Kirti
 
 I have something to add to the topic.
 
 I could edit the spfile with VI and add a parameter with a value of 20,
 later add the same parameter to the init file with a value of 30, bounce
 the
 DB and it worked very fine.
 
 SQL shutdown immediate;
 Database closed.
 Database dismounted.
 ORACLE instance shut down.
 SQL startup
 
 ORACLE instance started.
 
 Total System Global Area  235693104 bytes
 Fixed Size   279600 bytes
 Variable Size 167772160 bytes
 Database Buffers   67108864 bytes
 Redo Buffers 532480 bytes
 Database mounted.
 Database opened.
 SQL SHOW PARAMETER JOB
 
 NAME TYPEVALUE
  ---
 ---
 ---
 job_queue_processes  integer 20   -- spfile
 
 
 SQL shutdown immediate;
 Database closed.
 Database dismounted.
 ORACLE instance shut down.
 SQL startup
 ORACLE instance started.
 
 Total System Global Area  235693104 bytes
 Fixed Size   279600 bytes
 Variable Size 167772160 bytes
 Database Buffers   67108864 bytes
 Redo Buffers 532480 bytes
 Database mounted.
 Database opened.
 SQL show parameter job
 
 NAME TYPEVALUE
  ---
 ---
 ---
 job_queue_processes  integer 30   -- init
 SQL
 SQL
 
 Could you explain me that ???
 
 Ramon
 
 
 - Original Message -
 To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
 Sent: Sunday, July 14, 2002 5:58 PM
 
 
  All Right, Larry. Since we have the test servers and databases; and my
  Company still pays for 'doing Oracle' the 'scary' way, here is another
  'scary thing' I did with SPFILE :)
  (9iR1 on HP)
 
  SQL conn / as sysdba
  Connected to an idle instance.
  SQL startup using spfile
 
  ORACLE instance started.
  Total System Global Area   72273416 bytes
  Fixed Size   437768 bytes
  Variable Size  37748736 bytes
  Database Buffers   33554432 bytes
  Redo Buffers 532480 bytes
  Database mounted.
  Database opened.
  SQL show parameter db_cache_size
  NAME TYPEVALUE
   ---
  --
  db_cache_sizebig integer 33554432
 
  SQL !mv spfileKED9.ora spfileKED9.ora.bak  -- hide the spfile
 
  SQL !ls -l *.ora
  -rw-r--r--   1 oracle dba  12920 May 10  2001 initdw.ora
 
  SQL alter system set db_cache_size=10M scope=both;   -- try to set a
 new
  value
 
  System altered.   --- No problem?
 
  SQL show parameter db_cache_size
 
  NAME TYPEVALUE
   ---
  --
  db_cache_sizebig integer 12582912
 
  -- New value in effect.
 
  SQL !ls -l *.ora
  -rw-r--r--   1 oracle dba  12920 May 10  2001 initdw.ora
 
  -- Still no SFILE
  -- Now, why would not Oracle tell us that there was no spfile to
 process
  SCOPE=BOTH ?
 
  SQL c/both/spfile
1* alter system set db_cache_size=10M scope=spfile
  SQL /
  alter system set db_cache_size=10M scope=spfile
  *
  ERROR at line 1:
  ORA-27037: unable to obtain file status
  HP-UX Error: 2: No such file or directory
  Additional information: 3
 
  --This is what should have happened with SCOPE=BOTH as well, or at
 least
 a
  warning that SCOPE=BOTH was processed as SCOPE=MEMORY since there was no
  SPFILE available. I would not have objected if Oracle re-recreated
 SPFILE
 in
  the default location and told me so!
 
  If anyone has seen any mention of this particular behaviour of
 SCOPE=BOTH,
 I
  would like to know the source of that information. I have searched
 Metalink,
  Google but have not come across any. I have created an iTar with OWS.
  Thanks.
 
  As I said before, SPFILE has some things that need to be made fool
 proof.
 
  This time I did not drink prior to doing this 'scary' stuff !!;-)
 
  Regards,
 
  - Kirti
 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Deshpande, Kirti
  INET: [EMAIL PROTECTED]

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

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

RE:

[Farnsworth, Dave]

HELP

-Original Message-
Royce
Sent: Monday, July 15, 2002 3:23 PM
To: Multiple recipients of list ORACLE-L
Subject: 


CONFIRM L-ORACLE

Thnx  OK Bye
Instant gratification
takes too long 
 -- Carrie Fisher

Chris Royce
[EMAIL PROTECTED]
[EMAIL PROTECTED]

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

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

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

RE: SPFILE Bug [RE: Where is Oracle 9.2 init.ora?]

[Khedr, Waleed]

Work around: Yes
do not use spfile  
Hire a DBA :)

-Original Message-
Sent: Monday, July 15, 2002 5:02 PM
To: Multiple recipients of list ORACLE-L


Okay.. Oracle Support just informed me that Bug # 2462605 has been filed
regarding this issue with SPFILE not visible to public yet, but
following text is in my TAR:

--- 
  Called customer lms on vm please call when avail 
  SME did see this.. but did not file a bug on this. 

  15-JUL-02 17:08:16 GMT
  talked with custoemr.. about this.. he would like me to file a bug 
  filing bug 
  15-JUL-02 17:19:47 GMT
  bug was filed 
  2462605

  15-JUL-02 17:29:37 GMT
  Associated bug 2462605 has been updated and has changed status to 10.
-

- Kirti 

 -Original Message-
 From: Deshpande, Kirti [SMTP:[EMAIL PROTECTED]]
 Sent: Monday, July 15, 2002 12:24 PM
 To:   Multiple recipients of list ORACLE-L
 Subject:  RE: Where is Oracle 9.2 init.ora?
 
 Thanks, Tony. 
 
 If that were the case, the second test (scope=spfile) should not have
 failed. 
 
 Oracle Support left a v-mail to me stating that they are considering this
 a
 bug. And wanted to talk to me about more testing.  I will get with them
 later today (or tomorrow). 
 
 Regards.
 
 - Kirti
  
  -Original Message-
  From:   Aponte, Tony [SMTP:[EMAIL PROTECTED]]
  Sent:   Monday, July 15, 2002 9:37 AM
  To: [EMAIL PROTECTED]
  Cc: [EMAIL PROTECTED]
  Subject:RE: Where is Oracle 9.2 init.ora?
  
  On my version of UNIX (Solaris) moving/removing a file that is in use
 only
  affects the directory entry and not the actual payload on disk.  I
 suspect
  that the spfile was held open by your sqlplus program and it executed
 the
  I/O operation using the open file descriptor.  I've participated in
  similar (and unplanned) tests with ufs-based file systems where all of
 the
  underlying files where rm-ed and the database continued to run.  It
  crashed when it tried to switch into the next and non-existent redo log
  files.  A post-mortem on the incident taught us that removing an open
 file
  only removed the entry from UNIX's directory file but the cleanup was
  postponed until the OS closed the last open handle for that i-node.  
  
  HTH 
  Tony Aponte 
  
  -Original Message- 
  From: Deshpande, Kirti [ mailto:[EMAIL PROTECTED]] 
  Sent: Sunday, July 14, 2002 6:58 PM 
  To: Multiple recipients of list ORACLE-L 
  Subject: RE: Where is Oracle 9.2 init.ora? 
  
  
  All Right, Larry. Since we have the test servers and databases; and my 
  Company still pays for 'doing Oracle' the 'scary' way, here is another 
  'scary thing' I did with SPFILE :) 
  (9iR1 on HP) 
  
  SQL conn / as sysdba 
  Connected to an idle instance. 
  SQL startup using spfile 
  
  ORACLE instance started. 
  Total System Global Area   72273416 bytes 
  Fixed Size   437768 bytes 
  Variable Size  37748736 bytes 
  Database Buffers   33554432 bytes 
  Redo Buffers 532480 bytes 
  Database mounted. 
  Database opened. 
  SQL show parameter db_cache_size 
  NAME TYPEVALUE 
   --- 
  -- 
  db_cache_sizebig integer 33554432
  
  SQL !mv spfileKED9.ora spfileKED9.ora.bak  -- hide the spfile 
  
  SQL !ls -l *.ora 
  -rw-r--r--   1 oracle dba  12920 May 10  2001 initdw.ora 
  
  SQL alter system set db_cache_size=10M scope=both;   -- try to set a
 new
  
  value 
  
  System altered.   --- No problem?  
  
  SQL show parameter db_cache_size 
  
  NAME TYPEVALUE 
   --- 
  -- 
  db_cache_sizebig integer 12582912   
  
  -- New value in effect. 
  
  SQL !ls -l *.ora 
  -rw-r--r--   1 oracle dba  12920 May 10  2001 initdw.ora 
  
  -- Still no SFILE 
  -- Now, why would not Oracle tell us that there was no spfile to
 process 
  SCOPE=BOTH ? 
  
  SQL c/both/spfile 
1* alter system set db_cache_size=10M scope=spfile 
  SQL / 
  alter system set db_cache_size=10M scope=spfile 
  * 
  ERROR at line 1: 
  ORA-27037: unable to obtain file status 
  HP-UX Error: 2: No such file or directory 
  Additional information: 3 
  
  --This is what should have happened with SCOPE=BOTH as well, or at
 least
  a 
  warning that SCOPE=BOTH was processed as SCOPE=MEMORY since there was no
 
  SPFILE available. I would not have objected if Oracle re-recreated
 SPFILE
  in 
  the default location and told me so! 
  
  If anyone has seen any mention of this particular behaviour of
 SCOPE=BOTH,
  I 
  would like to know the source of that information. I have searched
  Metalink, 
  Google but have not come across any. I have created an iTar with OWS. 
  Thanks. 
  
  As I said before, SPFILE has some things that need 

RE: Oracle and NAS storage systems

[Orr, Steve]

So if you have a very busy varchar2(1) column and a 16K db_block_size, a 16K
block is written even if only one character in the block has changed? Seems
like hotspots, er, hot blocks could do a multiplicity thing. You know...
like the more you replicate DNA the more chance for mutation?  :-)

Been watching too many movies...



-Original Message-
Sent: Monday, July 15, 2002 2:28 PM
To: Multiple recipients of list ORACLE-L


Dick,

We're using Netapp F720's to store all our datafiles (production and
test) in a small/medium OLTP environment and are quite happy with the
setup. YMMV.

We run out of two sets of collocated servers. At each collocation
there are at least two filers and at least two servers. The filers and
the servers currently have three 100BaseT network connections. One
front channel and two back channels. Each LAN segment is switched.
Thus any server at a location can connect to any filer at that
location. Datafiles can be spread across filers or spread across
channels as performance requires.

The WAFL does indeed write to the nearest available inode and relinks
the inode map.  The unlinked inode is immediately available for
rewrite unless it is a member of a snapshot.  Thus while reserving
unlinked blocks is inefficient from a storage perspective, it is a
factor you get to control by controlling the snapshots.

-rje

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

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

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

9.0.1.3: Auto Undo Mngmnt: Ora-1594, Ora-1595: Mlink Doc 210980.9 95

[MacGregor, Ian A.]

I'm see ORA-1594 and ORA-1595 errors  ON A 9.0.1.3 database.  There are no 
accompanying  ORA-601 or ORA=604 errors.  The database is using automatic undo 
management.  Here is the trace file

*** 2002-07-13 02:49:08.842
SMON: following errors trapped and ignored:
ORA-01595: error freeing extent (2) of rollback segment (8))
ORA-01594: attempt to wrap into rollback segment (8) extent (2) which is being freed
*** 2002-07-13 03:30:07.831
SMON: following errors trapped and ignored:
ORA-01595: error freeing extent (2) of rollback segment (8))
ORA-01594: attempt to wrap into rollback segment (8) extent (2) which is being freed
*** 2002-07-13 04:26:28.403
SMON: following errors trapped and ignored:
ORA-01595: error freeing extent (2) of rollback segment (8))
ORA-01594: attempt to wrap into rollback segment (8) extent (2) which is being freed
*** 2002-07-13 05:22:48.969
SMON: following errors trapped and ignored:
ORA-01595: error freeing extent (2) of rollback segment (8))
ORA-01594: attempt to wrap into rollback segment (8) extent (2) which is being freed
*** 2002-07-13 06:19:09.530
SMON: following errors trapped and ignored:
ORA-01595: error freeing extent (2) of rollback segment (8))
ORA-01594: attempt to wrap into rollback segment (8) extent (2) which is being freed
*** 2002-07-13 07:15:30.111
SMON: following errors trapped and ignored:
ORA-01595: error freeing extent (2) of rollback segment (8))
ORA-01594: attempt to wrap into rollback segment (8) extent (2) which is being freed
*** 2002-07-13 08:11:50.684
SMON: following errors trapped and ignored:
ORA-01595: error freeing extent (2) of rollback segment (8))
ORA-01594: attempt to wrap into rollback segment (8) extent (2) which is being freed
*** 2002-07-13 09:08:11.262
SMON: following errors trapped and ignored:
ORA-01595: error freeing extent (2) of rollback segment (8))
ORA-01594: attempt to wrap into rollback segment (8) extent (2) which is being freed
*** 2002-07-13 10:04:31.833
SMON: following errors trapped and ignored:
ORA-01595: error freeing extent (2) of rollback segment (8))
ORA-01594: attempt to wrap into rollback segment (8) extent (2) which is being freed
*** 2002-07-13 11:00:52.426
SMON: following errors trapped and ignored:
ORA-01595: error freeing extent (2) of rollback segment (8))
ORA-01594: attempt to wrap into rollback segment (8) extent (2) which is being freed
*** 2002-07-13 11:57:12.998
SMON: following errors trapped and ignored:
ORA-01595: error freeing extent (2) of rollback segment (8))
ORA-01594: attempt to wrap into rollback segment (8) extent (2) which is being freed
*** 2002-07-13 12:53:33.582
SMON: following errors trapped and ignored:
ORA-01595: error freeing extent (2) of rollback segment (8))
ORA-01594: attempt to wrap into rollback segment (8) extent (2) which is being freed
*** 2002-07-13 13:49:54.157
SMON: following errors trapped and ignored:
ORA-01595: error freeing extent (2) of rollback segment (8))
ORA-01594: attempt to wrap into rollback segment (8) extent (2) which is being freed
*** 2002-07-13 14:46:14.739
SMON: following errors trapped and ignored:
ORA-01595: error freeing extent (2) of rollback segment (8))
ORA-01594: attempt to wrap into rollback segment (8) extent (2) which is being freed
*** 2002-07-13 15:32:20.928
SMON: following errors trapped and ignored:
ORA-01595: error freeing extent (2) of rollback segment (8))
ORA-01594: attempt to wrap into rollback segment (8) extent (2) which is being freed
*** 2002-07-13 16:28:41.504
SMON: following errors trapped and ignored:
ORA-01595: error freeing extent (2) of rollback segment (8))
ORA-01594: attempt to wrap into rollback segment (8) extent (2) which is being freed
*** 2002-07-13 17:25:02.089
SMON: following errors trapped and ignored:
ORA-01595: error freeing extent (2) of rollback segment (8))
ORA-01594: attempt to wrap into rollback segment (8) extent (2) which is being freed
*** 2002-07-13 18:21:22.666
SMON: following errors trapped and ignored:
ORA-01595: error freeing extent (2) of rollback segment (8))
ORA-01594: attempt to wrap into rollback segment (8) extent (2) which is being freed
*** 2002-07-13 19:17:43.236
SMON: following errors trapped and ignored:
ORA-01595: error freeing extent (2) of rollback segment (8))
ORA-01594: attempt to wrap into rollback segment (8) extent (2) which is being freed
*** 2002-07-13 20:14:03.810
SMON: following errors trapped and ignored:
ORA-01595: error freeing extent (2) of rollback segment (8))
ORA-01594: attempt to wrap into rollback segment (8) extent (2) which is being freed
*** 2002-07-13 21:05:17.171
SMON: following errors trapped and ignored:
ORA-01595: error freeing extent (2) of rollback segment (8))
ORA-01594: attempt to wrap into rollback segment (8) extent (2) which is being freed
*** 
SMON: following errors trapped and ignored:
ORA-01595: error freeing extent (2) of rollback segment (8))
ORA-01594: attempt to wrap into rollback segment (8) extent (2) which is being freed

How do I check whether a rollback activity is going on

[Gurelei]

Hi. 

Here is my situation. I have killed an ORacle
transaction. Oracle came back with session marked for
kill and the status of the session is now Killed.
I presume that the reason is that Oracle needs to roll
back the changes made. Can I confirm whether this is
indeed the case via some system tables?

thakns

gene

__
Do You Yahoo!?
Yahoo! Autos - Get free new car price quotes
http://autos.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Gurelei
  INET: [EMAIL PROTECTED]

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

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

RE: How do I check whether a rollback activity is going on

[Khedr, Waleed]

You should see some activity in v$transaction.

Regards,

Waleed

-Original Message-
Sent: Monday, July 15, 2002 5:39 PM
To: Multiple recipients of list ORACLE-L


Hi. 

Here is my situation. I have killed an ORacle
transaction. Oracle came back with session marked for
kill and the status of the session is now Killed.
I presume that the reason is that Oracle needs to roll
back the changes made. Can I confirm whether this is
indeed the case via some system tables?

thakns

gene

__
Do You Yahoo!?
Yahoo! Autos - Get free new car price quotes
http://autos.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Gurelei
  INET: [EMAIL PROTECTED]

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

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

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

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

RE: Re[2]: Your password! It's S New Worm W32/Frethem.K@mm

[MacGregor, Ian A.]

It's a new one not KLEZ ...
-BEGIN PGP SIGNED MESSAGE-

A number of people have received email from contacts at other sites
with the subject line Your Password!

This is a new email-based worm that hit many European High Energy
Physics sites earlier today and is now affecting sites in the US. 
The anti-virus companies have updates available soon, but in the
meantime the SLAC email gateway has stripped on the order of 600
infected email attachments destined to SLAC users.  At this time, we
have no reports of infection within SLAC and we should remain safe
even from those who infect their own machines by reading email from
non-SLAC sources (home insititutions, Yahoo, Hotmail, etc.) and then
executing the Decrypt-password.exe file.

Here is a quote from the CIAC Heads-Up on this latest worm ...

   There are reports this morning of DOE sites being hit 
   by the W32/Frethem.K@mm worm.  The worm uses its own 
   SMTP engine to send itself to email addresses that it 
   finds in the Microsoft Windows Address Book and in .dbx, 
   .wab, .mbx, .eml, and .mdb files. The email message 
   arrives with the following characteristics:

Subject: Re: Your Password!
Attachments: Decrypt-password.exe and Password.txt
Size of attachment:  48,640 bytes

   The affected systems are Windows 95, Windows 98, 
   Windows NT, Windows 2000, Windows XP, and Windows ME.

   The worm exploits the Incorrect MIME Header Can Cause 
   IE to Execute E-mail Attachment vulnerability (CIAC 
   Bulletin L-066) in Microsoft Internet Explorer 
   (version 5.01 or 5.5 without SP2).



-BEGIN PGP SIGNATURE-
Version: PGP 7.0.4

iQCVAwUBPTMKjF1NwfDT0XdRAQGAMQP/YXjQ8xz4XnRk02OYyrGKzDSQEaIOBm/Y
H19u0QJ9t68UH8bpOf3uGtZFNV4koieizW2d39/Eiyl/HKzuPa7tkjR+QE/CFvjX
RMg2XkYwbL1fuNyVDqjbPP400G/rYPAHnOjWEtUtXjPKrZnKT+IbPJUTQHjPGkJR
jEa9o/Sejws=
=vrs9
-END PGP SIGNATURE-

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Monday, July 15, 2002 9:08 AM
To: Multiple recipients of list ORACLE-L


Bunyamin,

Did you pick up a copy of worm_klez somewhere?

Dick Goulet

Reply Separator
Author: [EMAIL PROTECTED]
Date:   7/15/2002 6:53 AM

HTMLHEAD/HEADBODY
FONT COLORÿF
bATTENTION!/bbrbr
You can accessbr
bvery important/bbr
information bybr
this passwordbrbr
bDO NOT SAVE/bbr
password to diskbr
use your mindbrbr
now pressbr
bcancel/bbrbr
(Bunyamin Karadeniz)/font/BODY/HTML
iframe src=cid:W8dqwq8q918213 height=0 width=0/iframe


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

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

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

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

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

Re[2]: Oracle and NAS storage systems

[Robert Eskridge]

Hmmn, mutation in digital storage.  Maybe that's why programs seem
to have a shelf life?


O So if you have a very busy varchar2(1) column and a 16K db_block_size, a 16K
O block is written even if only one character in the block has changed? Seems
O like hotspots, er, hot blocks could do a multiplicity thing. You know...
O like the more you replicate DNA the more chance for mutation?  :-)

O Been watching too many movies...



R The WAFL does indeed write to the nearest available inode and relinks
R the inode map.  The unlinked inode is immediately available for
R rewrite unless it is a member of a snapshot.  Thus while reserving
R unlinked blocks is inefficient from a storage perspective, it is a
R factor you get to control by controlling the snapshots.


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

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

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

RE: McCain on Larry Ellison and Corporate Responsibility / Re: OT

[Johnson, Michael]

Ditto !

-Original Message-
Sent: Monday, July 15, 2002 2:02 PM
To: Multiple recipients of list ORACLE-L
OT - unix


Nope.

I just thought that people are innocent until proven guilty.  One thing
about someone in Ellison's position is that it would be impossible for him
to *ever* sell stock without having the unfounded accusations you've quoted
being hurled at him.  So, are you saying that it is OK to throw such
accusations around, when you don't know anything about anything?  Or is
there further substantiation for what you're saying?  Does that mean he
should never sell stock?  Or should he just live his life and ignore the
critics?

I respect and admire Sen. McCain as much as I respect and admire anyone, but
he is not infallible and he (and his staff) can certainly be off the mark...

- Original Message -
To: Tim Gorman [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Monday, July 15, 2002 10:49 AM
unix


 Tim,

 It is my understanding that Oracle's stocks have gone
 up and down wildly several times.

 As you say, the only time I've heard that Larry
 Ellison cashed out before a plunge happened was the
 recent one that McCain brought up.

 I'm afraid I fail to see what you think people should
 conclude from all that.

 Are you saying that it is ok for stock holding workers
 and investors to get gigantically screwed just because
 Larry Ellison has only done it once?

 regards,
 ep


 On 15 Jul 2002 at 4:53, Tim Gorman wrote:

 Date sent:  Mon, 15 Jul 2002 04:53:21 -0800
 From:   Tim Gorman [EMAIL PROTECTED]
 Subject:Re: McCain on Larry Ellison and
 Corporate Responsibility / Re: OT -
 unix
 To: Multiple recipients of list ORACLE-L
 [EMAIL PROTECTED]

  My understanding is that this was the very first time Ellison had ever
sold
  Oracle stock, in over 25 years of the company's existence, in 2000,
which is
  the occasion that McCain (and you) are referring to.  As you might be
aware,
  there was a far greater opportunity for Ellison to cash out and
leave
  Oracle dangling in 1990, when the price dropped from around $20 to $6
almost
  overnight after some financial-earning restatements.  On that occasion,
he
  would certainly have had prior knowledge of what was going to happen, to
put
  it mildly.  In 2000, any foreknowledge of a long-term downturn (26
months
  and counting?) would have been worth far more than $700m, especially to
  someone holding several billions in equities...
 
  - Original Message -
  To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
  Sent: Sunday, July 14, 2002 10:13 PM
  unix
 
 
   Speaking of herds, or at least what is left behind on
   the ground after they pass:
  
   on Meet the Press (TV program), Senator John McCain
   said that Larry Ellison cashed out $700,000,000 of his
   Oracle stocks just before they lost most of their
   value (sarcasm: I'm sure he is planning on plowing it
   back into the company, especially improving quality in
   OWS and Metalink).

 ..



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

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

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

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

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

Re: How do I check whether a rollback activity is going on

[Jack Silvey]

Gene,

Run this repeatedly - used_ublk will reduce as it
rolls back - after it is finished the session should
dissappear.

column sql_text word_wrapped

select vs.sid, vs.serial#,vt.used_ublk, vt.start_time,
vs.username, vs.osuser, substr(vsq.sql_text,1,75)
sql_text
from v$transaction vt, v$session vs, v$sqlarea vsq
where vt.ses_addr = vs.saddr
and vsq.address(+) = vs.sql_address
/

hth,

Jack


--- Gurelei [EMAIL PROTECTED] wrote:
 Hi. 
 
 Here is my situation. I have killed an ORacle
 transaction. Oracle came back with session marked
 for
 kill and the status of the session is now Killed.
 I presume that the reason is that Oracle needs to
 roll
 back the changes made. Can I confirm whether this is
 indeed the case via some system tables?
 
 thakns
 
 gene
 
 __
 Do You Yahoo!?
 Yahoo! Autos - Get free new car price quotes
 http://autos.yahoo.com
 -- 
 Please see the official ORACLE-L FAQ:
 http://www.orafaq.com
 -- 
 Author: Gurelei
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX:
 (858) 538-5051
 San Diego, California-- Public Internet
 access / Mailing Lists


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


__
Do You Yahoo!?
Yahoo! Autos - Get free new car price quotes
http://autos.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jack Silvey
  INET: [EMAIL PROTECTED]

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

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

RE: McCain on Larry Ellison and Corporate Responsibility / Re: OT

[Johnson, Michael]

I wish I had enough money to retire.
But I did get out of the market in the
Fall of 2000 so I at least have a fighting
chance.  

This is only because I had parents
who forced me to study bull and bear markets 
and let me know that money is important.

Otherwise I would be in the same boat
as everyone else.

FWIW.

Mike

-Original Message-
Sent: Monday, July 15, 2002 1:13 PM
To: Multiple recipients of list ORACLE-L
OT




On Mon, 15 Jul 2002, Johnson, Michael  wrote:

 Everyone should have been smart enough to sell stocks and
 put their money into cash or better yet short stocks
 when it was very clear that in the Fall of 2000 after the
 initial March 2000 sell off that we were going into
 a prolonged Bear market.

It's always easy to play monday morning quarterback. I assume you are now
retired because you made so much money from the very clear and prolonged
Bear market you forcasted in Fall 2000.

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

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

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

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

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

Re: Your password! It's S New Worm W32/Frethem.K@mm

[Joe Testa]

gotta love it, linux says save to disk?

bwahahaha, all ou m$ weenies, vulnerable again.



MacGregor, Ian A. wrote:

It's a new one not KLEZ ...
-BEGIN PGP SIGNED MESSAGE-

A number of people have received email from contacts at other sites
with the subject line Your Password!

This is a new email-based worm that hit many European High Energy
Physics sites earlier today and is now affecting sites in the US. 
The anti-virus companies have updates available soon, but in the
meantime the SLAC email gateway has stripped on the order of 600
infected email attachments destined to SLAC users.  At this time, we
have no reports of infection within SLAC and we should remain safe
even from those who infect their own machines by reading email from
non-SLAC sources (home insititutions, Yahoo, Hotmail, etc.) and then
executing the Decrypt-password.exe file.

Here is a quote from the CIAC Heads-Up on this latest worm ...

   There are reports this morning of DOE sites being hit 
   by the W32/Frethem.K@mm worm.  The worm uses its own 
   SMTP engine to send itself to email addresses that it 
   finds in the Microsoft Windows Address Book and in .dbx, 
   .wab, .mbx, .eml, and .mdb files. The email message 
   arrives with the following characteristics:

Subject: Re: Your Password!
Attachments: Decrypt-password.exe and Password.txt
Size of attachment:  48,640 bytes

   The affected systems are Windows 95, Windows 98, 
   Windows NT, Windows 2000, Windows XP, and Windows ME.

   The worm exploits the Incorrect MIME Header Can Cause 
   IE to Execute E-mail Attachment vulnerability (CIAC 
   Bulletin L-066) in Microsoft Internet Explorer 
   (version 5.01 or 5.5 without SP2).



-BEGIN PGP SIGNATURE-
Version: PGP 7.0.4

iQCVAwUBPTMKjF1NwfDT0XdRAQGAMQP/YXjQ8xz4XnRk02OYyrGKzDSQEaIOBm/Y
H19u0QJ9t68UH8bpOf3uGtZFNV4koieizW2d39/Eiyl/HKzuPa7tkjR+QE/CFvjX
RMg2XkYwbL1fuNyVDqjbPP400G/rYPAHnOjWEtUtXjPKrZnKT+IbPJUTQHjPGkJR
jEa9o/Sejws=
=vrs9
-END PGP SIGNATURE-

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Monday, July 15, 2002 9:08 AM
To: Multiple recipients of list ORACLE-L


Bunyamin,

Did you pick up a copy of worm_klez somewhere?

Dick Goulet

Reply Separator
Author: [EMAIL PROTECTED]
Date:   7/15/2002 6:53 AM

HTMLHEAD/HEADBODY
FONT COLORÿF
bATTENTION!/bbrbr
You can accessbr
bvery important/bbr
information bybr
this passwordbrbr
bDO NOT SAVE/bbr
password to diskbr
use your mindbrbr
now pressbr
bcancel/bbrbr
(Bunyamin Karadeniz)/font/BODY/HTML
iframe src=cid:W8dqwq8q918213 height=0 width=0/iframe


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

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

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


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

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

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

Re: Index questions

[CC Harvest]

sorry, CBO(Cost-based Optimizer).

--- Greg Moore [EMAIL PROTECTED] wrote:
 What's CBT?
 
  If we have a column of 'Y','N' values, the index
 will
  not help with CBT(usually most of the values are
 'N').
 
 
 -- 
 Please see the official ORACLE-L FAQ:
 http://www.orafaq.com
 -- 
 Author: Greg Moore
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX:
 (858) 538-5051
 San Diego, California-- Public Internet
 access / Mailing Lists


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


__
Do You Yahoo!?
Yahoo! Autos - Get free new car price quotes
http://autos.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: CC Harvest
  INET: [EMAIL PROTECTED]

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

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

Re: Oracle on Linux ... Production Strength ???

[Ray Stell]

On Mon, Jul 15, 2002 at 07:28:23AM -0800, [EMAIL PROTECTED] wrote:
 
 Not a honeymoon issue, just that Linux progresses much


The Oracle support matrix says SuSE 7.2 and RH 7.1.  RH flagged 
in the scheme about the time RH announced entry into the db 
market with it's PostgreSQL port.  Call it what you like, 
your idea that Oracle only supports Red Hat is false.



 The folks are Oracle simply aren't used to qualifying their
 product that often -- and may consider RH 7.X to be a 
 generic platform.


Maybe not 
===
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  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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

RE: OEM Intelligent Agent and port numbers - How can I assign/configure a port

[Reardon, Bruce (CALBBAY)]

Cherie,

I summarised the ports used by Oracle for our Network support specialist and have 
copied it below:

Metalink note 69511.1 refers to SNMP and the Oracle agent - hopefully that document or 
some of the others listed can help you out.


Oracle  TCP IP Ports - for future reference

Oracle uses a number of fixed TCP ports, these include (Metalink note 99721.1 has a 
more complete list if the ports that Oracle listens on)
1521 / 1526 - used by the Oracle listener as the initial point a client connects to
2481 - the recommended and officially registered listening port for client connections 
to the Java option using TCP/IP. 
2482 - the recommended and officially registered listening port for client connections 
to the Java option using TCP/IP with SSL. 

Client Connections
xyz - ie arbitrary port
In a standard Oracle configuration , when a client connects to the listener, the 
listener spawns a dedicated connection thread for that client on a dedicated TCP port.

From Metalink note 125021.1, the server port that is assigned to the client is 
randomly chosen by the operating system and can't be modified.  It can be any free 
port available that the server determines is not is use by any other software or 
hardware.
From note 66382.1, for the port on the client PC, what happens is that the networking 
software on the client chooses at random, or in sequential order, a valid port 
(between 1024 and 65535) so the client can send and receive data. 

(Metalink notes such as 125021.1, 124140.1, 2084440.6 + 66382.1 describe use of Oracle 
with Firewalls where one option is to force all clients to share the same singular TCP 
port - other possibilities include using a Firewall that supports SQLNet / Net8 or 
using Oracle's connection manager program).



The following are used for SNMP (Metalink note 69511.1)
161 - the Oracle SNMP Master agent needs to work as the SNMP master agent so it works 
on default port of 161 and SNMP itself gets moved to another port
8161 - the port we have chosen to move Windows SNMP service to

Oracle Enterprise Manager (OEM) ports (from Metalink note 94394.1)
1748 / 1754 - Used under full control by the Oracle Intelligent agent (process that 
schedules jobs and monitoring events)
These ports are used during the discovery process of Oracle services - 1748 is used 
for basic communication and 1754 is used for file transfer
7771 - The OEM client tools use this to talk to the Oracle Management Service (OMS) 
processes.
7772 -  The Oracle intelligent agent (IA) uses this to talk to the OMS
7773 - used as a SSL channel to transfer information from the Intelligent Agent to 
Enterprise Manager framework
1808 - Tools which communicate with the Oracle Data Gatherer use this port for basic 
communication
1809 - is also used for SSL communication between the client application and the Data 
Gatherer.
xyz - ie arbitrary port based on availability -Communication from the Data 
Gatherer back to the Capacity planner is done
via a callback mechanism. Capacity Planner will initiate a communication via 1808, and 
the Data Gatherer will initiate the response back via an arbitrary port, based on 
availability.


HTH,
Bruce Reardon
-Original Message-
Sent: Tuesday, 16 July 2002 2:49

We have a third-party application that needs to use the SNMP agent
associated with OEM.   They want to be able to get to it via a particular
port.

We have a port assigned to each database, based on which Oracle version it
is running.   However, as far as I know, there is not a particular port
number associated with the OEM agent.   The only way you can designate a
particular port number is by going through a particular database.

Is this correct.   I looked through the 9.0.1 Installing the Instelligent
Agent manual and I don't see any place where it states how you can
associate the OEM agent with a specific port number on UNIX.

Does anyone know how I can do this or am I limited to just associating port
numbers with databases.

Thanks,

Cherie Machler
Oracle DBA
Gelco Information Network
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Reardon, Bruce (CALBBAY)
  INET: [EMAIL PROTECTED]

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

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

Re: How do I check whether a rollback activity is going on

[Jared . Still]

It could be that pmon is rolling back the transaction.

It could also be that pmon is never going to clean it up, which sometimes
happens when killing an active transaction. 

I am a strong advocate of using 'orakill' on NT/Win2k and 'kill -9' on 
Unix to kill the process, rather than killing the session in Oracle.

If your session has still not been cleaned up, you'll understand my
position, as you will now have to bounce your database.

Check to see if the session is holding a lock, if so, and an unreasonable
amount of time has passed for pmon to do its cleanup, then you likely
need to bounce the database.

Jared






Gurelei [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
07/15/2002 02:39 PM
Please respond to ORACLE-L

 
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc: 
Subject:How do I check whether a rollback activity is going on


Hi. 

Here is my situation. I have killed an ORacle
transaction. Oracle came back with session marked for
kill and the status of the session is now Killed.
I presume that the reason is that Oracle needs to roll
back the changes made. Can I confirm whether this is
indeed the case via some system tables?

thakns

gene

__
Do You Yahoo!?
Yahoo! Autos - Get free new car price quotes
http://autos.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Gurelei
  INET: [EMAIL PROTECTED]

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

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



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

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

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

Re: How do I check whether a rollback activity is going on

[Jared . Still]

Sorry, forgot to answer your question during all my ranting.

select s.osuser
  ,s.username
  ,s.sid
  ,r.segment_name
  ,t.space
  ,t.recursive
  ,t.noundo
  ,t.used_ublk
  ,t.used_urec
  ,t.log_io
  ,t.phy_io
  ,substr(sa.sql_text,1,200) txt
from v$session s,
 v$transaction t,
 dba_rollback_segs r,
 v$sqlarea sa
where s.taddr=t.addr
and   t.xidusn=r.segment_id(+)
and   s.sql_address=sa.address(+);

Jared





Gurelei [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
07/15/2002 02:39 PM
Please respond to ORACLE-L

 
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc: 
Subject:How do I check whether a rollback activity is going on


Hi. 

Here is my situation. I have killed an ORacle
transaction. Oracle came back with session marked for
kill and the status of the session is now Killed.
I presume that the reason is that Oracle needs to roll
back the changes made. Can I confirm whether this is
indeed the case via some system tables?

thakns

gene

__
Do You Yahoo!?
Yahoo! Autos - Get free new car price quotes
http://autos.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Gurelei
  INET: [EMAIL PROTECTED]

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

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



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

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

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

Re: OT - unix vs linux vs windows - the future

[Joe Testa]

Thats were you're wrong, i dont use microsoft products, all of my 
development and presentations that i make are non microsoft products.

for IOUG presentations, requirement is to put them in msword and 
powerpoint, i convert from star office to those formatrs and have 
someone proof them so i know the conversion went ok.

so NO I DONT PIRATE software, dont need to since all that i run is free.

And yes feel free to look at the headers of this email, its from mozilla 
on linux. :)

selling my IT manager is easy on linux, since I'm the CTO of Data 
Management Consulting, and selling using linux for development is just 
as easy at client sites.

Outradeious prices absolutely but everywhere i've been they've already 
had oracle in-house so there was no selling to do.

joe


ltiu wrote:

Oracle. It's only free during development/education. Charges will be 
exhorbitant when getting production licenses.

Windows and SQL Server is free too - if you pirate, right? It's what every 
one does : 

Linux is free but trying to sell this to your IT manager is not.

On Sunday 14 July 2002 12:43, Joe Testa wrote:

I dont think the classic unix that you speak of will go away that
fast, too many solaris/aix/hpux machines floating around still.

I do any development/testing of features on linux, it cost me nothing
but the hardware.

RH 7.3 downloaded,  no cost.

technet member 9ir2 oracle downloaded, no cost.

it only makes sense.

joe

Andrey Bronfin wrote:

hi !
i might start another war , but i can't resist a part of me which wants to
ask :
what do you , seasoned gurus, think of everybody's (as it seems to be)
plans to abandon the classic unix for linux ?
In particular , most database vendors (as well as other enterprise
software vendors) name linux as the future #1 platform for their DBs
(especially given the fact that a DB cluster is not rare any more).
It also looks like many development shops shift their efforts to develop
on windows (or , in some rare cases, linux ) instead of unix .
What do you think about this ?


DBAndrey

* 03-9254520
* 058-548133
* mailto:[EMAIL PROTECTED]




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

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

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

Re: {9i New Features: Joins}

[Joe Testa]

Jim, since you sent that to the list, do i have a userid also? :)

joe


James Howerton wrote:

All,

Here is a sample of 9i new features.  You all should have a user on
DBA9 (moray.hs.uab.edu) to try this out, if not let me know.

...JIM...

[EMAIL PROTECTED] 7/15/02 10:48:28 AM 

Welcome to the latest installment of 9i new features.  This will not be
all exhaustive but just a sample.

Here is the table scripts to build the data for testing purposes.

drop table dept;
drop table emp;


create table dept
( dept_id varchar2(5) not null,
  dept_name varchar2(50) not null);

alter table dept add constraint dept_pk
  primary key(dept_id);

create table emp
( emp_id number(5) not null,
  emp_name varchar2(50) not null,
  dept_id varchar2(5) null);

alter table emp add constraint emp_pk
  primary key(emp_id);


insert into dept values ('HR','Catbert');
insert into dept values ('PAY','Payroll');
insert into dept values ('IT','Computer Geeks');
insert into dept values ('MANAG','PHB');
insert into dept values ('EXECU','Big Cheeses');
insert into dept values ('SECRE','Secretary Pool');
insert into dept values ('DBAS','Database Admins');
insert into dept values ('SLIME','Slimy Induhviduals');
insert into dept values ('NWORK','Always Blame On');
insert into dept values ('DUH','No Clue People');


insert into emp values(10,'Bubba Jones','EXECU');
insert into emp values(11,'Honcho Man','EXECU');
insert into emp values(12,'Junior','NWORK');
insert into emp values(13,'Help Desk','NWORK');
insert into emp values(14,'Ima Dumb','DUH');
insert into emp values(15,'Dont Be','DUH');
insert into emp values(16,'Bosses Aid','SECRE');
insert into emp values(17,'Doy Doofus','MANAG');
insert into emp values(18,'Keep em Running','DBAS');
insert into emp values(19,'Look at me','SLIME');
insert into emp values(20,'HR Troop','HR');
insert into emp values(21,'Big Pain','USERS');


Ok now we have some test data, lets look at the various joins.

In the old days(and we're NOT going to talk about sub queries), we
really only had equi-joins and a single outer join.

Now we have:

1.  Natural join: This is a join between 2 or more tables where the
columns names match between the tables, like in our table, the dept_id
column is the same name between the dept_name AND the same datatype.

OLD:  select emp_id, emp_name, dept_name
  from dept, emp
  where  dept.dept_id = emp.dept_id;

NEW:  select emp_id, emp_name, dept_name
  from emp natural join dept;



Notice the results we get 11 rows but we have 12 rows in emp.  A
natural join is an equi-join where you DON'T have to put the join
condition
in the where clause.

There is a bit more to this one, check the using clause also, hint
its used if the column names match but maybe the data types don't, etc.
  


2.  Cross join:  Your and my favorite, also known as a cartesian join.

OLD:  select emp_id, emp_name, dept_name
  from dept, emp;

NEW:  select emp_id, emp_name, dept_name
  from dept cross join emp;


Useful?, I think thats up for debate :)



3.  Outer join:  This is where you join two tables and want to see all
of the rows even if there is NO match.  You could outer join to the left
or right but not both at the same time.  Now you can do left or right
outer and even full outer, examples follow:

Left:  We want to see all employees even if they dont belong to a
dept.


OLD:  select dept.dept_id, dept.dept_name, emp.emp_id
  from emp, dept
  where dept.dept_id(+) = emp.dept_id
  order by emp_id;

NEW:  select dept.dept_id, dept.dept_name, emp.emp_id
  from emp left outer join dept
  on (emp.dept_id = dept.dept_id)
  order by emp.emp_id;




Right: We want to see all depts even if they dont have employees.

OLD:  select dept.dept_id, dept.dept_name, emp.emp_id
  from emp, dept
  where dept.dept_id = emp.dept_id(+)
  order by emp_id;


NEW:  select dept.dept_id, dept.dept_name, emp.emp_id
  from emp right outer join dept
  on (dept.dept_id = emp.dept_id)
  order by emp.emp_id;



Full:  We want to see all emps with or without being assigned to a dept
and all depts with or without employees.


OLD: No such single statement quewry exists, you had to do it via 2
queries
and a union statement like this:

  select dept.dept_id, dept.dept_name, emp.emp_id
  from emp, dept
  where dept.dept_id = emp.dept_id(+)
  union
  select dept.dept_id, dept.dept_name, emp.emp_id
  from emp, dept
  where dept.dept_id(+) = emp.dept_id;

NEW:  select dept.dept_id, dept.dept_name, emp.emp_id
  from emp full outer join dept
  on (emp.dept_id = dept.dept_id)
  order by emp.emp_id;



Thats about it for today, all hate email to /dev/null, all good stuff
to [EMAIL PROTECTED] 

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  FAX: (858) 538-5051
San Diego, California-- Public Internet 

Re: Virus -- RE: FW: Yor paswrd!

[bruceb]

FYI, I have a filter in that should catch this one from now on.  Gack, I hate these. 
;-)

The list should be safe again.

thanks,
bruce

- Original Message - 
To: [EMAIL PROTECTED]
Sent: Monday, July 15, 2002 11:34


 Bruce, looks like a virus may have made it through the list.
 
 Full headers below.
 
 Jared

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

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

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

Re: Your password!

[anditri]

password.txt
Description: Binary data

Re: Your password!

[anditri]

password.txt
Description: Binary data

Re: Index questions

[Don Granaman]

Bitmapped indexes will be fast for the queryagainst the 'Y's, but a
bitmapped index may not be appropriate if you are getting lots of DML
activity on this.

Another option is to use NULL instead of the vast majority value ('N' - in
this case) and create an index.  The nulls won't be indexed, so the index
will be small.  This works best when there are relatively few non-majority
values and they are the ones most critically/commonly queried.  A hint MAY
be required to make the CBO use the index.  This obviousy won't help on
queries against 'N' though.  Example, ORDERS table with a STATUS column -
98% 'Closed', 2% ('New' | 'Pending' | 'Whatever...').  Change the logical to
interprete NULL as 'Closed' and create an index on ORDERS.STATUS.  Queries
for open orders - ('Closed' | 'Pending' | 'Whatever...') become very fast.

Don Granaman
[OraSaurus]

- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Monday, July 15, 2002 2:58 PM


If we have a column of 'Y','N' values, the index will
not help with CBT(usually most of the values are 'N').

My question is : how about bitmap indexes? Should it
help a lot, or just a little bit?

Thanks,

Chris Harvest

__
Do You Yahoo!?
Yahoo! Autos - Get free new car price quotes
http://autos.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: CC Harvest
  INET: [EMAIL PROTECTED]

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

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

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

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

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

Re: Size of Oracle server processes

[Tim Gorman]

This is a pure guess, and I don't have my own 
OraApps system to check it upon first, so this might be embarrassing, but here 
goes...

Often I see 2 sessions started for every dedicated 
server process when Oracle Forms is in use with Oracle Apps, from R10.7 on 
up. I think the Jinitiator applet is creating the second session 
associated with the process. To verify this, you could try running the 
following query and see if it returns two rows instead of one:

  select sid, serial#, username, 
  osuser, process
  from 
  v$session
  where paddr in (select 
  addr from v$process
   
  where spid = 
  oracleSID-processID)
Plug in the PID for the server process into 
"oracleSID-processID" where you are seeing the large RSS. 
If you do get two rows back from the query, then 
this might be an explanation for the increased size?

Hope this helps...

-Tim

  - Original Message - 
  From: 
  Jos 
  Someone 
  To: Multiple recipients of list ORACLE-L 
  
  Sent: Monday, July 15, 2002 1:18 PM
  Subject: Size of Oracle server 
  processes
  
  I have a question to ask regarding Oracle server process 
  (oracleSID) size. We have just installed Oracle Apps 11i, while 
  monitoring the system using glance, I notice something strange, the oracle 
  server processes - process which has a name oracleSID has a very big 
  RSS size in glance, these processes were associated with the f60webmx 
  processes. I was curious about the size of it, normally these processes are 
  about 2-3M big. I did a quick test by logging on to the database using sqlplus 
  and observe the size of the oracle server process, it showeda size 
  of 2M. So why the oracleSID processes size is so big where they are 
  assoicated with f60webmx, is it something special about them? Or the RSS size 
  shown in glance is doubling up on something?
  Jos
  
  
  
  SOLD.com.au - Find yourself a 
bargain!

(Fwd)

[Eric D. Pierce]

trying again...

--- Forwarded message follows ---
Responsibility / Re: OT -unix
Date: Mon, 15 Jul 2002 18:55:37 -0400

Connect the dots, contrary to the highly postured false 
rectitude that you
are conveying, Ellison has a very long track record of sleaze 
that at a
minimum, ought to elicite a great deal of suspicion.

(I will contact McCain's people for additional info, let me 
know if you
would like me to mention you personally :)

Assuming that you actually care about corporate 
responsibility, and aren't
just acting pissy for the heck of it, you can find additional 
background on
McCain's position here:

http://www.straighttalkamerica.com

Most recently, Oracle tried to buy off legislators to thwart 
an audit of
the ELA that Oracle/Logicon put together with the State of 
California. As
far as I'm concerned, all the *ssholes involved in that at 
Oracle/Logicon,
lobbyists, and in the legislature, ought to be in jail.

btw, I'm sure that if Ellison had sold lots of stock at the 
bottom of the
market, and then it went way up, no one would complain.

regards,
ep


| Original Message:
| -
| From: Tim Gorman Tim@SageLogix=2Ecom
| Date: Mon, 15 Jul 2002 13:02:06 -0800
| To: ORACLE-L@fatcity=2Ecom
| Subject: Re: McCain on Larry Ellison and Corporate 
Responsibility /=20
| Re: OT - unix
|
| Nope=2E
|
| I just thought that people are innocent until proven 
guilty=2E  One=20
| thing about someone in Ellison's position is that it would 
be=20
| impossible for him to *ever* sell stock without having the 
unfounded
| accusations you've quoted being hurled at him=2E  So, are 
you saying=20
| that it is OK to throw such accusations around, when you 
don't know
| anything about anything?  Or is there further substantiation 
for what
| you're saying?  Does that mean he should never sell stock?  
Or should
| he just live his life and ignore the critics?
|
| I respect and admire Sen=2E McCain as much as I respect and 
admire=20
| anyone, but he is not infallible and he (and his staff) can 
certainly
| be off the mark=2E=2E=2E


- Original Message -
To: Tim Gorman Tim@SageLogix=2Ecom; ORACLE-
L@fatcity=2Ecom
Sent: Monday, July 15, 2002 10:49 AM
unix


 Tim,

 It is my understanding that Oracle's stocks have gone
 up and down wildly several times=2E

 As you say, the only time I've heard that Larry
 Ellison cashed out before a plunge happened was the
 recent one that McCain brought up=2E

 I'm afraid I fail to see what you think people should
 conclude from all that=2E

 Are you saying that it is ok for stock holding workers
 and investors to get gigantically screwed just because
 Larry Ellison has only done it once?



--
--
mail2web - Check your email from the web at
http://mail2web=2Ecom/ =2E



--- End of forwarded message ---
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Eric D. Pierce
  INET: [EMAIL PROTECTED]

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

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

(Fwd/2)

[Eric D. Pierce]

trying again...

--- Forwarded message follows ---
Responsibility / Re: OT
Date: Mon, 15 Jul 2002 15:14:39 -0400



| Original Message:
| -
| From: Johnson, M=2E
| Date: Mon, 15 Jul 2002 10:23:21 -0800
| To: ORACLE-L@fatcity=2Ecom
| Subject: RE: McCain on Larry Ellison and Corporate 
Responsibility / Re: =
OT


| Not defending Ellison for anything,=20

Understood


| but it appears
| McCain is just another politician who is only interested
| in his future and he constantly takes on these reform
| ideas  and just makes the matter worse


That sounds really cynical to me. Are you just speculating, or 
do you have
any info to back that up?

Note that Oracle/Ellison attempted to buy off politicians here 
in
Sacramento in order to stop the JLAC (legislative) audit of 
Oracle's ELA
with the State of California

Note that Senator Sarbanes was on the same TV program (Meet 
the Press) as
McCain, and generally agreed with McCain that there is a 
horrible lack of
corporate responsibility, and that reforming the institutions 
designed to
protect the public's interests has been made extremely 
difficult by the
influence of corrupt lobbyists and lack of effective campaign 
reform

Tim Russert (a rare TV journalist with some integrity) and the 
Senators
spent most of their time discussing the issue of putting 
executive stock
options on the expense sheets so as to more correctly 
reflect
profitability (or lack thereof)

Do you think it better serves the investment community for 
sleazy corrupt
executives to be able to hide their shenanighans from analysts 
and
investors?


| Everyone should accept the fact that we are in a bear
| market and as such all the boats go down


Argh, that is the problem, when you have these outrageous 
examples of
greedy, corrupt corporate executives cashing out (***AFTER 
COOKING THE
BOOKS***), leaving others to sink


| Everyone should have been smart enough to sell stocks and
| put their money into cash or better yet short stocks
| when it was very clear that in the Fall of 2000 after the
| initial March 2000 sell off that we were going into
| a prolonged Bear market


Should have been !?!?!

That isn't really the issue. As mentioned above, the issue was 
how excess
greed played out when the books were cooked to create a 
false impression
of profitability


| Ellison probably took the money and ran when this
| became apparent to him and many others.  I know I did.


So (regardless of whether Ellison is a good example, or not), 
do you think
that there should be *any* accountability for the social 
damage caused by
greed driven unethical accounting practices?

(fwiw, I'm sympathetic to libertarian/Chicago school free 
market
ideology, but I fear that like its opposite, leftist 
utopianism, when taken
to extremes, it doesn't work all that well in the real 
world.)

regards,
ep


-Original Message-
Sent: Monday, July 15, 2002 5:53 AM
To: Multiple recipients of list ORACLE-L
OT - unix


My understanding is that this was the very first time Ellison 
had ever sol=
d
Oracle stock, in over 25 years of the company's existence, in 
2000, which =
is
the occasion that McCain (and you) are referring to=2E  As you 
might be aw=
are,
there was a far greater opportunity for Ellison to cash 
out and leave
Oracle dangling in 1990, when the price dropped from around 
$20 to $6 almo=
st
overnight after some financial-earning restatements=2E  On 
that occasion, =
he
would certainly have had prior knowledge of what was going to 
happen, to p=
ut
it mildly=2E  In 2000, any foreknowledge of a long-term 
downturn (26 month=
s
and counting?) would have been worth far more than $700m, 
especially to
someone holding several billions in equities=2E=2E=2E

- Original Message -
To: Multiple recipients of list ORACLE-L ORACLE-
L@fatcity=2Ecom
Sent: Sunday, July 14, 2002 10:13 PM
unix


 Speaking of herds, or at least what is left behind on
 the ground after they pass:

 on Meet the Press (TV program), Senator John McCain
 said that Larry Ellison cashed out $700,000,000 of his
 Oracle stocks just before they lost most of their
 value (sarcasm: I'm sure he is planning on plowing it
 back into the company, especially improving quality in
 OWS and Metalink)=2E

 regards,
 ep


 On 14 Jul 2002 at 16:28, Alex wrote:

 Date sent:  Sun, 14 Jul 2002 16:28:18 -0800
 the future
 To: Multiple recipients of list ORACLE-L
 ORACLE-L@fatcity=2Ecom

  =2E=2E=2E As far as DB vendors targeting linux they move in herds and =
have
  just finished their linux port from when linux was a buzzword=2E

 =2E=2E


--
--
mail2web - Check your email from the web at
http://mail2web=2Ecom/ =2E



--- End of forwarded message ---
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Eric D. Pierce
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, 

RE: Sun D1000 Storage Box Setup

[VIVEK_SHARMA]

Given SUN D1000 Storage Box Containing 12 Disks , For Database Layout what would be 
the most optimal Setup ?
1) 1 Volume Software RAID 1+0 Containing 6+6 Disks ?
2) 2 Volumes - Each Volume consisting of Software RAID 1+0 Containing 3+3 Disks 
3) 3 Volumes - Each Volume consisting of Software RAID 1+0 Containing 2+2 Disks 
4) Any Other Combination 

NOTE D1000 Storage Box :-
1) Does NOT have a Hardware RAID Controller 
2) Contains HIGH PERFORMANCE JBOD ARRAY
Feature: High Performance JBOD Array (D1000). 
Function: The D1000 has 2 UltraSCSI channels, with 4 UltraSCSI connections. The Netra 
st D1000 can be configured with dual 40-MB/second UltraSCSI Channels. 
Benefit: The servers may access the disk drives as individual storage components or 
may use software RAID solutions to aggregate the disk drives into bigger logical disk 
volumes. 

For more Details Check :-

http://www.sun.com/storage/workgroup/a1000/details.html

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

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

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