date:20031211

Thursday, December 11, 2003, 6:14:25 PM, Tanel Poder ([EMAIL PROTECTED]) wrote:
TP> Hurry up, zettabyte and yottabyte might still be free ;)

Actually, now I wonder, how far do the names go? We have
kilobyte, megabyte, gigabyte, terabyte, petabyte, and then
what?

Best regards,

Jonathan Gennick --- Brighten the corner where you are
http://Gennick.com * 906.387.1698 * mailto:[EMAIL PROTECTED]

Join the Oracle-article list and receive one
article on Oracle technologies per month by 
email. To join, visit http://four.pairlist.net/mailman/listinfo/oracle-article, 
or send email to [EMAIL PROTECTED] and 
include the word "subscribe" in either the subject or body.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jonathan Gennick
  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: Windows clustering???

I'm guessing that you removed the monitor, keyboard and mouse, disabled terminal services, removed it from the domain, unbound NetBIOS from TCP/IP and shut down all of the non-required services (especially "Server") - and - put a penguin sticker on the front of it, so that people thought it was a scary leenucks box.
 
bonus points if it no longer resolves via DNS.
 
BDBAFH.
 
seriously though, we had a 7.3.4.4.1 db running on WinNT Server 4.0 at a client site whereby the OS had an uptime of over 2 years. guess that they just didn't beat on it much. uptimes of 6 months was not unusual."Cunningham, Gerald" <[EMAIL PROTECTED]> wrote:
Oh yeah? Just this week we had a Windows box that had been up for 29days straight!!!Yep. You read it right. I'm not giving out our secrets though.-Original Message-Sent: Wednesday, December 10, 2003 10:55 PMTo: Multiple recipients of list ORACLE-LThis is a small, static, but fiercely loyal group of VMS users for HP tomilk. OpenVMS is money in the bank for HP, as it was for Compaq andDEC. Even the bean-counters understand the insanity of shutting off aguaranteed, endless, and highly-profitable revenue stream upon whichthey do not have to expend any marketing or sales resources...Officially, they currently promise OpenVMS support through 2012 orthereabouts, I believe.In Colorado Springs (at the DEC-then-Compaq-then-HP hosting center),there is a VMS cluster hosting an Rdb-based application th!
at has
 beencontinuously available for the past 11-12 years. Zero downtime for theapplication. Absolutely stunning.on 12/10/03 2:14 PM, Tanel Poder at [EMAIL PROTECTED] wrote:> Maybe you all already know that, but HP is planning to support OpenVMS> on their Itanium servers :)> > Tanel.> > - Original Message -> To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>> Sent: Tuesday, December 09, 2003 10:14 PM> > >> I'm guessing they're not running Oracle on this VMS cluster. I >> really> liked>> the part about "the most difficult part was explaining to managers >> why it was unnecessary to shut systems down, even during the physical> relocation.">> >> http://www.theinquirer.net/?article=13002>> >> Imagine if DEC had any marketing...>> >> Rich&g!
t;>
 >> Rich Jesse System/Database Administrator>> [EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA>> -->> Please see the official ORACLE-L FAQ: http://www.orafaq.net>> -- >> Author: Jesse, Rich>> INET: [EMAIL PROTECTED]>> >> Fat City Network Services -- 858-538-5051 http://www.fatcity.com>> San Diego, California -- Mailing list and web hosting services>> ->> To REMOVE yourself from this mailing list, send an E-Mail message>> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in >> the message BODY, include a line containing: UNSUB ORACLE-L (or the >> name of mailing list you want to be removed from). You may also send>> the HELP command for other information (like subscribing).>> > -- Please see the o!
fficial
 ORACLE-L FAQ: http://www.orafaq.net-- Author: Tim GormanINET: [EMAIL PROTECTED]Fat City Network Services -- 858-538-5051 http://www.fatcity.comSan Diego, California -- Mailing list and web hosting services-To REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in themessage BODY, include a line containing: UNSUB ORACLE-L (or the name ofmailing list you want to be removed from). You may also send the HELPcommand for other information (like subscribing).-- Please see the official ORACLE-L FAQ: http://www.orafaq.net-- Author: Cunningham, GeraldINET: [EMAIL PROTECTED]Fat City Network Services -- 858-538-5051 http://www.fatcity.comSan Diego, California -- Mailing list and web hosting
 services-To REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).
Do you Yahoo!?
New Yahoo! Photos - easier uploading and sharing

Re: better delete statement to remove duplicate rows from exception

2003-12-11 Thread Dias Costa

Hi,

You can do this:

delete
from  orders o1
where rowid  <  (select  max(rowid)
  from  orders o2
  where o1.order_id = o2.order_id
  group   by  order_id
  having   count(order_id) > 1);
Obviously you cand firstly do a select statment (on a limited set of data),
instead of a delete statement, just to be sure it works as expected.


Best regards
Dias Costa
Jacques Kilchoer wrote:

In the situation below, is there a better way to write the delete statement that eliminates duplicates? (assuming duplicate rows form at most 5 % of the table rows) Notice that the exceptions table is not analyzed.

If I analyze the exceptions table, is there then another better way to write it?

create table my_exceptions
 (row_id urowid,
  owner varchar2 (30),
  table_name varchar2 (30),
  constraint varchar2 (30)
 );
create table orders
  (order_id   number (8) not null,
   order_date date,
   constraint orders_uq1 unique (order_id) disable
  ) ;
/* -- load table orders with millions of rows */
create index orders_idx1
on orders (order_id) ;
analyze table orders estimate statistics sample 10 percent ;
alter table orders
  enable constraint orders_uq1
  exceptions into my_exceptions ;
delete
from orders a
where
  a.rowid in
(select d.delete_row_id
  from
   (select
   min (b.row_id) over (partition by c.order_id) as keep_row_id,
   b.row_id as delete_row_id
 from my_exceptions b, orders c
 where c.rowid = b.row_id
 group by c.order_id, b.row_id
   ) d
  where
d.delete_row_id != d.keep_row_id
) ;
commit ;
alter table orders
  enable constraint orders_uq1 ;
truncate table my_exceptions ;
 



--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Dias Costa
 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: Performance tuning in complex environment

2003-12-11 Thread John Kanagaraj

Reminds me of the day when a third-party developed app (main batch program)
ran *very* slowly - the user department went out and bought this app and
server on their own without IT's blessing or support (a different story).
Dialogue below:

Third-party Developer (TPD): This same batch program which runs 1hr 30 min
on your box completes under 30 min at our Office with *your* data. We
suggest obtaining an IBM S80 because it is 3 times faster than your current
box

(IBM On-site person: Yes! Yes!!!)

User Department Manager (UDM): Ok - we have a $100,000 budget for this -
lets go out and buy this h/w (We need to go through IT for this purchase)

My Manager, when approached with this issue (MM): I know your TPD has this
view, but can my Sr. DBA look at this problem?

UDM: Ok, but I doubt anything can be done since my TPD says so...

TPD: Hey, your DBA can't mess with our code!

Sr.DBA (Me!): Ok - let's take a look at V$SYSTEM_EVENT, V$SESSION_EVENT and
V$SESSION_WAIT when your program runs...

Me: Hey - what's this session doing with 'SQL*Net Message from dblink'? This
is the top wait (more than 99% of TIME_WAITED in V$SESSION_EVENT)

TPD: Yeah - we have a view that makes a call to your employee table sitting
on your prod box to fetch the Emp name, once for every row in the loop
(1000s of rows, 3300 rows a pop)

Me: Haven't you guys heard of Replicated Tables? 

TPD: What's that? 

Me: (after creating a local copy and replacing the view with an indexed
table) Run your program now...

TPD: Hey - it finished in 5 minutes!!! We don't need to buy any other box!

UDM: I like that!!! Thanks!!

MM: Well done - I knew my DBA could do it!

(IBM On-site person: [EMAIL PROTECTED]@#&*()+__@)

Me: (Hitting myself on the head, and thinking to myself: I should have asked
for just 1% of the $$ that would have otherwise been unnecessarily spent on
that great big H/w box :(

Moral of the story:

(a) Never ass*u*me anything - ask for stats to prove any 'assumption'
(b) Get the right tools to determine the problem area (and use it correctly)

Afterthought (c) - Follow Gary Goodman's principle: Ask for 10% of the $$
allocated for the h/w that would have otherwise been spent on *trying* to
solve the problem by throwing h/w at it! (Cary - correct me if I erred
here!)

John Kanagaraj
DB Soft Inc
Phone: 408-970-7002 (W)

Grace - Getting something we do NOT deserve
Mercy - NOT getting something we DO deserve
Click on 'http://www.needhim.org' for Grace and Mercy that is freely
available!

** The opinions and facts contained in this message are entirely mine and do
not reflect those of my employer or customers **

>-Original Message-
>From: [EMAIL PROTECTED] 
>[mailto:[EMAIL PROTECTED] 
>Sent: Thursday, December 11, 2003 11:29 AM
>To: Multiple recipients of list ORACLE-L
>Subject: RE: Performance tuning in complex environment
>
>
>Not really sure what happened and why we decided to that. I 
>was involved in the beginning of project and remembered that 
>PM was mentioning about talking to another Logician client who 
>were facing same issues. 
>
>-Original Message-
>Jamadagni, Rajendra
>Sent: Thursday, December 11, 2003 10:55 AM
>To: Multiple recipients of list ORACLE-L
>
>
>Ummm ... what was the problem that prompted you guys to 
>replace citrix servers? 
>
>Raj
>---
>-
>Rajendra dot Jamadagni at nospamespn dot com
>All Views expressed in this email are strictly personal.
>QOTD: Any clod can have facts, having an opinion is an art !
>
>
>-Original Message-
>[mailto:[EMAIL PROTECTED]
>Sent: Thursday, December 11, 2003 1:35 PM
>To: Multiple recipients of list ORACLE-L
>
>
>Hello Everyone, I am trying to get some help/suggestions reg. 
>how to troubleshoot performance issues.
>
>Little back ground about our environment. Its third party 
>application (Logician) from GE. There are total 11 databases, 
>all on oracle 8174 H-UX 11i in cluster environment. All the 
>databases are on EMC Symmetrix using 6 disks. All the clients 
>are connecting to database thru Citrix terminal servers. 
>In last one year we spend lots of time/money in tuning 
>databases, replacing Citrix servers but end result is same. I 
>was wondering if anybody out there has ran into same kind of 
>situation. Our (DBAs) guess is the disk layout is not optimal 
>but we also dont have any data to prove that disks are the 
>bottleneck. Is there any way to collect these kinds of stats 
>in Oracle. We aren't getting much help from our SAN administrator.
>
>
>
>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 erro

Re: Re[2]: http://www.wintercorp.com/vldb/2003_TopTen_Survey/TopTenWinners.a sp

2003-12-11 Thread Eric King

But as you all know those are really crap, only companies such as EMC
benefit from it.

Eric

- Original Message - 
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Thursday, December 11, 2003 18:14
http://www.wintercorp.com/vldb/2003_TopTen_Survey/TopTenWinners.a sp


> Hurry up, zettabyte and yottabyte might still be free ;)
>
> Tanel.
>
> - Original Message - 
> To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
> Sent: Friday, December 12, 2003 12:44 AM
> http://www.wintercorp.com/vldb/2003_TopTen_Survey/TopTenWinners.a sp
>
>
> > Yeah, clearly, the guys at Exabyte were thinking ahead when they came up
> with their name. ;-)
> >
> > -Original Message-
> > Sent: Thursday, December 11, 2003 5:34 PM
> > To: Multiple recipients of list ORACLE-L
> > http://www.wintercorp.com/vldb/2003_TopTen_Survey/TopTenWinners.a sp
> >
> >
> > Thursday, December 11, 2003, 5:14:26 PM, Ryan ([EMAIL PROTECTED])
wrote:
> > R> very nice. what is teradata? I never hear that dbms mentioned.
> >
> > Isn't Teradata what Walmart uses? From what I know, it's
> > always been aimed at the market for really, really big
> > databases. Hence the prefix "tera", which isn't so big
> > anymore. Maybe they should rename the product Petadata.
> >
> > Best regards,
> >
> > Jonathan Gennick --- Brighten the corner where you are
> > http://Gennick.com * 906.387.1698 * mailto:[EMAIL PROTECTED]
> >
> > Join the Oracle-article list and receive one
> > article on Oracle technologies per month by
> > email. To join, visit
> http://four.pairlist.net/mailman/listinfo/oracle-article,
> > or send email to [EMAIL PROTECTED] and
> > include the word "subscribe" in either the subject or body.
> >
> > -- 
> > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > -- 
> > Author: Jonathan Gennick
> >   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: Bobak, Mark
> >   INET: [EMAIL PROTECTED]
> >
> > Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> > San Diego, California-- Mailing list and web hosting services
> > -
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from).  You may
> > also send the HELP command for other information (like subscribing).
> >
>
>
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: Tanel Poder
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
>
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Eric King
  INET: [EMAIL PROTECTED]

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

Re: Re[2]: http://www.wintercorp.com/vldb/2003_TopTen_Survey/TopTenWinners.a sp




so what features does teradata have that oracle 
doesnt for VLDBs? 

  - Original Message - 
  From: 
  Paul 
  Drake 
  To: Multiple recipients of list ORACLE-L 
  
  Sent: Thursday, December 11, 2003 6:59 
  PM
  Subject: Re: Re[2]: http://www.wintercorp.com/vldb/2003_TopTen_Survey/TopTenWinners.a 
  sp
  
  > Maybe they should rename the product Petadata.
  If they did, then its a good thing that they didn't name it 
  "TeraFile".
   
  PdJonathan Gennick <[EMAIL PROTECTED]> 
  wrote:
  Thursday, 
December 11, 2003, 5:14:26 PM, Ryan ([EMAIL PROTECTED]) wrote:R> 
very nice. what is teradata? I never hear that dbms mentioned.Isn't 
Teradata what Walmart uses? From what I know, it'salways been aimed at 
the market for really, really bigdatabases. Hence the prefix "tera", 
which isn't so biganymore. Maybe they should rename the product 
Petadata.Best regards,Jonathan Gennick --- Brighten the 
corner where you arehttp://Gennick.com * 906.387.1698 * 
mailto:[EMAIL PROTECTED]Join the Oracle-article list and receive 
onearticle on Oracle technologies per month by email. To join, visit 
http://four.pairlist.net/mailman/listinfo/oracle-article, or send email 
to [EMAIL PROTECTED] and include the word "subscribe" 
in either the subject or body.-- Please see the official 
ORACLE-! L FAQ: http://www.orafaq.net-- Author: Jonathan 
GennickINET: [EMAIL PROTECTED]Fat City Network Services -- 
858-538-5051 http://www.fatcity.comSan Diego, California -- Mailing list 
and web hosting 
services-To 
REMOVE yourself from this mailing list, send an E-Mail messageto: 
[EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe 
message BODY, include a line containing: UNSUB ORACLE-L(or the name of 
mailing list you want to be removed from). You mayalso send the HELP 
command for other information (like subscribing).
  
  
  Do you Yahoo!?New 
  Yahoo! Photos - easier uploading and sharing

RE: for security patches - going to 9.2.0.4

Paula,
I hope that you are just confused.
AFAIK, if you have created a database with a locally managed system tablespace, that you cannot set compatible to anything lower than 9.0.1.
Ok, you can set it, but oracle will complain during instance startup and you won't have a database instance to attach to. But this might be a myth of mine, its awhile since I last read the upgrade/migration guide.
I can see setting the init.ora parameter
optimizer_features_enable = 8.1.7
if the 9.2 CBO acts quite differently from its older brother did, back in 8.1.7.
But compatible? I seriously doubt it.
If you migrated your db from 8.1.7 to 9.2 and the system tablespace is still dictionary managed - that is a completely different matter.
I've been lucky enough that most dbs were small enough to just use exp/imp and move data into a clean, newly created db.
Paul
[EMAIL PROTECTED] wrote:
Guys,I saved all of your writing including Todd Boxx, Richard Foote, Wolfgang... about issues with 9.2.0.4. We are currently on 9.2.0.3 and I understand (although have not hit it yet) that in this version we could get locks when building indexes. Also, that basically you need to set your compatible parameter to 8.1.7. On some databases we have compatible set to 9.2.0.0. Question:-any bugs/problems going to 9.2.0.4 and...-should we really change compatible from 9.X to 8.1.7?We are currently migrating a large database to 9.X and I want to know if I should use the latest patchset 9.2.0.4 - for security and performance reasons?Also, we have some dev/test databases where once they go into production performance could be an issue - should we change the compatible param. to 8.1.7 proactivelyThanks,Paula-- 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.comSan Diego, California -- Mailing list and web hosting services-To REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).
Do you Yahoo!?
New Yahoo! Photos - easier uploading and sharing

wintercorp survey

2003-12-11 Thread Jacques Kilchoer

Can this be right? When I look for
Category: Peak Workload
Platform: All
Usage: OLTP

I see 6 SQL server databases and no Oracle databases.

> -Original Message-
> MacGregor, Ian A.
> Subject:
> http://www.wintercorp.com/vldb/2003_TopTen_Survey/TopTenWinners.asp
> 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jacques Kilchoer
  INET: [EMAIL PROTECTED]

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

Re: Re[2]: http://www.wintercorp.com/vldb/2003_TopTen_Survey/TopTenWinners.a sp

> Maybe they should rename the product Petadata.
If they did, then its a good thing that they didn't name it "TeraFile".
 
PdJonathan Gennick <[EMAIL PROTECTED]> wrote:
Thursday, December 11, 2003, 5:14:26 PM, Ryan ([EMAIL PROTECTED]) wrote:R> very nice. what is teradata? I never hear that dbms mentioned.Isn't Teradata what Walmart uses? From what I know, it'salways been aimed at the market for really, really bigdatabases. Hence the prefix "tera", which isn't so biganymore. Maybe they should rename the product Petadata.Best regards,Jonathan Gennick --- Brighten the corner where you arehttp://Gennick.com * 906.387.1698 * mailto:[EMAIL PROTECTED]Join the Oracle-article list and receive onearticle on Oracle technologies per month by email. To join, visit http://four.pairlist.net/mailman/listinfo/oracle-article, or send email to [EMAIL PROTECTED] and include the word "subscribe" in either the subject or body.-- Please see the official ORACLE-!
L FAQ:
 http://www.orafaq.net-- Author: Jonathan GennickINET: [EMAIL PROTECTED]Fat City Network Services -- 858-538-5051 http://www.fatcity.comSan Diego, California -- Mailing list and web hosting services-To REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).
Do you Yahoo!?
New Yahoo! Photos - easier uploading and sharing

better delete statement to remove duplicate rows from exception table?

2003-12-11 Thread Jacques Kilchoer

In the situation below, is there a better way to write the delete statement that 
eliminates duplicates? (assuming duplicate rows form at most 5 % of the table rows) 
Notice that the exceptions table is not analyzed.

If I analyze the exceptions table, is there then another better way to write it?

create table my_exceptions
  (row_id urowid,
   owner varchar2 (30),
   table_name varchar2 (30),
   constraint varchar2 (30)
  );

create table orders
   (order_id   number (8) not null,
order_date date,
constraint orders_uq1 unique (order_id) disable
   ) ;
/* -- load table orders with millions of rows */
create index orders_idx1
 on orders (order_id) ;
analyze table orders estimate statistics sample 10 percent ;
alter table orders
   enable constraint orders_uq1
   exceptions into my_exceptions ;
delete
 from orders a
 where
   a.rowid in
 (select d.delete_row_id
   from
(select
min (b.row_id) over (partition by c.order_id) as keep_row_id,
b.row_id as delete_row_id
  from my_exceptions b, orders c
  where c.rowid = b.row_id
  group by c.order_id, b.row_id
) d
   where
 d.delete_row_id != d.keep_row_id
 ) ;
commit ;
alter table orders
   enable constraint orders_uq1 ;
truncate table my_exceptions ;
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jacques Kilchoer
  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: Who are certified Oracle Masters?

2003-12-11 Thread Stephane Faroult

Ryan wrote:
> 
> you mean niemic didnt actually have to take the test? 

Scary, eh ?

(couldn't resist)

-- 
Regards,

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

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

Re: Re[2]: http://www.wintercorp.com/vldb/2003_TopTen_Survey/TopTenWinners.a sp

Hurry up, zettabyte and yottabyte might still be free ;)

Tanel.

- Original Message - 
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Friday, December 12, 2003 12:44 AM
http://www.wintercorp.com/vldb/2003_TopTen_Survey/TopTenWinners.a sp


> Yeah, clearly, the guys at Exabyte were thinking ahead when they came up
with their name. ;-)
>
> -Original Message-
> Sent: Thursday, December 11, 2003 5:34 PM
> To: Multiple recipients of list ORACLE-L
> http://www.wintercorp.com/vldb/2003_TopTen_Survey/TopTenWinners.a sp
>
>
> Thursday, December 11, 2003, 5:14:26 PM, Ryan ([EMAIL PROTECTED]) wrote:
> R> very nice. what is teradata? I never hear that dbms mentioned.
>
> Isn't Teradata what Walmart uses? From what I know, it's
> always been aimed at the market for really, really big
> databases. Hence the prefix "tera", which isn't so big
> anymore. Maybe they should rename the product Petadata.
>
> Best regards,
>
> Jonathan Gennick --- Brighten the corner where you are
> http://Gennick.com * 906.387.1698 * mailto:[EMAIL PROTECTED]
>
> Join the Oracle-article list and receive one
> article on Oracle technologies per month by
> email. To join, visit
http://four.pairlist.net/mailman/listinfo/oracle-article,
> or send email to [EMAIL PROTECTED] and
> include the word "subscribe" in either the subject or body.
>
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: Jonathan Gennick
>   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: Bobak, Mark
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
>


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

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

RE: Who are certified Oracle Masters?

2003-12-11 Thread Cary Millsap

I owe an apology whether I'm correct or not, because (1) I didn't really
*know* the answer (only what I've heard), and (2) it's really none of my
business anyway. So... even if my speculation were correct, all I've
done here is to propagate a rumor, which is what I'm trying to live my
professional life to teach people NOT to do.

So, to the list, and to Rich, please accept my apology.


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

Upcoming events:
- Performance Diagnosis 101: 12/16 Detroit, 1/27 Atlanta
- SQL Optimization 101: 12/8 Dallas, 2/16 Dallas
- Hotsos Symposium 2004: March 7-10 Dallas
- Visit www.hotsos.com for schedule details...


-Original Message-
Cary Millsap
Sent: Thursday, December 11, 2003 4:19 PM
To: Multiple recipients of list ORACLE-L

The answer to your first question is "Correct."


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

Upcoming events:
- Performance Diagnosis 101: 12/16 Detroit, 1/27 Atlanta
- SQL Optimization 101: 12/8 Dallas, 2/16 Dallas
- Hotsos Symposium 2004: March 7-10 Dallas
- Visit www.hotsos.com for schedule details...


-Original Message-
Ryan
Sent: Thursday, December 11, 2003 3:59 PM
To: Multiple recipients of list ORACLE-L

you mean niemic didnt actually have to take the test? It was just handed
to
him? who is jeremiah wilton?
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Thursday, December 11, 2003 4:09 PM


> IIRC, Tanel did the OCM as well, but I suspect most of the others on
> your list aren't prepared to waste their time attending OCP exams and
> courses just so they can get the OCM.  :)
>
> There were some honorary OCM's announced when the program first
started
> (OOW2002?).  From memory, Rich Niemic and Jeremiah Wilton are the only
> names that spring to mind from that group.
>
> Pete
>
> "Controlling developers is like herding cats."
>
> Kevin Loney, Oracle DBA Handbook
>
> "Oh no, it's not.  It's much harder than that!"
>
> Bruce Pihlamae, long-term Oracle DBA
>
>
> -Original Message-
> Mladen Gogala
> Sent: Friday, December 12, 2003 7:54 AM
> To: Multiple recipients of list ORACLE-L
>
> I know only of Pete Sharman. Who are other Oracle Certified Masters on
> this group? I suspect Tanel to be one, as well as Steve Adams, Cary
> Millsap,
> Mogens Norgaard, Anjo Kolk, Wolfgang Breitling, Gaja V. and Kirti
> Deshpande.
> Am I correct?
>
> 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: Pete Sharman
>   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: Ryan
  INET: [EMAIL PROTECTED]

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

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

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

RE: http://www.wintercorp.com/vldb/2003_TopTen_Survey/TopTenWinners.a sp

2003-12-11 Thread Grant Allen

They hire a DBA to run sp_lock a lot!



Ciao
Fuzzy
:-)

