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
> Cheers, > > -Roy > > Roy Pardee > Programmer/Analyst > SWFPAC Lockheed Martin IT > Extension 8487 > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Deshpande, Kirti INET: [EMAIL PROTECTED] Fat City

RE: Db. Upgrade Assistant - any bad stories?

2003-04-02 Thread Deshpande, Kirti
8.1.7 db to 9.2 db. > > > > Platform is AIX. > > > > "Database Upgrade Assistant" is going to be used. Does anyone have > > any bad experience with this oracle tool? Or the whole process is > > straight forward? > > > > Thanks, > >

RE: Db. Upgrade Assistant - any bad stories?

2003-04-02 Thread Deshpande, Kirti
; any bad experience 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:

RE: Oracle Mail

2003-04-01 Thread Deshpande, Kirti
are the experience? I was asked about 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

Oracle Mail

2003-04-01 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: Upgrade to AIX 5.2

2003-03-27 Thread Deshpande, Kirti
ought 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. > > Te

RE: sysresv doesn't work on AIX

2003-03-27 Thread Deshpande, Kirti
red segments. Peter Schauss -Original Message- Sent: Wednesday, March 26, 2003 4:44 PM 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

RE: sysresv doesn't work on AIX

2003-03-27 Thread Deshpande, Kirti
all m 2 0x02da4bbc --rw-r- oracle oinstall Anyone else have similar experiences? Thanks, Peter Schauss Northrop Grumman Corporation -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Deshpande, Kirti INET: [EMAIL PR

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 repla

RE: find on unix

2003-03-25 Thread Deshpande, Kirti
Create a 'flag' file with the '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

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 Ig

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 u

RE: Script to check for errors

2003-03-21 Thread Deshpande, Kirti
that and runs twice a day, but always 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

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: 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: Force to use a tablespace

2003-03-19 Thread Deshpande, Kirti
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 http:/

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: Urgent - ORA-03001 Error While creating BLOB in 9.0.1 ?!

2003-03-19 Thread Deshpande, Kirti
--- 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 l

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

2003-03-14 Thread Deshpande, Kirti
kernel 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: Su

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

2003-03-14 Thread Deshpande, Kirti
ACLE-L > > > I monitor /var/messages on my Sun boxes, 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 Networ

RE: segment from block#

2003-03-14 Thread Deshpande, Kirti
nt where 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-

RE: utl_file_dir and 9i

2003-03-14 Thread Deshpande, Kirti
to just specify a top level directory. Has this changed in 9i? Is it possible to specify a top level directory and then utl_file can write to subdirectories? John -- -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Deshpande, Kirti INET: [EMAIL PROTECTED] Fa

RE: log buffer space

2003-03-14 Thread Deshpande, Kirti
eckpoint occurs > > (5) when a commit occurs. > > > > Therefore, see if any of these could be the problem. It's easy to > > check #s 4 and 3. > > > > As Kirti suggested, the problem could be due to the redo logs being > > on a busy disk, or even a slow

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 transac

RE: why SAN ? why not external storage ?

2003-03-13 Thread Deshpande, Kirti
here 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:

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

2003-03-13 Thread Deshpande, Kirti
write one, watch out for those -ve numbers for TXNCOUNT..   :-))     Somebody is watching this list.. seriously   ;)   Rajendra,  you need to put your script on e-bay  ;)   Regards,     - Kirti   -Original Message-From: Deshpande, Kirti Sent: Friday, March 07, 2003 9:14

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 files on the same disk) to other not-so-busy disks.    - Kirti    -Original Message-From: [EMAIL PROTECTED] [mailto:[

RE: Corrected SQL Question...

2003-03-13 Thread Deshpande, Kirti
> -Original Message- > From: 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

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

2003-03-13 Thread Deshpande, Kirti
xt 256k minextents 20 optimal 5M); create rollback segment rollback_2 tablespace rollback_space * ERROR at line 1: ORA-01552: cannot use system rollback segment for non-system tablespace 'ROLLBACK_SPACE' Those script used to work under ORACLE 8i. Does anyone know why? Thanks. _ --

RE: Corrected SQL Question...

2003-03-13 Thread Deshpande, Kirti
AQ: 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 y

RE: Corrected SQL Question...

2003-03-13 Thread Deshpande, Kirti
Deshpande, 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

RE: Corrected SQL Question...

2003-03-13 Thread Deshpande, Kirti
e 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: 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

Corrected SQL Question...

2003-03-13 Thread Deshpande, Kirti
-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 - To

Corrected SQL Question...

2003-03-13 Thread Deshpande, Kirti
-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 - To

RE: 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 > -- > -- Please see the official ORACLE-L FAQ: http://www.orafaq

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

RE: POLL: Database to DBA ratio

2003-03-13 Thread Deshpande, Kirti
Sent: Wednesday, March 12, 2003 2:40 PM Subject: RE: POLL: Database to DBA ratio 350 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: Deshpa

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

2003-03-13 Thread Deshpande, Kirti
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

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: 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: 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: Re: OCP

2003-03-12 Thread Deshpande, Kirti
he 9i track. > > Good luck! > Darrell > > -- 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: monitor transactions over time

2003-03-07 Thread Deshpande, Kirti
Title: RE: monitor transactions over time From what I know Oracle Development folks have identified the code changes to correct this problem. 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

RE: Oracle Magazine excels itself

2003-03-04 Thread Deshpande, Kirti
tfree gap"...) > > plus the claim that the author had to be right > > because the > > comment was taken from Metalink. > > > > > > It would, quite arguably, have been valid to reply > > with > > something like: "Your comments do, indeed reflec

Metalink Oracle Support Improving.......

2003-03-03 Thread Deshpande, Kirti
/metalink.oracle.com/odc/east (or west)... - 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

RE: Oracle Magazine excels itself

2003-03-03 Thread Deshpande, Kirti
-- Mailing list and web > hosting services > - > To REMOVE yourself from this mailing list, send an > E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of > 'ListGuru') and in &

RE: multiple oracle homes

2003-03-02 Thread Deshpande, Kirti
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

RE: multiple oracle homes

2003-02-28 Thread Deshpande, Kirti
oth paths valid? === Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ray Stell INET: [EMAIL PROTECTED] -- Please see the offici

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

RE: Upgrade to AIX 5.2

2003-02-27 Thread Deshpande, Kirti
P 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 h

RE: Upgrade to AIX 5.2

2003-02-27 Thread Deshpande, Kirti
| \ /usr/bin/awk '/^ *[0-9]+/ {printf("LoadList entry at 0x%s\n 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 --

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, so why 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:

RE: Partitioning

2003-02-26 Thread Deshpande, Kirti
Am I doing something wrong 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.fat

RE: History

2003-02-26 Thread Deshpande, Kirti
> UK___March 19th > USA_(FL)_May 2nd > > > Next Seminar dates: > (see http://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 >

RE: corrupted block

2003-02-24 Thread Deshpande, Kirti
ebruary 24, 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

RE: corrupted block

2003-02-24 Thread Deshpande, Kirti
found same 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 hostin

RE: general recovery scenarios

2003-02-22 Thread Deshpande, Kirti
mentioned, 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-

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:

RE: AIX question

2003-02-21 Thread Deshpande, Kirti
ts full responsibility for taking proactive and remedial action about 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 -

RE: AIX question

2003-02-21 Thread Deshpande, Kirti
Thanks for any suggestions, and have a great weekend 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, Cal

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 fi

RE: ORA-02046

2003-02-21 Thread Deshpande, Kirti
ACLE-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 - To

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

2003-02-21 Thread Deshpande, Kirti
SIGSEGV for stack growth failure. Possible causes: insufficient memory or swap space, or stack size exceeded maxssiz. cc: error 1405: "/usr/ccs/bin/ld" terminated abnormally with signal 11. *** Error exit code 11 Stop. _ -- Please see the official ORACLE-L FAQ: http://www.ora

Resolved --> RE: Oracle unauthenticated remote system

2003-02-20 Thread Deshpande, Kirti
th of London and the East Coast of Scotland. NGSSoftware's sister company NGSConsulting, offers best of breed security consulting services, specialising in application, host and network security assessments. http://www.ngssoftware.com/ http://www.ngsconsulting.com/ Telephone +44

RE: storage clause

2003-02-20 Thread Deshpande, Kirti
x27;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.net -- Author: D

RE: Oracle unauthenticated remote system compromise (

2003-02-20 Thread Deshpande, Kirti
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-Mail message to: [EMAIL PROTECTED] (note EXACT

RE: direct path read waits

2003-02-20 Thread Deshpande, Kirti
XACT 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://

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 da

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 Message-F

RE: converting NT batch files to Unix shell

2003-02-20 Thread Deshpande, Kirti
ome easy for migration. 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 host

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 t

RE: Automatic Segment Space Management

2003-02-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: 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. I

RE: DBMS_JOB

2003-02-18 Thread Deshpande, Kirti
ibing). -- 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

RE: 8.1.7 Instance not creating an SGADEF file

2003-02-18 Thread Deshpande, Kirti
.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 this mailing

RE: ORA-00106

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

RE: Help Oracle 9i db creation scripts

2003-02-17 Thread Deshpande, Kirti
or my new 9i database with the new features included? TIA M.Godlewski -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Deshpande, Kirti INET: [EMAIL PROTECTED] Fat City Network Services--

RE: Teradata banned from IOUG???

2003-02-12 Thread Deshpande, Kirti
e. The architecture is nothing special. 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

Hotsos Symposium in Dallas

2003-02-12 Thread Deshpande, Kirti
all Hotsos 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 hostin

RE: AIX 4.3.3 / 8.1.7 & Timed Statistics & Tuning Question

2003-02-07 Thread Deshpande, Kirti
Scott Stefick UNIX Systems Administrator Oracle Certified Professional DBA Wm. Rainey Harper College 847.925.6130 ****** -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Deshpande, Kirti INET: [EMAIL PROTECTED]

RE: Hanging query puzzle

2003-02-06 Thread Deshpande, Kirti
.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 Servi

RE: Windows 2000 Cluster on oracle

2003-02-06 Thread Deshpande, Kirti
t rather stable, 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-- 85

RE: Oracle Migration Workbench for Sybase

2003-02-06 Thread Deshpande, Kirti
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 City Network Services-- 858-538-5051 http://www.fatcity.

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_STATISTICS set to TRUE.  Not problems have been encountered.    And about that tuning question: May be those are all dedicated connections, if so check

RE: First version with multiple archiver processes?

2003-02-06 Thread Deshpande, Kirti
7.x you can manually start multiple archive processes by > > using the "archieve log start to " 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 :-) > > > &

RE: Oracle Migration Workbench for Sybase

2003-02-06 Thread Deshpande, Kirti
ays I need "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 IN

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: 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

Oracle Migration Workbench for Sybase

2003-02-05 Thread Deshpande, Kirti
rafaq.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 this m

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

RE: SQL Tuning Help

2003-02-05 Thread Deshpande, Kirti
hy would be a bonus. TIA = 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://

RE: Hanging query puzzle

2003-02-05 Thread Deshpande, Kirti
ead >0 WAITING 20119 > >-Original Message- >Sent: Wednesday, February 05, 2003 2:58 PM >To: [EMAIL PROTECTED] >Cc: Thomas Jeff > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Desh

RE: 7.3.4 upgrade

2003-02-05 Thread Deshpande, Kirti
onest' feedback? 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

RE: ReInitiate Sequence Number

2003-01-31 Thread Deshpande, Kirti
ing). -- 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: ReInitiate Sequence Number

2003-01-31 Thread Deshpande, Kirti
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.net -- Author: Deshpande, Ki

RE: ReInitiate Sequence Number

2003-01-31 Thread Deshpande, Kirti
nt 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 Die

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: Excessive library cache latch contention

2003-01-31 Thread Deshpande, Kirti
ese latches are happening, 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: D

  1   2   3   4   5   6   7   8   9   >