Unix process tree

[Jeremy Bainbridge-Smith]

Title: Unix process tree





Hi Team


Firstly apologies for a slightly OT question.


Solaris has a great little command called "ptree" which given a process id as an argument, will present a tree of all the process' related to the given process id.

Question: Is there a similar command for Linux?


Cheers
Jeremy



Jeremy Bainbridge-Smith
Database Administrator
Hamilton City Council


Ph.   +64 7 838 6428
Mob.  +64 21 894481
~~~

RE: More On 10G

[Boivin, Patrice J]

Oracle 12???

Patrice.

-Original Message-
Sent: Monday, August 04, 2003 2:24 PM
To: Multiple recipients of list 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: Boivin, Patrice J
  INET: [EMAIL PROTECTED]

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

Re: Tuning ideas requested

[M Rafiq]

I shall add one more thing..In case of hash join/parallel sorts also watch 
usage of temp tablespace which may go very high with large sorts and may 
require a alrge temp tablespace.

Regards
Rafiq


Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Date: Tue, 05 Aug 2003 03:34:24 -0800
Hi!

How much memory do you have in server? With sort_area_size of 1GB,
hash_area_size will default to 2GB.
When looking at your execution plan, I think that there are two slaves for
reading data (one for each table), two slaves for doing hash join (both can
allocate up to 2GB for hashing!) and after first slaves have finished, these
can start order by (can allocate additional 1GB memory per slave, or even
more in some circumstances!).
Thus, if you don't have that much memory in your server, go with smaller
sort_area_size. But, since you are forcing hash join, setting hash_area_size
too small will degrade joins performance and hit your temporary tablespace
IO a lot. You should have analyzed your data well and should trace hash
joins with event 10104, to at least verify you don't have "Number of rows
iterated over" lines in your trace file (I means that because of incorrect
statistics and small hash_area_size even a single build partition doesn't
fit into memory and the same probe partition has to be re-read again and
again for every part of build partition).
You can get parallel execution & table queue information from v$pq_tqstat -
but I believe you have to run your query (with small amount of rows) first,
then check the view in the same session where you executed your query.
Btw, is your IO fast enough to cope with this kind of parallel degree? You
should also test, what happens with smaller degree, or modifying your
cursors to perform serial operations in parallel on different sets of data.
Actually, you should first look at insert /*+ APPEND PARALLEL */ select 
statement without any pl/sql cursors and cursor loops to move data to
another tablespace and create additional columns, it can be a lot faster,
especially with parallel execution.
Btw, I wouldn't delete records from temporary product listing table, I'd
just update some rows status to say that it's corresponding values have been
processed...
Tanel.

> ERROR at line 8:
> ORA-12801: error signaled in parallel query server P001
> ORA-04030: out of process memory when trying to allocate 8192 bytes (sort
> subheap,sort key)
>
> An autotrace of the 100,000 execution provided the following:
>
> Execution Plan
> --
>0  SELECT STATEMENT Optimizer=CHOOSE (Cost=739255 Card=99979 By
>   tes=5998740)
>
>10   WINDOW* (SORT)
> :Q607440
>03
>
>21 HASH JOIN* (Cost=738220 Card=99979 Bytes=5998740)
> :Q607440
>02
>
>32   TABLE ACCESS* (FULL) OF 'DRIVING' (Cost=761 Card=99979 By
> :Q607440
>   tes=1499685) 00
>
>42   TABLE ACCESS* (FULL) OF 'HISTORY' (Cost=737374 :Q607440
>Card=149171321 Bytes=6712709445)01
> Statistics
> --
> 229  recursive calls
>2811  db block gets
> 4875215  consistent gets
> 5055303  physical reads
> 652  redo size
>  1297355183  bytes sent via SQL*Net to client
>   117980660  bytes received via SQL*Net from client
> 1062887  SQL*Net roundtrips to/from client
>  12  sorts (memory)
>   2  sorts (disk)
>15943284  rows processed
>
> This is being executed on Oracle 8.1.7.4 on a 6-CPU Sun E4500.  The test
> query was executed using SQL*Plus locally on the server using "set
> autotrace traceonly".  During the actual execution another similarly
> demanding, yet different, script may also be executed.
>
> Questions:
> 1) Does my approach (cursoring through several iterations to manage sort
> size) seem valid?  Is there a better approach?
> 2) Are there other parameters to consider tuning to suit this type of
> query?  Normally this is a busy OLTP system with a 2M sort area size so
the
> system isn't configured for this type of query normally.
> 3) Is there anything in particular I should be monitoring?  I was 
watching
> "DML Processes" using TOAD during the first execution and it appeared 
that
> only 1 or 2 parallel slaves were reading at any one time - is this
> expected?
>
> Thanks for your advice.  In return, I will write a summary when the
> exercise is complete.
>
> Regards,
>   Mark.
>
>
<<>>

>Privileged/Confidential information may be contained in this message.
>   If you are not the addressee indicated in this message
>(or responsible for delivery of the mess

Q. To RAC or go vertical

[tjambu_fatcity]

Hi All
I would like to ask for your thoughts on whether to RAC or just go
vertical (more cpu)
Background
Txn - OLTP like txn during day but batch extracts at night and 
very big
batch extract periodically
Data Volume - 5-10 TByte
Data volatility - 99 % of data is very much like a ware house
(unchanged)
other
1% is read/update/delete/insert
Options
1.  Say a very large server like a HP Superdome or SUN E12000
with 8
CPUs
Server
already exist so cost is in obtaining additional CPU/Blades
ie
Traditional Server using plain old vanilla Oracle EE
- can
still increase head room.  
- batch
programs can utilise all 8 CPUs
- storage
system need not cater for clustering
2,  Same large server like a HP Superdome or SUN E12000 but
partitioned
into two.
Each with 4 CPU.
Oracle
RDBMS + RAC option
- storage
server need to cater for cluster config
- max
performance for batch is with 4 CPUs only

Which would you prefer and why.  I am not convinced with the RAC
option.  Now
if I was going with cheaper Intel servers like Dell servers with 4 CPUS
each, and
purchase say 4 nodes of 4 cpus each, that would be a different
story.  In this case
I have the equipment and ability to grow vertically.
ta
tony

RE: what is BAARF? --- OFA

[Jesse, Rich]

Not a "taker", but I'll put in my disdain for OFA, taken from the OFA doc at
http://download-west.oracle.com/docs/html/A97297_01/appg_ofa.htm :

1)  Who in their right minds thought it was a good idea to name the redos
with a ".log" extention?  It's asking for trouble, if not from a DBA, then
from an SA or a script that's used to clean up old log files.  Why the risk?

2)  For similar reasons, I refuse to create the database files under
$ORACLE_BASE.  How often does a DBA peruse that file tree?  Daily, for me.
Put them on a separate directory off of "/" on Unix, or their own drive
letter for Winders.  Then, anyone wanting to mess with the files from the
O/S level usually needs to go there on purpose and not by accident (unless
"root" does an "rm -R *" from "/", in which case there ain't a whole lot you
can do anyway).

3)  Having the administrative directory structure (table G-8 on the above
link) is impractical at best, and dangerous at worst.  If you lose one MP
(mount point; one set of drives), you lose all instances.  To prevent this,
you'd need to create SEVERAL MPs for each DB, even on a small system.  This
just isn't going to happen.  Instead, we make an "admin" directory under
$ORACLE_BASE, then a "DBNAME" directory for each DB underneath that.  The
appropriate adump, bdump, cdump, udump, pfile, etc. directories are then
created for each DBNAME.  Then, if necessary, each DBNAME directory can have
their own MP, for recoverability and scalability (I wouldn't stretch it to
include "performance"!).

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

NOFA!  :)

Rich

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



> -Original Message-
> From: Piet de Visser [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, August 05, 2003 6:39 AM
> To: Multiple recipients of list ORACLE-L
> Subject: Re: what is BAARF? --- OFA
> 
> 
> Tim, James, Mogens, Group,
> 
> Another BAARF advocate here...
> 
> However, I recognize Tim's problem when HW vendors:
> a) push raid5 or some form of autoraid.
> b) push for 8 separate disks of 125G each with only 
> redo-files on them...
> 
> While the BAARF initiative should continue in its simple, 
> elegant and forcefull form (hammer the msg home),
> I want to place a call to Gary, Tim and others, 
> to undertake A Revamp of the original OFA paper.
> 
> Determine the new requirements (most of the old ones still stand!)
> and from the requirements, enhance the OFA-structure. 
> It should take into account:
>  - SAN capabilities (snapshotting and snapshot-logs or caches)
>  - RAC and Clustered file systems, anticipate on 10G.
>  - easy of admin: single point of admin per database, not per 
> instance.
>  - make provisions for (physical) copies 
> (acceptance/testing/development)
>  - standby-db constructions (including for RAC-dbs, and 
> favour good-old-and-simple sqlplus ;-).
>  - Weigh the importance of redo-speed against things like 
> archive-storage and recoverability based on snap-copies.
> Separate redo-files only if redo is your bottleneck. Tip: Redo-files
> are the easiest db-files to move around: just add new groups...
> 
> Any Takers ? 
> Any ideas for a joint-effort ?
> 
> 
> Regards,
> 
> PdV
> 
> Oracle DBA.
> 
> DTMWFI, FWIW, JMTC and YMWV (of course it will) 
> 
> 
> PS: Frustration cost me my lunch break.
> Me too, Got bitten badly by a hardware vendor recently for _not_ 
> putting aside 35% of my multi-TB disk-capacity exclusively for redos.
> Salesman dreams to sell an additional nr of disks at 5% utilization
> because of the trueism: 
> "redo files should be on private, physical, devices". 
> He even knew of OFA, the Oracle-FILE-Architecture :-).
> Any advertising, as long as they spell the name right
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jesse, Rich
  INET: [EMAIL PROTECTED]

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

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

[Paula_Stankus]

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





