date:20030814

Ken - Since you've recently changed jobs, your upbeat attitude is
encouraging. I think you've made a good point that jobs aren't always
advertised. Another point is that when there are more jobs than available
candidates, companies have to advertise strongly to fill their positions.
When there are more candidates than available jobs, companies often find
that people are seeking out the opening before they post it.

Patrice - Look at what happened over the previous years. In 1999
corporations spent wildly on I.T. (naturally when the catastrophe didn't
occur because of the tireless efforts of I.T. people, the senior executives
felt the money was wasted). Then when spending would have naturally
declined, the dot-com madness stuck and things went wild. I think we are
just about to come out of the natural down cycle due to the extravagant
dot-com spending. But now I keep seeing articles about how much development
work is being sent overseas. Has anyone seen that affect Oracle DBA work
yet? 
 
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] 


-Original Message-
Sent: Thursday, August 14, 2003 9:14 AM
To: Multiple recipients of list ORACLE-L


I don't think it has as much to do with no available positions (although
that is part of the answer) as most medium to large companies don't use
newspaper ads anymore.  They are using the internet (especially for
technical jobs) and are signed up with Monster, BrassRing, etc. to do their
recruiting for them from their own company web sites.  I've seen this
definite shift here in the Minneapolis / St. Paul, MN area over the past
couple of years.  Most of these companies also provide e-mail service that
sends you an email when a job is posted that meets your specs.  So, why
waste your time on newspaper ads that only appear every Sunday?

My $0.02 worth,

Ken Janusz, CPIM


- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, August 14, 2003 6:34 AM


 I've been keeping an eye on the Boston Globe's Oracle DBA job postings,
two
 years ago it wasn't uncommon to see eight or more per week, now I tend to
 see one or two, or none.

 For a while they also announced big IT job fairs, I don't know if they
still
 do that or how successful they now are.

 The market has really shrunk in two years!

 There can't be a huge glut of DBAs out there looking for work...  It must
be
 a reduction in demand because companies are not making big infrastructure
 changes anymore.

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

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



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

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

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

RE: RMAN Script Question

2003-08-14 Thread David Wagoner

Title: RMAN Script Question



Thanks 
Samir, but I already tried that one too and it didn't work 
either.

Best regards, 
David B. Wagoner Database Administrator Arsenal Digital 
Solutions-Original Message-From: 
SARKAR, Samir [mailto:[EMAIL PROTECTED]Sent: 
Wednesday, August 06, 2003 9:52 AMTo: 
'[EMAIL PROTECTED]'Cc: David WagonerSubject: RE: RMAN 
Script Question

  David,
  
  Change the 
  following line in ur script :
  
  backup database plus archivelog delete 
  input 
  
  
  to 
  
  
  backupincremental level = 0plus 
  archivelog delete input 
  
  
  Hth,
  
  Samir
  
  Samir Sarkar Oracle DBA SchlumbergerSema 
  Email : 
  [EMAIL PROTECTED] Phone : +44 (0) 115 - 957 6028 EPABX : +44 (0) 115 - 957 6418 Ext. 
  76028 Fax : 
  +44 (0) 115 - 957 
  6018 
  
  
-Original Message-From: David Wagoner 
[mailto:[EMAIL PROTECTED]Sent: 06 August 2003 
15:09To: Multiple recipients of list ORACLE-LSubject: 
RMAN Script Question
I believe I have an RMAN script syntax 
error. The following script works fine: 

  resync catalog; run { allocate channel t1 type 'SBT_TAPE'; backup incremental level 0 skip inaccessible tag hot_db_bk_level0 filesperset 5 format 'data_full_%d_%U_%p_%c.bak' 
  (database); backup 
  tag='control_file_backup' format 'control_%s_%t.ctl' (current controlfile) ; release channel t1; } 
However, when I change the backup command to 
include archive logs and remove them after backup, I get an exit status of 1 
in NetBackup and some RMAN errors. Here is the revised 
script:

  resync catalog; run { allocate channel t1 type 'SBT_TAPE'; backup database plus archivelog delete 
  input skip 
  inaccessible tag 
  hot_db_bk_level0 filesperset 
  5 format 
  'data_full_%d_%U_%p_%c.bak' (database); backup tag='control_file_backup' 
  format 'control_%s_%t.ctl' (current 
  controlfile) ; release channel 
  t1; } 
Here is the RMAN error: 
RMAN-00571: 
=== RMAN-00569: === ERROR MESSAGE STACK 
FOLLOWS === RMAN-00571: 
=== RMAN-00558: error encountered while parsing input 
commands RMAN-01005: syntax 
error: found "(": expecting one of: "channel, comma, delete, diskratio, 
filesperset, format, force, include, keep, maxsetsize, noexclude, nokeep, 
not, parms, pool, ;, skip, setsize, tag"
RMAN-01007: at line 8 column 36 file: 
/usr/openv/netbackup/oracle_db/hot_database_backup_level0.rcv 
Anyone see the error? 
Best regards, 
David B. Wagoner Database Administrator Arsenal Digital Solutions

A real newbie DBA question on setting up a 9i client

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

When I configure an 8i client to attach to an Oracle database, I always
have the
The service name which has always been the database/instance name -- I
assume these don't necessarily have to be the same, but it appears to be
that way for single database applications.

I also have the host name which has always been the NetBIOS name of the
hosting W2K server.

So here is the question, is that all I need to configure the client if I
know I'm going to connect using TCP for a 9i client?

v/r

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

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

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

RE: OCP Question

2003-08-14 Thread Mercadante, Thomas F

Jay,

I would guess B and E.  I see no reason for a redo-log switch.  Looks like a
trick question.  B is one correct answer.  The other correct is either E or
A.  I would go for E.

Tom Mercadante
Oracle Certified Professional


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


Hello:

I was going through some OCP questions and wanted to make sure that my 
answers where correct.
This question comes from a 3rd party testing site, I have been checking each

question against my study guides to make sure they are correct.

I've done some testing and think that my answers might be correct but would 
like to double check as well as get anyone elses option on the answers and 
the reasoning for option E.

When the status of the tablespace moves from read-only to read write, which 
tow events occur?
(Choose Two)

A) Redo-log switch must take place
B) Normal checkpoints on the file now occur
C) Oracle automatically marks the file for backup
D) All objects in the tablespace are checked for integrity
E) The the DBWn process writes to the data files of the tablespace


I believe the answers are A, B

Reason:
A) I tested moving the a tablespace from read-only to read write and have 
noticed a log switch after moving the tablespace to a writeable state.
B) Since it is on longer Read-Only it will be updated during the checkpoint 
process
C) Doesn't happen, at least in my reading or testing
D) No verify structure is issued, or any of the other oracle tools for 
object checking are used
E) I'm alittle unsure of this one, it should update the headers how since it

is in a Read Write mode, although this should only happen at a checkpoint 
right?


Thanks in Advance,
Jay

_
MSN 8 with e-mail virus protection service: 2 months FREE*  
http://join.msn.com/?page=features/virus

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

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

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

Re: ora 1575?

2003-08-14 Thread Tim Gorman

Tanel hit the nail on the head.  In the past, ORA-01575 was usually
associated with temporary tablespaces that were DMT and not tablespace type
TEMPORARY (which started in Oracle7.3).  First and foremost, please make
sure you are using a TEMPORARY tablespace which is locally-managed and uses
TEMPFILEs...

It might be interesting to monitor V$LOCK for TYPE = 'ST' to see what
sessions are holding this enqueue.  If the activity is too transient,
perhaps querying V$SESSION_EVENT where EVENT = 'enqueue' might indirectly
imply which sessions have waited on an enqueue (not necessarily ST,
thought!) sometime in the past...



on 8/13/03 7:04 AM, Tanel Poder at [EMAIL PROTECTED] wrote:

 Hi!
 
 You can always schedule alter tablespace coalesce's during low usage time.
 But you should check whether you have adjacent free extents in your
 tablespaces at all? If you're not doing lot's of dropping or truncating
 objects, then you shouldn't have. Thus no need for coalesce either. Just
 check that all of your sort segments go to the temp tablespace (which should
 be in temporary mode, preferrably LMT as well).
 
 Tanel.
 
 
 thanks for the info. We do have a number of DMTS in
 the database. Three of them have pct_increase of 50%,
 the rest - 0. Should I consider changing the
 pct_increase to 0 in all tablespaces in order to get
 rid of this ora 1575? Wouldn't I want to have an
 automatic coalesce process for the DMTS though?
 
 thank you
 
 Gene
 --- Tim Gorman [EMAIL PROTECTED] wrote:
 Haven't seen this error since Oracle7...
 
 If the message is hitting the alert.log, then
 chances are good it is
 coming from SMON.  SMON is attempting to acquire the
 ST (a.k.a. Space
 transaction) enqueue in preparation for coalescing
 free space in some
 tablespaces.  However, if it is unable to acquire
 ST after a couple
 seconds, it times out and issues ORA-01575 to the
 alert.log.
 
 So, based on experiences from 6-7 years ago:
 
 * do you have a lot of dictionary-managed
 tablespaces?
 * do these DMT's have default PCTINCREASE
 non-zero, thus attacting
   SMON to do coalescing?
 
 If so, I'd suggest going to locally-managed
 tablespaces if at all
 possible...
 
 
 
 on 8/12/03 12:44 PM, Gurelei at [EMAIL PROTECTED]
 wrote:
 
 Hi all:
 
 I'm seeing the ora-01575 error in the alert
 logfile.
 The article on the metalink refers to the
 parameter
 which I think is obsolete in the ORacle version we
 are
 running (8.1.7). What does this error refer to?
 Any
 thoughts? references?
 
 thanks
 
 gene
 
 __
 Do you Yahoo!?
 Yahoo! SiteBuilder - Free, easy-to-use web site
 design software
 http://sitebuilder.yahoo.com
 
 -- 
 Please see the official ORACLE-L FAQ:
 http://www.orafaq.net
 -- 
 Author: Tim Gorman
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- 858-538-5051
 http://www.fatcity.com
 San Diego, California-- Mailing list and web
 hosting services
 
 -
 To REMOVE yourself from this mailing list, send an
 E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of
 'ListGuru') and in
 the message BODY, include a line containing: UNSUB
 ORACLE-L
 (or the name of mailing list you want to be removed
 from).  You may
 also send the HELP command for other information
 (like subscribing).
 
 
 __
 Do you Yahoo!?
 Yahoo! SiteBuilder - Free, easy-to-use web site design software
 http://sitebuilder.yahoo.com
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.net
 -- 
 Author: Gurelei
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- 858-538-5051 http://www.fatcity.com
 San Diego, California-- Mailing list and web hosting services
 -
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).
 
 

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

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

RE: HELP! Index Debate!

2003-08-14 Thread Henry Poras

Interesting analysis. Thanks.

Henry

-Original Message-
Wolfgang Breitling
Sent: Monday, August 04, 2003 11:49 PM
To: Multiple recipients of list ORACLE-L


Yes, the index can be used, but only the portion up to the first missing
column, or a column where the predicate is not an equal predicate, is used.
Those are so-called access predicates. The remaining predicates are
resolved after the row is fetched from the datablock - a so-called filter
predicate.

I offer some indirect evidence. Consider table test (a number, b number, c
number, d number, e varchar2(500));
The table is loaded as follows:
insert into test select mod(trunc(dbms_random.value*100,0),5)+1
, mod(trunc(dbms_random.value*100,0),5)+1
, mod(trunc(dbms_random.value*100,0),5)+1
, mod(trunc(dbms_random.value*100,0),5)+1
, rpad('a',50,'*')
from dba_objects where rownum = 25005
/
commit;
create index test_a on test (a, b, c, d);
analyze table test compute statistics;

I then ran a sequemce of test sql:

alter tablespace users offline;
alter tablespace users online;
alter session set events '10046 trace name context forever, level 8';
select e from test
where a=1
   and b=1
   and c=1
   and d=1
/
alter session set events '10046 trace name context off';

alter tablespace users offline;
alter tablespace users online;
alter session set events '10046 trace name context forever, level 8';
select e from test
where a=1
   and b=1
   and c=1
   and d2
/
alter session set events '10046 trace name context off';

alter tablespace users offline;
alter tablespace users online;
alter session set events '10046 trace name context forever, level 8';
select e from test
where a=1
   and b=1
   and c2
   and d=1
/
alter session set events '10046 trace name context off';

alter tablespace users offline;
alter tablespace users online;
alter session set events '10046 trace name context forever, level 8';
select e from test
where a=1
   and b2
   and c=1
   and d=1
/
alter session set events '10046 trace name context off';

and

alter tablespace users offline;
alter tablespace users online;
alter session set events '10046 trace name context forever, level 8';
select e from test
where a2
   and b=1
   and c=1
   and d=1
/
alter session set events '10046 trace name context off';

Note that because of the way the data is loaded, columns a, b, c, and d
only have values of 1,2,3,4, or 5 and therefore all the sql return the same
rows. The tablespace offline/online is there to invalidate any buffers of
the table and the index in the buffer pool (both are in tablespace users)
so that every query has to start from scratch.

Here are the trace results. Tablespace users consists of datafile #4. All
extents are 8 blocks (uniform LMT) and blocks 34985-35152 makes up the
index and blocks 24721-24728, 25337-26296, and 32825-34984 make up the
table:

PARSING IN CURSOR #1 len=59 dep=0 uid=23 oct=3 lid=23 tim=2925349191
hv=596441455 ad='511d4e88'
select e from test
where a=1
   and b=1
   and c=1
   and d=1
END OF STMT
PARSE #1:c=0,e=0,p=0,cr=0,cu=0,mis=1,r=0,dep=0,og=4,tim=2925349191
EXEC #1:c=0,e=0,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=4,tim=2925349191
WAIT #1: nam='SQL*Net message to client' ela= 0 p1=1413697536 p2=1 p3=0
WAIT #1: nam='file open' ela= 0 p1=0 p2=0 p3=0
WAIT #1: nam='db file sequential read' ela= 0 p1=4 p2=34986 p3=1
WAIT #1: nam='db file sequential read' ela= 0 p1=4 p2=34987 p3=1
WAIT #1: nam='db file sequential read' ela= 0 p1=4 p2=25345 p3=1
FETCH #1:c=0,e=0,p=3,cr=3,cu=0,mis=0,r=1,dep=0,og=4,tim=2925349191
WAIT #1: nam='SQL*Net message from client' ela= 0 p1=1413697536 p2=1 p3=0
WAIT #1: nam='db file sequential read' ela= 0 p1=4 p2=25688 p3=1
WAIT #1: nam='SQL*Net message to client' ela= 0 p1=1413697536 p2=1 p3=0
WAIT #1: nam='db file sequential read' ela= 0 p1=4 p2=25740 p3=1
WAIT #1: nam='db file sequential read' ela= 0 p1=4 p2=25839 p3=1
WAIT #1: nam='db file sequential read' ela= 0 p1=4 p2=25910 p3=1
WAIT #1: nam='db file sequential read' ela= 0 p1=4 p2=25925 p3=1
WAIT #1: nam='db file sequential read' ela= 0 p1=4 p2=25948 p3=1
WAIT #1: nam='db file sequential read' ela= 0 p1=4 p2=26018 p3=1
WAIT #1: nam='db file sequential read' ela= 0 p1=4 p2=26240 p3=1
WAIT #1: nam='db file sequential read' ela= 0 p1=4 p2=33350 p3=1
WAIT #1: nam='db file sequential read' ela= 0 p1=4 p2=33489 p3=1
WAIT #1: nam='db file sequential read' ela= 0 p1=4 p2=33840 p3=1
WAIT #1: nam='db file sequential read' ela= 0 p1=4 p2=33903 p3=1
WAIT #1: nam='db file sequential read' ela= 0 p1=4 p2=34032 p3=1
WAIT #1: nam='db file sequential read' ela= 0 p1=4 p2=34114 p3=1
WAIT #1: nam='db file sequential read' ela= 0 p1=4 p2=34207 p3=1
FETCH #1:c=0,e=0,p=15,cr=16,cu=0,mis=0,r=15,dep=0,og=4,tim=2925349191
WAIT #1: nam='SQL*Net message from client' ela= 5 p1=1413697536 p2=1 p3=0
WAIT #1: nam='db file sequential read' ela= 0 p1=4 p2=34235 p3=1
WAIT #1: nam='SQL*Net message to client' ela= 0 p1=1413697536 p2=1 p3=0
WAIT #1: nam='db file sequential read' ela= 0 p1=4 p2=34280 p3=1
WAIT #1: nam='db

RE: Re: OT -- Boston Globe job listings

When I worked for Oracle's custom development group
I worked on a large
conversion project that employed about 350
consultants (150 from Oracle).
They had a number of foreign consultants on the
project.  About 1 in 10 had
technical skills that were above mediocre, but they
worked cheap.  The code
they produced was a mess and we at Oracle wondered
how much time / money
would have to be spent after the fact to clean up
what the company got on
the cheap.  You get what you pay for.  I have dealt
with offshore technical
Oracle staff and have found them to be cheap in
cost but very poor overall
in the quality of what they delivered.  Companies
will wake up to this
sooner or later.

Ken

I basically think like you but I don't believe that offshore programmers are 
*inherently* worse than onshore programmers. I have lately been reviewing European as 
well as Indian code and in all honesty it was harder to tell which one was worse than 
the other; the 1 in 10 ratio you mention is more like a general rule. Productivity may 
be different though, but I hardly think positively of churning out bad code faster. I 
rather attribute the poor quality of some offshore developments to two factors, and in 
this order :
1 - It's dreadfully difficult to produce good code when you are far from your 
end-users. Specs are rarely perfect, and when all of your energy is absorbed by trying 
to make sense of what you are coding, quality comes a distant second.
2 - Cultural factors make it difficult for somebody raised in Asia and working in Asia 
to improve on the sometimes shoddy specs provided. Language can be a barrier, 
pseudo-code is slavishly turned into actual code (hmmm all those nice PL/SQL cursor 
loops), and if the management asks for something then it must be followed - you cannot 
make management lose face. I have recently seen a (grossly) grammatically incorrect 
error message in the specs popping up exactly the same in the code.

Regards,

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

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

Cisco security notice mentions the blaster worm possibly affectin

2003-08-14 Thread Rodrigues, Bryan

 existing access-list entries here

set security acl ip BLASTER permit any any

! -- applies both inbound and outbound

commit security acl BLASTER
set security acl map BLASTER vlans

To verify:

show security acl info all

To remove:

clear security acl BLASTER
commit security acl BLASTER

Catalyst 3550

Apply the IOS ACL on switch virtual interfaces (SVIs), which are Layer 3
interfaces to VLANs; on physical Layer 3 interfaces; and on Layer 3
EtherChannel interfaces in both the inbound and/or outbound direction.
Ensure
'no ip unreachable' is configured on the interface.

Apply the IOS ACL to Layer 2 interfaces on the switch only if an IOS ACL is
not
also applied to the input of a Layer 3 interface (an error message is
generated
upon attempts to do so). For Layer 2 interfaces the IOS ACL is supported on
the
physical interfaces only and not on EtherChannel interfaces. It can be
applied
on the inbound direction only.

Catalyst 2950

Apply the IOS ACL to the interface. Note that ACL's are only supported in
the
inbound direction. To apply ACLs to physical interfaces the enhanced
software
image (EI) must be installed.

Catalyst 2900XL and 3500XL

These are Layer 2 switches with no Layer 3 access list support.

PIX

The default behavior of the PIX is to block traffic from lower security
level
interfaces (OUTSIDE) to higher security level interfaces (INSIDE) unless the
affected ports and protocols have been explicitly permitted by an
access-list
or conduit.

In addition, Cisco recommends blocking traffic from higher security level
interfaces (INSIDE) to lower security level interfaces (OUTSIDE).

Customers should deny outbound attempts to these ports:

access-list acl_inside deny udp any any eq 69
access-list acl_inside deny tcp any any eq 135
access-list acl_inside deny udp any any eq 135
access-list acl_inside deny tcp any any eq 137
access-list acl_inside deny udp any any eq 137
access-list acl_inside deny tcp any any eq 138
access-list acl_inside deny udp any any eq 138
access-list acl_inside deny tcp any any eq 139
access-list acl_inside deny udp any any eq 139
access-list acl_inside deny tcp any any eq 445
access-list acl_inside deny tcp any any eq 593
access-list acl_inside deny tcp any any eq 

! --- insert previously configured acl statements here, 
! --- or permit all other traffic out

access-list acl_inside permit ip any any

access-group acl_inside in interface inside

The corresponding outbound lists may be applied, however, ACLs are strongly
recommended in lieu of outbound lists.

Exploitation and Public Announcements
=

This issue is being exploited actively and has been discussed in numerous
public announcements and messages. References include:

  * http://www.eeye.com/html/Research/Advisories/AL20030811.html 
   
  * http://www.cert.org/advisories/CA-2003-20.html 
   
Status of This Notice: INTERIM
=

This is a DRAFT notice. Although Cisco cannot guarantee the accuracy of all
statements in this notice, all of the facts have been checked to the best of
our ability. Cisco anticipates issuing updated versions of this notice when
there is material change in the facts.

Distribution


This notice will be posted on Cisco's worldwide website at 
http://www.cisco.com/warp/public/707/cisco-sn-20030814-blaster.shtml. 
In addition to worldwide web posting, a text version of this notice is
clear-signed with the Cisco PSIRT PGP key and is posted to the following
e-mail and Usenet news recipients:

  * [EMAIL PROTECTED]
   
Future updates of this notice, if any, will be placed on Cisco's worldwide
web.
Users concerned about this problem are encouraged to check the URL given
above
for any updates.

Revision History


+-+
| Revision | 14-August-2003 | Initial Public  |
| 1.0  || Release |
+-+

Cisco Security Procedures
=

If you have any new information that would be of use to us, please send
email
to [EMAIL PROTECTED]

Complete information on reporting security vulnerabilities in Cisco
products,
obtaining assistance with security incidents, and registering to receive
security information from Cisco, is available on Cisco's worldwide website
at 
http://www.cisco.com/warp/public/707/sec_incident_response.shtml. This
includes
instructions for press inquiries regarding Cisco security notices. All Cisco
Security Advisories are available at http://www.cisco.com/go/psirt/.

-

--

Related Information
===

  * Technical Support - Cisco Systems
  http://www.cisco.com/en/US/customer/support/index.html

-

--
All contents

HP-UX

2003-08-14 Thread Seema Singh

Hi,
Can someone send me  system administration document on OS HP-UX 11.0 if have 
?
thx
-Seema

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

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

RE: HP-UX

The standard manual set is quite large.  You might try HP-UX 11.x System
Administration by Poniatowsky.  A really short quide capable of being
sent to you in email might exist.  If so it will only suffice to make
you extremely dangerous and will almost certainly get you into a lot of
trouble.  At best it would be a cookbook.  You would gain no
understanding of underlying UNIX concepts.  If you don't want to buy a
book, http://docs.hp.com has the official documentation and it is free.

Allan

-Original Message-
Sent: Thursday, August 14, 2003 11:45 AM
To: Multiple recipients of list ORACLE-L


Hi,
Can someone send me  system administration document on OS HP-UX 11.0 if
have 
?
thx
-Seema

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

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

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


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

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

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

2003-08-14 Thread KENNETH JANUSZ

When I worked for Oracle's custom development group I worked on a large
conversion project that employed about 350 consultants (150 from Oracle).
They had a number of foreign consultants on the project.  About 1 in 10 had
technical skills that were above mediocre, but they worked cheap.  The code
they produced was a mess and we at Oracle wondered how much time / money
would have to be spent after the fact to clean up what the company got on
the cheap.  You get what you pay for.  I have dealt with offshore technical
Oracle staff and have found them to be cheap in cost but very poor overall
in the quality of what they delivered.  Companies will wake up to this
sooner or later.

Ken


- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, August 14, 2003 10:59 AM


 inline

  But now I keep seeing
  articles about how much development work is being sent
  overseas. Has anyone seen that affect Oracle DBA work yet?

 Huge discussions going on here at work about that very subject.  So far,
no one has come up with a reasonable argument for keeping the jobs in-house.
At the gut level it 'feels' like we should keep the jobs in-house and that
would be an overall benefit to the economy, too.  However, the financial
argument of should I pay 75K - 120K a year for US based DBAs or pay 45K -
80K for offshore talent is hard to beat.  The money ranges I gave are
contract employee/job shop type of quotes, IOW, a 75K US position would be
for a junior DBA that is actually getting 35K-40K and so on up the skill
range.

 v/r

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


 
  Dennis Williams
  DBA
  Lifetouch, Inc.
  [EMAIL PROTECTED] mailto:[EMAIL PROTECTED]
 
 
  -Original Message-
  Sent: Thursday, August 14, 2003 9:14 AM
  To: Multiple recipients of list ORACLE-L
 
 
  I don't think it has as much to do with no available
  positions (although that is part of the answer) as most
  medium to large companies don't use newspaper ads anymore.
  They are using the internet (especially for technical jobs)
  and are signed up with Monster, BrassRing, etc. to do their
  recruiting for them from their own company web sites.  I've
  seen this definite shift here in the Minneapolis / St. Paul,
  MN area over the past couple of years.  Most of these
  companies also provide e-mail service that sends you an email
  when a job is posted that meets your specs.  So, why waste
  your time on newspaper ads that only appear every Sunday?
 
  My $0.02 worth,
 
  Ken Janusz, CPIM
 
 
  - Original Message -
  To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
  Sent: Thursday, August 14, 2003 6:34 AM
 
 
   I've been keeping an eye on the Boston Globe's Oracle DBA job
   postings,
  two
   years ago it wasn't uncommon to see eight or more per week,
  now I tend
   to see one or two, or none.
  
   For a while they also announced big IT job fairs, I don't
  know if they
  still
   do that or how successful they now are.
  
   The market has really shrunk in two years!
  
   There can't be a huge glut of DBAs out there looking for
  work...  It
   must
  be
   a reduction in demand because companies are not making big
   infrastructure changes anymore.
  
   Patrice.
   --
   Please see the official ORACLE-L FAQ: http://www.orafaq.net
   --
   Author: Boivin, Patrice J
 INET: [EMAIL PROTECTED]
  
   Fat City Network Services-- 858-538-5051 http://www.fatcity.com
   San Diego, California-- Mailing list and web
  hosting services
  
  -
   To REMOVE yourself from this mailing list, send an E-Mail message
   to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
   the message BODY, include a line containing: UNSUB ORACLE-L (or the
   name of mailing list you want to be removed from).  You may
  also send
   the HELP command for other information (like subscribing).
  
  
 
  --
  Please see the official ORACLE-L FAQ: http://www.orafaq.net
  --
  Author: KENNETH JANUSZ
INET: [EMAIL PROTECTED]
 
  Fat City Network Services-- 858-538-5051 http://www.fatcity.com
  San Diego, California-- Mailing list and web hosting services
  -
  To REMOVE yourself from this mailing list, send an E-Mail message
  to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru')
  and in the message BODY, include a line containing: UNSUB
  ORACLE-L (or the name of mailing list you want to be removed
  from).  You may also send the HELP command for other
  information (like subscribing).
  --
  Please see the official ORACLE-L FAQ: http://www.orafaq.net
  --
  Author: DENNIS WILLIAMS
INET: [EMAIL PROTECTED]
 
  Fat City Network Services-- 858-538-5051 http://www.fatcity.com
  San Diego, California-- Mailing list and web hosting services

RE: Executing Oracle stored proc. over SQL Server linked services

2003-08-14 Thread Paula_Stankus

Title: RE: Executing Oracle stored proc. over SQL Server linked services





We have installed 9i client and 9i ole db provider and are trying to execute a procedure with input/output variables over a linked service in SQL Server database. We keep getting an error about undefined column. Has anyone done this before and do you have syntax. 

-SQL Server 2000
-Oracle 9i
-OLE DB
-Using SQL Server Query Analyzer
-We can successfully return data using openquery and passing just a SQL statement
-We can successfully execute functions
-Stored procedure gets error undefined columns

Re: streams comments

Stephen,

Did you write all the parameters by hand or used a script? ;)

 analyze table   have exec
DBMS_STATS.ONE_OF_273_POSSIBLE_CALLS(arg1,
 arg2, arg3, arg4, arg5, arg6, arg7, arg8, arg9, arg10, arg11, arg12,
arg13,
 arg14, arg15, arg16, arg17, arg18, arg19, arg20, arg21, arg22, arg23,
arg24,
 arg25, arg26, arg27, arg28, arg29, arg30, arg31, arg32, arg33, arg34,
arg35,
 arg36, arg37, arg38, arg39, arg40, arg41, arg42, arg43, arg44, arg45,
arg46,
 arg47, arg48, arg49, arg50, arg51, arg52, arg53, arg54, arg55, arg56,
arg57,
 arg58, arg59, arg60, arg61, arg62, arg63, arg64, arg65, arg66, arg67,
arg68,
 arg69, arg70, arg71, arg72, arg73, arg74, arg75, arg76, arg77, arg78,
arg79,
 arg80, arg81, arg82, arg83, arg84, arg85, arg86, arg87, arg88, arg89,
arg90,
 arg91, arg92, arg93, arg94, arg95, arg96, arg97, arg98, arg99, arg100).

 Do you get the impression that Oracle is just too damn lazy to update
their
 syntax parser?

I don't see anything wrong with it - I thank god (every night) that Oracle
has so many features and controls and hasn't hidden them away from us. If
you want to do things easy - use OEM and get SQL  PL/SQL execution commands
from it using Show SQL.

Tanel.


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

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

RE: OT -- Boston Globe job listings

2003-08-14 Thread Pardee, Roy E

Companies will wake up--or as likely--the offshore techies' skills will grow with 
experience  their work product will get better.  

Hopefully they'll also raise their prices at that point, tho they'll still have to 
entice companies to deal with the geographic/time/cultural differences so I'd guess 
there was a limit on how much they can do.

Is anyone in IT immune to this trend?  Maybe business analysts, due to the 
face-to-face they have to have w/the principles of the business?

Cheers,

-Roy

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

-Original Message-
Sent: Thursday, August 14, 2003 9:09 AM
To: Multiple recipients of list ORACLE-L


When I worked for Oracle's custom development group I worked on a large
conversion project that employed about 350 consultants (150 from Oracle).
They had a number of foreign consultants on the project.  About 1 in 10 had
technical skills that were above mediocre, but they worked cheap.  The code
they produced was a mess and we at Oracle wondered how much time / money
would have to be spent after the fact to clean up what the company got on
the cheap.  You get what you pay for.  I have dealt with offshore technical
Oracle staff and have found them to be cheap in cost but very poor overall
in the quality of what they delivered.  Companies will wake up to this
sooner or later.

Ken


- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, August 14, 2003 10:59 AM


 inline

  But now I keep seeing
  articles about how much development work is being sent
  overseas. Has anyone seen that affect Oracle DBA work yet?

 Huge discussions going on here at work about that very subject.  So far,
no one has come up with a reasonable argument for keeping the jobs in-house.
At the gut level it 'feels' like we should keep the jobs in-house and that
would be an overall benefit to the economy, too.  However, the financial
argument of should I pay 75K - 120K a year for US based DBAs or pay 45K -
80K for offshore talent is hard to beat.  The money ranges I gave are
contract employee/job shop type of quotes, IOW, a 75K US position would be
for a junior DBA that is actually getting 35K-40K and so on up the skill
range.

 v/r

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


 
  Dennis Williams
  DBA
  Lifetouch, Inc.
  [EMAIL PROTECTED] mailto:[EMAIL PROTECTED]
 
 
  -Original Message-
  Sent: Thursday, August 14, 2003 9:14 AM
  To: Multiple recipients of list ORACLE-L
 
 
  I don't think it has as much to do with no available
  positions (although that is part of the answer) as most
  medium to large companies don't use newspaper ads anymore.
  They are using the internet (especially for technical jobs)
  and are signed up with Monster, BrassRing, etc. to do their
  recruiting for them from their own company web sites.  I've
  seen this definite shift here in the Minneapolis / St. Paul,
  MN area over the past couple of years.  Most of these
  companies also provide e-mail service that sends you an email
  when a job is posted that meets your specs.  So, why waste
  your time on newspaper ads that only appear every Sunday?
 
  My $0.02 worth,
 
  Ken Janusz, CPIM
 
 
  - Original Message -
  To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
  Sent: Thursday, August 14, 2003 6:34 AM
 
 
   I've been keeping an eye on the Boston Globe's Oracle DBA job
   postings,
  two
   years ago it wasn't uncommon to see eight or more per week,
  now I tend
   to see one or two, or none.
  
   For a while they also announced big IT job fairs, I don't
  know if they
  still
   do that or how successful they now are.
  
   The market has really shrunk in two years!
  
   There can't be a huge glut of DBAs out there looking for
  work...  It
   must
  be
   a reduction in demand because companies are not making big
   infrastructure changes anymore.
  
   Patrice.
   --
   Please see the official ORACLE-L FAQ: http://www.orafaq.net
   --
   Author: Boivin, Patrice J
 INET: [EMAIL PROTECTED]
  
   Fat City Network Services-- 858-538-5051 http://www.fatcity.com
   San Diego, California-- Mailing list and web
  hosting services
  
  -
   To REMOVE yourself from this mailing list, send an E-Mail message
   to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
   the message BODY, include a line containing: UNSUB ORACLE-L (or the
   name of mailing list you want to be removed from).  You may
  also send
   the HELP command for other information (like subscribing).
  
  
 
  --
  Please see the official ORACLE-L FAQ: http://www.orafaq.net
  --
  Author: KENNETH JANUSZ
INET: [EMAIL PROTECTED]
 
  Fat City Network Services-- 858-538-5051 http://www.fatcity.com
  San Diego, California-- Mailing list and web hosting services

RE: HP-UX

2003-08-14 Thread Jesse, Rich

How's about a link instead?

http://www.bookpool.com/.x/6oqxxyd9k4/sm/0130125156


