RE: Re: IOT Tuning Question

2003-11-21 Thread Stephane Faroult
Zhu Chao, You are right to say that with a heap organized table you also have the index to encumber the SGA and indeed you are right to say that, as I put it, what I said is not totally correct. I should have been more specific. The reference to _partitioned_ IOTs implicitly associated them

Re: Re: IOT Tuning Question

2003-11-21 Thread Jay
Zhu/SF: Thanks for your insight. I was under the impression that Oracle did not recommend IOT for tables that where not fairly static. Would the reasoning for this not being an issue in this case be due to oracle now having to only maintain the IOT table blocks instead of the table blocks and the

Re: RE: Parse Vs Execute

2003-11-26 Thread ryan_oracle
just gave benchmarks. do you know anymore? > > From: "Cary Millsap" <[EMAIL PROTECTED]> > Date: 2003/11/26 Wed PM 02:39:39 EST > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > Subject: RE: Parse Vs Execute > > Don't do this: >

Re: RE: Parse Vs Execute

2003-11-28 Thread Jared Still
By using DBMS_SQL you can open a cursor and re-execute as many times as needed. You can't do that with execute immediate. On Wed, 2003-11-26 at 12:04, [EMAIL PROTECTED] wrote: > i remember in tom kytes new book there is a 'softer parse' he was referring to using > dbms_s

Re: RE: Parse Vs Execute

2003-11-29 Thread Jared Still
On Fri, 2003-11-28 at 09:24, Jared Still wrote: > By using DBMS_SQL you can open a cursor and re-execute as many > times as needed. > > You can't do that with execute immediate. > > On Wed, 2003-11-26 at 12:04, [EMAIL PROTECTED] wrote: > > i remember in tom kyte

Re: RE: partitioning option licensing

2003-12-03 Thread ryan_oracle
t ORACLE-L <[EMAIL PROTECTED]> > Subject: RE: partitioning option licensing > > As of 9iR2, partitioning is still licensed separately as a $10K (retail) > extra charge per processor. So, the total retail comes to a painful $50K > per processor for 9i + Partitioning. Also,

RE: Antw: RE: Little competition

2003-12-11 Thread Jamadagni, Rajendra
No, you are not but I think Richard from down under is a big David Bowie fan !! Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts,

RE: Antw: RE: Little competition

2003-12-11 Thread Guido Konsolke
Yes, I know. That David Bowie stuff comes up every few weeks / months in several c.d.o. groups. But what are 'fans'? In my opintion they make wind ;-) Anyway, I like this competition thread - mostly because there's nothing but bulls**t coming from me. Greetings to the list, Guido >>> [EMAIL PR

Re: Re: Oracle's jdbc driver

2003-12-14 Thread bhabani s pradhan
Yes Thanks a lot regards b s pradhan On Sat, 13 Dec 2003 David Hau wrote : >The method you need is: OracleDatabaseMetaData.getDriverVersion() > >Write a small Java program to call this method, or take a look at Metalink note >94091.1 or 73629.1 for sample code to get JDBC driver version.

Re: Re: New TPC benchmarks

2003-12-15 Thread Nuno Pinto do Souto
> Mogens Nørgaard <[EMAIL PROTECTED]> wrote: > Today it's only a question of finding a sponsor for the benchmark. > Then > you can break any report. > It's not only today... It's been like that for the last 8 years or so. Basically: "Have $$$? Will win" is the entire philosophy of all this TP

Re: Re: New TPC benchmarks

2003-12-15 Thread Paul Drake
Nuno,   > The whole thing is an extravagant waste. I beg to differ. When I ask for 2 external storage units of 14 drives apiece (DAS), and they look at me like I obviously have no clue about their intentions of a 3 drive RAID something other than 10 config, a configuration that they can download ju

Re: Re: New TPC benchmarks

2003-12-15 Thread Paul Drake
what's really helpful about these, are the server tweaks made (if you deploy on win32).   check out http://www.tpc.org/results/FDR/TPCC/dell_2650_261103_fdr.pdf   Pg 170 - there's a list of all of the services that are disabled/stopped - 24 in all. Pg 224 - the section of the MS diagnostics report

Re: Re: New TPC benchmarks

