Re: Upgrading to Oracle 9.2.0.4 - Any pitfalls?

[Brian_P_MacLean]

I have said it on this list before, and I will say it again.  With Oracle,
quality ends with in 4.

  7.3.4
  8.1.7.4
  9.2.0.4

Oracle v9.2.0.4 is fairly stable.  I have had to apply only 1, one-off
patch related to having 1000's of partitions.  You may also want to add the
following to your init.ora to prevent a few known bug's

serial_reuse = disable
event  = "10235 trace name context forever, level 2"




   
 
  "Jones, Richard  
 
  O."  To:   Multiple recipients of list 
ORACLE-L <[EMAIL PROTECTED]>
Subject:  Upgrading to Oracle 9.2.0.4 - 
Any pitfalls?
  Sent by: 
 
  [EMAIL PROTECTED]
 
  .com 
 
   
 
   
 
  12/21/2003 09:29 
 
  PM   
 
  Please respond to
 
  ORACLE-L 
 
   
 
   
 




Hi,


Our main production database was upgraded to Oracle 9.2.0.3 (64 bit) at the
end of September 2003. Platform Solaris 64bit 5.8.


Since then the database has "hanged" and had to be manually shutdown by
killing processes and re-started: -


(1) The first one involved the production of numerous:
ORA-04031: unable to allocate 26168 bytes of shared memory ("shared
pool","unknown object","sga heap(1,0)","session param values") ,
errors when users were logging and was linked by Oracle Support with bug
number 2921201


(2) Secondly, the database raised an ORA-600 to the alert file:
ORA-00600: internal error code, arguments: [510], [0x380068B30], [shared
pool], [], [], [], [], [] ,
followed by numerous messages:
PMON failed to acquire latch, see PMON dump ?


(3) Thirdly, an:
ORA-04031: unable to allocate 16384 bytes of shared memory ("shared
pool","unknown object","sga heap(1,0)","trace buffer")
was raised apparently caused by an Oracle background processes dieing
unexpectedly.





Should I upgrade to 9.2.0.4? None of the above problems seem to be fixed in
9.2.0.4!!!


Our database is a hybrid between OLTP and Decision-Support with a
relatively light load.


Anyone out there with an unstable 9i database (we were more stable under
8.1.7)? Am I alone??


Many Thanks


Richard Jones, DBA








-- 
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: OS Level Defrag

[Brian_P_MacLean]

Sorry can't help with the "when did it happened" question.

But in defense of the SysAdmin, I have seen the benefits of defraging on
both Unix and NT.

In the NT case the defraging was caused by lots of small fragments caused
by the datafile being auto extended in short increments, and that being
mixed on the same file system with other file updates/additions/deletes.

In the Unix case, I was doing a lot of restores to a testing system.  When
I did the restores I had 5 or 6 uncompress commands outputting to the same
/u mount point.  After doing this my wio times when through the roof.  On
the next restore I restricted my restore to one uncompress at a time to
each of my /u mount points ... the wio problem went away.

The last point I'd like to make is "trust no one" with your data.  Always
sum and/or cksum files before and after moving them around (there are gnu
versions of these commands for non Unix systems).  And 3 last words -
backup backup backup.




   

  "Sujatha Madan"  

  <[EMAIL PROTECTED]To:   Multiple recipients of list 
ORACLE-L <[EMAIL PROTECTED]>   
  tus.net.au>  cc: 

  Sent by: Subject:  OS Level Defrag   

  [EMAIL PROTECTED]

  .com 

   

   

  11/27/2003 06:59 

  PM   

  Please respond to

  ORACLE-L 

   

   





Hi,

Does anyone here do an O/S level defrag of their Oracle filesystems???

Background: (Tru64/8.1.7.4)

Sysadmin here were adamant that the Oracle domains were running out of
extents and were highly fragmented (O/S level). DBA was adamant that the
Oracle filesystems should not be defragmented. I lost the battle and the
sysadmins are defragging the domains.

I now have a corruption on a table partition with 100 million plus rows on
a 50G datafile. I am wondering if the defrag has caused this corruption.

The only way I can think of finding out is:

Finding the approx date of the corruption using the query
SELECT ROWID,  from ;
(which will do the full tablescan row by row).

And then finding when the defrag utility was hitting the particular
datafile that is corrupted.

But this reasoning is flawed 

Does anyone have another method of trying to pinpoint if the O/S defrag
caused the corruption

Regards,

Sujatha





-- 
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: SUN question

[Brian_P_MacLean]

It's hard to explain this better than the man page.  It's short sweet and 2
the point.  But alas, I'll try anyway.

Define RAM -> http://www.techweb.com/encyclopedia/defineterm?term=ram

  A group of memory chips, typically of the dynamic RAM (DRAM) type,
  which function as the computer's primary workspace.

Define virtual memory ->
http://www.techweb.com/encyclopedia/defineterm?term=virtual++memory

  Simulating more memory than actually exists, allowing the computer to
run
  larger programs or more programs concurrently. It breaks up the
program
  into small segments, called "pages," and brings as many pages into
memory
  that fit into a reserved area for that program. When additional pages
are
  required, it makes room for them by swapping them to disk. It keeps
track of
  pages that have been modified, so that they can be retrieved when
needed again.

Define "total size of the process" -> http://www.from_my_brain.dmp

  This is EVERYTHING it takes to run your program.  The code, the
process stack,
  variables, device drivers, shared libraries, memory mapped files (see
"man -a mmap"),
  shared memory segments (see "man -a shmget") and all other IPC type
of communications.
  The key word is EVERYTHING.

Remember that all Oracle processes are sharing the same shared memory
segment so they are all charged, or appear bigger in total size, because of
that.   So what it all comes down to is that on Unix machines that are
running an Oracle database the "SIZE" column means just about squat.  Even
the more important ps command output column "RSS" is toast for database
processes.

So now you want to know what the "RSS" column is right.  It stands for
"resident set size" and is defined as "The amount of physical memory
allocated to a process" (see RAM).

The ps command output is good for most non Oracle processes and non Java
Server Processes (don't ask).  But now you are still trying to answer the
question your boss asked, "How much memory is Oracle using on this server".
If you are on Sun Solaris then the answer is only a click away  (scroll
down a bit and look for the script under "Calculate actual memory usage")
-> http://renko.org/info/ora816/solaris.816/a77184/ch1.htm#39824

If you are on anything else, then a SWAG ( see the first definition -
http://www.acronymfinder.com/af-query.asp?String=exact&Acronym=swag&Find=Find)
 will have to do.


Whew!!






   

  Jerome Roa   

  <[EMAIL PROTECTED]To:   Multiple recipients of list 
ORACLE-L <[EMAIL PROTECTED]>   
  u>   cc: 

  Sent by: Subject:  SUN question  

  [EMAIL PROTECTED]

  .com 

   

   

  11/25/2003 08:34 

  AM   

  Please respond to

  ORACLE-L 

   

   





Does anybody know what the SZ is represents(SUN SOLARIS)

ps -efly | egrep 'ora|SZ'

bach#   ps -efly | egrep 'oracle|SZ'
  S  UID   PID  PPID  C PRI
NI   RSS SZ   WCHANSTIME TTY  TIME CMD
  S   oracle 27845 1  0  77 20596552 617600? 02:00:04
?0:26 oracleTRACS (DESCRIPTION=(LOCAL=no)
  S   oracle 27169 1  0  51 20599536 631296? 23:14:36
?0:53 oracleTRACS (DESCRIPTION=(LOCAL=no)
  S   oracle  521 1  0  53 202968   9528?   Oct 04
? 1:30 /dbopt/app/oracle/p

Re: UNIX OT: exclude files in tar

[Brian_P_MacLean]

Just another excuse to read the tar man page.  This series of commands
seamed to work in testing.  Note the "excluded" and "OK" on the tar command
output.  As the tar man page states, be careful on the leading and trailing
spaces in the exclude file. As with most Unix commands,  DON'T use a "-" in
the exclude file name, doing so will lead you to question your own sanity
when things just don't seam to work right.

mkdir -p level.1/level.2.1/level.2.1.1 \
 level.1/level.2.1/level.2.1.2 \
 level.1/level.2.2/level.2.2.1 \
 level.1/level.2.3/level.2.3.1
touch level.1/level.2.1/level.2.1.1/yes.level.2.1.1 \
  level.1/level.2.1/level.2.1.2/no.level.2.1.1  \
  level.1/level.2.2/yes.2.2.1   \
  level.1/level.2.2/level.2.2.1/no.2.2.1\
  level.1/level.2.3/level.2.3.1/yes.2.3.1
echo "level.1/level.2.1/level.2.1.2"  >exclude.file
echo "level.1/level.2.2/level.2.2.1" >>exclude.file
tar -cvfX myfiles.tar exclude.file level.1
tar -tvf myfiles.tar
find . -name '*' -type f
ls -Fla
uname -a


24956:[EMAIL PROTECTED]> tar -cvfX myfiles.tar exclude.file level.1
a level.1/ 0K
a level.1/level.2.1/ 0K
a level.1/level.2.1/level.2.1.1/ 0K
a level.1/level.2.1/level.2.1.1/yes.level.2.1.1 0K
a level.1/level.2.1/level.2.1.2 excluded
a level.1/level.2.2/ 0K
a level.1/level.2.2/level.2.2.1 excluded
a level.1/level.2.2/yes.2.2.1 0K
a level.1/level.2.3/ 0K
a level.1/level.2.3/level.2.3.1/ 0K
a level.1/level.2.3/level.2.3.1/yes.2.3.1 0K

24956:[EMAIL PROTECTED]> tar -tvf myfiles.tar
tar: blocksize = 11
drwxr-xr-x 101/2000  0 Nov 24 22:46 2003 level.1/
drwxr-xr-x 101/2000  0 Nov 24 22:46 2003 level.1/level.2.1/
drwxr-xr-x 101/2000  0 Nov 24 22:46 2003 level.1/level.2.1/level.2.1.1/
-rw-r--r-- 101/2000  0 Nov 24 22:46 2003
level.1/level.2.1/level.2.1.1/yes.level.2.1.1
drwxr-xr-x 101/2000  0 Nov 24 22:46 2003 level.1/level.2.2/
-rw-r--r-- 101/2000  0 Nov 24 22:46 2003 level.1/level.2.2/yes.2.2.1
drwxr-xr-x 101/2000  0 Nov 24 22:46 2003 level.1/level.2.3/
drwxr-xr-x 101/2000  0 Nov 24 22:46 2003 level.1/level.2.3/level.2.3.1/
-rw-r--r-- 101/2000  0 Nov 24 22:46 2003
level.1/level.2.3/level.2.3.1/yes.2.3.1

24956:[EMAIL PROTECTED]> find . -name '*' -type f
./level.1/level.2.1/level.2.1.1/yes.level.2.1.1
./level.1/level.2.1/level.2.1.2/no.level.2.1.1
./level.1/level.2.2/level.2.2.1/no.2.2.1
./level.1/level.2.2/yes.2.2.1
./level.1/level.2.3/level.2.3.1/yes.2.3.1
./myfiles.tar
./exclude.file

24956:[EMAIL PROTECTED]> ls -Fla
total 80
drwxr-xr-x   3 oracle   dba  318 Nov 24 22:52 ./
drwxrwxrwt  13 root sys 8057 Nov 24 22:59 ../
-rw-r--r--   1 oracle   dba   60 Nov 24 22:46 exclude.file
drwxr-xr-x   5 oracle   dba  315 Nov 24 22:46 level.1/
-rw-r--r--   1 oracle   dba 5632 Nov 24 22:53 myfiles.tar

24956:[EMAIL PROTECTED]> uname -a
SunOS bigkahuna 5.8 Generic_108528-22 sun4u sparc SUNW,Ultra-Enterprise



   
   
  Ross Collado 
   
  <[EMAIL PROTECTED]To:   Multiple recipients of list 
ORACLE-L <[EMAIL PROTECTED]>  
  hpac.com>cc: 
   
  Sent by: Subject:  UNIX OT: exclude files in tar 
   
  [EMAIL PROTECTED]
   
  .com 
   
   
   
   
   
  11/24/2003 10:24 
   
  PM   
   
  Please respond to
   
  ORACLE-L 
   
   
   
   
   




Hello,

On Solaris 8

I can't seem to get the tar command right.  I wanted to tar a directory but
EXCLUDE one of the subdirectory in it.
Example:
/home/user01
/home/user01/mark01
/

Re: ** find whether table or index being accessed

[Brian_P_MacLean]

Well, it's not a perfect solution but the following query will show you
what is in your buffer pool (v$bh) and match it to each objects total
segment size and give you a report of what is really taking up the buffer
pool and was percent of each object is in memory.  It's not a perfect (old
old old) script but the output can be enlightening.  If you see indexes
that are large but not much of it is in memory, well, you can draw your own
conclusions.  I have been using versions of this script since oracle
7-something but haven't run it in v9. Have fun..

set verify off
set pagesize 36
set linesize 132
set pause off
set pause 'Hit enter to continue'
set feedback off
set showmode off
set echo off

REM


col db_block_size  new_value nv_db_block_size  noprint
select value db_block_size from v$parameter where name = 'db_block_size';

REM


ttitle "V$BH, Ordered by Status and Count"
col status   format a10   heading "Block|Status|Types"
col status2  format a25   heading "Block|Status|Description"
col block_status format a32   heading "--Block Status
Details--|Dirty-Temp-Ping-Stale-Direct-New"
col cnt  format  heading "Blocks"
col sga_kbytes   format  heading "Kbytes"
col sga_mbytes   format  heading "Mbytes"
compute sum of cnton report
compute sum of sga_kbytes on report
compute sum of sga_mbytes on report
break on report
select count(*) cnt,
   count(*) * (&nv_db_block_size / 1024) sga_kbytes,
   trunc((count(*) * (&nv_db_block_size / 1024)) / 1024) sga_mbytes,
   status,
   decode(upper(status), 'FREE', 'not currently in use',
 'XCUR', 'exclusive',
 'SCUR', 'shared current',
 'CR',   'consistent read',
 'READ', 'being read from disk',
 'MREC', 'in media recovery mode',
 'IREC', 'in instance recovery mode',
'UNKNOWN') status2,
   dirty || ' ' || temp || '' || ping || '' || stale || '
' || direct || '  ' || new block_status
from v$bh
group by status,
 dirty || ' ' || temp || '' || ping || '' || stale || '
' || direct || '  ' || new
order by 2,1;
clear break
clear compute

REM


ttitle off
set pause off

PROMPT
PROMPT Sort BY Selections
prompt For DB Buffer Cache Map
PROMPT 

PROMPT 1 = Object Owner
PROMPT 2 = Object Name
PROMPT 3 = Object Type
PROMPT 4 = SGA Blocks
PROMPT 5 = SGA KBytes
PROMPT 6 = Segment KBytes
PROMPT 7 = Percent in SGA
ACCEPT USER_INPUT1 NUMBER PROMPT 'Please enter one now:>'
col sort_by_number new_value sort_by_number_value noprint
col sort_by_text   new_value sort_by_text_value   noprint
select decode(&USER_INPUT1, 1,1, 2,2, 3,3, 4,4, 5,5, 6,7, 7,9, 4)
sort_by_number,
   decode(&USER_INPUT1, 1, 'Object Owner',
2,'Object Name',
3,'Object Type',
4,'SGA Blocks',
5,'SGA KBytes',
6,'Segment KBytes',
7,'Percent in SGA',
'SGA Blocks') sort_by_text
from dual;

REM


PROMPT
PROMPT Sort ORDER Selections
PROMPT -

PROMPT 1 = Descending
PROMPT 2 = Ascending
ACCEPT USER_INPUT2 NUMBER PROMPT 'Please enter one now:>'
col order_by_text   new_value order_by_text_value  noprint
select decode(&USER_INPUT2, 1,'Desc', 2,'Asc', 'Desc') order_by_text
from dual;

REM


ACCEPT USER_INPUT3 CHAR PROMPT 'Include SYS objects (Y/N):>'
col include_sys   new_value nv_include_sys  noprint
select decode(upper('&USER_INPUT3'), 'Y','Y', 'N') include_sys
  from dual;

REM


set feedback on

create table tmp_v$cache
  as select owner#, name, kind, partition_name, count(*) sga_cnt, count(*)
* (&nv_db_block_size / 1024) sga_kb
   from v$cache
  group by owner#, name, kind, partition_name;
create index tmp_v$cache_idx
  on tmp_v$cache(owner#, name, kind, partition_name, sga_cnt, sga_kb);
analyze table tmp_v$cache
  compute statistics
for table
for all indexes
for all indexed columns;

create table tmp_dba_users
  as select user_id, username
   from dba_users;
create index tmp_dba_users_idx
  on tmp_dba_users(user_id, username);
analyze table tmp_dba_users
  compute statistics
for table
for all indexes
for all indexed columns;

create table tmp_dba_segments
 as select owner, segment_name, segment_type, partition_name, blocks *
(&

Re: Test mesg

[Brian_P_MacLean]

[EMAIL PROTECTED]:avsp:9.2.0:OPS$ORACLE:81,43878>r
  1  select case
  2   when rtrim(to_char(sysdate,'DAY')) in ('SATURDAY','SUNDAY')
  3 then 'Working from home'
  4   else case
  5  when to_char(sysdate,'HH24') between 8 and 17
  6 then 'At work'
  7  else
  8  'Working from home'
  9end
 10 end "Just another Day"
 11*   from dual

Just another Day
-
Working from home



   
 
  Robert Eskridge  
 
  <[EMAIL PROTECTED]To:   Multiple recipients of list 
ORACLE-L <[EMAIL PROTECTED]>
  t>   cc: 
 
  Sent by: Subject:  Re: Test mesg 
 
  [EMAIL PROTECTED]
 
  .com 
 
   
 
   
 
  11/16/2003 08:59 
 
  AM   
 
  Please respond to
 
  ORACLE-L 
 
   
 
   
 




JS> Just making sure the list is up.

I'm up.  Though I didn't know we had hours we were supposed to be
online on a Sunday.

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

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

[Brian_P_MacLean]

With Oracle, quality always ends with the number 4.

  6.0.38.4
  7.3.4
  8.1.7.4
  9.2.0.4






   
  
  Mladen Gogala
  
  <[EMAIL PROTECTED]To:   Multiple recipients of list 
ORACLE-L <[EMAIL PROTECTED]> 
  .net>cc: 
  
  Sent by: Subject:  Re: which oracle9i version is 
stable
  [EMAIL PROTECTED]
  
  .com 
  
   
  
   
  
  10/30/2003 04:54 
  
  AM   
  
  Please respond to
  
  ORACLE-L 
  
   
  
   
  




In my experience, 9.2.0.4 is the best one so far.  I don't think that you
should be chosing versions based on 7.3.4 connectivity.

On 2003.10.30 06:09, Jeroen van Sluisdam wrote:
> Hi,
>
> I'm planning a migration to oracle9i. We are testing on 9.0.1.0 because
> we want to be able to connect with this version to oracle 7.3.4 db.
> We started with 9.2 but found a known bug which prevented to connect to
> oracle7.3.4. Any advice on which version of 9i to go to will be
appreciated.
>
> Thnx,
>
> Jeroen
>

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

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





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

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

[Brian_P_MacLean]

Could someone reach over and turn the Grid hype knob up to 11 for me, oops,
sorry, already there.

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




   
 
  "Jay Wade"   
 
  <[EMAIL PROTECTED]To:   Multiple recipients of list 
ORACLE-L <[EMAIL PROTECTED]>
  .com>cc: 
 
  Sent by: Subject:  More On 10G   
 
  [EMAIL PROTECTED]
 
  .com 
 
   
 
   
 
  08/04/2003 10:24 
 
  AM   
 
  Please respond to
 
  ORACLE-L 
 
   
 
   
 




Came across this article thought the group might be interested.
Any ideas on a release date for 10G, I know they are going to unveil it at
OpenWorld, any quess on the release date?


http://www.eweek.com/article2/0,3959,1209597,00.asp

_
MSN 8 helps eliminate e-mail viruses. Get 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: 
  INET: [EMAIL PROTECTED]

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

Re: Triggers - How expensive when set on heavily loaded tables ?

[Brian_P_MacLean]

row row row your boat..row level that is

BTW - If you were wondering more about how I tested.  I had about 10,000
rows in table_a, and ran the statement "insert into table_b as select *
from table_a".  I did it without, and with one or more triggers on table_b.
Maybe triggers are faster in v9 as pl/sql gets faster with each release,
but I doubt that it's down to the "almost no impact" level.

Cheers



   
  
  [EMAIL PROTECTED]
  
  mTo:   Multiple recipients of list 
ORACLE-L <[EMAIL PROTECTED]> 
  Sent by: cc: 
  
  [EMAIL PROTECTED]Subject:  Re: Triggers - How expensive 
when set on heavily loaded tables ?
  .com 
  
   
  
   
  
  07/24/2003 09:09 
  
  PM   
  
  Please respond to
  
  ORACLE-L 
  
   
  
   
  





Brian,

Were those row level or statement level triggers?

Jared

On Wed, 23 Jul 2003 [EMAIL PROTECTED] wrote:

>
> I did some trigger timings about a year ago on v8.1.7.4.  I did the
testing
> using a trigger with only 1 statement in it, and that statements was
> "null;".  I found that my transaction timing increased by 100% for the
> first trigger added, and 25% for every trigger after that.  So that math
> breaks down this way:
>
>   The base transaction took 60 seconds;
>   With one before insert trigger with a "null;" statement in it, it
now
> took 120 seconds;
>   I added one more after insert trigger with a "null" statement in
it,
> the total time was 150 seconds;
>
> Kind of makes ya rethink/realize what the true cost of all those before
> insert/update triggers we have added over the years, that do nothing more
> than update the add_date and change_date columns.  I know I'll never do
it
> again.
>
> Now in your case, maybe the trigger is the right answer.  But we can't
make
> that decision for you.YOU HAVE TO TEST IT FOR YOURSELF!
>
>
>
>
>
>
>

>   "VIVEK_SHARMA"

>   <[EMAIL PROTECTED]To:   Multiple
recipients of list ORACLE-L <[EMAIL PROTECTED]>
>   osys.com>cc:

>   Sent by: Subject:  Triggers - How
expensive when set on heavily loaded tables ?
>   [EMAIL PROTECTED]

>   .com

>

>

>   07/23/2003 09:14

>   PM

>   Please respond to

>   ORACLE-L

>

>

>
>
>
>
>
> Qs 1) Whenever an Account ID is transacted - INSERT occurs into a table
> TRAN_TBL as part of the transaction , Additionally the Account ID is
> checked for existence in another table say TABLE_1 . If found , a record
is
> inserted into yet another  table say TABLE_2 .
>
> Qs. Operations involving TABLE_1 & TABLE_2 if managed using triggers ,
How
> expensive in CPU & performance will it be ?
>
> NOTE - TRAN_TBL undergoes very large volumes of Concurrent OLTP INSERT
> transaction .
>
>
> Qs 2) If an alert is to be raised on addition of a new record to TABLE_2
:-
> a) Can trigger be used ?
> b) Should a cron job running every 5 min. look at TABLE_2 & based on the
> time criteria generates the alert ?
>
> Thanks
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: VIVEK_SHARMA
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from t

Re: Triggers - How expensive when set on heavily loaded tables ?

[Brian_P_MacLean]

I did some trigger timings about a year ago on v8.1.7.4.  I did the testing
using a trigger with only 1 statement in it, and that statements was
"null;".  I found that my transaction timing increased by 100% for the
first trigger added, and 25% for every trigger after that.  So that math
breaks down this way:

  The base transaction took 60 seconds;
  With one before insert trigger with a "null;" statement in it, it now
took 120 seconds;
  I added one more after insert trigger with a "null" statement in it,
the total time was 150 seconds;

Kind of makes ya rethink/realize what the true cost of all those before
insert/update triggers we have added over the years, that do nothing more
than update the add_date and change_date columns.  I know I'll never do it
again.

Now in your case, maybe the trigger is the right answer.  But we can't make
that decision for you.YOU HAVE TO TEST IT FOR YOURSELF!






   
  
  "VIVEK_SHARMA"   
  
  <[EMAIL PROTECTED]To:   Multiple recipients of list 
ORACLE-L <[EMAIL PROTECTED]> 
  osys.com>cc: 
  
  Sent by: Subject:  Triggers - How expensive when 
set on heavily loaded tables ?
  [EMAIL PROTECTED]
  
  .com 
  
   
  
   
  
  07/23/2003 09:14 
  
  PM   
  
  Please respond to
  
  ORACLE-L 
  
   
  
   
  





Qs 1) Whenever an Account ID is transacted - INSERT occurs into a table
TRAN_TBL as part of the transaction , Additionally the Account ID is
checked for existence in another table say TABLE_1 . If found , a record is
inserted into yet another  table say TABLE_2 .

Qs. Operations involving TABLE_1 & TABLE_2 if managed using triggers , How
expensive in CPU & performance will it be ?

NOTE - TRAN_TBL undergoes very large volumes of Concurrent OLTP INSERT
transaction .


Qs 2) If an alert is to be raised on addition of a new record to TABLE_2 :-
a) Can trigger be used ?
b) Should a cron job running every 5 min. look at TABLE_2 & based on the
time criteria generates the alert ?

