RE: How to find the last execution time of a Procedure.

iously pinned. Of course, this assumes that there is adeqauet Shared pool space and the Db is not restarted in-between :) YMMV! John Kanagaraj DB Soft Inc Phone: 408-970-7002 (W) Grace - Getting something we do NOT deserve Mercy - NOT getting something we DO deserve Click on 'http://www.needh

RE: Anyone using IBM's Flashcopy for hotbacks?

e any *read* related problems though at the time of split... YMMV! John Kanagaraj DB Soft Inc Phone: 408-970-7002 (W) Disappointment is inevitable, but Discouragement is optional! ** The opinions and facts contained in this message are entirely mine and do not reflect those of my employer or customer

RE: Process consumes CPU and long time to finished

11i recommendations? DO you see the explain plan for this particular SQL? Is this slowdown new or has existed previously? Can you process a smaller set (with Start/End invoice numbers)? These are some things to try, rather than wait on Oracle Support... John Kanagaraj DB Soft Inc Phone: 408-970

RE: Shared Pool fragmentation

Rick, I forgot about shared_pool_reserved_size and the min_alloc parameter (hidden since 8i). See Note 146599.1 Diagnosing and Resolving Error ORA-04031. John >-Original Message- >From: John Kanagaraj [mailto:[EMAIL PROTECTED] >Sent: Tuesday, January 13, 2004 2:59 PM >

RE: Shared Pool fragmentation

#x27; performs a manual flush instead, ahead of time and could (possibly) prevent a 4031 ... John Kanagaraj DB Soft Inc Phone: 408-970-7002 (W) Listen to great, commercial-free christian music 24x7x365 at http://www.klove.com ** The opinions and facts contained in this message are

RE: re BCV / SnapShot / SnapClone and the ALTER SYSTEM

helme the Write cache of a SAN and delay the split. I found ML Note:91059.1 useful in understanding the SUSPEND command... John Kanagaraj DB Soft Inc Phone: 408-970-7002 (W) Grace - Getting something we do NOT deserve Mercy - NOT getting something we DO deserve Click on 'http://www.needhi

RE: re BCV / SnapShot / SnapClone and the ALTER SYSTEM

nce the Oracle process can read only from a 'live' datafile, RMAN _cannot_ be used with BCV/ShadowImage. And placing an RMAN backed-up DB in SUSPEND mode will only aggravate users :) John Kanagaraj DB Soft Inc Phone: 408-970-7002 (W) Listen to great, commercial-free christian music 24x7x3

RE: Books on rac

and I know for sure that he has worked on many RAC installations so you *might* get something from there... As ever, this is my $0.02 (which is not worth much against the Euro!), and carries my standard disclaimer. John Kanagaraj DB Soft Inc Phone: 408-970-7002 (W) Grace - Getting something we

RE: Suggestions Needed: Latch free - library cache

Title: Message Tracy,   This is a very cursory answer... If this is the 'library cache' latch, then there *should* be a number of entries in V$LATCH_CHILDREN. Are the figures therein skewed in some way among the child latches? If so, you *may* have an issue where a particular application or

RE: ora1652 question...

System-level ON SERVERERROR trigger and check for 1652 (among others) and record all the details into either alert.log (via dbms_system.ksdwrt call), database table, utl_file etc. Hth, John Kanagaraj DB Soft Inc Phone: 408-970-7002 (W) Disappointment is inevitable, but Discouragement is optional!

RE: stress testing

paper on this last IOUG, but couldn't go and present it :( John Kanagaraj DB Soft Inc Phone: 408-970-7002 (W) Grace - Getting something we do NOT deserve Mercy - NOT getting something we DO deserve Click on 'http://www.needhim.org' for Grace and Mercy that is freely available! ** T

RE: Hardware for RAC?

Title: Message Chinedu/Chandra,   Although I agree that you can use different OEM vendors as long as the OS is the same, be aware of the increased chances for some cross-vendor problems. You necessarily don't want finger-pointing between vendors when problems occur (they will!) in a complex R

RE: Apps 11.5.9 Disater Recovery Site

tanding of Processes" and "Change Control" Happy New Year all! John Kanagaraj DB Soft Inc Phone: 408-970-7002 (W) Grace - Getting something we do NOT deserve Mercy - NOT getting something we DO deserve Click on 'http://www.needhim.org' for Grace and Mercy that is

RE: Should we stop analyzing?

