RE: bad press for oracle....
Title: bad press for oracle Microsoft is buying IBM? Mladen Gogala Oracle DBA Phone:(203) 459-6855 Email:[EMAIL PROTECTED] -Original Message-From: Goulet, Dick [mailto:[EMAIL PROTECTED]Sent: Thursday, July 24, 2003 2:29 PMTo: Multiple recipients of list ORACLE-LSubject: RE: bad press for oracle Lets see, if memory is serving, Dial is signing an IT outsourcing deal with EDS. EDS & Oracle are NOT friends. EDS & IBM are. Oracle apps do not run on DB2, SAP does. SAP & EDS are friends. Do we see a connection there?? Dick GouletSenior Oracle DBAOracle Certified 8i DBA -Original Message-From: Chris Stephens [mailto:[EMAIL PROTECTED]Sent: Thursday, July 24, 2003 12:50 PMTo: Multiple recipients of list ORACLE-LSubject: bad press for oracle http://rss.com.com/2110-1017_3-5053453.html?type=pt&part=rss&tag=feed&subj=news
RE: Oracle 9i (9.2.0.4)- RH AS 2.1 HP Itanium
Oracle RDBMS 9.2.0.4??? I thought that the latest version was 9.2.0.3? Where did you get 9.2.0.4? Mladen Gogala Oracle DBA Phone:(203) 459-6855 Email:[EMAIL PROTECTED] -Original Message- Sent: Thursday, July 24, 2003 11:39 AM To: Multiple recipients of list ORACLE-L Hi there Who is running this. Would like to hear opinion and experiences. George George Leonard Oracle Database Administrator Dimension Data (Pty) Ltd (Reg. No. 1987/006597/07) Cell: (+27) 82 655 2466 Tel: (+27 11) 575 0573 Fax: (+27 11) 576 0573 E-mail:[EMAIL PROTECTED] Web: http://www.didata.co.za You Have The Obligation to Inform One Honestly of the risk, And As a Person You Are Committed to Educate Yourself to the Total Risk In Any Activity! Once Informed & Totally Aware of the Risk, Every Fool Has the Right to Kill or Injure Themselves as They See Fit! This email and all contents are subject to the following disclaimer: "http://www.didata.com/disclaimer.asp"; -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: George Leonard (ZA) INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gogala, Mladen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Re[2]: dba age
Yup! SQL Protected Mode Executable, which loaded oracle above 1M boundary on 286 boxes. I believe that the last ones were produced for oracle 6. Mladen Gogala Oracle DBA Phone:(203) 459-6855 Email:[EMAIL PROTECTED] -Original Message- Sent: Wednesday, July 23, 2003 4:40 PM To: Multiple recipients of list ORACLE-L S> I remember UFI, RPT-RPF, Forms 2.0 (IAD-IAG-IAP), SQL-QMX (for what it S> last),ODL (Oracle Data Loader), but I do not remember SQLPME . What was it ? Ow! That makes my brain hurt. I think it was like Protected Memory Executive that allowed Oracle to run up in the above 1M region on 386's and in some special archetectures with 286's. I hadn't relived that nightmare in many years. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Robert Eskridge INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gogala, Mladen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: index rebuild
Oh yes, index rebuild will solve all your problems. sqlplus "/ as sysdba" rtfm immediate Mladen Gogala Oracle DBA Phone:(203) 459-6855 Email:[EMAIL PROTECTED] -Original Message-From: AK [mailto:[EMAIL PROTECTED]Sent: Wednesday, July 23, 2003 2:15 PMTo: Multiple recipients of list ORACLE-LSubject: index rebuild Does index rebuild generates new statistics as well ? How does that can hit performance intermediately if I want to rebuild few indexes daily just to finish everything in 5 days . -ak
RE: possible to set continuation prompt in sql*plus?
set sqlprompt "^G" Will make it less quiet. Mladen Gogala Oracle DBA Phone:(203) 459-6855 Email:[EMAIL PROTECTED] -Original Message- Sent: Wednesday, July 23, 2003 4:19 PM To: Multiple recipients of list ORACLE-L Roy, You got me thinking on a tangent. How can I cut and paste the whole multi-line SQL statement at once and have it useable. Now you can, of course, use sqlplus in silent mode (-s), but that's a little too silent for my tastes. So how 'bout set sqlnumber off & sqlprompt ' '. That way you get: select blah, deblah from blahde where blah != deblah and ... Nicely cutable & pasteable, just thought I'd share. Mike Hand -Original Message- Sent: Tuesday, July 22, 2003 6:19 PM To: Multiple recipients of list ORACLE-L Apologies--I wasn't clear in my original post. Right now I'm getting: [EMAIL PROTECTED]> select username 2 from dba_users 3 where username like '%MC%' ; What I'd *really* like to have is: [EMAIL PROTECTED]> select username 2 from dba_users 3 where username like '%MC%' ; That way I could copy/paste sql commands as easily as I could when my prompt was just "SQL> ". Setting sqlnumber off gets me: [EMAIL PROTECTED]> select username [EMAIL PROTECTED]> from dba_users [EMAIL PROTECTED]> where username like '%MC%' ; Which isn't horrible, although I do miss the numbers. But no matter--I'll just live with it... Many thanks! -Roy Roy Pardee Programmer/Analyst/DBA SWFPAC Lockheed Martin IT Extension 8487 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hand, Michael T INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gogala, Mladen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: comments on 8i's autonomous PL/SQL block?
Yes, Maryan, that's exactly what you can do. Actually, session and transaction information are separated, so you can launch a separate transaction from within the current transaction. Here is an exerpt from the 9i PL/SQL manual: Once started, an autonomous transaction is fully independent. It shares no locks, resources, or commit-dependencies with the main transaction. So, you can log events, increment retry counters, and so on, even if the main transaction rolls back. Unlike regular triggers, autonomous triggers can contain transaction control statements such as COMMIT and ROLLBACK. Also, unlike regular triggers, autonomous triggers can execute DDL statements (such as CREATE and DROP) using native dynamic SQL The only missing feature is that you cannot do that asynchronously. Mladen Gogala Oracle DBA Phone:(203) 459-6855 Email:[EMAIL PROTECTED] -Original Message- Sent: Wednesday, July 23, 2003 3:04 PM To: Multiple recipients of list ORACLE-L Does anyone have any examples on the autonomous block provided in 8i? I read that it can have a transaction scope thats independent of the transaction scope of the calling block, and that it can perform operations, commit and rollback independent of the transactions of the calling block, before returning to the calling block? How is that? Does it mean it can start a transaction, update something, commit the change, and then return to the calling block where a change may still be uncommitted, even though the called block issued a commit? thx maa -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Maryann Atkinson INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gogala, Mladen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: dba age
Wow, I remember UFI, iapgen and RPT/RPF, but I started in 1989. Do you remember SQLPME? Mladen Gogala Oracle DBA Phone:(203) 459-6855 Email:[EMAIL PROTECTED] -Original Message-From: Michael Kline [mailto:[EMAIL PROTECTED]Sent: Wednesday, July 23, 2003 12:44 PMTo: Multiple recipients of list ORACLE-LSubject: RE: dba age Let's see... I remember dirt.. I remember UFI>. I remember version 4.1.0 that ran on DOS... PC, PC-XT.. Oracle since 1983... Good loaded question. Maks. -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Goulet, DickSent: Wednesday, July 23, 2003 12:09 PMTo: Multiple recipients of list ORACLE-LSubject: RE: dba age Now that's a LOADED question which I'm sure many a individual on this list will resist answering. Dick GouletSenior Oracle DBAOracle Certified 8i DBA -Original Message-From: AK [mailto:[EMAIL PROTECTED]Sent: Wednesday, July 23, 2003 11:55 AMTo: Multiple recipients of list ORACLE-LSubject: dba age Now this one is difficult folks . what is average age of an experienced oracle dba ? -ak
RE: dba age
I was born on 1/10/1961 in Zagreb, Croatia, which makes me 42 years of age. My horoscope sign is Ursus (6'4", 260 lbs, used to do greko-roman wrestling, I can still run 5 miles and lift myself on a chin-up bar). People sometimes confuse my age with the answer to certain question from the Doglas Adamses "Hitchiker's Guiide To Galaxy". Don't panic! Mladen Gogala Oracle DBA Phone:(203) 459-6855 Email:[EMAIL PROTECTED] -Original Message- Sent: Wednesday, July 23, 2003 12:55 PM To: Multiple recipients of list ORACLE-L Tanel. I am personally impressed with your pratical knowledge, based on your responses to this list. Mostly DBA's particpating on this list is 35+ (may in the range of 40-45). Only one DBA is 42 years old for the last 5 years. Guess who Gogala Mladen(don't shoot me as I am your fan). That is his favorite/magic figure 42. However, he can tell his real age if he wants. Regards Rafiq Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Date: Wed, 23 Jul 2003 08:09:56 -0800 Hi! Age isn't the most important criteria for good DBA. Ability to analyze issues and foresee possible consequences of your actions are the most important ones, at least from my point of view. Personally, I just turned 25. Whether I'm experienced or not, I won't speculate, but so far I've lost no data and have kept all my customers happy ;) Tanel. - Original Message - From: AK To: Multiple recipients of list ORACLE-L Sent: Wednesday, July 23, 2003 6:54 PM Subject: dba age Now this one is difficult folks .. what is average age of an experienced oracle dba ? -ak _ The new MSN 8: advanced junk mail protection and 2 months FREE* http://join.msn.com/?page=features/junkmail -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: M Rafiq INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gogala, Mladen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: dba age
I'm only thilteen. Mladen Gogala Oracle DBA Phone:(203) 459-6855 Email:[EMAIL PROTECTED] -Original Message-From: AK [mailto:[EMAIL PROTECTED]Sent: Wednesday, July 23, 2003 11:55 AMTo: Multiple recipients of list ORACLE-LSubject: dba age Now this one is difficult folks .. what is average age of an experienced oracle dba ? -ak
RE: HP-UX 11i/9.2.0.3/Strange Executions
Hopefully, not a pink one?
Mladen Gogala
Oracle DBA
Phone:(203) 459-6855
Email:[EMAIL PROTECTED]
-Original Message-
Sent: Tuesday, July 22, 2003 11:55 AM
To: Multiple recipients of list ORACLE-L
10gR4 will modify payroll and send me the check.
Jared
On Monday 21 July 2003 19:39, Mladen Gogala wrote:
> 10gR3 will read programmer's mind and automatically correct all design
> errors. RDBMS 11T will look like Arnie Schwartzenegger ("T" is for
> "Terminator"). I'll be back.
>
> On 2003.07.21 22:04, Rachel Carmichael wrote:
> > 10gR2 will automatically correct the errors.
> >
> > I'm waiting for the version that will know that I *meant* to type
> > "select" when I actually type "seelct"
> >
> > --- Daniel Fink <[EMAIL PROTECTED]> wrote:
> > > Okay, so its Monday...
> > >
> > > What I meant to say is that are the queries with different execution
> > > plans the ones encountering 7445s. If there is a common thread in the
> > > execution plans (i.e. hash join instead of nested loops), then the hj
> > > may be triggering the 7445s.
> > >
> > > Actually, 10g will have a new "FORETELL PLAN" feature that will
> > > predict the execution plan and all associated errors, complaints,
> > > incorrect data...
> > >
> > > "Gogala, Mladen" wrote:
> > > > Actually, I'm quite unaware of ORA-07745 as an execution plan. Can
> > >
> > > "EXPLAIN
> > >
> > > > PLAN"
> > > > foretell the error?
> > > >
> > > > Mladen Gogala
> > > > Oracle DBA
> > > > Phone:(203) 459-6855
> > > > Email:[EMAIL PROTECTED]
> > > >
> > > > -Original Message-
> > > > Sent: Monday, July 21, 2003 6:20 PM
> > > > To: Multiple recipients of list ORACLE-L
> > > >
> > > > Michael,
> > > > When you say 'different execution plans', what are the
> > >
> > > differences?
> > >
> > > > Is the choice in execution plans causing the ORA-07445? If so, why
> > >
> > > are the
> > >
> > > > execution plans different (there has to be a reason)? Statistics,
> > > > parameters, etc. will alter the execution plan choices.
> > > > The 7445 definitely deserves a call to Oracle Support
> > >
> > > (through SAP
> > >
> > > > if need be). 7445s are a royal pain to diagnose (like 600s).
> > > >
> > > > Daniel
> > > >
> > > >> begin:vcard
> > >
> > > n:Fink;Daniel
> > > tel;cell:303.808.3282
> > > tel;work:303.272.3225
> > > x-mozilla-html:TRUE
> > > adr:;;
> > > version:2.1
> > > email;internet:[EMAIL PROTECTED]
> > > title:DB Services Lead
> > > x-mozilla-cpt:;-4832
> > > fn:Daniel Fink
> > > end:vcard
> >
> > __
> > Do you Yahoo!?
> > Yahoo! SiteBuilder - Free, easy-to-use web site design software
> > http://sitebuilder.yahoo.com
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > --
> > Author: Rachel Carmichael
> > INET: [EMAIL PROTECTED]
> >
> > Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> > San Diego, California-- Mailing list and web hosting services
> > -
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from). You may
> > also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Jared Still
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Gogala, Mladen
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
RE: HP-UX 11i/9.2.0.3/Strange Executions
:A80 , :A81 , :A82 , :A83 , :A84 , :A85 , :A86 , > :A87 , :A88 , :A89 , :A90 , :A91 , :A92 , :A93 , :A94 , :A95 , :A96 , :A97 , :A98 , :A99 , :A100 , :A101 , :A102 , :A103 , :A104 , :A105 , :A106 , > :A107 , :A108 , :A109 , :A110 , :A111 , :A112 , :A113 , :A114 , :A115 , :A116 , :A117 , :A118 , :A119 , :A120 , :A121 , :A122 , :A123 , :A124 , :A > 125 , :A126 , :A127 , :A128 , :A129 , :A130 , :A131 , :A132 , :A133 , :A134 , :A135 , :A136 , :A137 , :A138 , :A139 , :A140 , :A141 , :A142 , :A143 > , :A144 , :A145 , :A146 , :A147 , :A148 , :A149 , :A150 , :A151 , :A152 , :A153 , :A154 , :A155 , :A156 , :A157 , :A158 , :A159 , :A160 , :A161 , > :A162 , :A163 , :A164 , :A165 , :A166 , :A167 , :A168 , :A169 , :A170 , :A171 , :A172 , :A173 , :A174 , :A175 , :A176 , :A177 , :A178 , :A179 , :A1 > 80 , :A181 , :A182 , :A183 , :A184 , :A185 , :A186 , :A187 , :A188 , :A189 , :A190 , :A191 , :A192 , :A193 , :A194 , :A195 , :A196 , :A197 , :A198 > , :A199 , :A200 , :A201 , :A202 , :A203 , :A204 , :A205 , :A206 , :A207 , :A208 , :A209 , :A210 , :A211 , :A212 , :A213 , :A214 , :A215 , :A216 , : > A217 , :A218 , :A219 , :A220 , :A221 , :A222 , :A223 , :A224 , :A225 , :A226 , :A227 , :A228 , :A229 , :A230 , :A231 , :A232 , :A233 , :A234 , :A23 > 5 , :A236 , :A237 , :A238 , :A239 , :A240 , :A241 , :A242 , :A243 , :A244 , :A245 , :A246 , :A247 , :A248 , :A249 , :A250 , :A251 , :A252 , :A253 , > :A254 , :A255 , :A256 , :A257 , :A258 , :A259 , :A260 , :A261 ) ) AND T_01 . "SPRAS" = :A262 > - Call Stack Trace - > > --- > === > Michael P. Vergara > Oracle DBA > Guidant Corporation > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Vergara, Michael (TEM) > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gogala, Mladen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: HP-UX 11i/9.2.0.3/Strange Executions
r16: 403f85d0 eiem: cr25: 4a2a808 r17: af0 iir: 72f50010 cr26: 4a2c808 r18:0 isr: a814c00 mpsfu_hi: 8001000e36c8 r19: 8001d9e8 ior: 80016ede9f30 mpsfu_lo: 0 r20:0 ipsw: ff080cff1f mpsfu_ov: 41 r21: 8001007d2650 goto:97f68 pad: 0 *** 2003-07-21 14:52:07.811 ksedmp: internal or fatal error ORA-07445: exception encountered: core dump [kghfrmrg()+596] [SIGSEGV] [unknown code] [0x80016EDE9F30] [] [] Current SQL statement for this session: SELECT T_00 . "MATNR" , T_00 . "PRDHA" , T_01 . "MAKTX" FROM "MARA" T_00 , "MAKT" T_01 WHERE ( T_01 . "MANDT" = :A0 AND T_01 . "MATNR" = T_00 . "MA TNR" ) AND T_00 . "MANDT" = :A1 AND ( ( T_00 . "MATNR" BETWEEN :A2 AND :A3 OR T_00 . "MATNR" BETWEEN :A4 AND :A5 OR T_00 . "MATNR" BETWEEN :A6 AND :A7 OR T_00 . "MATNR" BETWEEN :A8 AND :A9 OR T_00 . "MATNR" BETWEEN :A10 AND :A11 OR T_00 . "MATNR" BETWEEN :A12 AND :A13 OR T_00 . "MATNR" BETWEEN :A14 AND :A15 OR T_00 . "MATNR" BETWEEN :A16 AND :A17 OR T_00 . "MATNR" BETWEEN :A18 AND :A19 ) OR T_00 . "MATNR" IN ( :A20 , :A21 , :A22 , :A23 , :A24 , :A25 , :A26 , :A27 , :A28 , :A29 , :A30 , :A31 , :A32 , :A33 , :A34 , :A35 , :A36 , :A37 , :A38 , :A39 , :A40 , :A41 , :A42 , :A43 , :A44 , :A45 , :A46 , :A47 , :A48 , :A49 , :A50 , :A51 , :A52 , :A53 , :A54 , :A55 , :A56 , :A57 , :A58 , :A59 , :A60 , :A61 , :A62 , :A63 , :A64 , :A65 , :A66 , :A67 , :A68 , :A69 , :A70 , :A71 , :A72 , :A73 , :A74 , :A75 , :A76 , :A77 , :A78 , :A79 , :A80 , :A81 , :A82 , :A83 , :A84 , :A85 , :A86 , :A87 , :A88 , :A89 , :A90 , :A91 , :A92 , :A93 , :A94 , :A95 , :A96 , :A97 , :A98 , :A99 , :A100 , :A101 , :A102 , :A103 , :A104 , :A105 , :A106 , :A107 , :A108 , :A109 , :A110 , :A111 , :A112 , :A113 , :A114 , :A115 , :A116 , :A117 , :A118 , :A119 , :A120 , :A121 , :A122 , :A123 , :A124 , :A 125 , :A126 , :A127 , :A128 , :A129 , :A130 , :A131 , :A132 , :A133 , :A134 , :A135 , :A136 , :A137 , :A138 , :A139 , :A140 , :A141 , :A142 , :A143 , :A144 , :A145 , :A146 , :A147 , :A148 , :A149 , :A150 , :A151 , :A152 , :A153 , :A154 , :A155 , :A156 , :A157 , :A158 , :A159 , :A160 , :A161 , :A162 , :A163 , :A164 , :A165 , :A166 , :A167 , :A168 , :A169 , :A170 , :A171 , :A172 , :A173 , :A174 , :A175 , :A176 , :A177 , :A178 , :A179 , :A1 80 , :A181 , :A182 , :A183 , :A184 , :A185 , :A186 , :A187 , :A188 , :A189 , :A190 , :A191 , :A192 , :A193 , :A194 , :A195 , :A196 , :A197 , :A198 , :A199 , :A200 , :A201 , :A202 , :A203 , :A204 , :A205 , :A206 , :A207 , :A208 , :A209 , :A210 , :A211 , :A212 , :A213 , :A214 , :A215 , :A216 , : A217 , :A218 , :A219 , :A220 , :A221 , :A222 , :A223 , :A224 , :A225 , :A226 , :A227 , :A228 , :A229 , :A230 , :A231 , :A232 , :A233 , :A234 , :A23 5 , :A236 , :A237 , :A238 , :A239 , :A240 , :A241 , :A242 , :A243 , :A244 , :A245 , :A246 , :A247 , :A248 , :A249 , :A250 , :A251 , :A252 , :A253 , :A254 , :A255 , :A256 , :A257 , :A258 , :A259 , :A260 , :A261 ) ) AND T_01 . "SPRAS" = :A262 - Call Stack Trace - --- === Michael P. Vergara Oracle DBA Guidant Corporation -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Vergara, Michael (TEM) INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gogala, Mladen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San D
RE: 9i Grid "voodoo" cookbook
Microsoft is the world's largest provider of cluster f... solutions for the IT. Their OS has spawned $3G industry which has the sole purpose of trying to secure it. It is about time that they got some competition. Mladen Gogala Oracle DBA Phone:(203) 459-6855 Email:[EMAIL PROTECTED] -Original Message- Sent: Monday, July 21, 2003 5:25 PM To: Multiple recipients of list ORACLE-L (Yeah Tom Mercadante...I agree) I remember a time when Microsoft was spouting Windows clustering and how great it was. People started with two boxes then kept adding until the whole mess fell apart. People and companies whet bust promoting cluster solutions. Rather than sizing a box appropriately and purchasing the hardware sized to handle five years of growth now we are looking at a cluster scenario again. Adding boxes as we go. Just how easy is that? What about future security issues? Patches...etc... Frankly I find it hard to believe that anyone is going to save any money with blades and 9i RAC right now. Once again the hardware people have found that giving people less for the same cost is better (for them). Seems like the burden of testing and proving these cluster solutions is going to fall on us (IS). I mean really! Who would set this solution up and roll it into production in a weekend?? I sure wouldn't expect that. I would expect to have to create a test lab, buy test hardware and prove that it actually works. Seems expensive to me. Somebody honestly tell me they would have no problem converting a 8 way HP-UX box to four dual blades and 9i RAC in a weekend. Different packaging is all we have here. RAC is like a "lunchable". Less product, more expensive, more marketing promises and leaves a bad taste in my mouth. Don't get me wrong I think the idea sounds cool. It's just that we've all heard of cool stuff turning into a hot steaming pile real fast... IT budgets are stretched pretty thin. Buying unproven technology is not a very wise choice right now unless you have a lot of disposable cash for in house testing. Why should IT have to prove this works? Brad O. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Odland, Brad INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gogala, Mladen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: HP-UX 11i/9.2.0.3/Strange Executions
05 , :A106 , :A107 , :A108 , :A109 , :A110 , :A111 , :A112 , :A113 , :A114 , :A115 , :A116 , :A117 , :A118 , :A119 , :A120 , :A121 , :A122 , :A123 , :A124 , :A 125 , :A126 , :A127 , :A128 , :A129 , :A130 , :A131 , :A132 , :A133 , :A134 , :A135 , :A136 , :A137 , :A138 , :A139 , :A140 , :A141 , :A142 , :A143 , :A144 , :A145 , :A146 , :A147 , :A148 , :A149 , :A150 , :A151 , :A152 , :A153 , :A154 , :A155 , :A156 , :A157 , :A158 , :A159 , :A160 , :A161 , :A162 , :A163 , :A164 , :A165 , :A166 , :A167 , :A168 , :A169 , :A170 , :A171 , :A172 , :A173 , :A174 , :A175 , :A176 , :A177 , :A178 , :A179 , :A1 80 , :A181 , :A182 , :A183 , :A184 , :A185 , :A186 , :A187 , :A188 , :A189 , :A190 , :A191 , :A192 , :A193 , :A194 , :A195 , :A196 , :A197 , :A198 , :A199 , :A200 , :A201 , :A202 , :A203 , :A204 , :A205 , :A206 , :A207 , :A208 , :A209 , :A210 , :A211 , :A212 , :A213 , :A214 , :A215 , :A216 , : A217 , :A218 , :A219 , :A220 , :A221 , :A222 , :A223 , :A224 , :A225 , :A226 , :A227 , :A228 , :A229 , :A230 , :A231 , :A232 , :A233 , :A234 , :A23 5 , :A236 , :A237 , :A238 , :A239 , :A240 , :A241 , :A242 , :A243 , :A244 , :A245 , :A246 , :A247 , :A248 , :A249 , :A250 , :A251 , :A252 , :A253 , :A254 , :A255 , :A256 , :A257 , :A258 , :A259 , :A260 , :A261 ) ) AND T_01 . "SPRAS" = :A262 - Call Stack Trace - --- === Michael P. Vergara Oracle DBA Guidant Corporation -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Vergara, Michael (TEM) INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gogala, Mladen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: SHOW ERRORS not working
Have him try "SHOW ERRORS PROCEDURE " Mladen Gogala Oracle DBA Phone:(203) 459-6855 Email:[EMAIL PROTECTED] -Original Message- Sent: Monday, July 21, 2003 11:45 AM To: Multiple recipients of list ORACLE-L I have a developer that has ALTER ANY PROCEDURE rights. He changes a procedure, then compiles it and it says there are errors. But when he does a SHOW ERRORS in SQPlus, it shows nothing. If I do the same thing I can see the errors from the compiled procedure. I assume this is a permissions thing but have not been able to figure this one out. Anyone have any ideas on this? Thanks, Dave -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Farnsworth, Dave INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gogala, Mladen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: oracle10g
I thought it was "gridlock", not "grid"? You know, something like I-84 at 8:30 A.M.? Mladen Gogala Oracle DBA Phone:(203) 459-6855 Email:[EMAIL PROTECTED] -Original Message-From: Jamadagni, Rajendra [mailto:[EMAIL PROTECTED]Sent: Monday, July 21, 2003 11:14 AMTo: Multiple recipients of list ORACLE-LSubject: RE: oracle10g Oracle Grid Computing ... Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! -Original Message-From: Ruth Gramolini [mailto:[EMAIL PROTECTED]Sent: Monday, July 21, 2003 10:59 AMTo: Multiple recipients of list ORACLE-LSubject: RE: oracle10g What on earth does the g stand for? RBG -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Adams, Matthew (GECP, MABG, 088130)Sent: Thursday, July 17, 2003 3:45 PMTo: Multiple recipients of list ORACLE-LSubject: oracle10g Gotta love oracle. It won't be 10i, it'll be Oracle10g what on earth are they thinking? http://www.oracle.com/oracleworld/paris/conference/
RE: Howto Unsubscribe from this list
Send me a check to $500 and I'll get you off the hook. Mladen Gogala Oracle DBA Phone:(203) 459-6855 Email:[EMAIL PROTECTED] -Original Message- Sent: Friday, July 18, 2003 6:44 AM To: Multiple recipients of list ORACLE-L Hi Y'all, I'd like to unsubscribe from this list today as I am taking my holidays finally... Thank you, Regis * This electronic transmission is strictly confidential and intended solely for the addressee. It may contain information which is covered by legal, professional or other privilege. If you are not the intended addressee, you must not disclose, copy or take any action in reliance of this transmission. If you have received this transmission in error, please notify the sender as soon as possible. This footnote also confirms that this message has been swept for computer viruses. ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Regis Biassala INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gogala, Mladen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Why are SPFILEs binary anyway? (was RE: How to make SPFILE
SPFILE is instance specific, modified by "alter system", not by "alter database". That means that RAC doesn't affect it. You can try with raw device for the pfile, if you can do something like "vi /dev/rdsk/c0d1s2" (I hate [EMAIL PROTECTED] Emacs). If you can, please let me know which system allows that. Mladen Gogala Oracle DBA Phone:(203) 459-6855 Email:[EMAIL PROTECTED] -Original Message- Sent: Friday, July 18, 2003 11:15 AM To: Multiple recipients of list ORACLE-L My guess is that a "binary" SPFILE is expected to look the same whether it is a Raw Device [non-CFS RAC] or on a File System [CFS RAC or Single Instance database]. You should be able to do a dd of the SPFILE to move it between Raw and FileSystems. Thus you can take the SPFILE of a non-CFS RAC and plug it directly into use for CFS RAC or Single Database Instance. Hemant At 06:44 AM 17-07-03 -0800, you wrote: >I wonder if it is something built into the file or something that vi (or >whatever editor you are using) does to the file when you save it. I say >that because, if you edit the text part of an export file with vi, you get >an unusable file. But the text part of an export file can be edited by >other means and it will work -- for example, by running it through a C or >Perl program and editing the stream as it flows through the program; and I >think, if the export file is not too big (< 2 gig I think ) emacs (with >certain options??) can be used. > >The official word in the 9i new features class at the ivory tower in >Colorado Springs is that all the new features are wonderful, and you should >be using them. > > > -Original Message- > > > > it's a fake sort of binary -- try editing it with vi and then try > > opening your database with the spfile... but first make an init.ora > > copy of it. > > > > There is some sort of checksum going on, even though it looks like > > ASCII > > >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.net >-- >Author: Stephen Lee > INET: [EMAIL PROTECTED] > >Fat City Network Services-- 858-538-5051 http://www.fatcity.com >San Diego, California-- Mailing list and web hosting services >- >To REMOVE yourself from this mailing list, send an E-Mail message >to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in >the message BODY, include a line containing: UNSUB ORACLE-L >(or the name of mailing list you want to be removed from). You may >also send the HELP command for other information (like subscribing). Hemant K Chitale Oracle 9i Database Administrator Certified Professional My personal web site is : http://hkchital.tripod.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hemant K Chitale INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gogala, Mladen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: tuning : file number translation table
Carol, you have problems with the operating system, not oracle. Increase the parameter NINODE for your underlying OS. Inodes are being written to and from inode cache, thus causing waits. Mladen Gogala Oracle DBA Phone:(203) 459-6855 Email:[EMAIL PROTECTED] -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]Sent: Friday, July 18, 2003 11:09 AMTo: Multiple recipients of list ORACLE-LSubject: tuning : file number translation tableI'm hoping someone out there has experienced this problem... I can't seem to find many posts on MetaLink that discuss this. My environment : - I am running a 500 Gig OLTP database in a Solaris environment. I have some 0+1 disk available, but mostly RAID5 (array) for the datafiles. This is not in production yet, but we're doing some load testing, and so far, I've had the typical contentions with the "undo header" and "undo block" contention, "segment header" and so on. I've reduced these issues significantly, but now I think I may have a problem with "hot spots" and I/O. The one latch that comes up with a high % (contention) is "file number translation table". Its at %15. All other latch miss percentages are below 0. Seems like the access to the files is being pounded. Anyone had contention with this latch before ? Another thing that make me feel this is possibly I/O related is that the tablespace and datafiles show an uneven amount of activity across all possibly because this app naturally does tons of INSERTS and few UPDATES. Maybe I need to use partitioning to even out the activity. The top wait stats are related to dispatchers and MTS. I have a lot of dispatchers and shared servers (all are busy) but I suspect these wait stats are high because file access may now be the issue. Should I consider fewer dispatchers and shared servers ? This may relieve the "file number translation table" situation, but then I'm back to where I started before (lower number of concurrent sessions with a reasonable response time). Any advice or comments would be appreciated. Thanks in advance, Carol <>
RE:
Title: Message Nope, I am a Croatian and I live in Connecticut. I was just referring to an old movie called "The Life of Brian". Mladen Gogala Oracle DBA Phone:(203) 459-6855 Email:[EMAIL PROTECTED] -Original Message-From: Nelson, Allan [mailto:[EMAIL PROTECTED]Sent: Thursday, July 17, 2003 4:20 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Are you perhaps of Greek descent and living in Wisconsin? :-) Allan -Original Message-From: Gogala, Mladen [mailto:[EMAIL PROTECTED] Sent: Thursday, July 17, 2003 10:44 AMTo: Multiple recipients of list ORACLE-LSubject: RE: Correction: Blessed are the cheesemakers, for they shall be called the sons of God. Blessed are the Greek, for they shall inherit the Earth. Comment: It's obviously deeper then just the cheese makers, it is referring to all manufacturers of the dairy products. Mladen Gogala Oracle DBA Phone:(203) 459-6855 Email:[EMAIL PROTECTED] -Original Message-----From: Gogala, Mladen [mailto:[EMAIL PROTECTED]Sent: Wednesday, July 16, 2003 7:59 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Blessed are the cheesemakers, because they shall rule the Kingdom of God. Blessed are the Greek, because they shall inherit the Earth. Hope this helps you. Mladen Gogala Oracle DBA Phone:(203) 459-6855 Email:[EMAIL PROTECTED] -Original Message-From: Tom Pall [mailto:[EMAIL PROTECTED]Sent: Wednesday, July 16, 2003 7:39 PMTo: Multiple recipients of list ORACLE-LSubject: help __This email is intended solely for the person or entity to which it is addressed and may contain confidential and/or privileged information. Copying, forwarding or distributing this message by persons or entities other than the addressee is prohibited. If you have received this email in error, please contact the sender immediately and delete the material from any computer. This email may have been monitored for policy compliance. [021216]
RE: oracle10g
Gridlock computing is available since the dawn of computing, all that is needed is a proper application design. I've seen quite a few applications using oracle RDBMS to implement gridlock computing, producing look and feel quite similar to LIE (I-495 in NY) on Monday 08:15 A.M.. Mladen Gogala Oracle DBA Phone:(203) 459-6855 Email:[EMAIL PROTECTED] -Original Message-From: Boivin, Patrice J [mailto:[EMAIL PROTECTED]Sent: Thursday, July 17, 2003 4:20 PMTo: Multiple recipients of list ORACLE-LSubject: RE: oracle10g Think "G" for globally. They are thinking globally. The grid computing page on otn says grid computing is available now for 9i release 2... Patrice. -Original Message-From: Adams, Matthew (GECP, MABG, 088130) [mailto:[EMAIL PROTECTED]Sent: Thursday, July 17, 2003 4:45 PMTo: Multiple recipients of list ORACLE-LSubject: oracle10g Gotta love oracle. It won't be 10i, it'll be Oracle10g what on earth are they thinking? http://www.oracle.com/oracleworld/paris/conference/
RE: Why are SPFILEs binary anyway? (was RE: How to make SPFILE in
Why would you want to do that? You can always re-create the file from your PFILE. Oracle should have encrypted it. Mladen Gogala Oracle DBA Phone:(203) 459-6855 Email:[EMAIL PROTECTED] -Original Message- Sent: Thursday, July 17, 2003 12:10 PM To: Multiple recipients of list ORACLE-L in That's a good point. Someone should try a binary editor instead, like bvi and see what happens. -Original Message- Sent: Thursday, July 17, 2003 10:45 AM To: Multiple recipients of list ORACLE-L in I wonder if it is something built into the file or something that vi (or whatever editor you are using) does to the file when you save it. I say that because, if you edit the text part of an export file with vi, you get an unusable file. But the text part of an export file can be edited by other means and it will work -- for example, by running it through a C or Perl program and editing the stream as it flows through the program; and I think, if the export file is not too big (< 2 gig I think ) emacs (with certain options??) can be used. The official word in the 9i new features class at the ivory tower in Colorado Springs is that all the new features are wonderful, and you should be using them. > -Original Message- > > it's a fake sort of binary -- try editing it with vi and then try > opening your database with the spfile... but first make an init.ora > copy of it. > > There is some sort of checksum going on, even though it looks like > ASCII > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Richard Ji INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gogala, Mladen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE:
Correction: Blessed are the cheesemakers, for they shall be called the sons of God. Blessed are the Greek, for they shall inherit the Earth. Comment: It's obviously deeper then just the cheese makers, it is referring to all manufacturers of the dairy products. Mladen Gogala Oracle DBA Phone:(203) 459-6855 Email:[EMAIL PROTECTED] -Original Message-From: Gogala, Mladen [mailto:[EMAIL PROTECTED]Sent: Wednesday, July 16, 2003 7:59 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Blessed are the cheesemakers, because they shall rule the Kingdom of God. Blessed are the Greek, because they shall inherit the Earth. Hope this helps you. Mladen Gogala Oracle DBA Phone:(203) 459-6855 Email:[EMAIL PROTECTED] -Original Message-From: Tom Pall [mailto:[EMAIL PROTECTED]Sent: Wednesday, July 16, 2003 7:39 PMTo: Multiple recipients of list ORACLE-LSubject: help
RE:
Blessed are the cheesemakers, because they shall rule the Kingdom of God. Blessed are the Greek, because they shall inherit the Earth. Hope this helps you. Mladen Gogala Oracle DBA Phone:(203) 459-6855 Email:[EMAIL PROTECTED] -Original Message-From: Tom Pall [mailto:[EMAIL PROTECTED]Sent: Wednesday, July 16, 2003 7:39 PMTo: Multiple recipients of list ORACLE-LSubject: help
RE: RMAN & SQL Backtrack
Title: Message
Ruth,
that is correct but, generally speaking, backup to disk is rather awkward thing
to
do,
even without mentioning the fact that you need more disks for that and that
disks
are not free, either. Between thwe two of us, I don't
know a company doing backups to
the
disk.
Mladen Gogala Oracle DBA Phone:(203) 459-6855
Email:[EMAIL PROTECTED]
-Original Message-From: Ruth Gramolini
[mailto:[EMAIL PROTECTED]Sent: Wednesday, July 16, 2003
12:25 PMTo: Multiple recipients of list ORACLE-LSubject:
Re: RMAN & SQL Backtrack
Mladen, one correction or comment. You don't need
a third party package if you are backing up to disk. Then it's straight
rman.
Ruth
- Original Message -----
From:
Gogala, Mladen
To: Multiple
recipients of list ORACLE-L
Sent: Wednesday, July 16, 2003 11:39
AM
Subject: RE: RMAN & SQL
Backtrack
I
don't have any experience with SQL*Backtrack and I do have some
experience
with RMAN. Here are my
comments:
a)
RMAN is reliable. Once you write the backup scripts, they are executed by
operations
and there no surprises. In order
to rely on those scripts, one needs to test them,
especially
the recovery
part.
b)
RMAN needs a 3rd party backup software to run. Things like OmniBackup,
Tivoli, Legato or
SyncSort can be rather
expensive. RMAN doesn't write to tapes itself. RMAN delegates
a
backup software contacted
through the routines from libobk.so (or libobk.dll or libobk.sl)
to
do its writing. To get the
"libobk.so" from you backup software vendor of choice, you generally
have to write a check. That
means that RMAN is NOT free.
c)
Before version 9, RMAN was arcane and hard to learn. Thanks to Robert
Freeman, it is no
longer so. You can learn how to
configure and use RMAN and you can find a decent book
to learn RMAN from. It's not
very hard and it's fairly logical. One reading of the books suffices
for a good general
understanding.
d)
Quality of the software: RMAN leaves a lot to be desired. Its biggest
drawback is the fact that
it doesn't do any coordination
with the underlying backup catalog. In other words, you can
happily
declare backup obsolete in RMAN
and Legato will not know anything about it and vice
versa.
You can even delete backup in
Legato and reuse the tape while RMAN knows nothing about
it.
On the other hand, RMAN,
in contrast to all other methods, does not put tablespaces into
the
backup mode, thus
generating floods of redo archives. RMAN doesn't backup data blocks that
have never been used
("behind the watermark blocks"), which is great if you have a fresh
new
datafile which was added
to the tablespace just in case something might run out of
space.
e) Personnel. Despite the certification
process, it is not always easy to find a trained
personnel
which knows how to use it
and how to recover the database. I consider the ability to
recover
the database a basis for
someone to call himself/herself a DBA. You would be surprised
how
many people which claim
that title do not know how to recover the database. Even smaller number
knows how to use
RMAN.
f) I would suggest Jared Still, Cary
Millsap, Rachel Carmichael, Jonathan Lewis, Wolfgang Breitling,
Steve Adams, Gaja V., Arup
Nanda, Kirti Deshpande and Anjo Kolk to start the Oracle
List certification
process. I would trust
that one more then the OCP. I apologize to anyone who
I might have forgotten.
Mladen Gogala Oracle DBA Phone:(203)
459-6855 Email:[EMAIL PROTECTED]
-Original Message-From: Smith, Ron L.
[mailto:[EMAIL PROTECTED]Sent: Wednesday, July 16, 2003 10:59
AMTo: Multiple recipients of list ORACLE-LSubject:
RMAN & SQL Backtrack
We have been
using SQL Backtrack for backup and recovery for about 6 years
now. We are being pressured to start using RMAN because it is
free. Makes sense but I am wondering about reliability, complexity,
learning curve, etc...
Has anyone had
experience with both products or anyone new to RMAN that can give me an
idea of what to expect?
Thanks!
Ron
If you are not the intended recipient of this
e-mail message, any use, distribution or copying of the message is
prohibited. Please let me know immediately by return e-mail if you have
received this message by mistake, then delete the e-mail message. Thank
you.
RE: RMAN & SQL Backtrack
Hopefully, that doesn't mean that Gaja will start working
with SQL*Server? If he's moving to the management, that is well
deserved.
Mladen Gogala
Oracle DBA
Phone:(203) 459-6855
Email:[EMAIL PROTECTED]
-Original Message-
Sent: Wednesday, July 16, 2003 6:04 PM
To: Multiple recipients of list ORACLE-L
Kirti,
Gaja is moving the other (dark) side???
Elaboration, please.
Arup
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Wednesday, July 16, 2003 5:29 PM
> Wow! Mladen, thanks for listing my name in your list.
> As Arup mentioned, you forgot yourself. I would also suggest Dan Fink, Tim
Gorman, and Dr. Mogens!
> Gaja is moving the other (dark) side, so I won't mind excluding him :)
>
> When it comes to RMAN, I am not even in the rookie stage. We bought a few
copies of RF's book. But
> mine has now found its place under my desk! The Damagement is not yet
willing to commit any time
> and resources to "play" with RMAN and without the Tivoli API, we can not
do much.
>
> Although RMAN is free and the MML API may not cost as much, but when you
have a merged Company
> like ours (VERIZON=GTE + BellAtlantic), we have our own 'sand boxes' and
playing fields. Old BA
> stuff still uses SQL*BT while we, the fGTE DBAs want to move to RMAN
But may be we all leave
> that decision to Amdocs, as they might get our IT business pretty soon,
per some official rumors.
> Till then we will continue to use good old, and aged, hot backup scripts
to backup databases of
> all shapes and sizes (from 1G to over 500G)
>
> Cheers!
>
> - Kirti
>
> --- "Gogala, Mladen" <[EMAIL PROTECTED]> wrote:
> > I don't have any experience with SQL*Backtrack and I do have some
experience
> > with RMAN. Here are my comments:
> > a) RMAN is reliable. Once you write the backup scripts, they are
executed by
> > operations
> > and there no surprises. In order to rely on those scripts, one needs
to
> > test them, especially
> > the recovery part.
> > b) RMAN needs a 3rd party backup software to run. Things like
OmniBackup,
> > Tivoli, Legato or
> > SyncSort can be rather expensive. RMAN doesn't write to tapes
itself.
> > RMAN delegates a
> > backup software contacted through the routines from libobk.so (or
> > libobk.dll or libobk.sl) to
> > do its writing. To get the "libobk.so" from you backup software
vendor
> > of choice, you generally
> > have to write a check. That means that RMAN is NOT free.
> > c) Before version 9, RMAN was arcane and hard to learn. Thanks to Robert
> > Freeman, it is no
> > longer so. You can learn how to configure and use RMAN and you can
find
> > a decent book
> > to learn RMAN from. It's not very hard and it's fairly logical. One
> > reading of the books suffices
> > for a good general understanding.
> > d) Quality of the software: RMAN leaves a lot to be desired. Its biggest
> > drawback is the fact that
> > it doesn't do any coordination with the underlying backup catalog.
In
> > other words, you can happily
> > declare backup obsolete in RMAN and Legato will not know anything
about
> > it and vice versa.
> > You can even delete backup in Legato and reuse the tape while RMAN
> > knows nothing about it.
> > On the other hand, RMAN, in contrast to all other methods, does not
put
> > tablespaces into the
> > backup mode, thus generating floods of redo archives. RMAN doesn't
> > backup data blocks that
> > have never been used ("behind the watermark blocks"), which is
great if
> > you have a fresh new
> > datafile which was added to the tablespace just in case something
might
> > run out of space.
> > e) Personnel. Despite the certification process, it is not always easy
to
> > find a trained personnel
> > which knows how to use it and how to recover the database. I
consider
> > the ability to recover
> > the database a basis for someone to call himself/herself a DBA. You
> > would be surprised how
> > many people which claim that title do not know how to recover the
> > database. Even smaller number
> > knows how to use RMAN.
> > f) I would suggest Jared Still, Cary Millsap, Rachel Carmichael,
Jonathan
> > Lewis, Wolfgang Breitling,
> > Steve Adams, Gaja V., Arup Nanda, Kirti Deshpande and Anjo Kolk to
> > start the Oracle List certification
> > process. I would trust that one more then the OCP. I apologize to
anyone
> > who I might have forgotten.
> >
Damagement
Does anyone here have the original Dilber comic page that introduced the term "damagment"? I'd appreciate if someone sent it to me. Mladen Gogala Oracle DBA Phone:(203) 459-6855 Email:[EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gogala, Mladen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: * Sr. Oracle DBA with 8i and 9i experience needed..
Title: RE: * Sr. Oracle DBA with 8i and 9i experience needed.. Especially if he always uses his own, real address. I've put him in my "kill file" and I don't even have to pres "Delete" key or whatever it is they have in TX. Mladen Gogala Oracle DBA Phone:(203) 459-6855 Email:[EMAIL PROTECTED] -Original Message-From: Goulet, Dick [mailto:[EMAIL PROTECTED]Sent: Wednesday, July 16, 2003 12:00 PMTo: Multiple recipients of list ORACLE-LSubject: RE: * Sr. Oracle DBA with 8i and 9i experience needed.. Of the total SPAM I get each day, OraStaff is so far down in the noise to be unnoticeable. Heck I'll tolerate any spammer who only bothers me once or twice a month. Dammed those who bother me twice an hour! Dick GouletSenior Oracle DBAOracle Certified 8i DBA -Original Message-From: April Wells [mailto:[EMAIL PROTECTED]Sent: Wednesday, July 16, 2003 11:35 AMTo: Multiple recipients of list ORACLE-LSubject: RE: * Sr. Oracle DBA with 8i and 9i experience needed.. depends on the keyboard... I have one where it is right next to the enter key and backslash is next to the back space key. April Wells Oracle DBA/Oracle Apps DBA Corporate Systems Amarillo Texas You will recognize your own path when you come upon it, because you will suddenly have all the energy and imagination you will ever need. ~ Jerry Gillies ~ -Original Message- From: Ruth Gramolini [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 16, 2003 10:15 AM To: Multiple recipients of list ORACLE-L Subject: Re: * Sr. Oracle DBA with 8i and 9i experience needed.. Some of us like seeing the possibilities. The delete key is just to the right of the backslash. Ruth - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Wednesday, July 16, 2003 11:04 AM Jared, can we get orastaff banned from the list? I know people need jobs but Orastaff is a notorious spammer. I get spammed from these guys through my home email. > > From: OraStaff <[EMAIL PROTECTED]> > Date: 2003/07/16 Wed AM 10:54:27 EDT > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > Sr. Oracle DBA with 8i and 9i experience needed.. > > Minneapolis, Minnesota company has a great opportunity available for a Sr. level > Oracle DBA to join their IT staff. > > The selected candidate must be highly skilled in solving extremely complex > and very > critical customer issues. With preferably over 10 years experience in a > large-scale > multi-network open-systems environment, the candidate anticipates and plans > for reliability, > availability, and serviceability in the design, development and > implementation of > Oracle 8i and 9i solutions. > The candidate will be recognized as a technical authority in the design, > analysis, > implementation and integration of large-scale database management systems. > > Candidates local to the Minneapolis area are preferred, but any candidate > who meets > the qualifications for the position will be considered. > > Base Salary is in the 85-100K range plus bonus. > > PLEASE Do Not send your resume for this position UNLESS you have the skills > outlined below for this position. > > Please Do Not send your resume unless you have a stable work history. > Candidates whose work history includes frequent job changes connot be > considered. > > This is a full time staff position so no sub-contractors or third parties > please. > > NO H-1B candidates please. > > > *MUST meet these requirements: > -BS degree in CS or related field. > -8-10 years experience in a large-scale multi-network open-systems environment. > -Very solid Oracle DBA experience..including 8i and 9i. > -Proficient at capacity monitoring and management capabilities, preferably > an expert knowledge > of Enterprise Manager 9i (OEM), and STATSPACK. > -Experience performing Oracle installations, upgrades, and supporting Oracle > utilities > and services in a variety of operating systems (Solaris, NT, Linux) is > required. > -Migration and upgrade experience is essential. > -Expert knowledge of on-line back-up/recovery procedures with "snapshotting" > a plus. > -Proficiency with RMAN is essential. > -Ability to work with engineering staff to configure SAN storage for optimal > Oracle performance. > -Expert knowledge of UNIX scripting including CRON Jobs, Oracle Stored > Procedures, Triggers, > Packages, Real Application Clusters (RAC). > -Performance Tuning and Performance management skills are required, > SQL*Plus, PL/SQL, > SQL*Loader, SQL, and UNIX. > -The applicant must have in-depth experience with ER diagramming, data > modeling tools, > (erWIN preferred) normalization, de-normalization, database programming and > design, > query optimization, index optimizat
RE: * Sr. Oracle DBA with 8i and 9i experience needed..
Title: RE: * Sr. Oracle DBA with 8i and 9i experience needed.. Does TX have special keyboard layout? I know that everything is big in TX, but I didn't realize that was the case with the keyboards? Mladen Gogala Oracle DBA Phone:(203) 459-6855 Email:[EMAIL PROTECTED] -Original Message-From: April Wells [mailto:[EMAIL PROTECTED]Sent: Wednesday, July 16, 2003 11:35 AMTo: Multiple recipients of list ORACLE-LSubject: RE: * Sr. Oracle DBA with 8i and 9i experience needed.. depends on the keyboard... I have one where it is right next to the enter key and backslash is next to the back space key. April Wells Oracle DBA/Oracle Apps DBA Corporate Systems Amarillo Texas You will recognize your own path when you come upon it, because you will suddenly have all the energy and imagination you will ever need. ~ Jerry Gillies ~ -Original Message- From: Ruth Gramolini [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 16, 2003 10:15 AM To: Multiple recipients of list ORACLE-L Subject: Re: * Sr. Oracle DBA with 8i and 9i experience needed.. Some of us like seeing the possibilities. The delete key is just to the right of the backslash. Ruth - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Wednesday, July 16, 2003 11:04 AM Jared, can we get orastaff banned from the list? I know people need jobs but Orastaff is a notorious spammer. I get spammed from these guys through my home email. > > From: OraStaff <[EMAIL PROTECTED]> > Date: 2003/07/16 Wed AM 10:54:27 EDT > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > Subject: * Sr. Oracle DBA with 8i and 9i experience needed.. > > Minneapolis, Minnesota company has a great opportunity available for a Sr. level > Oracle DBA to join their IT staff. > > The selected candidate must be highly skilled in solving extremely complex > and very > critical customer issues. With preferably over 10 years experience in a > large-scale > multi-network open-systems environment, the candidate anticipates and plans > for reliability, > availability, and serviceability in the design, development and > implementation of > Oracle 8i and 9i solutions. > The candidate will be recognized as a technical authority in the design, > analysis, > implementation and integration of large-scale database management systems. > > Candidates local to the Minneapolis area are preferred, but any candidate > who meets > the qualifications for the position will be considered. > > Base Salary is in the 85-100K range plus bonus. > > PLEASE Do Not send your resume for this position UNLESS you have the skills > outlined below for this position. > > Please Do Not send your resume unless you have a stable work history. > Candidates whose work history includes frequent job changes connot be > considered. > > This is a full time staff position so no sub-contractors or third parties > please. > > NO H-1B candidates please. > > > *MUST meet these requirements: > -BS degree in CS or related field. > -8-10 years experience in a large-scale multi-network open-systems environment. > -Very solid Oracle DBA experience..including 8i and 9i. > -Proficient at capacity monitoring and management capabilities, preferably > an expert knowledge > of Enterprise Manager 9i (OEM), and STATSPACK. > -Experience performing Oracle installations, upgrades, and supporting Oracle > utilities > and services in a variety of operating systems (Solaris, NT, Linux) is > required. > -Migration and upgrade experience is essential. > -Expert knowledge of on-line back-up/recovery procedures with "snapshotting" > a plus. > -Proficiency with RMAN is essential. > -Ability to work with engineering staff to configure SAN storage for optimal > Oracle performance. > -Expert knowledge of UNIX scripting including CRON Jobs, Oracle Stored > Procedures, Triggers, > Packages, Real Application Clusters (RAC). > -Performance Tuning and Performance management skills are required, > SQL*Plus, PL/SQL, > SQL*Loader, SQL, and UNIX. > -The applicant must have in-depth experience with ER diagramming, data > modeling tools, > (erWIN preferred) normalization, de-normalization, database programming and > design, > query optimization, index optimization, use of hints. Optimal setup of > dblink, views, > and use of Oracle gateway is required. Must understand how to design and > tune an Oracle > database to optimize performance for potentially thousands of concurrent, > browser-based > users together with ETL processes. > -Excellent written and verbal communications skills with the ability to > effectively communicate > technical and business problems/issues in a non-technical manner, strong > problem resolution, > analysis, and customer ser
RE: * Sr. Oracle DBA with 8i and 9i experience needed..
tp://www.orafaq.net > -- > Author: OraStaff > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: <[EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ruth Gramolini INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services --------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gogala, Mladen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: RMAN & SQL Backtrack
Title: Message
I
don't have any experience with SQL*Backtrack and I do have some
experience
with
RMAN. Here are my comments:
a)
RMAN is reliable. Once you write the backup scripts, they are executed by
operations
and there no surprises. In order to
rely on those scripts, one needs to test them, especially
the recovery
part.
b)
RMAN needs a 3rd party backup software to run. Things like OmniBackup, Tivoli,
Legato or
SyncSort can be rather expensive.
RMAN doesn't write to tapes itself. RMAN delegates a
backup software contacted through
the routines from libobk.so (or libobk.dll or libobk.sl) to
do its writing. To get the
"libobk.so" from you backup software vendor of choice, you generally
have to write a check. That means
that RMAN is NOT free.
c)
Before version 9, RMAN was arcane and hard to learn. Thanks to Robert Freeman,
it is no
longer so. You can learn how to
configure and use RMAN and you can find a decent book
to learn RMAN from. It's not very
hard and it's fairly logical. One reading of the books suffices
for a good general
understanding.
d)
Quality of the software: RMAN leaves a lot to be desired. Its biggest drawback
is the fact that
it doesn't do any coordination with
the underlying backup catalog. In other words, you can
happily
declare backup obsolete in RMAN and
Legato will not know anything about it and vice versa.
You can even delete backup in Legato
and reuse the tape while RMAN knows nothing about it.
On the other hand, RMAN, in
contrast to all other methods, does not put tablespaces into
the
backup mode, thus generating
floods of redo archives. RMAN doesn't backup data blocks that
have never been used ("behind
the watermark blocks"), which is great if you have a fresh
new
datafile which was added to
the tablespace just in case something might run out of
space.
e) Personnel. Despite the certification process,
it is not always easy to find a trained personnel
which knows how to use it and
how to recover the database. I consider the ability to
recover
the database a basis for
someone to call himself/herself a DBA. You would be surprised
how
many people which claim that
title do not know how to recover the database. Even smaller number
knows how to use
RMAN.
f) I would suggest Jared Still, Cary
Millsap, Rachel Carmichael, Jonathan Lewis, Wolfgang Breitling,
Steve Adams, Gaja V., Arup Nanda,
Kirti Deshpande and Anjo Kolk to start the Oracle List
certification
process. I would trust
that one more then the OCP. I apologize to anyone who I
might have forgotten.
Mladen Gogala Oracle DBA Phone:(203) 459-6855
Email:[EMAIL PROTECTED]
-Original Message-From: Smith, Ron L.
[mailto:[EMAIL PROTECTED]Sent: Wednesday, July 16, 2003 10:59
AMTo: Multiple recipients of list ORACLE-LSubject: RMAN
& SQL Backtrack
We have been using
SQL Backtrack for backup and recovery for about 6 years now. We are
being pressured to start using RMAN because it is free. Makes sense but
I am wondering about reliability, complexity, learning curve,
etc...
Has anyone had
experience with both products or anyone new to RMAN that can give me an idea
of what to expect?
Thanks!
Ron
If you are not the intended recipient of this
e-mail message, any use, distribution or copying of the message is prohibited.
Please let me know immediately by return e-mail if you have received this
message by mistake, then delete the e-mail message. Thank
you.
RE: Oracle pricing question
That's a big sale, something like your friendly neighborhood Dodge sale. You can get Oracle Ram, with world's most powerful V8 engine and $3000 cashback with 0.7 APR. All bells and whistles like the Spatial Option, Transparent Gateways and Advanced Networking are included. Mladen Gogala Oracle DBA Phone:(203) 459-6855 Email:[EMAIL PROTECTED] -Original Message- Sent: Tuesday, July 15, 2003 11:15 AM To: Multiple recipients of list ORACLE-L Oracle used to sell databases "options" as add-ons to Oracle EE. I went to the Oracle Store web site, can't find any options listed anywhere. Do Spatial, Advanced Security, and Transparent Gateways all come with the EE license now? That would be nice. : ) Patrice. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gogala, Mladen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: should you seperate indexes from tables in seperate datafiles
Actually, there is a performance benefit, but is almost negligible. Performance benefit comes from the fact that indexes are usually read by using "db_file_sequential_read", which is, as I was told by 3 or 4 wise men without any gifts, a single block read. Having vast majority of I/O being short allows, at least in theory, the controller to better optimize the incoming I/O requests, thus achieving better service times. I must say that I haven't actually seen the benefits myself but my faith is rock solid and I'll continue to separate data from indexes. Mladen Gogala Oracle DBA Phone:(203) 459-6855 Email:[EMAIL PROTECTED] -Original Message- Sent: Tuesday, July 15, 2003 11:04 AM To: Multiple recipients of list ORACLE-L datafiles? I separate indexes and tables into different tablespaces for maintenance purposes, not for performance, as there really is no performance benefit if you are on a system with multiple users. At any given time, many users will be doing queries that read the indexes and many users will be doing queries that read the tables. Besides, I don't get to control how my disks are set up (part of that "now now little girl, don't you worry your pretty little head about how the disks are set up, you just leave that sort of stuff to us big data center operations people" crap I get) Maintenance: if I lose an index tablespace datafile, I can just offline/drop the tablespace and recreate it and the indexes within it rather than do recovery. My indexes and my tables tend to have different extent size requirements (most of my indexes are NOT comprised of all columns in the table) so I separate them for extent size purposes as well. --- [EMAIL PROTECTED] wrote: > There has been alot of literature stating that you will recieve > performance improvements by seperating indexes and tables across > multiple I/O points. > > Ie... you have a tables tablespace and an index tablespace. If you > put them on seperate hard drives, you will have less I/O contention. > > Now Im seeing some articles stating that this is not true. That > oracle actually accesses indexes and tables serially. Now it might be > useful seperate indexes from tables for maintenance purposes but this > wont lower I/O contention. > > Can anyone chime in on this? Curious to see where the evidence is > leading? > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: <[EMAIL PROTECTED] > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). __ Do you Yahoo!? SBC Yahoo! DSL - Now only $29.95 per month! http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gogala, Mladen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: RAC system Calls
The "times" call is very cheap and could not possibly consume so much time.
Here is what man page says:
NAME
times - get process and child process times
SYNOPSIS
#include
clock_t times(struct tms *buffer);
DESCRIPTION
times() fills the structure pointed to by buffer with time-accounting
information. The structure defined in is as follows:
struct tms {
clock_t tms_utime; /* user time */
clock_t tms_stime; /* system time */"
clock_t tms_cutime; /* user time, children */
clock_t tms_cstime; /* system time, children */
};
This information comes from the calling process and each of its
terminated child processes for which it has executed a wait(),
wait3(), or waitpid(). The times are in units of 1/CLK_TCK seconds,
where CLK_TCK is processor dependent The value of CLK_TCK can be
queried using the sysconf() function (see sysconf(2)).
Your problem is with the preceding "read" call. Try to figure out where is
attempting to read from, is there a process handling the file/device and
to which process is all that kernel CPU time billed. Try with ps -el and
top. Also, try with "netstat -i" to see whether you're retransmitting on
the high speed interconnect.
Mladen Gogala
Oracle DBA
Phone:(203) 459-6855
Email:[EMAIL PROTECTED]
-Original Message-
Sent: Friday, July 11, 2003 12:05 PM
To: Multiple recipients of list ORACLE-L
Mladen, As mentioned earlier, I have lots of "times"
funtion calls, which (my guess) relate to (60-70%)"IPC
send completion sync" waits I got in statspack. Dont
mean to fill your inboxes, but, pasting few truss
lines:
26949: read(14, "01 O\0\006\0\0\0\0\011 i".., 2064)
= 335
26949: times(0xFFBED228)
= 225698576
26949: times(0xFFBED0D8)
= 225698576
26949: times(0xFFBED228)
= 225698576
26949: times(0xFFBED108)
= 225698576
26949: times(0xFFBED108)
= 225698576
26949: times(0xFFBED108)
= 225698577
26949: times(0xFFBED108)
= 225698577
26949: times(0xFFBECA08)
= 225698577
26949: times(0xFFBECA08)
= 225698577
26949: times(0xFFBECC88)
= 225698577
26949: times(0xFFBECC88)
= 225698577
26949: times(0xFFBED0D8)
= 225698577
Thanks,
Ravi.
--- "Gogala, Mladen" <[EMAIL PROTECTED]> wrote:
> Just for fun, have you tried using truss to find out
> which calls
> are being used? That might help you.
>
> Mladen Gogala
> Oracle DBA
> Phone:(203) 459-6855
> Email:[EMAIL PROTECTED]
>
>
> -Original Message-
> Sent: Thursday, July 10, 2003 8:14 PM
> To: Multiple recipients of list ORACLE-L
>
>
> Raj,
> Yes. Timed_statistics=true. But I see the 'times'
> even
> in single instance(non-rac)database but relatively
> called negligible number of times.
> -Ravi.
> --- "Jamadagni, Rajendra"
> <[EMAIL PROTECTED]> wrote:
> > You seem to have timed_statistics=TRUE right ?? in
> > RAC you will ALWAYS see
> > GCS pings ... basically as long as
> > cluster_database=true, even if only one
> > node is running, you will still see Oracle trying
> to
> > ping other instances.
> >
> > My guess is that's what is happening ... but I
> could
> > be very well wrong, I
> > have RAC experience, but never tried to truss the
> > top processes.
> >
> > Raj
> >
>
> >
> > Rajendra dot Jamadagni at nospamespn dot com
> > All Views expressed in this email are strictly
> > personal.
> > QOTD: Any clod can have facts, having an opinion
> is
> > an art !
> >
> >
> > -Original Message-
> > Sent: Thursday, July 10, 2003 12:30 PM
> > To: Multiple recipients of list ORACLE-L
> >
> >
> > Hello List,
> >
> > We are running Benchmark tests on Solaris 2-Node
> > RAC.
> > Consistently noticed the following :
> > - Very high Kernel usage (averaging 45%) on TOP
> > - Statspack has "IPC Send Completion sync" waits
> > (70%
> > Total ela time)
> > - On trussing top process, found Oracle to be
> > issuing
> > huge number of "times" system calls in addition to
> > read/writes(which I think are select/inserts).
> > Has anyone noticed th
RE: Copying database from vxfs to ufs
You have to move them to NTFS on SUN first. Mladen Gogala Oracle DBA Phone:(203) 459-6855 Email:[EMAIL PROTECTED] -Original Message- Sent: Thursday, July 10, 2003 9:04 PM To: Multiple recipients of list ORACLE-L Hi, I have a database (200GB+ 8.1.7.4 version) on Vxfs file systems on a Sun server ( Solaris 8), which I need to migrate to Ufs file systems mounted on same server. To cut the migration time, can I copy the database files from vxfs to ufs ie across the different filesystems type. Has anyone done it and noticed any problems. Is it supported ? Thanks in advance. Manmohan Get advanced SPAM filtering on Webmail or POP Mail ... Get Lycos Mail! http://login.mail.lycos.com/r/referral?aid=27005 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Anubha Jalsingh INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gogala, Mladen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: RAC system Calls
Just for fun, have you tried using truss to find out which calls are being used? That might help you. Mladen Gogala Oracle DBA Phone:(203) 459-6855 Email:[EMAIL PROTECTED] -Original Message- Sent: Thursday, July 10, 2003 8:14 PM To: Multiple recipients of list ORACLE-L Raj, Yes. Timed_statistics=true. But I see the 'times' even in single instance(non-rac)database but relatively called negligible number of times. -Ravi. --- "Jamadagni, Rajendra" <[EMAIL PROTECTED]> wrote: > You seem to have timed_statistics=TRUE right ?? in > RAC you will ALWAYS see > GCS pings ... basically as long as > cluster_database=true, even if only one > node is running, you will still see Oracle trying to > ping other instances. > > My guess is that's what is happening ... but I could > be very well wrong, I > have RAC experience, but never tried to truss the > top processes. > > Raj > > > Rajendra dot Jamadagni at nospamespn dot com > All Views expressed in this email are strictly > personal. > QOTD: Any clod can have facts, having an opinion is > an art ! > > > -Original Message- > Sent: Thursday, July 10, 2003 12:30 PM > To: Multiple recipients of list ORACLE-L > > > Hello List, > > We are running Benchmark tests on Solaris 2-Node > RAC. > Consistently noticed the following : > - Very high Kernel usage (averaging 45%) on TOP > - Statspack has "IPC Send Completion sync" waits > (70% > Total ela time) > - On trussing top process, found Oracle to be > issuing > huge number of "times" system calls in addition to > read/writes(which I think are select/inserts). > Has anyone noticed this in your environment. I am > guessing these to be inter-instance pings, but could > not get any hits in Doc/Metalink to confirm this. > "times" call is clocking lot of CPU. Is this normal > ? > Any pointers would be helpful ? If this is out of > context, is there a separate list for RAC? > > Thanks, > Ravi. > > > > __ > Do you Yahoo!? > SBC Yahoo! DSL - Now only $29.95 per month! > http://sbc.yahoo.com > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.net > -- > Author: Ravi Kulkarni > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 > http://www.fatcity.com > San Diego, California-- Mailing list and web > hosting services > - > To REMOVE yourself from this mailing list, send an > E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of > 'ListGuru') and in > the message BODY, include a line containing: UNSUB > ORACLE-L > (or the name of mailing list you want to be removed > from). You may > also send the HELP command for other information > (like subscribing). > > *This > e-mail message is confidential, intended only for > the named recipient(s) above and may contain > information that is privileged, attorney work > product or exempt from disclosure under applicable > law. If you have received this message in error, or > are not the named recipient(s), please immediately > notify corporate MIS at (860) 766-2000 and delete > this e-mail message from your computer, Thank > you.*1 > __ Do you Yahoo!? SBC Yahoo! DSL - Now only $29.95 per month! http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ravi Kulkarni INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gogala, Mladen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: any script to parse alert log ?!
If you have more databases, there are synonyms, views and db-links.
That is classic DBA patchwork. The funniest siutations arise when
you have a circle of synonyms and db-links pointing to each other,
just like perpetuum mobile. What is impossible in thermodynamics, is
possible in oracle. It doesn't meant that it works, but can be done,
much to the joy of us DBAs.
Mladen Gogala
Oracle DBA
Phone:(203) 459-6855
Email:[EMAIL PROTECTED]
-Original Message-
Sent: Thursday, July 10, 2003 5:59 PM
To: Multiple recipients of list ORACLE-L
> Here is a good one:
> create or replace directory bdump as
> '/oracle/admin/o9i/bdump' / grant read on directory bdump to
> public / create table alert_log_ext ( line varchar2(2000) )
> organization external ( type oracle_loader default directory
> bdump access parameters
>(
>records delimited by newline
>nobadfile nologfile nodiscardfile
>fields (line char(132)
>)
> )
> location('alert_o9i.log') )
> reject limit unlimited
> /
>
> You can now write a PL/SQL or Java procedure to parse
> alert_log_ext table if your heart so desires. There is only
> one problem: this doesn't work if you don't have 9iR2.
Or if the database isn't up.
I do like the idea though, could centralize all alert.logs and indeed
listener.logs etc in one db.
Niall
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Niall Litchfield
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Gogala, Mladen
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
RE: Multiple addreses in tns
Add FAILOVER=ON and it will check the next address if the previous one has failed. Alternatively, use SOURCE_ROUTE=ON and it will check every single one of them if the previous one fails. Mladen Gogala Oracle DBA Phone:(203) 459-6855 Email:[EMAIL PROTECTED] -Original Message- Sent: Thursday, July 10, 2003 10:19 AM To: Multiple recipients of list ORACLE-L Is having multiple addresses valid for a tns entry? A client provided this to me and initailly looked invalid alias = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 10.5.141.22)(PORT = 1521)) (ADDRESS = (PROTOCOL = TCP)(HOST = 10.5.141.22)(PORT = 1526)) (ADDRESS = (PROTOCOL = TCP)(HOST = 10.5.41.34)(PORT = 1521)) (ADDRESS = (PROTOCOL = TCP)(HOST = 10.5.41.34)(PORT = 1526)) (ADDRESS = (PROTOCOL = TCP)(HOST = 10.5.41.36)(PORT = 1521)) (ADDRESS = (PROTOCOL = TCP)(HOST = 10.5.41.36)(PORT = 1526)) ) (CONNECT_DATA = (SID = name)(SERVER = DEDICATED)) ) >From initial testing, if the first server is not avaliable the entire connect fails. Personally Ive never seen this and from checking my reference, this does NOT seem to be valid Any input would be most welcome Thanks! bob -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bob Metelsky INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gogala, Mladen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Tech meetings
Title: RE: Tech meetings A R&R jet engine in a car Cute idea! There is an urban legend about a military guy who tried to mount a JATO rocket on his Chevy Impala (nothing so fancy as R & R). It didn't end up very good for him. May be he should have tried with R & R jet engine. Mladen Gogala Oracle DBA Phone:(203) 459-6855 Email:[EMAIL PROTECTED] -Original Message-From: Jamadagni, Rajendra [mailto:[EMAIL PROTECTED]Sent: Wednesday, July 09, 2003 2:34 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Tech meetings Okay ... so you don't get a car ... do you at-least get an engine once in say 5 years ?? Same thing happens to me, I always get the question .. "Do you get tickets to all the games?" the answer is a big NO. We may get to see them on our internal cable network, but unless you are good spending ($$) advertiser tickets are unlikely .. or if you win them in a contest. Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! -Original Message- From: Eberhard, Jeff [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 09, 2003 2:15 PM To: Multiple recipients of list ORACLE-L Subject: RE: Tech meetings I wish. I always get that question. I work at a gear box manufacturing plant which primarily manufactures gear boxes for jet engines. Rolls-Royce plc doesn't even make the cars anymore. In "1998 Rolls-Royce Motor Cars was sold by Vickers to Volkswagen, although BMW hold the rights to the name and the marque for use on Rolls-Royce cars, having acquired the rights from Rolls-Royce plc for £40m in 1998. BMW will take over responsibility for Rolls-Royce cars from the beginning of 2003." http://www.rolls-royce.com/history/timeline/default.htm Jeff Eberhard Database Administrator Rolls-Royce Gear Systems Park City, Utah
RE: rman legato 32 vs 64 bit conflict.
What platform is that? If SUN, tell your SA to do the following: pkginfo|grep -i legato. As far as I know, commands pkgadd, pkgrm and alike could be used to force the installation. Mladen Gogala Oracle DBA Phone:(203) 459-6855 Email:[EMAIL PROTECTED] -Original Message- Sent: Monday, July 07, 2003 5:34 PM To: Multiple recipients of list ORACLE-L Anyone there in oracle land running both 32 bit and 64 bit oracle and using rman w/legato. I assume i need 64 bit libs for 64 bit oracle and 32 bit libs for 32 bit oracle of the legato software?, the unix admin says legato wont install the 64 bit since it says its already installed. Any ideas would be appreciated. thanks, joe -- Joseph S Testa Chief Technology Officer Data Management Consulting p: 614-791-9000 f: 614-791-9001 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Joe Testa INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gogala, Mladen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle DBA 9i Books ever needed.
I have only one question: in the Hogwarts school of Oracle Wizardry Cary Dumbledore is probably the headmaster, but who will have the role of Lord Voldemort? Are developers to be considered muggles? Mladen Gogala Oracle DBA Phone:(203) 459-6855 Email:[EMAIL PROTECTED] -Original Message- Sent: Thursday, July 03, 2003 10:31 AM To: Multiple recipients of list ORACLE-L AHA! Thanks Hermione :) okay, now Jared will perform the crucias (sp? I don't have the book with me, I finished it and it's home) curse on me if I don't stop here and take this to the OT list. --- Nuno Souto <[EMAIL PROTECTED]> wrote: > - Original Message - > > > you mean we don't tune Oracle using spells, incantations and > prayers? > > > > Dang, I knew I was doing something wrong! > > > > > It's leviosa, not lehviosah... > ;) > Cheers > Nuno Souto > [EMAIL PROTECTED] > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Nuno Souto > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > __ Do you Yahoo!? SBC Yahoo! DSL - Now only $29.95 per month! http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gogala, Mladen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: LISTENER ON LINUX
What is the port? How did you check that it wasn't used? Which distro, which version of the database? Mladen Gogala Oracle DBA Phone:(203) 459-6855 Email:[EMAIL PROTECTED] -Original Message- Sent: Wednesday, July 02, 2003 2:36 PM To: Multiple recipients of list ORACLE-L Hi, When I am trying to start listener on Linux box ,getting error TNS-12542: TNS:address already in use TNS-12560: TNS:protocol adapter error TNS-00512: Address already in use Linux Error: 98: Address already in use I checked no process fro listener and no port used by another process. Let me know how to fix that pl thx -Seema _ Help STOP SPAM with the new MSN 8 and get 2 months FREE* http://join.msn.com/?page=features/junkmail -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Seema Singh INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gogala, Mladen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Should percent increase higher than 0 in 817?
I acutally work with oracle ever since the version 4.1 (IBM PC/XT, 512KB RAM) but a) I've never worked with 4.0 b) I know very well what PCTINCREASE is. Conclusion: Tanel, it wasn't me! I swear! Mladen Gogala Oracle DBA Phone:(203) 459-6855 Email:[EMAIL PROTECTED] -Original Message- Sent: Tuesday, July 01, 2003 7:14 PM To: Multiple recipients of list ORACLE-L I saw a "Sr. DBA" few years ago, who claimed he had worked with Oracle since V4.0, and he didn't have a clue what PCTINCREASE is... Tanel. - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Tuesday, July 01, 2003 11:51 PM > What about ones that you don't know? > > Mladen Gogala > Oracle DBA > Phone:(203) 459-6855 > Email:[EMAIL PROTECTED] > > > -Original Message- > Sent: Tuesday, July 01, 2003 4:11 PM > To: Multiple recipients of list ORACLE-L > > > PCTINCREASE is a bad good thing. Every DBA that I know of hunts down > objects with a pctincrease other than 0 and resets them. > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Gogala, Mladen > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tanel Poder INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gogala, Mladen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Should percent increase higher than 0 in 817?
What about ones that you don't know? Mladen Gogala Oracle DBA Phone:(203) 459-6855 Email:[EMAIL PROTECTED] -Original Message- Sent: Tuesday, July 01, 2003 4:11 PM To: Multiple recipients of list ORACLE-L PCTINCREASE is a bad good thing. Every DBA that I know of hunts down objects with a pctincrease other than 0 and resets them. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gogala, Mladen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Microsoft VS Oracle (again)
The most useful thing that Microsoft has ever been selling is Microsoft Xenix. Mladen Gogala Oracle DBA Phone:(203) 459-6855 Email:[EMAIL PROTECTED] -Original Message- Sent: Tuesday, July 01, 2003 4:11 PM To: Multiple recipients of list ORACLE-L Now, now, Microsoft has made some very useful desktop caliber applications, including SQL Server. >>> [EMAIL PROTECTED] 07/01/03 02:30PM >>> SQL server on Unix lets see.That would be none. SQL Server doesn't even run on Windows much less any other platform... Bwahahahahahaha... sorry...I got carried away... -Original Message- Sent: Tuesday, July 01, 2003 2:00 PM To: Multiple recipients of list ORACLE-L On which unix boxes does SQL Server work? I don't want to replace all of my AIX, HP-UX and Solaris boxes with NT. I'll consider SQL Server as a replacement as soon as it starts operating on Unix. Microsoft operating systems have spurned the whole industry trying to protect them from viruses, which makes them completely unsuitable for a central database of a Fortune 500 company. Does SQL Server work on Linux? Mladen Gogala Oracle DBA Phone:(203) 459-6855 Email:[EMAIL PROTECTED] -Original Message- Sent: Tuesday, July 01, 2003 1:00 PM To: Multiple recipients of list ORACLE-L FYI One of my friends at Microsoft, (yes I must to confess, I have friends at MS) gave me a "present", it's a 4 cd's kit called "SQL Server 2000 for the Oracle Customer", the kit consist in 4 cd's with demos, docs, presentations, videos and a lot of stuff showing why sql server is a better option as a DB instead oracle, contains price lists, performance evaluation and many other "information", maybe you'd like to spend some of your time giving Billy a chance to defend his product. The 4 cd's are available (almost completely) as links in: http://www.microsoft.com/sql/oraclekit Any comments? Gabriel = "Any dream worth having is a dream worth fighting for"(Cualquier sueño que valga la pena tener, es un sueño por el que vale la pena luchar)Charles Xavier __ Do you Yahoo!? SBC Yahoo! DSL - Now only $29.95 per month! http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gabriel Aragon INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gogala, Mladen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Odland, Brad INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Darrell Landrum INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.oraf
RE: Microsoft VS Oracle (again)
On which unix boxes does SQL Server work? I don't want to replace all of my AIX, HP-UX and Solaris boxes with NT. I'll consider SQL Server as a replacement as soon as it starts operating on Unix. Microsoft operating systems have spurned the whole industry trying to protect them from viruses, which makes them completely unsuitable for a central database of a Fortune 500 company. Does SQL Server work on Linux? Mladen Gogala Oracle DBA Phone:(203) 459-6855 Email:[EMAIL PROTECTED] -Original Message- Sent: Tuesday, July 01, 2003 1:00 PM To: Multiple recipients of list ORACLE-L FYI One of my friends at Microsoft, (yes I must to confess, I have friends at MS) gave me a "present", it's a 4 cd's kit called "SQL Server 2000 for the Oracle Customer", the kit consist in 4 cd's with demos, docs, presentations, videos and a lot of stuff showing why sql server is a better option as a DB instead oracle, contains price lists, performance evaluation and many other "information", maybe you'd like to spend some of your time giving Billy a chance to defend his product. The 4 cd's are available (almost completely) as links in: http://www.microsoft.com/sql/oraclekit Any comments? Gabriel = "Any dream worth having is a dream worth fighting for"(Cualquier sueño que valga la pena tener, es un sueño por el que vale la pena luchar)Charles Xavier __ Do you Yahoo!? SBC Yahoo! DSL - Now only $29.95 per month! http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gabriel Aragon INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gogala, Mladen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Performance
Hey, we can kill Martians by singing. Have you ever seen "Mars Attacks"? Mladen Gogala Oracle DBA Phone:(203) 459-6855 Email:[EMAIL PROTECTED] -Original Message- Sent: Tuesday, July 01, 2003 11:09 AM To: Multiple recipients of list ORACLE-L Now you have made them really mad. Now you will be forced to listen to their singing *AND* their accordion players! > -Original Message- > "All right already! I'll trash all my RAID-5 storage and > replace it with > RAID10!!! For the love of mercy, just PLEASE STOP SINGING!!!" -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gogala, Mladen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle "unlimited concurrent" license
Yes, in versions 5 and 6. Tell them that the money is needed for the "transaction processing option" (TPO). Mladen Gogala Oracle DBA Phone:(203) 459-6855 Email:[EMAIL PROTECTED] -Original Message- Sent: Monday, June 30, 2003 5:10 PM To: Multiple recipients of list ORACLE-L My management is claiming that we have an "unlimited concurrent users" license on one of our AIX machines and that we do not need to upgrade the license when we increase the number of processors. The Oracle web site section on licensing lists only two types of licenses for Enterprise Edition, Named users and Processor Based. Has anyone heard of this other type? Thanks, Peter Schauss -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Schauss, Peter INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gogala, Mladen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Online tech books
My guess is that some of those books are just a fuel reserve, when the weather gets really cold. Given the oil and gas prices today, it does make sense, you know. Bears accumulate fat for winter, while DBAs accumulate books. On the other hands, our cycle is not related to the weather but rather to the versions of oracle. You'll see chimneys start spewing some smoke when Oracle 10(i?) comes out. Mladen Gogala Oracle DBA Phone:(203) 459-6855 Email:[EMAIL PROTECTED] -Original Message- Sent: Monday, June 30, 2003 11:50 AM To: Multiple recipients of list ORACLE-L Have you really read all books you have in your bookcase??? JP On Monday 30 of June 2003 16:39, you wrote: > All.. > > I just returned frm vacation, but I wanted to respond to Jonathan > Gennick regarding my collection of books.( I managed to delete that > message) But, Ive taken some pictures of my collection.. Ive actually > purchaced all the books you see! > http://162.42.213.232/books/index.html > > > I would just like all to know that my initial recommendation to view > free books online was not an offer to circumvent actually purchacing the > books. Personally I prefer to actually have a hard copy in my hand for a > reference, on the other hand I though the online books may be handy and > hopefully spur individuals to purchace books they otherwise may not be > aware of, and possibly maybe for a struggling fellow who doesnt have a > dime but has an interest to learn may pick up something worthwhile > > Ahhh back to work > > Best to all > bob > > > And, more than likely, highly illegal. I was assume the > > authors on list list will be contacting their respective publishers? > > > > Rich > > > > Rich Jesse System/Database Administrator > > [EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA > > > > > -Original Message- > > > From: Bob Metelsky [mailto:[EMAIL PROTECTED] > > > Sent: Wednesday, June 18, 2003 11:04 AM > > > To: Multiple recipients of list ORACLE-L > > > Subject: Online tech books > > > > > > > > > This was just passed on to me and I'd like to share it wit > > > > the list... > > > > > http://www.palaydium.net/tech/ > > > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.net > > -- > > Author: Jesse, Rich > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > > San Diego, California-- Mailing list and web hosting services > > - > > To REMOVE yourself from this mailing list, send an E-Mail message > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') > > and in the message BODY, include a line containing: UNSUB > > ORACLE-L (or the name of mailing list you want to be removed > > from). You may also send the HELP command for other > > information (like subscribing). > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Pruner Jan [EMAIL PROTECTED] http://jan.pruner.cz/ - On a quiet Night, you can hear the Windows machines reboot. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jan Pruner INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gogala, Mladen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: printing out of Pl/SQL
So, summa technologiae can be reduced to the simple advice: "avoid NT if possible"? Mladen Gogala Oracle DBA Phone:(203) 459-6855 Email:[EMAIL PROTECTED] -Original Message- Sent: Monday, June 30, 2003 11:05 AM To: Multiple recipients of list ORACLE-L Hi SPOOL OUT will only write the SQL*plus output to the default printer on UNIX it is not implemented in SQL*plus for NT. You cannot do what you are trying to do below. UTL_FILE can only read and write clear text files. I am not an expert on windows internals but lpt1 is a device / port so should be some sort of device driver so i guess it has a different file type. UTL_FILE probably does a check internally to test if the file being opened is a text file. your best bet is to use C to write an external procedure to do it, or perhaps pipe the output from a text file to the printer externally. i.e use utl_file to write to a file and have a batch job that runs every few minutes and spools the file to the printer? hth kind regards Pete -- Pete Finnigan email:[EMAIL PROTECTED] Web site: http://www.petefinnigan.com - Oracle security audit specialists Book:Oracle security step-by-step Guide - see http://store.sans.org for details. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Pete Finnigan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gogala, Mladen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Question On Statistics Gathering
1) Oracle is bug free. If not bug free, it is, at least, unbreakable. That means that nothing wrong will happen to you as long as you don't have users or data. They are the problem. 2) Direct load doesn't generate statistics, even if monitoring attribute is set. Direct load is built for speed, like Ferrari, not for comfort, like a Cadillac. 3) Monitoring tables is relatively painless, but it is still advisable to analyze the tables with cron jobs over night. Look at the block sampling feature of dbms_stats. Mladen Gogala Oracle DBA Phone:(203) 459-6855 Email:[EMAIL PROTECTED] -Original Message- Sent: Friday, June 27, 2003 4:34 PM To: Multiple recipients of list ORACLE-L Hi All, Currently we have a very large database ( 8.1.7.4 ) on Tru64 that is having query optimization problems. Lacking good, up-to-date statistics is the main cause of it. Because of the size and availability window we can't afford to analyze the whole schema. Now 8i has a new feature that only gathers stats when stale. You have to set table to monitoring mode first. I am intrigued by this new feature and am reading up on it and have 2 questions: 1. How reliable and bug-free is this feature? 2. We do a lot of sqlldr direct path, which bypasses table insert. Will this feature catch the rows inserted that way? TIA Dennis -Original Message- Sent: Friday, June 27, 2003 2:30 PM To: Multiple recipients of list ORACLE-L One of our third party applications gave us the following message: ORA-04031: unable to allocate 4192 bytes of shared memory Environment is Oracle 8.1.7 on AIX 4.3.2 The output from "select * from v$sgastat showed about 3 mb free out of a total of 40 mb of shared pool. I increased the size of shared pool to 60 mb and started to watch the "shared pool"/"free memory" value in v$sgastat. It seems to vary between about 3 and 11 mb. 1. What is the application likely to be doing that requires it to allocate shared pool? 2. How do I know when I have the shared pool value in init.ora set high enough so that I won't get the ORA-04031 errors? 3. Is there any other init.ora parameter I ought to be looking at here? Thanks, Peter Schauss -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Schauss, Peter INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Meng, Dennis INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gogala, Mladen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Performance
SUM (DECODE(T.TSA_TIPO, 'C', NVL(T.TSA_VALOR,0))) into vDebito, vCredito FROM TCON_TRANSA T, TCON_DESTRAN D WHERE T.TSA_SUCURSAL = I AND T.TSA_CUENTA = pCuentaAND D.DST_NUMTRAN = T.TSA_NUMTRAN AND D.DST_SUCURSAL = T.TSA_SUCURSAL AND D.DST_FECHA BETWEEN vFechaIni and pFecha AND D.DST_CUADRA = 'S' ; exception when no_data_found then vDebito := 0; vCredito := 0; when others then null; end; vSaldo :=nvl (vSaldo,0) + (nvl(vSaldoAnt,0) + nvl(vDebito,0) - nvl(vCredito,0)) ; end loop; return vSaldo ; end; / Ramon E. Estevez [EMAIL PROTECTED] 809-535-8994 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ramon E. Estevez INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gogala, Mladen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: printing out of Pl/SQL
Title: RE: printing out of Pl/SQL Nope. The "spool out" command goes directly to the default printer, while "spool off" only stops spooling. Mladen Gogala Oracle DBA Phone:(203) 459-6855 Email:[EMAIL PROTECTED] -Original Message-From: Igor Neyman [mailto:[EMAIL PROTECTED]Sent: Friday, June 27, 2003 5:30 PMTo: Multiple recipients of list ORACLE-LSubject: RE: printing out of Pl/SQL Isn’t it: “spool off”? Igor Neyman, OCP DBA [EMAIL PROTECTED] -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jamadagni, RajendraSent: Friday, June 27, 2003 4:15 PMTo: Multiple recipients of list ORACLE-LSubject: RE: printing out of Pl/SQL oops ... it should be "spool out" Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! -Original Message-From: Jamadagni, Rajendra Sent: Friday, June 27, 2003 4:55 PMTo: Multiple recipients of list ORACLE-LSubject: RE: printing out of Pl/SQL Are you using sqlplus? spool on ... do some work spoo out will that work for you? Just a guess ... it might Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! -Original Message- From: Foelz.Frank [mailto:[EMAIL PROTECTED]] Sent: Friday, June 27, 2003 11:40 AM To: Multiple recipients of list ORACLE-L Subject: AW: printing out of Pl/SQL sounds like some Unix/Linux I am on NT / Oracle 8.0.6 > Frank < >-Ursprüngliche Nachricht- >Von: Gogala, Mladen [mailto:[EMAIL PROTECTED]] >Gesendet am: Freitag, 27. Juni 2003 16:14 >An: Multiple recipients of list ORACLE-L >Betreff: RE: printing out of Pl/SQL > >dd if= of=/dev/lpt1 > >Mladen Gogala >Oracle DBA >Phone:(203) 459-6855 >Email:[EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Foelz.Frank INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: printing out of Pl/SQL
Dick, it used to be so before 9.2. In 9.2 you have a parameter "location"
to utl_file.fopen, which is specified by using the "create directory"
command. I didn't see a version in his post so I assumed he's talking
about 9.2.
Mladen Gogala
Oracle DBA
Phone:(203) 459-6855
Email:[EMAIL PROTECTED]
-Original Message-
Sent: Friday, June 27, 2003 2:15 PM
To: Multiple recipients of list ORACLE-L
Unless I'm totally mistaken '/dev' also has to be in the UTL_FILE_DIR init
parameter.
Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA
-Original Message-
Sent: Friday, June 27, 2003 12:45 PM
To: Multiple recipients of list ORACLE-L
Interesting...
I should try it sometime.
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
-Original Message-
Gogala, Mladen
Sent: Friday, June 27, 2003 10:40 AM
To: Multiple recipients of list ORACLE-L
Oh, I missed the "PL/SQL" part. Here it is:
create or replace directory dev as '/dev';
grant read on dev to public;
fp:=utl_file.fopen('dev','lpt0','w',255);
I've never tried it personally, but this should work.
Mladen Gogala
Oracle DBA
Phone:(203) 459-6855
Email:[EMAIL PROTECTED]
-Original Message-
Sent: Friday, June 27, 2003 11:15 AM
To: Multiple recipients of list ORACLE-L
The question was, how to do it from PL/SQL.
I think, the only way is using external stored procedure.
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
-Original Message-
Gogala, Mladen
Sent: Friday, June 27, 2003 9:14 AM
To: Multiple recipients of list ORACLE-L
dd if= of=/dev/lpt1
Mladen Gogala
Oracle DBA
Phone:(203) 459-6855
Email:[EMAIL PROTECTED]
-Original Message-
Sent: Friday, June 27, 2003 8:30 AM
To: Multiple recipients of list ORACLE-L
Hi gurus,
anyone knows of a possibility to directly send data to :LPT1 ?
I am in the need of printing online when something definite happens to
the
DB...
TNX
> Frank <
Confidentiality Notes
This email and any files transmitted is intended only for the person or
entity to which it is addressed and may contain confidential and/or
privileged material. If you are not the authorised recipient, any use,
disclosure, copying, distribution or any action taken or omitted to be
taken
in reliance on it, is prohibited. If you received this in error, please
contact the sender and delete the material from any computer.
E-mail messages are not necessarily secure. Scheidt & Bachmann does not
accept responsibility for any changes made to this message after it was
sent.
Thank you for your cooperation!
Diese E-Mail und alle angehängten Dateien ist ausschließlich für die
Person
/ Personen bestimmt, an die diese adressiert ist und könnte vertrauliche
und
/ oder rechtlich geschützte Informationen enthalten. Sollten Sie nicht
der
für diese E-Mail bestimmte Adressat oder nicht zum Empfang berechtigt
sein,
ist Ihnen jeder Gebrauch, sowie jede Veröffentlichung, Vervielfältigung
oder
Weitergabe wie auch das Ergreifen oder Unterlassen von Maßnahmen im
Vertrauen auf erlangte Information untersagt. Sollten Sie diese E-Mail
irrtümlich erhalten haben, benachrichtigen Sie bitte den Absender und
löschen diese E-Mail von jedem Computer.
E-Mail-Mitteilungen sind nicht notwendigerweise sicher. Scheidt &
Bachmann
übernimmt keine Verantwortung für Veränderungen dieser Mitteilung, die
nach
dem Senden vorgenommen wurden.
Herzlichen Dank für Ihre Unterstützung!
-
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Foelz.Frank
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Gogala, Mladen
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information
RE: printing out of Pl/SQL
Oh, I missed the "PL/SQL" part. Here it is:
create or replace directory dev as '/dev';
grant read on dev to public;
fp:=utl_file.fopen('dev','lpt0','w',255);
I've never tried it personally, but this should work.
Mladen Gogala
Oracle DBA
Phone:(203) 459-6855
Email:[EMAIL PROTECTED]
-Original Message-
Sent: Friday, June 27, 2003 11:15 AM
To: Multiple recipients of list ORACLE-L
The question was, how to do it from PL/SQL.
I think, the only way is using external stored procedure.
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
-Original Message-
Gogala, Mladen
Sent: Friday, June 27, 2003 9:14 AM
To: Multiple recipients of list ORACLE-L
dd if= of=/dev/lpt1
Mladen Gogala
Oracle DBA
Phone:(203) 459-6855
Email:[EMAIL PROTECTED]
-Original Message-
Sent: Friday, June 27, 2003 8:30 AM
To: Multiple recipients of list ORACLE-L
Hi gurus,
anyone knows of a possibility to directly send data to :LPT1 ?
I am in the need of printing online when something definite happens to
the
DB...
TNX
> Frank <
Confidentiality Notes
This email and any files transmitted is intended only for the person or
entity to which it is addressed and may contain confidential and/or
privileged material. If you are not the authorised recipient, any use,
disclosure, copying, distribution or any action taken or omitted to be
taken
in reliance on it, is prohibited. If you received this in error, please
contact the sender and delete the material from any computer.
E-mail messages are not necessarily secure. Scheidt & Bachmann does not
accept responsibility for any changes made to this message after it was
sent.
Thank you for your cooperation!
Diese E-Mail und alle angehängten Dateien ist ausschließlich für die
Person
/ Personen bestimmt, an die diese adressiert ist und könnte vertrauliche
und
/ oder rechtlich geschützte Informationen enthalten. Sollten Sie nicht
der
für diese E-Mail bestimmte Adressat oder nicht zum Empfang berechtigt
sein,
ist Ihnen jeder Gebrauch, sowie jede Veröffentlichung, Vervielfältigung
oder
Weitergabe wie auch das Ergreifen oder Unterlassen von Maßnahmen im
Vertrauen auf erlangte Information untersagt. Sollten Sie diese E-Mail
irrtümlich erhalten haben, benachrichtigen Sie bitte den Absender und
löschen diese E-Mail von jedem Computer.
E-Mail-Mitteilungen sind nicht notwendigerweise sicher. Scheidt &
Bachmann
übernimmt keine Verantwortung für Veränderungen dieser Mitteilung, die
nach
dem Senden vorgenommen wurden.
Herzlichen Dank für Ihre Unterstützung!
-
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Foelz.Frank
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Gogala, Mladen
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Igor Neyman
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Gogala, Mladen
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-53
RE: printing out of Pl/SQL
dd if= of=/dev/lpt1 Mladen Gogala Oracle DBA Phone:(203) 459-6855 Email:[EMAIL PROTECTED] -Original Message- Sent: Friday, June 27, 2003 8:30 AM To: Multiple recipients of list ORACLE-L Hi gurus, anyone knows of a possibility to directly send data to :LPT1 ? I am in the need of printing online when something definite happens to the DB... TNX > Frank < Confidentiality Notes This email and any files transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. If you are not the authorised recipient, any use, disclosure, copying, distribution or any action taken or omitted to be taken in reliance on it, is prohibited. If you received this in error, please contact the sender and delete the material from any computer. E-mail messages are not necessarily secure. Scheidt & Bachmann does not accept responsibility for any changes made to this message after it was sent. Thank you for your cooperation! Diese E-Mail und alle angehängten Dateien ist ausschließlich für die Person / Personen bestimmt, an die diese adressiert ist und könnte vertrauliche und / oder rechtlich geschützte Informationen enthalten. Sollten Sie nicht der für diese E-Mail bestimmte Adressat oder nicht zum Empfang berechtigt sein, ist Ihnen jeder Gebrauch, sowie jede Veröffentlichung, Vervielfältigung oder Weitergabe wie auch das Ergreifen oder Unterlassen von Maßnahmen im Vertrauen auf erlangte Information untersagt. Sollten Sie diese E-Mail irrtümlich erhalten haben, benachrichtigen Sie bitte den Absender und löschen diese E-Mail von jedem Computer. E-Mail-Mitteilungen sind nicht notwendigerweise sicher. Scheidt & Bachmann übernimmt keine Verantwortung für Veränderungen dieser Mitteilung, die nach dem Senden vorgenommen wurden. Herzlichen Dank für Ihre Unterstützung! - -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Foelz.Frank INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gogala, Mladen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Register vs. Load of JDBC driver
Approximately 10 times slower. Mladen Gogala Oracle DBA Phone:(203) 459-6855 Email:[EMAIL PROTECTED] -Original Message- Sent: Thursday, June 26, 2003 5:15 PM To: Multiple recipients of list ORACLE-L What sort of differences? Is the DriverManager method slower than Class.forName()? -Original Message- Sent: Thursday, June 26, 2003 3:35 PM To: Multiple recipients of list ORACLE-L Hi List! I'm not a Java programer so please, forgive me my (blissful) ignorance. My developers are experiencing wild differences when connecting using driverManager.registerDriver vs. Class.forName (dynamic loading). Does anybody have any clue why is that? Any articles about registering vs. loading? Thanks! Mladen Gogala Oracle DBA Phone:(203) 459-6855 Email:[EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gogala, Mladen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Richard Ji INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gogala, Mladen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: redo log maintenance
Title: redo log maintenance Doco is plain wrong. I've been adding, dropping and switching logfiles ever since the version 6 and I have never needed to shut down the database for it. Mladen Gogala Oracle DBA Phone:(203) 459-6855 Email:[EMAIL PROTECTED] -Original Message-From: Koivu, Lisa [mailto:[EMAIL PROTECTED]Sent: Thursday, June 26, 2003 5:00 PMTo: Multiple recipients of list ORACLE-LSubject: redo log maintenance I'm reading through the 9.2 admin guide (yawn) and it says that the database must be mounted but not open to add, drop or rename redo logs. I have done this many times with the database up and running, with no problems. Why would it say this in the doco, or is the doco just plain wrong (again)? It doesn't let you do anything to redo logs that aren't archived or are currently being used, what's the harm? I don't get all the emails from the list - in fact I get none most of the time. So please be sure to include my personal email address when responding. Thanks Lisa Koivu Oracle Database Monkey Fairfield Resorts, Inc. Orlando Office: 407-248-4277 Ft. Lauderdale Office: 954-935-4117 Fax: 954-935-3639 Cell: 954-683-4459 "The sender believes that this E-Mail and any attachments were free of any virus, worm, Trojan horse, and/or malicious code when sent. This message and its attachments could have been infected during transmission. By reading the message and opening any attachments, the recipient accepts full responsibility for taking proactive and remedial action about viruses and other defects. The sender's business entity is not liable for any loss or damage arising in any way from this message or its attachments."-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Koivu, Lisa INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Register vs. Load of JDBC driver
Hi List! I'm not a Java programer so please, forgive me my (blissful) ignorance. My developers are experiencing wild differences when connecting using driverManager.registerDriver vs. Class.forName (dynamic loading). Does anybody have any clue why is that? Any articles about registering vs. loading? Thanks! Mladen Gogala Oracle DBA Phone:(203) 459-6855 Email:[EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gogala, Mladen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: CURSOR_SPACE_FOR_TIME
Do you have the bug number? Mladen Gogala Oracle DBA Phone:(203) 459-6855 Email:[EMAIL PROTECTED] -Original Message- Sent: Thursday, June 26, 2003 11:55 AM To: Multiple recipients of list ORACLE-L We are ran into a bug the other day where oracle dumps core with a ORA-07445 error. We tracked it down to a Context related bug where PL/SQL callout during heavy shared pool load cause the ora-07745 core dump. The suggested workarounds are to set CURSOR_SPACE_FOR_TIME to true. This is in 8.1.7.4.0 and is reportedly fixed in 9i. What are listers experience with this parameter? On our system it sound like setting this without altering the size of the shared pool would be potentially dangerous and could cause more problems that leaving it alone. This error is not a critical one to business functions and users here. (so far) Thanks Brad Odland -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Odland, Brad INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gogala, Mladen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: how to find folder size in unix
Hey Joe! Long time no see! Welcome back! Mladen Gogala Oracle DBA Phone:(203) 459-6855 Email:[EMAIL PROTECTED] -Original Message- Sent: Thursday, June 26, 2003 10:50 AM To: Multiple recipients of list ORACLE-L versus the magic number which in no way is reflected in size. Gogala, Mladen wrote: >Didn't they tell you that the size doesn't matter, it's the magic in the >folder? > >Mladen Gogala >Oracle DBA >Phone:(203) 459-6855 >Email:[EMAIL PROTECTED] > > >-Original Message- >[mailto:[EMAIL PROTECTED] >Sent: Thursday, June 26, 2003 7:00 AM >To: Multiple recipients of list ORACLE-L > > >how to find folder size in unix > > -- Joseph S Testa Chief Technology Officer Data Management Consulting p: 614-791-9000 f: 614-791-9001 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Joe Testa INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gogala, Mladen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: 9i OCP Details
You are talking about Scott Gossett jr. I took that internals course and it was good. It was very, very good. Mladen Gogala Oracle DBA Phone:(203) 459-6855 Email:[EMAIL PROTECTED] -Original Message- Sent: Thursday, June 26, 2003 10:25 AM To: Multiple recipients of list ORACLE-L Gudmundur Bjarni Josepsson wrote: >>If you want real advanced courses go with [...] what Jonathan Lewis >>or guys at his level provide. >> >> > >I have to agree on this. I've had the good fortune to sit in on Lewis's >'Optimising Oracle' and Cary Millsap's 'Hotsos Clinic 101' and no course >I ever took from Oracle Education comes close to what these guys offer >(and I've taken quite a few). > > > The only course from Oracle Education that's come close for me is the internals course that I took about 3 or 4 years ago. I haven't seen it offered recently. The instructor was Scott somebody, who was, I was told, THE Scott or Scott/Tiger fame. I second the recommendation for Jonathan Lewis; his Cost-Based Optimization course was well taught and I found it very useful. Craig Shallahamer (www.orapub.com) also offers some worthwhile courses and is a very good instructor. I'll find out about the Hotsos Clinic this August in Denver. Looking forward to it. Glenn Stauffer -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Glenn Stauffer INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gogala, Mladen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: how to find folder size in unix
Didn't they tell you that the size doesn't matter, it's the magic in the folder? Mladen Gogala Oracle DBA Phone:(203) 459-6855 Email:[EMAIL PROTECTED] -Original Message- [mailto:[EMAIL PROTECTED] Sent: Thursday, June 26, 2003 7:00 AM To: Multiple recipients of list ORACLE-L how to find folder size in unix -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: <[EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gogala, Mladen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle 9.2 RAC on Win2K?
On the PULSE side, we are running 8i but on the DW side, we're running 9.2. >From my experience, 9.2 doesn't need that much of an application partitioning as 8i. I mentioned "PULSE" because you also worked for Oxford as a consultant so you know what application system I'm talking about. Mladen Gogala Oracle DBA Phone:(203) 459-6855 Email:[EMAIL PROTECTED] -Original Message- Sent: Wednesday, June 25, 2003 12:45 PM To: Multiple recipients of list ORACLE-L At Oxford you are running Oracle8i, correct? Do you believe that application partitioning is as important with 9i and cache fusion as it is in 8i? --- Mladen Gogala <[EMAIL PROTECTED]> wrote: > > > Has anyone seen/run/stumbled over similar beast, if so - does it > "fly" > > or it "stinks"? > > Depends on the application system. RAC is a bit more tolerant, but > you still > want to minimize the block exchange between the nodes. Application > system must > be "functionally partitioned", meaning that related data should be > accessed > from the same node. Example: let's imagine that we have health care > application system which has elements like members/groups/providers, > claims > and drug utilization/ 3rd party vendors. Each of the listed groups is > a > complex application system accessing several hundreds of related > tables. Good > thing would be to put each of the listed application groups on its > own node > with the 4th node reserved for batch processing. If block exchange is > frequent > and DLM has a lot of work to do, then "flying" means "free falling > until you > hit the ground". > > P.S. > > > > I've looked at number of metalink articles and found none yet to > > "scratch" this specific "itch" of mine. > > > > Oracle RAC on Win2K is for some bizarre reason REQUIREMENT. > > Requirement by who? It usually helps to make a business case for a > specific > configuration and benchmark it to see whether the performance is > satisfactory. > Let me suggest a little benchmark: 4 clustered, beefed up PC boxes > vs. a > single, 16-CPU IBM P690 with the latest "960" CPUs and AIX 5.2. You > can > benchmark price and performance. I'd be very intrigued to find out > the > outcome. It is very hard to predict it properly (wink, wink). > > > > > > > > > -- > Mladen Gogala > Oracle DBA > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Mladen Gogala > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). = Paul Baumgartel, Adept Computer Associates, Inc. [EMAIL PROTECTED] __ Do you Yahoo!? SBC Yahoo! DSL - Now only $29.95 per month! http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Paul Baumgartel INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gogala, Mladen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Help Needed regarding partitioning
You first create an empty partitioned table with the same structure as the original table and then use "exchange partition" to exchange partitions with the original table. That way, your original table will end up having a single (empy) partition and the new table will have a full partiton. Now, split the partitions in the new table, rename the old one, rebuild the indexes, recreate grants and presto, you're ready to go. Mladen Gogala Oracle DBA Phone:(203) 459-6855 Email:[EMAIL PROTECTED] -Original Message-From: Munish Bajaj [mailto:[EMAIL PROTECTED]Sent: Wednesday, June 25, 2003 5:54 AMTo: Multiple recipients of list ORACLE-LSubject: Help Needed regarding partitioning Hi Listers, Please let me know whether I can convert an existing heavy table into a partitioned table and how? I need this to improve my query performance. Thanks and Best Regards Munish Bajaj
RE: Help Needed regarding partitioning
That is the greatest RTFM answer that I've ever seen! Mladen Gogala Oracle DBA Phone:(203) 459-6855 Email:[EMAIL PROTECTED] -Original Message- Sent: Wednesday, June 25, 2003 9:33 AM To: Multiple recipients of list ORACLE-L Read about exchanging partitions in chapter 17 and especially "Converting a Partition View into a Partitioned Table ": http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96521/toc.htm Even though you may not be using a partitioned view, you can use this technique to create the partitioned table. Jay Hostetter Oracle DBA D. & E. Communications Ephrata, PA USA >>> [EMAIL PROTECTED] 06/25/03 05:54AM >>> Hi Listers, Please let me know whether I can convert an existing heavy table into a partitioned table and how? I need this to improve my query performance. Thanks and Best Regards Munish Bajaj **DISCLAIMER This e-mail message and any files transmitted with it are intended for the use of the individual or entity to which they are addressed and may contain information that is privileged, proprietary and confidential. If you are not the intended recipient, you may not use, copy or disclose to anyone the message or any information contained in the message. If you have received this communication in error, please notify the sender and delete this e-mail message. The contents do not represent the opinion of D&E except to the extent that it relates to their official business. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jay Hostetter INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gogala, Mladen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Siemens ReliantUNIX
Try at http://www.despair.com or http://www.landoverbaptist.org Chances are better then on this list. Mladen Gogala Oracle DBA Phone:(203) 459-6855 Email:[EMAIL PROTECTED] -Original Message- [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 25, 2003 5:20 AM To: Multiple recipients of list ORACLE-L Where can I download this Opeerating Systems Patches -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: <[EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gogala, Mladen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: LOCALLY MANAGED TABLESPACE
What is the group view on your going with the locally managed tablespaces? Well, go ahead, make my data! Mladen Gogala Oracle DBA Phone:(203) 459-6855 Email:[EMAIL PROTECTED] -Original Message- Sent: Tuesday, June 24, 2003 11:59 AM To: Multiple recipients of list ORACLE-L Hi, What is the group view if I will go with locally managed tablespaces? thx -seema _ Tired of spam? Get advanced junk mail protection with MSN 8. http://join.msn.com/?page=features/junkmail -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Seema Singh INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gogala, Mladen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: (OT) RE: Look's like Larry's at it again...
Title: RE: (OT) RE: Look's like Larry's at it again... Well, what will happen if Oracle acquires a nucular weapon or other WMD? Mladen Gogala Oracle DBA Phone:(203) 459-6855 Email:[EMAIL PROTECTED] -Original Message-From: Bob Lofstrand [mailto:[EMAIL PROTECTED]Sent: Monday, June 23, 2003 2:50 PMTo: Multiple recipients of list ORACLE-LSubject: RE: (OT) RE: Look's like Larry's at it again... Unless international law changes a lot in the meantime we should never see a company take over a landmass, large or small. On the other hand maritime and admiralty law makes what happened with sealand theoretically legal. Law on the high seas should become interesting in the next century as the technology develops to create artificial islands. It also brings up the question of space stations that are built and launched by corporations. The way things are going one would assume that admiralty law will apply to space as well but I have never heard of a case. -Original Message- From: Jacques Kilchoer [mailto:[EMAIL PROTECTED]] Sent: Friday, June 20, 2003 5:20 PM To: Multiple recipients of list ORACLE-L Subject: (OT) RE: Look's like Larry's at it again... Ever heard of Sealand, the "country" formed by an ex-British radio station owner who took over an abandoned World War II military platform built off the coast of the UK and declared it a sovereign country? http://wikipedia.com/w/wiki.phtml?search=sealand&go=Go > -Original Message- > From: Boivin, Patrice J [mailto:[EMAIL PROTECTED]] > > Seriously though, I wondered years ago at what point > multinationals are > going to pick a deserted island, declare it their country, > and set up their > own tax laws. > > Some companies have higher revenues than countries. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jacques Kilchoer INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). The information contained in this communication, including attachments, is strictly confidential and for the intended use of the addressee only; it may also contain proprietary, price sensitive, or legally privileged information. Notice is hereby given that any disclosure, distribution, dissemination, use, or copying of the information by anyone other than the intended recipient is strictly prohibited and may be illegal. If you have received this communication in error, please notify the sender immediately by reply e-mail, delete this communication, and destroy all copies. Corporate Systems, Inc. has taken reasonable precautions to ensure that any attachment to this e-mail has been swept for viruses. We specifically disclaim all liability and will accept no responsibility for any damage sustained as a result of software viruses and advise you to carry out your own virus checks before opening any attachment.
RE: DATAFILE SIZE
There is no limitation on Solaris 9i, mostly because there is no Solaris 9i. You might have just given an idea to Mr. Scott McNeally. Mladen Gogala Oracle DBA Phone:(203) 459-6855 Email:[EMAIL PROTECTED] -Original Message- Sent: Monday, June 23, 2003 3:05 PM To: Multiple recipients of list ORACLE-L IS there still a datafile size limitation on 9i? 2G? (Solaris) Thanks. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jerome Roa INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gogala, Mladen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle client for Unix System V
Forget about open source oracle. That is not going to happen in the next few milleniums. You can try thin driver or UnixODBC. Mladen Gogala Oracle DBA Phone:(203) 459-6855 Email:[EMAIL PROTECTED] -Original Message- Sent: Monday, June 23, 2003 11:39 AM To: Multiple recipients of list ORACLE-L I would like to open a connection to a Oracle database within a machine running a dialect of Unix System V Release 4.0 (more exactly, MP-RAS SVR4 Unix). It is a Perl ETL script that uses DBI and DBD::Oracle, which in turn needs Oracle client software. Is there a way to do it? Is source code for Oracle client available so that I can try to make it (compile, install and test) at this Unix machine? Best regards, Adriano. _ Adriano Rodrigues Ferreira Analista de Sistemas Metodologia e Controle de Processos/Tecnologia da Informação Peixoto Ind. Com. Trans. e Serv. Ltda Tel: 34 3218-5507 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gogala, Mladen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Migrating 8i OPS to RAC 9.2
KG, you're an ace. Thank you very much. Mladen Gogala Oracle DBA Phone:(203) 459-6855 Email:[EMAIL PROTECTED] -Original Message- Sent: Monday, June 23, 2003 9:49 AM To: Multiple recipients of list ORACLE-L Mladen: I am not aware any of the documentations which explains this cache fusion to ping pong feature(!). There are 3 components in the typical CR prosessing.. Let us assume there is a resource R which is mastered by the instance A and owned by the instance B on X mode. And also we assume the resource R is requested by Instance C. In this case the requester enquires the status of that resource to the master database and got to know that is owned by instance B. So now it is Instance B's respoisibility to constuct the CR and send it to Instnace C. Here, there is something called light work rule (X$KCLCRST.LIGHT?) which decides the CR construction and block transfer over interconnect (again the CR processing for S to N locks are different based on the setting of _cr_grant_local parameter) or thru the disk transfer. Basically the current holder of the resource maintains a fairness counter, which is incremented every time it sends CR copy over the interconnect to the requester and there is a threshold for the number of CR copies created for that resource. Once the ceiling is hit, instead of creating the CR copies, the LMD simply downconverts the lock to NULL and informs the convertion to Intance A. In simple terms it is like a normal OPS ping. The owner downgrades the lock and the requester reads from the disk after getting approval from the lock master. The threshold is controlled by the parameter _fairness_threshold and IIRC that defaults to 4 or 5. So every 6th (or 5th) CR request will most of the times results in a PING and I have seen good performance improvements in most of the RAC databases by changing this parameter. Best Regards, K Gopalakrishnan (Currently I am in a country (for a week) where I have very limited access to the internet , So I may not be able to reply if you have any more questions And I don't have any oracle database/documentation to test/verify. So please take the advise with a pinch of salt !) -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: K Gopalakrishnan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gogala, Mladen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Look's like Larry's at it again...
ORA-GON? Daniel, you are a genius! He could also ammend the constitution to read We, the PeopleSoft Mladen Gogala Oracle DBA Phone:(203) 459-6855 Email:[EMAIL PROTECTED] -Original Message- Sent: Friday, June 20, 2003 4:55 PM To: Multiple recipients of list ORACLE-L I figured he try for something closer to home...say Oragon? Then Bill would want to buy Mississippi (postal abreviation MS for our non-us listers). "Jesse, Rich" wrote: > > Oracle Makes Bid to Buy State of Delaware > > Software giant willing to assume state's $225 million deficit in exchange > for > legislative control, naming rights > > Wilmington, DE - Oracle CEO Larry Ellison today announced his intention to > purchase the state of Delaware for $300 million in cash and Oracle stock. > The > move comes on the heels of Oracle's bid for rival software firm PeopleSoft, > and is the first time that an offer has been made to buy a U.S. territory. > > Delaware governor Ruth Ann Minner responded to the bid with shock and seemed > certain that the hostile takeover could be avoided. > > "Oracle's bid comes as a big surprise to the government and people of > Delaware", said Minner at a press conference. "At this point, we are > checking > into whether or not a company, such as Oracle, can buy a state, and whether > or > not Delaware is actually for sale." > > Oracle's announcement sent shockwaves through the political and economic > landscape. Oracle shares dropped 8% immediately following the announcement, > only to rebound and break even for the day, with heavy volume being traded. > Meanwhile, government officials in Washington scrambled to look into the > legality of such a purchase, and who actually currently owns Delaware. > > In an afternoon press conference, Ellison seemed certain that Oracle would > own > Delaware in the near future. > > "The fact is that the state of Delaware is in a budget crisis that it can > not > resolve. Oracle's bid will immediately pump $300 million into the state > budget, and (Oracle) will also be assuming all current Delaware debt. Call > this a 'hostile takeover' if you must, but the people of this great state > deserve a better future, and I will be able to give them just that." > > President Bush, who was giving a speech to coal miners in Kentucky, called > the > Oracle bid "interesting" and added that "49 states would be easier for me to > handle than 50". > > Ellison rival Tom Siebel called the move "typical", and added "Larry thinks > he > can take over the world, and I guess he thinks this is a good place to > start. > I personally would have targeted Vermont." > > Ellison defended his decision, citing fourteen state parks, a minor league > baseball franchise, an annual Nascar race in Dover, and the annual Great > Delaware Kite Festival as reasons that Delaware is primed for success. > > "Delaware is a state rich in tradition and excitement. None of the existing > festivals or events will be changed. I mean, who doesn't love minor league > baseball and kites?" > > If the takeover bid is successful, Ellison plans to place several Oracle > executives in key state government positions, and is considering re-naming > the > state either New Ellison or OracleLand. > > [Couldn't resist, Jared! Hope it's not too OT!] > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Jesse, Rich > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gogala, Mladen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: (OT) RE: Look's like Larry's at it again...
Bummer! I've already started to hope that I'll soon be living in Connecticut ver 10i. Even Red Sox defeats would hurt less in the Oracleland. Mladen Gogala Oracle DBA Phone:(203) 459-6855 Email:[EMAIL PROTECTED] -Original Message- Sent: Friday, June 20, 2003 3:30 PM To: Multiple recipients of list ORACLE-L I hate to be a spoilsport, but some people unfamiliar with the USA might be taking this seriously. This is, of course, a humorous piece, in the same vein as the joke about Microsoft purchasing the Catholic Church http://www.spunk.org/library/humour/sp001526.html > -Original Message- > From: Jesse, Rich [mailto:[EMAIL PROTECTED] > > Oracle Makes Bid to Buy State of Delaware > > > Software giant willing to assume state's $225 million deficit > in exchange > for > legislative control, naming rights > > Wilmington, DE - Oracle CEO Larry Ellison today announced his > intention to > purchase the state of Delaware for $300 million in cash and > Oracle stock. > The > move comes on the heels of Oracle's bid for rival software > firm PeopleSoft, > and is the first time that an offer has been made to buy a > U.S. territory. > > Delaware governor Ruth Ann Minner responded to the bid with > shock and seemed > certain that the hostile takeover could be avoided. > > "Oracle's bid comes as a big surprise to the government and people of > Delaware", said Minner at a press conference. "At this point, we are > checking > into whether or not a company, such as Oracle, can buy a > state, and whether > or > not Delaware is actually for sale." > > Oracle's announcement sent shockwaves through the political > and economic > landscape. Oracle shares dropped 8% immediately following > the announcement, > only to rebound and break even for the day, with heavy volume > being traded. > Meanwhile, government officials in Washington scrambled to > look into the > legality of such a purchase, and who actually currently owns Delaware. > > In an afternoon press conference, Ellison seemed certain that > Oracle would > own > Delaware in the near future. > > "The fact is that the state of Delaware is in a budget crisis > that it can > not > resolve. Oracle's bid will immediately pump $300 million into > the state > budget, and (Oracle) will also be assuming all current > Delaware debt. Call > this a 'hostile takeover' if you must, but the people of this > great state > deserve a better future, and I will be able to give them just that." > > President Bush, who was giving a speech to coal miners in > Kentucky, called > the > Oracle bid "interesting" and added that "49 states would be > easier for me to > handle than 50". > > Ellison rival Tom Siebel called the move "typical", and added > "Larry thinks > he > can take over the world, and I guess he thinks this is a good place to > start. > I personally would have targeted Vermont." > > Ellison defended his decision, citing fourteen state parks, a > minor league > baseball franchise, an annual Nascar race in Dover, and the > annual Great > Delaware Kite Festival as reasons that Delaware is primed for > success. > > "Delaware is a state rich in tradition and excitement. None > of the existing > festivals or events will be changed. I mean, who doesn't love > minor league > baseball and kites?" > > If the takeover bid is successful, Ellison plans to place > several Oracle > executives in key state government positions, and is > considering re-naming > the > state either New Ellison or OracleLand. > > > [Couldn't resist, Jared! Hope it's not too OT!] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jacques Kilchoer INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services --------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gogala, Mladen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Look's like Larry's at it again...
Cool. State of Connecticut also has a budget crisis.. Mladen Gogala Oracle DBA Phone:(203) 459-6855 Email:[EMAIL PROTECTED] -Original Message- Sent: Friday, June 20, 2003 2:20 PM To: Multiple recipients of list ORACLE-L Oracle Makes Bid to Buy State of Delaware Software giant willing to assume state's $225 million deficit in exchange for legislative control, naming rights Wilmington, DE - Oracle CEO Larry Ellison today announced his intention to purchase the state of Delaware for $300 million in cash and Oracle stock. The move comes on the heels of Oracle's bid for rival software firm PeopleSoft, and is the first time that an offer has been made to buy a U.S. territory. Delaware governor Ruth Ann Minner responded to the bid with shock and seemed certain that the hostile takeover could be avoided. "Oracle's bid comes as a big surprise to the government and people of Delaware", said Minner at a press conference. "At this point, we are checking into whether or not a company, such as Oracle, can buy a state, and whether or not Delaware is actually for sale." Oracle's announcement sent shockwaves through the political and economic landscape. Oracle shares dropped 8% immediately following the announcement, only to rebound and break even for the day, with heavy volume being traded. Meanwhile, government officials in Washington scrambled to look into the legality of such a purchase, and who actually currently owns Delaware. In an afternoon press conference, Ellison seemed certain that Oracle would own Delaware in the near future. "The fact is that the state of Delaware is in a budget crisis that it can not resolve. Oracle's bid will immediately pump $300 million into the state budget, and (Oracle) will also be assuming all current Delaware debt. Call this a 'hostile takeover' if you must, but the people of this great state deserve a better future, and I will be able to give them just that." President Bush, who was giving a speech to coal miners in Kentucky, called the Oracle bid "interesting" and added that "49 states would be easier for me to handle than 50". Ellison rival Tom Siebel called the move "typical", and added "Larry thinks he can take over the world, and I guess he thinks this is a good place to start. I personally would have targeted Vermont." Ellison defended his decision, citing fourteen state parks, a minor league baseball franchise, an annual Nascar race in Dover, and the annual Great Delaware Kite Festival as reasons that Delaware is primed for success. "Delaware is a state rich in tradition and excitement. None of the existing festivals or events will be changed. I mean, who doesn't love minor league baseball and kites?" If the takeover bid is successful, Ellison plans to place several Oracle executives in key state government positions, and is considering re-naming the state either New Ellison or OracleLand. [Couldn't resist, Jared! Hope it's not too OT!] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gogala, Mladen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Book Recommendation for Apache
O'Reilly is good. Also, get yourself comanche (http://www.comanche.org). That is a gooey tool for setting up Apache. Mladen Gogala Oracle DBA Phone:(203) 459-6855 Email:[EMAIL PROTECTED] -Original Message-From: Sam Bootsma [mailto:[EMAIL PROTECTED]Sent: Thursday, June 19, 2003 4:44 PMTo: Multiple recipients of list ORACLE-LSubject: Book Recommendation for Apache Hi, Any recommendations on good Apache books? We will be bringing in Oracle 9iAS shortly. Third party application constraints require the use of Forms 6i, which in turn requires that we stay with 9iAS Release 1 (version 1.0.2.x.x). We are currently running Oracle Application Server. I want to understand how 9iAS works. For me, the steps to understanding this are something like: 1) Understand HTTP 2) Understand Apache 3) Understand 9iAS I have found useful information on the Internet describing the HTTP protocol, and I am comfortable I understand that well enough to move on. Now I want to get a handle on the Apache Server. I have had a brief look at a book from O’reilly called “Apache, The Definitive Guide”. This looks like a good book. Thanks, Sam p.s. A few months, I read on the List that the Publisher of Tom Kyte’s book “"Expert One-On-One Oracle" has gone bankrupt. Can anybody confirm if this is true?
RE: [Q] Script to generate "grant privilege" on a table?
Look into DBMS_METADATA examples in the oracle 9.2 technical documentation. That is precisely the example they gave. Mladen Gogala Oracle DBA Phone:(203) 459-6855 Email:[EMAIL PROTECTED] -Original Message- Sent: Friday, June 20, 2003 8:45 AM To: Multiple recipients of list ORACLE-L Does anyone has script which can check "grant privilege" on a table and generate output for future usage? Thanks. __ Do you Yahoo!? SBC Yahoo! DSL - Now only $29.95 per month! http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: mike mon INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gogala, Mladen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: oracle authentication from windows
That,
of course, will render your database totally insecure and open to anybody
who
can bring in a WinXP laptop, change the windoze username and log in as he
pleases.
DBA
that sets his production parameters the way Arup described deserves to be
publicly tortured by Bill O'Reilly in the "no spin
zone".
Mladen Gogala Oracle DBA Phone:(203) 459-6855
Email:[EMAIL PROTECTED]
-Original Message-From: Arup Nanda
[mailto:[EMAIL PROTECTED]Sent: Thursday, June 19, 2003 3:46
PMTo: Multiple recipients of list ORACLE-LSubject: Re:
oracle authentication from windows
Sure.
Just declare these in your init.ora
os_authent_prefix=OPS$remote_os_authent=TRUE
bounce the database, add a user called
OPS$, e.g. OPS$AK if your Windows login id is AK
as
create user ops$ak identified
externally
From windows connect as "/@servicename",
e.g. sqlplus /@service1
If it doesn't work, the OS user may be different.
Use this query while connected to the database from Windows
cleint.
SQL> select sys_context('USERENV','OS_USER')
from dual;
See what OS username comes up; use that
instead.
HTH.
Arup Nanda
www.proligence.com
- Original Message -
From:
AK
To: Multiple
recipients of list ORACLE-L
Sent: Thursday, June 19, 2003 1:10
PM
Subject: oracle authentication from
windows
We want our client users ( forms user )
to just enter windows password and then automatically able to get in to
oracle .Is there a way oracle can authenticate from windows ( or active
directory ) . enbadding password in runform.exe not an option .
thanks,
-ak
RE: Passwords and authentication
Title: Passwords and authentication Bummer! I was hoping for a commission from Oracle! Mladen Gogala Oracle DBA Phone:(203) 459-6855 Email:[EMAIL PROTECTED] -Original Message-From: Jamadagni, Rajendra [mailto:[EMAIL PROTECTED]Sent: Thursday, June 19, 2003 3:18 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Passwords and authentication Label Security = Sometimes we need to compile forms against production instance (please don't ask) to resolve some really stupid issues. When compiling, the form has to be compiled with schema owner (again don't ask). As the production schema are locked down, we need a way to connect to compile. I do not want to set-up an elaborate scheme as mentioned by Arup, because this will _NOT_ be a regular feature. This all came into picture because the new release mechanism that we are testing ... you check in a form into PVCS, as it gets promoted to R_F_P, the DBAs would check it out, compile it and release it. And all three processes will be managed by event triggers in PVCS. The main use of using encrypted connection to connect to db is to compile forms and reports (from windows platform). Ok well, seems like a bit of impossible task to me ... to connect using the encrypted value from dba_users view. Thanks for the ideas though ... Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! -Original Message-From: Gogala, Mladen [mailto:[EMAIL PROTECTED]Sent: Thursday, June 19, 2003 12:45 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Passwords and authentication There is also label security option which is present on Enterprise Edition CD. That would alleviate the need for manual encryption because the table cannot be seen unless there is sufficient security clearance. Also, logging in from SQL*Plus can be disabled from the USER_PRODUCT_PROFILE. Connected to that, is anybody on this list using label security? Does anybody have experience with it? Arup, you are writing a book about security in Oracle 9.2 and I hope that you will cover label security. Mladen Gogala Oracle DBA Phone:(203) 459-6855 Email:[EMAIL PROTECTED] -Original Message-From: Arup Nanda [mailto:[EMAIL PROTECTED]Sent: Thursday, June 19, 2003 12:15 PMTo: Multiple recipients of list ORACLE-LSubject: Re: Passwords and authentication Raj, My first question will be how you would want to pass the encrypted password. sqlplus /? But won't the encrypted password be known before making the connection? If so, then the user who will encrypt the password will also know how to decrypt them. What's the advantage in doing that? Are you concerned someone sniffing the network uncovers a clear password? If so, have you considered network security with password encryption by Oracle Net? If that is not the concern but rather you don't want the users to know the real password, here is a solution you might be interested. It's part of a elaborate application security design. Please read on if you are interested. You would have user called SECUSER with only table APP_USERS. The table has two columns - APP_USER and APP_PASS, in encrypted manner, with Triple DES Encryption. The user also has one function - check_app_password, which accepts two parameters - the userid and the password and returns a string. The return value is YES is the password supplied is correct and NO, if it isn't. It does not shw the correct password, ever; just shows if the supplied password is correct or not. This function is defined as DEFINER rights. All users get an execute privilege on this function, nothing else on the rest of the objects of the SECUSER user. Inside the function, the password is retrieved from the table, decrypted with the key inside the procedure and matched with the supplied one. Another function is provided to encrypt the password using teh same key. For more ecurity, the userid and password combination can encrypted, not just the password. If you want I can give you the code for the functions. When the app user connects, the connection is done through a generic id, that, after the conenction, validates the password using the function and authenticates the user. If the password is not correct, the user is booted out. Now comes other issues - fine grained acc
RE: Passwords and authentication
Title: Passwords and authentication There is also label security option which is present on Enterprise Edition CD. That would alleviate the need for manual encryption because the table cannot be seen unless there is sufficient security clearance. Also, logging in from SQL*Plus can be disabled from the USER_PRODUCT_PROFILE. Connected to that, is anybody on this list using label security? Does anybody have experience with it? Arup, you are writing a book about security in Oracle 9.2 and I hope that you will cover label security. Mladen Gogala Oracle DBA Phone:(203) 459-6855 Email:[EMAIL PROTECTED] -Original Message-From: Arup Nanda [mailto:[EMAIL PROTECTED]Sent: Thursday, June 19, 2003 12:15 PMTo: Multiple recipients of list ORACLE-LSubject: Re: Passwords and authentication Raj, My first question will be how you would want to pass the encrypted password. sqlplus /? But won't the encrypted password be known before making the connection? If so, then the user who will encrypt the password will also know how to decrypt them. What's the advantage in doing that? Are you concerned someone sniffing the network uncovers a clear password? If so, have you considered network security with password encryption by Oracle Net? If that is not the concern but rather you don't want the users to know the real password, here is a solution you might be interested. It's part of a elaborate application security design. Please read on if you are interested. You would have user called SECUSER with only table APP_USERS. The table has two columns - APP_USER and APP_PASS, in encrypted manner, with Triple DES Encryption. The user also has one function - check_app_password, which accepts two parameters - the userid and the password and returns a string. The return value is YES is the password supplied is correct and NO, if it isn't. It does not shw the correct password, ever; just shows if the supplied password is correct or not. This function is defined as DEFINER rights. All users get an execute privilege on this function, nothing else on the rest of the objects of the SECUSER user. Inside the function, the password is retrieved from the table, decrypted with the key inside the procedure and matched with the supplied one. Another function is provided to encrypt the password using teh same key. For more ecurity, the userid and password combination can encrypted, not just the password. If you want I can give you the code for the functions. When the app user connects, the connection is done through a generic id, that, after the conenction, validates the password using the function and authenticates the user. If the password is not correct, the user is booted out. Now comes other issues - fine grained access control and fine grained auditing. These features need to have a sepcific named database user. However, that can be easily fixed by setting up an application context and passing the app_user value to a context attribute. This attribute can now be tracked, rather than the userid. Hope this helps. Arup Nanda www.proligence.com - Original Message - From: Jamadagni, Rajendra To: Multiple recipients of list ORACLE-L Sent: Thursday, June 19, 2003 9:19 AM Subject: Passwords and authentication Is it possible to connect to database using encrypted passwords? Using sqlplus? Thanks Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art !
RE: MySQL in the future?
How can a honest DBA become a lawyer? It seems to me that technology has become dependent on lawyers. If AIX is stopped, it will be a disaster of biblical proportions which will seriously disrupt business. I believe that the future lies in litigation, not technology. As for MySQL, it has never been a favorite of mine. If I need an open source database, it seems to me that Postgres is the way to go. It supports transactions from the start and it also supports more or less classic SQL. Mladen Gogala Oracle DBA Phone:(203) 459-6855 Email:[EMAIL PROTECTED] -Original Message- Sent: Thursday, June 19, 2003 10:13 AM To: Multiple recipients of list ORACLE-L I think we've all seen and are once again seeing a similar maneuver. Can you get MySql from mysql.org, sure but it's going to be left way in the dirt by MySql AB until their version is the only acceptable one out there. Course by then it probably will acquire a different name. and of course a higher price tag. Only the lawyers win!!! Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Wednesday, June 18, 2003 11:35 PM To: Multiple recipients of list ORACLE-L I'm glad I'm not a lawyer. What does distribute internally mean? I work for company X and write an application to use a MySQL database. I take the zip file I downloaded from MySQL and install it to another server, and now two sets of people are using the database on different machines with the same application. Does that mean I distributed it internally? > -Original Message- > From: Matthew Zito [mailto:[EMAIL PROTECTED] > > But its not that clear, though - look at this part: > > "As long as you never distribute (internally or externally) the MySQL > Software in any way, you are free to use it for powering your > application, irrespective of whether your application is under GPL or > other OSI approved license or not. > " > > So, I would interpret that as saying that if you wrote a web > application > or a win32 application that just connects to a centrally located mysql > database and runs queries, no need to GPL your software. If your app > comes with an installer that installs the app as well as mysql, its > gotta be GPL or you have to purchase a commercial license. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jacques Kilchoer INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Goulet, Dick INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gogala, Mladen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: MySQL in the future?
Nope, it will not. Companies are still suspicious toward open source and if they cannot buy it, they will not use it. The most often quoted reason is support. Mladen Gogala Oracle DBA Phone:(203) 459-6855 Email:[EMAIL PROTECTED] -Original Message- Sent: Tuesday, June 17, 2003 3:10 PM To: Multiple recipients of list ORACLE-L WILL OPEN-SOURCE THREATEN ORACLE, IBM AND MS? | Internet News How big of a threat are open-source databases to software giants like Oracle, who hold most of the market and revenue share today? MySQL could be the biggest challenger to Oracle, and even Microsoft and IBM in the database market. MySQL is making inroads as a database alternative for small businesses or departmentally inside larger enterprises. Ultimately, the groundswell of support for MySQL could propel it on a Linux-like course to stardom as companies look to reduce TCO for databases. For the full details, click: http://www.internetnews.com/ent-news/article.php/2221901 Interesting article Is this the wave of the future for the small consultant?? If the CEO is smart he will start a certification program and release upgrades every 18 months. It keeps the revenue comming it. Ron -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ron Rogers INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gogala, Mladen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: recreating a create database file
I have it at home. It's a modified version of the script in Orac_Dba, concocted by Jared Still and Andy Duncan. You can get the script from CPAN and I'll send you my version when I get home. I've even sent it to Jared and Andy, but I don't have time to maintain Orac_Dba right now. May be Jared has it somewhere at hand. Mladen Gogala Oracle DBA Phone:(203) 459-6855 Email:[EMAIL PROTECTED] -Original Message- Sent: Tuesday, June 17, 2003 10:09 AM To: Multiple recipients of list ORACLE-L Good morning all, Somehow all of my scripts to create the databases on my 9i sandbox have disappeared. Does anyone have a script or trick or something to recreate these files? I could recreate them manually but I am somewhat of a time crunch. Thanks in advance, Ruth -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ruth Gramolini INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gogala, Mladen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: asking your opinion
With a standby database, either physical or logical (Oracle 9i) you get a failower machine, typically much smaller then the original one. The problem is that there isn't much else you can do on that machine. In case of a logical standby, you can use it as a report server, but then again, you are duplicating your disks and storing the same database in two different places. It is much easier to administer then RAC because you don't have DLM to contend with and hardwarewise, it is cheaper (no clustering software, no high speed interconnects no RAC licenses). With RAC, you get much more. You get several nodes accessing the same database, thus providing you with the transparent failover and much greater survivability of the database. Also, you can use all nodes of a RAC configuration for transactions. With RAC, nodes ship to each other the current version of a block as well as the read consistent images of a block (constructed from rollback segments) so partitioning the application functionally is no longer necessary. Also, your database is not stored in two different places, so there is no problem with the consistency. As for one or more databases, it depends on your budget and your business needs. The most survivable configuration would include a central RAC database and smaller departmental RAC databases which would deliver the data to the central database by using multimastering replication.That would also include something like BCV database to have up as a readonly copy during maintenance times. Now we're talking eight figures. The business has to take a good look at itself and decide which data absolutely must survive and which data can be temporarily offline in order for the business to survive. There is a known story about the WTC branch office of Chase Manhattan, which was switched to a remote copy and which didn't lose a single transaction despite the fact that the branch office itself was completely destroyed. That kind of survivability costs money and business must decide whether it needs it or not. Mladen Gogala Oracle DBA Phone:(203) 459-6855 Email:[EMAIL PROTECTED] -Original Message- Sent: Tuesday, June 17, 2003 12:15 AM To: Multiple recipients of list ORACLE-L Hi Dear listers, I'd like to ask your opinion about our possible new project. overview; install fatwire for the whole community for web application. no single point of failure, sun servers, oracle. We have more than 10 divisions currently( different department, like arts, dental, enginerring..etc), but we want the flexibility to add more "unit" as the environment changes and grows. Question 1: database option; what is the pros and cons about physical standby database, logical staandby or RAC? I think the answer should be RAC, right? question 2: Among the questions is whether this is a series of databases for each unit or a central database that is shared by all? I am new to this area, I would appreciate any input informantion. Thanks again, Joan -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Joan Hsieh INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gogala, Mladen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: RE: World premier performance of the BAARF party logo
I'm not sure. You may be right. I thought that it was Larry Ellison, but then again, it's Monday and my memory is probably failing me. Mladen Gogala Oracle DBA Phone:(203) 459-6855 Email:[EMAIL PROTECTED] -Original Message- Sent: Monday, June 16, 2003 4:25 PM To: Multiple recipients of list ORACLE-L That was McNealy that said HP was a great little printer company, wasn't it? Cary Millsap Hotsos Enterprises, Ltd. http://www.hotsos.com Upcoming events: - Hotsos Clinic 101 in Dallas, Washington, Denver, Sydney - Hotsos Symposium 2004, March 7-10 Dallas - Visit www.hotsos.com for schedule details... -Original Message- Gogala, Mladen Sent: Monday, June 16, 2003 2:10 PM To: Multiple recipients of list ORACLE-L When Larry met Carly? I don't know whether Carly is his type, but that would be some marriage! I can still remember the fiery relationship with Sandra Kurtzig, the former CEO of Ingres. Having in mind that HP is a "great printer company", according to Larry, I doubt that the relationship would work. Mladen Gogala Oracle DBA Phone:(203) 459-6855 Email:[EMAIL PROTECTED] -Original Message- Sent: Monday, June 16, 2003 11:54 AM To: Multiple recipients of list ORACLE-L >- --- Original Message --- - >From: "Gogala, Mladen" <[EMAIL PROTECTED]> >To: Multiple recipients of list ORACLE-L ><[EMAIL PROTECTED]> >Sent: Mon, 16 Jun 2003 06:44:18 > >A movie with Julia Roberts or Meg Ryan is what I >had in mind. > >Mladen Gogala >Oracle DBA >Phone:(203) 459-6855 >Email:[EMAIL PROTECTED] > When Larry met Carly ? Regards, Stephane Faroult Oriole -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephane Faroult INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gogala, Mladen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Cary Millsap INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gogala, Mladen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: RE: World premier performance of the BAARF party logo
When Larry met Carly? I don't know whether Carly is his type, but that would be some marriage! I can still remember the fiery relationship with Sandra Kurtzig, the former CEO of Ingres. Having in mind that HP is a "great printer company", according to Larry, I doubt that the relationship would work. Mladen Gogala Oracle DBA Phone:(203) 459-6855 Email:[EMAIL PROTECTED] -Original Message- Sent: Monday, June 16, 2003 11:54 AM To: Multiple recipients of list ORACLE-L >- --- Original Message --- ----- >From: "Gogala, Mladen" <[EMAIL PROTECTED]> >To: Multiple recipients of list ORACLE-L ><[EMAIL PROTECTED]> >Sent: Mon, 16 Jun 2003 06:44:18 > >A movie with Julia Roberts or Meg Ryan is what I >had in mind. > >Mladen Gogala >Oracle DBA >Phone:(203) 459-6855 >Email:[EMAIL PROTECTED] > When Larry met Carly ? Regards, Stephane Faroult Oriole -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephane Faroult INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gogala, Mladen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: World premier performance of the BAARF party logo
Title: RE: World premier performance of the BAARF party logo Well, the way memory is growing, we'll soon have in-memory databases which will bring the ultimate victory to Cary by rendering the phrase "hit ratio" meaningless. How's that for futuristic thinking? To go even further, there might even come the day when that monster created by IBM, the PC itself will become obsolete and everything will work of a small device, call it "network computer" which will run applications from your "application service provider". Am I a genuine futurist thinker or what? Don't tell Larry that I've stolen some of his ideas. Mladen Gogala Oracle DBA Phone:(203) 459-6855 Email:[EMAIL PROTECTED] -Original Message-From: Whittle Jerome Contr NCI [mailto:[EMAIL PROTECTED]Sent: Monday, June 16, 2003 9:50 AMTo: Multiple recipients of list ORACLE-LSubject: RE: World premier performance of the BAARF party logo Putting on my futuristic thinking hat, I see a day not too far off when there won't be any Ds. RAID, as we know it, will go away. Jerry Whittle ASIFICS DBA NCI Information Systems Inc. [EMAIL PROTECTED] 618-622-4145 -Original Message- Daniel W. Fink wrote: > Mogens, > As a futuristic thinker, I challenge you to go beyond todays > technology and consider what the next millenium may bring. While it is > all good and well to be against RAID-Free/Four/Five, we should also > issue a policy statement against the newer, though not currently > production ready, configurations listed below. > > RAID-Firteen/Fourteen/Fifteen, Free hundred through Five hundred > ninety nine (inclusive), Free thousand through Five thousand nine > hundred ninety nine (inclusive) and all RAIDS that are powers of > Free/Four/Five. > > Dan
RE: World premier performance of the BAARF party logo
ail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- Mladen Gogala Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gogala, Mladen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle Names
RACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Goulet, Dick INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gogala, Mladen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle Names
Oracle names is actually a very stable software and it works very nice. I have very good experience with that product. As for LDAP, it's huge, incompatible, hard to administer and you must have 9iAS. It doesn't work with iPlanet, weblogic or websphere.It's a proprietary LDAP if such thing exists. The other thing that would be even simpler is hostnaming. Name your database same as the host (service_names and global_dbname in listener.ora), put it on the port 1521 and enjoy. Mladen Gogala Oracle DBA Phone:(203) 459-6855 Email:[EMAIL PROTECTED] -Original Message- Sent: Thursday, June 12, 2003 1:49 PM To: Multiple recipients of list ORACLE-L We are starting a project that will eventually have 500 laptops wandering around in the wild. These will have an Access database for untethered use, and will periodically connect to Oracle via Net8 to resynchronize itself. The idea of changing 500 tnsnames.ora files sometime down the line is daunting. I've been studying for the OCP Net8 exam, and they mention Oracle Names. 1. Are any of you using the Oracle Names? 2. Is it as easy to configure as Oracle makes it sound, or is it difficult? 3. Is Names reasonably robust? I can see this as yet another single point of failure. 4. Oracle hinted that Oracle Names is going away in favor of LDAP. Is this imminent, or just a scare tactic? I had held off using Names because of this, but the company has made a commitment to MS Active Directory, which I gather from the list postings isn't very compatible with Oracle's LDAP. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gogala, Mladen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: RE: db file sequential read [WAS:wait event puzzler]
gt; > * > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.net > > -- > > Author: Bhaskar Viswanathan > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > > San Diego, California-- Mailing list and web hosting services > > - > > To REMOVE yourself from this mailing list, send an E-Mail message > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > > the message BODY, include a line containing: UNSUB ORACLE-L > > (or the name of mailing list you want to be removed from). You may > > also send the HELP command for other information (like subscribing). > > > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.net > > -- > > Author: Senthil Kumar D > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > > San Diego, California-- Mailing list and web hosting services > > - > > To REMOVE yourself from this mailing list, send an E-Mail message > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > > the message BODY, include a line containing: UNSUB ORACLE-L > > (or the name of mailing list you want to be removed from). You may > > also send the HELP command for other information (like subscribing). > > > > > DISCLAIMER: > This message (including attachment if any) is confidential and may be privileged. Before opening attachments please check them for viruses and defects. MindTree Consulting Private Limited (MindTree) will not be responsible for any viruses or defects or any forwarded attachments emanating either from within MindTree or outside. If you have received this message by mistake please notify the sender by return e-mail and delete this message from your system. Any unauthorized use or dissemination of this message in whole or in part is strictly prohibited. Please note that e-mails are susceptible to change and MindTree shall not be liable for any improper, untimely or incomplete transmission. > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Naveen Nahata > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: <[EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gogala, Mladen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: java.sql.SQLException: ORA-21243896
Yup. Your SID isn't found. Mladen Gogala Oracle DBA Phone:(203) 459-6855 Email:[EMAIL PROTECTED] -Original Message- Sent: Wednesday, June 11, 2003 6:25 PM To: Multiple recipients of list ORACLE-L DBA's, Has anyone ever seen this: 15:37:19 06/11 [DBUG] [ConnectionPoolC] SvcsConnectionFinished Reading properties horizon 15:37:20 06/11 [EROR] [ConnectionPoolC] SvcsConnection SQLException occured while while creating pool for horizon 15:37:20 06/11 [EROR] [ConnectionPoolC] SvcsConnection java.sql.SQLException: ORA-21243896: Message 21243896 not found; product=RDBMS; facility=ORA IRIX64 Error: 67108868: Unknown system error This is from the connection pool log in BEA, it show up when re-deploying the application from BEA??? TAI ...JIM... -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: James Howerton INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gogala, Mladen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: db file sequential read [WAS:wait event puzzler]
I must confess that I checked by using "strace" on Linux and, true enough, for index read, I've got "read" calls and for full table scan, I've got "readv" (scatter/gather IO). Obviously, I'll have to re-learn some stuff from version 7. I successfully forgot versions 4, 5.0, 5.1.22, 6.0.36, 7.0.16, 7.1.16 and 7.2. I'll try forgetting 7.3.4 as well although it's the last really stable version of oracle. Mladen Gogala Oracle DBA Phone:(203) 459-6855 Email:[EMAIL PROTECTED] -Original Message- Sent: Thursday, June 12, 2003 4:24 AM To: Multiple recipients of list ORACLE-L Mladen: Prior to 8i (or 8) you see the multiblock sequential reads while doing the reads from the sort segments or temporary segments. But in 8i sort IO is done as direct IO and we see some other waits. Starting from 8i the db file sequential read is always a single block read which TYPICALLY happens during index scans.. Are you convinced? Best Regards, K Gopalakrishnan --- "Gogala, Mladen" <[EMAIL PROTECTED]> wrote: > A SINGLE block? I was convinced that it was <= > DB_FILE_MULTIBLOCK_READ_COUNT > blocks. > Are you sure? > > Mladen Gogala > Oracle DBA > Phone:(203) 459-6855 > Email:[EMAIL PROTECTED] > > > -Original Message- > Sent: Wednesday, June 11, 2003 2:19 PM > To: Multiple recipients of list ORACLE-L > > > Dennis: > > THe event 'db file sequential read' is NOT always an INDEX Scan. It > is > just a single block read which TYPICALLY happens during an INDEX > scan. > The word 'TYPICALLY' is the key here. > > > > Best Regards, > K Gopalakrishnan > > > > > -Original Message- > Meng, Dennis > Sent: Wednesday, June 11, 2003 11:02 AM > To: Multiple recipients of list ORACLE-L > > > Good day all, > We have a bunch of queries in our data warehouse environment that are > taking > a long time to complete. > I did a select on v$session_wait on one of the queries when it is > running > and it shows the wait event to be 'db file sequential read', which > means it > is scanning index blocks, correct? But when I put the p1 p2 p3 > values into > another query to see which segment it belongs to, it shows me a > table, not > an index. How can this be? > > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: K Gopalakrishnan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gogala, Mladen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: wait event puzzler
The "db file sequential read" means that oracle is trying to read a sequence of consecutive blocks, shorter then DB_FILE_MULTIBLOCK_READ_COUNT. That usually happens when reading indexes, but it's not inconceivable to happen during table access as well. Mladen Gogala Oracle DBA Phone:(203) 459-6855 Email:[EMAIL PROTECTED] -Original Message- Sent: Wednesday, June 11, 2003 2:02 PM To: Multiple recipients of list ORACLE-L Good day all, We have a bunch of queries in our data warehouse environment that are taking a long time to complete. I did a select on v$session_wait on one of the queries when it is running and it shows the wait event to be 'db file sequential read', which means it is scanning index blocks, correct? But when I put the p1 p2 p3 values into another query to see which segment it belongs to, it shows me a table, not an index. How can this be? TIA Dennis - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Meng, Dennis INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gogala, Mladen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: wait event puzzler
A SINGLE block? I was convinced that it was <= DB_FILE_MULTIBLOCK_READ_COUNT blocks. Are you sure? Mladen Gogala Oracle DBA Phone:(203) 459-6855 Email:[EMAIL PROTECTED] -Original Message- Sent: Wednesday, June 11, 2003 2:19 PM To: Multiple recipients of list ORACLE-L Dennis: THe event 'db file sequential read' is NOT always an INDEX Scan. It is just a single block read which TYPICALLY happens during an INDEX scan. The word 'TYPICALLY' is the key here. Best Regards, K Gopalakrishnan -Original Message- Meng, Dennis Sent: Wednesday, June 11, 2003 11:02 AM To: Multiple recipients of list ORACLE-L Good day all, We have a bunch of queries in our data warehouse environment that are taking a long time to complete. I did a select on v$session_wait on one of the queries when it is running and it shows the wait event to be 'db file sequential read', which means it is scanning index blocks, correct? But when I put the p1 p2 p3 values into another query to see which segment it belongs to, it shows me a table, not an index. How can this be? TIA Dennis - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Meng, Dennis INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: K Gopalakrishnan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gogala, Mladen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: New Oracle security tool?
Oracle Security Auditing Tool for Analyzing Networks Does anybody have any good suggestions for abbreviations?Mladen GogalaOracle DBAPhone:(203) 459-6855Email:[EMAIL PROTECTED]-Original Message-From: Jesse, Rich [mailto:[EMAIL PROTECTED]]Sent: Wednesday, June 11, 2003 11:20 AMTo: Multiple recipients of list ORACLE-LSubject: New Oracle security tool?Anyone know what the forthcoming security tools are called? Part of OEMIV???http://www.eweek.com/article2/0,3959,1121278,00.aspRichRich Jesse System/Database Administrator[EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA--Please see the official ORACLE-L FAQ: http://www.orafaq.net--Author: Jesse, Rich INET: [EMAIL PROTECTED]Fat City Network Services -- 858-538-5051 http://www.fatcity.comSan Diego, California -- Mailing list and web hosting services-To REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).
RE: Named Pipes Protocol Adapter
And you would really allow your pipes to go nameless? I have
both names and nicknames for the integral parts of my plumbing.
Leaky Jack and wet Jill are my favorites.
Windoze has no concept of SYSV IPC, in particular it doesn't know
what shared memory is. Oracle on Windoze is not running processes,
it's running threads. That means that you cannot attach ("shmat")
shared memory as on a civilized OS but you have to use Oracle*Net.
The protocol that you are using to communicate with a database on
your local machine is called "named pipes".
Just read the fine manuals, everything is in there.
Mladen Gogala
Oracle DBA
Phone:(203) 459-6855
Email:[EMAIL PROTECTED]
-Original Message-
Sent: Tuesday, June 10, 2003 6:25 PM
To: Multiple recipients of list ORACLE-L
List,
Why would someone want to use Named Pipes Protocol Adapter? I have never
used this, could someone educated me on this?
David Ehresmann
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Ehresmann, David
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Gogala, Mladen
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
RE: International User Community
Title: International User Community IOUG? Is that an "Iraqi Oracle User Group"? Boy, thing are developing fast! Mladen Gogala Oracle DBA Phone:(203) 459-6855 Email:[EMAIL PROTECTED] -Original Message-From: April Wells [mailto:[EMAIL PROTECTED]Sent: Monday, June 09, 2003 12:04 PMTo: Multiple recipients of list ORACLE-LSubject: International User Community While not trying to sound like this is coming off like a shameless plug, because it isn't... I have an Apps book going to publisher in a couple weeks and they want to do PR. To that end, they have asked me to fill out a fairly extensive paper on who might ever care about such a book... including International Organizations they might push out PR stuff to. Thanks to Rachel, I got a list of IOUG OAUG UKOUG EOUG APOUG and ODTUG Anyone know any others? This wasn't exaclty the kind of reasearch I was planning on... =) . Thanks in advance for any help and... sorry Jared for the questionable content. April The information contained in this communication, including attachments, is strictly confidential and for the intended use of the addressee only; it may also contain proprietary, price sensitive, or legally privileged information. Notice is hereby given that any disclosure, distribution, dissemination, use, or copying of the information by anyone other than the intended recipient is strictly prohibited and may be illegal. If you have received this communication in error, please notify the sender immediately by reply e-mail, delete this communication, and destroy all copies. Corporate Systems, Inc. has taken reasonable precautions to ensure that any attachment to this e-mail has been swept for viruses. We specifically disclaim all liability and will accept no responsibility for any damage sustained as a result of software viruses and advise you to carry out your own virus checks before opening any attachment.
RE: A new form of ORA-1555
Well, I've read a lot of that on this list (this is not the first time FBQ is being discussed) but as a conservative and somewhat paranoid DBA, I don't want to try anything that isn't supported with a very new feature like FBQ. The experience taught me a lesson about ora-600 and alike. I really wouldn't want to depend on a feature that is very, very new. I'd much rather use logminer instead. That's just me. Mladen Gogala Oracle DBA Phone:(203) 459-6855 Email:[EMAIL PROTECTED] -Original Message-From: Daniel W. Fink [mailto:[EMAIL PROTECTED]Sent: Friday, June 06, 2003 6:20 PMTo: Multiple recipients of list ORACLE-LSubject: Re: A new form of ORA-1555Mladen, That is a common misconception, one that Oracle wholeheartedly supports. Flashback Query (FBQ) depends upon the smon_scn_time table, which is popluated in 9i, regardless of the undo_management setting. This table is populated regardless of the UNDO_RETENTION parameter. This parameter is the guideline (not absolute) that Oracle uses when deciding which extents to reclaim when it needs space. If Oracle needs space, it may take extents containing committed transaction info that is still within the UNDO_RETENTION time. You can perform FBQ using RBSs, though this is probably not supported by Oracle, so use it at your own peril. The chances of success are diminished because of the difference in undo space management (rbs reuses space more often). I have done this several times, but in a non-production environment. IIRC, v$undostat is not populated unless the undo_management is set to auto. This really does not help in making the transition from rbs to aum. It would be nice to have it populated regardless so that you would have data to use to set the undo tablespace size and the value of UNDO_RETENTION. I did make one mistake. You have to enable flashback for a table or have the flashback_any_table privilege (Thanks, Kirti).DanGogala, Mladen wrote: Flashback query is enabled by setting the UNDO_RETENTION parameter to the desired number of seconds. Table V$UNDOSTAT contains the column MAXQUERYLEN which gives the max time that you can use to dynamically set UNDO_RETENTION. You also have to enable flashback for session using DBMS_FLASHBACK. Mladen Gogala Oracle DBA Phone:(203) 459-6855 Email:[EMAIL PROTECTED]
RE: A new form of ORA-1555
Flashback query is enabled by setting the UNDO_RETENTION parameter to the desired number of seconds. Table V$UNDOSTAT contains the column MAXQUERYLEN which gives the max time that you can use to dynamically set UNDO_RETENTION. You also have to enable flashback for session using DBMS_FLASHBACK. Mladen Gogala Oracle DBA Phone:(203) 459-6855 Email:[EMAIL PROTECTED] -Original Message-From: Daniel W. Fink [mailto:[EMAIL PROTECTED]Sent: Friday, June 06, 2003 5:01 PMTo: Multiple recipients of list ORACLE-LSubject: Re: A new form of ORA-1555You do not have to specifically enable a table for flashback query. In 9.2 (Kirti, please correct me if I am wrong), it is automatically enabled, even if you are not using AUM.I believe that this is a new error message format for 9. The solution that is commonly quoted is to increase your undo_retention to cover the amount of time needed to complete the query. However, this is not a guarantee that the query will actually work. If space is needed, unexpired extents will be reused. I think you may be hitting a situation similar to what Rachel encountered several weeks ago. It appears that a large number (at least 104) undo segments have been created. SMON is now offlining them in the hopes of reclaiming space. This brings up a situation posed recently and it was not a condition I had tested. If a large number of segments is created, are they ever dropped or do they continue to exist and consume space (at least 2 extents/128k) in the undo tablespace until it is dropped and a new one created? I THINK that the answer is that once created an undo segment will exist until the tablespace is dropped as there is no 'drop undo segment' command with aum. -- Daniel W. Fink http://www.optimaldba.comRuth Gramolini wrote: It might have something to do with setting the table to do a Flashback query. Maybe Dan will know. Ruth - Original Message - From: Jamadagni, Rajendra To: Multiple recipients of list ORACLE-L Sent: Friday, June 06, 2003 10:00 AM Subject: A new form of ORA-1555 A sighting in alert log ... SMON offlining US=102 SMON offlining US=104 Fri Jun 6 08:42:06 2003 ORA-01555 caused by SQL statement below (Query Duration=41895 sec, SCN: 0x0010.c2bd0c24): Fri Jun 6 08:42:06 2003 SELECT ROUND(G_1/:"SYS_B_00") G_1, ROUND(G_2/:"SYS_B_01") G_2, ROUND(G_3/:"SYS_B_02") G_3, ROUND(G_4/:"SYS_B_03") G_4, R OUND(G_5/:"SYS_B_04") G_5, ROUND(A_1/:"SYS_B_05") A_1, ROUND(A_2/:"SYS_B_06") A_2, ROUND(A_3/:"SYS_B_07") A_3, ROUND(A_4 /:"SYS_B_08") A_4, ROUND(A_5/:"SYS_B_09") A_5, LOG_NO, AE, ADVR, AGNC, OFFICE, POB_ID, POB_CREATE_DT, POB_STAT From (SE LECT DECODE(YEAR,:"SYS_B_10",NVL((DECODE(QTR,:"SYS_B_11",NVL(CURR_GOAL,:"SYS_B_12"))),:"SYS_B_13"),:"SYS_B_14") G_1,DECO DE(YEAR,:"SYS_B_15",NVL((DECODE(QTR,:"SYS_B_16",NVL(CURR_GOAL,:"SYS_B_17"))),:"SYS_B_18"),:"SYS_B_19") G_2,DECODE(YEAR,: "SYS_B_20",NVL((DECODE(QTR,:"SYS_B_21",NVL(CURR_GOAL,:"SYS_B_22"))),:"SYS_B_23"),:"SYS_B_24") G_3,DECODE(YEAR,:"SYS_B_25 ",NVL((DECODE(QTR,:"SYS_B_26",NVL(CURR_GOAL,:"SYS_B_27"))),:"SYS_B_28"),:"SYS_B_29") G_4,DECODE(YEAR,:"SYS_B_30",NVL((DE CODE(QTR,:"SYS_B_31",NVL(CURR_GOAL,:"SYS_B_32"))),:"SYS_B_33"),:"SYS_B_34") G_5,DECODE(YEAR,:"SYS_B_35",NVL((DECODE(QTR, :"SYS_B_36",NVL(CURR_ACCRUAL,:"SYS_B_37"))),:"SYS_B_38"),:"SYS_B ~ But I havn't figured out why query duration and SCN is shown any ideas? ... what is the significance? Oracle 9202, RAC TIA Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art !
