Re: Digestive Martinis
On Tuesday 12 June 2001 13:39, Koivu, Lisa wrote: > Bombay Sapphire, splash of olive juice and a few green olives. > > MM > Does the job REAL fast. Ah, a kindred spirit at last. Jared -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
high parses plus buffer holder
hi all, I got this application , they are not using any packages ,triggers or procedure. And there are lots of statements number of parsing = number of execute. Is there any way you can pinned the sql statsments into sga, beside increasing the sga size. buffer holder. I ran this statements select decode(state,0, 'FREE', 1,decode(lrba_seq,0,'AVAILABLE','BEING USED'), 3, 'BEING USED', state) "BLOCK STATUS", count(*) from x$bh group by decode(state,0,'FREE',1,decode(lrba_seq,0,'AVAILABLE', 'BEING USED'),3, 'BEING USED', state) and got the following result. BLOCK STATUSCOUNT(*) -- AVAILABLE5889 BEING USED 299 FREE 13012 Just for the purpose of testing it, I alter a table which has about 500 blocks to be cached and select * from that table. execute the above statements againg I got the same result. Where I expected to have 500 blocks lesser in free block. What have done wrong here? Thanks And Regards Chark Sairlao -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sairlao, Chark INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Digestive
On Tuesday 12 June 2001 15:05, [EMAIL PROTECTED] wrote: > > It's just that some are better than others :-) > and of them all, I have to agree with Jared, 16yr old Lagavullin is the > best. Hear hear! > If you don't like it too peaty , try Jura or Oban - I prefer them slightly > peatier. I *like* the peaty. Jared -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: check file size, extension question???
On Tuesday 12 June 2001 17:38, Christopher Spence wrote:
> I will beat Jared to this, What about using Perl?
How about:
-
#!/usr/bin/perl
$filename=shift;
$size = (stat($filename))[7];
print "File in Bytes : $size\n";
printf("File in MBytes: %5.2f\n", $size/=2**20);
---
call if filesize and use like this:
filesize
Jared
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Jared Still
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
extracting selective information
Hi All, We are developing a kind of reporting tool which wud connect to another database and present the data from that database in a format so that it is easily analysable for the end-user. Now the intented approach is to have a database for the reporting module and to periodically refresh only the recent modifications from that database.Now one solution to that was to create snapshots and refresh periodically but then , this is possible only if both these databases are oracle.How can we do this if say we have to do it from any other database like SQL Server into a oracle database. TIA, Jothish -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: K. JOTHISH INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
OT: Perl module question
Hi, I am installing a request tracking software (WREQ) which requires Perl 5 with GDBM support. I could not find GDBM_File.pm under /usr/local on my Solaris 2.6 machine. The command perl -e 'use GDBM_File;' gave the message: Can't locate GDBM_File in @INC (@INC contains ) Questions: 1) Do you know if a standard perl installation should contain GDBM_File module? If yes then I will try to re-install the Perl software. 2) I also downloaded Gnu gdbm and installed it on the machine. It seems to install a number of .so and .a files in /usr/local/lib (but I could not find GDBM_File.pm anywhere). Do I need to link the software into Perl somehow so GDBM_File.pm module is created in the Perl library? Thanks Long -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nguyen, Long (ITS, Limestone Ave) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Primary keys, Surrogate keys and SSN
On Tuesday 12 June 2001 13:19, Jared Still wrote: > The only real downfall of surrogate keys is that it may require a developer > to do a join on the FK to the parent table to get the unique key > information. Well, there are other downfalls on a system with a high transaction rate, but there are ways to deal with them. Jonatha Lewis' book 'Practical Oracle 8i' has several suggestions. Jared -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: OT: Pin a CPU in Solaris
On Tuesday 12 June 2001 10:40, Erik Williams wrote:
> Does anyone know how to pin a Solaris CPU at a high utilization? I am doing
> some testing and want to evaluate a system under a high CPU load. Thanks.
>
> Erik
The philosophical context of this excercise is already well covered,
so I just had some fun making a Perl script to do it.
Run it in a loop, add a loop to the script, run as many of these
as you want.
Fire up 50 of these babies simultaneously and bring your system
administrator to his knees, along with your systems.
Change the factorial from 2,000,000 to 200,000,000 for extra
special effects. ;)
You're welcome. :)
Jared
#!/usr/bin/perl -w
print factorial([1..200]), "\n";
sub factorial {
$refArray2Factor = shift;
clear();
my $factored=0;
my $arrayMax = @$refArray2Factor;
for ( my $i=0; $i<$arrayMax; $i++ ) {
$factored = _factorial(${$refArray2Factor}[$i]);
}
return $factored;
}
{
my $factorial;
sub _factorial {
my $factor = shift;
$factorial = 1 unless defined $factorial;
$factorial *= $factor;
return $factorial;
}
sub clear { undef $factorial }
}
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Jared Still
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
ora - 900 error while using copy command in a stored procedure
Hi DBA Gurus, Is it possible to use the copy command in a stored procedure? I am trying to use the copy command to copy one of the table data from user A to user B in the same database in a stored procedure with source database, username and password and destination database, username and password being used as input parameters. But I am getting ora - 900 error - invalid sql statement error. Any ideas? Here is my code: create or replace procedure copy_proc as sql1 varchar2(2000); begin sql1:= 'copy from primal/primal@primal to jstage2/jstage2@primal append carrier using select * from carrier'; execute immediate sql1; end; Any help in this regard will be very much appreciated. TIA and Regards, Ranganath -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ranganath K INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Oracle 817 is the fastest database on IBM's fastest server
List, Check out www.tpc.org, Oracle 8i occupies 6 out of 10 places in the TPC-C OLTP (non clustered) category. Oracle managed 2nd spot on IBM eServer pSeries with a bit over 220,000 transactions per minute (tpmC). IBM eServer pSeries 680 Model 7017-S85 Number 1 spot is Fujitsu's SymfoWARE Server Enterprise Edition. Fujitsu announced that SymfoWARE Server achieved the world best tmpC (Transactions Per Minute C) result on a 4 Intel CPU based Fujitsu Teamserver. vist http://www.symfoware.com/server/overview.html#Server Anyone using Symfoware? , or could enlighten us on its stability, robustness, performance, etc. , seems pretty impressive reviewing the TPC-C results and the above URL. Regards Suhen -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Suhen Pather INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
advance backup & recover (RMAN?)
> List, > one of our clients insists to isntall the "advance backup and recover > option" of > oralce... (8.1.6) (it's written on the back of the CD, "CD includes > advance backup and recovery") > > are they talking about the RMAN ? or something else ? > > Regards > > rahul > > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rahul INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: SMP/MPP and PQO
"In Search of Clusters" by Gregory F. Pfister, 2nd edition, Prentice-Hall (Saddle River, NJ) 1998 isbn 0-13-899709-8 and it is a wonderful book. I wish there were other technical books like this. The book is readable, fun, and excruciatingly technical all at the same time. -Original Message-From: Mohan, Ross [mailto:[EMAIL PROTECTED]]Sent: Tuesday, June 12, 2001 5:19 PMTo: Multiple recipients of list ORACLE-LSubject: RE: SMP/MPP and PQO I think it was just updated, too. Great book. -Original Message-From: Henry Poras [mailto:[EMAIL PROTECTED]]Sent: Tuesday, June 12, 2001 3:04 PMTo: Multiple recipients of list ORACLE-LSubject: RE: SMP/MPP and PQO Lisa, If you are interested in more detail on the differences between SMP, NUMA, and clusters, there is a great book "In search of clusters". It's one of the best technical books I've read. I can't remember the author's name, but maybe another list member can help. I picked it up because someone else on the list recomended it a while ago. Henrh -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]Sent: Tuesday, June 12, 2001 12:48 PMTo: Multiple recipients of list ORACLE-LSubject: Re: SMP/MPP and PQOHi Lisa SMP - In SMP many CPUs share the same memory. Typical example would be E450, 4 processors, 4GB memory. Only L2 cache in the CPUs need to be co-ordinated when a memory buffer is changed or intended to change. MPP - In MPP each CPU has its own memory and its own disks that they control (typically). An example would be nCUBE or IBM RS6000, where each processor runs its own OS and messaging is used heavily to coordinate the access to the resources. NUMA - Nun -uniform memory access - Group of CPUs share the same memory and the messaging is used between the group of the CPUs to coordinate the access to the resource. An example would be Sequent NUMA-Q, where there are multiple quads and each quad has 4 cpus and 2GB memory (typically) and IQ-link coordinates the access to the resources between the quads. HP has ccNUMA for this. Now, I don't think, E10k domain would qualify for a MPP, since there is no coordination or access restrictions between the domains ( at least that I know of). Each domain can manipulate its own disk / memory /devices without any messaging between the domains, in a non-clustered environment. PQ architecture splits the FTS or long running operations on non-partitioned tables, in to multiple chunks based upon the rowid ranges. It is not a simple split though. First, work is divided in to degree of parallelism. For example, if the QC process determines that it has to scan 100,000 blocks and parallelism is determined as 4 then 25000 would be the split. But not all 25000 block is handed over to the slave processes. QC uses 9/13 rule. QC hands over 9/13 of the work (i.e. 25000 * 9/13=17307) blocks equally to the slave processes. When the slave processes finishes up the 9/13 work, then they get 3/13 of the work (25000 *3/13=5769) blocks and 1/13 of the work when the second set of 3/13s are exhausted. This is done to evenly distribute the load. For example, there could data skew such that one process could finish up its 9/13 work much faster than other processes and hence those processes can take up the rema! in! ! ing work. The suitability of PQO parallelism should be defined by IO sub system in conjunction with CPU power. If you have many spindles in 2 cpu server my take on it would be to use parallelism of 2 to4 depending upon the cpu clock speed, disk speed, memory etc.. ThanksRiyaj "Re-yas" ShamsudeenCertified Oracle DBAi2 technologies www.i2.com "Koivu, Lisa" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 06/12/01 09:17 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject: SMP/MPP and PQOHello everyone, I was reading up on the differences between SMP, MPP and how they may affect PQO (Parallel Query). My understanding is that MPP is a host with defined domains (like an e10k with virtual machines on it). SMP is a standalone host with no domains and multiple processors. I am not considering clustering here. It seemed to me the only requirement that you really need to run PQO is to have available resources to power it. For exam
advance backup & recover (RMAN?)
List, one of our clients insists to isntall the "advance backup and recover option" of oralce... (8.1.6) (it's written on the back of the CD, "CD includes advance backup and recovery") are they talking about the RMAN ? or something else ? Regards rahul -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rahul INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
solaris - no utmpx entry !
List, we are suddenly getting "no utmpx entry" "you must exec login from the lowest leve" message from solaris., when trying to connect using dumb terminals (or console) ... as our solaris guy is not available... i need some suggestions on how to solve this.. * CANNOT log into any OTHER account also... * have tried switching off /on the server... did not work.. Regards Rahul -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rahul INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
regarding indexes..
hi all, how can we find whether we need to build more indexes other than primary keys. how can we know about what all indexes are being accessed, and creating on which columns will help improve performance. saurabh
RE: Digestive
I don't know if that makes you an idiot, unless you hate the Scottish and there booze or the distillery has gone broke. I could think of a lot of worse things to own a square foot of. Peter McLarty At 08:15 PM 12/06/2001 -0800, you wrote: >Glenfiddich is very good, but I vote for Laphroaig from the Isle of Islay. >Wanna know what an idiot I am? A couple of years ago, Laphroaig gave away 1 >square foot of their distillery if you bought a bottle and filled out all >the paperwork. Well, I did it, and am the proud owner of 1 square foot of >the Laphroaig distillery! > >Cheers! > >Jim > >^ >Jim Hawkins >Lead SAPR/3 Oracle Database Administrator >MEMC Electronic Materials, Inc. >501 Pearl Drive >St. Louis, MO 63376 >(636) 474-7832 >[EMAIL PROTECTED] (work) >[EMAIL PROTECTED] (personal) >^ > >-Original Message- >Rajendra >Sent: Tuesday, June 12, 2001 5:05 PM >To: Multiple recipients of list ORACLE-L > > >Talking about single malt .. > >My vote goes to Glenfiddich ... anyone? > >Raj >__ >Rajendra Jamadagni MIS, ESPN Inc. >Rajendra dot Jamadagni at ESPN dot com >Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. > >QOTD: Any clod can have facts, but having an opinion is an art ! > >*4 > >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.com >-- >Author: Jamadagni, Rajendra > INET: [EMAIL PROTECTED] > >Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 >San Diego, California-- Public Internet access / Mailing Lists > >To REMOVE yourself from this mailing list, send an E-Mail message >to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in >the message BODY, include a line containing: UNSUB ORACLE-L >(or the name of mailing list you want to be removed from). You may >also send the HELP command for other information (like subscribing). > >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: Hawkins Family > INET: [EMAIL PROTECTED] > >Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 >San Diego, California-- Public Internet access / Mailing Lists > >To REMOVE yourself from this mailing list, send an E-Mail message >to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in >the message BODY, include a line containing: UNSUB ORACLE-L >(or the name of mailing list you want to be removed from). You may >also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Peter McLarty INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Why is db slow after analyze?
Oh, hehe I have a habit of just skiming things, get too many emails per day :) "Walking on water and developing software from a specification are easy if both are frozen." Christopher R. Spence Oracle DBA Fuelspot -Original Message- Sent: Tuesday, June 12, 2001 10:36 PM To: Multiple recipients of list ORACLE-L I thought of the same thing. But how can this explain his statement "Bouncing the db brings things back to normal" ? - Kirti Deshpande Verizon Information Services http://www.superpages.com > -Original Message- > From: Christopher Spence [SMTP:[EMAIL PROTECTED]] > Sent: Tuesday, June 12, 2001 9:16 PM > To: Multiple recipients of list ORACLE-L > Subject: RE: Why is db slow after analyze? > > If you analyze SYS/SYSTEM you will cripple the performance of the > database, namely the table you mentioned and exports. > Drop the statsistics as soon as possible off the SYS/SYSTEM objects. > > This bug was suppose to be fixed in 8.1.7 and existed for some time, I am > not sure if it ever got fixed as I have not tested lately. > > > > "Walking on water and developing software from a specification are easy if > both are frozen." > > Christopher R. Spence > Oracle DBA > Fuelspot > > -Original Message- > From: Greg Moore [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, June 12, 2001 9:41 PM > To: Multiple recipients of list ORACLE-L > Subject: Why is db slow after analyze? > > > I ran dbms_stats.gather_database_stats( ); on a test machine with no > other users. After this, running a simple query on dba_extents was > extremely slow. > > Does anyone have an idea on what's the likely cause of this? I'd > like to check after gathering stats, but am not sure what to look at to > verify why the simple query runs so, so slowly. (Bouncing the db brings > things back to normal, but doesn't help me understand what the holdup > was.) > > Thanks. > > > > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deshpande, Kirti INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Christopher Spence INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Digestive
Glenfiddich is very good, but I vote for Laphroaig from the Isle of Islay. Wanna know what an idiot I am? A couple of years ago, Laphroaig gave away 1 square foot of their distillery if you bought a bottle and filled out all the paperwork. Well, I did it, and am the proud owner of 1 square foot of the Laphroaig distillery! Cheers! Jim ^ Jim Hawkins Lead SAPR/3 Oracle Database Administrator MEMC Electronic Materials, Inc. 501 Pearl Drive St. Louis, MO 63376 (636) 474-7832 [EMAIL PROTECTED] (work) [EMAIL PROTECTED] (personal) ^ -Original Message- Rajendra Sent: Tuesday, June 12, 2001 5:05 PM To: Multiple recipients of list ORACLE-L Talking about single malt .. My vote goes to Glenfiddich ... anyone? Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art ! *4 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.com -- Author: Jamadagni, Rajendra INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hawkins Family INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Email from PL/SQL
Title: RE: Changing Java pool size to 0 Hi all, Using UTL_TCP (and thru other package like utl_smtp) I can send Email. But the problem I find is - I can send mail in the name of someone else mail ID. I would like to know from you - Why PL/SQL allow me to send mail impersonating someone else Email ID. Where is the pitfall ? In PL/SQL or In Mail Server ? TIA Naba
Re: Why is db slow after analyze?
>> Drop the statsistics as soon as possible off the SYS/SYSTEM objects. When I do nothing more than bounce the db, two things happen. The simple select on dba_extents immediately performs in less than a second (instead of 45 seconds). Also, right after doing the dbms_stats.gather_database_stats, the query on dba_extents returned approx 3,400 rows. But after the bounce it's only returning approx 2,300 rows. It appears that 1,000 extents went away. I'm wondering if the problem is related to RBS's, and if an inefficient number or sizing of RBS's may be causing the high CPU usage. - Original Message - From: Christopher Spence To: Multiple recipients of list ORACLE-L Sent: Tuesday, June 12, 2001 7:15 PM Subject: RE: Why is db slow after analyze? If you analyze SYS/SYSTEM you will cripple the performance of the database, namely the table you mentioned and exports. Drop the statsistics as soon as possible off the SYS/SYSTEM objects. This bug was suppose to be fixed in 8.1.7 and existed for some time, I am not sure if it ever got fixed as I have not tested lately. "Walking on water and developing software from a specification are easy if both are frozen." Christopher R. Spence Oracle DBA Fuelspot -Original Message-From: Greg Moore [mailto:[EMAIL PROTECTED]]Sent: Tuesday, June 12, 2001 9:41 PMTo: Multiple recipients of list ORACLE-LSubject: Why is db slow after analyze? I ran dbms_stats.gather_database_stats( ); on a test machine with no other users. After this, running a simple query on dba_extents was extremely slow. Does anyone have an idea on what's the likely cause of this? I'd like to check after gathering stats, but am not sure what to look at to verify why the simple query runs so, so slowly. (Bouncing the db brings things back to normal, but doesn't help me understand what the holdup was.) Thanks.
RE: missing all control file
I am the last one went home yesterday, so nobody aware of it ; ) Sinardy -Original Message- Sent: Wednesday, 13 June 2001 4:25 AM To: Multiple recipients of list ORACLE-L On Tuesday 12 June 2001 03:21, Sinardy Xing wrote: > Hi all, > > I accidentally rm all my control file, I forgot do > ALTER DATABASE BACKUP CONTROLFILE TO TRACE; Glad to hear your database is now safe and sound. Now let's hear a little about how you managed to remove all of your control files. When you realized what happened, did you get that all over body buzz that indicates that you may be nearer to death than you ever expected? :) Maybe we can offer some tips to help prevent that kind of error in the future. More importantly, do your user and/or boss know what happened? :) Jared -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sinardy Xing INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Removing Older version of Oracle on NT
Can I get a copy of the writeup on how to fully clean NT/Win2k of Oracle Product ? -Original Message- Sent: Wednesday, June 13, 2001 3:04 AM To: Multiple recipients of list ORACLE-L Yea, this would be the easiest way. I could uninstall ALL Oracle products. And reinstall 8i. Then I could rebuild the database etc etc. I have a very nice writeup on how to fully clean NT of Oracle products.I have used it more than once. I might even have it electronically if anyone would like a copy. However, in the interest of learning more about NT/Oracle, I wanted to JUST remove 8.0 and all the 80 databases. I tried Universal Installer and it wouldn't give me an option to remove 8.0. I'm gonna try to do it with all the information you all have provided and see what happens. Ken Hitchcox - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Tuesday, June 12, 2001 6:50 AM > Interesting problem, I think I faced this with 816 and 815 once. I would > think the easiest thing to do, if all that you are trying to do is get some > hd space back would be to delete the Oracle 8.0 service and all of it's > files. Messing with the registry might be a little difficult. You could > probably search through the registry and at the least you will be able to > remove any reference to the 8.0 home. > Question though, why don't you want to just reinstall? Besides the obvious > that you can't, it would be a lot easier? > Kev > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sunrise DBA INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raymond Lee Meng Hong INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Why is db slow after analyze?
I thought of the same thing. But how can this explain his statement "Bouncing the db brings things back to normal" ? - Kirti Deshpande Verizon Information Services http://www.superpages.com > -Original Message- > From: Christopher Spence [SMTP:[EMAIL PROTECTED]] > Sent: Tuesday, June 12, 2001 9:16 PM > To: Multiple recipients of list ORACLE-L > Subject: RE: Why is db slow after analyze? > > If you analyze SYS/SYSTEM you will cripple the performance of the > database, namely the table you mentioned and exports. > Drop the statsistics as soon as possible off the SYS/SYSTEM objects. > > This bug was suppose to be fixed in 8.1.7 and existed for some time, I am > not sure if it ever got fixed as I have not tested lately. > > > > "Walking on water and developing software from a specification are easy if > both are frozen." > > Christopher R. Spence > Oracle DBA > Fuelspot > > -Original Message- > From: Greg Moore [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, June 12, 2001 9:41 PM > To: Multiple recipients of list ORACLE-L > Subject: Why is db slow after analyze? > > > I ran dbms_stats.gather_database_stats( ); on a test machine with no > other users. After this, running a simple query on dba_extents was > extremely slow. > > Does anyone have an idea on what's the likely cause of this? I'd > like to check after gathering stats, but am not sure what to look at to > verify why the simple query runs so, so slowly. (Bouncing the db brings > things back to normal, but doesn't help me understand what the holdup > was.) > > Thanks. > > > > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deshpande, Kirti INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Forever running Analyze
Last time I talked to them (6 months ago) it was Raid 5 "Walking on water and developing software from a specification are easy if both are frozen." Christopher R. Spence Oracle DBA Fuelspot -Original Message- Sent: Tuesday, June 12, 2001 9:56 PM To: Multiple recipients of list ORACLE-L Paul, They are RAID 4. And WAFL is their own proprietary system and you have very little control over allocation. You don't need to worry about it. (or so the sales rep and engineer said) Rachel >From: Paul Drake <[EMAIL PROTECTED]> >Reply-To: [EMAIL PROTECTED] >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> >Subject: RE: Forever running Analyze >Date: Tue, 12 Jun 2001 15:10:53 -0800 > >Kevin, > >I thought that those are actually RAID 4. >You don't have any control over allocation on a NetApp box? >Is that due to inherent limitations of the volume manager/file systems >or due to implementation specific to your SysAdmins' biases? > >thanks, > >Paul > > >-Original Message- >Sent: Tuesday, June 12, 2001 6:39 PM >To: Multiple recipients of list ORACLE-L > > >New file system is out. We are running on Net App Appliances containing a >Raid 5 system on Solaris using Oracle 8.0.5. Not the best environment but >its what we have to work with. So, hardware is out. > >As far as file system tuning . Another no. Its a Waffle system . >basicly, write anywhere , so where you put the tables and indexes are prety >much a moot point. > >So, we are down to runnig it at night. Not the kind of suggestion I was >looking for but its the one I figured I would hear. > >Oh well. > >Thanks anyway. > >-Original Message- >Sent: Tuesday, June 12, 2001 5:05 PM >To: Multiple recipients of list ORACLE-L > > >buy a better i/o subsystem? this should finish in single digit minutes, at >worst. > >ok, can't do that? > >then > >tune the i/o system >can't? >ok, then partition the table/index to faster/more/different drives >can't? >ok, then run the analyze at night via cron >can't >ok, then screw it, it's not worth it. ( just kidding ) > >-Original Message- >Sent: Tuesday, June 12, 2001 5:31 PM >To: Multiple recipients of list ORACLE-L > > >Hi folks; > We have an Analyze running that is taking forever. Here is the setup: >The table is about 250 bytes wide. >The table is normally 100,000 rows >The table has grown to over 4,000,000 rows. >There is one index on 1 column. >We used the Compute Statistics options > >Does anyone have any suggestions on how we can get this analyze to complete >and still generate worthwile statistics ?? > >Thanks > >Kevin > >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: Paul Drake > INET: [EMAIL PROTECTED] > >Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 >San Diego, California-- Public Internet access / Mailing Lists > >To REMOVE yourself from this mailing list, send an E-Mail message >to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in >the message BODY, include a line containing: UNSUB ORACLE-L >(or the name of mailing list you want to be removed from). You may >also send the HELP command for other information (like subscribing). _ Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Christopher Spence INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Pin a CPU in Solaris
I'm not sure of the context of this question, but I'll assume it isn't a joke ;-) I don't think this is what you are really asking, but I'll offer it up anyway. You can bind a particular process to a particular CPU in Solaris with pbind. It does not make for a very good simulation for the reasons already noted. If, for whatever reason, you want to stress a particular CPU, you might try pbind'ing several intense processes to it. Pbind is probably more useful for diagnostics though. I recently had a situation where we were encountering very sporadic "math errors" in one select statement in a Pro*C program running in one 20-CPU domain on an E10K. We isolated the problem to a hardware glitch in one particular CPU that was returning erroneous results from one particular floating point operation - by writing a simple Pro*C test program to loop through the select and then pbind'ing it to each of the CPUs. All but one passed, so we blacklisted that CPU until we could get it replaced. Hence -- "$ man pbind". You will need the process id and the CPU id. -Don Granaman [certifiable OraSaurus] - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Tuesday, June 12, 2001 4:00 PM > Binding processes to CPUs is not at normal, > even in high load situations. > > System scheduler ticks move even busy procs > off CPUs, to go back through the run skedder. > > Yes, of course, the newer/better run scheduler > are aware of register and CPU cache flush issues, > but there is no guarantee a processor under the > default scheduler will own a CPU. Not at all. > > Of course, I could be misunderstanding what you're > trying to test. If you're trying to run a single > CPU benchmark, then YES, you'd want to have ONE and > ONLY ONE processor to run it...no context switches, > no processor swaps...just b*lls to the wall performance. > > But that's not real life, and should not be proferred > as a simulation of it. > > hth > > Hannibal > > -Original Message- > Sent: Tuesday, June 12, 2001 1:41 PM > To: Multiple recipients of list ORACLE-L > > > Does anyone know how to pin a Solaris CPU at a high utilization? I am doing > some testing and want to evaluate a system under a high CPU load. Thanks. > > Erik > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Erik Williams > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Mohan, Ross > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Don Granaman INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Question about many Oracle Data Files
I agree 100% in what your saying, but I think saying "It is really bad to drop tables randomly from production environment" would be a very similar assesmment. If your doing a checkpoint every 15 seconds with 1,000,000 datafiles over 3,500 tablespaces with 10k redo logs, well perhaps the problem isn't the database. "Walking on water and developing software from a specification are easy if both are frozen." Christopher R. Spence Oracle DBA Fuelspot -Original Message- Sent: Tuesday, June 12, 2001 9:15 PM To: Multiple recipients of list ORACLE-L >I beg to differ with this persons assessment. > >Number of datafiles hardly effect performance in any noticable >manor. This >can be noted during checkpoint where high count of data files >check point >with similar efficiency of low number. Christopher, It is not *only* the number of datafiles that affects performance - it is the combination of number of log switches X number of files that is the problem. A reduction in either of these two equals to a low percentage of I/O for file header update vs actual, 'useful' I/O. A small set of redolog files with a large number of files = disaster (which implements itself as sudden occurences of 'database freeze') John Kanagaraj -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Kanagaraj INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Christopher Spence INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Why is db slow after analyze?
If you analyze SYS/SYSTEM you will cripple the performance of the database, namely the table you mentioned and exports. Drop the statsistics as soon as possible off the SYS/SYSTEM objects. This bug was suppose to be fixed in 8.1.7 and existed for some time, I am not sure if it ever got fixed as I have not tested lately. "Walking on water and developing software from a specification are easy if both are frozen." Christopher R. Spence Oracle DBA Fuelspot -Original Message-From: Greg Moore [mailto:[EMAIL PROTECTED]]Sent: Tuesday, June 12, 2001 9:41 PMTo: Multiple recipients of list ORACLE-LSubject: Why is db slow after analyze? I ran dbms_stats.gather_database_stats( ); on a test machine with no other users. After this, running a simple query on dba_extents was extremely slow. Does anyone have an idea on what's the likely cause of this? I'd like to check after gathering stats, but am not sure what to look at to verify why the simple query runs so, so slowly. (Bouncing the db brings things back to normal, but doesn't help me understand what the holdup was.) Thanks.
RE: Digestive
There is a Scottish bar in NYC (St. Andrews) with an REALLY nice selection of single malts. I can't remember the name of the Scotch now (it's one I'd never heard of before), but the waiter persuaded my friend and me to try it. it was a 25 year old single malt. MAJOR YUM!I gotta go back there. Soon. >From: "Mohan, Ross" <[EMAIL PROTECTED]> >Reply-To: [EMAIL PROTECTED] >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> >Subject: RE: Digestive >Date: Tue, 12 Jun 2001 14:33:00 -0800 > >another *excellent* choice. > >if not Glendronach > Glenmorangie >elsif not Glenmorangie > Glenfiddich >elsif not Glenfiddich > Glenlivet >elsif not Glenlivet > JW Black >elsif not JW Black, > JW Red ><...> >end if; > >-Original Message- >Sent: Tuesday, June 12, 2001 6:05 PM >To: Multiple recipients of list ORACLE-L > > >Talking about single malt .. > >My vote goes to Glenfiddich ... anyone? > >Raj >__ >Rajendra Jamadagni MIS, ESPN Inc. >Rajendra dot Jamadagni at ESPN dot com >Any opinion expressed here is personal and doesn't reflect that of ESPN >Inc. > >QOTD: Any clod can have facts, but having an opinion is an art ! > >*4 > >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.com >-- >Author: Jamadagni, Rajendra > INET: [EMAIL PROTECTED] > >Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 >San Diego, California-- Public Internet access / Mailing Lists > >To REMOVE yourself from this mailing list, send an E-Mail message >to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in >the message BODY, include a line containing: UNSUB ORACLE-L >(or the name of mailing list you want to be removed from). You may >also send the HELP command for other information (like subscribing). >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: Mohan, Ross > INET: [EMAIL PROTECTED] > >Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 >San Diego, California-- Public Internet access / Mailing Lists > >To REMOVE yourself from this mailing list, send an E-Mail message >to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in >the message BODY, include a line containing: UNSUB ORACLE-L >(or the name of mailing list you want to be removed from). You may >also send the HELP command for other information (like subscribing). _ Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Forever running Analyze
Paul, They are RAID 4. And WAFL is their own proprietary system and you have very little control over allocation. You don't need to worry about it. (or so the sales rep and engineer said) Rachel >From: Paul Drake <[EMAIL PROTECTED]> >Reply-To: [EMAIL PROTECTED] >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> >Subject: RE: Forever running Analyze >Date: Tue, 12 Jun 2001 15:10:53 -0800 > >Kevin, > >I thought that those are actually RAID 4. >You don't have any control over allocation on a NetApp box? >Is that due to inherent limitations of the volume manager/file systems >or due to implementation specific to your SysAdmins' biases? > >thanks, > >Paul > > >-Original Message- >Sent: Tuesday, June 12, 2001 6:39 PM >To: Multiple recipients of list ORACLE-L > > >New file system is out. We are running on Net App Appliances containing a >Raid 5 system on Solaris using Oracle 8.0.5. Not the best environment but >its what we have to work with. So, hardware is out. > >As far as file system tuning . Another no. Its a Waffle system . >basicly, write anywhere , so where you put the tables and indexes are prety >much a moot point. > >So, we are down to runnig it at night. Not the kind of suggestion I was >looking for but its the one I figured I would hear. > >Oh well. > >Thanks anyway. > >-Original Message- >Sent: Tuesday, June 12, 2001 5:05 PM >To: Multiple recipients of list ORACLE-L > > >buy a better i/o subsystem? this should finish in single digit minutes, at >worst. > >ok, can't do that? > >then > >tune the i/o system >can't? >ok, then partition the table/index to faster/more/different drives >can't? >ok, then run the analyze at night via cron >can't >ok, then screw it, it's not worth it. ( just kidding ) > >-Original Message- >Sent: Tuesday, June 12, 2001 5:31 PM >To: Multiple recipients of list ORACLE-L > > >Hi folks; > We have an Analyze running that is taking forever. Here is the setup: >The table is about 250 bytes wide. >The table is normally 100,000 rows >The table has grown to over 4,000,000 rows. >There is one index on 1 column. >We used the Compute Statistics options > >Does anyone have any suggestions on how we can get this analyze to complete >and still generate worthwile statistics ?? > >Thanks > >Kevin > >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: Paul Drake > INET: [EMAIL PROTECTED] > >Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 >San Diego, California-- Public Internet access / Mailing Lists > >To REMOVE yourself from this mailing list, send an E-Mail message >to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in >the message BODY, include a line containing: UNSUB ORACLE-L >(or the name of mailing list you want to be removed from). You may >also send the HELP command for other information (like subscribing). _ Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Why is db slow after analyze?
Clarification on my gather_database_stats question: While running the simple query on dba_extents, which should send data flying to the screen, but instead sends the result set in slow, small bursts, I noticed the Solaris CDE performance monitor graphs show CPU is pinned at 100% during the 45 seconds it takes to get the dba_extents data (which normally would come flying back in less than a second.) None of the other performance monitors showed unusual activity. Running the simple query (select segment_name from dba_extents) a second and third time produces the same results -- long run time, CPU pinned at 100%. - Greg - Original Message - From: Greg Moore To: [EMAIL PROTECTED] Sent: Tuesday, June 12, 2001 5:25 PM Subject: Why is db slow after analyze? I ran dbms_stats.gather_database_stats( ); on a test machine with no other users. After this, running a simple query on dba_extents was extremely slow. Does anyone have an idea on what's the likely cause of this? I'd like to check after gathering stats, but am not sure what to look at to verify why the simple query runs so, so slowly. (Bouncing the db brings things back to normal, but doesn't help me understand what the holdup was.) Thanks.
Why is db slow after analyze?
I ran dbms_stats.gather_database_stats( ); on a test machine with no other users. After this, running a simple query on dba_extents was extremely slow. Does anyone have an idea on what's the likely cause of this? I'd like to check after gathering stats, but am not sure what to look at to verify why the simple query runs so, so slowly. (Bouncing the db brings things back to normal, but doesn't help me understand what the holdup was.) Thanks.
RE: Digestive
there's a bottle of that too on my shelf, Christmas present from my junior DBA. Tell me he doesn't know how to bribe his boss properly :) >From: "Shaw, John B" <[EMAIL PROTECTED]> >Reply-To: [EMAIL PROTECTED] >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> >Subject: RE: Digestive >Date: Tue, 12 Jun 2001 14:05:15 -0800 > >The Macallan 12 year old >Described by Paul Pacult, the renowned international whisky writer, in his >book Kindred Spirits as: "simply the best 12 Year Old single malt around", >The Macallan has justly reaped such critical acclaim. The secret of The >Macallan lies in defiant adherence to traditional methods and ingredients. >The continued use of finest Golden Promise barley and the insistence on oak >sherry casks from Spain are just two of the pre-requisites for perfection. > > >-Original Message- >Sent: Tuesday, June 12, 2001 4:31 PM >To: Multiple recipients of list ORACLE-L > > >Glenmorangie 12 year old oh yum > > > > >From: Jared Still <[EMAIL PROTECTED]> > >Reply-To: [EMAIL PROTECTED] > >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > >Subject: Re: Digestive > >Date: Tue, 12 Jun 2001 12:53:43 -0800 > > > >On Tuesday 12 June 2001 12:33, Thater, William wrote: > > > > > > single malt RULES!;-) > > > >Well, yeah, I like that too. > > > >I have some 16 yr old Lagavulin ( spelling? ) in the > >pantry that is just awesome. Fine smokey flavor from > >aging in Oak Brandy barrels. ( Or sherry, I'll have to check ) > > > >Jared > >-- > >Please see the official ORACLE-L FAQ: http://www.orafaq.com > >-- > >Author: Jared Still > > INET: [EMAIL PROTECTED] > > > >Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > >San Diego, California-- Public Internet access / Mailing Lists > > > >To REMOVE yourself from this mailing list, send an E-Mail message > >to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > >the message BODY, include a line containing: UNSUB ORACLE-L > >(or the name of mailing list you want to be removed from). You may > >also send the HELP command for other information (like subscribing). > >_ >Get your FREE download of MSN Explorer at http://explorer.msn.com > >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: Rachel Carmichael > INET: [EMAIL PROTECTED] > >Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 >San Diego, California-- Public Internet access / Mailing Lists > >To REMOVE yourself from this mailing list, send an E-Mail message >to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in >the message BODY, include a line containing: UNSUB ORACLE-L >(or the name of mailing list you want to be removed from). You may >also send the HELP command for other information (like subscribing). >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: Shaw, John B > INET: [EMAIL PROTECTED] > >Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 >San Diego, California-- Public Internet access / Mailing Lists > >To REMOVE yourself from this mailing list, send an E-Mail message >to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in >the message BODY, include a line containing: UNSUB ORACLE-L >(or the name of mailing list you want to be removed from). You may >also send the HELP command for other information (like subscribing). _ Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: logminer in the 9i world, etc
well i'm basing my statement on the docs(which isn't much i know) but as soon as its on a platform i can use, i'll tets it out and let everyone know for sure :) joe > Nick Wagner wrote: > > Either way... I tried it with 9.0.0.0.0 beta 3 and I got the normal > DML to work just fine. However I could not get the DDL to work.. I > set the parameters just like the doc says, but all my DDL queries just > seamed to go out to lunch on me... > > My log files were very small for the testing... 5 MB files, and I > only did 3 DDL statements... > > anyone else have this problem. > > Nick > > -Original Message- > From: MacGregor, Ian A. [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, June 12, 2001 3:57 PM > To: Multiple recipients of list ORACLE-L > Subject: RE: logminer in the 9i world, etc > > The question should be, "Can it undo DDL?" > > Ian MacGregor > Stanford Linear Accelerator Center > [EMAIL PROTECTED] > > -Original Message- > Sent: Tuesday, June 12, 2001 1:19 PM > To: Multiple recipients of list ORACLE-L > > Can it redo DDL? > > Alex Hillman > > -Original Message- > Sent: Tuesday, June 12, 2001 3:52 PM > To: Multiple recipients of list ORACLE-L > > Well afetr reading the docs about logminer in version 9i, maybe i can > get > one more year worth of presentation out of it. > > it tracks and displays DDL :) > > useless trivia question(i know the answer) :) > > So what do you get with the new datatype: timestamp > > Joe > > _ > Get your FREE download of MSN Explorer at http://explorer.msn.com > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Joseph Testa > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Hillman, Alex > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: MacGregor, Ian A. > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). -- Joe Testa http://www.oracle-dba.com Performing Remote DBA Services, need some backup DBA support? For Sale: Oracle-dba.com domain, its not going cheap but feel free to ask :) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joseph S. Testa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Question about many Oracle Data Files
>I beg to differ with this persons assessment. > >Number of datafiles hardly effect performance in any noticable >manor. This >can be noted during checkpoint where high count of data files >check point >with similar efficiency of low number. Christopher, It is not *only* the number of datafiles that affects performance - it is the combination of number of log switches X number of files that is the problem. A reduction in either of these two equals to a low percentage of I/O for file header update vs actual, 'useful' I/O. A small set of redolog files with a large number of files = disaster (which implements itself as sudden occurences of 'database freeze') John Kanagaraj -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Kanagaraj INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: check file size, extension question???
If you are using korn shell, then why spawn a new process to do this. Try:
a="somefile.gz"
if [ "$a" != "${a%.gz}" ] ; then
echo "this is a gz file"
elif [ "$a" != "${a%.z}" ] ; then
echo "this is a z file"
else
echo "I don't know"
fi
You could also do this...
a="somefile.gz"
SUFFIX=".${a#*\.}"
FILE="${a%$SUFFIX}"
echo "$a $FILE $SUFFIX"
Ron.
cspence@FuelS
pot.com To: [EMAIL PROTECTED]
Sent by: cc:
root@fatcity.Subject: RE: check file size, extension
question???
com
06/12/01
05:38 PM
Please
respond to
ORACLE-L
I will beat Jared to this, What about using Perl?
"Walking on water and developing software from a specification are easy if
both are frozen."
Christopher R. Spence
Oracle DBA
Fuelspot
-Original Message-
Sent: Tuesday, June 12, 2001 7:58 PM
To: Multiple recipients of list ORACLE-L
Hi, all
I'm writing some auto backup/refresh script, do you
know any command that returns only size or extenstion
or a file? (there will be only one file in the
directory)
I know awk can return only a part of the output, but
somehow I cann't combine awk and ls -l successfully.
ls -s returns some size I don't want, I'd like to have
size as shown in ls -l.
For the refresh script, I like to check file
extension, so if it's in gz, I'll gunzip; if it's Z,
I'll uncompress.
Thanks!
Andrea
__
Do You Yahoo!?
Get personalized email addresses from Yahoo! Mail - only $35
a year! http://personal.mail.yahoo.com/
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Andrea Oracle
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Christopher Spence
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Ron Thomas
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other informat
Oracle DBA Needed in Peoria, IL..
*Description: Peoria, IL company needs an Oracle DBA with Unix experience to join its' I.T. team. This position will have typical DBA responsibilities i.e.: physical database design, installations,performance analysis, system tuning, backup, recovery, etc. This is a full time staff position. No sub-contractors please. * Requirements: - 3+ yrs Oracle DBA experience. - Unix - U.S. Citizenship or permanent residency This position offers: * Opportunity to become a key member of the team * Compensation up to 70K.. D.O.E. * Challenge * Relocation Assistance NO sub contracting positions available. *U.S. citizenship or green card holders only PLEASE do not send your resume if you are not in the United States. For immediate consideration, please send your resume as an attachment to: OraStaff, Inc. Ph: 1-800-549-8502-Please do not call if you need sponsorship Email: [EMAIL PROTECTED] Please use job code: One/DBA/Peoria/Diane Note: This is only one of the many opportunities that we have available across the U.S. for candidates with Oracle skills who are U.S. citizens or permanent residents. So if this one is not a match for you, we invite you to send us your resume- as we quite possibly have the opportunity that you are seeking. We pay referral fees. So please contact me if you know of anyone who would be qualified/interested in the posiition described above- if it is not a match for you. Thanks, Bill Law -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: OraStaff INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: check file size, extension question???
I will beat Jared to this, What about using Perl? "Walking on water and developing software from a specification are easy if both are frozen." Christopher R. Spence Oracle DBA Fuelspot -Original Message- Sent: Tuesday, June 12, 2001 7:58 PM To: Multiple recipients of list ORACLE-L Hi, all I'm writing some auto backup/refresh script, do you know any command that returns only size or extenstion or a file? (there will be only one file in the directory) I know awk can return only a part of the output, but somehow I cann't combine awk and ls -l successfully. ls -s returns some size I don't want, I'd like to have size as shown in ls -l. For the refresh script, I like to check file extension, so if it's in gz, I'll gunzip; if it's Z, I'll uncompress. Thanks! Andrea __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail - only $35 a year! http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Andrea Oracle INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Christopher Spence INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: logminer in the 9i world, etc
Title: RE: logminer in the 9i world, etc Either way... I tried it with 9.0.0.0.0 beta 3 and I got the normal DML to work just fine. However I could not get the DDL to work.. I set the parameters just like the doc says, but all my DDL queries just seamed to go out to lunch on me... My log files were very small for the testing... 5 MB files, and I only did 3 DDL statements... anyone else have this problem. Nick -Original Message- From: MacGregor, Ian A. [mailto:[EMAIL PROTECTED]] Sent: Tuesday, June 12, 2001 3:57 PM To: Multiple recipients of list ORACLE-L Subject: RE: logminer in the 9i world, etc The question should be, "Can it undo DDL?" Ian MacGregor Stanford Linear Accelerator Center [EMAIL PROTECTED] -Original Message- Sent: Tuesday, June 12, 2001 1:19 PM To: Multiple recipients of list ORACLE-L Can it redo DDL? Alex Hillman -Original Message- Sent: Tuesday, June 12, 2001 3:52 PM To: Multiple recipients of list ORACLE-L Well afetr reading the docs about logminer in version 9i, maybe i can get one more year worth of presentation out of it. it tracks and displays DDL :) useless trivia question(i know the answer) :) So what do you get with the new datatype: timestamp Joe _ Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joseph Testa INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hillman, Alex INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: MacGregor, Ian A. INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Forever running Analyze
Analyze estimate with 10% sample, alternatively analyze compute during off-hours, if possible. Most of my "million row" club tables get maintained only on weekends, or in pre-scheduled intervals. Gary WeberSenior DBACharles Jones, LLC609-530-1144, ext 5529 -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Kevin LangeSent: Tuesday, June 12, 2001 5:31 PMTo: Multiple recipients of list ORACLE-LSubject: Forever running Analyze Hi folks; We have an Analyze running that is taking forever. Here is the setup: The table is about 250 bytes wide. The table is normally 100,000 rows The table has grown to over 4,000,000 rows. There is one index on 1 column. We used the Compute Statistics options Does anyone have any suggestions on how we can get this analyze to complete and still generate worthwile statistics ?? Thanks Kevin
RE: apology
I think it's the last thing Dan Quayle said before he lost his job as Vice President. --Walt Weaver Bozeman, Montana, USA -Original Message- Sent: Tuesday, June 12, 2001 4:05 PM To: Multiple recipients of list ORACLE-L 'The Soviet Union does not exist any more in its present format'. What is that suppose to mean? Just curious... -Original Message- Sent: Tuesday, June 12, 2001 5:31 PM To: Multiple recipients of list ORACLE-L On Tue, 12 Jun 2001,Thater, William scribbled on the wall in glitter crayon: ->well, i'm jealous. i could use some. my aunt died from breast cancer over the weekend and the funerial was today. oh damn, this was not supposed to go to the list. i'm sorry for bothering everyone with my personal stuff. put it down to lack of single malt.;-) -- Bill "Shrek" Thater Certifiable ORACLE DBA Telergy, Inc.[EMAIL PROTECTED] ~~ You gotta program like you don't need the money, You gotta compile like you'll never get hurt, You gotta run like there's nobody watching, It's gotta come from the heart if you want it to work. ~~ The Soviet Union does not exist any more in its present format. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thater, William INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Weaver, Walt INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Digestive
another *excellent* choice. if not Glendronach Glenmorangie elsif not Glenmorangie Glenfiddich elsif not Glenfiddich Glenlivet elsif not Glenlivet JW Black elsif not JW Black, JW Red <...> end if; -Original Message- Sent: Tuesday, June 12, 2001 6:05 PM To: Multiple recipients of list ORACLE-L Talking about single malt .. My vote goes to Glenfiddich ... anyone? Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art ! *4 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.com -- Author: Jamadagni, Rajendra INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohan, Ross INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Utl_Smtp trouble
did you run caths.sql when you created the data dictionary?
-Original Message-
Sent: Tuesday, June 12, 2001 7:32 PM
To: Multiple recipients of list ORACLE-L
Hi,
I tried to send e-mail with Utl_Smtp package.
At the line c := utl_smtp.open_connection('MySmtpServerAddress.com');
I always get the error message: " Service not available.Utl_Smtp line
83.Utl_Smtp line 344"
What should be wrong?
I tried this at two different customers with 8.1.6 and 8.1.7 versions.
Both customers have internet through ethernet(intranet) connection.
Thank you in advance.
Zsolt Csillag,
Hungary
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Csillag Zsolt
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Paul Drake
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Re: Digestive
> Adding some olive juice to the drink makes it 'dirty'. In the version I heard about, a bartender makes a martini dirty by holding your glass near the edge of the bar and running his hand over the bar once, so that about ten drops of whatever happens to be there end up in your drink. I like your definition better. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Greg Moore INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
real-time scheduler in Solaris?
Folks, Does anyone know how to exploit the real-time scheduler in Solaris? I can only find vague references to this on the web. We're considering using the real-time scheduler for Oracle background processes on our busiest Solaris boxes (that support 2-3k connections). We want to make Unix bias the Oracle background processes for CPU, all other things being equal. We had some consultants suggesting our MTS config wasn't getting the cycles it needed after we called into question their SQL (which is too long a story for me to get into -- I'll begin ranting about big consulting companies. :) Thanks, Steve Steve Austin DBA for Unix-based systems Enterprise Data Center Operations, XO Communications email: [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Austin, Steve S INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Forever running Analyze
Hi Kevin, I use estimate stats with sample 30 percent with some of the large tables (~ 60,000,000 rows). Generated stats are okay. It completes in about 2-3 hours (8.0.6 and 8.1.7 databases). Have you considered estimating stats rather than computing? HTH, Regards, - Kirti Deshpande Verizon Information Services http://www.superpages.com > -Original Message- > From: Kevin Lange [SMTP:[EMAIL PROTECTED]] > Sent: Tuesday, June 12, 2001 4:31 PM > To: Multiple recipients of list ORACLE-L > Subject: Forever running Analyze > > Hi folks; > We have an Analyze running that is taking forever. Here is the setup: > The table is about 250 bytes wide. > The table is normally 100,000 rows > The table has grown to over 4,000,000 rows. > There is one index on 1 column. > We used the Compute Statistics options > > Does anyone have any suggestions on how we can get this analyze to > complete and still generate worthwile statistics ?? > > Thanks > > Kevin -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deshpande, Kirti INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
check file size, extension question???
Hi, all I'm writing some auto backup/refresh script, do you know any command that returns only size or extenstion or a file? (there will be only one file in the directory) I know awk can return only a part of the output, but somehow I cann't combine awk and ls -l successfully. ls -s returns some size I don't want, I'd like to have size as shown in ls -l. For the refresh script, I like to check file extension, so if it's in gz, I'll gunzip; if it's Z, I'll uncompress. Thanks! Andrea __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail - only $35 a year! http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Andrea Oracle INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Forever running Analyze
Waffle file system goes by the theory of writing anywhere it pleases, it also will not modify blocks directly unless there are no blocks available. Saving them for doing snapshots and quick recovery. NetApp uses Raid 5 pretty religiously, but has a write-back NVRAM that is placed very early in the transaction process to speed response time. If I remember correctly it does not support Pre-fetch or any of the nicer EMC features as such as that. "Walking on water and developing software from a specification are easy if both are frozen." Christopher R. Spence Oracle DBA Fuelspot -Original Message- Sent: Tuesday, June 12, 2001 7:11 PM To: Multiple recipients of list ORACLE-L Kevin, I thought that those are actually RAID 4. You don't have any control over allocation on a NetApp box? Is that due to inherent limitations of the volume manager/file systems or due to implementation specific to your SysAdmins' biases? thanks, Paul -Original Message- Sent: Tuesday, June 12, 2001 6:39 PM To: Multiple recipients of list ORACLE-L New file system is out. We are running on Net App Appliances containing a Raid 5 system on Solaris using Oracle 8.0.5. Not the best environment but its what we have to work with. So, hardware is out. As far as file system tuning . Another no. Its a Waffle system . basicly, write anywhere , so where you put the tables and indexes are prety much a moot point. So, we are down to runnig it at night. Not the kind of suggestion I was looking for but its the one I figured I would hear. Oh well. Thanks anyway. -Original Message- Sent: Tuesday, June 12, 2001 5:05 PM To: Multiple recipients of list ORACLE-L buy a better i/o subsystem? this should finish in single digit minutes, at worst. ok, can't do that? then tune the i/o system can't? ok, then partition the table/index to faster/more/different drives can't? ok, then run the analyze at night via cron can't ok, then screw it, it's not worth it. ( just kidding ) -Original Message- Sent: Tuesday, June 12, 2001 5:31 PM To: Multiple recipients of list ORACLE-L Hi folks; We have an Analyze running that is taking forever. Here is the setup: The table is about 250 bytes wide. The table is normally 100,000 rows The table has grown to over 4,000,000 rows. There is one index on 1 column. We used the Compute Statistics options Does anyone have any suggestions on how we can get this analyze to complete and still generate worthwile statistics ?? Thanks Kevin -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Paul Drake INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Christopher Spence INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: logminer in the 9i world, etc
yes according to the docs. joe "Hillman, Alex" wrote: > > Can it redo DDL? > > Alex Hillman > > -Original Message- > Sent: Tuesday, June 12, 2001 3:52 PM > To: Multiple recipients of list ORACLE-L > > Well afetr reading the docs about logminer in version 9i, maybe i can get > one more year worth of presentation out of it. > > it tracks and displays DDL :) > > useless trivia question(i know the answer) :) > > So what do you get with the new datatype: timestamp > > Joe > > _ > Get your FREE download of MSN Explorer at http://explorer.msn.com > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Joseph Testa > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Hillman, Alex > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing) -- Joe Testa http://www.oracle-dba.com Performing Remote DBA Services, need some backup DBA support? For Sale: Oracle-dba.com domain, its not going cheap but feel free to ask :) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joseph S. Testa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Forever running Analyze
I am hoping that things might work. This is one of our posibilities tonite. I have just always stayed clear of Estimating statistics. But, thanks for the numbers. I will consider it. Kevin -Original Message- Sent: Tuesday, June 12, 2001 4:34 PM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Hi Kevin, I use estimate stats with sample 30 percent with some of the large tables (~ 60,000,000 rows). Generated stats are okay. It completes in about 2-3 hours (8.0.6 and 8.1.7 databases). Have you considered estimating stats rather than computing? HTH, Regards, - Kirti Deshpande Verizon Information Services http://www.superpages.com > -Original Message- > From: Kevin Lange [SMTP:[EMAIL PROTECTED]] > Sent: Tuesday, June 12, 2001 4:31 PM > To: Multiple recipients of list ORACLE-L > Subject: Forever running Analyze > > Hi folks; > We have an Analyze running that is taking forever. Here is the setup: > The table is about 250 bytes wide. > The table is normally 100,000 rows > The table has grown to over 4,000,000 rows. > There is one index on 1 column. > We used the Compute Statistics options > > Does anyone have any suggestions on how we can get this analyze to > complete and still generate worthwile statistics ?? > > Thanks > > Kevin -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kevin Lange INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Digestive
Talking about single malt .. My vote goes to Glenfiddich ... anyone? Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art ! *4 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.com -- Author: Jamadagni, Rajendra INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Question about many Oracle Data Files
I beg to differ with this persons assessment. Number of datafiles hardly effect performance in any noticable manor. This can be noted during checkpoint where high count of data files check point with similar efficiency of low number. Granted, having 1000 128k data files wouldn't be efficient. Reasonability on creating datafiles has never posed performance problems I have noticed. But in short, yes of course there will be some increased time at checkpoint with more datafiles, it is only common sense, but the time it takes to update the SCN in the header is so small in comparison of the time it takes to write out the dirty blocks. "Walking on water and developing software from a specification are easy if both are frozen." Christopher R. Spence Oracle DBA Fuelspot -Original Message- Sent: Monday, June 11, 2001 2:16 PM To: Multiple recipients of list ORACLE-L All, Awhile back, on the "other" list, there was a discussion regarding the number of data files that an Oracle database might contain. Someone posted a warning that too many data files might actually hurt performance in that it might inflate the amount of work to be done at SCN update time. How would I test this? What "wait value" might be too high to indicate that this is taking too long? I am not having an immediate problem, but know of a group that might be. thanks for any help Tom Mercadante Oracle Certified Professional -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Christopher Spence INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: OT - SSN( Enforced Constraints (sic) ??
except check out the ssn faq and alot of those numbers are not used. joe PS: http://www.faqs.org/faqs/privacy/ssn-faq/ Regina Harter wrote: > > When the DMV first asked for my SSN, I gave them an incorrect one, because > as far as I'm concerned they don't need to know it. Now that they actually > check the number with the SSA I was forced to correct it. Most places are > forbidden to require that you supply your SSN unless they need it to report > taxable earnings. I regularly refuse to supply mine. > > At 10:58 AM 6/12/01 -0800, you wrote: > >It's interesting that SSNs are not recycled. My mother works for the SSA > >and says they are after the person is deceased for a certain period of time > >(I forget the specifics). Also, a lot of people get nervous when you use > >their SSN for an identifier. I've noticed that most State Driver's Licenses > >do not use the SSN at the license number anymore because people were getting > >their identities stolen. The same thing goes for having it printed > >permanently on your checks. > > > >Let's calculate quickly on this one: > > > >250,000,000 million in the U.S. (Legal) > >999,999,999 possible numbers (xxx-xx-) > >- > >equals mandatory recycling. > > > >--Michael > > > >-Original Message- > >[mailto:[EMAIL PROTECTED]] > >Sent: Tuesday, June 12, 2001 2:18 PM > >To: Multiple recipients of list ORACLE-L > > > > > > > >There is also a problem with SSNs, if you deal with Foreign nationals. > >We had that problem with a US Army program in Europe and Korea. > >We had to make up Unique numbers to fit the program. > > > >Georgette > > > >-Original Message- > >Sent: Tuesday, June 12, 2001 12:41 > >To: Multiple recipients of list ORACLE-L > > > > > >SSN's are not recycled. > > > > >From the SSA OIG's testimony on SSN use and misuse before congress - > > > > "The SSN is a unique identifier" > > > > http://www.ssa.gov/oig/Testimony05222001.htm > > > > SSN is a perfectly good PK for personnel systems. If you find duplicates > > your employer certainly needs to know about it. > > > > I once had a personnel database with 25 years of personnel data (about > > 1,200,000 individuals). When we loaded it into Oracle with the SSN as PK, > > there was one duplicate SSN. Of course, that employer was very > > conscientious about requiring a valid SSN. > > > > > > > > > > > > > > > > > > > >-- > >Please see the official ORACLE-L FAQ: http://www.orafaq.com > >-- > >Author: > > INET: [EMAIL PROTECTED] > > > >Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > >San Diego, California-- Public Internet access / Mailing Lists > > > >To REMOVE yourself from this mailing list, send an E-Mail message > >to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > >the message BODY, include a line containing: UNSUB ORACLE-L > >(or the name of mailing list you want to be removed from). You may > >also send the HELP command for other information (like subscribing). > >-- > >Please see the official ORACLE-L FAQ: http://www.orafaq.com > >-- > >Author: Cornio, Georgette Ms USACFSC > > INET: [EMAIL PROTECTED] > > > >Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > >San Diego, California-- Public Internet access / Mailing Lists > > > >To REMOVE yourself from this mailing list, send an E-Mail message > >to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > >the message BODY, include a line containing: UNSUB ORACLE-L > >(or the name of mailing list you want to be removed from). You may > >also send the HELP command for other information (like subscribing). > >-- > >Please see the official ORACLE-L FAQ: http://www.orafaq.com > >-- > >Author: Jenkins, Michael > > INET: [EMAIL PROTECTED] > > > >Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > >San Diego, California-- Public Internet access / Mailing Lists > > > >To REMOVE yourself from this mailing list, send an E-Mail message > >to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > >the message BODY, include a line containing: UNSUB ORACLE-L > >(or the name of mailing list you want to be removed from). You may > >also send the HELP command for other information (like subscribing). > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Regina Harter > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in >
RE: Forever running Analyze
if you cannot do the oracle "assessed estimate" of 3GB/hour then perhaps the IO system is in need of modification or replacement. "Walking on water and developing software from a specification are easy if both are frozen." Christopher R. Spence Oracle DBA Fuelspot -Original Message-From: Mohan, Ross [mailto:[EMAIL PROTECTED]]Sent: Tuesday, June 12, 2001 6:05 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Forever running Analyze buy a better i/o subsystem? this should finish in single digit minutes, at worst. ok, can't do that? then tune the i/o system can't? ok, then partition the table/index to faster/more/different drives can't? ok, then run the analyze at night via cron can't ok, then screw it, it's not worth it. ( just kidding ) -Original Message-From: Kevin Lange [mailto:[EMAIL PROTECTED]]Sent: Tuesday, June 12, 2001 5:31 PMTo: Multiple recipients of list ORACLE-LSubject: Forever running Analyze Hi folks; We have an Analyze running that is taking forever. Here is the setup: The table is about 250 bytes wide. The table is normally 100,000 rows The table has grown to over 4,000,000 rows. There is one index on 1 column. We used the Compute Statistics options Does anyone have any suggestions on how we can get this analyze to complete and still generate worthwile statistics ?? Thanks Kevin
RE: How to re-arrange the nullable columns
There are reasons of storage/performance that simply creating a view will not address. "Walking on water and developing software from a specification are easy if both are frozen." Christopher R. Spence Oracle DBA Fuelspot -Original Message- Sent: Tuesday, June 12, 2001 12:12 PM To: Multiple recipients of list ORACLE-L If its for application developers ease in INSERT etc. then how about creating a view which has columns in proper order? -Rahul - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Tuesday, June 12, 2001 8:45 AM > Hi DBA's, > > Greetings... > > In some of application tables, i found not null columns are appeared at the > last. > > So, how can i re-arrange by the way i can make the not null columns are in > the earliest of the table. > > Is the only way to re-create the tables accordingly, or any other best > methods are there?. > > Thanks. > > Regards, > Nirmal. > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Nirmal Kumar Muthu Kumaran > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rahul Dandekar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Christopher Spence INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: logminer in the 9i world, etc
Linda, yes list admin send her a prize :) joe "Seley, Linda" wrote: > > Oh oh, wild guess milliseconds? > > -Original Message- > Sent: Tuesday, June 12, 2001 4:05 PM > To: Multiple recipients of list ORACLE-L > > yes, except that i'm one of those sick pups that reads the docs. > > joe > "Thater, William" wrote: > > > > On Tue, 12 Jun 2001,Joseph Testa scribbled on the wall in glitter crayon: > > > > ->Well afetr reading the docs about logminer in version 9i, maybe i can > get > > ->one more year worth of presentation out of it. > > -> > > ->it tracks and displays DDL :) > > -> > > -> > > ->useless trivia question(i know the answer) :) > > -> > > -> > > ->So what do you get with the new datatype: timestamp > > > > bored?;-) > > > > -- > > Bill "Shrek" Thater Certifiable ORACLE DBA > > Telergy, Inc.[EMAIL PROTECTED] > > ~~ > > You gotta program like you don't need the money, > > You gotta compile like you'll never get hurt, > > You gotta run like there's nobody watching, > > It's gotta come from the heart if you want it to work. > > ~~ > > The Soviet Union does not exist any more in its present format. > > > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > -- > > Author: Thater, William > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > > San Diego, California-- Public Internet access / Mailing Lists > > > > To REMOVE yourself from this mailing list, send an E-Mail message > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > > the message BODY, include a line containing: UNSUB ORACLE-L > > (or the name of mailing list you want to be removed from). You may > > also send the HELP command for other information (like subscribing) > > -- > Joe Testa http://www.oracle-dba.com > Performing Remote DBA Services, need some backup DBA support? > For Sale: Oracle-dba.com domain, its not going cheap but feel free to > ask:) > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Joseph S. Testa > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > -- Joe Testa http://www.oracle-dba.com Performing Remote DBA Services, need some backup DBA support? For Sale: Oracle-dba.com domain, its not going cheap but feel free to ask :) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joseph S. Testa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: How to re-arrange the nullable columns
If a row takes more storage, wouldn't it be safe to say it is slower than one of less storage? "Walking on water and developing software from a specification are easy if both are frozen." Christopher R. Spence Oracle DBA Fuelspot -Original Message- Sent: Tuesday, June 12, 2001 1:28 PM To: Multiple recipients of list ORACLE-L Yeah, Perfomance wise there is no benefit(if yes pls correct me), But i read in manuals as, if the not null columns were resided as a last column of a table, then it consumes more storage space then the other case. Any one have any suggestions regarding this issue Regards, Nirmal. > -Original Message- > From: William Beilstein [SMTP:[EMAIL PROTECTED]] > Sent: Tuesday, June 12, 2001 6:01 PM > To: Multiple recipients of list ORACLE-L > Subject: Re: How to re-arrange the nullable columns > > It makes no difference in performance where the not null columns are > placed. Why do you want to go to the headache of modifying the table > structure for something so trivial? > > >>> [EMAIL PROTECTED] 06/12/01 08:45AM >>> > Hi DBA's, > > Greetings... > > In some of application tables, i found not null columns are appeared at > the > last. > > So, how can i re-arrange by the way i can make the not null columns are > in > the earliest of the table. > > Is the only way to re-create the tables accordingly, or any other best > methods are there?. > > Thanks. > > Regards, > Nirmal. > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Nirmal Kumar Muthu Kumaran > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: William Beilstein > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nirmal Kumar Muthu Kumaran INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Christopher Spence INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Utl_Smtp trouble
Hi,
I tried to send e-mail with Utl_Smtp package.
At the line c := utl_smtp.open_connection('MySmtpServerAddress.com');
I always get the error message: " Service not available.Utl_Smtp line
83.Utl_Smtp line 344"
What should be wrong?
I tried this at two different customers with 8.1.6 and 8.1.7 versions.
Both customers have internet through ethernet(intranet) connection.
Thank you in advance.
Zsolt Csillag,
Hungary
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Csillag Zsolt
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
RE: OT - 9i DB for HP-UX Available On Technet
And what happens when HP gets out of the software market as they have stated they intended on doing? "Walking on water and developing software from a specification are easy if both are frozen." Christopher R. Spence Oracle DBA Fuelspot -Original Message- Sent: Tuesday, June 12, 2001 1:41 PM To: Multiple recipients of list ORACLE-L At one point in time (96-98), I remember Digital Unix (OSF) used to be the platform of choice for Oracle. I recently had an interview at some place and the guy was telling me that all the HA stuff comes out for HP first since they're supposed to be a more reliable platform than Sun. It sounds like the intial release platform might be changing to HP. --- [EMAIL PROTECTED] wrote: > Listers, > > Since there was some discussion about the next > platform on which 9i might be > released, I thought some might be interested in > knowing that 9i for HP-UX is > now available on TechNet. > > Regards, > > Larry G. Elkins > [EMAIL PROTECTED] > > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > -- > Author: > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: > (858) 538-5051 > San Diego, California-- Public Internet > access / Mailing Lists > > To REMOVE yourself from this mailing list, send an > E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of > 'ListGuru') and in > the message BODY, include a line containing: UNSUB > ORACLE-L > (or the name of mailing list you want to be removed > from). You may > also send the HELP command for other information > (like subscribing). __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail - only $35 a year! http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: mohammed bhatti INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Christopher Spence INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Job search on this list
I think you already have, so does it matter? "Walking on water and developing software from a specification are easy if both are frozen." Christopher R. Spence Oracle DBA Fuelspot -Original Message- Sent: Tuesday, June 12, 2001 6:33 PM To: Multiple recipients of list ORACLE-L All, I hate interrupting all the scrumptious, gastronomic activity going on today, but... How much of a no-no is it to use this list to declare myself officially almost- unemployed and looking for work? The way I figure it is that if one does this regularly and uses this board as a free advertising forum, that would be bad, but to let everyone know that the writing is on the wall, in bold, and I'll consider all offers for food would be ok. Since that's how I figure it, here goes: For rent or sale: one 15-year Oracle dba / engineer / architect, with certification. Market-rate to possibly pricey, communicates very well, and can (usually) make the database sing. For details, contact Yosi Greenfield at [EMAIL PROTECTED] (for a LIMITED time!), or at [EMAIL PROTECTED] Any offers of employment will be considered - possibly gasped at with a look of horror, but considered. Any offers of food will be queued until the offers of employment run out. Ok y'all, really now, if anybody's got a need or a lead, lemme know. MUCH thanks, Yosi Yosi Greenfield [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Christopher Spence INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: logminer in the 9i world, etc
Paul, it didnt get picked up for the IOUG live 2001. I've bored the local user group to death with logminer(as well as alot of other people i'm sure). I'll make sure you get you a copy of it in jul. joe Paul Drake wrote: > > Joe, > > I didn't get to see the advanced logminer presentation at IOUG-A. > - is that one 201? > - any chance of seeing it at your user group meeting in July? > - does it exist in print anywhere? > > Paul > > -Original Message- > Sent: Tuesday, June 12, 2001 6:05 PM > To: Multiple recipients of list ORACLE-L > > Hey Joe, > Will that be Logminer 102 or 103 ? > > Do I need to bring Miner's uniform (the hat and all) ? > > Cheers! > > - Kirti > > > -Original Message- > > From: Joseph Testa [SMTP:[EMAIL PROTECTED]] > > Sent: Tuesday, June 12, 2001 2:52 PM > > To: Multiple recipients of list ORACLE-L > > Subject: logminer in the 9i world, etc > > > > Well afetr reading the docs about logminer in version 9i, maybe i can get > > one more year worth of presentation out of it. > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Deshpande, Kirti > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > -- Joe Testa http://www.oracle-dba.com Performing Remote DBA Services, need some backup DBA support? For Sale: Oracle-dba.com domain, its not going cheap but feel free to ask :) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joseph S. Testa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: getting recursive error, any ideas?
It's due to a trigger. Unfortunately it looks very similar to the error I was getting on the trigger which recorded destructive DDL. The corrected trigger code has been sent in another mail; a close cursor statment was placed incorrectly in the code. Your statement is failing because the program is trying to close a cursor which was not opened. The original mail did have warnings about the code not being thoroughly tested. Ian MacGregor Stanford Linear Accelerator Center [EMAIL PROTECTED] -Original Message- Sent: Tuesday, June 12, 2001 3:05 PM To: Multiple recipients of list ORACLE-L Hi all, I am getting following error while running this statement? any ideas where is it coming from? 1* ALTER TABLE corp.service_cat_rq ADD (location_ind CHAR(1) DEFAULT 'Y') SQL> / ALTER TABLE corp.service_cat_rq ADD (location_ind CHAR(1) DEFAULT 'Y') * ERROR at line 1: ORA-00604: error occurred at recursive SQL level 1 ORA-01001: invalid cursor ORA-06512: at line 40 We are on 8.1.6.2. 64 bit on HP unix 11.0 Oracle8i Enterprise Edition Release 8.1.6.2.0, 64 bit - Producti PL/SQL Release 8.1.6.2.0 - Production CORE8.1.6.0.0 Production TNS for HPUX: Version 8.1.6.2.0 - Production NLSRTL Version 3.4.0.0.0 - Production Thanks for your help. Sandesh -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Naik, Sandesh S INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: MacGregor, Ian A. INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: logminer in the 9i world, etc
The question should be, "Can it undo DDL?" Ian MacGregor Stanford Linear Accelerator Center [EMAIL PROTECTED] -Original Message- Sent: Tuesday, June 12, 2001 1:19 PM To: Multiple recipients of list ORACLE-L Can it redo DDL? Alex Hillman -Original Message- Sent: Tuesday, June 12, 2001 3:52 PM To: Multiple recipients of list ORACLE-L Well afetr reading the docs about logminer in version 9i, maybe i can get one more year worth of presentation out of it. it tracks and displays DDL :) useless trivia question(i know the answer) :) So what do you get with the new datatype: timestamp Joe _ Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joseph Testa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hillman, Alex INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: MacGregor, Ian A. INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: logminer in the 9i world, etc
good question about the logminer version, its probably logminer 9i :) bring the mining hat, batteries will be supplied :) joe "Deshpande, Kirti" wrote: > > Hey Joe, > Will that be Logminer 102 or 103 ? > > Do I need to bring Miner's uniform (the hat and all) ? > > Cheers! > > - Kirti > > > -Original Message- > > From: Joseph Testa [SMTP:[EMAIL PROTECTED]] > > Sent: Tuesday, June 12, 2001 2:52 PM > > To: Multiple recipients of list ORACLE-L > > Subject: logminer in the 9i world, etc > > > > Well afetr reading the docs about logminer in version 9i, maybe i can get > > one more year worth of presentation out of it. > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Deshpande, Kirti > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing) -- Joe Testa http://www.oracle-dba.com Performing Remote DBA Services, need some backup DBA support? For Sale: Oracle-dba.com domain, its not going cheap but feel free to ask :) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joseph S. Testa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Forever running Analyze
Kevin, I thought that those are actually RAID 4. You don't have any control over allocation on a NetApp box? Is that due to inherent limitations of the volume manager/file systems or due to implementation specific to your SysAdmins' biases? thanks, Paul -Original Message- Sent: Tuesday, June 12, 2001 6:39 PM To: Multiple recipients of list ORACLE-L New file system is out. We are running on Net App Appliances containing a Raid 5 system on Solaris using Oracle 8.0.5. Not the best environment but its what we have to work with. So, hardware is out. As far as file system tuning . Another no. Its a Waffle system . basicly, write anywhere , so where you put the tables and indexes are prety much a moot point. So, we are down to runnig it at night. Not the kind of suggestion I was looking for but its the one I figured I would hear. Oh well. Thanks anyway. -Original Message- Sent: Tuesday, June 12, 2001 5:05 PM To: Multiple recipients of list ORACLE-L buy a better i/o subsystem? this should finish in single digit minutes, at worst. ok, can't do that? then tune the i/o system can't? ok, then partition the table/index to faster/more/different drives can't? ok, then run the analyze at night via cron can't ok, then screw it, it's not worth it. ( just kidding ) -Original Message- Sent: Tuesday, June 12, 2001 5:31 PM To: Multiple recipients of list ORACLE-L Hi folks; We have an Analyze running that is taking forever. Here is the setup: The table is about 250 bytes wide. The table is normally 100,000 rows The table has grown to over 4,000,000 rows. There is one index on 1 column. We used the Compute Statistics options Does anyone have any suggestions on how we can get this analyze to complete and still generate worthwile statistics ?? Thanks Kevin -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Paul Drake INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: apology
LOL !!! Kwell and W would have made a fine team - Kirti > -Original Message- > From: Weaver, Walt [SMTP:[EMAIL PROTECTED]] > Sent: Tuesday, June 12, 2001 5:39 PM > To: Multiple recipients of list ORACLE-L > Subject: RE: apology > > I think it's the last thing Dan Quayle said before he lost his job as Vice > President. > > --Walt Weaver > Bozeman, Montana, USA > > -Original Message- > Sent: Tuesday, June 12, 2001 4:05 PM > To: Multiple recipients of list ORACLE-L > > > 'The Soviet Union does not exist any more in its present format'. > > What is that suppose to mean? Just curious... > > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deshpande, Kirti INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Digestive
Macallan 18yr. -Original Message- Sent: Tuesday, June 12, 2001 6:05 PM To: Multiple recipients of list ORACLE-L Talking about single malt .. My vote goes to Glenfiddich ... anyone? Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art ! *4 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.com -- Author: Jamadagni, Rajendra INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Wolfe, Charles INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Forever running Analyze
New file system is out. We are running on Net App Appliances containing a Raid 5 system on Solaris using Oracle 8.0.5. Not the best environment but its what we have to work with. So, hardware is out. As far as file system tuning . Another no. Its a Waffle system . basicly, write anywhere , so where you put the tables and indexes are prety much a moot point. So, we are down to runnig it at night. Not the kind of suggestion I was looking for but its the one I figured I would hear. Oh well. Thanks anyway. -Original Message-From: Mohan, Ross [mailto:[EMAIL PROTECTED]]Sent: Tuesday, June 12, 2001 5:05 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Forever running Analyze buy a better i/o subsystem? this should finish in single digit minutes, at worst. ok, can't do that? then tune the i/o system can't? ok, then partition the table/index to faster/more/different drives can't? ok, then run the analyze at night via cron can't ok, then screw it, it's not worth it. ( just kidding ) -Original Message-From: Kevin Lange [mailto:[EMAIL PROTECTED]]Sent: Tuesday, June 12, 2001 5:31 PMTo: Multiple recipients of list ORACLE-LSubject: Forever running Analyze Hi folks; We have an Analyze running that is taking forever. Here is the setup: The table is about 250 bytes wide. The table is normally 100,000 rows The table has grown to over 4,000,000 rows. There is one index on 1 column. We used the Compute Statistics options Does anyone have any suggestions on how we can get this analyze to complete and still generate worthwile statistics ?? Thanks Kevin
RE: logminer in the 9i world, etc
Oh oh, wild guess milliseconds? -Original Message- Sent: Tuesday, June 12, 2001 4:05 PM To: Multiple recipients of list ORACLE-L yes, except that i'm one of those sick pups that reads the docs. joe "Thater, William" wrote: > > On Tue, 12 Jun 2001,Joseph Testa scribbled on the wall in glitter crayon: > > ->Well afetr reading the docs about logminer in version 9i, maybe i can get > ->one more year worth of presentation out of it. > -> > ->it tracks and displays DDL :) > -> > -> > ->useless trivia question(i know the answer) :) > -> > -> > ->So what do you get with the new datatype: timestamp > > bored?;-) > > -- > Bill "Shrek" Thater Certifiable ORACLE DBA > Telergy, Inc.[EMAIL PROTECTED] > ~~ > You gotta program like you don't need the money, > You gotta compile like you'll never get hurt, > You gotta run like there's nobody watching, > It's gotta come from the heart if you want it to work. > ~~ > The Soviet Union does not exist any more in its present format. > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Thater, William > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing) -- Joe Testa http://www.oracle-dba.com Performing Remote DBA Services, need some backup DBA support? For Sale: Oracle-dba.com domain, its not going cheap but feel free to ask :) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joseph S. Testa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Seley, Linda INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Job search on this list
All, I hate interrupting all the scrumptious, gastronomic activity going on today, but... How much of a no-no is it to use this list to declare myself officially almost- unemployed and looking for work? The way I figure it is that if one does this regularly and uses this board as a free advertising forum, that would be bad, but to let everyone know that the writing is on the wall, in bold, and I'll consider all offers for food would be ok. Since that's how I figure it, here goes: For rent or sale: one 15-year Oracle dba / engineer / architect, with certification. Market-rate to possibly pricey, communicates very well, and can (usually) make the database sing. For details, contact Yosi Greenfield at [EMAIL PROTECTED] (for a LIMITED time!), or at [EMAIL PROTECTED] Any offers of employment will be considered - possibly gasped at with a look of horror, but considered. Any offers of food will be queued until the offers of employment run out. Ok y'all, really now, if anybody's got a need or a lead, lemme know. MUCH thanks, Yosi Yosi Greenfield [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Digestive DBA Special
Title: RE: Digestive DBA Special The wearing of the red shirt to hide a bloody wound is usually said of Admiral Nelson. The wearing of brown pants to hide a panicked bowel reaction is not. Ian MacGregor Stanford Linear Accelerator Center [EMAIL PROTECTED] -Original Message-From: Koivu, Lisa [mailto:[EMAIL PROTECTED]]Sent: Tuesday, June 12, 2001 2:19 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Digestive DBA Special DBA Special? Captain Morgan, after the story I heard on this list years ago about the pirate that wore a red shirt so his men couldn't see he was bleeding, and chose special times to wear his brown pants. There have been a few times in my short tenure as a dba when the brown pants were absolutely necessary. Captain is my fav, he improves my golf game and my balance in general :) -Original Message- From: Jared Still [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, June 12, 2001 4:39 PM To: Multiple recipients of list ORACLE-L Subject: Re: Digestive On Tuesday 12 June 2001 13:19, Rajaram wrote: > Did you say Bombay? BTW, what is "Bombay Sapphire dirty Martini" ? Bombay Sapphire Gin. Very good, very smooth, very expensive. Martini and Rossi Extra Dry Vermouth. Pour Gin and Vermouth over ice, amount of vermouth differs according to taste. If you have a shaker, shake the drink with ice, then pour over 3 large spicy green olives. Adding some olive juice to the drink makes it 'dirty'. Adding scotch to it makes it 'smoky'. We should come up with a 'DBA special' variation. :0 Jared > -Original Message- > From: Jared Still [SMTP:[EMAIL PROTECTED]] > Sent: Tuesday, June 12, 2001 4:03 PM > To: Multiple recipients of list ORACLE-L > Subject: Re: Digestive > > > > How about a Bombay Sapphire dirty Martini, straight up, > spicy olives? > > Yum. > > Jared > > On Tuesday 12 June 2001 11:43, Igor Neyman wrote: > > LOL, > > > > May I be more specific: > > > > SET ORACLE-L JIN&TONIC > > > > Igor Neyman, OCP DBA > > Perceptron, Inc. > > (734)414-4627 > > [EMAIL PROTECTED] > > > > > > - Original Message - > > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> > > Sent: Tuesday, June 12, 2001 1:46 PM > > > > > WHY NOT JUST SET ORACLE-L APERITIF? > > > > > > -Original Message- > > > Sent: Tuesday, June 12, 2001 1:27 PM > > > To: Multiple recipients of list ORACLE-L > > > > > > > > > SET ORACLE-L DIGESTIVE > > > > > > = > > > Hamid Alavi > > > 4268 Flintlock LN > > > Westlake Village 91631 > > > PH: 818-8790966 > > > > > > __ > > > Do You Yahoo!? > > > Get personalized email addresses from Yahoo! Mail - only $35 > > > a year! http://personal.mail.yahoo.com/ > > > -- > > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > > -- > > > Author: hamid alavi > > > INET: [EMAIL PROTECTED] > > > > > > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 > > > San Diego, California -- Public Internet access / Mailing Lists > > > > > > To REMOVE yourself from this mailing list, send an E-Mail message > > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > > > the message BODY, include a line containing: UNSUB ORACLE-L > > > (or the name of mailing list you want to be removed from). You may > > > also send the HELP command for other information (like subscribing). > > > -- > > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > > -- > > > Author: Mohan, Ross > > > INET: [EMAIL PROTECTED] > > > > > > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 > > > San Diego, California -- Public Internet access / Mailing Lists > > > > > > To REMOVE yourself from this mailing list, send an E-Mail message > > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > > > the message BODY, include a line containing: UNSUB ORACLE-L > > > (or the name of mailing list you want to be removed from). You may > > > also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yours
RE: logminer in the 9i world, etc
Joe, I didn't get to see the advanced logminer presentation at IOUG-A. - is that one 201? - any chance of seeing it at your user group meeting in July? - does it exist in print anywhere? Paul -Original Message- Sent: Tuesday, June 12, 2001 6:05 PM To: Multiple recipients of list ORACLE-L Hey Joe, Will that be Logminer 102 or 103 ? Do I need to bring Miner's uniform (the hat and all) ? Cheers! - Kirti > -Original Message- > From: Joseph Testa [SMTP:[EMAIL PROTECTED]] > Sent: Tuesday, June 12, 2001 2:52 PM > To: Multiple recipients of list ORACLE-L > Subject: logminer in the 9i world, etc > > Well afetr reading the docs about logminer in version 9i, maybe i can get > one more year worth of presentation out of it. > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deshpande, Kirti INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Paul Drake INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
CORRECTION To: Destructive SQL Trapping "Alter Table Drop Column"
In the trigger I posted I closed the "get_column_name" cursor at the wrong spot. It
worked beautifully for "drops", but
"adds" complained
Here is the corrected code
--
pcolumn_name dba_tab_columns.column_name%type;
cursor get_column_name is
select column_name from dba_tab_columns where
owner = ora_dict_obj_owner and table_name = ora_dict_obj_name;
sql_dummy varchar2(1);
cursor is_drop_column is
select
'x'
from
sys.x$_kglpn p,
sys.x$_kglcursor c,
v$_session s
where
p.kglpnhdl = c.kglhdadr and
p.kglpnses = s.saddr and
instr(lower(replace(c.kglnaobj,' ', null)),'dropcolumn') > 0 and
instr(lower(c.kglnaobj),'select') = 0 and
s.audsid = sys_context('USERENV', 'SESSIONID');
Begin
if (((ora_sysevent = 'DROP') and (ora_dict_obj_type = 'TABLE'))
or ora_sysevent = 'TRUNCATE') and ora_dict_obj_owner != 'SYS' THEN
object_security.record_destructive_ddl(null);
elsif ora_sysevent = 'ALTER' and ora_dict_obj_type = 'TABLE'
and ora_dict_obj_owner != 'SYS' THEN
open is_drop_column;
fetch is_drop_column into sql_dummy;
close is_drop_column;
if sql_dummy = 'x' then
open get_column_name;
loop
fetch get_column_name into pcolumn_name;
exit when get_column_name%notfound;
if ora_is_drop_column(pcolumn_name) then
object_security.record_destructive_ddl(pcolumn_name);
end if;
end loop;
close get_column_name;
end if;
end if;
end;
/
Warning I'm still testing this.
As far as wanting to know whether drop column was issued, I don't want to loop
through all the columns in the table
when a constraint is created, or a column is added, or a column is widened etc. Yes,
my thinking is that its better to check the SQL rather than calling the function
needlessly. But I have not done any performance testing.
I cannot think of any DDL which is issued against the sys owned tables after database
create time, nor a reason for there to be. At one time tables needed to support
certain database options were owned by sys, but I don't think that's true anymore; I
haven't installed every option. If these premises are true, it is better to stop any
DDL against a sys table than to record it, and that's a different trigger. I will
probably remove the exclusion on sys tables from the present trigger to see if any DDL
against them is trapped before writing a trigger which prevents such DDL.
Ian MacGregor
Stanford Linear Accelerator Center
[EMAIL PROTECTED]
Original Message-
[mailto:[EMAIL PROTECTED]]
Sent: Tuesday, June 12, 2001 1:31 PM
To: Multiple recipients of list ORACLE-L
Column"
Thanks for posting this, I have a few questions. Why you need to look at the SQL
statement at all. You already know that the statement is ALTER TABLE, so why not
just check for dropped columns.
if ora_dict_obj_type = 'TABLE' THEN
if ora_dict_obj_type = 'ALTER' THEN
for x in get_column_name loop
if ora_is_drop_column (x.column_name) then
object_security.record_destructive_ddl (x.column_name);
end if;
end loop;
else
...
Is it a performance thing? Is it faster to retrieve the SQL all the time and
only check for dropped columns when you have to?
And Is that also the reason for excluding the SYS schema?
chaim
"MacGregor, Ian A." <[EMAIL PROTECTED]> on 06/11/2001 07:18:21 PM
Please respond to [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:(bcc: Chaim Katz/Completions/Bombardier)
CREATE or replace TRIGGER record_destructive_ddl_trigger before drop or alter
or truncate ON DATABASE
Declare
pcolumn_name dba_tab_columns.column_name%type;
cursor get_column_name is
select column_name from dba_tab_columns where
owner = ora_dict_obj_owner and table_name = ora_dict_obj_name;
sql_dummy varchar2(1);
cursor is_drop_column is
select
'x'
from
sys.x$_kglpn p,
sys.x$_kglcursor c,
v$session s
where
p.kglpnhdl = c.kglhdadr and
p.kglpnses = s.saddr and
instr(lower(replace(c.kglnaobj,' ', null)),'select') = 0 and
instr(lower(replace(c.kglnaobj,' ', null)),'dropcolumn') > 0 and
s.audsid = sys_context('USERENV', 'SESSIONID');
Begin
if (((ora_sysevent = 'DROP') and (ora_dict_obj_type = 'TABLE'))
or ora_sysevent = 'TRUNCATE') and ora_dict_obj_owner != 'SYS' THEN
object_security.record_destructive_ddl(null);
elsif ora_sysevent = 'ALTER' and ora_dict_obj_type = 'TABLE'
and ora_dict_obj_owner != 'SYS' THEN
open is_drop_column;
fetch is_drop_column into sql_dummy;
close
RE: OT - SSN( Enforced Constraints (sic) ??
When the DMV first asked for my SSN, I gave them an incorrect one, because as far as I'm concerned they don't need to know it. Now that they actually check the number with the SSA I was forced to correct it. Most places are forbidden to require that you supply your SSN unless they need it to report taxable earnings. I regularly refuse to supply mine. At 10:58 AM 6/12/01 -0800, you wrote: >It's interesting that SSNs are not recycled. My mother works for the SSA >and says they are after the person is deceased for a certain period of time >(I forget the specifics). Also, a lot of people get nervous when you use >their SSN for an identifier. I've noticed that most State Driver's Licenses >do not use the SSN at the license number anymore because people were getting >their identities stolen. The same thing goes for having it printed >permanently on your checks. > >Let's calculate quickly on this one: > >250,000,000 million in the U.S. (Legal) >999,999,999 possible numbers (xxx-xx-) >- >equals mandatory recycling. > >--Michael > >-Original Message- >[mailto:[EMAIL PROTECTED]] >Sent: Tuesday, June 12, 2001 2:18 PM >To: Multiple recipients of list ORACLE-L > > > >There is also a problem with SSNs, if you deal with Foreign nationals. >We had that problem with a US Army program in Europe and Korea. >We had to make up Unique numbers to fit the program. > >Georgette > >-Original Message- >Sent: Tuesday, June 12, 2001 12:41 >To: Multiple recipients of list ORACLE-L > > >SSN's are not recycled. > > >From the SSA OIG's testimony on SSN use and misuse before congress - > > "The SSN is a unique identifier" > > http://www.ssa.gov/oig/Testimony05222001.htm > > SSN is a perfectly good PK for personnel systems. If you find duplicates > your employer certainly needs to know about it. > > I once had a personnel database with 25 years of personnel data (about > 1,200,000 individuals). When we loaded it into Oracle with the SSN as PK, > there was one duplicate SSN. Of course, that employer was very > conscientious about requiring a valid SSN. > > > > > > > > > >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: > INET: [EMAIL PROTECTED] > >Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 >San Diego, California-- Public Internet access / Mailing Lists > >To REMOVE yourself from this mailing list, send an E-Mail message >to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in >the message BODY, include a line containing: UNSUB ORACLE-L >(or the name of mailing list you want to be removed from). You may >also send the HELP command for other information (like subscribing). >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: Cornio, Georgette Ms USACFSC > INET: [EMAIL PROTECTED] > >Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 >San Diego, California-- Public Internet access / Mailing Lists > >To REMOVE yourself from this mailing list, send an E-Mail message >to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in >the message BODY, include a line containing: UNSUB ORACLE-L >(or the name of mailing list you want to be removed from). You may >also send the HELP command for other information (like subscribing). >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: Jenkins, Michael > INET: [EMAIL PROTECTED] > >Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 >San Diego, California-- Public Internet access / Mailing Lists > >To REMOVE yourself from this mailing list, send an E-Mail message >to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in >the message BODY, include a line containing: UNSUB ORACLE-L >(or the name of mailing list you want to be removed from). You may >also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Regina Harter INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: logminer in the 9i world, etc
yes, except that i'm one of those sick pups that reads the docs. joe "Thater, William" wrote: > > On Tue, 12 Jun 2001,Joseph Testa scribbled on the wall in glitter crayon: > > ->Well afetr reading the docs about logminer in version 9i, maybe i can get > ->one more year worth of presentation out of it. > -> > ->it tracks and displays DDL :) > -> > -> > ->useless trivia question(i know the answer) :) > -> > -> > ->So what do you get with the new datatype: timestamp > > bored?;-) > > -- > Bill "Shrek" Thater Certifiable ORACLE DBA > Telergy, Inc.[EMAIL PROTECTED] > ~~ > You gotta program like you don't need the money, > You gotta compile like you'll never get hurt, > You gotta run like there's nobody watching, > It's gotta come from the heart if you want it to work. > ~~ > The Soviet Union does not exist any more in its present format. > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Thater, William > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing) -- Joe Testa http://www.oracle-dba.com Performing Remote DBA Services, need some backup DBA support? For Sale: Oracle-dba.com domain, its not going cheap but feel free to ask :) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joseph S. Testa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Digestive
On the subject of Scotch ... As the only certified (that I know of) genuine born and bred Scotsman on the list these days (Originally from Glasgow Scotland, and now scraping a living as a Development DBA in Minneapolis MN) I have to say that they are all wonderful, you don't get a bad single malt Scotch ! It's just that some are better than others :-) and of them all, I have to agree with Jared, 16yr old Lagavullin is the best. If you don't like it too peaty , try Jura or Oban - I prefer them slightly peatier. another delightful one is Balvennie and another , Aberlour. If you want something slightly sweeter, try Glengoyne or Glenturret. They are all good. Enjoy , or as we say Slainte Mhath Brian. "Mohan, Ross" <[EMAIL PROTECTED]>@fatcity.com on 06/12/2001 04:18:44 PM Please respond to [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Lagavulin??!?! Yikes, Jared, I am going to revoke my "Soul Brother" license from you. Don't tell me you like "Laphroaig" as well? That peaty sh*t should be used to clean road tar off SUVs. Now, if you're talking a fine Glendronach, you've got my full attention. -Original Message- Sent: Tuesday, June 12, 2001 4:54 PM To: Multiple recipients of list ORACLE-L On Tuesday 12 June 2001 12:33, Thater, William wrote: > > single malt RULES!;-) Well, yeah, I like that too. I have some 16 yr old Lagavulin ( spelling? ) in the pantry that is just awesome. Fine smokey flavor from aging in Oak Brandy barrels. ( Or sherry, I'll have to check ) Jared -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohan, Ross INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: logminer in the 9i world, etc
Hey Joe, Will that be Logminer 102 or 103 ? Do I need to bring Miner's uniform (the hat and all) ? Cheers! - Kirti > -Original Message- > From: Joseph Testa [SMTP:[EMAIL PROTECTED]] > Sent: Tuesday, June 12, 2001 2:52 PM > To: Multiple recipients of list ORACLE-L > Subject: logminer in the 9i world, etc > > Well afetr reading the docs about logminer in version 9i, maybe i can get > one more year worth of presentation out of it. > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deshpande, Kirti INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Forever running Analyze
Couldn't you try and estimate about 50% of it? It's not as reliable, but it would probably work. Kev -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Kevin LangeSent: Tuesday, June 12, 2001 5:31 PMTo: Multiple recipients of list ORACLE-LSubject: Forever running Analyze Hi folks; We have an Analyze running that is taking forever. Here is the setup: The table is about 250 bytes wide. The table is normally 100,000 rows The table has grown to over 4,000,000 rows. There is one index on 1 column. We used the Compute Statistics options Does anyone have any suggestions on how we can get this analyze to complete and still generate worthwile statistics ?? Thanks Kevin
Re: SSN's
Careful about using 999 numbers , the IRS actually use these for non resident taxpayers. (Spouses of H1- B visa holders etc) For all you H1-B's out there, if your H4 other half can't get an SSN, then they must have a number from the INS called a TaxPayer ID number (TIN). Otherwise the banks will withhold 36% of your interest for the IRS. Also when you file your taxes at the end of the year, if your H4 spouse does not have either a SSN or a TIN, the IRS will not allow you to claim any allowances against your taxes for them. Brian. [EMAIL PROTECTED]@fatcity.com on 06/12/2001 02:21:28 PM Please respond to [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: There are two people (or organizations) that you MUST give your SSN to. Your employer - you can't work in the US without an SSN and your employer must ensure that you have a valid SSN. Your Bank - so the IRS can track any financial transactions. Your employer cannot get in trouble for knowing your SSN. I enjoyed the stories about someone getting checks and then the SSA gave him a new SSN from someone who was "really" dead. Someday I'll tell you about my experiences wrangling frogs. Foreign nationals are fun. There is a 10 digit INS number for Green Card holders - but they have no trouble getting an SSN if they're here to work legitimately. Generally, when dealing with people who do not have an SSN you can make one up, just start it with "999-" since real SSNs don't go that high. Also, don't call it an SSN since those people may think that they have been issued an SSN and really get themselves in trouble. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
getting recursive error, any ideas?
Hi all, I am getting following error while running this statement? any ideas where is it coming from? 1* ALTER TABLE corp.service_cat_rq ADD (location_ind CHAR(1) DEFAULT 'Y') SQL> / ALTER TABLE corp.service_cat_rq ADD (location_ind CHAR(1) DEFAULT 'Y') * ERROR at line 1: ORA-00604: error occurred at recursive SQL level 1 ORA-01001: invalid cursor ORA-06512: at line 40 We are on 8.1.6.2. 64 bit on HP unix 11.0 Oracle8i Enterprise Edition Release 8.1.6.2.0, 64 bit - Producti PL/SQL Release 8.1.6.2.0 - Production CORE8.1.6.0.0 Production TNS for HPUX: Version 8.1.6.2.0 - Production NLSRTL Version 3.4.0.0.0 - Production Thanks for your help. Sandesh -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Naik, Sandesh S INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: apology
'The Soviet Union does not exist any more in its present format'. What is that suppose to mean? Just curious... -Original Message- Sent: Tuesday, June 12, 2001 5:31 PM To: Multiple recipients of list ORACLE-L On Tue, 12 Jun 2001,Thater, William scribbled on the wall in glitter crayon: ->well, i'm jealous. i could use some. my aunt died from breast cancer over the weekend and the funerial was today. oh damn, this was not supposed to go to the list. i'm sorry for bothering everyone with my personal stuff. put it down to lack of single malt.;-) -- Bill "Shrek" Thater Certifiable ORACLE DBA Telergy, Inc.[EMAIL PROTECTED] ~~ You gotta program like you don't need the money, You gotta compile like you'll never get hurt, You gotta run like there's nobody watching, It's gotta come from the heart if you want it to work. ~~ The Soviet Union does not exist any more in its present format. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thater, William INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Forever running Analyze
buy a better i/o subsystem? this should finish in single digit minutes, at worst. ok, can't do that? then tune the i/o system can't? ok, then partition the table/index to faster/more/different drives can't? ok, then run the analyze at night via cron can't ok, then screw it, it's not worth it. ( just kidding ) -Original Message-From: Kevin Lange [mailto:[EMAIL PROTECTED]]Sent: Tuesday, June 12, 2001 5:31 PMTo: Multiple recipients of list ORACLE-LSubject: Forever running Analyze Hi folks; We have an Analyze running that is taking forever. Here is the setup: The table is about 250 bytes wide. The table is normally 100,000 rows The table has grown to over 4,000,000 rows. There is one index on 1 column. We used the Compute Statistics options Does anyone have any suggestions on how we can get this analyze to complete and still generate worthwile statistics ?? Thanks Kevin
RE: Digestive
The Macallan 12 year old Described by Paul Pacult, the renowned international whisky writer, in his book Kindred Spirits as: "simply the best 12 Year Old single malt around", The Macallan has justly reaped such critical acclaim. The secret of The Macallan lies in defiant adherence to traditional methods and ingredients. The continued use of finest Golden Promise barley and the insistence on oak sherry casks from Spain are just two of the pre-requisites for perfection. -Original Message- Sent: Tuesday, June 12, 2001 4:31 PM To: Multiple recipients of list ORACLE-L Glenmorangie 12 year old oh yum >From: Jared Still <[EMAIL PROTECTED]> >Reply-To: [EMAIL PROTECTED] >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> >Subject: Re: Digestive >Date: Tue, 12 Jun 2001 12:53:43 -0800 > >On Tuesday 12 June 2001 12:33, Thater, William wrote: > > > > single malt RULES!;-) > >Well, yeah, I like that too. > >I have some 16 yr old Lagavulin ( spelling? ) in the >pantry that is just awesome. Fine smokey flavor from >aging in Oak Brandy barrels. ( Or sherry, I'll have to check ) > >Jared >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: Jared Still > INET: [EMAIL PROTECTED] > >Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 >San Diego, California-- Public Internet access / Mailing Lists > >To REMOVE yourself from this mailing list, send an E-Mail message >to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in >the message BODY, include a line containing: UNSUB ORACLE-L >(or the name of mailing list you want to be removed from). You may >also send the HELP command for other information (like subscribing). _ Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Shaw, John B INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Enforced Costraints ??
You know, no matter how many times I have been told that a certain value is unique, not null, and will never, ever change, and thus should be used as a primary key, there comes a time that someone decides they need to be changed, if only because they were entered wrong in the first place. At 08:06 AM 6/12/01 -0800, you wrote: >If user id is unique, not null, and never will be or will not change, then >no need for surrogate or datetime. >Surrogate keys are great because they are no hassle and easy. They do not >mutate 10 columns of a primary key into other tables everytime you have a >relationship with them. Although as someone brought up, sequences are nasty >things, and they cause a few problems with indexes. > >"Walking on water and developing software from a specification are easy if >both are frozen." > >Christopher R. Spence >Oracle DBA >Fuelspot > > > >-Original Message- >Sent: Tuesday, June 12, 2001 10:42 AM >To: Multiple recipients of list ORACLE-L > > >I have no real solid design experience, but in the current model that I am >working on I created this table... > > AUDIT DENIED LOGONS > >| ADL Userid | >| ADL DateTime | >|| >|| > > >The two columns in the table are the PK. I have been debating back and >forth about this. I wonder if I should remove ADL DateTime from the PK. >Still debating. > >As for a surrogate key, it just didn't seem to need one. Does it? What >for? > >At any rate, DBA stuff is easy compared to design work. I find myself >arguing about every single little detail, it's driving me nuts. > >Any thoughts or arguments or ideas? > >Many thanks. > >Chris > >-Original Message- >Sent: Tuesday, June 12, 2001 10:12 AM >To: Multiple recipients of list ORACLE-L > > >Well, here's one problem - there is no guarantee that Social Security Number >will indeed be unique. SS#'s are reassigned, just like phone numbers are. >IMHO, surrogate keys are always a good idea. Has anyone got an example of >when a surrogate key is NOT a good idea? >Lisa Koivu >Oracle Database Administrator >954-935-4117 >The information in the electronic mail message is Cendant confidential and >may be legally privileged, it is intended solely for the addressee(s) access >to this internet electronic mail message by anyone else is unauthorized. If >you are not the intended recipient, any disclosure, copying, distribution or >any action taken or omitted to be taken in reliance on it is prohibited and >may be unlawful. >The sender believes that this E-mail and any attachments were free of any >virus, worm, Trojan horse, and/or malicious code when sent. This message and >its attachments could have been infected during transmission. By reading the >message and opening any attachments, the recipient accepts full >responsibility for taking protective and remedial action about viruses and >other defects. Cendant Corporation or Affiliates are not liable for any loss >or damage arising in any way from this message or its attachments. > > > >-Original Message- >Sent: Tuesday, June 12, 2001 9:21 AM >To: Multiple recipients of list ORACLE-L >In a DSS environment, it is a standard practice to create surrogate keys for > >primary key. I never had experience with this (having duplicates in PK). >Perhaps a list member could tell what probs might arise. >Rao >-Original Message- >Sent: Tuesday, June 12, 2001 6:26 AM >To: Multiple recipients of list ORACLE-L > > >Not good enough ! According to various documents, you should add your own >primary key (surrogate key), which also makes it easier to keep track of >history and combine various sources. I agree with Lee: you should never >implement a PK with non-unique values. >Remco >-Oorspronkelijk bericht- >Van: Rahul [mailto:[EMAIL PROTECTED]] >Verzonden: dinsdag 12 juni 2001 11:56 >Aan: Multiple recipients of list ORACLE-L >Onderwerp: RE: Enforced Costraints ?? > > >DSS ! > > > > -- > > From: Robertson Lee - lerobe[SMTP:[EMAIL PROTECTED] ] > > Reply To: [EMAIL PROTECTED] > > Sent: Tuesday, June 12, 2001 4:00 PM > > To: Multiple recipients of list ORACLE-L > > Subject: RE: Enforced Costraints ?? > > > > am I missing something here ?? Why would you ever need to be in that > > situation (a table with non-unique values in a PK column) ? > > > > Apologies if this is a no-brainer. > > > > Lee > > > > > > -Original Message- > > Sent: 12 June 2001 09:41 > > To: Multiple recipients of list ORACLE-L > > > > > > i think the solution is to . > > > > (on a table with non-unique values in a PK candidate column) > > > > 1) create a non-unique index on the pk candidate colunm > > 2) create the pk using enable novalidate clause > > > > this way the existing data will NOT checked for uniqueness, the constraint > > > will be "enforced" for the upcoming data only... > > > > Regards > > Rahul > > > > > > > > ---
RE: Help on Upgrade - I'm an idiot
That's what I ended up doing. While I was struggling with it I was told by my boss that the decision was made that we can't install the 8.1.6.3 patch because we only have 8.1.6.2 in QA. So I've killed the database entirely (processes and files) and am now reinstalling 8.1.6 from the beginning to redo the upgrade from the backup. Sigh, late night ahead. -Original Message- Sent: Tuesday, June 12, 2001 4:39 PM To: Multiple recipients of list ORACLE-L There is always the ultimate last resort Jay. If you can not stop the DB any other way you can always kill all of its processes. This is not recommended as a way or normally stopping a DB, but I have used it in the past when I was out of choices. After killing the processes, I brought the DB up a step at a time nomout, shutdown mount , shutdown ... open ... shutdown . Then finally opened it up. I wanted to see how it faired on each step before I commited anything. You might give it a whirl if its your only alternative. Kevin -Original Message- Sent: Tuesday, June 12, 2001 3:12 PM To: Multiple recipients of list ORACLE-L Jay: You may have some semaphore stuff screwed up... (i'm not a UNIX Admin and I don't play one on TV) I ran into this before too. We had to bounce the box to fix the problem. Kevin -Original Message- Sent: Tuesday, June 12, 2001 3:31 PM To: Multiple recipients of list ORACLE-L I'm doing a test upgrade from 8.0.4 to 8.1.6.3. Finished the 8.1.6 upgrade. Was about to do the patch installation when I was called into a meeting then got 2 phone calls (this all kept happening during the upgrade also) and had several people stop by. Finally got back to it, started the patch installation and soon realized that I hadn't shut the database down before doing so. I immediately stopped to patchset installation and tried to shut down the database but I get the following errors: $ svrmgrl Oracle Server Manager Release 3.1.6.0.0 - Production Copyright (c) 1997, 1999, Oracle Corporation. All Rights Reserved. ORA-03113: end-of-file on communication channel SVRMGR> connect internal Password: Is there anything I can do or do I need to restore from backup and start the whole procedure from scratch? 2nd question: Is it possible to do the patch install and then do the upgrade? The patchset instructions imply not, but there's a technical forum response that implies you can. Which is it? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Miller, Jay INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Toepke, Kevin M INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kevin Lange INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Miller, Jay INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP
apology
On Tue, 12 Jun 2001,Thater, William scribbled on the wall in glitter crayon: ->well, i'm jealous. i could use some. my aunt died from breast cancer over the weekend and the funerial was today. oh damn, this was not supposed to go to the list. i'm sorry for bothering everyone with my personal stuff. put it down to lack of single malt.;-) -- Bill "Shrek" Thater Certifiable ORACLE DBA Telergy, Inc.[EMAIL PROTECTED] ~~ You gotta program like you don't need the money, You gotta compile like you'll never get hurt, You gotta run like there's nobody watching, It's gotta come from the heart if you want it to work. ~~ The Soviet Union does not exist any more in its present format. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thater, William INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Digestive
Glenmorangie 12 year old oh yum >From: Jared Still <[EMAIL PROTECTED]> >Reply-To: [EMAIL PROTECTED] >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> >Subject: Re: Digestive >Date: Tue, 12 Jun 2001 12:53:43 -0800 > >On Tuesday 12 June 2001 12:33, Thater, William wrote: > > > > single malt RULES!;-) > >Well, yeah, I like that too. > >I have some 16 yr old Lagavulin ( spelling? ) in the >pantry that is just awesome. Fine smokey flavor from >aging in Oak Brandy barrels. ( Or sherry, I'll have to check ) > >Jared >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: Jared Still > INET: [EMAIL PROTECTED] > >Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 >San Diego, California-- Public Internet access / Mailing Lists > >To REMOVE yourself from this mailing list, send an E-Mail message >to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in >the message BODY, include a line containing: UNSUB ORACLE-L >(or the name of mailing list you want to be removed from). You may >also send the HELP command for other information (like subscribing). _ Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Forever running Analyze
Hi folks; We have an Analyze running that is taking forever. Here is the setup: The table is about 250 bytes wide. The table is normally 100,000 rows The table has grown to over 4,000,000 rows. There is one index on 1 column. We used the Compute Statistics options Does anyone have any suggestions on how we can get this analyze to complete and still generate worthwile statistics ?? Thanks Kevin
RE: Digestive
Jared, I'm shocked, SHOCKED that you would spoil the excellent tast of Bombay Saphire with Vermouth and/or water (via melting ice). Maybe an olive or two (or three) for color, as long as they're well drained. Save the Vermouth and olive juice for the cheap stuff!8^) My personal DBA Special is a "Mexican Martini", straight Hornitos tequila with 2 or 3 (or 4) slices of Jalapeno - guaranteed to clear your mind and sinuses! Again, hold the salt, lime, ice and other "pollutants" - save them for the rather bland tequilas such as Cuervo. Jack Jack C. Applewhite Database Administrator/Developer OCP Oracle8 DBA iNetProfit, Inc. Austin, Texas www.iNetProfit.com [EMAIL PROTECTED] (512)327-9068 -Original Message- Sent: Tuesday, June 12, 2001 3:39 PM To: Multiple recipients of list ORACLE-L On Tuesday 12 June 2001 13:19, Rajaram wrote: > Did you say Bombay? BTW, what is "Bombay Sapphire dirty Martini" ? Bombay Sapphire Gin. Very good, very smooth, very expensive. Martini and Rossi Extra Dry Vermouth. Pour Gin and Vermouth over ice, amount of vermouth differs according to taste. If you have a shaker, shake the drink with ice, then pour over 3 large spicy green olives. Adding some olive juice to the drink makes it 'dirty'. Adding scotch to it makes it 'smoky'. We should come up with a 'DBA special' variation. :0 Jared -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jack C. Applewhite INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Digestive
Lagavulin??!?! Yikes, Jared, I am going to revoke my "Soul Brother" license from you. Don't tell me you like "Laphroaig" as well? That peaty sh*t should be used to clean road tar off SUVs. Now, if you're talking a fine Glendronach, you've got my full attention. -Original Message- Sent: Tuesday, June 12, 2001 4:54 PM To: Multiple recipients of list ORACLE-L On Tuesday 12 June 2001 12:33, Thater, William wrote: > > single malt RULES!;-) Well, yeah, I like that too. I have some 16 yr old Lagavulin ( spelling? ) in the pantry that is just awesome. Fine smokey flavor from aging in Oak Brandy barrels. ( Or sherry, I'll have to check ) Jared -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohan, Ross INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Digestive
A dirty martini has a bit of the liquid from the jar of olives poured into the glass. Denise Gwinn [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Ora-600 : Internal error code.. Help!!!
Title: RE: Ora-600 : Internal error code.. Help!!! Lisa; According to their web site: Unal Bilisim is an organization which is specialized in Oracle Database. It's located in Adana/Turkey. Unal Bilisim applies and believes in Deductive Business Management philosophy. This management philosophy is the management method of internet age. It makes products and services centralized, reduces costs, broadens customer scope. So, products and services of Unal Bilisim will be internet-based. Products will be run on internet, services will be delivered over internet. -Original Message-From: Koivu, Lisa [mailto:[EMAIL PROTECTED]]Sent: Tuesday, June 12, 2001 3:39 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Ora-600 : Internal error code.. Help!!! OK. What is unal-bilisim, it sounds like it's kinda disgusting. But what do I know. -Original Message- From: Kevin Lange [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, June 12, 2001 4:25 PM To: Multiple recipients of list ORACLE-L Subject: RE: Ora-600 : Internal error code.. Help!!! There is a web site, http://www.unal-bilisim.com/products/iorabugfinder/iorabugfinder.html, that lets you upload your trace file and it will give you links to any relavant info it can find on the subject. You might want to try it. -Original Message- Sent: Tuesday, June 12, 2001 1:07 PM To: Multiple recipients of list ORACLE-L DBA's I am getting following error in alert.log once in two days. on Jun 11 09:26:11 2001 Errors in file /export/home/u01/app/oracle/admin/orcl/udump/orcl_ora_6342.trc: ORA-00600: internal error code, arguments: [12333], [111], [108], [44], [], [], [], [] Mon Jun 11 09:49:04 2001 LGWR: prodding the archiver The DB is 8.1.5 on Solaris 7. When I referered to metalink, it says there could be some problem with the network in OS level. I am not sure how to track the error or where to look for this in the OS. Could some one help me in finding the cause of this problem? Thanks Raj -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raj Gopalan INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kevin Lange INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Digestive Martinis
Title: RE: Digestive Martinis Bombay Sapphire, dash of good blended Scotch, ice, shake, pour, add twist of lemon zest, wave bottle of vermouth in front of finished martini. -Original Message-From: Koivu, Lisa [mailto:[EMAIL PROTECTED]]Sent: Tuesday, June 12, 2001 4:39 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Digestive Martinis Bombay Sapphire, splash of olive juice and a few green olives. MM Does the job REAL fast. -Original Message- From: Rajaram [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, June 12, 2001 4:19 PM To: Multiple recipients of list ORACLE-L Subject: RE: Digestive Did you say Bombay? BTW, what is "Bombay Sapphire dirty Martini" ? -Original Message- From: Jared Still [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, June 12, 2001 4:03 PM To: Multiple recipients of list ORACLE-L Subject: Re: Digestive How about a Bombay Sapphire dirty Martini, straight up, spicy olives? Yum. Jared On Tuesday 12 June 2001 11:43, Igor Neyman wrote: > LOL, > > May I be more specific: > > SET ORACLE-L JIN&TONIC > > Igor Neyman, OCP DBA > Perceptron, Inc. > (734)414-4627 > [EMAIL PROTECTED] > > > - Original Message - > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> > Sent: Tuesday, June 12, 2001 1:46 PM > > > WHY NOT JUST SET ORACLE-L APERITIF? > > > > -Original Message- > > Sent: Tuesday, June 12, 2001 1:27 PM > > To: Multiple recipients of list ORACLE-L > > > > > > SET ORACLE-L DIGESTIVE > > > > = > > Hamid Alavi > > 4268 Flintlock LN > > Westlake Village 91631 > > PH: 818-8790966 > > > > __ > > Do You Yahoo!? > > Get personalized email addresses from Yahoo! Mail - only $35 > > a year! http://personal.mail.yahoo.com/ > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > -- > > Author: hamid alavi > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 > > San Diego, California -- Public Internet access / Mailing Lists > > > > To REMOVE yourself from this mailing list, send an E-Mail message > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > > the message BODY, include a line containing: UNSUB ORACLE-L > > (or the name of mailing list you want to be removed from). You may > > also send the HELP command for other information (like subscribing). > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > -- > > Author: Mohan, Ross > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 > > San Diego, California -- Public Internet access / Mailing Lists > > > > To REMOVE yourself from this mailing list, send an E-Mail message > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > > the message BODY, include a line containing: UNSUB ORACLE-L > > (or the name of mailing list you want to be removed from). You may > > also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). NetZero Platinum No Banner Ads and Unlimited Access Sign Up Today - Only $9.95 per month! http://www.netzero.net -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rajaram INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be remove
RE: Digestive DBA Special
Title: RE: Digestive DBA Special DBA Special? Captain Morgan, after the story I heard on this list years ago about the pirate that wore a red shirt so his men couldn't see he was bleeding, and chose special times to wear his brown pants. There have been a few times in my short tenure as a dba when the brown pants were absolutely necessary. Captain is my fav, he improves my golf game and my balance in general :) -Original Message- From: Jared Still [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, June 12, 2001 4:39 PM To: Multiple recipients of list ORACLE-L Subject: Re: Digestive On Tuesday 12 June 2001 13:19, Rajaram wrote: > Did you say Bombay? BTW, what is "Bombay Sapphire dirty Martini" ? Bombay Sapphire Gin. Very good, very smooth, very expensive. Martini and Rossi Extra Dry Vermouth. Pour Gin and Vermouth over ice, amount of vermouth differs according to taste. If you have a shaker, shake the drink with ice, then pour over 3 large spicy green olives. Adding some olive juice to the drink makes it 'dirty'. Adding scotch to it makes it 'smoky'. We should come up with a 'DBA special' variation. :0 Jared > -Original Message- > From: Jared Still [SMTP:[EMAIL PROTECTED]] > Sent: Tuesday, June 12, 2001 4:03 PM > To: Multiple recipients of list ORACLE-L > Subject: Re: Digestive > > > > How about a Bombay Sapphire dirty Martini, straight up, > spicy olives? > > Yum. > > Jared > > On Tuesday 12 June 2001 11:43, Igor Neyman wrote: > > LOL, > > > > May I be more specific: > > > > SET ORACLE-L JIN&TONIC > > > > Igor Neyman, OCP DBA > > Perceptron, Inc. > > (734)414-4627 > > [EMAIL PROTECTED] > > > > > > - Original Message - > > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> > > Sent: Tuesday, June 12, 2001 1:46 PM > > > > > WHY NOT JUST SET ORACLE-L APERITIF? > > > > > > -Original Message- > > > Sent: Tuesday, June 12, 2001 1:27 PM > > > To: Multiple recipients of list ORACLE-L > > > > > > > > > SET ORACLE-L DIGESTIVE > > > > > > = > > > Hamid Alavi > > > 4268 Flintlock LN > > > Westlake Village 91631 > > > PH: 818-8790966 > > > > > > __ > > > Do You Yahoo!? > > > Get personalized email addresses from Yahoo! Mail - only $35 > > > a year! http://personal.mail.yahoo.com/ > > > -- > > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > > -- > > > Author: hamid alavi > > > INET: [EMAIL PROTECTED] > > > > > > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 > > > San Diego, California -- Public Internet access / Mailing Lists > > > > > > To REMOVE yourself from this mailing list, send an E-Mail message > > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > > > the message BODY, include a line containing: UNSUB ORACLE-L > > > (or the name of mailing list you want to be removed from). You may > > > also send the HELP command for other information (like subscribing). > > > -- > > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > > -- > > > Author: Mohan, Ross > > > INET: [EMAIL PROTECTED] > > > > > > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 > > > San Diego, California -- Public Internet access / Mailing Lists > > > > > > To REMOVE yourself from this mailing list, send an E-Mail message > > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > > > the message BODY, include a line containing: UNSUB ORACLE-L > > > (or the name of mailing list you want to be removed from). You may > > > also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Digestive
If you are doing gins, try Junipero gin while in San Francisco. Most excellent. Denise Gwinn [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: SMP/MPP and PQO
I think it was just updated, too. Great book. -Original Message-From: Henry Poras [mailto:[EMAIL PROTECTED]]Sent: Tuesday, June 12, 2001 3:04 PMTo: Multiple recipients of list ORACLE-LSubject: RE: SMP/MPP and PQO Lisa, If you are interested in more detail on the differences between SMP, NUMA, and clusters, there is a great book "In search of clusters". It's one of the best technical books I've read. I can't remember the author's name, but maybe another list member can help. I picked it up because someone else on the list recomended it a while ago. Henrh -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]Sent: Tuesday, June 12, 2001 12:48 PMTo: Multiple recipients of list ORACLE-LSubject: Re: SMP/MPP and PQOHi Lisa SMP - In SMP many CPUs share the same memory. Typical example would be E450, 4 processors, 4GB memory. Only L2 cache in the CPUs need to be co-ordinated when a memory buffer is changed or intended to change. MPP - In MPP each CPU has its own memory and its own disks that they control (typically). An example would be nCUBE or IBM RS6000, where each processor runs its own OS and messaging is used heavily to coordinate the access to the resources. NUMA - Nun -uniform memory access - Group of CPUs share the same memory and the messaging is used between the group of the CPUs to coordinate the access to the resource. An example would be Sequent NUMA-Q, where there are multiple quads and each quad has 4 cpus and 2GB memory (typically) and IQ-link coordinates the access to the resources between the quads. HP has ccNUMA for this. Now, I don't think, E10k domain would qualify for a MPP, since there is no coordination or access restrictions between the domains ( at least that I know of). Each domain can manipulate its own disk / memory /devices without any messaging between the domains, in a non-clustered environment. PQ architecture splits the FTS or long running operations on non-partitioned tables, in to multiple chunks based upon the rowid ranges. It is not a simple split though. First, work is divided in to degree of parallelism. For example, if the QC process determines that it has to scan 100,000 blocks and parallelism is determined as 4 then 25000 would be the split. But not all 25000 block is handed over to the slave processes. QC uses 9/13 rule. QC hands over 9/13 of the work (i.e. 25000 * 9/13=17307) blocks equally to the slave processes. When the slave processes finishes up the 9/13 work, then they get 3/13 of the work (25000 *3/13=5769) blocks and 1/13 of the work when the second set of 3/13s are exhausted. This is done to evenly distribute the load. For example, there could data skew such that one process could finish up its 9/13 work much faster than other processes and hence those processes can take up the rema! in! ! ing work. The suitability of PQO parallelism should be defined by IO sub system in conjunction with CPU power. If you have many spindles in 2 cpu server my take on it would be to use parallelism of 2 to4 depending upon the cpu clock speed, disk speed, memory etc.. ThanksRiyaj "Re-yas" ShamsudeenCertified Oracle DBAi2 technologies www.i2.com "Koivu, Lisa" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 06/12/01 09:17 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject: SMP/MPP and PQOHello everyone, I was reading up on the differences between SMP, MPP and how they may affect PQO (Parallel Query). My understanding is that MPP is a host with defined domains (like an e10k with virtual machines on it). SMP is a standalone host with no domains and multiple processors. I am not considering clustering here. It seemed to me the only requirement that you really need to run PQO is to have available resources to power it. For example, a little 2-cpu box that is pinned a majority of the time is only going to suffer if PQO is turned on. However, if we had a 16-cpu box with abundant resources, turning on PQO would help fts and large index scans in a dw-type environment. (At least this is what I saw in the past). Also, I was taught that PQO should not be used when a table/index is not partitioned. However, upon reading the doco, it states that the slaves split up work by blocks (or was it extents?). Seems to me this could cause more problems than it's worth (i/o contention?) and partitioning, if done ca
Re: Digestive
On Tue, 12 Jun 2001,Jared Still scribbled on the wall in glitter crayon: ->On Tuesday 12 June 2001 12:33, Thater, William wrote: ->> ->> single malt RULES!;-) -> ->Well, yeah, I like that too. -> ->I have some 16 yr old Lagavulin ( spelling? ) in the ->pantry that is just awesome. Fine smokey flavor from ->aging in Oak Brandy barrels. ( Or sherry, I'll have to check ) -> ->Jared -> well, i'm jealous. i could use some. my aunt died from breast cancer over the weekend and the funerial was today. -- Bill "Shrek" Thater Certifiable ORACLE DBA Telergy, Inc.[EMAIL PROTECTED] ~~ You gotta program like you don't need the money, You gotta compile like you'll never get hurt, You gotta run like there's nobody watching, It's gotta come from the heart if you want it to work. ~~ The Soviet Union does not exist any more in its present format. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thater, William INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Pin a CPU in Solaris
Binding processes to CPUs is not at normal, even in high load situations. System scheduler ticks move even busy procs off CPUs, to go back through the run skedder. Yes, of course, the newer/better run scheduler are aware of register and CPU cache flush issues, but there is no guarantee a processor under the default scheduler will own a CPU. Not at all. Of course, I could be misunderstanding what you're trying to test. If you're trying to run a single CPU benchmark, then YES, you'd want to have ONE and ONLY ONE processor to run it...no context switches, no processor swaps...just b*lls to the wall performance. But that's not real life, and should not be proferred as a simulation of it. hth Hannibal -Original Message- Sent: Tuesday, June 12, 2001 1:41 PM To: Multiple recipients of list ORACLE-L Does anyone know how to pin a Solaris CPU at a high utilization? I am doing some testing and want to evaluate a system under a high CPU load. Thanks. Erik -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Erik Williams INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohan, Ross INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Digestive
Drink with the President's kids, and it's "Jenna Tonic". -Original Message- Sent: Tuesday, June 12, 2001 2:43 PM To: Multiple recipients of list ORACLE-L LOL, May I be more specific: SET ORACLE-L JIN&TONIC Igor Neyman, OCP DBA Perceptron, Inc. (734)414-4627 [EMAIL PROTECTED] - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Tuesday, June 12, 2001 1:46 PM > WHY NOT JUST SET ORACLE-L APERITIF? > > -Original Message- > Sent: Tuesday, June 12, 2001 1:27 PM > To: Multiple recipients of list ORACLE-L > > > SET ORACLE-L DIGESTIVE > > = > Hamid Alavi > 4268 Flintlock LN > Westlake Village 91631 > PH: 818-8790966 > > __ > Do You Yahoo!? > Get personalized email addresses from Yahoo! Mail - only $35 > a year! http://personal.mail.yahoo.com/ > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: hamid alavi > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Mohan, Ross > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Igor Neyman INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohan, Ross INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Digestive
On Tuesday 12 June 2001 12:33, Thater, William wrote: > > single malt RULES!;-) Well, yeah, I like that too. I have some 16 yr old Lagavulin ( spelling? ) in the pantry that is just awesome. Fine smokey flavor from aging in Oak Brandy barrels. ( Or sherry, I'll have to check ) Jared -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Ora-600 : Internal error code.. Help!!!
Title: RE: Ora-600 : Internal error code.. Help!!! OK. What is unal-bilisim, it sounds like it's kinda disgusting. But what do I know. -Original Message- From: Kevin Lange [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, June 12, 2001 4:25 PM To: Multiple recipients of list ORACLE-L Subject: RE: Ora-600 : Internal error code.. Help!!! There is a web site, http://www.unal-bilisim.com/products/iorabugfinder/iorabugfinder.html, that lets you upload your trace file and it will give you links to any relavant info it can find on the subject. You might want to try it. -Original Message- Sent: Tuesday, June 12, 2001 1:07 PM To: Multiple recipients of list ORACLE-L DBA's I am getting following error in alert.log once in two days. on Jun 11 09:26:11 2001 Errors in file /export/home/u01/app/oracle/admin/orcl/udump/orcl_ora_6342.trc: ORA-00600: internal error code, arguments: [12333], [111], [108], [44], [], [], [], [] Mon Jun 11 09:49:04 2001 LGWR: prodding the archiver The DB is 8.1.5 on Solaris 7. When I referered to metalink, it says there could be some problem with the network in OS level. I am not sure how to track the error or where to look for this in the OS. Could some one help me in finding the cause of this problem? Thanks Raj -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raj Gopalan INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kevin Lange INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