due to incorrect or stale statistics. Projects in the new year include revisting the Stats gathering schedules of all our 90+ databases, some of which are analyzed daily :( Have a happy, blessed new year all! John Kanagaraj DB Soft Inc Phone: 408-970-7002 (W) Listen to great, commercial-free

RE: A performance problem

in the case of a UNIX based 11i DB server). Although this would have been just a SQL_TRACE (10046 Level 1), you can *still* run a tkprof on it to determine which SQL consumed the most time Hth, John Kanagaraj DB Soft Inc Phone: 408-970-7002 (W) Disappointment is inevitable, but Discouragement

RE: A performance problem

this indeed does use a Dblink or it is from somewhere else... [See the problem with Statspack?!] John Kanagaraj DB Soft Inc Phone: 408-970-7002 (W) Grace - Getting something we do NOT deserve Mercy - NOT getting something we DO deserve Click on 'http://www.needhim.org' for Grace and Mer

IT at Walmart and Kmart - keeping it On-Topic

g 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

RE: Performance tuning in complex environment

use it correctly) Afterthought (c) - Follow Gary Goodman's principle: Ask for 10% of the $$ allocated for the h/w that would have otherwise been spent on *trying* to solve the problem by throwing h/w at it! (Cary - correct me if I erred here!) John Kanagaraj DB Soft Inc Phone: 408-970-7002 (W)

RE: Verifying success of dbms_repcat.execute_ddl

Paul, How about an ON DDL system trigger on the source (and possibly target) databases? This trigger can log any and every detail of the who/what/when whenever *any* DDL is performed by whoever... Let me know if you need more details. John Kanagaraj DB Soft Inc Phone: 408-970-7002 (W) Listen to

RE: RBO to CBO migration books/ material

(see my paper) * Let the Developers and UA testers loose on that Db * Use Cary's method to identity the top set of business processes and determine if the performance is Ok * If not Ok, then tune it... All the best! John Kanagaraj DB Soft Inc Phone: 408-970-7002 (W) Disappointment is inevita

RE: Multi-threaded server - will it help in this case

gured default connection. You can do this via ONAMES too (and I know you use one!) - see Note:1036577.6. Btw, I am currently in the UK helping with a Name Server rollout.. John Kanagaraj DB Soft Inc Phone: 408-970-7002 (W) Grace - Getting something we do NOT deserve Mercy - NOT getting something

RE: Re[2]: Sequences in OPS/RAC

otherwise. You *can* miss uncached sequences under certain conditions when the Db restarts or a short burst of SQL causes pressure on the DD cache... Had this occur once in an Apps database and had to apply patches to undo and put back the sequence... John Kanagaraj DB Soft Inc Phone: 408-970-7002

RE: Moving projects from development/test to production

nto a framework for IT processes that define what an IT organization needs to get things done properly. However, in my limited understanding, the IT scene and organizations changes direction and in leadership so rapidly that one needs an evolving plan (to say the least). John Kanagaraj DB Sof

RE: xdb and xschema

Any help appreciated. TIA M. Do you Yahoo!? Exclusive Video Premiere - Britney Spears -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: John Kanagaraj INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California

RE: Overhead Associated with Signon Audit in Financials 11.0

g - that's an excellent one too] I am going to stop now and let Apps gurus such as Andy R, Tanel and Tim G comment. John Kanagaraj Oracle Applications DBA DB Soft Inc Work : (408) 970 7002 Listen to great, commercial-free christian music 24x7x365 at http://www.klove.com ** The opinions

RE: DBA Support Database

committment behind it. If executed and maintained well, it can relieve a lot of pressure and work and add value to the 'business' [Hope I don't sound like damagement :) ] John Kanagaraj Oracle Applications DBA DB Soft Inc Work : (408) 970 7002 Listen to great, commerci

RE: Overhead Associated with Signon Audit in Financials 11.0

switched on. Let us know if you need more info. John Kanagaraj Oracle Applications DBA DB Soft Inc Work : (408) 970 7002 Listen to great, commercial-free christian music 24x7x365 at http://www.klove.com ** The opinions and facts contained in this message are entirely mine and do not reflect those

RE: 10046 level 8 trace - help required with 'direct path

usage (outside of that explained above)... John Kanagaraj Oracle Applications DBA DB Soft Inc Work : (408) 970 7002 Listen to great, commercial-free christian music 24x7x365 at http://www.klove.com ** The opinions and facts contained in this message are entirely mine and do not reflect those of my

RE: DBA Support Database

nce to put together a periodic publishing of a List of databases and versions, Sizes allocated and used, and other good stuff such as 'Average BCHR in the last month' :-) These tools have the capability to reference such standalone repositories and update themselves, so you haven't lost