Rich

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


 -Original Message-
 From: Seema Singh [mailto:[EMAIL PROTECTED]
 Sent: Thursday, August 14, 2003 11:45 AM
 To: Multiple recipients of list ORACLE-L
 Subject: HP-UX
 
 
 Hi,
 Can someone send me  system administration document on OS 
 HP-UX 11.0 if have 
 ?
 thx
 -Seema
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jesse, Rich
  INET: [EMAIL PROTECTED]

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

RE: OT -- Boston Globe job listings


But lower paying jobs mean lower tax revenues.  Uh oh!

 -Original Message-
 
   Regrettably that average collection of greedy, stupid 
 executives are also the politicians we have to deal with as 
 well.  Just take a look at King George  his greedy deputy Chaney.
 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Stephen Lee
  INET: [EMAIL PROTECTED]

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

RE: OT -- Boston Globe job listings


Back in the days when I used to do configuration management (among other
things), I saw which programmers were producing what code and found that a
good programmer would average about 10 - 20 times the amount of a
typical programmer.  And a kick ass programmer would produce about 100
times the code everyone else; and the code is better quality.

I have seen that the most important factor in development costs are the
ability of the management to build a staff of programmers who are in the
good to kick ass range -- a process that seems to take about 3 to 5
years depending on the job/employee market.  But my experience has been rare
that management understands that, in terms of cost per line of code, the
best programmers are the most cost-effective programmers.

The best programmer I ever saw usually produced about 100 times the output
of the rest of the entire project staff; and he was working on the most
difficult parts of the application.  He also packed both his upper and lower
gums with Copenhagen snuff, smoked cigarettes, drank coffee, and wore a
nicotine patch.  I'm not kidding; we're talking wired to the max.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Stephen Lee
  INET: [EMAIL PROTECTED]

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

OT -- Boston Globe job listings

2003-08-14 Thread Boivin, Patrice J

I've been keeping an eye on the Boston Globe's Oracle DBA job postings, two
years ago it wasn't uncommon to see eight or more per week, now I tend to
see one or two, or none.

For a while they also announced big IT job fairs, I don't know if they still
do that or how successful they now are.

The market has really shrunk in two years!

There can't be a huge glut of DBAs out there looking for work...  It must be
a reduction in demand because companies are not making big infrastructure
changes anymore.

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

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

If you load your data into a table with an enable foreign key, it will be checked on 
the fly by SQL*Loader with the conventional path. In direct mode it disables 
constraints, and I am unsure whether it checks them when reenabling them (something 
which you can optionally get); any way it would let you with the manual check to do.
If your CSV file is not in the million of rows or more range, I would go for 
SQL*Loader with the conventional path.

HTH

SF

- --- Original Message --- -
From: Saira Somani-Mendelin
[EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L
[EMAIL PROTECTED]
Sent: Thu, 14 Aug 2003 05:44:23

List,

I have been given a csv file to load into an Oracle
table. This table
has no referential integrity constraints (it is
checked via the
application) so I could end up inserting a bogus
record. 

Is there any way for me to check for the existence
of a record in
another table while loading data using SQL*Loader? 


Here's the process I use right now:

Load records into a temporary table.
Query these records against the reference table.
If record doesn't exist, spool it into a file, give
it back to the BA,
get them to fix it, then go through the whole
process again until there
are no bad records.

Seems like a roundabout way to do things - it
definitely works for me
but I just wonder if there is an easier way.

Thanks in advance,
Saira

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

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

RE: OT -- Boston Globe job listings

2003-08-14 Thread Goulet, Dick

Considering the defecits theur running up, that sure does not seem to bother them, or 
is that just the stupid part, as in we will not burden our childern part of last 
years State of the Union.

Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA

-Original Message-
Sent: Thursday, August 14, 2003 2:49 PM
To: Multiple recipients of list ORACLE-L



But lower paying jobs mean lower tax revenues.  Uh oh!

 -Original Message-
 
   Regrettably that average collection of greedy, stupid 
 executives are also the politicians we have to deal with as 
 well.  Just take a look at King George  his greedy deputy Chaney.
 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Stephen Lee
  INET: [EMAIL PROTECTED]

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

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

RE: OT -- Boston Globe job listings

At least some parts were.  We use OPM here and it was a conversion of
GEMMS done in India.

Allan
-Original Message-
Sent: Thursday, August 14, 2003 11:05 AM
To: Multiple recipients of list ORACLE-L


Wasn't Oracle 11i developed outside the USA?  The initial
implementations were a real mess.

Ken


- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, August 14, 2003 10:54 AM


 Of course the shipment of development work out of the US affects 
 DBAs! Support of production systems is only one part of the job, and 
 the outsourcing of application development to another physical 
 location then necessarily outsources the systems/database 
 administration with it.  How many huge application development 
 projects do you see in the US these
days?

 There is no cherry picking.  The IT industry in the US is moving
overseas,
 it is a trend, and it will move much faster than the manufacturing 
 sector did, for obvious reasons.  There is lighter equipment to move.

 It is difficult to tell that the water level in the lake is dropping 
 when you are treading water.  Until your feet touch bottom...



 on 8/14/03 8:24 AM, DENNIS WILLIAMS at [EMAIL PROTECTED] wrote:

  Ken - Since you've recently changed jobs, your upbeat attitude is 
  encouraging. I think you've made a good point that jobs aren't 
  always advertised. Another point is that when there are more jobs 
  than
available
  candidates, companies have to advertise strongly to fill their
positions.
  When there are more candidates than available jobs, companies often 
  find that people are seeking out the opening before they post it.
 
  Patrice - Look at what happened over the previous years. In 1999 
  corporations spent wildly on I.T. (naturally when the catastrophe 
  didn't occur because of the tireless efforts of I.T. people, the 
  senior
executives
  felt the money was wasted). Then when spending would have naturally 
  declined, the dot-com madness stuck and things went wild. I think we

  are just about to come out of the natural down cycle due to the 
  extravagant dot-com spending. But now I keep seeing articles about 
  how much
development
  work is being sent overseas. Has anyone seen that affect Oracle DBA 
  work yet?
 
  Dennis Williams
  DBA
  Lifetouch, Inc.
  [EMAIL PROTECTED] mailto:[EMAIL PROTECTED]
 
 
  -Original Message-
  Sent: Thursday, August 14, 2003 9:14 AM
  To: Multiple recipients of list ORACLE-L
 
 
  I don't think it has as much to do with no available positions 
  (although that is part of the answer) as most medium to large 
  companies don't use newspaper ads anymore.  They are using the 
  internet (especially for technical jobs) and are signed up with 
  Monster, BrassRing, etc. to do
their
  recruiting for them from their own company web sites.  I've seen 
  this definite shift here in the Minneapolis / St. Paul, MN area over

  the past couple of years.  Most of these companies also provide 
  e-mail service
that
  sends you an email when a job is posted that meets your specs.  So, 
  why waste your time on newspaper ads that only appear every Sunday?
 
  My $0.02 worth,
 
  Ken Janusz, CPIM
 
 
  - Original Message -
  To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
  Sent: Thursday, August 14, 2003 6:34 AM
 
 
  I've been keeping an eye on the Boston Globe's Oracle DBA job 
  postings,
  two
  years ago it wasn't uncommon to see eight or more per week, now I 
  tend
to
  see one or two, or none.
 
  For a while they also announced big IT job fairs, I don't know if 
  they
  still
  do that or how successful they now are.
 
  The market has really shrunk in two years!
 
  There can't be a huge glut of DBAs out there looking for work...  
  It
must
  be
  a reduction in demand because companies are not making big
infrastructure
  changes anymore.
 
  Patrice.
  --
  Please see the official ORACLE-L FAQ: http://www.orafaq.net
  --
  Author: Boivin, Patrice J
INET: [EMAIL PROTECTED]
 
  Fat City Network Services-- 858-538-5051 http://www.fatcity.com
  San Diego, California-- Mailing list and web hosting
services
  ---
  --
  To REMOVE yourself from this mailing list, send an E-Mail message
  to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
  the message BODY, include a line containing: UNSUB ORACLE-L
  (or the name of mailing list you want to be removed from).  You may
  also send the HELP command for other information (like
subscribing).
 
 

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

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

RE: OT -- Boston Globe job listings

2003-08-14 Thread Boivin, Patrice J

Didn't the UK outsource their IT function to EDS?

Patrice.

-Original Message-
Sent: Thursday, August 14, 2003 1:45 PM
To: Multiple recipients of list ORACLE-L


You should try the UK. 
The government seems to be actively encouraging this sort of thing. I think
they see short term gains to be made from cheap labour. That seems very
short-sighted to me but it's typ[ical of the set of losers we're saddled
with.



-Original Message-
Sent: 14 August 2003 16:34
To: Multiple recipients of list ORACLE-L


This makes me puke.


- Original Message - 
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, August 14, 2003 11:04 AM


 I know of one Fortune 50 company (US) that has a local division that has
 fired all of their programmers at least at that location.  All's done in
 India with e-mail, web, and teleconfrencing.
 
 Rich
 
 Rich Jesse   System/Database Administrator
 [EMAIL PROTECTED]  Quad/Tech Inc, Sussex, WI USA
 
 
  -Original Message-
  From: Mark Leith [mailto:[EMAIL PROTECTED]
  Sent: Thursday, August 14, 2003 10:54 AM
  To: Multiple recipients of list ORACLE-L
  Subject: RE: OT -- Boston Globe job listings
  
  
  Ken,
  
  With the amount of companies I talk to (in a sales-critter 
  role) you would
  actually be surprised at how many people ARE doing exactly this!
  
  Mark
  
  -Original Message-
  KENNETH JANUSZ
  Sent: 14 August 2003 16:45
  To: Multiple recipients of list ORACLE-L
  
  
  Dennis:
  
  With respect to sending production DBA positions to India, et 
  al.  I don't
  think companies are very included to do this because of 
  security concerns
  and the confidentiality of the information stored in the DB.  
   It's not a
  good idea to open your DB's to the entire world.
  
  Ken
  
  
  - Original Message -
  To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
  Sent: Thursday, August 14, 2003 10:24 AM
  
  
   Ken - Since you've recently changed jobs, your upbeat attitude is
   encouraging. I think you've made a good point that jobs 
  aren't always
   advertised. Another point is that when there are more jobs 
  than available
   candidates, companies have to advertise strongly to fill 
  their positions.
   When there are more candidates than available jobs, 
  companies often find
   that people are seeking out the opening before they post it.
  
   Patrice - Look at what happened over the previous years. In 1999
   corporations spent wildly on I.T. (naturally when the 
  catastrophe didn't
   occur because of the tireless efforts of I.T. people, the senior
  executives
   felt the money was wasted). Then when spending would have naturally
   declined, the dot-com madness stuck and things went wild. I 
  think we are
   just about to come out of the natural down cycle due to the 
  extravagant
   dot-com spending. But now I keep seeing articles about how much
  development
   work is being sent overseas. Has anyone seen that affect 
  Oracle DBA work
   yet?
  
   Dennis Williams
   DBA
   Lifetouch, Inc.
   [EMAIL PROTECTED] mailto:[EMAIL PROTECTED]
  
  
   -Original Message-
   Sent: Thursday, August 14, 2003 9:14 AM
   To: Multiple recipients of list ORACLE-L
  
  
   I don't think it has as much to do with no available 
  positions (although
   that is part of the answer) as most medium to large 
  companies don't use
   newspaper ads anymore.  They are using the internet (especially for
   technical jobs) and are signed up with Monster, BrassRing, 
  etc. to do
  their
   recruiting for them from their own company web sites.  I've 
  seen this
   definite shift here in the Minneapolis / St. Paul, MN area 
  over the past
   couple of years.  Most of these companies also provide 
  e-mail service that
   sends you an email when a job is posted that meets your 
  specs.  So, why
   waste your time on newspaper ads that only appear every Sunday?
  
   My $0.02 worth,
  
   Ken Janusz, CPIM
  
  
   - Original Message -
   To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
   Sent: Thursday, August 14, 2003 6:34 AM
  
  
I've been keeping an eye on the Boston Globe's Oracle DBA 
  job postings,
   two
years ago it wasn't uncommon to see eight or more per 
  week, now I tend
  to
see one or two, or none.
   
For a while they also announced big IT job fairs, I don't 
  know if they
   still
do that or how successful they now are.
   
The market has really shrunk in two years!
   
There can't be a huge glut of DBAs out there looking for 
  work...  It
  must
   be
a reduction in demand because companies are not making big
  infrastructure
changes anymore.
   
Patrice.
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.net
 -- 
 Author: Jesse, Rich
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- 858-538-5051 http://www.fatcity.com
 San Diego, California-- Mailing list

RE: Off Topic Question - Update.inf file

2003-08-14 Thread Orr, Steve

Hey Shrek, that could go both ways... 

Regarding...
 ...linux users that are just windows users in disguise.

And...
 someone had installed linux... and he couldn't tell the difference.

It depends on your perspective. The above could also be interpreted to
mean, There are a lot windoze user that are closet Linux users but just
don't know it yet. This is just my misplaced optimism that somehow the
MS juggernaut ownership of the desktop could somehow be challenged. 

I use Gnome and KDE but the shell gives me complete power to do anything
I want just like being root on any *nix. You can't say that about the
DOS remnant of a command shell with windoze.

Regarding Microsoft's macro-hard hegemony, I'm still looking for justice
in an unjust world. :-(


Steve Orr



-Original Message-
Sent: Wednesday, August 13, 2003 11:35 AM
To: Multiple recipients of list ORACLE-L

Joe Testa  scribbled on the wall in glitter crayon:

 Good point, i'm such a bigot as i used linux back when it was minix 
 and have been doing unix admin work for 20 years now ;)
 
 joe

well, unlike you there are now starting to be a number of linux users
that are just windows users in disguise.;-)  case in point, duheveloper
comes to me with his laptop and tells me his windows oracle doesn't
work anymore. someone had installed linux on the laptop with dual boot
defaulted to linux running gnome.  and he couldn't tell the difference.
boot into windows and every thing works fine.

--
Bill Shrek Thater ORACLE DBA  BAARF Party member #25
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Orr, Steve
  INET: [EMAIL PROTECTED]

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

RE: How to tell Oracle the directories of script files

2003-08-14 Thread Martin, Alan (Contractor) (DLIS)

Title: RE: How to tell Oracle the directories of script files





Use SQLPATH.


Alan Martin
Defense Logistics Info Service
Battle Creek, MI


-Original Message-
From: Reuben D. Budiardja [mailto:[EMAIL PROTECTED]] 
Sent: Thursday, August 14, 2003 2:09 PM
To: Multiple recipients of list ORACLE-L
Subject: How to tell Oracle the directories of script files




Hello,
Suppose I have some SQL scripts in my /home/user directories, /usr/local/bin 
directories, etc.
If I start 'sqlplus' from console in /home/user directories, I can 
load/execute the script by doing:
SQL @scriptname


But what if I don't start sqlplus from that directories? How do I tell Oracle 
to find the scripts in /home/user, then if it's not there in /usr/local/bin, 
for example? So that I can be anywhere in the filesystem when starting 
sqlplus and can execute my SQL script.


Just like the $PATH environment variables in *nix system that tell the shell 
where to find executables, is there a similar thing for Oracle?


Thanks for any help.


RDB


-- 
Reuben D. Budiardja
Department of Physics and Astronomy
The University of Tennessee, Knoxville, TN
-
/\ ASCII Ribbon Campaign against HTML 
\ / email and proprietary format 
X attachments.
/ \
-
Have you been used by Microsoft today? 
Choose your life. Choose freedom. 
Choose LINUX.
-


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


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

2003-08-14 Thread Seema Singh

Hi,
Does anyone know oracle client(8.1.6) available on linux(Red hat EE) ?
If not can I run l higher client with old version of database(oracle 8.1.6)?
thx
-Seema
_
The new MSN 8: advanced junk mail protection and 2 months FREE*  
http://join.msn.com/?page=features/junkmail

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

RE: RE: OT -- Boston Globe job listings

Ken - Since you've recently changed jobs, your
upbeat attitude is
encouraging. I think you've made a good point that
jobs aren't always
advertised. Another point is that when there are
more jobs than available
candidates, companies have to advertise strongly to
fill their positions.
When there are more candidates than available jobs,
companies often find
that people are seeking out the opening before they
post it.

Patrice - Look at what happened over the previous
years. In 1999
corporations spent wildly on I.T. (naturally when
the catastrophe didn't
occur because of the tireless efforts of I.T.
people, the senior executives
felt the money was wasted). Then when spending
would have naturally
declined, the dot-com madness stuck and things went
wild. I think we are
just about to come out of the natural down cycle
due to the extravagant
dot-com spending. But now I keep seeing articles
about how much development
work is being sent overseas. Has anyone seen that
affect Oracle DBA work
yet? 

Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
mailto:[EMAIL PROTECTED] 

Dennis,

   Concerning your last question, a young indian DBA friend of mine in Bangalore was 
complaining about the night shifts and all the donkey work Indians have to perform to 
keep a 24x7 watch on US databases ... I would personally tend to use timezones to get 
senior DBAs from all around the world ready to help at normal business hours but I 
guess that this will have to wait until costs in India raise to sufficient levels - 
which in the end will happen (take a look at Hong Kong and Singapore).
   I indeed believe that the market for DBAs is going to shrink somewhat. As someone 
pointed out, big, pharaonic projects are much less common today than they were a few 
years back. A 'mature' database running stable applications and that you don't want to 
upgrade hardly requires on a daily or weekly basis anything to do that you cannot put 
in a crontab file. Moreover, the official Oracle gospel is of course that new versions 
require less and less administration - a claim which provokes more sarcastic comments 
on this list than in the upper management levels.
However, the amount of data which people are willing to store seems to be joyfully 
outpacing Moore's law, and I don't see the trend losing momentum anytime soon. Expect 
more work related to architecture, replication (the days of exp backups have long been 
over) and of course performance tuning. It's probably the junior part of the market 
which is going to bear the brunt of the slow-down. Till the pendulum swings back and 
makes outsourcing out of fashion, by which time I hope that India and China will 
locally provide enough work for their IT people, which is more than likely.

My 0.02 EUR.

Regards,

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

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

RE: Off Topic Question - Update.inf file

Actually there is a Linux clone of MechWarriors

Allan

-Original Message-
Sent: Wednesday, August 13, 2003 12:54 PM
To: Multiple recipients of list ORACLE-L



How could they not tell the difference?  Windows runs MechWarriors;
Linux doesn't.  What more is there to know?

 -Original Message-
 someone had installed linux on the laptop with dual boot
 defaulted to linux
 running gnome.  and he couldn't tell the difference.  boot 
 into windows and
 every thing works fine.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Stephen Lee
  INET: [EMAIL PROTECTED]

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


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

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

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

is lazydba list server down

2003-08-14 Thread Jeffrey Beckstrom




I have not received mail from it in several days...is it down?

Jeffrey BeckstromDatabase AdministratorGreater Cleveland Regional 
Transit Authority1240 W. 6th StreetCleveland, Ohio 44113(216) 
781-4204

Re: OT -- Boston Globe job listings

2003-08-14 Thread Joe Testa

Steve taking that a bit further, you're important enough to be doing 
wireless email in caribbean, remind me to NOT be that way IF i ever grow 
up :)

joe

Orr, Steve wrote:

I'm ideologically opposed to almost anything that obstructs free trade,
even if it directly affects my personal economy, income and career. It's
a global economy and other industries (e.g. auto mfgrs., textiles,
agriculture, etc.) have had to adapt or cope so why shouldn't we? What
makes us think we're so special or should be exempt? If someone can do
your job better and cheaper than you is it their fault? The best
protection is not in trade legislation but in being competitive and
providing a good service with value. If your job merely involves
interfacing with computers via an online session then it really
doesn't matter where you are. That can be both good and bad depending on
your circumstance.
Steve Orr, disciple of Adam Smith...

Virtually present in Bozeman, MT but actually operating from my laptop
via wireless connection while sunning at the beach on a heretofore
undisclosed Carribean Isle.


-Original Message-
Sent: Thursday, August 14, 2003 10:34 AM
To: Multiple recipients of list ORACLE-L
This makes me puke.

- Original Message - 
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, August 14, 2003 11:04 AM

 

I know of one Fortune 50 company (US) that has a local division that 
has fired all of their programmers at least at that location.  All's 
done in India with e-mail, web, and teleconfrencing.

Rich

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

-Original Message-
From: Mark Leith [mailto:[EMAIL PROTECTED]
Sent: Thursday, August 14, 2003 10:54 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: OT -- Boston Globe job listings
Ken,

With the amount of companies I talk to (in a sales-critter
role) you would
actually be surprised at how many people ARE doing exactly this!
Mark

-Original Message-
KENNETH JANUSZ
Sent: 14 August 2003 16:45
To: Multiple recipients of list ORACLE-L
Dennis:

With respect to sending production DBA positions to India, et
al.  I don't
think companies are very included to do this because of 
security concerns
and the confidentiality of the information stored in the DB.  
It's not a
good idea to open your DB's to the entire world.

Ken

- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, August 14, 2003 10:24 AM
 

Ken - Since you've recently changed jobs, your upbeat attitude is 
encouraging. I think you've made a good point that jobs
   

aren't always
 

advertised. Another point is that when there are more jobs
   

than available
 

candidates, companies have to advertise strongly to fill
   

their positions.
 

When there are more candidates than available jobs,
   

companies often find
 

that people are seeking out the opening before they post it.

Patrice - Look at what happened over the previous years. In 1999 
corporations spent wildly on I.T. (naturally when the
   

catastrophe didn't
 

occur because of the tireless efforts of I.T. people, the senior
   

executives
 

felt the money was wasted). Then when spending would have 
naturally declined, the dot-com madness stuck and things went 
wild. I
   

think we are
 

just about to come out of the natural down cycle due to the
   

extravagant
 

dot-com spending. But now I keep seeing articles about how much
   

development
 

work is being sent overseas. Has anyone seen that affect
   

Oracle DBA work
 

yet?

Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED] mailto:[EMAIL PROTECTED]
-Original Message-
Sent: Thursday, August 14, 2003 9:14 AM
To: Multiple recipients of list ORACLE-L
I don't think it has as much to do with no available
   

positions (although
 

that is part of the answer) as most medium to large
   

companies don't use
 

newspaper ads anymore.  They are using the internet (especially 
for technical jobs) and are signed up with Monster, BrassRing,
   

etc. to do
their
 

recruiting for them from their own company web sites.  I've
   

seen this
 

definite shift here in the Minneapolis / St. Paul, MN area
   

over the past
 

couple of years.  Most of these companies also provide
   

e-mail service that
 

sends you an email when a job is posted that meets your
   

specs.  So, why
 

waste your time on newspaper ads that only appear every Sunday?

My $0.02 worth,

Ken Janusz, CPIM

- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, August 14, 2003 6:34 AM
   

I've been keeping an eye on the Boston Globe's Oracle DBA
 

job postings,
 

two
   

years ago it wasn't uncommon to see eight

RE: OT -- Boston Globe job listings

2003-08-14 Thread Chelur, Jayadas {PBSG}

Scott Adams has said it all ...

http://www.dilbert.com/comics/dilbert/archive/dilbert-20030803.html


-Original Message-
Sent: Thursday, August 14, 2003 2:20 PM
To: Multiple recipients of list ORACLE-L


I'm ideologically opposed to almost anything that obstructs free trade,
even if it directly affects my personal economy, income and career. It's
a global economy and other industries (e.g. auto mfgrs., textiles,
agriculture, etc.) have had to adapt or cope so why shouldn't we? What
makes us think we're so special or should be exempt? If someone can do
your job better and cheaper than you is it their fault? The best
protection is not in trade legislation but in being competitive and
providing a good service with value. If your job merely involves
interfacing with computers via an online session then it really
doesn't matter where you are. That can be both good and bad depending on
your circumstance.


Steve Orr, disciple of Adam Smith...

Virtually present in Bozeman, MT but actually operating from my laptop
via wireless connection while sunning at the beach on a heretofore
undisclosed Carribean Isle.



-Original Message-
Sent: Thursday, August 14, 2003 10:34 AM
To: Multiple recipients of list ORACLE-L


This makes me puke.


- Original Message - 
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, August 14, 2003 11:04 AM


 I know of one Fortune 50 company (US) that has a local division that 
 has fired all of their programmers at least at that location.  All's 
 done in India with e-mail, web, and teleconfrencing.
 
 Rich
 
 Rich Jesse   System/Database Administrator
 [EMAIL PROTECTED]  Quad/Tech Inc, Sussex, WI USA
 
 
  -Original Message-
  From: Mark Leith [mailto:[EMAIL PROTECTED]
  Sent: Thursday, August 14, 2003 10:54 AM
  To: Multiple recipients of list ORACLE-L
  Subject: RE: OT -- Boston Globe job listings
  
  
  Ken,
  
  With the amount of companies I talk to (in a sales-critter
  role) you would
  actually be surprised at how many people ARE doing exactly this!
  
  Mark
  
  -Original Message-
  KENNETH JANUSZ
  Sent: 14 August 2003 16:45
  To: Multiple recipients of list ORACLE-L
  
  
  Dennis:
  
  With respect to sending production DBA positions to India, et
  al.  I don't
  think companies are very included to do this because of 
  security concerns
  and the confidentiality of the information stored in the DB.  
   It's not a
  good idea to open your DB's to the entire world.
  
  Ken
  
  
  - Original Message -
  To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
  Sent: Thursday, August 14, 2003 10:24 AM
  
  
   Ken - Since you've recently changed jobs, your upbeat attitude is 
   encouraging. I think you've made a good point that jobs
  aren't always
   advertised. Another point is that when there are more jobs
  than available
   candidates, companies have to advertise strongly to fill
  their positions.
   When there are more candidates than available jobs,
  companies often find
   that people are seeking out the opening before they post it.
  
   Patrice - Look at what happened over the previous years. In 1999 
   corporations spent wildly on I.T. (naturally when the
  catastrophe didn't
   occur because of the tireless efforts of I.T. people, the senior
  executives
   felt the money was wasted). Then when spending would have 
   naturally declined, the dot-com madness stuck and things went 
   wild. I
  think we are
   just about to come out of the natural down cycle due to the
  extravagant
   dot-com spending. But now I keep seeing articles about how much
  development
   work is being sent overseas. Has anyone seen that affect
  Oracle DBA work
   yet?
  
   Dennis Williams
   DBA
   Lifetouch, Inc.
   [EMAIL PROTECTED] mailto:[EMAIL PROTECTED]
  
  
   -Original Message-
   Sent: Thursday, August 14, 2003 9:14 AM
   To: Multiple recipients of list ORACLE-L
  
  
   I don't think it has as much to do with no available
  positions (although
   that is part of the answer) as most medium to large
  companies don't use
   newspaper ads anymore.  They are using the internet (especially 
   for technical jobs) and are signed up with Monster, BrassRing,
  etc. to do
  their
   recruiting for them from their own company web sites.  I've
  seen this
   definite shift here in the Minneapolis / St. Paul, MN area
  over the past
   couple of years.  Most of these companies also provide
  e-mail service that
   sends you an email when a job is posted that meets your
  specs.  So, why
   waste your time on newspaper ads that only appear every Sunday?
  
   My $0.02 worth,
  
   Ken Janusz, CPIM
  
  
   - Original Message -
   To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
   Sent: Thursday, August 14, 2003 6:34 AM
  
  
I've been keeping an eye on the Boston Globe's Oracle DBA
  job postings,
   two
years ago it wasn't uncommon

RE: OT -- Boston Globe job listings

2003-08-14 Thread Goulet, Dick

Allan,

Regrettably that average collection of greedy, stupid executives are also 
the politicians we have to deal with as well.  Just take a look at King George  his 
greedy deputy Chaney.

Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA

-Original Message-
Sent: Thursday, August 14, 2003 1:49 PM
To: Multiple recipients of list ORACLE-L


One of the truly dog eat dog aspects of this is that the Indians, in
some areas, are unable to compete with the Chinese and so they
themselves are being outsourced.  

I don't think any amount of complaining from DBA ranks will make the
slightest bit of difference to the average collection of greedy, stupid
executives that are pervasive in industry.  If business people ever had
ethics that extended beyond profit margins they certainly show no
evidence of that today.  And Sturgeon's law shows that you are likely to
be dealing with the least competent greedy people.

I'm afflicted by a sensitivity to historical irony.  In the 60's and
70's the literature complained that corporate executives had
insufficient incentives to perform well because their compensation did
not vary with the corporation's stock performance.  In addition, there
was general consensus that accounting staff were too conservative to
meet the creative financing requirements of modern corporations. We
certainly changed all that.  Declining emphasis on character aligned
with stock based compensation plans and creative MBAs in CFO slots
certainly did produce some interesting corporate performance.  I live
and work in Houston and the examples I have in mind are Enron, Dynergy,
Reliant..

I suspect that the only thing that will moderate this is some expensive
offshore project failures that cause executive blood to be shed.  The
remarks in another post about the cultural problems inherent in turning
specs into good applications without end-user input and testing are
right on target.  Unfortunately, it will be years before academia
catches on.

Allan

-Original Message-
Sent: Thursday, August 14, 2003 11:09 AM
To: Multiple recipients of list ORACLE-L


When I worked for Oracle's custom development group I worked on a large
conversion project that employed about 350 consultants (150 from
Oracle). They had a number of foreign consultants on the project.  About
1 in 10 had technical skills that were above mediocre, but they worked
cheap.  The code they produced was a mess and we at Oracle wondered how
much time / money would have to be spent after the fact to clean up what
the company got on the cheap.  You get what you pay for.  I have dealt
with offshore technical Oracle staff and have found them to be cheap in
cost but very poor overall in the quality of what they delivered.
Companies will wake up to this sooner or later.

Ken


- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, August 14, 2003 10:59 AM


 inline

  But now I keep seeing
  articles about how much development work is being sent overseas. Has

  anyone seen that affect Oracle DBA work yet?

 Huge discussions going on here at work about that very subject.  So 
 far,
no one has come up with a reasonable argument for keeping the jobs
in-house. At the gut level it 'feels' like we should keep the jobs
in-house and that would be an overall benefit to the economy, too.
However, the financial argument of should I pay 75K - 120K a year for US
based DBAs or pay 45K - 80K for offshore talent is hard to beat.  The
money ranges I gave are contract employee/job shop type of quotes, IOW,
a 75K US position would be for a junior DBA that is actually getting
35K-40K and so on up the skill range.

 v/r

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


 
  Dennis Williams
  DBA
  Lifetouch, Inc.
  [EMAIL PROTECTED] mailto:[EMAIL PROTECTED]
 
 
  -Original Message-
  Sent: Thursday, August 14, 2003 9:14 AM
  To: Multiple recipients of list ORACLE-L
 
 
  I don't think it has as much to do with no available positions 
  (although that is part of the answer) as most medium to large 
  companies don't use newspaper ads anymore. They are using the 
  internet (especially for technical jobs) and are signed up with 
  Monster, BrassRing, etc. to do their recruiting for them from their 
  own company web sites.  I've seen this definite shift here in the 
  Minneapolis / St. Paul, MN area over the past couple of years.  Most

  of these companies also provide e-mail service that sends you an 
  email when a job is posted that meets your specs.  So, why waste
  your time on newspaper ads that only appear every Sunday?
 
  My $0.02 worth,
 
  Ken Janusz, CPIM
 
 
  - Original Message -
  To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
  Sent: Thursday, August 14, 2003 6:34 AM
 
 
   I've been keeping an eye on the Boston Globe's Oracle DBA job 
   postings,
  two
   years ago it wasn't uncommon to see eight or

Re: OT -- Boston Globe job listings

2003-08-14 Thread Joe Testa

Steve now thats one of the funnier things i've read for a while, that 
will probably work.

joe

Orr, Steve wrote:

Usually these kind of customers don't actually meet the live DBA's in person so there's gotta be a hack work-around solution to this. Here's what I propose: Setup a domain name with and ISP that has an overseas address. Then setup an Apache virtual host that redirects to your own operations. Adopt pseudonymns with ethnic sounding names reflecting the ISP overseas address. A good place to setup shop would be someplace like Montana. Anyone want to join me in this venture?

Steve, er uh, Gerhardt Mohammad Lee Kim,



-Original Message-
Sent: Thursday, August 14, 2003 10:14 AM
To: Multiple recipients of list ORACLE-L
Tim,

	I regret to have to agree with you.  More of the IT jobs are  will be moving to overseas locations until those locations prove that they cannot support US operations for one reason or other.  I believe it is just an effort by unintelligent CEO, CIO, and CFO's to save a buck today.  What we'll end up with is a number of large companies that are trying to sell products to a lot of unemployed middle class people who won't open their wallets.  What's the old saying, penny wise pound foolish?  As in save a penny here drop a dollar there.

Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA
-Original Message-
Sent: Thursday, August 14, 2003 11:54 AM
To: Multiple recipients of list ORACLE-L
Of course the shipment of development work out of the US affects DBAs! Support of production systems is only one part of the job, and the outsourcing of application development to another physical location then necessarily outsources the systems/database administration with it.  How many huge application development projects do you see in the US these days?

There is no cherry picking.  The IT industry in the US is moving overseas, it is a trend, and it will move much faster than the manufacturing sector did, for obvious reasons.  There is lighter equipment to move.

It is difficult to tell that the water level in the lake is dropping when you are treading water.  Until your feet touch bottom...



on 8/14/03 8:24 AM, DENNIS WILLIAMS at [EMAIL PROTECTED] wrote:

 

Ken - Since you've recently changed jobs, your upbeat attitude is
encouraging. I think you've made a good point that jobs aren't always 
advertised. Another point is that when there are more jobs than 
available candidates, companies have to advertise strongly to fill 
their positions. When there are more candidates than available jobs, 
companies often find that people are seeking out the opening before 
they post it.

Patrice - Look at what happened over the previous years. In 1999
corporations spent wildly on I.T. (naturally when the catastrophe 
didn't occur because of the tireless efforts of I.T. people, the 
senior executives felt the money was wasted). Then when spending would 
have naturally declined, the dot-com madness stuck and things went 
wild. I think we are just about to come out of the natural down cycle 
due to the extravagant dot-com spending. But now I keep seeing 
articles about how much development work is being sent overseas. Has 
anyone seen that affect Oracle DBA work yet?

Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED] mailto:[EMAIL PROTECTED]
-Original Message-
Sent: Thursday, August 14, 2003 9:14 AM
To: Multiple recipients of list ORACLE-L
I don't think it has as much to do with no available positions
(although that is part of the answer) as most medium to large 
companies don't use newspaper ads anymore.  They are using the 
internet (especially for technical jobs) and are signed up with 
Monster, BrassRing, etc. to do their recruiting for them from their 
own company web sites.  I've seen this definite shift here in the 
Minneapolis / St. Paul, MN area over the past couple of years.  Most 
of these companies also provide e-mail service that sends you an email 
when a job is posted that meets your specs.  So, why waste your time 
on newspaper ads that only appear every Sunday?

My $0.02 worth,

Ken Janusz, CPIM

- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, August 14, 2003 6:34 AM
   

I've been keeping an eye on the Boston Globe's Oracle DBA job
postings,
 

two
   

years ago it wasn't uncommon to see eight or more per week, now I
tend to see one or two, or none.
For a while they also announced big IT job fairs, I don't know if
they
 

still
   

do that or how successful they now are.

The market has really shrunk in two years!

There can't be a huge glut of DBAs out there looking for work...  It
must
 

be
   

a reduction in demand because companies are not making big
infrastructure changes anymore.
Patrice.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Boivin, Patrice J
 INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego,

RE: Off Topic Question - Update.inf file

2003-08-14 Thread Mark Leith

Check this out:

http://www.annoyances.org/exec/forum/winxp/t1032598735

HTH

Mark
===
 Mark Leith | T: +44 (0)1905 330 281
 Sales  Marketing  | F: +44 (0)870 127 5283
 Cool Tools UK Ltd  | E: [EMAIL PROTECTED]
===
   http://www.cool-tools.co.uk
   Maximising throughput  performance


-Original Message-
KENNETH JANUSZ
Sent: 13 August 2003 16:49
To: Multiple recipients of list ORACLE-L


Yesterday I got hit with the Blaster Bug.  To make a long story short I
cannot apply the MS fix to my XP Prof. since I don't have the Update.inf
file.  Would like some feedback on where I can locate it and what directory
it belongs in.  I'm on XP Prof. SP1.  I tried apply SP1a and it errored out
saying it needed this file also.

TIA,

Ken Janusz, CPIM
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.504 / Virus Database: 302 - Release Date: 24/07/2003

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

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

you can take the user off windows, but... (was RE: Off Topic Question - Update.inf file)

2003-08-14 Thread Pardee, Roy E

This is an excellent point.  Anybody remember when there was (is?) a stigma associated 
with being an AOL user, as opposed to using a real ISP?  AOL made things easy enough 
that the less adept could 'get on the internet', where they were generally reviled by 
the old-hands, who were more of a select, 'nerd' elite.

My guess is it'll be the same thing as the less technical people start migrating to 
linux.

Cheers,

-Roy

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

-Original Message-
Sent: Wednesday, August 13, 2003 10:35 AM
To: Multiple recipients of list ORACLE-L


Joe Testa  scribbled on the wall in glitter crayon:

 Good point, i'm such a bigot as i used linux back when it was minix
 and have been doing unix admin work for 20 years now ;)
 
 joe

