Oracle Support Alert 223399.1 on Export Bug 2598387

2003-02-04 Thread Hemant K Chitale
the RAID-5 arrays and re-organising the file systems at the same time] and I can't just go back and verify each of the multi-million-row tables. Look up bug 2598387 -- it's scary. Hemant Hemant K Chitale My web site page is : http://hkchital.tripod.com -- Please see the official ORACLE-L FAQ: http

DBSNMP connecting ? -- was RE: The lightbulb goes on -

2003-02-02 Thread Hemant K Chitale
information (like subscribing). Hemant K Chitale My web site page is : http://hkchital.tripod.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hemant K Chitale INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego

re SHUTDOWN ABORT -- was RE: Debate on rc commands Solaris and

2003-01-31 Thread Hemant K Chitale
for other information (like subscribing). Hemant K Chitale My web site page is : http://hkchital.tripod.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hemant K Chitale INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San

Performance of DBMS_LOB.WRITE

2003-01-29 Thread Hemant K Chitale
currently is that the size of the write, at 2 16K blocks, is too small. Hemant K Chitale http://hkchital.tripod.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hemant K Chitale INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http

Re: Connexion between 9iAS and Oracle 7.3.4

2003-01-28 Thread Hemant K Chitale
information (like subscribing). Hemant K Chitale My web site page is : http://hkchital.tripod.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hemant K Chitale INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California

Re: Oracle 9i 32bit and 64bit on the same server

2003-01-26 Thread Hemant K Chitale
in advance, Joshua Gratis e-mail resten av livet på: www.yahoo.se/mail Busenkelt! Hemant K Chitale My web site page is : http://hkchital.tripod.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hemant K Chitale INET: [EMAIL PROTECTED] Fat City Network Services

DDLs -- was Re: simple question on DDL

2003-01-24 Thread Hemant K Chitale
: 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). Hemant K Chitale My web site page is : http://hkchital.tripod.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author

RE: DDLs -- was Re: simple question on DDL

2003-01-24 Thread Hemant K Chitale
of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Hemant K Chitale My web site page is : http://hkchital.tripod.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hemant K Chitale INET: [EMAIL

Re: Global names

2003-01-23 Thread Hemant K Chitale
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 the HELP command for other information (like subscribing). Hemant K Chitale My web site page is : http

RE: simple question on DDL

2003-01-23 Thread Hemant K Chitale
for other information (like subscribing). Hemant K Chitale My web site page is : http://hkchital.tripod.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hemant K Chitale INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San

RE: Upgrade from 7.3.4 to 8.0.6

2003-01-22 Thread Hemant K Chitale
Chitale My web site page is : http://hkchital.tripod.com http://hkchital.tripod.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hemant K Chitale INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California

Re: Oracle 9.2.0.2 performance problem

2003-01-22 Thread Hemant K Chitale
and OS all at the same time. There is a multitude of possibilities. Have you compared the init.ora files (Hemant's SORT_AREA_SIZE recommendation is a good one). Hemant K Chitale To: Multiple recipients of list ORACLE-L [EMAIL

Re: Upgrade from 7.3.4 to 8.0.6

2003-01-21 Thread Hemant K Chitale
this and know the fix? Thanks in advance. --Chris [EMAIL PROTECTED] Hemant K Chitale My web site page is : http://hkchital.tripod.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hemant K Chitale INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051

RE: Undo Segment of 4GB for 1mn 4col update ?

2003-01-21 Thread Hemant K Chitale
--- -- undo_management string AUTO undo_retention integer 30 undo_suppress_errors boolean FALSE undo_tablespace string UNDOTBS1 Hemant K Chitale http://hkchital.tripod.com -- Please see

Re: Oracle 9.2.0.2 performance problem

2003-01-21 Thread Hemant K Chitale
via SQL*Net from client 29729 SQL*Net roundtrips to/from client 0 sorts (memory) 1 sorts (disk) 445919 rows processed Hemant K Chitale My web site page is : http://hkchital.tripod.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hemant K Chitale INET: [EMAIL

Fwd: Fwd: Undo Segment of 4GB for 1mn 4col update ?

2003-01-20 Thread Hemant K Chitale
, failed, update. Was it also deleting freed extents in the Undo Tablespace ? [Locally-Managed, SYSTEM Allocation, AUTOMATIC SegmentSpaceManagement] I am going to end up with egg on my face. Hemant - Forwarded message from Hemant K Chitale [EMAIL PROTECTED] - Date: Mon, 20 Jan 2003 17

Does anyone have a Quick and Easy/Dirty HW benchmark for Oracle DB ?

2003-01-19 Thread Hemant K Chitale
is to be run on an HP PA-RISC HPUX machine and a Sun SPARC Solaris machine to get a quick-and-easy/dirty feel of the performance of the two processors. Hemant K Chitale http://hkchital.tripod.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hemant K Chitale INET: [EMAIL

Re: Can't start Apache for OEM web interface

2003-01-16 Thread Hemant K Chitale
Jan 15 16:21:06 2003] [crit] (2)No such file or directory: Apache JServ enc ountered a fatal error; check your ApJServLogFile for details if none are presen t in this file. Exiting. What is ApJServLogFile and where can I find it??? Thanks, Helmut Hemant K Chitale My web site page is : http

RE: Question about a session error with 9iRAC

2003-01-16 Thread Hemant K Chitale
! Hemant K Chitale My web site page is : http://hkchital.tripod.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hemant K Chitale INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list

RE: Minimum required init.ora parameters -- COMPATIBLE not

2003-01-16 Thread Hemant K Chitale
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). Hemant K Chitale My web site page is : http://hkchital.tripod.com -- Please see the official ORACLE-L FAQ: http

Re: Context/Intermedia/OracleText index rebuilds and ORA-29863

2003-01-15 Thread Hemant K Chitale
] (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 the HELP command for other information (like subscribing). Hemant K Chitale My web site page is : http

Re: Question about a session error with 9iRAC

2003-01-15 Thread Hemant K Chitale
Manager - Enterprise Data Architecture gloughmiller (IPS) 678.893.3217 (office) Hemant K Chitale My web site page is : http://hkchital.tripod.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hemant K Chitale INET: [EMAIL PROTECTED] Fat City Network Services

RE: Minimum required init.ora parameters

2003-01-14 Thread Hemant K Chitale
, 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). Hemant K Chitale My web site page is : http://hkchital.tripod.com -- Please see the official ORACLE-L FAQ: http

Re: Internet file system

2003-01-14 Thread Hemant K Chitale
Management Software Development Kit?? or no? I don't want to waste my time downloading what I think is IFS v9.0.3 when v9.0.2 is the latest release and CMSDK is just for developers working with IFS. Thanks for your help. Hemant K Chitale My web site page is : http://hkchital.tripod.com -- Please

RE: Minimum required init.ora parameters

2003-01-13 Thread Hemant K Chitale
). Hemant K Chitale My web site page is : http://hkchital.tripod.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hemant K Chitale INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing

Re: Tru64 Direct I/O

2003-01-10 Thread Hemant K Chitale
: 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). Hemant K Chitale My web site page is : http://hkchital.tripod.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hemant

9iRAC on SAN ?

2003-01-07 Thread Hemant K Chitale
allows two nodes to access the disks. Is there a difference for the SAN implementation if the DB server is HPUX (Database Files on Raw Devices) or Tru64 (Database Files on a Cluster File System) ? Hemant K Chitale http://hkchital.tripod.com -- Please see the official ORACLE-L FAQ: http

Re: 8.1.7 with *what* version of Portal??

2002-12-28 Thread Hemant K Chitale
(like subscribing). Hemant K Chitale My web site page is : http://hkchital.tripod.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hemant K Chitale INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California

Re: Distributed Option

2002-12-28 Thread Hemant K Chitale
') 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). Hemant K Chitale My web site page is : http://hkchital.tripod.com -- Please see the official ORACLE-L FAQ

RE: Those Pesky Little Audit Files (ora_99999.aud)

2002-12-28 Thread Hemant K Chitale
MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you.*1 Hemant K Chitale My web site page is : http://hkchital.tripod.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author

Re: Versioning the Database !

2002-12-27 Thread Hemant K Chitale
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). Hemant K Chitale My web site page is : http://hkchital.tripod.com

RE: Bizzare behaviour of set oracle_sid=mysid

2002-12-22 Thread Hemant K Chitale
') 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). Hemant K Chitale My web site page is : http://hkchital.tripod.com -- Please see the official ORACLE-L

Re: What Bonnie's benchmark should we expect for RAID 0+1

2002-12-22 Thread Hemant K Chitale
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). Hemant K Chitale My web site page is : http://hkchital.tripod.com -- Please see the official ORACLE-L FAQ: http

Fwd: RE: 9i / 9iRAC : Segment_Space_Management AUTO, with LOB

2002-12-21 Thread Hemant K Chitale
with 9.2 we had faced severe LOCKING on setting segment space management AUTO had to REMOVE it HTH -Original Message- From: Hemant K Chitale [mailto:[EMAIL PROTECTED]] Sent: Sunday, December 15, 2002 8:09 AM To: Multiple recipients of list ORACLE-L Subject: RE: 9i / 9iRAC

RE: Backup DB files to the Tape

2002-12-19 Thread Hemant K Chitale
] (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 the HELP command for other information (like subscribing). Hemant K Chitale My web site page is : http

Re: iAS 1.0.2.2.2a vs 9iR2 db

2002-12-19 Thread Hemant K Chitale
to be removed from). You may also send the HELP command for other information (like subscribing). Hemant K Chitale My web site page is : http://hkchital.tripod.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hemant K Chitale INET: [EMAIL PROTECTED] Fat City

Re: Where's that last archive log?

2002-12-19 Thread Hemant K Chitale
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). Hemant K Chitale My web site page is : http://hkchital.tripod.com -- Please see the official ORACLE-L FAQ

Re: Bizzare behaviour of set oracle_sid=mysid

2002-12-19 Thread Hemant K Chitale
(like subscribing). Hemant K Chitale My web site page is : http://hkchital.tripod.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hemant K Chitale INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California

Re: OEM email problems (unix)

2002-12-15 Thread Hemant K Chitale
subscribing). Hemant K Chitale http://hkchital.tripod.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hemant K Chitale INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list

RE: 9i / 9iRAC : Segment_Space_Management AUTO, with LOB

2002-12-14 Thread Hemant K Chitale
-fixes for Segment_Space_Management=AUTO in the 9.2.0.2 PatchSet Release Notes. Hemant K Chitale My web site page is : http://hkchital.tripod.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hemant K Chitale INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538

OEM 9.2 to collect Unix server stats from IA

2002-12-13 Thread Hemant K Chitale
or Database performance statistics using OEM 9.2 and IA 9.2 and view historical data ? Hemant Hemant K Chitale My web site page is : http://hkchital.tripod.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hemant K Chitale INET: [EMAIL PROTECTED] Fat City Network

9i / 9iRAC : Segment_Space_Management AUTO, with LOB Segments

2002-12-13 Thread Hemant K Chitale
? There seem to be a number of bug-fixes for Segment_Space_Management=AUTO in the 9.2.0.2 PatchSet Release Notes. Hemant K Chitale My web site page is : http://hkchital.tripod.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hemant K Chitale INET: [EMAIL PROTECTED] Fat

RE: Issues/Cautions Migrating Oracle DB across platforms

2002-12-12 Thread Hemant K Chitale
COMMIT=Y to improve Import performance but commiting at every record, instead of at every buffer-size]. Recommendations / experiences appreciated. Hemant K Chitale http://hkchital.tripod.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hemant K Chitale INET: [EMAIL

RE: Memory issues on HPUX --- docs on MetaLink

2002-12-11 Thread Hemant K Chitale
In my emails of the last two days I had mentioned that I had compiled a list of docs on Metalink. If you'd like to see the docs, I've placed them at http://hkchital.tripod.com/HPUX_Notes_from_Oracle.zip Hemant K Chitale My web site page is : http://hkchital.tripod.com -- Please see

RE: Oracle 9i installation - Basic Qs - HELP!

2002-12-11 Thread Hemant K Chitale
of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Hemant K Chitale My web site page is : http://hkchital.tripod.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hemant K Chitale INET

RE: Daily job to populate table in another database

2002-12-11 Thread Hemant K Chitale
, distribution, retention, copying or reliance on this communication is prohibited and may attract civil and/or criminal penalties. Thank you. -Original Message- From: Hemant K Chitale [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 10

Issues/Cautions Migrating Oracle DB across platforms

2002-12-11 Thread Hemant K Chitale
to improve Import performance but commiting at every record, instead of at every buffer-size]. Recommendations / experiences appreciated. Hemant K Chitale http://hkchital.tripod.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hemant K Chitale INET: [EMAIL

RE: Oracle10i SE benchmarks on HP -- listed

2002-12-10 Thread Hemant K Chitale
although the Hardware is Available Now. Wonder if Oracle has really frozen the 10i production code ? What about the Enterprise Edition, then ? Hemant K Chitale http://hkchital.tripod.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: hkchital INET: [EMAIL PROTECTED

Re: Daily job to populate table in another database

2002-12-10 Thread Hemant K Chitale
Chitale My web site page is : http://hkchital.tripod.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hemant K Chitale INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web

re RAC -- patches ---- was RE: Recipe for application design

2002-12-05 Thread Hemant K Chitale
do that? Hemant K Chitale My web site page is : http://hkchital.tripod.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hemant K Chitale INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California

RE: oracle precompiler in O 9.2

2002-12-03 Thread Hemant K Chitale
also send the HELP command for other information (like subscribing). Hemant K Chitale My web site page is : http://hkchital.tripod.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hemant K Chitale INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538

RE: Recipe for application design to run on RAC

2002-11-29 Thread Hemant K Chitale
as a DBA : ] Hemant At 09:14 AM 27-11-02 -0800, you wrote: The first thing to do is quit using tnsnames.ora on the client PC's. Use Oracle names or Oracle Internet Directory. Jared Hemant K Chitale [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 11/27/2002 07:28 AM Please respond to ORACLE

RE: Recipe for application design to run on RAC

2002-11-29 Thread Hemant K Chitale
$$ licensing but ... -Original Message- From: Hemant K Chitale [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 27, 2002 10:29 AM To: Multiple recipients of list ORACLE-L Subject: RE: Recipe for application design to run on RAC Hmm. Oracle says that with the improved Cache Fusion

Re: Oracle on windows and shadow thread file access

2002-11-29 Thread Hemant K Chitale
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). Hemant K Chitale My web site page is : http://hkchital.tripod.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com

RE: Recipe for application design to run on RAC

2002-11-27 Thread Hemant K Chitale
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). Hemant K Chitale My web site page is : http://hkchital.tripod.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hemant K

Re: e: when is an error msg not an error msg ?

2002-11-14 Thread Hemant K Chitale
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). Hemant K Chitale My web site page is : http://hkchital.tripod.com -- Please

Re: SPARC-III v Alpha

2002-10-29 Thread Hemant K Chitale
Thanks for the link ! Hemant At 06:33 AM 28-10-02 -0800, you wrote: Hemant K Chitale wrote: Does anyone have benchmark or comparative figures for Sun SPARC v Compaq (thenewhp) Alpha for Oracle Databases ? I found some benchmark figures for Datawarehouses at the Oracle website

RE: SPARC-III v Alpha

2002-10-29 Thread Hemant K Chitale
didn't scuff up the soap box too much.) And as long as I am at it here: ps -eo args | nawk -F_ 'NF == 3 /ora_smon_/ {print $3}' -Original Message- From: Hemant K Chitale [mailto:hkchital;singnet.com.sg] Sent: Monday, October 28, 2002 8:19 AM To: Multiple recipients of list ORACLE-L

SPARC-III v Alpha

2002-10-28 Thread Hemant K Chitale
!]. Hemant K Chitale My web site page is : http://hkchital.tripod.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hemant K Chitale INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list

Re: auditing CREATE DATABASE

2002-10-20 Thread Hemant K Chitale
subscribing). Hemant K Chitale My web site page is : http://hkchital.tripod.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hemant K Chitale INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California

Re: Multiple Listeners

2002-10-17 Thread Hemant K Chitale
Hemant K Chitale My web site page is : http://hkchital.tripod.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hemant K Chitale INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing

RE: NO ANALYZE STATS FOR TABLE

2002-10-15 Thread Hemant K Chitale
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 the HELP command for other information (like subscribing). Hemant K Chitale My web site page is : http

Re: [Q] ORACLE 9.2 and different version of client?

2002-10-11 Thread Hemant K Chitale
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 the HELP command for other information (like subscribing). Hemant K Chitale My web site page is : http

RE: [Q] ORACLE 9.2 and different version of client?

2002-10-11 Thread Hemant K Chitale
') 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). Hemant K Chitale My web site page is : http://hkchital.tripod.com -- Please see the official ORACLE-L FAQ

Oracle Portal -- DB Performance Tuning -- any tips ?

2002-10-09 Thread Hemant K Chitale
/commits in the first place ? Hemant K Chitale My web site page is : http://hkchital.tripod.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hemant K Chitale INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego

Re: Modify init.ora

2002-10-08 Thread Hemant K Chitale
was created and running for quite a long while, is it true that the maximum of the process will increase as what i changed? do i need to change anything? init.ora will be used everytime the database start, right? or just for the initialization for db creation? thanks in advance. Hemant K Chitale

Re: FAILED_LOGIN_ATTEMPTS

2002-10-03 Thread Hemant K Chitale
the HELP command for other information (like subscribing). Hemant K Chitale My web site page is : http://hkchital.tripod.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hemant K Chitale INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http

Re: Sample Pro*C code for TAF in 8iOPS/9iRAC

2002-10-03 Thread Hemant K Chitale
on gt; session failover gt; gt; and resubmit the transaction. gt; gt; gt; gt; gt; gt; Hemant K Chitale gt; gt; My web site page is : http://hkchital.tripod.com gt; gt; gt; gt; gt; gt; -- gt; gt; Please see the official ORACLE-L FAQ: gt; http://www.orafaq.com gt; gt; -- gt; gt; Author

Sample Pro*C code for TAF in 8iOPS/9iRAC

2002-10-02 Thread Hemant K Chitale
to be hanging, without returning any error, when a transaction is in-flight We do know that Insert/Update/Deletes do not really failover but are wondering how the Pro*C programs could be written to handle the oracle error on session failover and resubmit the transaction. Hemant K Chitale My web site page

Re: Memory Based FS on Solaris 8

2002-09-30 Thread Hemant K Chitale
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 the HELP command for other information (like subscribing). Hemant K Chitale My web site page

Re: migrating 8.x-9i and charsets

2002-09-27 Thread Hemant K Chitale
al16utf16. I went forward with the upgrade. I would like to know if there is anything I can do to check the data after this change or did the ccscan need only need to be ran against converting to UTF8. This test database houses the 11i applications objects. TIA for any information Hemant K Chitale

Re: Is the effect of modifying PCTFREE/PCTUSED immediate ?

2002-09-26 Thread Hemant K Chitale
and pctused. This should affect existing blocks. Make sure to rebuild any indicies. HTH, -- Alan Davey [EMAIL PROTECTED] On 9/25/2002 11:38 AM, Hemant K Chitale [EMAIL PROTECTED] wrote: Let me clarify my original question. I do not expect the FreeList for a table to get updated instantaneously

RE: Is the effect of modifying PCTFREE/PCTUSED immediate ?

2002-09-26 Thread Hemant K Chitale
] (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 the HELP command for other information (like subscribing). Hemant K Chitale My web site page is : http

RE: RAC (Real Application Clusters)

2002-09-26 Thread Hemant K Chitale
command for other information (like subscribing). Hemant K Chitale My web site page is : http://hkchital.tripod.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hemant K Chitale INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http

RE: Is the effect of modifying PCTFREE/PCTUSED immediate ?

2002-09-25 Thread Hemant K Chitale
in existing Extents still use the old PCTFREE/PCTUSED parameters and keep re-entering the FreeList. Hemant K Chitale http://hkchital.tripod.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http

Re: Another Character Set Problem

2002-09-17 Thread Hemant K Chitale
subscribing). Hemant K Chitale My web site page is : http://hkchital.tripod.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hemant K Chitale INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California

Tools to query DB and present results in a Graphical format

2002-09-12 Thread Hemant K Chitale
Are there any simple tools to query a database [SQLServer or Oracle] and present the results in a Graphical format --- e.g. the database could contain HelpDesk Call logs and a display could be an Ageing Report or Call Rate. Hemant K Chitale Now using Eudora Email. Try it ! My home page

Re: APPS password security

2002-09-06 Thread Hemant K Chitale
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 the HELP command for other information (like subscribing). Hemant K Chitale Now using Eudora Email

RE: connect to the databases without using tnsnames.ora?

2002-09-06 Thread Hemant K Chitale
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 the HELP command for other information (like subscribing). Hemant K Chitale Now using

Re: connection output on clone instance

2002-09-06 Thread Hemant K Chitale
Hemant K Chitale Now using Eudora Email. Try it ! My home page is : http://hkchital.tripod.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hemant K Chitale INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego

RE: ctrl c on PCs

2002-09-06 Thread Hemant K Chitale
, Ohio 44113 (216) 781-4204 Hemant K Chitale Now using Eudora Email. Try it ! My home page is : http://hkchital.tripod.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hemant K Chitale INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX

RE: ORA-3120 querying across a DB-Link from a 9i2 db to and

2002-08-29 Thread Hemant K Chitale
anything similar ? I do have TAR open currently. Hemant K Chitale Now using Eudora Email. Try it ! My home page is : http://hkchital.tripod.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hemant K Chitale INET: [EMAIL PROTECTED] Fat City Network Services

ORA-3120 querying across a DB-Link from a 9i2 db to and 8.1.7

2002-08-28 Thread Hemant K Chitale
: integer overflow Anyone seen anything similar ? I do have TAR open currently. Hemant K Chitale Now using Eudora Email. Try it ! My home page is : http://hkchital.tripod.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hemant K Chitale INET: [EMAIL PROTECTED

Re: Oracle 9i Application Server question

2002-08-21 Thread Hemant K Chitale
that you should be installing 9iAS first into one ORACLE_HOME and then 9iDB into another ORACLE_HOME. Hemant At 06:18 AM 21-08-02 -0800, you wrote: Oracle 9i Release 1 (9.0.1) and Oracle 9i Application Server version 1.0.2.2.0 Hemant K Chitale Now using Eudora Email. Try it ! My home page is : http

Re: Viewing Data in Oracle Apps Tables

2002-08-20 Thread Hemant K Chitale
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 the HELP command for other information (like subscribing). Hemant K Chitale Now using Eudora

Oracle 9.2 Client/Server cnct to Oracle7 NOT Supported

2002-08-19 Thread Hemant K Chitale
produced to allow Oracle 9.2 to connect to Oracle7 as such connections are not supported. References Documentation Bug for incorrect information about 9.2 - 7 Bug:2477736 Report a connect time error for 9.2 - 7 connect attempts Bug:2308496 Hemant K Chitale Now using Eudora Email. Try it ! My home

Re: how to force a log switch

2002-08-18 Thread Hemant K Chitale
for other information (like subscribing). Hemant K Chitale Now using Eudora Email. Try it ! My home page is : http://hkchital.tripod.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hemant K Chitale INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538

Re: Simple favor from the guru's

2002-08-16 Thread Hemant K Chitale
from). You may also send the HELP command for other information (like subscribing). Hemant K Chitale Now using Eudora Email. Try it ! My home page is : http://hkchital.tripod.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hemant K Chitale INET: [EMAIL

RE: Data Warehouse on Windows

2002-08-16 Thread Hemant K Chitale
information (like subscribing). Hemant K Chitale Now using Eudora Email. Try it ! My home page is : http://hkchital.tripod.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hemant K Chitale INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858

Re: compile invalid objects

2002-08-16 Thread Hemant K Chitale
me script that compiles all invalid objects untill all objects are valid will be great . Yes I am looking for the one which does this in a loop so that i dont have to run this many times to get 0 invalid objects . Thanks , -Bp Hemant K Chitale Now using Eudora Email. Try it ! My home page

RE: Query with a Remote Table over a DB-Link

2002-08-15 Thread Hemant K Chitale
Chitale Now using Eudora Email. Try it ! My home page is : http://hkchital.tripod.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hemant K Chitale INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public

Fwd: Query with a Remote Table over a DB-Link

2002-08-14 Thread Hemant K Chitale
Resending Date: Wed, 14 Aug 2002 23:42:35 +0800 To: [EMAIL PROTECTED] From: Hemant K Chitale [EMAIL PROTECTED] Subject: Query with a Remote Table over a DB-Link I had always understood that a query which joins a remote table to a local table would pull the entire remote table over and then do

Query with a Remote Table over a DB-Link

2002-08-14 Thread Hemant K Chitale
? Hemant K Chitale Now using Eudora Email. Try it ! My home page is : http://hkchital.tripod.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hemant K Chitale INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego

Re: 11i Conc. Manager Question

2002-08-13 Thread Hemant K Chitale
may also send the HELP command for other information (like subscribing). Hemant K Chitale Now using Eudora Email. Try it ! My home page is : http://hkchital.tripod.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hemant K Chitale INET: [EMAIL PROTECTED] Fat

Re: interMedia Text

2002-08-12 Thread Hemant K Chitale
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). Hemant K Chitale Now using Eudora Email. Try it ! My home page is : http://hkchital.tripod.com -- Please see the official ORACLE

re _sqlexec_progression_cost -- again

2002-08-04 Thread Hemant K Chitale
and Rule-based. Although Bug 1210242 mentioned in note 68955.1 says that the bug is fixed in 8.1.7, it doesn't seem to have been fixed -- as apparent in notes 169935.1 and 174605.1. Hemant Hemant K Chitale Now using Eudora Email. Try it ! My home page is : http://hkchital.tripod.com

RE: Monitoring occurence of snaphot too old

2002-08-03 Thread Hemant K Chitale
). You may also send the HELP command for other information (like subscribing). Hemant K Chitale Now using Eudora Email. Try it ! My home page is : http://hkchital.tripod.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hemant K Chitale INET: [EMAIL PROTECTED

_sqlexec_progression_cost

2002-08-02 Thread Hemant K Chitale
queries. See Note:68955.1 for more details of this parameter. Also, note 68955.1 recommends setting it to 0 to resolve some cursor sharing bugs in Oracle8i. I don't query V$SESSION_LONGOPS so it doesn't matter to me if this view doesn't get updated. Hemant K Chitale Now using Eudora Email. Try

Re: 9i RAC on NetApp

2002-07-23 Thread Hemant K Chitale
subscribing). Hemant K Chitale Now using Eudora Email. Try it ! My home page is : http://hkchital.tripod.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hemant K Chitale INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San

Re: Urgent - Upgrade from 8.1.6 to 8.1.6.3

2002-06-25 Thread Hemant K Chitale
') 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). Hemant K Chitale -- Please see the official ORACLE-L FAQ: http://www.orafaq.com

<    1   2   3   4   >