RE: ORA-4031 error help.

s below 9204. I would suggest an upgrade first... John Kanagaraj DB Soft Inc Phone: 408-970-7002 (W) God's word wrapped in great music - 24x7x365 at http://www.klove.com ** The opinions and facts contained in this message are entirely mine and do not reflect those of my employer or customers **

RE: Cache a table

. Does anyone have additional information that can verify this? I heard this from a knowledgeable Oracle instructor in an Oracle Tuning training Class. John Kanagaraj DB Soft Inc Phone: 408-970-7002 (W) Disappointment is inevitable, but Discouragement is optional! ** The opinions and facts containe

RE: re Rebuilding Indexes in Oracle Apps -- was RE: RE: Separate

WS_PER_KEY17.3659016 2.36196062 BLKS_GETS_PER_ACCESS12.1829508 3.68098031 PRE_ROWS0 0 PRE_ROWS_LEN0 0 For a detailed explanation, look at the definition of INDEX_STATS. YMMV, but you will probably get the most from Non-unique indexes... (as in this case). John

RE: RE: Cary's Book - new topic

> > > > > >Raj (and all who use Oracle's Trace analyzer, > >I 'converted' the trace analzyer tables to GTTs, and no longer >had the space >issues with large trace files. This is because the data is stored >'t

RE: Problem with undo tablespace and snapshot too old

Helmut, The SELECT article 'Understanding ORA-0155' by Tim Gorman is a must-read. Get a subscription to IOUG, or ask Tim nicely and he might give a copy of the article to you... (Probably better to get an IOUG subs - there is a ton of excellent articles and tech stuff out there) John

RE: Financials and APPS password

level DDL trigger that detects and records *any* DDL changes made. Use this to rap any knuckles connected to fingers that stray! Hth, John Kanagaraj DB Soft Inc Phone: 408-970-7002 (W) Grace - Getting something we do NOT deserve Mercy - NOT getting something we DO deserve Click on 'http://www.n

RE: Oracle on Sun vs Tru64

nd use piping rather than perform an export-ftp-import cycle? * Do you have additional (and equivalent) h/w so that you can test approaches and fine tune the whole thing? These are some of the questions that you might want to start asking of your CIO!!! John Kanagaraj DB Soft Inc Phone: 408-970-7002

RE: re Rebuilding Indexes in Oracle Apps -- was RE: RE: Separate

suggest a TRUNCate of these tables after processing monthend (or at an agreed time with the users), so the index will be chopped as well.... John Kanagaraj DB Soft Inc Phone: 408-970-7002 (W) Disappointment is inevitable, but Discouragement is optional! ** The opinions and facts contained i

RE: re Rebuilding Indexes in Oracle Apps -- was RE: RE: Separate

uses where activity_status='COMPLETE' group by item_type,activity_status; Once the 'correct' purge is complete, the 'holey' indexes will need to be rebuilt and the WF_ tables copied/truncated/recopied to shrink the HWM to reasonable levels. Let me know what your install shows u

RE: CBO and cartesian product

t;. Since this is a customized report though, you *may* be able to get away with setting them within the program (or reverting to RULE as a quick fix) John Kanagaraj DB Soft Inc Phone: 408-970-7002 (W) Listen to great, commercial-free christian music 24x7x365 at http://www.klove.com ** Th

RE: RE: Separate Indexes and Data

Title: Message Jared,   Any indexes supporting a "In-Today; Gone-Tomorrow" status table will require index rebuilds. Most of them have monotonically increasing numbers which lends itself to a 'holey' index... (I have a bunch of them with Oracle Apps Concurrent Manager and Workflow tables)  

RE: USERENV('SESSIONID') on RAC

L> select USERENV('SESSIONID') from dual; USERENV('SESSIONID') 7077637 04:46:32 SQL> select SYS_CONTEXT('USERENV','SESSIONID') from dual; SYS_CONTEXT('USERENV','SESSIONID') -

RE: how to keep statistics up to date for CBO

ks.htm' (click on the paper link). It deals with a few things that you can trip up on. I should probably update it with 9iR2 specific stuff, but haven't yet had the time :( And of course, Tim's CBO paper at http://www.evdbt.com' *is* a must-read! John Kanagaraj DB Soft Inc Phone

RE: RE: Cary's Book - new topic

Title: Message Raj (and all who use Oracle's Trace analyzer,   I 'converted' the trace analzyer tables to GTTs, and no longer had the space issues with large trace files. This is because the data is stored 'temporarily' and is used for reporting in a subsequent SQL in the same session stream

RE: Please help me tune this "io done" wait event

time since I even touched AIX (4.2 last) so I may be way off-course here... John Kanagaraj DB Soft Inc Phone: 408-970-7002 (W) Grace - Getting something we do NOT deserve Mercy - NOT getting something we DO deserve Click on 'http://www.needhim.org' for Grace and Mercy that is freely

RE: sid/serial# vs. audsid: why both?

rs? AUDSID is 0 if connecting as internal. Notes 123128.1 and 122230.1 may help! John Kanagaraj DB Soft Inc Phone: 408-970-7002 (W) Listen to great, commercial-free christian music 24x7x365 at http://www.klove.com ** The opinions and facts contained in this message are entirely mine and do not

RE: CLOB

Reference manuals... The offshoot is that the space consumed by LOBs will increase when there are updates, depending on PCTVERSION. John Kanagaraj DB Soft Inc Phone: 408-970-7002 (W) Disappointment is inevitable, but Discouragement is optional! ** The opinions and facts contained in this message are

RE: Multiple block sizes

Title: Message Mladen/Avinish,   I would just be a little careful about keeping 'hot' indexes in 32K blocks. The chances of encountering buffer busy waits during multiple, simultaneous INSERTs and DELETEs would be higher as root blocks and branch blocks that need to be updated would now hold

RE: Offshore protests + Idle events (to keep it On-track!)

ed to death after this. These 'idle' events from a Statspack report helped me solve the issue (turn off PQ on all tables - it was an OLTP system). John Kanagaraj DB Soft Inc Phone: 408-970-7002 (W) Listen to great, commercial-free christian music 24x7x365 at http://www.klove.com ** The opi

RE: Migrating from ONAMES to OID

ice against progress (Onames -> OiD), my question is 'Why fix something that is currently not broken'? Until the whole LDAP space settles down, I would advice waiting. (You still have V7 and that will crimp your style) John Kanagaraj DB Soft Inc Phone: 408-970-7002 (W) Disappointment

RE: Apps 11.5.8 and 9i

f '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://ww

RE: Confuzzled on OPTIMiZER_INDEX_COST_ADJ

, >DB_FILE_MULTIBLOCK_READ_COUNT, .. etc). As well, Histograms >and other stats >can influence FTS vs Indexed reads. For a complete list of >parameters that >influence the CBO, you can look up my paper at >http://www.geocities.com/john_sharmila/links.htm or look at a >10053 trace...

RE: Confuzzled on OPTIMiZER_INDEX_COST_ADJ

influence the CBO, you can look up my paper at http://www.geocities.com/john_sharmila/links.htm or look at a 10053 trace... John Kanagaraj DB Soft Inc Phone: 408-970-7002 (W) Listen to great, commercial-free christian music 24x7x365 at http://www.klove.com ** The opinions and facts contained in

'Test' Note on Metalink...

Have a laff! See Note 240863.1 (esp the first sentence). This seems to have been around since 11-Jun-2003 (if the Modified date can be believed) John -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: John Kanagaraj INET: [EMAIL PROTECTED] Fat City Network Services

RE: Session Stat interpretation - total runtime

Total Elapsed time = 2622 secs, which ties in neatly (nearly) to 2529 secs... The DB cannot measure time for context switches and wait times less than a msec (I think). Hope this explains! John Kanagaraj DB Soft Inc Phone: 408-970-7002 (W) Disappointment is inevitable, but Discouragement is

RE: offshoring article

>>Here is a link to an article from McKinsey & Co. My >>> >>> >>favorite positive is >> >> >>>that offshoring IT jobs frees Americans up to do >>> >>> >>other jobs. Now they dont >> >> >>

Oracle World - Listers get together (proposed Tuesday Sep 9)

3rd and Howard) San Francisco, CA 94105 415-543-8060 I will send out a reminder email closer to that time (like Monday :) Let me know if there are additional numbers... John Kanagaraj DB Soft Inc Phone: 408-970-7002 (W) Disappointment is inevitable, but Discouragement is optional! ** The opinions an

RE: Permissions error

Title: Message Was 'root.sh' run successfully? This should set the SUID/GID (set-UID and GID) on the 'oracle' executable...   $ ls -l $ORACLE_HOME/bin/oracle -rwxr-x--x 1 oracle dba 33734776 Jul 9 13:19 /u01/c4prdb/8.1.7/bin/oracle If this is what you see (i.e. rwxr-x---x), then login as

RE: Congratulations Arup (DBA of the Year)

10 members of an organization for $595. John Kanagaraj DB Soft Inc Phone: 408-970-7002 (W) Grace - Getting something we do NOT deserve Mercy - NOT getting something we DO deserve Click on 'http://www.needhim.org' for Grace and Mercy that is freely available! ** The opinions and facts contained in

RE: using developer under Unix versus on PC and then ftp code to

Title: Message NT - uppercase/lowercase no problems. UNIX - got problem! NT - Bill wants to use "\" just to spite UNIX; UNIX - Used "/" right from the beginning NT - Has a lot of GUI goodies that developers may want to use/call. UNIX - Likes the command line, so doesn't support that many GU

RE: get sid (session id) and serial#?

Title: Message Need to install @?/rdbms/admin/dbmssupp while connected as SYS. Available on all platforms 8.0.6+ I understand.   John KanagarajDB Soft IncPhone: 408-970-7002 (W)Disappointment is inevitable, but Discouragement is optional!** The opinions and facts contained in this message a

RE: How to find the session holding the library cache pin.

Murali, Running this should help in identifying the object being locked and the SID holding that pin. John Kanagaraj DB Soft Inc Phone: 408-970-7002 (W) Grace - Getting something we do NOT deserve Mercy - NOT getting something we DO deserve Click on 'http://www.needhim.org' for Grace

RE: perl/shell script for alert log

pool allocation errors *along* with the SQL/Stack from the offending process (and thus time of occurrence). And keep *all* the event lines together ;-) John Kanagaraj DB Soft Inc Phone: 408-970-7002 (W) Grace - Getting something we do NOT deserve Mercy - NOT getting something we DO deserve Cl

