Re: Views for a table

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

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

2004-01-23 Thread Kirtikumar Deshpande
-- Author: Kirtikumar Deshpande 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: Re: pga_aggregate_target and a memory leak

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

RE: How to get unique value using AWK?

2004-01-22 Thread Kirtikumar Deshpande
-- Author: Simpson, Ken INET: [EMAIL PROTECTED] __ Do you Yahoo!? Yahoo! SiteBuilder - Free web site building tool. Try it! http://webhosting.yahoo.com/ps/sb/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kirtikumar Deshpande INET: [EMAIL

Re: AQ

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

Re: pga_aggregate_target and a memory leak

2004-01-21 Thread Kirtikumar Deshpande
://www.orafaq.net -- Author: Kirtikumar Deshpande 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: Parallel Query determined by?

2004-01-21 Thread Kirtikumar Deshpande
__ Do you Yahoo!? Yahoo! Hotjobs: Enter the Signing Bonus Sweepstakes http://hotjobs.sweepstakes.yahoo.com/signingbonus -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kirtikumar Deshpande INET: [EMAIL PROTECTED] Fat City Network Services

Re: pga_aggregate_target and a memory leak

2004-01-21 Thread Kirtikumar Deshpande
. No. The system has 4 GB of physical memory. Over 2GB was free. Jared Kirtikumar Deshpande [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 01/21/2004 06:09 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc

Re: Re: pga_aggregate_target and a memory leak

2004-01-21 Thread Kirtikumar Deshpande
the S_A_S set to 2MB (S_A_R_S = 1MB)at the instance level. It has over 600 persistent users. No MTS in use. - Kirti --- [EMAIL PROTECTED] wrote: kirti-- would you recommend avoiding pga_aggregate_target for now? From: Kirtikumar Deshpande [EMAIL PROTECTED] Date: 2004/01/21 Wed PM 02

Re: pga_aggregate_target and a memory leak

2004-01-21 Thread Kirtikumar Deshpande
you Yahoo!? Yahoo! Hotjobs: Enter the Signing Bonus Sweepstakes http://hotjobs.sweepstakes.yahoo.com/signingbonus -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kirtikumar Deshpande INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http

9i Automatic Memory Damagement:)

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

Re: AQ

2004-01-20 Thread Kirtikumar Deshpande
-- __ Do you Yahoo!? Yahoo! Hotjobs: Enter the Signing Bonus Sweepstakes http://hotjobs.sweepstakes.yahoo.com/signingbonus -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kirtikumar Deshpande INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http

Re: Rename tablespace in 9I

2004-01-17 Thread Kirtikumar Deshpande
://hotjobs.sweepstakes.yahoo.com/signingbonus -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kirtikumar Deshpande INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting

Re: dba interview questions

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

Re: shutting down oracle on AIX during machine shutdown

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

Re: Re: dba interview questions

2003-10-24 Thread Kirtikumar Deshpande
. Particularly developer questions From: Kirtikumar Deshpande [EMAIL PROTECTED] Date: 2003/10/24 Fri AM 09:49:26 EDT To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: dba interview questions The problem with such lists is that the prospects also have

RE: anyone have opinions on the future of the 'grid'?

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

Re: Redo Log (Largest size used)

2003-10-17 Thread Kirtikumar Deshpande
). __ Do you Yahoo!? The New Yahoo! Shopping - with improved product search http://shopping.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kirtikumar Deshpande INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http

Re: Redo Log (Largest size used)

