Re: buffer cache
select obj.name, trunc(count(*)*100/vp.value,2) percentage from sys.x$bh bh, sys.obj$ obj, (select value from v$parameter where name = 'db_block_buffers') vp where bh.obj = obj.dataobj# group by obj.name, value order by percentage desc; will work (at least under 8i and 9i). 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.6422 (e) [EMAIL PROTECTED] // 1024D/1100A5A0 1370 F70A 9365 96C9 2F5E 56C2 B2B9 262F 1100 A5A0
Re: EMC Storage Array Issue
I know the VOS (veritas-oracle-sun) team was actively troubleshooting this bug 6 months ago, you might want to ask to be escalated to them (supposedly all customers can ask to have their problems escalated to that team, and the team will troubleshoot issues across all 3 product lines). George On Tuesday, April 16, 2002, at 05:38 PM, James A wrote: > One Reply from Oracle > > Dear Customer, > > Please go to the Oracle MetaLink ( http://metalink.oracle.com/ ) site > to download the patch referenced below. > > Patch: 1685984 - DBWR TERMINATES WITH ORA-27062 AFTER ONE AIOWAIT > TIMEOUT WARNING > > Password = > Platform = Sun SPARC Solaris > Product= Oracle Server > Version= 8.1.6.3 > > Customers are reminded that one-off Oracle Server patches are not > subject to the same rigorous level of testing as done for Oracle > Server patch sets. Customers are encouraged to install and test this > patch in a test environment prior to full production implementation. > > > -Original Message- > Sent: Tuesday, April 16, 2002 12:59 PM > To: Multiple recipients of list ORACLE-L > > > Do you have any more info on this BUG? I can't find anything that > appears > close to this on Metaclink. > > Rich Jesse System/Database Administrator > [EMAIL PROTECTED] Quad/Tech International, Sussex, > WI USA > > >> -Original Message- >> From: James A [mailto:[EMAIL PROTECTED]] >> Sent: Monday, April 15, 2002 1:24 PM >> To: Multiple recipients of list ORACLE-L >> Subject: RE: EMC Storage Array Issue >> >> >> We ran into a similar issue on 8.1.6.0 for Solaris 32bit and Veritas >> Volumes. Oracle noted this as a bug in their release and >> suggest go to >> 8.1.6.3 or better 8.1.7.3. >> We are testing this now. So far it seems to work. > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Jesse, Rich > 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, 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 information (like subscribing). > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: James A > 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, 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 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 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 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 the HELP command for other information (like subscribing).
Re: EMC Storage Array Issue
It seems silly to get into a semantic argument over this. My point was
that Oracle in fact does use asynchronous io as far as the POSIX
definition of aio. Just because the ocntrolling thread looks in on the
status of the aiocb when it is signaled upon completion doesn't make it
any less asynchronous.
On Monday, April 15, 2002, at 06:23 PM, Anjo Kolk wrote:
> George,
>
> Those writes are unbuffered (so synchronous) and each thread will write
> them
> out and will wait for the write to finish and then update the AIO
> control
> block in the parent thread 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.
>
>
> George Schlossnagle wrote:
>
>> On Monday, April 15, 2002, at 02:08 PM, Anjo Kolk wrote:
>>
>>> Claudio,
>>>
>>> All writes in Oracle are synchronous, they are just fired
>>> asynchronously. So
>>> even the DBWR writes synchronously.
>>
>> My dbw uses asynchronous writes I'm writing to qio files, which
>> means that they bypass buffer cache, but I think it's misleading to
>> call
>> those 'synchronous writes', they're asynchronous, unbuffered writes.
>>
>> 14:28:09(george@core-0)[~]> truss -tkaio -twrite -tread -p `ps -ef |
>> grep dbw | grep -v grep | awk '{print $2}'`
>> kaio(AIOWRITE, 396, 0xB0258000, 8192, 0x4FBF6000, 0x01974EC8) = 0
>> kaio(AIOWRITE, 308, 0xB6BFE000, 8192, 0x48478000, 0x01B20518) = 0
>> kaio(AIOWRITE, 396, 0xB921A000, 8192, 0x249E8000, 0x019C5558) = 0
>> kaio(AIOWRITE, 396, 0xB4584000, 8192, 0x24F7E000, 0x0196CA84) = 0
>> kaio(AIOWRITE, 396, 0xB82BC000, 8192, 0x6D822000, 0x01B543CC) = 0
>> kaio(AIOWRITE, 313, 0xB5ED4000, 8192, 0x1FCD2000, 0x019EE1D8) = 0
>> kaio(AIOWRITE, 395, 0xBF256000, 8192, 0x21AE6000, 0x01971958) = 0
>> kaio(AIOWRITE, 313, 0xB170, 8192, 0x1FCD4000, 0x019B65D0) = 0
>> kaio(AIOWRITE, 396, 0xBA238000, 8192, 0x24F86000, 0x01B5E32C) = 0
>>
>>
>>> So individual writes are synchronously, they are just fired off
>>> asynchronously.
>>>
>>> Anjo Kolk.
>>>
>>> claudio cutelli wrote:
>>>
>>>> Hi,
>>>> which background process had the problem?
>>>> because if lgwr, it already write in sync mode ...
>>>>
>>>> - Original Message -
>>>> To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
>>>> Sent: Monday, April 15, 2002 5:33 PM
>>>>
>>>>> We have implemented a Sun Solaris Cluster (4 machines),
>>>>> connected
>>>>> to
>>>>> an EMC storage array. The migration began last fall, and we now
>>>>> have
>>>>> 15
>>>>> Oracle instances, with a mixture of 8.1.6 and 8.1.7, located there.
>>>>> We
>>>>> recently have had 2 occurances of asynchronous I/O wait times
>>>>> exceeded.
>>>>> When this occurs, every database crashes at the same time. The
>>>>> solution
>>>>> from EMC is to turn asynchronous I/O off in all of the Oracle
>>>>> instances
>>>>> (disk_async_io = false) and to increase the database writer slaves
>>>>> (dbwr_io_slaves = ) to emulate asynchronous I/O.
>>>>> Has anyone run into this problem before? If so, how did you
>>>>> "correct" it? My feeling is that EMC is trying to give us a bandage
>>>>> to
>>>>> cover up the real problem, by trying to get Oracle to ignore it.
>>>>>
>>>>> Thank you.
>>>>>
>>>>> --
>>>>> 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 ORACLE-L FAQ: http://www.orafaq.com
>>>>> --
>>>>> Author: Scott Canaan
>>>>> INET: [EMAIL PROTECTED]
>>>>>
>>>>> Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
>>>>> San Diego, California-- Public Internet access / Mailing
>>>>> Lists
>>>>> ---
Re: EMC Storage Array Issue
On Monday, April 15, 2002, at 02:08 PM, Anjo Kolk wrote:
> Claudio,
>
> All writes in Oracle are synchronous, they are just fired
> asynchronously. So
> even the DBWR writes synchronously.
My dbw uses asynchronous writes I'm writing to qio files, which
means that they bypass buffer cache, but I think it's misleading to call
those 'synchronous writes', they're asynchronous, unbuffered writes.
14:28:09(george@core-0)[~]> truss -tkaio -twrite -tread -p `ps -ef |
grep dbw | grep -v grep | awk '{print $2}'`
kaio(AIOWRITE, 396, 0xB0258000, 8192, 0x4FBF6000, 0x01974EC8) = 0
kaio(AIOWRITE, 308, 0xB6BFE000, 8192, 0x48478000, 0x01B20518) = 0
kaio(AIOWRITE, 396, 0xB921A000, 8192, 0x249E8000, 0x019C5558) = 0
kaio(AIOWRITE, 396, 0xB4584000, 8192, 0x24F7E000, 0x0196CA84) = 0
kaio(AIOWRITE, 396, 0xB82BC000, 8192, 0x6D822000, 0x01B543CC) = 0
kaio(AIOWRITE, 313, 0xB5ED4000, 8192, 0x1FCD2000, 0x019EE1D8) = 0
kaio(AIOWRITE, 395, 0xBF256000, 8192, 0x21AE6000, 0x01971958) = 0
kaio(AIOWRITE, 313, 0xB170, 8192, 0x1FCD4000, 0x019B65D0) = 0
kaio(AIOWRITE, 396, 0xBA238000, 8192, 0x24F86000, 0x01B5E32C) = 0
> So individual writes are synchronously, they are just fired off
> asynchronously.
>
> Anjo Kolk.
>
> claudio cutelli wrote:
>
>> Hi,
>> which background process had the problem?
>> because if lgwr, it already write in sync mode ...
>>
>> - Original Message -
>> To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
>> Sent: Monday, April 15, 2002 5:33 PM
>>
>>> We have implemented a Sun Solaris Cluster (4 machines), connected
>>> to
>>> an EMC storage array. The migration began last fall, and we now have
>>> 15
>>> Oracle instances, with a mixture of 8.1.6 and 8.1.7, located there.
>>> We
>>> recently have had 2 occurances of asynchronous I/O wait times
>>> exceeded.
>>> When this occurs, every database crashes at the same time. The
>>> solution
>>> from EMC is to turn asynchronous I/O off in all of the Oracle
>>> instances
>>> (disk_async_io = false) and to increase the database writer slaves
>>> (dbwr_io_slaves = ) to emulate asynchronous I/O.
>>> Has anyone run into this problem before? If so, how did you
>>> "correct" it? My feeling is that EMC is trying to give us a bandage
>>> to
>>> cover up the real problem, by trying to get Oracle to ignore it.
>>>
>>> Thank you.
>>>
>>> --
>>> 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 ORACLE-L FAQ: http://www.orafaq.com
>>> --
>>> Author: Scott Canaan
>>> 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, 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 information (like subscribing).
>>>
>> --
>> Please see the official ORACLE-L FAQ: http://www.orafaq.com
>> --
>> Author: claudio cutelli
>> 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, 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 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) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> --------
> To REMOVE yourself from this maili
Re: EMC Storage Array Issue
Are you running Veritas as well? There are (I belive still outstanding) bugs with VXFS/VXVM on Oracle which cause these errors. Also, are you seeing high latency right times or experiencing 'hangs' in IO to your symmetrix? I've also seen faulty fiber cabling cause this problem (basically all IO to the symmetrix blocked, and the asynch io's timed-out. George On Monday, April 15, 2002, at 01:19 PM, Scott Canaan wrote: > Claudio, > I didn't think to mention the process. It is always the ckpt > (checkpoint) > background process that reports the problem. The database goes down > with an > ORA-27062. > > claudio cutelli wrote: > >> Hi, >> which background process had the problem? >> because if lgwr, it already write in sync mode ... >> >> - Original Message - >> To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> >> Sent: Monday, April 15, 2002 5:33 PM >> >>> We have implemented a Sun Solaris Cluster (4 machines), connected >>> to >>> an EMC storage array. The migration began last fall, and we now have >>> 15 >>> Oracle instances, with a mixture of 8.1.6 and 8.1.7, located there. >>> We >>> recently have had 2 occurances of asynchronous I/O wait times >>> exceeded. >>> When this occurs, every database crashes at the same time. The >>> solution >>> from EMC is to turn asynchronous I/O off in all of the Oracle >>> instances >>> (disk_async_io = false) and to increase the database writer slaves >>> (dbwr_io_slaves = ) to emulate asynchronous I/O. >>> Has anyone run into this problem before? If so, how did you >>> "correct" it? My feeling is that EMC is trying to give us a bandage >>> to >>> cover up the real problem, by trying to get Oracle to ignore it. >>> >>> Thank you. >>> >>> -- >>> 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 ORACLE-L FAQ: http://www.orafaq.com >>> -- >>> Author: Scott Canaan >>> 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, 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 information (like subscribing). >>> >> -- >> Please see the official ORACLE-L FAQ: http://www.orafaq.com >> -- >> Author: claudio cutelli >> 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, 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 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 ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Scott Canaan > 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, 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 information (like subscribing). > > // George Schlossnagle // Principal Consultant // OmniTI, Inc http://www.omniti.com // (c) 301
Re: free buffer waits
Sounds like the write latency on your storage is high or you have an abusive. 'free buffer waits' is the db writer failing to flush it's cache fast enough to disk. George On Thursday, March 7, 2002, at 06:39 PM, Manytrees wrote: Hello all, Does anybody know what parameters 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 night all, Joel. // 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
Re: New iMac as dba workstation
I'm using a Titanium G4 as a workstation, does that count? ;) I've had marginal luck using products like SQLGrinder (native OSX app, uses JDBC for connectivity). Ultimately though, I fell back to using Tora X-forwarded back to my box (I'm running XDarwin on top of Agua). I This is all part of a grand experiment, and I have to say that for me it's a marginal success at best. The cut-and-paste between Aqua and XDarwin is poor, which makes Tora only marginally useful for me. I would kill for OCI libs for OSX and a port of Golden. George On Monday, March 4, 2002, at 06:23 AM, Jan Pruner wrote: > Is anybody using iMac as workstation (db admin, programming Oracle > stuff > etc.)? > Is there net8 client verison for PowerPC or have I to run sqlplus (or > TOra) > remote? > > Thanks > > JP > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Jan Pruner > 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, 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 information (like subscribing). > > --- > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Jan Pruner > 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, 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 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 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 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 the HELP command for other information (like subscribing).
Two whitepapers, for interest and comments
In the process of preparing some documentation for a client, I prepared two brief white papers related to Oracle sizing and performance tuning. A colleague suggested I post them here, so here goes. Comments/feedback are of course welcome. :) Sizing Memory for Oracle on Solaris (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 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: (858) 538-5051 San Diego, California-- 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 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).
Re: Library Cache wait -- Who is holding this latch
You shouldn't need to do that. To find out who the holders are of all latches currently being aited on by ithers you could do SELECT lh.sid, ln.name, sq.sql_text FROM v$latchholder lh, v$sqlarea sq, v$session se, v$session_wait sw, v$latchname ln WHERE sw.event = 'latch free' 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 96C9 2F5E 56C2 B2B9 262F 1100 A5A0 On Tuesday, February 19, 2002, at 11:28 AM, Diego Cutrone wrote: you'll have to take a library cache dump and look for the latch number displayed in the P1 Field of your query. HTH Greetings Diego Cutrone - Original Message - From: Gupta, Brijesh To: Multiple recipients of list ORACLE-L Sent: Friday, February 15, 2002 12:08 PM Subject: Library Cache wait -- Who is holding this latch Hi All I have a session which is waiting for Library Cache latch for 6 hours. How can I find who is holding this latch. This session is executing a pl/sql script ( Not package ). Latch# 60 is library cache latch. Here is from v$session_wait 1 select * from v$session_wait 2* where sid=1005 PROD>/ Press Enter to Continue SID SEQ# EVENT P1TEXT --- --- -- - P1RAW P2TEXT P2 P2RAW --- -- Wait Sec in P3TEXT P3 P3RAW time Wait STATE --- -- 1005 5987 latch free address @9925 0701C0A5E228 number 60 003C tries 0 00 -1 32,962 WAITED SHORT Thanks Brijesh Gupta Oracle Production DBA
Re: Async I/O on Sun Solaris
Works like a charm against qio files as well. May work on vxfs (I haven't checked). It may be a metter of definition, but I wouldn't characterize not working on ufs as not working on Solaris. That seems an overly sweeping statement to me. George On Saturday, February 16, 2002, at 09:03 PM, Jared Still wrote: > > Well, no not actually. > > You must use raw devices for async IO to work with Oracle on Solaris. > > It's pretty easy to prove this using svrmgrl and truss. If you dig > around > in the archives you may find some references to it, 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: >> Huh? >> >> asynch_io works fine on Solaris. At least on Solaris 2.6, 7, and 8. >> >> On Friday, February 15, 2002, at 10:28 AM, Peter Barnett wrote: >>> Async IO on Solaris does not work - or at least it has >>> not worked with lower OS releases. Someone might have >>> more up to date information on Solaris 8. >>> >>> >>> --- "Daiminger, Helmut" >>> >>> <[EMAIL PROTECTED]> wrote: >>>> Hi! >>>> >>>> How can I find out whether my operating system >>>> supports async I/O? Can I >>>> turn this on/off? >>>> >>>> What is the relation between async I/O and the usage >>>> of Oracle I/O slaves? >>>> >>>> Can anybody shed some light on this? >>>> >>>> This is 8.1.7 on Sun Solaris 8. >>>> >>>> Thanks, >>>> Helmut >>> >>> = >>> Pete Barnett >>> Lead Database Administrator >>> The Regence Group >>> [EMAIL PROTECTED] >>> >>> __ >>> Do You Yahoo!? >>> Got something to say? Say it better with Yahoo! Video Mail >>> http://mail.yahoo.com >>> -- >>> Please see the official ORACLE-L FAQ: http://www.orafaq.com >>> -- >>> Author: Peter Barnett >>> 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, 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 information (like subscribing). >> >> // George Schlossnagle >> // 1024D/1100A5A0 1370 F70A 9365 96C9 2F5E56C2 B2B9 262F 1100 A5A0 > -- > Please 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 > > 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 the HELP command for other 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: (858) 538-5051 San Diego, California-- 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 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).
Re: Async I/O on Sun Solaris
Huh? asynch_io works fine on Solaris. At least on Solaris 2.6, 7, and 8. On Friday, February 15, 2002, at 10:28 AM, Peter Barnett wrote: > Async IO on Solaris does not work - or at least it has > not worked with lower OS releases. Someone might have > more up to date information on Solaris 8. > > > --- "Daiminger, Helmut" > <[EMAIL PROTECTED]> wrote: >> Hi! >> >> How can I find out whether my operating system >> supports async I/O? Can I >> turn this on/off? >> >> What is the relation between async I/O and the usage >> of Oracle I/O slaves? >> >> Can anybody shed some light on this? >> >> This is 8.1.7 on Sun Solaris 8. >> >> Thanks, >> Helmut >> >> > > > = > Pete Barnett > Lead Database Administrator > The Regence Group > [EMAIL PROTECTED] > > __ > Do You Yahoo!? > Got something to say? Say it better with Yahoo! Video Mail > http://mail.yahoo.com > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Peter Barnett > 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, 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 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: (858) 538-5051 San Diego, California-- 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 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).
Re: BIG DATABASE second post
At peak workloads, the main server sends 587109096 bytes per minute, and receives 28779721 bytes per minute. The server does over 25 user calls per minute at peak workloads, and 11000 user commits per minute (TPM). To clarify a bit of Paul's bragging - that's the database that does 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 new services // for supplementing DBAs: get our help with monitoring, 24x7 on-call, // daily verifications, storage management, performance and more.
Re: EMC Not Releasing Space
Hi, This almost certainly has nothing to do with your symmetrix. The first two guesses I would make are: 1) oracle still has an open filehandle associated with the now-gone inode. The space will not be deallocated until thta filehandle is closed. You can use a tool like lsof to see if anyone still has on open fh associated with that object (for example, any session that had used that file before it was removed) 2) your file system has not updated it's metadata. Try syncing the file system a couple times and see if that fixes it (i.e. sync; sync; sync). Also, some filesystems (notably vxfs) have had bugs were the tools 'lied' about allocation information. HTH, George --- http://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 and more. - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Tuesday, January 08, 2002 1:19 PM > Hi, > > Just curious if anyone has any experience with an EMC > Symmetrix not releasing the space for a deleted > datafile. If so, is there a solution or work-around? > > Yesterday, we took a tablespace offline, dropped it > and then deleted the associated datafile. The file was > 1G in size and today the space has still not been > released as indicated by 'df -k'. According to another > DBA here, they have seen this in the past and said > bouncing the DB remedied the problem. > > It sounds like the inodes are still in use by Oracle > but I can't imagine why. I've worked with Symmetrix > systems before and have never experienced this > behavior. We are running 8.1.7.2 (64bit) on Solaris > 2.8. Any suggestions? > > As always, your feedback is appreciated. > > -w > > __ > Do You Yahoo!? > Send FREE video emails in Yahoo! Mail! > http://promo.yahoo.com/videomail/ > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Walter K > 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, 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 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 / 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-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).
Re: Shared pool wait for library cache pin
> George, > > Just checked again right now.Following is the result that I got: > > SQL> select version_count, count(*) from v$sqlarea group by version_count; > > VERSION_COUNT COUNT(*) > - -- > 1 48241 > 2 9 > 4 2 > 8 1 >27 1 > What is the query with the high version count (I don't think it's the one with the literal sql (though you should consider setting cursor_sharing = force, to have oracle bind all your literal sql for you), I would imagine that's part of the slew of queries with 1 version). > Yesterday, after we flushed the shared pool, the highest value I got was > about 400. If after the flush it remained at 400 then there was an active session using that sql. Is there a period of time when no one is using your application (like in the middle of the night) when you can execute a shared pool flush? You may have better luck then. What is the history on this issue? How long was the app running fine before you started having problems? Were any changes at all made proximal to that time (for example, any changes to the underlying tables, or implementation of a snapshot with them asthe master table, or a change in backup method from cold-backup to hot-backup?) Anything at all that you can correlate with this becoming a noticeable issue? I agree with Jared that upgrading may be a good idea, but it would be nice to confirm what bug/feature you are hitting before you do an emergency upgrade. > > Need I mention that this app has a couple of statements that don't use bind > variables. > > Obviously, this looks fairly bad already. I'm trying to get Steve Adam's > whence_invalids script > to work but am having trouble with one of the views. I'm missing the view > and am trying to > create it. Not sure if it's available in this version: sys.x_$kglob Steve creates views on all the x$ tables. if you go into the scripts part of the site (http://www.ixora.com.au/scripts/prereq.htm) there's a script to generate them all (called create_xviews.sql or something similair). Alternatively, if you want to run the queries as sys, you can just change all the x_$'s to x$'s. > > We are also 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 statements in that job is > causing the problem. > > Thanks for your reply, > > Cherie > > > > "George > Schlossnagle"To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > .com>Subject: Re: Shared pool wait for library cache pin > Sent by: > [EMAIL PROTECTED] > om > > > 01/03/02 10:00 > AM > Please respond > to ORACLE-L > > > > > > > Hi Cherie, > > The version_count should be irrelevant of the number of users you have. I > doubt this is a shared memory leak, it sounds like simple latch conetention > based on the number of versions you have of certain queries. If flushing > your shared pool resets the version count for that query, then that is a > good workaround. If not, a bounce will clearly take care of it. How fast > are your version count/invalidations growing? > > George > > - Original Message - > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> > Sent: Thursday, January 03, 2002 8:40 AM > > > > > > George, > > > > 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]> > > > thian.com> Subject: Re: Shared pool > wait for library cache pin > > Sent by: > > [EMAIL PROTECTED] > > > > > > 01/02/02 02:41 > > PM > > Please respond > > to ORACLE-L > > > > > > > > > > > > > > Do any of your queries have a high version_count (visible
Re: Shared pool wait for library cache pin
Hi Cherie, The version_count should be irrelevant of the number of users you have. I doubt this is a shared memory leak, it sounds like simple latch conetention based on the number of versions you have of certain queries. If flushing your shared pool resets the version count for that query, then that is a good workaround. If not, a bounce will clearly take care of it. How fast are your version count/invalidations growing? George - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Thursday, January 03, 2002 8:40 AM > > George, > > 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]> > thian.com> Subject: Re: Shared pool wait for library cache pin > Sent by: > [EMAIL PROTECTED] > > > 01/02/02 02:41 > PM > Please respond > to ORACLE-L > > > > > > > Do any of your queries have a high version_count (visible through > v$sqlarea)? > > George > > - Original Message - > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> > Sent: Wednesday, January 02, 2002 3:20 PM > > > > > > We are seeing a lot of shared pool waits (for libary cache pin) on > > our 8.1.5 web-based application. We are seeing this via Precise/Indepth > > SQL monitoring tool. > > > > I haven't been able to find much documentation on shared pool waits or > > library cache pins. > > > > Can anyone tell me what might be causing this problem? > > > > Thanks, > > > > Cherie > > > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > -- > > Author: > > 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, 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 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 / 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-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: > 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, 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 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 / 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-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).
Re: Shared pool wait for library cache pin
Hi, There are a number of 8.1.5 bugs that can cause these symptoms. There is the null-refresh snapshot bug (1348501), and a number of aditional bugs of whihc may or may not be published (but that are referenced in other notes on metalink), including, but not limited to 1000866: HIGH V$SQLAREA.VERSION_COUNT/LOADED_VERSIONS FOR INSERT USING BIND VARIABLES 1522724: HIGH VERSION_COUNT & LOADED_VERSIONS IN V$SQLAREA FOR SQL USING BIND VARIABLES 1210242: Cursors not shared if both TIMED_STATISTICS and SQL_TRACE are enabled 1318267: INSERT AS SELECT may not share SQL when it should If your high version_count seems to be related to a high number of invalidations (on the same query of course - also in v$sqlarea), then it may not be a bug per se, it may just be due to changed dependecies. If so, you may want to try this script off of Steve Adams' site to see where your invalidations are likely stemming from: http://www.ixora.com.au/scripts/sql/whence_invalidations.sql George --- http://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 and more. - Original Message - To: <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Thursday, January 03, 2002 9:29 AM > > George/Arun, > > I see that bug > > > > >1640583 > >is present in 8.1.6.3 but I'm >having trouble confirming that >it is present in 8.1.5. >How can I positively confirm >that? > >This bug text does not mention >the timed_statistics issue. >Is there some place where >this connection is documented. >I need something I can show >the application owner >that has more details than the >text of this bug has. The >bug text itself is not very > enlightening. > >I don't see anything else on >Metalink that has more >details. > >Any further advice is greatly > appreciated. > >Cherie Machler > Oracle DBA > Gelco Information Network > > > > > > > > George > Schlossnagle To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > thian.com> Subject: Re: Shared pool wait for library cache pin > Sent by: > [EMAIL PROTECTED] > > > 01/03/02 12:50 > AM > Please respond > to ORACLE-L > > > > > > > Hi, > > Queries with high version counts can cause library cache latch > contention, as the query must hold that latch during soft parse and has > to go through the entire list of query versions in the data dictionary. > High version_count's are often caused by a high number of invalidations > on the query. Invalidations of a query can be caused by a number of > different things (one is the bug with timed_statistics, another is a bug > present up to 8.1.6.3 in some instances when materialized views are > used), other causes of invalidations are analyzing a dependent table or > index, or truncating a dependent table. > > If this is causing you a problem, the next step is to track down what > the cause of your high version_counts is, and work to correct it or > workaround it (depending on the frequency t
Re: Shared pool wait for library cache pin
> George/Arun, > > Thanks for your helpful replies. This information may help me > explain the performance problems that peaked yesterday. > > I do have timed_statistics set to true and my version is 8.1.5. and sql_trace? There are some workarounds posted in the bug report for the timed statistics error. > > How do you define whether a version count is "high" ? Is there > some threshould that you cross when it becomes "high". Is it > a percentage of total statements or users or what? It should be completely unrelated to both those variables. Basically (disclaimer: this is purely speculation based off observation and experience), the loaded versiosn of a query are kept as a linked list. When a session soft parses the query, it has to go through all the versions to find the current valid one. it has to hold the latch as it searches the list. I would worry about any version counts over 100. > > This problem seems to have creeped up on us over time. > After I flushed the shared pool yesterday, we seem to be > o.k. right now. Our application owner is concerned that this > problem may recur. If the query is not active at the time of the flush, it should be eligible for removal. If it's frequently executed, you may not be able to flush it out with a shared pool flush. If the count increases slowly, this may be a valid workaround for you. > > If we do indeed have this bug, then our only recourse seems > to be either to upgrade to 8.1.7.x or to use the work-around of > flushing the shared pool, right? Be aware that invalidations (which new versions can be attributed to) can also be cause by changing dependencies. Analyzing your tables or truncating dependent objects will also cause this. There are a number of distinct, unrelated causes of high version counts in 8.1.5, I would try to nail down which it is and attack the problem from there. Again, if the counts grow slowly and a flush resets them, then you have a great workaround to hold you until you come up with a robust solution. George --- http://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 and more. > > Thanks for taking time to reply. > > Cherie > > > > George > Schlossnagle To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > thian.com> Subject: Re: Shared pool wait for library cache pin > Sent by: > [EMAIL PROTECTED] > > > 01/03/02 12:50 > AM > Please respond > to ORACLE-L > > > > > > > Hi, > > Queries with high version counts can cause library cache latch > contention, as the query must hold that latch during soft parse and has > to go through the entire list of query versions in the data dictionary. > High version_count's are often caused by a high number of invalidations > on the query. Invalidations of a query can be caused by a number of > different things (one is the bug with timed_statistics, another is a bug > present up to 8.1.6.3 in some instances when materialized views are > used), other causes of invalidations are analyzing a dependent table or > index, or truncating a dependent table. > > If this is causing you a problem, the next step is to track down what > the cause of your high version_counts is, and work to correct it or > workaround it (depending on the frequency that the query is executed, 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. > > George > > // 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 and more. > > > On Wednesday, January 2, 2002, at 04:35 PM, [EMAIL PROTECTED] > wrote: > > > > > Yes, there are a handful with more than 400. > > I'm not sure what high is? > > > > Cherie > > > > > > > > "George > > Schlossnagle" To: Multiple recipients > > of list ORACLE-L <[EMAIL PROTECTED]> > > >
Re: Shared pool wait for library cache pin
Hi, Queries with high version counts can cause library cache latch contention, as the query must hold that latch during soft parse and has to go through the entire list of query versions in the data dictionary. High version_count's are often caused by a high number of invalidations on the query. Invalidations of a query can be caused by a number of different things (one is the bug with timed_statistics, another is a bug present up to 8.1.6.3 in some instances when materialized views are used), other causes of invalidations are analyzing a dependent table or index, or truncating a dependent table. If this is causing you a problem, the next step is to track down what the cause of your high version_counts is, and work to correct it or workaround it (depending on the frequency that the query is executed, 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. George // 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 and more. On Wednesday, January 2, 2002, at 04:35 PM, [EMAIL PROTECTED] wrote: Yes, there are a handful with more than 400. I'm not sure what high is? Cherie "George Schlossnagle" To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> thian.com> Subject: Re: Shared pool wait for library cache pin Sent by: [EMAIL PROTECTED] 01/02/02 02:41 PM Please respond to ORACLE-L Do any of your queries have a high version_count (visible through v$sqlarea)? George - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Wednesday, January 02, 2002 3:20 PM We are seeing a lot of shared pool waits (for libary cache pin) on our 8.1.5 web-based application. We are seeing this via Precise/Indepth SQL monitoring tool. I haven't been able to find much documentation on shared pool waits or library cache pins. Can anyone tell me what might be causing this problem? Thanks, Cherie -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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, 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 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 / 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-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: 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, 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 information (like subscribing).
Re: Shared pool wait for library cache pin
Do any of your queries have a high version_count (visible through v$sqlarea)? George - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Wednesday, January 02, 2002 3:20 PM > > We are seeing a lot of shared pool waits (for libary cache pin) on > our 8.1.5 web-based application. We are seeing this via Precise/Indepth > SQL monitoring tool. > > I haven't been able to find much documentation on shared pool waits or > library cache pins. > > Can anyone tell me what might be causing this problem? > > Thanks, > > Cherie > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: > 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, 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 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 / 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-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).
Re: VLDB backup policy
olerating a little more downtime > > in case > > of a crash. > > > > I just have never happened to work with 10 Terrabytes size of DB, in > > particular ,i believe that my proven backup strategies that work well > > with > > 100GB DB might need some amending when it comes to 10 TB size. > > > > Another constraint is that i'm limited to Oracle 8.1.7 , and can not > > upgrade > > to 9i. > > > > I need to decide which hardware/software needs to be > > purchased/evaluated to > > implement solid DRP and HA. > > People say : EMC , Veritas , Legato etc... > > I'm just lost among these (and many others) buzzwords and need a > > "Second > > opinion" from gurus, like you. > > Please share your experience and thoughts. > > Thanks a lot in advance ! > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > -- > > 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 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 HELP command for other information (like subscribing). > > > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > -- > > Author: Kimberly Smith > > 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, 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 information (like subscribing). > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > -- > > Author: Mercadante, Thomas F > > 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, 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 information (like subscribing). > > > __ > Do You Yahoo!? > Send your FREE holiday greetings online! > http://greetings.yahoo.com > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Rachel Carmichael > 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, 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 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 / 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-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).
Re: Determining Striping
tion, distribution > > or > > copying of this communication is strictly > > prohibited. > > If you have received this communication in error, > > please > > re-send this communication to the sender and delete > > the > > original message or any copy of it from your > > computer > > system. > > -- > > Please see the official ORACLE-L FAQ: > > http://www.orafaq.com > > -- > > Author: Robertson Lee - lerobe > > 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, 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 information > > (like subscribing). > > = > Connor McDonald > http://www.oracledba.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 > from News and Sport to Email and Music Charts > http://uk.my.yahoo.com > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: =?iso-8859-1?q?Connor=20McDonald?= > 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, 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 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 / 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-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).
Re: VLDB backup policy
e 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: Kimberly Smith > 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, 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 information (like subscribing). > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > 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 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 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 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 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).
Re: x$ksmpp table question
That was how I spotted the bad processes in the first place. Now I want details on what is swelling their pgas. x$ksmpp will give that for my own session, I want the same information for the sessions in question. George On Saturday, December 29, 2001, at 08:10 AM, Deepak Thapliyal wrote: > 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 >> >> - Original Message - >> From: Khedr, Waleed >> To: Multiple recipients of list ORACLE-L >> Sent: Thursday, December 27, 2001 2:20 PM >> Subject: RE: x$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 Schlossnagle >> [mailto:[EMAIL PROTECTED]] >> Sent: Thursday, December 27, 2001 2:00 PM >> To: Multiple recipients of list ORACLE-L >> Subject: x$ksmpp table question >> >> >> 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 >> shadow process (in particular, not the one >> associated with the ssession running the query). >> >> Thanks, >> >> George >> >> --- http://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 >> and more. >> > > > __ > Do You Yahoo!? > Send your FREE holiday greetings online! > http://greetings.yahoo.com > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Deepak Thapliyal > 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, 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 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 / 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-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).
Re: x$ksmpp table question
Ok... but that doesn't answer my original
question either and I also then have to post-process it. If I could query
x$ksmpp for it, then I could get the info online.
'You can't do it' is a fine answer as
well
george
- Original Message -
From:
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 3:35 PMTo: Multiple recipients of
list ORACLE-LSubject: Re: x$ksmpp table
question
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 of list ORACLE-L
Sent: Thursday, December 27, 2001
2:20 PM
Subject: RE: x$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 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) 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 shadow process (in particular, not the one associated with the
ssession running the query).
Thanks,
George
--- http://www.pythian.com -- [EMAIL PROTECTED]
-- 877-PYTHIANSmarter than adding another team member,
Pythian has new services forsupplementing DBAs: get our help with
monitoring, 24x7 on-call, dailyverifications, storage management,
performance and
more.
Re: x$ksmpp table question
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 of list ORACLE-L Sent: Thursday, December 27, 2001 2:20 PM Subject: RE: x$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 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) 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 shadow process (in particular, not the one associated with the ssession running the query). Thanks, George --- http://www.pythian.com -- [EMAIL PROTECTED] -- 877-PYTHIANSmarter than adding another team member, Pythian has new services forsupplementing DBAs: get our help with monitoring, 24x7 on-call, dailyverifications, storage management, performance and more.
x$ksmpp table question
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 shadow process (in particular, not the one associated with the ssession running the query). Thanks, George --- http://www.pythian.com -- [EMAIL PROTECTED] -- 877-PYTHIANSmarter than adding another team member, Pythian has new services forsupplementing DBAs: get our help with monitoring, 24x7 on-call, dailyverifications, storage management, performance and more.
weird pga swelling
I'm experiencing a weird issue I've never encountered before. One of my clients runs a moderately active database being connected to by a group of webservers running mod_perl, making a 'standard' set of queries to generate dynamic content. 'standard' in this sense means that the queries are unchanged for many months, none of them are particularly expensive. Randomly (once/twice week) I'm having shadow processes (LOCAL=NO sessions) whose PGA is welling to huge sizes. I am measuring this with pmem. I see things like: 3606: oracleFLPDT (LOCAL=NO) Address Kbytes Resident Shared Private Permissions Mapped File 0001 24776 19960 19960 - read/exec oracle 0185 240 240 208 32 read/write/exec oracle 0188C000 1083848 946408 - 946408 read/write/exec[ heap ] 8000 1143448 1143448 1143448 - read/write/exec/shared [shmid=0x2db5] That's 1G of private heap usage by that one process. These sessions are not stuck running any particular sql, I have caught them executing any and all of the standard application code and they don't seem to be spinning on any particular 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 verifications, storage management, performance and more.
Re: retrieving objects usign OCI
> Actually this code is written for Oracle8, which I > believe doesnot support user-defined object retrieval > using OCI. A casual glance over the code shows that > there are no OCI calls like OCIDefineObject, > OCIObjectNew etc. which may be needed to define place > holders for return values on a statement fetch. I believe that oci8 supports these calls (I've never used them, but they are in the 8i oci programmers ref guide). I can't give you a reference I can personally vouch for, but these hits off google looked good. http://www.ms.mff.cuni.cz/~kopecky/ora8doc/appdev.804/a58234/app_exam.htm http://uisnt1.humboldt.edu/otn/library/product/tools/pg2k/info/oci_tips.pdf http://www.math.ut.ee/~askot/oradox/orasupp/coderep/cat9/smpl0069.htm http://www.math.ut.ee/~askot/oradox/orasupp/coderep/cat9/smpl0029.htm Plus of course the Oracle OCI Programmers reference whihc you can get off technet. As a note Oracle::OCI supports those calls, but I don't see any examples of how it's used besides the ones here: http://www.cpan.org/modules/by-authors/Tim_Bunce/OCI_Talk1_200106.zip If whomever mentioned examples of this in work could 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 hard. >> 30 seconds on CPAN >> led me to: >> >> > http://www.cpan.org/modules/by-module/Oraperl/TIMB/Oracle- >> OCI-0.06.tar.gz, >> a tar ball with the latest veriosn of the perl >> module mentioned. That >> having been said, I don't believe this module has >> any useful 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. >> >> George >> >> // 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 and more. >> >> >> > > __ > Do You Yahoo!? > Send your FREE holiday greetings online! > http://greetings.yahoo.com > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: siddharth aggarwal > 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, 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 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 / 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-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).
Re: retrieving objects usign OCI
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-0.06.tar.gz, a tar ball with the latest veriosn of the perl module mentioned. That having been said, I don't believe this module has any useful 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. George // 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 and more. On Tuesday, December 25, 2001, at 01:55 AM, siddharth aggarwal wrote: Hi, I checked out the cpan website but couldn't find any such OCI examples that you have mentioned. I would really appreciate if you could send the appropriate link. Thanks, Sid --- Steven Lembark <[EMAIL PROTECTED]> wrote: I am trying to retrieve objects from an ORACLE 8i database using OCI. I have attached some code that I wrote for the same but it fails at the OCIStmtFetch call with the error ORA-00932 inconsistent datatypes. Has anyone worked on such an issue before? Thanks in advance. Check out Oracle::OCI on CPAN. It is a Perl interface to the OCI lib's by the same gent who wrote DBI and DBD::Oracle. It has plenty of examples -- both from the internal code using OCI and the Perly interface. -- Steven Lembark 2930 W. Palmer Workhorse Computing Chicago, IL 60647 +1 800 762 1582 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steven Lembark 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, 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 information (like subscribing). __ Do You Yahoo!? Send your FREE holiday greetings online! http://greetings.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: siddharth aggarwal 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, 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 information (like subscribing).
Re: diagnosing latch free
A sort extent pool latch? That's weird. You can get the sid of the guy holding the latch by joining v$latch.addr (or v$latchchildren if it's a latch with children - sort extent is not) against v$latchholder.laddr. something like select sid from v$latch l, v$latchholder lh where l.addr = lh.laddr and l.name = 'sort extent pool'; On Saturday, December 8, 2001, at 06:20 PM, Doug C wrote: > Ok.. it's a sort segment latch.. any way to find out why? It's been > sitting > around for over an hour ... > > On Sat, 08 Dec 2001 14:35:18 -0800, 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 Schlossnagle wrote: >> >>> Try: >>> >>> select ln.name from v$session_wait sw, v$latchname ln where sw.p2 = >>> ln.latch#. >>> >>> Best, >>> >>> George >>> >>> 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 and more. >>> >>> >>> On Saturday, December 8, 2001, at 04:05 PM, Doug C wrote: >>> >>>> I have a session that seems to be hung on a sql_statment. >>>> >>>> Here is it's session_wait entry: >>>> >>>>SID SEQ# >>>> -- -- >>>> EVENT >>>> >>>> P1TEXT >>>> P1 >>>> >>>> -- >>>> P1RAWP2TEXT >>>> >>>> >>>> P2 P2RAW >>>> -- >>>> P3TEXT >>>> P3 >>>> >>>> -- >>>> P3RAW WAIT_TIME SECONDS_IN_WAIT STATE >>>> -- --- --- >>>> 62 1239 >>>> latch free >>>> address >>>> 805352248 >>>> 3000B338 number >>>> 88 0058 >>>> tries >>>> 923 >>>> 039B 0 0 WAITING >>>> >>>> >>>> The seq# goes up from time to time. >>>> My question is how to determine what kind of latch is bothering it? >>>> Does P2 (88) indicate what type of latch? Can I join with some other >>>> table to >>>> find out what 88 is? >>>> >>>> Thanks, >>>> D >>>> -- >>>> Please see the official ORACLE-L FAQ: http://www.orafaq.com >>>> -- >>>> Author: Doug C >>>> 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, 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 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 / 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-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
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 where sw.p2 = ln.latch#. Best, George 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 and more. On Saturday, December 8, 2001, at 04:05 PM, Doug C wrote: I have a session that seems to be hung on a sql_statment. Here is it's session_wait entry: SID SEQ# -- -- EVENT P1TEXT P1 -- P1RAWP2TEXT P2 P2RAW -- P3TEXT P3 -- P3RAW WAIT_TIME SECONDS_IN_WAIT STATE -- --- --- 62 1239 latch free address 805352248 3000B338 number 88 0058 tries 923 039B 0 0 WAITING The seq# goes up from time to time. My question is how to determine what kind of latch is bothering it? Does P2 (88) indicate what type of latch? Can I join with some other table to find out what 88 is? Thanks, D -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Doug C 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, 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 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 / 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-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).
Re: diagnosing latch free
Try: select ln.name from v$session_wait sw, v$latchname ln where sw.p2 = ln.latch#. Best, George 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 and more. On Saturday, December 8, 2001, at 04:05 PM, Doug C wrote: > I have a session that seems to be hung on a sql_statment. > > Here is it's session_wait entry: > >SID SEQ# > -- -- > EVENT > > P1TEXT > P1 > > -- > P1RAWP2TEXT > > > P2 P2RAW > -- > P3TEXT > P3 > > -- > P3RAW WAIT_TIME SECONDS_IN_WAIT STATE > -- --- --- > 62 1239 > latch free > address > 805352248 > 3000B338 number > 88 0058 > tries > 923 > 039B 0 0 WAITING > > > The seq# goes up from time to time. > My question is how to determine what kind of latch is bothering it? > Does P2 (88) indicate what type of latch? Can I join with some other > table to > find out what 88 is? > > Thanks, > D > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Doug C > 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, 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 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 / 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-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).
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: Multiple recipients of list ORACLE-L Sent: Friday, November 16, 2001 10:30 AM Subject: RE: Internal Benchmarking I've had some luck with the tools described in Scaling Oracle8i by Morle. It has and awk script to parse out 10046 event trace sql and bind variable information and produce a tcl script suitable for dbaman. Dbaman is an extended tcl shell sotra-likea oratcl. I've used it to run sql that I have captured by setting event 10046. I turn on tracing for the system and for sessions already running. After the time period has elapsed I turn it off and proceed to collect all trace files into a working directory. I then feed each trace file into the awk script to produce the dbaman tcl script. I use a separate instance of dbaman to process each tcl file. I then reload the database from a golden copy and re-run the scripts, then repeat until I reach my tuning goal. A few gotcha's; the current dbaman works with 7.3 libraries. And it has a quirk with the interpretation of the bind variables. If the bind variable begins with a number then it assumes that the rest of the characters are also numbers, so it chokes on "123ABC" when it fires of an execute operation. I dug into the dbaman code, found the IF-THEN line that was checking the first character and commented out the entire statement. I rebuilt dbaman according to the instructions and it worked. I'll post the changes if you are going to pursue dbaman. The only thing I didn't try was to simulate the think/latency time. But that time can be extracted from the tim column in the sql trace file. I would do this in the awk script that is doing the initial translation of raw trace to dbaman tcl. The tim value is in 100'ths of a second but I don't know how to convert it to actual time of day. But the relative time between statements can be derived from it. HTH. Tony Aponte -Original Message- From: Orr, Steve [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 14, 2001 4:00 PM To: Multiple recipients of list ORACLE-L Subject: Internal Benchmarking Howdy All, I want to create some database-only benchmarking scripts to reflect a typical day in the life of a custom application. I'm thinking about using LogMiner to get the redo and v$sqlarea to derive a representative mix of queries. Maybe we can also sniff/parse the network traffic to the DB server. Since I'm looking only at database activity I'm not too keen on applications which merely record and replay end-user keystrokes and mouse clicks but I would like to mimic delays in transaction commits due to network latency and user indecision or whatever. I'd also like to be able to increase the load intensity by factors of 10 to 1000. Has anyone created any application specific benchmark routines and can you share some tips on how to do this? Any good tools that you have used? Any comments on Mercury Interactive stuff? Other ideas? AtDhVaAnNkCsE, Steve Orr -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Orr, Steve 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, 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 information (like subscribing).
Re: Code to Validate email addresses
- Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Wednesday, October 24, 2001 9:15 AM > Hi, > > We have implemented a form that emails reports. The user has to enter his > email address. > > However, we are finding that a lot of users are entering incorrect and > invalid email addresses. > > Obviously, we can do nothing if they enter an incorrect (but syntactically > correct) email address. > > What I am looking for is: > > 1) A definition of the syntactically correct format of an email address > (from some sort of authoritative source) check out rfc 822 : http://www.faqs.org/rfcs/rfc822.html > > 2) Hopefully some pl/sql code that will validate a sting to see if it is a > valid email address. That's tough. To really syntactically validate an email address is really hard. There's a 3 page perl program in the backof the O'reily Matsering Regular Expressions Book that does the trick nicely. Maybe you could convert it to something in sqlj. > > If anyone can assist, I would appreciate it! > > Regards > Oweson Flynn > _ > "Tell me what you think, Captain, I'm all ears" - Spock > > Certified Oracle DBA > The Flynn Consultancy > Tel: 082-600-7-006 > Fax: (011) 782-9313 > EMail: [EMAIL PROTECTED] > > > > *** > > This message may contain information which is confidential and subject to legal privilege. If you are not the intended recipient, you may not peruse, use, disseminate, distribute or copy this message. If you have received this message in error, please notify the sender immediately by email, facsimile or telephone and return and/or destroy the original message. > > *** > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Oweson Flynn > 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, 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 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 / 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-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).
Re: Veritas Quickio and DB_BLOCK_SIZE
> Hi George, > > I wanted to make sure that the information I was > giving you was as accurate and current as possible. > This prompted me to have one of my guys to check it > out in the Veritas Documentation, before I sent out > the note. The documentation for version 3.3, clearly > states that the default logical blocksize for Veritas > is 1024 bytes. Your take about the automatic scale-up > for very large files may also be true. Hmmm... I'm running 3.2 and it defintely manifests scaleup. I tried it with various partition sizes, it defaulted to 1k, then scaled to 2k, hit 4k at around 300G (the biggest single volume I had to play with). > > Regardless, I think the point I was trying to drive > home is simple - You need to ensure "equality" of > db_block_size and the filesystem block size. The > default value may change across releases and that is > not something that we have control over 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 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, 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 information (like subscribing).
Re: Veritas Quickio and DB_BLOCK_SIZE
> I/O tuning fundamentals require us to ensure that the > filesystem blocksize = db_block_size. The default > filesystem blocks size in Veritas is 1K and it is more > than likely that almost every Veritas filesystem that > is out there is in fact created with an 1K block size. > This is true even though we are talking about Quick > I/O which works on a Veritas-simulated raw device. I don't believe this is true. I believe Veritas automatically scales it's default block size depending on the size of the partitiion you create, either 1k, 2k, 4k or 8k depending 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 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, 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 information (like subscribing).
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: Multiple recipients of list ORACLE-L Sent: Thursday, October 04, 2001 2:50 PM Subject: RE: Max number of sessions Oracle uses PROCESSES + 10% + 5 for setting the hard limit of the sessions parameter. "Do not criticize someone until you walked a mile in their shoes, that way when you criticize them, you are a mile a way and have their shoes." Christopher R. Spence Oracle DBA Phone: (978) 322-5744 Fax: (707) 885-2275 Fuelspot 73 Princeton Street North, Chelmsford 01863 -Original Message-From: Yuval Arnon [mailto:[EMAIL PROTECTED]] Sent: Thursday, October 04, 2001 2:16 PMTo: Multiple recipients of list ORACLE-LSubject: Max number of sessions Hi, I would like to find out how to compute/estimate the maximum number of sessions a db can handle. Preferably based on the init.ora params sessions and processes, size of sga, size of ram, the /etc/system params etc. This is for a db running using MTS. TIA Yuval.
Re: Backup Strategy
om). 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-- 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 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).
Re: Network Appliance Options
>From what I've read on the sun-managers list, Oracle on Netapp is just a dog (no pony for you!). George - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Monday, September 24, 2001 6:07 PM > Has anyone used Network Appliance? > > Any options good/bad appreciated as it applies to Unix (Solaris and HP) and Oracle 8.1.6 and above. > > Going to a dog and pony show by them tomorrow. > > Kathy > > Confidential > This e-mail and any files transmitted with it are the property > of Belkin Components and/or its affiliates, are confidential, > and are intended solely for the use of the individual or > entity to whom this e-mail is addressed. If you are not one > of the named recipients or otherwise have reason to believe > that you have received this e-mail in error, please notify the > sender and delete this message immediately from your computer. > Any other use, retention, dissemination, forwarding, printing > or copying of this e-mail is strictly prohibited. > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Kathy Duret > 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, 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 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 / 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-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).
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, August 28, 2001 4:16 PM Subject: Re: OT : kernel using 75% of CPU Does anybody know how I can see how much memory each process is using under Solaris. On Digital UNIX it was ps -aux, if I remember correctly... Thanks! Jerry - Original Message - From: Jerry C To: [EMAIL PROTECTED] Sent: Tuesday, August 28, 2001 2:58 PM Subject: Re: OT : kernel using 75% of CPU Thanks for the reply, Chris. I'm a bit ashamed, being as old as I am, that I don't have a better grasp on swapping. I initially thought maybe it was a swap problem also, but top shows 0.0% swap. I thought I had also checked vmstat earlier, but yikes: csuaor46> csuaor46> vmstat 15 20 procs memory page disk faults cpu r b w swap free re mf pi po fr de sr s6 s1 s1 s5 in sy cs us sy id 2 0 0 15352 14472 68 1513 14 227 953 56488 260 0 2 2 0 638 78 933 25 24 50 11 0 0 6240696 63336 105 1759 41 246 1754 62760 545 0 8 8 0 1130 4956 773 22 76 1 11 0 0 6243360 62864 42 2594 82 236 2357 62760 757 0 7 6 0 1239 6960 987 40 60 1 8 0 0 6238120 62368 48 1746 25 260 3767 56488 1198 0 7 6 0 1052 4837 762 36 63 1 8 0 0 6239640 65200 33 1772 229 262 2092 62760 619 0 16 16 0 1232 5776 871 28 70 2 5 1 0 6247656 62440 57 2078 162 497 4025 62760 1308 0 15 15 0 1216 5808 815 21 75 4 5 0 0 6247776 63456 26 2445 149 285 2716 62760 2188 0 11 13 0 1164 6593 903 17 79 4 10 1 0 6240680 62648 80 3008 266 523 4527 62760 9226 0 25 25 0 1127 6725 884 22 76 2 6 0 0 6218216 68664 33 2251 66 105 1086 62760 377 0 6 6 0 847 20782 744 31 67 2 5 0 0 6201240 62840 9 1799 72 350 2490 62760 415 0 9 9 0 1207 8889 781 15 80 5 5 0 0 6199336 62760 6 1935 40 923 3564 62760 636 0 9 9 0 1373 5193 1082 21 69 10 10 0 0 6189552 63840 11 1476 33 722 3089 62760 548 0 9 8 0 1364 4530 957 21 77 2 10 0 0 6174304 70704 25 2705 86 759 6441 62760 1003 0 10 10 0 1258 5551 836 29 67 4 8 0 0 6186512 63824 51 1728 44 227 1413 56488 188 0 9 7 0 1319 4485 676 31 68 0 7 0 0 6196448 63064 49 1635 44 235 1179 62760 167 0 4 4 0 1207 4968 694 39 61 1 9 0 0 6188656 63872 11 1915 112 433 2065 62760 308 0 13 12 0 1140 4835 828 37 62 1 Do the pi (page in) and po (page out) statistics represent swapping?! Thanks again, Jerry - 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 paging and swapping is the first thing that comes to mind, look at vmstat. I think your question is completely on topic. "Do not criticize someone until you walked a mile in their shoes, that way when you criticize them, you are a mile a way and have their shoes." Christopher R. Spence Oracle DBA Phone: (978) 322-5744 Fax: (707) 885-2275 Fuelspot 73 Princeton Street North, Chelmsford 01863 -Original Message-From: Jerry C [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 28, 2001 11:20 AMTo: Multiple recipients of list ORACLE-LSubject: OT : kernel using 75% of CPU Hi there, I have a Sun e4500, running Solaris 2.7 and Oracle 8.1.7.1.0. Everything looks normal from a database perspective, but when I run "top" it show the kernel being very hog-like: load averages: 14.38, 15.18, 15.18 07:16:21126 processes: 118 sleeping, 4 running, 4 on cpuCPU states: 0.6% idle, 26.6% user, 72.8% kernel, 0.0% iowait, 0.0% swapMemory: 4096M real, 63M free, 216M swap in use, 5310M swap free PID USERNAME THR PRI NICE SIZE RES STATE TIME CPU COMMAND 2286 oracle 1 0 0 1844M 1814M run 9:44 13.90% oracle11068 oracle 1 0 0 2056K 1536K cpu0 0:02 1.53% top11333 oracle 1 0 0 1150M 1124M cpu1 0:01 1.39% oracle 5944 oracle 1 40 0 1820M 1789M sleep 14:40 1.36% oracle 4797 root 1 50 0 2112K 1248K sleep 6:01 1.36% top11346 oracle 1 0 0 110M 92M cpu0 0:01 1.26% oracle4 oracle 1 0 0 1009M 984M cpu1
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 noticed a fairly high load average, it appears you have a lot of processes trying to get on the cpu, for a very long time, over the last 15 minutes you have had 15 load average which is high. "Do not criticize someone until you walked a mile in their shoes, that way when you criticize them, you are a mile a way and have their shoes." Christopher R. Spence Oracle DBA Phone: (978) 322-5744 Fax: (707) 885-2275 Fuelspot 73 Princeton Street North, Chelmsford 01863 -Original Message-From: Jerry C [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 28, 2001 11:20 AMTo: Multiple recipients of list ORACLE-LSubject: OT : kernel using 75% of CPU Hi there, I have a Sun e4500, running Solaris 2.7 and Oracle 8.1.7.1.0. Everything looks normal from a database perspective, but when I run "top" it show the kernel being very hog-like: load averages: 14.38, 15.18, 15.18 07:16:21126 processes: 118 sleeping, 4 running, 4 on cpuCPU states: 0.6% idle, 26.6% user, 72.8% kernel, 0.0% iowait, 0.0% swapMemory: 4096M real, 63M free, 216M swap in use, 5310M swap free PID USERNAME THR PRI NICE SIZE RES STATE TIME CPU COMMAND 2286 oracle 1 0 0 1844M 1814M run 9:44 13.90% oracle11068 oracle 1 0 0 2056K 1536K cpu0 0:02 1.53% top11333 oracle 1 0 0 1150M 1124M cpu1 0:01 1.39% oracle 5944 oracle 1 40 0 1820M 1789M sleep 14:40 1.36% oracle 4797 root 1 50 0 2112K 1248K sleep 6:01 1.36% top11346 oracle 1 0 0 110M 92M cpu0 0:01 1.26% oracle4 oracle 1 0 0 1009M 984M cpu1 0:00 0.66% oracle11157 oracle 1 0 0 1009M 984M run 0:00 0.63% oracle11368 oracle 1 33 0 1794M 1765M sleep 0:00 0.29% oracle19558 oracle 1 60 0 1797M 1751M sleep 78:28 0.28% oracle19554 oracle 1 60 0 1794M 1751M sleep 38:05 0.20% oracle11366 oracle 1 55 0 1793M 1763M sleep 0:00 0.19% oracle11292 oracle 1 26 2 2008K 1424K run 0:00 0.19% dsql Any ideas on what I, as a lowly DBA, would be able to check? It's a bit out of my area and I'm stumped... Thanks! Jerry
Re: database upgrade policy?
The scary part is that it is (was I guess), a very low-concurrency fledgling datawarehouse-type instance. The rest of our shop is very high-transaction oltp. Still, I just chalk it up to a lesson learned. It was built out on 9i as an opportunity to try out 9i. - Original Message - 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] >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> >Subject: Re: database upgrade policy? >Date: Thu, 23 Aug 2001 11:16:02 -0800 > >Sure. We seemed to be suffering from bug 1904199 or a variant. We >experienced frequent deadlocks on resources: > >Sat Aug 4 08:03:21 2001 >Errors in file /opt/db/oracle/admin/report/bdump/report_smon_13262.trc: >ORA-00060: deadlock detected while waiting for resource >Sat Aug 4 08:03:25 2001 >Errors in file /opt/db/oracle/admin/report/bdump/report_smon_13262.trc: >ORA-00060: deadlock detected while waiting for resource >Sat Aug 4 08:03:29 2001 >Errors in file /opt/db/oracle/admin/report/bdump/report_smon_13262.trc: >ORA-00060: deadlock detected while waiting for resource >Sat Aug 4 08:03:34 2001 >Errors in file /opt/db/oracle/admin/report/bdump/report_smon_13262.trc: >ORA-00060: deadlock detected while waiting for resource >Sat Aug 4 08:03:38 2001 >Errors in file /opt/db/oracle/admin/report/bdump/report_smon_13262.trc: > >followed by 7445s and 600s and then SMON terminating > >After one of these crashes, we were unable to reopen the database: > > >Then one day on trying to reopen the database following > >Errors in file /opt/db/oracle/admin/report/udump/report_ora_14226.trc: >ORA-00600: internal error code, arguments: [kteoprpect-1], [2], [1], [], >[], [], [], [] >Sun Aug 12 21:38:45 2001 >Errors in file /opt/db/oracle/admin/report/udump/report_ora_14226.trc: >ORA-00600: internal error code, arguments: [kteoprpect-1], [2], [1], [], >[], [], [], [] >Sun Aug 12 21:38:45 2001 >Error 600 happened during db open, shutting down database >USER: terminating instance due to error 600 >Instance terminated by USER, pid = 14226 >ORA-1092 signalled during: alter database open... > >Our support analysts saud that a fix was in progress and that there was no >known way to recover, even an ALTER DATABASE OPEN RESETLOGS. A choice >tidbit from the bug report: > >"This could be quite serious for customers as there is no simple way out of >this scenario." > >Buyer beware. > > > > - Original Message - > From: JOE TESTA > To: [EMAIL PROTECTED] ; [EMAIL PROTECTED] > Sent: Thursday, August 23, 2001 2:08 PM > Subject: Re: database upgrade policy? > > > George, are you willing to expand on what it was, for the rest of us? > > joe > > > >>> [EMAIL PROTECTED] 08/23/01 02:52PM >>> > We just had a total database lost under 9i. Known bug, no workaround, > better-luck-next-time type situation. Luckily for us we were testing it >on > a non-critical database, but that puts me off it for a while. > > George > > - Original Message - > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> > Sent: Thursday, August 23, 2001 1:27 PM > > > Good for you, David. We are moving in that direction, too. I convince > people by saying 9i is really 8.2. > > Paul Baumgartel > MortgageSight Holdings, LLC > [EMAIL PROTECTED] > > > -Original Message- > Sent: Thursday, August 23, 2001 12:41 PM > To: Multiple recipients of list ORACLE-L > > > Okay, I know some of you are going to call me crazy but here goes... > > **We're now using 9i in Production** > > There, I admit it. But I have to ask you this- do you think 9i will be >more > buggy than the 8.1.6 that we were running that was causing core dumps, > referential integrity violations, etc.? I'm betting that 9i will be at > least a little bit better than that. Performance should be better too. > > I'll report back any gotchas (there are bound to be some!). > > > david > > > > -Original Message- > Sent: Thursday, August 23, 2001 9:46 AM > To: Multiple recipients of list ORACLE-L > > Paul, > No it's more like, "Hey, I heard there is a new version of the > database > out, do we have it yet? Why not? Can we have it? Yeah let's do it, >that > would be cool. Oh and
Re: database upgrade policy?
T 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 the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Paul Baumgartel 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, 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 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 / 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-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).
Re: database upgrade policy?
ww.orafaq.com--Author: Kevin Kostyszyn INET: [EMAIL PROTECTED]Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051San Diego, California -- Public Internet 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 ORACLE-L(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: Paul Drake INET: [EMAIL PROTECTED]Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051San Diego, California -- Public Internet 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 ORACLE-L(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: Kevin Kostyszyn INET: [EMAIL PROTECTED]Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051San Diego, California -- Public Internet 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 ORACLE-L(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: David Wagoner INET: [EMAIL PROTECTED]Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051San Diego, California -- Public Internet 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 ORACLE-L(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: Paul Baumgartel INET: [EMAIL PROTECTED]Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051San Diego, California -- Public Internet 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 ORACLE-L(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) 538-5051 FAX: (858) 538-5051San Diego, California -- Public Internet 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 ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).
Re: PHP on Linux with Oracle
you should probably mail this to [EMAIL PROTECTED] George - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Friday, August 17, 2001 9:45 AM > > We've a Problem with PHP4 OCIFetch and varchar2 ! > > OCHIFetch with number or date Filed it work's fine but when i'll fetch a varchar2 Filed then i've no output in the browser ! > > When i dump the array then i see the character is 20 Bytes my field is 10 bytes i suppose so the character is unicode ! > > Anybody have i idea what i can do ? > > -- Rudi > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: > 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, 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 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 / 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-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).
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 +!; This has been running fine for 3 years. Suddenly in the past 3 weeks I have been seeing performance problems and the sudden appearance of some (apprently) constraint checking recursive sql whihc is in direct proportionto the inserts. This recursive sql was never in the sqlarea previously. The lines look like: select executions, sqltext from v$sqlarea; 166092573 INSERT INTO HITCOUNTER ( ALIAS,USEHITCOUNTER,HITS ) VALUES ( :b1,1,0 )165799528 select c.name, u.name from con$ c, cdef$ cd, user$ u where c.con# = cd.con# and cd.enabled = :1 and c.owner# = u.user# Further if I do: desc v$session;select sql_text from v$sqlarea sq, v$session sewhere prev_sql_addr = 'AA46049C' and prev_hash_value = '1318728909'and sql_address = sq.address and sql_hash_value = sq.hash_value; (that sql_address and hsah_value are for the insert statement above) I frequently (though not exclusively the recursive sql) I am always returned either no rows or that recursive sql statement (and these are not the most executed statements in the db either (they are 10th and 11th respectively, and any session is equally likely to run any of the the top 20 executed queries, in any pairings), so I would expect to see others if this was just a coincidence. I've searched Metalink and Google for this sql with basically no luck, and I have an open Tar which is getting no response. has anyone seen anything similair? Any clues, thoughts, etc? --George Schlossnagle1024D/1100A5A0 1370 F70A 9365 96C9 2F5E 56C2 B2B9 262F 1100 A5A0
Re: Off Topic: For Sale Sparc 5 170MHz capable of running 9i
Can you run 9i on 64M of ram? On Saturday, July 21, 2001, at 09:35 PM, Christopher Spence wrote: > If anyone is interested in a cheap machine to start playing with 9i > with. I > just got a lot of 100 Sparc 5's. > > Standard configuration is: > > HyperSparc 170MHz > 64Mb Ram > Internal CDROM and Floppy > Turbo GX Video (13W Connector) > 2Gb SCSI Hard Drive > > I am putting them on ebay at $225 each. Which is less than they > normally go > for, but I just want to get rid of this shipment so I can get this lot > of > Blade 1000's. > > To run Oracle 9i, I would recommend increasing the ram and disk. Which > we > have both. > > Sorry about the off topic, I know a few people mentioned they were > looking > for some machines. > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > 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 > > 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 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 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 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).
Re: UNIX
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: Fisher, Julie > > 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, 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 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 / 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-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: Fisher, Julie > 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, 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 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 / 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-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).
Re: UNIX
Not to be pedantic, but df -k shows all mounted partitions, regardless of whether they are in /etc/vfstab or not. It requires read permisions on /etc/mnttab (whihc should be readable by everyone, but I suppose some sick SA could change it so that only root could read it. The system would function normally, but non-root users wouldn't be able to use df functionally. George - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Tuesday, July 10, 2001 4:29 PM > Richard, > > df -k will show you what slices of a disk have an entry in /etc/vfstab AND > have been mounted using the mount command in Solaris. Whoever has root > privileges to the system (or have been given the right permissions) can use > the format command to see all disks attached to the machine, no matter if > they have been mounted or not - no matter if they have an entry in > /etc/vfstab or not. > > HTH, > > Julie > > > > Julie Fisher > Sandia National Laboratories > Oracle 8i DBA - OCP8i > Solaris 2.6,7/HP-UX 11.0 System Administrator > Web Server Administrator > > > -Original Message- > Sent: July 10, 2001 1:23 PM > To: Multiple recipients of list ORACLE-L > > > Df -k > > This does not cover raid volumes, that would depend which volume manager > your using. > > -Original Message- > Sent: Tuesday, July 10, 2001 1:52 PM > To: Multiple recipients of list ORACLE-L > > > Does anyone know of a command or file that would display the available disks > on a Solaris 2.6 box and/or the corresponding disks for each mount point??? > > TIA, > Richard Huntley > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Richard Huntley > 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, 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 information (like subscribing). > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > 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 > > 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 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-5051 FAX: (858) 538-5051 > San Diego, California-- 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 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 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, 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 information (like subscribing).
Re: Linux profile - a little offtopic
also, try man bash (or whatever your shell is). It will explain what files are sourced under which circumstances. george On Saturday, June 30, 2001, at 01:20 PM, Gregory Conron wrote: > On June 30, 2001 01:30 pm, Csillag Zsolt wrote: >> Hi, >> >> Since I'd like to install Oracle for Linux, I need to change the >> profile for user 'oracle'. >> >> I edited the .profile file located in /home/oracle folder but it >> seems to me that this isn't the file that Linux loads at startup. > > Take a look at /etc/profile - this is the default system-wide user > profile (be aware that all changes to this file will affect all > non-root users on the system). > > Cheers, > GC > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Gregory Conron > 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, 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 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 / 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-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).
Re: Undocumented Init.Ora Parms
And to get their values: select KSPPINM, KSPPSTVL ,KSPPDESC from sys.x_$ksppi ksppi, sys.x_$ksppcv ksppcv where substr(KSPPINM,1,1) ='_' and ksppi.indx = ksppcv.indx; - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Thursday, June 21, 2001 6:42 PM > Jeremiah; > First, thanks. NIce infor to have. > > Second, the first line works great on Solaris and Oracle 8.0.5. > > Third, the sql statement should actually be > select KSPPINM, KSPPDESC from x$ksppi where substr(KSPPINM,1,1) = > '_' > Missed the ,1 parm off the substr. > > -Original Message- > Sent: Thursday, June 21, 2001 5:01 PM > To: Multiple recipients of list ORACLE-L > > > This used to work on other platforms and versions, but my HP-UX 64 bit > binary > doesn't have any interesting strings any more: > > strings $ORACLE_HOME/bin/oracle | perl -ne 'print if /^_[a-z]+_[a-z]/' | > sort | uniq > > The typical location for underscore parameters is x$ksppi: > > (as SYS:) > select KSPPINM, KSPPDESC from x$ksppi where substr(KSPPINM,1) = '_'; > > The event codes (most of them) are documented in > $ORACLE_HOME/rdbms/mesg/oraus.msg, after error number 1. > > -- > Jeremiah Wilton > http://www.speakeasy.net/~jwilton > > On Thu, 21 Jun 2001, Kevin Lange wrote: > > > Is there any place that has a list of ALL the things you can put into > the > > Init file and what they do ?? Not just the regular option strings I > > can get a list of these from a couple of web sites , but all of the hidden > , > > and as far as I know, undocumented EVENT strings as well?? > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Jeremiah Wilton > 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, 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 information (like subscribing). > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Kevin Lange > 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, 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 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 / 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-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).
Re: What the difference between qio and direct I/O option in VxFS
Quick I/O is part of the database edition. Direct I/O is a generic mount option for vxfs artition (standard part of vxfs). Mounting something convosyn=direct avoids s buffer cache for everything, whereas quick i/o actually provides an interface for accessing the file as a raw character device. George - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Wednesday, June 20, 2001 8:51 AM > Direct I/O is part of the Database Edition. > > "Walking on water and developing software from a specification are easy if > both are frozen." > > Christopher R. Spence > Oracle DBA > Fuelspot > > > > -Original Message- > Sent: Tuesday, June 19, 2001 8:15 PM > To: Multiple recipients of list ORACLE-L > VxFS > > > Connor, > > Thanks for the info. Is Direct I/O licensed with the Veritas Volume manager > or the Database edition?? We want to be able to avoid double buffering, > sound like Direct I/O is what we want, however our SysAdmin insisted that we > need to purchase the Database edition, I thought Direct I/O came with the > VxFS file system, maybe the SysAdmin confused Direct I/O to raw ,please > clarify?? > > KC > > > -Original Message- > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > Date: Wednesday, June 20, 2001 2:53 AM > > > > > >Direct IO is the capacity to perform operations > >without the data being passed through the Unix buffer > >cache (it goes straight to/from the disks to the > >Oracle buffer cache) > > > >Quick IO is Veritas's simulation of raw datafiles - it > >presents the file to Oracle as if it were raw. > > > >hth > >connor > > > >--- KC <[EMAIL PROTECTED]> wrote: > Dear List, > >> > >> What the difference between qio and direct I/O > >> option in Veritas file system VxFS?? > >> > >> KC > >> > > > > > >= > >Connor McDonald > >http://www.oracledba.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!? > >Get your free @yahoo.co.uk address at http://mail.yahoo.co.uk > >or your free @yahoo.ie address at http://mail.yahoo.ie > >-- > >Please see the official ORACLE-L FAQ: http://www.orafaq.com > >-- > >Author: =?iso-8859-1?q?Connor=20McDonald?= > > 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, 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 information (like subscribing). > > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: KC > 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, 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 information (like subscribing). > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > 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 > > 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 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 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 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).
Re: Increasing Freelists?
You can do an alter table TABLENAME storage freelists N - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Friday, June 15, 2001 4:01 PM > The table must be dropped, yes. > > Default for table is 1 freelist, 2 for indexes. > > This is not scientific ( both because there are no > data to support it in your post and I have no hard > perf data of my own ) but freelists are small and > easily/rapidly maintained. Unless you have some > sort of "niche-y" oddball application that needs > every drop of space in a block, you can safely bump > yourself up to 10 freelists on your hot tables. Maybe > just a 2x or 4x on your less incandescent ones. > > But, most important: for my money, LoadRunner does > not always accurately simulate actual loads. > > You might be tuning yourself away from a non-existent > problem. > > hth > > -Original Message- > Sent: Friday, June 15, 2001 3:31 PM > To: Multiple recipients of list ORACLE-L > > > We've been load testing an application that will be allowing customers to > enter their email information through the web. The loadrunner application > was experiencing periodic freezing after which it would go back to normal. > Reviewing the statspack information I saw a high number of buffer busy waits > with the majority of the buffer waits being data block waits. This is not > surprising, since the application is doing heavy inserts into several > tables. > The recommendation from an article I have is to create multiple freelists > for the tables undergoing heavy inserts. I've never done this before and I > have no idea of how many to create. Increase the freelists from 1 to 2? > More? What about freelist groups? > > And am I correct that the table must be dropped and recreated to increase > this parameter? > > I was hoping to have read Gaja's book before I had to deal with this but > it's still in the mail :). > > Thanks in advance. > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Miller, Jay > 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, 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 information (like subscribing). > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Mohan, Ross > 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, 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 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 / 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-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).
Re: Veritas Quick I/0 and Oracle/ Asycnchronous I/O
It seems sarcasm may be beyond you. Check the smileys for emphasis in Alex's mail. - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Monday, June 11, 2001 4:00 PM > I disagree wholeheartedly with this statement Alex. How can you make this > statement without knowing the situation? (You seem to be becoming the > resident troller in this group! Sorry, but it does appear that way.) > > In spite of all evidence and repeated warnings, management often does not > allow the most reasonable "solution" - preferring instead to play ostrich > and simply throw hardware at the problem. Then one day even this isn't > enough or it becomes prohibitively expensive and they want to hold someone > else responsible for their own bad decisions - and the all too common > scapegoat hunting expedition begins! That is when I usually forward to the > "hunters" the same email that I sent them three years ago (and two years ago > and a year ago , and six months ago, ...) analyzing the problem and > proposing a reasonable solution - with attached proof (e.g. tkprof output > showing how rewriting a few problematic queries can reduce CPU utilization > by a factor of 72 and LIO by a factor of 6200! A real life example - that > stayed like this for over three and a hlf years!). > > -Don Granaman > [certifiable OraSaurus] > > - Original Message - > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> > Sent: Monday, June 11, 2001 1:40 PM > > > > Of cource you did not do your job properly. Or are you telling us that > > damagement did not do their job properly? I have never heard anything more > > ridiculous. :-). > > > > Alex Hillman > > > > -Original Message- > > Sent: Monday, June 11, 2001 8:50 AM > > To: Multiple recipients of list ORACLE-L > > > > > > Jared wrote: > > > > >I just *had* to point this out. Had too many damagers want to solve > > >everything by buying HW when they have no idea what the problem is. > > > > > > > how about Sun E650, 26 CPUs (yes, I said 26), 9GB RAM > > > > made the application fly. Until we hit THE ultimate peak stress day and > > they died. I had spent the year prior screaming about how the application > > needed some serious rewrite or we would die on that day. Database had been > > "designed" (if you can call it that) by people who did not know Oracle and > > so recreated their flat file system. > > > > They told me that the reason we died was because I had not done my job > > properly. > > > > What's wrong with that picture? > > > > > > _ > > Get your FREE download of MSN Explorer at http://explorer.msn.com > > > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > -- > > Author: Rachel Carmichael > > 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, 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 information (like subscribing). > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > -- > > Author: Hillman, Alex > > 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, 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 information (like subscribing). > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Don Granaman > 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
> 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 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, 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 information (like subscribing).
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 running 'real' apps outside of a *nix environments constantly vacillates between shamefully poor and thankfully poor. :) George I should have called it pagefile - not swap. Paul -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Paul Drake 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, 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 information (like subscribing).
Re: Veritas Quick I/0 and Oracle/ Asycnchronous I/O
Hmmm so it's a pci only interface, so I can't use it with my Enterprise Sun systems, and drivers for Tru64 don't yet exist, so unless you're running Windoze, AIX or Linux, you're out of luck. That's a real bummer. Anyone use Imperial's solid state disks? I played with them at a clients a few months ago. I had a few problems with DMP but they were otherwise very impressive. Fiber interface, so you can put them on a fabric switch and share them between your hosts. http://www.imperialtechnology.com/ On Sunday, June 10, 2001, at 06:05 PM, Paul Drake wrote: > Christopher Spence wrote: >> >> AWESOME looking website >> >> "Walking on water and developing software from a specification are >> easy if >> both are frozen." >> >> Christopher R. Spence >> Oracle DBA >> Fuelspot >> >> -Original Message- >> From: Paul Drake [mailto:[EMAIL PROTECTED]] >> Sent: Sunday, June 10, 2001 4:34 PM >> To: [EMAIL PROTECTED] >> Cc: [EMAIL PROTECTED] >> Subject: Re: Veritas Quick I/0 and Oracle/ Asycnchronous I/O >> >> http://www.platypustechnology.com/default2.asp > > Christopher, > > I like the section that dicusses how it "makes Citrix suck less". > > I was thinking about a pair of these for (oracle mirrored) online redo > logs. > 2 units of 1 GB each would have plentry of room - half for redo and half > for swap. > If it works really well, get a 3rd unit for swap alone - but it would > have to be on another bus channel. > > this is where having multiple PCI bus channels (e.g. 4) really makes a > big difference. > 1 for internel storage (ultra 160/m SCSI) > 1 for external storage (fibre channel or ultra 160/m SCSI) > 1 for gigabit network cards (and backup fast ethernet card) > 1 for PCI NVRAM for swap and online redo > > 64 bit slots allow for (max) 350 MB/sec transfers. wow. > cdw has these (special order) - > http://www.cdw.com/shop/products/default.asp?EDC=209969 > the one listed looked like it supported a 32 bit interface. > $2500 each. ouch. > sounds like a good way of justifying an adequate number of hard drives > for online redo. > > Paul > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Paul Drake > 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, 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 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 / 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-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).
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 MB/sec transfers. wow. cdw has these (special order) - http://www.cdw.com/shop/products/default.asp?EDC=209969 the one listed looked like it supported a 32 bit interface. $2500 each. ouch. sounds like a good way of justifying an adequate number of hard drives for online redo. Paul -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Paul Drake 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, 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 information (like subscribing).
Re: Veritas for Oracle, What is it.
>> There are a number of veritas products for Oracle on Sun. The main two are veritas databse edition for oracle, which consists of veritas volume manager, file system, quick i/o (for doing raw character device access to files - the best of raw and cooked file systems) and storage checkpoints (for doing persistent file system snapshots and incremental snapshots mainly for backups). The other is netbackup block-level incremental extension for netbackup, whihc interfaces with the above-mentioned storage checkpoints for doing block-level incremental backups with nb. George >> We are in the process of justifying Oracle Manufacturing. The system >> quote >> from SUN has this item Veritas for Oracle (14+K). >> >> Can someone give me an explanation of what it is? The sales rep was >> not >> sure stating it was for backup/recovery of an Oracle database. We >> currently are licensed for Legato Networker, and it looks like a >> redundant >> purchase if we include this line item. > > ... > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Eric D. Pierce > 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, 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 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 / 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-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).
Re: Shared Pool info - V$sqlarea.
Particularly, this can be caused by a huge amount of logical IO (proportionately dwarfing the amount of disk io and resulting in a falsely 'positive' hit ratio). Take a look at your sqlarea again and look at buffer_gets/executions - that may kick up some queries doing more logical io than you want. George On Tuesday, June 5, 2001, at 10:40 PM, Jared Still wrote: > > Did you say 99% hit ratio? > > Contrary to a once popular opinion, that is > not really a good thing. > > It often means there's a cartesian product > in a join, caused by not fully specifying > the join key. At least that's the reason > I've usually seen for it. > > Keeps disk access down though. :) > > Jared > > On Tuesday 05 June 2001 05:25, Raj Gopalan wrote: >> Thanks Chris. >> >> The problem I am facing is 100% CPU usage and memory paging out at >> times. I >> tought the starting point is v$sqlarea. Purchasing of Precise SQL or >> SQL >> Vision can not happen here immediately. The RAM size is 512MB and SGA >> is >> 210MB. The buffer cache hit ratio is 99%. >> >> I was just wondering is there any way to find out the cause of this >> problem? >> >> TIA >> >> Cheers >> >> Raj >> >> -Original Message- >> Sent: 01 June 2001 19:51 >> To: Multiple recipients of list ORACLE-L >> >> >> Oracle has no guarentee how long statistics and plans will be >> available for >> statements, depending on the activity of the database they may be >> there for >> 2 seconds they may be there for 2 weeks. >> >> Products like Precise SQL and SQL Vision Lab help in that manor where >> they >> capture transactions and activity continuously in a non-intrusive >> manor. >> This is the only guarenteed way to get 99.999% of the transactions. >> >> >> "Walking on water and developing software from a specification are >> easy if >> both are frozen." >> >> Christopher R. Spence >> Oracle DBA >> Fuelspot >> >> >> >> -Original Message- >> Sent: Friday, June 01, 2001 12:16 PM >> To: Multiple recipients of list ORACLE-L >> >> >> DBAs >> >> The statistics in v$sqlarea is getting flushed very often. >> >> In the morning I found the a query which has more than 10,000 disk >> reads as >> the top one. But now the top most query with disk reads has not more >> than >> 100 disk reads. I have not bouncd the DB or flushed the shared pool. >> The >> overall library cache hit ratio is 97%.where us SQLAREA hit ratio is >> 60%. >> >> Any Idea what could be reason? >> >> TIA, >> >> Raj > -- > Please 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 > > 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 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 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 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).
Re: How do I corrupt a block
You can write a little perl script to write over the block. Just open the datafile, sysseek to (block_number)*(block_size), then syswrite(chr(0),block_size). Strangely though, the naive approach of overwriting a block entirely with nulls results in a block which is not detectable with dbms_repair (though you will definitely get a corrupt block error). If you want to be more clever (for example, altering the itl lists in the block, which is detectable by dbms_repair), then I would recommend do a formatted dump with alter system dump datafile the doing a raw dump of the block with dd if=... ibs=block_size skip=block_number count=1, viewing that with a hex editor and then comparing the two. The location and structure of the header components is pretty obvious. You can then use the method above to change what you want to change. Of course, doing any of this can damage your database beyond repair and you won't be supported by oracle support, etc. George - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Thursday, May 31, 2001 4:01 PM > > It apparently is only on NT, and unless you have the password, > which is known only to Oracle Support Personnel, you can't > use it. > > http://www.ixora.com.au/q+a/0101/23224038.htm > > Jared > > > On Thursday 31 May 2001 12:10, K Gopalakrishnan wrote: > > Hi ! > > > > > > The simple thing is you can edit the datablocks using > > BBED editor. It is shipped with Oracle and You need a > > password to use that utility. You can browse and edit > > the data blocks. > > > > > > $BBED will give the required details. BUT IT IS > > DANGEROUS>>>>>>>>>>>> > > > > --- novicedba <[EMAIL PROTECTED]> wrote: > > > hi, > > > This may sound funny. I want to know how to > > > corrupt a block. I want to test the different > > > methods of identifying block corruption, but I don't > > > have sample data blocks. > > > Please help me > > > > > > novice > > > > = > > Have a nice day !! > > > > Best Regards, > > K Gopalakrishnan, > > Bangalore, INDIA. > > > > __ > > Do You Yahoo!? > > Get personalized email addresses from Yahoo! Mail - only $35 > > a year! http://personal.mail.yahoo.com/ > -- > Please 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 > > 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 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 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 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).
Re: Performance tuning
No to be overly pedantic, but RAID5 does not change the number of write() calls made by DBWR. It will change the number of disk operations done by your hardware controller or your software raid drivers, but that's slightly different. - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Wednesday, May 30, 2001 2:02 PM > Raid 5 can consume as much as 60% overhead for writes. > > "Walking on water and developing software from a specification are easy if > both are frozen." > > Christopher R. Spence > Oracle DBA > Fuelspot > > > > -Original Message- > Sent: Wednesday, May 30, 2001 12:51 PM > To: Multiple recipients of list ORACLE-L > > > John, have you read Cary Millsap's paper on RAID 5? www.hotsos.com I > believe. RAID 5 will require additional writes by DBWR which is going to be > huge overhead during a dataload. > > - Ethan Post > > -Original Message- > Sent: Wednesday, May 30, 2001 6:51 AM > To: Multiple recipients of list ORACLE-L > > > FOR YOUR INFORMATION > > ESIS and EPFAL are now part of Logica. The Internet email addresses of the > staff has changed to the following - [EMAIL PROTECTED] eg > [EMAIL PROTECTED] Emails using the old format will continue to be delivered > until 30th June 2001. > > Peter McLarty wrote > "Are you running RAID and if so what configuration. (Not RAID 5 I hope)" > > Interesting. I am posting an excerpt from Doc 97597.1 Optimising Raid > performance for Oracle RDBMS on NT > > RAID 5 is useful for Oracle datafiles but not for redo log files or rollback > segments which are sequentially accessed. Datafiles belonging to the > temporary tablespace are not suitable for a RAID 5 device. More benefits > will be seen in situations where reads predominate over writes. > > I know that in this instance it is a data load that is being discussed but > presumably once the data is loaded then it will be read more than once. > > Certainly the tone of the note suggests that raid 5 is not a definite no-no > rather a 'be cautious as to which files are placed where'. It is my belief > that often a single raid level is set for all files rather than a mix of > raid 1 and raid 5 as appropriate. > > Peter, I fully agree that the level of memory utilised here is totally > insufficient and is very likely to be the constraining factor in this case. > > John > > > -- -- > -- > This e-mail is intended for the use of the addressee(s) only and may contain > privileged, confidential, or proprietary information that is exempt from > disclosure under law. If you have received this message in error, please > inform us promptly by reply e-mail, then delete the e-mail and destroy any > printed copy. Thank you. > > > == > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Post, Ethan > 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, 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 information (like subscribing). > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > 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 > > 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 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 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 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).
Re: Sessions are waiting on buffer busy wait with P3 value 130 in v$s
Hi Steve, A couple questions: whihc p3 value is the value that indicates a need to increase freelists? Are there any plans to adapt your freeliusts estimation script for tables for indexes as well, or pointers on how to do so (I think I can do a direct port to work off dba_indexes, butparts of the logic aren't clear to me, so I feel like that would be shooting in the dark.) Thanks, George - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Friday, May 25, 2001 12:09 PM v$s > Hi Sri, > > If you can identify the segments involved from the p1 and p2 parameters and put > those segments into a KEEP buffer pool you should be able to get a lot of > relief. Failing that, or if they are too big, consider either increasing > db_block_buffers if you can or setting _db_percent_hot_default to something like > 80. That would allow up to 80% of the DEFAULT buffer pool to be used for hot > buffers thereby improving the caching of the buffers that are causing you to > wait. > > @ Regards, > @ Steve Adams > @ http://www.ixora.com.au/ > @ http://www.christianity.net.au/ > > > -Original Message- > Sent: Friday, 25 May 2001 9:26 > To: Multiple recipients of list ORACLE-L > v$s > > > We've lot buffer busy waits in data block with P3 value 130 in V$session. > > I've read about this in few notes, but still I do not understand few things. > > > P3=130 means: > - > Block is being read by another session and no other > suitable block image was found, so we wait until the read > is completed. This may also occur after a buffer cache > assumed deadlock. The kernel can't get a buffer in a > certain amount of time and assumes a deadlock. > Therefore it will read the CR version of the block. > > Does it mean that the block is being held in an incompatible mode by the > first session or set of sessions reading it in shared mode, and current > session is trying to lock it exclusively for a DML and waiting for the same. > > > What are steps we can take to avoid this types of buffer busy waits? > > Thanks for your help. > Sri > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Srikannan Gopalsamy > 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, 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 information (like subscribing). > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Steve Adams > 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, 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 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 / 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-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).