--
The contents of this post are my opinions only
  If swallowed seek medical advice 

> -Original Message-
> From: Ryan [mailto:[EMAIL PROTECTED]
> Sent: Friday, 12 December 2003 09:30
> To: Multiple recipients of list ORACLE-L
> Subject: Re:
> http://www.wintercorp.com/vldb/2003_TopTen_Survey/TopTenWinners.a sp
> 
> 
> also, how do people scale sql server to that many concurrent 
> users if reads
> block writes?
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Grant Allen
  INET: [EMAIL PROTECTED]

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

RE: Re[2]: http://www.wintercorp.com/vldb/2003_TopTen_Survey/TopTenWinners.a sp

2003-12-11 Thread Bobak, Mark

Yeah, clearly, the guys at Exabyte were thinking ahead when they came up with their 
name. ;-)

-Original Message-
Sent: Thursday, December 11, 2003 5:34 PM
To: Multiple recipients of list ORACLE-L
http://www.wintercorp.com/vldb/2003_TopTen_Survey/TopTenWinners.a sp


Thursday, December 11, 2003, 5:14:26 PM, Ryan ([EMAIL PROTECTED]) wrote:
R> very nice. what is teradata? I never hear that dbms mentioned.

Isn't Teradata what Walmart uses? From what I know, it's
always been aimed at the market for really, really big
databases. Hence the prefix "tera", which isn't so big
anymore. Maybe they should rename the product Petadata.

Best regards,

Jonathan Gennick --- Brighten the corner where you are
http://Gennick.com * 906.387.1698 * mailto:[EMAIL PROTECTED]

Join the Oracle-article list and receive one
article on Oracle technologies per month by 
email. To join, visit http://four.pairlist.net/mailman/listinfo/oracle-article, 
or send email to [EMAIL PROTECTED] and 
include the word "subscribe" in either the subject or body.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jonathan Gennick
  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: Bobak, Mark
  INET: [EMAIL PROTECTED]

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

Re: Re[2]: http://www.wintercorp.com/vldb/2003_TopTen_Survey/TopTenWinners.a sp

anyone know how it compares to oracle?
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Thursday, December 11, 2003 5:34 PM
http://www.wintercorp.com/vldb/2003_TopTen_Survey/TopTenWinners.a sp


> Thursday, December 11, 2003, 5:14:26 PM, Ryan ([EMAIL PROTECTED]) wrote:
> R> very nice. what is teradata? I never hear that dbms mentioned.
>
> Isn't Teradata what Walmart uses? From what I know, it's
> always been aimed at the market for really, really big
> databases. Hence the prefix "tera", which isn't so big
> anymore. Maybe they should rename the product Petadata.
>
> Best regards,
>
> Jonathan Gennick --- Brighten the corner where you are
> http://Gennick.com * 906.387.1698 * mailto:[EMAIL PROTECTED]
>
> Join the Oracle-article list and receive one
> article on Oracle technologies per month by
> email. To join, visit
http://four.pairlist.net/mailman/listinfo/oracle-article,
> or send email to [EMAIL PROTECTED] and
> include the word "subscribe" in either the subject or body.
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Jonathan Gennick
>   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: Ryan
  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[2]: http://www.wintercorp.com/vldb/2003_TopTen_Survey/TopTenWinners.a sp

Thursday, December 11, 2003, 5:14:26 PM, Ryan ([EMAIL PROTECTED]) wrote:
R> very nice. what is teradata? I never hear that dbms mentioned.

Isn't Teradata what Walmart uses? From what I know, it's
always been aimed at the market for really, really big
databases. Hence the prefix "tera", which isn't so big
anymore. Maybe they should rename the product Petadata.

Best regards,

Jonathan Gennick --- Brighten the corner where you are
http://Gennick.com * 906.387.1698 * mailto:[EMAIL PROTECTED]

Join the Oracle-article list and receive one
article on Oracle technologies per month by 
email. To join, visit http://four.pairlist.net/mailman/listinfo/oracle-article, 
or send email to [EMAIL PROTECTED] and 
include the word "subscribe" in either the subject or body.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jonathan Gennick
  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: http://www.wintercorp.com/vldb/2003_TopTen_Survey/TopTenWinners.a sp

Teradata is NCRs database engine mostly used for DSS & OLAP.

Tanel.

- Original Message - 
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Friday, December 12, 2003 12:14 AM
http://www.wintercorp.com/vldb/2003_TopTen_Survey/TopTenWinners.a sp


> very nice. what is teradata? I never hear that dbms mentioned.
> - Original Message -
> To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
> Sent: Thursday, December 11, 2003 5:04 PM
> sp
>
>
> > These are their numbers for online databases.  Most of SLAC'S Babar
> Objectivity. database is on tape managed in  a hierarchical file system,
> HPSS.  Last I heard we had about 50 TB online.
> >
> > Ian MacGregor
> > Stanford Linear Accelerator Center
> > [EMAIL PROTECTED]
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > --
> > Author: MacGregor, Ian A.
> >   INET: [EMAIL PROTECTED]
> >
> > Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> > San Diego, California-- Mailing list and web hosting services
> > -
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from).  You may
> > also send the HELP command for other information (like subscribing).
>
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: Ryan
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
>


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

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

Re: http://www.wintercorp.com/vldb/2003_TopTen_Survey/TopTenWinners.a sp

also, how do people scale sql server to that many concurrent users if reads
block writes?

- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Thursday, December 11, 2003 5:14 PM
http://www.wintercorp.com/vldb/2003_TopTen_Survey/TopTenWinners.a sp


> very nice. what is teradata? I never hear that dbms mentioned.
> - Original Message -
> To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
> Sent: Thursday, December 11, 2003 5:04 PM
> sp
>
>
> > These are their numbers for online databases.  Most of SLAC'S Babar
> Objectivity. database is on tape managed in  a hierarchical file system,
> HPSS.  Last I heard we had about 50 TB online.
> >
> > Ian MacGregor
> > Stanford Linear Accelerator Center
> > [EMAIL PROTECTED]
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > --
> > Author: MacGregor, Ian A.
> >   INET: [EMAIL PROTECTED]
> >
> > Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> > San Diego, California-- Mailing list and web hosting services
> > -
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from).  You may
> > also send the HELP command for other information (like subscribing).
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Ryan
>   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: Ryan
  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: Who are certified Oracle Masters?

2003-12-11 Thread Pete Sharman

Well, I could say "Haven't you heard the song?  Jeremiah was a bullfrog,
was a good friend of mine ...", but that would really date me.  :)

Last I heard, Jeremiah was at Amazon.  He occasionally posts answers on
oracle-l, so no doubt he'll correct me if:

a) I have his name wrong
b) I has his employer wrong
c) He actually IS a bullfrog.   :)

Pete

"Controlling developers is like herding cats."

Kevin Loney, Oracle DBA Handbook

"Oh no, it's not.  It's much harder than that!"

Bruce Pihlamae, long-term Oracle DBA


-Original Message-
Ryan
Sent: Friday, December 12, 2003 8:59 AM
To: Multiple recipients of list ORACLE-L

you mean niemic didnt actually have to take the test? It was just handed
to
him? who is jeremiah wilton?
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Thursday, December 11, 2003 4:09 PM


> IIRC, Tanel did the OCM as well, but I suspect most of the others on
> your list aren't prepared to waste their time attending OCP exams and
> courses just so they can get the OCM.  :)
>
> There were some honorary OCM's announced when the program first
started
> (OOW2002?).  From memory, Rich Niemic and Jeremiah Wilton are the only
> names that spring to mind from that group.
>
> Pete
>
> "Controlling developers is like herding cats."
>
> Kevin Loney, Oracle DBA Handbook
>
> "Oh no, it's not.  It's much harder than that!"
>
> Bruce Pihlamae, long-term Oracle DBA
>
>
> -Original Message-
> Mladen Gogala
> Sent: Friday, December 12, 2003 7:54 AM
> To: Multiple recipients of list ORACLE-L
>
> I know only of Pete Sharman. Who are other Oracle Certified Masters on
> this group? I suspect Tanel to be one, as well as Steve Adams, Cary
> Millsap,
> Mogens Norgaard, Anjo Kolk, Wolfgang Breitling, Gaja V. and Kirti
> Deshpande.
> Am I correct?
>
> 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: Pete Sharman
>   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: Ryan
  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: Pete Sharman
  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: Who are certified Oracle Masters?

2003-12-11 Thread Freeman Robert - IL

As I recall Rich talking about it, he did indeed take the exam. It was not
just "handed" to him.

Robert


-Original Message-
To: Multiple recipients of list ORACLE-L
Sent: 12/11/2003 3:59 PM

you mean niemic didnt actually have to take the test? It was just handed
to
him? who is jeremiah wilton?
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Thursday, December 11, 2003 4:09 PM


> IIRC, Tanel did the OCM as well, but I suspect most of the others on
> your list aren't prepared to waste their time attending OCP exams and
> courses just so they can get the OCM.  :)
>
> There were some honorary OCM's announced when the program first
started
> (OOW2002?).  From memory, Rich Niemic and Jeremiah Wilton are the only
> names that spring to mind from that group.
>
> Pete
>
> "Controlling developers is like herding cats."
>
> Kevin Loney, Oracle DBA Handbook
>
> "Oh no, it's not.  It's much harder than that!"
>
> Bruce Pihlamae, long-term Oracle DBA
>
>
> -Original Message-
> Mladen Gogala
> Sent: Friday, December 12, 2003 7:54 AM
> To: Multiple recipients of list ORACLE-L
>
> I know only of Pete Sharman. Who are other Oracle Certified Masters on
> this group? I suspect Tanel to be one, as well as Steve Adams, Cary
> Millsap,
> Mogens Norgaard, Anjo Kolk, Wolfgang Breitling, Gaja V. and Kirti
> Deshpande.
> Am I correct?
>
> 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: Pete Sharman
>   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: Ryan
  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: Who are certified Oracle Masters?

2003-12-11 Thread Pete Sharman

Oh, and I forgot.  No, the honorary OCM's didn't have to take the test.
They were given the OCM in recognition of their contributions to the
Oracle world as a whole.  Actually, some of them I'd never heard of
before either, so that probably explains why I can't recall who they are
now.

Pete

"Controlling developers is like herding cats."

Kevin Loney, Oracle DBA Handbook

"Oh no, it's not.  It's much harder than that!"

Bruce Pihlamae, long-term Oracle DBA


-Original Message-
Ryan
Sent: Friday, December 12, 2003 8:59 AM
To: Multiple recipients of list ORACLE-L

you mean niemic didnt actually have to take the test? It was just handed
to
him? who is jeremiah wilton?
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Thursday, December 11, 2003 4:09 PM


> IIRC, Tanel did the OCM as well, but I suspect most of the others on
> your list aren't prepared to waste their time attending OCP exams and
> courses just so they can get the OCM.  :)
>
> There were some honorary OCM's announced when the program first
started
> (OOW2002?).  From memory, Rich Niemic and Jeremiah Wilton are the only
> names that spring to mind from that group.
>
> Pete
>
> "Controlling developers is like herding cats."
>
> Kevin Loney, Oracle DBA Handbook
>
> "Oh no, it's not.  It's much harder than that!"
>
> Bruce Pihlamae, long-term Oracle DBA
>
>
> -Original Message-
> Mladen Gogala
> Sent: Friday, December 12, 2003 7:54 AM
> To: Multiple recipients of list ORACLE-L
>
> I know only of Pete Sharman. Who are other Oracle Certified Masters on
> this group? I suspect Tanel to be one, as well as Steve Adams, Cary
> Millsap,
> Mogens Norgaard, Anjo Kolk, Wolfgang Breitling, Gaja V. and Kirti
> Deshpande.
> Am I correct?
>
> 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: Pete Sharman
>   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: Ryan
  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: Pete Sharman
  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: Who are certified Oracle Masters?

2003-12-11 Thread Cary Millsap

The answer to your first question is "Correct."


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

Upcoming events:
- Performance Diagnosis 101: 12/16 Detroit, 1/27 Atlanta
- SQL Optimization 101: 12/8 Dallas, 2/16 Dallas
- Hotsos Symposium 2004: March 7-10 Dallas
- Visit www.hotsos.com for schedule details...


-Original Message-
Ryan
Sent: Thursday, December 11, 2003 3:59 PM
To: Multiple recipients of list ORACLE-L

you mean niemic didnt actually have to take the test? It was just handed
to
him? who is jeremiah wilton?
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Thursday, December 11, 2003 4:09 PM


> IIRC, Tanel did the OCM as well, but I suspect most of the others on
> your list aren't prepared to waste their time attending OCP exams and
> courses just so they can get the OCM.  :)
>
> There were some honorary OCM's announced when the program first
started
> (OOW2002?).  From memory, Rich Niemic and Jeremiah Wilton are the only
> names that spring to mind from that group.
>
> Pete
>
> "Controlling developers is like herding cats."
>
> Kevin Loney, Oracle DBA Handbook
>
> "Oh no, it's not.  It's much harder than that!"
>
> Bruce Pihlamae, long-term Oracle DBA
>
>
> -Original Message-
> Mladen Gogala
> Sent: Friday, December 12, 2003 7:54 AM
> To: Multiple recipients of list ORACLE-L
>
> I know only of Pete Sharman. Who are other Oracle Certified Masters on
> this group? I suspect Tanel to be one, as well as Steve Adams, Cary
> Millsap,
> Mogens Norgaard, Anjo Kolk, Wolfgang Breitling, Gaja V. and Kirti
> Deshpande.
> Am I correct?
>
> 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: Pete Sharman
>   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: Ryan
  INET: [EMAIL PROTECTED]

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

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

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

RE: Who are certified Oracle Masters?

2003-12-11 Thread TOMPKINS, MARGARET

Pete,
   Scott Nelson, Paul Dorsey, Peter Koletzke, and David Ensor were also part of the 
original 6-pack I believe, and it was announced in the fall of 2001.  Maggie

Respectfully,
> Maggie Tompkins - CAD SQA
> Corporate Applications Division
> Technology Services Organization - Kansas City
> Defense Finance and Accounting Service
> 816-926-1117 (DSN 465); [EMAIL PROTECTED]
> 


-Original Message-
Sent: Thursday, December 11, 2003 3:09 PM
To: Multiple recipients of list ORACLE-L


IIRC, Tanel did the OCM as well, but I suspect most of the others on
your list aren't prepared to waste their time attending OCP exams and
courses just so they can get the OCM.  :)

There were some honorary OCM's announced when the program first started
(OOW2002?).  From memory, Rich Niemic and Jeremiah Wilton are the only
names that spring to mind from that group.

Pete

"Controlling developers is like herding cats."

Kevin Loney, Oracle DBA Handbook

"Oh no, it's not.  It's much harder than that!"

Bruce Pihlamae, long-term Oracle DBA


-Original Message-
Mladen Gogala
Sent: Friday, December 12, 2003 7:54 AM
To: Multiple recipients of list ORACLE-L

I know only of Pete Sharman. Who are other Oracle Certified Masters on
this group? I suspect Tanel to be one, as well as Steve Adams, Cary
Millsap,
Mogens Norgaard, Anjo Kolk, Wolfgang Breitling, Gaja V. and Kirti
Deshpande. 
Am I correct?

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: Pete Sharman
  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: TOMPKINS, MARGARET
  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: http://www.wintercorp.com/vldb/2003_TopTen_Survey/TopTenWinners.a sp

very nice. what is teradata? I never hear that dbms mentioned.
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Thursday, December 11, 2003 5:04 PM
sp


> These are their numbers for online databases.  Most of SLAC'S Babar
Objectivity. database is on tape managed in  a hierarchical file system,
HPSS.  Last I heard we had about 50 TB online.
>
> Ian MacGregor
> Stanford Linear Accelerator Center
> [EMAIL PROTECTED]
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: MacGregor, Ian A.
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Ryan
  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: Who are certified Oracle Masters?