I have done DR just fine using the same database name and creating (with links or otherwise) the same file system names.  This was using a complete backup to restore a database to the same host with a different name and the bug alluded to using the "untilclause" I feel is the key.  BTW, I just waited till afterhours brought the database down, copied the file and cloned the easy way.  

-Original Message-
From: DENNIS WILLIAMS [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, August 05, 2003 10:44 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: URGENT: Trying to duplicate database from cold backup -
auxi



Paula - How is your duplication going? Well I hope. Are you basically trying
to perform a disaster recovery? That was basically what I was requested to
do. The statement was "imagine the computer room was taken out by
terrorists, and all you have are the tapes from the off-site storage. You
are provided another server, now recover the database". Is this anything
like what you are trying to do? As I recall, DUPLICATE wouldn't work because
it just copies the production database, not using the backup tape. With help
from a local consultant I accomplished that.




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


-Original Message-
Sent: Monday, August 04, 2003 6:14 PM
To: Multiple recipients of list ORACLE-L




Dear Robert, 


Wow, I get the best!!!  Anyway, in this case I am trying to clone/duplicate
an existing database to a new database.  Therefore, I don't have an existing
control file and when I have done this with same database name from Host A
to Host B as part of the duplication command it basically recreates the
control file.  I have gotten that type of clone to work.


I have also gotten clones to work where I was on host A and wanted to clone
database A to database B by copying from a shutdown database, editing the
"backup controlfile to trace" file.  


This case is different from either one above.  In this case I am trying to
use RMAN and one Host A take a backup of database A and restore it as
database B all from the backup itself.  This operation I have not been able
to do so I wait for off-hours to do the second option listed above.  


-Original Message- 
 ] 
Sent: Monday, August 04, 2003 6:34 PM 
To: Multiple recipients of list ORACLE-L 
auxi 



Paula, 


Try to mount the auxillary database manually, and see what error you get. 
That might help point you in the right direction in solving the problem. 
probably 70% of the time it's an issue with the configuration of the aux 
database (e.g. parameter set wrong, etc...). Manual startup will show you if


that is the case most of the time. 


RF 


-Original Message- 
To: Multiple recipients of list ORACLE-L 
Sent: 8/4/2003 5:14 PM 


Hmmm. 


Got Robert's book on 9i 
This database and clone is in 8.1.7 hmmm. 


-Original Message- 
< mailto:[EMAIL PROTECTED]  > ] 
Sent: Monday, August 04, 2003 5:49 PM 
To: Multiple recipients of list ORACLE-L 
auxi 



Paula - I was never able to get this working, but then I didn't have 
Robert 
Freeman's book at that time. Do you have his book as a resource? 




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


-Original Message- 
Sent: Monday, August 04, 2003 4:39 PM 
To: Multiple recipients of list ORACLE-L 



I did. 


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



you need to :   startup nomount pfile=xxx.ora 


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



Guys, 
  
When trying to duplicate database with this script 
  
  
I have my auxiliary setup as new database, target setup as old database 
and 
am using duplicate database command along with logfile command to create 
new 
logfiles.  
  
  
  
Get error: 
  
RMAN-06136: ORACLE error from auxiliary database: ORA-01507: database 
not 
mounte 


d 


  


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


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

RE: Q. To RAC or go vertical

[tjambu_fatcity]

Stephen

I agree with your comments re scalability vs fault tolerance.
Actually the configuration I am looking at is 16 CPUS. So it
is either one domain (vertical) of 16 CPUS or 
4 nodes of 4 CPUs each or
2 nodes of 8 CPUS each.

And on top of this I have to cater for a Standby environment as well.
The standby will definitely not be a big box like an E12K but maybe (if 
talking SUN) say V880 or 4800 . 

tony

At 06:54 AM 05/08/2003 -0800, you wrote:


>I think the point of RAC is fault tolerance, not scalability.  If it's
>performance you want then you want a bigger box, not more boxes.  8 CPUs is
>not big.  You sure don't need the expensive hardware if all you want to run
>is 8 CPUs.  It would be better to go with a smaller frame and use the money
>you save to get more CPUs and additional I/O capacity.  For example, instead
>of E12K with 8 CPUs, get 4810 with 12 CPUs -- unless you have definite plans
>to push the E12K out to its limits in the future.  Don't forget to consider
>the backup requirements of a 5 - 10 TByte database.  Another consideration,
>I think, is that those big, fancy boxes require additional sys admin skills.
>
>-Original Message-
>Hi All
>
>I would like to ask for your thoughts on whether to RAC or just go vertical
>(more cpu)
>
>Background
>
>Txn - OLTP like txn during day but batch extracts at night and 
>very big batch extract periodically
>Data Volume - 5-10 TByte
>Data volatility - 99 % of data is very much like a ware house (unchanged)
>other 1% is read/update/delete/insert
>
>Options
>1.  Say a very large server like a HP Superdome or SUN E12000
>with 8 CPUs
>Server already exist so cost is in obtaining additional CPU/Blades
>ie Traditional Server using plain old vanilla Oracle EE
>- can still increase head room.  
>- batch programs can utilise all 8 CPUs
>- storage system need not cater for clustering
>
>2,  Same large server like a HP Superdome or SUN E12000 but partitioned
>into two. Each with 4 CPU.
>Oracle RDBMS + RAC option
>- storage server need to cater for cluster config
>- max performance for batch is with 4 CPUs only
>
>
>Which would you prefer and why.  I am not convinced with the RAC option.
>Now
>if I was going with cheaper Intel servers like Dell servers with 4 CPUS
>each, and
>purchase say 4 nodes of 4 cpus each, that would be a different story.  In
>this case
>I have the equipment and ability to grow vertically.
>
>ta
>tony
>-- 
>Please see the official ORACLE-L FAQ: http://www.orafaq.net
>-- 
>Author: Stephen Lee
>  INET: [EMAIL PROTECTED]
>
>Fat City Network Services-- 858-538-5051 http://www.fatcity.com
>San Diego, California-- Mailing list and web hosting services
>-
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from).  You may
>also send the HELP command for other information (like subscribing).

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

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