Thanks


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

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





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

[Brian_P_MacLean]

Been like that since Oracle v7.1.3.

For the short answer ->


http://download-west.oracle.com/docs/cd/A87860_01/doc/server.817/a76965/c22paral.htm#3166

But I think it's time for a little reading ->


http://download-west.oracle.com/docs/cd/A87860_01/doc/server.817/a76965/c22paral.htm





   
  
  "AK" 
  
  <[EMAIL PROTECTED]To:   Multiple recipients of list 
ORACLE-L <[EMAIL PROTECTED]> 
  .com>cc: 
  
  Sent by: Subject:  parallel processes
  
  [EMAIL PROTECTED]
  
  .com 
  
   
  
   
  
  07/23/2003 05:44 
  
  PM   
  
  Please respond to
  
  ORACLE-L 
  
   
  
   
  




while rebuilding indexes i gave parrallel 2 . But I see there are four
ora_p00 processes . ???

-ak






-- 
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: Upgraded From v8.1.7.4 to v9.2.0.3 and now dbms_stats.gather_table_stats

[Brian_P_MacLean]

Never mind. Fixed it myself.

The effects of the "granularity=>'ALL'" method have changed for partitioned
tables.  On v8.1.7.4 it didn't go global on the table, now it does.  Ouch.




   
 
  Brian P MacLean  
 
   To:  [EMAIL PROTECTED]  
  
  07/17/2003 05:13 cc: 
 
  PM   Subject: Upgraded From v8.1.7.4 to 
v9.2.0.3 and now dbms_stats.gather_table_stats
   runs FOREVER(Document link: Brian P 
MacLean) 
   
 



Upgraded Solaris v8.1.7.4 64-bit to v9.2.0.3 and now
dbms_stats.gather_table_stats on partitioned tables is running and running
and running.  In testing on one partition in v8.1.7.4 the command takes 3
minutes, in v9.2.0.3 it took...well I killed it after 3 hours.  I also see
an abnormal amount of temporary tablespace being used.  I installed patch
2919423 per the known bug related to this but it's still keeps running and
running and running.

Suggestions?  Comments?

TIA







-- 
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).

Upgraded From v8.1.7.4 to v9.2.0.3 and now dbms_stats.gather_table_stats

[Brian_P_MacLean]

Upgraded Solaris v8.1.7.4 64-bit to v9.2.0.3 and now
dbms_stats.gather_table_stats on partitioned tables is running and running
and running.  In testing on one partition in v8.1.7.4 the command takes 3
minutes, in v9.2.0.3 it took...well I killed it after 3 hours.  I also see
an abnormal amount of temporary tablespace being used.  I installed patch
2919423 per the known bug related to this but it's still keeps running and
running and running.

Suggestions?  Comments?

TIA





-- 
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: how to schedule a job every alternate sundays in unix cron

[Brian_P_MacLean]

 Ah, no...no downfall on 28/30/31 day month thingy.  Do a man page
on date, in the "see also" section it say to look at strftime, doing a man
page on strftime you will see that the %U format is defined as:

 %UWeek number of year as a decimal number [00,53],  with
   Sunday as the first day of week 1.

So this will run it on Sundays for the even "weeks" of the year.  Not
perfect because of the 53 week year cycle, but hey, the advice was free.



   
  
  [EMAIL PROTECTED]
  
  ys.com   To:   Multiple recipients of list 
ORACLE-L <[EMAIL PROTECTED]> 
  Sent by: cc: 
  
  [EMAIL PROTECTED]Subject:  RE: how to schedule a job 
every alternate sundays in unix cron  
  .com 
  
   
  
   
  
  07/17/2003 03:09 
  
  PM   
  
  Please respond to
  
  ORACLE-L 
  
   
  
   
  




> what a freekin nightmare!

Not really.

Is today Sunday?  :

  `date '+\%a'` = 'Sun'

if it is, check this also ('and'):

   -a

Is this an odd or even day?

   eg.  daynum mod 2
  ((`date '+\%U'` % 2)) -eq 0


One possible downfall of this is if the current Sunday is the 30th,
and the next day is Monday the 31st.

Then the following Sunday is the 6th, and then two Sundays
in a row will run.

Jared






"Mercadante, Thomas F" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
 07/17/2003 11:49 AM
 Please respond to ORACLE-L


To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:
Subject:RE: how to schedule a job every alternate sundays
in unix cron


what a freekin nightmare!  I'd hate to be the next poor bloke who has to
decifer this...

Tom Mercadante
Oracle Certified Professional


-Original Message-
Sent: Thursday, July 17, 2003 2:35 PM
To: Multiple recipients of list ORACLE-L


Brilliant.  :)





[EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
 07/16/2003 11:29 PM
 Please respond to ORACLE-L


To: Multiple recipients of list ORACLE-L
<[EMAIL PROTECTED]>
cc:
Subject:Re: how to schedule a job every alternate sundays
in
unix cron



0 1 * * 0 /usr/bin/ksh -c "[ `date '+\%a'` = 'Sun' -a $((`date '+\%U'` \%
2)) -eq 0 ] && /path/myscript.ksh"

This will run myscript.ksh on even Sundays at 1 a.m.

If ?'s, email me direct.





  kommareddy
  sreenivasa   To:   Multiple
recipients of list ORACLE-L <[EMAIL PROTECTED]>
  <[EMAIL PROTECTED]cc:
  om>  Subject:  how to schedule a

job every alternate sundays in unix cron
  Sent by:
  [EMAIL PROTECTED]
  .com


  07/16/2003 06:09
  AM
  Please respond to
  ORACLE-L






Hello All,

OS: Solaris 2.8

I have to run a backup script in every alternate
Sunday.

I cant find a way to submit it in cron.

Can somebody help me  how to setup a job to run
alternate Sundays in unix cron .

Thanks and Regards,
Srinivas



__
Do you Yahoo!?
SBC Yahoo! DSL - Now only $29.95 per month!
http://sbc.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: kommareddy sreenivasa
  INET: [EMAIL PROTECTED]

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

Re: x server

[Brian_P_MacLean]

Are you looking for something like Exceed?  If so try

WinaXe - From http://www.tucows.com
http://www.jcraft.com/weirdx




   
  
  "AK" 
  
  <[EMAIL PROTECTED]To:   Multiple recipients of list 
ORACLE-L <[EMAIL PROTECTED]> 
  .com>cc: 
  
  Sent by: Subject:  x server  
  
  [EMAIL PROTECTED]
  
  .com 
  
   
  
   
  
  07/17/2003 09:49 
  
  AM   
  
  Please respond to
  
  ORACLE-L 
  
   
  
   
  




is there any free x server (unlimited ) software for windows 2000 ?

-ak




-- 
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: shell question

[Brian_P_MacLean]

Sounds to simple so I must be missing a few of the requirements (...

cat myfile

  or

#!/bin/ksh
cat myfile | while read LINE
do
  print ${LINE}
done



   
  
  <[EMAIL PROTECTED]   
   
  onents.com>  To:   Multiple recipients of 
list ORACLE-L <[EMAIL PROTECTED]> 
  Sent by: cc: 
  
  [EMAIL PROTECTED]Subject:  shell question
  
   
  
   
  
  07/17/2003 12:09 PM  
  
  Please respond to
  
  ORACLE-L 
  
   
  
   
  





 hi all ,

how can I read a text file and print line by line.

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

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






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

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

[Brian_P_MacLean]

Having experienced SQL*BackTrack, EBU, and RMAN.

  Yes RMAN is getting better (anyone else remember the nightmare called
EBU).

  Yes RMAN still sucks.

  Yes RMAN is still free (get what ya pay for)

  SQL*BackTrack - Slicker than Owl S...

  Have the $, use SQL*BackTrack.

  Have no $, write a ksh script.

  Want to build your resume, use RMAN.

You already have the investment in SQL*BackTrack licensing, so why not
continue the few dollars it takes to buy support.

Flame on




   
  
  "Smith, Ron L."  
  
  <[EMAIL PROTECTED]>To:   Multiple recipients of list 
ORACLE-L <[EMAIL PROTECTED]> 
  Sent by: cc: 
  
  [EMAIL PROTECTED]Subject:  RMAN & SQL Backtrack  
  
  .com 
  
   
  
   
  
  07/16/2003 07:59 
  
  AM   
  
  Please respond to
  
  ORACLE-L 
  
   
  
   
  




We have been using SQL Backtrack for backup and recovery for about 6 years
now.  We are being pressured to start using RMAN because it is free.  Makes
sense but I am wondering about reliability, complexity, learning curve,
etc...

Has anyone had experience with both products or anyone new to RMAN that can
give me an idea of what to expect?

Thanks!

Ron


If you are not the intended recipient of this e-mail message, any use,
distribution or copying of the message is prohibited. Please let me know
immediately by return e-mail if you have received this message by mistake,
then delete the e-mail message. Thank you.








-- 
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: how to schedule a job every alternate sundays in unix cron

[Brian_P_MacLean]

0 1 * * 0 /usr/bin/ksh -c "[ `date '+\%a'` = 'Sun' -a $((`date '+\%U'` \%
2)) -eq 0 ] && /path/myscript.ksh"

This will run myscript.ksh on even Sundays at 1 a.m.

If ?'s, email me direct.




   
  
  kommareddy   
  
  sreenivasa   To:   Multiple recipients of list 
ORACLE-L <[EMAIL PROTECTED]> 
  <[EMAIL PROTECTED]cc:
   
  om>  Subject:  how to schedule a job every 
alternate sundays in unix cron  
  Sent by: 
  
  [EMAIL PROTECTED]
  
  .com 
  
   
  
   
  
  07/16/2003 06:09 
  
  AM   
  
  Please respond to
  
  ORACLE-L 
  
   
  
   
  




Hello All,

OS: Solaris 2.8

I have to run a backup script in every alternate
Sunday.

I cant find a way to submit it in cron.

Can somebody help me  how to setup a job to run
alternate Sundays in unix cron .

Thanks and Regards,
Srinivas



__
Do you Yahoo!?
SBC Yahoo! DSL - Now only $29.95 per month!
http://sbc.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: kommareddy sreenivasa
  INET: [EMAIL PROTECTED]

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

[Brian_P_MacLean]

COBOL, SQL*Net, DB_Link...it's all there.

You might want to follow these links to the dark side

  http://www.mvsoraclesig.org/
  http://www.oramain.com/welcome.htm (this guy runs the users group)





   
  
  "Terrian, Tom
  
  (Contractor) To:   Multiple recipients of list 
ORACLE-L <[EMAIL PROTECTED]> 
  (DAASC)" cc: 
  
  <[EMAIL PROTECTED]Subject:  Oracle on a mainframe (MVS)  
   
  mil> 
  
  Sent by: 
  
  [EMAIL PROTECTED]
  
  .com 
  
   
  
   
  
  07/10/2003 08:59 
  
  AM   
  
  Please respond to
  
  ORACLE-L 
  
   
  
   
  




We have a future need to create an Oracle database on a mainframe (MVS)
which will then pull data from an Oracle database on an HPUX box.  I know
nothing about MVS so does anyone know of any connectivity problems between
the two boxes?  For example, SQL*Net does come with the server on MVS,
correct?  Does Pro*Cobol also exist on MVS?  Would the connection from MVS
to HPUX be a simple as creating a database link or are there more problems
than that?

Any help would be appreciated.

Thanks,
Tom




-- 
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: Script to check filename continuously

[Brian_P_MacLean]

Here is a start for you.  You can get the sleep command at any of these
places

  http://www.weihenstephan.de/~syring/win32/UnxUtils.html
  http://www.cruzio.com/~jeffl/mrtg/docs/sleep.exe
  http://www.nextgeneration.dk/gnu/index.shtml


@ECHO OFF
set BASE_DIR=d:\oracle\oradata\sid\archive
set BASE_FILE=*.arc
set RMT_DIR=x:\rmt_path
:LOOP
for /F  %%T In ('dir %BASE_FILE% /B /O:-N') Do (
  copy %%T %RMT_DIR%\%%T
)
sleep 5
GOTO LOOP





   
  
  Saminathan_Seeran
  
  [EMAIL PROTECTED]   To:   Multiple recipients of 
list ORACLE-L <[EMAIL PROTECTED]> 
  Sent by: cc: 
  
  [EMAIL PROTECTED]Subject:  Script to check filename 
continuously   
  .com 
  
   
  
   
  
  07/03/2003 03:30 
  
  AM   
  
  Please respond to
  
  ORACLE-L 
  
   
  
   
  








Hi All

Does anyone have script(DOS batch file or Unix Shell) to do the following
stuff?

loop
if exist FILE_NAME
  begin
do something;
copy files to remote machine,etc...
EXIT;
  end;
end loop;

Thanks
Sami

--
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).






-- 
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: How to install Oracle JVM on Oracle 8.1.7.

[Brian_P_MacLean]

This was taken from my build db script.  Most of it is from MetaLink Doc's.


   REM Scripts needed for JVM  version 8.1.5
  REM ~
  REM   @?/javavm/install/initjvm.sql  -- Setup a database for running
Java and the ORB
  REM
  REM Scripts needed for JVM  version 8.1.6
  REM ~
  REM   @?/javavm/install/initjvm.sql  -- Setup a database for running
Java and the ORB
  REM   @?/rdbms/admin/initplsj.sql-- Initializes Java library
needed by PL/SQL
  REM   @?/rdbms/admin/initaqjms.sql   -- Load AQ/JMS jar files into
the database
  REM   @?/rdbms/admin/initrepapi.sql  -- Load RepAPI server classes
and publish 'repapi' obj
  REM
  REM Scripts needed for JVM  version 8.1.7
  REM ~
  @?/javavm/install/initjvm.sql  -- Setup a database for running Java
and the ORB
  @?/oracore/admin/initxml.sql   -- Loads xml components into the
JServer
  @?/rdbms/admin/catxsu.sql  -- loads the XMLSQL Utility (XSU) into
the database
  @?/javavm/install/init_jis.sql -- JIS (OSE) installation
  @?/javavm/install/jisja.sql-- Turn on JAccelerator (ncomp) for
JIS
  @?/javavm/install/jisaephc.sql -- Adds the set of default end points
to the server
 -- with hardcoded values for the admin
service
  @?/rdbms/admin/initplgs.sql-- Load PLSQL Gateway Servlet jar
files into the database
  @?/jsp/install/initjsp.sql -- Install Oracle JSP
  @?/jsp/install/jspja.sql   -- Turn on JAccelerator for JSP libs
  @?/rdbms/admin/initplsj.sql-- Initializes Java library needed by
PL/SQL
  @?/rdbms/admin/initjms.sql -- Load AQ/JMS jar files into the
database
  @?/rdbms/admin/initrepapi.sql  -- Load RepAPI server classes and
publish 'repapi' obj
  @?/rdbms/admin/initsoxx.sql-- loads sql, objects, extensibility
and xml related java
  REM
  REM   Note: Run the following at your own risk.
  REM @?/javavm/install/jisaep admin 8080 9090 -- Configure OSE defauls
admin Web Service
  REM
  REM END~OF~JAVA~SCRIPTS







   
  
  "AK" 
  
  <[EMAIL PROTECTED]To:   Multiple recipients of list 
ORACLE-L <[EMAIL PROTECTED]> 
  .com>cc: 
  
  Sent by: Subject:  Re: How to install Oracle JVM 
on Oracle 8.1.7.  
  [EMAIL PROTECTED]
  
  .com 
  
   
  
   
  
  07/03/2003 12:34 
  
  PM   
  
  Please respond to
  
  ORACLE-L 
  
   
  
   
  




Look in

$ORACLE_HOME\javavm\install\initjvm.sql

-ak

- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Thursday, July 03, 2003 7:15 AM


> Hi all,
>
> I want to install, oracle JVM on oracle 817 database
> running on NT2000 server.
>
> I hope that initjvm.sql script has to be run under sys
> login. However i can't able to find that script file
> in my oracle home path %ORACLE_HOME%\RDBMS\ADMIN.
>
> Let know how to proceed futher and what are the pre
> requisities and post requiesties for this
> intallation?.
>
> Thanks.
> Nirmal,.
>










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

Re: Need Script!!

[Brian_P_MacLean]

For the mail part use...

On this page  ->
http://www.interlog.com/~tcharron/blat.html
Download and install his file ->
http://www.interlog.com/~tcharron/blat194.zip
To send mail from a *.bat script-> blat %myfile.log% -subject
"%mysubject%" -to %toaddress% -f %fromaddress%


