Re: Perf Advice Needed: cache buffers chains, high waits, _db_block_hash_buckets

, probably on the order of 10x a second at peak) - all indexes that helped performance are created and around already. :( But, ideally I'd like to be able to prove this is the cause of the hot buffers before fixing anything. Thanks, guys!! James -- James Manning [EMAIL PROTECTED] GPG Key

Re: Oracle learning network v Oracle CBT-Select

[Erik Williams] What is OPP? http://otn.oracle.com/partners/oraclepartnerprogram.html -- James Manning [EMAIL PROTECTED] GPG Key fingerprint = B913 2FBD 14A9 CE18 B2B7 9C8E A0BF B026 EEBB F6E4 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: James Manning INET

itrprof broken?

-bilisim.com/qa/discus/ Is there another site that's running that same code or something else that can analyzer Event 10046 trace logs? Daniþment Gazi Ünal: Any ideas? itrprof's been such a wonderful tool, I'd really miss not being able to use it any more :( Thanks!! James -- James Manning

Perf Advice Needed: cache buffers chains, high waits, _db_block_hash_buckets

!! James -- James Manning [EMAIL PROTECTED] GPG Key fingerprint = B913 2FBD 14A9 CE18 B2B7 9C8E A0BF B026 EEBB F6E4 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: James Manning INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538

Re: How to make deletes faster.

, putting the table into nologging during the delete (if that's an option, which it probably isn't), etc? -- James Manning [EMAIL PROTECTED] GPG Key fingerprint = B913 2FBD 14A9 CE18 B2B7 9C8E A0BF B026 EEBB F6E4 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: James Manning

Re: Oracle error ORA-04031

[[EMAIL PROTECTED]] I'm getting an ORA-04031: unable to allocate 8192 bytes of shared memory (large pool,unknown object,sort subheap,sort key) error, and am having a hard time solving the issue. http://www.cryer.co.uk/brian/oracle/ORA04031.htm -- James Manning [EMAIL PROTECTED] GPG Key

Re: UNIX QUESTION.

[Hamid Alavi] ANYBODY KNOW WHAT'S THE EQUIVALENT OF THIS COMMAND IN UNIX? host start cmd /c copy /u04/oradata/AMDEV/rbs01.dbf D:\oradata\fred\backup host cp /u04/oradata/AMDEV/rbs01.dbf /oradata/fred/backup -- James Manning [EMAIL PROTECTED] GPG Key fingerprint = B913 2FBD 14A9 CE18 B2B7

Re: Just got back from SQL*Server 2000 training...

don't block readers? I had heard Progress was on that list, but never confirmed. -- James Manning [EMAIL PROTECTED] GPG Key fingerprint = B913 2FBD 14A9 CE18 B2B7 9C8E A0BF B026 EEBB F6E4 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: James Manning INET: [EMAIL

Re: RedHat Linux 7.2 Oracle 9i Shutdown

numbers (controlling order of execution) for startup and shutdown respectively. Much much easier, at least IMHO, than doing symlinks by hand. James -- James Manning [EMAIL PROTECTED] GPG Key fingerprint = B913 2FBD 14A9 CE18 B2B7 9C8E A0BF B026 EEBB F6E4 -- Please see the official ORACLE-L FAQ: http

Re: How to step over the STDIN, while input redirection is not given at commandline

a jmm@bp6:/tmp cat b jmm@bp6:/tmp cat c jmm@bp6:/tmp perl -e 'shift; print ' a b c jmm@bp6:/tmp cat b c | perl -e 'shift; print ' a James -- James Manning [EMAIL PROTECTED] GPG Key fingerprint = B913 2FBD 14A9 CE18 B2B7 9C8E A0BF B026 EEBB F6E4 -- Please see

Re: Create Database ... really dumb question

[SARKAR, Samir] Check Metalink Note : 56016.999 Is there any way to get access to metalink for those of us not fortunate enough to have an Oracle support contract? (Startup life is fun!) -- James Manning [EMAIL PROTECTED] GPG Key fingerprint = B913 2FBD 14A9 CE18 B2B7 9C8E A0BF B026 EEBB

Re: ora -01122

Manning [EMAIL PROTECTED] GPG Key fingerprint = B913 2FBD 14A9 CE18 B2B7 9C8E A0BF B026 EEBB F6E4 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: James Manning INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego

Re: high tkprof parse counts == real # of hard parses?

that would be more helpful, I still have the raw trace around and would be happy to re-run it. Thanks! -- James Manning [EMAIL PROTECTED] GPG Key fingerprint = B913 2FBD 14A9 CE18 B2B7 9C8E A0BF B026 EEBB F6E4 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: James Manning

Re: Moving Oracle Binaries from HP to SUN

. I'd give the probability rating around 1% at best :) -- James Manning [EMAIL PROTECTED] GPG Key fingerprint = B913 2FBD 14A9 CE18 B2B7 9C8E A0BF B026 EEBB F6E4 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: James Manning INET: [EMAIL PROTECTED] Fat City Network

Re: high tkprof parse counts == real # of hard parses?

an insert trigger on the table that sets the PK field to a seq.nextval? Thanks for your help, Bjørn! James -- James Manning [EMAIL PROTECTED] GPG Key fingerprint = B913 2FBD 14A9 CE18 B2B7 9C8E A0BF B026 EEBB F6E4 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: James

Re: high tkprof parse counts == real # of hard parses?

. But then, why isn't tkprof more clear on soft vs. hard parses? :( In any case, it looks like it's not the problem I thought it was. -- James Manning [EMAIL PROTECTED] GPG Key fingerprint = B913 2FBD 14A9 CE18 B2B7 9C8E A0BF B026 EEBB F6E4 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com

Re: high tkprof parse counts == real # of hard parses?

count (total) 69494630 parse time cpu 1082154 parse time elapsed 1420764 That looks *much* better to me! James -- James Manning [EMAIL PROTECTED] GPG Key fingerprint = B913 2FBD 14A9 CE18 B2B7 9C8E A0BF B026 EEBB F6E4 -- Please see the official ORACLE-L FAQ: http

Re: FTP Exports

-- James Manning [EMAIL PROTECTED] GPG Key fingerprint = B913 2FBD 14A9 CE18 B2B7 9C8E A0BF B026 EEBB F6E4 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: James Manning INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego

high tkprof parse counts == real # of hard parses?

:) Thanks! James -- James Manning [EMAIL PROTECTED] GPG Key fingerprint = B913 2FBD 14A9 CE18 B2B7 9C8E A0BF B026 EEBB F6E4 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: James Manning INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538