2003-10-17 Thread Kirtikumar Deshpande
. |-+ | | Kirtikumar Deshpande | | | kirtikumar_deshpande| | | @yahoo.com | | | Sent by: | | | [EMAIL PROTECTED

Re: insert and commit 1000 records at a time

2003-10-17 Thread Kirtikumar Deshpande
-- Author: Kirtikumar Deshpande 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: Effect on Oracle of changing server time from EST to GMT

2003-10-17 Thread Kirtikumar Deshpande
-- Author: Kirtikumar Deshpande 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: anyone have opinions on the future of the 'grid'?

2003-10-16 Thread Kirtikumar Deshpande
. __ Do you Yahoo!? The New Yahoo! Shopping - with improved product search http://shopping.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kirtikumar Deshpande INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538

Re: ** increasing size for a partitioned table key field

2003-10-15 Thread Kirtikumar Deshpande
product search __ Do you Yahoo!? The New Yahoo! Shopping - with improved product search http://shopping.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kirtikumar Deshpande INET: [EMAIL PROTECTED] Fat City Network Services

Re: continuously copy archive redo logfiles to tape

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

Re: hrs to run catpatch.sql

2003-10-15 Thread Kirtikumar Deshpande
- with improved product search http://shopping.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kirtikumar Deshpande INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting

RE: hrs to run catpatch.sql

2003-10-15 Thread Kirtikumar Deshpande
__ Do you Yahoo!? The New Yahoo! Shopping - with improved product search http://shopping.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kirtikumar Deshpande INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http

RE: Problem with undo tablespace and snapshot too old

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

Re: continuously copy archive redo logfiles to tape

2003-10-15 Thread Kirtikumar Deshpande
sai Kirtikumar Deshpande [EMAIL PROTECTED] wrote: We use cron facility to run a script that copies archived log files, not in use by archiver process, (fuser command) to a different location. We also use 'Autosys' software to run such scripts on remote servers. Another script, that runs after

Re: Shell script broken, bdf adds new line for long filesystem name.

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

RE: Estimating space needed for UNDO tablespaces

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

Re: Estimating space needed for UNDO tablespaces

2003-09-26 Thread Kirtikumar Deshpande
product search http://shopping.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kirtikumar Deshpande 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[2]: 10g: SQL Plus

2003-09-24 Thread Kirtikumar Deshpande
. __ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kirtikumar Deshpande INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http

RE: Stuck Query

2003-09-23 Thread Kirtikumar Deshpande
wait just shows the last wait). Tanel. snip __ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kirtikumar Deshpande INET

RE: Offshore protests + Idle events (to keep it On-track!)

2003-09-23 Thread Kirtikumar Deshpande
-- Author: Kirtikumar Deshpande 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: Offshore protests + Idle events (to keep it On-track!)

2003-09-23 Thread Kirtikumar Deshpande
$IDLE_EVENT table. Thanks Stephane Paquette Administrateur de bases de donnees Database Administrator Standard Life www.standardlife.ca Tel. (514) 499-7999 7470 and (514) 925-7187 [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] -Original Message- Kirtikumar Deshpande Sent: Tuesday

Re: SGA Max size

2003-09-22 Thread Kirtikumar Deshpande
Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kirtikumar Deshpande INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego

Re: YEAAAAAAAAAAAAAAAAAAA!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!, drop in number

2003-09-22 Thread Kirtikumar Deshpande
://www.orafaq.net -- Author: Kirtikumar Deshpande 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: Huge optimization costs with 9.2

2003-09-22 Thread Kirtikumar Deshpande
? Thank you in advance. __ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kirtikumar Deshpande INET: [EMAIL PROTECTED] Fat

Re: OT: Tempfile weirdness

2003-09-18 Thread Kirtikumar Deshpande
the original tempfile never grabbed any space. -- __ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kirtikumar Deshpande INET

Re: IBM AIX 32-Bit

2003-09-18 Thread Kirtikumar Deshpande
. Does it also work the other way round? Thanks, Helmut __ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kirtikumar

RE: How to extract data directly from a datafile ?

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

Re: SQL help needed

2003-09-17 Thread Kirtikumar Deshpande
--- Kirtikumar Deshpande [EMAIL PROTECTED] wrote: Hello Listers, I need some SQL help. Not sure if this is possible in plain SQL or not, but here it is: I have a table with two columns: EMPNBR LINENBR -- --- 100 1 200 4 300 8 400 9 500

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

2003-09-17 Thread Kirtikumar Deshpande
: Kirtikumar Deshpande 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: Tempfile weirdness

2003-09-17 Thread Kirtikumar Deshpande
site design software http://sitebuilder.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kirtikumar Deshpande INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web

SQL help needed

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

RE: 9i - Dynamic SGA - SGA_MAX_SIZE