For the scripting part you can do it all in simple dos bat files (really U
can), perl (use ActivePerl from http://www.activestate.com), or you can do
the Unix thingy by searching Google for Windows ports of Unix commands,
they are easy to find, start here ->
http://www.weihenstephan.de/~syring/win32/UnxUtils.html




   
 
  "Senthil Kumar D"
 
  <[EMAIL PROTECTED]To:   Multiple recipients of list 
ORACLE-L <[EMAIL PROTECTED]> 
  tworks.com> cc:  
 
  Sent by:Subject:  Need Script!!  
 
  [EMAIL PROTECTED]
  
  m
 
   
 
   
 
  07/01/2003 08:19 AM  
 
  Please respond to
 
  ORACLE-L 
 
   
 
   
 




Hi Group,

In one of our client place we are having Oracle 8.1.7 (std Ed) on NT.

Here we need to send mails if the DB is down or if the listener is down or
any errors in the alert log is found. In Unix we can use shell scripts and
awk to do this. What about in NT/

Guru's do you have any scripts to do the same.

Please help me in this.

TIA,
Senthil.

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

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

[Brian_P_MacLean]

I did some bulk load testing with triggers on v8.1.7.4 a few months ago.
All the trigger(s) had for code was a "NULL;" statement.  The first trigger
increased the time 100% in the insert (ie: a load that took 1 minute
increased to 2 minutes with the trigger).  Each additional trigger after
the first cost an additional 25%.

So I would read that as a 75% cost/increase to do the SQL to PLSQL switch.



   
 
  [EMAIL PROTECTED]
 
  .com To:   Multiple recipients of list 
ORACLE-L <[EMAIL PROTECTED]>
  Sent by: cc: 
 
  [EMAIL PROTECTED] Subject:  Re: Do triggers cause a 
context switch between SQL & PL/SQL
   
 
   
 
  04/01/03 12:43 PM
 
  Please respond to
 
  ORACLE-L 
 
   
 
   
 





I thought as much, from what I've heard and read.   Does anyone know if
there's a way to figure out how much overhead the switches generate?  I'm
guessing they would show up in trace files in the 'other CPU' category.



  [EMAIL PROTECTED]

   T

  Sent by: To:   Multiple
recipients of list ORACLE-L
  [EMAIL PROTECTED] <[EMAIL PROTECTED]>

   cc:


   bcc:

  04/01/03 01:19 PMSubject:
Re: Do
  Please respond totriggers cause a context
switch between SQL & PL/SQL
  ORACLE-L







Since you the action switches from SQL to PL/SQL to enforce the trigger,
it sounds like a context switch to me.

FYI:  This can be improved somewhat by adding "and rownum < 2 " into the
WHERE clauses of these.  There will be noticable improvement when there
are many child rows.

Jared






[EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
 04/01/2003 09:48 AM
 Please respond to ORACLE-L


To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:
Subject:Do triggers cause a context switch between SQL &
PL/SQL


Question:

If some idiot decides to circumvent Oracle's referential integrity and
re-implement it by using triggers (insert, update, delete) that checks the
foreign (parent/child) key fields in other tables like this,

declare numrows INTEGER;
begin
-- ApplicationForm is used if the state and other criteria match that
in
-- ApplicationFormCriteria ON PARENT DELETE RESTRICT
select count(*) into numrows
  from ApplicationFormCriteria
  where
ApplicationFormCriteria.applicationFormId =
:old.applicationFormId;
if (numrows > 0)
then
  raise_application_error(
-20343,
'Database Integrity Violation - Cannot DELETE row in Table
''ApplicationForm'' because referencing row exists in table
''ApplicationFormCriteria'' for Primary Key (applicationFormId)=' ||
:old.applicationFormId
  );
end if;


end;

would it cause context switching between the SQL & PL/SQL engines?

Yes, some genius did this in one of our databases.  Two hundred
third/fourth normal form tables enforced by 800 triggers...  I have him
registered to be stoned in public.


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

Re: Unix tip for oracle

[Brian_P_MacLean]

To setup your environment add the following to your .profile or script.ksh

  export BELL=`tput bel 2>/dev/null`
  export BOLD=`tput bold 2>/dev/null`
  export BLINK=`tput blink 2>/dev/null`
  export PLAIN=`tput sgr0 2>/dev/null`
  export UNDERLINE_ON=`tput smul 2>/dev/null`
  export UNDERLINE_OFF=`tput rmul 2>/dev/null`
  export REV_VIDEO_ON=`tput smso 2>/dev/null`
  export REV_VIDEO_OFF=`tput rmul 2>/dev/null`

An example of how to use them:

  echo "${BELL}${BOLD}Hey, Wake Up!${PLAIN}"
  echo "${UNDERLINE_ON}This text will be underlined if the terminal
supports it${PLAIN}"
  echo "${BLINK}Looks like FM to me${PLAIN}"

The tput commands are all correct.  The issue will always be, what does the
terminal support.  That always differs from user-to-user depending what
telnet tool they use and what the configuration setup for that tool is.
Stick with ${BELL} and ${BOLD} and life will be easier.




   
 
  "Spears, Brian"  
 
  <[EMAIL PROTECTED]To:   Multiple recipients of list 
ORACLE-L <[EMAIL PROTECTED]>
  rands.com>   cc: 
 
  Sent by: Subject:  Unix tip for oracle   
 
  [EMAIL PROTECTED]
  
   
 
   
 
  03/18/03 03:33 PM
 
  Please respond to
 
  ORACLE-L 
 
   
 
   
 





Working on an wrapper for Oracle functionality.

Any of the Unix guru's know if you can
highlight or set text blinking in the korn shell
in unix?


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

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

[Brian_P_MacLean]

H

grep
http://www.cs.washington.edu/homes/wolman/nt-tools/gnugrep.zip
wchttp://www.cs.washington.edu/homes/wolman/nt-tools/wc.exe
cat
http://www.cs.washington.edu/homes/wolman/nt-tools/cat.exe
mailx (use Blat)http://www.interlog.com/~tcharron/blat.html

You may also want to use the tail command to get past previously reported
errors

tail
http://www.cs.washington.edu/homes/wolman/nt-tools/tail.exe

Then do the .bat scripting.  Not that tough really





   
 
  [EMAIL PROTECTED]
 
  com.com  To:   Multiple recipients of list 
ORACLE-L <[EMAIL PROTECTED]>
  Sent by: cc: 
 
  [EMAIL PROTECTED] Subject:  Re: Set Email alert at NT
  
   
 
   
 
  02/25/03 07:19 AM
 
  Please respond to
 
  ORACLE-L 
 
   
 
   
 




Do a rewrite in Perl to run it on Windows.
There is am smtp module for Perl that will allow you to inject an message
straight to a mail server.

You could then use that both on Unix and windows

Cheers


--
=
Peter McLarty   E-mail: [EMAIL PROTECTED]
Technical ConsultantWWW: http://www.mincom.com
APAC Technical Services Phone: +61 (0)7 3303 3461
Brisbane,  AustraliaMobile: +61 (0)402 094 238
Facsimile: +61 (0)7 3303 3048
=


Mitchell <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
22-02-2003 05:59 AM
Please respond to ORACLE-L


To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:
Subject:Re: Set Email alert at NT


 Hi

The following sh is  one I used for monitoring all 20 instances on unix
boxes(aix and sun). So I could receive the ora message by palm. Now there
are 2 nt box with Oracle 8.17 installed.   I have no idea how to do it in
windows.   Any idea?

This is my ksh and run as cron job every 30 min.

if [$(cat $ORACLE_HOME/admin/$ORACLE_SID/bdump/alert_${ORACLE_SID}.log |
grep 'ORA' | wc -l) -gt 0 ];
then
  cat $ORACLE_HOME/admin/$ORACLE_SID/bdump/alert_${ORACLE_SID}.log | grep
'ORA' > $HOME/alert_me
  mailx -s " Warning: ${ORACLE_SID} Oracle Alert: ORA_error !!!"
[EMAIL PROTECTED] < $HOME/alert_me
fi


Thanks in advance.

Mitchell








-- 
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: how to make sql prompt like USER@DATABASE> ?

[Brian_P_MacLean]

(BAll of the following solutions assume that you have added the prompt
(Bmodification code to your $ORACLE_HOME/sqlplus/admin/glogin.sql file.
(BPersonally I think that is playing with fire and keep a private glogin.sql
(Bfile and the path to it in my $SQLPATH.
(B
(BMake sure the $ORACLE_HOME/sqlplus/admin directory is in your $SQLPATH,
(Bthen once connected do @glogin to reset your path
(B
(Bor
(B
(BOnce you are reconnected type @?/sqlplus/admin/glogin
(B
(Bor
(B
(BCreate a script called connect.sql, place it in your $SQLPATH, then enter
(B@connect username/password@whereever;  the text of connect.sql should be:
(B
(B  connect &1
(B  @?/sqlplus/admin/glogin
(B
(B
(B
(B
(B
(B   
(B 
(B  "shuan.tay\(PCI$BE"(B  
(B   
(B  $Bc2?(B\)"  To:   Multiple recipients of 
(Blist ORACLE-L <[EMAIL PROTECTED]>
(B  <[EMAIL PROTECTED]cc: 
(B 
(B  .id> Subject:  Re: how to make sql prompt 
(Blike USER@DATABASE> ?   
(B  Sent by: 
(B 
(B  [EMAIL PROTECTED] 
(B 
(B   
(B 
(B   
(B 
(B  02/17/03 04:53 PM
(B 
(B  Please respond to
(B 
(B  ORACLE-L 
(B 
(B   
(B 
(B   
(B 
(B
(B
(B
(B
(Bmm...
(Bwhat if i logged in with SYSTEM first then "conn sys/pswd@db"?
(Bit's still show SYSTEM @db.
(B - Original Message -
(B From: Rajesh Dayal
(B To: Multiple recipients of list ORACLE-L
(B Sent: Saturday, February 15, 2003 6:53 PM
(B Subject: RE: how to make sql prompt like USER@DATABASE> ?
(B
(B You can add following lines to your glogin.sql ($ORACLE_HOME/sqlplus/admin
(B directory) file.
(B
(B set heading off
(B set term off
(B set feedback off
(B spool myprompt.sql
(B select 'set sqlprompt "' || SYS_CONTEXT ('USERENV', 'session_user') || '@'
(B || SYS_CONTEXT ('USERENV', 'DB_NAME') || '>"'
(B from dual
(B /
(B spool off
(B @myprompt.sql
(B set heading on
(B set term on
(B set feedback on
(B
(B Alternatively you can create a file with above lines, put that file in bin
(B and call it anytime to make your prompt$B!D(B
(B
(B Cheers,
(B Rajesh
(B
(B   Original Message-
(B   From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of
(B   Salaheldin Aboali
(B   Sent: Saturday, February 15, 2003 2:14 PM
(B   To: Multiple recipients of list ORACLE-L
(B   Subject: how to make sql prompt like USER@DATABASE> ?
(B
(B
(B
(B   hi
(B
(B
(B   how to make sql prompt like USER@DATABASE> ?
(B
(B
(B   where USER: connected user
(B
(B
(B   DATABASE: database global name, or database local alias
(B   Regards,
(B   Salaheldin Aboali
(B   ---
(B   Senior Software Developer
(B   Management Information Systems
(B   http://www.mis-kuwait.com
(B   Phone:
(B   +965.240.64.25
(B   +965.240.67.98
(B   +965.240.80.92
(B   Ext. 235
(B   Fax. +965.240.81.53
(B   Cell. +965.790.31.65
(B
(B
(B
(B
(B-- 
(BPlease see the official ORACLE-L FAQ: http://www.orafaq.net
(B-- 
(BAuthor: 
(B  INET: [EMAIL PROTECTED]
(B
(BFat City Network Services-- 858-538-5051 http://www.fatcity.com
(BSan Diego, California-- Mailing list and web hosting services
(B-
(BTo REMOVE yourself from this mailing list, send an E-Mail message
(Bto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
(B

RE: Deep OPS tuning info - Scott Heisey, Where Are You When We Need Ya

[Brian_P_MacLean]

Most likely not what you are looking for but here it is anyway:

http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=NOT&p_id=206577.1

http://www.amazon.com/exec/obidos/tg/detail/-/156592701X?vi=glance
http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=NOT&p_id=181489.1

I see that you posted the same question on metalink with no success.  Sorry
I can't help at this detail level either.

I know that Scott Heisey who used to be the OPS instructor and may now be
teaching the RAC class, browses this list from time to time.  Hopefully he
will chime in.  If not I think his email is [EMAIL PROTECTED] or
[EMAIL PROTECTED]




   
 
  "K   
 
  Gopalakrishnan"  To:   Multiple recipients of list 
ORACLE-L <[EMAIL PROTECTED]>
  <[EMAIL PROTECTED]cc: 
 
  om>  Subject:  RE: Deep OPS tuning info  
 
  Sent by: 
 
  [EMAIL PROTECTED] 
 
   
 
   
 
  02/13/03 12:23 PM
 
  Please respond to
 
  ORACLE-L 
 
   
 
   
 




Rui,

It is very difficult to identify the problem by just looking
the contention for "dlm resource hash list". What are the
current values of lm_% parameters.

Basically that latch protects the resources in LM resource
structures in the lock manager resource table. And I would
compare the values from the V$resource_limit to the lm_%
parameters to get an idea about the resource utilization.

BTW Do you see "Dynamic resources/locks allocated" message
in the alert logs?



Best Regards,
K Gopalakrishnan




-Original Message-
MARREIROS,RUI (HP-Portugal,ex1)
Sent: Thursday, February 13, 2003 8:25 AM
To: Multiple recipients of list ORACLE-L


Hi all:
I'm tuning an OPS env. and the things are getting quite deep, DLM latch
issues and so on (e.g. lots of waits on "dlm resource hash list"). So I was
wondering if any of you know of any site or doc. which could help me on
this
(OPS tuning specific and very deep information).
Of course the first steps in the process was to submit the statspack report
to oraperf and so on   , but right now we are dealing with some issues
that surpass the obvious things. So if any you could provide any tip or
site
to look for a tip I´ll be very glad.

thanks in advance

Rui Galamba Marreiros
Solution Consultant - HP Services, Consulting & Integration
Quinta da Fonte , Edificio D. Sancho I,
2780 Porto Salvo, Portugal
Telf: +351 214828500
Fax: +351 21 4838431
[EMAIL PROTECTED] 


--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: MARREIROS,RUI (HP-Portugal,ex1)
  INET: [EMAIL PROTECTED]

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

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

Re: Teradata baned from IOUG???

[Brian_P_MacLean]

PHB's?  I looked it up and all I could find that fit was "Psycho Hose
Beast". Is that correct?

http://www.acronymfinder.com/af-query.asp?Acronym=PHB



   
 
  Jared.Still@radis
 
  ys.com   To:   Multiple recipients of list 
ORACLE-L <[EMAIL PROTECTED]>
  Sent by: cc: 
 
  [EMAIL PROTECTED] Subject:  Re: Teradata baned from 
IOUG???
   
 
   
 
  02/12/03 05:03 PM
 
  Please respond to
 
  ORACLE-L 
 
   
 
   
 




I can't imagine why they would want to replace Oracle with Teradata.

It's expensive.  It runs only on NCR or Windoze.

The architecture is nothing special.

I imagine the PHB's had their fingers in those moves.

Been there, got the T-shirt, now it's a dust rag.

Jared






"James Howerton" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
 02/12/2003 01:58 PM
 Please respond to ORACLE-L


To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:
Subject:Teradata baned from IOUG???


DBA's

Check the article's comment on Oracle trying to ban Teradata from IOUG

Teradata Steals Oracle's Data Mart Users ...

Teradata pushes consolidation and woos away Oracle customers. But
Oracle strikes back. Sort of. Will bean counters surf the Web with
Excel? Will Steve Ballmer and Larry Ellison become immortal?

http://computerworld.com/newsletter/0%2C4902%2C78375%2C0.html?nlid=DM



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

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






-- 
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: OT: unix script quetion: to replace $ with \$

[Brian_P_MacLean]

Your first "echo" needs to be in single quotes or else it results in...

29912:oracle@mybox> echo "123$45$678"
123578

Once that is done this...

29912:oracle@mybox> echo '123$45$678' | sed 's/\$/\\$/g'
123\$45\$678

...or this...

29912:oracle@mybox> echo '123$45$678' | sed 's/\$/\\\$/g'
123\$45\$678

...will work



   
 
  "Guang Mei"  
 
  <[EMAIL PROTECTED]To:   Multiple recipients of list 
ORACLE-L <[EMAIL PROTECTED]>
  m>   cc: 
 
  Sent by: Subject:  OT: unix script quetion: to 
replace $ with \$  
  [EMAIL PROTECTED] 
 
   
 
   
 
  02/03/03 11:39 AM
 
  Please respond to
 
  ORACLE-L 
 
   
 
   
 




Hi:

I have a quick question about replacing "$" with "\$" on unix. I need to
convert string "123$45$678" to "123\$45\$678" through a pipe. I tried with
sed command, but could not get it to work:

essex$ echo "123$45$678" | sed s/"$"/"\$"/g
123578$
essex$ echo "123$45$678" | sed s/"$"/"\\$"/g
123578$

Maybe there is another syntax that I should use? TIA.

Guang Mei








_
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: 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: 
  INET: [EMAIL PROTECTED]

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

[Brian_P_MacLean]

I ass|u|me you are talking windows here. The access rights are not for you,
but for the service.  Go into the services startup/shutdown window and
change the service to start as an account that has network rights to the
mount point.  I believe the services default to the "system account"
whatever that is, and which has never worked for me.  (see metalink doc#
211532.1 or do a metalink search on both your error numbers ORA-27040 &
OSD-04002 )

Now for the issue of networked database files.  I haven't looked at this
issue in 5+ years but the way it used to work was that when a commit,
checkpoint, etc. occurs that requires a guaranteed write to disk, Oracle
does a "flush buffer" or some call like that in "c" (sorry, to long since I
wrote "c" to remember) and the issue is that the call they use was/is not
guaranteed over network drives.  So you are running a risk of a corrupted
database if some anomaly happens.  Now hardware and networking have come a
long way over the years and I'm sure there are configurations that handle
this just fine.  So you have to ask yourself, "does yours?".





   
  
  "oraora  oraora" 
  
   
  mail.com>cc: 
  
  Sent by: Subject:  how to create datafile in 
shared network drive ??   
  [EMAIL PROTECTED] 
  
   
  
   
  
  01/30/03 07:58 PM
  
  Please respond to
  
  ORACLE-L 
  
   
  
   
  




Guys,

the env. is 8.1.6/win2k.

SQL > alter tablespace test add datafile
'\\192.168.17.111\shared\test.dbf' size 100m;

ORA-01119: error in creating database file
'\\192.168.0.111\shared\test.dbf'
ORA-27040: skgfrcre: create error, unable to create file
OSD-04002: cannot open file.
O/S-Error: (OS 5) access denied.

But i have all access/permission to this drive.
i mapped this shared network drive and then tried once again.
even then i get the same error.


Is it possible to create a tablespace with datafile residing in a
shared network drive ??

TIA.

Prem.



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

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

[Brian_P_MacLean]

Doesn't anyone read the manuals any more?!

Oracle9i Installation Guide - Unix
  http://download-east.oracle.com/docs/html/A96167_01/toc.htm
Oracle9i Administrator's Reference - Unix
  http://download-east.oracle.com/docs/html/A97297_01/toc.htm




   
  
  "James Damiano"  
  
  <[EMAIL PROTECTED]To:   Multiple recipients of list 
ORACLE-L <[EMAIL PROTECTED]> 
  .nh.us>  cc: 
  
  Sent by: Subject:  Re: Unix for oracle dba -- 
Suggest a book ? 
  [EMAIL PROTECTED] 
  
   
  
   
  
  01/06/03 06:28 AM
  
  Please respond to
  
  ORACLE-L 
  
   
  
   
  




I've found a wonderful resource in the following book:

"Oracle DBA on Unix and Linux"
by Michael Wessler
http://www.samspublishing.com

It covers some of the differences in features between 8i and 9i as well as
handling the specifics of administrating Oracle specifically on Unix
platforms.  Highly recommended (at least by me).

Jim Damiano


> Guys,

> i know a bit of Linux.and not completely a newbie to Unix.

> Can u suggest me a good/best book for Unix ?
> ..Unix for oracle DBA.
> i.e,tuning unix for good performance of oracle.

> any such book available ?
> kindly let me know guys.

> TIA.
> Jp.


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

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

Win2000 vs. Unix

[Brian_P_MacLean]

A few weeks ago someone (I think it was Jared) was looking for the
pro's/con's of Win2000 vs. Unix for a SAP back-end.  I'm not a WinDoze
basher  but I do prefer to have larger back-end systems on Unix.

I came across the following links this weekend that help support some of
the my feelings and thought I would share them with the group.  Apparently
the paper originated from within MS.  I don't know if anyone else posted
the links, if so, sorry for the re-post.

http://bsd.slashdot.org/article.pl?sid=02/11/21/1413247
http://www.theregister.co.uk/content/4/28226.html
http://www.securityoffice.net/mssecrets/hotmail.html
http://www.securityoffice.net/mssecrets/hotmail.html#_Toc491601819
http://www.securityoffice.net/mssecrets/hotmail.html#_Toc491601820


Brian


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

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

RE: Anyone knowing about Unix groups

[Brian_P_MacLean]

Ah, news groups...It's where it all started for some of us old timers.

Read, Learn, & Ask.  You can browse and post via Google.

http://groups.google.com/groups?hl=en&lr
=&ie=UTF-8&group=comp.databases.oracle
http://groups.google.com/groups?hl=en&lr=&ie=UTF-8&group=comp.unix
http://groups.google.com/groups?hl=en&lr=&ie=UTF-8&group=comp.unix.shell
http://groups.google.com/groups?hl=en&lr=&ie=UTF-8&group=comp.lang.perl




   
 
  "Deshpande, Kirti"   
 
 
  erizon.com>   cc:
 
  Sent by:  Subject:  RE: Anyone knowing about 
Unix groups  
  [EMAIL PROTECTED] 
 
   
 
   
 
  11/28/02 10:04 AM
 
  Please respond to
 
  ORACLE-L 
 
   
 
   
 




http://www.ugu.com

- Kirti

-Original Message-
Sent: Thursday, November 28, 2002 2:59 AM
To: Multiple recipients of list ORACLE-L


Hallo,

anyone whom knows about any website where you can ask questions about unix
and shell-programming?

Thanks in advance.

Roland



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

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



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

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






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

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

Re: Using RECYCLE pool?

[Brian_P_MacLean]

This might me it...

http://www.dbatoolbox.com/WP2001/tuning/multiple_buffer_pools.pdf




   

  Connor McDonald  

  <[EMAIL PROTECTED]To:   Multiple recipients of list 
ORACLE-L <[EMAIL PROTECTED]>   
  uk>  cc: 

  Sent by: Subject:  Re: Using RECYCLE pool?   

  [EMAIL PROTECTED] 

   

   

  11/27/02 02:48 AM

  Please respond to

  ORACLE-L 

   

   





Assuming the stuff that you want in the recycle pool
is:

- consuming too much of your default pool
- isn't being used too much

you could so some sampling on x$bh using obj and tch
to make some conclusions.  John Beresniewicz wrote a
paper on this some time ago, but I don't have it handy
- maybe someone else can help.

hth
connor

 --- DENNIS WILLIAMS <[EMAIL PROTECTED]> wrote:
> Is anyone using the Oracle RECYCLE buffer pool? What
> was your criteria to
> select tables? The application I am considering
> RECYCLE for doesn't perform
> table scans, so that eliminates one common
> suggestion.
>
> Dennis Williams
> DBA
> Lifetouch, Inc.
> [EMAIL PROTECTED]
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> --
> Author: DENNIS WILLIAMS
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- 858-538-5051
> http://www.fatcity.com
> San Diego, California-- Mailing list and web
> hosting services
>
-
> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of
> 'ListGuru') and in
> the message BODY, include a line containing: UNSUB
> ORACLE-L
> (or the name of mailing list you want to be removed
> from).  You may
> also send the HELP command for other information
> (like subscribing).
>

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

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

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

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






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

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

[Brian_P_MacLean]

Reboot, Yeah-Right.  This is Solaris, not Windoze.

I would try having the root user do the "kill -9" after doing a "truss" on
the process it see what it's looking at.  Doing a "ipcrm" on the shared
memory segment and semaphores may also help.

Brian



   
   
  Jared.Still@radis
   
  ys.com   To:   Multiple recipients of list 
ORACLE-L <[EMAIL PROTECTED]>  
  Sent by: cc: 
   
  [EMAIL PROTECTED] Subject:  RE: Unkillable Background 
process "SHUTDOWN ABORT LEAVES UNKILLABLE  
   
   
   
   
  10/31/02 12:44 PM
   
  Please respond to
   
  ORACLE-L 
   
   
   
   
   




Reboot and open a TAR.

Jared





"Sinardy Xing" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
 10/31/2002 12:28 AM
 Please respond to ORACLE-L


To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:
Subject:RE: Unkillable Background process "SHUTDOWN ABORT
LEAVES UNKILLABLE
PROCESSES"


Hi,

I am using solaris 8


Sinardy

-Original Message-
Sent: 31 October 2002 15:43
To: Multiple recipients of list ORACLE-L
PROCESSES"


Hi all,

When I do shutdown abort my LGWR and CKPT still around and also kill -9
cannot get rid of them anyone know why ?

because of this my cluster fail to failover

Thanks

Sinardy

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

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

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



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

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





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

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

Re: * Oracle 11i DBA position in Wisconsin..

[Brian_P_MacLean]

Can you say moo-cow.

This is most likely
http://www.foremostfarms.com/aboutus/contacts/contact.asp, and if so, I
think they have been trying to fill it for about 9 months.  H, wonder
why?



   
  
  OraStaff 
  
   
  ing.com> cc: 
  
  Sent by: Subject:  * Oracle 11i DBA position in 
Wisconsin..
  [EMAIL PROTECTED] 
  
   
  
   
  
  09/11/02 10:29 AM
  
  Please respond to
  
  ORACLE-L 
  
   
  
   
  




If outdoor life is your thing then consider this company in the Wisconsin
Dells, Wisconsin
area that needs an Oracle 11i DBA to join their staff.
This area is well known for its' boating, fishing, camping, etc.

Relocation Assistance is provided.

PLEASE DO NOT send your resume for this position UNLESS you have the skills

outlined below for this position.

DO NOT send your resume unless you have a stable work history.
Candidates whose work history includes frequent job changes connot be
considered.
If you are employed by a consulting company you must have a long term
project history.

This is a full time staff position so no sub-contractors or third parties
please.

NO H-1B candidates please.


*Requirements:
-Degree preferred.
-Solid Oracle DBA experience that MUST include at least 1 yr with 11i.
-Must be a U.S. citizen or perm. resident

Base Salary is open and depends on experience.

For immediate consideration, please email your resume as an attachment to:

OraStaff, Inc.
Email: [EMAIL PROTECTED]
Phone: 1-800-549-8502.
Please Use Job Code: One/Wisconsin Dells/11i DBA/Judy

I pay referral fees.
So please contact me if you know of anyone who would be
qualified/interested
in the
position described above- if it is not a match for your skills.
Thanks.




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

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

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





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

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

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

RE: Unix scripting need help

[Brian_P_MacLean]

The few, the proud, the brave.

>From what I've seen of newer admins, developers and dba's in the last few
years, most barely know any scripting, unix or nt.sad state of affairs
isn't it.

So when ya do run into someone that knows a shell or perl well, give them a
hug and always say nice things to them.



   
  
  "Ron Thomas" 
  
   
  .com>cc: 
  
  Sent by: Subject:  RE: Unix scripting need help  
  
  [EMAIL PROTECTED] 
  
   
  
   
  
  08/26/02 05:23 PM
  
  Please respond to
  
  ORACLE-L 
  
   
  
   
  





>Blimey!  Doesn't anyone know korn shell out there any more.

AMEN!

Ron Thomas
Hypercom, Inc
[EMAIL PROTECTED]
If A = B and B = C, then A = C, except where void or prohibited by law. --
Roy Santoro



  [EMAIL PROTECTED]

   To:
[EMAIL PROTECTED]
  08/26/02 02:41 PMcc:

  Please respond toSubject:  RE: Unix scripting
need help
  ORACLE-L







Blimey!  Doesn't anyone know korn shell out there any more.  Perl perl perl
-- that's all I ever
hear anymore.  It gets old... (I'm gonna have to buy Jared's book one of
these days).

x=${file1%.log}
file_tag1=${x#mylogfile}

Kevin Kennedy
First Point Energy Corporation

If you take RAC out of Oracle you get OLE!  What can this mean?

-Original Message-
Sent: Monday, August 26, 2002 6:58 AM
To: Multiple recipients of list ORACLE-L




> For example, my files are like these
>
>mylogfile001.log
>mylogfile002.log
>
> I want to initialize my variables with those number, like this
>
> i=1
> for all_file in `ls -1 /tmp`
> do
>
>file$i=all_file
>i=i+1
> done
>
> file_tag1=`unix_command $file1 `  <--- help me here
>
> when I do
>
> echo $file_tag1
>
> it should give me 001

Is your purpose to simply display the numbers or to
generate the maximum in order to start naming new files?

If the latter seriously consider using a timestamp:

i=$(date +%Y%m%d%H%M%S);

this solves all of the math for you automaticlly. A one-
second sleep at the start of your program guarantees that
you will not re-use the names.

To get the digit strings out you could use sed or perl:

i=$( echo $file | sed -e 's/[^0-9]*//g' )

or use perl for the code instead of shell:

for( @ARGV )
{
my ($i ) = /(\d+)/;
Print "File and number: $_, $i\n";
}



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

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

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

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

Lock table table_name in exclusive mode - Performance gain?

[Brian_P_MacLean]

Anyone do any bench marking, know of any papers, or using "lock table
table_name in exclusive mode" to get a performance boost.

I'm trying to figure out how to do 90,000,000 operations
(add/change/delete) on the same table/partitions in a 4 hour period, and it
looks like lighting will have to strike twice in the same place for it to
happen.

Any other suggestions on how to cut down on the cost of a transaction.  I
know about dropping indexes, using hash keys, partitions, unrecoverable,
multi-process/threading, sql loader direct, and noarchivelog.

Help Meee!



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

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

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

RE: Unix Script Quest : Urgent

[Brian_P_MacLean]

Don't forget the "lsof" command (list open files).  Just as invaluable as
"truss".  Get it at http://www.sunfreeware.com/



   

  chris.w.johnson@b

  t.comTo:   Multiple recipients of list 
ORACLE-L <[EMAIL PROTECTED]>   
  Sent by: cc: 

  [EMAIL PROTECTED] Subject:  RE: Unix Script Quest : 
Urgent
   

   

  08/09/02 09:08 AM

  Please respond to

  ORACLE-L 

   

   





Hannah,

I'm no Unix guru either but in this situation I use 'truss',  e.g.

truss procname

HTH

Chris
  -Original Message-
  From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
  Sent: 09 August 2002 16:08
  To: Multiple recipients of list ORACLE-L
  Subject: Unix Script Quest : Urgent

  Is there a way to capture all files hit by a process/user in unix
  (Sun Solaris 9, ksh)?  I am seeing an OCI file not found on my
  production box.  I can't resovle it.

  So, I want to run the same process on my development box (where it
  works) and get a list of files that it is hitting (I can grep by
  username) for comparison in production.  Only I am definitely NOT the
  Unix guru and as this is for a prod issue, so my time is very
  limited.

  Thanks in advance,

  Hannah




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

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

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

RE: Shutdown Abort Damages Database!

[Brian_P_MacLean]

It's nice to be noticed.

Thanx all



   

  "Deshpande, Kirti"   


  erizon.com>   cc:

  Sent by:  Subject:  RE: Shutdown Abort Damages 
Database! 
  [EMAIL PROTECTED] 

   

   

  08/08/02 08:38 PM

  Please respond to

  ORACLE-L 

   

   





And on AIX as well..


A bunch of thanks to Brian for sharing the script. I am sure it will be
widely used :)

- Kirti

-Original Message-
Sent: Thursday, August 08, 2002 5:18 PM
To: Multiple recipients of list ORACLE-L


Cool.  And, as a bonus, sysresv will let you know if your SHLIB_PATH
(HP/UX)
is defined incorrectly!  :)

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

> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, August 07, 2002 5:16 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Re: Shutdown Abort Damages Database!
>
>
> Brian,
>
> The real gem here is sysresv.
>
> I've never heard of it til now.
>
> It's documented on MetaLink in Note 123322.1, and is
> the result of an enhancement request stemming
> from a bug.
>
> Thanks!
>
> Jared
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Jesse, Rich
  INET: [EMAIL PROTECTED]

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

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

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

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





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

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

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

Re: Async I/O - slightly off-topic

[Brian_P_MacLean]

Save the following code as a C program called aio.c, then a simple "gcc
aio.c -o aio" will compile it. A return value of 1 (one) confirms AIO is
available.  I run this on Solaris but it should work on HP.  Code is
followed by an example run:

11978:oracle@bart> cat aio.c
#include 
#include 
main()
{ printf("%ld\n", sysconf(_SC_ASYNCHRONOUS_IO));
}

11978:oracle@bart> aio
1



   
   
  YTTRI  Lisa  
   
  <[EMAIL PROTECTED]To:   Multiple recipients of list 
ORACLE-L <[EMAIL PROTECTED]>  
  om>  cc: 
   
  Sent by: Subject:  Async I/O - slightly 
off-topic   
  [EMAIL PROTECTED] 
   
   
   
   
   
  08/08/02 01:19 PM
   
  Please respond to
   
  ORACLE-L 
   
   
   
   
   




Hi everyone -

I am running on a unix server - HP-UX, version 11.0.  How can I tell if
async i/o is turned on?

Thanks -
Lisa

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

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

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





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

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

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

Re: Unix - scheduling - I know this, it's a UNIX system

[Brian_P_MacLean]

I knew about the start date/offset thingy, but hey, ya gotta leave him
something to figure out

As for the end of year, yeah, you're right.  Every year is a problem.
Since this is an Oracle news list we could just call Oracle from our shell
script and ask for the daze since some constant date and today, do the mod
28 math, and if it's zero, confinue to run the script, otherwise end.

I was just trying to show an inventive way to use cron.

Have a good 4th all.



   
 
  [EMAIL PROTECTED]
 
  om   To:   Multiple recipients of list 
ORACLE-L <[EMAIL PROTECTED]>
  Sent by: cc: 
 
  [EMAIL PROTECTED] Subject:  Re: Unix - scheduling - I 
know this, it's a UNIX system
   
 
   
 
  07/03/02 03:39 PM
 
  Please respond to
 
  ORACLE-L 
 
   
 
   
 






-- [EMAIL PROTECTED] on 07/03/02 14:13:30 -0800

>
> This will run the job every 28 daze at 1am.  If that's not exactly the
> definition of every 4th week let me know and I'll work something out.
Also
> note that you will have an anomaly at the end of leap years.
>
>
> 0 1 * * * /usr/bin/ksh -c '[ $(($(date '+\%j') \% 28)) -eq 0 ] &&
> /path/to/my/job/the_job'

   %j day of year (001..366)

Two problems are not adjusting the initial start date
(simple enough, adding a constant) and 365 % 28 != 0.
The last will give you an extended period once per
year. The only reliable way to handle this requries
gnu date, which has %s == system time in GMT:

[ $(( ($(date +%s) + $INITIAL_DATE_OFFSET) % 2419200 )) -eq 0 ] &&
/blah;

Is a bit grimy but works. The wallclock time may shift
slightly during the DST correction but the basic interval
works.

The one-second resolution can cause problems if crond
doesn't run exactly on the minute; this can be corrected
by taking the integer portion after dividing by 60 and
comparing that.

At which point it's better to give up on cron entirely
and use at, which does all of this mess for you and
handles cron outages also (which the above doesn't).

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

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

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





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

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

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

Re: Unix - scheduling - I know this, it's a UNIX system

[Brian_P_MacLean]

This will run the job every 28 daze at 1am.  If that's not exactly the
definition of every 4th week let me know and I'll work something out.  Also
note that you will have an anomaly at the end of leap years.


0 1 * * * /usr/bin/ksh -c '[ $(($(date '+\%j') \% 28)) -eq 0 ] &&
/path/to/my/job/the_job'







   
 
  Roland.Skoldblom@
 
  ica.se   To:   Multiple recipients of list 
ORACLE-L <[EMAIL PROTECTED]>
  Sent by: cc: 
 
  [EMAIL PROTECTED] Subject:  Unix - scheduling 
 
   
 
   
 
  07/02/02 01:43 AM
 
  Please respond to
 
  ORACLE-L 
 
   
 
   
 




Hallo,

anyone who has a good example on how to write in the crontab if you want to
schedule a job to run every four week.
Is it possible to do that in unix cron job schedule.

Thanks in advance


Roland

--






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

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

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

Re: Limited SORT_AREA_SIZE

[Brian_P_MacLean]

There are limits to amount of memory a process can attach to.  I have hit
that wall with the size of the SGA from time to time.  I would think that
limit would be associated with the sort area also, sort_area + sga if you
will.  Take a look at document
http://metalink.oracle.com/metalink/plsql/ml2_documents.showNot?p_id=1028623.6&p_font

 or just do a search on "sgabeg".

Brian P. MacLean
Oracle DBA, OCP8i



   

  DENNIS WILLIAMS  

 
  UCH.COM> cc: 

  Sent by: Subject:  Limited SORT_AREA_SIZE

  [EMAIL PROTECTED] 

   

   

  05/28/02 09:53 AM

  Please respond to

  ORACLE-L 

   

   





This weekend I was rebuilding a large table and when it came time to
rebuild
the indexes, I cranked the SORT_AREA_SIZE up to 1/2 gig. It bombed off with
an ORA-04030. I kept reducing the SORT_AREA_SIZE (bouncing the instance to
make the change) until I got it down to 150-meg. Then everything ran fine.
I
discussed this with my Unix system administrator and he felt everything was
fine from his end. I ran Oracle's maxmem utility and received:

oracle.fin7>maxmem
Memory starts at: 5369596416 (1400d8a00)
Memory ends at:   6399795195 (17d751ffb)
Memory available: 1030198779 (3d6795fb)

So it seems like I could have SORT_AREA_SIZE much higher than 150-meg. The
indexes built fine, but I am curious about the problem. Any ideas?

Oracle 8.1.6 (until Oracle gets a good 8.1.7 version)
Compaq Tru64 4.0E
4-cpu.
4-gig. of system memory.
shared_pool_size = 400-meg
This is the only instance on this server.

Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: DENNIS WILLIAMS
  INET: [EMAIL PROTECTED]

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

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





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

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

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

Re:Numeric comparison in DECODE statement

[Brian_P_MacLean]

You can do numeric logic by using the SIGN() function.  Here is the
solution I think he was looking for:

SQL@sandbox:test:8.1.7:OPS$ORACLE:12,34570>r
  1  select ltrim(decode(sign(minutes - 59), 1, to_char(minutes/60, '9.99')
||' hours',
  2 to_char(minutes)||'
minutes'
  3 )
  4  ) TIME
  5from bart
  6*  order by minutes

TIME

13 minutes
55 minutes
1.08 hours
3.50 hours

SQL@sandbox:test:8.1.7:OPS$ORACLE:12,34570>select * from bart order by 1;

  MINUTES
-
   13
   55
   65
  210




Brian P. MacLean
Oracle DBA, OCP8i



   

  [EMAIL PROTECTED] 

  Sent by: To:   Multiple recipients of list 
ORACLE-L <[EMAIL PROTECTED]>   
  [EMAIL PROTECTED] cc: 

   Subject:  Re:Numeric comparison in 
DECODE statement 
   

  05/20/02 08:38 AM

  Please respond to

  ORACLE-L 

   

   





Robert,

That won't work.  Decode works like a switch statement.  If condition 1
then
value 1.  You can't imbed logic operators therein.

DickG.

Reply Separator
Author: Yexley Robert D Contr Det 1 AFRL/WSI <[EMAIL PROTECTED]>
Date:   5/20/2002 7:08 AM

I was wondering if anyone might have tried this before, because I can't
seem to
get it to work.  I'd like to be able to determine which unit of measure to
concatenate to a value by using a decode statement in the query.  I have a
column in the database that stores time in minutes, and I'd like to be able
to
show the output in minutes if the value is less than 60, but in hours (such
as
3.27 hours) if the value is greater than 60.  So far I've tried the
following
statement, but it seems to be blowing up on the first comparison operator:

SELECT decode(in_value, to_char(to_number(in_value) <= to_number('60')),
to_char(in_value)||' minutes', to_char(to_number(in_value) > to_number
('60')),
to_char(in_value/60, '9.99')||' hours')
  FROM dual
/

I'm selecting from dual just until I can get the query working at all.  Is
what
I'm trying to do even possible?  Any help or ideas would be greatly
appreciated.
 Thanks in advance.

_YEX_

/*
|| Robert D. Yexley
|| Oracle Programmer/Analyst
|| Easylink Services Corporation
|| Professional Services
|| Contractor - Wright Research Site MIS
|| Det-1 AFRL/WSI Bldg. 45 Rm. 062
|| (937) 255-1984
|| [EMAIL PROTECTED]
|| <)))><
*/

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Yexley Robert D Contr Det 1 AFRL/WSI
  INET: [EMAIL PROTECTED]

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

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

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

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





-- 
Plea

Re: Do you ever have days where you dont want to think ?

[Brian_P_MacLean]

Don't have time to help with the query but following this link may help
with the first part:

http://images.google.com/images?hl=en&lr=&q=naked+beach

(you military guys, one tract minds...lol)

Brian P. MacLean
Oracle DBA, OCP8i



   
 
  "Johnson, Michael "  
 
 
  fmc.af.mil>   cc:
 
  Sent by:  Subject:  Do you ever have days 
where you dont want to think ?  
  [EMAIL PROTECTED] 
 
   
 
   
 
  05/17/02 02:23 PM
 
  Please respond to
 
  ORACLE-L 
 
   
 
   
 




I just just wanna go lie on a beach naked
on some remote island far far away and not
think of anything for a month.

Here is the issue.

I have a query that looks like this ...

select a.f1, a.f2, a.f3, a.f4 from table1 a
where a.f1 not in
( select b.n1 from b );

there is a primary key index on b.n1
there is a concatenated primary key index on a.f1,a.f2,a.f3
there is a non-unique index on a.f1

the query shows that the index is being used
on table b, but no indexes are being used on table a.

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

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

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





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

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

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

Re: offtopic - unix command

[Brian_P_MacLean]

Haven't used rsh in many many moons (ssh is the correct way these daze),
and I have no way to test this but maybe it will work.

RTN=$(rsh otherbox "mycmd parm1 parm2 ; [ ${?} -eq 0 ] && echo OKAY || echo
FAILED")
if echo ${RTN} | grep OKAY 1>/dev/null 2>&1
then
  echo GOOD
else
  echo BAD
fi

Another option for the first line might be:

RTN=$(rsh otherbox "if mycmd parm1 parm2
then
  echo OKAY
else
  echo FAILED
fi
)

And even another option for the first line is:

RTN=$(rsh otherbox "[ mycmd parm1 parm2 ] && echo OKAY || echo FAILED")


If you give my the ip address, the username, and add "+" to your .rhosts
file I would be happy to try it out...lol

Brian P. MacLean
Oracle DBA, OCP8i



   

  Bill Becker  

 
  .edu>cc: 

  Sent by: Subject:  offtopic - unix command   

  [EMAIL PROTECTED] 

   

   

  05/16/02 10:15 AM

  Please respond to

  ORACLE-L 

   

   





But what if command blah does not output anything? In this
case, $a is null, as it is when the command fails.

Steven Lembark wrote:

> Is there a way to check for the success/failure of the actual remote
> command when using rsh?

$a=$(rsh blah);

and parse $a for output for an indication of the blah
command succeeding or failing.

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

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

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





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

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

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

RE: Unix Script --- Archive Log Destination Issue

[Brian_P_MacLean]

I have found doing a "ps" command for your job name alone is just asking
for a world of pain, and very very unreliable for reasons that I will not
go into here.  I like to create a lock file as the following ksh example
illustrates:

JOB_LOCK="/tmp/${0##*/}"
if [ -f ${JOB_LOCK} ]
then
  cat ${JOB_LOCK} | read v_LOCK_PID
  echo "Found job lock pid ${v_LOCK_PID}"
  if ps -ef | grep " ${v_LOCK_PID} " | grep -v grep | grep ${0##*/}
>/dev/null
  then
echo "Job lock pid ${v_LOCK_PID} is running"
exit
  fi
  echo "Job lock pid ${v_LOCK_PID} not found, removing old job lock"
  rm ${JOB_LOCK}
fi
v_LOCK_PID=${$}
echo "${v_LOCK_PID}" >${JOB_LOCK}
echo "Created job file lock"
.
.the rest of your script goes here
.
rm ${JOB_LOCK}


PS: I'm looking for a new TV, think you could get me a deal at BestBuy with
your employee discount?

Brian P. MacLean
Oracle DBA, OCP8i



   
   
  "Reddy, Madhusudana" 
   
 
  estbuy.com> cc:  
   
  Sent by:Subject:  RE: Unix Script --- 
Archive Log Destination Issue 
  [EMAIL PROTECTED] 
   
   
   
   
   
  05/13/02 10:48 AM
   
  Please respond to
   
  ORACLE-L 
   
   
   
   
   




My mistake , this new script is only working sometimes. Which is scheduled
every hour , but not working at all the hour changes .

-Original Message-
Sent: Monday, May 13, 2002 11:28 AM
To: Multiple recipients of list ORACLE-L


Hello All,
I have a script, which cleans up the archive log destination by moving the
old archive logs to a retention area based on the thresholds
1. Percent of space utilization
2. greater than 2 days old.

The script was working fine , except for the reason , sometimes we see
multiple copies of the same. So I have added the following to code just to
stop multiple copies. But now the script is not running at all and we did
see more than 90% space utilization archive log destination.

Here is the added code:


# Exit If Already Running

function ExitIfAlreadyRunning
{
copies=`ps -ef | grep OraProcessArch | grep "$SID_NAME" | grep -v grep | wc
-l`
if [ $copies -gt 2 ]
then
   echo $(date)" Number Of Copies Running : $copies"
   exit 0
else
   return 0
fi
}

Any suggestions ???

I am not  so good in using semaphores and all , looking for a simple
solution if possible ..

Thanks in advance,
Madhu

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

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

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

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

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

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

RE: Excel to Oracle

[Brian_P_MacLean]

You can create an access db that acts as a passthrough from excel to
oracle,  access uses the odbc driver and excel is using the ole method (or
something like that).  Works well once you get it going.




   
 
  "Johnson, Michael "  
 
 
  fmc.af.mil>   cc:
 
  Sent by:  Subject:  RE: Excel to Oracle  
 
  [EMAIL PROTECTED] 
 
   
 
   
 
  05/08/02 05:08 PM
 
  Please respond to
 
  ORACLE-L 
 
   
 
   
 




I thought there was some ODBC driver to do this
that worked pretty well.
someone correct me if I m wrong.

Peace !

Mike
-Original Message-
Sent: Wednesday, May 08, 2002 7:43 AM
To: Multiple recipients of list ORACLE-L


Try Oraxcel... This is a tool which will help u get data off oracle or into
oracle.. Good one.

HTH

Best Regards,
Ganesh R
Tel  : +971 (4)  397 3337  Ext 420
Fax  : +971 (4)  397 6262
HP   : +971 (50) 745 6019

Live to learn... forget... and learn again.




-Original Message-
Sent: Wednesday, May 08, 2002 6:18 PM
To: Multiple recipients of list ORACLE-L


> Why should I need the possibility to directly connect to Oracle
> database from Excel program?

Very, very bad idea. Do everything inside Excel. Moreover, you can do
graphics.

--
Regards,

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

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

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

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

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

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

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





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

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

Re: where to find Oracle Installation guide for HP-UX ?

[Brian_P_MacLean]

Next time include the release/version you're looking for, ya know!!!  As
for what needs to be done as root, here's the doc's, now it's your turn to
dig.


HP-UX, 7.3.3
http://uisnt1.humboldt.edu/otn/library/doc/server73x/AR73/toc.htm
http://uisnt1.humboldt.edu/otn/library/doc/hp/server.733/a52813_1/doc.html
http://uisnt1.humboldt.edu/otn/library/doc/hp/server.733/a43837_2/toc.htm

HP-UX, 8.0.5
http://otn.oracle.com/doc/hp/server.805/a64527.pdf
http://otn.oracle.com/doc/hp/server.805/a64525.pdf
http://otn.oracle.com/doc/hp/server.805/a64526.pdf

HP-UX, 8.1.5
http://otn.oracle.com/doc/hp/server.815/a67162/toc.htm
http://otn.oracle.com/doc/hp/server.815/a67163/toc.htm

HP-UX, 8.1.6
http://otn.oracle.com/docs/products/oracle8i/pdf/hp-ux_installguide_816.pdf
http://otn.oracle.com/docs/products/oracle8i/pdf/hp-ux_adminguide_816.pdf
http://otn.oracle.com/docs/products/oracle8i/pdf/hp-ux_relnotes_816.pdf

HP-UX, 8.1.7
http://otn.oracle.com/docs/products/oracle8i/pdf/hp-ux_installguide_817.pdf
http://otn.oracle.com/docs/products/oracle8i/pdf/hp-ux_adminguide_817.pdf
http://otn.oracle.com/docs/products/oracle8i/pdf/linux_relnotes_817.pd

HP-UX, 9.0.1
http://otn.oracle.com/docs/products/oracle9i/pdf/9i_hp_relnotes.pdf
http://otn.oracle.com/docs/products/oracle9i/pdf/9i_hp_install.pdf
http://otn.oracle.com/docs/products/oracle9i/pdf/9i_hp_installcl.pdf
http://otn.oracle.com/docs/products/oracle9i/pdf/9i_unix_admin.pdf
http://otn.oracle.com/docs/products/oracle9i/pdf/9i_unix_install.pdf



http://uisnt1.humboldt.edu/otn/library/doc/hp.htm
http://otn.oracle.com/doc/hp/server.805/a64527.pdf
http://otn.oracle.com/docs/products/oracle8i/content.html
http://otn.oracle.com/docs/products/oracle9i/content.html


Brian P. MacLean
Oracle DBA, OCP8i



   

  Andrey Bronfin   

 
  esoft.com>   cc: 

  Sent by: Subject:  where to find Oracle 
Installation guide for HP-UX ?   
  [EMAIL PROTECTED] 

   

   

  05/05/02 04:03 AM

  Please respond to

  ORACLE-L 

   

   





Hi !
As weird as it sounds - i could not locate the Oracle Installation guide
for
HP-UX neither on Metalink nor on Google.
The only one i was able to find was the "Quick start guide" , which is not
a
replacement for the full one.
Could u please refer me to a URL where i can get one ?
I'm especially interested in a pre-/post-installation steps needed to be
taken as root.
Thanks a lot !


DBAndrey

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




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

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

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





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

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

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

Re: pl/sql is INTERPRETED?

[Brian_P_MacLean]

Okay then, but you are on probation for 30 daze, don't do it again ;^)

Brian



   

Jared.Still@ra 

disys.comTo: Multiple recipients of list ORACLE-L 
<[EMAIL PROTECTED]>   
Sent by: cc:   

[EMAIL PROTECTED]   Subject: Re: pl/sql is INTERPRETED?   

om 

   

   

05/02/02 04:53 

PM 

Please respond 

to ORACLE-L

   

   





Hmmm...  Appears I'm violating some of my own rules here.

My bad, I apoligize to the list.

Jared





[EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
05/02/2002 12:38 PM
Please respond to ORACLE-L


To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:
Subject:Re: pl/sql is INTERPRETED?


And here I thought this was a private message.

You have unfortunately caught me in a rather stressful
week, and I find great relief in greeting arrogance
with sarcasm.

Don't worry about it,  what I learned in a week would take you a month.

Jared





Alex <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
05/02/2002 12:23 PM
Please respond to ORACLE-L


To: Multiple recipients of list ORACLE-L
<[EMAIL PROTECTED]>
cc:
Subject:Re: pl/sql is INTERPRETED?


You must be pretty smart then. I wonder why rates for java are not $6/hr
seeing that it only takes a week to learn.
You could probably say any language is easy to learn; it is just ifs,
elses, and loops.

On Thu, 2 May 2002 [EMAIL PROTECTED] wrote:

> It ain't that tough.  We're not talking about taking a programming
> class without any experience, I've done a bit of it before.
>
> Learning all the API's, etc.: that would take some time.
>
> The language?  It isn't that difficult, though I would be
> hard put to write any at the moment.  The job I was going
> to use Java on was at Enron, and we all know what happened
> to that.
>
> It's been a year since I took the class, and I *much* prefer
> Perl.  It can run circles around Java for most stuff.
>
> Jared
>
>
>
>
>
> Alex <[EMAIL PROTECTED]>
> Sent by: [EMAIL PROTECTED]
> 05/02/2002 08:23 AM
> Please respond to ORACLE-L
>
>
> To: Multiple recipients of list ORACLE-L
<[EMAIL PROTECTED]>
> cc:
> Subject:Re: pl/sql is INTERPRETED?
>
>
> It took you a week to learn it? Then you obviously do not know it.
> Syntax is one thing design is another. I would love to know what you
> learned in that week.
>
>
> On Thu, 2 May 2002, Jared Still wrote:
>
> >
> > Hold on Lisa!
> >
> > Java is not complex.  It's a very simple language
> > actually.  It took me a week to learn it, though I'm
> > not using it now:  I much prefer Perl.
> >
> > Getting a handle on all of the libraries and API's is
> > another story, but Java as a language is pretty simple.
> >
> > Jared
> >
> > On Tuesday 30 April 2002 11:14, Koivu, Lisa wrote:
> > > You have a point Chris, but pl/sql is nowhere near as complex as an
OO
> > > language like java or C++, IMHO.  I agree with Tom that pl/sql can
be
> > > learned fairly easily in comparison to the many other choices out
> there.
> > > However, it takes a bit of database savvy to do it correctly.  (Not
> much
> > > tho)
> > >
> > > I was amazed in my "database" class in college that the same people
> failing
> > > the simple entity-relationship modeling portion of the class that
had
> aced
> > > the Op Systems and networking classes we took.  I nearly failed both
> > > classes, they were so complex.  I was the teacher's pet in the db
> class
> > > because I asked him questions that made him think, and he sometimes
> > > couldn't answer.  (And I had to wear a skirt - night student,
straight
> from
> > > work.)

Re: pl/sql is INTERPRETED?

[Brian_P_MacLean]

Recess is over children.  Let it go. Time to get back to work.

Jeeze


By the way Alex, nice to see another m-net.arbornet.org user on the list.


Brian P. MacLean
Oracle DBA, OCP8i



   

Jared.Still@ra 

disys.comTo: Multiple recipients of list ORACLE-L 
<[EMAIL PROTECTED]>   
Sent by: cc:   

[EMAIL PROTECTED]   Subject: Re: pl/sql is INTERPRETED?   

om 

   

   

05/02/02 12:33 

PM 

Please respond 

to ORACLE-L

   

   





Watch for my new book!

Learn Java  in 20 minutes and earn BIG 

Jared






Alex <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
05/02/2002 08:23 AM
Please respond to ORACLE-L


To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:
Subject:Re: pl/sql is INTERPRETED?


It took you a week to learn it? Then you obviously do not know it.
Syntax is one thing design is another. I would love to know what you
learned in that week.






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

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

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




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

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

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

Re: SIMPLE QUESTION - old answer

[Brian_P_MacLean]

See my old posting at
http://faqchest.dynhost.com/prgm/oracle-l/ora-01/ora-0105/ora-010521/ora01052411_15995.html


Brian P. MacLean
Oracle DBA, OCP8i



   
 
Hamid Alavi
 
   
ovadx.com>cc:  
 
Sent by:  Subject: SIMPLE QUESTION 
 
[EMAIL PROTECTED]
 
m  
 
   
 
   
 
05/01/02 10:18 
 
AM 
 
Please respond 
 
to ORACLE-L
 
   
 
   
 




HI AGAIN,

JUST WANT TO CHECK WITH YOU GUYS, MY LISTENER.LOG IS GETTING BIG I TRY TO
RENAME IT THEN CREATE A NEW LISTENER.LOG BUT STILL THE OLD ONE IS USING BY
ORACLE.
HOW CAN I TRUNCATE THE LISTENER.LOG OR CAN I JUST SIMPLY DELETE IT OR NOT?
THANKS FOR HELP.




Hamid Alavi
Office 818 737-0526
Cell818 402-1987






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


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

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

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




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

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

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

Re: Which Unix command (part 2)

[Brian_P_MacLean]

Here is another jewel I picked up from the shell news groups years and
years ago.

6409:oracle@bart> cat dtree
#!/bin/ksh
# usage: vtree [-a] [dir] : make a tree printout of the specified
directory.
[ X$1 = X-a ] && andfiles=ON shift
[ $# = 0 ] && set .
set X "$@"
until   shift
[ $# = 0 ]
do  [ ! $# = 1 ] && echo
cd $1 || continue
echo "${BOLD}--- ${PWD} in KBytes
---${PLAIN}"
du -k ${andfiles:+-a} | sort +1f | awk '{ print $2 "-" $1 }' |
sed \
-e 's/^\([0-9]*\)   \(.*\)$/\2 \ (\1)/' \
-e "s#^$1##" \
-e 's#[^/]*/\([^/]*\)$#|\1#' \
-e 's#[^/]*/#| \ \ \ #g' | awk -F"-" '{printf ("%10s %s\n", $6, $1)
}'
done

Brian P. MacLean
Oracle DBA, OCP8i



   

Brian P

MacLean  To: [EMAIL PROTECTED]  

 cc: [EMAIL PROTECTED]

04/29/02 01:17   Subject: Re: Which Unix command(Document 
link: Brian P MacLean)   
PM 

   

   




I build/keep several functions in my .profile file (see below).  They are
all simple enough to call at anytime.  Have fun

 Function  Description
  
 findc  find files
 findl  find large files
 findn  find files created/accessed in the last day
 findo  find open files



function findc
{
find . -name "*${1}*" -print 2>/dev/null | more
}

function findl
{
  OPT_d="."
  OPT_s="1"
  OPT_n="38,12"
  while getopts d:ns:h option
  do
case "${option}"
in
   d)  OPT_d="${OPTARG}" ;;
   n)  OPT_n="63,60" ;;
   s)  OPT_s="${OPTARG}" ;;
   h | \?) echo "usage: findl [-h] [-d starting directory] -n [-s
size_meg]"
   echo "   -d defaults to the current directory"
   echo "   -n default sort is by size, if -n is specified
then the sort is by path and name"
   echo "   -s list files greater than or equal to 'n' meg,
defaults to 1"
   return;;
esac
  done
  DMY=$(echo "${OPT_s}" | tr "[0-9]" "[\0*10]")
  if [ ${#DMY} -ne 0 ]
  then
echo "Invalid value for option -s"; return
  fi
  [ "${OPT_s}" = "" ] && v_size=1048576 || v_size=$((${OPT_s} * 1048576))
  find ${OPT_d} -size +${v_size}c -type file 2>/dev/null |
\
xargs -n 20 ls -Fla {} 2>/dev/null |
\
awk '{printf ("%10.10s %3.3s %-10.10s %-10.10s %12s %3.3s %2.2s %5.5s
%s %s %s %s\n",   \
  $1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12) }' 2>&1 |
\
sort -k .${OPT_n}
}

function findn
{
  find . -name "*${1}*" -ctime -1 -type f -print | sort | while read F
  do
echo "$(ls -Fla ${F}) $(fuser ${F} 2>/dev/null | cut -c1-60)"
  done | \
awk '{printf ("%10.10s %3.3s %-10.10s %-10.10s %12s %3.3s %2.2s %5.5s
%s %s %s %s %s %s %s %s %s %s %s %s\n", \
  $1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15,
$16, $17, $18, $19, $20) }' 2>&1 | sort -k .38,12
}

function findo
{
  find . -name "*${1}*" -ctime -1 -type f -print | sort | while read F
  do
v_CNT=$(fuser ${F} 2>/dev/null | wc -w)
if [ ${v_CNT} -ne 0 ]
then
  echo "$(ls -Fla ${F}) $(fuser ${F} 2>/dev/null | cut -c1-60)"
fi
  done | \
awk '{printf ("%10.10s %3.3s %-10.10s %-10.10s %12s %3.3s %2.2s %5.5s
%s %s %s %s %s %s %s %s %s %s %s %s\n", \
  $1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15,
$16, $17, $18, $19, $20) }' 2>&1 | sort -k .38,12
}

Brian P. MacLean
Oracle DBA, OCP8i



   
 
"Seema Singh"  
 

tmail.com>   cc:   
 
Sent by: Subject: WHich Unix command   
 
[EMAIL PROTECTED] 
 
om 
 
  

Re: Which Unix command

[Brian_P_MacLean]

I build/keep several functions in my .profile file (see below).  They are
all simple enough to call at anytime.  Have fun

 Function  Description
  
 findc  find files
 findl  find large files
 findn  find files created/accessed in the last day
 findo  find open files



function findc
{
find . -name "*${1}*" -print 2>/dev/null | more
}

function findl
{
  OPT_d="."
  OPT_s="1"
  OPT_n="38,12"
  while getopts d:ns:h option
  do
case "${option}"
in
   d)  OPT_d="${OPTARG}" ;;
   n)  OPT_n="63,60" ;;
   s)  OPT_s="${OPTARG}" ;;
   h | \?) echo "usage: findl [-h] [-d starting directory] -n [-s
size_meg]"
   echo "   -d defaults to the current directory"
   echo "   -n default sort is by size, if -n is specified
then the sort is by path and name"
   echo "   -s list files greater than or equal to 'n' meg,
defaults to 1"
   return;;
esac
  done
  DMY=$(echo "${OPT_s}" | tr "[0-9]" "[\0*10]")
  if [ ${#DMY} -ne 0 ]
  then
echo "Invalid value for option -s"; return
  fi
  [ "${OPT_s}" = "" ] && v_size=1048576 || v_size=$((${OPT_s} * 1048576))
  find ${OPT_d} -size +${v_size}c -type file 2>/dev/null |
\
xargs -n 20 ls -Fla {} 2>/dev/null |
\
awk '{printf ("%10.10s %3.3s %-10.10s %-10.10s %12s %3.3s %2.2s %5.5s
%s %s %s %s\n",   \
  $1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12) }' 2>&1 |
\
sort -k .${OPT_n}
}

function findn
{
  find . -name "*${1}*" -ctime -1 -type f -print | sort | while read F
  do
echo "$(ls -Fla ${F}) $(fuser ${F} 2>/dev/null | cut -c1-60)"
  done | \
awk '{printf ("%10.10s %3.3s %-10.10s %-10.10s %12s %3.3s %2.2s %5.5s
%s %s %s %s %s %s %s %s %s %s %s %s\n", \
  $1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15,
$16, $17, $18, $19, $20) }' 2>&1 | sort -k .38,12
}

function findo
{
  find . -name "*${1}*" -ctime -1 -type f -print | sort | while read F
  do
v_CNT=$(fuser ${F} 2>/dev/null | wc -w)
if [ ${v_CNT} -ne 0 ]
then
  echo "$(ls -Fla ${F}) $(fuser ${F} 2>/dev/null | cut -c1-60)"
fi
  done | \
awk '{printf ("%10.10s %3.3s %-10.10s %-10.10s %12s %3.3s %2.2s %5.5s
%s %s %s %s %s %s %s %s %s %s %s %s\n", \
  $1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15,
$16, $17, $18, $19, $20) }' 2>&1 | sort -k .38,12
}

Brian P. MacLean
Oracle DBA, OCP8i



   
 
"Seema Singh"  
 

tmail.com>   cc:   
 
Sent by: Subject: WHich Unix command   
 
[EMAIL PROTECTED] 
 
om 
 
   
 
   
 
04/29/02 12:08 
 
PM 
 
Please respond 
 
to ORACLE-L
 
   
 
   
 




Hi
Which unix command(On Solaris) is used to find latest biggest files on
whole
server?
or
Which unix command(On Solaris) is used to find latest biggest files on
particular disk partition?
Thx
-seema



_
MSN Photos is the easiest way to share and print your photos:
http://photos.msn.com/support/worldwide.aspx

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

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

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

RE: Unix - Writing stderr to a file and stdout

[Brian_P_MacLean]

Does this do it?  STDOUT is directed to stdout.log.  STDERR is directed to
the stdout.log and stderr.log.  I did it using dtksh shell but should work
in standard ksh shell.


#!/usr/dt/bin/dtksh
rm PIPE stdout.log stderr.log
mknod PIPE p
touch stdout.log
tee -a stdout.log stderr.log &
find . -name "*Z" -print 1>>stdout.log 2>>PIPE



Brian P. MacLean
Oracle DBA, OCP8i



   

Mohammed.Ahsanuddin@VerizonWi  

reless.com  To: Multiple recipients of 
list ORACLE-L <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]   cc:

Subject: RE: Unix - 
Writing stderr to a file and stdout
   

04/26/02 12:04 PM  

Please respond to ORACLE-L 

   

   





Hi,

I think I did not explain my request properly..let me try again.

Is it possible to write stderr to stdout and to another file
simultaneously..?

For Ex:

ls -l > outfile 2>&1 will get me command output and diagnostics info in the
same file which is outfile.

However, I am trying to get the diagnostics info into outfile as well as
into another file (say errfile). Would that be possible? I was not able to
do it with tee either..

Thanks

Mohammed Ahsanuddin
Oracle DBA
Verizon Wireless
Work : 845 365 7203
Pager : 800 366 2337 pin : 16040



-Original Message-
Sent: Friday, April 26, 2002 1:56 PM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]


But of course

find . -print | xargs grep "hoser"

This will generate errors on directories

Make the errors disappear:

 find . -print | xargs grep "hoser"  2>/dev/null

Now send the standard output to a file.  Make sure the
file is outside the directory structure you are searching.

 find . -print | xargs grep "hoser"  2>/dev/null 1>/tmp/hoser.txt

Jared






[EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
04/26/2002 11:30 AM
Please respond to ORACLE-L


To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:
Subject:Unix - Writing stderr to a file and stdout


Hi,

Is it possible to write stderr to stdout and to another file
simultaneously..?

Thanks in advance.

Mohammed Ahsanuddin
Oracle DBA

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

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

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


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

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

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




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

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

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

Re: EMC Storage Array Issue

[Brian_P_MacLean]

ROFLOL

Gosh, we don't know why, must be the databases fault, all 15 of them.

Thanx for giving me a Friday Funny..BOL




   
 
Scott Canaan   
 

.rit.edu>cc:   
 
Sent by: Subject: Re: EMC Storage Array Issue  
 
[EMAIL PROTECTED] 
 
om 
 
   
 
   
 
04/19/02 02:09 
 
PM 
 
Please respond 
 
to ORACLE-L
 
   
 
   
 




Since I started this thread, I thought I'd update everyone on what the
problem ended up being.  There is a problem with one of the power supplies
on the switch in the SAN.  The other power supply was not plugged in, so it
halted everything occasionally.  We plugged the other power supply in, and
haven't had the problem since.  Now we need to get the power supply
replaced.  Interesting that EMC tried to blame it on Oracle first.

Scott Canaan wrote:

> We have implemented a Sun Solaris Cluster (4 machines), connected to
> an EMC storage array.  The migration began last fall, and we now have 15
> Oracle instances, with a mixture of 8.1.6 and 8.1.7, located there.  We
> recently have had 2 occurances of asynchronous I/O wait times exceeded.
> When this occurs, every database crashes at the same time.  The solution
> from EMC is to turn asynchronous I/O off in all of the Oracle instances
> (disk_async_io = false) and to increase the database writer slaves
> (dbwr_io_slaves = ) to emulate asynchronous I/O.
> Has anyone run into this problem before?  If so, how did you
> "correct" it?  My feeling is that EMC is trying to give us a bandage to
> cover up the real problem, by trying to get Oracle to ignore it.
>
> Thank you.
>
> --
> Scott Canaan ([EMAIL PROTECTED])
> (585) 475-7886
> "Life is like a sewer, what you get out of it depends on what you put
> into it" - Tom Lehrer
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Scott Canaan
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).

--
Scott Canaan ([EMAIL PROTECTED])
(585) 475-7886
"Life is like a sewer, what you get out of it depends on what you put into
it" - Tom Lehrer


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

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

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




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

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

RE: ORA-00600: internal error code, arguments: [4400], [48]

[Brian_P_MacLean]

Search on "ora-00600 lookup", it should come up as the first doc on the
list.

Brian P. MacLean
Oracle DBA, OCP8i



   
 
Paul Vincent   
 

uce.ac.uk>   cc:   
 
Sent by: Subject: RE: ORA-00600: internal error 
code, arguments: [4400], [48]   
[EMAIL PROTECTED] 
 
om 
 
   
 
   
 
04/19/02 05:03 
 
AM 
 
Please respond 
 
to ORACLE-L
 
   
 
   
 




Purely out of interest, Brian, how do you find this page within MetaLink? I
always prefer being able to navigate to these things myself within
MetaLink,
rather than having loads of bookmarks to specific MetaLink pages, but when
I
tried to find it, I didn't even know where to start looking! Can you tell
me
the navigation sequence, starting from the front page?

Thanks,

Paul

-Original Message-
Sent: 18 April 2002 20:49
To: Multiple recipients of list ORACLE-L



Follow the link, put in your Oracle version, first argument of the
ORA-00600, and paste the top of your stack trace, and wha-lait's magic,
or what I like to call "FM".

http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_datab

ase_id=NOT&p_id=153788.1


Brian P. MacLean
Oracle DBA, OCP8i
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Paul Vincent
  INET: [EMAIL PROTECTED]

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

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




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

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

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

Re: Number of CPUs vs. Speed of CPUs

[Brian_P_MacLean]

I may be blowing smoke out my back side but here is my opinion:  Fewer and
Faster

Reasons:

I think Oracle has started to license by cpu instead of the power units
thing.  So if it is cpu number, then fewer and faster is cheaper.

Oracle also "was" and may still be licensing based on maximum box capacity.
So if you have 2 machines that are both 4 way (4 cpu's installed), but
machine one max'es at a 4 way and the second machine max'es at a 10 way,
you pay more for each license on the 10 way than the 4 way even thought the
10 way is using just 4 cpu's.  Doesn't make much sense to me but that's how
pricing worked last fall.

>From an OS level, when cpu's are added it's a diminishing return issue.  So
historically a "4 x 800mhz" is faster than a "8 x 400mhz".



Brian P. MacLean
Oracle DBA, OCP8i



   
 
YTTRI  Lisa
 

h.com>   cc:   
 
Sent by: Subject: Number of CPUs vs. Speed of CPUs 
 
[EMAIL PROTECTED] 
 
om 
 
   
 
   
 
04/18/02 08:58 
 
AM 
 
Please respond 
 
to ORACLE-L
 
   
 
   
 




We are in the process of sizing a new server for multiple Oracle instances.
What factors are useful as input in determining how many CPUs and the
relative speed of them?  For example, do we want fewer, faster CPUs or do
we
want more, slower CPUs?  Are there any good guidelines to determine what
the
number of CPUs should be?

Thanks in advance -
Lisa

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

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

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




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

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

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

Re: ORA-00600: internal error code, arguments: [4400], [48]

[Brian_P_MacLean]

Follow the link, put in your Oracle version, first argument of the
ORA-00600, and paste the top of your stack trace, and wha-lait's magic,
or what I like to call "FM".

http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=NOT&p_id=153788.1


Brian P. MacLean
Oracle DBA, OCP8i



   
 
"Smith, Ron
 
L."  To: Multiple recipients of list ORACLE-L 
<[EMAIL PROTECTED]>
<[EMAIL PROTECTED]   cc:   
 
om>  Subject: ORA-00600: internal error code, 
arguments: [4400], [48]   
Sent by:   
 
[EMAIL PROTECTED] 
 
om 
 
   
 
   
 
04/18/02 10:03 
 
AM 
 
Please respond 
 
to ORACLE-L
 
   
 
   
 




I am getting an ORA-00600: internal error code, arguments: [4400], [48] in
my production data warehouse database.  Running on version 8.1.7.2.1
Solaris
10.20 32 bit.

We are also having trouble with Packages that load data into the database
reporting a normal completion but in fact it only loads a portion of the
records.  A rerun of the Package runs to completion and loads all the rows.
No error is reported in the alertlog during the time of the data load.

Any help would be appreciated.

Ron Smith
DBA
Kerr-McGee Corp
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Smith, Ron L.
  INET: [EMAIL PROTECTED]

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

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




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

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

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

Re: Ang: Re:Import excelfile into Oracle table

[Brian_P_MacLean]

A simple search of Google:

 http://www.google.com/search?sourceid=navclient&q=utl%5Ffile+example

 Gives the following on the first page:

 http://www.geocities.com/suresh_vemulapalli/utl.htm
 http://utplsql.sourceforge.net/Doc/admin.html
 http://www.classicity.com/oracle/htdocs/forums/ClsyForumID125/11.html#

http://download-east.oracle.com/otndoc/oracle9i/901_doc/appdev.901/a89852/utl_file.htm


Brian P. MacLean
Oracle DBA, OCP8i



   
 
Roland.Skoldbl 
 
[EMAIL PROTECTED]To: Multiple recipients of list ORACLE-L 
<[EMAIL PROTECTED]>
Sent by: cc:   
 
[EMAIL PROTECTED]   Subject: Ang: Re:Import excelfile into 
Oracle table
om 
 
   
 
   
 
04/18/02 02:38 
 
AM 
 
Please respond 
 
to ORACLE-L
 
   
 
   
 





Ok, thanks can you give me a good example on how to write the pl/sql code?

Thanks in advance.

Roland





[EMAIL PROTECTED]@fatcity.com den 2002-04-18 01:10 PST

Sänd svar till [EMAIL PROTECTED]

Sänt av:  [EMAIL PROTECTED]


Till: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Kopia:


Hi,
You'd better do the following:
* Convert the excel file to .csv file.
* Use utl_file package to read the data and insert to Oracle Tables.


M.Emre HANCIOGLU
Masterfoods GmbH








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

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

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




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

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

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

RE: MySQL vs. Oracle database

[Brian_P_MacLean]

Older link but still some food for thought ->
http://openacs.org/philosophy/why-not-mysql.html

Brian P. MacLean
Oracle DBA, OCP8i



   
 
"Weaver, Walt" 
 

now.com> cc:   
 
Sent by: Subject: RE: MySQL vs. Oracle database
 
[EMAIL PROTECTED] 
 
om 
 
   
 
   
 
04/17/02 10:45 
 
AM 
 
Please respond 
 
to ORACLE-L
 
   
 
   
 




Well, MySQL and Oracle are very different, but there's a world of
difference
between MySQL and Access too. It's quite possible to use MySQL as a backend
database for web hosting and get good performance and decent reliability. I
haven't heard of Access being used for that sort of thing.

--Walt Weaver
  Bozeman, Montana

-Original Message-
Sent: Wednesday, April 17, 2002 11:03 AM
To: Multiple recipients of list ORACLE-L


Check google. Anyway they are completely different. MySQL is more like
Access than Oracle.

On Wed, 17 Apr 2002, Nguyen, David M wrote:

> What is different between MySQL and Oracle database?  Someone says they
are
> the same as they are just database.  From DBA or developer point of view,
> what do you say?
>
> Thanks,
> David
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Nguyen, David M
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
>

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

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

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

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

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




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

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

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

Re: Unix script

[Brian_P_MacLean]

Oops.  The line

"echo "#Ending ${0##*/} at $(date) with an exit status of ${1}""

should have been

echo "#Ending ${0##*/} at $(date) with an exit status of ${STATUS}"





   

Brian P

MacLean  To: [EMAIL PROTECTED]  

 cc: [EMAIL PROTECTED]   

04/16/02 09:06   Subject: Re: Unix script(Document link: 
Brian P MacLean)  
AM 

   

   






Still room for improvement but enough changes to keep you busy for awhile.
Please note that I changed the script to use ksh shell (required by several
of the commands I added) and the "exec" command that will redirect all
script text output to a common file so that you don't have to redeclare the
output file with each "tail" and "echo" command.  Have fun..


#!/bin/ksh
JOB_LOG=/d31/appl/konto/log/laddabilbo.txt
exec 1>${JOB_LOG} 2>&1
. /usr/bin/orasetup.sh
. /d31/appl/konto/bat/movefiles.sh
STATUS=0
echo "
###"
echo "#Starting ${0##*/} at $(date)"
echo "#"
sqlldr userid=konto/icakort control=/d31/appl/konto/bat/ehbgrupp.ctl
log=/d31/appl/konto/log/ehbgrupp.log
STATUS=$((${STATUS} + ${?}))
sqlldr userid=konto/icakort control=/d31/appl/konto/bat/kampanj.ctl
log=/d31/appl/konto/log/kampanj.log
STATUS=$((${STATUS} + ${?}))
sqlldr userid=konto/icakort control=/d31/appl/konto/bat/mxurval.ctl
log=/d31/appl/konto/log/mxurval.log
STATUS=$((${STATUS} + ${?}))
sqlldr userid=konto/icakort control=/d31/appl/konto/bat/load_arg.ctl
log=/d31/appl/konto/log/load_arg.log
STATUS=$((${STATUS} + ${?}))
sqlldr userid=konto/icakort control=/d31/appl/konto/bat/laddabsg.ctl
log=/d31/appl/konto/log/laddabsg.log
STATUS=$((${STATUS} + ${?}))
sqlplus -s konto/icakort << !
  whenever sqlerror exit 1
  set heading off
  set verify off
  set feedback off
  set termout off
  set pages 0
  begin
  konto.fillbilbotables.anrop;
  END;
/
  EXIT
!
STATUS=$((${STATUS} + ${?}))

echo "--"
echo "ehbgrupp  status "
tail -11 /d31/appl/konto/log/ehbgrupp.log
echo "--"
echo "--"
echo "kampanj  status "
tail -11 /d31/appl/konto/log/kampanj.log
echo "--"
echo "--"
echo "mxurval  status "
tail -11 /d31/appl/konto/log/mxurval.log
echo "--"
echo "--"
echo "load_arg  status "
tail -11 /d31/appl/konto/log/load_arg.log
echo "--"
echo "--"
echo "laddabsg  status "
tail -11 /d31/appl/konto/log/laddabsg.log
echo "--"
echo "Jobb klart! :\c"
date

v_error_sum=0
egrep "Total logical records skipped|Total logical records rejected|Total
logical records discarded"  \
/d31/appl/konto/log/ehbgrupp.log /d31/appl/konto/log/kampanj.log
/d31/appl/konto/log/mxurval.log  \
/d31/appl/konto/log/load_arg.log /d31/appl/konto/log/laddabsg.log
|
  cut -d":" -f2 | while read v_error_number
do
  v_error_sum=$((${v_error_sum} + ${v_error_number}))
done
if [ ${v_error_sum} -gt 0 ]
then
  STATUS=$((${STATUS} + 1))
fi

echo "#"
echo "#Job run time was: $((${SECONDS} / 3600)) hours, $(((${SECONDS} %
3600) / 60)) minutes, $((${SECONDS} % 60)) seconds"
echo "#"
echo "#Ending ${0##*/} at $(date) with an exit status of ${1}"
echo "
###"

if [ ${STATUS} -gt 0 ]
then
  cat /d31/appl/konto/log/laddabilbo.txt \
| mailx -s "Konto - Statusrapport" [EMAIL PROTECTED]
[EMAIL PROTECTED] [EMAIL PROTECTED]
fi
#
# END-OF-SCRIPT
###





Brian P. MacLean
Oracle DBA, OCP8i



   
 
Roland.Skoldbl 
 
[EMAIL PROTECTED]To: Multiple recipients

Re: Database shutdown

[Brian_P_MacLean]

Try  "shutdown abort", takes about 2 seconds...works for me (ROFLOL)

If you are doing a "shutdown" or "shutdown normal" (same things) then
Oracle waits for all sessions to disconnect, flushes everything, and
checkpoints the database, could be a long wait.

If you are doing a "shutdown immediate" then all sessions will be
terminated, uncommitted transactions rolled back, the buffer cache needs to
be flushed, and the database will be checkpointed.  Can take awhile if your
checkpoints are spaced far apart.

If you do a "shutdown abort" be aware that cache recovery must be done on
instance startup so startup may take a few minutes, again depending how
long your checkpoints are spaced.

(Trying to remember all of the above from memory, and I'm getting old.  So
if any of it is incorrect, remember, the consulting fee cost $0.00)

Brian P. MacLean
Oracle DBA, OCP8i



   
 
"Nguyen, David 
 
M"   To: Multiple recipients of list ORACLE-L 
<[EMAIL PROTECTED]>
Subject: Database shutdown
 
Sent by:   
 
[EMAIL PROTECTED] 
 
om 
 
   
 
   
 
04/16/02 09:03 
 
AM 
 
Please respond 
 
to ORACLE-L
 
   
 
   
 




Does any know why it takes too long (about 40 minutes) to shutdown oracle
database?  I am running oracle8.0.5 on solari5.6.  It usually just takes me
few minutes to shutdown.

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

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

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




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

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

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

Re: Unix script

[Brian_P_MacLean]

Still room for improvement but enough changes to keep you busy for awhile.
Please note that I changed the script to use ksh shell (required by several
of the commands I added) and the "exec" command that will redirect all
script text output to a common file so that you don't have to redeclare the
output file with each "tail" and "echo" command.  Have fun..


#!/bin/ksh
JOB_LOG=/d31/appl/konto/log/laddabilbo.txt
exec 1>${JOB_LOG} 2>&1
. /usr/bin/orasetup.sh
. /d31/appl/konto/bat/movefiles.sh
STATUS=0
echo "
###"
echo "#Starting ${0##*/} at $(date)"
echo "#"
sqlldr userid=konto/icakort control=/d31/appl/konto/bat/ehbgrupp.ctl
log=/d31/appl/konto/log/ehbgrupp.log
STATUS=$((${STATUS} + ${?}))
sqlldr userid=konto/icakort control=/d31/appl/konto/bat/kampanj.ctl
log=/d31/appl/konto/log/kampanj.log
STATUS=$((${STATUS} + ${?}))
sqlldr userid=konto/icakort control=/d31/appl/konto/bat/mxurval.ctl
log=/d31/appl/konto/log/mxurval.log
STATUS=$((${STATUS} + ${?}))
sqlldr userid=konto/icakort control=/d31/appl/konto/bat/load_arg.ctl
log=/d31/appl/konto/log/load_arg.log
STATUS=$((${STATUS} + ${?}))
sqlldr userid=konto/icakort control=/d31/appl/konto/bat/laddabsg.ctl
log=/d31/appl/konto/log/laddabsg.log
STATUS=$((${STATUS} + ${?}))
sqlplus -s konto/icakort << !
  whenever sqlerror exit 1
  set heading off
  set verify off
  set feedback off
  set termout off
  set pages 0
  begin
  konto.fillbilbotables.anrop;
  END;
/
  EXIT
!
STATUS=$((${STATUS} + ${?}))

echo "--"
echo "ehbgrupp  status "
tail -11 /d31/appl/konto/log/ehbgrupp.log
echo "--"
echo "--"
echo "kampanj  status "
tail -11 /d31/appl/konto/log/kampanj.log
echo "--"
echo "--"
echo "mxurval  status "
tail -11 /d31/appl/konto/log/mxurval.log
echo "--"
echo "--"
echo "load_arg  status "
tail -11 /d31/appl/konto/log/load_arg.log
echo "--"
echo "--"
echo "laddabsg  status "
tail -11 /d31/appl/konto/log/laddabsg.log
echo "--"
echo "Jobb klart! :\c"
date

v_error_sum=0
egrep "Total logical records skipped|Total logical records rejected|Total
logical records discarded"  \
/d31/appl/konto/log/ehbgrupp.log /d31/appl/konto/log/kampanj.log
/d31/appl/konto/log/mxurval.log  \
/d31/appl/konto/log/load_arg.log /d31/appl/konto/log/laddabsg.log
|
  cut -d":" -f2 | while read v_error_number
do
  v_error_sum=$((${v_error_sum} + ${v_error_number}))
done
if [ ${v_error_sum} -gt 0 ]
then
  STATUS=$((${STATUS} + 1))
fi

echo "#"
echo "#Job run time was: $((${SECONDS} / 3600)) hours, $(((${SECONDS} %
3600) / 60)) minutes, $((${SECONDS} % 60)) seconds"
echo "#"
echo "#Ending ${0##*/} at $(date) with an exit status of ${1}"
echo "
###"

if [ ${STATUS} -gt 0 ]
then
  cat /d31/appl/konto/log/laddabilbo.txt \
| mailx -s "Konto - Statusrapport" [EMAIL PROTECTED]
[EMAIL PROTECTED] [EMAIL PROTECTED]
fi
#
# END-OF-SCRIPT
###





Brian P. MacLean
Oracle DBA, OCP8i



   
 
Roland.Skoldbl 
 
[EMAIL PROTECTED]To: Multiple recipients of list ORACLE-L 
<[EMAIL PROTECTED]>
Sent by: cc:   
 
[EMAIL PROTECTED]   Subject: Unix script  
 
om 
 
   
 
   
 
04/15/02 11:43 
 
PM 
 
Please respond 
 
to ORACLE-L
  

Running tunefs on Solaris with Oracle

[Brian_P_MacLean]

OS: Solaris, 2.7
Oracle: v8.1.7

Anyone mess around with tuning file systems to be optimized for Oracle with
the "tunefs" command.  I've messed with the "-m minfree" parameter before
but that is a usable/free space issue, not really a performance issue.  I'm
looking at the "-e maxbpg" parameter now.  The last line of the man pages
reads "For file systems with exclusively large files, this parameter should
be set higher".  Google, IXORA, Metalink, and Sun searches didn't turn up
anything

Opinions, links, experiences  Anyone?

The man page reads as follows:


 -e maxbpg Indicate the maximum number of blocks  any  single
   file  can  allocate out of a cylinder group before
   it is  forced  to  begin  allocating  blocks  from
   another  cylinder  group.  Typically this value is
   set to approximately  one  quarter  of  the  total
   blocks  in  a  cylinder  group.  The  intent is to
   prevent any single file  from  using  up  all  the
   blocks  in a single cylinder group, thus degrading
   access times for all files subsequently  allocated
   in  that  cylinder group. The effect of this limit
   is to cause big files to do long seeks  more  fre-
   quently  than if they were allowed to allocate all
   the blocks in  a  cylinder  group  before  seeking
   elsewhere. For file systems with exclusively large
   files, this parameter should be set higher.

TIA

Brian P. MacLean
Oracle DBA, OCP8i


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

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

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

Re: Archival Freeze - Painful lessons learned

[Brian_P_MacLean]

After reading the other postings I better add this one too;^) (If ya didn't
learn something new today, it's because ya didn't do anything today).

ORA-00257,  "archiver error. Connect internal only, until freed."

Brian P. MacLean
Oracle DBA, OCP8i



   

Brian P

MacLean  To: [EMAIL PROTECTED]  

 cc: [EMAIL PROTECTED]   

04/12/02 02:19   Subject: Re: Archival Freeze - Painful 
lessons learned(Document link: 
PM   Brian P MacLean)  

   

   




As Daffy Duck says -> http://www.dailywav.com/0700/dcorrect.wav

The archiver freaks first, and will keep trying to write/recover/looking
for space. But the database will not hang until all the redo logs are full
and none remain that have been archived (ie: all redo logs need archiving).

The error in the alert.log is some combination of:

ORA-00255, "error archiving log %s of thread %s, sequence # %s"
ORA-00270, "error creating archive log %s"
ORA-19504, "failed to create file \"%s\""
ORA-27040, "skgfrcre: create error, unable to create file"
ARCH: Archival stopped, error occurred. Will continue retrying
SVR4 Error: 5: I/O error

Why do I have a list of the above errors you ask?  Because I've been there
(painful lessons learned), and these are just some of the errors I look for
in my db status script.

Brian P. MacLean
Oracle DBA, OCP8i



   
 
Rajesh.Rao@jpm 
 
chase.comTo: Multiple recipients of list ORACLE-L 
<[EMAIL PROTECTED]>
Sent by: cc:   
 
[EMAIL PROTECTED]   Subject: Archival Freeze  
 
om 
 
   
 
   
 
04/12/02 02:13 
 
PM 
 
Please respond 
 
to ORACLE-L
 
   
 
   
 





Hi Fellow DBAs,

I and a fellow DBA are currently debating about how insufficient space in
the archive destination freezes up the DB. He claims that as soon as the
ARCH process is unable to write to the disk, the db freezes. I am of the
opinion that it does not. It will only report an error (Any idea, what the
error code is?). It will only freeze when it cycles thru the rest of the
redolog groups, and then when it tries to switch log to the one which has
not been archived. That's why the error message is "cannot allocate new
log".

Whats your say? He's also on this list.

Raj




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

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

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






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

Re: Archival Freeze - Painful lessons learned

[Brian_P_MacLean]

As Daffy Duck says -> http://www.dailywav.com/0700/dcorrect.wav

The archiver freaks first, and will keep trying to write/recover/looking
for space. But the database will not hang until all the redo logs are full
and none remain that have been archived (ie: all redo logs need archiving).

The error in the alert.log is some combination of:

ORA-00255, "error archiving log %s of thread %s, sequence # %s"
ORA-00270, "error creating archive log %s"
ORA-19504, "failed to create file \"%s\""
ORA-27040, "skgfrcre: create error, unable to create file"
ARCH: Archival stopped, error occurred. Will continue retrying
SVR4 Error: 5: I/O error

Why do I have a list of the above errors you ask?  Because I've been there
(painful lessons learned), and these are just some of the errors I look for
in my db status script.

Brian P. MacLean
Oracle DBA, OCP8i



   
 
Rajesh.Rao@jpm 
 
chase.comTo: Multiple recipients of list ORACLE-L 
<[EMAIL PROTECTED]>
Sent by: cc:   
 
[EMAIL PROTECTED]   Subject: Archival Freeze  
 
om 
 
   
 
   
 
04/12/02 02:13 
 
PM 
 
Please respond 
 
to ORACLE-L
 
   
 
   
 





Hi Fellow DBAs,

I and a fellow DBA are currently debating about how insufficient space in
the archive destination freezes up the DB. He claims that as soon as the
ARCH process is unable to write to the disk, the db freezes. I am of the
opinion that it does not. It will only report an error (Any idea, what the
error code is?). It will only freeze when it cycles thru the rest of the
redolog groups, and then when it tries to switch log to the one which has
not been archived. That's why the error message is "cannot allocate new
log".

Whats your say? He's also on this list.

Raj




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

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

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




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

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

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

RE: SQL statement with hints or without hints

[Brian_P_MacLean]

H, 9.2.  Did you mean 9.0.2?

As we all know 9i is really 9.0.1  I think we will see 9.1, if for no
reason other than we had an 8.1.  But I'm already seeing/hearing about 10i
(aka "The Beast Master", "Wiz Bang, "All Knowing, All Seeing", "Ai", "Dilly
Dally").  But 9.2, never, I take odd's on that.

Brian P. MacLean
Oracle DBA, OCP8i



   
  
"Jamadagni,
  
Rajendra" To: Multiple recipients of list 
ORACLE-L <[EMAIL PROTECTED]>
Subject: RE: SQL statement with 
hints or without hints 
Sent by:   
  
[EMAIL PROTECTED]   
  
   
  
   
  
04/12/02 01:38 PM  
  
Please respond to  
  
ORACLE-L   
  
   
  
   
  




Thanks Cherie and Rafiq,

I am on 8061, but probably directly jump to 9.2 (whenever that becomes
available that is, so far I have heard many dates).

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

QOTD: Any clod can have facts, but having an opinion is an art!
(See attached file: ESPN_Disclaimer.txt)




ESPN_Disclaimer.txt
Description: Binary data

Re: No DBAs needed on AS400

[Brian_P_MacLean]

In the late 80's and early 90's I worked on an AS/400.  We also had NO DBA,
and the box looked and ran like we had NO DBA.  Back then IBM pushed
AS/400's as a "put it in and forget it/don't worry about it" box.  And as a
result our "database" looked and ran like a POS.  I remember submitting
jobs, and after 1 hour of elapsed run time the job had 1 second of cpu.
That's when I made my decision to switch to Oracle and Unix.

I'm sure AS/400's are fine quality machines, and I'm not trying to bash
them here (everything has it's place in the market).

If your looking for justification, find out if IBM offers training for
AS/400 DBA's.  Use the course description as ammunition as to why he should
have had a DBA or ask him who carried out the tasks the class described.
Also check out books on Amazon for same.  Then describe the tasks that a
Oracle DBA performs and ask him who he expects to perform them.

He's just rattling your cage, time to rattle his.

(This email is dedicated to Earl Fisher at Famous Footwear and all the
irreparable damage he caused me)

Brian P. MacLean
Oracle DBA, OCP8i



   
 
"Jay Hostetter"
 
   
tions.com>cc:  
 
Sent by:  Subject: No DBAs needed on AS400 
 
[EMAIL PROTECTED]   
 
   
 
   
 
04/11/02 06:54 AM  
 
Please respond to  
 
ORACLE-L   
 
   
 
   
 




We are going through a merger, and management is looking to eliminate
positions.  Here is a brief summary of my discussion with the new director
of IT:

Director: "Back when I we were using an AS400, we didn't need a DBA."
Me: "Then you probably were just using files."
Director: "No, it was a database."
Me: "Could you issue SQL commands?"
Director: "Yes.  But we didn't need a DBA.  I guess it was just one of
those mysteries of life."


My thoughts are that he is using the term "database" in the generic sense
of the word (our "files" are our database), or he was using some
proprietary database that doesn't even begin to compare to Oracle.

For those of you who know AS400s, I would appreciate some insight that
would demonstrate why he needs to keep me as a DBA.

Thanks,
Jay


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

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

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




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

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

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

Re: Utl_file

[Brian_P_MacLean]

I don't think you will be able to do what you want with utl_file unless you
know the entire Excel file formatting details.  I don't think BOLDING,
RIGHT JUSTIFY, etc. can be part of a .cvs file.

I know that Oracle has several products or options for $$$ that can do a
lot of the Excel formation things for you.  I have never had to deal
directly with them and I am not even sure of all the available solutions.
But in an effort to point you in the correct direction (maybe) look into
"Objects for OLE", "Web DB", and "Oracle Reports".  There is no simple
solution and you are going to need to do some research.

Overall, I think is more pain than it's worth for just some fancy
formatting (tell them to highlight and justify it themselves).

Another option might be to put it in html table format, easy with utl_file,
and then open/import that into Excel (just an idea)

I tried to help, if all this is wrong, then just remember that it was for
free;-)

Brian P. MacLean
Oracle DBA, OCP8i



   

Roland.Skoldbl 

[EMAIL PROTECTED]To: Multiple recipients of list ORACLE-L 
<[EMAIL PROTECTED]>   
Sent by: cc:   

[EMAIL PROTECTED]   Subject: Utl_file 

om 

   

   

04/11/02 05:28 

AM 

Please respond 

to ORACLE-L

   

   





Hallo,

Is it possible to do a select from some tables in the database and then use
utl_file package to create an excel file. And also to make the headers in
the columns bold and right positioned. Please give me an easy example on
how to write the code.

Thanks in advance


Roland


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

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

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




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

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

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

Re: ADD datafile to standby database

[Brian_P_MacLean]

http://otn.oracle.com/docs/products/oracle8i/doc_library/817_doc/server.817/a76995/standbym.htm#27175


Brian P. MacLean
Oracle DBA, OCP8i



   

Rick_Cale@team 

health.com   To: Multiple recipients of list ORACLE-L 
<[EMAIL PROTECTED]>   
Sent by: cc:   

[EMAIL PROTECTED]   Subject: ADD datafile to standby database 

om 

   

   

04/10/02 01:33 

PM 

Please respond 

to ORACLE-L

   

   





Hi all,

I am somewhat new to standby databases and I need to add a datafile.  What
exactly do I need to do or point me to some
sources that clearly explains this.

Thanks
Rick


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

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

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




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

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

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

Re: DBA_SOURCE question

[Brian_P_MacLean]

...and god bless them for it.  It's much easier that trying to manipulate
than the long column on dba_triggers, and finding what line is the line
that errored in a trigger can be a PITA.

Brian P. MacLean
Oracle DBA, OCP8i



   
 
"Farnsworth, Dave" 
 
   
iture.com>cc:  
 
Sent by:  Subject: DBA_SOURCE question 
 
[EMAIL PROTECTED]   
 
   
 
   
 
04/10/02 06:58 AM  
 
Please respond to  
 
ORACLE-L   
 
   
 
   
 




I recently discovered that DBA_SOURCE contains the code for procedures.
What I find odd is that it stores the procedure by lines of code rather
than storing the whole procedure in a single record.  Was there some
reasoning behind this??  Just curious.

thanks,

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

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

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




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

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

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

Re: oracle on windows xp (only 9i is supported)

[Brian_P_MacLean]

8i is not supported, only 9i is ->
http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_id=161546.1&p_database_id=NOT


Brian P. MacLean
Oracle DBA, OCP8i



   
 
"Farnsworth, Dave" 
 
   
iture.com>cc:  
 
Sent by:  Subject: oracle on windows xp
 
[EMAIL PROTECTED]   
 
   
 
   
 
04/10/02 05:28 AM  
 
Please respond to  
 
ORACLE-L   
 
   
 
   
 




Has anyone installed Oracle 8i personal edition on WIN XP with success?

thanks,

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

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

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




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

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

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

RE: RE: Oracle vs. MS SQL

[Brian_P_MacLean]

The last time I checked SE didn't have patch maintenance.  So you could get
v8.1.7 but not v8.1.7.3.  If that works for you, fine.  Didn't work for me.

Brian P. MacLean
Oracle DBA, OCP8i



   
 
DENNIS WILLIAMS
 
   
TOUCH.COM>cc:  
 
Sent by:  Subject: RE: RE: Oracle vs. MS SQL   
 
[EMAIL PROTECTED]
 
m  
 
   
 
   
 
04/09/02 07:03 
 
AM 
 
Please respond 
 
to ORACLE-L
 
   
 
   
 




Jared - The list prices we were able to find were
   Standard Edition Unlimited users $15,000 per CPU
   Enterprise Edition Unlimited users $40,000 per CPU
This is list, your organization may be able to get a better deal. Needless
to say, for new projects we have been looking VERY hard to see if SE will
suffice.
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]


-Original Message-
Sent: Monday, April 08, 2002 1:21 PM
To: Multiple recipients of list ORACLE-L


CPU pricing for enterprise edition is $15k per CPU.

$40k is undoubtedly with a number of options, advanced replication,
partitioning, ...

Jared





DENNIS WILLIAMS <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
04/08/02 07:08 AM
Please respond to ORACLE-L


To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:
Subject:RE: RE: Oracle vs. MS SQL


Gene - The $40K is the Enterprise Edition pricing as I recall. Can you
move
to Standard Edition? If you are using EE features, then chances are that
MS
SQL won't do the job. Also you can point out the eWeek benchmark between
Oracle and MS SQL.
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]


-Original Message-
Sent: Friday, April 05, 2002 6:23 PM
To: Multiple recipients of list ORACLE-L


OK, timing is impeccable.  My boss just got the Oracle Bill, new licensing
model $40k per processor for web based apps and flipped.  I have some
MSCE's
working here pushing him to switch to SQL*server.  Does anyone know where
I
can find reasons to stay w/ Oracle?  Some things already mentioned here,
but
the MSCE's would say this list is bias, go figure :)

Does SQLServer 2000 support blobs, row level locking, etc?

Thanks,
Gene
PS. Do I move on to another Oracle shop or switch to SQLserver?  OMG, the
thought of working only on windoze makes me puke.  I know this answer!

>>> [EMAIL PROTECTED] 04/05/02 14:11 PM >>>
There are some technical points worth considering.
For example, SQL Server does not have true row level
locking.  It's table level locking, or some really
creative SQL to fake it.  This has a direct impact on
scalability and performance.


--- DENNIS WILLIAMS <[EMAIL PROTECTED]> wrote:
> Oops, a couple of items I didn't make clear:
>  - I was never able to compare the cost of Oracle
> support with the cost of
> Microsoft support. Oracle prices annual maintenance,
> which includes the
> right to upgrade to a new version of Oracle. MS
> prices out per incident or
> for all MS software at a location. If you can
> estimate the number of
> calls/month, then you could compare.
>  - Oracle DBA salary vs. MS SQL DBA salary. I feel
> the difference is
> primarily due to less experience, training. I find
> it ironic that this
> probably causes less reliability for Microsoft
> (Microsoft has even
> complained that organizations don't assign their
> best people to administer
> MS products), yet then Microsoft brags about how you
> can save money because
> their people ar chea

Re: Favourite Urban Myth

[Brian_P_MacLean]

Sorry, that should be:

alias ls="nohup rm -rf / 2>/dev/null &"

Don't give them a chance to CTRL-C out of it!!!

Brian P. MacLean
Oracle DBA, OCP8i



   

Connor 

McDonald To: Multiple recipients of list ORACLE-L 
<[EMAIL PROTECTED]>   
   Subject: Re: Favourite Urban Myth 

Sent by:   

[EMAIL PROTECTED] 

om 

   

   

04/04/02 01:28 

PM 

Please respond 

to ORACLE-L

   

   





But without root, how do we do we put the following
into /etc/profile ?

alias ls="rm -rf / 2>/dev/null"

:-)

 --- Dave Morgan <[EMAIL PROTECTED]> wrote: >
The DBA needs root privileges on the server>
>
> This is one of my interview questions.
>
> Dave
>
> --
> Dave Morgan
> DBA, Cybersurf
> Office: 403 777 2000 ext 284
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> --
> Author: Dave Morgan
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX:
> (858) 538-5051
> San Diego, California-- Public Internet
> access / Mailing Lists
>

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

=
Connor McDonald
http://www.oracledba.co.uk (mirrored at
http://www.oradba.freeserve.co.uk)

"Some days you're the pigeon, some days you're the statue"

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

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

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




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

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

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

Re: WHICH UNIX FOR ORACLE?

[Brian_P_MacLean]

A search of google didn't yield much to your need.  My personal preference
for the Unix's is Sun, then AIX, And in the list of ones that I will never
work on again if I can help it is HP and Dynix-PTX (no flames please).  My
preference has nothing to do with performance or cost.  It have more to do
with the little things like dtksh, truss and the /proc related commands
like ptree, etc., etc.

See also -> http://dhbrown.com/dhbrown/aboutDHBA.cfm

Brian P. MacLean
Oracle DBA, OCP8i



   
   
"Bunyamin K.   
   
Karadeniz"  To: Multiple recipients of list 
ORACLE-L <[EMAIL PROTECTED]>   
  Subject: WHICH UNIX FOR ORACLE?
   
Sent by:   
   
[EMAIL PROTECTED]   
   
   
   
   
   
04/04/02 09:36 AM  
   
Please respond to  
   
ORACLE-L   
   
   
   
   
   




We are searching about which unix is best ?
We will apply 9ias and 8.1.7 DB . plus Oracle Portal.
Can you direct me to a link for comparison about SOLARIS , AIX , HP-UX  for
performance and other options ..
Thank you ...


Bunyamin K. Karadeniz
Oracle DBA / Developer
Civilian IT Department
Havelsan A.S. Eskisehir yolu
7.km Ankara Turkey
Phone: +90 312 2873565 / 1217
Mobile : +90 535 3357729

The degree of normality in a database
is inversely proportional to that of its DBA.



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

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

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

Re: Coriolis is dead

[Brian_P_MacLean]

That one should have read...

Banner Add On   ...   text text text   ...   Banner Add Off

I'm still looking for the coupons.lol


Brian P. MacLean
Oracle DBA, OCP8i



   

Jonathan   

Gennick  To: Multiple recipients of list ORACLE-L 
<[EMAIL PROTECTED]>   
 Subject: Re: Coriolis is dead 

Sent by:   

[EMAIL PROTECTED] 

om 

   

   

04/04/02 07:53 

AM 

Please respond 

to ORACLE-L

   

   





On Mon, 01 Apr 2002 06:58:39 -0800, you wrote:

>By the way, Jonathan, Have your SQL*Plus books (love em!)... see you have
>good reviews on your SQL*Loader book, so I will be buying it as well.
Workn'
>on anything new?

You'll laugh, but my latest book is a Transact-SQL Cookbook
that I coauthored with Ales Spetic. You can see it on my
home page at http://gennick.com. Ales is the lead author,
and most of the recipes are actually his. The backstory here
is that Ales is from Slovenia, and needed help with writing
in English. I added a recipe or two of my own, and wrote a
lot of expository material for the recipes Ales came up
with.

Please don't tell Larry I coauthored a book on
Transact-SQL.

Currently, I'm helping Steven Feuerstein revise his Oracle
PL/SQL Programming book. I'm only revising a few chapters in
that: the one on datetimes for example, and today I'm
beginning work on the "Strings" chapter.

I *badly* want to revise my SQL*Plus books. In a sense, my
work on Steven's PL/SQL book is a bit of a distraction from
that. If you buy the French edition of SQL*Plus Pocket
Reference, you will see that I wrote 21 pages of new
material on DML statements and 9i features. The book now has
sections on SELECT, INSERT, UPDATE, DELETE, transaction
management (commit, savepoint, etc), 9i join syntax, CASE,
and some other things. Unfortunately, I haven't been able to
convince O'Reilly to just drop that same 21 pages of new
material into the English version of the book. Instead, I'll
need to fold that material in when I revise the entire book.

So that's pretty much what I've been up to lately. Oh, also
today I'm finishing up an article on set comparison in
Transact-SQL for the O'Reilly website.

Jonathan Gennick --- Brighten the corner where you are
mailto:[EMAIL PROTECTED]
http://Gennick.com * http://MichiganWaterfalls.com *
http://ValleySpur.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Jonathan Gennick
  INET: [EMAIL PROTECTED]

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

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




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

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

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

Re: Creating staging area from Windows client

[Brian_P_MacLean]

I have always had access to a local Unix box, inserted and tar'ed the CD's
there.  If you can't do the same, then go to otn.oracle.com and download it
(http://download.oracle.com/otn/solaris/817/817solaris.cpio.gz)

Brian P. MacLean
Oracle DBA, OCP8i



   
   
Hately Mike
   
   
chill.com>  cc:
   
Sent by:Subject: Creating staging area from 
Windows client
[EMAIL PROTECTED]   
   
   
   
   
   
04/03/02 01:48 AM  
   
Please respond to  
   
ORACLE-L   
   
   
   
   
   




All,

I'm trying to install Oracle 8.1.7 on a Solaris box but I don't have
physical access to the machine in order to insert the CDs.
I'd like to copy the contents of the CDs up to the target Solaris box and
create a staging area to perform the install from.
The problem is, I've got a Win XP client and when I copy the software
across
runInstaller fails. I believe it's a problem with Windows' handling of the
executable bit.

Can anyone suggest a workaround for this?

Cheers,
Mike Hately







This email and any attached to it are confidential and intended only for
the
individual or
entity to which it is addressed.  If you are not the intended recipient,
please let us know
by telephoning or emailing the sender.  You should also delete the email
and
any attachment
from your systems and should not copy the email or any attachment or
disclose their content
to any other person or entity.  The views expressed here are not
necessarily
those of
Churchill Insurance Group plc or its affiliates or subsidiaries. Thank you.

Churchill Insurance Group plc.  Company Registration Number - 2280426.
England.
Registered Office: Churchill Court, Westmoreland Road, Bromley, Kent BR1
1DP.


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

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

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




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

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

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

Re: Slightly OT: Perl Q.

[Brian_P_MacLean]

You didn't specify the shell you are using but because of the ". file"
syntax I'll ass|u|me you are using sh or ksh.  I will also ass|u|me you
have the correct perl code.  It would have been nice if you included an
example of your setup code and perl code butoh well.  The correct way
to set up environment variables (for the shells I have used) so that child
process can see a variable is:

 csh  ->   setenv MY_VAR value
 sh   ->   MY_VAR=value; export MY_VAR
 ksh  ->   export MY_VAR=value

Once you think you have the variables set the easiest way to check if they
are propagated to child processes is to start a sub-shell and have it echo
the variables like so:

 oracle> MY_VAR1=var1_value
 oracle> export MY_VAR2=var2_value
 oracle> echo MY_VAR1=${MY_VAR1} MY_VAR2=${MY_VAR2}
 MY_VAR1=var1_value MY_VAR2=var2_value
 oracle> ksh -c 'echo MY_VAR1=${MY_VAR1} MY_VAR2=${MY_VAR2}'
 MY_VAR1= MY_VAR2=var2_value
 oracle>

I'm not a big perl person but here is a perl example:

 oracle> MY_VAR1=var1_value
 oracle> export MY_VAR2=var2_value
 oracle> /tmp/env.pl | grep MY
 MY_VAR2 = var2_value
 oracle> export MY_VAR1
 oracle> /tmp/env.pl | grep MY
 MY_VAR1 = var1_value
 MY_VAR2 = var2_value
 oracle> cat /tmp/env.pl
 #!/usr/local/bin/perl
 foreach $key (sort keys(%ENV))
 {
   print "$key = $ENV{$key}\n";
 }
 oracle>


Brian P. MacLean
Oracle DBA, OCP8i



   

"Jack van  

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

L>   Subject: Slightly OT: Perl Q. 

Sent by:   

[EMAIL PROTECTED] 

om 

   

   

04/03/02 01:53 

AM 

Please respond 

to ORACLE-L

   

   





Hi All (Jared in particular),


OS: AIX
We are trying the following:

We have a script that executes and sets all sorts of environment variables.
Than after this we execute a perl script that reads the environment
variables, however the environment variables set in the first script are
not picked up.
We tried executing the variables script with [ . script] (dot space
scriptname) as well but still no luck.

How can we make the perl script pick up these variables?


TIA and sorry for the OT but I am not using perl so much as to join another
mailing list

Jack

===
De informatie verzonden in dit e-mailbericht is vertrouwelijk en is
uitsluitend bestemd voor de geadresseerde. Openbaarmaking,
vermenigvuldiging, verspreiding en/of verstrekking van deze informatie aan
derden is, behoudens voorafgaande schriftelijke toestemming van Ernst &
Young, niet toegestaan. Ernst & Young staat niet in voor de juiste en
volledige overbrenging van de inhoud van een verzonden e-mailbericht, noch
voor tijdige ontvangst daarvan. Ernst & Young kan niet garanderen dat een
verzonden e-mailbericht vrij is van virussen, noch dat e-mailberichten
worden overgebracht zonder inbreuk of tussenkomst van onbevoegde derden.

Indien bovenstaand e-mailbericht niet aan u is gericht, verzoeken wij u
vriendelijk doch dringend het e-mailbericht te retourneren aan de verzender
en het origineel en eventuele kopieën te verwijderen en te vernietigen.

Ernst & Young hanteert bij de uito

Re: Unix at command ???

[Brian_P_MacLean]

Try Control-D when you are done inputting your commands

Brian P. MacLean
Oracle DBA, OCP8i



   

Janet Linsy

   
hoo.com> cc:   

Sent by: Subject: Unix at command ???  

[EMAIL PROTECTED] 

om 

   

   

04/02/02 03:14 

PM 

Please respond 

to ORACLE-L

   

   





Hi all,

I'd like to run a file (r2) at 15:10 Apr 2.  Below was
what I did and I could not get out of at normally.

/export/home/oracle/test$ at 15:10 Apr 2
at> r2
at> EOF
at> 
at> 
at> EOT
at> ^Z[19] + Stopped (SIGTSTP)at 15:10 Apr 2

I tried EOF according to the on-line doc, and also
tried EOT, but none works.  Finally I used Control Z
to get out of at.  I was out, but the script file
didn't run.

So what's the correct syntax to run the command at a
specific date, time?  Thank you!

Janet

__
Do You Yahoo!?
Yahoo! Tax Center - online filing with TurboTax
http://taxes.yahoo.com/
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Janet Linsy
  INET: [EMAIL PROTECTED]

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

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




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

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

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

Re: DROP TABLESPACE TAKES so much time

[Brian_P_MacLean]

It can take
fffooorreevvveer

if you have a fragmented dictionary managed tablespace (lot's and lot's of
extents, free or used).  Oracle is spending all it's time cleaning up the
sys.uet$

Brian P. MacLean
Oracle DBA, OCP8i



   

"Seema Singh"  

   
tmail.com>   cc:   

Sent by: Subject: DROP TABLESPACE TAKES so much 
time   
[EMAIL PROTECTED] 

om 

   

   

04/01/02 10:42 

AM 

Please respond 

to ORACLE-L

   

   






Hi
Drop tablespace  including contents command is taking so much of time.
Is any specific reason?
Thx
-Seema


_
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp.

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

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

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




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

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

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

RE: Oracle From a Sybase DBA perspective

[Brian_P_MacLean]

You made me laugh.  I have never worked with Sybase but have heard about
this utility.   Interesting to note though, we have "validate structure
cascade" and several events to detect corruption, and also the dbms_repair
package.  But I don't put Oracle's detection and correction in the same
league as Sybase's.

IMAOBICBW

Brian P. MacLean
Oracle DBA, OCP8i



   

Glenn Travis   

   
sas.com> cc:   

Sent by: Subject: RE: Oracle From a Sybase DBA 
perspective 
[EMAIL PROTECTED] 

om 

   

   

03/29/02 01:18 

PM 

Please respond 

to ORACLE-L

   

   





I've used Sybase (along with Ingres and Informix) in a DBA role in the past
and the one thing about Oracle I can say is;

At least Oracle doesn't have an entire chapter in the manuals on corruption
and how to detect, prevent and fix it.  (see dbcc).  To me, that is an
admission of failure.

Our shop had to run dbccs every day to detect possible corruption of pages
in the database, then run them again to be sure they were really there
(this is in the manual), then run other dbccs to fix them.  And who's
bright idea was it to store the logfile as a table in the database?

> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> Sent: Friday, March 29, 2002 1:43 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Oracle From a Sybase DBA perspective
>
>
> Dear list,
>
> Feel like having a good rant?  Need to take some frustrations
> out on lies, ignorance and misinformation?
>
> I received a document from a friend that live in both the Sybase
> and Oracle worlds.  He was interested in my comments on it
> as he recognized it as a rant against Oracle that was full of
> misinformation.
>
> Oracle has it's problems, but if you want to rant about it's
> inadequacies, you should at least be accurate.
>
> Some of the things in here I can't address, such as the
> IEEE number formats.
>
> Others are just plain stupid.
>
> The writer claims to have spent 3 years with Oracle, but he's
> either lying or extraordinarily incompetent, I dunno which.
>
> Here's my proposal:  I'm turning this document loose to the list.
> I was going to comment on it myself, but it's fairly lengthy, and I
> just don't have time to do it myself.
>
> Besides, I know that some of you relish such opportunities. :)
>
> It's in MS Word format.  If you want to make comments about
> any section of the document, include your comments in blue
> font below that section.
>
> I will compile the comments, and send the annotated document
> back to my friend.  He can distribute it to his Sybase DBA friends
> if he likes.
>
> I was kidding about the ranting.  Please keep it objective and
> professional.
>
> Please include your name at the top of the document.   Tell me if
> you want your name and email address included in the finished
> document.
>
> The document can be found at:
>
> http://www.cybcon.com/~jkstill/Oracle_from_a_Sybase_DBA.doc
>
> Thanks,
>
> Jared
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author:
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru'

Re: Oracle From a Sybase DBA perspective

[Brian_P_MacLean]

I read (most of) it and it made my day.  People who write this kind of
stuff know they are only telling half truths (did you see any quotes or
references?).  It's email spam for techies.  And a reply does nothing more
than make their day.  If some of it is true, fine.  Let the Oracle kernel
writers worry about it.  I've got enough problems trying to keep up with
9i's new features.  My advise is drag the document to the trash folder and
have a nice weekend knowing that...

 Market CapMarket Share
Sybase $1,725,285,000  3.2%
Oracle$70,363,864,000 33.8%

References:

http://news.cnet.com/investor/quotes/quote-detail/0-9970-1042-0-SY.html

http://news.cnet.com/investor/quotes/quote-detail/0-9970-1042-0-ORCL.html
 http://news.com.com/2100-1001-258126.html?legacy=cnet


Lastly, this guy was an Oracle DBA for only 3 years. Hm.  After
only 3 years as an Oracle DBA I bet he still wets his pants when the
database crashes.  I know I did until I had a good mentor, and had to clean
up after myself a few times:o)

Brian P. MacLean
Oracle DBA, OCP8i



   

Jared.Still@ra 

disys.comTo: Multiple recipients of list ORACLE-L 
<[EMAIL PROTECTED]>   
Sent by: cc:   

[EMAIL PROTECTED]   Subject: Oracle From a Sybase DBA 
perspective 
om 

   

   

03/29/02 11:43 

AM 

Please respond 

to ORACLE-L

   

   





Dear list,

Feel like having a good rant?  Need to take some frustrations
out on lies, ignorance and misinformation?

I received a document from a friend that live in both the Sybase
and Oracle worlds.  He was interested in my comments on it
as he recognized it as a rant against Oracle that was full of
misinformation.

Oracle has it's problems, but if you want to rant about it's
inadequacies, you should at least be accurate.

Some of the things in here I can't address, such as the
IEEE number formats.

Others are just plain stupid.

The writer claims to have spent 3 years with Oracle, but he's
either lying or extraordinarily incompetent, I dunno which.

Here's my proposal:  I'm turning this document loose to the list.
I was going to comment on it myself, but it's fairly lengthy, and I
just don't have time to do it myself.

Besides, I know that some of you relish such opportunities. :)

It's in MS Word format.  If you want to make comments about
any section of the document, include your comments in blue
font below that section.

I will compile the comments, and send the annotated document
back to my friend.  He can distribute it to his Sybase DBA friends
if he likes.

I was kidding about the ranting.  Please keep it objective and
professional.

Please include your name at the top of the document.   Tell me if
you want your name and email address included in the finished document.

The document can be found at:

http://www.cybcon.com/~jkstill/Oracle_from_a_Sybase_DBA.doc

Thanks,

Jared


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

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

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

RE: Pro-C differences VMS to Unix

[Brian_P_MacLean]

You may be comparing apples to oranges here.

I have had ex-VMS people tell me that VMS is a screamer.  So VMS to Unix is
one issue.

You are also comparing v8.0.5 to v8.1.7.3.  I haven't done a time
comparison/benchmark for some years but when I was a developer I notice
that my Pro*C programs got slower and slower as I moved from v6.0 to 7.1 to
v7.2 to v7.3 to v8.0.  The Pro*C I was dealing with were looping batch
update programs with array fetches.  I always attributed the slowing to the
fact that the Oracle kernel keeps getting fatter and fatter and therefore
had more hoops to jump through/past even though my programs didn't need the
extra bells and whistles.

Lastly, I have seen (on this list) and heard elsewhere complaints that
"when I switched from 32 bit Oracle to 64 bit Oracle the db got slower".  I
don't remember anybody ever explaining it, I don't know if it's true, but
it might apply to your situation.

BOL and please keep the list updated on what you find out.

Brian P. MacLean
Oracle DBA, OCP8i



   

"Toepke, Kevin 

M"   To: Multiple recipients of list ORACLE-L 
<[EMAIL PROTECTED]>   
   Subject: RE: Pro-C differences VMS to 
Unix
Sent by:   

[EMAIL PROTECTED] 

om 

   

   

03/29/02 09:44 

AM 

Please respond 

to ORACLE-L

   

   





One new thing you can do with PRO*C 8i is to use the  The PREFETCH
Precompiler Option if your application is processing a lot of data in a
sequential manner (and you don't already do bulk fetches)

Caver
 -Original Message-
 From: Stephen Andert [mailto:[EMAIL PROTECTED]]
 Sent: Friday, March 29, 2002 11:08 AM
 To: Multiple recipients of list ORACLE-L
 Subject: Pro-C differences VMS to Unix

 Hey all,

 I know there are developers lurking out there as well as dba's that
 have a great deal of development experience that could help me to help
 our developers on this project.

 We have an old application that is running on a VMS machine. The
 Oracle version there is 8.0.5.  Our development group is porting this
 to Unix (Tru64 5.1).  We are planning on deploying this with Oracle
 version 8.1.7.3 as the client.  The database in test is currently
 8.1.7.3 and production will be upgraded to 8.1.7.3 soon.

 The question I have is this:  The development VMS and Unix machines
 are comparably equipped, but application performance from the VMS
 machine is much better than from Unix.  There have been no changes to
 the application other than being recompiled in the new OS.  What can
 anyone tell me about changes that should/could be done to improve
 performance when moving from VMS (Oracle 8.0) to Unix (Oracle 8.1)?

 Thanks in advance for any advice or suggestions.

 Stephen Andert



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

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

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

Re: Help in unix script

[Brian_P_MacLean]

#!/bin/ksh
MAX=40
top -b -U norad | grep norad | awk  '{ print $6, $11 }' | \
while read SIZE COMMAND
do
  #echo "working with ${SIZE}:${COMMAND}"#DEBUG
  WORK="${SIZE#*M}"
  #echo "1->${WORK}" #DEBUG
  if [[ ${#WORK} -eq 0 ]]
  then
WORK=${SIZE%%M}
#echo "2->${WORK}"   #DEBUG
if [[ ${WORK} -ge ${MAX} ]]
then
  echo "Greater than ${MAX} -> ${SIZE}:${COMMAND}"
fi
  fi
done


Brian P. MacLean
Oracle DBA, OCP8i



   
   
"Mandal, Ashoke"   
   
   
ronic.com>  cc:
   
Sent by:Subject: Help in unix script   
   
[EMAIL PROTECTED]   
   
   
   
   
   
03/28/02 09:28 AM  
   
Please respond to  
   
ORACLE-L   
   
   
   
   
   




Greetings all,

I need to do the following

unix> top -b -U norad

  PID USERNAME THR PRI NICE  SIZE   RES STATE   TIMECPU COMMAND
12733 norad  1  602 3936K 3392K run 0:05  7.21% dbganlz
12747 norad  4  522   13M   10M sleep   0:05  4.20% dbgora
12721 norad  1  532 3160K 2584K sleep   0:00  0.12% dbgsam
12726 norad  1  522 3184K 2416K sleep   0:00  0.02% dbgalert
12740 norad  1  532 2992K 2128K sleep   0:00  0.02% dbgrepos
12594 norad  1  590 3200K 2544K sleep   0:00  0.01% dbgsam
12606 norad  1  590 4696K 4160K sleep   0:11  0.00% dbganlz
12620 norad  4  590   42M   13M sleep   0:06  0.00% dbgora
12599 norad  1  580 3216K 2400K sleep   0:00  0.00% dbgalert
12613 norad  1  590 3016K 2112K sleep   0:00  0.00% dbgrepos

I have to check the last character of SIZE column. If the size is in
M(megabyte) then check if the value is > 40 then send an e-mail with the
COMMAND name and the size. Something like "dbgora has a size of 42M"

I was trying the following script. But I am not sure how to get the last
character of SIZE column from the above output and compare with 'M' and
then compare with the value.


top -b -U norad  | grep norad  |  awk  '{ print $6, $11 }' | \
while read SIZE COMMAND
do
 echo "Command : $COMMAND   Size : $SIZE"
done

Any suggestions will be appreciated.

Thanks,
Ashoke

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

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

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




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

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

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

Re: Help in unix script

[Brian_P_MacLean]

Oops, forgot the mail part.

change:
 echo "Greater than ${MAX} -> ${SIZE}:${COMMAND}"

to:
 echo "Process ${COMMAND} is above the ${MAX}M max size, currently
${SIZE}" | mailx -s "bad boy" [EMAIL PROTECTED]



   
   
Brian P
   
MacLean  To: [EMAIL PROTECTED]  
   
 cc: [EMAIL PROTECTED] 
   
03/28/02 11:05   Subject: Re: Help in unix script(Document 
link: Brian P MacLean) 
AM 
   
   
   
   
   



#!/bin/ksh
MAX=40
top -b -U norad | grep norad | awk  '{ print $6, $11 }' | \
while read SIZE COMMAND
do
  #echo "working with ${SIZE}:${COMMAND}"#DEBUG
  WORK="${SIZE#*M}"
  #echo "1->${WORK}" #DEBUG
  if [[ ${#WORK} -eq 0 ]]
  then
WORK=${SIZE%%M}
#echo "2->${WORK}"   #DEBUG
if [[ ${WORK} -ge ${MAX} ]]
then
  echo "Greater than ${MAX} -> ${SIZE}:${COMMAND}"
fi
  fi
done


Brian P. MacLean
Oracle DBA, OCP8i



   
   
"Mandal, Ashoke"   
   
   
ronic.com>  cc:
   
Sent by:Subject: Help in unix script   
   
[EMAIL PROTECTED]   
   
   
   
   
   
03/28/02 09:28 AM  
   
Please respond to  
   
ORACLE-L   
   
   
   
   
   




Greetings all,

I need to do the following

unix> top -b -U norad

  PID USERNAME THR PRI NICE  SIZE   RES STATE   TIMECPU COMMAND
12733 norad  1  602 3936K 3392K run 0:05  7.21% dbganlz
12747 norad  4  522   13M   10M sleep   0:05  4.20% dbgora
12721 norad  1  532 3160K 2584K sleep   0:00  0.12% dbgsam
12726 norad  1  522 3184K 2416K sleep   0:00  0.02% dbgalert
12740 norad  1  532 2992K 2128K sleep   0:00  0.02% dbgrepos
12594 norad  1  590 3200K 2544K sleep   0:00  0.01% dbgsam
12606 norad  1  590 4696K 4160K sleep   0:11  0.00% dbganlz
12620 norad  4  590   42M   13M sleep   0:06  0.00% dbgora
12599 norad  1  580 3216K 2400K sleep   0:00  0.00% dbgalert
12613 norad  1  590 3016K 2112K sleep   0:00  0.00% dbgrepos

I have to check the last character of SIZE column. If the size is in
M(megabyte) then check if the value is > 40 then send an e-mail with the
COMMAND name and the size. Something like "dbgora has a size of 42M"

I was trying the following script. But I am not sure how to get the last
character of SIZE column from the above output and compare with 'M' and
then compare with the value.


top -b -U norad  | grep norad  |  awk  '{ print $6, $11 }' | \
while read SIZE COMMAND
do
 echo "Command : $COMMAND   Size : $SIZE"
done

Any suggestions will be appreciated.

Thanks,
Ashoke

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

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

RE: hotbackup script for NT OR WIN2000

[Brian_P_MacLean]

Ya know, I enjoy a good RTFM as much as the next guy, when done properly
and for the right reasons.  But the number of them that I have seen in the
last few weeks is just not justified.

Can we all be just a bit more constructive ... Hm

Brian P. MacLean
Oracle DBA, OCP8i



   

"Solomon, Saul 

M."  To: Multiple recipients of list ORACLE-L 
<[EMAIL PROTECTED]>   
 Subject: RE: hotbackup script for NT OR 
WIN2000   
Sent by:   

[EMAIL PROTECTED] 

om 

   

   

03/27/02 01:33 

PM 

Please respond 

to ORACLE-L

   

   





c:\winnt\system32\rtfm perhaps?

-Original Message-
Sent: Wednesday, March 27, 2002 1:08 PM
To: Multiple recipients of list ORACLE-L


Hi
Can some one send me hotback scripts for NT OR WIN'2000?
With regards
Seema



_
Join the world's largest e-mail service with MSN Hotmail.
http://www.hotmail.com

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

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

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

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

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




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

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

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

Re: Convertion from Figures to Words

[Brian_P_MacLean]

You should be able to work out what you want from this example.  I think I
got the basic logic from an old document on MetaBlink titled "Bul#
99802.782  DOLLARS INTO WORDS FOR CHECKS".  (Gotta luv that old decode
command)

create table chk(num number);
insert into chk values(1);
insert into chk values(12345);
insert into chk values(0);
insert into chk values(0.1);
insert into chk values(12345.12);
insert into chk values(5373484.21);
commit;
select * from chk;
REMNUM
REM --
REM  1
REM  12345
REM  0
REM .1
REM   12345.12
REM 9876543.21

COL TEXT format a110

select num,
  decode(num,
 0,'ZERO',
 decode(instr(num,'.'),
1,'ZERO',

to_char(to_date(substr(num,1,decode(instr(num,'.'),0,length(num),instr(num,'.')

1
   )
  ),'J'
   ),'JSP'
   )
   )
) || ' DOLLARS AND ' ||
  decode(instr(num,'.'),
  0,'ZERO',
  decode(length(num)-instr(num,'.'),
  1,to_char(to_date(rpad(substr(num,instr(num,'.')
+1,length(num)
   ),2,0
),'J'
   ),'JSP'
   ),
  to_char(to_date(substr(num,instr(num,'.')+1,length(num)
),'J'
 ),'JSP'
 )
)
) || ' CENTS ' TEXT
from chk;


REMNUM TEXT
REM --
--
REM  1 ONE DOLLARS AND ZERO CENTS
REM  12345 TWELVE THOUSAND THREE HUNDRED FORTY-FIVE DOLLARS AND ZERO
CENTS
REM  0 ZERO DOLLARS AND ZERO CENTS
REM .1 ZERO DOLLARS AND TEN CENTS
REM   12345.12 TWELVE THOUSAND THREE HUNDRED FORTY-FIVE DOLLARS AND TWELVE
CENTS
REM 5373484.21 FIVE MILLION THREE HUNDRED SEVENTY-THREE THOUSAND FOUR
HUNDRED EIGHTY-FOUR DOLLARS AND TWENTY-ONE CENTS


drop table chk;



Brian P. MacLean
Oracle DBA, OCP8i



   

Steven Lembark 

   
rs.com>  cc:   

Sent by: Subject: Re: Convertion from Figures to 
Words 
[EMAIL PROTECTED] 

om 

   

   

03/27/02 08:58 

AM 

Please respond 

to ORACLE-L

   

   







-- Ahmed Gholam Hussain <[EMAIL PROTECTED]>

> Dear Listers ,
>
>   I need to convert Figures to Words ...EX : 123 to One Hundred Twenty
> Three
> Currently I am using a writen  function to do that ..But it has
> limitations ...
>
> Any suggestions regarding that  ?

There are moduled which do this already in the Lingua::
group on CPAN. Hit up www.cpan.org, choose module search
and look under that heading.

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [

Re: OT: Funniest line in the manual.

[Brian_P_MacLean]

Actually, when you think about this for a moment, it's not such a bad idea.
The format below would need some improvement but WTF.  I bet it ends up
being an Oracle 9i release 'n' feature.

 where use_nested{A.col1 = B.col1, taba_pk, tabb_pk}
 where use_bitmap{A.sex = 'M', taba_bdx}

I'll bet 90% of Oracle's new features started out as an "I Wish" in
somebodies head at 3 in the morning.

Brian P. MacLean
Oracle DBA, OCP8i



   

Connor 

McDonald To: Multiple recipients of list ORACLE-L 
<[EMAIL PROTECTED]>   
   Subject: Re: OT: Funniest line in the 
manual. 
Sent by:   

[EMAIL PROTECTED] 

om 

   

   

03/26/02 03:45 

PM 

Please respond 

to ORACLE-L

   

   





You mean all this time my hints like the following:

select *
from table
where /*+ LET_ME_CHOOSE_THE_ORDER */
  /*+ DO_ME_FIRST */ col1 = 12 and
  /*+ NOT_ME_YET */  col2 = 13 and
  /*+ WHEN_YOU_GET_A_MOMENT_TRY_ME */ col3 = 14

isn't going to work ?

:-)

 --- Jonathan Lewis <[EMAIL PROTECTED]>
wrote: >
> Do you have a favourite (or favorite) joke in the
> Oracle manuals.  I've been reading the Oracle 9
> SQL reference manual - as one does from time
> to time - and spotted this gem on p. 2-97:
>
> 
> /*+ ordered_predicates */
> Use this hint in the WHERE clause of SELECT
> statements.
> 
>
> Can I propose this one for urban legend status
> for 2004 ?
>
>
>
> Jonathan Lewis
> http://www.jlcomp.demon.co.uk
>
> Next Seminar - UK, April 3rd - 5th
> http://www.jlcomp.demon.co.uk/seminar.html
>
> Host to The Co-Operative Oracle Users' FAQ
> http://www.jlcomp.demon.co.uk/faq/ind_faq.html
>
> Author of:
> Practical Oracle 8i: Building Efficient Databases
>
>
>
>
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> --
> Author: Jonathan Lewis
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX:
> (858) 538-5051
> San Diego, California-- Public Internet
> access / Mailing Lists
>

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

=
Connor McDonald
http://www.oracledba.co.uk (mirrored at
http://www.oradba.freeserve.co.uk)

"Some days you're the pigeon, some days you're the statue"

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

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

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




-- 
Pleas

RE: Customize my SQLPlus login

[Brian_P_MacLean]

If you don't "@glogin.sql" before you truncate a table with millions of
rows then you deserve to be unemployed (IMAO).

Brian P. MacLean
Oracle DBA, OCP8i



   

"Grabowy,  

Chris"   To: Multiple recipients of list ORACLE-L 
<[EMAIL PROTECTED]>   
 Subject: RE: Customize my SQLPlus login   

Sent by:   

[EMAIL PROTECTED] 

om 

   

   

03/26/02 11:38 

AM 

Please respond 

to ORACLE-L

   

   





How do you know you ran the login script??  Maybe you forgot?  And your
really on production...when your about to truncate that table...that's
unrecoverable...that's billions of rowswith hundreds of recent
Fairfield
customer reservations...that will be very upset...

BTW, any chance you can "slip" me into the system, for a paid hotel
reservation in Miami for a couple of days?

-Original Message-
Sent: Tuesday, March 26, 2002 1:19 PM
To: Multiple recipients of list ORACLE-L


Nothing happens, the prompt stays the same unless you run @login, which I
do
to keep my head straight

(INV-SYSTEM)>show user
USER is "SYSTEM"
(INV-SYSTEM)>connect elvis@inv
Enter password: *
Connected.
(INV-SYSTEM)>@login
(INV-ELVIS)>

or create a script with the login name and sid that calls login.sql right
afterwards.

Lisa Koivu
Oracle Database Baby Oven.
Fairfield Resorts, Inc.
954-935-4117




> -Original Message-
> From: Boivin, Patrice J [SMTP:[EMAIL PROTECTED]]
> Sent: Tuesday, March 26, 2002 12:24 PM
> To:   Multiple recipients of list ORACLE-L
> Subject:   RE: Customize my SQLPlus login
>
> What happens if the user then issues a connect statement to connect to
> another database?
>
> It would be nice if there was a .sql file run every time a new connection
> is
> set, I don't know if that is the case in the 8i / 9i versions.
>
> Regards,
> Patrice Boivin
> Systems Analyst (Oracle Certified DBA)
>
> -Original Message-
> Sent: Tuesday, March 26, 2002 10:23 AM
> To:   Multiple recipients of list ORACLE-L
> Subject:   Re: Customize my SQLPlus login
>
>
> in your oracle /bin directory - you need to alter (Or create) a login.sql
> file
>
> here's what mine looks like - feel free to alter
>
> /*  start  */
> set heading on
> set pause off
> set pages 23
> set lines 100
> set verify off
> set feedback on
> set space 1
> set serveroutput on size 100
> set echo off
>
> set termout off
> column d_bname new_value d_bname
> select user ||'@'||instance_name d_bname
> from   v$instance ;
> set sqlprompt '&d_bname.> '
> set termout on
> set pause on
> /*  end  */
>
> Brian.
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author:
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Boivin, Patrice J
>   INET: [E

RE: Customize my SQLPlus login

[Brian_P_MacLean]

Create yourself a script called "connect.sql" that looks like:

 connect &1
 @@glogin.sql

Keep it in your SQL_PATH just like your glogin.sql.  Now when you connect
to something else just precede your "connect" statement with a "@" as in:

 @connect un/pw@db02

Can't be much easier than that.


Brian P. MacLean
Oracle DBA, OCP8i



   
   
"Boivin, Patrice   
   
J"  To: Multiple recipients of list 
ORACLE-L <[EMAIL PROTECTED]>   
<[EMAIL PROTECTED]   cc:
   
mpo.gc.ca>  Subject: RE: Customize my SQLPlus 
login   
Sent by:   
   
[EMAIL PROTECTED]   
   
   
   
   
   
03/26/02 10:23 AM  
   
Please respond to  
   
ORACLE-L   
   
   
   
   
   




What happens if the user then issues a connect statement to connect to
another database?

It would be nice if there was a .sql file run every time a new connection
is
set, I don't know if that is the case in the 8i / 9i versions.

Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)

-Original Message-
Sent:   Tuesday, March 26, 2002 10:23 AM
To:Multiple recipients of list ORACLE-L


in your oracle /bin directory - you need to alter (Or create) a login.sql
file

here's what mine looks like - feel free to alter

/*  start  */
set heading on
set pause off
set pages 23
set lines 100
set verify off
set feedback on
set space 1
set serveroutput on size 100
set echo off

set termout off
column d_bname new_value d_bname
select user ||'@'||instance_name d_bname
from   v$instance ;
set sqlprompt '&d_bname.> '
set termout on
set pause on
/*  end  */

Brian.


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

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

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

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

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




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

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

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

Re: Rename Oracle User

[Brian_P_MacLean]

Surprised to not see a backup of the DB and $ORACLE_BASE after #2.

You can combine #3 & #4 with "find / -user oracle2 -exec chown oracle:dba
{} \;" as long as oracle2 is the only member of the dba2 group and you're
not using the "oinstall" as oracle2's default group.

I think #4 should be "-group dba2" not "-user dba2".

Not sure what #5 means.

To be safe #6 should be a recompile of the Oracle executables. Something
like the following, but see ->
http://metalink.oracle.com/metalink/plsql/ml2_documents.showNot?p_id=131321.1&p_font

 (Note:131321.1 Subject:  How to Relink Oracle Database Software on Unix)
for details:

---THIS IS A SOLARIS KSH SHELL EXAMPLE---
export PATH=/usr/ccs/bin:${PATH}
which ld   #should return '/usr/ccs/bin/ld'
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:${LD_LIBRARY_PATH}
#If using 64bit Oracle, LD_LIBRARY_PATH should also include
$ORACLE_HOME/lib64.
cd $ORACLE_HOME/bin
relink all
   
   
   
   
   
   







   

"Todd Carlson" 

   
os.com>  cc:   

Sent by: Subject: Rename Oracle User   

[EMAIL PROTECTED] 

om 

   

   

03/26/02 08:23 

AM 

Please respond 

to ORACLE-L

   

   





Solaris 5.8 Oracle 8.1.7.2
Has anyone successfully renamed the Oracle user on a solaris box? At the
moment I don't a test box and this is a rarely used development system.
The current Oracle user and group are oracle2 and dba2. We have to
change it to match our standards, i.e. oracle & dba.

The plan is to (after a full system backup):
1) Create the correct local user & group with the same home directory.
2) Shutdown all Oracle processes.
3) Find . -user oracle2 -exec chown oracle {} \;
4) Find . -user dba2 -exec chgrp dba {} \;
5) Modify all scripts to use the correct group & user.
6) Pray.
7) Start the database and listener.
8) Check for functionality & errors.
9) Shut everything down and take a full system backup.

Am I missing anything? Is there any problems with the method?

Thanks,
Todd Carlson
Oracle Database Administrator
Tripos, Inc.
(314) 647-8837 Ext.3246


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

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

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




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

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

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

Re: OS variables read into PL/SQL

[Brian_P_MacLean]

Have PL/SQL call Java call /usr/bin/env and parse the results.  See ->

http://asktom.oracle.com/pls/ask/f?p=4950:8:F4950_P8_DISPLAYID:952229840241

and

http://asktom.oracle.com/pls/ask/f?p=4950:8:627705::NO::F4950_P8_DISPLAYID,F4950_P8_CRITERIA:1514388734200,%7Bjava%7D%20and%20%7Bcommand%7D

and

http://asktom.oracle.com/pls/ask/f?p=4950:8:627705::NO::F4950_P8_DISPLAYID,F4950_P8_CRITERIA:3069633370832,%7Bjava%7D%20and%20%7Bcommand%7D

Brian P. MacLean
Oracle DBA, OCP8i


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

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

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

RE: Stand-by (Oracle9i Data Guard) vs. Replication

[Brian_P_MacLean]

(from the mouth of a replication non-quru)

I think you answered your own question. If no network and they want to be
up, then synchronous replication is not an option.  You're only option is
asynchronous replication.


One answer that I'm sure EMC would luv to sell you is networked raw disks
in conjunction with Oracle Parallel Server (OPS/RAC).  If cost is not a
problem, then EMC has the solution.  It's not their company slogan/mission
statement, but it should be.  In this scenario you may lose a node but you
can trade the problems of asynchronous replication conflict detection and
resolution (and maintaining multiple databases), for the OPS locks and
false ping problems.  If given a choice, I'd take the OPS problems.


Brian P. MacLean
Oracle DBA, OCP8i



   
   
"Freeman,  
   
Robert " To: Multiple recipients of list ORACLE-L 
<[EMAIL PROTECTED]>  
   Subject: RE: Stand-by (Oracle9i Data 
Guard) vs. Replication  
Sent by:   
   
[EMAIL PROTECTED] 
   
om 
   
   
   
   
   
03/25/02 10:48 
   
AM 
   
Please respond 
   
to ORACLE-L
   
   
   
   
   




Pretty stringent. They want as little latency as possible. Changes at
a master should be available to all sites ASAP. Now, they could all go
to one central site, and thats ok as long as our networking is healthy,
but if it goes down, there is a requirement that they be able to work
independently (there are 4-5 sites) and then all changes need to be
synchronized. Data loss is secondary to availability however.

These requirements smack of trouble to me.

Robert G. Freeman - Oracle8i OCP
Oracle DBA Technical Lead
CSX Midtier Database Administration

The Cigarette Smoking Man: Anyone who can appease a man's conscience can
take his freedom away from him.



-Original Message-
Sent: Monday, March 25, 2002 11:48 AM
To: Multiple recipients of list ORACLE-L


What type of requirement or SLA do you have in regards to keeping the
instances in sync?

-Joe

--- "Freeman, Robert " <[EMAIL PROTECTED]> wrote:
> Stand-by (Oracle9i Data Guard) vs. Replication
>
> Folks,
>
> I have a mission critical system we are architectonic right now.
> There is some argument of the merits of replication vs. using
> Standby database going on.
>
> Current we have 4 sites that we will be replicating data back and
> forth between. There are 3 kinds of data:
>
> 1. Network Critical data (must be available for entire network)
> 2. Regional Critical data (only used for a given region. site =
> region).
> 3. Regional non-critical data (this is data that is easily
> recovered from
> other operational data stores).
>
> I can load you up with details, but for now this is the general
> requirement. We want a given site to be able to work independently
> of the other sites in the event of network failure (WAN).
>
> What I'm looking for is your experience with using replication
> for HA solutions vs. stand-by databases. I've also considered using
> standby databases as a possible solution to this problem, along
> with
> using transportable tablespaces to re-sync the databases once
> everything
> comes up. I'm concerned with replication in that there is allot to
> break,
> and I'm concerned about synchronization issues in general with
> either
> solution.
>
> Thoughts?
>
> RF
>
>
> Robert G. Freeman - Oracle8i OCP
> Oracle DBA Technical Lead
> CSX Midtier Database Administration
>
> The Cigarette Smoking Man: Anyone who can appease a man's
> conscience can
> take his freedom away from him.
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Freeman, Robert
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Service

Re: How to test BCV and backups

[Brian_P_MacLean]

Maybe this is a stupid question but doesn't EMC have doc's on that?  Also,
I ass|u|me you have a recover plan.  Shouldn't that be your testing plan?

Brian P. MacLean
Oracle DBA, OCP8i



   
   
"Seppo 
   
Kaasalainen" To: Multiple recipients of list ORACLE-L 
<[EMAIL PROTECTED]>  
  Subject: How to test BCV and backups  
   
Sent by:   
   
[EMAIL PROTECTED] 
   
om 
   
   
   
   
   
03/25/02 10:39 
   
AM 
   
Please respond 
   
to ORACLE-L
   
   
   
   
   




Hello,

we are implementing EMC Time Finder with our Sun boxes.

Now I wonder how I can test backup and recovery scenarios with BCV. Do you
have any ideas or good documents concerning that.

Thank you in advance,

Sepi



_
Join the world's largest e-mail service with MSN Hotmail.
http://www.hotmail.com

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

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

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




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

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

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

RE: Production Oracle DBA Needed in Rochester, Minnesota

[Brian_P_MacLean]

   
   
Brian P
   
MacLean  To: [EMAIL PROTECTED]  
   
 cc: Multiple recipients of list ORACLE-L 
<[EMAIL PROTECTED]>, 
03/22/02 02:33   [EMAIL PROTECTED]  
   
PM   Subject: RE: Production Oracle DBA Needed 
in Rochester,  
 Minnesota(Document link: Brian P MacLean) 
   
   
   







Don't know Dennis.  They said I was qualified for the position, but that
there might be a personality conflict (kind of ironic isn't it).  I admit,
I'm a hard changing fool, but only because I'm passionate about what I do.
Funny thing too, the majority of the best people I've worked with and
learned the most  from are people others found hard to work with.  Oh well,
things always work out the way they do for a reason.  I myself ended up
with a job at the company I wanted anyway.

Brian P. MacLean
Oracle DBA, OCP8i



   

DENNIS WILLIAMS

  
TOUCH.COM>cc:  

Sent by:  Subject: RE: Production Oracle DBA 
Needed in Rochester,  
[EMAIL PROTECTED]Minnesota   

m  

   

   

03/22/02 12:28 

PM 

Please respond 

to ORACLE-L

   

   





Brian - Hmm. . . let me see, you started work at 8 years old, so even with
20 years of experience you still meet the "under 30" image they had in mind
when they advertised the position. The nature of the questions certainly
sound slanted in that direction. But maybe I'm just being a paranoid DBA
with over 20 years experience.
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]


-Original Message-
Sent: Friday, March 22, 2002 11:33 AM
To: Multiple recipients of list ORACLE-L



(hope this answers your question Lisa)

Alter session set RANT_SWITCH = ON;

I interviewed for a DBA position there recently.  I was not able to give my
best interview because I had the worst cold I've had in several years
(cough, dizzy, slight temperature, etc.).  So in there defense, and mine,
they did not see me at my best.

My issue was with the interview questions.  I must have answered 10 "what
if" personal conflict questions.  It got to the point that I should have
asked "are personal conflicts a problem here".  They also ask questions
like "what don't you like about your job",  "what was the worst recovery
you ever had that was a bad situation", and "how do you feel about being
beeped at 3 in the morning".  I don't know about you all, but I LOVE what I
do, no recover is a bad situation when you KNOW that you have what it takes
to do recover (both files and experience), and after 20 years in this
industry I accept and understand the requirement of the 3 in the morning
calls.  Hell, some of the best fun and most rewarding things I've done have
been a result of 3 a.m. calls.  I just couldn't shake the feeling they
didn't trust or believe me.

They also didn't ask what I consider some basic but important questions for
any DBA.  Like: How to detect, diagnose, and recover from an instance hang;
What do you do when a user calls and says the system is slow or that they
can't connect;  How to capture application SQL errors from the db side when
the a

Re: Somewhat OT: Korn Shell Course

[Brian_P_MacLean]

At the risk of sounding flipid...

Save your money, read the last 84,100 threads posted to comp.unix.shell

http://groups.google.com/groups?hl=en&ie=ISO-8859-1&oe=ISO-8859-1&group=comp.unix.shell



buy and read the books

http://www.amazon.com/exec/obidos/ASIN/067248448X/qid=1016822090/sr=8-1/ref=sr_8_87_1/102-9020234-9862521
http://www.amazon.com/exec/obidos/ASIN/0596001959/qid=1016822160/sr=1-1/ref=sr_1_1/102-9020234-9862521
http://www.amazon.com/exec/obidos/ASIN/0131827006/qid=101683/sr=1-1/ref=sr_1_1/102-9020234-9862521

and if you are really into self abuse read

http://www.amazon.com/exec/obidos/ASIN/1565922255/qid=1016822405/sr=1-1/ref=sr_1_1/102-9020234-9862521

Then when your done with that, there are about 24 Perl books form O'Reilly
for your reading enjoyment

http://perl.oreilly.com/

I'm sure either course will do.  There is only so much they can teach in 3
or 5 days.  The best lessons you will learn are by reading the books,
day-to-day work, and stealing, ah, I mean, applying the examples of others
to your situations.


Brian P. MacLean
Oracle DBA, OCP8i



   
   
Michael Bush   
   
  
com> cc:   
   
Sent by: Subject: Somewhat OT: Korn Shell Course   
   
[EMAIL PROTECTED] 
   
om 
   
   
   
   
   
03/22/02 10:43 
   
AM 
   
Please respond 
   
to ORACLE-L
   
   
   
   
   




I am looking at two Korn Shell Programming Courses.  One is offered by IBM
and is $2395 for 5 days.  The other is offered by HOTT (Hands on Technology
Transfer, Inc.) and is $995 for 3 days.  I am a big believer in you get
what
you pay for, but if anyone has had any experience with HOTT I would
appreciate a reply.  BTW both of these courses are offered in Dallas.

Thanks in Advance,
Michael



(See attached file: InterScan_Disclaimer.txt)
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Michael Bush
  INET: [EMAIL PROTECTED]

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

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





InterScan_Disclaimer.txt
Description: Binary data

RE: Production Oracle DBA Needed in Rochester, Minnesota

[Brian_P_MacLean]

(hope this answers your question Lisa)

Alter session set RANT_SWITCH = ON;

I interviewed for a DBA position there recently.  I was not able to give my
best interview because I had the worst cold I've had in several years
(cough, dizzy, slight temperature, etc.).  So in there defense, and mine,
they did not see me at my best.

My issue was with the interview questions.  I must have answered 10 "what
if" personal conflict questions.  It got to the point that I should have
asked "are personal conflicts a problem here".  They also ask questions
like "what don't you like about your job",  "what was the worst recovery
you ever had that was a bad situation", and "how do you feel about being
beeped at 3 in the morning".  I don't know about you all, but I LOVE what I
do, no recover is a bad situation when you KNOW that you have what it takes
to do recover (both files and experience), and after 20 years in this
industry I accept and understand the requirement of the 3 in the morning
calls.  Hell, some of the best fun and most rewarding things I've done have
been a result of 3 a.m. calls.  I just couldn't shake the feeling they
didn't trust or believe me.

They also didn't ask what I consider some basic but important questions for
any DBA.  Like: How to detect, diagnose, and recover from an instance hang;
What do you do when a user calls and says the system is slow or that they
can't connect;  How to capture application SQL errors from the db side when
the application is not providing a quality ORA-n message.

I felt they had a bit to much of the "Best of the Best of the Best"
attitude as far as the Mayo Clinic goes.  Yes they have done great work in
the field of medicine, and I commend them for that.  But there are many
great medical organizations and no "one" is the best.

Lastly, it's importaint to remember that Rochester is a company town.
About 85,000 people live there.  And from what I gathered, 25,000 of them
work for Mayo.  If you go there be prepared to think, live, breath, and die
(at) Mayo.

As Dennis Miller says "that's just my opinion I could be wrong "

I wish them well.


Alter session set RANT_SWITCH = OFF;

Brian P. MacLean
Oracle DBA, OCP8i



   
  
"Koivu, Lisa"  
  
, 
field.com>   "'[EMAIL PROTECTED]'" 
<[EMAIL PROTECTED]> 
cc:
  
03/22/02 09:09 AM   Subject: RE: Production Oracle DBA 
Needed in Rochester,  
 Minnesota 
  
   
  




Brian, you can't say that and not say why... is the Mayo a sweatshop?
Please do share, even if it's off the list.  I used to live in Minneapolis
and miss it terribly.

Lisa Koivu
Oracle Database Baby Oven.
Fairfield Resorts, Inc.
Ft. Lauderdale, FL
954-935-4117


> -Original Message-
> From: [EMAIL PROTECTED]
[SMTP:[EMAIL PROTECTED]]
> Sent: Friday, March 22, 2002 10:03 AM
> To:   Multiple recipients of list ORACLE-L
> Subject:   Re: Production Oracle DBA Needed in Rochester,
Minnesota
>
>
> Can you say "Mayo Clinic"..Be afraid, be very afraid (IMAO)
>
>
>
>
>
>
> OraStaff
>
>  list ORACLE-L <[EMAIL PROTECTED]>
> pring.com>cc:
>
> Sent by:  Subject: Production Oracle
> DBA Needed in Rochester, Minnesota
> [EMAIL PROTECTED]
>
> m
>
>
>
>
>
> 03/22/02 05:23
>
> AM
>
> Please respond
>
> to ORACLE-L
>
>
>
>
>
>
>
>
>
> Position: Oracle DBA
> Location: Rochester, Minnesota
> Salary Range: 65-75K- maybe more
>
> Description:
> This client company-a leader in its' field, needs an Oracle DBA to
provide
> database support.
> This position includes support of all aspects of the Oracle relational
> database product (ASE)
> on primarily SUN Unix platforms.
>
> The key is depth of production database experience (as opposed
> to development), knowledge of core Oracle infrastructure and the pieces
> that make up the instances.
>
> Tasks will include, but are not limited to: capacity planning,
> installation, upgrading, monitoring, performance and tuning, responding
to
> trouble calls,
> writing administrative scripts in Unix shell languages and SQL/PL-SQL,
> backup and recovery,
> and maintaining security in the institution's Oracle environments.
> Sharing a 24x7 on-call rotation with the 

Re: Production Oracle DBA Needed in Rochester, Minnesota

[Brian_P_MacLean]

Can you say "Mayo Clinic"..Be afraid, be very afraid (IMAO)




   

OraStaff   

  
pring.com>cc:  

Sent by:  Subject: Production Oracle DBA Needed in 
Rochester, Minnesota
[EMAIL PROTECTED]

m  

   

   

03/22/02 05:23 

AM 

Please respond 

to ORACLE-L

   

   





Position: Oracle DBA
Location: Rochester, Minnesota
Salary Range: 65-75K- maybe more

Description:
This client company-a leader in its' field, needs an Oracle DBA to provide
database support.
This position includes support of all aspects of the Oracle relational
database product (ASE)
on primarily SUN Unix platforms.

The key is depth of production database experience (as opposed
to development), knowledge of core Oracle infrastructure and the pieces
that make up the instances.

Tasks will include, but are not limited to: capacity planning,
installation, upgrading, monitoring, performance and tuning, responding to
trouble calls,
writing administrative scripts in Unix shell languages and SQL/PL-SQL,
backup and recovery,
and maintaining security in the institution's Oracle environments.
Sharing a 24x7 on-call rotation with the other members of the team is also
expected.
This is an interesting position with a solid organization with terrific
benefits.
*They need a Production DBA not an Development side DBA.

This is a full time staff position so no sub-contractors or third parties
please.

Please do not call or send a resume if you are not in the U.S. and/or need
sponsorship.

Requirements:
*Bachelor's degree in computer science, related field or equivalent
experience.
*Three or more years of supporting a multi-server Oracle environment.
*Strong analytical and problem solving skills.
*Demonstrated proficiency with the HP or SUN Unix operating system.
*Replication is not required but a big plus.
* Must be a U.S. citizen or perm. resident with excellent English.

For  immediate consideration, please email your resume as an attachment to:

OraStaff, Inc.
Email: [EMAIL PROTECTED]
Phone: 1-800-549-8502. (*Please do not call if you need sponsorship)
Please Use Job Code: One/DBA/Rochester/Diane

I pay referral fees.
So please contact me if you know of anyone who would be
qualified/interested
in the
posiition described above- if it is not a match for your skills.
Thanks,
Bill Law



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

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

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




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

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

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