Re: ** v$log.status

2004-01-30 Thread Hemant K Chitale
from). You may also send the HELP command for other information (like subscribing). Do you Yahoo!? Yahoo! SiteBuilder - Free web site building tool. Try it! Hemant K Chitale Oracle 9i Database Administrator Certified Professional http://hkchital.tripod.com {last updated 24-Jan-04} -- Please

RE: What to look for in STATSPACK report

2004-01-28 Thread Hemant K Chitale
for other information (like subscribing). Hemant K Chitale Oracle 9i Database Administrator Certified Professional http://hkchital.tripod.com {last updated 24-Jan-04} -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hemant K Chitale INET: [EMAIL PROTECTED] Fat City

Re: ROWID PROBLEM

2004-01-26 Thread Hemant K Chitale
FIELD IS NOT SORTED IN MY DATABASE WITH THE INSERTION DATA.. I INSERT THE TIME WITH EVERY RECORD AND WHEN SELECT FROM THE TABLE WITH ORDER BY ROWID I GET RANDOM TIMES IN TIME FIELD !!! THAT HAPPEND WITH ME IN ONE TABLE ONLY WALEED HAGGAGY Hemant K Chitale Oracle 9i Database Administrator

RE: !!Please Read - Oracle-L is moving!!

2004-01-23 Thread Hemant K Chitale
. *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** Hemant K Chitale Oracle 9i Database Administrator Certified Professional http://hkchital.tripod.com {last updated 22-Jan-04} -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hemant K Chitale INET: [EMAIL PROTECTED] Fat City Network

Re: [Q] create tablespace with different block size error???

2004-01-23 Thread Hemant K Chitale
). You may also send the HELP command for other information (like subscribing). Hemant K Chitale Oracle 9i Database Administrator Certified Professional http://hkchital.tripod.com {last updated 22-Jan-04} -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hemant K Chitale