well, unlike you there are now starting to be a number of linux users that
are just windows users in disguise.;-)  case in point, duheveloper comes to
me with his laptop and tells me his windows oracle doesn't work anymore.
someone had installed linux on the laptop with dual boot defaulted to linux
running gnome.  and he couldn't tell the difference.  boot into windows and
every thing works fine.

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

The whole of science is nothing more than a refinement of everyday thinking.
- Albert Einstein

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

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

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

How to tell Oracle the directories of script files

2003-08-14 Thread Reuben D. Budiardja


Hello,
Suppose I have some SQL scripts in my /home/user directories, /usr/local/bin 
directories, etc.
If I start 'sqlplus' from console in /home/user directories, I can 
load/execute the script by doing:
SQL @scriptname

But what if I don't start sqlplus from that directories? How do I tell Oracle 
to find the scripts in /home/user, then if it's not there in /usr/local/bin,  
for example? So that I can be anywhere in the filesystem when starting 
sqlplus and can execute my SQL script.

Just like the $PATH environment variables in *nix system that tell the shell 
where to find executables, is there a similar thing for Oracle?

Thanks for any help.

RDB

-- 
Reuben D. Budiardja
Department of Physics and Astronomy
The University of Tennessee, Knoxville, TN
-
/\  ASCII Ribbon Campaign against HTML
\ /  email and proprietary format  
 X   attachments.
/ \
-
Have you been used by Microsoft today? 
Choose your life. Choose freedom. 
Choose LINUX.
-

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

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

2003-08-14 Thread Jesse, Rich

Doh!  I should've gone to bestbookbuys, like someone had posted last week or
so:

http://www.bestwebbuys.com/books/compare/isbn/0130125156/isrc/b-home-search