2003-12-11 Thread Cary Millsap

No, no, no! Definitely not me. I'm 99.999% certain not Mogens or Anjo
either. I don't think Steve either (80% sure). Not sure about the
others.

Thank you for the sentiment, though!


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

Upcoming events:
- Performance Diagnosis 101: 12/16 Detroit, 1/27 Atlanta
- SQL Optimization 101: 12/8 Dallas, 2/16 Dallas
- Hotsos Symposium 2004: March 7-10 Dallas
- Visit www.hotsos.com for schedule details...


-Original Message-
Mladen Gogala
Sent: Thursday, December 11, 2003 2:54 PM
To: Multiple recipients of list ORACLE-L

I know only of Pete Sharman. Who are other Oracle Certified Masters on
this group? I suspect Tanel to be one, as well as Steve Adams, Cary
Millsap,
Mogens Norgaard, Anjo Kolk, Wolfgang Breitling, Gaja V. and Kirti
Deshpande. 
Am I correct?

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

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

http://www.wintercorp.com/vldb/2003_TopTen_Survey/TopTenWinners.a sp

2003-12-11 Thread MacGregor, Ian A.

These are their numbers for online databases.  Most of SLAC'S Babar Objectivity. 
database is on tape managed in  a hierarchical file system, HPSS.  Last I heard we had 
about 50 TB online.  

Ian MacGregor
Stanford Linear Accelerator Center
[EMAIL PROTECTED]
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: MacGregor, Ian A.
  INET: [EMAIL PROTECTED]

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

Re: Who are certified Oracle Masters?

you mean niemic didnt actually have to take the test? It was just handed to
him? who is jeremiah wilton?
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Thursday, December 11, 2003 4:09 PM


> IIRC, Tanel did the OCM as well, but I suspect most of the others on
> your list aren't prepared to waste their time attending OCP exams and
> courses just so they can get the OCM.  :)
>
> There were some honorary OCM's announced when the program first started
> (OOW2002?).  From memory, Rich Niemic and Jeremiah Wilton are the only
> names that spring to mind from that group.
>
> Pete
>
> "Controlling developers is like herding cats."
>
> Kevin Loney, Oracle DBA Handbook
>
> "Oh no, it's not.  It's much harder than that!"
>
> Bruce Pihlamae, long-term Oracle DBA
>
>
> -Original Message-
> Mladen Gogala
> Sent: Friday, December 12, 2003 7:54 AM
> To: Multiple recipients of list ORACLE-L
>
> I know only of Pete Sharman. Who are other Oracle Certified Masters on
> this group? I suspect Tanel to be one, as well as Steve Adams, Cary
> Millsap,
> Mogens Norgaard, Anjo Kolk, Wolfgang Breitling, Gaja V. and Kirti
> Deshpande.
> Am I correct?
>
> 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: Pete Sharman
>   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: Ryan
  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: Log actively being archived by another process

Hi...

check note: 119547.1 on Metalink

HTH
JL

--- [EMAIL PROTECTED] wrote:
> Hi List,
> 
> Just changed my database from No archive Log mode to
> Archive Log mode and I am keep getting the following
> error in Alert Log. What could be wrong?
> 
> 
> Thu Dec 11 16:06:20 2003
> ARC1: Evaluating archive   log 6 thread 1 sequence
> 403
> ARC1: Unable to archive log 6 thread 1 sequence 403
>   Log actively being archived by another process
> ARC1: Evaluating archive   log 4 thread 1 sequence
> 404
> ARC1: Unable to archive log 4 thread 1 sequence 404
>   Log actively being archived by another process
> Thu Dec 11 16:06:25 2003
> ARC0: Evaluating archive   log 6 thread 1 sequence
> 403
> ARC0: Unable to archive log 6 thread 1 sequence 403
>   Log actively being archived by another process
> ARC0: Evaluating archive   log 4 thread 1 sequence
> 404
> ARC0: Unable to archive log 4 thread 1 sequence 404
>   Log actively being archived by another process
> Thu Dec 11 16:06:30 2003
> ARC1: Evaluating archive   log 6 thread 1 sequence
> 403
> ARC1: Unable to archive log 6 thread 1 sequence 403
>   Log actively being archived by another process
> ARC1: Evaluating archive   log 4 thread 1 sequence
> 404
> ARC1: Unable to archive log 4 thread 1 sequence 404
>   Log actively being archived by another process
> 
> 
> -- 
> 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).


__
Do you Yahoo!?
New Yahoo! Photos - easier uploading and sharing.
http://photos.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jose Luis Delgado
  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).

diff between FGRD and ARCH in v$archived_log.creator column

2003-12-11 Thread jaysingh1

Gurus,

What is FGRD and ARCH in v$archived_log.creator column.

I see something like below in my db.
select recid,creator from v$archived_log
RECID CREATOR
- ---
1 FGRD   
2 ARCH   
3 ARCH   
4 ARCH   
5 ARCH   
6 ARCH   
7 ARCH   
8 FGRD   
8 rows selected



-- 
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: Who are certified Oracle Masters?

2003-12-11 Thread Wolfgang Breitling

Thanks for the vote of confidence, but I'm not an OCM.

In order to pass, I am lacking a few vital pieces (in increasing severity)

a) $$
b) time
c) knowledge
My knowledge and interest is rather limited to tuning and the CBO.

I believe Tanel is, according to credentials listed on the slides of his 
10g presentation.

At 01:54 PM 12/11/2003, you wrote:
I know only of Pete Sharman. Who are other Oracle Certified Masters on
this group? I suspect Tanel to be one, as well as Steve Adams, Cary Millsap,
Mogens Norgaard, Anjo Kolk, Wolfgang Breitling, Gaja V. and Kirti Deshpande.
Am I correct?
Mladen Gogala
Oracle DBA
Wolfgang Breitling
Oracle7, 8, 8i, 9i OCP DBA
Centrex Consulting Corporation
http://www.centrexcc.com 

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

Re: RE: Who are certified Oracle Masters?

Yup, I managed to pass it in december 2002 and I'd say it has been quite useful for an 
unknown consultant from nowhere like me.

But I agree with you, other guys mentioned here don't need any certificate to prove 
their mastership. They are way over any current or future certification anyway...

Tanel.

---
Saatja: "Pete Sharman" <[EMAIL PROTECTED]>
Kuupäev: 11.12.2003 23:09:26
---
> IIRC, Tanel did the OCM as well, but I suspect most of the others on
> your list aren't prepared to waste their time attending OCP exams and
> courses just so they can get the OCM.  :)
> 
> There were some honorary OCM's announced when the program first
> started
> (OOW2002?).  From memory, Rich Niemic and Jeremiah Wilton are the only
> names that spring to mind from that group.
> 
> Pete
> 
> "Controlling developers is like herding cats."
> 
> Kevin Loney, Oracle DBA Handbook
> 
> "Oh no, it's not.  It's much harder than that!"
> 
> Bruce Pihlamae, long-term Oracle DBA
> 
> 
> -Original Message-
> Mladen Gogala
> Sent: Friday, December 12, 2003 7:54 AM
> To: Multiple recipients of list ORACLE-L
> 
> I know only of Pete Sharman. Who are other Oracle Certified Masters on
> this group? I suspect Tanel to be one, as well as Steve Adams, Cary
> Millsap,
> Mogens Norgaard, Anjo Kolk, Wolfgang Breitling, Gaja V. and Kirti
> Deshpande.
> Am I correct?
> 
> 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: Pete Sharman
>   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: Who are certified Oracle Masters?

2003-12-11 Thread Pete Sharman

IIRC, Tanel did the OCM as well, but I suspect most of the others on
your list aren't prepared to waste their time attending OCP exams and
courses just so they can get the OCM.  :)

There were some honorary OCM's announced when the program first started
(OOW2002?).  From memory, Rich Niemic and Jeremiah Wilton are the only
names that spring to mind from that group.

Pete

"Controlling developers is like herding cats."

Kevin Loney, Oracle DBA Handbook

"Oh no, it's not.  It's much harder than that!"

Bruce Pihlamae, long-term Oracle DBA


-Original Message-
Mladen Gogala
Sent: Friday, December 12, 2003 7:54 AM
To: Multiple recipients of list ORACLE-L

I know only of Pete Sharman. Who are other Oracle Certified Masters on
this group? I suspect Tanel to be one, as well as Steve Adams, Cary
Millsap,
Mogens Norgaard, Anjo Kolk, Wolfgang Breitling, Gaja V. and Kirti
Deshpande. 
Am I correct?

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: Pete Sharman
  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 actively being archived by another process

2003-12-11 Thread jaysingh1

Hi List,

Just changed my database from No archive Log mode to Archive Log mode and I am keep 
getting the following error in Alert Log. What could be wrong?


Thu Dec 11 16:06:20 2003
ARC1: Evaluating archive   log 6 thread 1 sequence 403
ARC1: Unable to archive log 6 thread 1 sequence 403
  Log actively being archived by another process
ARC1: Evaluating archive   log 4 thread 1 sequence 404
ARC1: Unable to archive log 4 thread 1 sequence 404
  Log actively being archived by another process
Thu Dec 11 16:06:25 2003
ARC0: Evaluating archive   log 6 thread 1 sequence 403
ARC0: Unable to archive log 6 thread 1 sequence 403
  Log actively being archived by another process
ARC0: Evaluating archive   log 4 thread 1 sequence 404
ARC0: Unable to archive log 4 thread 1 sequence 404
  Log actively being archived by another process
Thu Dec 11 16:06:30 2003
ARC1: Evaluating archive   log 6 thread 1 sequence 403
ARC1: Unable to archive log 6 thread 1 sequence 403
  Log actively being archived by another process
ARC1: Evaluating archive   log 4 thread 1 sequence 404
ARC1: Unable to archive log 4 thread 1 sequence 404
  Log actively being archived by another process


-- 
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: Who are certified Oracle Masters?

2003-12-11 Thread Odland, Brad

Woo Hooo!! 

NOT ME!!

I'm a certified oracle bastard!

lol

Brad O.

okay...I'm done...
(back into my cage)


-Original Message-
Sent: Thursday, December 11, 2003 2:54 PM
To: Multiple recipients of list ORACLE-L


I know only of Pete Sharman. Who are other Oracle Certified Masters on
this group? I suspect Tanel to be one, as well as Steve Adams, Cary Millsap,
Mogens Norgaard, Anjo Kolk, Wolfgang Breitling, Gaja V. and Kirti Deshpande.

Am I correct?

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: Odland, Brad
  INET: [EMAIL PROTECTED]

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

Re: RE: Little competition

> PCTFREE and PCTUSED are not part of the storage
> clause.
>  
> SQL> create table t1 (c1 number)
> tablespace lmt1 pctfree 20 pctused 30;
>  
> Table created.
>  
> Lot's
> of potential to go down the wrong path on this one.
> Assumptions!

Maybe it has been already mentioned here, but with ASSM, pctused value is ignored. A 
"full" block becomes free again when its usage drops below next freeness status. There 
are 4 freeness statuses for an ASSM table block, representing in 25% increments how 
full a block (plus two additional statuses for unformatted and logically full blocks).

Tanel.

Who are certified Oracle Masters?

2003-12-11 Thread Mladen Gogala

I know only of Pete Sharman. Who are other Oracle Certified Masters on
this group? I suspect Tanel to be one, as well as Steve Adams, Cary Millsap,
Mogens Norgaard, Anjo Kolk, Wolfgang Breitling, Gaja V. and Kirti Deshpande. 
Am I correct?

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

RE: Performance tuning in complex environment

2003-12-11 Thread DENNIS WILLIAMS

Avnish - Since nobody has mentioned it yet (my posts arrive late, so
probably will by the time this appears), get Cary Millsap's book Optimizing
Oracle Performance

http://search.barnesandnoble.com/textbooks/booksearch/isbnInquiry.asp?userid
=6WIANMIL0H&isbn=059600527X&TXT=Y&itm=1

His methods sound exactly suited to your issues.

Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED] 

-Original Message-
[mailto:[EMAIL PROTECTED]
Sent: Thursday, December 11, 2003 12:35 PM
To: Multiple recipients of list ORACLE-L


Hello Everyone, I am trying to get some help/suggestions reg. how to
troubleshoot performance issues.

Little back ground about our environment. Its third party application
(Logician) from GE. There are total 11 databases, all on oracle 8174 H-UX
11i in cluster environment. All the databases are on EMC Symmetrix using 6
disks. All the clients are connecting to database thru Citrix terminal
servers. 
In last one year we spend lots of time/money in tuning databases, replacing
Citrix servers but end result is same. I was wondering if anybody out there
has ran into same kind of situation. Our (DBAs) guess is the disk layout is
not optimal but we also dont have any data to prove that disks are the
bottleneck. Is there any way to collect these kinds of stats in Oracle. We
aren't getting much help from our SAN administrator.



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

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

Re: Oracle Data Guard

2003-12-11 Thread Yong Huang

Hi, Jonathan,

I think your question is why I mentioned TDU, not just SDU, in my response to
Guang's message. I admit I didn't give much thought and threw that in.
Note:44694.1 says it's set to 32k by default and its adjustable range is 0 to
32k. Then the question is why Oracle chose the magical 32k. Would changing it
to anything else yield any SQL*Net performance gain? It won't be too much extra
work for Guang Mei to find out while he's experimenting with SDU.

It's a little confusing when you say TDU is MTU, because, I think, the term MTU
(Maximum transmission unit) is already used by network engineers to refer to
the maximum number of bytes a data link layer frame can contain (1500 bytes for
Ethernet e.g.). But I understand what you mean.

Regarding a less than maximum SDU size, maybe it's useful if most of the SQL
result is much less than 32k? Somebody can experiment and find out.

Yong Huang

Jonathan Lewis wrote:

Can you clarify a couple of points for me.

The SDU (session data unit) is presumably the
packet size that the Oracle client and server
want to pass back and forth - which is presumably
the maximum size the one synchronous dialogue unit
will be.

The TDU (transport data unit) is presumably the
predicted size of the transport maximum unit of
data transfer (MTU).

a) Why does Oracle need to know anything about
the underlying transport mechanism ?

b) If I set the SDU to the largest legal value (possibly
32K, perhaps 64K) the server task switch will occur
after building and sending that packet - is there any good
reason why I shouldn't do that.  After all, if the transport
simply accepts the 64K packet and gets it to the other
end of the wire (not yet to the client session, just to the
receiving transport layer) as rapidly as possible does it
matter to Oracle whether the transport is using 1.5K or
8K packets.  The fact that the transport layer doesn't
have to work its packet synchronously means that some
overheads have disappeared as far as Oracle is concerned.

Regards

Jonathan Lewis

> Hi, Guang,
>
> Look up SDU and TDU in Oracle documentation Network configuration. You set
them
> in tnsnames.ora and listener.ora, not sqlnet.ora. protocol.ora allows you to
> modify some procotol-specific parameters. In addition, in your client
> application, you can choose a sensible array fetch size, such as arraysize in
> sqlplus (in fact, sqlplus arraysize changes more than just network data chunk
> size). You can't magically increase the network transfer rate by lowering
> network latency. But you can indirectly increase the rate by other means,
such
> as buffering slightly more data in one chunk.
>
> Yong Huang

__
Do you Yahoo!?
New Yahoo! Photos - easier uploading and sharing.
http://photos.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Yong Huang
  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: Performance tuning in complex environment

2003-12-11 Thread Karniotis, Stephen

OK.  Before we go blaming Oracle DB, you need to look at the entire picture.

1. Are other applications within the environment affected by slow
performance?
2. What other apps are running on the network?
3. Have any network-related diagnostics been performed to ensure that
Network bottlenecks are not causing the issue.
4. What is your disk configuration look like?  Mirroring/Striping, etc.
5. How large/small are the transactions?

   

Thank You

Stephen P. Karniotis
Technical Alliance Manager
Compuware Corporation
Direct: (313) 227-4350
Mobile: (248) 408-2918
Email:  [EMAIL PROTECTED] 
Web:www.compuware.com 

 -Original Message-
[EMAIL PROTECTED]
Sent:   Thursday, December 11, 2003 2:29 PM
To: Multiple recipients of list ORACLE-L
Subject:RE: Performance tuning in complex environment

Not really sure what happened and why we decided to that. I was involved in
the beginning of project and remembered that PM was mentioning about talking
to another Logician client who were facing same issues. 

-Original Message-
Jamadagni, Rajendra
Sent: Thursday, December 11, 2003 10:55 AM
To: Multiple recipients of list ORACLE-L


Ummm ... what was the problem that prompted you guys to replace citrix
servers? 

Raj


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


-Original Message-
[mailto:[EMAIL PROTECTED]
Sent: Thursday, December 11, 2003 1:35 PM
To: Multiple recipients of list ORACLE-L


Hello Everyone, I am trying to get some help/suggestions reg. how to
troubleshoot performance issues.

Little back ground about our environment. Its third party application
(Logician) from GE. There are total 11 databases, all on oracle 8174 H-UX
11i in cluster environment. All the databases are on EMC Symmetrix using 6
disks. All the clients are connecting to database thru Citrix terminal
servers. 
In last one year we spend lots of time/money in tuning databases, replacing
Citrix servers but end result is same. I was wondering if anybody out there
has ran into same kind of situation. Our (DBAs) guess is the disk layout is
not optimal but we also dont have any data to prove that disks are the
bottleneck. Is there any way to collect these kinds of stats in Oracle. We
aren't getting much help from our SAN administrator.



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



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

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

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


DISCLAIMER:
This message is intended for the sole use of the individual to whom it is
addressed, and may contain information that is

RE: 10g new features (was: dc_used_extents ,dc_free_extents and d

2003-12-11 Thread GovindanK

Yes .. that is good.

GovindanK 

On Wed, 10 Dec 2003 13:44:34 -0800, "Freeman Robert - IL"
<[EMAIL PROTECTED]> said:
> Excellent slide show Tanel!
> 
> Robert
> 
> -Original Message-
> To: Multiple recipients of list ORACLE-L
> Sent: 12/10/2003 3:34 PM
> dc_histogram_defs)
> 
> > Pete, I'd like to clarify my position first: I don't have any burning
> problem
> > that would compel me to start testing 10g. I want only to learn the
> new
> > features.
> 
> Btw, if you want to learn some of the 10g database engine new features
> (not
> the marketing buzzwords), then check out one of my presentations from:
> 
> http://integrid.info/Poder_10g_New_Features.ppt
> 
> Tanel.
> 
> 
> -- 

-- 
http://www.fastmail.fm - A no graphics, no pop-ups email service
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: GovindanK
  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: Performance tuning in complex environment

2003-12-11 Thread Odland, Brad

Oh I've run into THIS beforeyou are in a sticky technical AND political
situation I am sure.

It is really not that complex.

I'll bet they (your DBAs) have already been told you that the app is
horribly designed and it was a mistake and that the hardware is under
powered canned "dataserver install" was poorly laid out. The vendor says
everything is fine and are basically silent but willing to send in expensive
consultants. You don't trust you DBA's. They are pissed at you and the
vendor. (imagine that)

Now you are stuck with hearing exactly what you didn't want to hear. The
DBA's (If they are Oracle DBA's) have done everything they can and now you
are on a fishing expedition because you don't trust your DBAs...you probably
have been glazing over when ever you hear them talk about issues with this
system...because of that they have washed their hands of it. They can't help
you if you don't all sit down and listen and respect each other.

I'll put got $20 bucks that if I came in and sat down with them for ten
minutes I'd find out they were sharp competent people who have been given
the crap because of this lousy application.

So why don't you send your DBAs in here and let them tell the folks on this
board what they have done thus far and maybe there will be some good come
out if it. Also expect that apps purchased two years ago are going to
royally suck for the most part as the software industry was a giant scam at
that time.

Frankly if you have multiple users on citrix attaching to oracle expect poor
performance. Think about it. A Citrix server with dozens of users using the
same resources to display an entire desktop across the networkHave you
determined if it is app performance or oracle? What this tells me is this is
a client server app licensed to sacrifice cost versus performance. You
bought the Citrix version to save money no doubt. Now you are stuck. Either
way you have fell for the  "sell them the sizzle give them the bacon later"
software bait and switch. 

Do queries typically run faster on a stand alone install of the client than
the Citrix?

