RE: RMAN - problems restoring to clone server

2003-01-31 Thread Johnson Poovathummoottil
!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Johnson Poovathummoottil INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California

Re: Parallel query on partitioned table gives inconsisitent

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

Parallel query on partitioned table gives inconsisitent results in 9.2.0.2

2003-01-23 Thread Johnson Poovathummoottil
. __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Johnson Poovathummoottil INET: [EMAIL PROTECTED] Fat City Network Services

Find Queries by a group of users

2002-10-24 Thread Johnson Poovathummoottil
. Please advice. __ Do you Yahoo!? Y! Web Hosting - Let the expert host your web site http://webhosting.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Johnson Poovathummoottil INET: [EMAIL PROTECTED] Fat

RE: Advice needed on move to Sun 15K (losing spindles)

2002-10-14 Thread Johnson Poovathummoottil
executables and some other === message truncated === __ Do you Yahoo!? Faith Hill - Exclusive Performances, Videos More http://faith.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Johnson Poovathummoottil INET

Re: Changing ONAMES enrtries fiasco

2002-09-25 Thread Johnson Poovathummoottil
). __ Do you Yahoo!? New DSL Internet Access from SBC Yahoo! http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Johnson Poovathummoottil INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http

Re: Best Practice - Partitioned object, one partition per tablespace,

2002-09-25 Thread Johnson Poovathummoottil
-- Author: Johnson Poovathummoottil 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: Changing ONAMES enrtries fiasco

2002-09-25 Thread Johnson Poovathummoottil
of the change, except after it's daily (by default) region DB refresh. Thanks! Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -Original Message- From: Johnson Poovathummoottil

Re: RMAN restore to another node