Rich

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


 -Original Message-
 From: Nelson, Allan [mailto:[EMAIL PROTECTED]
 Sent: Thursday, August 14, 2003 1:49 PM
 To: Multiple recipients of list ORACLE-L
 Subject: RE: HP-UX
 
 
 It's out of stock,
 
 Allan
 
 -Original Message-
 Sent: Thursday, August 14, 2003 12:14 PM
 To: Multiple recipients of list ORACLE-L
 
 
 How's about a link instead?
 
 http://www.bookpool.com/.x/6oqxxyd9k4/sm/0130125156
 
 
 Rich
 
 Rich Jesse   System/Database Administrator
 [EMAIL PROTECTED]  Quad/Tech Inc, Sussex, WI USA
 
 
  -Original Message-
  From: Seema Singh [mailto:[EMAIL PROTECTED]
  Sent: Thursday, August 14, 2003 11:45 AM
  To: Multiple recipients of list ORACLE-L
  Subject: HP-UX
  
  
  Hi,
  Can someone send me  system administration document on OS
  HP-UX 11.0 if have 
  ?
  thx
  -Seema
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jesse, Rich
  INET: [EMAIL PROTECTED]

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

Re: OT -- Boston Globe job listings

2003-08-14 Thread KENNETH JANUSZ

I don't think it has as much to do with no available positions (although
that is part of the answer) as most medium to large companies don't use
newspaper ads anymore.  They are using the internet (especially for
technical jobs) and are signed up with Monster, BrassRing, etc. to do their
recruiting for them from their own company web sites.  I've seen this
definite shift here in the Minneapolis / St. Paul, MN area over the past
couple of years.  Most of these companies also provide e-mail service that
sends you an email when a job is posted that meets your specs.  So, why
waste your time on newspaper ads that only appear every Sunday?

My $0.02 worth,

Ken Janusz, CPIM


- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, August 14, 2003 6:34 AM


 I've been keeping an eye on the Boston Globe's Oracle DBA job postings,
two
 years ago it wasn't uncommon to see eight or more per week, now I tend to
 see one or two, or none.

 For a while they also announced big IT job fairs, I don't know if they
still
 do that or how successful they now are.

 The market has really shrunk in two years!

 There can't be a huge glut of DBAs out there looking for work...  It must
be
 a reduction in demand because companies are not making big infrastructure
 changes anymore.

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

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



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

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

RE: OT -- Boston Globe job listings

Let me guess: MCI-Worldcom, Global Crossing or Enron?

--
Mladen Gogala
Oracle DBA 



-Original Message-
Jesse, Rich
Sent: Thursday, August 14, 2003 12:05 PM
To: Multiple recipients of list ORACLE-L


I know of one Fortune 50 company (US) that has a local division that has
fired all of their programmers at least at that location.  All's done in
India with e-mail, web, and teleconfrencing.

Rich

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


 -Original Message-
 From: Mark Leith [mailto:[EMAIL PROTECTED]
 Sent: Thursday, August 14, 2003 10:54 AM
 To: Multiple recipients of list ORACLE-L
 Subject: RE: OT -- Boston Globe job listings
 
 
 Ken,
 
 With the amount of companies I talk to (in a sales-critter
 role) you would
 actually be surprised at how many people ARE doing exactly this!
 
 Mark
 
 -Original Message-
 KENNETH JANUSZ
 Sent: 14 August 2003 16:45
 To: Multiple recipients of list ORACLE-L
 
 
 Dennis:
 
 With respect to sending production DBA positions to India, et
 al.  I don't
 think companies are very included to do this because of 
 security concerns
 and the confidentiality of the information stored in the DB.  
  It's not a
 good idea to open your DB's to the entire world.
 
 Ken
 
 
 - Original Message -
 To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
 Sent: Thursday, August 14, 2003 10:24 AM
 
 
  Ken - Since you've recently changed jobs, your upbeat attitude is 
  encouraging. I think you've made a good point that jobs
 aren't always
  advertised. Another point is that when there are more jobs
 than available
  candidates, companies have to advertise strongly to fill
 their positions.
  When there are more candidates than available jobs,
 companies often find
  that people are seeking out the opening before they post it.
 
  Patrice - Look at what happened over the previous years. In 1999 
  corporations spent wildly on I.T. (naturally when the
 catastrophe didn't
  occur because of the tireless efforts of I.T. people, the senior
 executives
  felt the money was wasted). Then when spending would have naturally 
  declined, the dot-com madness stuck and things went wild. I
 think we are
  just about to come out of the natural down cycle due to the
 extravagant
  dot-com spending. But now I keep seeing articles about how much
 development
  work is being sent overseas. Has anyone seen that affect
 Oracle DBA work
  yet?
 
  Dennis Williams
  DBA
  Lifetouch, Inc.
  [EMAIL PROTECTED] mailto:[EMAIL PROTECTED]
 
 
  -Original Message-
  Sent: Thursday, August 14, 2003 9:14 AM
  To: Multiple recipients of list ORACLE-L
 
 
  I don't think it has as much to do with no available
 positions (although
  that is part of the answer) as most medium to large
 companies don't use
  newspaper ads anymore.  They are using the internet (especially for 
  technical jobs) and are signed up with Monster, BrassRing,
 etc. to do
 their
  recruiting for them from their own company web sites.  I've
 seen this
  definite shift here in the Minneapolis / St. Paul, MN area
 over the past
  couple of years.  Most of these companies also provide
 e-mail service that
  sends you an email when a job is posted that meets your
 specs.  So, why
  waste your time on newspaper ads that only appear every Sunday?
 
  My $0.02 worth,
 
  Ken Janusz, CPIM
 
 
  - Original Message -
  To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
  Sent: Thursday, August 14, 2003 6:34 AM
 
 
   I've been keeping an eye on the Boston Globe's Oracle DBA
 job postings,
  two
   years ago it wasn't uncommon to see eight or more per
 week, now I tend
 to
   see one or two, or none.
  
   For a while they also announced big IT job fairs, I don't
 know if they
  still
   do that or how successful they now are.
  
   The market has really shrunk in two years!
  
   There can't be a huge glut of DBAs out there looking for
 work...  It
 must
  be
   a reduction in demand because companies are not making big
 infrastructure
   changes anymore.
  
   Patrice.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jesse, Rich
  INET: [EMAIL PROTECTED]

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



Note:
This message is for the named person's use only.  It may 
contain confidential, proprietary or legally privileged 
information.  No

RE: Question on views

2003-08-14 Thread Pardee, Roy E

I think that's a fair characterization.  What makes them cool (and
dangerous) is that you can set Oracle up to automatically treat queries
like SELECT * from MyTable as if they said SELECT * FROM
MyMaterializedView instead.  That's the query rewrite feature.  If
the MV is based on a query that takes a long time to run (and that's
generally where you're using them) then you can get blindingly fast perf
where you'd otherwise get bogged down.  But at the cost of storage space
and (depending on how you have them set up) some currency.

And, there are a couple of different types of MVs--some of them are
'fast refreshable' (meaning a refresh doesn't require completely
ditching the existing data  recomputing all of it from scratch) and
some aren't.  For a fast refreshable MV, you can even specify that it
should be updated transactionally along with its dependant tables.

All this  more are in the OLAP docs:

http://download-west.oracle.com/docs/cd/A91202_01/901_doc/server.901/a90
237/mv.htm#33614

Cheers,

-Roy

P.S. I think mssql's analogue to this is the 'indexed view', but am not
sure.

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

-Original Message-
[mailto:[EMAIL PROTECTED]
Sent: Wednesday, August 13, 2003 7:34 AM
To: Multiple recipients of list ORACLE-L


Thank you very much.  Come to find our the MV the ICDB folks were using
did not have 'stale' data in it, but it flat out had the wrong data in
it because they used the wrong selection parameters.

So essentially a MV is a SQL select stored to a table, kinda of like:

SELECT * FROM MyTable INTO MyOtherTable

v/r

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



 -Original Message-
 From: Pardee, Roy E [mailto:[EMAIL PROTECTED] 
 Sent: Tuesday, August 12, 2003 6:34 PM
 To: Multiple recipients of list ORACLE-L
 Subject: RE: Question on views
 
 
 From the concepts manual:
 
 quote
 Materialized Views
 
 A materialized view provides indirect access to table data by 
 storing the results of a query in a separate schema object. 
 Unlike an ordinary view, which does not take up any storage 
 space or contain any data, a materialized view contains the 
 rows resulting from a query against one or more base tables 
 or views. A materialized view can be stored in the same 
 database as its base table(s) or in a different database.
 
 Materialized views stored in the same database as their base 
 tables can improve query performance through query rewrites. 
 Query rewrites are particularly useful in a data warehouse 
 environment. /quote
 
 Roy Pardee
 Programmer/Analyst/DBA
 SWFPAC Lockheed Martin IT
 Extension 8487
 
 -Original Message- [mailto:[EMAIL PROTECTED]
 Sent: Tuesday, August 12, 2003 8:25 AM
 To: Multiple recipients of list ORACLE-L
 
 
 It is confirmed it is a materialized view.  How can they go 
 stale?  What is the difference in them and a traditional view?
 
 v/r
 
 Stephen S. Wolfe, GS-11, DAFC
 Data Services Manager
 [EMAIL PROTECTED]
 (813) 827-9974  DSN 651-9974
 
 
 
  -Original Message-
  From: Hately, Mike (LogicaCMG) [mailto:[EMAIL PROTECTED]
  Sent: Tuesday, August 12, 2003 10:04 AM
  To: Multiple recipients of list ORACLE-L
  Subject: RE: Question on views
  
  
  Stephen,
  
  Traditional views don't go stale though they can be made
  invalid if the underlying objects change. This shouldn't 
  really be happening on a regular basis unless the schema is 
  changing rapidly. 
  He may be using a materialized view. These can go stale. 
  Before going any further ask him which of these is the cause 
  and get the name of the view. 
  I'd have thought that if a materialized view was created by 
  his application then it's his responsibility.
  
  Cheers,
  Mike Hately,
  Consultant DBA
  
  -Original Message- [mailto:[EMAIL PROTECTED]
  Sent: 12 August 2003 13:40
  To: Multiple recipients of list ORACLE-L
  
  
  I just had a contractor tell me that the problem with my
  Diabetic detection and Listing 'feature' in their product 
  (Integrated Clinical Database, ICDB) is because the 'view' 
  crafted for that detection is going 'stale'.
  
  I admit that most my SQL design experience is in MSSQL's
  T-SQL although I'm starting to come up to speed on SQL*Plus, 
  anyway, the above explanation provided to be from the TriCare 
  guy seems bogus.
  
  Simply put there are four or five good Lab Chemistry
  parameters one could use in a SQL select statement to 
  determine if a patient is diabetic or a diabetic candidate 
  without having specific ICD9 diagnosis coding that declares 
  the patient diabetic.
  
  A select statement returns a cursor of data that meets the
  selection criteria and on MSSQL is a static snapshot of what 
  is in the database at the time the query was executed.  Thus, 
  if a patient had parameters that met diabetic conditions 
  stored in the database over the past year, how can a view go 
  'stale'?

RE: Raid 1 vs Raid 5 for tablespaces


Yes, it isn't quite the same as actually growing a RAID device, but it kind
of looks like that in the end. 

It certainly requires some good management skills, or you can create
quite a mess. 

With power comes complexity.

Jared







Matthew Zito [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
08/13/2003 05:14 PM
Please respond to ORACLE-L


To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:RE: Raid 1 vs Raid 5 for tablespaces



Yes and no - its a semantical issue. If you want to grow a Veritas volume with the RAID under hardware control, either you need to have free space on the exposed RAID device the volume is using as a subdisk (to use Veritas parlance), in which case you're just using more free space on the existing RAID group, or you need to expand the volume onto another exposed RAID device. Either way, you're not actually growing the RAIDed device - just expanding the volume onto additional pre-existing space.

Certainly, all LVMs allow you to resize volumes - when they include a software RAID component, you gain an additional level of flexibility over what most hardware RAID arrays offer. Veritas, in my mind, is the gold standard. I haven't seen another LVM+RAID come close to the featureset and elegance that they offer.

Thanks,
Matt

--
Matthew Zito
GridApp Systems
Email: [EMAIL PROTECTED]
Cell: 646-220-3551
Phone: 212-358-8211 x 359
http://www.gridapp.com 
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, August 13, 2003 7:03 PM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: RE: Raid 1 vs Raid 5 for tablespaces
Importance: High


You can grow volumes though without putting the RAID under software control. 

Veritas Volume Mgr allows you to do that. 

Jared 






Matthew Zito [EMAIL PROTECTED] 
Sent by: [EMAIL PROTECTED] 
08/13/2003 09:14 AM 
 Please respond to ORACLE-L 

To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] 
cc: 
Subject:RE: Raid 1 vs Raid 5 for tablespaces





The _only_ even theoretical advantage to software RAID-0 is that software
RAID implementations tend to have more flexibility than the hardware ones.
For example, there are a number of software RAID implementations that allow
you to grow RAID-0 volumes, something that is generally not allowed in
hardware RAID, and most of those allow you to do it online. Some of the
better software RAID implementations even allow for online volume type
conversion - from RAID-1 to RAID-5 when adding a third disk to a mirrored
pair, as a random example.

Beyond that, there's no reason to have software RAID. Any other extraneous
advantages can be gleaned by using a traditional VM on top of hardware
RAID-ed devices. And even some of that stuff is better in hardware. :)

Thanks,
Matt

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

 -Original Message-
 From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On 
 Behalf Of Jared Still
 Sent: Wednesday, August 13, 2003 11:54 AM
 To: Multiple recipients of list ORACLE-L
 Subject: Re: Raid 1 vs Raid 5 for tablespaces
 
 
 
 Tim,
 
 Are you suggesting that HW RAID 1 with SW RAID 0 is a better 
 combination than HW RAID 1 and HW RAID 0?
 
 If so, why?
 
 Jared
 
 On Tue, 2003-08-12 at 21:59, Tim Gorman wrote:
  Software RAID-1 can mirror across controllers, channels, 
 and storage 
  arrays, should any of those be considered a 
 single-point-of-failure...
  
  The combination of HW RAID-1 and SW RAID-0 is optimal for 
 performance, 
  if the HW supports it...
  
  
  on 8/12/03 9:04 PM, Matthew Zito at [EMAIL PROTECTED] wrote:
  
   
   Actually, as of AIX 4.3.3, it does support 0+1 for LVs, but that 
   wasn't the scenario I was imagining. I was envisioning 
 creating a 
   set of RAID-1 raid groups on the storage array and then striping 
   across them using the LVM. RAID-1 is one of those things 
 that I feel 
   is generally better to let your storage array handle - software 
   RAID-1 requires your host to generate double the I/Os and 
 should one 
   side of the pair fail, hardware arrays tend to recover more 
   gracefully than software raid. RAID-0, by comparison, is 
 very easy.
   
   Thanks,
   Matt
   
   
   - Original Message -
   To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
   Sent: Tuesday, August 12, 2003 9:44 PM
   
   
   The AIX LVM supports RAID-0 and RAID-1, but not together, as you 
   state.
   
   However, a rude form of RAID-0 can be achieved by specifying max
   allocation
   policy, which will cause round-robin distribution of physical 
   extents
   (PEs)
   across a list of physical volumes (PVs), thereby approximately 
   RAID-0 at a large granularity (i.e. 4M, 8M, 16M per stripe). 
   Still, it beats the
   heck 
   out of RAID5...
   
   
   on 8/12/03 12:24 PM, Schauss, Peter at 
 [EMAIL PROTECTED] wrote:
   
   Our hardware people

RE: OT -- Boston Globe job listings


I'm a senior DBA (whatever that means), and I do lot of ad hoc scripting
for other people, and I don't get no 75K.  But then, I'm not working for 35K
to 40K either -- except when I was at WorldCom four years ago where I worked
for 44K.  They figured out how to get the best of both worlds: Work the H1
thing so that you bring overseas over here for the same price as having it
overseas.  Even then, they still managed to go bankrupt.

 -Original Message-
 a 75K US position would be for a junior 
 DBA that is actually getting
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Stephen Lee
  INET: [EMAIL PROTECTED]

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

RE: OT -- Boston Globe job listings

2003-08-14 Thread Odland, Brad

RANT

The problem is that companies are scrambling to cut costs to keep that
quarterly report looking good. Sometime ago some CEO found that if the
quarterly report looked good he justified getting paid more. So the emphasis
has been year after year to plan for the next quarter. Now that the economy
is tanking how does the CEO make the Q3 report look good...? But cutting
expenses. How do you do that?...get rid of high wage jobs! Hell with making
a better product...that doesn't work any more. We LIKE crap in America!

Frankly outsourcing offshore is going to blow up in corporate America's
face. It is like a turd in gift wrapping paper. Looks good on the outside
but once inside it is not a very pleasant experience. The problem of rising
costs and complexity of IT is not going to be solved by throwing dozens of
cheap programmers from India at it. The real problem is the software
companies that are more about marketing than substance. And Microsoft's game
platform OS that everyone thinks is so effing great. (STOP...don't get me
started...) 


Hey there is an opportunity right there...salvaging all the failed
outsourcing projects

I can see myself now. In a posh conference room. Wild shouting, arms
flailing, fingers pointing...only difference is I'm in India not Illinois or
Wisconsin. I'm being yelled at by two dozen programmers (instead of just two
or three) after I tell them their application is out of scope, out of
control and fails to meet any of the requirements laid out by the client.

Same deal...different location.


/RANT


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

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

2003-08-14 Thread Ken Hitchcox




I just 
wanted to report progress. It was @tns:name that solved this problem. Next 
step is resolving all the print problems that citrix is know for. 


Ken

  -Original Message-From: [EMAIL PROTECTED] 
  [mailto:[EMAIL PROTECTED]On Behalf Of 
  [EMAIL PROTECTED]Sent: Saturday, August 09, 2003 12:39 
  AMTo: Multiple recipients of list ORACLE-LSubject: Re: 
  TNS errorsKen, I don't see your 
  connection string in here, but I'm going to guess that it does not include '@TNS_NAME', which is what you 
  will have to do when connecting via a 
  client such as citrix. Remember, 
  you're not really on the console, though it may look like it.  Don't know how many times I did this with Terminal 
  Services on Win2k before it finally 
  sunk in. Jared 
  
  


  
  "Ken Hitchcox" 
[EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 
08/08/2003 02:04 PM 
Please respond to ORACLE-L 
  To:   
 Multiple recipients of list ORACLE-L 
[EMAIL PROTECTED] cc:

 Subject:TNS 
  errorsHi everyone,Been a very long time since I posted, but finally 
  running into a problem.New system:Win 2k Server, Citrix XPe, 
  Powerbuilder 5.0 App, Oracle 8i.  If I run thePowerbuilder 
  executable on the server, it connects to Oracle just fine.When 
  I try to connect using Citrix (from this machine or a differentmachine) on 
  the same network, I get TNS-12560, When I look at the nmi.log,I 
  see:Fatal NI connect error 12560, connecting 
  to:(DESCRIPTION=(ADDRESS=(PROTOCOL=BEQ)(PROGRAM=ORACLE)(ARGV0=ORACLEFIRST)(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))'))(CONNECT_DATA=(CID=(PROGRAM=c:\oracle\ora81\bin\dbsnmp.exe)(HOST=SUNRISE-SAMS)(USER=SYSTEMVERSION 
  INFORMATION:TNS for 32-bit Windows: Version 8.1.7.0.0 - Production Oracle 
  Bequeath NTProtocol Adapter for 32-bit Windows: Version 8.1.7.0.0 - 
  ProductionTime: 07-AUG-2003 10:48:22Tracing not turned on.Tns 
  error struct:nr err code: 0ns main err code: 12560TNS-12560: 
  TNS:protocol adapter errorns secondary err code: 0nt main err code: 
  530TNS-00530: Protocol adapter errornt secondary err code: 2nt OS 
  err code: 0I'm STILL a newbie, you would think that after 5 years of 
  managing my rinkydink database, I'd know something, but...Anyway, 
  can anyone help me to resolve this problem? Yes, I will turntracing 
  on as soon as I figure out how to for DBSNMP.Thanks,Ken 
  HitchcoxPS Hi Rachael C still have DBA101 on my 
  desk.-- Please see the official ORACLE-L FAQ: 
  http://www.orafaq.net-- Author: Ken HitchcoxINET: 
  [EMAIL PROTECTED]Fat City Network Services  -- 
  858-538-5051 http://www.fatcity.comSan Diego, California   
   -- Mailing list and web hosting 
  services-To 
  REMOVE yourself from this mailing list, send an E-Mail messageto: 
  [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message 
  BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing 
  list you want to be removed from). You mayalso send the HELP command 
  for other information (like 
subscribing).

Re: Semaphore problem

Fermin Bernaus wrote:
 
 Did you have a look to the alert file? what does it say? error 13 means some 
 kind of permission has been violated at the OS level (at least under UNIX) probably 
 trying to access a file (for cration, reading or whatever)
 
 Fermin.
 
 -Mensaje original-
 De: Smith, Ron L. [mailto:[EMAIL PROTECTED]
 Enviado el: miércoles, 13 de agosto de 2003 19:10
 Para: Multiple recipients of list ORACLE-L
 Asunto: Semaphore problem
 
 Has anyone ever seen an error like:
 
 ERROR: rbusy(SEMOP) (13; Permission denied)
 
 There is no Oracle error associated with it.
 
 Thanks!
 Ron
 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.net
 --
 Author: Smith, Ron L.
   INET: [EMAIL PROTECTED]
 

Ron,

   Run 
  ipcs -s
  and check what you have. Sempaphores are usually used to synchronize
processes - when a process holds the semaphore, any other process anted
to hold it waits until it is released. Quite similar to an Oracle lock.
It's possible that an instance crashed without releasing some resources.
the trouble will be with identifying the semaphores that are here and
shouldn't. Otherwise they can be deleted with ipcrm.

HTH

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

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

Re: ora 1575?

2003-08-14 Thread Gurelei

Tim,

thanks for the info. We do have a number of DMTS in
the database. Three of them have pct_increase of 50%,
the rest - 0. Should I consider changing the
pct_increase to 0 in all tablespaces in order to get
rid of this ora 1575? Wouldn't I want to have an
automatic coalesce process for the DMTS though?

thank you

Gene
--- Tim Gorman [EMAIL PROTECTED] wrote:
 Haven't seen this error since Oracle7...
 
 If the message is hitting the alert.log, then
 chances are good it is
 coming from SMON.  SMON is attempting to acquire the
 ST (a.k.a. Space
 transaction) enqueue in preparation for coalescing
 free space in some
 tablespaces.  However, if it is unable to acquire
 ST after a couple
 seconds, it times out and issues ORA-01575 to the
 alert.log.
 
 So, based on experiences from 6-7 years ago:
 
 * do you have a lot of dictionary-managed
 tablespaces?
 * do these DMT's have default PCTINCREASE
 non-zero, thus attacting
   SMON to do coalescing?
 
 If so, I'd suggest going to locally-managed
 tablespaces if at all
 possible...
 
 
 
 on 8/12/03 12:44 PM, Gurelei at [EMAIL PROTECTED]
 wrote:
 
  Hi all:
  
  I'm seeing the ora-01575 error in the alert
 logfile.
  The article on the metalink refers to the
 parameter
  which I think is obsolete in the ORacle version we
 are
  running (8.1.7). What does this error refer to?
 Any
  thoughts? references?
  
  thanks
  
  gene
  
  __
  Do you Yahoo!?
  Yahoo! SiteBuilder - Free, easy-to-use web site
 design software
  http://sitebuilder.yahoo.com
 
 -- 
 Please see the official ORACLE-L FAQ:
 http://www.orafaq.net
 -- 
 Author: Tim Gorman
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- 858-538-5051
 http://www.fatcity.com
 San Diego, California-- Mailing list and web
 hosting services

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


__
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software
http://sitebuilder.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Gurelei
  INET: [EMAIL PROTECTED]

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


... or even the actual size of the data

use dbms_space for that







DENNIS WILLIAMS [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
08/13/2003 10:39 AM
Please respond to ORACLE-L


To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:RE: How do I find out the size of a index


Roger - What do you mean by size? The allocation on disk, or the actual
number of blocks the index is using? Years ago when I was trying to get the
actual number of blocks an index was using (to predict when an index was
going to outgrow its extent), I used the LEAF_BLOCKS of the USER_INDEXES
table (after analyze, as Tanel points out. Theoretically this is slightly
under the total, but it was the closest I was able to find.

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


-Original Message-
Sent: Wednesday, August 13, 2003 11:54 AM
To: Multiple recipients of list ORACLE-L


Hi,

I can use select blocks*8 from dba_tables where table_name='ABC'
to find out the size of a table.
How do I find out the size of a index? I do not see a column BLOCK in
dba_indexes.

Thanks,

Roger Xu
Database Administrator
Dr Pepper Bottling Company of Texas
(972)721-8337

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

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

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

RE: Raid 1 vs Raid 5 for tablespaces

It robs of CPU power, that's true, but I've never seen a place where CPU
consumption would go
above 30% on average. If it does, then it's time to upgrade, or to quote the
Taco Bell dog,
you need a bigger box. With approximately 70% left idle, companies usually
have a few percent
of the CPU power to dedicate for RAID-0. After all, all those boxes have nfs
daemons, sendmail,
lpd/lp/CUPS, xdm/gdm, automounter and some other daemons running. Database
server seldomly needs 
to export file systems, route mail (well, that comes in handy here and
there), manipulate printers
or scan the units for a music CD. If I want to play Kashmir or Stairway To
Heaven, I'm not
going to (ab)use my database server for that purpose. Those few percent
spent on RAID-0 are quite
insignificant in comparison with the CPU percentage wasted by routed, gated,
walld, talkd, xdm 
and alike. The sad truth is that people no longer tune their systems,
because a bigger system is
actually cheaper then an SA needed to tune it properly. We're talking about
the SUV mentality 
translated into IT. You don't actually care whether an additional gallon of
washing liquid is 
wasting space in your SUV when you have enough room to accommodate a medium
sized elementary
school in your vehicle.

--
Mladen Gogala
Oracle DBA 



-Original Message-
Millsap
Sent: Wednesday, August 13, 2003 11:39 PM
To: Multiple recipients of list ORACLE-L


Problem with head-to-head price comparisons is that software RAID level 0
has hidden costs that a lot of folk might not understand before purchasing.
For example, I would argue that software RAID level 0 costs a heck of a lot
more than the list price, because it robs CPU capacity from your
applications.


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

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


-Original Message-
Jesse, Rich
Sent: Wednesday, August 13, 2003 11:49 AM
To: Multiple recipients of list ORACLE-L

How's about price?  That's pretty important to some folk.  :)

Rich

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


 -Original Message-
 From: Matthew Zito [mailto:[EMAIL PROTECTED]
 Sent: Wednesday, August 13, 2003 11:14 AM
 To: Multiple recipients of list ORACLE-L
 Subject: RE: Raid 1 vs Raid 5 for tablespaces
 
 
 
 
 The _only_ even theoretical advantage to software RAID-0 is
 that software
 RAID implementations tend to have more flexibility than the 
 hardware ones.
 For example, there are a number of software RAID 
 implementations that allow
 you to grow RAID-0 volumes, something that is generally not allowed in
 hardware RAID, and most of those allow you to do it online.  
 Some of the
 better software RAID implementations even allow for online volume type
 conversion - from RAID-1 to RAID-5 when adding a third disk 
 to a mirrored
 pair, as a random example.
 
 Beyond that, there's no reason to have software RAID.  Any
 other extraneous
 advantages can be gleaned by using a traditional VM on top of hardware
 RAID-ed devices.  And even some of that stuff is better in 
 hardware. :)
 
 Thanks,
 Matt
 
 --
 Matthew Zito
 GridApp Systems
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jesse, Rich
  INET: [EMAIL PROTECTED]

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


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

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


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

RE: OT -- Boston Globe job listings


No no! Not EDS. That was Ed's.  As in:
Ed's plumbing, welding, and database admin
( and professional dancing)

 -Original Message-
 
 Didn't the UK outsource their IT function to EDS?
 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Stephen Lee
  INET: [EMAIL PROTECTED]

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

Re: Oracle and Windows 2000 SP4 - any experiences to share

I'm sure many of us would love to know how to disable that thing.

I know I would.

Jared





Tanel Poder [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
 08/08/2003 04:24 AM
 Please respond to ORACLE-L

 
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc: 
Subject:Re: Oracle and Windows 2000 SP4 - any experiences to share


Hi!

Btw, after installing SP4, a service Automatic Updates has appeared and 
is
active by default (without even asking from me!).
I just figured it out  disabled it instantly. I have W2k professional.
Could you verify, whether you also do have this service installed 
automatic or is it just me?

Tanel.

- Original Message - 
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, August 07, 2003 1:34 PM


  FWIW, I installed it on my P4 at work and it's
  caused no problems yet.  8.1.7.4 as well.
  But in my Athlon XP at home, it's made the system
  so unstable I had to upgrade all sorts of drivers!
  There you go, 6 of 1...

 Hi!

 I've used SP4 on Athlon XP for a week now (with Oracle 9.2.0.1). So far
have
 seen no problems..

 Tanel.


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

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



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

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



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

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

RMAN Backup piece being placed in wrong directory

2003-08-14 Thread Stefick Ronald S Contr ESC/HRIDD

Title: Message




OS: 
Win2K
DB: 
8.1.7.4

All, 


Here 
is what I am running:
run{set archivelog destination to 
'D:\backup\oracle\Hotbackup';set controlfile autobackup format for device 
type disk to 'D:\backup\oracle\Hotbackup\cf_%F.bak';backup database 
format'D:\backup\oracle\Hotbackup\rman_d%d_t%t_U%U.bak' plus 
archivelog;}


Here 
is a the result after I run it: 
(The 
part I'm concerned about is in red. I would 
like that stuff to go to 'D:\backup\oracle\Hotbackup').

executing command: SET ARCHIVELOG DESTINATION
executing command: SET CONTROLFILE AUTOBACKUP FORMAT
Starting backup at 
07-AUG-03current log archivedusing channel ORA_DISK_1using channel 
ORA_DISK_2using channel ORA_DISK_3channel ORA_DISK_1: starting archive 
log backupsetchannel ORA_DISK_1: specifying archive log(s) in backup 
setinput archive log thread=1 sequence=4 recid=2 stamp=500738572channel 
ORA_DISK_1: starting piece 1 at 07-AUG-03channel ORA_DISK_2: starting 
archive log backupsetchannel ORA_DISK_2: specifying archive log(s) in backup 
setinput archive log thread=1 sequence=5 recid=1 stamp=500738568input 
archive log thread=1 sequence=6 recid=3 stamp=500738573input archive log 
thread=1 sequence=7 recid=4 stamp=500738574input archive log thread=1 
sequence=8 recid=5 stamp=500815654input archive log thread=1 sequence=9 
recid=6 stamp=500824391input archive log thread=1 sequence=10 recid=7 
stamp=501340112channel ORA_DISK_2: starting piece 1 at 07-AUG-03channel 
ORA_DISK_3: starting archive log backupsetchannel ORA_DISK_3: specifying 
archive log(s) in backup setinput archive log thread=1 sequence=11 recid=8 
stamp=501343673input archive log thread=1 sequence=12 recid=9 
stamp=501343804input archive log thread=1 sequence=13 recid=10 
stamp=501347437input archive log thread=1 sequence=14 recid=11 
stamp=501347562input archive log thread=1 sequence=15 recid=12 
stamp=501407160input archive log thread=1 sequence=16 recid=13 
stamp=501407288channel ORA_DISK_3: starting piece 1 at 07-AUG-03channel 
ORA_DISK_1: finished piece 1 at 07-AUG-03piece 
handle=C:\ORACLE\ORACLE\9.2.0\DATABASE\1AEU5O7O_1_1 
comment=NONEchannel ORA_DISK_1: backup set complete, elapsed time: 
00:00:16channel ORA_DISK_3: finished piece 1 at 07-AUG-03piece handle=C:\ORACLE\ORACLE\9.2.0\DATABASE\1CEU5O7O_1_1 
comment=NONEchannel ORA_DISK_3: backup set complete, elapsed time: 
00:00:16channel ORA_DISK_1: starting archive log backupsetchannel 
ORA_DISK_1: specifying archive log(s) in backup setinput archive log 
thread=1 sequence=17 recid=14 stamp=501407709input archive log thread=1 
sequence=18 recid=15 stamp=501407832input archive log thread=1 sequence=19 
recid=16 stamp=501407991channel ORA_DISK_1: starting piece 1 at 
07-AUG-03channel ORA_DISK_1: finished piece 1 at 07-AUG-03piece handle=C:\ORACLE\ORACLE\9.2.0\DATABASE\1DEU5O89_1_1 
comment=NONEchannel ORA_DISK_1: backup set complete, elapsed time: 
00:00:02channel ORA_DISK_2: finished piece 1 at 07-AUG-03piece handle=C:\ORACLE\ORACLE\9.2.0\DATABASE\1BEU5O7O_1_1 
comment=NONEchannel ORA_DISK_2: backup set complete, elapsed time: 
00:00:20Finished backup at 07-AUG-03

Starting backup at 07-AUG-03using channel 
ORA_DISK_1using channel ORA_DISK_2using channel ORA_DISK_3channel 
ORA_DISK_1: starting full datafile backupsetchannel ORA_DISK_1: specifying 
datafile(s) in backupsetinput datafile fno=2 
name=D:\ORACLE\EWFMS\UNDOTBS01.DBFinput datafile fno=00010 
name=D:\ORACLE\EWFMS\TCS_INDEXES01.DBFinput datafile fno=00011 
name=D:\ORACLE\EWFMS\NOTF_DATA.DBFinput datafile fno=3 
name=D:\ORACLE\EWFMS\CWMLITE01.DBFchannel ORA_DISK_1: starting piece 1 at 
07-AUG-03channel ORA_DISK_2: starting full datafile backupsetchannel 
ORA_DISK_2: specifying datafile(s) in backupsetinput datafile fno=8 
name=D:\ORACLE\EWFMS\XDB01.DBFinput datafile fno=00012 
name=D:\ORACLE\EWFMS\NOTF_INDX.DBFinput datafile fno=9 
name=D:\ORACLE\EWFMS\TCS_DATA01.DBFinput datafile fno=6 
name=D:\ORACLE\EWFMS\TOOLS01.DBFchannel ORA_DISK_2: starting piece 1 at 
07-AUG-03channel ORA_DISK_3: starting full datafile backupsetchannel 
ORA_DISK_3: specifying datafile(s) in backupsetinput datafile fno=1 
name=D:\ORACLE\EWFMS\SYSTEM01.DBFinput datafile fno=4 
name=D:\ORACLE\EWFMS\DRSYS01.DBFinput datafile fno=5 
name=D:\ORACLE\EWFMS\INDX01.DBFinput datafile fno=7 
name=D:\ORACLE\EWFMS\USERS01.DBFchannel ORA_DISK_3: starting piece 1 at 
07-AUG-03channel ORA_DISK_2: finished piece 1 at 07-AUG-03piece 
handle=D:\BACKUP\ORACLE\HOTBACKUP\RMAN_DEWFMS_T501408013_U1FEU5O8D_1_1.BAK 
comment=NONEchannel ORA_DISK_2: backup set complete, elapsed time: 
00:00:46channel ORA_DISK_1: finished piece 1 at 07-AUG-03piece 
handle=D:\BACKUP\ORACLE\HOTBACKUP\RMAN_DEWFMS_T501408013_U1EEU5O8D_1_1.BAK 
comment=NONEchannel ORA_DISK_1: backup set complete, elapsed time: 
00:01:41channel ORA_DISK_3: finished piece 1 at 07-AUG-03piece 
handle=D:\BACKUP\ORACLE\HOTBACKUP\RMAN_DEWFMS_T501408013_U1GEU5O8D_1_1.BAK 
comment=NONEchannel ORA_DISK_3: backup set

RE: Oracle Name Server

2003-08-14 Thread Jesse, Rich

It can't -- unless you haven't tried replication in OiD.  H doggy.  It's
a hacked implementation of AR and works like it.

Then again, this was 9.0.1 on Linux.  Perhaps things have changed, but I
don't have the time nor the hair to figure that out.

Rich

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


 -Original Message-
 From: Mladen Gogala [mailto:[EMAIL PROTECTED]
 Sent: Friday, August 08, 2003 11:14 AM
 To: Multiple recipients of list ORACLE-L
 Subject: RE: Oracle Name Server
 
 
 Dennis, on the plus side, there is only one way OID can go: 
 for the better.
 It can't get any worse.
 
 --
 Mladen Gogala
 Oracle DBA 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jesse, Rich
  INET: [EMAIL PROTECTED]

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

Re: Take an Oracle 8.1 export file back to an Oracle 7.1 database.

Title: Message



Hi!

You just set compatible and 
optimizer_features_enable to 8.1.7 ;)

Tanel.

  - Original Message - 
  From: 
  Mladen 
  Gogala 
  To: Multiple recipients of list ORACLE-L 
  
  Sent: Thursday, August 07, 2003 8:29 
  PM
  Subject: RE: Take an Oracle 8.1 export 
  file back to an Oracle 7.1 database.
  
  I'm 
  very interested in finding out how will you import LOB's, Java classes, 
  function based indexes, IOTand ADT objects into V7 
  database,
  especially if it is V7.1 and not 7.3.4 or 7.3.5. Please, keep us 
  posted.
  
  
  --Mladen GogalaOracle DBA 
  

-Original Message-From: [EMAIL PROTECTED] 
[mailto:[EMAIL PROTECTED] On Behalf Of Bartolo, 
DavidSent: Thursday, August 07, 2003 1:15 PMTo: 
Multiple recipients of list ORACLE-LSubject: Take an Oracle 8.1 
export file back to an Oracle 7.1 database.
Hi all 
Is it possible to take an Oracle Version 8.1 
database export file and load it into an Oracle Version 7.1 database? 
The export file of the 8.1 is on a different 
machine than the 7.1 database. If I can not is there some other 
method I can use to get the data from the 
8.1 export file to the 7.1 database. 
Thanks David 
  

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

RE: Change based recovery

2003-08-14 Thread Fermin Bernaus


Thank you all for your suggestions. I really have no time for downtime during 
the week, but we have space to keep the archived logs on disk but not a backup (even a 
partial hot backup) of the database unless I move it to a tape, which is too much time 
and resource consuming, so here is what I've been doing until now:

- We make a cold backup + verify every weekend, fortunately we are allowed to stop the 
database on Saturdays and Sundays.

- We backup all archived logs every night during the week + exports of the tables to a 
disk on the server, then copy them to a tape. We never delete them until a new cold 
backup is performed, this way I have all the archived logs copied several times in 
several tapes every week.

I have at least two sets of tapes (15 tapes counting them all) which I reuse 
every 2 weeks, so I keep 2 verified cold backups + their archived logs for 2 weeks, 
which has proved enough for now. We store them in a safety fire proof case in a 
different building.

As for RMAN I've never tried it, do you think it could help me in any way 
considering my backup strategy?

Thanks!

Fermin.

-Mensaje original-
De: DENNIS WILLIAMS [mailto:[EMAIL PROTECTED]
Enviado el: lunes, 11 de agosto de 2003 16:40
Para: Multiple recipients of list ORACLE-L
Asunto: RE: Change based recovery


Fermin - And it is always a good idea to keep at least the previous backup
to the last. Often this just costs an extra tape, but could be very useful
in the unlikely case there is something wrong with the most recent back.
With backing up once/week, realize that in a recovery situation, if Oracle
cannot read a single archived redo log, recovery stops at that point. Also,
if you are considering changing your backup strategy, you should consider
RMAN.



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

 

-Original Message-
Sent: Monday, August 11, 2003 6:24 AM
To: Multiple recipients of list ORACLE-L


 
I've been reading your messages with much interest. I have some
experience with database administration and I have done many tests, but I've
not tried what I am going to expose in this message, maybe you can help. We
do cold backups on a regular basis (every weekend) then just backup the
archive log every day, then delete them every time a new cold backup is
done. We have tested it and if all database files (parameters file,
datafiles, control files) except for one control file and the archived logs
were lost we could recover the entire database issuing the following
commands after restoring all missing files and mounting the database:
 
SET AUTORECOVERY ON
RECOVER DATABASE
ALTER DATABASE OPEN
 
My questions are: 
 
1 - Could a complete restore be done even if we lost ALL control files?
can we recover the entire database from a cold backup provided we have all
archived logs until the failure time?
2 - If the answer is yes, what is the advantage of doing on-line backups
of datafiles and control files?
 
Thanks for your answers, I always learn so much from this list!!
 
Fermin.

-Mensaje original-
De: Hand, Michael T [mailto:[EMAIL PROTECTED]
Enviado el: viernes, 08 de agosto de 2003 18:10
Para: Multiple recipients of list ORACLE-L
Asunto: RE: Change based recovery


Lisa,
The 3rd option (besides shuting down source database and using a controlfile
trace) is to alter database backup controlfile to 'filename'; , use this
file, then proceed with the recovery as Venu suggests.  I've used this
method on a hot backup to roll the database forward.  Also, don't bother
restoring the redo logs as you will be overwriting / recreating them with
the alter database open resetlogs.  One more thing I noticed.  Your until
change number looks to me like an archive sequence number rather than the
SCN it needs to be.  Hope this helps.
 
Mike Hand

-Original Message-
Sent: Thursday, August 07, 2003 8:21 AM
To: Multiple recipients of list ORACLE-L


Hi Guys and Gals, 
We are currently doing some testing to enable us to move our production
database from one unix box to another.
We are running a 7.3.4 db in archivelog mode.  The approach that management
want to use is to restore the database on the new server from a backup and
then roll it forward using the archived redo logs.
 
I have a full cold back up from last Friday. I have restored the datafiles,
controlfiles and redo logs onto our test server from the backup tape, and
then ftp'd the archived logs over.
 
I then do - 
SVRMGR startup mount
ORACLE instance started.
Total System Global Area 258304260 bytes
Fixed Size   45092 bytes
Variable Size126925024 bytes
Database Buffers 131072000 bytes
Redo Buffers262144 bytes
Database mounted.
SVRMGR recover database until change 10349;
Media recovery complete. 

 

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

Re: RE: how to turn off ODBC auto-commit?

2003-08-14 Thread rgaffuri

it says it is in tom kytes book. he says its there because ODBC is written by 
microsoft and sql server needs to commit often because reads blocks writes and you run 
into concurrency issues. 

 From: DENNIS WILLIAMS [EMAIL PROTECTED]
 Date: 2003/08/11 Mon AM 10:44:29 EDT
 To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
 Subject: RE: how to turn off ODBC auto-commit?

 Ryan
 I don't think autocommit is a feature of ODBC.

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

 -Original Message-
 Sent: Saturday, August 09, 2003 8:54 PM
 To: Multiple recipients of list ORACLE-L

 There is a function to turn off the auto-Commit in the JDBC. Is there one
 for the ODBC? Id prefer to commit at the transaction level and not for every
 statement.

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

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

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

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

RE: tables and views

2003-08-14 Thread Igor Neyman










Views arent in all_tables, they are
in all_views.





Igor Neyman, OCP DBA

[EMAIL PROTECTED]







-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of AK
Sent: Friday, August 08, 2003 1:19
PM
To: Multiple recipients of list
ORACLE-L
Subject: tables and views





How to diiferentiate views and
tables in all_tables and all_tab_columns . which column and what criteria can
return only tables ??











-ak

RE: How do I create a temp table with no logging?

Jake - The syntax is

create table test2 nologging as select * from test;

Taking the advice of the experts on this list, I decided to confirm this, I
ran the query Mike Hatley posted a few days ago:

select s.sid,s.value
 from v$sesstat s
where s.statistic#=99
and s.value!=0

I found some interesting results I can't understand:

Small table (75 rows) nologging  - 673,776 (bytes??)
Medium table (35,000 rows) nologging - 84,424 
Medium table with default (logging)  - 84,040

Can anyone offer a theory?

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


-Original Message-
Sent: Friday, August 08, 2003 2:44 AM
To: Multiple recipients of list ORACLE-L


Hello,
I am trying to make a temp table with no logging as select * from table.  
Does anyone have a good example?  THanks a ton!
Jake
__
Plutoid - http://www.plutoid.com - Shop Plutoid for the best prices on
Rims, Car Audio, and Performance Parts.



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

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

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

Re: Can't insert into partition

Btw, have you noticed that you have a dot instead of comma in your hash
hint:

SELECT /*+ use_hash(cjs, ps. md, a, o, x, wv, apc, wv1)  */

How big are your tables - why do you want to have hash join on all of them?
Hash joins aren't fast if you got huge datasets and little hash_area_size...
especially when statistics aren't correct.

Check for v$session_event for your session and for what does it wait the
most (also compare with CPU used by this session statistic from v$sesstat
although from execution plan I'd say you got IO problem rather than CPU
bottleneck).

Tanel.

- Original Message - 
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, August 06, 2003 6:39 PM



 We have a situation where a process can't insert into a partition of a
 partitioned table. The process just keeps running.
 - A stored procedure executes a SQL insert statement (listing below).
 - It normally completes in 30 minutes, but now just runs for hours.
 - Oracle 8.1.6 on Dec/Compaq/HP Alpha
 - In tracing the process, it is waiting on db file scattered read.
 - This is a relatively new process, but it has completed successfully
twice
 in production and numerous times in test.
 - I was able to perform a simple insert into the partition.
 - I created a test table (non-partitioned) and the process worked fine
 there, completing in the normal 30 minutes.
 - I rebuilt the partition (drop partition and create partition), to no
 effect.
 I'm stumped and looking for any suggestions:

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

 Here is the SQL and the explain plan:


  SQL explain plan for
2  INSERT /*+ APPEND  */INTO CURRJOBFACT NOLOGGING
3  ( bunch of columns )
   21SELECT /*+ use_hash(cjs, ps. md, a, o, x, wv, apc, wv1)  */
   22  CJS.JOBNBR,CJS.SOURCEFISCALYEAR,CJS.LIFETOUCHID,MD.PROGRAMID,
   23  CJS.MARKETINGCODE,CJS.PLANTRECEIPTDATE,CJS.PHOTOGRAPHYDATE,
   24
  CJS.SHIPDATE,CJS.SELLINGMETHODCODE,CJS.MDRPRIMARYID,CJS.SUBPROGRAMCODE,
   25  CJS.TERRCODE,CJS.SUBTERRCODE,CJS.BIDIND,CJS.PDKIND,CJS.PDKPARTNBR,
   26  CJS.RETAKEIND,
   27
 
TO_NUMBER(TRANSLATE(UPPER(SUBSTR(CJS.JOBNBR,10,1)),'ABCDEFGHIJKLMNOPQRSTUV
  ,
   28DECODE(TO_DATE(CJS.SHIPDATE,'/MM/DD'), NULL ,'N','Y'),
   29DECODE(NVL(GREATEST(CJS.YTDCASHRECEIVEDAMT,0),0),0,
   30DECODE(CJS.PAYSTATUSIND,'F','Y','N'),'Y') PAIDJOBIND,
   31  CJS.PAYSTATUSIND,PS.PAIDSHIPPEDJOBIND,
   32  DECODE(SUBSTR(CJS.JOBNBR,9,1),'I','Y','N') PREJOBIND,CJS.PLANTCODE,
   33
  CJS.SHOTQTY,PS.MTDSHIPPEDPKGQTY,PS.MTDCHARGEBACKAMT,PS.MTDTERRCMSNAMT,
   34  NVL(PS.MTDTERRCMSNAMT,0) - NVL(PS.MTDCHARGEBACKAMT,0)
  ,PS.MTDCASHRECEIVEDA,
   35  PS.MTDCASHRETAINEDAMT,PS.MTDESTACCTCMSNAMT,PS.MTDACCTCMSNPAIDAMT,
   36
 
PS.MTDGROSSCASHAMT,PS.MTDSALESTAXAMT,CJS.YTDSHIPPEDPKGQTY,CJS.YTDCHARGEBAC
  ,
   37  CJS.YTDTERRCMSNAMT,CJS.YTDTERREARNINGSAMT,CJS.YTDCASHRECEIVEDAMT,
   38
CJS.YTDCASHRETAINEDAMT,CJS.YTDESTACCTCMSNAMT,CJS.YTDACCTCMSNPAIDAMT,
   39  CJS.YTDCASHRECEIVEDAMT +YTDESTACCTCMSNAMT  + YTDACCTCMSNPAIDAMT ,
   40  CJS.YTDSALESTAXAMT,CJS.YTDPERFECTSALEAMT,PS.PRELIMYTDSHIPPEDPKGQTY,
   41  PS.PRELIMYTDCHARGEBACKAMT,PS.PRELIMYTDTERRCMSNAMT,
   42  PS.PRELIMYTDTERRCMSNAMT - PS.PRELIMYTDCHARGEBACKAMT
  ,PS.PRELIMYTDCASHRECEI,
   43  PS.PRELIMYTDCASHRETAINEDAMT,PS.PRELIMYTDESTACCTCMSNAMT,
   44
 
PS.PRELIMYTDACCTCMSNPAIDAMT,PS.PRELIMYTDGROSSCASHAMT,PS.PRELIMYTDSALESTAXA
  ,
   45  PS.PRELIMYTDPERFECTSALEAMT,CJS.YTDJTEPAIDPKGQTY,CJS.YTDPAIDPKGQTY,
   46  CJS.YTDUNPAIDPKGQTY,CJS.YTDXNOPURCHASEQTY,PS.YTDPAIDPKGSHIPQTY,
   47
 
PS.YTDUNPAIDPKGSHIPQTY,CJS.PROOFPOSEQTY,CJS.PROOFCOUNTQTY,CJS.EXTRACTDATE,
   48
CJS.ORIGINALRECEIVEDDATE,PS.CMSNSTATUSCODE,WV1.FIRSTPOSITIVECASHDATE,
   49  DECODE(C.LIFETOUCHID, NULL ,'New','Retained') RENEWALSTATUSCODE,
   50  NVL(WV.PRELIMYTDESTACCTCMSNAMT,
   51  DECODE(NVL(PS.PRELIMYTDESTACCTCMSNAMT,0),0, NULL
  ,PS.PRELIMYTDESTACCTCMSNA,
   52  APC.AVGPKGPRICE
   53  FROM CURRJOB_STAGE CJS,PERIOD_STAGE PS,MARKETINGDIM MD,
   54  (SELECT A1.JOBNBR,DECODE(SUM(PAIDOFFERQTY),0,0,
   55  SUM(A1.OFFERPRICEAMT * A1.PAIDOFFERQTY ) / SUM(A1.PAIDOFFERQTY) )
  AVGPKGPR
   56 FROM (SELECT DISTINCT
  A.JOBNBR,A.OFFERNAME,A.PAIDOFFERQTY,A.OFFERPRICEAT
   57   FROM OFFERLOAD_STAGE A
   58   WHERE A.OFFERNAME IN (
  'A','B','C','D','E','F','G','H','I','J','K
   59  GROUP BY A1.JOBNBR ) APC,
   60  (SELECT DISTINCT C.LIFETOUCHID,C.PROGRAMID,MD.MARKETINGCODE
   61  FROM CURRJOBFACT C,MARKETINGDIM MD  WHERE C.SOURCEFISCALYEAR  2004
   62  AND C.MARKETINGCODE = MD.MARKETINGCODE ) C,
   63  (SELECT JOBNBR,MIN(DEPOSITDATE) FIRSTPOSITIVECASHDATE
   64  FROM CASHTXNFACT
   65  WHERE SOURCEFISCALYEAR = 2004  GROUP BY JOBNBR ) WV1,
   66  (SELECT X.JOBNBR,X.WEEKENDDATE,X.PRELIMYTDESTACCTCMSNAMT
   67  FROM WKLYJOBFACT X,
   68  (SELECT JOBNBR,MAX(WEEKENDDATE) MAXWEEKENDDATE
   69  FROM WKLYJOBFACT  WHERE SOURCEFISCALYEAR = 2004
   70AND NVL(PRELIMYTDESTACCTCMSNAMT,0)  0

RE: HP-UX

It's out of stock,

Allan

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


How's about a link instead?

http://www.bookpool.com/.x/6oqxxyd9k4/sm/0130125156


Rich

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


 -Original Message-
 From: Seema Singh [mailto:[EMAIL PROTECTED]
 Sent: Thursday, August 14, 2003 11:45 AM
 To: Multiple recipients of list ORACLE-L
 Subject: HP-UX
 
 
 Hi,
 Can someone send me  system administration document on OS
 HP-UX 11.0 if have 
 ?
 thx
 -Seema
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jesse, Rich
  INET: [EMAIL PROTECTED]

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


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

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

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

RE: RMAN Backup piece being placed in wrong directory

2003-08-14 Thread Freeman Robert - IL

Good point Tom

RF

-Original Message-
To: Multiple recipients of list ORACLE-L
Sent: 8/7/2003 1:29 PM

Ronald,
 
It looks like just the archivelog was not going into the correct
directory, right?  But then you did *not* include a format clause for
the archivelog.
 
Looking at the docs, it looks like you should change the following:
 
backup database format
'D:\backup\oracle\Hotbackup\rman_d%d_t%t_U%U.bak' plus archivelog;

to
 
backup database format
'D:\backup\oracle\Hotbackup\rman_d%d_t%t_U%U.bak' plus archivelog format
'D:\backup\oracle\Hotbackup\arcs_d%d_t%t_U%U.bak'

 
Good Luck!

Tom Mercadante 
Oracle Certified Professional 

-Original Message-
[mailto:[EMAIL PROTECTED]
Sent: Thursday, August 07, 2003 1:15 PM
To: Multiple recipients of list ORACLE-L


Robert? Dennis?  Anyone?
 
-Original Message-
Sent: Thursday, August 07, 2003 9:24 AM
To: Multiple recipients of list ORACLE-L


OS: Win2K
DB: 8.1.7.4
 
All, 
 
Here is what I am running:
run{
set archivelog destination to 'D:\backup\oracle\Hotbackup';
set controlfile autobackup format for device type disk to 
'D:\backup\oracle\Hotbackup\cf_%F.bak';
backup database format
'D:\backup\oracle\Hotbackup\rman_d%d_t%t_U%U.bak' plus archivelog;
}
 
 
Here is a the result after I run it: 
(The part I'm concerned about is in red.  I would like that stuff to go
to 'D:\backup\oracle\Hotbackup').
 
executing command: SET ARCHIVELOG DESTINATION
executing command: SET CONTROLFILE AUTOBACKUP FORMAT

Starting backup at 07-AUG-03
current log archived
using channel ORA_DISK_1
using channel ORA_DISK_2
using channel ORA_DISK_3
channel ORA_DISK_1: starting archive log backupset
channel ORA_DISK_1: specifying archive log(s) in backup set
input archive log thread=1 sequence=4 recid=2 stamp=500738572
channel ORA_DISK_1: starting piece 1 at 07-AUG-03
channel ORA_DISK_2: starting archive log backupset
channel ORA_DISK_2: specifying archive log(s) in backup set
input archive log thread=1 sequence=5 recid=1 stamp=500738568
input archive log thread=1 sequence=6 recid=3 stamp=500738573
input archive log thread=1 sequence=7 recid=4 stamp=500738574
input archive log thread=1 sequence=8 recid=5 stamp=500815654
input archive log thread=1 sequence=9 recid=6 stamp=500824391
input archive log thread=1 sequence=10 recid=7 stamp=501340112
channel ORA_DISK_2: starting piece 1 at 07-AUG-03
channel ORA_DISK_3: starting archive log backupset
channel ORA_DISK_3: specifying archive log(s) in backup set
input archive log thread=1 sequence=11 recid=8 stamp=501343673
input archive log thread=1 sequence=12 recid=9 stamp=501343804
input archive log thread=1 sequence=13 recid=10 stamp=501347437
input archive log thread=1 sequence=14 recid=11 stamp=501347562
input archive log thread=1 sequence=15 recid=12 stamp=501407160
input archive log thread=1 sequence=16 recid=13 stamp=501407288
channel ORA_DISK_3: starting piece 1 at 07-AUG-03
channel ORA_DISK_1: finished piece 1 at 07-AUG-03
piece handle=C:\ORACLE\ORACLE\9.2.0\DATABASE\1AEU5O7O_1_1 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:16
channel ORA_DISK_3: finished piece 1 at 07-AUG-03
piece handle=C:\ORACLE\ORACLE\9.2.0\DATABASE\1CEU5O7O_1_1 comment=NONE
channel ORA_DISK_3: backup set complete, elapsed time: 00:00:16
channel ORA_DISK_1: starting archive log backupset
channel ORA_DISK_1: specifying archive log(s) in backup set
input archive log thread=1 sequence=17 recid=14 stamp=501407709
input archive log thread=1 sequence=18 recid=15 stamp=501407832
input archive log thread=1 sequence=19 recid=16 stamp=501407991
channel ORA_DISK_1: starting piece 1 at 07-AUG-03
channel ORA_DISK_1: finished piece 1 at 07-AUG-03
piece handle=C:\ORACLE\ORACLE\9.2.0\DATABASE\1DEU5O89_1_1 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:02
channel ORA_DISK_2: finished piece 1 at 07-AUG-03
piece handle=C:\ORACLE\ORACLE\9.2.0\DATABASE\1BEU5O7O_1_1 comment=NONE
channel ORA_DISK_2: backup set complete, elapsed time: 00:00:20
Finished backup at 07-AUG-03
 
Starting backup at 07-AUG-03
using channel ORA_DISK_1
using channel ORA_DISK_2
using channel ORA_DISK_3
channel ORA_DISK_1: starting full datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
input datafile fno=2 name=D:\ORACLE\EWFMS\UNDOTBS01.DBF
input datafile fno=00010 name=D:\ORACLE\EWFMS\TCS_INDEXES01.DBF
input datafile fno=00011 name=D:\ORACLE\EWFMS\NOTF_DATA.DBF
input datafile fno=3 name=D:\ORACLE\EWFMS\CWMLITE01.DBF
channel ORA_DISK_1: starting piece 1 at 07-AUG-03
channel ORA_DISK_2: starting full datafile backupset
channel ORA_DISK_2: specifying datafile(s) in backupset
input datafile fno=8 name=D:\ORACLE\EWFMS\XDB01.DBF
input datafile fno=00012 name=D:\ORACLE\EWFMS\NOTF_INDX.DBF
input datafile fno=9 name=D:\ORACLE\EWFMS\TCS_DATA01.DBF
input datafile fno=6 name=D:\ORACLE\EWFMS\TOOLS01.DBF
channel ORA_DISK_2: starting piece 1 at 07-AUG-03
channel ORA_DISK_3: starting full datafile backupset

RE: [stupid] vi question

:1,$s/^v^M$/^v^G/


--
Mladen Gogala
Oracle DBA 



-Original Message-
Saira Somani-Mendelin
Sent: Wednesday, August 06, 2003 1:09 PM
To: Multiple recipients of list ORACLE-L


Suddenly my vi editor is showing ^M at the end of each line. How do I get
rid of it?

Thanks in advance,
Saira


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

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



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

Any views expressed in this message are those of the 
individual sender, except where the message states 
otherwise and the sender is authorized to state them 
to be the views of any such entity.
-
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Mladen Gogala
  INET: [EMAIL PROTECTED]

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

RE: More On 10G

You are definitely reading writings of Hans Christian Andersen.

--
Mladen Gogala
Oracle DBA 



-Original Message-
Boivin, Patrice J
Sent: Wednesday, August 06, 2003 1:34 PM
To: Multiple recipients of list ORACLE-L


I think 10G is supposed to be faster than 9i Release 2.

I read too much though, and can't remember where I read that.

Patrice.

-Original Message-
Sent: Wednesday, August 06, 2003 12:04 PM
To: Multiple recipients of list ORACLE-L



I noticed that the new Oracle TPC-C benchmark was 10G ... if that means
anything.

 -Original Message-
 
 Heard an Oracle rep last week say that 10G was mostly
 hype.  If you want to watch what's for real at Oracle
 it's Linux.
 
 Only time will tell if he is right, but he has a
 better inside track to the Oracle gossip that I do.
 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Stephen Lee
  INET: [EMAIL PROTECTED]

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

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



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

Any views expressed in this message are those of the 
individual sender, except where the message states 
otherwise and the sender is authorized to state them 
to be the views of any such entity.
-
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Mladen Gogala
  INET: [EMAIL PROTECTED]

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

Re: what is BAARF? --- OFA

Hi!

 4)  I think the /u01, /u02, etc. MP naming is a pain.  They mean
 nothing.  In a disaster recovery, the last thing you want is to have
someone
 forget what /u01 is.  This is the 21st century, people!  We have the
power
 to NAME DIRECTORIES something meaningful!

I still like to use concept of /u[0-9][0-9]/oradata/$DBNAME, that means
database name is included in directory path and I can use wildcards when
playing around in file system. Other notation I've seen is somewhat
opposite: /data/$DBNAME/[0-9][0-9]/

Other installations have used no standard for placing datafiles or have used
random as standard :|

Tanel.


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

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

Re: ora 1575?

Check that the less than 1% of sorts aren't huge ones and not done by user
whose temporary_tablespace is pointed to permanent one.. system for example.

(Just a note that you can get temporary segments to non-temporary
tablespaces due failed index (re)creations, and create table as select)

Tanel.
- Original Message - 
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, August 13, 2003 8:54 PM


 Tim and Tanel:

 thanks for your help. The temp tablespace is LMTS
 and is TEMPORARY  and less than 1% of all sorts has
 been done on disk. I will make sure to check the
 v$locks when this issue appears again. I have changed
 the pcticrease for all the tablespaces to 0% so may be
 this will take care of the issue.

 Gene

 --- Tim Gorman [EMAIL PROTECTED] wrote:
  Tanel hit the nail on the head.  In the past,
  ORA-01575 was usually
  associated with temporary tablespaces that were DMT
  and not tablespace type
  TEMPORARY (which started in Oracle7.3).  First and
  foremost, please make
  sure you are using a TEMPORARY tablespace which is
  locally-managed and uses
  TEMPFILEs...
 
  It might be interesting to monitor V$LOCK for TYPE =
  'ST' to see what
  sessions are holding this enqueue.  If the activity
  is too transient,
  perhaps querying V$SESSION_EVENT where EVENT =
  'enqueue' might indirectly
  imply which sessions have waited on an enqueue (not
  necessarily ST,
  thought!) sometime in the past...
 
 
 
  on 8/13/03 7:04 AM, Tanel Poder at
  [EMAIL PROTECTED] wrote:
 
   Hi!
  
   You can always schedule alter tablespace
  coalesce's during low usage time.
   But you should check whether you have adjacent
  free extents in your
   tablespaces at all? If you're not doing lot's of
  dropping or truncating
   objects, then you shouldn't have. Thus no need for
  coalesce either. Just
   check that all of your sort segments go to the
  temp tablespace (which should
   be in temporary mode, preferrably LMT as well).
  
   Tanel.
  
  
   thanks for the info. We do have a number of DMTS
  in
   the database. Three of them have pct_increase of
  50%,
   the rest - 0. Should I consider changing the
   pct_increase to 0 in all tablespaces in order to
  get
   rid of this ora 1575? Wouldn't I want to have an
   automatic coalesce process for the DMTS though?
  
   thank you
  
   Gene
   --- Tim Gorman [EMAIL PROTECTED] wrote:
   Haven't seen this error since Oracle7...
  
   If the message is hitting the alert.log, then
   chances are good it is
   coming from SMON.  SMON is attempting to acquire
  the
   ST (a.k.a. Space
   transaction) enqueue in preparation for
  coalescing
   free space in some
   tablespaces.  However, if it is unable to
  acquire
   ST after a couple
   seconds, it times out and issues ORA-01575 to
  the
   alert.log.
  
   So, based on experiences from 6-7 years ago:
  
   * do you have a lot of dictionary-managed
   tablespaces?
   * do these DMT's have default PCTINCREASE
   non-zero, thus attacting
 SMON to do coalescing?
  
   If so, I'd suggest going to locally-managed
   tablespaces if at all
   possible...
  
  
  
   on 8/12/03 12:44 PM, Gurelei at
  [EMAIL PROTECTED]
   wrote:
  
   Hi all:
  
   I'm seeing the ora-01575 error in the alert
   logfile.
   The article on the metalink refers to the
   parameter
   which I think is obsolete in the ORacle version
  we
   are
   running (8.1.7). What does this error refer to?
   Any
   thoughts? references?
  
   thanks
  
   gene
  
   __
   Do you Yahoo!?
   Yahoo! SiteBuilder - Free, easy-to-use web site
   design software
   http://sitebuilder.yahoo.com
  
   -- 
   Please see the official ORACLE-L FAQ:
   http://www.orafaq.net
   -- 
   Author: Tim Gorman
 INET: [EMAIL PROTECTED]
  
   Fat City Network Services-- 858-538-5051
   http://www.fatcity.com
   San Diego, California-- Mailing list and
  web
   hosting services
  
  
 
 -
   To REMOVE yourself from this mailing list, send
  an
   E-Mail message
   to: [EMAIL PROTECTED] (note EXACT spelling of
   'ListGuru') and in
   the message BODY, include a line containing:
  UNSUB
   ORACLE-L
   (or the name of mailing list you want to be
  removed
   from).  You may
   also send the HELP command for other information
   (like subscribing).
  
  
   __
   Do you Yahoo!?
   Yahoo! SiteBuilder - Free, easy-to-use web site
  design software
   http://sitebuilder.yahoo.com
   -- 
   Please see the official ORACLE-L FAQ:
  http://www.orafaq.net
   -- 
   Author: Gurelei
 INET: [EMAIL PROTECTED]
  
   Fat City Network Services-- 858-538-5051
  http://www.fatcity.com
   San Diego, California-- Mailing list and
  web hosting services
  
 
 -
   To REMOVE yourself from this mailing list, send
  an E-Mail message

RE: Raid 1 vs Raid 5 for tablespaces

2003-08-14 Thread Matthew Zito



The _only_ even theoretical advantage to software RAID-0 is that software
RAID implementations tend to have more flexibility than the hardware ones.
For example, there are a number of software RAID implementations that allow
you to grow RAID-0 volumes, something that is generally not allowed in
hardware RAID, and most of those allow you to do it online.  Some of the
better software RAID implementations even allow for online volume type
conversion - from RAID-1 to RAID-5 when adding a third disk to a mirrored
pair, as a random example.

Beyond that, there's no reason to have software RAID.  Any other extraneous
advantages can be gleaned by using a traditional VM on top of hardware
RAID-ed devices.  And even some of that stuff is better in hardware. :)

Thanks,
Matt

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

 -Original Message-
 From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On 
 Behalf Of Jared Still
 Sent: Wednesday, August 13, 2003 11:54 AM
 To: Multiple recipients of list ORACLE-L
 Subject: Re: Raid 1 vs Raid 5 for tablespaces
 
 
 
 Tim,
 
 Are you suggesting that HW RAID 1 with SW RAID 0 is a better 
 combination than HW RAID 1 and HW RAID 0?
 
 If so, why?
 
 Jared
 
 On Tue, 2003-08-12 at 21:59, Tim Gorman wrote:
  Software RAID-1 can mirror across controllers, channels, 
 and storage 
  arrays, should any of those be considered a 
 single-point-of-failure...
  
  The combination of HW RAID-1 and SW RAID-0 is optimal for 
 performance, 
  if the HW supports it...
  
  
  on 8/12/03 9:04 PM, Matthew Zito at [EMAIL PROTECTED] wrote:
  
   
   Actually, as of AIX 4.3.3, it does support 0+1 for LVs, but that 
   wasn't the scenario I was imagining.  I was envisioning 
 creating a 
   set of RAID-1 raid groups on the storage array and then striping 
   across them using the LVM. RAID-1 is one of those things 
 that I feel 
   is generally better to let your storage array handle - software 
   RAID-1 requires your host to generate double the I/Os and 
 should one 
   side of the pair fail, hardware arrays tend to recover more 
   gracefully than software raid.  RAID-0, by comparison, is 
 very easy.
   
   Thanks,
   Matt
   
   
   - Original Message -
   To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
   Sent: Tuesday, August 12, 2003 9:44 PM
   
   
   The AIX LVM supports RAID-0 and RAID-1, but not together, as you 
   state.
   
   However, a rude form of RAID-0 can be achieved by specifying max
   allocation
   policy, which will cause round-robin distribution of physical 
   extents
   (PEs)
   across a list of physical volumes (PVs), thereby approximately 
   RAID-0 at a large granularity (i.e. 4M, 8M, 16M per stripe).  
   Still, it beats the
   heck
   out of RAID5...
   
   
   on 8/12/03 12:24 PM, Schauss, Peter at 
 [EMAIL PROTECTED] wrote:
   
   Our hardware people tell me that our disk array will 
 not support 
   Raid
   10.
   Given a choice between Raid 1 or 5 for my tablespaces, 
 which one 
   is best?  This is Oracle 8.1.7 on AIX 4.3.3.  The 
 application will 
   have a mix of read and write activity.
   
   Thanks,
   Peter Schauss
   
   --
   Please see the official ORACLE-L FAQ: http://www.orafaq.net
   --
   Author: Tim Gorman
 INET: [EMAIL PROTECTED]
   
   Fat City Network Services-- 858-538-5051 
 http://www.fatcity.com
   San Diego, California-- Mailing list and web 
 hosting services
   
 ---
   --
   To REMOVE yourself from this mailing list, send an E-Mail message
   to: [EMAIL PROTECTED] (note EXACT spelling of 
 'ListGuru') and in
   the message BODY, include a line containing: UNSUB ORACLE-L
   (or the name of mailing list you want to be removed 
 from).  You may
   also send the HELP command for other information (like 
 subscribing).
   
  
  --
  Please see the official ORACLE-L FAQ: http://www.orafaq.net
  -- 
  Author: Tim Gorman
INET: [EMAIL PROTECTED]
  
  Fat City Network Services-- 858-538-5051 http://www.fatcity.com
  San Diego, California-- Mailing list and web 
 hosting services
  
 -
  To REMOVE yourself from this mailing list, send an E-Mail message
  to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in 
  the message BODY, include a line containing: UNSUB ORACLE-L (or the 
  name of mailing list you want to be removed from).  You may 
 also send 
  the HELP command for other information (like subscribing).
  
 
 
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.net
 -- 
 Author: Jared Still
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- 858-538-5051 http://www.fatcity.com
 San Diego, California-- Mailing list and web hosting services
 -
 To REMOVE yourself from

RE: View question

2003-08-14 Thread Teresita Castro




Thanks for answer me.

The problem that I have is the next, I have to calculate from 
a item transaction table the stock on hand to determinate date, (to made 
different reports).

To do this I made the next query:


SELECT DISTINCT ITEM, SOH_QTY, UPDATE_DATE, 
UPDATE_TIMEFROM ICTRANS 
b1WHERE 
(COMPANY = 2000) AND (LOCATION = 'TJU01') 

and
 
(UPDATE_DATE= 
(SELECT Max(UPDATE_DATE)AS 
FECH_HORA 
FROM 
ICTRANS 
WHERE UPDATE_DATE = to_date('08/01/2003', 'mm/dd/') AND (COMPANY = b1.COMPANY) AND 
(LOCATION = b1.LOCATION) AND (ITEM = 
b1.ITEM) 
GROUP BY 
ITEM))AND(UPDATE_TIME= 
(SELECT MIN(UPDATE_TIME)AS 
HORA 
FROM 
ICTRANS 
WHERE (UPDATE_DATE = b1.UPDATE_DATE) AND (COMPANY 
= b1.COMPANY)AND (LOCATION = b1.LOCATION) AND (ITEM = 
b1.ITEM) 
GROUP BY ITEM))ORDER by ITEM 

Now I have to made a report that have the next 
information: Item, stock on hand , entraces andexits per item in 
determinate period of time. To determinate if is an entrace or exitdepend 
of the sign of the Ictrans.quantity field.

In this example the 08/01/2003 date will be the initial 
date.

This is a new system and maybe we will not have movements on 
the initial date orafter it, so I have to bring the initial inventory from 
another table, ITEMLOC ( item by location) that have the initial inventory of 
the item.

So the query will be something like :

select company,location, item, sum (case when 
quantity0 then quantity else 0 end) exit, sum(case when quantity=0 then 
quantity else 0 end) 
entrace
from ictrans
where company=2000 and location='TJU01' and 
update_date between to_date('08/01/2003','mm/dd/') and 
to_date('08/06/2003','mm/dd/') 
group by company,location, item

Union with the result of the item stock on hand 
(SOH_QTY) of the first query, or in case that this result 
is null, to obtain the stock on hand I have to consult the ITEMLOC 
table

Select item, soh_qty from itemloc where company=2000 
and location='TJU01'

I hope I made my self clear and you undestand my 
explaination. What I want to do it a view(vw_stockonhand) to obtain the initial 
inventory then made a left join to the ictrans table, so in case that I don't 
have movements on the initial date or after it returns me a null, and another 
left join with the Itemloc, so if vw_stockonhand is null I get the 
itemloc.soh_qty.

Thanks for you time

RE: oracle 9 IAS

2003-08-14 Thread April Wells

none out yet. Don Burleson is supposed to have one out on Oracle
Press in November... don't know how beginner it will be, but I think it is on
Amazon.

April Wells Oracle DBA/Oracle Apps DBA Corporate Systems Amarillo Texas
Few people really enjoy the simple pleasure
of flying a kite Adam Wells age
11

-Original Message-From: AK
[mailto:[EMAIL PROTECTED]Sent: Wednesday, August 06, 2003 12:04
PMTo: Multiple recipients of list ORACLE-LSubject:
oracle 9 IAS
Any good book on oracle 9iAS for beginners which
covers installation , configurations etc .
There is too much in oracle docs .

-Ak

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

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

RE: It's an Oracle Fun Friday!

Just looking at netcraft.com to see what Oracle's
running these days, when I
noticed their netblock is owned by Oracle
Datenbanksysteme GmbH.  German
Oracle

First move before the SAP AG hostile takeover bid?

Regards,

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

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

RE: quick suggestions for tuning ?

Prem
   Head for http://www.hotsos.com and study their documents. Cary Millsap,
who is kind enough to participate on this list, has identified LIO as a key
performance issue.

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


-Original Message-
Sent: Monday, August 11, 2003 10:00 AM
To: Multiple recipients of list ORACLE-L


Thanks a lot Connor.
Apart from bind vars.,LIO is a big issue here.

54 million consistent gets.
does it mean that db_cache_size (700M) is small ?

any good docs or links regarding LIO and how to deal with it ?
 
Can u explain me Connor ?

Regards,
Jp.


From: Connor McDonald [EMAIL PROTECTED]
Subject: Fwd: Re: quick suggestions for tuning ?
Date: 10-08-2003 23:44:25
Its not really rocket science here...
CPU is at the top of the timed event - and what causes
CPU (or is the most common cause) - logical I/O.  54
million consistent gets later down in the report
probably a bit of a giveaway there :-)
Next section in the report is some nice queries that
use up 4 or so million buffer gets.  Good ones to
start with...  As you've already noticed, no bind
variables.
Then some other miscellaneous things - look at how
much free memory you have in most of your pools SGA
breakdown difference - might be able to use that
better elsewhere.
cheers
connor



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

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

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

Re: What books recommended for Data Modeling ?

2003-08-14 Thread Dilip Patel





Hi All, 
Need some suggestions/Input.

My application database is 8.1.7, NOARCHIVELOG, WIN200, total size 4 
GB, more of single user OLTP client-server application. Now the customer 
wants to give training on this application to hundred trainees at a time. 
For this he wants to install hundred database instances on same server 
machine, which *each* will be accessed simultaneously from 100 different 
client workstations. The reasons for installing all instances on 
same machine are - to avoid re-installing databases on 100 workstations 
after each round of training.- No user should see any other user's data. 
Please suggest if this approach is feasible or is it at all 
possible.Tested this with upto 5 instances, and it seems to work. The 
customer is willing to upgrade to any hardware needed for this setup. 
Thanks in advance for your time.Dilip.

RE: Can't insert into partition

Wolfgang
   Thank you so much! You spotted something that we had overlooked! The
dot/comma was indeed the problem. And thanks to you and everyone else for
the help that helped narrow the problem down to this point.
   It seems that as you pointed out, the hint had a syntax error all along,
but CBO was making a good decision anyway for awhile, then for some reason
didn't make a good decision anymore.

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


-Original Message-
Sent: Thursday, August 07, 2003 5:49 PM
To: Multiple recipients of list ORACLE-L


No, you can put a hint in inner sql and subselects. Some hints you NEED to 
put on a subselect to make any sense.
Is that sql verbatim? The hint has a syntax error. There is a dot rather 
than a comma after ps which - pooof - may turn the princely hint into an 
ugly toad (no pun intended) comment.
Another thnig you can try, since you are using bind variables, is to jack 
up db_file_multiblock_read_count, hash_multiblock_io_count, hash_area_size, 
optimizer_index_cost_adj (to 1), create a stored outline of the sql - 
hopefully it will use hash joins with all the help, and then revert to the 
normal init_ora settings and tell oracle to use the stored outline.

At 02:19 PM 8/7/2003 -0800, you wrote:
Thanks Wolfgang! And thanks to the others who have helped us unravel this
problem.
Your suggestion put us on the right track. I started running a SQL
trace/tkprof, and lo and behold, when the stored procedure submits the SQL,
CBO does everything as NESTED LOOPS. The next question is how to induce CBO
to consider HASH JOIN?
The original query had USE_HASH hints on the subqueries. Somewhere I
thought I recalled that you could only put hints on the outer SQL statement
-- is that true? So we tried adding the USE_HASH hint to the overall INSERT
statement, to no effect. Here is the relevant portion of the tkprof output.
Thanks again to eveyone.

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

INSERT /*+ APPEND use_hash(CJS, PS, APC, MD, C, WV1, WV)  */INTO
CURRJOBFACT
   NOLOGGING ( JOBNBR,SOURCEFISCALYEAR,LIFETOUCHID,PROGRAMID,MARKETINGCODE,

PLANTRECEIPTDATE,PHOTOGRAPHYDATE,SHIPDATE,SELLINGMETHODCODE,MDRPRIMARYID,
   SUBPROGRAMCODE,TERRCODE,SUBTERRCODE,BIDIND,PDKIND,PDKPARTNBR,RETAKEIND,

RETAKENBR,SHIPPEDJOBIND,PAIDJOBIND,PAYSTATUSIND,PAIDSHIPPEDJOBIND,PREJOBIND
,
   PLANTCODE,SHOTQTY,MTDSHIPPEDPKGQTY,MTDCHARGEBACKAMT,MTDTERRCMSNAMT,

MTDTERREARNINGSAMT,MTDCASHRECEIVEDAMT,MTDCASHRETAINEDAMT,MTDESTACCTCMSNAMT,
   MTDACCTCMSNPAIDAMT,MTDGROSSCASHAMT,MTDSALESTAXAMT,YTDSHIPPEDPKGQTY,
   YTDCHARGEBACKAMT,YTDTERRCMSNAMT,YTDTERREARNINGSAMT,YTDCASHRECEIVEDAMT,
   YTDCASHRETAINEDAMT,YTDESTACCTCMSNAMT,YTDACCTCMSNPAIDAMT,YTDGROSSCASHAMT,
   YTDSALESTAXAMT,YTDPERFECTSALEAMT,PRELIMYTDSHIPPEDPKGQTY,
   PRELIMYTDCHARGEBACKAMT,PRELIMYTDTERRCMSNAMT,PRELIMYTDTERREARNINGSAMT,

PRELIMYTDCASHRECEIVEDAMT,PRELIMYTDCASHRETAINEDAMT,PRELIMYTDESTACCTCMSNAMT,
   PRELIMYTDACCTCMSNPAIDAMT,PRELIMYTDGROSSCASHAMT,PRELIMYTDSALESTAXAMT,
   PRELIMYTDPERFECTSALEAMT,YTDJTEPAIDPKGQTY,YTDPAIDPKGQTY,YTDUNPAIDPKGQTY,
   YTDXNOPURCHASEQTY,PRELIMYTDPAIDPKGSHIPQTY,PRELIMYTDUNPAIDPKGSHIPQTY,

PROOFPOSEQTY,PROOFCOUNTQTY,EXTRACTDATE,ORIGINALRECEIVEDDATE,CMSNSTATUSCODE,
   FIRSTPOSITIVECASHDATE,RENEWALSTATUSCODE,ORIGESTACCTCMSNAMT,AVGPKGPRICE )
   SELECT /*+ use_hash(cjs, ps. md, a, o, x, wv, apc, wv1)  */CJS.JOBNBR,
 (columns omitted)
   PS.PRELIMYTDESTACCTCMSNAMT)) ORIGESTACCTCMSNAMT,APC.AVGPKGPRICE   FROM
   CURRJOB_STAGE CJS,PERIOD_STAGE PS,MARKETINGDIM MD,(SELECT A1.JOBNBR,
   DECODE(SUM(PAIDOFFERQTY),0,0,SUM(A1.OFFERPRICEAMT * A1.PAIDOFFERQTY ) /
   SUM(A1.PAIDOFFERQTY) ) AVGPKGPRICE   FROM (SELECT DISTINCT A.JOBNBR,
   A.OFFERNAME,A.PAIDOFFERQTY,A.OFFERPRICEAMT   FROM OFFERLOAD_STAGE A
WHERE
   A.OFFERNAME IN ( 'A','B','C','D','E','F','G','H','I','J','K'  )) A1
GROUP
   BY A1.JOBNBR ) APC,(SELECT DISTINCT C.LIFETOUCHID,C.PROGRAMID,
   MD.MARKETINGCODE   FROM CURRJOBFACT C,MARKETINGDIM MD  WHERE
   C.SOURCEFISCALYEAR  :b1  AND C.MARKETINGCODE = MD.MARKETINGCODE ) C,
   (SELECT JOBNBR,MIN(DEPOSITDATE) FIRSTPOSITIVECASHDATE   FROM CASHTXNFACT
   WHERE SOURCEFISCALYEAR = :b1  GROUP BY JOBNBR ) WV1,(SELECT X.JOBNBR,
   X.WEEKENDDATE,X.PRELIMYTDESTACCTCMSNAMT   FROM WKLYJOBFACT X,(SELECT
JOBNBR,
   MAX(WEEKENDDATE) MAXWEEKENDDATE   FROM WKLYJOBFACT  WHERE
SOURCEFISCALYEAR
=
:b1  AND NVL(PRELIMYTDESTACCTCMSNAMT,0)  0  GROUP BY JOBNBR ) W1
WHERE
   X.JOBNBR = W1.JOBNBR  AND X.WEEKENDDATE = W1.MAXWEEKENDDATE ) WV  WHERE
   CJS.JOBNBR = PS.JOBNBR (+)AND CJS.JOBNBR = APC.JOBNBR (+)AND
   CJS.MARKETINGCODE = MD.MARKETINGCODE  AND CJS.LIFETOUCHID =
C.LIFETOUCHID
   (+)AND CJS.MARKETINGCODE = C.MARKETINGCODE (+)AND CJS.JOBNBR =
   WV1.JOBNBR (+)AND CJS.JOBNBR = WV.JOBNBR (+)



call count   cpuelapsed   disk  querycurrent
rows
--- --   -- -- -- --
--
Parse

RE: [stupid] vi question

2003-08-14 Thread Cary Millsap

If you're using Vim, it's ^q instead of ^v:

:%s/^v^M//g -- vi
:%s/^q^M//g -- Vim


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

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


-Original Message-
Nelson Flores
Sent: Wednesday, August 06, 2003 12:35 PM
To: Multiple recipients of list ORACLE-L

Two ways
1. :s/^M//g (where the ^M is CTRL-V M)
2. dos2unix inputfile  outputfile



-Mensaje original-
De: Saira Somani-Mendelin [mailto:[EMAIL PROTECTED] 
Enviado el: miércoles, 06 de agosto de 2003 13:09
Para: Multiple recipients of list ORACLE-L
Asunto: OT: [stupid] vi question

Suddenly my vi editor is showing ^M at the end of each line. How do I
get rid of it?

Thanks in advance,
Saira


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

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

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


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

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

RE: Downloading patchests from Metalink

2003-08-14 Thread Willett, Mark

Title: Message









I just downloaded a patch a few minutes
ago from oracle-updates-west.conxion.com - no problem.





Mark



Mark
Willett

Corporate Database Administrator

-

The statements and
opinions expressed here are my own and do not

necessarily reflect
those of Sunnen Products Company. In addition, this

communication,
including any attachments, may contain confidential

information and is
intended only for the individual or entity to whom it is

addressed. Any
review, dissemination, or copying of this communication

in part or in whole by
anyone other than the intended recipient is strictly 

prohibited. If
you are not the intended recipient, please contact the sender

by reply email and
delete and destroy all copies of the original message.





-Original Message-
From: Mladen Gogala
[mailto:[EMAIL PROTECTED] 
Sent: Tuesday, August 05, 2003
11:40 AM
To: Multiple recipients of list
ORACLE-L
Subject: Downloading patchests
from Metalink





Has anybody been able to download a
patch from Metalink? I'm getting an error saying that





The opration timed out
when attempting to contact oracle-updates-west.conxion.com.





Did oracle subcontract their
downloading facilities to Iraq or Afganistan? This host has been





refusing any contact with me
fortwo days now. 









--
Mladen Gogala
Oracle DBA 















Note:





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





Any views expressed in this message are those of the
individual sender, except where the message states otherwise and the sender is
authorized to state them to be the views of any such entity.

RE: URGENT: Trying to duplicate database from cold backup - auxi

2003-08-14 Thread Jack van Zanen

Title: Message






Hi Paula

Another issue you may encounter is that duplicate in 
8.1.7may not work w/o a "set until" clause see bug 2329702


Jack

-Original Message-From: 
[EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 
Sent: Monday, August 04, 2003 11:09 PMTo: Multiple 
recipients of list ORACLE-LSubject: RE: URGENT: Trying to duplicate 
database from cold backup - auxi

  This 
  is the type of script I am using:
  
  rman 
  EOFconnect target rman/[EMAIL PROTECTED]connect catalog 
  rman/[EMAIL PROTECTED]connect auxiliary sys/[EMAIL PROTECTED]run 
  {resync catalog;allocate auxiliary channel d1 type disk;allocate 
  auxiliary channel d2 type disk;set newname for datafile 
  '/data/oracle8/TEST2/systemTEST2.dbf' TO 
  '/data/oracle8/TEST3/systemTEST3.dbf';set newname for datafile 
  '/data/oracle8/TEST2/rbsTEST2.dbf' TO 
  '/data/oracle8/TEST3/rbsTEST3.dbf';set newname for datafile 
  '/data/oracle8/TEST2/tempTEST2.dbf' TO 
  '/data/oracle8/TEST3/tempTEST3.dbf';set newname for datafile 
  '/data/oracle8/TEST2/dataTEST2.dbf' TO 
  '/data/oracle8/TEST3/dataTEST3.dbf';sql 'alter system switch 
  logfile';duplicate target database to 
  test3LOGFILE'/data/oracle8/TEST3/redoTEST301.log' size 
  1M,'/data/oracle8/TEST3/redoTEST302.log' size 
  1M,'/data/oracle8/TEST3/redoTEST303.log' size 
  1M;}EOF
  
-Original Message-From: Stankus, Paula G 
Sent: Monday, August 04, 2003 4:12 PMTo: 
'[EMAIL PROTECTED]'Subject: RE: URGENT: Trying to duplicate 
database from cold backup - auxiliary database not mounted 
error!!!
Guys,

When trying to duplicate database with this 
script


I 
have my auxiliary setup as new database, target setup as old database and am 
using duplicate database command along with logfile command to create new 
logfiles. 



Get error:


RMAN-06136: ORACLE error from auxiliary database: ORA-01507: database not 
mounte
d

Re: How to tell Oracle the directories of script files

2003-08-14 Thread Reginald . W . Bailey


Yes there is a way.  In UNIX environments (I think this works in NT/2000 as
well) you can set the environment variable SQLPATH to a list of directories
that contain SQL files.  SQLPlus will search this path if the file is not
found in the current directory.

RWB



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



   
  
[EMAIL PROTECTED]  

ys.utk.eduTo: [EMAIL PROTECTED]
   
Sent by:  cc:  
  
[EMAIL PROTECTED]   Subject: How to tell Oracle the 
directories of script files
om 
  
   
  
   
  
08/14/2003 01:09 PM
  
Please respond to  
  
ORACLE-L   
  
   
  
   
  





Hello,
Suppose I have some SQL scripts in my /home/user directories,
/usr/local/bin
directories, etc.
If I start 'sqlplus' from console in /home/user directories, I can
load/execute the script by doing:
SQL @scriptname

But what if I don't start sqlplus from that directories? How do I tell
Oracle
to find the scripts in /home/user, then if it's not there in
/usr/local/bin,
for example? So that I can be anywhere in the filesystem when starting
sqlplus and can execute my SQL script.

Just like the $PATH environment variables in *nix system that tell the
shell
where to find executables, is there a similar thing for Oracle?

Thanks for any help.

RDB

--
Reuben D. Budiardja
Department of Physics and Astronomy
The University of Tennessee, Knoxville, TN
-
/\  ASCII Ribbon Campaign against HTML
\ /  email and proprietary format
 X   attachments.
/ \
-
Have you been used by Microsoft today?
Choose your life. Choose freedom.
Choose LINUX.
-

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

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




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

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

Title: Message

yep,
ftp to update.oracle.com. Login with your metalink credentials and cd to
the patch directory using the number with no p on the prefix. That has
worked for me today.

Allan

-Original Message-From: Mladen Gogala
[mailto:[EMAIL PROTECTED] Sent: Tuesday, August 05, 2003
11:40 AMTo: Multiple recipients of list ORACLE-LSubject:
Downloading patchests from Metalink
Has anybody been
able to download a patch from Metalink? I'm getting an error saying
that
"The
opration timed out when attempting to contact
oracle-updates-west.conxion.com".
Did oracle
subcontract their downloading facilities to Iraq or Afganistan? This host has
been
refusing any
contact with me fortwo days now.

--Mladen GogalaOracle DBA

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

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

RE: 100 instances on same server !!!

2003-08-14 Thread Jamadagni, Rajendra




We 
have about 35 instances on each node of RAC they are of course DEVL/ACPT 
types.

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

  -Original Message-From: Dilip Patel 
  [mailto:[EMAIL PROTECTED]Sent: Thursday, August 07, 2003 6:54 
  PMTo: Multiple recipients of list ORACLE-LSubject: Re: 
  100 instances on same server !!!
  
  Thanks for the replies so far. Considering the fact that my database is 
  tiny ( just around 3 GB ), How many of them can work on same server? I can 
  just test with 5 instances, with limited hardware. Will the CPUs be able to 
  take load of 100 instances? Is it worth experimenting this? 
  
  I am on 8.1.7.4 and the application is already built. I stand no chance 
  of changing the code. That is why using individual schemas for individual 
  users is not an option. Right now I am just asked if 100 instances can run on 
  same server and I don't have solid answer. 
  
  Just on side note, canI ask, What is the maximum number of 
  instances anyone has ever worked/heard being installedwith in same 
  server? 
  
  Thanks again.
  
  Dilip.
  
- Original Message - 
From: AK 
To: Multiple recipients of list ORACLE-L 

Sent: Thursday, August 07, 2003 11:54 
AM
Subject: Re: What books recommended for 
Data Modeling ?
100 instances woh . If you are in 9i look at 
possibilities like contextor label security . or creating another schema 
.-ak- Original Message - To: "Multiple 
recipients of list ORACLE-L" [EMAIL PROTECTED]Sent: 
Wednesday, August 06, 2003 9:24 PM I have not heard 
installing hundred database instances on same server. Maybe you 
should think creating one instance, and then hundred schemas in 
it. Guang On Wed, 6 Aug 2003, Dilip Patel 
wrote:  Hi All,  Need some 
suggestions/Input.   My application database is 
8.1.7, NOARCHIVELOG, WIN200,  total size 4 GB, more of single 
user OLTP client-server application.   Now the 
customer wants to give training on this application to 
hundredtrainees  at a time. For this he wants to install 
hundred database instances onsame  server machine, 
which *each* will be accessed simultaneously from 100different 
 client workstations.   The reasons for 
installing all instances on same machine are  - to avoid 
re-installing databases on 100 workstations after each roundof 
 training.  - No user should see any other user's 
data.   Please suggest if this approach is feasible 
or is it at all possible.Tested this with upto 5 instances, and 
 it seems to work. The customer is willing to upgrade to any 
hardwareneeded for  this setup.   
Thanks in advance for your time.   Dilip. 
 --  Please see the official ORACLE-L FAQ: http://www.orafaq.net --  
Author: Guang Mei INET: [EMAIL PROTECTED] Fat City 
Network Services -- 858-538-5051 http://www.fatcity.com San Diego, 
California -- Mailing list and web 
hosting services 
- 
To REMOVE yourself from this mailing list, send an E-Mail message 
to: [EMAIL PROTECTED] (note 
EXACT spelling of 'ListGuru') and in the message BODY, include a 
line containing: UNSUB ORACLE-L (or the name of mailing list you 
want to be removed from). You may also send the HELP command 
for other information (like subscribing).-- Please see the 
official ORACLE-L FAQ: http://www.orafaq.net-- Author: 
AK INET: [EMAIL PROTECTED]Fat City 
Network Services -- 858-538-5051 http://www.fatcity.comSan Diego, 
California -- Mailing list and web 
hosting 
services-To 
REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT 
spelling of 'ListGuru') and inthe message BODY, include a line 
containing: UNSUB ORACLE-L(or the name of mailing list you want to be 
removed from). You mayalso send the HELP command for other 
information (like 
subscribing).
*This e-mail 
message is confidential, intended only for the named recipient(s) above and may 
contain information that is privileged, attorney work product or exempt from 
disclosure under applicable law. If you have received this message in error, or are 
not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 
and delete this e-mail message from your computer, Thank 
you.*1

RE: Off Topic Question - Update.inf file


How could they not tell the difference?  Windows runs MechWarriors; Linux
doesn't.  What more is there to know?

 -Original Message-
 someone had installed linux on the laptop with dual boot 
 defaulted to linux
 running gnome.  and he couldn't tell the difference.  boot 
 into windows and
 every thing works fine.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Stephen Lee
  INET: [EMAIL PROTECTED]

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

Re: quick suggestions for tuning ?

2003-08-14 Thread M Rafiq

Yes, I agree.

Regards
Rafiq


Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Date: Tue, 12 Aug 2003 22:19:23 -0800
quote
You poor guy. Try to bring some guy with you who can speak English and
Japanese to resolve ths communication problem. in 1993 when I was working in
Tokyo for 10 days in my ex-employer office and having problem with Harware,
the Japanese Engineer was brining one Bangadeshi guy to communicate with me
in English and it worked just fine.
/quote
Rafiq,it doesn't work the same way everywhere yaar.
Bringing a guy just for translation is nearly impossible here.
i know some japanese and i try to manage with that.
even if u know Japanese,it's not a cake walk to convince a japanese.
Client's vary  their attitude varies.
Do u agree with me ?!
Regards,
Jp.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Prem Khanna J
  INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
_
STOP MORE SPAM with the new MSN 8 and get 2 months FREE*  
http://join.msn.com/?page=features/junkmail

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

RE: Referencing other schemas' tables in PL/SQL procedure

2003-08-14 Thread Paul Vincent

Naveen - many thanks! I had a vague recollection that this may be the case, rattling 
around in the back of my mind, but I couldn't find confirmation in the manuals. Thanks 
for the definitive answer! It's an annoying restriction, but now we can cope with it!

Paul

-Original Message-
Sent: 12 August 2003 13:06
To: Multiple recipients of list ORACLE-L


Any privileges granted through roles are not enabled in PL/SQL procedures.

You need to have the privilege granted directly not through a ROLE.

Regards
Naveen

-Original Message-
From: Paul Vincent [mailto:[EMAIL PROTECTED]
Sent: Tuesday, August 12, 2003 5:29 PM
To: Multiple recipients of list ORACLE-L
Subject: Referencing other schemas' tables in PL/SQL procedure


Hi,

one of our developers is having a problem. His userid has 
the DBA role on a test database, and he's written a PL/SQL 
procedure, in his schema, which is referencing (via SELECT) 
and updating a table in another schema, so he's coding the select as:

  CURSOR c1
   IS
  select distinct ORIG_MODULE
 from QLDBA.GENTRAN
 where TRANS_DT = to_date('15/07/2003','dd/mm/');

...however, when he tries to compile the procedure, he gets 
several error messages including:

Line # = 16 Column # = 11 Error Text = PLS-00201: identifier 
'QLDBA.GENTRAN' must be declared


Now, the table GENTRAN certainly exists in the QLDBA schema, 
so there must be some rule being broken here. I thought 
anyone with the DBA role could do any DML on any table in 
any schema? Indeed, when the guy runs the select in a 
SQL*Plus window, it works fine, so can any PL/SQL guru shed 
some light on this? My PL/SQL skills are pretty rudimentary, 
and a rummage through the PL/SQL User Guide didn't turn 
anything up...

Hope someone can help!

Regards,

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

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



DISCLAIMER:
This message (including attachment if any) is confidential and may be privileged. 
Before opening attachments please check them for viruses and defects. MindTree 
Consulting Private Limited (MindTree) will not be responsible for any viruses or 
defects or any forwarded attachments emanating either from within MindTree or outside. 
If you have received this message by mistake please notify the sender by return  
e-mail and delete this message from your system. Any unauthorized use or dissemination 
of this message in whole or in part is strictly prohibited.  Please note that e-mails 
are susceptible to change and MindTree shall not be liable for any improper, untimely 
or incomplete transmission.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Naveen Nahata
  INET: [EMAIL PROTECTED]

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

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

RE: URGENT: Trying to duplicate database from cold backup - auxi

  I would be interested how other sites that rely on RMAN handle this 
issue.

I for one, don't use RMAN for that.  It's too much work.

There's a separate project for verifying backups. 

The databases I'm called on to duplicate have lately been 400-500
gigs, more than I want to pull from tape unless absolutely necesssary.

It's much faster to plug two servers into a gigabit switch and
copy the files across a private network at approx 100 gigabytes
per hour.

Jared






DENNIS WILLIAMS [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
 08/05/2003 02:59 PM
 Please respond to ORACLE-L

 
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc: 
Subject:RE: URGENT:  Trying to duplicate database from cold backup - 
auxi


Robert - What I've done over the years is tie the creation of test 
databases
to backup verification. The old issue of how can you trust your backups
unless you've done a recovery. It has seemed that I get a request to build 
a
test database at about the right interval to periodically verify the 
backup.
It is nice to say that I would just periodically verify the backups, but
like most DBAs, there is always a more pressing task.
   With RMAN, I assumed that I would continue this practice. It has been a
pain, but I ended up with a method that works. The biggest problem is that
when the test database is recovered, it initially has the same name as the
production database, then I change the name.
   I would be interested how other sites that rely on RMAN handle this
issue.
also send the HELP command for other information (like subscribing).



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

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

Re: More On 10G

2003-08-14 Thread Nuno Souto

no please!  Do NOT light a match

Cheers
Nuno Souto
[EMAIL PROTECTED]
- Original Message - 

 Sure smells like an IBM SP2 environment to mesomeone light a match or
 open a windowplease


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

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

ORA-3113

2003-08-14 Thread Avnish.Rastogi

Applied 250 OS patches on HP-UX 11.11 server and after that getting ORA-3113 error 
message every time I do svrmgrl or sqlplus /nolog connect /as sysdba. This database 
holds RMAN catalog for more than 30 databases and really very critical. Please share 
your ideas.

I already tried to relink and rebooting the server.

Database is 816 64bit on HP-UX 11.11



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

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

RE: last column in a table is added with a DEFAULT

2003-08-14 Thread Guang Mei

Title: RE: last column in a table is added with a DEFAULT



See the test 
below:

[EMAIL PROTECTED] create table t1 (c1 
number);Table created.[EMAIL PROTECTED] insert into t1 (c1) 
values (1);1 row created.[EMAIL PROTECTED] insert into t1 (c1) 
values (2);1 row created.

[EMAIL PROTECTED] 
commit;Commit complete.[EMAIL PROTECTED] select * from 
t1; 
C1-- 
1 2[EMAIL PROTECTED] alter table t1 add (c2 
number default 999);Table altered.[EMAIL PROTECTED] select * from 
t1; 
C1 C2-- 
-- 
1 
999 
2 999


  -Original Message-From: [EMAIL PROTECTED] 
  [mailto:[EMAIL PROTECTED]On Behalf Of Ehresmann, 
  DavidSent: Thursday, August 07, 2003 3:09 PMTo: Multiple 
  recipients of list ORACLE-LSubject: RE: last column in a table is 
  added with a DEFAULT
  I 
  understand that part. What the programmer is saying that you can not add 
  the last column to a table with a default value. Does that sound 
  reasonable?
  thanks, Raj.
  David.
  
-Original Message-From: Jamadagni, Rajendra 
[mailto:[EMAIL PROTECTED]Sent: Thursday, August 07, 
2003 1:25 PMTo: Multiple recipients of list 
ORACLE-LSubject: RE: last column in a table is added with a 
DEFAULT
as soon as you add a column all depending code goes invalid, 
the dependency checking process doesn't discriminate about the default 
value.
Raj  
Rajendra dot Jamadagni at nospamespn dot com 
All Views expressed in this email are strictly 
personal. QOTD: Any clod can have facts, having an 
opinion is an art ! 
-Original Message- From: 
Ehresmann, David [mailto:[EMAIL PROTECTED]] 
Sent: Thursday, August 07, 2003 1:09 PM To: Multiple recipients of list ORACLE-L Subject: last column in a table is added with a DEFAULT 

Has anybody ever heard of this? I have a developer 
saying this is an oracle bug. It caused some 
packages to go invalid. 
"The error seems to be related to a bug in oracle caused 
when the last column in a table is added with a 
default." 
David Ehresmann 
-- Please see the official ORACLE-L 
FAQ: http://www.orafaq.net -- Author: Ehresmann, David  INET: [EMAIL PROTECTED] 
Fat City Network Services -- 858-538-5051 
http://www.fatcity.com San Diego, California -- 
Mailing list and web hosting services - 
To REMOVE yourself from this mailing list, send an E-Mail 
message to: [EMAIL PROTECTED] (note EXACT 
spelling of 'ListGuru') and in the message BODY, 
include a line containing: UNSUB ORACLE-L (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 -- Boston Globe job listings