RE: International Language Support Experiences?

Title: Message David,   I can share this from an Oracle Apps perspective - we upgraded to UTF8 (a multi byte char set) from WE8ISO5599-1 (single byte Western Eur charset). Some of the biggest problems that we faced are:   1. Cut-and-paste produces incorrect characters which were acceptable i

RE: Onames and various connections scenarios

rior to that as dump_tnsnames adds to the end of the current one and doesn't handle changes very well. Hth, John Kanagaraj DB Soft Inc Phone: 408-970-7002 (W) Grace - Getting something we do NOT deserve Mercy - NOT getting something we DO deserve Click on 'http://www.needhim.org' for

RE: optimizer_max_permutations

Just fyi - it seems that Oracle had realized this in advance and has specifically instructed the Oracle Applications 11i installations to set this to 2000. John Kanagaraj DB Soft Inc Phone: 408-970-7002 (W) Listen to great, commercial-free christian music 24x7x365 at http://www.klove.com ** The

RE: Query results to .csv

min manual for Direct INSERT - and I might be wrong. Just cross-check this out before implementing... John Kanagaraj -Original Message- Sent: Monday, August 25, 2003 5:09 PM To: Multiple recipients of list ORACLE-L Hi! What about several insert /*+ APPEND NOLOGGING */ commands over databas

