(or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: George Schlossnagle
INET: [EMAIL PROTECTED]
Fat City Netwo
ternet access / Mailing
ListsTo
REMOVE yourself from this mailing list, send an E-Mail messageto:
[EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message
BODY, include a line containing: UNSUB
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing li
: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Thursday, August 23, 2001 3:36 PM
so if more than one person selects from a given object, you die?
they aren't particularly forthcoming on what the bug really is.
>From: "George Schlossnagle" <
Title: Message
Are you running software raid 10 or software raid 5
on that box?
- Original Message -
From:
Christopher
Spence
To: Multiple recipients of list ORACLE-L
Sent: Tuesday, August 28, 2001 1:30
PM
Subject: RE: OT : kernel using 75% of
CPU
Also
Title: Message
The RMCmem toolkit from Sun Engineering (though not
officially supporte dby Sun) is great for this. Lacking that you can find
a berkely style ps in
/usr/ucb/ps
- Original Message -
From:
Jerry C
To: Multiple recipients of list ORACLE-L
Sent: Tuesday, A
On Tuesday, June 11, 2002, at 09:08 PM, BigP wrote:
Hi Guys ,
IS there any way I can find what is occupying how much of buffer cache . Like .. what table is taking most of space etc .
Thanks ,
Bp
// George Schlossnagle
// Principal Consultant
// OmniTI, Inc http://www.omniti.com
// (c) 301.343
Title: RE: Internal Benchmarking
I wrote a Perl DBDI/DBD::Oracle port of Morle's
dbaman scripts. It's available at http://www.omniti.org/~george/trace2perl/trace2perl.pl.
Should work w/o problemsanywhere DBD::Oracle is installed.
- Original Message -
From:
Aponte, Tony
To
lude a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Ge
oops, probably only want the events that are latch frees:
select ln.name from v$session_wait sw, v$latchname ln where sw.p2 = ln.latch# and sw.event = 'latch free';
On Saturday, December 8, 2001, at 04:50 PM, George Schlossnagle wrote:
Try:
select ln.name from v$session_wait sw, v$la
you wrote:
>
>> oops, probably only want the events that are latch frees:
>>
>> select ln.name from v$session_wait sw, v$latchname ln where sw.p2 =
>> ln.latch# and sw.event = 'latch free';
>>
>> On Saturday, December 8, 2001, at 04:50 PM, George Schlo
l examples for you. I would recommend looking at libsqlora
http://www.poitschke.de/libsqlora8/ a wrapper library for oci. It will either do what you want (if you want to just use that instead of oci), or looking at it's implementation should give you all you need to know about using oci.
Ge
uld forward some links
for it, I'd be appreciative.
Best of luck,
George
>
> I'd appreciate any further comments.
>
> Thanks and regards,
> Siddharth.
>
> --- George Schlossnagle <[EMAIL PROTECTED]> wrote:
>> No offense, but you couldn't have looked too h
ular query.
Any thoughts? This seems like a PGA memory leak to me.
// George Schlossnagle
// www.pythian.com -- [EMAIL PROTECTED] -- 877-PYTHIAN
// Smarter than adding another team member, Pythian has new services
// for supplementing DBAs: get our help with monitoring, 24x7 on-call,
// daily v
I have a question about the x$ksmpp table.
Supposedly (according to Steve Adams' internals book) is the reference
table for the heap allocation for a processes pga. I assume this means for
a processes own pga. If so, is it possible (and if so how) to access
the same data for an arbitrary
essage-----From: George Schlossnagle [mailto:[EMAIL PROTECTED]]Sent:
Thursday, December 27, 2001 2:00 PMTo: Multiple recipients of
list ORACLE-LSubject: x$ksmpp table question
I have a question about the x$ksmpp
table. Supposedly (according to Steve Adams' internals book) i
Khedr,
Waleed
To: Multiple recipients of list ORACLE-L
Sent: Thursday, December 27, 2001 3:50
PM
Subject: RE: x$ksmpp table question
dump
the heap.
-Original Message-From: George Schlossnagle [mailto:[EMAIL PROTECTED]]Sent:
Thursday, December 27, 2001
:
> george, try using pmap
>
> hth
> deepak
> --- George Schlossnagle <[EMAIL PROTECTED]> wrote:
>> I want access to the fll heap structure though. My
>> process pga is huge, I want to see what the
>> allocations are.
>>
>> George
>>
>>
Author: Andrey Bronfin
> INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> --------
> To REMOVE you
acledba.co.uk (mirrored at
> http://www.oradba.freeserve.co.uk)
>
> "Some days you're the pigeon, some days you're the statue"
>
> ______
> Do You Yahoo!?
> Everything you'll ever need on one web page
>
-- Public Internet access / Mailing
> > Lists
> >
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and i
B ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>
>
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: George Schlossnagle
INET: [EMAIL PROTECTED]
F
ausing you a service problem currently, I would still keep an eye on it, as the version_count for queries rises, the chances of getting severe contention on the library cache latch increases.
George
// George Schlossnagle
// www.pythian.com -- [EMAIL PROTECTED] -- 877-PYTHIAN
// Smarter than addi
, a
> shared pool flush may remove all versions (or none)). If it's not
> causing you a service problem currently, I would still keep an eye on
> it, as the version_count for queries rises, the chances of getting
> severe contention on the library cache latch increases.
>
&g
Any further
advice is greatly
>
appreciated.
>
>Cherie
Machler
> Oracle DBA
> Gelco
Information Network
>
>
;
> George,
>
> Not particularly based on the number of users that we have.
>
> See my other reply to Jared for follow-up.
>
> Cherie
>
>
>
> "George
> Schlossnagle"
monitoring shared memory usage and saw a big jump when a
> regular batch
> job was run at 10:30am.
A jump in shared memory usage? Oracle preallocates all of it's shared
memory at startup. Are you talking about a jump in regular process memory
usage?
> We think one/some of the stat
: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>
>
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Aut
587109096 bytes per minutes in SQLNet traffic. The website itself does 195Mb/s at peak. We have a gigabit Ethernet drop from a major provider.
George
// George Schlossnagle
// www.pythian.com -- [EMAIL PROTECTED] -- 877-PYTHIAN
// Smarter than adding another team member, Pythian has ne
ling list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other inf
t, or search on google
> as there are a couple of sites that archive this list.
>
> With cooked filesystems, you won't get async IO on Solaris, at least
> on 2.6 and 2.7. Not sure about 2.8.
>
> Jared
>
> On Saturday 16 February 2002 16:08, George Schlossnagle wrote:
>
7;
AND sw.p1raw = lh.laddr
AND ln.latch# = sw.p2
AND se.sid = lh.sid
AND se.sql_address = sq.address
AND se.sql_hash_value = sq.hash_value
// George Schlossnagle
// Principal Consultant
// OmniTI, Inc http://www.omniti.com
// (c) 301.343.6422 (e) [EMAIL PROTECTED]
// 1024D/1100A5A0 1370 F70A 9365
(http://www.omniti.com/~george/sizing_wp.pdf)
Using Cached QuickIO to Accelerate Oracle on Small Memory Systems
(http://www.omniti.com/~george/qio_wp.pdf)
Best,
George
// George Schlossnagle
// Principal Consultant
// OmniTI, Inc http://www.omniti.com
// 1024D/1100A5A0 1370 F70A
[EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>
>
// G
ers I should be tuning/change to try & reduce the number of busy buffer waits. I have a system which at times has over 15+session waiting on "free buffer waits".
The explanation that I have been able to find so far is that session are waiting on buffer to free up :)
Have a good
the HELP command for other information (like subscribing).
>
> --
> Scott Canaan ([EMAIL PROTECTED])
> (585) 475-7886
> "Life is like a sewer, what you get out of it depends on what you put
> into it"
> - Tom Lehrer
>
>
> --
> Please see the official OR
You may
>> also send the HELP command for other information (like subscribing).
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Anjo Kolk
> INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051 FAX: (858)
d to indicate that the I/O took place. The
> parent
> thread will check this control block to make sure that the I/O really
> happened. If there is an error or some time out experid and the i/o
> didn't
> complete, the parent thread will assume an error.
>
> Anjo.
>
cess / Mailing Lists
>
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information
--
> Author: Christopher Spence
> INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> ---
list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command f
age
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
-
; To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send
o send the HELP command for other information (like subscribing).
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: Fisher, Julie
> > INET: [EMAIL PROTECTED]
> >
> > Fat City Network Services-- (858) 538
end the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: George Schlossnagle
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Inter
I'm expereinceing a weird problem.
I have a tabl whihcis basically a collection of
counters (NAME VARCHAR2, COUNTER NUMBER). For various reasons that are
unimportant in this context the tables work by atempting an insert on (NAME, 1)
and if that fails they do an update COUNTER = COUNTER +!
Mailing Lists
>
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB OR
--
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you w
---
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing lis
ease see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Jared Still
> INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
>
ing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other informa
1 for PCI NVRAM for swap and online redo
I totally buy into using this sort of technology for online redo, but using it for swap just seems silly. You shouldn't be swapping anyway, and if you are it's much cheaper to buy ram than to buy a solid-state disk.
64 bit slots allow for (max) 350 MB/se
-
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You
George,
Agreed about it being silly for swap on a *nix box, but if you're
running on a brain-dead OS that is going to page stuff out
uncontrollably (NT/W2K) even with lots of available memory - its still a
good idea to give the OS some pagefile space on NVRAM.
Ahh My lack of knowledge of runn
> But there WOULD be the possibility of using them with Sun E250s and E450s.
Sure. Except that the drivers aren't available. Besides, these are really
tiny, unscaleable boxes.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: George Schlossnagle
INET
> INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
>
> To REMOVE yours
this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other i
an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see
Title: Max number of sessions
Isn't that the inverse? You require one
shadow process per session, plus the background processes. You should
always have more procs than sessions (jn a non-MTS environment).
George
- Original Message -
From:
Christopher
Spence
To: Multi
on the creation size. I would also like
to chip in that I run 8k block size and create all my file systems with 8k
block size specified. I may just be the exception.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: George Schlossnagle
INET: [EMAIL PROTECTED]
Fat C
,
George
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: George Schlossnagle
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
---
VE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HEL
63 matches
Mail list logo