[Thomas Day]

retention time --- set it for a couple of hours longer than you think the
export will take.



   

  "Guerra, Abraham 

  J" 
  @amfam.com>  cc: 

  Sent by: Subject: Snapshot too old in undo 
tablespace in 9i? 
  ml-errors

   

   

  08/05/2003 01:24 

  PM   

  Please respond   

  to ORACLE-L  

   

   






Hello  Group,

I just upgraded  a database to Oracle 9.2.0.3 from 8.1.7.  I created an
undo tablespace with  10 (default) undo segments... however, during an
export I got the following  message:

ORA-01555: snapshot too old: rollback segment  number 15 with name "
_SYSSMU15$" too small

I thought this was a thing of the past... According to  the documentation,
if an undo segment gets full, it starts using idle ones...  also, the undo
tablespace still had a lot of room to  grow...

Any insights will be welcome.

Thanks

Abraham Guerra
Oracle  DBA
American Family  Insurance

<< Attachment Removed : Notebook.jpg >>




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

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

Re: Opatch

[Kirtikumar Deshpande]

Is the correct perl lib in the PATH? 

- Kirti 


--- "MacGregor, Ian A." <[EMAIL PROTECTED]> wrote:
> I'm trying to use opatch and receive the following error
> 
> [EMAIL PROTECTED] $ opatch apply
> PERL5LIB=; export PERL5LIB
> /usr/local/bin/perl
> /opt/oracle/admin/general/patchsets/opatch/patch2617419/OPat
> ch/opatch.pl apply
> Can't call method "build_option_details" on an undefined value at
> /opt/oracle/admin/general/patchsets/opatch/patch2617419/OPatch/opatch_modules/Apply.pm
>  line
> 2299.
> 
> ORACLE_HOME is correctly set, PATH is correct as well.  Any idea what the problem 
> may be.
> 
> Every opatch command fails with the above error including such things as opatch 
> -version.
> 
> Ian MacGregor
> Stanford Linear Accelerator Center
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: MacGregor, Ian A.
>   INET: [EMAIL PROTECTED]
> 

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

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

RE: what is BAARF?

[Thater, William]

Rachel Carmichael  scribbled on the wall in glitter crayon:

> if nominated I will not run, if elected I shall not serve

but think of the distraction if you wear THE DRESS.;-)

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

There's nothing I like less than bad arguments for a view that I hold dear.
- Daniel Dennett 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Thater, William
  INET: [EMAIL PROTECTED]

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

RE: Snapshot too old in undo tablespace in 9i?

[Guerra, Abraham J]

Thanks.

Abraham

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



retention time --- set it for a couple of hours longer than you think the
export will take.



   

  "Guerra, Abraham 

  J" 
  @amfam.com>  cc: 

  Sent by: Subject: Snapshot too old in undo 
tablespace in 9i? 
  ml-errors

   

   

  08/05/2003 01:24 

  PM   

  Please respond   

  to ORACLE-L  

   

   






Hello  Group,

I just upgraded  a database to Oracle 9.2.0.3 from 8.1.7.  I created an
undo tablespace with  10 (default) undo segments... however, during an
export I got the following  message:

ORA-01555: snapshot too old: rollback segment  number 15 with name "
_SYSSMU15$" too small

I thought this was a thing of the past... According to  the documentation,
if an undo segment gets full, it starts using idle ones...  also, the undo
tablespace still had a lot of room to  grow...

Any insights will be welcome.

Thanks

Abraham Guerra
Oracle  DBA
American Family  Insurance

<< Attachment Removed : Notebook.jpg >>




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

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

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

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

[Paula_Stankus]

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





With DR did use RMAN.  Again:


(1) using RMAN worked fine from one host to another of same database
(2) using cold backup and editing backup controlfile worked fine for same host different database name
(3) using RMAN for duplicating one database to same host with different database name in Version 8.1.7.X seemed to require "until"