Do the queries run by the app run the same or faster when executed through
say sqlplus...

How far flung is this Citrix app do you have remote users? In remote
offices? What kind of bandwidth do you have?

How much data is pumped between the database and the client in a typical
connection?

Sorry if a came off a bit frank, but If I were you I would go back and
listen to your DBA's again. This time more closely because I am sure you
left a lot of other information out. Stop listening to the Citrix and
Logician marketing hype and listen to your people. Software vendors could
care less how well your app runs as long as they get their stinking money.
They are in the business first to SELL SOFTWARE, always remember that.

You have to get everybody working together, accept the situation, set some
new expectations and hold the vendor partially accountable if you are going
to move forward on this problem.

If you indeed can say: "When I push this button it take ten minutes to get
the data" and the same query takes just as long from sqlplus then you
POSSIBLY have a database issue, a program design issue or both.

Good luck.

Brad Odland





-Original Message-
[mailto:[EMAIL PROTECTED]
Sent: Thursday, December 11, 2003 12:35 PM
To: Multiple recipients of list ORACLE-L


Hello Everyone, I am trying to get some help/suggestions reg. how to
troubleshoot performance issues.

Little back ground about our environment. Its third party application
(Logician) from GE. There are total 11 databases, all on oracle 8174 H-UX
11i in cluster environment. All the databases are on EMC Symmetrix using 6
disks. All the clients are connecting to database thru Citrix terminal
servers. 
In last one year we spend lots of time/money in tuning databases, replacing
Citrix servers but end result is same. I was wondering if anybody out there
has ran into same kind of situation. Our (DBAs) guess is the disk layout is
not optimal but we also dont have any data to prove that disks are the
bottleneck. Is there any way to collect these kinds of stats in Oracle. We
aren't getting much help from our SAN administrator.



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

RE: Performance tuning in complex environment

2003-12-11 Thread Jamadagni, Rajendra

Thanks 

I asked because we also use Citrix and so far we never had a problem related to 
Citrix, only problems we had were inefficient coding and oracle bugs, nothing related 
to HW/disk/WTS etc. The only problem initially with Citrix was configuring client 
printers, but our guys figured it out as well.

Raj

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


-Original Message-
[mailto:[EMAIL PROTECTED]
Sent: Thursday, December 11, 2003 2:29 PM
To: Multiple recipients of list ORACLE-L


Not really sure what happened and why we decided to that. I was involved in the 
beginning of project and remembered that PM was mentioning about talking to another 
Logician client who were facing same issues. 


**
This e-mail message is confidential, intended only for the named recipient(s) above 
and may contain information that is privileged, attorney work product or exempt from 
disclosure under applicable law. If you have received this message in error, or are 
not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 
and delete this e-mail message from your computer, Thank you.
**5
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jamadagni, Rajendra
  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: NT -> Win2K causes performance degradation..

Mark,
 
MS w2k3 server supports large memory in the standard product, advanced edition not required. For me, those (client) systems are still in acceptance testing, and I have not yet actually run them with a process memory > 2 GB. I'll let you know after I do, sounds like a good test for a rainy evening. :)
 
If you right-click on the "My Computer" icon on the desktop and select "properties" you will see that the PAE option is enabled as "Physical Adress Extension" right below the memory listing (e.g. 5,766,448 KB RAM).
 
You can also view the settings in the registry in 
HKLM\SYSTEM\CurrentControlSet\Control
SystemStartOptions: REG_SZ : FASTDETECT 3BG PAE
 
hth.
 
Paul
Mark Leith <[EMAIL PROTECTED]> wrote:
Hi all,Thanks for the pointers that you have all supplied. Sage advice that theyshouldn't have changed Oracle whilst changing their OS at the same time.I also did some checking up on the /3GB switch before it was mentioned(having seen it on here in the past) - Windows 2000 does in fact support a4gb address space, though the /3GB switch is only appropriate for Windows2000 Advanced Server and Windows 2000 Datacenter Server - if you use it forMicrosoft Windows 2000 Server - you will lose 1gb of address space! Moreinfo (based on Exchange though) is available here:http://support.microsoft.com/default.aspx?scid=kb%3Ben-us%3B328882If we ever find out what the actual cause was, I'll feed it back to thelist. For now we've suggested they roll back the Oracle changes, reassessperformance, and then increase their memory structur!
es in
 steps - assessingperformance along the way. We've also asked about the /3GB switch, andpagefile sizes - though they think that the rate of their swapping hasn'tincreased since the upgrade.Thanks again!Mark-Original Message-Yechiel AdarSent: 11 December 2003 14:40To: Multiple recipients of list ORACLE-LThe /3GB does not work for the simple reason that in W2K you have 3GB as maxaddress space. At least that what my sysadmin tells me (after checking withMS).Yechiel AdarMehish- Original Message -To: Multiple recipients of list ORACLE-LSent: Wednesday, December 10, 2003 6:49 PMMark,My guess is, that the new OS re-instated the file system caching.By default, 41% (yes, it should have been 42%) of physical memory will beallocated to filesystem caching, as W2K thinks it a fileserver (and domaincontroller, web server, print server, etc) un!
til you
 tell it otherwise.This is much improved in w2k3 server - where you tell it what you want it tobe.A good sysadmin would have set the OS to "optimize throughput for networkapplications" which would have turned off the filesystem caching. Ok, itsonly one radio button to select, so an MSCE could set it also.Surprisingly enough, in W2K Server - changing this setting does not requirea reboot, although I don't know if the changes take effect until after asystem restart. That's not the sort of thing that I usually test, as NT4 hadme trained to reboot afterwards.the other thing may be, that the boot.ini no longer supports the /3GB or/PAE switches as Jared mentioned - but that should not cause the symptomsyou are reporting.hth.PaulMark Leith <[EMAIL PROTECTED]>wrote:Hi All,We've been asked a question from one of our clients that I'm a littlestumped on.They run an OLTP d!
atabase
 (Oracle 8.1.7), and have recently upgraded theirNT machine to Windows 2000, they were running with 2gb of memory, andupgraded that to 4gb in the process. As they increased physical memory, theyalso increased their SGA size & db_block_buffers.Since they've upgraded they have noticed a significant decrease inperformance (the way it was described to me was "it was 7 out of 10, and isnow 3 out of 10"..).Has anybody else done a system upgrade of this nature that has caused lessthan desirable effects? Any pointers as to what to look at? We've requestedsome stats (top wait stats etc.) and I'll feed these back as and when I getthem - but I thought I'd throw this out to you guys in the vague hopethatsomeone has experienced some relatively similar experiences.Cheers!Mark===Mark Leith | T: +44 (0)1905 330 281Sales & Marketing | F: +44 (0)870 127
 5283Cool Tools UK Ltd | E: [EMAIL PROTECTED]===http://www.cool-tools.co.ukMaximising throughput & performance---Outgoing mail is certified Virus Free.Checked by AVG anti-virus system (http://www.grisoft.com).Version: 6.0.547 / Virus Database: 340 - Release Date: 02/12/2003--Please see the official ORACLE-L FAQ: http://www.orafaq.net--Author: Mark LeithINET: [EMAIL PROTECTED]Fat City Network Services -- 858-538-5051 http://www.fatcity.comSan Diego, California -- Mailing list and web hosting services-To REMOVE yourself from this mailing list, send an E-Ma! il messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UN

RE: Performance tuning in complex environment

2003-12-11 Thread Avnish.Rastogi

Not really sure what happened and why we decided to that. I was involved in the 
beginning of project and remembered that PM was mentioning about talking to another 
Logician client who were facing same issues. 

-Original Message-
Jamadagni, Rajendra
Sent: Thursday, December 11, 2003 10:55 AM
To: Multiple recipients of list ORACLE-L


Ummm ... what was the problem that prompted you guys to replace citrix servers? 

Raj

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


-Original Message-
[mailto:[EMAIL PROTECTED]
Sent: Thursday, December 11, 2003 1:35 PM
To: Multiple recipients of list ORACLE-L


Hello Everyone, I am trying to get some help/suggestions reg. how to troubleshoot 
performance issues.

Little back ground about our environment. Its third party application (Logician) from 
GE. There are total 11 databases, all on oracle 8174 H-UX 11i in cluster environment. 
All the databases are on EMC Symmetrix using 6 disks. All the clients are connecting 
to database thru Citrix terminal servers. 
In last one year we spend lots of time/money in tuning databases, replacing Citrix 
servers but end result is same. I was wondering if anybody out there has ran into same 
kind of situation. Our (DBAs) guess is the disk layout is not optimal but we also dont 
have any data to prove that disks are the bottleneck. Is there any way to collect 
these kinds of stats in Oracle. We aren't getting much help from our SAN administrator.



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


**
This e-mail message is confidential, intended only for the named recipient(s) above 
and may contain information that is privileged, attorney work product or exempt from 
disclosure under applicable law. If you have received this message in error, or are 
not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 
and delete this e-mail message from your computer, Thank you.
**5
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jamadagni, Rajendra
  INET: [EMAIL PROTECTED]

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


DISCLAIMER:
This message 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 s

Re: Windows clustering???

2003-12-11 Thread Mladen Gogala

Let me guess your secret: "Windows box" is running X-windows X11R6 and an OS 
ending in "x"? Your version of windows has a bug in BSOD?

On 12/11/2003 01:59:37 PM, "Cunningham, Gerald" wrote:
> Oh yeah? Just this week we had a Windows box that had been up for 29
> days straight!!!
> 
> Yep. You read it right. I'm not giving out our secrets though.
> 
> -Original Message-
> Sent: Wednesday, December 10, 2003 10:55 PM
> To: Multiple recipients of list ORACLE-L
> 
> 
> This is a small, static, but fiercely loyal group of VMS users for HP to
> milk.  OpenVMS is money in the bank for HP, as it was for Compaq and
> DEC. Even the bean-counters understand the insanity of shutting off a
> guaranteed, endless, and highly-profitable revenue stream upon which
> they do not have to expend any marketing or sales resources...
> 
> Officially, they currently promise OpenVMS support through 2012 or
> thereabouts, I believe.
> 
> In Colorado Springs (at the DEC-then-Compaq-then-HP hosting center),
> there is a VMS cluster hosting an Rdb-based application that has been
> continuously available for the past 11-12 years.  Zero downtime for the
> application. Absolutely stunning.
> 
> 
> 
> on 12/10/03 2:14 PM, Tanel Poder at [EMAIL PROTECTED] wrote:
> 
> > Maybe you all already know that, but HP is planning to support OpenVMS
> 
> > on their Itanium servers :)
> > 
> > Tanel.
> > 
> > - Original Message -
> > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
> > Sent: Tuesday, December 09, 2003 10:14 PM
> > 
> > 
> >> I'm guessing they're not running Oracle on this VMS cluster.  I 
> >> really
> > liked
> >> the part about "the most difficult part was explaining to managers 
> >> why it was unnecessary to shut systems down, even during the physical
> > relocation."
> >> 
> >> http://www.theinquirer.net/?article=13002
> >> 
> >> Imagine if DEC had any marketing...
> >> 
> >> Rich
> >> 
> >> Rich Jesse   System/Database Administrator
> >> [EMAIL PROTECTED]  Quad/Tech Inc, Sussex, WI USA
> >> --
> >> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> >> -- 
> >> Author: Jesse, Rich
> >>   INET: [EMAIL PROTECTED]
> >> 
> >> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> >> San Diego, California-- Mailing list and web hosting services
> >> -
> >> To REMOVE yourself from this mailing list, send an E-Mail message
> >> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in 
> >> the message BODY, include a line containing: UNSUB ORACLE-L (or the 
> >> name of mailing list you want to be removed from).  You may also send
> 
> >> the HELP command for other information (like subscribing).
> >> 
> > 
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: Tim Gorman
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the
> message BODY, include a line containing: UNSUB ORACLE-L (or the name of
> mailing list you want to be removed from).  You may also send the HELP
> command for other information (like subscribing).
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: Cunningham, Gerald
>   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).
> 

Mladen Gogala
Oracle DBA



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

Re: Performance tuning in complex environment

DBAs should never 'guess' about performance. If they are guessing you need new DBAs. 

They should be running statspacks, sql trace, and looking at timing data. 

Its too much to explain in an email. Fire your DBAs and find people who dont 'guess'. 
How much are you paying these guys? 
> 
> From: <[EMAIL PROTECTED]>
> Date: 2003/12/11 Thu PM 01:34:52 EST
> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> Subject: Performance tuning in complex environment
> 
> Hello Everyone, I am trying to get some help/suggestions reg. how to troubleshoot 
> performance issues.
> 
> Little back ground about our environment. Its third party application (Logician) 
> from GE. There are total 11 databases, all on oracle 8174 H-UX 11i in cluster 
> environment. All the databases are on EMC Symmetrix using 6 disks. All the clients 
> are connecting to database thru Citrix terminal servers. 
> In last one year we spend lots of time/money in tuning databases, replacing Citrix 
> servers but end result is same. I was wondering if anybody out there has ran into 
> same kind of situation. Our (DBAs) guess is the disk layout is not optimal but we 
> also dont have any data to prove that disks are the bottleneck. Is there any way to 
> collect these kinds of stats in Oracle. We aren't getting much help from our SAN 
> administrator.
> 
> 
> 
> 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).
> 

-- 
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: Windows clustering???

2003-12-11 Thread Cunningham, Gerald

Oh yeah? Just this week we had a Windows box that had been up for 29
days straight!!!

Yep. You read it right. I'm not giving out our secrets though.

-Original Message-
Sent: Wednesday, December 10, 2003 10:55 PM
To: Multiple recipients of list ORACLE-L

This is a small, static, but fiercely loyal group of VMS users for HP to
milk.  OpenVMS is money in the bank for HP, as it was for Compaq and
DEC. Even the bean-counters understand the insanity of shutting off a
guaranteed, endless, and highly-profitable revenue stream upon which
they do not have to expend any marketing or sales resources...

Officially, they currently promise OpenVMS support through 2012 or
thereabouts, I believe.

In Colorado Springs (at the DEC-then-Compaq-then-HP hosting center),
there is a VMS cluster hosting an Rdb-based application that has been
continuously available for the past 11-12 years.  Zero downtime for the
application. Absolutely stunning.

on 12/10/03 2:14 PM, Tanel Poder at [EMAIL PROTECTED] wrote:

> Maybe you all already know that, but HP is planning to support OpenVMS

> on their Itanium servers :)
> 
> Tanel.
> 
> - Original Message -
> To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
> Sent: Tuesday, December 09, 2003 10:14 PM
> 
> 
>> I'm guessing they're not running Oracle on this VMS cluster.  I 
>> really
> liked
>> the part about "the most difficult part was explaining to managers 
>> why it was unnecessary to shut systems down, even during the physical
> relocation."
>> 
>> http://www.theinquirer.net/?article=13002
>> 
>> Imagine if DEC had any marketing...
>> 
>> Rich
>> 
>> Rich Jesse   System/Database Administrator
>> [EMAIL PROTECTED]  Quad/Tech Inc, Sussex, WI USA
>> --
>> Please see the official ORACLE-L FAQ: http://www.orafaq.net
>> -- 
>> Author: Jesse, Rich
>>   INET: [EMAIL PROTECTED]
>> 
>> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
>> San Diego, California-- Mailing list and web hosting services
>> -
>> To REMOVE yourself from this mailing list, send an E-Mail message
>> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in 
>> the message BODY, include a line containing: UNSUB ORACLE-L (or the 
>> name of mailing list you want to be removed from).  You may also send

>> the HELP command for other information (like subscribing).
>> 
> 

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

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

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

Oracle Java stored procedure question

2003-12-11 Thread AdamDonahue

Folks,

Anyone know if it's possible to pass a package record type as a parameter 
to a Java stored procedure?

e.g.,

create or replace package el_zip_pkg
is
type file_rec_type is record (
namevarchar2(255)
,   datablob
);

type file_rec_list_type is table of file_rec_type;

procedure create_zip_file( zip_file_name varchar2(255), files 
file_rec_list_type );
end el_zip_pkg;

create or replace package body el_zip_pkg
is
procedure create_zip_file( zip_file_name varchar2(255), files 
file_rec_list_type )
is
language java
name 'com.maximus.hf.utils.Zipper.createZipFile( java.lang.String, 
oracle.sql.ARRAY )';
end el_zip_pkg;

This fails, complaining that a non-schema record type cannot be passed to 
a Java routine.

So, I'm using object types, but I can't embed these within the package -- 
I preferred to keep this structure packaged within its own namespace, 
rather than relying on additional types within the calling user's schema.

Any workarounds?  Am I missing something obvious?

Adam

-- 
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: Performance tuning in complex environment

2003-12-11 Thread Jamadagni, Rajendra

Ummm ... what was the problem that prompted you guys to replace citrix servers? 

Raj

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


-Original Message-
[mailto:[EMAIL PROTECTED]
Sent: Thursday, December 11, 2003 1:35 PM
To: Multiple recipients of list ORACLE-L


Hello Everyone, I am trying to get some help/suggestions reg. how to troubleshoot 
performance issues.

Little back ground about our environment. Its third party application (Logician) from 
GE. There are total 11 databases, all on oracle 8174 H-UX 11i in cluster environment. 
All the databases are on EMC Symmetrix using 6 disks. All the clients are connecting 
to database thru Citrix terminal servers. 
In last one year we spend lots of time/money in tuning databases, replacing Citrix 
servers but end result is same. I was wondering if anybody out there has ran into same 
kind of situation. Our (DBAs) guess is the disk layout is not optimal but we also dont 
have any data to prove that disks are the bottleneck. Is there any way to collect 
these kinds of stats in Oracle. We aren't getting much help from our SAN administrator.



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


**
This e-mail message is confidential, intended only for the named recipient(s) above 
and may contain information that is privileged, attorney work product or exempt from 
disclosure under applicable law. If you have received this message in error, or are 
not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 
and delete this e-mail message from your computer, Thank you.
**5
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jamadagni, Rajendra
  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).

Performance tuning in complex environment

2003-12-11 Thread Avnish.Rastogi

Hello Everyone, I am trying to get some help/suggestions reg. how to troubleshoot 
performance issues.

Little back ground about our environment. Its third party application (Logician) from 
GE. There are total 11 databases, all on oracle 8174 H-UX 11i in cluster environment. 
All the databases are on EMC Symmetrix using 6 disks. All the clients are connecting 
to database thru Citrix terminal servers. 
In last one year we spend lots of time/money in tuning databases, replacing Citrix 
servers but end result is same. I was wondering if anybody out there has ran into same 
kind of situation. Our (DBAs) guess is the disk layout is not optimal but we also dont 
have any data to prove that disks are the bottleneck. Is there any way to collect 
these kinds of stats in Oracle. We aren't getting much help from our SAN administrator.



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: SQL Area Reloads

2003-12-11 Thread Alexander . Feinstein

Title: RE: SQL Area Reloads

No, "reload" does not include initial load.
"reload" - Any PIN of an object that is not the first PIN performed since the object handle was created, and which requires loading the object from disk.

"First_loads" = pins - pinhits - reloads 

Alex.

-Original Message-
From: Tim Gorman [mailto:[EMAIL PROTECTED]] 
Sent: Thursday, December 11, 2003 8:39 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: SQL Area Reloads

OK, fair enough.

Something to consider:  the concept of "reload" probably
also includes the concept of "initial/first load".  I don't know whether this is the case for certain, but one way to check might be to query the number of items in the V$SQLAREA (i.e. "select count(*) from v$sqlarea").  After all, each of those entries had to be loaded (a.k.a. "reloaded") at least once, I think...

> Shared pool is free all the time.
> There are no DDLs executed, no analyze or no package
> compiles still there are SQL AREA reloads.
> The database is on 9i RAC. The reloads are appearing on
> RAC instances.
> -Original Message-
> Sent: Wednesday, December 10, 2003 11:05 PM
> To: Multiple recipients of list ORACLE-L
> 
> 
> Sure, it's free now.  But has that always been the case?
> 
> 
> on 12/10/03 3:14 PM, Ashish Sahasrabudhe at 
> [EMAIL PROTECTED] wrote:
> 
> 
> 
> The statspack report is showing 10,684 reload for SQL AREA with 2.2% 
> misses.
> 
> ==
> == ==
> Library Cache Activity for DB: MAIN  Instance: MAIN 
> Snaps: 18089 -18090  ->"Pct Misses"  should be very low 
> 
> Get  Pct    Pin    Pct    
>   Invali- 
> Namespace   Requests  Miss Requests Miss  
>   Reloads dations
> ---  -- -- --
> --  
> BODY  12,186    0.0 12,186    0.0 
> 0 0 
> CLUSTER   95    0.0 10    0.0 
> 0 0 
> INDEX    466    0.0    461    0.0 
> 0 0 
> SQL AREA  44,142    0.1    500,987    2.2 
>    10,684 0 
> TABLE/PROCEDURE  208,498    0.1    584,219    0.0 
> 1 0 
> TRIGGER    2,746    0.0  2,746    0.0 
> 0 0 
> ==
> == == 
> 
> The 250 MB of shared pool is free. Why would it cause
> reloads if there is so much
> free space available? 
> 
> Any help is appreciated.
> 
> Ashish
> 
> 
> 
> 
> 
> 
> 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Tim Gorman
  INET: [EMAIL PROTECTED]

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

RE: for security patches - going to 9.2.0.4

2003-12-11 Thread Paula_Stankus

Guys,

I saved all of your writing including Todd Boxx, Richard Foote, Wolfgang... about 
issues with 9.2.0.4.  We are currently on 9.2.0.3 and I understand (although have not 
hit it yet) that in this version we could get locks when building indexes.  Also, that 
basically you need to set your compatible parameter to 8.1.7.  On some databases we 
have compatible set to 9.2.0.0.  

Question:

-any bugs/problems going to 9.2.0.4 and...
-should we really change compatible from 9.X to 8.1.7?

We are currently migrating a large database to 9.X and I want to know if I should use 
the latest patchset 9.2.0.4 - for security and performance reasons?

Also, we have some dev/test databases where once they go into production performance 
could be an issue - should we change the compatible param. to 8.1.7 proactively

Thanks,
Paula
-- 
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: RE: Little competition

2003-12-11 Thread Daniel Hanks

On Thu, 11 Dec 2003 [EMAIL PROTECTED] wrote:

> oracle literature is really lacking in entry level docs anyway. The concepts 
> document is way too large to be digestable by someone new to the topic. 
> 
> What we really need is:
> 
> simple SQL book for newbies
  - O'Reilly's Mastering Oracle SQL?
(It starts out from the basics, and moves at a rapid pace, but it's very
 well done, IMO. 312 pages)

> simple PL/SQL book for newbies
  - O'Reilly's Learning Oracle PL/SQL?
(Not quite as imposing as Oracle PL/SQL Programming, and just a bit over
400 pages.)

> Architecture book
  - O'Reilly's Oracle Essentials: Oracle9i, Oracle8i & Oracle8?
(381 pages)

> automatic features
  - Not sure...might be covered a bit in the previous title.

I guess altogether that's pushing 1000 pages, but between those three books, there's 
probably a lot of good information. (I'm a major O'Reilly fan, if you couldn't 
tell...). Once they've digested these, Milsap & Holt would be next in the list of 
course ;-).

> 
> Beginning Oracle Programming by Kyte, et all took a stab at this but they included 
> WAY too much information and some sections are unreadable(the pl/sql chapters are 
> terrible). 
> 
> Any newbie book should be 400 pages maximum. People get intimidated by large books 
> when they are new. 

For most of these 'simple' databases though, do people really need to get into PL/SQL? 
Or would SQL itself be enough for most of these tasks? If so you could drop the PL/SQL 
book off the list and you're down 400 pages.

-- Dan

   Daniel Hanks - Systems/Database Administrator
   About Inc., Web Services Division

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Daniel Hanks
  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: NT -> Win2K causes performance degradation..

2003-12-11 Thread Mark Leith

Hi all,

Thanks for the pointers that you have all supplied. Sage advice that they
shouldn't have changed Oracle whilst changing their OS at the same time.

I also did some checking up on the /3GB switch before it was mentioned
(having seen it on here in the past) - Windows 2000 does in fact support a
4gb address space, though the /3GB switch is only appropriate for Windows
2000 Advanced Server and Windows 2000 Datacenter Server - if you use it for
Microsoft Windows 2000 Server - you will lose 1gb of address space! More
info (based on Exchange though) is available here:
http://support.microsoft.com/default.aspx?scid=kb%3Ben-us%3B328882

If we ever find out what the actual cause was, I'll feed it back to the
list. For now we've suggested they roll back the Oracle changes, reassess
performance, and then increase their memory structures in steps - assessing
performance along the way. We've also asked about the /3GB switch, and
pagefile sizes - though they think that the rate of their swapping hasn't
increased since the upgrade.

Thanks again!

Mark



-Original Message-
Yechiel Adar
Sent: 11 December 2003 14:40
To: Multiple recipients of list ORACLE-L


The /3GB does not work for the simple reason that in W2K you have 3GB as max
address space. At least that what my sysadmin tells me (after checking with
MS).

Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L
Sent: Wednesday, December 10, 2003 6:49 PM


Mark,

My guess is, that the new OS re-instated the file system caching.
By default, 41% (yes, it should have been 42%) of physical memory will be
allocated to filesystem caching, as W2K thinks it a fileserver (and domain
controller, web server, print server, etc) until you tell it otherwise.

This is much improved in w2k3 server - where you tell it what you want it to
be.

A good sysadmin would have set the OS to "optimize throughput for network
applications" which would have turned off the filesystem caching. Ok, its
only one radio button to select, so an MSCE could set it also.

Surprisingly enough, in W2K Server - changing this setting does not require
a reboot, although I don't know if the changes take effect until after a
system restart. That's not the sort of thing that I usually test, as NT4 had
me trained to reboot afterwards.

the other thing may be, that the boot.ini no longer supports the /3GB or
/PAE switches as Jared mentioned - but that should not cause the symptoms
you are reporting.

hth.

Paul

Mark Leith <[EMAIL PROTECTED]> wrote:
Hi All,

We've been asked a question from one of our clients that I'm a little
stumped on.

They run an OLTP database (Oracle 8.1.7), and have recently upgraded their
NT machine to Windows 2000, they were running with 2gb of memory, and
upgraded that to 4gb in the process. As they increased physical memory, they
also increased their SGA size & db_block_buffers.

Since they've upgraded they have noticed a significant decrease in
performance (the way it was described to me was "it was 7 out of 10, and is
now 3 out of 10"..).

Has anybody else done a system upgrade of this nature that has caused less
than desirable effects? Any pointers as to what to look at? We've requested
some stats (top wait stats etc.) and I'll feed these back as and when I get
them - but I thought I'd throw this out to you guys in the vague hope
thatsomeone has experienced some relatively similar experiences.

Cheers!

Mark

===
Mark Leith | T: +44 (0)1905 330 281
Sales & Marketing | F: +44 (0)870 127 5283
Cool Tools UK Ltd | E: [EMAIL PROTECTED]
===
http://www.cool-tools.co.uk
Maximising throughput & performance
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.547 / Virus Database: 340 - Release Date: 02/12/2003

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

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


Do you Yahoo!?
New Yahoo! Photos - easier uploading and sharing
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.547 / Virus Database: 340 - Release Date: 02/12/2003

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

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing lis

char is going away? - Thanks

2003-12-11 Thread Gene Gurevich

Just to thank all who replied ( sure did not expect
that much replied): Taner, Tim, Kevin, Murali,
Jonnathan,  Jesse, Michael, DEnnis, Jamadagni, Mladen,
Pete, Thomas, Kenneth. Sorry if I forgot anyone. 

Gene


__
Do you Yahoo!?
Free Pop-Up Blocker - Get it now
http://companion.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Gene Gurevich
  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: 3rd Party Oracle Licenses

you need to contact oracle sales to make certain. The obligation is on your company 
double check. 

i doubt what they are saying is true. please post what you find out. 
> 
> From: "Jay Hostetter" <[EMAIL PROTECTED]>
> Date: 2003/12/11 Thu AM 09:14:26 EST
> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> Subject: 3rd Party Oracle Licenses
> 
> We are purchasing a software package from a vendor.  The vendor states that the 
> package includes sufficient Oracle licenses.  Since I'm supposed to keep on top of 
> our licensing costs, I'm trying to make sure that there are no surprises down the 
> road - such as additional Oracle support fees or Oracle claiming that we don't have 
> this new box licensed, etc.  How can the vendor prove that they are providing a 
> license?  When I asked them for some type of proof, they forward the OLSA to me, 
> which is basically generic - it doesn't tell me if the license is SE, EE, SE One, 
> perpertual, term, CPU, Named User, etc.  Any thoughts or do I just take their word 
> for it?
> 
> Thanks,
> Jay
> 
> 
> 
> **DISCLAIMER
> This e-mail message and any files transmitted with it are intended for the use of 
> the individual or entity to which they are addressed and may contain information 
> that is privileged, proprietary and confidential. If you are not the intended 
> recipient, you may not use, copy or disclose to anyone the message or any 
> information contained in the message. If you have received this communication in 
> error, please notify the sender and delete this e-mail message. The contents do not 
> represent the opinion of D&E except to the extent that it relates to their official 
> business.
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: Jay Hostetter
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> 

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

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

Re: NT -> Win2K causes performance degradation..

The /3GB does not work for the simple reason that in W2K
you have 3GB as max address space. At least that what my sysadmin tells me
(after checking with MS).
Yechiel AdarMehish

- Original Message -
From:
Paul
Drake
To: Multiple recipients of list ORACLE-L

Sent: Wednesday, December 10, 2003 6:49
PM
Subject: Re: NT -> Win2K causes
performance degradation..

Mark,
My guess is, that the new OS re-instated the file system caching.
By default, 41% (yes, it should have been 42%) of physical memory will be
allocated to filesystem caching, as W2K thinks it a fileserver (and
domain controller, web server, print server, etc) until you tell it
otherwise.
This is much improved in w2k3 server - where you tell it what you want it
to be.
A good sysadmin would have set the OS to "optimize throughput for network
applications" which would have turned off the filesystem caching. Ok, its only
one radio button to select, so an MSCE could set it also.
Surprisingly enough, in W2K Server - changing this setting does not
require a reboot, although I don't know if the changes take effect until after
a system restart. That's not the sort of thing that I usually test, as NT4 had
me trained to reboot afterwards.
the other thing may be, that the boot.ini no longer supports the /3GB or
/PAE switches as Jared mentioned - but that should not cause the symptoms
you are reporting.
hth.
PaulMark Leith <[EMAIL PROTECTED]>
wrote:
Hi
All,We've been asked a question from one of our clients that I'm a
littlestumped on.They run an OLTP database (Oracle 8.1.7), and
have recently upgraded theirNT machine to Windows 2000, they were
running with 2gb of memory, andupgraded that to 4gb in the process. As
they increased physical memory, theyalso increased their SGA size &
db_block_buffers.Since they've upgraded they have noticed a
significant decrease inperformance (the way it was described to me was
"it was 7 out of 10, and isnow 3 out of 10"..).Has anybody else
done a system upgrade of this nature that has caused lessthan desirable
effects? Any pointers as to what to look at? We've requestedsome stats
(top wait stats etc.) and I'll feed these back as and when I getthem -
but I thought I'd throw this out to you guys in the vague hope thatsomeone has experienced some relatively similar
experiences.Cheers!Mark===Mark
Leith | T: +44 (0)1905 330 281Sales & Marketing | F: +44 (0)870 127
5283Cool Tools UK Ltd | E:
[EMAIL PROTECTED]===http://www.cool-tools.co.ukMaximising
throughput & performance---Outgoing mail is certified Virus
Free.Checked by AVG anti-virus system
(http://www.grisoft.com).Version: 6.0.547 / Virus Database: 340 -
Release Date: 02/12/2003-- Please see the official ORACLE-L FAQ:
http://www.orafaq.net-- Author: Mark LeithINET:
[EMAIL PROTECTED]Fat City Network Services -- 858-538-5051
http://www.fatcity.comSan Diego, California -- Mailing list and web
hosting
services-To
REMOVE yourself from this mailing list, send an E-Ma! il messageto:
[EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe
message BODY, include a line containing: UNSUB ORACLE-L(or the name of
mailing list you want to be removed from). You mayalso send the HELP
command for other information (like subscribing).

Do you Yahoo!?New
Yahoo! Photos - easier uploading and sharing

Re: Dblink fails between 8.1.7 (Unix) and 9i (Zos 390) due to inv

My bad. IGNORE PREVIOUS.

It should be the same as: select * from global_name.

Yechiel Adar
Mehish
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Thursday, December 11, 2003 5:34 PM


> Yes. The name must be equal to select name from v$database.
>
> Yechiel Adar
> Mehish
> - Original Message -
> To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
> Sent: Thursday, December 11, 2003 4:54 PM
>
>
> > Clive,
> >
> > If the GLOBAL_NAMES parameter is set to true, then you must create the
> > database link with the same name as the database to which it connects..
Is
> > that the case?
> >
> > Mark
> >
> >
> >
> > -Original Message-
> > Hybart, Clive
> > Sent: 11 December 2003 12:24
> > To: Multiple recipients of list ORACLE-L
> > inv
> >
> >
> > On UNIX 8.1.7 global_names = true
> >
> > On Zos 390 9i global_names = false
> >
> >
> > Is this causing a mismatch perhaps ?
> >
> > Regards
> >
> > Clive
> >
> > -Original Message-
> > Sent: 10 December 2003 12:10
> > To: Multiple recipients of list ORACLE-L
> > inv
> >
> >
> > Clive,
> > during the upgrade has the global_names parameter somehow been changed
> > from false to true? This would cause the connection to be refused if the
> > link name does not match the global_name for the target database.
> >
> > Cheers,
> > Mike Hately
> >
> > -Original Message-
> > On Behalf Of Hybart, Clive
> > Sent: 10 December 2003 10:39
> > To: Multiple recipients of list ORACLE-L
> >
> >
> >
> > Since upgrading our mainframe database to 9.2.0.1.0.25 a dblink between
> > a Unix box (8.1.7.0) and the mainframe fails.
> > However sqlplus using the same connection syntax "Connect
> > username/[EMAIL PROTECTED]" is fine.
> > Any ideas, peeps ?
> >
> >
> >
> > 
> > 
> > E mail Disclaimer
> >
> > You agree that you have read and understood this disclaimer and you
> > agree to be bound by its terms.
> >
> > The information contained in this e-mail and any files transmitted with
> > it (if any) are confidential and intended for the addressee only.  If
> > you have received this  e-mail in error please notify the originator.
> >
> >
> > This e-mail and any attachments have been scanned for certain viruses
> > prior to sending but CE Electric UK Funding Company nor any of its
> > associated companies from whom this e-mail originates shall be liable
> > for any losses as a result of any viruses being passed on.
> >
> > No warranty of any kind is given in respect of any information contained
> > in this   e-mail and you should be aware that that it might be
> > incomplete, out of date or incorrect. It is therefore essential that you
> > verify all such information with us before placing any reliance upon it.
> >
> > CE Electric UK Funding Company
> > Lloyds Court
> > 78 Grey Street
> > Newcastle upon Tyne
> > NE1 6AF
> > Registered in England and Wales: Number 3476201
> >
> > 
> > 
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > --
> > Author: Hately, Mike (LogicaCMG)
> >   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: Hybart, Clive
> >   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).
> > ---
> > Incoming mail is certified Virus Free.
> > Checked by AVG anti-virus system (http://www.grisoft.com).
> > Version: 6.0.547 / Virus Database: 340 - Release Date: 02/12/2003
> >
> > ---
> > Outgoing mail is certified Virus Free.
> > Checked by AVG anti-virus system (http://www.grisoft.com).
> > Version: 6.0.547 / Virus Database: 340 - Release Date: 02/12/2003
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.net
>

RE: Strange behavior with dbms_stats...

Oooppp...

Sorry... I sent the testing proc... this is the
original...

procedure get_statistics as
 cursor get_users_list is
  select username
  from dba_users
  where username != 'SYS' and username != 'SYSTEM';

begin
 for i in get_users_list
 loop
  dbms_stats.gather_schema_stats(ownname=>
chr(39)||i.username||chr(39), cascade=> TRUE);
 end loop;
end;


--- "Jamadagni, Rajendra"
<[EMAIL PROTECTED]> wrote:
> after running the block, do you actually spool the
> output and run that??
> 
> Raj
>

> Rajendra dot Jamadagni at nospamespn dot com
> All Views expressed in this email are strictly
> personal.
> QOTD: Any clod can have facts, having an opinion is
> an art !
> 
> 
> -Original Message-
> Sent: Thursday, December 11, 2003 11:09 AM
> To: Multiple recipients of list ORACLE-L
> 
> 
> List...
> 
> SunOS 5.8, Oracle 8.1.6 (and 8.1.7 too).
> 
> I use the proc at the bottom to generate statistics.
> 
> It seems to work, but if I check statistics with:
> 
> select owner, table_name, num_rows, blocks,
> av_row_len,
> to_char(last_analyzed, 'MM/DD/ HH24:MI:SS')
> from dba_tables;
> 
> the tables have the OLD last_analyzed time!
> 
> but... If I execute ONE by ONE:
> 
> exec dbms_stats.gather_schema_stats(ownname =>
> 'PERFSTAT', cascade => TRUE);
> 
> it works fine!!...
> 
> So, am I doing something wrong?
> 
> Any help?
> 
> TIA
> JL
> 
> create or replace procedure get_statistics as
>cursor get_users_list is
>   select username
>   from dba_users
>   where username != 'SYS' 
> and username != 'SYSTEM';
> 
> begin
>for i in get_users_list
>loop
>   dbms_output.put_line('exec
> dbms_stats.gather_schema_stats(ownname =>
> '||chr(39)||i.username||chr(39)||', cascade =>
> TRUE);');
>end loop;
> end;
> /
> 
> 
> 
> __
> Do you Yahoo!?
> New Yahoo! Photos - easier uploading and sharing.
> http://photos.yahoo.com/
> -- 
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.net
> -- 
> Author: Jose Luis Delgado
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051
> http://www.fatcity.com
> San Diego, California-- Mailing list and web
> hosting services
>
-
> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of
> 'ListGuru') and in
> the message BODY, include a line containing: UNSUB
> ORACLE-L
> (or the name of mailing list you want to be removed
> from).  You may
> also send the HELP command for other information
> (like subscribing).
> 
>
**
> This e-mail message is confidential, intended only
> for the named recipient(s) above and may contain
> information that is privileged, attorney work
> product or exempt from disclosure under applicable
> law. If you have received this message in error, or
> are not the named recipient(s), please immediately
> notify corporate MIS at (860) 766-2000 and delete
> this e-mail message from your computer, Thank you.
>
**4
> -- 
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.net
> -- 
> Author: Jamadagni, Rajendra
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051
> http://www.fatcity.com
> San Diego, California-- Mailing list and web
> hosting services
>
-
> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of
> 'ListGuru') and in
> the message BODY, include a line containing: UNSUB
> ORACLE-L
> (or the name of mailing list you want to be removed
> from).  You may
> also send the HELP command for other information
> (like subscribing).


__
Do you Yahoo!?
New Yahoo! Photos - easier uploading and sharing.
http://photos.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jose Luis Delgado
  INET: [EMAIL PROTECTED]

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

Re: RE: Little competition

oracle literature is really lacking in entry level docs anyway. The concepts document 
is way too large to be digestable by someone new to the topic. 

What we really need is:

simple SQL book for newbies
simple PL/SQL book for newbies
Architecture book
automatic features

Beginning Oracle Programming by Kyte, et all took a stab at this but they included WAY 
too much information and some sections are unreadable(the pl/sql chapters are 
terrible). 

Any newbie book should be 400 pages maximum. People get intimidated by large books 
when they are new. 
> 
> From: "Hately, Mike (LogicaCMG)" <[EMAIL PROTECTED]>
> Date: 2003/12/11 Thu AM 08:44:32 EST
> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> Subject: RE: Little competition
> 
> Good points Jonathan,
> 
> The 'box' as far as I'm concerned was accomodated by v7.3.4. That had 95% of
> the features anyone could want for most environments. After that we've had a
> succession of 'nice to have' features.
> Don't get me wrong, some environments absolutely demand these new features
> and there's a living to be made in understanding all of the new bells and
> whistles but I agree that most people don't use more than a tiny subset of
> the available toys.
> 
> Mike Hately
> 
> PS Yes, I'm aware that there will follow a list of post-7.3.4 features that
> people consider absolutely vital.  =)
> 
> -Original Message-
> Sent: 11 December 2003 13:25
> To: Multiple recipients of list ORACLE-L
> 
> Maybe I'm wrong here, but I don't
> believe Oracle has put together the simplified DBA manual
> yet, and perhaps maybe they should. What do you think?
> Should Oracle define the box and write a manual for
> customers who want to live within that box?
> 
> Best regards,
> 
> Jonathan Gennick --- Brighten the corner where you are
> http://Gennick.com * 906.387.1698 * mailto:[EMAIL PROTECTED]
> 
> 
> 
> 
> E mail Disclaimer
> 
> You agree that you have read and understood this disclaimer and you agree to be 
> bound by its terms.
> 
> The information contained in this e-mail and any files transmitted with it (if any) 
> are confidential and intended for the addressee only.  If you have received this  
> e-mail in error please notify the originator.
> 
> This e-mail and any attachments have been scanned for certain viruses prior to 
> sending but CE Electric UK Funding Company nor any of its associated companies from 
> whom this e-mail originates shall be liable for any losses as a result of any 
> viruses being passed on.
> 
> No warranty of any kind is given in respect of any information contained in this   
> e-mail and you should be aware that that it might be incomplete, out of date or 
> incorrect. It is therefore essential that you verify all such information with us 
> before placing any reliance upon it.
> 
> CE Electric UK Funding Company
> Lloyds Court
> 78 Grey Street
> Newcastle upon Tyne
> NE1 6AF
> Registered in England and Wales: Number 3476201
> 
> 
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: Hately, Mike (LogicaCMG)
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> 

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

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

Re: Little competition

2003-12-11 Thread Jared . Still


create table
test_table
(c1 number)
tablespace users
pctfree 20 pctused 30
/

Works for me.   ;)

( USERS is ASSM)







"Richard Foote" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
 12/11/2003 03:39 AM
 Please respond to ORACLE-L

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


Little competition for you all :)
 
