Re: Oracle 11i

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

RE: question about migrating to 9i

2003-09-10 Thread M Rafiq
command for other information (like subscribing). _ Send and receive larger attachments with Hotmail Extra Storage. http://join.msn.com/?PAGE=features/es -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: M Rafiq INET

Re: question about migrating to 9i

2003-09-11 Thread M Rafiq
). _ Send and receive larger attachments with Hotmail Extra Storage. http://join.msn.com/?PAGE=features/es -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: M Rafiq INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http

Re: alert log for physical standby?

2003-09-11 Thread M Rafiq
: http://www.orafaq.net -- Author: M Rafiq INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from

Re: What is a large database?

2003-09-11 Thread M Rafiq
. _ Get 10MB of e-mail storage! Sign up for Hotmail Extra Storage. http://join.msn.com/?PAGE=features/es -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: M Rafiq INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San

RE: What is a large database?

2003-09-11 Thread M Rafiq
-mail storage! Sign up for Hotmail Extra Storage. http://join.msn.com/?PAGE=features/es -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: M Rafiq INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing

RE: how can I see which database I am logged into without

2003-09-11 Thread M Rafiq
computer virus scan online from McAfee. http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: M Rafiq INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California

Checking for code using hints(from database)

2003-09-13 Thread M Rafiq
. Regards Rafiq _ Get 10MB of e-mail storage! Sign up for Hotmail Extra Storage. http://join.msn.com/?PAGE=features/es -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: M Rafiq INET: [EMAIL PROTECTED] Fat City

Re: Checking for code using hints(from database)