-Original Message-
From: DENNIS WILLIAMS [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, August 05, 2003 11:39 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: URGENT: Trying to duplicate database from cold backup -
auxi



Paula - Okay, when you say you brought the database down, copied the files,
etc., I presume that had nothing to do with RMAN? You didn't mention RMAN in
that post, but your original post was all about RMAN.


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




I have done DR just fine using the same database name and creating (with
links or otherwise) the same file system names.  This was using a complete
backup to restore a database to the same host with a different name and the
bug alluded to using the "untilclause" I feel is the key.  BTW, I just
waited till afterhours brought the database down, copied the file and cloned
the easy way.  


-Original Message- 
 ] 
Sent: Tuesday, August 05, 2003 10:44 AM 
To: Multiple recipients of list ORACLE-L 
auxi 



Paula - How is your duplication going? Well I hope. Are you basically trying


to perform a disaster recovery? That was basically what I was requested to 
do. The statement was "imagine the computer room was taken out by 
terrorists, and all you have are the tapes from the off-site storage. You 
are provided another server, now recover the database". Is this anything 
like what you are trying to do? As I recall, DUPLICATE wouldn't work because


it just copies the production database, not using the backup tape. With help


from a local consultant I accomplished that. 




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


-Original Message- 
Sent: Monday, August 04, 2003 6:14 PM 
To: Multiple recipients of list ORACLE-L 




Dear Robert, 


Wow, I get the best!!!  Anyway, in this case I am trying to clone/duplicate 
an existing database to a new database.  Therefore, I don't have an existing


control file and when I have done this with same database name from Host A 
to Host B as part of the duplication command it basically recreates the 
control file.  I have gotten that type of clone to work. 


I have also gotten clones to work where I was on host A and wanted to clone 
database A to database B by copying from a shutdown database, editing the 
"backup controlfile to trace" file.  


This case is different from either one above.  In this case I am trying to 
use RMAN and one Host A take a backup of database A and restore it as 
database B all from the backup itself.  This operation I have not been able 
to do so I wait for off-hours to do the second option listed above.  


-Original Message- 
< mailto:[EMAIL PROTECTED]  > ] 
Sent: Monday, August 04, 2003 6:34 PM 
To: Multiple recipients of list ORACLE-L 
auxi 



Paula, 


Try to mount the auxillary database manually, and see what error you get. 
That might help point you in the right direction in solving the problem. 
probably 70% of the time it's an issue with the configuration of the aux 
database (e.g. parameter set wrong, etc...). Manual startup will show you if



that is the case most of the time. 


RF 


-Original Message- 
To: Multiple recipients of list ORACLE-L 
Sent: 8/4/2003 5:14 PM 


Hmmm. 


Got Robert's book on 9i 
This database and clone is in 8.1.7 hmmm. 


-Original Message- 
< mailto:[EMAIL PROTECTED]   <
mailto:[EMAIL PROTECTED]  > > ] 
Sent: Monday, August 04, 2003 5:49 PM 
To: Multiple recipients of list ORACLE-L 
auxi 



Paula - I was never able to get this working, but then I didn't have 
Robert 
Freeman's book at that time. Do you have his book as a resource? 




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


-Original Message- 
Sent: Monday, August 04, 2003 4:39 PM 
To: Multiple recipients of list ORACLE-L 



I did. 


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



you need to :   startup nomount pfile=xxx.ora 


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



Guys, 
  
When trying to duplicate database with this script 
  
  
I have my auxiliary setup as new database, target setup as old database 
and 
am using duplicate database command along with logfile command to create 
new 
logfiles.  
  
  
  
Get error: 
  
RMAN-06136: ORACLE

Tuning ideas requested

[Mark Richard]

Hi Everyone,

I apologise in advance for the long post - I want to explain the situation
clearly though.  If tuning large queries isn't your thing you can probably
skip this.

I have to do some large data conversion activities and I'm looking for
suggestions to tune a fairly average query.  Let me try to briefly explain
the situation:

1)  A history table containing ~150million records needs two attributes
added.
2) One of these attributes has a constant value assigned for all existing
records, the other attribute is populated based on a rule which can be
achieved using a pair of analytical functions.
3) The opportunity to change tablespace and redefine one index is being
incorporated

The approach so far is as follows:

1) Rename existing table
2) Define empty table in new tablespace, do not create any indexes
3) Create a temporary table listing the unique products (around 1.4million
products exist in the table having on average 100 records each) and a
required value
4) Cursor through the products applying the statement below in batches
5) Insert records into new table
6) Delete products from temporary driving table
7) Commit steps 5 and 6 and repear cursor in step 4 until complete
8) Create indexes, drop temporary table, etc

The temporary table deletion is used to provide a restart capability in the
event of failure.  The statement to create records is:

SELECT /*+ use_hash(m th) parallel(m 4) parallel(th 4) */
th.,
  m.version
- COUNT (1) OVER (PARTITION BY sourceguid)
+ ROW_NUMBER () OVER (PARTITION BY sourceguid ORDER BY
creationdate)

VERSION
  FROM history th, driving m
 WHERE th.sourceguid = m.productguid
   AND m.rownumber >= 1
   AND m.rownumber <= 