2003-08-14 Thread Kirtikumar Deshpande
dynamically by the same size as the increase in sga_max_size. That is the test for coming weekend. --- Kirtikumar Deshpande [EMAIL PROTECTED] wrote: SGA_MAX_SIZE was introduced in 9i to allow dynamic sizing of SGA (Dynamic Sizing feature) components such as, shared pool, large pool, buffer

RE: what is BAARF? --- OFA

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

RE: 9i - Dynamic SGA - SGA_MAX_SIZE

2003-08-06 Thread Kirtikumar Deshpande
- Free, easy-to-use web site design software http://sitebuilder.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kirtikumar Deshpande INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California

Re: Opatch

2003-08-05 Thread Kirtikumar Deshpande
: MacGregor, Ian A. INET: [EMAIL PROTECTED] __ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kirtikumar Deshpande INET

Re: 9i - Dynamic SGA - SGA_MAX_SIZE

2003-08-03 Thread Kirtikumar Deshpande
://www.orafaq.net -- Author: Kirtikumar Deshpande 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: 9i - Dynamic SGA - SGA_MAX_SIZE

2003-08-02 Thread Kirtikumar Deshpande
for me, I am little concerned that Oracle does not chock on me. --- Kirtikumar Deshpande [EMAIL PROTECTED] wrote: It does not work as advertised, in AIX either... I played with this in AIX 5L. - Kirti __ Do you Yahoo!? Yahoo! SiteBuilder - Free

RE: 9i - Dynamic SGA - SGA_MAX_SIZE

2003-08-01 Thread Kirtikumar Deshpande
! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kirtikumar Deshpande INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California

RE: How to display FLOAT in 99999.999 format

2003-08-01 Thread Kirtikumar Deshpande
information (like subscribing). __ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kirtikumar Deshpande INET: [EMAIL PROTECTED] Fat

Re: ** how to check version and problems

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

Re: undo tablespace and rollback segments in oracle9i

2003-07-30 Thread Kirtikumar Deshpande
-- Author: Kirtikumar Deshpande 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: undo tablespace and rollback segments in oracle9i

2003-07-30 Thread Kirtikumar Deshpande
-to-use web site design software http://sitebuilder.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kirtikumar Deshpande INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list

Re: 9i-OCP Question

2003-07-30 Thread Kirtikumar Deshpande
://www.orafaq.net -- Author: Kirtikumar Deshpande 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: 9i-OCP Question

2003-07-30 Thread Kirtikumar Deshpande
://www.orafaq.net -- Author: Kirtikumar Deshpande 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: direct path write waits, please help

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

Re: Oracle 7.3.2

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

RE: upgrade to 9i

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

RE: Unix root account remote access