It's a two part question:

    What's wrong with the following piece of expert analysis ?
    Which well know "Oracle Guru" published this (and continues to display it on his web-page) ?
 
 
"Sadly, Oracle9i doesn't allow you to specify the value for PCTFREE if you're using automatic space management. This is a serious limitation because Oracle9i can't know in advance about the amount of VARCHAR expansion in a table row, leading to excessive row chaining and poor access performance."
 
SQL> create table
  2   test_table
  3   (c1 number)
  4  tablespace
  5   asm_test
  6  storage
  7   ( pctfree 20 pctused 30 )
  8  ;
 
   ( pctfree 20 pctused 30 )
     *
ERROR at line 7:
ORA-02143: invalid STORAGE option

However, here's an important point. While Oracle9i rejects the PCTFREE and PCTUSED parameters with locally managed tablespaces with automatic space management, it does allow you to enter invalid settings for NEXT and FREELISTS settings"
 
 
 
You've gotta love it !!
 
Sorry no clues 
 
Cheers ;)
 
Richard

Re: Re: Strange behavior with dbms_stats...

put it into a a dbms_output to see what is passed as variables

then wrap it in execute immediate. your doing dynamic pl/sql. i think that will work. 
> 
> From: anu <[EMAIL PROTECTED]>
> Date: 2003/12/11 Thu AM 11:54:35 EST
> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> Subject: Re: Strange behavior with dbms_stats...
> 
> The proc generates the 'exec dbms_stats ' statements for all the users. Are you 
> saving the output and running it manually or not. IT would have the same statements 
> that you run one by one. 
> 
> Jose Luis Delgado <[EMAIL PROTECTED]> wrote:List...
> 
> SunOS 5.8, Oracle 8.1.6 (and 8.1.7 too).
> 
> I use the proc at the bottom to generate statistics.
> 
> It seems to work, but if I check statistics with:
> 
> select owner, table_name, num_rows, blocks,
> av_row_len,
> to_char(last_analyzed, 'MM/DD/ HH24:MI:SS')
> from dba_tables;
> 
> the tables have the OLD last_analyzed time!
> 
> but... If I execute ONE by ONE:
> 
> exec dbms_stats.gather_schema_stats(ownname =>
> 'PERFSTAT', cascade => TRUE);
> 
> it works fine!!...
> 
> So, am I doing something wrong?
> 
> Any help?
> 
> TIA
> JL
> 
> create or replace procedure get_statistics as
> cursor get_users_list is
> select username
> from dba_users
> where username != 'SYS' 
> and username != 'SYSTEM';
> 
> begin
> for i in get_users_list
> loop
> dbms_output.put_line('exec
> dbms_stats.gather_schema_stats(ownname =>
> '||chr(39)||i.username||chr(39)||', cascade =>
> TRUE);');
> end loop;
> end;
> /
> 
> 
> 
> __
> Do you Yahoo!?
> New Yahoo! Photos - easier uploading and sharing.
> http://photos.yahoo.com/
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: Jose Luis Delgado
> INET: [EMAIL PROTECTED]
> 
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
> 
> 
> -
> Do you Yahoo!?
> Free Pop-Up Blocker - Get it now
> 
The proc generates the 'exec dbms_stats ' statements for all the users. Are you saving the output and running it manually or not. IT would have the same statements that you run one by one. Jose Luis Delgado <[EMAIL PROTECTED]> wrote:
List...SunOS 5.8, Oracle 8.1.6 (and 8.1.7 too).I use the proc at the bottom to generate statistics.It seems to work, but if I check statistics with:select owner, table_name, num_rows, blocks,av_row_len,to_char(last_analyzed, 'MM/DD/ HH24:MI:SS')from dba_tables;the tables have the OLD last_analyzed time!but... If I execute ONE by ONE:exec dbms_stats.gather_schema_stats(ownname =>'PERFSTAT', cascade => TRUE);it works fine!!...So, am I doing something wrong?Any help?TIAJLcreate or replace procedure get_statistics ascursor get_users_list isselect usernamefrom dba_userswhere username != 'SYS' and username != 'SYSTEM';beginfor i in get_users_listloopdbms_output.put_line('execdbms_stats.gather_schema_stats(ownname
 =>'||chr(39)||i.username||chr(39)||', cascade =>TRUE);');end loop;end;/__Do you Yahoo!?New Yahoo! Photos - easier uploading and sharing.http://photos.yahoo.com/-- Please see the official ORACLE-L FAQ: http://www.orafaq.net-- Author: Jose Luis DelgadoINET: [EMAIL PROTECTED]Fat City Network Services -- 858-538-5051 http://www.fatcity.comSan Diego, California -- Mailing list and web hosting services-To REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).
Do you Yahoo!?
Free Pop-Up Blocker - Get it now

RE: 3rd Party Oracle Licenses

2003-12-11 Thread Goulet, Dick

Rule of thumb, NEVER trust the third party vendor to have it right.  Call YOUR Oracle 
sales rep & get his/her advice.  We've had an application sold to us "with Oracle 
licenses" when the third party vendor was not licensed by Oracle to do so.  Mind you 
as long as the contract between you and the third party vendor states that they are 
selling you a database license Oracle is nice about things. But still it can get 
sticky!!!

Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA

-Original Message-
Sent: Thursday, December 11, 2003 11:29 AM
To: Multiple recipients of list ORACLE-L


Our apps that use Oracle come with an "Application license".  By the terms
of this license, we get to use that Oracle DB for that app and that app
alone.  The DB support comes from the app vendor and not Oracle.  Not
feeling particularly comfortable with this arrangement, we purchased
separate Oracle licenses in order to get "Silver support" directly from
Oracle, as I've yet to meet a vendor who had a grip on the DBs they sell
with their product.

Then again, these were "network concurrent user" licenses, which
unfortunately no longer exist.  Perhaps a low-end 5-user named license would
work for you.

HTH!  GL!  :)

Rich

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


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


We are purchasing a software package from a vendor.  The vendor states that
the package includes sufficient Oracle licenses.  Since I'm supposed to keep
on top of our licensing costs, I'm trying to make sure that there are no
surprises down the road - such as additional Oracle support fees or Oracle
claiming that we don't have this new box licensed, etc.  How can the vendor
prove that they are providing a license?  When I asked them for some type of
proof, they forward the OLSA to me, which is basically generic - it doesn't
tell me if the license is SE, EE, SE One, perpertual, term, CPU, Named User,
etc.  Any thoughts or do I just take their word for it?

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

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

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

Re: Strange behavior with dbms_stats...

2003-12-11 Thread anu

The proc generates the 'exec dbms_stats ' statements for all the users. Are you saving the output and running it manually or not. IT would have the same statements that you run one by one. Jose Luis Delgado <[EMAIL PROTECTED]> wrote:
List...SunOS 5.8, Oracle 8.1.6 (and 8.1.7 too).I use the proc at the bottom to generate statistics.It seems to work, but if I check statistics with:select owner, table_name, num_rows, blocks,av_row_len,to_char(last_analyzed, 'MM/DD/ HH24:MI:SS')from dba_tables;the tables have the OLD last_analyzed time!but... If I execute ONE by ONE:exec dbms_stats.gather_schema_stats(ownname =>'PERFSTAT', cascade => TRUE);it works fine!!...So, am I doing something wrong?Any help?TIAJLcreate or replace procedure get_statistics ascursor get_users_list isselect usernamefrom dba_userswhere username != 'SYS' and username != 'SYSTEM';beginfor i in get_users_listloopdbms_output.put_line('execdbms_stats.gather_schema_stats(ownname
 =>'||chr(39)||i.username||chr(39)||', cascade =>TRUE);');end loop;end;/__Do you Yahoo!?New Yahoo! Photos - easier uploading and sharing.http://photos.yahoo.com/-- Please see the official ORACLE-L FAQ: http://www.orafaq.net-- Author: Jose Luis DelgadoINET: [EMAIL PROTECTED]Fat City Network Services -- 858-538-5051 http://www.fatcity.comSan Diego, California -- Mailing list and web hosting services-To REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).
Do you Yahoo!?
Free Pop-Up Blocker - Get it now

RE: 3rd Party Oracle Licenses

2003-12-11 Thread Mercadante, Thomas F

Jay,

I would call your local Oracle Sales office and run it by them.

As my old boss used to say - "ALWAYS cut the cards".

Tom Mercadante
Oracle Certified Professional


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


We are purchasing a software package from a vendor.  The vendor states that
the package includes sufficient Oracle licenses.  Since I'm supposed to keep
on top of our licensing costs, I'm trying to make sure that there are no
surprises down the road - such as additional Oracle support fees or Oracle
claiming that we don't have this new box licensed, etc.  How can the vendor
prove that they are providing a license?  When I asked them for some type of
proof, they forward the OLSA to me, which is basically generic - it doesn't
tell me if the license is SE, EE, SE One, perpertual, term, CPU, Named User,
etc.  Any thoughts or do I just take their word for it?

Thanks,
Jay



**DISCLAIMER
This e-mail message and any files transmitted with it are intended for the
use of the individual or entity to which they are addressed and may contain
information that is privileged, proprietary and confidential. If you are not
the intended recipient, you may not use, copy or disclose to anyone the
message or any information contained in the message. If you have received
this communication in error, please notify the sender and delete this e-mail
message. The contents do not represent the opinion of D&E except to the
extent that it relates to their official business.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jay Hostetter
  INET: [EMAIL PROTECTED]

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

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

Re[2]: Little competition

Thursday, December 11, 2003, 8:44:25 AM, Mercadante, Thomas F ([EMAIL PROTECTED]) 
wrote:
MTF> And I think a condensed documentation set is a great
MTF> idea. I wonder if there is a market for it?

If I just wrote the book? No, I doubt it would sell in
high-enough numbers. The Oracle book market is much too soft
now to take a risk on a niche title.

But if I could convince Oracle to buy into the book, well,
then it'd be a different story. Oracle has done a lot to
make their database simpler to manage (under the right
circumstances), but I haven't seen where they've pulled
everything together into a simplified management paradigm
(sorry for that buzzword) that they can present to
customers. Just what is "the simple way" to manage Oracle? I
don't think that's been well-defined, and I think it could
be well-defined.

First, you'd need to somehow define what a "simpfilied
Oracle environment" looks like. I don't know how to do this
yet. For the sake of argument, let's peg it as:

Less than 100GB of data, 100 users or less, TCP/IP only,
some downtime each day is acceptable, no need for fancy
recoveries such as tablespace-point-in-time.

I don't think the above is quite enough of a definition, but
run with it for a bit. Given the above, think about the
tasks a DBA needs to perform:

Backup/recovery - Lot's of options here, but who cares? Can
we define a simple regime that works? Run in archive log
mode, use RMAN to do a full backup once/week, run
incremental backups each night, documented and simple
instructions to recover from: loss of control file, loss of
log file, loss of datafile. No fancy scenarios. Just assume
that everything is always to be recovered to the point of
failure.

Startup/shutdown - ?

Creating a tablespace - Use automatic space management,
automatic extent sizing, automatic datafile extension. Just
issue CREATE TABLESPACE XXX, and let Oracle figure
everything else out.

Creating a table - Show how to create a table and define
constraints, how to create simple indexes, ignore storage
options (let them be automatic), ignore partitioning, ignore
the object features, ignore index storage parameters, ignore
PCTFREE/PCTUSED, etc.

Creating a database - Use dbca, check all the options for
automatic space management, automatic everything else,
probably need to decide on a pool of disks for Oracle to use
for datafiles.

Moving a table to another database - Define one way that
will work good-enough given the size parameters.

Moving a schema to another database - ditto. define one way
that works.

I'm not sure what else. The idea would be to produce a very
task-oriented manual that covered the subset of tasks
necessary to operate in the simplified environment. It'd be
something to give to technical person not familiar with
Oracle, and it should be enough to let that person create
and manage a database in the simplified environment.

Best regards,

Jonathan Gennick --- Brighten the corner where you are
http://Gennick.com * 906.387.1698 * mailto:[EMAIL PROTECTED]

Join the Oracle-article list and receive one
article on Oracle technologies per month by 
email. To join, visit http://four.pairlist.net/mailman/listinfo/oracle-article, 
or send email to [EMAIL PROTECTED] and 
include the word "subscribe" in either the subject or body.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jonathan Gennick
  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: 3rd Party Oracle Licenses

Take their word - in a contract that specify that they are responsible in
case Oracle ask for more money, and then check with Oracle.

Yechiel Adar
Mehish
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Thursday, December 11, 2003 4:14 PM


> We are purchasing a software package from a vendor.  The vendor states
that the package includes sufficient Oracle licenses.  Since I'm supposed to
keep on top of our licensing costs, I'm trying to make sure that there are
no surprises down the road - such as additional Oracle support fees or
Oracle claiming that we don't have this new box licensed, etc.  How can the
vendor prove that they are providing a license?  When I asked them for some
type of proof, they forward the OLSA to me, which is basically generic - it
doesn't tell me if the license is SE, EE, SE One, perpertual, term, CPU,
Named User, etc.  Any thoughts or do I just take their word for it?
>
> Thanks,
> Jay
>
>
>
> **DISCLAIMER
> This e-mail message and any files transmitted with it are intended for the
use of the individual or entity to which they are addressed and may contain
information that is privileged, proprietary and confidential. If you are not
the intended recipient, you may not use, copy or disclose to anyone the
message or any information contained in the message. If you have received
this communication in error, please notify the sender and delete this e-mail
message. The contents do not represent the opinion of D&E except to the
extent that it relates to their official business.
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Jay Hostetter
>   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: Yechiel Adar
  INET: [EMAIL PROTECTED]

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

RE: Code Conversion from MSSQL into Oracle

2003-12-11 Thread Hallas, John, Tech Dev

Steve Perry from this list produced a perl script to read a import file (rows=n) and 
produce formatted DDL.
Whilst it is not perfect (as Steve agrees) it does give a good basis of where to start 
with processing and transforming a text input stream into a text output stream whilst 
making a small no of changes)  - or ETL as it is called these days, using PERL as the 
mechanism.
 
I host the zip file on my site at http://www.hcresources.co.uk/perlscript.shtml
 
I hope someone finds it useful.   If they do thank Steve.
 
HTH 
 
John

-Original Message-
Sent: 11 December 2003 12:55
To: Multiple recipients of list ORACLE-L


10 years ago or so, I wrote a 105 line script for the UNIX "sed" (a.k.a. "stream 
editor") command to convert Teradata "BTEQ" scripts into Oracle SQL*Plus.  Painful, 
yet thrilling, and it took only about a day of concentration with the O'Reilly "Awk 
and Sed" book at hand.

I'll bet you can write something (whether in "sed" or "awk" or Perl or Java) faster 
than it takes you find a TransactSQL-to-PL/SQL converter...?  And if you don't know 
Perl (probably the best choice) yet, this exercise could be the opportunity to put a 
huge new skill into the old skillset...

Just a thought...



on 12/11/03 4:49 AM, VIVEK_SHARMA at [EMAIL PROTECTED] wrote:





Are there any TOOLs for converting Sample Code (like the following) from MSSQL into 
Oracle?



SAMPLE :-



DECLARE @entity_id char(32), @branch_id char(9)



DECLARE  cur_temp_GEMT CURSOR FOR select

branch_id,entity_id from GEMT where other_party_name='' and entity_type='D'



OPEN cur_temp_GEMT   



FETCH NEXT FROM cur_temp_GEMT INTO

 @branch_id,@entity_id

 

WHILE @@FETCH_STATUS = 0



BEGIN





UPDATE GEMT SET other_party_name=(SELECT name from GEAT where branch_id [EMAIL 
PROTECTED] and [EMAIL PROTECTED] and  addr_type='1' and entity_type='D') where [EMAIL 
PROTECTED] and branch_id = @branch_id



FETCH NEXT FROM cur_temp_GEMT INTO

 @branch_id,

 @entity_id





END



CLOSE cur_temp_GEMT

DEALLOCATE cur_temp_GEMT










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

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

RE: SQL Area Reloads

2003-12-11 Thread Tim Gorman

OK, fair enough.

Something to consider:  the concept of "reload" probably
also includes the concept of "initial/first load".  I don't
know whether this is the case for certain, but one way to
check might be to query the number of items in the V$SQLAREA
(i.e. "select count(*) from v$sqlarea").  After all, each of
those entries had to be loaded (a.k.a. "reloaded") at least
once, I think...

> Shared pool is free all the time.
> There are no DDLs executed, no analyze or no package
> compiles still there are SQL AREA reloads.
> The database is on 9i RAC. The reloads are appearing on
> RAC instances. 
> -Original Message-
> Sent: Wednesday, December 10, 2003 11:05 PM
> To: Multiple recipients of list ORACLE-L
> 
> 
> Sure, it's free now.  But has that always been the case?
> 
> 
> on 12/10/03 3:14 PM, Ashish Sahasrabudhe at
> [EMAIL PROTECTED] wrote:
> 
> 
> 
> The statspack report is showing 10,684 reload for SQL AREA
> with 2.2% misses. 
> 
> ==
> == == 
> Library Cache Activity for DB: MAIN  Instance: MAIN 
> Snaps: 18089 -18090  ->"Pct Misses"  should be very low 
> 
> Get  PctPinPct
>   Invali- 
> Namespace   Requests  Miss Requests Miss  
>   Reloads dations 
> ---  -- -- --
> --  
> BODY  12,1860.0 12,1860.0 
> 0 0 
> CLUSTER   950.0 100.0 
> 0 0 
> INDEX4660.04610.0 
> 0 0 
> SQL AREA  44,1420.1500,9872.2 
>10,684 0 
> TABLE/PROCEDURE  208,4980.1584,2190.0 
> 1 0 
> TRIGGER2,7460.0  2,7460.0 
> 0 0 
> ==
> == == 
> 
> The 250 MB of shared pool is free. Why would it cause
> reloads if there is so much 
> free space available? 
> 
> Any help is appreciated. 
> 
> Ashish 
> 
> 
> 
> 
> 
> 
> 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Tim Gorman
  INET: [EMAIL PROTECTED]

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

RE: Little competition

2003-12-11 Thread nelson . petersen




What's wrong with the analysis?

 
Wrong 
syntax in the 'CREATE TABLE'
 
PCTFREE and PCTUSED are not part of the storage 
clause.
 
SQL> create table t1 (c1 number) 
tablespace lmt1 pctfree 20 pctused 30;
 
Table created.
 
Lot's 
of potential to go down the wrong path on this one.
Assumptions!
 
Nelson
 
 -Original Message-From: 
Richard Foote [mailto:[EMAIL PROTECTED]Sent: Thursday, 
December 11, 2003 6:39 AMTo: Multiple recipients of list 
ORACLE-LSubject: Little competition

  Little competition for you all :)
   
  It's a two part question:
  
    What's wrong with the 
following piece of expert analysis ? 
    Which well know "Oracle Guru" 
published this (and continues to display it on his web-page) 
?
   
   
  "Sadly, Oracle9i doesn't allow you to specify the 
  value for PCTFREE if you're using automatic space management. This is a 
  serious limitation because Oracle9i can't know in advance about the amount of 
  VARCHAR expansion in a table row, leading to excessive row chaining and poor 
  access performance."
  
   
  SQL> create 
  table  2   
  test_table  3   (c1 
  number)  4  tablespace  5   asm_test  
  6  storage  7   ( pctfree 20 
  pctused 30 )  8  ;    ( pctfree 20 pctused 
  30 ) *ERROR at line 7:ORA-02143: invalid 
  STORAGE optionHowever, here's an important point. While 
  Oracle9i rejects the PCTFREE and PCTUSED parameters with locally managed 
  tablespaces with automatic space management, it does allow you to enter 
  invalid settings for NEXT and FREELISTS settings"
   
   
   
  You've gotta love it !!
   
  Sorry no clues 
   
  Cheers ;)
   
  Richard

RE: 3rd Party Oracle Licenses

2003-12-11 Thread Jesse, Rich

Our apps that use Oracle come with an "Application license".  By the terms
of this license, we get to use that Oracle DB for that app and that app
alone.  The DB support comes from the app vendor and not Oracle.  Not
feeling particularly comfortable with this arrangement, we purchased
separate Oracle licenses in order to get "Silver support" directly from
Oracle, as I've yet to meet a vendor who had a grip on the DBs they sell
with their product.

Then again, these were "network concurrent user" licenses, which
unfortunately no longer exist.  Perhaps a low-end 5-user named license would
work for you.

HTH!  GL!  :)

Rich

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


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


We are purchasing a software package from a vendor.  The vendor states that
the package includes sufficient Oracle licenses.  Since I'm supposed to keep
on top of our licensing costs, I'm trying to make sure that there are no
surprises down the road - such as additional Oracle support fees or Oracle
claiming that we don't have this new box licensed, etc.  How can the vendor
prove that they are providing a license?  When I asked them for some type of
proof, they forward the OLSA to me, which is basically generic - it doesn't
tell me if the license is SE, EE, SE One, perpertual, term, CPU, Named User,
etc.  Any thoughts or do I just take their word for it?

Thanks,
Jay
-- 
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: Strange behavior with dbms_stats...

2003-12-11 Thread Vergara, Michael (TEM)

Um...the PL/SQL script at the bottom of your e-mail doesn't
DO anything other than output a line.  Do you use this
in a subsequent command file?

Cheers,
Mike


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


List...

SunOS 5.8, Oracle 8.1.6 (and 8.1.7 too).

I use the proc at the bottom to generate statistics.

It seems to work, but if I check statistics with:

select owner, table_name, num_rows, blocks,
av_row_len,
to_char(last_analyzed, 'MM/DD/ HH24:MI:SS')
from dba_tables;

the tables have the OLD last_analyzed time!

but... If I execute ONE by ONE:

exec dbms_stats.gather_schema_stats(ownname =>
'PERFSTAT', cascade => TRUE);

it works fine!!...

So, am I doing something wrong?

Any help?

TIA
JL

create or replace procedure get_statistics as
   cursor get_users_list is
select username
from dba_users
where username != 'SYS' 
and username != 'SYSTEM';

begin
   for i in get_users_list
   loop