Before execution I changed the sort_area_size to 1GB.  I tried using a
"magic number" of 100,000 which resulted in about 17million records being
created in ~40 minutes, I then tried a magic number of 200,000 which caused
the following error after ~20 minutes:

ERROR at line 8:
ORA-12801: error signaled in parallel query server P001
ORA-04030: out of process memory when trying to allocate 8192 bytes (sort
subheap,sort key)

An autotrace of the 100,000 execution provided the following:

Execution Plan
--
   0  SELECT STATEMENT Optimizer=CHOOSE (Cost=739255 Card=99979 By
  tes=5998740)

   10   WINDOW* (SORT)
:Q607440
   03

   21 HASH JOIN* (Cost=738220 Card=99979 Bytes=5998740)
:Q607440
   02

   32   TABLE ACCESS* (FULL) OF 'DRIVING' (Cost=761 Card=99979 By
:Q607440
  tes=1499685) 00

   42   TABLE ACCESS* (FULL) OF 'HISTORY' (Cost=737374 :Q607440
   Card=149171321 Bytes=6712709445)01
Statistics
--
229  recursive calls
   2811  db block gets
4875215  consistent gets
5055303  physical reads
652  redo size
 1297355183  bytes sent via SQL*Net to client
  117980660  bytes received via SQL*Net from client
1062887  SQL*Net roundtrips to/from client
 12  sorts (memory)
  2  sorts (disk)
   15943284  rows processed

This is being executed on Oracle 8.1.7.4 on a 6-CPU Sun E4500.  The test
query was executed using SQL*Plus locally on the server using "set
autotrace traceonly".  During the actual execution another similarly
demanding, yet different, script may also be executed.

Questions:
1) Does my approach (cursoring through several iterations to manage sort
size) seem valid?  Is there a better approach?
2) Are there other parameters to consider tuning to suit this type of
query?  Normally this is a busy OLTP system with a 2M sort area size so the
system isn't configured for this type of query normally.
3) Is there anything in particular I should be monitoring?  I was watching
"DML Processes" using TOAD during the first execution and it appeared that
only 1 or 2 parallel slaves were reading at any one time - is this
expected?

Thanks for your advice.  In return, I will write a summary when the
exercise is complete.

Regards,
  Mark.

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

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: Q. To RAC or go vertical

[Odland, Brad]

When you do TCO analysis do add in the costs of administration? The learning
curve?
The maintenance? The value of reliability and familiar support structures?
WHat kind of proof do you have about the claim of RAC's reliability compared
to a single mutliple processor system?

What about when a node does fail and suddenly the users and batch processing
is left with 1/2 or a 1/4 of the procsessing power gone? How long is it
going to take to get the system back to 100%? Lots of admins can be
confident in gettting a huge hp or sun box up in less than 12 hours. Is 6
hours of downtime worse than three days of processing at 50% capacity?

What about the value of KNOWING a solution works not just speculating on how
much money it MIGHT save.

The IT industry has fallen because of lots of "sell them the sizzle, get em'
the bacon later" marketing hype like the info floating around about RAC and
grid. Software and hardware vendors have been jumping from one "great idea"
to another. The result is a lot of products that end up in the bone yard and
another round of layoffs.

What is happening is hardware and software vendors are feeding the markets
desire to have a low cost system with unlimited power and scalability. I am
sorry to say you STILL can't have both. I know what vendors are thinking,
they think this will be holy grail of IT that will bring us back to the fat
days of pre y2k. 

"Get the grid going it so complex that they will have to use our consulting
services too...once wer'e in the door we'll be there for years." IT
directors made the mistake of trusting vendors once. They aren't going to do
again.

Frankly I am all for reducing complexity and increasing reliability. Right
now there is proven technology that may cost a bit more but in the long is
going to be the right decision. 

"The above notes and my company aside, I would be shocked if I ever
implemented a large single-image Oracle instance ever again. "

Yeah right when monkeys fly out my butt.

Brad O.


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




The point of RAC is both fault tolerance AND scalability.  More
specifically, the ability to recover from a multi-node failure as well as
use commodity hardware and scale on demand are the major motivating factors.
Besides that, the cost difference between a mid-size SSI server and a RAC
cluster is simply stunning.  

We've done the TCO analysis over and over again, and there's simply no
fiscal justification in today's world to put a mid-size database instance on
anything _besides_ RAC.  If you look at the hardware cost difference alone
between an 8-way sun box and two 4-way linux boxes, its more than a 10-fold
cost difference. That's before you take into account you often need a volume
manager, a cluster server, and a whole second node to cluster it with to
achieve the same level of reliability you get with a RAC cluster.  

As always, full disclosure says I should say that I have a vested interest
in the success of RAC, but I'm not even including our product in the cost
comparison.  Just vanilla RAC-on-linux vs. big-UNIX is a pretty compelling
story in and of itself.