Re: ADMIN: Status of list server systems (and update about

2004-01-21 Thread Hemant K Chitale
(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 Oracle 9i Database Administrator Certified Professional http://hkchital.tripod.com {last updated 05-Jan-04} -- Please see the official ORACLE-L FAQ

Any comments on Open Source Projects for Oracle ?

2004-01-21 Thread Hemant K Chitale
OTN has published a list of Oracle Open Source Projects at http://otn.oracle.com/tech/opensource/projects.html Hemant K Chitale Oracle 9i Database Administrator Certified Professional http://hkchital.tripod.com {last updated 05-Jan-04} -- Please see the official ORACLE-L FAQ: http

Re: Host concurrent program whom call ar60runb

2004-01-21 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 Oracle 9i Database Administrator Certified Professional http://hkchital.tripod.com {last updated

Re: Re: pga_aggregate_target -- actual values from my database

2004-01-21 Thread Hemant K Chitale
end the HELP command for other information (like subscribing). Hemant K Chitale Oracle 9i Database Administrator Certified Professional http://hkchital.tripod.com {last updated 05-Jan-04} -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hemant K Chitale INET: [EM

RE: full recovery

2004-01-21 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 Oracle 9i

Re: Anyone using IBM's Flashcopy for hotbacks?

2004-01-16 Thread Hemant K Chitale
also send the HELP command for other information (like subscribing). Hemant K Chitale Oracle 9i Database Administrator Certified Professional http://hkchital.tripod.com {last updated 05-Jan-04} -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hemant K Chitale INET: [EMAIL

Re: ** OCP for 9i requirements -- Instructor Led Class is a

2004-01-14 Thread Hemant K Chitale
what is on the oracle website? www.oracle.com do a search for certification. - Original Message - From: Hemant K Chitale To: Multiple recipients of list ORACLE-L Sent: Tuesday, January 13, 2004 9:34 AM Subject: Re: ** OCP for 9i requirements Are you sure that the on-line version

Re: Import foibles

2004-01-14 Thread Hemant K Chitale
for other information (like subscribing). Hemant K Chitale Oracle 9i Database Administrator Certified Professional http://hkchital.tripod.com {last updated 05-Jan-04} -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hemant K Chitale INET: [EMAIL PROTECTED] Fat City Network

Re: ** OCP for 9i requirements

2004-01-13 Thread Hemant K Chitale
Do you Yahoo!? Yahoo! Hotjobs: Enter the Signing Bonus Sweepstakes Hemant K Chitale Oracle 9i Database Administrator Certified Professional http://hkchital.tripod.com {last updated 05-Jan-04} -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hemant K Chitale INET

Curious ORA-942 on DataDict Views in 8.1.7 with

2004-01-12 Thread Hemant K Chitale
:00 SYSTEM 116.25 January 12 2004 00:00:00 TEMP 199.996094 January 12 2004 00:00:00 6 rows selected. SQL Of course, I resolved the issue with GRANT SELECT ON DBA_FREE_SPACE to DBSNMP. Hemant K Chitale Oracle 9i Database Administrator Certified Professional http://hkchital.tripod.com {last

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

2004-01-10 Thread Hemant K Chitale
is that the original instance is not usable during this time. All sessions are hanging. Benefit is that no recovery is needed and if everything goes OK, you're done very, very quickly. It's either-or approach, not a combination. On 2004.01.10 00:09, Hemant K Chitale wrote: Mladen, Is the ALTER SYSTEM

re BCV / SnapShot / SnapClone and the ALTER SYSTEM SUSPEND --

2004-01-09 Thread Hemant K Chitale
and without generating a TB of redo archives for the duration of hot backup mode. Robert Freeman's book is definitely the best source for anything RMAN around. Hemant K Chitale Oracle 9i Database Administrator Certified Professional http://hkchital.tripod.com {last updated 05-Jan-04

Re: Apps 11.5.9 D.R. Site -- MetaLink Note 216212.1 ??

2004-01-04 Thread Hemant K Chitale
(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 Oracle 9i Database Administrator Certified Professional My personal web site is : http://hkchital.tripod.com -- Please see the official ORACLE-L FAQ

Re: SESSION_CACHED_CURSORS -- RE: Parse Vs Execute

2003-12-02 Thread Hemant K Chitale
thought about pinning frequently used-objects. This script: $AD_TOP/sql/ADXCKPIN.sql should give you a list of objects you should pin (You can use $AD_TOP/sql/ADXGNPIN.sql and ADXSPPNS.sql for generating the pinning scripts afterwards). Tanel. - Original Message - From: Hemant K Chitale

Re: SESSION_CACHED_CURSORS -- RE: Parse Vs Execute

2003-12-01 Thread Hemant K Chitale
CURSOR_SPACE_FOR_TIME is FALSE. This is an Oracle Apps R11 install. Hemant At 05:29 AM 30-11-03 -0800, you wrote: What's the value for your cursor_space_for_time parameter? Tanel. - Original Message - From: Hemant K Chitale To: Multiple recipients of list ORACLE-L Sent: Sunday

SESSION_CACHED_CURSORS -- RE: Parse Vs Execute

2003-11-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 Oracle 9i Database

When / why we resize/clean the temporary tablespace -- was RE:

2003-11-15 Thread Hemant K Chitale
subscribing). Hemant K Chitale Oracle 9i Database Administrator Certified Professional My personal web site 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

Re: Clean temporary tablespace

2003-11-14 Thread Hemant K Chitale
). You may also send the HELP command for other information (like subscribing). Hemant K Chitale Oracle 9i Database Administrator Certified Professional My personal web site is : http://hkchital.tripod.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hemant K Chitale

RE: Clean temporary tablespace

2003-11-12 Thread Hemant K Chitale
). Hemant K Chitale Oracle 9i Database Administrator Certified Professional My personal web site 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

Re: Sequences CYCLEing -- was RE: How do you genrate primary

2003-11-09 Thread Hemant K Chitale
/ NEXTVAL -- 1 SQL / NEXTVAL -- 2 SQL On 2003.11.08 10:54, Hemant K Chitale wrote: Ah yes. The exception case when sequence numbers are not unique. Believe me, I've seen Sequences with low MAXVALUE [the guy decided that the the number would never exceed 4 digits