2003-07-18 Thread Kirtikumar Deshpande
08816-2825 (732) 672-0464 (Cell) (732) ! 257-6001 (Home) __ Do you Yahoo!? SBC Yahoo! DSL - Now only $29.95 per month! http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kirtikumar Deshpande INET: [EMAIL PROTECTED

Re: sqlldr questions

2003-07-17 Thread Kirtikumar Deshpande
INET: [EMAIL PROTECTED] __ Do you Yahoo!? SBC Yahoo! DSL - Now only $29.95 per month! http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kirtikumar Deshpande INET: [EMAIL PROTECTED] Fat City Network Services

RE: Why are SPFILEs binary anyway? (was RE: How to make SPFILE in

2003-07-17 Thread Kirtikumar Deshpande
.*2 __ Do you Yahoo!? SBC Yahoo! DSL - Now only $29.95 per month! http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kirtikumar Deshpande INET: [EMAIL PROTECTED] Fat City

Re: STATSPACK in Oracle 8.1.6.0

2003-07-17 Thread Kirtikumar Deshpande
! DSL - Now only $29.95 per month! http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kirtikumar Deshpande INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web

RE: RMAN SQL Backtrack

2003-07-16 Thread Kirtikumar Deshpande
, July 16, 2003 10:59 AM To: Multiple recipients of list ORACLE-L __ Do you Yahoo!? SBC Yahoo! DSL - Now only $29.95 per month! http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kirtikumar Deshpande INET: [EMAIL

Re: RMAN SQL Backtrack

2003-07-16 Thread Kirtikumar Deshpande
!? SBC Yahoo! DSL - Now only $29.95 per month! http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kirtikumar Deshpande INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing

Re: How to make SPFILE in sync with INIT.ORA ?

2003-07-16 Thread Kirtikumar Deshpande
=== __ Do you Yahoo!? SBC Yahoo! DSL - Now only $29.95 per month! http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kirtikumar Deshpande INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com

RE: Why are SPFILEs binary anyway? (was RE: How to make SPFILE in

2003-07-16 Thread Kirtikumar Deshpande
- Now only $29.95 per month! http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kirtikumar Deshpande INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web

RE: 10i reg.

2003-07-16 Thread Kirtikumar Deshpande
! __ Do you Yahoo!? SBC Yahoo! DSL - Now only $29.95 per month! http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kirtikumar Deshpande INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego

Re: How to make SPFILE in sync with INIT.ORA ?

2003-07-14 Thread Kirtikumar Deshpande
: Kirtikumar Deshpande INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list

RE: import from 8i to 9i /IMP-00003:ORA-02298

2003-07-09 Thread Kirtikumar Deshpande
://www.orafaq.net -- Author: Kirtikumar Deshpande 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: tunning an index built

2003-07-09 Thread Kirtikumar Deshpande
Yahoo!? SBC Yahoo! DSL - Now only $29.95 per month! http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kirtikumar Deshpande INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California

RE: Tech meetings

2003-07-09 Thread Kirtikumar Deshpande
: Kirtikumar Deshpande 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: OEM tools

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

RE: import from 8i to 9i /IMP-00003:ORA-02298

2003-07-08 Thread Kirtikumar Deshpande
] __ Do you Yahoo!? SBC Yahoo! DSL - Now only $29.95 per month! http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kirtikumar Deshpande INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http

Re: import from 8i to 9i /IMP-00003:ORA-02298

2003-07-08 Thread Kirtikumar Deshpande
-- Author: INET: [EMAIL PROTECTED] __ Do you Yahoo!? SBC Yahoo! DSL - Now only $29.95 per month! http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kirtikumar Deshpande INET: [EMAIL PROTECTED] Fat City Network Services

Re: Windows server max file size

2003-07-07 Thread Kirtikumar Deshpande
nothing. Not dreaming costs you everything. __ Do you Yahoo!? SBC Yahoo! DSL - Now only $29.95 per month! http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kirtikumar Deshpande INET: [EMAIL PROTECTED] Fat City Network

Re: RE: Should percent increase higher than 0 in 817?

2003-07-04 Thread Kirtikumar Deshpande
. Right or wrong? Guang snip __ Do you Yahoo!? SBC Yahoo! DSL - Now only $29.95 per month! http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kirtikumar Deshpande INET: [EMAIL PROTECTED] Fat City Network Services

RE: Oracle DBA 9i Books ever needed.

2003-07-02 Thread Kirtikumar Deshpande
that isn't included in your existing books, we can recommend books that cover different material. For performance tuning, a great book to start with is: Oracle 101 Performance Tuning by Jaga Krishna Vaidyanatha, Kirtikumar Deshpande, and John Kostelac. I have also been impressed

RE: Should percent increase higher than 0 in 817?

2003-07-02 Thread Kirtikumar Deshpande
://www.orafaq.net -- Author: Gogala, Mladen INET: [EMAIL PROTECTED] __ Do you Yahoo!? SBC Yahoo! DSL - Now only $29.95 per month! http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kirtikumar Deshpande INET

Re: Redo Copy Latch contention ??

2003-07-02 Thread Kirtikumar Deshpande
://www.orafaq.net -- Author: Kirtikumar Deshpande 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: Should percent increase higher than 0 in 817?

2003-07-02 Thread Kirtikumar Deshpande
terminated... - Kirti --- Kirtikumar Deshpande [EMAIL PROTECTED] wrote: After we rolled out our own scripts to monitor TS usage (de-Installing BMC Patrol) following is a line from a Very Senior DBA's email sent to us (not-so-senior-DBA-team-members) yesterday: I don't think the script

RE: Dedicated Server problem ORA-03113

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

Re: log for transaction

2003-06-24 Thread Kirtikumar Deshpande
Yahoo!? SBC Yahoo! DSL - Now only $29.95 per month! http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kirtikumar Deshpande INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California

Re: WAITED TOO LONG FOR A ROW CACHE ENQUEUE LOCK! pid=12

2003-06-20 Thread Kirtikumar Deshpande
only $29.95 per month! http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kirtikumar Deshpande INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting

Re: Inserting blanks from a PROCOBOL program

2003-06-19 Thread Kirtikumar Deshpande
-- __ Do you Yahoo!? SBC Yahoo! DSL - Now only $29.95 per month! http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kirtikumar Deshpande INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com

RE: copy a datafile to a raw device

2003-06-19 Thread Kirtikumar Deshpande
be wrong with my dd command thanks Gene __ Do you Yahoo!? SBC Yahoo! DSL - Now only $29.95 per month! http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kirtikumar Deshpande INET: [EMAIL PROTECTED] Fat

Re: OEM question

2003-06-18 Thread Kirtikumar Deshpande
-- Author: Kirtikumar Deshpande 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: ORA-01555 with Automatic Undo Management mode

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

Re: Partitions of table read only

2003-06-18 Thread Kirtikumar Deshpande
Landrum INET: [EMAIL PROTECTED] __ Do you Yahoo!? SBC Yahoo! DSL - Now only $29.95 per month! http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kirtikumar Deshpande INET: [EMAIL PROTECTED] Fat City Network

Re: Partitions of table read only

2003-06-18 Thread Kirtikumar Deshpande
, no one else knows anything about that table. As far as any other user in the database knows, it doesn't exist. Nor does the tablespace --- Kirtikumar Deshpande [EMAIL PROTECTED] wrote: Rachel, You forgot to kill all other active transactions... ;( - Kirti

Re: ORA-01555 with Automatic Undo Management mode

2003-06-18 Thread Kirtikumar Deshpande
Yahoo!? SBC Yahoo! DSL - Now only $29.95 per month! http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kirtikumar Deshpande INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California

Re: Partitions of table read only

2003-06-18 Thread Kirtikumar Deshpande
. Oh yeah, 9.2.0.1 on Linux Rachel __ Do you Yahoo!? SBC Yahoo! DSL - Now only $29.95 per month! http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kirtikumar Deshpande INET: [EMAIL PROTECTED] Fat City Network

RE: HP-Sun Cross Platform Migration - Exp/Imp, CTAS over dblink or ..

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

Re: count(*) vs count(0)

2003-06-06 Thread Kirtikumar Deshpande
Vivek, Your same question on LazyDBA list hasbeen answered correctly. :) - Kirti VIVEK_SHARMA [EMAIL PROTECTED] wrote: Is there a performance equality between COUNT(*) COUNT(0) ?Is it same , indpendent of the Oracle Version ?Forgive the repeat raising , as this issue seems to have come before

Re: A new form of ORA-1555

2003-06-06 Thread Kirtikumar Deshpande
A classic case when AUM does not help prevent 1555 errors ! Query duration is MAXQUERYLENreported inv$undostat view. SCN could be the 'as of SCN' when the query started (not sure, as I could never get my small tests to failwith 1555 when using AUM). What is also interesting is the SMON

Re: A new form of ORA-1555

2003-06-06 Thread Kirtikumar Deshpande
calendar with sync to Outlook(TM). http://calendar.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kirtikumar Deshpande INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web

Re: A new form of ORA-1555

2003-06-06 Thread Kirtikumar Deshpande
] __ Do you Yahoo!? Yahoo! Calendar - Free online calendar with sync to Outlook(TM). http://calendar.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kirtikumar Deshpande INET: [EMAIL PROTECTED] Fat City Network Services

Re: buffer busy waits, unique index, p3=1?

2003-06-06 Thread Kirtikumar Deshpande
Yahoo!? Yahoo! Calendar - Free online calendar with sync to Outlook(TM). http://calendar.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kirtikumar Deshpande INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego

  1   2   >