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
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
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:
>
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
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
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,
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,
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
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.
> 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
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
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
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
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.
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... :)
>
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
> ~~
, 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
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,
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
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
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
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:
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]>
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
>
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
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:
[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 '
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.
> >
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
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
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
> 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
- 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
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
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
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
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,
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
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 -
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
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
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
>
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
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
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
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]>
>
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
> >
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
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
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
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
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' ||
> 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.
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
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
> 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
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
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
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
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
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
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
. 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:
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
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
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
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
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
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 <[
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
>
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
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
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
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
; 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
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
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
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,
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 ,
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
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
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
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
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
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
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
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
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
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
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
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
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
>
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
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!
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:
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
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
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
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
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
901 - 1000 of 64849 matches
Mail list logo