Sequences CYCLEing -- was RE: How do you genrate primary keys?

2003-11-08 Thread Hemant K Chitale
Chitale Oracle 9i Database Administrator Certified Professional My personal web site 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

Re[2]: How do you genrate primary keys?

2003-11-06 Thread Hemant K Chitale
, November 5, 2003, 9:24:41 AM, Hemant K Chitale ([EMAIL PROTECTED]) wrote: HKC 1. Hit a table that keeps a counter. HKC Used to be a mechanism in the Oracle5 days [If I remember correctly, HKC Sequences came in Oracle6]. Issues were with locking the single HKC record used as the generator

RE: ORDER -- was Re[2]: Sequences in OPS/RAC

2003-11-05 Thread Hemant K Chitale
(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 Oracle 9i Database Administrator Certified Professional My personal web site is : http://hkchital.tripod.com -- Please see the official ORACLE-L

Re: How do you genrate primary keys?

2003-11-05 Thread Hemant K Chitale
you want to be removed from). You may also send the HELP command for other information (like subscribing). Hemant K Chitale Oracle 9i Database Administrator Certified Professional My personal web site is : http://hkchital.tripod.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net

Re[2]: Sequences in OPS/RAC

2003-11-04 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 Oracle 9i Database Administrator Certified

Sequences in OPS/RAC

2003-11-03 Thread Hemant K Chitale
that a single sequence can have duplicate values in the two instances of an RAC cluster ? Hemant K Chitale Oracle 9i Database Administrator Certified Professional My personal web site is : http://hkchital.tripod.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hemant K

Re: Sequences in OPS/RAC

2003-11-03 Thread Hemant K Chitale
significant overhead on your cluster. On 11/03/2003 10:39:26 AM, Hemant K Chitale wrote: I have always been comfortable with the idea that Sequences continue to guarantee uniqueness even in OPS / RAC environments. However, a recent Builder.Com article by Scott Stephens on the SYS_GUID

RE: re Rebuilding Indexes in Oracle Apps -- an update

2003-11-01 Thread Hemant K Chitale
periodically. Hemant K Chitale Oracle 9i Database Administrator Certified Professional My personal web site 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: Overhead Associated with Signon Audit in Financials 11.0

2003-10-31 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 Oracle 9i Database Administrator Certified Professional My personal web site is : http://hkchital.tripod.com -- Please see

RE: Overhead Associated with Signon Audit in Financials 11.0

2003-10-31 Thread Hemant K Chitale
to be removed from). You may also send the HELP command for other information (like subscribing). Hemant K Chitale Oracle 9i Database Administrator Certified Professional My personal web site is : http://hkchital.tripod.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hemant K

Re: DR Planning

2003-10-31 Thread Hemant K Chitale
! Shopping - with improved product search Hemant K Chitale Oracle 9i Database Administrator Certified Professional My personal web site 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

Re: When would we see optimizer_mode=NONE in V$SQLAREA ?

2003-10-30 Thread Hemant K Chitale
(*) -- -- CHOOSE 1467 NONE 1261 RULE 5 Tanel. - Original Message - From: Hemant K Chitale [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, October 29, 2003 5:04 PM Subject: When would we see optimizer_mode=NONE in V$SQLAREA ? I noticed

Re: Removing NUMGROUP from lexer in ConTerMedText index

2003-10-30 Thread Hemant K Chitale
from). You may also send the HELP command for other information (like subscribing). Hemant K Chitale Oracle 9i Database Administrator Certified Professional My personal web site is : http://hkchital.tripod.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hemant K Chitale

RE: 9I RAC corporate standard.

2003-10-29 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 Oracle 9i Database Administrator Certified Professional My personal web site is : http

When would we see optimizer_mode=NONE in V$SQLAREA ?