2003-12-16 Thread Jonathan Lewis
I agree with the benefits of being able to wave benchmark papers around and saying "But look what they HAD to do !" The line from one of the HP ones (1M tpcc) that I really liked was: Most of the space on the arrays in the tested system was unused during the performance tests, but is available

Re: Re: New TPC benchmarks

2003-12-16 Thread Nuno Souto
they'll just ignore me and go buy whatever crap the IBM sales rep is flogging that week! Now, of course these documents are useful to find out what sorts of tricks they do re services in Windoze and so on. I've found those other ways. In fact, they are documented in M$'s Tech Notes.

(U) RE: RE: Hit Ratio

2003-12-22 Thread Johnson, Michael
12/22 Mon PM 02:14:26 EST > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > Subject: RE: Hit Ratio > > My BCHR is currently 96.62%. In the past, it was normally over 99%. What > should I do? > > I'll be waiting for Mladen's reply... :) >

Re: RE: A performance problem

2003-12-29 Thread ryan_oracle
nts of list ORACLE-L <[EMAIL PROTECTED]> > Subject: RE: A performance problem > > The other database in on a different server. > > I looked at the statspack report for the other database, for the time period in > question. > > Top 5 Timed Events > ~~

Re: RE: A performance problem

2003-12-29 Thread ryan_oracle
, Venu (CT Appl Suppt)" <[EMAIL PROTECTED]> > Date: 2003/12/29 Mon PM 01:14:34 EST > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > Subject: RE: A performance problem > > John, > > I can run this in our development environment and trace the j

Re: Re: Another OCP slant...

2003-07-17 Thread rgaffuri
certification they want experience PLUS certification. > > From: Jonathan Gennick <[EMAIL PROTECTED]> > Date: 2003/07/17 Thu PM 12:09:38 EDT > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > Subject: Re: Another OCP slant... > > Thursday, July 17,

RE: Re[2]: dba age

2003-07-23 Thread Purcell, Sandra
exactly... now, i have to say, there is the option to round up/down when necessary depending on how many gray hairs are showing through the hair color application and available room lighting... -Original Message- Sent: Wednesday, 23 July, 2003 12:15 To: Multiple recipients of list ORAC

RE: Re[2]: dba age

2003-07-23 Thread Gogala, Mladen
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 r

RE: Re[2]: dba age

2003-07-23 Thread Stephane Paquette
I'm young but my memory is already going away :( -Original Message- Gogala, Mladen Sent: Wednesday, July 23, 2003 5:20 PM To: Multiple recipients of list ORACLE-L Yup! SQL Protected Mode Executable, which loaded oracle above 1M boundary on 286 boxes. I believe that the last ones were p

Re: RE: Question on SGA

2003-07-28 Thread rgaffuri
recipients of list ORACLE-L <[EMAIL PROTECTED]> > Subject: RE: Question on SGA > > I'm expecting a lot of innovative answers for this question > > :-) > > > -Original Message- > > From: Senthil Kumar D [mailto:[EMAIL PROTECTED] > > Sent:

Re: RE: Question on SGA

2003-07-28 Thread Tanel Poder
gt; > if there is enough memory, Oracle will reserve its space from that first. > > > > From: "Naveen Nahata" <[EMAIL PROTECTED]> > > Date: 2003/07/28 Mon AM 07:59:24 EDT > > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>

Re: Re: 9i-OCP Question

2003-07-30 Thread rgaffuri
i didnt ask the question. I was responding. what is up with the attitude? > > From: Mladen Gogala <[EMAIL PROTECTED]> > Date: 2003/07/30 Wed PM 02:04:57 EDT > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > Subject: Re: 9i-OCP Question >

Re: RE: 9i-OCP Question

2003-07-30 Thread rgaffuri
half responding to make sure I understand it correctly. > > From: "Pardee, Roy E" <[EMAIL PROTECTED]> > Date: 2003/07/30 Wed PM 03:14:30 EDT > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > Subject: RE: 9i-OCP Question > > I t

Re: Re: 9i-OCP Question

2003-07-30 Thread rgaffuri
yeah that might be the right answer, but you would get it wrong on the OCP... assuming the books are right. > > From: Peter Gram <[EMAIL PROTECTED]> > Date: 2003/07/30 Wed PM 04:09:28 EDT > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > Subject:

