RE: dbshut script - why shutdown so much???

2003-04-04 Thread Deshpande, Kirti
table monitoring counts before the ABORT, either in 8i or 9i? Rich Rich JesseSystem/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Deshpande, Kirti

RE: dbshut script - shutdown or shutdown immediate

2003-04-03 Thread Deshpande, Kirti
ORACLE-L FAQ: http://www.orafaq.net -- Author: Deshpande, Kirti INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

RE: Db. Upgrade Assistant - any bad stories?

2003-04-02 Thread Deshpande, Kirti
is straight forward? Thanks, Vladimir Barac -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Deshpande, Kirti INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting

RE: Db. Upgrade Assistant - any bad stories?

2003-04-02 Thread Deshpande, Kirti
with this oracle tool? Or the whole process is straight forward? Thanks, Vladimir Barac -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Deshpande, Kirti INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego

RE: Oracle Mail

2003-04-01 Thread Deshpande, Kirti
it. I have no idea how it works. I am trying to gather as much info as possible from Oracle.com, Google etc.. Thanks. - Kirti -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Deshpande, Kirti INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http

RE: sysresv doesn't work on AIX

2003-03-27 Thread Deshpande, Kirti
FAQ: http://www.orafaq.net -- Author: Deshpande, Kirti 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

RE: sysresv doesn't work on AIX

2003-03-27 Thread Deshpande, Kirti
To: Multiple recipients of list ORACLE-L Login as the owner of the shared mem segments and run it. It just worked for me on RH 7.2 with 8.1.7 Jared -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Deshpande, Kirti INET: [EMAIL PROTECTED] Fat City Network Services

RE: Upgrade to AIX 5.2

2003-03-27 Thread Deshpande, Kirti
817 and 9i can not coexisted on aix 5L. Thanks, joan Deshpande, Kirti wrote: Tracy, We are still debating this issue with our preferred App Vendor... Since there is no 64-bit 8.1.7.4 on AIX 5L, upgrading to 9i is what we will pursue. Testing the Vendor App on 9i/AIX 4.3.3 should

RE: events number and meaning

2003-03-26 Thread Deshpande, Kirti
1. Assuming Wait Events: Please check the Database Server Reference Guide for the respective release. Also check www.oraperf.com, there a list of wait events by Oracle Versions. Free membership is required. 2. Using triggers at database level. for example: create or replace trigger

RE: find on unix

2003-03-25 Thread Deshpande, Kirti
Ignore that.. It will find newer files, not older files.. I misread the question. Sorry.. - Kirti -Original Message-From: Deshpande, Kirti Sent: Tuesday, March 25, 2003 1:39 PMTo: '[EMAIL PROTECTED]'Cc: '[EMAIL PROTECTED]'Subject: RE: find on unix Create a 'flag

RE: find on unix

2003-03-25 Thread Deshpande, Kirti
Changing 'find' to following would work: find . ! -newer oldfile -print - Kirti -Original Message-From: Deshpande, Kirti Sent: Tuesday, March 25, 2003 1:50 PMTo: '[EMAIL PROTECTED]'Cc: '[EMAIL PROTECTED]'Subject: RE: find on unix Ignore that.. It will find

RE: find on unix

2003-03-25 Thread Deshpande, Kirti
Create a 'flag' filewiththe 'particular'date as its last modified date: touch -t 200303201330.40 oldfile The timestamp is of the format:MMDDHHMM.SS Then use find command to find files newer (later) than oldfile. find . -newer oldfile -print HTH, - Kirti -Original

RE: Script to check for errors

2003-03-21 Thread Deshpande, Kirti
sends out. Thanks. Maks. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Deshpande, Kirti INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

RE: Urgent - ORA-03001 Error While creating BLOB in 9.0.1 ?!

2003-03-19 Thread Deshpande, Kirti
the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Deshpande, Kirti INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web

RE: Rownum

2003-03-19 Thread Deshpande, Kirti
, I wanted to know the concept of Rownum.. Is it similar to Row Id ? Thanks and Regards, Santosh -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Deshpande, Kirti INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San

RE: Force to use a tablespace

2003-03-19 Thread Deshpande, Kirti
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: Deshpande, Kirti INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San

RE: Data Capture program

2003-03-19 Thread Deshpande, Kirti
-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Deshpande, Kirti INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

RE: SQL*LOADER question

2003-03-19 Thread Deshpande, Kirti
: Deshpande, Kirti 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 from this mailing list, send an E

RE: log buffer space

2003-03-14 Thread Deshpande, Kirti
, the problem could be due to the redo logs being on a busy disk, or even a slow one. HTH. Arup - Original Message - From: Deshpande, Kirti To: Multiple recipients of list ORACLE-L Sent: Thursday, March 13, 2003 8:13 PM Subject: RE: log buffer space Increasing

RE: utl_file_dir and 9i

2003-03-14 Thread Deshpande, Kirti
can write to subdirectories? John -- -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Deshpande, Kirti INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting

RE: segment from block#

2003-03-14 Thread Deshpande, Kirti
this block ( 259186 ) belongs ? select segment_name from dba_extents where block_id= 259186 and 259186 = block_id+blocks -ak -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Deshpande, Kirti INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http

RE: Sun=/var/messages HP-UX=???

2003-03-14 Thread Deshpande, Kirti
, does HP-UX have anytype of OS log files worth monitoring? Thanks, Ethan -- -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Deshpande, Kirti INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California

RE: Sun=/var/messages HP-UX=???

2003-03-14 Thread Deshpande, Kirti
virtual memory /stand/vmunixthe kernel, system name list -Original Message- From: Deshpande, Kirti [mailto:[EMAIL PROTECTED] Sent: Friday, March 14, 2003 3:41 PM To: Multiple recipients of list ORACLE-L Subject: RE: Sun=/var/messages HP-UX=??? What

A SQL Question

2003-03-13 Thread Deshpande, Kirti
A CD DC EF FE G H H G Thanks for your help. - Kirti -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Deshpande, Kirti INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San

RE: Sun=/var/messages HP-UX=???

2003-03-13 Thread Deshpande, Kirti
the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Post, Ethan INET: [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Deshpande, Kirti INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego

RE: POLL: Database to DBA ratio

2003-03-13 Thread Deshpande, Kirti
Oracle Databases spread across US and Europe. 14 full time, 4 part time. 75% of applications are designed and built in-house. -Original Message- From: Deshpande, Kirti [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 12, 2003 1:59 PM To: Multiple recipients of list

RE: A SQL Question

2003-03-13 Thread Deshpande, Kirti
I messed up typing the data for the table. It has no dups. The second occurrence of C, D and E, F should actually be D, C and F, E. Sorry about that... Need more hot tea to wake me up !! - Kirti -Original Message- From: Deshpande, Kirti Sent: Thursday, March 13, 2003 7

RE: A SQL Question

2003-03-13 Thread Deshpande, Kirti
-L FAQ: http://www.orafaq.net -- -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Deshpande, Kirti INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

Corrected SQL Question...

2003-03-13 Thread Deshpande, Kirti
://www.orafaq.net -- Author: Deshpande, Kirti 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

Corrected SQL Question...

2003-03-13 Thread Deshpande, Kirti
://www.orafaq.net -- Author: Deshpande, Kirti 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

RE: Corrected SQL Question...

2003-03-13 Thread Deshpande, Kirti
recipients of list ORACLE-L I think its easier if you do it cross-tab AUS DAL DAL AUS Is that acceptable? Or just select AUS DAL If it also has a DAL AUS Are either of those metods acceptable? If so, pick one and Ill show you how to do it. From: Deshpande, Kirti [EMAIL PROTECTED] Date: 2003/03

RE: Corrected SQL Question...

2003-03-13 Thread Deshpande, Kirti
: http://www.orafaq.net -- Author: Deshpande, Kirti 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

RE: Corrected SQL Question...

2003-03-13 Thread Deshpande, Kirti
, KirtiSubject: RE: Corrected SQL Question... (see answer below) -Original Message- From: Deshpande, Kirti [mailto:[EMAIL PROTECTED]] Here is the test data: SQL select c1,c2 from cp; C1 C2 --- --- AUS DAL AUS HOU DAL AUS DAL HOU DAL LIT DAL XYZ HOU

RE: Corrected SQL Question...

2003-03-13 Thread Deshpande, Kirti
-- Author: Deshpande, Kirti 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 from this mailing list

RE: Create rollback segment under ORACLE 9ir2 failed????

2003-03-13 Thread Deshpande, Kirti
rollback segment for non-system tablespace 'ROLLBACK_SPACE' Those script used to work under ORACLE 8i. Does anyone know why? Thanks. _ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Deshpande, Kirti INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538

RE: Corrected SQL Question...

2003-03-13 Thread Deshpande, Kirti
: Deshpande, Kirti [mailto:[EMAIL PROTECTED] Sent: Thursday, March 13, 2003 2:24 PM To: Multiple recipients of list ORACLE-L Subject: RE: Corrected SQL Question... All they wanted was to pair up those city codes. DAL -- AUS followed by AUS -- DAL, AUS -- HOU followed by HOU -- AUS etc

RE: log buffer space

2003-03-13 Thread Deshpande, Kirti
Increasing log_buffer size is an option, if it is really small. I would also check if the redo logs are on a busy disk. If so, try moving those (or other busy data fileson the same disk) to othernot-so-busy disks. - Kirti -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL

TXNCOUNT in V$UNDOSTAT (9i R2) [ Was -- RE: monitor

2003-03-13 Thread Deshpande, Kirti
, watch out for those -ve numbers for TXNCOUNT.. :-)) Somebody is watching this list.. seriously ;) Rajendra, youneed toput your script on e-bay ;) Regards, - Kirti -Original Message-From: Deshpande, Kirti Sent: Friday, March 07, 2003 9:14 PMTo: Multiple recipients

RE: why SAN ? why not external storage ?

2003-03-13 Thread Deshpande, Kirti
understand there reason to go for SAN, i sugguested to buy an external storage box instead. How can i justify my desicion ? (cost of not the factor) TIA rahul -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Deshpande, Kirti INET: [EMAIL PROTECTED] Fat

RE: TXNCOUNT in V$UNDOSTAT (9i R2) [ Was -- RE: monitor

2003-03-13 Thread Deshpande, Kirti
Title: RE: monitor transactions over time Make that bug #2506744. Sorry.. - Kirti -Original Message-From: Deshpande, Kirti Sent: Thursday, March 13, 2003 7:20 PMTo: '[EMAIL PROTECTED]'Subject: TXNCOUNT in V$UNDOSTAT (9i R2) [ Was -- RE: monitor transactions over

RE: Re: OCP

2003-03-12 Thread Deshpande, Kirti
side is a total of six exams instead of just four. If your company is willing to send you to one of the 9i classes, I would take advantage of that and just go for the 9i track. Good luck! Darrell -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Deshpande

RE: DEFAULT ROLE ALL

2003-03-12 Thread Deshpande, Kirti
That sets all roles assigned to the username as it's default and are in effect at the same time whenever username logs in. - Kirti -Original Message-From: Edouard Dormidontov [mailto:[EMAIL PROTECTED]Sent: Wednesday, March 12, 2003 7:39 AMTo: Multiple recipients of list

RE: POLL: Database to DBA ratio

2003-03-12 Thread Deshpande, Kirti
. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Deshpande, Kirti INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego

RE: monitor transactions over time

2003-03-07 Thread Deshpande, Kirti
Title: RE: monitor transactions over time From what IknowOracle Development folks have identified the code changes to correct thisproblem. Just do not when Oracle would issue the patch. Since the bug was logged against 9i R2, patch would be provided. This bug was originally logged in Aug

RE: Oracle Magazine excels itself

2003-03-04 Thread Deshpande, Kirti
I'm right, you're wrong - yah, boo, sucks. I'm not impressed.. Regards Jonathan Lewis http://www.jlcomp.demon.co.uk Coming soon one-day tutorials: -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Deshpande, Kirti INET: [EMAIL PROTECTED

RE: Oracle Magazine excels itself

2003-03-03 Thread Deshpande, Kirti
FAQ: http://www.orafaq.net -- Author: Deshpande, Kirti 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

RE: multiple oracle homes

2003-03-02 Thread Deshpande, Kirti
(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: Deshpande, Kirti INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051

RE: Upgrade to AIX 5.2

2003-02-28 Thread Deshpande, Kirti
Our Current Environment: 64-bit AIX 4.3.3 running 32-bit 8.1.7.4 and 64-bit 9i. Here is what we are thinking of testing... (a very high level task list, there will be App testing in all these steps). First, upgrade databases to 64-bit 9i Second, upgrade AIX to 5L, install 64-bit 9i

RE: multiple oracle homes

2003-02-28 Thread Deshpande, Kirti
PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Deshpande, Kirti INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

RE: Checkpoints

2003-02-27 Thread Deshpande, Kirti
Zabair, Increasing the l_c_i would help. I see you have l_c_t set to 0, sowhy not set l_c_i to 0 as well? So that the checkpoint will only occur at log switches. - Kirti -Original Message-From: Zabair Ahmed [mailto:[EMAIL PROTECTED]Sent: Thursday, February 27, 2003 3:39

RE: Upgrade to AIX 5.2

2003-02-27 Thread Deshpande, Kirti
Name: %s\n\n,$2,$6)} fi April Wells Oracle DBA Great spirits have always encountered violent opposition from mediocre minds -- Albert Einstein -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Deshpande, Kirti INET: [EMAIL PROTECTED] Fat City Network Services

RE: Upgrade to AIX 5.2

2003-02-27 Thread Deshpande, Kirti
://www.orafaq.net -- Author: Deshpande, Kirti 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 from

RE: History

2003-02-26 Thread Deshpande, Kirti
://www.jlcomp.demon.co.uk/seminar.html ) USA_(CA, TX)_August The Co-operative Oracle Users' FAQ http://www.jlcomp.demon.co.uk/faq/ind_faq.html -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Deshpande, Kirti INET: [EMAIL PROTECTED] Fat City Network Services

RE: Partitioning

2003-02-26 Thread Deshpande, Kirti
Or you cannot specify a storage size for partitions. Please help.. Thanks Conrad... - -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Deshpande, Kirti INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California

RE: corrupted block

2003-02-24 Thread Deshpande, Kirti
corupted data -- -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Deshpande, Kirti INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

RE: corrupted block

2003-02-24 Thread Deshpande, Kirti
, 2003 12:29 PM To: Multiple recipients of list ORACLE-L Thanks Kirti. Interesting, dba_extents doesn't return rows for block_id=57856. However, export to /dev/null does report the corruption. Does this indicate disk or memory corruption? Deshpande, Kirti wrote: Suzy, Just more questions

RE: general recovery scenarios

2003-02-22 Thread Deshpande, Kirti
, recovering a truncate'd table from the backup. something similiar, on those lines. albiet, thanks for the earlier answers ! -sam -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Deshpande, Kirti INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http

RE: Oracle 9i hanging when linking during install !!!

2003-02-21 Thread Deshpande, Kirti
abnormally with signal 11. *** Error exit code 11 Stop. _ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Deshpande, Kirti INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting

RE: ORA-02046

2003-02-21 Thread Deshpande, Kirti
-- Author: Deshpande, Kirti 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 from this mailing

RE: Oracle unauthenticated remote system compromise (

2003-02-21 Thread Deshpande, Kirti
apply this patch to upgrade to 8.1.7.4? Joan Deshpande, Kirti wrote: Hello All, If anyone successfully applied this patch (for Alert #51) to 8.1.7.4 32-bit on HP-UX 11.0, please let me know. It seems that the patch is not able to find a couple of required lib files. Nothing found

RE: AIX question

2003-02-21 Thread Deshpande, Kirti
everyone -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Deshpande, Kirti INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

RE: AIX question

2003-02-21 Thread Deshpande, Kirti
viruses and other defects. The sender's business entity is not liable for any loss or damage arising in any way from this message or its attachments. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Deshpande, Kirti INET: [EMAIL PROTECTED] Fat City Network Services

RE: AIX question

2003-02-21 Thread Deshpande, Kirti
Title: AIX question Kevin, Thanks for sharing those scripts. :) Those are *good* !!I am keeping those. - Kirti -Original Message-From: Kevin Lange [mailto:[EMAIL PROTECTED]Sent: Friday, February 21, 2003 1:25 PMTo: Multiple recipients of list ORACLE-LSubject: RE: AIX

RE: Automatic Segment Space Management

2003-02-20 Thread Deshpande, Kirti
sequential scanning, though I have not tested it thoroughly. Best Regards, K Gopalakrishnan Bangalore, INDIA (Now in Austria) --- Deshpande, Kirti [EMAIL PROTECTED] wrote: In a very limited tests that I performed with ASSM (quite some time ago), I found that it tends to use a bit more space than

RE: converting NT batch files to Unix shell

2003-02-20 Thread Deshpande, Kirti
. Thanks in advance, Srinivas -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Deshpande, Kirti INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

RE: Oracle Names Server 8.1.7 on HP 11

2003-02-20 Thread Deshpande, Kirti
We run 4 Names servers on 4 different host machines, each having its own repository database on that host. These are defined in various preference order in SQLNET.ora file on various clients. Repository databases are monitored by other mechanisms. - Kirti -Original

RE: GRRRRR OWS

2003-02-20 Thread Deshpande, Kirti
Title: RE: GR OWS FWIW We have ASSP, SCRP,SCRU... :) - Kirti -Original Message-From: Loughmiller, Greg [mailto:[EMAIL PROTECTED]]Sent: Thursday, February 20, 2003 1:16 PMTo: Multiple recipients of list ORACLE-LSubject: RE: GR OWS LMAO.. Now you need a database

RE: direct path read waits

2003-02-20 Thread Deshpande, Kirti
-- Author: Deshpande, Kirti 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 from this mailing list

RE: Oracle unauthenticated remote system compromise (

2003-02-20 Thread Deshpande, Kirti
: 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: Deshpande, Kirti INET: [EMAIL PROTECTED] Fat City Network Services

RE: storage clause

2003-02-20 Thread Deshpande, Kirti
: 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: Deshpande, Kirti INET: [EMAIL PROTECTED] Fat City Network Services

Resolved -- RE: Oracle unauthenticated remote system

2003-02-20 Thread Deshpande, Kirti
ORACLE-L FAQ: http://www.orafaq.net -- Author: Deshpande, Kirti INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

RE: Automatic Segment Space Management

2003-02-19 Thread Deshpande, Kirti
if anybody had any positive/negative experiences with it. I got some good info at: http://www.dbazine.com/burleson11.html Thank you, Jay Hostetter Oracle DBA D. E. Communications Ephrata, PA USA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Deshpande, Kirti

RE: 8.1.7 Instance not creating an SGADEF file

2003-02-18 Thread Deshpande, Kirti
-- Author: Deshpande, Kirti 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 from this mailing list

RE: DBMS_JOB

2003-02-18 Thread Deshpande, Kirti
the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Deshpande, Kirti INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

RE: Teradata banned from IOUG???

2003-02-18 Thread Deshpande, Kirti
Thanks you, Dan. Very nicely put. - Kirti -Original Message-From: Daniel W. Fink [mailto:[EMAIL PROTECTED]]Sent: Tuesday, February 18, 2003 11:31 AMTo: Multiple recipients of list ORACLE-LSubject: Re: Teradata banned from IOUG???IOUG is a volunteer organization. If

RE: Help Oracle 9i db creation scripts

2003-02-17 Thread Deshpande, Kirti
ORACLE-L FAQ: http://www.orafaq.net -- Author: Deshpande, Kirti INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

RE: ORA-00106

2003-02-17 Thread Deshpande, Kirti
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: Deshpande, Kirti INET: [EMAIL PROTECTED] Fat City Network

Hotsos Symposium in Dallas

2003-02-12 Thread Deshpande, Kirti
staff !! Cheers! - Kirti -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Deshpande, Kirti INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

RE: Teradata banned from IOUG???

2003-02-12 Thread Deshpande, Kirti
. I imagine the PHB's had their fingers in those moves. Been there, got the T-shirt, now it's a dust rag. Jared -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Deshpande, Kirti INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http

RE: AIX 4.3.3 / 8.1.7 Timed Statistics Tuning Question

2003-02-07 Thread Deshpande, Kirti
. Rainey Harper College 847.925.6130 ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Deshpande, Kirti INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California

RE: Oracle Migration Workbench for Sybase

2003-02-06 Thread Deshpande, Kirti
Sybase Adaptive Server ODBC driver Release 3.11.00.01. Searched Sybase web site for this driver, but failed to locate it. Any ideas about its source? Thanks. - Kirti -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Deshpande, Kirti INET: [EMAIL PROTECTED] Fat

RE: First version with multiple archiver processes?

2003-02-06 Thread Deshpande, Kirti
and the added processes wil die when there is no more redofiles to archive, but for permanent having multiple processes the answer is 8.1.3 :-) Deshpande, Kirti wrote: I can think of 8.1.3. - Kirti -Original Message- Sent: Wednesday, February 05, 2003 6:04 PM

RE: AIX 4.3.3 / 8.1.7 Timed Statistics Tuning Question

2003-02-06 Thread Deshpande, Kirti
Title: AIX 4.3.3 / 8.1.7 & Timed Statistics & Tuning Question Lisa, We have several databases on AIX 4.3.3/8.1.7.x. All of them have TIMED_STATISTICSset to TRUE. Not problems havebeenencountered. And about that tuning question: May bethose are all dedicated connections, if so check what's

RE: Oracle Migration Workbench for Sybase

2003-02-06 Thread Deshpande, Kirti
, but failed to locate it. Any ideas about its source? Thanks. - Kirti -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Deshpande, Kirti INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California

RE: Windows 2000 Cluster on oracle

2003-02-06 Thread Deshpande, Kirti
, at least Win2k server is. I have one system on Win2k that I reboot, oh, every 6 months or so. Death to NT though. Jared -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Deshpande, Kirti INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http

RE: Hanging query puzzle

2003-02-06 Thread Deshpande, Kirti
/faq/ind_faq.html -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Deshpande, Kirti INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

RE: 7.3.4 upgrade

2003-02-05 Thread Deshpande, Kirti
? Thanks a lot Cyril -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Deshpande, Kirti INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

RE: Hanging query puzzle

2003-02-05 Thread Deshpande, Kirti
FAQ: http://www.orafaq.net -- Author: Deshpande, Kirti 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

RE: SQL Tuning Help

2003-02-05 Thread Deshpande, Kirti
= Sundeep Maini Consultant Currently on Assignement at Caterpillar Peoria [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Deshpande, Kirti INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego

RE: First version with multiple archiver processes?

2003-02-05 Thread Deshpande, Kirti
-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Deshpande, Kirti INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

Oracle Migration Workbench for Sybase

2003-02-05 Thread Deshpande, Kirti
: Deshpande, Kirti 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 from this mailing list, send an E

RE: Windows 2000 Cluster on oracle

2003-02-05 Thread Deshpande, Kirti
to NT though. Jared -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Deshpande, Kirti INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

RE: windows application to show sql being executed by a client

2003-02-05 Thread Deshpande, Kirti
Title: windows application to show sql being executed by a client program Pretty cool... A future Quest product ??? ;) Just wondering... :) - Kirti -Original Message-From: Jacques Kilchoer [mailto:[EMAIL PROTECTED]]Sent: Wednesday, February 05, 2003 7:59 PMTo:

RE: Excessive library cache latch contention

2003-01-31 Thread Deshpande, Kirti
, which objects / cursors etc are causing the contention. I've grappled with SQL against x$kglob, trying to join back to the P1RAW but am not getting very far. Any ideas? TIA. Neil. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Deshpande, Kirti INET: [EMAIL

RE: Oracle 101 Performance Tuning comes to the rescue again!

2003-01-31 Thread Deshpande, Kirti
Tom, Thanks a lot. I am glad to read that the book is helping you. I am not so sure about ".. solves all problems", though ;) Regards, - Kirti -Original Message-From: Mercadante, Thomas F [mailto:[EMAIL PROTECTED]]Sent: Friday, January 31, 2003 11:52 AMTo: Multiple

RE: ReInitiate Sequence Number

2003-01-31 Thread Deshpande, Kirti
send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Deshpande, Kirti INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list

RE: ReInitiate Sequence Number

2003-01-31 Thread Deshpande, Kirti
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: Deshpande, Kirti INET: [EMAIL PROTECTED] Fat City Network Services

RE: ReInitiate Sequence Number

2003-01-31 Thread Deshpande, Kirti
: Deshpande, Kirti 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 from this mailing list, send

RE: Global Stats

2003-01-30 Thread Deshpande, Kirti
to dictionary from SGA once in 15 minutes and then the tables are examined to get the stale stats. Metalink note 102334.1 has some details.. Best Regards, K Gopalakrishnan Bangalore, INDIA --- Deshpande, Kirti [EMAIL PROTECTED] wrote: Gopal, I should have waited a bit longer.. It was about 12

RE: why so many log switches?

2003-01-30 Thread Deshpande, Kirti
://www.orafaq.net -- Author: Deshpande, Kirti 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 from

  1   2   3   4   5   6   7   8   9   >