2003-10-29 Thread Hemant K Chitale
see a number of entries in V$SQL like that ? [I had approx 20% of the entries]. Hemant K Chitale Oracle 9i Database Administrator Certified Professional My personal web site is : http://hkchital.tripod.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hemant K Chitale

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

2003-10-23 Thread Hemant K Chitale
: 12/8-12 Dallas - Hotsos Symposium 2004: March 7-10 Dallas - Visit www.hotsos.com for schedule details... -Original Message- Hemant K Chitale Sent: Tuesday, October 21, 2003 10:15 AM To: Multiple recipients of list ORACLE-L Unfortunately, the lines Unoccupied space on indexes occurs when

Re: Performance problem with Shareplex and Oracle

2003-10-23 Thread Hemant K Chitale
information (like subscribing). Hemant K Chitale Oracle 9i Database Administrator Certified Professional My personal web site 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: RE: CBO, RBO and will v5 ever really go away?

2003-10-23 Thread Hemant K Chitale
for other information (like subscribing). Hemant K Chitale Oracle 9i Database Administrator Certified Professional My personal web site 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

RE: Do not connect Oracle DB to the Internet. Oracle Alert #59

2003-10-23 Thread Hemant K Chitale
Chitale Oracle 9i Database Administrator Certified Professional My personal web site 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: How to trace 3rd party app

2003-10-23 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 Oracle 9i Database Administrator Certified Professional My personal web site is : http://hkchital.tripod.com -- Please see the official ORACLE-L FAQ: http

RE: Transportable tablespaces -- yes in 10g ?

2003-10-23 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 Oracle 9i Database Administrator Certified Professional My personal web site is : http

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

2003-10-21 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 Oracle 9i Database Administrator Certified Professional

RE: Financials and APPS password

2003-10-18 Thread Hemant K Chitale
for the named addressee only. It contains information that may be confidential. Unless you are the named addressee or an authorized designee, you may not copy or use it, or disclose it to anyone else. If you received it in error please notify us immediately and then destroy it. Hemant K Chitale Oracle 9i

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

2003-10-17 Thread Hemant K Chitale
also send the HELP command for other information (like subscribing). Hemant K Chitale Oracle 9i Database Administrator Certified Professional My personal web site is : http://hkchital.tripod.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hemant K Chitale INET: [EMAIL

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

2003-10-16 Thread Hemant K Chitale
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 Oracle 9i Database Administrator Certified

Re: re Rebuilding Indexes in Oracle Apps -- Quoting an Apps

2003-10-16 Thread Hemant K Chitale
are redundant, wasteful and can actually be detrimental to performance. Cheers Richard Hemant K Chitale Oracle 9i Database Administrator Certified Professional My personal web site is : http://hkchital.tripod.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author

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

2003-10-14 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 Oracle 9i Database Administrator Certified Professional My personal web site is : http

Re: FW: Concurrent Manager

2003-10-13 Thread Hemant K Chitale
is change... -Tim on 10/12/03 8:59 AM, Hemant K Chitale at [EMAIL PROTECTED] wrote: I keep Concurrent Managers on the DB server because the managers fire off child processes to run all requests and I do not want report jobs submitted by users that are actually large batch-jobs running over

Re: Concurrent Manager

2003-10-12 Thread Hemant K Chitale
because of the overhead of the SQLNet round-trips. Hemant At 04:10 AM 09-10-03 -0800, you wrote: Hi , In Oracle Apps why concurrent manager and report server should be in database tier when other application servers are in application tier.? Thx Hemant K Chitale Oracle 9i Database Administrator

Re: Temp Tablespace

2003-10-09 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 Oracle 9i Database

Re: 11i Licencing Hel(l)p

2003-10-07 Thread Hemant K Chitale
options they require. Any insight into the Oracle Licencing nightmare would be appreciated. Kevin P.S., I know we should be using CPU licences, but that isn't my call. Hemant K Chitale Oracle 9i Database Administrator Certified Professional My personal web site is : http://hkchital.tripod.com

RE: Top (=10) Issues faced by Oracle DBAs Deploying in a