2002-09-18 Thread Johnson Poovathummoottil
are just checking to see whether anyone else has experienced this behavior? Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] -Original Message- From: Johnson Poovathummoottil [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 17, 2002 9:02

RE: RMAN restore to another node

2002-09-18 Thread Johnson Poovathummoottil
. [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] -Original Message- From: Johnson Poovathummoottil [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 17, 2002 9:02 AM To: DENNIS WILLIAMS; '[EMAIL PROTECTED]' Cc: '[EMAIL PROTECTED]' Subject: RE: RMAN restore to another

RMAN restore to another node

2002-09-17 Thread Johnson Poovathummoottil
: Johnson Poovathummoottil 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: RMAN restore to another node

2002-09-17 Thread Johnson Poovathummoottil
than have RMAN recover it. I'm just wondering whether you are getting some side-effect from the successful control file recovery.   Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] -Original Message- From: Johnson Poovathummoottil [mailto

RE: RMAN restore to another node

2002-09-17 Thread Johnson Poovathummoottil
] -Original Message- From: Johnson Poovathummoottil [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 17, 2002 9:02 AM To: DENNIS WILLIAMS; '[EMAIL PROTECTED]' Cc: '[EMAIL PROTECTED]' Subject: RE: RMAN restore to another node Oracle support too pointed to that. I tested

RE: RMAN restore to another node

2002-09-17 Thread Johnson Poovathummoottil
commands? Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] -Original Message- From: Johnson Poovathummoottil [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 17, 2002 9:23 AM To: Multiple recipients of list ORACLE-L Subject: RMAN restore

RE: RMAN restore to another node

2002-09-17 Thread Johnson Poovathummoottil
is, why are you getting this error: RMAN-06026: some targets not found - aborting restore Are you trying to restore all of the files, are just some of them? Tom Mercadante Oracle Certified Professional -Original Message- From: Johnson Poovathummoottil [mailto:[EMAIL

RE: RMAN restore to another node

2002-09-17 Thread Johnson Poovathummoottil
commands, so I am only guessing here - but that is what the error is telling you. You do not have any channel's available for Rman to use. Good Luck. Tom Mercadante Oracle Certified Professional -Original Message- From: Johnson Poovathummoottil [mailto:[EMAIL PROTECTED

Is buffer gets same as logical reads?

2002-08-20 Thread Johnson Poovathummoottil
-- Author: Johnson Poovathummoottil INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from

Re: extremely high number of executions

2002-08-02 Thread Johnson Poovathummoottil
the p1-p3 columns. HTH, Jared Johnson Poovathummoottil [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 07/31/2002 02:50 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Re

extremely high number of executions

2002-07-31 Thread Johnson Poovathummoottil
ORACLE-L FAQ: http://www.orafaq.com -- Author: Johnson Poovathummoottil INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

Re: extremely high number of executions

2002-07-31 Thread Johnson Poovathummoottil
by time_waited / Johnson Poovathummoottil [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 07/31/2002 01:24 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:extremely high number of executions Hi

RE: Number of File systems to use.

2002-04-25 Thread Johnson Poovathummoottil
person to address that question. RF Robert G. Freeman Author Oracle9i New Features by Oracle Press Mastering Oracle8i By Sybex -Original Message- From: Johnson Poovathummoottil [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 24, 2002 8:58 AM To: LazyDBA.com Discussion Subject

RE: What block size are you using for your new 9i data warehouse?

2002-04-25 Thread Johnson Poovathummoottil
://games.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Johnson Poovathummoottil INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

file open, db file parallel write

2002-04-25 Thread Johnson Poovathummoottil
? __ Do You Yahoo!? Yahoo! Games - play chess, backgammon, pool and more http://games.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Johnson Poovathummoottil INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051

Number of File systems to use.

2002-04-24 Thread Johnson Poovathummoottil
chess, backgammon, pool and more http://games.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Johnson Poovathummoottil INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet

Re: Number of File systems to use.

2002-04-24 Thread Johnson Poovathummoottil
My understanding was that EMC does not stripe its disks. they just have mirror and RAID S. --- Sr DBA [EMAIL PROTECTED] wrote: Why would you software stripe it if you are using EMC? - Original Message - From: Johnson Poovathummoottil [EMAIL PROTECTED] To: LazyDBA.com Discussion

Re: migrate from 8i to 9i

2002-04-11 Thread Johnson Poovathummoottil
). __ Do You Yahoo!? Yahoo! Tax Center - online filing with TurboTax http://taxes.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Johnson Poovathummoottil INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858

Fine Grained Acces

2002-03-29 Thread Johnson Poovathummoottil
Johnson __ Do You Yahoo!? Yahoo! Greetings - send holiday greetings for Easter, Passover http://greetings.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Johnson Poovathummoottil INET: [EMAIL PROTECTED] Fat

Moving databases from WIN2K to Unix

2002-01-21 Thread Johnson Poovathummoottil
FREE video emails in Yahoo! Mail! http://promo.yahoo.com/videomail/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Johnson Poovathummoottil INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California

Re: Data warehouse on Win2K

2001-10-30 Thread Johnson Poovathummoottil
!? Make a great connection at Yahoo! Personals. http://personals.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Johnson Poovathummoottil INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego

Data warehouse on Win2K

2001-10-29 Thread Johnson Poovathummoottil
! Personals. http://personals.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Johnson Poovathummoottil INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing

Re: Partition tables: Indexes

2001-10-01 Thread Johnson Poovathummoottil
://phone.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Johnson Poovathummoottil INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

RE: Freelist Contention

2001-08-21 Thread Johnson Poovathummoottil
for other information (like subscribing). __ Do You Yahoo!? Make international calls for as low as $.04/minute with Yahoo! Messenger http://phonecard.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Johnson

RE: Freelist Contention - PQ slaves

2001-08-21 Thread Johnson Poovathummoottil
busy waits. --- Koivu, Lisa [EMAIL PROTECTED] wrote: I thought that parallel query slaves were smart enough to divide up the work between them so there was no overlap? What am I missing? Can you elaborate? -Original Message- From: Johnson Poovathummoottil [SMTP:[EMAIL

Disk config. for datafiles of Temp Tablespace

2001-08-14 Thread Johnson Poovathummoottil
/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Johnson Poovathummoottil INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

Re: How to improve the performance of Direct path Write?

2001-07-09 Thread Johnson Poovathummoottil
Yahoo!? Get personalized email addresses from Yahoo! Mail http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Johnson Poovathummoottil INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego

Using data dictionary tables to manage application

2001-07-06 Thread Johnson Poovathummoottil
://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Johnson Poovathummoottil INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

Re: large SORT_AREA_SIZE usefullness

2001-06-22 Thread Johnson Poovathummoottil
? __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Johnson Poovathummoottil INET: [EMAIL PROTECTED] Fat City Network

Re: large SORT_AREA_SIZE usefullness

2001-06-21 Thread Johnson Poovathummoottil
Yahoo!? Get personalized email addresses from Yahoo! Mail http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Johnson Poovathummoottil INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego

Re: Waits on cache buffers chains latch

2001-06-21 Thread Johnson Poovathummoottil
email addresses from Yahoo! Mail http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Johnson Poovathummoottil INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public

large SORT_AREA_SIZE usefullness

2001-06-20 Thread Johnson Poovathummoottil
. Could some one explain this behaviour? __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Johnson Poovathummoottil INET

RE: large SORT_AREA_SIZE usefullness

2001-06-20 Thread Johnson Poovathummoottil
ORACLE-L FAQ: http://www.orafaq.com -- Author: Johnson Poovathummoottil INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

RE: Tuning Sorts

2001-06-16 Thread Johnson Poovathummoottil
!? Spot the hottest trends in music, movies, and more. http://buzz.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Johnson Poovathummoottil INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California

Tuning Sorts

2001-06-15 Thread Johnson Poovathummoottil
addresses from Yahoo! Mail - only $35 a year! http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Johnson Poovathummoottil INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California

RE: Help! Emergency! Upgrade 8.1.6 to 8.1.7

2001-06-15 Thread Johnson Poovathummoottil
__ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail - only $35 a year! http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Johnson Poovathummoottil INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX

Sort_multiblock_read_count

2001-06-14 Thread Johnson Poovathummoottil
__ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail - only $35 a year! http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Johnson Poovathummoottil INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051

RE: Temporary files and Quick i/o

2001-05-18 Thread Johnson Poovathummoottil
://www.orafaq.com -- Author: Johnson Poovathummoottil INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from

When to go for ORACLE NAMES Server

2001-05-11 Thread Johnson Poovathummoottil
://auctions.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Johnson Poovathummoottil INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

Re: RMAN Backup Size

2001-04-30 Thread Johnson Poovathummoottil
ORACLE-L FAQ: http://www.orafaq.com -- Author: Johnson Poovathummoottil INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

Statspack

2001-04-25 Thread Johnson Poovathummoottil
-- Author: Johnson Poovathummoottil INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from

Script to Compare table structures

2001-03-28 Thread Johnson Poovathummoottil
FAQ: http://www.orafaq.com -- Author: Johnson Poovathummoottil INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

Re: How to alter default tablespace of IOT?

2001-02-15 Thread Johnson Poovathummoottil
esses from Yahoo! Mail - only $35 a year! http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Johnson Poovathummoottil INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego,

Re: How to alter default tablespace of IOT?

2001-02-15 Thread Johnson Poovathummoottil
ttp://www.orafaq.com -- Author: Johnson Poovathummoottil INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet ac