Easy,
A new formula for the hit ratio
Regards
Jonathan Lewis
http://www.jlcomp.demon.co.uk
The educated person is not the person
who can answer the questions, but the
person who can question the answers -- T. Schick Jr
One-day tutorials:
http://www.jlcomp.demon.co.uk/tutorial.html
- Original Message -
Actually, it isn't SAP. I was simply creating a set of MV's
based on SAP tables in another database.
Fair enough.
I wonder what I need to tune to fix this?
stop creating those tables?
D
Seriously: aren't you getting the I/O as mostly writes during the
It's the Best of Breed versus One Vendor debate, and there are pros and
cons galore.
The perfect scenario, of course, is when they combine, so one vendor
delivers the best of everything. That's what we have with Microsoft,
isn't it? ;-) : Office stuff, OS, Database, ERP, CRM, video player,
Ah yes, you could introduce heuristically (spelling?!) skewed hit
ratios. As Dave Ensor explained at UKOUG, the word heuristic in
Oracle's optimizer code can be translated directly into constant. So
add a number here or there until it fits.
Mogens
Jonathan Lewis wrote:
Easy,
A new formula
When you use alter system archive log current, then your (foreground)
session will do the archiving, thus leaving a FGRD record in your
v$archived_log view.
Tanel.
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Friday, December 12, 2003 7:49 PM
Hello list, I am using 9.2.0.1.0 enterprise edition on windows.
Earlier when I use to specify nls_lang=French_France.US7ASCII in 9i release
1
I would get the following messages in French
c: sqlplus
Entrez le nom utilisateur :
But now when I specify nls_lang=French_France.US7ASCII , sqlplus
Does anyone know if the ANSI join syntax (LEFT OUTER JOIN, RIGHT OUTER JOIN, instead
of (+) =, etc.) was backported to 8i?
Ciao
Fuzzy
:-)
--
The contents of this post are my opinions only
If swallowed seek medical advice
--
Please see the
Sunday, December 21, 2003, 7:14:27 PM, Grant Allen ([EMAIL PROTECTED]) wrote:
GA Does anyone know if the ANSI join syntax (LEFT OUTER JOIN, RIGHT OUTER JOIN,
instead of (+) =,
GA etc.) was backported to 8i?
No, it was not.
Best regards,
Jonathan Gennick --- Brighten the corner where you are
-Original Message-
From: Jonathan Gennick [mailto:[EMAIL PROTECTED]
Sent: Monday, 22 December 2003 11:59
To: Multiple recipients of list ORACLE-L
Subject: Re: ANSI join syntax and Oracle 8i
Sunday, December 21, 2003, 7:14:27 PM, Grant Allen
([EMAIL PROTECTED]) wrote:
GA Does
I have said it on this list before, and I will say it again. With Oracle,
quality ends with in 4.
7.3.4
8.1.7.4
9.2.0.4
Oracle v9.2.0.4 is fairly stable. I have had to apply only 1, one-off
patch related to having 1000's of partitions. You may also want to add the
following
At lease 9.2.0.5 will be released by oracle.
I have seen some note talking about 9.2.0.5 patchset.
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Monday, December 22, 2003 12:49 PM
I have said it on this list before, and I will say it again.
I don't, but perhaps Lex does? He's crazy about that Join stuff and even
has a whole one-day class on mathematical methods in SQL. Also, he has
written a book on SQL, that still sells well - but it's in Dutch, so
you'd have to learn that language first :).
Lex - welcome to the Oracle-L list
12 matches
Mail list logo