Now, I said there's no _fiscal_ justification.  RAC is obviously not a
hammer for every nail.  There are both applications and workloads that
either require special tuning or are just not optimal for message-passing
clusters.  Also, there are scalability limitations due to interconnect
latency in terms of the number of nodes you can have in a cluster - this is
something we're working on addressing here.

RAC's other big problem is that Oracle's RAC documentation
isartistic...by which I mean misleading, difficult to understand, and
sometimes just wrong.  This keeps organizations off of RAC or convinces them
to hire consultants, and the vast majority of RAC consultants out there are
even worse than the vast majority of Oracle/Sun consultancy practices -
cookie cutter solutions and ill-informed consultants.  

The above notes and my company aside, I would be shocked if I ever
implemented a large single-image Oracle instance ever again.  

*clambers off soapbox*

Thanks,
Matt

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

> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On 
> Behalf Of Stephen Lee
> Sent: Tuesday, August 05, 2003 10:54 AM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: Q. To RAC or go vertical
> 
> 
> 
> I think the point of RAC is fault tolerance, not scalability. 
>  If it's performance you want then you want a bigger box, not 
> more boxes.  8 CPUs is not big.  You sure don't need the 
> expensive hardware if all you want to run is 8 CPUs.  It 
> would be better to go with a smaller frame and use the money 
> you save to get more CPUs and additional I/O capacity.  For 
> example, instead of E12K with 8 CPUs, get 4810 with 12 CPUs 
> -- u

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

[Freeman Robert - IL]

Yep, if I can just move the datafiles over gigabit link, thats what I will
do.

Otherwise I just do a restore and rename...

RF


-Original Message-
To: Multiple recipients of list ORACLE-L
Sent: 8/5/2003 5:19 PM

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

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

There's a separate project for verifying backups. 

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

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

Jared






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

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


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



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

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

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

[Jack Daniels]

Excellent points Matt. "resistance to change" is very hard to overcome. I've come across a lot of people who view any new technology as unreliable, complicated and expensive. But with RAC, its none of those. Its been around and version > 9.2.0.1 is reliable, and I personally don't have issues with its so-called complicated-ness. 
 
I'm supporting 3 applications on a 2-node RAC system (by taking advantage of all 16 cpus instead of just 8 in a/p cluster) and plan to add a new node when 2 new applications come in the next few months. We can take advantage of the latest/greatest cpu by bringing on a new node, instead of getting "locked" in to a huge SMP box and relying on the vendor to provide "trade-in" deals for outdated slower architectures.
 
Another case in point :
 
It took almost an year to finally fix an corruption issue with Sun E10K; had to face numerous outages, with heavy penalties (financial) to the customer due to failing SLAs. 
 
Compare that to our recent experience with RAC. 
 
One of the nodes of (IBM pSeries) suffer a hardware failure; 2nd node transparently picks up the extra load; operates at higher load than usual; no data loss; no outage; no impact to SLA. 2 days later, the hardware is replaced and the 1st node joins the cluster and load is balanced again across 2 nodes. Its priceless to the company. 
Matthew Zito <[EMAIL PROTECTED]> wrote:
*sigh* Alright, I'll bite. See inline.--Matthew ZitoGridApp SystemsEmail: [EMAIL PROTECTED]Cell: 646-220-3551Phone: 212-358-8211 x 359http://www.gridapp.com> -Original Message-> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On > Behalf Of Odland, Brad> Sent: Tuesday, August 05, 2003 3:35 PM> To: Multiple recipients of list ORACLE-L> Subject: RE: Q. To RAC or go vertical> > > When you do TCO analysis do add in the costs of > administration? Yes (in fact, we even say that it costs three times as much to administer alinux RAC cluster as a sun cluster).> The learning curve? Yes.> The maintenance? Yes. >The > value of reliability and familiar support structures? WHat > kind of p!
roof do
 you have about the claim of RAC's > reliability compared to a single mutliple processor system?> The value of reliability? I'm not talking about buying some random Intelwhite-box vendor - I'm talking about a name like IBM, HPQ, etc. I have seenfar higher reliability from those vendors than Sun in the last four years.Case in point - I had three E6500s once supporting over 100 IBM intelservers. I had one intel failure in a six month period, and three hardwarefailures on the Suns. That's an impressive reliability ratio from ahardware perspective. Familiar support structures should be an oxymoron -your hardware should fail rarely enough that you should have to look up the1-800 number you need to call. As far as proof of reliability, that's hard to quantify. However, from alogical perspective, on an SMP system when a processor fails, the entiresystem goes down. When a node fails in a cluster, the others take o!
ver
 forit. Yes - software bugs can rear their ugly head and prevent that fromhappening, but that's a constant.> What about when a node does fail and suddenly the users and > batch processing is left with 1/2 or a 1/4 of the procsessing > power gone? How long is it going to take to get the system > back to 100%? Lots of admins can be confident in gettting a > huge hp or sun box up in less than 12 hours. Is 6 hours of > downtime worse than three days of processing at 50% capacity?Is it better to have a performance impacted system or a down system? Is itbetter to buy twice the capacity to compensate for the fact your hideouslyexpensive UNIX server tends to fall over when there's a two-bit memory erroror cache corruption? I've never seen an intel box broken so badly it takesthree days to fix. On the other hand, I had an e4500 that took Sun 7 monthsof replacing every part in the system to figure ou!
