Re: buffer cache

, 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.6422 (e

Re: EMC Storage Array Issue

also send the HELP command for other information (like subscribing). // George Schlossnagle // Principal Consultant // OmniTI, Inc http://www.omniti.com // (c) 301.343.6422 (e) [EMAIL PROTECTED] // 1024D/1100A5A0  1370 F70A 9365 96C9 2F5E 56C2 B2B9 262F 1100 A5A0 -- Please see

Re: EMC Storage Array Issue

also send the HELP command for other information (like subscribing). // George Schlossnagle // Principal Consultant // OmniTI, Inc http://www.omniti.com // (c) 301.343.6422 (e) [EMAIL PROTECTED] // 1024D/1100A5A0  1370 F70A 9365 96C9 2F5E 56C2 B2B9 262F 1100 A5A0 -- Please see

Re: EMC Storage Array Issue

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). // George Schlossnagle // Principal Consultant // OmniTI, Inc http

Re: EMC Storage Array Issue

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. George Schlossnagle wrote: On Monday, April 15, 2002, at 02:08 PM

Re: free buffer waits

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 night all,   Joel.

Re: New iMac as dba workstation

). You may also send the HELP command for other information (like subscribing). // George Schlossnagle // Principal Consultant // OmniTI, Inc http://www.omniti.com // (c) 301.343.6422 (e) [EMAIL PROTECTED] // 1024D/1100A5A0  1370 F70A 9365 96C9 2F5E 56C2 B2B9 262F 1100 A5A0 -- Please

Re: Library Cache wait -- Who is holding this latch

= 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 96C9 2F5E 56C2

Two whitepapers, for interest and comments

(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

Re: Async I/O on Sun Solaris

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: Huh? asynch_io works fine on Solaris. At least on Solaris 2.6, 7, and 8. On Friday

Re: Async I/O on Sun Solaris

information (like subscribing). // George Schlossnagle // 1024D/1100A5A0  1370 F70A 9365 96C9 2F5E 56C2 B2B9 262F 1100 A5A0 -- 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

Re: BIG DATABASE second post

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 new services

Re: EMC Not Releasing Space

://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 To REMOVE yourself from

Re: Shared pool wait for library cache pin

adding another team member, Pythian has new services for supplementing DBAs: get our help with monitoring, 24x7 on-call, daily verifications, storage management, performance and more. Thanks for taking time to reply. Cherie George Schlossnagle

Re: Shared pool wait for library cache pin

Gelco Information Network George Schlossnagle To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] schlossnagle@py cc: thian.com

Re: Shared pool wait for library cache pin

, Not particularly based on the number of users that we have. See my other reply to Jared for follow-up. Cherie George Schlossnagle To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] schlossnagle@py cc

Re: Shared pool wait for library cache pin

memory at startup. Are you talking about a jump in regular process memory usage? We think one/some of the statements in that job is causing the problem. Thanks for your reply, Cherie George SchlossnagleTo: Multiple recipients of list

Re: VLDB backup policy

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 Internet access

Re: Determining Striping

). 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 Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California

Re: VLDB backup policy

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 Internet access / Mailing Lists

Re: Shared pool wait for library cache pin

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 Internet access / Mailing Lists

Re: Shared pool wait for library cache pin

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 adding another

Re: x$ksmpp table question

: george, try using pmap pid 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 - Original Message - From: Khedr, Waleed To: Multiple recipients

x$ksmpp table question

I have a question about the x$ksmpp table. Supposedly (according to Steve Adams' internals book) is thereference 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

Re: x$ksmpp table question

$ksmpp table question George, You can get the PGA information you're looking for from v$sesstat Query v$statname: select * from v$statname where name like '%pga%' get the statistic# and query v$sesstat for that session. Waleed -Original Message-From: George

weird pga swelling

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 verifications, storage management, performance

Re: retrieving objects usign OCI

. 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 hard. 30 seconds on CPAN led me to: http://www.cpan.org/modules/by-module/Oraperl/TIMB/Oracle- OCI

Re: retrieving objects usign OCI

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. George // George

Re: diagnosing latch free

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$latchname ln where sw.p2 = ln.latch#. Best

Re: diagnosing latch free

-- 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 To REMOVE yourself from

Re: diagnosing latch free

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$latchname ln

Re: Internal Benchmarking

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:

Re: Code to Validate email addresses

). 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 Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California

Re: Max number of sessions

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:

Re: Veritas Quickio and DB_BLOCK_SIZE

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 City Network Services-- (858) 538

Re: Veritas Quickio and DB_BLOCK_SIZE

or should depend on. And I am very glad to hear that your environment adheres to that. Good for you!!! Absolutely. I wasn't intending to contradict your point, just to clarify a particular of it. Best, George -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: George

Re: Backup Strategy

, 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 the official ORACLE-L FAQ: http://www.orafaq.com -- Author: George Schlossnagle INET: [EMAIL PROTECTED

Re: Network Appliance Options

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: George Schlossnagle INET: [EMAIL PROTECTED] Fat City

Re: OT : kernel using 75% of CPU

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

Re: OT : kernel using 75% of CPU

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,

Re: database upgrade policy?

or the name of mailing list you want to be removed from). You mayalso 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 Network Services -- (858) 5

Re: database upgrade policy?

://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 To REMOVE yourself from

Re: database upgrade policy?

- To: 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 [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED

Re: PHP on Linux with Oracle

). -- 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

weird recursive sql

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 +!;

Re: Off Topic: For Sale Sparc 5 170MHz capable of running 9i

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 the official ORACLE-L FAQ: http://www.orafaq.com -- Author: George Schlossnagle INET: [EMAIL

Re: UNIX

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

Re: UNIX

-- 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 To REMOVE yourself from this mailing

Re: Linux profile - a little offtopic

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 Network Services-- (858) 538-5051 FAX

Re: Undocumented Init.Ora Parms

-- 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 To REMOVE yourself from this mailing list

Re: What the difference between qio and direct I/O option in VxFS

') 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 the official ORACLE-L FAQ: http://www.orafaq.com -- Author: George Schlossnagle

Re: Increasing Freelists?

: George Schlossnagle INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list

Re: Veritas Quick I/0 and Oracle/ Asycnchronous I/O

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: [EMAIL

Re: Veritas Quick I/0 and Oracle/ Asycnchronous I/O

(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 Network Services-- (858) 538-5051

Re: Veritas Quick I/0 and Oracle/ Asycnchronous I/O

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

Re: Veritas Quick I/0 and Oracle/ Asycnchronous I/O

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

Re: Veritas Quick I/0 and Oracle/ Asycnchronous I/O

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

Re: Veritas for Oracle, What is it.

: 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: George Schlossnagle INET: [EMAIL PROTECTED] Fat City Network

Re: Shared Pool info - V$sqlarea.

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

Re: How do I corrupt a block

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: George Schlossnagle INET: [EMAIL PROTECTED

Re: Performance tuning

://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 To REMOVE yourself from

Re: Sessions are waiting on buffer busy wait with P3 value 130 in v$s

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 Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego