RE: MC/Serviceguard vs Sun Clusters
LMAO -Original Message- [mailto:[EMAIL PROTECTED]] Sent: 07 February 2002 21:53 To: Multiple recipients of list ORACLE-L Talk about serendipity -- I hope you payed that disconnected contractor a bonus for debugging your failsafe setup? -Original Message- Sent: Thursday, February 07, 2002 9:00 AM To: Multiple recipients of list ORACLE-L Rama, We did the MC/ServiceGuard thing some years ago. Worked well, after our SA rebuilt the servers from ground 0. Adding it on to an existing server is ok, but somewhat unstable. One item to be VERY careful of. The heartbeat cable, in our case a ethernet thin line, needs to be on a dedicated link, preferably a purchased vs. custom made cable, and protected from accidental disconnect. Ours got disconnected by a contractor working in the computer room because it was in his way. The resulting reboot of the backup server and forcible takeover of the disk farm absolutely destroyed the database. We had more file corruption than I ever could have imagined. Consequently we abandoned ServiceGuard are going to standby databases instead. Dick Goulet Reply Separator Author: Rama Malladi [EMAIL PROTECTED] Date: 2/6/2002 5:23 PM Hi... I am looking for inputs from anybody who has experience in both MC/Serviceguard (MC/S) as well as Sun cluster implementation. If a DBA/SA team has lots of experience in implementing MC/Serviceguard clusters on HP and trying to move to SunClusters for HA solution ... a) What are the common things between MC/S and and Sun clusters (ex: about 5 minute fail-over time, fixed IP address, 2 or more nodes in a cluster, disk sharing etc..) b) Any differences between these... What are the things to watch out for (assuming the team already knows in and out of MC/Serviceguard) Thank you in advance... Rama -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rama Malladi INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Kirsch, Walter J (Northrop Grumman) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computer system. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robertson Lee - lerobe INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information
Migrating from 8.1.6 EE to 8.1.7 SE
Title: Migrating from 8.1.6 EE to 8.1.7 SE Hi! Our company wants to upgrade some of our databases from 8.1.6 to 8.1.7. Right now, we are using 8.1.6 Enterprise Edition, but when we migrate to 8.1.7 we want to use Standard Edition. What would be the procedure to migrate from 8.1.6. EE to 8.1.7 SE? Do we have to go to 8.1.7 EE first? This is on Win2k. Thanks, Helmut
Re: Identifying Long Running SQL's
select sql_text from v$sql where disk_reads ? = IO killers or buffer_gets ? = cpu killers or executions ?= excessive usage order by any_of_the_three_above hth connor --- Helen J Mitchell [EMAIL PROTECTED] wrote: Does anyone have a script that can identify the most inefficient SQL code running in the application ranking from least to most efficient? Helen J Mitchell Oracle Database Administrator E - [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Helen J Mitchell INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). = Connor McDonald http://www.oracledba.co.uk (mirrored at http://www.oradba.freeserve.co.uk) Some days you're the pigeon, some days you're the statue __ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Connor=20McDonald?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Where does a DBA go from here?
Its Friday, the immediate solution is get beer !! As to your other problem its text book time - take a look at Tuning 101 by the lists own Kirti and Gaja. Lee -Original Message- Sent: 07 February 2002 21:07 To: Multiple recipients of list ORACLE-L So, there I am. I've taken the main Oracle courses -- Intro to SQL, DBA (Oracle 7!), Backup Recovery, Network Admin, and Perf Tuning. Now where do I go for more Oracle training? This is sparked by a recent perceived lag in one of our new databases. We've tracked it down to a possible hot block or two, but I never used X$BH or V$LATCH_CHILDREN in any of my Oracle classes. And I *know* I'm far from being ready for an Internals class. So how do I get from here to there? education.oracle.com doesn't seem to have a whole lot other than Internals. Or is that where I'm at now? Confused and no beer. Rich JesseSystem/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computer system. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robertson Lee - lerobe INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
An Oracle product like microsoft ISA server
Hi, Is there a product from Oracle like ISA (Internet Security and Acceleration) Server. Our application is developed in ASP and VB Script, back-end on Oracle 8i. Is this in Oracle Application Server scope for security and acceleration? Any discussion group or list to get information from? Any help is appreciated. Best Regards, Aleem -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Abdul Aleem INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Where does a DBA go from here?
I agree, get the pints in first. Worry about Oracle later. When you do come to it, try Oracle8i internal services for waits, latches, locks and memory by Steve Adams. And of course book. Jim -Original Message- Lee - lerobe Sent: 08 February 2002 09:58 To: Multiple recipients of list ORACLE-L Its Friday, the immediate solution is get beer !! As to your other problem its text book time - take a look at Tuning 101 by the lists own Kirti and Gaja. Lee -Original Message- Sent: 07 February 2002 21:07 To: Multiple recipients of list ORACLE-L So, there I am. I've taken the main Oracle courses -- Intro to SQL, DBA (Oracle 7!), Backup Recovery, Network Admin, and Perf Tuning. Now where do I go for more Oracle training? This is sparked by a recent perceived lag in one of our new databases. We've tracked it down to a possible hot block or two, but I never used X$BH or V$LATCH_CHILDREN in any of my Oracle classes. And I *know* I'm far from being ready for an Internals class. So how do I get from here to there? education.oracle.com doesn't seem to have a whole lot other than Internals. Or is that where I'm at now? Confused and no beer. Rich JesseSystem/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computer system. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robertson Lee - lerobe INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: James McCann INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Weird connection behavior
Title: Weird connection behavior Hi! I'm experiencing a weird behavior here: when I try to connect to an Instance - named ITSP - (I am locally on the server): user/pw@itsp, the connect works fine. But when I try to connect to that same database from my windows client, using user/pw@itsp, I get the message: Oracle not available. Any idea what is going on here? This is 8.1.7 on Sun Solaris. Thanks, Helmut
Re: Bitmap Indexes
Ethan, We are using all bitmap indexes on our main fact table. We also have a mix of bitmap and b-tree indexes on other tables. The bitmap indexes work best in SQL with multiple where clauses anded together where each column in the where clause has a bit-map index on it. The more of these bit-mapped indexes that you have in your where clause, the better. At least two is best. We have quite a lot of pockets of poor performance. Many of those explain plans mix bit-mapped indexes with b-tree indexes. I've never seen the optimizer try to convert a bit-mapped index to a b-tree index but we are at 8.0.4. I've never tried to convert a bit-mapped index to a b-tree or vice-versa.Might be interesting to try. However it's tough because this is a production database that was already in place when I got here. I should also note that our fact table and several others are partitioned and we have star_transformation_enabled set to true. Please post a summary of your results to the list if you have time. This is an interesting thread. Cherie Machler Oracle DBA Gelco Information Network. Post, Ethan Ethan.Post@ps To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] .netcc: Sent by: Subject: Bitmap Indexes [EMAIL PROTECTED] om 02/07/02 03:06 PM Please respond to ORACLE-L Posted on behalf of a friend... Fellow Oracle data warehouse DBAs (if this isn't you, you can delete this note now): I have a question regarding Oracle's bitmap indexes. We have been DABBLING with bitmap indexes with mixed results here. In many cases, they are great solutions. In some cases, where we have a mix of bitmap and b-tree indexes on the same table, we occasionally get into trouble --- this has to do with the Oracle optimizer deciding, on the fly, to convert a regular b-tree index into a bitmap. It does this so that it can AND or OR the various bitmap indexes together. Sounds great on the surface but when this occurs, response time goes in the toilet. In one situation we have, we have a fact table with two bitmap indexes and a few other b-tree indexes. A particular query we run bogs down (NEVER COMPLETES) with this mix of indexes. Based on the access path that's being chosen, we know which b-tree index is being converted on the fly. If we convert that b-tree index into a bitmap (so we now have 3 bitmap indexes and Oracle does not need to create the third one on the fly), the query really runs well. If we replace the bitmap indexes with b-tree indexes (so we only have b-tree indexes), we get decent response times. (This is all on Oracle 8.1.7.2.0, by the way.) I'm wondering if the rest of you data warehouse DBAs have gone whole hog with bitmap indexes. My testing shows that when Oracle doesn't have to create a bitmap index on the fly, the queries respond wonderfully. So, I'm wondering if our dabbling is actually a bad validation approach and, instead, we should be 'running' with LOTS bitmap indexes instead of 'crawling' with only a few of them. In other words, maybe we're not taking all of our medication, as someone else put it recently. Any insight would be most appreciated. I'm not looking for insight on the query I have used as an example. I'm looking for a generalized answer that says, Yes, if you start using bitmap indexes, you should go TOTALLY to bitmap indexes or, Hmmm, we're using some bitmap indexes and some b-tree indexes and don't have the problem you have. -- Please
Reorganising Database
Hi All, I am currently testing a database reorg and am facing extremely long table drop times due to too many extents. This is expected but is there a way to speed things up?? Jack === De informatie verzonden in dit e-mailbericht is vertrouwelijk en is uitsluitend bestemd voor de geadresseerde. Openbaarmaking, vermenigvuldiging, verspreiding en/of verstrekking van deze informatie aan derden is, behoudens voorafgaande schriftelijke toestemming van Ernst Young, niet toegestaan. Ernst Young staat niet in voor de juiste en volledige overbrenging van de inhoud van een verzonden e-mailbericht, noch voor tijdige ontvangst daarvan. Ernst Young kan niet garanderen dat een verzonden e-mailbericht vrij is van virussen, noch dat e-mailberichten worden overgebracht zonder inbreuk of tussenkomst van onbevoegde derden. Indien bovenstaand e-mailbericht niet aan u is gericht, verzoeken wij u vriendelijk doch dringend het e-mailbericht te retourneren aan de verzender en het origineel en eventuele kopieën te verwijderen en te vernietigen. Ernst Young hanteert bij de uitoefening van haar werkzaamheden algemene voorwaarden, waarin een beperking van aansprakelijkheid is opgenomen. De algemene voorwaarden worden u op verzoek kosteloos toegezonden. = The information contained in this communication is confidential and is intended solely for the use of the individual or entity to whom it is addressed. You should not copy, disclose or distribute this communication without the authority of Ernst Young. Ernst Young is neither liable for the proper and complete transmission of the information contained in this communication nor for any delay in its receipt. Ernst Young does not guarantee that the integrity of this communication has been maintained nor that the communication is free of viruses, interceptions or interference. If you are not the intended recipient of this communication please return the communication to the sender and delete and destroy all copies. In carrying out its engagements, Ernst Young applies general terms and conditions, which contain a clause that limits its liability. A copy of these terms and conditions is available on request free of charge. === -- 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: Where does a DBA go from here?
I meant to say of course Kirti's book Jim -Original Message- McCann Sent: 08 February 2002 11:18 To: Multiple recipients of list ORACLE-L I agree, get the pints in first. Worry about Oracle later. When you do come to it, try Oracle8i internal services for waits, latches, locks and memory by Steve Adams. And of course book. Jim -Original Message- Lee - lerobe Sent: 08 February 2002 09:58 To: Multiple recipients of list ORACLE-L Its Friday, the immediate solution is get beer !! As to your other problem its text book time - take a look at Tuning 101 by the lists own Kirti and Gaja. Lee -Original Message- Sent: 07 February 2002 21:07 To: Multiple recipients of list ORACLE-L So, there I am. I've taken the main Oracle courses -- Intro to SQL, DBA (Oracle 7!), Backup Recovery, Network Admin, and Perf Tuning. Now where do I go for more Oracle training? This is sparked by a recent perceived lag in one of our new databases. We've tracked it down to a possible hot block or two, but I never used X$BH or V$LATCH_CHILDREN in any of my Oracle classes. And I *know* I'm far from being ready for an Internals class. So how do I get from here to there? education.oracle.com doesn't seem to have a whole lot other than Internals. Or is that where I'm at now? Confused and no beer. Rich JesseSystem/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computer system. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robertson Lee - lerobe INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: James McCann INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: James McCann INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: TFM
THANK you! I kinda had a hunch that life would change... When I worked for US Steel, their Mississippi plant installed Financials and I had to send id IMS data... I wasn't wild about it then, and I wasn't directly connected. I just keep thinking... it's a learning experience... it's a learning experience... April -Original Message- Sent: Thursday, February 07, 2002 3:53 PM To: Multiple recipients of list ORACLE-L April -- Get onto Metalink - Top Tech Docs. There's more there than you'll be able to read in a lifetime. One thing to know is that once you install Applications, your life as a DBA *will* change. Good luck! Bambi. -Original Message- Sent: Thursday, February 07, 2002 3:07 PM To: Multiple recipients of list ORACLE-L We are getting ready to sign a contract with Oracle for Financials. I have been looking for the manuals so I can read up on what their suggestions are for installation, tuning... for the 3000+ tables and associated other back end stuff... anyone know where they can be found. I can find some on Oracle Apps Net, but not really the kind of stuff I am looking for... are their other? April Wells Oracle DBA Corporate Systems Amarillo Texas begin 666 InterScan_Disclaimer.txt M5AE(EN9F]R;6%T:6]N(-O;G1A:6YE9!I;B!T:ES(4M;6%I;!IR!S M=')I8W1L2!C;VYF:61E;G1I86P@86YD(9OB!T:4@:6YT96YD960@=7-E M(]F('1H92!A91R97-S964@;VYL3L@:70@;6%Y(%LV\@8F4@;5G86QL M2!PFEV:6QE9V5D(%N9]OB!PFEC92!S96YS:71I=F4N(!.;W1I8V4@ M:7,@:5R96)Y(=I=F5N('1H870@86YY(1IV-L;W-UF4L('5S92!OB!C M;W!Y:6YG(]F('1H92!I;F9OFUA=EO;B!B2!A;GEO;F4@;W1H97(@=AA M;B!T:4@:6YT96YD960@F5C:7!I96YT(ES('!R;VAI8FET960@86YD(UA M2!B92!I;QE9V%L+B @268@6]U(AA=F4@F5C96EV960@=AIR!M97-S M86=E(EN(5RF]R+!P;5AV4@;F]T:69Y('1H92!S96YD97(@:6UM961I M871E;'D@8GD@F5T=7)N(4M;6%I;X*D-OG!OF%T92!37-T96US+!) M;F,N(AAR!T86ME;B!E=F5R2!R96%S;VYA8FQE('!R96-A=71I;VX@=\@ M96YS=7)E('1H870@86YY(%T=%C:UE;G0@=\@=AIR!E+6UA:6P@:%S M()E96X@W=E'0@9F]R('9IG5S97,N(!792!A8V-E'0@;F\@;EA8FEL M:71Y(9OB!A;GD@9%M86=E('-UW1A:6YE9!AR!A(')EW5L=!O9B!S M;V9T=V%R92!V:7)UV5S(%N9!A9'9IV4@6]U(-AG)Y(]U=!Y;W5R M(]W;B!V:7)UR!C:5C:W,@8F5F;W)E(]P96YI;F@86YY(%T=%C:UE M;G0N#0I4:4@:6YF;W)M871I;VX@8V]N=%I;F5D(EN('1H:7,@92UM86EL M(ES('-TFEC=QY(-O;F9I95N=EA;!A;F0@9F]R('1H92!I;G1E;F1E M9!UV4@;V8@=AE(%D9')EW-E92!O;FQY.R!I=!M87D@86QS;R!B92!L M96=A;QY('!R:79I;5G960@86YD+V]R('!R:6-E('-E;G-I=EV92X@($YO M=EC92!IR!H97)E8GD@9VEV96X@=AA=!A;GD@9ES8VQOW5R92P@=7-E M(]R(-O'EI;F@;V8@=AE(EN9F]R;6%T:6]N()Y(%N6]N92!O=AE MB!T:%N('1H92!I;G1E;F1E9!R96-IEE;G0@:7,@')O:EB:71E9!A M;F0@;6%Y()E(EL;5G86PN(!)9B!Y;W4@:%V92!R96-E:79E9!T:ES M(UEW-A9V4@:6X@97)R;W(L('!L96%S92!N;W1I9GD@=AE('-E;F1EB!I M;6UE9EA=5L2!B2!R971UFX@92UM86EL+@H*0V]R]R871E(%-YW1E M;7,L($EN8RX@:%S('1A:V5N(5V97)Y(')E87-O;F%B;4@')E8V%U=EO M;B!T;R!E;G-UF4@=AA=!A;GD@871T86-H;65N=!T;R!T:ES(4M;6%I M;!H87,@8F5E;B!S=V5P=!F;W(@=FER=7-ERX@(%=E(%C8V5P=!N;R!L M:6%B:6QI='D@9F]R(%N2!D86UA9V4@W5S=%I;F5D(%S($@F5S=6QT M(]F('-O9G1W87)E('9IG5S97,@86YD(%D=FES92!Y;W4@8V%RGD@;W5T M('EO=7(@;W=N('9IG5S(-H96-KR!B969OF4@;W!E;FEN9R!A;GD@871T ,86-H;65N=X-@T* end -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: April Wells INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Bellows, Bambi INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: April Wells INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like
RE: What impacts index build times on partitioned tables?
Rafiq, Yes, we have parallel set to six. We are using nologging. I am checking on the sort_area_size. Thanks, Cherie Mohammad Rafiq To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] rafiq9857@hot cc: mail.comSubject: RE: What impacts index build times on partitioned tables? Sent by: [EMAIL PROTECTED] om 02/07/02 03:06 PM Please respond to ORACLE-L Please check following Are you creating indexes with parallel clause or not? Are you using unrecoverable/nologging or not Is your sort_area_size is ok? What type of TEMP tablespace are you using with temp file or datafile and sizing of extents are proper? Is your target tablespace is not that much fragmented? Regards Rafiq Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: Thu, 07 Feb 2002 08:55:47 -0800 Yechiel, There is no other activity in this warehouse database while the index builds are being done. The users access is shut off, no batch jobs for this database are running, and the nightly data loads have already finished. Thanks, Cherie àãø éçéàì adary@mehish. To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] co.il cc: Sent by: Subject: RE: What impacts index build times on partitioned tables? [EMAIL PROTECTED] om 02/07/02 10:20 AM Please respond to ORACLE-L I think that it is related to the activity against the DB. Not only there is more load on the DB but access path that use the index can default to full table scan if the index is not available because you are rebuilding it just now. Yechiel Adar, Mehish Computer Services [EMAIL PROTECTED] -Original Message- From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] Sent: Thu, February 07, 2002 5:55 PM To: Multiple recipients of list ORACLE-L Subject: What impacts index build times on partitioned tables? We drop and recreate many indexes on our large partitioned fact table in our data warehouse nightly. The amount of data in the table increases gradually with time but there aren't huge fluctuations in the amount of data in the partitions from day to day. The problem is that the amount of time that it takes to recreate the indexes varies widely. From 40 minutes to almost three hours. I am inclined to believe that this is a scheduling issue related to the time of the day and the day of the week. I think we may be experiencing competition from other batch jobs from other applications. One application, in particular, is sort of a black box because it is not on Oracle and it belongs to people who reside in a remote site. However, I want to make sure I've considered all of the possibilities. What factors might influence how long it takes to rebuild indexes on existing partitions? If I just did some maintenance to split out some data for a new time period into a new partition, might that make a difference in how long it takes to build the indexes? These indexes are all locally partitioned indexes. Thanks for any insight you can lend. Cherie Machler Oracle DBA Gelco Information
ORA-01000: maximum open cursors exceeded
We had this error show up the other day. I am wondering if there is a performance limit on how big you should set your OPEN_CURSORS parameter in the SID.init file? Mine currently is set at 300. Are there any guidelines on this setting? Just wondering. Thanks, Dave -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Farnsworth, Dave INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: starting an .exe job
In oracle manuals read about 'external' stored procedures. Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, February 08, 2002 2:18 AM Hi all, is it possible to start an arbitrary .exe out of PlSQL ??? I am running on NT4/Oracle 7.3.4 TNX Frank Foelz _ Scheidt Bachmann GmbH Gestaltung Parkhaussysteme Breite Strasse 132 41238 Moenchengladbach Phone : ++49 2166 / 266 - 837 Fax: ++49 2166 / 266 - 615 e-mail : mailto:[EMAIL PROTECTED] URL: http://www.scheidt-bachmann.de -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Foelz.Frank INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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).
RE: Weird connection behavior
You can get this message when the ORACLE_HOME is wrong in the listener.ora file; I am unsure about a wrong ORACLE_SID (CONNECT_DATA) in the tnsnames.ora file, it may be this message or another one. FYI there is a fairly complete list of what can go wrong and why with SQL*Net in the 'SQL*Net primer' paper in the 'First Steps' section of the Oriole site (URL below). - Original Message - From: Daiminger, Helmut [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Fri, 08 Feb 2002 03:48:18 Hi! I'm experiencing a weird behavior here: when I try to connect to an Instance - named ITSP - (I am locally on the server): user/pw@itsp, the connect works fine. But when I try to connect to that same database from my windows client, using user/pw@itsp, I get the message: Oracle not available. Any idea what is going on here? This is 8.1.7 on Sun Solaris. Thanks, Helmut Stephane Faroult Oriole Corporation Performance Tools Free Scripts -- http://www.oriole.com, designed by Oracle DBAs for Oracle DBAs -- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroul INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Error running catxsu.sql SUMMARY
http://home.clara.net/dwotton/dba/jsp_impl.htm Section Grant read permission on the input file solved the problem. -Original Message- Sent: Wednesday, February 06, 2002 5:38 PM To: Kirsch, Walter J (Northrop Grumman) FWIW - On a couple of occasions when I've seen errors like this, the solution was to drop reinstall the JVM inside Oracle. The down side is that after dropping the JVM, the instance needs to be bounced. YMMV HTH HAND! Kirsch, Walter J (Northrop Grumman) wrote: HP-UX 11.0 32-bit running 8.1.7.0.0 While trying to install the XML-XSU Utility, I followed the instructions in Using XML-SQL Utility (XSU) after step (1) loadjar'ing the xmlparser2, I ran step (2) sqlplus'ing the file catxsu.sql with the following result: --- ptmp:/opt/oracle/817/rdbms/admin sqlplus system/x @catxsu SQL*Plus: Release 8.1.7.0.0 - Production on Wed Feb 6 11:13:59 2002 (c) Copyright 2000 Oracle Corporation. All rights reserved. Connected to: Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production With the Partitioning option JServer Release 8.1.7.0.0 - Production call sys.dbms_java.loadjava ('-v -r -grant PUBLIC rdbms/jlib/xsu12.jar') * ERROR at line 1: ORA-29532: Java call terminated by uncaught Java exception: java.security.AccessControlException: the Permission (java.io.FilePermission /opt/oracle/817/rdbms/jlib/xsu12.jar read) has not been granted by dbms_java.grant_permission to SchemaProtectionDomain(SYSTEM|PolicyTableProxy(SYSTEM)) --the rest of the script ran without error. - Advice, anyone? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kirsch, Walter J (Northrop Grumman) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Charlie Mengler Maintenance Warehouse [EMAIL PROTECTED] 10641 Scripps Summit Ct. 858-831-2229 San Diego, CA 92131 You can lead some people to knowledge, but you can't make them think! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kirsch, Walter J (Northrop Grumman) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Instream SQL
I have a Unix batch script that calls a short (5 line) SQL script. Is there any way to include the SQL statements in the Unix script instead of calling the SQL? Ron Smith DBA Kerr-McGee Corp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Bitmap Indexes
Kirti, Just cureous. Normally bitmap indexes ae ae used for low cardinality columns. I am confused when you state - "Just one table uses it(bitmap index), with b-tree indexes for PKry and one other non-unique index" If you mean - you use Bitmap index for the non unique index with b-tree index for PKey I am OK with that. Shaibal From: "Deshpande, Kirti" <[EMAIL PROTECTED]> Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Subject: RE: Bitmap Indexes Date: Thu, 07 Feb 2002 19:58:20 -0800 Ethan, I have been using bitmap and b-tree indexes on the same table in our data mart since 7.3.4. Never had a problem with query performance. Now we have partitioned the tables in 8.1.7.x and most tables that were using bitmaps do not need to use them anymore. Just one table uses it, with b-tree indexes for PKry and one other non-unique index. No problems so far. The only issue we had with bitmap indexes was the way it used up extents, if those were not droppped before the dataloads. The problem still exists with 8.1.7.x. Have not tried with 9i yet.. HTH, - Kirti -Original Message- Sent: Thursday, February 07, 2002 3:07 PM To: Multiple recipients of list ORACLE-L Posted on behalf of a friend... Fellow Oracle data warehouse DBAs (if this isn't you, you can delete this note now): I have a question regarding Oracle's bitmap indexes. We have been DABBLING with bitmap indexes with mixed results here. In many cases, they are great solutions. In some cases, where we have a mix of bitmap and b-tree indexes on the same table, we occasionally get into trouble --- this has to do with the Oracle optimizer deciding, on the fly, to convert a regular b-tree index into a bitmap. It does this so that it can AND or OR the various bitmap indexes together. Sounds great on the surface but when this occurs, response time goes in the toilet. In one situation we have, we have a fact table with two bitmap indexes and a few other b-tree indexes. A particular query we run bogs down (NEVER COMPLETES) with this mix of indexes. Based on the access path that's being chosen, we know which b-tree index is being converted on the fly. If we convert that b-tree index into a bitmap (so we now have 3 bitmap indexes and Oracle does not need to create the third one on the fly), the query really runs well. If we replace the bitmap indexes with b-tree indexes (so we only have b-tree indexes), we get decent response times. (This is all on Oracle 8.1.7.2.0, by the way.) I'm wondering if the rest of you data warehouse DBAs have gone "whole hog" with bitmap indexes. My testing shows that when Oracle doesn't have to create a bitmap index on the fly, the queries respond wonderfully. So, I'm wondering if our dabbling is actually a bad validation approach and, instead, we should be 'running' with LOTS bitmap indexes instead of 'crawling' with only a few of them. In other words, maybe we're not "taking all of our medication", as someone else put it recently. Any insight would be most appreciated. I'm not looking for insight on the query I have used as an example. I'm looking for a generalized answer that says, "Yes, if you start using bitmap indexes, you should go TOTALLY to bitmap indexes" or, "Hmmm, we're using some bitmap indexes and some b-tree indexes and don't have the problem you have". -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Post, Ethan INET: [EMAIL PROTECTED] -- 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). MSN Photos is the easiest way to share and print your photos: Click Here -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Shaibal Talukder INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Free dbs / Mysql
Hello, We are working with Oracle 8.1.7.2 on Sun Solaris. We want to check if a free db can replace some of our Oracle databases. Is someone using a free database in production ? Any good or bad history ? Regards HEnrik -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Henrik Ekenber INET: [EMAIL PROTECTED] [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: TFM
April: OTN may have some things on Oracle Apps. Oracle's web site has some good documentation on this. You may also try www.oaug.com or www.oaug.org at this is the web site for the Oracle Applications User Group. They also have a list serve that has some great tuning ideas. Thank You Stephen P. Karniotis Technical Alliance Manager Compuware Corporation Direct: (248) 865-4350 Mobile: (248) 408-2918 Email: [EMAIL PROTECTED] Web:www.compuware.com -Original Message- Sent: Thursday, February 07, 2002 4:38 PM To: Multiple recipients of list ORACLE-L Subject:RE: TFM This is the beauty of Oracle Apps! -Original Message- Sent: Thursday, February 07, 2002 4:07 PM To: Multiple recipients of list ORACLE-L We are getting ready to sign a contract with Oracle for Financials. I have been looking for the manuals so I can read up on what their suggestions are for installation, tuning... for the 3000+ tables and associated other back end stuff... anyone know where they can be found. I can find some on Oracle Apps Net, but not really the kind of stuff I am looking for... are their other? April Wells Oracle DBA Corporate Systems Amarillo Texas begin 666 InterScan_Disclaimer.txt M5AE(EN9F]R;6%T:6]N(-O;G1A:6YE9!I;B!T:ES(4M;6%I;!IR!S M=')I8W1L2!C;VYF:61E;G1I86P@86YD(9OB!T:4@:6YT96YD960@=7-E M(]F('1H92!A91R97-S964@;VYL3L@:70@;6%Y(%LV\@8F4@;5G86QL M2!PFEV:6QE9V5D(%N9]OB!PFEC92!S96YS:71I=F4N(!.;W1I8V4@ M:7,@:5R96)Y(=I=F5N('1H870@86YY(1IV-L;W-UF4L('5S92!OB!C M;W!Y:6YG(]F('1H92!I;F9OFUA=EO;B!B2!A;GEO;F4@;W1H97(@=AA M;B!T:4@:6YT96YD960@F5C:7!I96YT(ES('!R;VAI8FET960@86YD(UA M2!B92!I;QE9V%L+B @268@6]U(AA=F4@F5C96EV960@=AIR!M97-S M86=E(EN(5RF]R+!P;5AV4@;F]T:69Y('1H92!S96YD97(@:6UM961I M871E;'D@8GD@F5T=7)N(4M;6%I;X*D-OG!OF%T92!37-T96US+!) M;F,N(AAR!T86ME;B!E=F5R2!R96%S;VYA8FQE('!R96-A=71I;VX@=\@ M96YS=7)E('1H870@86YY(%T=%C:UE;G0@=\@=AIR!E+6UA:6P@:%S M()E96X@W=E'0@9F]R('9IG5S97,N(!792!A8V-E'0@;F\@;EA8FEL M:71Y(9OB!A;GD@9%M86=E('-UW1A:6YE9!AR!A(')EW5L=!O9B!S M;V9T=V%R92!V:7)UV5S(%N9!A9'9IV4@6]U(-AG)Y(]U=!Y;W5R M(]W;B!V:7)UR!C:5C:W,@8F5F;W)E(]P96YI;F@86YY(%T=%C:UE %;G0N#0H end -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: April Wells INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Khedr, Waleed INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Karniotis, Stephen INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: TFM
April: Let me add to Bambi's wonderful comments. Administering Oracle Applications can be a daunting task. Like no other canned application you have ever implemented. Don't count on the product installing correctly 100%. Don't count on just installing it one time and then leaving it alone. I guarantee that you will be applying thousands of patches once the installation is complete???. This product needs A LOT of hand holding so get your boots on and be ready. There are many people in this and the OAUG forum that can help you. I would suggest reading the installation and configuration guide cover to cover and preparing you System Admins for hell. Thank You Stephen P. Karniotis Technical Alliance Manager Compuware Corporation Direct: (248) 865-4350 Mobile: (248) 408-2918 Email: [EMAIL PROTECTED] Web:www.compuware.com -Original Message- Sent: Thursday, February 07, 2002 4:53 PM To: Multiple recipients of list ORACLE-L Subject:RE: TFM April -- Get onto Metalink - Top Tech Docs. There's more there than you'll be able to read in a lifetime. One thing to know is that once you install Applications, your life as a DBA *will* change. Good luck! Bambi. -Original Message- Sent: Thursday, February 07, 2002 3:07 PM To: Multiple recipients of list ORACLE-L We are getting ready to sign a contract with Oracle for Financials. I have been looking for the manuals so I can read up on what their suggestions are for installation, tuning... for the 3000+ tables and associated other back end stuff... anyone know where they can be found. I can find some on Oracle Apps Net, but not really the kind of stuff I am looking for... are their other? April Wells Oracle DBA Corporate Systems Amarillo Texas begin 666 InterScan_Disclaimer.txt M5AE(EN9F]R;6%T:6]N(-O;G1A:6YE9!I;B!T:ES(4M;6%I;!IR!S M=')I8W1L2!C;VYF:61E;G1I86P@86YD(9OB!T:4@:6YT96YD960@=7-E M(]F('1H92!A91R97-S964@;VYL3L@:70@;6%Y(%LV\@8F4@;5G86QL M2!PFEV:6QE9V5D(%N9]OB!PFEC92!S96YS:71I=F4N(!.;W1I8V4@ M:7,@:5R96)Y(=I=F5N('1H870@86YY(1IV-L;W-UF4L('5S92!OB!C M;W!Y:6YG(]F('1H92!I;F9OFUA=EO;B!B2!A;GEO;F4@;W1H97(@=AA M;B!T:4@:6YT96YD960@F5C:7!I96YT(ES('!R;VAI8FET960@86YD(UA M2!B92!I;QE9V%L+B @268@6]U(AA=F4@F5C96EV960@=AIR!M97-S M86=E(EN(5RF]R+!P;5AV4@;F]T:69Y('1H92!S96YD97(@:6UM961I M871E;'D@8GD@F5T=7)N(4M;6%I;X*D-OG!OF%T92!37-T96US+!) M;F,N(AAR!T86ME;B!E=F5R2!R96%S;VYA8FQE('!R96-A=71I;VX@=\@ M96YS=7)E('1H870@86YY(%T=%C:UE;G0@=\@=AIR!E+6UA:6P@:%S M()E96X@W=E'0@9F]R('9IG5S97,N(!792!A8V-E'0@;F\@;EA8FEL M:71Y(9OB!A;GD@9%M86=E('-UW1A:6YE9!AR!A(')EW5L=!O9B!S M;V9T=V%R92!V:7)UV5S(%N9!A9'9IV4@6]U(-AG)Y(]U=!Y;W5R M(]W;B!V:7)UR!C:5C:W,@8F5F;W)E(]P96YI;F@86YY(%T=%C:UE %;G0N#0H end -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: April Wells INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Bellows, Bambi INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Karniotis, Stephen INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Help !! Password Encryption/decryption ??
Hello everybody , I am on 8.1.6/NT . i need to encrypt / decrypt the password of my users for my web based application. I went thro' DBMS_OBFUSCATION_TOOLKIT.DESEncrypt and DBMS_OBFUSCATION_TOOLKIT.DESDecrypt methods . but as per the docs , this package requires the password ( which is to be encrypted ) to be in multiples of 8 bytes . i don't think this is possible always . have i understood anything wrong ? can anyone throw some light on this . how do u guys encounter this situation ? any likely scripts plz ?!!! TIA. Jp. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Prem J Khanna INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Free dbs / Mysql
i heard postgress is pretty good from friends at .coms still in business :). [EMAIL PROTECTED] 02/08/02 08:58AM Hello, We are working with Oracle 8.1.7.2 on Sun Solaris. We want to check if a free db can replace some of our Oracle databases. Is someone using a free database in production ? Any good or bad history ? Regards HEnrik -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Henrik Ekenber INET: [EMAIL PROTECTED] [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Gene Sais INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: datafile compression
Keith, I've been using PKZip (version 4.00) under Win2k to zip and unzip Oracle export dump files for months without a hitch. In fact, I just now zipped and unzipped a 400MB 8i datafile with no errors. Are you sure there wasn't some other factor that affected the test you did? Do you have the latest version of PKZip? Command line PKZip would be my first choice. Jack Jack C. Applewhite Database Administrator/Developer OCP Oracle8 DBA iNetProfit, Inc. Austin, Texas www.iNetProfit.com [EMAIL PROTECTED] (512)327-9068 -Original Message- Worley Sent: Thursday, February 07, 2002 5:23 PM To: Multiple recipients of list ORACLE-L Hello everyone. Let me say first to all who are on the list group THANK YOU. From reading the emails I receive I have learned a LOT the past few weeks. My question here is. I am trying to find a way to compress the datafiles when I copy them to a backup folder on NT. Does anyone have a suggestion as to what product they use to compress datafiles? Has anyone ever used the COMPRESS option on a folder in NT to compress datafiles? If so, was there ever a problem. I did try pkzip and when the files unzipped it gave errors abour the crc checks. I also researched this and didn't find much about compressing datafiles BUT i'm not that good with the oracle doc's yet either. Thanks in advance for any responses to this email and everyone have a good day. -- 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: ORA-01000: maximum open cursors exceeded
no performance impact whatsoever . I have various Java applications that require huge number of cursors and i have limit set to 7500 without any issues Sam - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, February 08, 2002 5:03 PM We had this error show up the other day. I am wondering if there is a performance limit on how big you should set your OPEN_CURSORS parameter in the SID.init file? Mine currently is set at 300. Are there any guidelines on this setting? Just wondering. Thanks, Dave -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Farnsworth, Dave INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sam Roberts INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Scrolling Sideways in SQL*Plus
Hi ! Do all you have allready done and more: maximize the window. It usualy does the trick. Dias Costa [EMAIL PROTECTED] wrote: Hi, I set the linesize larger and the buffer etc.. I do get the scrollbar and there is data to the right of the screen, but the scrollbar just won't work HTH Jack Rachel Carmichael [EMAIL PROTECTED]@fatcity.com on 07-02-2002 15:08:33 Please respond to [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc:(bcc: Jack van Zanen/nlzanen1/External/MEY/NL) set linesize larger --- [EMAIL PROTECTED] wrote: Hi All, Maybe a stupid question but this is bugging me. In SQL*Plus I get a scrollbar sideways but can't use it even though there is data to the right of the screen. I looked at all the settings but can't find the setting to make it usable 8.1.6 8.1.7 Client on W2K Anybody??? TIA Jack === De informatie verzonden in dit e-mailbericht is vertrouwelijk en is uitsluitend bestemd voor de geadresseerde. Openbaarmaking, vermenigvuldiging, verspreiding en/of verstrekking van deze informatie aan derden is, behoudens voorafgaande schriftelijke toestemming van Ernst Young, niet toegestaan. Ernst Young staat niet in voor de juiste en volledige overbrenging van de inhoud van een verzonden e-mailbericht, noch voor tijdige ontvangst daarvan. Ernst Young kan niet garanderen dat een verzonden e-mailbericht vrij is van virussen, noch dat e-mailberichten worden overgebracht zonder inbreuk of tussenkomst van onbevoegde derden. Indien bovenstaand e-mailbericht niet aan u is gericht, verzoeken wij u vriendelijk doch dringend het e-mailbericht te retourneren aan de verzender en het origineel en eventuele kopieën te verwijderen en te vernietigen. Ernst Young hanteert bij de uitoefening van haar werkzaamheden algemene voorwaarden, waarin een beperking van aansprakelijkheid is opgenomen. De algemene voorwaarden worden u op verzoek kosteloos toegezonden. = The information contained in this communication is confidential and is intended solely for the use of the individual or entity to whom it is addressed. You should not copy, disclose or distribute this communication without the authority of Ernst Young. Ernst Young is neither liable for the proper and complete transmission of the information contained in this communication nor for any delay in its receipt. Ernst Young does not guarantee that the integrity of this communication has been maintained nor that the communication is free of viruses, interceptions or interference. If you are not the intended recipient of this communication please return the communication to the sender and delete and destroy all copies. In carrying out its engagements, Ernst Young applies general terms and conditions, which contain a clause that limits its liability. A copy of these terms and conditions is available on request free of charge. === -- 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!? Send FREE Valentine eCards with Yahoo! Greetings! http://greetings.yahoo.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). == De informatie verzonden in dit e-mailbericht is vertrouwelijk en is uitsluitend bestemd voor de geadresseerde. Openbaarmaking, vermenigvuldiging,
Re: ORA-01000: maximum open cursors exceeded
It only cost you memory on the server side - there is practically no performance hit. However, running out of open_cursors could be a sign of incorrectly coded applications, that would open and never close a cursor. You therefore need to keep an eye on this - v$open_cursor may be of interest. Thanks, Bjørn. Farnsworth, Dave wrote: We had this error show up the other day. I am wondering if there is a performance limit on how big you should set your OPEN_CURSORS parameter in the SID.init file? Mine currently is set at 300. Are there any guidelines on this setting? Just wondering. Thanks, Dave -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?ISO-8859-1?Q?Bj=F8rn?= Engsig INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Help !! Password Encryption/decryption ??
See the encryption article at www.cybcon.com/~jkstill Jared Prem J Khanna [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 02/08/02 06:08 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Help !! Password Encryption/decryption ?? Hello everybody , I am on 8.1.6/NT . i need to encrypt / decrypt the password of my users for my web based application. I went thro' DBMS_OBFUSCATION_TOOLKIT.DESEncrypt and DBMS_OBFUSCATION_TOOLKIT.DESDecrypt methods . but as per the docs , this package requires the password ( which is to be encrypted ) to be in multiples of 8 bytes . i don't think this is possible always . have i understood anything wrong ? can anyone throw some light on this . how do u guys encounter this situation ? any likely scripts plz ?!!! TIA. Jp. -- 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: TFM
April, You can also purchase the Oracle book Oracle Applications Performance Tuning Handbook by Andy Tremayne ISBN: 0-07-212549-7 ($59.99 US). I've found a few interesting things in it; it covers tuning of the database and the tiers, but not install and setup. Also check out Apps Net for some white papers he's written for the OAUG conferences (and Apps World?). The other Oracle Financials book (no idea of the title or ISBN #) I found very high level and not useful. Margaret -Original Message- From: April Wells [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 07, 2002 4:07 PM To: Multiple recipients of list ORACLE-L Subject: TFM We are getting ready to sign a contract with Oracle for Financials. I have been looking for the manuals so I can read up on what their suggestions are for installation, tuning... for the 3000+ tables and associated other back end stuff... anyone know where they can be found. I can find some on Oracle Apps Net, but not really the kind of stuff I am looking for... are their other? April Wells Oracle DBA Corporate Systems Amarillo Texas -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Murray, Margaret INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: high tkprof parse counts == real # of hard parses?
Re the soft parse: this is essentially hashing the SQL and getting a hit in the lib cache. These can't be avoided. There may be more going on than that, but it's much less work than a hard parse. Jared On Friday 08 February 2002 00:58, you wrote: v$sesstat splits this down into hard and soft parses. sys@cust col name format a30 sys@cust select * from v$statname 2 where name like '%parse%' 3 / STATISTIC# NAMECLASS -- -- -- 177 parse time cpu 64 178 parse time elapsed 64 179 parse count (total)64 180 parse count (hard) 64 You'll probably find that most are soft parses - still not great, but nowhere near as bad as hard ones. hth connor --- James Manning [EMAIL PROTECTED] wrote: I've seen what looks to be conflicting evidence, so I'm trying to get a handle on whether the tkprof output I'm seeing with the parse counts == execution counts is real or not: What gets me is that it even happens for static statements that are happening in triggers - like this statement that's part of a insert trigger for a table to set the PK from a seq. *** * SELECT OBL_ID_SEQ.NEXTVAL FROM DUAL call count cpuelapsed disk querycurrentrows --- -- -- -- -- -- -- Parse 7953 2.21 2.17 0 0 0 0 Execute 7953 1.18 1.24 0 0 0 0 Fetch 7953 1.25 1.22 0 7953 318217953 --- -- -- -- -- -- -- total23859 4.64 4.63 0 7953 318217953 Misses in library cache during parse: 0 Optimizer goal: CHOOSE Parsing user id: 36 (PR_SCHEMA) (recursive depth: 2) Rows Execution Plan --- --- 0 SELECT STATEMENT GOAL: CHOOSE 0 SEQUENCE OF 'OBL_ID_SEQ' 0TABLE ACCESS (FULL) OF 'DUAL' *** * I wanna believe the Parse count is wrong, but the elapsed and CPU time are way too high to believe that it's actually only be parsed once :( My shared pool is around 123MB at the moment - any way to definitely check whether that's the issue? seems like it shouldn't be given that size. Here's a statement called from a jdbc client that has the same problem (my sql traces show the vast majority of sql strings, called from clients or from inside pl/sql, are having this issue) *** * select RANK_AVAIL_SECONDS from overall_stats where USR_LOGNAME=:1 call count cpuelapsed disk querycurrentrows --- -- -- -- -- -- -- Parse 464 0.09 0.11 0 0 0 0 Execute464 0.12 0.11 0 0 0 0 Fetch 464 0.03 0.03 0 1393 0 464 --- -- -- -- -- -- -- total 1392 0.24 0.25 0 1393 0 464 Misses in library cache during parse: 1 Optimizer goal: CHOOSE Parsing user id: 36 (PR_SCHEMA) Rows Row Source Operation --- --- 1 TABLE ACCESS BY INDEX ROWID OVERALL_STATS 2 INDEX RANGE SCAN (object id 68692) Rows Execution Plan --- --- 0 SELECT STATEMENT GOAL: CHOOSE 1 TABLE ACCESS GOAL: ANALYZED (BY INDEX ROWID) OF 'OVERALL_STATS' 2INDEX (RANGE SCAN) OF 'OSTATS_LOGN_IDX' (NON-UNIQUE) *** * I certainly appreciate any pointers or insights that can be provided - I just don't get why all these reparse's are happening. In case it helps any, I *do* see these statements in the v$sql view - in fact the second one had high enough buffer_gets that I figured out a missing index :) Thanks! James -- James Manning [EMAIL PROTECTED] GPG Key fingerprint = B913 2FBD 14A9 CE18 B2B7 9C8E A0BF B026 EEBB F6E4 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: James Manning INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego,
DO YOU HAVE ANY DATABASE RUNNING ACTIVE 1000 SESSIONS ?
My question is DO YOU HAVE ANY DATABASE RUNNING ACTIVE 1000 SESSIONS ON NT ? I WILL TRY Multi Threaded Server BUT STILL I HAVE DOUBTS ? DO YOU HAVE LINKS TO ADVICE ME TO READ ABOUT THIS POINT ? ( HIGH CONNECTION/TRANSACTION NUMBER PER SECOND) THANK YOU
RE: Where does a DBA go from here?
Rich, The best Oracle training I've ever had by far is playing around with a small test DB on a laptop or PC. Stress it, hurt it, recover it, tune it, etc., etc. When done in conjunction with one of the fine books mentioned by others on this list - even better. I've only had one official Oracle training course - in the spring of 1989. It was 4-1/2 days of RDBMS v5, SQL*Forms and RPT/RPF. Since then I've attended some of the mini courses at IOUG, ODTUG, Open World, etc. - nice little hits of the latest technologies. I studied for my Oracle8 OCP exams by working through Jason Couchman's book and beating up an 8.0.5 DB on my PC - learned a hell of a lot. My on-going study plan for Oracle skills boils down to Beating, Browsing and Books. - Beat up a test database - Browse fine Web sites like Steve Adams' IXORA (and beat up the DB) - Buy and read good books (and beat up the DB) I think I've learned about as much as if I'd sat in a bunch of classes - and saved a pile of money. ;-) 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: 07 February 2002 21:07 To: Multiple recipients of list ORACLE-L So, there I am. I've taken the main Oracle courses -- Intro to SQL, DBA (Oracle 7!), Backup Recovery, Network Admin, and Perf Tuning. Now where do I go for more Oracle training? This is sparked by a recent perceived lag in one of our new databases. We've tracked it down to a possible hot block or two, but I never used X$BH or V$LATCH_CHILDREN in any of my Oracle classes. And I *know* I'm far from being ready for an Internals class. So how do I get from here to there? education.oracle.com doesn't seem to have a whole lot other than Internals. Or is that where I'm at now? Confused and no beer. Rich JesseSystem/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -- 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: TFM
Keep thinking it, April, and feel free to send me an email when you feel like you're going to explode. -Original Message- Sent: Friday, February 08, 2002 6:48 AM To: Multiple recipients of list ORACLE-L THANK you! I kinda had a hunch that life would change... When I worked for US Steel, their Mississippi plant installed Financials and I had to send id IMS data... I wasn't wild about it then, and I wasn't directly connected. I just keep thinking... it's a learning experience... it's a learning experience... April -Original Message- Sent: Thursday, February 07, 2002 3:53 PM To: Multiple recipients of list ORACLE-L April -- Get onto Metalink - Top Tech Docs. There's more there than you'll be able to read in a lifetime. One thing to know is that once you install Applications, your life as a DBA *will* change. Good luck! Bambi. -Original Message- Sent: Thursday, February 07, 2002 3:07 PM To: Multiple recipients of list ORACLE-L We are getting ready to sign a contract with Oracle for Financials. I have been looking for the manuals so I can read up on what their suggestions are for installation, tuning... for the 3000+ tables and associated other back end stuff... anyone know where they can be found. I can find some on Oracle Apps Net, but not really the kind of stuff I am looking for... are their other? April Wells Oracle DBA Corporate Systems Amarillo Texas begin 666 InterScan_Disclaimer.txt M5AE(EN9F]R;6%T:6]N(-O;G1A:6YE9!I;B!T:ES(4M;6%I;!IR!S M=')I8W1L2!C;VYF:61E;G1I86P@86YD(9OB!T:4@:6YT96YD960@=7-E M(]F('1H92!A91R97-S964@;VYL3L@:70@;6%Y(%LV\@8F4@;5G86QL M2!PFEV:6QE9V5D(%N9]OB!PFEC92!S96YS:71I=F4N(!.;W1I8V4@ M:7,@:5R96)Y(=I=F5N('1H870@86YY(1IV-L;W-UF4L('5S92!OB!C M;W!Y:6YG(]F('1H92!I;F9OFUA=EO;B!B2!A;GEO;F4@;W1H97(@=AA M;B!T:4@:6YT96YD960@F5C:7!I96YT(ES('!R;VAI8FET960@86YD(UA M2!B92!I;QE9V%L+B @268@6]U(AA=F4@F5C96EV960@=AIR!M97-S M86=E(EN(5RF]R+!P;5AV4@;F]T:69Y('1H92!S96YD97(@:6UM961I M871E;'D@8GD@F5T=7)N(4M;6%I;X*D-OG!OF%T92!37-T96US+!) M;F,N(AAR!T86ME;B!E=F5R2!R96%S;VYA8FQE('!R96-A=71I;VX@=\@ M96YS=7)E('1H870@86YY(%T=%C:UE;G0@=\@=AIR!E+6UA:6P@:%S M()E96X@W=E'0@9F]R('9IG5S97,N(!792!A8V-E'0@;F\@;EA8FEL M:71Y(9OB!A;GD@9%M86=E('-UW1A:6YE9!AR!A(')EW5L=!O9B!S M;V9T=V%R92!V:7)UV5S(%N9!A9'9IV4@6]U(-AG)Y(]U=!Y;W5R M(]W;B!V:7)UR!C:5C:W,@8F5F;W)E(]P96YI;F@86YY(%T=%C:UE M;G0N#0I4:4@:6YF;W)M871I;VX@8V]N=%I;F5D(EN('1H:7,@92UM86EL M(ES('-TFEC=QY(-O;F9I95N=EA;!A;F0@9F]R('1H92!I;G1E;F1E M9!UV4@;V8@=AE(%D9')EW-E92!O;FQY.R!I=!M87D@86QS;R!B92!L M96=A;QY('!R:79I;5G960@86YD+V]R('!R:6-E('-E;G-I=EV92X@($YO M=EC92!IR!H97)E8GD@9VEV96X@=AA=!A;GD@9ES8VQOW5R92P@=7-E M(]R(-O'EI;F@;V8@=AE(EN9F]R;6%T:6]N()Y(%N6]N92!O=AE MB!T:%N('1H92!I;G1E;F1E9!R96-IEE;G0@:7,@')O:EB:71E9!A M;F0@;6%Y()E(EL;5G86PN(!)9B!Y;W4@:%V92!R96-E:79E9!T:ES M(UEW-A9V4@:6X@97)R;W(L('!L96%S92!N;W1I9GD@=AE('-E;F1EB!I M;6UE9EA=5L2!B2!R971UFX@92UM86EL+@H*0V]R]R871E(%-YW1E M;7,L($EN8RX@:%S('1A:V5N(5V97)Y(')E87-O;F%B;4@')E8V%U=EO M;B!T;R!E;G-UF4@=AA=!A;GD@871T86-H;65N=!T;R!T:ES(4M;6%I M;!H87,@8F5E;B!S=V5P=!F;W(@=FER=7-ERX@(%=E(%C8V5P=!N;R!L M:6%B:6QI='D@9F]R(%N2!D86UA9V4@W5S=%I;F5D(%S($@F5S=6QT M(]F('-O9G1W87)E('9IG5S97,@86YD(%D=FES92!Y;W4@8V%RGD@;W5T M('EO=7(@;W=N('9IG5S(-H96-KR!B969OF4@;W!E;FEN9R!A;GD@871T ,86-H;65N=X-@T* end -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: April Wells INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Bellows, Bambi INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: April Wells INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT
RE: Instream SQL
I'm a little confused. It sounds like what you're trying to do is: #!/bin/ksh echo Look at me! I'm in a Unix script! sleep 5 sqlplus EOF system/incredibly_secret_password select 'Look at me... here in SQL*Plus! Life is grand!' from dual; !echo Where am I? I'm so confused! There's an orange elephant here! exit EOF echo Wasn't that fun? exit HTH, Bambi. -Original Message- Sent: Friday, February 08, 2002 8:23 AM To: Multiple recipients of list ORACLE-L I have a Unix batch script that calls a short (5 line) SQL script. Is there any way to include the SQL statements in the Unix script instead of calling the SQL? Ron Smith DBA Kerr-McGee Corp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bellows, Bambi INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: MAX_IO_SIZE and Temp Next Extent approach to ORA-03232 Error
When i had this problem i put initial and next extent size of temporary tablespace equal or greater than MAX_IO_SIZE. Example: With MAX_IO_SIZE= 128K the default storage for the initial and next extent must be = (128 * 1024) = 131072 bytes. MAX_IO_SIZE is an Operating system dependant parameter. you can find MAX_IO_SIZE putting db_file_multiblock_read_count = 100 and than trace a full table scan, look in the trace and find the third field in wait: db file scattered read to find number of bd_block read for any I/O operation. Ciao - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, February 08, 2002 1:28 AM Listers, Environment: Solaris 7 running 64 Bit Oracle 8.1.7.2.x. Received an ORA-03232 error this morning after bumping up the HASH_AREA_SIZE on a QA box overnight. HASH_MULTIBLOCK_IO_COUNT is 0, and has been 0 for as long as I know, meaning that Oracle calculates the value on the fly for each individual SQL statement. From information found in Metalink forums, etc, it appears that this has popped up on lots of people after bumping up HASH_AREA_SIZE. Though I couldn't find anything describing *how* Oracle calc's the HASH_MULTIBLOCK_IO_COUNT when set to zero, it appears the HASH_AREA_SIZE plays some role, based on Usenet and MetaLink forum comments. Anyway, to the question. Some of the Oracle notes say that as long as the NEXT extent size for the TEMP tablespace is greater than MAX_IO_SIZE, which is OS dependent (and on Solaris defined by maxphys, I think) the problem should go away. But, some folks posting in the forums say that even if they went with something along the lines of 1 MB for initial and next, with a max_io_size of 128K, they still encountered the error. Anyway, the quick fix was to set HASH_MUTLIBLOCK_IO_COUNT to 2 since this could be done with an ALTER SYSTEM command. But I am curious what other people may have done who have run into with this. We eventually would like to go back to a HASH_MULTIBLOCK_IO_COUNT of 0, if only because Oracle recommends that (good advice?), and address this through appropriate TEMP extent sizing. Heck, you could make the extents pretty large but you would like to know up front if the fix will work. So that's why I ask for feedback here. A TAR will be opened through the point of contact that handles TAR's. We hope to get an official word from Oracle on this. But, the fact that some people have said the extent size bigger than max_io_size didn't work has us wondering. Regards, Larry G. Elkins [EMAIL PROTECTED] 214.954.1781 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Larry Elkins INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: claudio cutelli INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: high tkprof parse counts == real # of hard parses?
[Daniþment Gazi Ünal] it looks like not normal. can you run your trace file by http://www.unal-bilisim.com/products/itrprof/itrprof.html . if results same, can you email me your raw file ? When I ran it through that, it claimed only 18 hard parses which makes me feel a *lot* better. But then, why isn't tkprof more clear on soft vs. hard parses? :( In any case, it looks like it's not the problem I thought it was. -- James Manning [EMAIL PROTECTED] GPG Key fingerprint = B913 2FBD 14A9 CE18 B2B7 9C8E A0BF B026 EEBB F6E4 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: James Manning INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Help !! Password Encryption/decryption ??
Title: RE: Help !! Password Encryption/decryption ?? Here it is for any length. SELECT RPAD('thestring',LENGTH('thestring') + 8 - DECODE(MOD(length('thestring'),8),0,8,MOD(length('thestring'),8)),' ') ||'' AS 12345678901234567890 FROM DUAL Tony Aponte -Original Message- From: Aponte, Tony Sent: Friday, February 08, 2002 11:32 AM To: '[EMAIL PROTECTED]' Cc: '[EMAIL PROTECTED]' Subject: RE: Help !! Password Encryption/decryption ?? How about right-padding the string to a multiple of 8 bytes. I think 8-MOD(LENGTH(string),8) will give you the number of characters to use in RPAD(string,...). E.I.. to pad with blanks: SELECT RPAD('123456789',LENGTH('123456789') + 8 - mod(length('12345678'),8),' ') AS 12345678901234567890 FROM DUAL 1234567890123456 123456789 HTH Tony Aponte -Original Message- From: Prem J Khanna [mailto:[EMAIL PROTECTED]] Sent: Friday, February 08, 2002 9:08 AM To: Multiple recipients of list ORACLE-L Subject: Help !! Password Encryption/decryption ?? Hello everybody , I am on 8.1.6/NT . i need to encrypt / decrypt the password of my users for my web based application. I went thro' DBMS_OBFUSCATION_TOOLKIT.DESEncrypt and DBMS_OBFUSCATION_TOOLKIT.DESDecrypt methods . but as per the docs , this package requires the password ( which is to be encrypted ) to be in multiples of 8 bytes . i don't think this is possible always . have i understood anything wrong ? can anyone throw some light on this . how do u guys encounter this situation ? any likely scripts plz ?!!! TIA. Jp. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Prem J Khanna INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
URGENT Help on tracking unauthorized login to Oracle Database
Greetings, We have a database with very sensitive data. Our management wants me to find out the way to secure this data from unauthorized login and track these users who tried to login to this database. Is there any way we can track the unauthorized users, who try to login to an oracle database with invalid userid or password but with valid connect string. If there is no options under oracle then is there any 3rd party software for this purpose. Any help is appreciated Thanks, Ashoke -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mandal, Ashoke INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Script stops running.
Hi all, I get a perl script to telnet to several machines on network to check something I want to check. When it trys to connect a machine which is down, the script will stop running. How do I tell it to continue to check the next machine and ignore the one down?. Below is my script. Thanks, David == #!/usr/local/bin/perl -w use Net::Telnet; %city = qw(host1 passwd host2 passwd host3 passwd host4 passwd ); $telnet = Net::Telnet-new ( Timeout = 10, Input_log = 'PSXreplication.log', Prompt = ('/[%:] $/'), ); foreach $key (sort keys %city) { $telnet-prompt(/$key%/i); $telnet-open($key); $telnet-login('ssuser', $city{$key}); $telnet-prompt(/$key%/i); $telnet-cmd('ls -l'); print =\n\n; $telnet-close($key); } -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nguyen, David M INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Antwort: Help !! Password Encryption/decryption ??
Hi Prem, If you want to use des to encrypt and decrypt you have to pad the data to multiples of 8 byte ( i.e. fill the missing bytes with zero). IMHO using symetric encryption to protect passwds is dangerous Alex Apostolopoulos ___ WebTechnology Smart Card Solutions Secartis AG-eSolutions by Giesecke Devrient Bretonischer Ring 3, D-85630 Grasbrunn, Germany Phone: +49(0)89 4119-7086, Fax: +49(0)89 4119-7403 Email: [EMAIL PROTECTED], Home: www.secartis.com ___ |++| || Prem J Khanna|| || [EMAIL PROTECTED]| An: | || Gesendet von:| Multiple recipients | || [EMAIL PROTECTED] | of list ORACLE-L | ||| [EMAIL PROTECTED]| || 08.02.2002 15:08 | | || Bitte antworten an | Kopie: | || ORACLE-L || ||| Thema: | ||| Help !! Password | ||| Encryption/decryption| ||| ?? | |++| Hello everybody , I am on 8.1.6/NT . i need to encrypt / decrypt the password of my users for my web based application. I went thro' DBMS_OBFUSCATION_TOOLKIT.DESEncrypt and DBMS_OBFUSCATION_TOOLKIT.DESDecrypt methods . but as per the docs , this package requires the password ( which is to be encrypted ) to be in multiples of 8 bytes . i don't think this is possible always . have i understood anything wrong ? can anyone throw some light on this ... how do u guys encounter this situation ? any likely scripts plz ?!!! TIA. Jp. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Prem J Khanna INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: capacity planning??
Shibu, Go to http://www.orapub.com Craig Shallahamer is THE Guru on the subject. I took his course a couple years ago - excellent! Jack Jack C. ApplewhiteDatabase Administrator/DeveloperOCP Oracle8 DBAiNetProfit, Inc.Austin, Texaswww.iNetProfit.com[EMAIL PROTECTED](512)327-9068 -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of ShibuSent: Friday, February 08, 2002 12:13 AMTo: Multiple recipients of list ORACLE-LSubject: capacity planning?? Hi all Can anyone send me a doc or white paper on capcity planning?? regards, shibu
RE: Bitmap Indexes
Shaibal, That one table has a low cardinality column and has a bit map index on it. In addition, the table has indexes on other columns. Hope this is clear now. - Kirti -Original Message-From: Shaibal Talukder [mailto:[EMAIL PROTECTED]]Sent: Friday, February 08, 2002 7:58 AMTo: Multiple recipients of list ORACLE-LSubject: RE: Bitmap Indexes Kirti, Just cureous. Normally bitmap indexes ae ae used for low cardinality columns. I am confused when you state - "Just one table uses it(bitmap index), with b-tree indexes for PKry and one other non-unique index" If you mean - you use Bitmap index for the non unique index with b-tree index for PKey I am OK with that. Shaibal From: "Deshpande, Kirti" <[EMAIL PROTECTED]> Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Subject: RE: Bitmap Indexes Date: Thu, 07 Feb 2002 19:58:20 -0800 Ethan, I have been using bitmap and b-tree indexes on the same table in our data mart since 7.3.4. Never had a problem with query performance. Now we have partitioned the tables in 8.1.7.x and most tables that were using bitmaps do not need to use them anymore. Just one table uses it, with b-tree indexes for PKry and one other non-unique index. No problems so far. The only issue we had with bitmap indexes was the way it used up extents, if those were not droppped before the dataloads. The problem still exists with 8.1.7.x. Have not tried with 9i yet.. HTH, - Kirti -Original Message- Sent: Thursday, February 07, 2002 3:07 PM To: Multiple recipients of list ORACLE-L Posted on behalf of a friend... Fellow Oracle data warehouse DBAs (if this isn't you, you can delete this note now): I have a question regarding Oracle's bitmap indexes. We have been DABBLING with bitmap indexes with mixed results here. In many cases, they are great solutions. In some cases, where we have a mix of bitmap and b-tree indexes on the same table, we occasionally get into trouble --- this has to do with the Oracle optimizer deciding, on the fly, to convert a regular b-tree index into a bitmap. It does this so that it can AND or OR the various bitmap indexes together. Sounds great on the surface but when this occurs, response time goes in the toilet. In one situation we have, we have a fact table with two bitmap indexes and a few other b-tree indexes. A particular query we run bogs down (NEVER COMPLETES) with this mix of indexes. Based on the access path that's being chosen, we know which b-tree index is being converted on the fly. If we convert that b-tree index into a bitmap (so we now have 3 bitmap indexes and Oracle does not need to create the third one on the fly), the query really runs well. If we replace the bitmap indexes with b-tree indexes (so we only have b-tree indexes), we get decent response times. (This is all on Oracle 8.1.7.2.0, by the way.) I'm wondering if the rest of you data warehouse DBAs have gone "whole hog" with bitmap indexes. My testing shows that when Oracle doesn't have to create a bitmap index on the fly, the queries respond wonderfully. So, I'm wondering if our dabbling is actually a bad validation approach and, instead, we should be 'running' with LOTS bitmap indexes instead of 'crawling' with only a few of them. In other words, maybe we're not "taking all of our medication", as someone else put it recently. Any insight would be most appreciated. I'm not looking for insight on the query I have used as an example. I'm looking for a generalized answer that says, "Yes, if you start using bitmap indexes, you should go TOTALLY to bitmap indexes" or, "Hmmm, we're using some bitmap indexes and some b-tree indexes and don't have the problem you have". -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Post, Ethan INET: [EMAIL PROTECTED] -- 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). MSN Photos is the easiest way to share and print your photos: Click Here-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Shaibal Talukder INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself
Re: Instream SQL
I have a Unix batch script that calls a short (5 line) SQL script. Is there any way to include the SQL statements in the Unix script instead of calling the SQL? #!/bin/sh sqlplus user/pass EOF select update delete EOF -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nicolai Tufar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Help !! Password Encryption/decryption ??
You could get creative by using RPAD() or LPAD() ... 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! -Original Message- Sent: Friday, February 08, 2002 9:08 AM To: Multiple recipients of list ORACLE-L Hello everybody , I am on 8.1.6/NT . i need to encrypt / decrypt the password of my users for my web based application. I went thro' DBMS_OBFUSCATION_TOOLKIT.DESEncrypt and DBMS_OBFUSCATION_TOOLKIT.DESDecrypt methods . but as per the docs , this package requires the password ( which is to be encrypted ) to be in multiples of 8 bytes . i don't think this is possible always . have i understood anything wrong ? can anyone throw some light on this . how do u guys encounter this situation ? any likely scripts plz ?!!! TIA. Jp. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Prem J Khanna INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). ***1 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 ESPN at (860) 766-2000 and delete this e-mail message from your computer, Thank you. ***1
Re: Bitmap Indexes
Hi, Here is an article about it bitmap indexes ... I hope this gives you information. Helen - Original Message - From: Shaibal Talukder To: Multiple recipients of list ORACLE-L Sent: Friday, February 08, 2002 6:58 AM Subject: RE: Bitmap Indexes Kirti, Just cureous. Normally bitmap indexes ae ae used for low cardinality columns. I am confused when you state - "Just one table uses it(bitmap index), with b-tree indexes for PKry and one other non-unique index" If you mean - you use Bitmap index for the non unique index with b-tree index for PKey I am OK with that. Shaibal From: "Deshpande, Kirti" <[EMAIL PROTECTED]> Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Subject: RE: Bitmap Indexes Date: Thu, 07 Feb 2002 19:58:20 -0800 Ethan, I have been using bitmap and b-tree indexes on the same table in our data mart since 7.3.4. Never had a problem with query performance. Now we have partitioned the tables in 8.1.7.x and most tables that were using bitmaps do not need to use them anymore. Just one table uses it, with b-tree indexes for PKry and one other non-unique index. No problems so far. The only issue we had with bitmap indexes was the way it used up extents, if those were not droppped before the dataloads. The problem still exists with 8.1.7.x. Have not tried with 9i yet.. HTH, - Kirti -Original Message- Sent: Thursday, February 07, 2002 3:07 PM To: Multiple recipients of list ORACLE-L Posted on behalf of a friend... Fellow Oracle data warehouse DBAs (if this isn't you, you can delete this note now): I have a question regarding Oracle's bitmap indexes. We have been DABBLING with bitmap indexes with mixed results here. In many cases, they are great solutions. In some cases, where we have a mix of bitmap and b-tree indexes on the same table, we occasionally get into trouble --- this has to do with the Oracle optimizer deciding, on the fly, to convert a regular b-tree index into a bitmap. It does this so that it can AND or OR the various bitmap indexes together. Sounds great on the surface but when this occurs, response time goes in the toilet. In one situation we have, we have a fact table with two bitmap indexes and a few other b-tree indexes. A particular query we run bogs down (NEVER COMPLETES) with this mix of indexes. Based on the access path that's being chosen, we know which b-tree index is being converted on the fly. If we convert that b-tree index into a bitmap (so we now have 3 bitmap indexes and Oracle does not need to create the third one on the fly), the query really runs well. If we replace the bitmap indexes with b-tree indexes (so we only have b-tree indexes), we get decent response times. (This is all on Oracle 8.1.7.2.0, by the way.) I'm wondering if the rest of you data warehouse DBAs have gone "whole hog" with bitmap indexes. My testing shows that when Oracle doesn't have to create a bitmap index on the fly, the queries respond wonderfully. So, I'm wondering if our dabbling is actually a bad validation approach and, instead, we should be 'running' with LOTS bitmap indexes instead of 'crawling' with only a few of them. In other words, maybe we're not "taking all of our medication", as someone else put it recently. Any insight would be most appreciated. I'm not looking for insight on the query I have used as an example. I'm looking for a generalized answer that says, "Yes, if you start using bitmap indexes, you should go TOTALLY to bitmap indexes" or, "Hmmm, we're using some bitmap indexes and some b-tree indexes and don't have the problem you have". -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Post, Ethan INET: [EMAIL PROTECTED] -- 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). MSN Photos is the easiest way to share and print your photos: Click Here-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Shaibal Talukder INET: [EMAIL PROTECTED] Fat City Network Services
RE: Where does a DBA go from here?
OK, from the responses, here's The Plan: 1) Get beer. I prefer Guinness or Goose Island. Done. 2) Get Oracle Perf Tuning 101. Done. 3) Get more beer. 4) Beat up on some test DBs, and work on real live DBs to engrain that class material into the surviving brain cells (see Step 1). Sorta done with this one, but I need more. The 22 DBs here at work and 1 at home ought to help! 5) Get more beer. 6) Go to Oracle conferences. I need to go 7) Get more beer. 8) Hit the web, preferrably with beer in non-mouse hand. (Wisconsin twin-can beer hat optional) 9) Go to Internals class and actually understand and learn from it. Yay! 10) Get lots more beer. 11) Actually do some work here. Sounds good folks. I think I'm on the right track (sans beer at work, of course), with my Oracle course work completed over a year ago, and some DBA experiences under my belt. Time to plunk away at more DBs! Thanks! :) Rich JesseSystem/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA President, Beer Ale Lager Lovers Society http://www.westbend.net/~legoman -Original Message- Sent: Friday, February 08, 2002 8:58 AM To: Multiple recipients of list ORACLE-L Rich, The best Oracle training I've ever had by far is playing around with a small test DB on a laptop or PC. Stress it, hurt it, recover it, tune it, etc., etc. When done in conjunction with one of the fine books mentioned by others on this list - even better. I've only had one official Oracle training course - in the spring of 1989. It was 4-1/2 days of RDBMS v5, SQL*Forms and RPT/RPF. Since then I've attended some of the mini courses at IOUG, ODTUG, Open World, etc. - nice little hits of the latest technologies. I studied for my Oracle8 OCP exams by working through Jason Couchman's book and beating up an 8.0.5 DB on my PC - learned a hell of a lot. My on-going study plan for Oracle skills boils down to Beating, Browsing and Books. - Beat up a test database - Browse fine Web sites like Steve Adams' IXORA (and beat up the DB) - Buy and read good books (and beat up the DB) I think I've learned about as much as if I'd sat in a bunch of classes - and saved a pile of money. ;-) 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: 07 February 2002 21:07 To: Multiple recipients of list ORACLE-L So, there I am. I've taken the main Oracle courses -- Intro to SQL, DBA (Oracle 7!), Backup Recovery, Network Admin, and Perf Tuning. Now where do I go for more Oracle training? This is sparked by a recent perceived lag in one of our new databases. We've tracked it down to a possible hot block or two, but I never used X$BH or V$LATCH_CHILDREN in any of my Oracle classes. And I *know* I'm far from being ready for an Internals class. So how do I get from here to there? education.oracle.com doesn't seem to have a whole lot other than Internals. Or is that where I'm at now? Confused and no beer. Rich JesseSystem/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: URGENT Help on tracking unauthorized login to Oracle Database
Administrators guide chapter on auditing. joe Mandal, Ashoke wrote: Greetings, We have a database with very sensitive data. Our management wants me to find out the way to secure this data from unauthorized login and track these users who tried to login to this database. Is there any way we can track the unauthorized users, who try to login to an oracle database with invalid userid or password but with valid connect string. If there is no options under oracle then is there any 3rd party software for this purpose. Any help is appreciated Thanks, Ashoke -- 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: Where does a DBA go from here?
Can anyone tell me if Steve's book contains details that would be useful in understanding the Wait Interface that Tuning 101 covers? Or would it be more redundant from that aspect? Thanks. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, February 08, 2002 5:18 AM To: Multiple recipients of list ORACLE-L I agree, get the pints in first. Worry about Oracle later. When you do come to it, try Oracle8i internal services for waits, latches, locks and memory by Steve Adams. And of course book. Jim -Original Message- Lee - lerobe Sent: 08 February 2002 09:58 To: Multiple recipients of list ORACLE-L Its Friday, the immediate solution is get beer !! As to your other problem its text book time - take a look at Tuning 101 by the lists own Kirti and Gaja. Lee -Original Message- Sent: 07 February 2002 21:07 To: Multiple recipients of list ORACLE-L So, there I am. I've taken the main Oracle courses -- Intro to SQL, DBA (Oracle 7!), Backup Recovery, Network Admin, and Perf Tuning. Now where do I go for more Oracle training? This is sparked by a recent perceived lag in one of our new databases. We've tracked it down to a possible hot block or two, but I never used X$BH or V$LATCH_CHILDREN in any of my Oracle classes. And I *know* I'm far from being ready for an Internals class. So how do I get from here to there? education.oracle.com doesn't seem to have a whole lot other than Internals. Or is that where I'm at now? Confused and no beer. Rich JesseSystem/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computer system. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robertson Lee - lerobe INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: James McCann INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: datafile compression
I've been using PKZip GUI for years and never have had a problem. Jack C. Applewhite To: Multiple recipients of list ORACLE-L japplewhite [EMAIL PROTECTED] @inetprofit.ccc: om Subject: RE: datafile compression Sent by: root 02/08/2002 11:03 AM Please respond to ORACLE-L Keith, I've been using PKZip (version 4.00) under Win2k to zip and unzip Oracle export dump files for months without a hitch. In fact, I just now zipped and unzipped a 400MB 8i datafile with no errors. Are you sure there wasn't some other factor that affected the test you did? Do you have the latest version of PKZip? Command line PKZip would be my first choice. Jack Jack C. Applewhite Database Administrator/Developer OCP Oracle8 DBA iNetProfit, Inc. Austin, Texas www.iNetProfit.com [EMAIL PROTECTED] (512)327-9068 -Original Message- Worley Sent: Thursday, February 07, 2002 5:23 PM To: Multiple recipients of list ORACLE-L Hello everyone. Let me say first to all who are on the list group THANK YOU. From reading the emails I receive I have learned a LOT the past few weeks. My question here is. I am trying to find a way to compress the datafiles when I copy them to a backup folder on NT. Does anyone have a suggestion as to what product they use to compress datafiles? Has anyone ever used the COMPRESS option on a folder in NT to compress datafiles? If so, was there ever a problem. I did try pkzip and when the files unzipped it gave errors abour the crc checks. I also researched this and didn't find much about compressing datafiles BUT i'm not that good with the oracle doc's yet either. Thanks in advance for any responses to this email and everyone have a good day. -- 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). -- 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: What impacts index build times on partitioned tables?
Cherie, Now, --Yes, we have parallel set to six Do you have enough physical memory and CPU power/faster drives for writing to handle this number of parallel process as it is intensive on such resources specially available memory at that time plus writing capabilty of your drives. There may be possible bottlenecks. Just check. If you are using tool 'glance' this will give you a good idea while running this process. Nologging is fine. You are checking sort area size right... What about temp tablespace and target tablespace fragmentation... Regards Rafiq Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: Fri, 08 Feb 2002 04:43:25 -0800 Rafiq, Yes, we have parallel set to six. We are using nologging. I am checking on the sort_area_size. Thanks, Cherie Mohammad Rafiq To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] rafiq9857@hot cc: mail.comSubject: RE: What impacts index build times on partitioned tables? Sent by: [EMAIL PROTECTED] om 02/07/02 03:06 PM Please respond to ORACLE-L Please check following Are you creating indexes with parallel clause or not? Are you using unrecoverable/nologging or not Is your sort_area_size is ok? What type of TEMP tablespace are you using with temp file or datafile and sizing of extents are proper? Is your target tablespace is not that much fragmented? Regards Rafiq Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: Thu, 07 Feb 2002 08:55:47 -0800 Yechiel, There is no other activity in this warehouse database while the index builds are being done. The users access is shut off, no batch jobs for this database are running, and the nightly data loads have already finished. Thanks, Cherie àãø éçéàì adary@mehish. To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] co.il cc: Sent by: Subject: RE: What impacts index build times on partitioned tables? [EMAIL PROTECTED] om 02/07/02 10:20 AM Please respond to ORACLE-L I think that it is related to the activity against the DB. Not only there is more load on the DB but access path that use the index can default to full table scan if the index is not available because you are rebuilding it just now. Yechiel Adar, Mehish Computer Services [EMAIL PROTECTED] -Original Message- From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] Sent: Thu, February 07, 2002 5:55 PM To: Multiple recipients of list ORACLE-L Subject: What impacts index build times on partitioned tables? We drop and recreate many indexes on our large partitioned fact table in our data warehouse nightly. The amount of data in the table increases gradually with time but there aren't huge fluctuations in the amount of data in the partitions from day to day. The problem is that the amount of time that it takes to recreate the indexes varies widely. From 40 minutes to almost three hours. I am inclined to believe that this is a scheduling issue related to the time of the day and the day of the week. I think we may be experiencing competition from other batch jobs from other applications. One application, in particular, is sort of a black box because it is not on Oracle and it belongs to people who reside in a remote site. However, I want to make sure I've considered all of the possibilities. What factors might influence how long it takes to rebuild indexes on existing partitions? If I just did some maintenance to split out some data for a new time period into a new partition, might that make a difference in how long it takes to build the indexes? These indexes are all locally partitioned indexes. Thanks for any insight you can lend. Cherie Machler Oracle DBA Gelco Information Network -- 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
Re:RE: MC/Serviceguard vs Sun Clusters
Glenn, The database corruption we had occurred under a very specific circumstance. It occurred only when the prime server was alive well and the backup server thought the prime had died. Now, after some correction by my SA, we were using a much older version of ServiceGuard at the time things have somewhat changed in the interim although not enough to make him comfortable. In this scenario, the backup system rebooted. During that reboot it forcibly wrenched the disk drives away from the prime system, forcing a complete failure of the prime server, then mounted and tried to run the database. When this occurred file lengths would change all over the place, control files would be 0 bytes, a 100 MB datafile might tell you it was 150MB or 50MB. Mount points that had been 40% used were now either 100% or 0% used. In short all kinds of strange things would happen, to Oracle and HP files. HP admitted that this would happen, since the files were 'still opened for write by the prime system' and had been improperly switched. Regrettably at the time they did not have a way to prevent it. Dick Goulet Reply Separator Author: Glenn Travis [EMAIL PROTECTED] Date: 2/7/2002 1:07 PM Could you explain the file corruption in a little more detail? I cannot imagine how failover would cause file corruption, much less how a properly configured running Oracle instance can get 'absolutely destroyed'. Isn't that the purpose of having Oracle over say a nonlogged, singlethreaded, cheapo db engine...? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 07, 2002 9:00 AM To: Multiple recipients of list ORACLE-L Subject: Re:MC/Serviceguard vs Sun Clusters Rama, We did the MC/ServiceGuard thing some years ago. Worked well, after our SA rebuilt the servers from ground 0. Adding it on to an existing server is ok, but somewhat unstable. One item to be VERY careful of. The heartbeat cable, in our case a ethernet thin line, needs to be on a dedicated link, preferably a purchased vs. custom made cable, and protected from accidental disconnect. Ours got disconnected by a contractor working in the computer room because it was in his way. The resulting reboot of the backup server and forcible takeover of the disk farm absolutely destroyed the database. We had more file corruption than I ever could have imagined. Consequently we abandoned ServiceGuard are going to standby databases instead. Dick Goulet Reply Separator Author: Rama Malladi [EMAIL PROTECTED] Date: 2/6/2002 5:23 PM Hi... I am looking for inputs from anybody who has experience in both MC/Serviceguard (MC/S) as well as Sun cluster implementation. If a DBA/SA team has lots of experience in implementing MC/Serviceguard clusters on HP and trying to move to SunClusters for HA solution ... a) What are the common things between MC/S and and Sun clusters (ex: about 5 minute fail-over time, fixed IP address, 2 or more nodes in a cluster, disk sharing etc..) b) Any differences between these... What are the things to watch out for (assuming the team already knows in and out of MC/Serviceguard) Thank you in advance... Rama -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rama Malladi INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Glenn Travis INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To
RE: capacity planning??
I will chime in with my recommendation for this as well. Jack and I attended the same class. Jared Jack C. Applewhite [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 02/08/02 07:13 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: capacity planning?? Shibu, Go to http://www.orapub.com Craig Shallahamer is THE Guru on the subject. I took his course a couple years ago - excellent! 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: Friday, February 08, 2002 12:13 AM To: Multiple recipients of list ORACLE-L Hi all Can anyone send me a doc or white paper on capcity planning?? regards, shibu -- 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-01000: maximum open cursors exceeded
Dave, When I ran into this error using AP Oracle Applications, I was told this could be set as high as I wished with no performance hit up front (the cursors are not allocated, only allowed). In fact, the support analyst couldn't come up with a good reason why it shouldn't be set to the maximum for the platform (on Solaris at the time it was 1000). I suspect there is a reason, but getting the transactions through AP far outweighed the potential performance impact ;) (I didn't see any, but was really chasing other, larger performance issues at the time). Margaret -Original Message- From: Farnsworth, Dave [mailto:[EMAIL PROTECTED]] Sent: Friday, February 08, 2002 8:03 AM To: Multiple recipients of list ORACLE-L Subject: ORA-01000: maximum open cursors exceeded We had this error show up the other day. I am wondering if there is a performance limit on how big you should set your OPEN_CURSORS parameter in the SID.init file? Mine currently is set at 300. Are there any guidelines on this setting? Just wondering. Thanks, Dave -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Farnsworth, Dave INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Murray, Margaret INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Instream SQL
That's it! Thanks! Ron -Original Message- Sent: Friday, February 08, 2002 10:18 AM To: Multiple recipients of list ORACLE-L I'm a little confused. It sounds like what you're trying to do is: #!/bin/ksh echo Look at me! I'm in a Unix script! sleep 5 sqlplus EOF system/incredibly_secret_password select 'Look at me... here in SQL*Plus! Life is grand!' from dual; !echo Where am I? I'm so confused! There's an orange elephant here! exit EOF echo Wasn't that fun? exit HTH, Bambi. -Original Message- Sent: Friday, February 08, 2002 8:23 AM To: Multiple recipients of list ORACLE-L I have a Unix batch script that calls a short (5 line) SQL script. Is there any way to include the SQL statements in the Unix script instead of calling the SQL? Ron Smith DBA Kerr-McGee Corp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bellows, Bambi INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Performance issues
You should not expect to see much performance improvement, except in special cases where you can replace large deletes or loads by simpler partition operations. Your decision to use partitioning should be based on the ability to handle (i.e. DBA work) partitions separately, where you can e.g. mass delete/load, make parts read-only to reduce backup, or enable partial recovery during disk outages. Note, however, that much of this depends on your ability to partition indexes and data equivalently so that you avoid global indexes. Sathish Tatikonda wrote: Hi All, We are developing a system in which some tables in the database might be having about 100 Million records. We are planning to use table and index partition's as a means to improve performance. Could you please share your experiences/views about handling such huge tables. Is this partitioning sufficient or do we have to look in to some other means. It would also be of great help if you could provide me some pointers to documents which gives some insight for handling such tables and databases. thanks in advance, Sathish. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?ISO-8859-1?Q?Bj=F8rn?= Engsig INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Help !! Password Encryption/decryption ??
- Original Message - I went thro' DBMS_OBFUSCATION_TOOLKIT.DESEncrypt and DBMS_OBFUSCATION_TOOLKIT.DESDecrypt methods . but as per the docs , this package requires the password ( which is to be encrypted ) to be in multiples of 8 bytes . i don't think this is possible always . yes, this is implied by the fact that DES works with blocks take a look at http://www.cybcon.com/~jkstill/util/encryption/encryption.html for an overview of alternative ways for encryption/obfuscation hth, Marin ...what you brought from your past, is of no use in your present. When you must choose a new path, do not bring old experiences with you. Those who strike out afresh, but who attempt to retain a little of the old life, end up torn apart by their own memories. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Marin Dimitrov INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
FTP Exports
I am FTPing exports in binary mode as a part of my backup/recovery plan. What happens when the network connection is lost between FTP client and server while a file is being transferred? Will an incomplete file appear on the FTP server or would the FTP server sense the disconnect and remove the partially transferred file? 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).
Call for Presenters(July/Oct 2001)
As a past President of Ohio Oracle Users Group, I still volunteer with our local user group and my current task if to ask you Oracle experts about presenting at our group. We are looking for presenters for out July 15th meeting. If you're interested in coming to Columbus OH for present, kindly let us know what your topic would be and the board will meet to choose and notify the people chosen. We are also looking for presenters for our Oct Meeting, if you're interested in that we'd like to see an abstract(50 words maximum). Please send all info to [EMAIL PROTECTED] or [EMAIL PROTECTED] Thanks, Joe -- 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: UDUMP Files
Clint, Does Metalink Note:125215.1 help? John Kanagaraj Oracle Applications DBA DBSoft Inc (W): 408-970-7002 Grace - Getting something we don't deserve Mercy - NOT getting something we deserve Click on 'http://www.needhim.org' for Grace and Mercy that is freely available! ** The opinions and statements above are entirely my own and not those of my employer or clients ** -Original Message- Sent: Friday, February 08, 2002 12:33 AM To: Multiple recipients of list ORACLE-L Hi all. Can someone help me with this message I keep on getting in my UDUMP directory. Thanks Clint oracle $ more trinity_ora_6621.trc /oracle/8.1.7/database/admin/trinity/udump/trinity_ora_6621.trc Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production With the Partitioning option JServer Release 8.1.7.0.0 - Production ORACLE_HOME = /oracle/8.1.7/database System name:SunOS Node name: meb01 Release:5.8 Version:Generic_108528-07 Machine:sun4u Instance name: trinity Redo thread mounted by this instance: 1 Oracle process number: 36 Unix process pid: 6621, image: oracle@meb01 (TNS V1-V3) *** SESSION ID:(34.28) 2002-02-08 10:32:00.459 kvotenlg: epc_init failed. EPC error: 191 -- 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:URGENT Help on tracking unauthorized login to Oracle Data
Ashoke, In your circumstances, I'll retract a previous statement on the usefulness of the listener.log file. This one case where you may be able to extract the information you desire, to include the computer from which they were attempting to login, and the date/time. The only problem is that you have to go searching through a flat file. Dick Goulet Reply Separator Author: Mandal; Ashoke [EMAIL PROTECTED] Date: 2/8/2002 7:13 AM Greetings, We have a database with very sensitive data. Our management wants me to find out the way to secure this data from unauthorized login and track these users who tried to login to this database. Is there any way we can track the unauthorized users, who try to login to an oracle database with invalid userid or password but with valid connect string. If there is no options under oracle then is there any 3rd party software for this purpose. Any help is appreciated Thanks, Ashoke -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mandal, Ashoke INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Where does a DBA go from here?
Definitely #6. I've learned more from conferences that anywhere else. If nothing else you get to drink with the people from the list :), i' ll be at IOUG. joe Jesse, Rich wrote: OK, from the responses, here's The Plan: 1) Get beer. I prefer Guinness or Goose Island. Done. 2) Get Oracle Perf Tuning 101. Done. 3) Get more beer. 4) Beat up on some test DBs, and work on real live DBs to engrain that class material into the surviving brain cells (see Step 1). Sorta done with this one, but I need more. The 22 DBs here at work and 1 at home ought to help! 5) Get more beer. 6) Go to Oracle conferences. I need to go 7) Get more beer. 8) Hit the web, preferrably with beer in non-mouse hand. (Wisconsin twin-can beer hat optional) 9) Go to Internals class and actually understand and learn from it. Yay! 10)Get lots more beer. 11)Actually do some work here. Sounds good folks. I think I'm on the right track (sans beer at work, of course), with my Oracle course work completed over a year ago, and some DBA experiences under my belt. Time to plunk away at more DBs! Thanks! :) Rich JesseSystem/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA President, Beer Ale Lager Lovers Society http://www.westbend.net/~legoman -Original Message- Sent: Friday, February 08, 2002 8:58 AM To: Multiple recipients of list ORACLE-L Rich, The best Oracle training I've ever had by far is playing around with a small test DB on a laptop or PC. Stress it, hurt it, recover it, tune it, etc., etc. When done in conjunction with one of the fine books mentioned by others on this list - even better. I've only had one official Oracle training course - in the spring of 1989. It was 4-1/2 days of RDBMS v5, SQL*Forms and RPT/RPF. Since then I've attended some of the mini courses at IOUG, ODTUG, Open World, etc. - nice little hits of the latest technologies. I studied for my Oracle8 OCP exams by working through Jason Couchman's book and beating up an 8.0.5 DB on my PC - learned a hell of a lot. My on-going study plan for Oracle skills boils down to Beating, Browsing and Books. - Beat up a test database - Browse fine Web sites like Steve Adams' IXORA (and beat up the DB) - Buy and read good books (and beat up the DB) I think I've learned about as much as if I'd sat in a bunch of classes - and saved a pile of money. ;-) 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: 07 February 2002 21:07 To: Multiple recipients of list ORACLE-L So, there I am. I've taken the main Oracle courses -- Intro to SQL, DBA (Oracle 7!), Backup Recovery, Network Admin, and Perf Tuning. Now where do I go for more Oracle training? This is sparked by a recent perceived lag in one of our new databases. We've tracked it down to a possible hot block or two, but I never used X$BH or V$LATCH_CHILDREN in any of my Oracle classes. And I *know* I'm far from being ready for an Internals class. So how do I get from here to there? education.oracle.com doesn't seem to have a whole lot other than Internals. Or is that where I'm at now? Confused and no beer. Rich JesseSystem/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -- 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).
cost based optimizer
Title: cost based optimizer I have a table of 500,000 records that is analyzed and contains several indexes that are analyzed. Can someone explain to me why the cost without a hint is much lower than the cost with a hint? Using a hint is 10 times faster than without a hint even though the cost is much higher. Since this is a third party app, I cannot add hints. What aoptions do I have? select /*+ Index(ICMSSHDR XSKSHDRS181M1) Use this index XSKSHDRS181M1 */ PKTS_ICMSSHDR from ICMSSHDR where (FK_IX_ICMSSHDR_DELV='x' and (SHDR_DELV_WHSE_CODE'86')); Execution Plan -- 0 SELECT STATEMENT Optimizer=CHOOSE (Cost=213529 Card=228346 Bytes=12102338) 1 0 TABLE ACCESS (BY INDEX ROWID) OF 'ICMSSHDR' (Cost=213529 Card=228346 Bytes=12102338) 2 1 INDEX (RANGE SCAN) OF 'XSKSHDRS181M1' (NON-UNIQUE) (Cost=2346 Card=228346) select PKTS_ICMSSHDR from ICMSSHDR where (FK_IX_ICMSSHDR_DELV='x' and (SHDR_DELV_WHSE_CODE'86')); Execution Plan -- 0 SELECT STATEMENT Optimizer=CHOOSE (Cost=3526 Card=228346 Bytes=12102338) 1 0 TABLE ACCESS (FULL) OF 'ICMSSHDR' (Cost=3526 Card=228346 Bytes=12102338) Thanks John Baylis Database Administrator Canadian Forest Products Ltd. Vancouver B.C. Canada (604) 697-6476 (Office) (604) 313-6054 (Cell)
RE: Help !! Password Encryption/decryption ??
We use it and we have created all the encrypted fields with a length as a multiple of 8 bytes. Then pad the data to the next multiple of 8 bytes before storing. Then trim it after retrieving the data and decrypting it. HTH, Beth -Original Message- Sent: Friday, February 08, 2002 9:08 AM To: Multiple recipients of list ORACLE-L Hello everybody , I am on 8.1.6/NT . i need to encrypt / decrypt the password of my users for my web based application. I went thro' DBMS_OBFUSCATION_TOOLKIT.DESEncrypt and DBMS_OBFUSCATION_TOOLKIT.DESDecrypt methods . but as per the docs , this package requires the password ( which is to be encrypted ) to be in multiples of 8 bytes . i don't think this is possible always . have i understood anything wrong ? can anyone throw some light on this . how do u guys encounter this situation ? any likely scripts plz ?!!! TIA. Jp. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Prem J Khanna INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Seefelt, Beth INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Instream SQL
OT Warning On List, I move that we choose Bambi as the 'funnest' person on this list! Thanks for that ROTFL on a Friday morning. Sets the mood for the weekend. John Kanagaraj -Original Message- From: Bellows, Bambi [mailto:[EMAIL PROTECTED]] Sent: Friday, February 08, 2002 8:18 AM To: Multiple recipients of list ORACLE-L Subject: RE: Instream SQL I'm a little confused. It sounds like what you're trying to do is: #!/bin/ksh echo Look at me! I'm in a Unix script! sleep 5 sqlplus EOF system/incredibly_secret_password select 'Look at me... here in SQL*Plus! Life is grand!' from dual; !echo Where am I? I'm so confused! There's an orange elephant here! exit EOF echo Wasn't that fun? exit HTH, Bambi. -Original Message- Sent: Friday, February 08, 2002 8:23 AM To: Multiple recipients of list ORACLE-L I have a Unix batch script that calls a short (5 line) SQL script. Is there any way to include the SQL statements in the Unix script instead of calling the SQL? Ron Smith DBA Kerr-McGee Corp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bellows, Bambi INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: 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: URGENT Help on tracking unauthorized login to Oracle Database
Joe, We referred the auditing option. My understanding is that you can track the oracle users using database auditing feature once the users are logged into the database. But my requirement is to track the users who tried to login to the database but could not login due to wrong password. For example, somebody may know the connect string for an oracle database and trying to login to the database as system user and with various combination of password. We like to know who are these users. Thanks, Ashoke -Original Message- Sent: Friday, February 08, 2002 11:54 AM To: Multiple recipients of list ORACLE-L Database Administrators guide chapter on auditing. joe Mandal, Ashoke wrote: Greetings, We have a database with very sensitive data. Our management wants me to find out the way to secure this data from unauthorized login and track these users who tried to login to this database. Is there any way we can track the unauthorized users, who try to login to an oracle database with invalid userid or password but with valid connect string. If there is no options under oracle then is there any 3rd party software for this purpose. Any help is appreciated Thanks, Ashoke -- 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: Mandal, Ashoke INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: What impacts index build times on partitioned tables?
How much sort area size are u using -Original Message- Sent: Friday, February 08, 2002 12:24 PM To: Multiple recipients of list ORACLE-L Cherie, Now, --Yes, we have parallel set to six Do you have enough physical memory and CPU power/faster drives for writing to handle this number of parallel process as it is intensive on such resources specially available memory at that time plus writing capabilty of your drives. There may be possible bottlenecks. Just check. If you are using tool 'glance' this will give you a good idea while running this process. Nologging is fine. You are checking sort area size right... What about temp tablespace and target tablespace fragmentation... Regards Rafiq Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: Fri, 08 Feb 2002 04:43:25 -0800 Rafiq, Yes, we have parallel set to six. We are using nologging. I am checking on the sort_area_size. Thanks, Cherie Mohammad Rafiq To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] rafiq9857@hot cc: mail.comSubject: RE: What impacts index build times on partitioned tables? Sent by: [EMAIL PROTECTED] om 02/07/02 03:06 PM Please respond to ORACLE-L Please check following Are you creating indexes with parallel clause or not? Are you using unrecoverable/nologging or not Is your sort_area_size is ok? What type of TEMP tablespace are you using with temp file or datafile and sizing of extents are proper? Is your target tablespace is not that much fragmented? Regards Rafiq Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: Thu, 07 Feb 2002 08:55:47 -0800 Yechiel, There is no other activity in this warehouse database while the index builds are being done. The users access is shut off, no batch jobs for this database are running, and the nightly data loads have already finished. Thanks, Cherie àãø éçéàì adary@mehish. To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] co.il cc: Sent by: Subject: RE: What impacts index build times on partitioned tables? [EMAIL PROTECTED] om 02/07/02 10:20 AM Please respond to ORACLE-L I think that it is related to the activity against the DB. Not only there is more load on the DB but access path that use the index can default to full table scan if the index is not available because you are rebuilding it just now. Yechiel Adar, Mehish Computer Services [EMAIL PROTECTED] -Original Message- From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] Sent: Thu, February 07, 2002 5:55 PM To: Multiple recipients of list ORACLE-L Subject: What impacts index build times on partitioned tables? We drop and recreate many indexes on our large partitioned fact table in our data warehouse nightly. The amount of data in the table increases gradually with time but there aren't huge fluctuations in the amount of data in the partitions from day to day. The problem is that the amount of time that it takes to recreate the indexes varies widely. From 40 minutes to almost three hours. I am inclined to believe that this is a scheduling issue related to the time of the day and the day of the week. I think we may be experiencing competition from other batch jobs from other applications. One application, in particular, is sort of a black box because it is not on Oracle and it belongs to people who reside in a remote site. However, I want to make sure I've considered all of the possibilities. What factors might influence how long it takes to rebuild indexes on existing partitions? If I just did some maintenance to split out some data for a new time period into a new partition, might that make a difference in how long it takes to build the indexes? These indexes are all locally partitioned indexes. Thanks for any insight you can lend. Cherie Machler Oracle DBA Gelco Information Network -- 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
RE: TFM
Count on it! -Original Message- Sent: Friday, February 08, 2002 10:14 AM To: Multiple recipients of list ORACLE-L Keep thinking it, April, and feel free to send me an email when you feel like you're going to explode. -Original Message- Sent: Friday, February 08, 2002 6:48 AM To: Multiple recipients of list ORACLE-L THANK you! I kinda had a hunch that life would change... When I worked for US Steel, their Mississippi plant installed Financials and I had to send id IMS data... I wasn't wild about it then, and I wasn't directly connected. I just keep thinking... it's a learning experience... it's a learning experience... April -Original Message- Sent: Thursday, February 07, 2002 3:53 PM To: Multiple recipients of list ORACLE-L April -- Get onto Metalink - Top Tech Docs. There's more there than you'll be able to read in a lifetime. One thing to know is that once you install Applications, your life as a DBA *will* change. Good luck! Bambi. -Original Message- Sent: Thursday, February 07, 2002 3:07 PM To: Multiple recipients of list ORACLE-L We are getting ready to sign a contract with Oracle for Financials. I have been looking for the manuals so I can read up on what their suggestions are for installation, tuning... for the 3000+ tables and associated other back end stuff... anyone know where they can be found. I can find some on Oracle Apps Net, but not really the kind of stuff I am looking for... are their other? April Wells Oracle DBA Corporate Systems Amarillo Texas begin 666 InterScan_Disclaimer.txt M5AE(EN9F]R;6%T:6]N(-O;G1A:6YE9!I;B!T:ES(4M;6%I;!IR!S M=')I8W1L2!C;VYF:61E;G1I86P@86YD(9OB!T:4@:6YT96YD960@=7-E M(]F('1H92!A91R97-S964@;VYL3L@:70@;6%Y(%LV\@8F4@;5G86QL M2!PFEV:6QE9V5D(%N9]OB!PFEC92!S96YS:71I=F4N(!.;W1I8V4@ M:7,@:5R96)Y(=I=F5N('1H870@86YY(1IV-L;W-UF4L('5S92!OB!C M;W!Y:6YG(]F('1H92!I;F9OFUA=EO;B!B2!A;GEO;F4@;W1H97(@=AA M;B!T:4@:6YT96YD960@F5C:7!I96YT(ES('!R;VAI8FET960@86YD(UA M2!B92!I;QE9V%L+B @268@6]U(AA=F4@F5C96EV960@=AIR!M97-S M86=E(EN(5RF]R+!P;5AV4@;F]T:69Y('1H92!S96YD97(@:6UM961I M871E;'D@8GD@F5T=7)N(4M;6%I;X*D-OG!OF%T92!37-T96US+!) M;F,N(AAR!T86ME;B!E=F5R2!R96%S;VYA8FQE('!R96-A=71I;VX@=\@ M96YS=7)E('1H870@86YY(%T=%C:UE;G0@=\@=AIR!E+6UA:6P@:%S M()E96X@W=E'0@9F]R('9IG5S97,N(!792!A8V-E'0@;F\@;EA8FEL M:71Y(9OB!A;GD@9%M86=E('-UW1A:6YE9!AR!A(')EW5L=!O9B!S M;V9T=V%R92!V:7)UV5S(%N9!A9'9IV4@6]U(-AG)Y(]U=!Y;W5R M(]W;B!V:7)UR!C:5C:W,@8F5F;W)E(]P96YI;F@86YY(%T=%C:UE M;G0N#0I4:4@:6YF;W)M871I;VX@8V]N=%I;F5D(EN('1H:7,@92UM86EL M(ES('-TFEC=QY(-O;F9I95N=EA;!A;F0@9F]R('1H92!I;G1E;F1E M9!UV4@;V8@=AE(%D9')EW-E92!O;FQY.R!I=!M87D@86QS;R!B92!L M96=A;QY('!R:79I;5G960@86YD+V]R('!R:6-E('-E;G-I=EV92X@($YO M=EC92!IR!H97)E8GD@9VEV96X@=AA=!A;GD@9ES8VQOW5R92P@=7-E M(]R(-O'EI;F@;V8@=AE(EN9F]R;6%T:6]N()Y(%N6]N92!O=AE MB!T:%N('1H92!I;G1E;F1E9!R96-IEE;G0@:7,@')O:EB:71E9!A M;F0@;6%Y()E(EL;5G86PN(!)9B!Y;W4@:%V92!R96-E:79E9!T:ES M(UEW-A9V4@:6X@97)R;W(L('!L96%S92!N;W1I9GD@=AE('-E;F1EB!I M;6UE9EA=5L2!B2!R971UFX@92UM86EL+@H*0V]R]R871E(%-YW1E M;7,L($EN8RX@:%S('1A:V5N(5V97)Y(')E87-O;F%B;4@')E8V%U=EO M;B!T;R!E;G-UF4@=AA=!A;GD@871T86-H;65N=!T;R!T:ES(4M;6%I M;!H87,@8F5E;B!S=V5P=!F;W(@=FER=7-ERX@(%=E(%C8V5P=!N;R!L M:6%B:6QI='D@9F]R(%N2!D86UA9V4@W5S=%I;F5D(%S($@F5S=6QT M(]F('-O9G1W87)E('9IG5S97,@86YD(%D=FES92!Y;W4@8V%RGD@;W5T M('EO=7(@;W=N('9IG5S(-H96-KR!B969OF4@;W!E;FEN9R!A;GD@871T M86-H;65N=X-@T*5AE(EN9F]R;6%T:6]N(-O;G1A:6YE9!I;B!T:ES M(4M;6%I;!IR!S=')I8W1L2!C;VYF:61E;G1I86P@86YD(9OB!T:4@ M:6YT96YD960@=7-E(]F('1H92!A91R97-S964@;VYL3L@:70@;6%Y(%L MV\@8F4@;5G86QL2!PFEV:6QE9V5D(%N9]OB!PFEC92!S96YS:71I M=F4N(!.;W1I8V4@:7,@:5R96)Y(=I=F5N('1H870@86YY(1IV-L;W-U MF4L('5S92!OB!C;W!Y:6YG(]F('1H92!I;F9OFUA=EO;B!B2!A;GEO M;F4@;W1H97(@=AA;B!T:4@:6YT96YD960@F5C:7!I96YT(ES('!R;VAI M8FET960@86YD(UA2!B92!I;QE9V%L+B @268@6]U(AA=F4@F5C96EV M960@=AIR!M97-S86=E(EN(5RF]R+!P;5AV4@;F]T:69Y('1H92!S M96YD97(@:6UM961I871E;'D@8GD@F5T=7)N(4M;6%I;X*D-OG!OF%T M92!37-T96US+!);F,N(AAR!T86ME;B!E=F5R2!R96%S;VYA8FQE('!R M96-A=71I;VX@=\@96YS=7)E('1H870@86YY(%T=%C:UE;G0@=\@=AI MR!E+6UA:6P@:%S()E96X@W=E'0@9F]R('9IG5S97,N(!792!A8V-E M'0@;F\@;EA8FEL:71Y(9OB!A;GD@9%M86=E('-UW1A:6YE9!AR!A M(')EW5L=!O9B!S;V9T=V%R92!V:7)UV5S(%N9!A9'9IV4@6]U(-A MG)Y(]U=!Y;W5R(]W;B!V:7)UR!C:5C:W,@8F5F;W)E(]P96YI;F@ 386YY(%T=%C:UE;G0N#0H-@ end -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: April Wells INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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:
RE: TFM
April, We upgraded from 10.7 to 11i. We had to apply around 200 patches. The entire upgrade project took 9 months. I suggest hiring consultants to help with the install. This will consume 100% of you time until it is fully implemented. After that it will consume around 50% of your time, depending on the modules you will be using. If you are the only DBA, start pushing management to hire another person. You will need to tune the concurrent managers, apply patches, clone the entire environment, etc. We have 1 person dedicated to administering the applications portion - creating users, monitoring the concurrent managers, assisting users with problems, applying patches, etc. We have a dba dedicated to backups, tuning, assisting with patches, assisting with client issues, etc. Welcome to hell. Jay Hostetter Oracle DBA D. E. Communications Ephrata, PA USA [EMAIL PROTECTED] 02/08/02 09:08AM April: Let me add to Bambi's wonderful comments. Administering Oracle Applications can be a daunting task. Like no other canned application you have ever implemented. Don't count on the product installing correctly 100%. Don't count on just installing it one time and then leaving it alone. I guarantee that you will be applying thousands of patches once the installation is complete???. This product needs A LOT of hand holding so get your boots on and be ready. There are many people in this and the OAUG forum that can help you. I would suggest reading the installation and configuration guide cover to cover and preparing you System Admins for hell. Thank You Stephen P. Karniotis Technical Alliance Manager Compuware Corporation Direct: (248) 865-4350 Mobile: (248) 408-2918 Email: [EMAIL PROTECTED] Web:www.compuware.com -Original Message- Sent: Thursday, February 07, 2002 4:53 PM To: Multiple recipients of list ORACLE-L Subject:RE: TFM April -- Get onto Metalink - Top Tech Docs. There's more there than you'll be able to read in a lifetime. One thing to know is that once you install Applications, your life as a DBA *will* change. Good luck! Bambi. -Original Message- Sent: Thursday, February 07, 2002 3:07 PM To: Multiple recipients of list ORACLE-L We are getting ready to sign a contract with Oracle for Financials. I have been looking for the manuals so I can read up on what their suggestions are for installation, tuning... for the 3000+ tables and associated other back end stuff... anyone know where they can be found. I can find some on Oracle Apps Net, but not really the kind of stuff I am looking for... are their other? April Wells Oracle DBA Corporate Systems Amarillo Texas -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jay Hostetter INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Bitmap Indexes
Kirti, ' The only issue we had with bitmap indexes was the way it used up extents, if those were not droppped before the dataloads.' If I remember correctly, this issue was fixed in 7.3.4.4 as I was having the same problem while dataload in our datawarehouse and workaround was to drop index before inserts and an index size 10M was using unlimited space. This problem was in 7.3.4.0...Besides there were couple of other issues relating to bitmap indexes specially rebuilding of bitmap index on a table which was having degree 1 was resulting in ORA-600 messages even if you were not specifying parallel option. I worked with Oracle Support on this issue for around one year but not resloved till I left that company. Regards Rafiq Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: Fri, 08 Feb 2002 05:58:21 -0800 MOHAMMAD RAFIQ _ Send and receive Hotmail on your mobile device: http://mobile.msn.com ---BeginMessage--- Kirti, Just cureous. Normally bitmap indexes ae ae used for low cardinality columns. I am confused when you state - "Just one table uses it(bitmap index), with b-tree indexes for PKry and one other non-unique index" If you mean - you use Bitmap index for the non unique index with b-tree index for PKey I am OK with that. Shaibal From: "Deshpande, Kirti" <[EMAIL PROTECTED]> Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Subject: RE: Bitmap Indexes Date: Thu, 07 Feb 2002 19:58:20 -0800 Ethan, I have been using bitmap and b-tree indexes on the same table in our data mart since 7.3.4. Never had a problem with query performance. Now we have partitioned the tables in 8.1.7.x and most tables that were using bitmaps do not need to use them anymore. Just one table uses it, with b-tree indexes for PKry and one other non-unique index. No problems so far. The only issue we had with bitmap indexes was the way it used up extents, if those were not droppped before the dataloads. The problem still exists with 8.1.7.x. Have not tried with 9i yet.. HTH, - Kirti -Original Message- Sent: Thursday, February 07, 2002 3:07 PM To: Multiple recipients of list ORACLE-L Posted on behalf of a friend... Fellow Oracle data warehouse DBAs (if this isn't you, you can delete this note now): I have a question regarding Oracle's bitmap indexes. We have been DABBLING with bitmap indexes with mixed results here. In many cases, they are great solutions. In some cases, where we have a mix of bitmap and b-tree indexes on the same table, we occasionally get into trouble --- this has to do with the Oracle optimizer deciding, on the fly, to convert a regular b-tree index into a bitmap. It does this so that it can AND or OR the various bitmap indexes together. Sounds great on the surface but when this occurs, response time goes in the toilet. In one situation we have, we have a fact table with two bitmap indexes and a few other b-tree indexes. A particular query we run bogs down (NEVER COMPLETES) with this mix of indexes. Based on the access path that's being chosen, we know which b-tree index is being converted on the fly. If we convert that b-tree index into a bitmap (so we now have 3 bitmap indexes and Oracle does not need to create the third one on the fly), the query really runs well. If we replace the bitmap indexes with b-tree indexes (so we only have b-tree indexes), we get decent response times. (This is all on Oracle 8.1.7.2.0, by the way.) I'm wondering if the rest of you data warehouse DBAs have gone "whole hog" with bitmap indexes. My testing shows that when Oracle doesn't have to create a bitmap index on the fly, the queries respond wonderfully. So, I'm wondering if our dabbling is actually a bad validation approach and, instead, we should be 'running' with LOTS bitmap indexes instead of 'crawling' with only a few of them. In other words, maybe we're not "taking all of our medication", as someone else put it recently. Any insight would be most appreciated. I'm not looking for insight on the query I have used as an example. I'm looking for a generalized answer that says, "Yes, if you start using bitmap indexes, you should go TOTALLY to bitmap indexes" or, "Hmmm, we're using some bitmap indexes and some b-tree indexes and don't have the problem you have". -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Post, Ethan INET: [EMAIL PROTECTED] -- 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
Re: Bitmap Indexes
Helen, Attachments do not make it to the list. Igor Neyman, OCP DBA[EMAIL PROTECTED] - Original Message - From: Helen J Mitchell To: Multiple recipients of list ORACLE-L Sent: Friday, February 08, 2002 12:18 PM Subject: Re: Bitmap Indexes Hi, Here is an article about it bitmap indexes ... I hope this gives you information. Helen - Original Message - From: Shaibal Talukder To: Multiple recipients of list ORACLE-L Sent: Friday, February 08, 2002 6:58 AM Subject: RE: Bitmap Indexes Kirti, Just cureous. Normally bitmap indexes ae ae used for low cardinality columns. I am confused when you state - "Just one table uses it(bitmap index), with b-tree indexes for PKry and one other non-unique index" If you mean - you use Bitmap index for the non unique index with b-tree index for PKey I am OK with that. Shaibal From: "Deshpande, Kirti" <[EMAIL PROTECTED]> Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Subject: RE: Bitmap Indexes Date: Thu, 07 Feb 2002 19:58:20 -0800 Ethan, I have been using bitmap and b-tree indexes on the same table in our data mart since 7.3.4. Never had a problem with query performance. Now we have partitioned the tables in 8.1.7.x and most tables that were using bitmaps do not need to use them anymore. Just one table uses it, with b-tree indexes for PKry and one other non-unique index. No problems so far. The only issue we had with bitmap indexes was the way it used up extents, if those were not droppped before the dataloads. The problem still exists with 8.1.7.x. Have not tried with 9i yet.. HTH, - Kirti -Original Message- Sent: Thursday, February 07, 2002 3:07 PM To: Multiple recipients of list ORACLE-L Posted on behalf of a friend... Fellow Oracle data warehouse DBAs (if this isn't you, you can delete this note now): I have a question regarding Oracle's bitmap indexes. We have been DABBLING with bitmap indexes with mixed results here. In many cases, they are great solutions. In some cases, where we have a mix of bitmap and b-tree indexes on the same table, we occasionally get into trouble --- this has to do with the Oracle optimizer deciding, on the fly, to convert a regular b-tree index into a bitmap. It does this so that it can AND or OR the various bitmap indexes together. Sounds great on the surface but when this occurs, response time goes in the toilet. In one situation we have, we have a fact table with two bitmap indexes and a few other b-tree indexes. A particular query we run bogs down (NEVER COMPLETES) with this mix of indexes. Based on the access path that's being chosen, we know which b-tree index is being converted on the fly. If we convert that b-tree index into a bitmap (so we now have 3 bitmap indexes and Oracle does not need to create the third one on the fly), the query really runs well. If we replace the bitmap indexes with b-tree indexes (so we only have b-tree indexes), we get decent response times. (This is all on Oracle 8.1.7.2.0, by the way.) I'm wondering if the rest of you data warehouse DBAs have gone "whole hog" with bitmap indexes. My testing shows that when Oracle doesn't have to create a bitmap index on the fly, the queries respond wonderfully. So, I'm wondering if our dabbling is actually a bad validation approach and, instead, we should be 'running' with LOTS bitmap indexes instead of 'crawling' with only a few of them. In other words, maybe we're not "taking all of our medication", as someone else put it recently. Any insight would be most appreciated. I'm not looking for insight on the query I have used as an example. I'm looking for a generalized answer that says, "Yes, if you start using bitmap indexes, you should go TOTALLY to bitmap indexes" or, "Hmmm, we're using some bitmap indexes and some b-tree indexes and don't have the problem you have". -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Post, Ethan INET: [EMAIL PROTECTED] -- 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
RE: Where does a DBA go from here?
Title: RE: Where does a DBA go from here? I haven't read the Tuning 101 but it sounds like it lets you know where you are waiting. The Internals book will give you in-depth knowledge of why by diving deeper into some of the algorithms used to implement those waits. Break out the aspirin 'cause it ain't leisure reading. HTH Tony Aponte -Original Message- From: DENNIS WILLIAMS [mailto:[EMAIL PROTECTED]] Sent: Friday, February 08, 2002 12:48 PM To: Multiple recipients of list ORACLE-L Subject: RE: Where does a DBA go from here? Can anyone tell me if Steve's book contains details that would be useful in understanding the Wait Interface that Tuning 101 covers? Or would it be more redundant from that aspect? Thanks. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, February 08, 2002 5:18 AM To: Multiple recipients of list ORACLE-L I agree, get the pints in first. Worry about Oracle later. When you do come to it, try Oracle8i internal services for waits, latches, locks and memory by Steve Adams. And of course book. Jim -Original Message- Lee - lerobe Sent: 08 February 2002 09:58 To: Multiple recipients of list ORACLE-L Its Friday, the immediate solution is get beer !! As to your other problem its text book time - take a look at Tuning 101 by the lists own Kirti and Gaja. Lee -Original Message- Sent: 07 February 2002 21:07 To: Multiple recipients of list ORACLE-L So, there I am. I've taken the main Oracle courses -- Intro to SQL, DBA (Oracle 7!), Backup Recovery, Network Admin, and Perf Tuning. Now where do I go for more Oracle training? This is sparked by a recent perceived lag in one of our new databases. We've tracked it down to a possible hot block or two, but I never used X$BH or V$LATCH_CHILDREN in any of my Oracle classes. And I *know* I'm far from being ready for an Internals class. So how do I get from here to there? education.oracle.com doesn't seem to have a whole lot other than Internals. Or is that where I'm at now? Confused and no beer. Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computer system. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robertson Lee - lerobe INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: James McCann INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists
RE: Help !! Password Encryption/decryption ??
Title: RE: Help !! Password Encryption/decryption ?? How about right-padding the string to a multiple of 8 bytes. I think 8-MOD(LENGTH(string),8) will give you the number of characters to use in RPAD(string,...). E.I.. to pad with blanks: SELECT RPAD('123456789',LENGTH('123456789') + 8 - MOD(LENGTH('123456789'),8),' ') AS 12345678901234567890 FROM DUAL 1234567890123456 123456789 HTH Tony Aponte -Original Message- From: Prem J Khanna [mailto:[EMAIL PROTECTED]] Sent: Friday, February 08, 2002 9:08 AM To: Multiple recipients of list ORACLE-L Subject: Help !! Password Encryption/decryption ?? Hello everybody , I am on 8.1.6/NT . i need to encrypt / decrypt the password of my users for my web based application. I went thro' DBMS_OBFUSCATION_TOOLKIT.DESEncrypt and DBMS_OBFUSCATION_TOOLKIT.DESDecrypt methods . but as per the docs , this package requires the password ( which is to be encrypted ) to be in multiples of 8 bytes . i don't think this is possible always . have i understood anything wrong ? can anyone throw some light on this . how do u guys encounter this situation ? any likely scripts plz ?!!! TIA. Jp. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Prem J Khanna INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: cost based optimizer
First, you should be aware that the Cost is only Oracle's best guess as to what Access Path is faster. It's often wrong. What version are you on? Depending on version you have several options 1. Create a histogram on the XSKSHDRS181M1 column 2. Set the optimizer_index_cost_adj equal to a value under 100. This lowers the cost Oracle assumes an index will add. We have it set to 75 on our data warehouse. 3. Associate the access path resulting with using the hint with the SQL (I don't remember how to do this, but remember reading about it around a year ago). Good luck! Jay Miller -Original Message- Sent: Friday, February 08, 2002 1:08 PM To: Multiple recipients of list ORACLE-L I have a table of 500,000 records that is analyzed and contains several indexes that are analyzed. Can someone explain to me why the cost without a hint is much lower than the cost with a hint? Using a hint is 10 times faster than without a hint even though the cost is much higher. Since this is a third party app, I cannot add hints. What aoptions do I have? select /*+ Index(ICMSSHDR XSKSHDRS181M1) Use this index XSKSHDRS181M1 */ PKTS_ICMSSHDR from ICMSSHDR where (FK_IX_ICMSSHDR_DELV='x' and (SHDR_DELV_WHSE_CODE'86')); Execution Plan -- 0 SELECT STATEMENT Optimizer=CHOOSE (Cost=213529 Card=228346 Bytes=12102338) 10 TABLE ACCESS (BY INDEX ROWID) OF 'ICMSSHDR' (Cost=213529 Card=228346 Bytes=12102338) 21 INDEX (RANGE SCAN) OF 'XSKSHDRS181M1' (NON-UNIQUE) (Cost=2346 Card=228346) select PKTS_ICMSSHDR from ICMSSHDR where (FK_IX_ICMSSHDR_DELV='x' and (SHDR_DELV_WHSE_CODE'86')); Execution Plan -- 0 SELECT STATEMENT Optimizer=CHOOSE (Cost=3526 Card=228346 Bytes=12102338) 10 TABLE ACCESS (FULL) OF 'ICMSSHDR' (Cost=3526 Card=228346 Bytes=12102338) Thanks John Baylis Database Administrator Canadian Forest Products Ltd. Vancouver B.C. Canada (604) 697-6476 (Office) (604) 313-6054 (Cell) -- 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).
Re: datafile compression
Keith, For the backup I am copying db files into 'compressed' directory (so they get compressed while being copied). I recovered db from 'compressed' db files many times (they get automatically de-compressed while being copied from 'compressed' directory into 'normal'), and compression didn't cause any problems. Though, for some reason I didn't risk to set 'compressed' directory for archived RedoLog files. Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, February 07, 2002 6:23 PM Hello everyone. Let me say first to all who are on the list group THANK YOU. From reading the emails I receive I have learned a LOT the past few weeks. My question here is. I am trying to find a way to compress the datafiles when I copy them to a backup folder on NT. Does anyone have a suggestion as to what product they use to compress datafiles? Has anyone ever used the COMPRESS option on a folder in NT to compress datafiles? If so, was there ever a problem. I did try pkzip and when the files unzipped it gave errors abour the crc checks. I also researched this and didn't find much about compressing datafiles BUT i'm not that good with the oracle doc's yet either. Thanks in advance for any responses to this email and everyone have a good day. Confidentiality Disclaimer This email and any files transmitted with it may contain confidential and /or proprietary information in the possession of WellStar Health System, Inc. (WellStar) and is intended only for the individual or entity to whom addressed. This email may contain information that is held to be privileged, confidential and exempt from disclosure under applicable law. If the reader of this message is not the intended recipient, you are hereby notified that any unauthorized access, dissemination, distribution or copying of any information from this email is strictly prohibited, and may subject you to criminal and/or civil liability. If you have received this email in error, please notify the sender by reply email and then delete this email and its attachments from your computer. Thank you. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Keith Worley INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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).
Re: Script stops running.
You really need to ask this on a Perl list or in one of the ontopic usenet Perl forums. Check www.perl.com. Jared Nguyen, David M [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 02/08/02 08:33 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Script stops running. Hi all, I get a perl script to telnet to several machines on network to check something I want to check. When it trys to connect a machine which is down, the script will stop running. How do I tell it to continue to check the next machine and ignore the one down?. Below is my script. Thanks, David == #!/usr/local/bin/perl -w use Net::Telnet; %city = qw(host1 passwd host2 passwd host3 passwd host4 passwd ); $telnet = Net::Telnet-new ( Timeout = 10, Input_log = 'PSXreplication.log', Prompt = ('/[%:] $/'), ); foreach $key (sort keys %city) { $telnet-prompt(/$key%/i); $telnet-open($key); $telnet-login('ssuser', $city{$key}); $telnet-prompt(/$key%/i); $telnet-cmd('ls -l'); print =\n\n; $telnet-close($key); } -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nguyen, David M INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: cost based optimizer
Title: cost based optimizer John: The Cost of a query is based on Oracle's estimation of the number of datablocks that will have to be read in order to resolve the query. The Index-access Plan's cost is higher because Oracle is estimating that it will have to process more datablocks to return the requested rows. Oracle's optimizer isn't perfect. I have found that the Cost of a query is a reasonable measure of relative performance of queries only when the estimated number of rows(Card=999) is reasonably accurate. You didn't say what version of Oracle you are using. If you are using Oracle 8i or above, you can use the Plan Stability feature to specify the explain plan for the query without using hints. HTH Kevin -Original Message-From: Baylis, John [mailto:[EMAIL PROTECTED]]Sent: Friday, February 08, 2002 1:08 PMTo: Multiple recipients of list ORACLE-LSubject: cost based optimizer I have a table of 500,000 records that is analyzed and contains several indexes that are analyzed. Can someone explain to me why the cost without a hint is much lower than the cost with a hint? Using a hint is 10 times faster than without a hint even though the cost is much higher. Since this is a third party app, I cannot add hints. What aoptions do I have? select /*+ Index("ICMSSHDR" XSKSHDRS181M1) Use this index XSKSHDRS181M1 */ PKTS_ICMSSHDR from ICMSSHDR where (FK_IX_ICMSSHDR_DELV='x' and (SHDR_DELV_WHSE_CODE'86')); Execution Plan -- 0 SELECT STATEMENT Optimizer=CHOOSE (Cost=213529 Card=228346 Bytes=12102338) 1 0 TABLE ACCESS (BY INDEX ROWID) OF 'ICMSSHDR' (Cost=213529 Card=228346 Bytes=12102338) 2 1 INDEX (RANGE SCAN) OF 'XSKSHDRS181M1' (NON-UNIQUE) (Cost=2346 Card=228346) select PKTS_ICMSSHDR from ICMSSHDR where (FK_IX_ICMSSHDR_DELV='x' and (SHDR_DELV_WHSE_CODE'86')); Execution Plan -- 0 SELECT STATEMENT Optimizer=CHOOSE (Cost=3526 Card=228346 Bytes=12102338) 1 0 TABLE ACCESS (FULL) OF 'ICMSSHDR' (Cost=3526 Card=228346 Bytes=12102338) Thanks John Baylis Database Administrator Canadian Forest Products Ltd. Vancouver B.C. Canada (604) 697-6476 (Office) (604) 313-6054 (Cell)
RE: Bitmap Indexes
Rafiq, We still have the same issues in 8.1.7.0. I have to yet applied the 8.1.7.2 patch set (may move to 9.0.2 instead). However, the growth is not as much. But it is still not acceptable. We did not set the degree of parallelism on the said table, so we did not have any ORA errors. Regards, - Kirti -Original Message- Sent: Friday, February 08, 2002 10:34 AM To: Multiple recipients of list ORACLE-L Kirti, ' The only issue we had with bitmap indexes was the way it used up extents, if those were not droppped before the dataloads.' If I remember correctly, this issue was fixed in 7.3.4.4 as I was having the same problem while dataload in our datawarehouse and workaround was to drop index before inserts and an index size 10M was using unlimited space. This problem was in 7.3.4.0...Besides there were couple of other issues relating to bitmap indexes specially rebuilding of bitmap index on a table which was having degree 1 was resulting in ORA-600 messages even if you were not specifying parallel option. I worked with Oracle Support on this issue for around one year but not resloved till I left that company. Regards Rafiq Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: Fri, 08 Feb 2002 05:58:21 -0800 MOHAMMAD RAFIQ _ Send and receive Hotmail on your mobile device: http://mobile.msn.com -- 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: Slightly OT: Looking for Java Info
Hey Mike, You mention Apache with Oracle. I want to pick up this book from O'Reilly: http://www.oreilly.com/catalog/oracleopen/ There's a section on Java, although I don't know if it'll be what you're looking for. The sample chapter they provide has a ton of links on it, too: http://www.oreilly.com/catalog/oracleopen/chapter/ch01.html HTH! GL! :) Rich Jesse System/Database Administrator [EMAIL PROTECTED]Quad/Tech International, Sussex, WI USA Original Message- Sent: Thursday, February 07, 2002 3:07 PM To: Multiple recipients of list ORACLE-L Hi All! I need some help doing research. RANTI dabble with Java in my 'spare' time, and this has come to the attention of my manglement, who recently requested a small app/applet 'when I could get around to it'. Then it was 'when do you think you can get to it?', and now they want it yesterday. /RANT Ok, what I need is to find a cookbook for setting up a web server to serve up Java applets that can connect to multiple databases. I have an HP workstation with 8.1.7 loaded, with the Apache web server, but I have no clue about how to a) serve up a Java applet, and b) let it connect to a database that is not on the local machine. I'm using JDeveloper 3.2. Does anybody know of any books, web sites, white papers, notes scribbled on the backs of envelopes, anything that would provide a cookbook for this type of setup? Oh, and did I mention this is a 'spare time' activity? Not a lot of time available for in-depth research until after it's set up. Any help is appreciated. Thanks, Mike -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: URGENT Help on tracking unauthorized login to Oracle Database
Title: RE: URGENT Help on tracking unauthorized login to Oracle Database I have an idea for a poor man's version of what you are looking for. Turn on listener logging to a level high enough where you can see the text of the net traffic. With some creativity or a copy of Sed Awk you'll be able to search for the invalid username/password text. A visual inspection of the surrounding log file lines will give you machine name, osuser, username, etc. Depending on your connection activity disk space may be an issue. We've implemented jobs to cycle the log every hour to reduce the disk consumption. I figure that you could do the same and delete any logs that don't have any violations in it. HTH Tony Aponte -Original Message- From: Mandal, Ashoke [mailto:[EMAIL PROTECTED]] Sent: Friday, February 08, 2002 1:54 PM To: Multiple recipients of list ORACLE-L Subject: RE: URGENT Help on tracking unauthorized login to Oracle Database Joe, We referred the auditing option. My understanding is that you can track the oracle users using database auditing feature once the users are logged into the database. But my requirement is to track the users who tried to login to the database but could not login due to wrong password. For example, somebody may know the connect string for an oracle database and trying to login to the database as system user and with various combination of password. We like to know who are these users. Thanks, Ashoke -Original Message- Sent: Friday, February 08, 2002 11:54 AM To: Multiple recipients of list ORACLE-L Database Administrators guide chapter on auditing. joe Mandal, Ashoke wrote: Greetings, We have a database with very sensitive data. Our management wants me to find out the way to secure this data from unauthorized login and track these users who tried to login to this database. Is there any way we can track the unauthorized users, who try to login to an oracle database with invalid userid or password but with valid connect string. If there is no options under oracle then is there any 3rd party software for this purpose. Any help is appreciated Thanks, Ashoke -- 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: Mandal, Ashoke INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: cost based optimizer
explanation: what i've found is cost has absolutely no bearing on anything, a relatively useless number. joe Baylis, John wrote: I have a table of 500,000 records that is analyzed and contains several indexes that are analyzed. Can someone explain to me why the cost without a hint is much lower than the cost with a hint? Using a hint is 10 times faster than without a hint even though the cost is much higher. Since this is a third party app, I cannot add hints. What aoptions do I have? select /*+ Index(ICMSSHDR XSKSHDRS181M1) Use this index XSKSHDRS181M1 */ PKTS_ICMSSHDR from ICMSSHDR where (FK_IX_ICMSSHDR_DELV='x' and (SHDR_DELV_WHSE_CODE'86')); Execution Plan -- 0 SELECT STATEMENT Optimizer=CHOOSE (Cost=213529 Card=228346 Bytes=12102338) 10 TABLE ACCESS (BY INDEX ROWID) OF 'ICMSSHDR' (Cost=213529 Card=228346 Bytes=12102338) 21 INDEX (RANGE SCAN) OF 'XSKSHDRS181M1' (NON-UNIQUE) (Cost=2346 Card=228346) select PKTS_ICMSSHDR from ICMSSHDR where (FK_IX_ICMSSHDR_DELV='x' and (SHDR_DELV_WHSE_CODE'86')); Execution Plan -- 0 SELECT STATEMENT Optimizer=CHOOSE (Cost=3526 Card=228346 Bytes=12102338) 10 TABLE ACCESS (FULL) OF 'ICMSSHDR' (Cost=3526 Card=228346 Bytes=12102338) Thanks *John Baylis* D atabase Administrator Canadian Forest Products Ltd. Vancouver B.C. Canada (604) 697-6476 (Office) (604) 313-6054 (Cell) -- 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: URGENT Help on tracking unauthorized login to Oracle Database
I stand by my original statement, look at auditing unsuccessful connections. joe Mandal, Ashoke wrote: Joe, We referred the auditing option. My understanding is that you can track the oracle users using database auditing feature once the users are logged into the database. But my requirement is to track the users who tried to login to the database but could not login due to wrong password. For example, somebody may know the connect string for an oracle database and trying to login to the database as system user and with various combination of password. We like to know who are these users. Thanks, Ashoke -Original Message- Sent: Friday, February 08, 2002 11:54 AM To: Multiple recipients of list ORACLE-L Database Administrators guide chapter on auditing. joe Mandal, Ashoke wrote: Greetings, We have a database with very sensitive data. Our management wants me to find out the way to secure this data from unauthorized login and track these users who tried to login to this database. Is there any way we can track the unauthorized users, who try to login to an oracle database with invalid userid or password but with valid connect string. If there is no options under oracle then is there any 3rd party software for this purpose. Any help is appreciated Thanks, Ashoke -- 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: Call for Presenters(July/Oct 2001)
Doooh, who's a doofus and went thru a time/space continuum. July/Oct 2002. thanks, joe Deshpande, Kirti wrote: Just too darn late for July/Oct 2001 ;) - Kirti -Original Message- From: Joseph S Testa [mailto:[EMAIL PROTECTED]] Sent: Friday, February 08, 2002 11:24 AM To: Multiple recipients of list ORACLE-L Subject: Call for Presenters(July/Oct 2001) As a past President of Ohio Oracle Users Group, I still volunteer with our local user group and my current task if to ask you Oracle experts about presenting at our group. We are looking for presenters for out July 15th meeting. If you're interested in coming to Columbus OH for present, kindly let us know what your topic would be and the board will meet to choose and notify the people chosen. We are also looking for presenters for our Oct Meeting, if you're interested in that we'd like to see an abstract(50 words maximum). Please send all info to [EMAIL PROTECTED] or [EMAIL PROTECTED] Thanks, Joe -- 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: Bitmap Indexes
Helen, Thanks. My confusion was not about bitmap index. Anyway Kirtis explanations helped to clarify my doubts. Shaibal From: "Helen J Mitchell" <[EMAIL PROTECTED]> Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Subject: Re: Bitmap Indexes Date: Fri, 08 Feb 2002 09:18:30 -0800 Hi, Here is an article about it bitmap indexes ... I hope this gives you information. Helen - Original Message - From: Shaibal Talukder To: Multiple recipients of list ORACLE-L Sent: Friday, February 08, 2002 6:58 AM Subject: RE: Bitmap Indexes Kirti, Just cureous. Normally bitmap indexes ae ae used for low cardinality columns. I am confused when you state - "Just one table uses it(bitmap index), with b-tree indexes for PKry and one other non-unique index" If you mean - you use Bitmap index for the non unique index with b-tree index for PKey I am OK with that. Shaibal From: "Deshpande, Kirti" Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L Subject: RE: Bitmap Indexes Date: Thu, 07 Feb 2002 19:58:20 -0800 Ethan, I have been using bitmap and b-tree indexes on the same table in our data mart since 7.3.4. Never had a problem with query performance. Now we have partitioned the tables in 8.1.7.x and most tables that were using bitmaps do not need to use them anymore. Just one table uses it, with b-tree indexes for PKry and one other non-unique index. No problems so far. The only issue we had with bitmap indexes was the way it used up extents, if those were not droppped before the dataloads. The problem still exists with 8.1.7.x. Have not tried with 9i yet.. HTH, - Kirti -Original Message- Sent: Thursday, February 07, 2002 3:07 PM To: Multiple recipients of list ORACLE-L Posted on behalf of a friend... Fellow Oracle data warehouse DBAs (if this isn't you, you can delete this note now): I have a question regarding Oracle's bitmap indexes. We have been DABBLING with bitmap indexes with mixed results here. In many cases, they are great solutions. In some cases, where we have a mix of bitmap and b-tree indexes on the same table, we occasionally get into trouble --- this has to do with the Oracle optimizer deciding, on the fly, to convert a regular b-tree index into a bitmap. It does this so that it can AND or OR the various bitmap indexes together. Sounds great on the surface but when this occurs, response time goes in the toilet. In one situation we have, we have a fact table with two bitmap indexes and a few other b-tree indexes. A particular query we run bogs down (NEVER COMPLETES) with this mix of indexes. Based on the access path that's being chosen, we know which b-tree index is being converted on the fly. If we convert that b-tree index into a bitmap (so we now have 3 bitmap indexes and Oracle does not need to create the third one on the fly), the query really runs well. If we replace the bitmap indexes with b-tree indexes (so we only have b-tree indexes), we get decent response times. (This is all on Oracle 8.1.7.2.0, by the way.) I'm wondering if the rest of you data warehouse DBAs have gone "whole hog" with bitmap indexes. My testing shows that when Oracle doesn't have to create a bitmap index on the fly, the queries respond wonderfully. So, I'm wondering if our dabbling is actually a bad validation approach and, instead, we should be 'running' with LOTS bitmap indexes instead of 'crawling' with only a few of them. In other words, maybe we're not "taking all of our medication", as someone else put it recently. Any insight would be most appreciated. I'm not looking for insight on the query I have used as an example. I'm looking for a generalized answer that says, "Yes, if you start using bitmap indexes, you should go TOTALLY to bitmap indexes" or, "Hmmm, we're using some bitmap indexes and some b-tree indexes and don't have the problem you have". -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Post, Ethan INET: [EMAIL PROTECTED] -- 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). -- MSN Photos is the easiest way to share and print your photos: Click
RE: Free dbs / Mysql
Henrik - At my company, some of the production people use MySQL and it seems to work fine for the specific purposes they put it. I think Jared did a good job of pointing out the limitations of these free databases. Not a lot of simultaneous updates, for example. Not good recovery. Study the limitations and if you can live with the limitations, go for it. Look at your Oracle licensing. If you have unlimited licensing on your server, then switching some tasks to a free database on that same server wouldn't save you any money. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- [mailto:[EMAIL PROTECTED]] Sent: Friday, February 08, 2002 7:58 AM To: Multiple recipients of list ORACLE-L Hello, We are working with Oracle 8.1.7.2 on Sun Solaris. We want to check if a free db can replace some of our Oracle databases. Is someone using a free database in production ? Any good or bad history ? Regards HEnrik -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Henrik Ekenber INET: [EMAIL PROTECTED] [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: URGENT Help on tracking unauthorized login to Oracle Database
Title: RE: URGENT Help on tracking unauthorized login to Oracle Database Administrators guide. Chapter on auditing. Audit session. Rivaldi -Original Message- From: Mandal, Ashoke [mailto:[EMAIL PROTECTED]] Sent: Friday, February 08, 2002 12:54 PM To: Multiple recipients of list ORACLE-L Subject: RE: URGENT Help on tracking unauthorized login to Oracle Database Joe, We referred the auditing option. My understanding is that you can track the oracle users using database auditing feature once the users are logged into the database. But my requirement is to track the users who tried to login to the database but could not login due to wrong password. For example, somebody may know the connect string for an oracle database and trying to login to the database as system user and with various combination of password. We like to know who are these users. Thanks, Ashoke -Original Message- Sent: Friday, February 08, 2002 11:54 AM To: Multiple recipients of list ORACLE-L Database Administrators guide chapter on auditing. joe Mandal, Ashoke wrote: Greetings, We have a database with very sensitive data. Our management wants me to find out the way to secure this data from unauthorized login and track these users who tried to login to this database. Is there any way we can track the unauthorized users, who try to login to an oracle database with invalid userid or password but with valid connect string. If there is no options under oracle then is there any 3rd party software for this purpose. Any help is appreciated Thanks, Ashoke -- 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: Mandal, Ashoke INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: high tkprof parse counts == real # of hard parses?
[Connor McDonald] v$sesstat splits this down into hard and soft parses. Ah - thanks Connor! select name, sum(value) total from v$sesstat,v$statname where v$sesstat.statistic#=v$statname.statistic# and name like '%parse%' group by name parse count (hard) 2169 parse count (total) 69494630 parse time cpu 1082154 parse time elapsed 1420764 That looks *much* better to me! James -- James Manning [EMAIL PROTECTED] GPG Key fingerprint = B913 2FBD 14A9 CE18 B2B7 9C8E A0BF B026 EEBB F6E4 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: James Manning INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: DO YOU HAVE ANY DATABASE RUNNING ACTIVE 1000 SESSIONS ?
Hi Bunyamin, list, We have a system that supports many tens of thousands of simultaneous users. It has 1466 sessions connected as we speak, and generally has around 100 of those sessions marked status "ACTIVE" in v$session. We do concentrate users to sessions in a web layer. We did at one time attempt MTS, however we found that we quickly went down as dispatchers failed to keep up with the load. Oracle did its best to help us tune it, and we tried half a dozen possible configurations, but eventually the attempts were causing too much downtime and we went back to dedicated session. At peak time, our call rate is 25 user calls per minute. Hope this helps, Paul - Original Message - From: Bunyamin K. Karadeniz To: Multiple recipients of list ORACLE-L Sent: Friday, February 08, 2002 11:08 AM Subject: DO YOU HAVE ANY DATABASE RUNNING ACTIVE 1000 SESSIONS ? My question is DO YOU HAVE ANY DATABASE RUNNING ACTIVE 1000 SESSIONS ON NT ? I WILL TRY Multi Threaded Server BUT STILL I HAVE DOUBTS ? DO YOU HAVE LINKS TO ADVICE ME TO READ ABOUT THIS POINT ? ( HIGH CONNECTION/TRANSACTION NUMBER PER SECOND) THANK YOU
9i Autostart and Shutdown
We have multiple versions of Oracle on our UNIX Sun boxes. The autostart and autoshutdown that we had been using for 7.3.4, 8.0.4 and 8i do not work for the new 9i development databases. We're planning some reboots this weekend and I don't really have time to find the right patches and to apply them. Does anybody have a copy of dbstart and dbshut that works on Sun Solaris for 7.3.4, 8.0.4, 8i and 9i? In particular, I need to replace the svrmgrl with sqlplus. If anyone could embed the code in their reply or attach a file in a reply directly to me, I'd greatly appreciate it. Thanks, Cherie Machler Oracle DBA Gelco Information Network -- 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).
Does ORACLE standard edition support failover?
Does anyone know ORACLE standard edition on NT support failover or NOT? Thanks. _ Join the worlds largest e-mail service with MSN Hotmail. http://www.hotmail.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: dist cash INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: FTP Exports
Erik - You probably want a Unix group or networking group to get a definitive answer. FTP won't delete the file on your server. However if you write a Unix command to delete the file as part of your FTP script, you should test for a success/failure indication from the FTP script before you delete the file. My understanding is that FTP has integrity checks built in to sense whether the transfer was successful or not. HTH. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, February 08, 2002 10:04 AM To: Multiple recipients of list ORACLE-L I am FTPing exports in binary mode as a part of my backup/recovery plan. What happens when the network connection is lost between FTP client and server while a file is being transferred? Will an incomplete file appear on the FTP server or would the FTP server sense the disconnect and remove the partially transferred file? 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: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Bitmap Indexes
Kirti, That error/ORA-600 occurs only on rebuild. Creation don't have this issue...ver 7.3.4.4 Regards Rafiq Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: Fri, 08 Feb 2002 11:39:16 -0800 Rafiq, We still have the same issues in 8.1.7.0. I have to yet applied the 8.1.7.2 patch set (may move to 9.0.2 instead). However, the growth is not as much. But it is still not acceptable. We did not set the degree of parallelism on the said table, so we did not have any ORA errors. Regards, - Kirti -Original Message- Sent: Friday, February 08, 2002 10:34 AM To: Multiple recipients of list ORACLE-L Kirti, ' The only issue we had with bitmap indexes was the way it used up extents, if those were not droppped before the dataloads.' If I remember correctly, this issue was fixed in 7.3.4.4 as I was having the same problem while dataload in our datawarehouse and workaround was to drop index before inserts and an index size 10M was using unlimited space. This problem was in 7.3.4.0...Besides there were couple of other issues relating to bitmap indexes specially rebuilding of bitmap index on a table which was having degree 1 was resulting in ORA-600 messages even if you were not specifying parallel option. I worked with Oracle Support on this issue for around one year but not resloved till I left that company. Regards Rafiq Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: Fri, 08 Feb 2002 05:58:21 -0800 MOHAMMAD RAFIQ _ Send and receive Hotmail on your mobile device: http://mobile.msn.com -- 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). MOHAMMAD RAFIQ _ Send and receive Hotmail on your mobile device: http://mobile.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohammad Rafiq INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Bitmap Indexes
oops ... forgot ... - Original Message - From: Igor Neyman To: Multiple recipients of list ORACLE-L Sent: Friday, February 08, 2002 11:23 AM Subject: Re: Bitmap Indexes Helen, Attachments do not make it to the list. Igor Neyman, OCP DBA[EMAIL PROTECTED] - Original Message - From: Helen J Mitchell To: Multiple recipients of list ORACLE-L Sent: Friday, February 08, 2002 12:18 PM Subject: Re: Bitmap Indexes Hi, Here is an article about it bitmap indexes ... I hope this gives you information. Helen - Original Message - From: Shaibal Talukder To: Multiple recipients of list ORACLE-L Sent: Friday, February 08, 2002 6:58 AM Subject: RE: Bitmap Indexes Kirti, Just cureous. Normally bitmap indexes ae ae used for low cardinality columns. I am confused when you state - "Just one table uses it(bitmap index), with b-tree indexes for PKry and one other non-unique index" If you mean - you use Bitmap index for the non unique index with b-tree index for PKey I am OK with that. Shaibal From: "Deshpande, Kirti" <[EMAIL PROTECTED]> Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Subject: RE: Bitmap Indexes Date: Thu, 07 Feb 2002 19:58:20 -0800 Ethan, I have been using bitmap and b-tree indexes on the same table in our data mart since 7.3.4. Never had a problem with query performance. Now we have partitioned the tables in 8.1.7.x and most tables that were using bitmaps do not need to use them anymore. Just one table uses it, with b-tree indexes for PKry and one other non-unique index. No problems so far. The only issue we had with bitmap indexes was the way it used up extents, if those were not droppped before the dataloads. The problem still exists with 8.1.7.x. Have not tried with 9i yet.. HTH, - Kirti -Original Message- Sent: Thursday, February 07, 2002 3:07 PM To: Multiple recipients of list ORACLE-L Posted on behalf of a friend... Fellow Oracle data warehouse DBAs (if this isn't you, you can delete this note now): I have a question regarding Oracle's bitmap indexes. We have been DABBLING with bitmap indexes with mixed results here. In many cases, they are great solutions. In some cases, where we have a mix of bitmap and b-tree indexes on the same table, we occasionally get into trouble --- this has to do with the Oracle optimizer deciding, on the fly, to convert a regular b-tree index into a bitmap. It does this so that it can AND or OR the various bitmap indexes together. Sounds great on the surface but when this occurs, response time goes in the toilet. In one situation we have, we have a fact table with two bitmap indexes and a few other b-tree indexes. A particular query we run bogs down (NEVER COMPLETES) with this mix of indexes. Based on the access path that's being chosen, we know which b-tree index is being converted on the fly. If we convert that b-tree index into a bitmap (so we now have 3 bitmap indexes and Oracle does not need to create the third one on the fly), the query really runs well. If we replace the bitmap indexes with b-tree indexes (so we only have b-tree indexes), we get decent response times. (This is all on Oracle 8.1.7.2.0, by the way.) I'm wondering if the rest of you data warehouse DBAs have gone "whole hog" with bitmap indexes. My testing shows that when Oracle doesn't have to create a bitmap index on the fly, the queries respond wonderfully. So, I'm wondering if our dabbling is actually a bad validation approach and, instead, we should be 'running' with LOTS bitmap indexes instead of 'crawling' with only a few of them. In other words, maybe we're not "taking all of our medication", as someone else put it recently. Any insight would be most appreciated. I'm not looking for insight on the query I have used as an example. I'm looking for a generalized answer that says, "Yes, if you start using bitmap indexes, you should go TOTALLY to bitmap indexes" or, "Hmmm, we're using some bitmap indexes and some b-tree indexes and don't have the problem you have". -- Please see
RE: FTP Exports
I'm pretty sure you will get a partial file in most cases. Some FTP daemons even have the capability to resume a broken tranfer. Almost all of them return an error code when the transfer is incomplete. I would test this out in my script and make provisions to notify someone in the event of a failure. --Michael -Original Message- Sent: Friday, February 08, 2002 3:09 PM To: Multiple recipients of list ORACLE-L Erik - You probably want a Unix group or networking group to get a definitive answer. FTP won't delete the file on your server. However if you write a Unix command to delete the file as part of your FTP script, you should test for a success/failure indication from the FTP script before you delete the file. My understanding is that FTP has integrity checks built in to sense whether the transfer was successful or not. HTH. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, February 08, 2002 10:04 AM To: Multiple recipients of list ORACLE-L I am FTPing exports in binary mode as a part of my backup/recovery plan. What happens when the network connection is lost between FTP client and server while a file is being transferred? Will an incomplete file appear on the FTP server or would the FTP server sense the disconnect and remove the partially transferred file? 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: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jenkins, Michael - EDS INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Migrating from 8.1.6 EE to 8.1.7 SE
Helmut - SE vs.. EE is a matter of features. The aspect you must study is whether you are using any EE features. You don't want to migrate to SE only to find that some important parts of your application rely on EE features. Compared to that, getting the data moved should be a snap. Unless your database is so large you need to migrate it, you may just want to install 8.1.7 SE, then export and import your data to move it. As near as I can tell, Oracle only offers SE because MS SQL has a very appealing cost model (upgrades are extra). Oracle went through its product and removed features that MS doesn't have and called that SE, and priced it much lower. Therefore, I don't think Oracle is eager for you to move from EE to SE, and probably don't offer any special assistance. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, February 08, 2002 2:48 AM To: Multiple recipients of list ORACLE-L Hi! Our company wants to upgrade some of our databases from 8.1.6 to 8.1.7. Right now, we are using 8.1.6 Enterprise Edition, but when we migrate to 8.1.7 we want to use Standard Edition. What would be the procedure to migrate from 8.1.6. EE to 8.1.7 SE? Do we have to go to 8.1.7 EE first? This is on Win2k. Thanks, Helmut -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Re: Performance issues
To: 'Mohammad Rafiq' [EMAIL PROTECTED] Date: Fri, 8 Feb 2002 15:25:32 -0500 There are two parts to this issue. 1. DBA issue, that Bj0rn Engsig talked about. 2. System performance. We have couple of systems where one of our table has 70 million rows and the other 110 million rows. We just converted our 70 million records table to a partitioned table. Table is spread over 12 drives is using 0+1 RAID. Index is partitioned but is on 4 drives. Reason for doing this was that when 12 processes were trying to insert into the table we were getting buffer busy waits. Most of the processes were trying to write to the same block. Partitioning the table cut down the buffer busy waits. Spreading the table on more drives removed the db sequential read problems. We still had to go further and optimize the SQL to minimize disk reads and so on, but we cut down the I/O wait time. By partitioning the table and index, you are dealing with a piece of the table for access and insert. That means rather than dealing with 100 million rows table, you will be dealing with say 10 million rows table. We used to have a 31 million records table for 31 days data. About 10 years go we split this table into 31 of 1 million rows tables and associated indexes. This way we deal with only 1 million records tables, which were much smaller to manage as well as provided faster access. With partitioning option you are basically doing the same thing, except you have one table but it is broken up in 31 tables. It still has one name but it could be spread of 3 to 30 drives and no one but the DBA knows the difference. So divide and conquer is the strategy. Make it smaller and make it manageable. Reduce I/O contention and increase access time. Table and index Partitioning will help but it is not the only thing. Most important of all is how optimized, well structured and architected code is. This is where we spent most of the time. To modify the code, so we minimize number of SQL executions. Remove SQL from inner loops, optimize the SQL and specially process all the data as it came from the disks, so we do not have to go back to disk to get the data for processing it later. Keep your disk I/O down, buffer_get(reads) low by optimizing the INDEXes. From your email I can not tell what type of application you are working on. If it is data warehouse type application, Oracle has a good article on their site about using bitmap indexes and partitioning that might help you. If you are going to partition tables and indexes, you may want to consider Oracle parallel processing. That means you may need a multi-processor machine. You would consider having multiple controllers, if table spread over many drives. The list can be quite long depending on what your requirements are. Shakir [EMAIL PROTECTED] -Original Message- Sent: Friday, February 08, 2002 2:34 PM To: [EMAIL PROTECTED] fyi... Reply-To: [EMAIL PROTECTED] You should not expect to see much performance improvement, except in special cases where you can replace large deletes or loads by simpler partition operations. Your decision to use partitioning should be based on the ability to handle (i.e. DBA work) partitions separately, where you can e.g. mass delete/load, make parts read-only to reduce backup, or enable partial recovery during disk outages. Note, however, that much of this depends on your ability to partition indexes and data equivalently so that you avoid global indexes. Sathish Tatikonda wrote: Hi All, We are developing a system in which some tables in the database might be having about 100 Million records. We are planning to use table and index partition's as a means to improve performance. Could you please share your experiences/views about handling such huge tables. Is this partitioning sufficient or do we have to look in to some other means. It would also be of great help if you could provide me some pointers to documents which gives some insight for handling such tables and databases. thanks in advance, Sathish. _ Send and receive Hotmail on your mobile device: http://mobile.msn.com The information contained in this message is intended only for the recipient, may be privileged and confidential and protected from disclosure. If the reader of this message is not the intended recipient, or an employee or agent responsible for delivering this message to the intended recipient, please be aware that any dissemination or copying of this communication is strictly prohibited. If you have received this communication in error, please immediately notify us by replying to the message and deleting it from your computer. Thank you, Standard Poor's MOHAMMAD RAFIQ _ Join the worlds largest
RE: Weird connection behavior
The tnsnames.ora on your windows box does not have the correct connect string in it. Scott Shafer San Antonio, TX 210-581-6217 Common sense will not accomplish great things. Simply become insane and desperate. -Original Message- From: Daiminger, Helmut [SMTP:[EMAIL PROTECTED]] Sent: Friday, February 08, 2002 5:48 AM To: Multiple recipients of list ORACLE-L Subject: Weird connection behavior Hi! I'm experiencing a weird behavior here: when I try to connect to an Instance - named ITSP - (I am locally on the server): user/pw@itsp, the connect works fine. But when I try to connect to that same database from my windows client, using user/pw@itsp, I get the message: Oracle not available. Any idea what is going on here? This is 8.1.7 on Sun Solaris. Thanks, Helmut -- 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).
Finding out used blocks in the database
Hi As we all know RMAN backs up only the used blocks in the database.Was wondering if there is any way to query the database to find out if a block is used or not so as to find out how much of the database is currently being used ? TIA
RE: FTP Exports
These things happen. The partial file remains. Best way to do it is to do an ls -l on the transferred file on the host node then do it in ftp (to an output file), compare the sizes, and if they match you're golden, and if they don't, retry it. HTH, Bambi. -Original Message- Sent: Friday, February 08, 2002 10:04 AM To: Multiple recipients of list ORACLE-L I am FTPing exports in binary mode as a part of my backup/recovery plan. What happens when the network connection is lost between FTP client and server while a file is being transferred? Will an incomplete file appear on the FTP server or would the FTP server sense the disconnect and remove the partially transferred file? 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: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bellows, Bambi INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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-01000: maximum open cursors exceeded
Yep, open_cursors has always been a freebie. I can't help but think that an extraordinarily high open_cursors has to cost some semaphores, but I've managed to have very high open_cursors and very moderate semaphore settings and not run into any problems. HTH, Bambi. -Original Message- Sent: Friday, February 08, 2002 10:04 AM To: Multiple recipients of list ORACLE-L Dave, When I ran into this error using AP Oracle Applications, I was told this could be set as high as I wished with no performance hit up front (the cursors are not allocated, only allowed). In fact, the support analyst couldn't come up with a good reason why it shouldn't be set to the maximum for the platform (on Solaris at the time it was 1000). I suspect there is a reason, but getting the transactions through AP far outweighed the potential performance impact ;) (I didn't see any, but was really chasing other, larger performance issues at the time). Margaret -Original Message- From: Farnsworth, Dave [mailto:[EMAIL PROTECTED]] Sent: Friday, February 08, 2002 8:03 AM To: Multiple recipients of list ORACLE-L Subject: ORA-01000: maximum open cursors exceeded We had this error show up the other day. I am wondering if there is a performance limit on how big you should set your OPEN_CURSORS parameter in the SID.init file? Mine currently is set at 300. Are there any guidelines on this setting? Just wondering. Thanks, Dave -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Farnsworth, Dave INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Murray, Margaret INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Bellows, Bambi INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Call for Presenters(July/Oct 2001)
Joe, Kirti said I should speak to you about presenting my rman paper, 'What you always wanted to kow about rman but were afraid to ask' . He suggested I do one ro OOW in December and I am going to practice at NYOUG in Sept. I will give it a tryout here in April. He says you might even be able to pay my way...my boss won't pay or even give me the time off. Let me know! Regards, Ruth Gramolini - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, February 08, 2002 2:13 PM Doooh, who's a doofus and went thru a time/space continuum. July/Oct 2002. thanks, joe Deshpande, Kirti wrote: Just too darn late for July/Oct 2001 ;) - Kirti -Original Message- From: Joseph S Testa [mailto:[EMAIL PROTECTED]] Sent: Friday, February 08, 2002 11:24 AM To: Multiple recipients of list ORACLE-L Subject: Call for Presenters(July/Oct 2001) As a past President of Ohio Oracle Users Group, I still volunteer with our local user group and my current task if to ask you Oracle experts about presenting at our group. We are looking for presenters for out July 15th meeting. If you're interested in coming to Columbus OH for present, kindly let us know what your topic would be and the board will meet to choose and notify the people chosen. We are also looking for presenters for our Oct Meeting, if you're interested in that we'd like to see an abstract(50 words maximum). Please send all info to [EMAIL PROTECTED] or [EMAIL PROTECTED] Thanks, Joe -- 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: Ruth Gramolini INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).