Re: RE: Question on views

2003-08-14 Thread rgaffuri
[EMAIL PROTECTED]> > Date: 2003/08/12 Tue AM 11:24:42 EDT > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > Subject: RE: Question on views > > > you mixed a lot of functional information in your question, so > > its difficult to follow the exact '

Re: RE: Question on views

2003-08-14 Thread rgaffuri
nts of list ORACLE-L <[EMAIL PROTECTED]> > Subject: RE: Question on views > > > you mixed a lot of functional information in your question, so > > its difficult to follow the exact 'oracle' question you are asking. > > Sorry, but I'm still learning. > >

Re: RE: OCP Architecture question

2003-08-15 Thread rgaffuri
yeah thats what i figured... but having these certifications are good for my career. thanks. I figured it was a stupid question. > > From: "Cary Millsap" <[EMAIL PROTECTED]> > Date: 2003/08/15 Fri AM 01:14:23 EDT > To: Multiple recipients of list ORACLE-L <[EMAIL

Re: RE: OCP Architecture question

2003-08-15 Thread rgaffuri
t ORACLE-L <[EMAIL PROTECTED]> > Subject: RE: OCP Architecture question > > Ryan, > > I will research the answer but I have an urgent question. > > Do you have SelfTest Software for the SQL and PL/SQL test or do you have the > Architecure and Administration Self

RE: RE: OCP Architecture question

2003-08-15 Thread DENNIS WILLIAMS
Millsap" <[EMAIL PROTECTED]> > Date: 2003/08/15 Fri AM 01:14:23 EDT > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > Subject: RE: OCP Architecture question > > With respect to evaluating answer number one, it's a bad question, > because you have kn

Re: Re: OT - Linux books ??

2003-08-26 Thread rgaffuri
> Date: 2003/08/26 Tue AM 08:54:29 EDT > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > Subject: Re: OT - Linux books ?? > > Both are good but the second on your list is particularly useful for > admin work. In my opinion, the first is more of a getting

Re: Re: OT - Linux books ??

2003-08-26 Thread Nuno Souto
- Original Message - > how different is it to administer oracle on different flavors of unix? Im running > into some annoying nuassances in syntax between solaris korn shell and hp-unix korn shell. > > is it just little syntax differences or is there alot more to it? > > You sure it's HP

Re: Re: OT - Linux books ??

2003-08-26 Thread rgaffuri
such things as monitoring I/O, etc... Systems Admin and DBA work overlaps. is it alot different on different unix systems? > > From: Joe Testa <[EMAIL PROTECTED]> > Date: 2003/08/26 Tue AM 09:44:33 EDT > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > Su

Re: Re: OT - Linux books ??

2003-08-26 Thread rgaffuri
08/26 Tue AM 09:59:33 EDT > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > Subject: Re: Re: OT - Linux books ?? > > - Original Message - > > > how different is it to administer oracle on different flavors of unix? Im running > > into some anno

RE: Re: OT - Linux books ??

2003-08-26 Thread Kevin Toepke
fferent on different unix systems? > > From: Joe Testa <[EMAIL PROTECTED]> > Date: 2003/08/26 Tue AM 09:44:33 EDT > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > Subject: Re: OT - Linux books ?? > > administering oracle is not really an issue caus

RE: Re: OT - Linux books ??

2003-08-26 Thread Mladen Gogala
Well, IBM has AIX, a very solid and stable version of unix which works really well. SCO has become very popular lately and using SCO Unix will turn you into the most popular guy on this list. Then there is Irix, made by SGI. HP actually has several unix versions Tru64, HP-UX, Tandem Unix, Ultrix,

RE: Re: OT - Linux books ??

2003-08-26 Thread Matthew Zito
den Gogala > Sent: Tuesday, August 26, 2003 12:24 PM > To: Multiple recipients of list ORACLE-L > Subject: RE: Re: OT - Linux books ?? > > > Well, IBM has AIX, a very solid and stable version of unix > which works really > well. SCO has become very popular lately and us

RE: Re: OT - Linux books ??

2003-08-26 Thread rgaffuri
i thought linux was just unix designed to run on a PC. how different is the kernel? > > From: "Matthew Zito" <[EMAIL PROTECTED]> > Date: 2003/08/26 Tue PM 01:24:26 EDT > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > Subject: RE: Re: OT -

RE: Re: OT - Linux books ??

2003-08-26 Thread Mladen Gogala
l: [EMAIL PROTECTED] Cell: 646-220-3551 Phone: 212-358-8211 x 359 http://www.gridapp.com > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On > Behalf Of Mladen Gogala > Sent: Tuesday, August 26, 2003 12:24 PM > To: Multiple recipients of list

RE: Re: OT - Linux books ??

2003-08-26 Thread Thater, William
Mladen Gogala scribbled on the wall in glitter crayon: > AIX phased out in favor of Linux? I believe that SCO asked for > injunction to prevent IBM > from distributing AIX, and there is a whole saga around SCO and Linux. > According to some, > Unix variants are like higlanders: there can be only

RE: Re: OT - Linux books ??

2003-08-26 Thread Matthew Zito
gt; From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On > Behalf Of [EMAIL PROTECTED] > Sent: Tuesday, August 26, 2003 1:40 PM > To: Multiple recipients of list ORACLE-L > Subject: RE: Re: OT - Linux books ?? > > > i thought linux was just unix designed to run on a PC. how >

RE: Re: OT - Linux books ??

2003-08-26 Thread Matthew Zito
PROTECTED] Cell: 646-220-3551 Phone: 212-358-8211 x 359 http://www.gridapp.com > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On > Behalf Of Mladen Gogala > Sent: Tuesday, August 26, 2003 1:44 PM > To: Multiple recipients of list ORACLE-L > Subjec