dbms_output.put_line('exec
dbms_stats.gather_schema_stats(ownname =>
'||chr(39)||i.username||chr(39)||', cascade =>
TRUE);');
   end loop;
end;
/


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

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

RE: Strange behavior with dbms_stats...

2003-12-11 Thread Jamadagni, Rajendra

after running the block, do you actually spool the output and run that??

Raj

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


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


List...

SunOS 5.8, Oracle 8.1.6 (and 8.1.7 too).

I use the proc at the bottom to generate statistics.

It seems to work, but if I check statistics with:

select owner, table_name, num_rows, blocks,
av_row_len,
to_char(last_analyzed, 'MM/DD/ HH24:MI:SS')
from dba_tables;

the tables have the OLD last_analyzed time!

but... If I execute ONE by ONE:

exec dbms_stats.gather_schema_stats(ownname =>
'PERFSTAT', cascade => TRUE);

it works fine!!...

So, am I doing something wrong?

Any help?

TIA
JL

create or replace procedure get_statistics as
   cursor get_users_list is
select username
from dba_users
where username != 'SYS' 
and username != 'SYSTEM';

begin
   for i in get_users_list
   loop
dbms_output.put_line('exec
dbms_stats.gather_schema_stats(ownname =>
'||chr(39)||i.username||chr(39)||', cascade =>
TRUE);');
   end loop;
end;
/



__
Do you Yahoo!?
New Yahoo! Photos - easier uploading and sharing.
http://photos.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jose Luis Delgado
  INET: [EMAIL PROTECTED]

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

**
This e-mail message is confidential, intended only for the named recipient(s) above 
and may contain information that is privileged, attorney work product or exempt from 
disclosure under applicable law. If you have received this message in error, or are 
not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 
and delete this e-mail message from your computer, Thank you.
**4
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jamadagni, Rajendra
  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[2]: Little competition

Thursday, December 11, 2003, 8:44:32 AM, Hately, Mike (LogicaCMG) ([EMAIL PROTECTED]) 
wrote:
HML> PS Yes, I'm aware that there will follow a list of post-7.3.4 features that
HML> people consider absolutely vital.  =)

And therein lies part of the challenge. I'm sure too, that
every product manager at Oracle would want their feature to
be included "in the box".

Best regards,

Jonathan Gennick --- Brighten the corner where you are
http://Gennick.com * 906.387.1698 * mailto:[EMAIL PROTECTED]

Join the Oracle-article list and receive one
article on Oracle technologies per month by 
email. To join, visit http://four.pairlist.net/mailman/listinfo/oracle-article, 
or send email to [EMAIL PROTECTED] and 
include the word "subscribe" in either the subject or body.

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

Strange behavior with dbms_stats...

List...

SunOS 5.8, Oracle 8.1.6 (and 8.1.7 too).

I use the proc at the bottom to generate statistics.

It seems to work, but if I check statistics with:

select owner, table_name, num_rows, blocks,
av_row_len,
to_char(last_analyzed, 'MM/DD/ HH24:MI:SS')
from dba_tables;

the tables have the OLD last_analyzed time!

but... If I execute ONE by ONE:

exec dbms_stats.gather_schema_stats(ownname =>
'PERFSTAT', cascade => TRUE);

it works fine!!...

So, am I doing something wrong?

Any help?

TIA
JL

create or replace procedure get_statistics as
   cursor get_users_list is
select username
from dba_users
where username != 'SYS' 
and username != 'SYSTEM';

begin
   for i in get_users_list
   loop
dbms_output.put_line('exec
dbms_stats.gather_schema_stats(ownname =>
'||chr(39)||i.username||chr(39)||', cascade =>
TRUE);');
   end loop;
end;
/



__
Do you Yahoo!?
New Yahoo! Photos - easier uploading and sharing.
http://photos.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jose Luis Delgado
  INET: [EMAIL PROTECTED]

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

RE: SQL Area Reloads

2003-12-11 Thread Ashish Sahasrabudhe

Title: Re: SQL Area Reloads



Shared 
pool is free all the time.
There 
are no DDLs executed, no analyze or no package compiles still there are 
SQL AREA reloads.
The 
database is on 9i RAC. The reloads are appearing on RAC 
instances.

  -Original Message-From: Tim Gorman 
  [mailto:[EMAIL PROTECTED]Sent: Wednesday, December 10, 2003 11:05 
  PMTo: Multiple recipients of list ORACLE-LSubject: Re: 
  SQL Area ReloadsSure, it's free now. 
   But has that always been the case?on 12/10/03 3:14 PM, 
  Ashish Sahasrabudhe at [EMAIL PROTECTED] wrote:
  The statspack report is showing 
10,684 reload for SQL AREA with 2.2% misses. == 
Library Cache Activity for DB: MAIN  Instance: MAIN 
 Snaps: 18089 -18090 ->"Pct Misses" 
 should be very low Get 
 Pct    Pin 
   Pct 
  Invali- 
Namespace 
  Requests 
 Miss Requests Miss 
Reloads  dations ---  -- -- -- -- 
 BODY 
 12,186 
   0.0 12,186 
   0.0 
 0 
   0 CLUSTER 
  95 
   0.0 
10 
   0.0 
 0 
   0 INDEX 
   466 
   0.0 
   461 
   0.0 
 0 
   0 SQL AREA 
 44,142 
   0.1    500,987 
   2.2 10,684 
   0 TABLE/PROCEDURE  208,498 
   0.1    584,219 
   0.0 
 1 
   0 TRIGGER 
   2,746 
   0.0 
 2,746 
   0.0 
 0 
   0 == 
The 250 MB of shared pool is free. Why would it cause 
reloads if there is so much free space 
available? Any help is appreciated. 
Ashish

Strange behavior with dbms_stats...

List...

SunOS 5.8, Oracle 8.1.6 (and 8.1.7 too).

I use this proc to generate statistics:

create or replace procedure get_statistics as
   cursor get_users_list is
select username
from dba_users
where username != 'SYS' 
and username != 'SYSTEM';

begin
   for i in get_users_list
   loop
dbms_output.put_line('exec
dbms_stats.gather_schema_stats(ownname =>
'||chr(39)||i.username||chr(39)||', cascade =>
TRUE);');
   end loop;
end;
/



__
Do you Yahoo!?
New Yahoo! Photos - easier uploading and sharing.
http://photos.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jose Luis Delgado
  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: Little competition

2003-12-11 Thread Hately, Mike (LogicaCMG)

Good points Jonathan,

The 'box' as far as I'm concerned was accomodated by v7.3.4. That had 95% of
the features anyone could want for most environments. After that we've had a
succession of 'nice to have' features.
Don't get me wrong, some environments absolutely demand these new features
and there's a living to be made in understanding all of the new bells and
whistles but I agree that most people don't use more than a tiny subset of
the available toys.

Mike Hately

PS Yes, I'm aware that there will follow a list of post-7.3.4 features that
people consider absolutely vital.  =)

-Original Message-
Sent: 11 December 2003 13:25
To: Multiple recipients of list ORACLE-L

Maybe I'm wrong here, but I don't
believe Oracle has put together the simplified DBA manual
yet, and perhaps maybe they should. What do you think?
Should Oracle define the box and write a manual for
customers who want to live within that box?

Best regards,

Jonathan Gennick --- Brighten the corner where you are
http://Gennick.com * 906.387.1698 * mailto:[EMAIL PROTECTED]




E mail Disclaimer

You agree that you have read and understood this disclaimer and you agree to be bound 
by its terms.

The information contained in this e-mail and any files transmitted with it (if any) 
are confidential and intended for the addressee only.  If you have received this  
e-mail in error please notify the originator.

This e-mail and any attachments have been scanned for certain viruses prior to sending 
but CE Electric UK Funding Company nor any of its associated companies from whom this 
e-mail originates shall be liable for any losses as a result of any viruses being 
passed on.

No warranty of any kind is given in respect of any information contained in this   
e-mail and you should be aware that that it might be incomplete, out of date or 
incorrect. It is therefore essential that you verify all such information with us 
before placing any reliance upon it.

CE Electric UK Funding Company
Lloyds Court
78 Grey Street
Newcastle upon Tyne
NE1 6AF
Registered in England and Wales: Number 3476201



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Hately, Mike (LogicaCMG)
  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: Web hosting

2003-12-11 Thread Kevin Toepke

Title: Message



I use 
PHP Webhosting for all of the sites I manage. 
http://phpwebhosting.com/
 
Kevin

  
  -Original Message-From: 
  [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 
  Wednesday, December 10, 2003 6:40 PMTo: Multiple recipients of list 
  ORACLE-LSubject: OT: Web hostingSorry for the off topic, but I don't have any one 
  locally to ask this of. My 
  co-workers that are developers tend to be somewhat MScentric. 
  Can anyone recommend a good, inexpensive 
  web hosting company that runs on open 
  source:  Linux, Perl, MySQL, PHP, etc.? This is to be for my personal use, and I'm trying to 
  get good, and cheap.  :) Thanks, Jared

Re: Re: Little competition

2003-12-11 Thread Jonathan Lewis



I managed to emulate Don Burleson's problem:

SQL> create table test_table
  2  (c1 number)
  3  storage (pctfree 20 pctused 30);
storage (pctfree 20 pctused 30)
 *
ERROR at line 3:
ORA-02143: invalid STORAGE option

But when I read the error message, and
corrected the error that was reporting,
the statement worked:

create table test_table(c1 number)
pctfree 20 pctused 30;

Table created.

=

Richard was kind enough to refrain from
posting the next paragraph in the tip:


This could be a serious issue for the Oracle professional unless they
remember that locally-managed tablespaces with automatic space management
ignore any specified values for NEXT and FREELISTS.



There is another error here.
For a bonus 10 points can anyone spot it ?

Hint - try the following in a tablespace
which is locallally managed, with automatic
space management, and either system managed
or uniform sized extents of no more than 1 M.

create table test2(n1 number)
storage (initial 1M next 2M pctincrease 100 minextents 3);

Regards

Jonathan Lewis
http://www.jlcomp.demon.co.uk

  The educated person is not the person
  who can answer the questions, but the
  person who can question the answers -- T. Schick Jr


One-day tutorials:
http://www.jlcomp.demon.co.uk/tutorial.html


Three-day seminar:
see http://www.jlcomp.demon.co.uk/seminar.html
UK___November


The Co-operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html


- Original Message - 
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Thursday, December 11, 2003 1:14 PM


again, what is so bad with what burleson said about the pctfree and pctused?

>
> >> >
> >> > From: "Richard Foote" <[EMAIL PROTECTED]>
> >> > Date: 2003/12/11 Thu AM 06:39:26 EST
> >> > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> >> > Subject: Little competition
> >> >
> >> > Little competition for you all :)
> >> >
> >> > It's a two part question:
> >> >   a.. What's wrong with the following piece of expert analysis ?
> >> >   b.. Which well know "Oracle Guru" published this (and continues
to
> >> display it on his web-page) ?
> >> >
> >> >
> >> > "Sadly, Oracle9i doesn't allow you to specify the value for PCTFREE
if
> >> you're using automatic space management. This is a serious limitation
because
> >> Oracle9i can't know in advance about the amount of VARCHAR expansion in
a
> >> table row, leading to excessive row chaining and poor access
performance."
> >> >
> >> > SQL> create table
> >> >   2   test_table
> >> >   3   (c1 number)
> >> >   4  tablespace
> >> >   5   asm_test
> >> >   6  storage
> >> >   7   ( pctfree 20 pctused 30 )
> >> >   8  ;
> >> >
> >> >( pctfree 20 pctused 30 )
> >> >  *
> >> > ERROR at line 7:
> >> > ORA-02143: invalid STORAGE option
> >> >
> >> > However, here's an important point. While Oracle9i rejects the
PCTFREE and
> >> PCTUSED parameters with locally managed tablespaces with automatic
space
> >> management, it does allow you to enter invalid settings for NEXT and
> >> FREELISTS settings"
> >> >

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jonathan Lewis
  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: Dblink fails between 8.1.7 (Unix) and 9i (Zos 390) due to inv

Yes. The name must be equal to select name from v$database.

Yechiel Adar
Mehish
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Thursday, December 11, 2003 4:54 PM


> Clive,
>
> If the GLOBAL_NAMES parameter is set to true, then you must create the
> database link with the same name as the database to which it connects.. Is
> that the case?
>
> Mark
>
>
>
> -Original Message-
> Hybart, Clive
> Sent: 11 December 2003 12:24
> To: Multiple recipients of list ORACLE-L
> inv
>
>
> On UNIX 8.1.7 global_names = true
>
> On Zos 390 9i global_names = false
>
>
> Is this causing a mismatch perhaps ?
>
> Regards
>
> Clive
>
> -Original Message-
> Sent: 10 December 2003 12:10
> To: Multiple recipients of list ORACLE-L
> inv
>
>
> Clive,
> during the upgrade has the global_names parameter somehow been changed
> from false to true? This would cause the connection to be refused if the
> link name does not match the global_name for the target database.
>
> Cheers,
> Mike Hately
>
> -Original Message-
> On Behalf Of Hybart, Clive
> Sent: 10 December 2003 10:39
> To: Multiple recipients of list ORACLE-L
>
>
>
> Since upgrading our mainframe database to 9.2.0.1.0.25 a dblink between
> a Unix box (8.1.7.0) and the mainframe fails.
> However sqlplus using the same connection syntax "Connect
> username/[EMAIL PROTECTED]" is fine.
> Any ideas, peeps ?
>
>
>
> 
> 
> E mail Disclaimer
>
> You agree that you have read and understood this disclaimer and you
> agree to be bound by its terms.
>
> The information contained in this e-mail and any files transmitted with
> it (if any) are confidential and intended for the addressee only.  If
> you have received this  e-mail in error please notify the originator.
>
>
> This e-mail and any attachments have been scanned for certain viruses
> prior to sending but CE Electric UK Funding Company nor any of its
> associated companies from whom this e-mail originates shall be liable
> for any losses as a result of any viruses being passed on.
>
> No warranty of any kind is given in respect of any information contained
> in this   e-mail and you should be aware that that it might be
> incomplete, out of date or incorrect. It is therefore essential that you
> verify all such information with us before placing any reliance upon it.
>
> CE Electric UK Funding Company
> Lloyds Court
> 78 Grey Street
> Newcastle upon Tyne
> NE1 6AF
> Registered in England and Wales: Number 3476201
>
> 
> 
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Hately, Mike (LogicaCMG)
>   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: Hybart, Clive
>   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).
> ---
> Incoming mail is certified Virus Free.
> Checked by AVG anti-virus system (http://www.grisoft.com).
> Version: 6.0.547 / Virus Database: 340 - Release Date: 02/12/2003
>
> ---
> Outgoing mail is certified Virus Free.
> Checked by AVG anti-virus system (http://www.grisoft.com).
> Version: 6.0.547 / Virus Database: 340 - Release Date: 02/12/2003
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Mark Leith
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to b

Re: sequences and cursors

2003-12-11 Thread Jonathan Lewis


Run your test case, and check the contents
of v$open_cursor. Unless my memory has
got it backwards, 
the pl/sql cursor cache is counted towards 
max_open_cursors, but the cursors that have
been held open by the 'dirty tricks department'
are closed as required if the limit is reached:
(so should not be responsible for ORA-01000 
anyway).

cursors held open as session_cache'd cursors
are counted independently of max_open_cursors -
so should not cause an ORA-01000


Regards

Jonathan Lewis
http://www.jlcomp.demon.co.uk

  The educated person is not the person 
  who can answer the questions, but the 
  person who can question the answers -- T. Schick Jr


One-day tutorials:
http://www.jlcomp.demon.co.uk/tutorial.html


Three-day seminar:
see http://www.jlcomp.demon.co.uk/seminar.html
UK___November


The Co-operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html


- Original Message - 
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Thursday, December 11, 2003 2:09 PM


> It might be held in the cursor cache, it may even be 
> held in session cursors cache but it will not be counted
> as an open cursor. My suggestion had diagnostic purpose only.
> The problem is, probably, with the tool which explicitly closes 
> cursors too frequently and insufficiently sized shared pool
> which throws cursors out soon after they're closed.
> 
> 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jonathan Lewis
  INET: [EMAIL PROTECTED]

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

RE: Downloading patches

2003-12-11 Thread Jerry Hess

Try using updates.oracle.com.

-Original Message-
Mladen Gogala
Sent: Thursday, December 11, 2003 8:39 AM
To: Multiple recipients of list ORACLE-L


Nope. Not since oracle killed the ftp server they used (ftp://oracle-ftp.oracle.com).
You could have used wget when the ftp server was there. That is the primary reason
I had to purchase a cable modem connection. 
On 12/11/2003 03:54:24 AM, "Naveen, Nahata (IE10)" wrote:
> Hi,
> 
> This might be a rudimentary question. I'm trying to download patch 3095277
> (9.2.0.4) from windows workstation behind a proxy.
> 
> Is there any way I can use ftp to download the same rather than using the
> standard browser based download which seems to be a but slower?
> 
> Regards
> Naveen
> > -Original Message-
> > From: Yong Huang [mailto:[EMAIL PROTECTED]
> > Sent: Wednesday, December 10, 2003 9:09 PM
> > To: Multiple recipients of list ORACLE-L
> > Subject: Re: leaf node 90-10 splits
> > 
> > 
> > Hi, Tanel,
> > 
> > Where do you see this statistic? I only see "leaf node 
> > splits" in 8.1.7 and 9.2
> > documentation. If the index is on strictly monotonically 
> > increasing numbers,
> > won't a new node be added to the right without a block split?
> > 
> > Yong Huang
> > 
> > > I wonder why does statistic "leaf node 90-10 splits" imply 
> > that right-hand
> > > index leaf block is split as 90-10, not 100-0 as it really 
> > is. (tested on
> > > 9.2.0.4 W2k).
> > >
> > > Historical reasons?
> > >
> > > Tanel.
> > 
> > __
> > Do you Yahoo!?
> > New Yahoo! Photos - easier uploading and sharing.
> > http://photos.yahoo.com/
> > -- 
> > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > -- 
> > Author: Yong Huang
> >   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: Naveen, Nahata (IE10)
>   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).
> 

Mladen Gogala
Oracle DBA



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

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

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

RE: Antw: RE: Little competition

2003-12-11 Thread Guido Konsolke

Yes, I know. That David Bowie stuff comes up every few
weeks / months in several c.d.o. groups.

But what are 'fans'? In my opintion they make wind ;-)

Anyway, I like this competition thread - mostly because
there's nothing but bulls**t coming from me.

Greetings to the list,
Guido


>>> [EMAIL PROTECTED] 11.12.2003  14.24 Uhr >>>
No, you are not but I think Richard from down under is a big David Bowie fan !!

Raj

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


-Original Message-
[mailto:[EMAIL PROTECTED] 
Sent: Thursday, December 11, 2003 8:09 AM
To: Multiple recipients of list ORACLE-L


Hi Raj,

David Bowie? Didn't he publish something regarding
'space' management a long time ago? ;-)

I may (as usual) be totally wrong here.

Greetings,
Guido

>>> [EMAIL PROTECTED] 11.12.2003  13.49 Uhr >>>
Richard,
 
Don't know about the "guru", but sorry to hear that David Bowie is sick with Influenza.
 
Raj
 
Rajendra dot Jamadagni at nospamespn dot com 
All Views expressed in this email are strictly personal. 
QOTD: Any clod can have facts, having an opinion is an art ! 

**
This e-mail message is confidential, intended only for the named recipient(s) above 
and may contain information that is privileged, attorney work product or exempt from 
disclosure under applicable law. If you have received this message in error, or are 
not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 
and delete this e-mail message from your computer, Thank you.
**4
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net 
-- 
Author: Jamadagni, Rajendra
  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: Guido Konsolke
  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: Dblink fails between 8.1.7 (Unix) and 9i (Zos 390) due to inv

2003-12-11 Thread Mark Leith

Clive,

If the GLOBAL_NAMES parameter is set to true, then you must create the
database link with the same name as the database to which it connects.. Is
that the case?

Mark



-Original Message-
Hybart, Clive
Sent: 11 December 2003 12:24
To: Multiple recipients of list ORACLE-L
inv


On UNIX 8.1.7 global_names = true

On Zos 390 9i global_names = false


Is this causing a mismatch perhaps ?

Regards

Clive

-Original Message-
Sent: 10 December 2003 12:10
To: Multiple recipients of list ORACLE-L
inv


Clive,
during the upgrade has the global_names parameter somehow been changed
from false to true? This would cause the connection to be refused if the
link name does not match the global_name for the target database.

Cheers,
Mike Hately

-Original Message-
On Behalf Of Hybart, Clive
Sent: 10 December 2003 10:39
To: Multiple recipients of list ORACLE-L



Since upgrading our mainframe database to 9.2.0.1.0.25 a dblink between
a Unix box (8.1.7.0) and the mainframe fails.
However sqlplus using the same connection syntax "Connect
username/[EMAIL PROTECTED]" is fine.
Any ideas, peeps ?





E mail Disclaimer

You agree that you have read and understood this disclaimer and you
agree to be bound by its terms.

The information contained in this e-mail and any files transmitted with
it (if any) are confidential and intended for the addressee only.  If
you have received this  e-mail in error please notify the originator.


This e-mail and any attachments have been scanned for certain viruses
prior to sending but CE Electric UK Funding Company nor any of its
associated companies from whom this e-mail originates shall be liable
for any losses as a result of any viruses being passed on.

No warranty of any kind is given in respect of any information contained
in this   e-mail and you should be aware that that it might be
incomplete, out of date or incorrect. It is therefore essential that you
verify all such information with us before placing any reliance upon it.

CE Electric UK Funding Company
Lloyds Court
78 Grey Street
Newcastle upon Tyne
NE1 6AF
Registered in England and Wales: Number 3476201




--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Hately, Mike (LogicaCMG)
  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: Hybart, Clive
  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).
---
Incoming mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.547 / Virus Database: 340 - Release Date: 02/12/2003

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.547 / Virus Database: 340 - Release Date: 02/12/2003

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

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

Re: Downloading patches

2003-12-11 Thread Mladen Gogala

Nope. Not since oracle killed the ftp server they used (ftp://oracle-ftp.oracle.com).
You could have used wget when the ftp server was there. That is the primary reason
I had to purchase a cable modem connection. 
On 12/11/2003 03:54:24 AM, "Naveen, Nahata (IE10)" wrote:
> Hi,
> 
> This might be a rudimentary question. I'm trying to download patch 3095277
> (9.2.0.4) from windows workstation behind a proxy.
> 
> Is there any way I can use ftp to download the same rather than using the
> standard browser based download which seems to be a but slower?
> 
> Regards
> Naveen
> > -Original Message-
> > From: Yong Huang [mailto:[EMAIL PROTECTED]
> > Sent: Wednesday, December 10, 2003 9:09 PM
> > To: Multiple recipients of list ORACLE-L
> > Subject: Re: leaf node 90-10 splits
> > 
> > 
> > Hi, Tanel,
> > 
> > Where do you see this statistic? I only see "leaf node 
> > splits" in 8.1.7 and 9.2
> > documentation. If the index is on strictly monotonically 
> > increasing numbers,
> > won't a new node be added to the right without a block split?
> > 
> > Yong Huang
> > 
> > > I wonder why does statistic "leaf node 90-10 splits" imply 
> > that right-hand
> > > index leaf block is split as 90-10, not 100-0 as it really 
> > is. (tested on
> > > 9.2.0.4 W2k).
> > >
> > > Historical reasons?
> > >
> > > Tanel.
> > 
> > __
> > Do you Yahoo!?
> > New Yahoo! Photos - easier uploading and sharing.
> > http://photos.yahoo.com/
> > -- 
> > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > -- 
> > Author: Yong Huang
> >   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: Naveen, Nahata (IE10)
>   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).
> 

Mladen Gogala
Oracle DBA

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

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

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

Re: OT: Web hosting

2003-12-11 Thread Robert Pegram

I have been thinking of using ipowerweb.

http://www.ipowerweb.com/

Rob Pegram

--- [EMAIL PROTECTED] wrote:
> Sorry for the off topic, but I don't have any one
> locally to ask this of.
> 
> My co-workers that are developers tend to be
> somewhat MScentric.
> 
> Can anyone recommend a good, inexpensive web hosting
> company
> that runs on open source:  Linux, Perl, MySQL, PHP,
> etc.?
> 
> This is to be for my personal use, and I'm trying to
> get good, and cheap. 
> :)
> 
> Thanks,
> 
> Jared
> 

__
Do you Yahoo!?
Free Pop-Up Blocker - Get it now
http://companion.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Robert Pegram
  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: analyze problems

2003-12-11 Thread Wolfgang Breitling

Not that he needs it, but I can confirm Jonathan's claim that the 
method_opt clause you are using does not collect column statistics:

SQL> @delete_table_stats tp1

PL/SQL procedure successfully completed.

SQL> @tblstats tp1

avg
TABLE_NAME free used  fl 
log rows   blks   emptyrow px LAST_ANAL pool G U
--   --- ---  -- 
--- -- -- -  - -
TP1 
1   DEFAULT  N N
TP1.P1 (1)   10   40   1 
YES DEFAULT  N N
TP1.P2 (2)   10   40   1 
YES DEFAULT  N N
TP1.P3 (3)   10   40   1 
YES DEFAULT  N N

4 rows selected.

SQL> @colstats tp1

tablecolumn   NDV  density 
nulls lo hi  bkts
 - --  
--- -- -- -
TP1  N1
TP1  N2
TP1  N3
TP1  C1
TP1  C2
TP1  C3
TP1  D1
TP1  D2
TP1  D3
TP1  L

10 rows selected.

SQL> exec DBMS_STATS.GATHER_TABLE_STATS (ownname => 'SCOTT', tabname => 
'TP1', method_opt => 'FOR COLUMNS', cascade => TRUE);

PL/SQL procedure successfully completed.

SQL> @tblstats tp1

avg
TABLE_NAME free used  fl 
log rows   blks   emptyrow px LAST_ANAL pool G U
--   --- ---  -- 
--- -- -- -  - -
TP125,000  8,402 
   0100  1 11-DEC-03 DEFAULT  Y N
TP1.P1 (1)   10   40   1 
YES2,490836   010011-DEC-03 DEFAULT  Y N
TP1.P2 (2)   10   40   1 
YES2,489852   010011-DEC-03 DEFAULT  Y N
TP1.P3 (3)   10   40   1 
YES   20,021  6,714   010011-DEC-03 DEFAULT  Y N

4 rows selected.

SQL> @colstats tp1

tablecolumn   NDV  density 
nulls lo hi  bkts
 - --  
--- -- -- -
TP1  N1
TP1  N2
TP1  N3
TP1  C1
TP1  C2
TP1  C3
TP1  D1
TP1  D2
TP1  D3
TP1  L

10 rows selected.

SQL>

If you are seeing column statistics then they are old.
As to your original questions
"Are there any known do and don'ts concerning dbms_stats which might 
explain this?"
Nothing specific to dbms_stats, just the general advice: DON'T believe 
everything a self-proclaimed Oracle-Guru or consultant tells you. DO your 
own homework and due diligence. TEST what you are doing or planning to do. 
If you insist in painting all tables in your schemas with the same brush 
then at least just gather basic column statistics (num_distinct, min, max, 
nulls) by leaving the default method_opt alone. Afterwards you can collect 
histograms on select columns. In my opinion "for all indexed columns" is 
both too broad and too narrow - not all indexed column need or even should 
have histograms and some non-indexed columns could benefit from a histogram.

Is it better to stay on analyze table ?
No
Can I expect lot's of problems in execute plans when migrating?
Yes
At 03:44 AM 12/11/2003, you wrote:
Hi Jonathan,

Can you please elaborate on this 75 buckets issue.
I had an advice from an oracle consultant to implement analyzing
Like this. BTW column statistics are there but it makes no difference
In plans. I also added optimizer_index_caching=90 and
Optimizer_index_cost_adj=40 both also without effect on my testcase
Wolfgang Breitling
Oracle7, 8, 8i, 9i OCP DBA
Centrex Consulting Corporation
http://www.centrexcc.com 

--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Wolfgang Breitling
 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 mes

Re[2]: Little competition

Thursday, December 11, 2003, 8:34:32 AM, Tim Gorman ([EMAIL PROTECTED]) wrote:
TG> Neither the PCTFREE and PCTUSED clauses go inside the STORAGE clause.  They
TG> are independent of it.  That is why the error was thrown, not because
TG> PCTFREE is invalid with ASSM...

Oh my. I'm so blind! I completely missed that. That's funny.

Best regards,

Jonathan Gennick --- Brighten the corner where you are
http://Gennick.com * 906.387.1698 * mailto:[EMAIL PROTECTED]

Join the Oracle-article list and receive one
article on Oracle technologies per month by 
email. To join, visit http://four.pairlist.net/mailman/listinfo/oracle-article, 
or send email to [EMAIL PROTECTED] and 
include the word "subscribe" in either the subject or body.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jonathan Gennick
  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[3]: Little competition

Thursday, December 11, 2003, 8:44:43 AM, [EMAIL PROTECTED] ([EMAIL PROTECTED]) wrote:
rcn> The biggest thing about working on database in the
rcn> multi-TB range is that its a nice buzzword for your
rcn> resume. Its not necessarily harder.

This brings back some memories. I remember back when I moved
up to my first "big" database. I went from managing a bunch
of 5-10GB databases to one that was some 70GB in size. (try
not to laugh now, ok) I was practically petrified. I
fired off this one query to hit DBA_EXTENTS and sum up
extent sizes for the different tablespaces. I was afraid the
database might impload. Such a big database. So many
extents. Well, I was much too easily intimidated. That big
database was no different than the little instance on my
laptop.

Some differences, I've found, come into play when you start
to move large amounts of data around. For example, I might
be able to move a small table from one tablespace to another
using an INSERT...SELECT...FROM. But maybe I don't want to
do it that way for a table that's 10GB in size.
Export/Import works, but what if my table is 10GB and my
disks are only 4GB? And then there's the network. I'm not
above exporting a table over TCP/IP connection, but that
only works up to a certain point. A 5MB table? Ok. A 1MB
table I might even try over a dial-up connection. A 10GB
table over the network? Not ok. You really have to think a
lot more about *how* you move data when the volumes get
high.

rcn> Besides, when your on a 'lower' end project with less
rcn> resources and less people, Id argue that alot of times
rcn> your job is alot harder. You dont have the same
rcn> hardware and you have to do alot more different things
rcn> yourself. Though it doesnt look as good on a resume...

I did a lot of different things. That's true. I think they
look ok on my resume though, and I like lots of variety and
change in what I do. Actually, it's how I got into PL/SQL.
Had I been doing DBA work at a really big site, I probably
wouldn't have been asked to also take on PL/SQL development
for a client application. As it was, I sort of got sucked
into pretty much everything that was even remotely connected
to the database, which was pretty much everything.

Best regards,

Jonathan Gennick --- Brighten the corner where you are
http://Gennick.com * 906.387.1698 * mailto:[EMAIL PROTECTED]

Join the Oracle-article list and receive one
article on Oracle technologies per month by 
email. To join, visit http://four.pairlist.net/mailman/listinfo/oracle-article, 
or send email to [EMAIL PROTECTED] and 
include the word "subscribe" in either the subject or body.

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

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

Re: Re: Little competition

#1. these instances are still on 8i. We are supposed to go to 9i, but its not my call

#2. its read only for the users. We do batch loads at night and I did not notice any 
slow down in the loads. I run statspack regularly. no problem. Just gotta do an alter 
table move periodically when we get too much row migration, but I can do that over the 
weekend. 

Depends on your situation. There are cases for dense blocks
and there are cases where you dont want to do this. 

again, what is so bad with what burleson said about the pctfree and pctused? 
> 
> From: Tim Gorman <[EMAIL PROTECTED]>
> Date: 2003/12/11 Thu AM 07:59:25 EST
> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> Subject: Re: Little competition
> 
> >> I can cut 45 minutes off my load times by shrinking the data file?
> 
> And how much overhead gets added to DML statements as blocks madly shift on
> and off the freelists with each operation?  Priorities, priorities,
> priorities...
> 
> If you¹re using 9i or above, the table COMPRESS feature might be a more
> effective mechanism?
> 
> 
> 
> on 12/11/03 5:44 AM, [EMAIL PROTECTED] at [EMAIL PROTECTED] wrote:
> 
> > hopefully i wont sound like a complete idiot, but what is wrong with wanting
> > to be able to handle your own pctfree and pctused. Ok oracle handles the next
> > and initial extent sizes...(which causes fragmentation).
> > 
> > I use transportable tablespaces and in order to increase the time it takes to
> > copy these datafiles, I use pctused 99 and pctfree 1 in order to compact the
> > tables. I can cut 45 minutes off my load times by shrinking the data file?
> >> > 
> >> > From: "Richard Foote" <[EMAIL PROTECTED]>
> >> > Date: 2003/12/11 Thu AM 06:39:26 EST
> >> > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> >> > Subject: Little competition
> >> > 
> >> > Little competition for you all :)
> >> > 
> >> > It's a two part question:
> >> >   a.. What's wrong with the following piece of expert analysis ?
> >> >   b.. Which well know "Oracle Guru" published this (and continues to
> >> display it on his web-page) ?
> >> > 
> >> > 
> >> > "Sadly, Oracle9i doesn't allow you to specify the value for PCTFREE if
> >> you're using automatic space management. This is a serious limitation because
> >> Oracle9i can't know in advance about the amount of VARCHAR expansion in a
> >> table row, leading to excessive row chaining and poor access performance."
> >> > 
> >> > SQL> create table
> >> >   2   test_table
> >> >   3   (c1 number)
> >> >   4  tablespace
> >> >   5   asm_test
> >> >   6  storage
> >> >   7   ( pctfree 20 pctused 30 )
> >> >   8  ;
> >> >  
> >> >( pctfree 20 pctused 30 )
> >> >  *
> >> > ERROR at line 7:
> >> > ORA-02143: invalid STORAGE option
> >> > 
> >> > However, here's an important point. While Oracle9i rejects the PCTFREE and
> >> PCTUSED parameters with locally managed tablespaces with automatic space
> >> management, it does allow you to enter invalid settings for NEXT and
> >> FREELISTS settings"
> >> > 
> >> > 
> >> > 
> >> > You've gotta love it !!
> >> > 
> >> > Sorry no clues 
> >> > 
> >> > Cheers ;)
> >> > 
> >> > Richard
> >> > 
> >> > 
> > 
> > 
> > Little competition for you all :)
> >  
> > It's a two part question:
> > * What's wrong with the following piece of expert analysis ?
> > * Which well know "Oracle Guru" published this (and continues to display
> > it on his web-page) ?
> >  
> >  
> > "Sadly, Oracle9i doesnt allow you to specify the value for PCTFREE if youre
> > using automatic space management. This is a serious limitation because
> > Oracle9i cant know in advance about the amount of VARCHAR expansion in a
> > table row, leading to excessive row chaining and poor access performance."
> >  
> > SQL> create table
> >   2   test_table
> >   3   (c1 number)
> >   4  tablespace
> >   5   asm_test
> >   6  storage
> >   7   ( pctfree 20 pctused 30 )
> >   8  ;
> >  
> >( pctfree 20 pctused 30 )
> >  *
> > ERROR at line 7:
> > ORA-02143: invalid STORAGE option
> > 
> > However, heres an important point. While Oracle9i rejects the PCTFREE and
> > PCTUSED parameters with locally managed tablespaces with automatic space
> > management, it does allow you to enter invalid settings for NEXT and FREELISTS
> > settings"
> >  
> >  
> >  
> > You've gotta love it !!
> >  
> > Sorry no clues 
> >  
> > Cheers ;)
> >  
> > Richard
> > 
> 
> 
> 
> 
Title: Re: Little competition



>> I can cut 45 minutes off my load times by shrinking the data file?

And how much overhead gets added to DML statements as blocks madly shift on and off the freelists with each operation?  Priorities, priorities, priorities...

If you’re using 9i or above, the table COMPRESS feature might be a more effective mechanism?



on 12/11/03 5:44 AM, [EMAIL PROTECTED] at [EMAIL PROTECTED] wrote:

hopefully i wont sound like a complete idiot, but what is wrong with wanting to be able to handle your own pctfree and pctuse

Re: long raw risk