2003-09-14 Thread M Rafiq
' , 'PACKAGE BODY') and text like '%/*+%'; Did not test the query though. HTH GovindanK On Sat, 13 Sep 2003 19:59 , M Rafiq [EMAIL PROTECTED] sent: Env OPEN VMS ALPHA 7.3 Database 8.1.7.4 Optimizer = Choose Application written for Rule but use of lot of Hints in code. Reason of using cost based

Re: Checking for code using hints(from database)

2003-09-16 Thread M Rafiq
' , 'PACKAGE BODY') and text like '%/*+%'; Did not test the query though. HTH GovindanK On Sat, 13 Sep 2003 19:59 , M Rafiq [EMAIL PROTECTED] sent: Env OPEN VMS ALPHA 7.3 Database 8.1.7.4 Optimizer = Choose Application written for Rule but use of lot of Hints in code. Reason of using cost

RE: RE: Oracle Press OCP exam guide frustrations

2003-09-16 Thread M Rafiq
: M Rafiq 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-Mail

Re: RE: RE: Oracle Press OCP exam guide frustrations

2003-09-17 Thread M Rafiq
useful ? Jp. 17-09-2003 13:34:36, Caffrey, Melanie [EMAIL PROTECTED] wrote: This is most likely the reason Oracle has now made it a requirement. Otherwise, who would ever take a course? -Original Message- From: M Rafiq [mailto:[EMAIL PROTECTED] Sent: Tue 9/16/2003 11:54 PM

Re: +++Need an urgent info+++

2003-09-17 Thread M Rafiq
of e-mail storage! Sign up for Hotmail Extra Storage. http://join.msn.com/?PAGE=features/es -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: M Rafiq INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California

RE: DBMS_STATS and CBO

2003-09-18 Thread M Rafiq
command for other information (like subscribing). _ Get a FREE computer virus scan online from McAfee. http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: M

Re: HELP: HD crashed, oracle get Error ORA-00205

2003-09-18 Thread M Rafiq
://join.msn.com/?PAGE=features/es -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: M Rafiq INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

RE: oraperf.com is now Veritas

2003-09-18 Thread M Rafiq
_ Get 10MB of e-mail storage! Sign up for Hotmail Extra Storage. http://join.msn.com/?PAGE=features/es -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: M Rafiq INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San

RE: DBMS_STATS and CBO

2003-09-18 Thread M Rafiq
://www.orafaq.net -- Author: M Rafiq INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from

Re: Blocking and locking on 3-tier oracle app

2003-09-26 Thread M Rafiq
://join.msn.com/?PAGE=features/es -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: M Rafiq INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

RE: RE: what causes a memory dump?

2003-09-26 Thread M Rafiq
://www.orafaq.net -- Author: M Rafiq INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from

Re: Temp Tablespace

2003-10-09 Thread M Rafiq
). _ Frustrated with dial-up? Get high-speed for as low as $29.95/month (depending on the local service providers in your area). https://broadband.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: M Rafiq INET: [EMAIL PROTECTED

RE: Temp Tablespace

2003-10-09 Thread M Rafiq
). _ Get McAfee virus scanning and cleaning of incoming attachments. Get Hotmail Extra Storage! http://join.msn.com/?PAGE=features/es -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: M Rafiq INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538

Re: Redos gone crazy--a job for audit?

2003-10-09 Thread M Rafiq
-- Author: M Rafiq INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send

Re: Some bug in 9.2

2003-10-10 Thread M Rafiq
the official ORACLE-L FAQ: http://www.orafaq.net -- Author: M Rafiq 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: re Rebuilding Indexes in Oracle Apps -- was RE: RE: Separate

2003-10-14 Thread M Rafiq
has exceeded its 2MB storage limit? Get Hotmail Extra Storage! http://join.msn.com/?PAGE=features/es -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: M Rafiq INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego

RE: re Rebuilding Indexes in Oracle Apps

2003-10-14 Thread M Rafiq
FAQ: http://www.orafaq.net -- Author: M Rafiq INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself

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

2003-10-15 Thread M Rafiq
so no LMT involved. Regards Rafiq Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: Wed, 15 Oct 2003 13:19:24 -0800 Please explain why these indexes must be built. What benefits do you see from it? Are they quantifiable? Jared M Rafiq [EMAIL

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

2003-10-15 Thread M Rafiq
ORACLE-L Please explain why these indexes must be built. What benefits do you see from it? Are they quantifiable? Jared M Rafiq [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 10/14/2003 03:49 PM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED

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

2003-10-16 Thread M Rafiq
for a period of time? Thanks, Jared On Wed, 2003-10-15 at 18:04, M Rafiq wrote: Jared, Those tables are transit type of tables and depending on your volume of data, there are lot of deletes and inserts all the time resuling index fragmentation(holes due to deletes) and space usage. The rebuilding

Re: where is Tanel ?

2003-10-16 Thread M Rafiq
and enjoy patented spam control and more. Get two months FREE! http://join.msn.com/?page=dept/byoa -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: M Rafiq INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego

Re: Linking DataGuard to Management Server

2003-10-16 Thread M Rafiq
://www.orafaq.net -- Author: M Rafiq INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from

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

2003-10-16 Thread M Rafiq
, but there are also metrics to back it up, they just need to be collected before and after. Thanks, Jared M Rafiq [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 10/16/2003 10:34 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc

Re: OW Paris get-together, was : Re: where is Tanel ?

2003-10-16 Thread M Rafiq
numerous. I guess that as a native I am designated to be the coordinator, so please e-mail me directly so that we try to arrange something. SF M Rafiq wrote: I am missing his presence too? It looks he became angry because of some personal remarks by our some fellow listers. Tanel, where are you? We

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

2003-10-16 Thread M Rafiq
by indexed columns value changes. Fragmentated indexes degrade the performance of index range scan operations. At 06:29 AM 16-10-03 -0800, you wrote: On Wed, 2003-10-15 at 18:04, M Rafiq wrote: Jared, Those tables are transit type of tables and depending on your volume of data

Re: Re: WHERE 1 = 1 (any info on this)

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

RE: questions regarding nologging

2003-10-22 Thread M Rafiq
Hotmail account has exceeded its 2MB storage limit? Get Hotmail Extra Storage! http://join.msn.com/?PAGE=features/es -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: M Rafiq INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http

RE: questions regarding nologging

2003-10-22 Thread M Rafiq
because you forgot to sign in enough? Get Hotmail Extra Storage today! http://join.msn.com/?PAGE=features/es -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: M Rafiq INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego

Re: questions regarding nologging

2003-10-23 Thread M Rafiq
the reason why splitting partitions also doesn't generate redo, as Arup has noted. Oracle has highly optimized many of these operations and avoding excessive redo log generarion is one of the best optimizations one can make. On 2003.10.22 23:54, M Rafiq wrote: Waleed, I agree with you as I moved a 5GB

RE: which oracle9i version is stable

2003-10-30 Thread M Rafiq
_ Never get a busy signal because you are always connected with high-speed Internet access. Click here to comparison-shop providers. https://broadband.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: M Rafiq INET: [EMAIL

RE: 2G trace files - solved...sort of

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

RE: dual

2003-10-30 Thread M Rafiq
ORACLE-L FAQ: http://www.orafaq.net -- Author: M Rafiq 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: Getting Number of Rows in CTAS across DBLink

2003-11-07 Thread M Rafiq
_ Concerned that messages may bounce because your Hotmail account is over limit? Get Hotmail Extra Storage! http://join.msn.com/?PAGE=features/es -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: M Rafiq INET

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

2003-11-15 Thread M Rafiq
by service area.) -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: M Rafiq INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

NT/WINDOWS 2000 resources for ORACLE

2003-11-20 Thread M Rafiq
the FreeScan now! http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: M Rafiq INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list

Re: NT/WINDOWS 2000 resources for ORACLE

2003-11-20 Thread M Rafiq
mounted as directories). Other issue still tackling is my general ignorance but that is a lifetime battle. Good Luck. From: M Rafiq [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: NT/WINDOWS 2000 resources for ORACLE Date: Thu, 20 Nov

RE: NT/WINDOWS 2000 resources for ORACLE

2003-11-21 Thread M Rafiq
ORACLE-L [EMAIL PROTECTED] Date: Thu, 20 Nov 2003 12:50:15 -0800 Comments interleaved -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of M Rafiq Sent: 20 November 2003 15:45 To: Multiple recipients of list ORACLE-L Subject: NT/WINDOWS 2000 resources

Unix scripts on Windows 2000 after installing MKS tool kit

2003-12-02 Thread M Rafiq
version 8.6. Regards Rafiq _ Winterize your home with tips from MSN House Home. http://special.msn.com/home/warmhome.armx -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: M Rafiq INET: [EMAIL PROTECTED] Fat

Re: Unix scripts on Windows 2000 after installing MKS tool kit

2003-12-03 Thread M Rafiq
for festive fun. http://special.msn.com/network/happyholidays.armx -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: M Rafiq INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting

RE: ORA-21779: duration not active

2003-12-14 Thread M Rafiq
I think you may hitting a bug as per following details from metalink...You may open a tar for a workaround... Doc ID: 49397.1 As per above another oracle note you are setting any duration for this sesion which may be avoided...meaning have you assigned any profile to that user running export

RE: ORA-21779: duration not active

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

Any good product / option for Source code control

2004-01-07 Thread M Rafiq
customizing MSN Messenger — learn how here! http://www.msnmessenger-download.com/tracking/reach_customize -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: M Rafiq INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California

RE: Any good product / option for Source code control

2004-01-07 Thread M Rafiq
FAQ: http://www.orafaq.net -- Author: M Rafiq INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself

RE: Progress of an index rebuild

2004-01-07 Thread M Rafiq
subscribing). _ Worried about inbox overload? Get MSN Extra Storage now! http://join.msn.com/?PAGE=features/es -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: M Rafiq INET: [EMAIL PROTECTED] Fat City Network

RE: Any good product / option for Source code control

2004-01-08 Thread M Rafiq
correctly, it's free. Cary Millsap Hotsos Enterprises, Ltd. http://www.hotsos.com Upcoming events: - Performance Diagnosis 101: 1/27 Atlanta - SQL Optimization 101: 2/16 Dallas - Hotsos Symposium 2004: March 7-10 Dallas - Visit www.hotsos.com for schedule details... -Original Message- M Rafiq Sent

RE: Startup Migrate

2004-01-22 Thread M Rafiq
://www.orafaq.net -- Author: M Rafiq 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: [Q] wait time on stat

2004-01-29 Thread M Rafiq
FAQ: http://www.orafaq.net -- Author: M Rafiq 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

<    1   2