RE: Re: OT - Linux books ??

2003-08-26 Thread Mladen Gogala
s the kernel? > > From: "Matthew Zito" <[EMAIL PROTECTED]> > Date: 2003/08/26 Tue PM 01:24:26 EDT > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > Subject: RE: Re: OT - Linux books ?? > > > And of course, there's the other free UNIX

RE: Re: OT - Linux books ??

2003-08-26 Thread rgaffuri
linux from unix? > > From: "Mladen Gogala" <[EMAIL PROTECTED]> > Date: 2003/08/26 Tue PM 02:34:28 EDT > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > Subject: RE: Re: OT - Linux books ?? > > Different from what? It's very d

Re: Re: OT - Linux books ??

2003-08-26 Thread Tanel Poder
PM > i thought linux was just unix designed to run on a PC. how different is the kernel? > > > > From: "Matthew Zito" <[EMAIL PROTECTED]> > > Date: 2003/08/26 Tue PM 01:24:26 EDT > > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> >

Re: Re: OT - Linux books ??

2003-08-26 Thread Tanel Poder
o:[EMAIL PROTECTED] On > > Behalf Of Mladen Gogala > > Sent: Tuesday, August 26, 2003 12:24 PM > > To: Multiple recipients of list ORACLE-L > > Subject: RE: Re: OT - Linux books ?? > > > > > > Well, IBM has AIX, a very solid and stable version of unix > >

RE: Re: OT - Linux books ??

2003-08-26 Thread Mladen Gogala
Define "based"? -- Mladen Gogala Oracle DBA -Original Message- Tanel Poder Sent: Tuesday, August 26, 2003 4:44 PM To: Multiple recipients of list ORACLE-L AFAIK, Apples unix is based on [Open|Free]BSD as well. Tanel. Note: This message is for the named person's use only. It ma

Re: Re: OT - Linux books ??

2003-08-27 Thread Tanel Poder
Hi! Mac OS X has modified mach microkernel, FreeBSD userspace, FreeBSD & NetBSD drivers and Aqua user interface. from http://developer.apple.com/darwin "Beneath the appealing, easy-to-use interface of Mac OS X is a rock-solid foundation that is engineered for stability, reliability, and performa

RE: RE: display x square

2003-08-27 Thread Guido Konsolke
Hi, eeh, sorry but your 1. post says: 'I need to display' now, your 1. post says: 'I don't want to display'. Would you please tell us what you really want / need. And (as Naveen wrote: where). Still headscratching, Guido -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Autho

Re: Re: OT - Linux books ??