t what
 was wrong with it.We had to decomission it as a production server because it was crashingevery few days.Hey, if you're concerned about node downtime and want to be crafty - buy anextra node for your RAC cluster. Splurge and spend the extra $10k for anode that sits there idle until its needed. It's _still_ better than buyingtwice your needed capacity. In fact - I haven't run the numbers, but I betyou could buy double the nodes you actually need and leave them idle andstill be vastly cheaper than two big unix servers.> What about the value of KNOWING a solution works not just > speculating on how much money it MIGHT save.> Do today's solutions "work"? If you're running an enterprise database today,you need to buy two servers, pay for a clustering software, spend the moneyto implement a clustering solution, pay through the nose for platinumsupport on these things, and you still need to hire smart !
people to
 runthem. And the end result is a solution where when a server dies, the otherserver that's been sitting there sucking down power and idling now gets tosta

RE: Q. To RAC or go vertical

[Stephen Lee]

Yeah, I thought about making the statement a little more vague to leave
myself plenty of wiggle room.  But, what the heck, go ahead and make it, and
see what happens.

Granted, there might be extreme circumstances in which RAC might be the only
way to bring sufficient numbers of CPUs to bear.  But, in general, while I'm
sure Oracle would much rather you pay $60K per CPU than $40K, and in order
to get people to do that, they would like everyone to believe that RAC is
that amazing application with a million-and-one uses, I can't think of any
situation where two boxes with, for example, 8 CPUs each would match the
performance of one box with 16 CPUs. assuming all other things are equal,
and we don't have some pathological situation like the old Sparc 2000 that
could not support the number of CPUs it could hold.  To put it more
generally, I don't think scaling out is as good as scaling up when it comes
to best database performance.

If the economics of the situation were such that a Redundant Array of
Inexpensive Computers (RAIC??) were the goal -- i.e. multiple cheap
computers as opposed to one very pricey computer -- and if your application
writers had the intellectual kahones and considerable programming experience
to write the application to efficiently use such an arrangement, then RAC
would make sense.  In the context of the original post, I got the impression
that the company has fairly deep pockets, so there is no intent to use RAIC
as a bargain basement equivalent of a big box (as far as I could tell).
There was no indication that the application(s) will be tailored to RAC, so
I don't think scaling out will be as effective as scaling up.

If fault tolerance is a requirement for the installation, or finances
require some kind of RAIC installation, or you have maxxed out your E15K,
then RAC might be appropriate.  But I don't think its use as just an
alternative means of bringing in more CPUs is correct.

And one of the other guys here just said Oracle now has the top TMP(c or d)
benchmark using HP Itanium systems.  I haven't checked it out yet, so that's
just hearsay.  I guess that means Microsoft will now be required to put
together a bigger cluster to beat it.


> -Original Message-
> 
> While fault tolerance is certainly one of the features of RAC,
> it isn't correct to say that it is not also for scalability.
> 
> Buy a bigger box?  That works fine until you're in the biggest
> box you can get, then what?  I realize that it's a small market
> segment that requires that kind of hardware, but it still exists.
> 
> Sun has been testing a cluster of 15k servers with RAC, ostensibly
> for scalability.  Some nodes are populated with 78 CPU's and 288
> Gig of RAM.  ( yes, that is correct ).
> 
> Jared
> 
> 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Stephen Lee
  INET: [EMAIL PROTECTED]

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

Log buffer and Shared Pool tuning.

[Avnish.Rastogi]

What are the things I should monitor to make sure that Shared Pool and Log buffer are 
set correctly. On one database I have Shared pool GAB and Log buffer MOB, are these 
values too high.

Thanks



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

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

RE: Unix process tree

[Jeremy Bainbridge-Smith]

Title: Unix process tree



Thanks 
mate!

  -Original Message-From: Tanel Poder 
  [mailto:[EMAIL PROTECTED]Sent: Tuesday, 5 August 2003 10:19 
  p.m.To: Multiple recipients of list ORACLE-LSubject: Re: 
  Unix process tree
  Redhat AS 2.1 at least has something, probably 
  others as well. It's "pstree" if I recall correctly.
   
  Also, ps has some options to print process 
  dependencies out.
   
  Tanel.
  
- Original Message - 
From: 
Jeremy 
Bainbridge-Smith 
To: Multiple 
recipients of list ORACLE-L 
Sent: Tuesday, August 05, 2003 5:49 
AM
Subject: Unix process tree

Hi Team 
Firstly apologies for a slightly OT 
question. 
Solaris has a great little command called "ptree" 
which given a process id as an argument, will present a tree of all the 
process' related to the given process id.
Question: Is there a similar command for 
Linux? 
Cheers Jeremy 
 Jeremy Bainbridge-Smith Database Administrator Hamilton City Council 
Ph.   +64 7 838 6428 
Mob.  +64 21 894481 
~~~