RE: rollback use query

.) and this generates a small amount of redo. Not that I'd argue with Anita anyway 8-) John Kanagaraj -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Kanagaraj INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California

RE: Need help tuning FTS

/updates/deletes also add to this. Short of re-scheduling jobs and playing around with _DB_BLOCK_HASH_LATCHES, I don't see any solutions. Do post us if you manage to reduce contention using the _ parameter as we have a similar problem. John Kanagaraj -- Please see the official ORACLE-L FAQ: http

RE: SUMMARY: Thanks everyone - tru64

Lisa, If you want an exact echo of Kevin's statement, count me in. We had a similar situation in a far-away, tiny country called Brunei. AIX is the best UNIX OS I have seen - at least for the SA. And the S80 is a lean, mean monster. John Kanagaraj -Original Message- Sent: Tuesday

RE: Need help tuning FTS

, what I did was to take Steve's script that looks at v$bh and group/count the hot blocks by object name. John Kanagaraj -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Kanagaraj INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538

RE: TUSC and Kevin Loney

I guess I am the last to discover this, but Kevin now works for TUSC. No Patrice - you were not the last! I thought Kevin was 'independent', so where did you get this info from? Anyway, TUSC is big in the Oracle area, and I wouldn't be surprised. John Kanagaraj -- Please see the official

RE: TUSC and Kevin Loney

' fame), Steven Feuerstein (of PL/SQL fame), And now, as TUSC are: Rich Niemiec (President IOUG-A?), Kevin Loney, Mike Ault, ... So is this coalition a viable alternative to the all-knowing Oracle Support Services? John Kanagaraj -- Please see the official ORACLE-L FAQ: http://www.orafaq.com

RE: Auto Extend

unless you need to? Fully agreed! John Kanagaraj -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Kanagaraj INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing

RE: FTP process exceeds ulimit as oracle user

'refresh -s inetd' as 'root' on AIX which restarts the inetd daemon. Hth, (Hope this helps!) John Kanagaraj -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Kanagaraj INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego

RE: Sun Solaris 8 - Listener failed to start a dedicated server p

the problem... Another issue that occurs in my mind is that some filesystem - either $ORACLE_HOME or $TNS_ADMIN or whereever sqlnet logs are kept became full.. John Kanagaraj -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Kanagaraj INET: [EMAIL PROTECTED] Fat City

RE: Binding a process to a CPU .

. In short: Processor binding works (when supported by the OS) well *only* for CPU bound tasks not for a CPU-I/O combination-type process such as the Oracle backgound processes. And before I quit : YMMV. Hth, John Kanagaraj PS: Haven't I heard of you at the Revealnet pipeline? -Original

RE: Sun Solaris 8 - Listener failed to start a dedicated server p

). Changes to /etc/system will need a server restart to become effective. John Kanagaraj -Original Message- Sent: Tuesday, May 22, 2001 11:57 AM To: Multiple recipients of list ORACLE-L On one of our Sun (development) servers, we have 8 databases running for different versions of Oracle

RE: catalog.sql catproc.sql

in... John Kanagaraj -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Kanagaraj INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

RE: Binding a process to a CPU .

What does hth, Mean? HTH - Hope This Helps... Hth :) John Kanagaraj -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Kanagaraj INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public

RE: Sun Solaris 8 - Listener failed to start a dedicated server p

Hi Jacques, One more thing to check - the max number of processes across the entire system as well as the max. no of processes per user. I am not sure about the names, but you get the drift, right? You may be bumping the ceiling on either of these values... John Kanagaraj -Original

RE: Nothing to do with Oracle : But is is very important : Your r

'DELETE's being done. John Kanagaraj -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Kanagaraj INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

RE: job offer from SAUDI ARABIA

the Holy month of Ramadan. There are some who just love it and there are some can't just get enough - there are all kinds in this world. John Kanagaraj -Original Message- Sent: Wednesday, May 16, 2001 5:50 AM To: Multiple recipients of list ORACLE-L Hi all , I have taken an offer

RE: enqueue waits

information about it. 3) How would you interpret this information and what can be done in order to eliminate (or at least minimize) enqueue locks in this database? Thanks. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Kanagaraj INET: [EMAIL PROTECTED

RE: Tomato Story

the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Kanagaraj INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

RE: sys.IDL_UB1$

Dev/2000 or load up *lots* of new procedures / packages? Not surprising this happened on a development database - AFAIK this SYS owned table stores pieces of the source and is subject to *lots* of chained rows... John Kanagaraj -- Please see the official ORACLE-L FAQ: http://www.orafaq.com

RE: LSNRCTL Password

!! It is quite easy to test this out - you can create a dummy listener.ora on the Prod box, point that to the Dev box and stop the listener from Prod... Hth, John Kanagaraj -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Kanagaraj INET: [EMAIL PROTECTED] Fat City

RE: Oracle tuning book

others, Mogens Nørgaard implemented it. John Kanagaraj Oracle Applications DBA Hitach Data Systems, Santa Clara Work : (408) 970 7002 From: Don Granaman [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: Oracle tuning book Date: Tue

RE: Cool way to crash an Oracle database, any time, any place

'... John Kanagaraj -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Kanagaraj INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

RE: Inserts slowing down on OLTP systems

,'999.9') ibadness FROM index_stats where name = upper('index_name'); undefine index_name As a rule of thumb if 10-15% of the table data changes, then you should consider rebuilding the index. Hth, John Kanagaraj Oracle Applications DBA Hitach Data Systems, Santa Clara Work

RE: Happy Birthday List !!

! And thanks for your time, patience and persistence. John Kanagaraj (used to be that lone voice from remote Brunei, back on the list after a hectic three months) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Kanagaraj INET: [EMAIL PROTECTED] Fat City Network Services

<    1   2   3   4   5