2003-08-27 Thread Nuno Souto
Apart form all the others you've already heard about, Fujitsu and some of their subsidiaries also have their own Unix flavour. I believe Unisys and NCR also have their own. Cheers Nuno Souto [EMAIL PROTECTED] - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECT

RE: RE: display x square

2003-08-27 Thread Stephane Faroult
I am afraid you are totally off-topic. This is not a database problem, it is a character set problem. Check the character set you are using, there may be, among those weird characters outside the 'usual' ranges, a tiny little 2 hanging up. Note down the character number, say n, and store 'x' ||

Re: RE: display x square

2003-08-27 Thread Tanel Poder
 > Store it as 'x ** 2' and everybody will understand. Or store it in two rows, one row is ' 2' and second one is 'x'   SQL> select ' 2' || chr(10) || 'x' SQR from dual;   SQR 2x ;)   Tanel.  

RE: RE: display x square

2003-08-27 Thread manoj . gurnani
I am not offtopic. Mq question was to display the notation x superscript 2 as written down in paper. -Original Message- Stephane Faroult Sent: Wednesday, August 27, 2003 6:19 PM To: [EMAIL PROTECTED] I am afraid you are totally off-topic. This is not a database problem, it is a charac

RE: RE: display x square

2003-08-27 Thread DENNIS WILLIAMS
Manoj I agree entirely with Stephane. For most of us the display is based on the ASCII character set, which doesn't have the character you desire. If you go beyond ASCII, then you are in the "device-dependent" region. For example, if you wanted to print this on an HP laser printer, then you'd ne

RE: Re: OT - Linux books ??

2003-08-28 Thread Niall Litchfield
> The Linux kernel is totally different, though you will find > some code in it that is from System 4 UNIX. And maybe even from SCO Niall -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Niall Litchfield INET: [EMAIL PROTECTED] Fat City Network Services-- 858

RE: RE: Question about Constraint

2003-08-29 Thread Stephane Faroult
Cannot be since you are allowed to have the same companynumber several times for type 2 - but you are right in refering to 'id' - in fact the design is faulty. Quite obviously the 'type' is an attribute of the company, not of the employee. There is no way but a trigger to check it, but it should

Re: RE: Oracle on Win2000

2003-09-04 Thread Prem Khanna J
Bala,my reply is also the same as John said. "PC Anywhere or the console straightaway" Jp. 04-09-2003 17:34:26, "Hallas, John, Tech Dev" <[EMAIL PROTECTED]> wrote: >PC Anywhere or direct from the console -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Prem Khanna J

RE: RE: Oracle on Win2000