2003-09-30 Thread Hemant K Chitale
from). You may also send the HELP command for other information (like subscribing). Hemant K Chitale Oracle 9i Database Administrator Certified Professional My personal web site is : http://hkchital.tripod.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hemant K Chitale

Re: SEGMENT SPACE MANAGEMENT AUTO hangs on 9.2.0.4 on Linux

2003-09-29 Thread Hemant K Chitale
to state them to be the views of any such entity. Hemant K Chitale Oracle 9i Database Administrator Certified Professional My personal web site is : http://hkchital.tripod.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hemant K Chitale INET: [EMAIL PROTECTED] Fat

Re: Top (=10) Issues faced by Oracle DBAs Deploying in a

2003-09-27 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 Oracle 9i Database Administrator Certified Professional My personal web site is : http://hkchital.tripod.com -- Please see

Google's architecture -- was Re: paging and google.com

2003-09-26 Thread Hemant K Chitale
). Hemant K Chitale Oracle 9i Database Administrator Certified Professional My personal web site 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

Experiences setting OPEN_CURSORS for Java applications

2003-09-26 Thread Hemant K Chitale
JDBC connections. The WebMethods consultant wanted me to set OPEN_CURSORS to 500. Plumtree also requries OPEN_CURSORS to 250 or so. Hemant K Chitale Oracle 9i Database Administrator Certified Professional My personal web site is : http://hkchital.tripod.com -- Please see the official ORACLE-L FAQ

RE: Google's architecture -- was Re: paging and google.com

2003-09-26 Thread Hemant K Chitale
recipients of list ORACLE-L Subject: Re: Google's architecture -- was Re: paging and google.com hmmm. must have read it wrong in the book. any idea how to get the 'estimated number of record returned? Hemant K Chitale Oracle 9i Database Administrator Certified Professional My personal web site

Fwd: RE: RAC for download -- re RAC Pricing and Partitioning

2003-09-25 Thread Hemant K Chitale
$70K per CPU ! Data Mining, OLAP, Advanced Security, Spatial and Label Security are also seperately priced options. Hemant Date: Thu, 25 Sep 2003 22:46:40 +0800 To: [EMAIL PROTECTED] From: Hemant K Chitale [EMAIL PROTECTED] Subject: RE: RAC for download -- re RAC Pricing Check oraclestore.com

RE: RAC for download -- re RAC Pricing

2003-09-25 Thread Hemant K Chitale
To: Multiple recipients of list ORACLE-L Subject: Re: RAC for download I've seen the same kind of confusion with respect to the partitioning option, where people have been informed by their sales rep that partitioning option is part of EE. Well, yes, if you pay extra for it. Mogens Hemant K Chitale

Re: ORA-4052 querying in PLSQL across a DB-Link from 9.2.0.1 to

2003-09-24 Thread Hemant K Chitale
/SQL: SQL Statement ignored SQL I've logged a Priority-2 TAR with Support currently but wonder if someone else can reproduce this {I can reproduce it on the only 2 9.2.0.4 instances I have, both Solaris, connecting from the 9.2.0.1 instance} Hemant K Chitale Oracle 9i Database

RE: RAC for download

2003-09-24 Thread Hemant K Chitale
of any such entity. Hemant K Chitale Oracle 9i Database Administrator Certified Professional My personal web site 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

ORA-4052 querying in PLSQL across a DB-Link from 9.2.0.1 to

2003-09-22 Thread Hemant K Chitale
with Support currently but wonder if someone else can reproduce this {I can reproduce it on the only 2 9.2.0.4 instances I have, both Solaris, connecting from the 9.2.0.1 instance} Hemant K Chitale Oracle 9i Database Administrator Certified Professional My personal web site is : http

Fwd: Re: Tempfile weirdness

2003-09-19 Thread Hemant K Chitale
-0800 To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] X-Comment: Oracle RDBMS Community Forum X-Sender: Hemant K Chitale [EMAIL PROTECTED] Sender: [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] Organization: Fat City Network Services, San Diego, California For a critical database where I want