RE: Performance Problem

sage 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.net -- Author: John Kanagaraj INET: [EMAIL P

RE: About trcanlzr

Stephane,   I have used the trcanlzr on occasion when required by an iTAR. Be careful when the trace file is big - it can blow out the tablespace holding the TRCANLYZR tables. Since the data in these tables are temporary in nature - they are used only for reporting - I converted the bigg

RE: Oracle World anyone?

. I will send out another invite closer to that time. John Kanagaraj -Original Message- Sent: Thursday, August 14, 2003 8:14 PM To: Multiple recipients of list ORACLE-L And there will be a bunch of us 'Silicon Valley' types who can arrange a get-together for ORACLE-L members.

RE: URGENT!!! My 9i databases are not shutting down

Title: Message Tanel,   It is more like 'two is company, three is a crowd'. The 'sync; sync; sync' was used in the days of yore when the disk controller was flaky and you had a few seconds of 'think time' on your hand in between commands. As Hemant says, it became a habit which still dogs me

RE: library cahce pin wait on drop user

owned by the user Hth, John Kanagaraj DB Soft Inc Phone: 408-970-7002 (W) Disappointment is inevitable, but Discouragement is optional! ** The opinions and facts contained in this message are entirely mine and do not reflect those of my employer or customers ** -Original Message- Sent

RE: Oracle World anyone?

And there will be a bunch of us 'Silicon Valley' types who can arrange a get-together for ORACLE-L members. The rowdy bunch that got together last year nearly tore up the Restaurant, btw.... John Kanagaraj Oracle Applications DBA DB Soft Inc Work : (408) 970 7002 Listen to great, comme

RE: Interesting Locking Problem

RTs take place at the same time, during heavy load. Both these situations were likely in our case. I think a ML search of certain keywords would generate a bug list of sufficient size! John Kanagaraj Oracle Applications DBA DB Soft Inc Work : (408) 970 7002 Listen to great, commercial-free chr

RE: If you replied... Optimizer Mode question with regard v$sqlar

Mike, This means that the same query was executed at least twice with a slightly different executing environment which caused the optimizer to choose a different execution path. See ML Note 1013747.102. John Kanagaraj DB Soft Inc Phone: 408-970-7002 (W) Grace - Getting something we do NOT

RE: "direct path write" waits, please help

disks and moving at least the TEMP, RBS, Redo (and Arch if present) to this will definitely help. John Kanagaraj Phone: 408-970-7002 (W) Fax: 408 327 3086 (Call/Email prior to fax) -Original Message- Sent: Tuesday, July 29, 2003 8:54 AM To: Multiple recipients of list ORACLE-L Hi All

RE: Managing Archived Redo Logs

DBF' ORA-00272: error writing archive log ORA-00334: archived log: '/u091/oradata//arch/arch1_69616.log' Mon May 13 05:36:57 2002 Thread 1 cannot allocate new log, sequence 69618 Checkpoint not complete John Kanagaraj -Original Message- Sent: Wednesday, July 23, 2003 12:

RE: MicroSlop DTC

ora _just_ before doing this, and having some script check the sizes of the created file (just in case). John Kanagaraj Oracle Applications DBA DBSoft Inc (W): 408-970-7002 What would you see if you were allowed to look back at your life at the end of your journey in this earth? ** The opinions and

RE: Estimating User Load on the system

work usage) Collect and summarize system wide (via STATSPACK) and for individual users via LOGOFF just to compare. John Kanagaraj Oracle Applications DBA DBSoft Inc (W): 408-970-7002 Disappointment is inevitable, but Discouragement is optional! ** The opinions and statements above are entirely