2003-09-04 Thread Brian Dunbar
Prem Khanna J [mailto:[EMAIL PROTECTED] on Thursday, September 04, 2003 4:05 AM said; > Bala,my reply is also the same as John said. > "PC Anywhere or the console straightaway" My favorite for remote console access on W2K is TightVNC - http://www.tightvnc.com/ - or the 'ol standby, NetMeeting. W

Re: RE: Oracle Masters exam

2003-09-04 Thread rgaffuri
t ORACLE-L <[EMAIL PROTECTED]> > Subject: RE: Oracle Masters exam > > So, it's nothing like OCP where you get the certification when you spew out > certain amount of the green stuff? I wonder how long will it take before > seeing > oracle masters who don't know

Re: RE: Oracle Masters exam

2003-09-04 Thread rgaffuri
s of list ORACLE-L <[EMAIL PROTECTED]> > Subject: RE: Oracle Masters exam > > > I though about trying to figure out how to get it to be a write off... > > I'm not sure how taking an advanced class will help me to pass the test... I > kind of would like to take it

Re: RE: Oracle Masters exam

2003-09-04 Thread rgaffuri
t ORACLE-L <[EMAIL PROTECTED]> > Subject: RE: Oracle Masters exam > > Well, I've had the luxury of not only not paying for any of the > certification, but actually being paid to DO the certification: > > 7.3 - original certification as an Oracle instructor paid for by Oracl

RE: RE: Oracle Masters exam

2003-09-04 Thread Pete Sharman
. Well written and concise. Your 8i book is still on the market even though coriolis went under? > > From: "Pete Sharman" <[EMAIL PROTECTED]> > Date: 2003/09/04 Thu PM 02:49:26 EDT > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > Subject: RE:

RE: RE: Oracle Masters exam

2003-09-04 Thread Boivin, Patrice J
n" <[EMAIL PROTECTED]> > Date: 2003/09/04 Thu PM 02:49:26 EDT > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > Subject: RE: Oracle Masters exam > > Well, I've had the luxury of not only not paying for any of the > certification, but

RE: RE: Oracle Masters exam

2003-09-04 Thread Mladen Gogala
ket even though coriolis went under? > > From: "Pete Sharman" <[EMAIL PROTECTED]> > Date: 2003/09/04 Thu PM 02:49:26 EDT > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > Subject: RE: Oracle Masters exam > > Well, I've had the luxury of not

RE: RE: Oracle Masters exam

2003-09-04 Thread Freeman Robert - IL
recipients of list ORACLE-L <[EMAIL PROTECTED]> > Subject: RE: Oracle Masters exam > > Well, I've had the luxury of not only not paying for any of the > certification, but actually being paid to DO the certification: > > 7.3 - original certification as an Oracle instruct

Re: Re: Oracle Masters exam

2003-09-05 Thread rgaffuri
y and need people to do what you want. Its not your fault other people hold it in such high value. I have no control over them. > > From: "Nuno Souto" <[EMAIL PROTECTED]> > Date: 2003/09/05 Fri AM 08:20:13 EDT > To: Multiple recipients of list ORACLE-L <[EMAIL PROTE

Re: RE: Oracle Script Documentation

2003-09-05 Thread rgaffuri
EDT > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > Subject: RE: Oracle Script Documentation > > Jay >Here is your chance to join the big league and become an expert in your > own area. One thing I've noticed in tracing the scripts is that many of the

Re: Re: Oracle Masters exam

2003-09-08 Thread rgaffuri
what do they have you do? you set up a database where everything that can go wrong does go wrong with no access to documentation right? > > From: "Tanel Poder" <[EMAIL PROTECTED]> > Date: 2003/09/08 Mon AM 09:44:27 EDT > To: Multiple recipients of list ORACLE-L <[

RE: Re: Oracle Masters exam

2003-09-08 Thread Pete Sharman
r" <[EMAIL PROTECTED]> > Date: 2003/09/08 Mon AM 09:44:27 EDT > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > Subject: Re: Oracle Masters exam > > Thanks Patrice. > Yes, the exam was challenging, I've never typed and thought that fast >

RE: Re: Oracle Masters exam

2003-09-08 Thread T Nguyen
o wrong with no access to documentation right? > > From: "Tanel Poder" <[EMAIL PROTECTED]> > Date: 2003/09/08 Mon AM 09:44:27 EDT > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > Subject: Re: Oracle Masters exam > > Thanks Patrice. > Ye

RE: Re: Oracle Masters exam

2003-09-08 Thread Boivin, Patrice J
access to documentation right? > > From: "Tanel Poder" <[EMAIL PROTECTED]> > Date: 2003/09/08 Mon AM 09:44:27 EDT > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > Subject: Re: Oracle Masters exam > > Thanks Patrice. > Yes, the exam was

Re: Re: Oracle Masters exam

2003-09-08 Thread rgaffuri
how many ocms are there world wide? > > From: "GovindanK" <[EMAIL PROTECTED]> > Date: 2003/09/08 Mon PM 02:49:26 EDT > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > Subject: Re: Oracle Masters exam > > Congrats Tanel on becomi

RE: Re: Oracle Masters exam

2003-09-08 Thread Mladen Gogala
Too many. -- Mladen Gogala Oracle DBA > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On > Behalf Of [EMAIL PROTECTED] > Sent: Monday, September 08, 2003 3:40 PM > To: Multiple recipients of list ORACLE-L > Subject: Re: Re: Oracle Master

Re: Re: Oracle Masters exam

2003-09-08 Thread Tanel Poder
; Behalf Of [EMAIL PROTECTED] > > Sent: Monday, September 08, 2003 3:40 PM > > To: Multiple recipients of list ORACLE-L > > Subject: Re: Re: Oracle Masters exam > > > > > > how many ocms are there world wide? > > > > > Note: > This me

RE: Re: Oracle Masters exam

2003-09-09 Thread Mark Leith
many. > > -- > Mladen Gogala > Oracle DBA > > > > > -Original Message- > > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On > > Behalf Of [EMAIL PROTECTED] > > Sent: Monday, September 08, 2003 3:40 PM > > To: Multiple recipients of list

Re: Re: Oracle Masters exam

2003-09-09 Thread Nuno Souto
will you CEASE to give them more ideas on how to bleed the customer base dry? You say too many, they go and create another qualification even more expensive... :D Cheers Nuno Souto [EMAIL PROTECTED] - Original Message - > Too many. > > > > -Original Message- > > From: [EMAIL PR

Re: RE: RAC on linux

2003-02-03 Thread chao_ping
hi, When you want to apply patch for your db on linux, for example, 9202, it need the hangcheck module. and this module need the redhat advanced server kernel, so if you do your rac with rh8, Can you still apply the patch? And it is beyond the support of oracle support, when you run into bug,

Re: RE: Oracle TEMPORARY SEGMENT

2003-02-11 Thread chao_ping
Whittle Jerome Contr NCI, I think your sql should not work on a really TEMPORARY tablespace, and temporary tablespace do not need to be cleaned either. Regards zhu chao msn:[EMAIL PROTECTED] www.happyit.net www.cnoug.org(China Oracle User Group) === 2003-02-11 06:49:00 ,

RE: RE: Oracle TEMPORARY SEGMENT

2003-02-11 Thread Whittle Jerome Contr NCI
Title: RE: RE: Oracle TEMPORARY SEGMENT Hi, It does work on temporary (that are truly temporary and not permanent) tablespaces in 7.3.4 and 8.1.7. I use it when I don't want to wait for SMON to clean things up. Just yesterday one our 'power users' ran SQL that selected from

RE: RE: Oracle TEMPORARY SEGMENT

2003-02-11 Thread M Rafiq
Jerry, Your sql will never run on Temp tablespace 'that are truly temporary' in 8.1.7 Just see the results Oracle8i Enterprise Edition Release 8.1.7.2.0 - Production With the Partitioning option JServer Release 8.1.7.2.0 - Production SQL> alter tablespace temp default storage(pctincrea

RE: RE: Oracle TEMPORARY SEGMENT

2003-02-11 Thread Whittle Jerome Contr NCI
Title: RE: RE: Oracle TEMPORARY SEGMENT Rafiq, I'm not using locally managed tablespaces just yet. If the definition of  'truly temporary'  includes locally managed tablespace, then you are correct. Thanks for keeping me on the straight and narrow. Jerry Whittle A

RE: RE: Oracle TEMPORARY SEGMENT

2003-02-11 Thread M Rafiq
Jerry, It was just for update. True temporary tablespace cannot be created using datafile(dictionery managed) but tempfile which is allowable by locally managed tablespace. I just tried to create it with datafile but it gave me error. Here, on this list we are learning everyday something new

Re: Re[2]: Oracle Tools

2003-03-05 Thread Chuck Hamilton
Know what you mean about coverage. I was up at Bretton Woods NH skiing over the Christmas holidays and couldn't get a cell phone to work until I at all. Not sure if that was a bad thing though :-). - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: We

Re: Re[2]: Oracle Tools

2003-03-05 Thread Chuck Hamilton
Also have a look at MobileLynX. Can't figure out for the life of me why the don't advertise this thing. It does most if not all of what PocketDBA does but is also user extensible. It's actually an XML engine but they provide scripts for managing Unix and Oracle as part of the package. If you want t

Re: RE: Value of OCP

2003-03-19 Thread rgaffuri
PROTECTED]> > Date: 2003/03/19 Wed PM 02:10:42 EST > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > Subject: RE: Value of OCP > > Depends on the orginazation. > > Some organizations are rigid seniority based traditionaly managed > where it does not

Re: RE: Value of OCP

2003-03-19 Thread Darrell Landrum
ople have said so and so has an OCP so they know what they are doing. Ive also seen some jobs that require OCPs. Not tons, but a few. > > From: Lyndon Tiu <[EMAIL PROTECTED]> > Date: 2003/03/19 Wed PM 02:10:42 EST > To: Multiple recipients of list ORACLE-L <[EMAIL

RE: RE: Value of OCP

2003-03-20 Thread Orr, Steve
Title: RE: RE: Value of OCP Red Green, my hero!!! http://www.ducttapeforever.com/forever.html -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 20, 2003 8:59 AM To: Multiple recipients of list ORACLE-L Subject: Re:RE: Value of OCP Good

RE: RE: Value of OCP

2003-03-20 Thread Jeremy Pulcifer
Title: Message If the ladies can't find you handsome, at least let them find you handy! -Original Message-From: Orr, Steve [mailto:[EMAIL PROTECTED] Sent: Thursday, March 20, 2003 8:54 AMTo: Multiple recipients of list ORACLE-LSubject: RE: RE: Value of OCP Red

RE: RE: Value of OCP

2003-03-20 Thread Paula_Stankus
Title: RE: RE: Value of OCP Personally I like the old glue gun - well okay, watch out for electricity surges whilst deploying the glue gun method.  However, really useful for most kid related things - wip up a costume in no time, fix that plastic toy, diaper to cheap to stick - the glue gun

Re[2]: RE: New DBA.

2003-03-20 Thread dgoulet
EST > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > Subject: RE: New DBA. > > Pat >Not to be impolite, but what makes you think this is the next logical > career move for you? Before you become a DBA it is good if you have a lot of > other compu

RE: RE: Value of OCP

2003-03-20 Thread Rachel Carmichael
remind me to tell you about my glue-gun related accident.. never ever try to brush the hot glue off your hand! --- [EMAIL PROTECTED] wrote: > Personally I like the old glue gun - well okay, watch out for > electricity > surges whilst deploying the glue gun method. However, really useful > for >

RE: RE: Value of OCP

2003-03-20 Thread Paula_Stankus
Title: RE: RE: Value of OCP You sure that isn't spackle you are talking about?  Oracle OCP DBA -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 20, 2003 10:59 AM To: Multiple recipients of list ORACLE-L Subject: Re:RE: Value o

RE: RE: Value of OCP

2003-03-20 Thread Orr, Steve
  OK, done with OT.   -Original Message-From: Jeremy Pulcifer [mailto:[EMAIL PROTECTED]Sent: Thursday, March 20, 2003 11:04 AMTo: Multiple recipients of list ORACLE-LSubject: RE: RE: Value of OCP If the ladies can't find you handsome, at least let them find you handy!

Re: RE: Locally Managed Tablespaces

2003-03-21 Thread rgaffuri
nts of list ORACLE-L <[EMAIL PROTECTED]> > Subject: RE: Locally Managed Tablespaces > > Once you set to uniform extents, pctincrease will default to 0. > > Most Oracle gurus advise to just use uniform extents for all situations. > > -Original Message- > Sent:

RE: RE: Locally Managed Tablespaces

2003-03-21 Thread Jacques Kilchoer
Title: RE: RE: Locally Managed Tablespaces > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] > > thanks in case I happen to work on a 7.3 database > > what kind of pctincrease should I set? What about the other > settings? Just cu

Re: RE: Locally Managed Tablespaces

2003-03-21 Thread Rachel Carmichael
TED]> > > Date: 2003/03/21 Fri PM 12:54:41 EST > > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > > Subject: RE: Locally Managed Tablespaces > > > > Once you set to uniform extents, pctincrease will default to 0. > > > > M

RE: RE: Locally Managed Tablespaces

2003-03-21 Thread Jared . Still
gt; Sent by: [EMAIL PROTECTED] 03/21/2003 11:00 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject:RE: RE: Locally Managed Tablespaces > -Original Message- > From: [EMAIL PROTECTED] [ma

Re: RE: Locally Managed Tablespaces

2003-03-21 Thread Jonathan Lewis
For 7.3 it is also important to set MINIMUM EXTENT for the tablespace to match the initial and next - then every extent has to be at worst a multiple of the minimum extent size whatever a rogue user does. Regards Jonathan Lewis http://www.jlcomp.demon.co.uk For one-day tutorials: (see http://ww

RE: RE: Locally Managed Tablespaces

2003-03-21 Thread Jacques Kilchoer
Title: RE: RE: Locally Managed Tablespaces > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] > > I think my 'reasonable' # of extents must be higher than > yours Jacques. :) I agree that having a datafile autoextend is better than

<    5   6   7   8   9   10   11   12   13   14   >