If it would be a preprocessor define, you wouldn't see it.
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Saturday, September 13, 2003 3:39 PM
> Connor rules.
>
> Tim Gorman wrote:
>
> >I've performed "nm -o oracle" and "strings -a oracle" on t
Connor rules.
Tim Gorman wrote:
I've performed "nm -o oracle" and "strings -a oracle" on the Oracle
executable, searching for the phrase "sstiomax" to no avail. To me, that
implies that SSTIOMAX is not a variable in the "C" program that is Oracle.
Instead, by C programmer conventions, any name e
Another member of this list was once (possibly still is?) responsible for an
application with a database whose DB_BLOCK_SIZE was set to 4608. Mind you,
it was most certainly not their choice, but instead was mandated by the
vendor.
The reasoning for the setting? A "very important" table in this
Great. Can keep lots of blocks in the buffer pool. Hit ratio is at 110%
Try it out some time.
At 07:49 AM 9/13/2003 -0800, you wrote:
Wolfgang, please let us know how those 8-byte database blocks work for you,
OK?
Wolfgang Breitling
Centrex Consulting Corporation
http://www.centrexcc.com
--
Please
I've performed "nm -o oracle" and "strings -a oracle" on the Oracle
executable, searching for the phrase "sstiomax" to no avail. To me, that
implies that SSTIOMAX is not a variable in the "C" program that is Oracle.
Instead, by C programmer conventions, any name expressed in all upper-case
would m
How can we find the value of SSTIOMAX ?(What is it for
9i ?)
Thanks,
Ravi.
--- Tim Gorman <[EMAIL PROTECTED]> wrote:
> There is a MetaLink article #131530.1 on the
> constant SSTIOMAX which may
> provide some interesting reading on this topic
> surround "max I/O size" and
> the setting of DBFMRC.
There is a MetaLink article #131530.1 on the constant SSTIOMAX which may
provide some interesting reading on this topic surround "max I/O size" and
the setting of DBFMRC. The article is over 2 years old -- not sure if it
pertains to 9i or above...
Wolfgang, please let us know how those 8-byte dat
db_block_size=8, db_file_multiblock_read_count = 32
That is a Peoplesoft ERP system, a hybrid of oltp and dss with heavy
reporting activity at month end. The dfmrc value was established through
trial and 10053 trace analysis. Some report sql still require use_hash
hints in order to avoid silly
I would expect the pread64() calls to map to "db file sequential read" and
the readv() calls to map to "db file scattered read". Jeff's "Why are
Oracle's Read Events 'Named Backwards'?" explains (www.hotsos.com/catalog).
Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com
Upcoming events
Thanks Wolfgang, Cary for taking the time to answer my first question. After
taking a second look on the hotsos doc, it did in fact address my problem,
specifically the third bullet point. I simply missed to apply the pattern,
shown in the example for the third point, to my situation.
As for prea
Purely a guess, but looking at the figures
do you think that Oracle is using readv for
values up to 128K, and pread for values
larger than 128K ?
Regards
Jonathan Lewis
http://www.jlcomp.demon.co.uk
Now available One-day tutorials:
Cost Based Optimisation
Trouble-shooting and Tuning
Inde
Jun,
Wolfgang is correct, and it is covered in Jeff's document. It's the third
point (with example) listed at the bottom of page 1.
Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com
Upcoming events:
- Hotsos Clinic 101, Mar 25-27 Oxford
- Hotsos Clinic 101, Apr 8-10 Chicago
-Or
My explanation is that blocks 1473, 2566, 2580, 2590, 2617, 2628, 2648,
2681, 2695, 2702, 2714, 2719, 2748, 2760, 2773, 2794, 2798, 2811, and 2819
were already in the buffer pool and the FTS reads "around" them.
At 08:08 PM 3/12/2003 -0800, you wrote:
I have been wondering how to set the optimal
AIL PROTECTED]>
Sent by: cc:
root@fatcity. Subject: RE:
db_file_multiblock_read_count
Title: RE: db_file_multiblock_read_count/max i/o
thanks Connor. Excellent info.
Lisa Koivu
Ft. Lauderdale, FL, USA
-Original Message-
From: Connor McDonald [SMTP:[EMAIL PROTECTED]]
Sent: Monday, June 25, 2001 2:18 PM
To: Multiple recipients of list ORACLE-L
Subject
Title: RE: db_file_multiblock_read_count/max i/o
Oracle
will silently set it to the max setting for the platform. Meaning the
v$parameter will just show what you set it at reguardless of what the max
is. The only way is using truss type utility and monitor the system
calls.
"Wa
rom: Smith, Ron L. [SMTP:[EMAIL PROTECTED]]
> > Sent: Monday, June 25, 2001 11:12 AM
> > To: Multiple recipients of list ORACLE-L
> > Subject:RE: db_file_multiblock_read_count
> >
> > How do you tell for sure what the max i/o size is
> set to?
> &
Title: RE: db_file_multiblock_read_count
Hi
A year
or two back, the suggestion (on solaris at least) was to avoid using vmstat with
the first parm set to a value lower than 10, because the act of measuring perf
becomes a drain if you do it every 5 seconds (or less).
I tend
to use vmstat
://www.superpages.com
> -Original Message-
> From: Koivu, Lisa [SMTP:[EMAIL PROTECTED]]
> Sent: Monday, June 25, 2001 11:23 AM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: db_file_multiblock_read_count
>
> Thanks Guy. I don't even have a unix system he
Title: RE: db_file_multiblock_read_count
Thanks Guy. I don't even have a unix system here to do a man page. Talk about BOREDOM.
Lis
-Original Message-
From: Guy Hammond [SMTP:[EMAIL PROTECTED]]
Sent: Monday, June 25, 2001 11:28 AM
To: Multiple recipients of list ORA
Title: RE: db_file_multiblock_read_count
geez.
Load a
trial copy of MKS on NT and get back into da swing of tings,
gal!
:)
-Original Message-From: Koivu, Lisa
[mailto:[EMAIL PROTECTED]]Sent: Monday, June 25, 2001 12:23
PMTo: Multiple recipients of list ORACLE-LSubject: RE
Title: RE: db_file_multiblock_read_count/max i/o
Um that was something I relied upon my trusty SA to tell me.
I can't answer that. Sorry. Anyone know? I do know how to determine this is different between platforms.
Lisa
-Original Message-
From: Smith, Ron L.
Title: RE: db_file_multiblock_read_count
Hi
Lisa,
IIRC,
the first line of vmstat gives you cumulative values since system boot. And "2
10" means "every 2 seconds, 10 times" (on Solaris, at any
rate).
Cheers,
g
-Original Message-From: Koivu, Li
How do you tell for sure what the max i/o size is set to?
-Original Message-
Sent: Monday, June 25, 2001 9:23 AM
To: Multiple recipients of list ORACLE-L
Hi Liam,
1. Setting db_file_multiblock_count to a number that when multiplied by
your block size is greater than your max i/o siz
Title: RE: db_file_multiblock_read_count
Hi Liam,
1. Setting db_file_multiblock_count to a number that when multiplied by your block size is greater than your max i/o size on your host will encourage full table scans. I also read somewhere else about the effects of doing this, I know
25 matches
Mail list logo