RE: RMAN in NOCATALOG mode?

2003-09-18 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 Oracle 9i Database Administrator Certified Professional My personal

RE: Backup controlfile does not include ALTER TABLESPACE ...

2003-09-18 Thread Hemant K Chitale
: How is backup controlfile different? It doesn't contain the last SCN. -- Mladen Gogala Oracle DBA -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Hemant K Chitale Sent: Wednesday, September 17, 2003 11:45 AM To: Multiple recipients of list ORACLE-L

Re: 'Test' Note on Metalink...

2003-09-18 Thread Hemant K Chitale
(like subscribing). Hemant K Chitale Oracle 9i Database Administrator Certified Professional My personal web site 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

Re: Tempfile weirdness

2003-09-18 Thread Hemant K Chitale
For a critical database where I want to be SURE that the file system has enough space for the TempFile, I run a large SELECT * FROM DBA_SOURCE UNION SELECT * FROM DBA_SOURCE UNION

RE: Backup controlfile does not include ALTER TABLESPACE ...

2003-09-17 Thread Hemant K Chitale
to identify tempfiles. Not neat. Hemant K Chitale Oracle 9i Database Administrator Certified Professional My personal web site 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

Re: invalid ROWID

2003-09-17 Thread Hemant K Chitale
subscribing). Hemant K Chitale Oracle 9i Database Administrator Certified Professional My personal web site 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: ORA-600

2003-09-16 Thread Hemant K Chitale
], [], [], [], [], [], [] Ron Smith Hemant K Chitale Oracle 9i Database Administrator Certified Professional My personal web site 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

Backup controlfile does not include ALTER TABLESPACE ... ADD

2003-09-16 Thread Hemant K Chitale
. Hemant K Chitale Oracle 9i Database Administrator Certified Professional My personal web site 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

Re: more questions -- multiplexing of datafiles

2003-09-04 Thread Hemant K Chitale
subscribing). Hemant K Chitale Oracle 9i Database Administrator Certified Professional My personal web site 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

Re: Oracle Enhancement Request System

2003-09-03 Thread Hemant K Chitale
Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! Hemant K Chitale Oracle 9i Database Administrator Certified Professional My personal web

RE: Error Log

2003-09-01 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 Oracle 9i Database Administrator Certified Professional My personal web site is : http://hkchital.tripod.com -- Please see

RE: 7.3.4 on hp-ux11 upgrade problem

2003-08-30 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 Oracle 9i Database

Re: Error Log

2003-08-30 Thread Hemant K Chitale
(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 Oracle 9i Database Administrator Certified Professional My personal web site is : http://hkchital.tripod.com -- Please see the official ORACLE-L FAQ: http

Re: 7.3.4 on hp-ux11 upgrade problem

2003-08-27 Thread Hemant K Chitale
(like subscribing). Hemant K Chitale Oracle 9i Database Administrator Certified Professional My personal web site 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

Re: Forms - as sysdba

2003-08-21 Thread Hemant K Chitale
invalid username/password or TNS error (can't recognize the connect string). I have also tried it from command line but didn't succeed. Does anyone know if/how is it possible? Thanks a lot Robert Pipich Hemant K Chitale Oracle 9i Database Administrator Certified Professional My personal web

Re: Forms 3 and 9i

2003-08-21 Thread Hemant K Chitale
, you won't be supported. Hemant At 02:59 AM 21-08-03 -0800, you wrote: Hi All, Will forms 3 works with 9i. Any known issues in this. TIA, Senthil. Hemant K Chitale Oracle 9i Database Administrator Certified Professional My personal web site is : http://hkchital.tripod.com -- Please see

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

2003-08-21 Thread Hemant K Chitale
and will accept no responsibility for any damage sustained as a result of software viruses and advise you to carry out your own virus checks before opening any attachment. Hemant K Chitale Oracle 9i Database Administrator Certified Professional My personal web site is : http://hkchital.tripod.com

Re: OEM

2003-08-21 Thread Hemant K Chitale
commands appropriately . Any Idea ? thanks, -ak Hemant K Chitale Oracle 9i Database Administrator Certified Professional My personal web site is : http://hkchital.tripod.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hemant K Chitale INET: [EMAIL PROTECTED] Fat

RE: dbca and finish button

2003-08-19 Thread Hemant K Chitale
want to be removed from). You may also send the HELP command for other information (like subscribing). Hemant K Chitale Oracle 9i Database Administrator Certified Professional My personal web site is : http://hkchital.tripod.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net

Using noatime mount-flag to improve performance ?

2003-08-19 Thread Hemant K Chitale
/scalzo_linux01.html also mentions this. Has anyone used this on Unix [Solaris/AIX/HPUX/Tru64] servers ? 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

RE: 32 or 64? -- on Solaris 8 ?

2003-08-19 Thread Hemant K Chitale
also send the HELP command for other information (like subscribing). 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 corrupted online redo logs and archivelogs -- was RE: PTC

2003-08-14 Thread Hemant K Chitale
lost some data !] Hemant K Chitale Oracle 9i Database Administrator Certified Professional My personal web site 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

Storage Cache - WriteThrough or WriteBack

2003-08-14 Thread Hemant K Chitale
being low/dead. {Should I/O be allowed to proceed if the Cache Batteries are dead or should the storage automatically switch to WriteThrough ?} 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: PTC Windchill

2003-08-14 Thread Hemant K Chitale
or $ORACLE_HOME/dbs ! At least for these implementation, I am involved before they go live and either the consultant modifies the script to create the datafiles in the location I specify or I shutdown the database after the application installation and relocate the datafiles !} Hemant K Chitale

Re: what happens if a remove a job that is running?

2003-08-14 Thread Hemant K Chitale
). Hemant K Chitale Oracle 9i Database Administrator Certified Professional My personal web site 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

Oracle 10G is real

2003-08-14 Thread Hemant K Chitale
overview of these self-managing solutions that allow DBAs to become more productive, help their organizations reduce management costs, and scale to manage the Enterprise Computing Grid. Hemant K Chitale Oracle 9i Database Administrator Certified Professional My personal web site is : http

Re: sar

2003-08-03 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 Oracle 9i Database Administrator Certified Professional My personal web site is : http

Re: clustering

2003-07-31 Thread Hemant K Chitale
. But in 9.2 they say these problems are fixed. (One instance hits ORA-600 with parameter 4519 and all instances would hang until restarted all instances). This was on 3-node tru64. Tanel. - Original Message - From: Hemant K Chitale To: Multiple recipients of list ORACLE-L Sent: Tuesday

Re: optimizer parameters in Oracle 9.2

2003-07-30 Thread Hemant K Chitale
). You may also send the HELP command for other information (like subscribing). Hemant K Chitale Oracle 9i Database Administrator Certified Professional My personal web site is : http://hkchital.tripod.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hemant K Chitale

Re: 8.1.7.4 interim patch management strategy

2003-07-30 Thread Hemant K Chitale
list you want to be removed from). You may also send the HELP command for other information (like subscribing). Hemant K Chitale Oracle 9i Database Administrator Certified Professional My personal web site is : http://hkchital.tripod.com -- Please see the official ORACLE-L FAQ: http

Re: Resend : Question about EXTPROC and vulnerability

2003-07-30 Thread Hemant K Chitale
Resending this email, hoping for a reply this time. Date: Fri, 25 Jul 2003 07:49:24 -0800 To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] X-Comment: Oracle RDBMS Community Forum X-Sender: Hemant K Chitale [EMAIL PROTECTED] Sender: [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] From

Resend : Question about EXTPROC and vulnerability

2003-07-29 Thread Hemant K Chitale
Resending this email, hoping for a reply this time. Date: Fri, 25 Jul 2003 07:49:24 -0800 To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] X-Comment: Oracle RDBMS Community Forum X-Sender: Hemant K Chitale [EMAIL PROTECTED] Sender: [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] From

  1   2   3   4   >