RE: tunning an index built

How about Sort_area_size? This will matter - check for 'sorts to disk' and 'sort rows' from that session's v$sesstat (joined to v$statname). John Kanagaraj Oracle Applications DBA DBSoft Inc (W): 408-970-7002 Grace - Getting something we don't deserve; Mercy - NO

RE: wierd wait event - library cache load lock

ould be on account of a number of shared pool related bugs (don't know what version you are on). John Kanagaraj Oracle Applications DBA DBSoft Inc (W): 408-970-7002 Great, uplifting music - http://www.klove.com ** The opinions and statements above are entirely my own and not those of my empl

RE: CACHE/NOCACHE

ld usually start with looking at wait events, rather than the buffer cache. the 'Oracle Performance Tuning 101' book by Gaja Vaidyanatha and Kirti Deshpande of this list should be you first stop! John Kanagaraj Oracle Applications DBA DBSoft Inc (W): 408-970-7002 I don't know what the f

RE: Microsoft VS Oracle (again)

n, Murali?] may be able to add some details [Hint!] John Kanagaraj Oracle Applications DBA DBSoft Inc (W): 408-970-7002 Disappointment is inevitable, but Discouragement is optional! ** The opinions and statements above are entirely my own and not those of my employer or clients ** >

RE: 10046 Trace file questions

er de-allocated. I would expect, though, to see 'direct path writes' and 'direct path reads' events in the trace John Kanagaraj Oracle Applications DBA DBSoft Inc (W): 408-970-7002 Grace - Getting something we don't deserve; Mercy - NOT getting something we dese

RE: nfile parameter problem

esses that opens files (since they are now shared). Monitoring 'sar -v' on a regular basis (or even writing some scripts that chop up the columns under the 'ov' columns and alert when this is > 0) is a good proactive idea. John Kanagaraj Oracle Applications DBA DB Soft Inc W

RE: SORT_AREA_SIZE question

n ON LOGON system trigger should allow specific connections to set a larger SAS. And no one has mentioned SORT_AREA_RETAINED_SIZE yet... I wonder why! John Kanagaraj Oracle Applications DBA DB Soft Inc Work : (408) 970 7002 Listen to great, commercial-free christian music 24x7x365 at http://www

RE: nfile parameter problem

sic problem could be that you have way too many Datafiles... Consolidating this files (via CTAS, Export/Import, etc.) will reduce the number of open files, as there will be lesser number of files to open. John Kanagaraj Oracle Applications DBA DB Soft Inc Work : (408) 970 7002 Listen to great, commerc

RE: SMON taking 50% of CPU and certain queries hanging

, then you should check if you have lost previous values of AIO (configured via SMIT AIO). John Kanagaraj Oracle Applications DBA DBSoft Inc (W): 408-970-7002 Grace - Getting something we don't deserve; Mercy - NOT getting something we deserve Click on 'http://www.needhim.org' fo

RE: oracle authentication from windows

tp://www.orafaq.net -- Author: Arup Nanda INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself f

RE: Anyone using IBM's FastT900 SAN for Oracle DBs?

e see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: John Kanagaraj INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting

Resend: Anyone using IBM's FastT900 SAN for Oracle DBs?

reason why this cannot be done ], but it costs $$. And I have an _all_ RAID 1 volumes on the ERP SAN, after having successfully fought off a RAID5 'initiative' when we moved from a previous box :) [Mogens - Does this qualify me for an elevated status in the BAARF party?] John Kanaga

RE: Anyone using IBM's FastT900 SAN for Oracle DBs?

ces > - > 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 > (o

RE: Fragmentation ?

___ Do you Yahoo!? Yahoo! Calendar - Free online calendar with sync to Outlook(TM). http://calendar.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services

RE: Oracle Names

gt; this, but the company has made a commitment to MS Active > Directory, which I > gather from the list postings isn't very compatible with > Oracle's LDAP. I wouldn't worry about it - Names is available in 9i, and OiD is flaky from what I have heard so far. In summary: GO for

RE: Rule Based Optimizer

Q: http://www.orafaq.net > -- > Author: Freeman Robert - IL > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > --

RE: statspack snapshots cause 3-4 sec of 100% CPU utilization

lowing me to rap some knuckles ;-) #!/bin/ksh # # Name: top20.ksh # Purpose: Display the top 20 CPU consumers. Specify a SID to collect # only those top procs related to that SID in a multi-db system # Author:John Kanagaraj, DBSoft Inc/ Aug 2001 # Notes: Tested a

RE: statspack snapshots cause 3-4 sec of 100% CPU utilization

utilization at that time... John Kanagaraj Oracle Applications DBA DBSoft Inc (W): 408-970-7002 Disappointment is inevitable, but Discouragement is optional! ** The opinions and statements above are entirely my own and not those of my employer or clients ** > -Original Message- >

RE: statspack snapshots cause 3-4 sec of 100% CPU utilization

andrake - just wondering if the CPU cycles used for memory access are being counted against the wrong pigeonhole.. John Kanagaraj Oracle Applications DBA DBSoft Inc (W): 408-970-7002 Grace - Getting something we don't deserve; Mercy - NOT getting something we deserve Click on 'http://www.ne

RE: performance questions

and give you the low-down. The article is a 'protected' one at IOUG's SELECT Online, so you can either join IOUG (a good idea IMHO not only for many more such articles, but also be part of a group that can make a difference) or request the Goddess for a copy. John Kanagaraj Oracle A

RE: Oracle 11i new features

x27;i' replacing the 5 here. So when 11.5.9 is released later this year and they run out of numbers there, I believe it will mutate to Oracle 12i or Apps 12i The life of the person who is in charge of numbering at Oracle is gonna become quite complicated for sure..... John Kanagaraj Oracle Ap

RE: dbms_stats

ave enabled the MONITORING attribute. To > enable monitoring for tables, use the MONITORING keyword of > the CREATE TABLE > and ALTER TABLE statements, as described in "Designating Tables for > Monitoring and Automated Statistics Gathering" on page 8-9. > > John Kanag

  1   2   3   4   5   >