--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Prem Khanna J
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
Dennis,
Excellent recommendation, Guy Harrison's book (2nd Edition) is excellent the
best I've seen on SQL tuning. I've used it for a number of years. I had the
1st edition and then bought the 2nd when it came out.
Cheers,
Chris
-Original Message-
Sent: 29 October 2003 15:49
To:
Jared
Thanks for the response. I've had a play and here are the conclusions: -
1) The cache controlled by session_cached_cursors is entirely separate from
the pl/sql static cursor cache. You can turn the former off by setting
session_cached_cursors to zero, but you can only turn the latter off
And since we all know that memory accesses are
~14k times faster than disk, these benchmarks
just drive the point home.
Of course you talk about raw memory access vs. raw disk access here...
When you have several memory protection and disk caching mechanisms these
figures will change..
Tanel.
Anyone noticed www.dbazine.com...
This domain has temporarily been disabled.
To restore the domain, contact your Customer Support.
Ooops...
=
Connor McDonald
web: http://www.oracledba.co.uk
web: http://www.oaktable.net
email: [EMAIL PROTECTED]
GIVE a man a fish and he will eat for a day.
Yep, and it has been like that for several days already
Tanel.
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Friday, November 28, 2003 3:34 PM
Anyone noticed www.dbazine.com...
This domain has temporarily been disabled.
To restore the
Title: RE: analyze after truncate
I once took over an old database which hadn't been analyzed in nearly a year, so I started analyzing it every two weeks. For the most part things stayed the same or got faster; however, one procedure would sometimes, only sometimes, take a lot longer. Come
maybe its running on sql server?
From: Connor McDonald [EMAIL PROTECTED]
Date: 2003/11/28 Fri AM 08:34:25 EST
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: Semi-OT...dbazine
Anyone noticed www.dbazine.com...
This domain has temporarily been disabled.
To restore
Tanel - Thanks! That is sort of what I did. I shut down the listener and let
them start the other process that wanted port 8080. Then I restarted the
listener and it griped because it couldn't have that port, but everything
else seemed to come up okay. I don't like rude surprises just as I had my
And I thought that all old people knew cobol ;-)
I'll try to think of a solution that does involve creating many tables per redefine
statement.
Stephane Paquette
Administrateur de bases de donnees
Database Administrator
Standard Life
www.standardlife.ca
Tel. (514) 499-7999 poste 7470
Hi List,
In our DB we see huge number of softparses during the load test. So I thought of
setting SESSION_CACHED_CURSORS parameter to positive number(100) to take
advantage of SOFTER SOFT PARSE. But I am getting negative impact.
Kindly advice me what is going on here.
Version :8.1.7.3
OS: Sun
Sorry can't help with the when did it happened question.
But in defense of the SysAdmin, I have seen the benefits of defraging on
both Unix and NT.
In the NT case the defraging was caused by lots of small fragments caused
by the datafile being auto extended in short increments, and that being
Michael:
You can find this layout in the book Oracle8i DBA Handbook by Kevin Loney
Marlene Theriault. Chapter 4 discusses this scenario in detail. Going
from the optimum of 22 disks to the minimum of 7. You can probably find it
in other text books.
Hope this helps,
Ken Janusz, CPIM
-
At 06:49 28-11-03 -0800, you wrote:
And I thought that all old people knew cobol ;-)
I'll try to think of a solution that does involve creating many tables per
redefine statement.
I thought you needed every redefine in the same table? So you mean 'many
into table clauses' ISO 'many
Perhaps you missed the sarcasm in my response.
On Fri, 2003-11-28 at 03:14, Tanel Poder wrote:
And since we all know that memory accesses are
~14k times faster than disk, these benchmarks
just drive the point home.
Of course you talk about raw memory access vs. raw disk access here...
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_sql instead of execute
Sorry, it was a typo, I meant a solution that does not involve creating many tables
per
redefine statement.
Stéphane
-Original Message-
Carel-Jan Engel
Sent: 28 novembre, 2003 11:49
To: Multiple recipients of list ORACLE-L
At 06:49 28-11-03 -0800, you wrote:
And I thought that all
At 10:29 28-11-03 -0800, you wrote:
Sorry, it was a typo, I meant a solution that does not involve creating
many tables per
redefine statement.
Stéphane
Allright, success!
Regards, Carel-Jan
-- There will allwasy be another 10 last bugs --
--
Please see the official ORACLE-L FAQ:
Title: OT - MVS / Java / Oracle 9iAS
I am a Java-idiot.
I am hoping some of the brilliant people on this list can help me
A developer came to me with a problem they are having.
He is setting up a JVM to run under USS (Unix System Services) on OS/390 v2.10
He has java code that uses
Well, all of those benchmarks could be summarized in a single sentence:
Oracle is the best, ite missa est.
On 11/28/2003 12:19:25 PM, Jared Still wrote:
Perhaps you missed the sarcasm in my response.
On Fri, 2003-11-28 at 03:14, Tanel Poder wrote:
And since we all know that memory accesses
It's solved. The oci-code
must be changed when going from oracle 7 to
Oracle 8 or 9. When a sequence.nextval is called using
a float_type you get returned
Duplicates. Not only the type of
column returned must be changed but the buffer etc .. also
Thanks,
Jeroen
LG,
Any pointers, white
papers, URL, etc.on how to replicate data from Oracle 8i/9i to
M$-SQL2K?
Many
thanks,
Nick Khimani
Sujatha - If it helps, we have Tru64 and 8.1.6 here. My sys admin has
defragged the disk quite a few times with no apparent ill effects.
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Thursday, November 27, 2003 7:59 PM
To: Multiple recipients of list
Patrice - By technical, do you mean a feature comparison or a performance
comparison. You might want to research the eWeek benchmark for the three a
couple of years ago. They made extensive efforts to produce an objective
performance analysis, but even at that they had another article later about
Ignore
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: viraj2
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
ignore
viraj2 wrote:
Ignore
--
Joseph S Testa
Chief Technology Officer
Data Management Consulting
614-791-9000
It's all about the CACHE
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Joe Testa
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051
26 matches
Mail list logo