Re: clustering

(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: Does the client hang or disconnect when the server's

it shorter (sqlnet.expire_time?) Check metalink note 151972.1 for more info. HTH Mike Hemant K Chitale [EMAIL PROTECTED]To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] .com.sg cc

Question about EXTPROC and vulnerability

/renaming the extproc executable. Why ? Is it that Oracle wants people to use EXTPROC [or makes use of EXTPROC itself] so it does not specify how EXTPROC can be disabled ? Hemant K Chitale Oracle 9i Database Administrator Certified Professional My personal web site is : http://hkchital.tripod.com

Does the client hang or disconnect when the server's

SQLPlus get server disconnect from the TCP stack ? 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: Why are SPFILEs binary anyway? (was RE: How to make SPFILE

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 My

Recent reports on outages caused by DB2 and 9iRAC issues

] http://www.eweek.com/article2/0,3959,1196879,00.asp and http://www.computerworld.com/databasetopics/data/software/story/0,10801,83186,00.html Hemant K Chitale Oracle 9i Database Administrator Certified Professional My personal web site is : http://hkchital.tripod.com -- Please see

Recreating the Temporary segment in a TEMPORARY Tablespace

is not valid. What other commands could I use ? Creating another TEMPORARY TABLESPACE, changing user's TEMPORARY_TABLESPACE and then dropping the first tablespace is an option but one that I would not prefer. Hemant K Chitale Oracle 9i Database Administrator Certified Professional My personal web site

Re: Tech meetings

this, and was wondering if there is a quick list out there any where. TIA 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

RE: What are the restrictions in naming an Oracle SID/Database?

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: Caffeine good.

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: TSPITR or PITR

). 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: TSPITR or PITR

database. Therefore, my response on the test (tablespace point-in-time recovery), coming from successful experience in production environments, would have been marked incorrect on this test. C'est la vie (or more appropriately C'est la certification)... on 6/29/03 4:34 AM, Hemant K Chitale at [EMAIL

Re: Friday Humor - RMAN

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: High-availability database question !!!!

confidential ; ] Regards Hemant At 10:34 PM 26-06-03 -0800, you wrote: You mean the Danish Promis system? You're running that? Hemant K Chitale wrote: The That might come as a surprise to some people, but there's basically no 25/8/370 availability with Oracle unless you either specify downtime as something

Re: High-availability database question !!!!

). ___ LOOK GOOD, FEEL GOOD - WWW.HEALTHIEST.CO.ZA Cool Connection, Cool Price, Internet Access for R59 monthly @ WebMail http://www.webmail.co.za/dialup/ Hemant K Chitale Oracle 9i Database Administrator Certified Professional My

Re: is a process/session rolling back ?

') 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 web site is : http

RE: copy a datafile to a raw device

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 PROTECTED] Fat

RE: AQ, RAC and delay

Message- Hemant K Chitale Sent: Thursday, June 19, 2003 5:38 AM To: Multiple recipients of list ORACLE-L Although MCPD may default to 700centiseconds [although I have seen a much lower value on 9.2 on Tru64], in most cases, delays of 7seconds don't occur [and shouldn't be acceptable ?!]. I do have

RE: Oracle Financials 10SC on HP-UX rev 11

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

Re: AQ, RAC and delay

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 site

RE: ORA600 [2103] [0] [0] [1] [900]

when the server is less busy --- to verify the busyness being the cause of the Control File Enqueue Hemant At 11:44 PM 12-06-03 -0800, you wrote: It is a local filesystem Kind Regards, Hatzistavrou Yannis -Original Message- From: Hemant K Chitale [mailto:[EMAIL PROTECTED] Sent

RE: RAC, fail over and timeout .. Big Question

] (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

Re: SYS not able to GRANT -- Strange !

(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://www.fatcity.com San Diego, California-- Mailing

Re: SYS not able to GRANT -- Strange !

(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://www.fatcity.com San Diego, California-- Mailing

changing optimizer_mode for a running session

and restarting the session -- something like using DBMS_SYSTEM.SET_EV to set an event in a running session. 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:

') 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 web site

RE: changing optimizer_mode for a running session

dbms_system.SET_BOOL_PARAM_IN_SESSION (17, 520, 'optmizer_mode', TRUE); PL/SQL procedure successfully completed. Mark -Original Message- Hemant K Chitale Sent: 12 June 2003 12:09 To: Multiple recipients of list ORACLE-L I am talking of a scenario where another user has already connected

Re: ORA600 [2103] [0] [0] [1] [900]

304666384 session uga memory Has anybody encountered such problem before? How can it be resolved? Kind Regards, Hatzistavrou Yannis Database Administrator SchlumbergerSema Phone ext. 478 Email: [EMAIL PROTECTED] Hemant K Chitale Oracle 9i Database Administrator Certified Professional My

Re: HP-Sun Cross Platform Migration - Exp/Imp, CTAS over

(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: HP-Sun Cross Platform Migration - Exp/Imp, CTAS over

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 PROTECTED] Fat City

Re: Database recovery question

(Technical Support) Shell International Limited Shell Centre, London SE1 7NA, United Kingdom Tel: +44 (0)20 7934 4529 Email: [EMAIL PROTECTED] Internet: http://www.shell.comhttp://www.shell.com Hemant K Chitale Oracle 9i Database Administrator Certified Professional My personal web site is : http

Re: Tablespace management.

-Mail 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

RE: RMAN: What blocks are backed up with a full backup?

of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Hemant K Chitale My personal web site is : http://hkchital.tripod.com -- Please see

Re: daily clone

an E-Mail 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 My

Re: Immediate v. Abort

Chitale 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 Diego, California-- Mailing list and web hosting

Re: RE: Autoallocate vs Uniform extent performance

). You may also send the HELP command for other information (like subscribing). Hemant K Chitale 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: alter table add

command for other information (like subscribing). Hemant K Chitale 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: Upgrade 8.1.7.0 to 8.1.7.4.x Tru64 Parallel Server

you want to be removed from). You may also send the HELP command for other information (like subscribing). Hemant K Chitale 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: may not be necessary -- was RE: Oracle DB Backups on SAN

the HELP command for other information (like subscribing). Hemant K Chitale 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

Archive of all our postings at BlackSheepNetworks

Guys, Are you aware of the archives of all our postings to ORACLE-L at http://www.blacksheepnetworks.com/security/resources/oracle-mailinglist/author.html Hemant K Chitale My personal web site is : http://hkchital.tripod.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net

may not be necessary -- was RE: Oracle DB Backups on SAN with

that they will be providing. Hemant At 08:04 AM 26-03-03 -0800, you wrote: Why do you have to suspend? -- Jeremiah Wilton http://www.speakeasy.net/~jwilton On Wed, 26 Mar 2003, Hemant K Chitale wrote: We want true server-less backups. I know that RMAN's overhead is [much] lower than

RE: Urgent: restore from hot backup w/o archivelogs

containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Hemant K Chitale My personal web site is : http://hkchital.tripod.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net

Re: max_commit_propagation_delay

, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Hemant K Chitale My personal web site is : http://hkchital.tripod.com -- Please see the official ORACLE-L FAQ: http

RE: Oracle DB Backups on SAN with ALTER SYSTEM SUSPEND

? -- Jeremiah Wilton http://www.speakeasy.net/~jwilton On Wed, 26 Mar 2003, Hemant K Chitale wrote: We want true server-less backups. I know that RMAN's overhead is [much] lower than that of the ALTER TABLESPACE BEGIN/END BACKUP but the Snapshot method in a SAN [akin to splitting and resilivering

RE: Oracle DB Backups on SAN with ALTER SYSTEM SUSPEND

for the SUSPEND/RESUME, actually flushing all I/O to the disks] ? The SAN will be a Hitachi 9970 sold by Sun. The databases will be 8.1.7 32-bit / 64-bit on Solaris 8. Hemant K Chitale http://hkchital.tripod.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hemant K Chitale INET

RE: Quick Question -- 8.1.7 logs applied to 9.2.0 database

as soon as possible... Thanks! Nick Wagner Hemant K Chitale 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: Database Modeling- Normalization - Dinosaurs or What?

viruses and advise you to carry out your own virus checks before opening any attachment. Hemant K Chitale 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: Quick Question -- 8.1.7 logs applied to 9.2.0 database

about who it makes friends with. -Original Message- From: Hemant K Chitale [mailto:[EMAIL PROTECTED]mailto:[EMAIL PROTECTED] Sent: Tuesday, March 25, 2003 9:19 AM To: Multiple recipients of list ORACLE-L Subject: RE: Quick Question -- 8.1.7 logs applied to 9.2.0 database Courageous

Oracle DB Backups on SAN with ALTER SYSTEM SUSPEND

for the SUSPEND/RESUME, actually flushing all I/O to the disks] ? The SAN will be a Hitachi 9970 sold by Sun. The databases will be 8.1.7 32-bit / 64-bit on Solaris 8. Hemant K Chitale http://hkchital.tripod.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hemant K

RE: Shutdown Immediate hangs

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://www.fatcity.com San

RE: Temporary Tablespace and RAC

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

RE: Passing DB-Link name in a Loop

dba_data_files@'||remote_db; execute immediate exec_string into db_size; T¬ -Original Message- From: Hemant K Chitale [mailto:[EMAIL PROTECTED] Sent: 21 March 2003 01:34 To: Multiple recipients of list ORACLE-L Subject: Passing DB-Link name in a Loop Guys, help me here

Re: Error while running export backup shell script

you. 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://www.fatcity.com San Diego, California-- Mailing list and web

RE: Passing DB-Link name in a Loop

- From: Hemant K Chitale [mailto:[EMAIL PROTECTED] Sent: 21 March 2003 09:48 To: Tim Onions; [EMAIL PROTECTED] Subject: RE: Passing DB-Link name in a Loop Thanks Tim ! That works ! now I just have to resolve the ORA-02020: too many database links in use error ! Thanks again

Re: audit_trail=db Overhead ?

containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Hemant K Chitale My personal web site is : http://hkchital.tripod.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author

RE: Error while running export backup shell script

:/data/oracle9i/product/9.0.1:N FANTA:/oracle8i/product/8.1.6:N LSYRS:/oracle8i/product/8.1.6:N Still the script is not running properly. Should I change anything in the script? Thanks and Regards, Ranganath -Original Message- From: Hemant K Chitale [SMTP:[EMAIL PROTECTED

RE: switch logfile vs. archive log current

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

RE: New DBA.

list you want to be removed from). You may also send the HELP command for other information (like subscribing). Hemant K Chitale 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

RE: switch logfile vs. archive log current

may also send the HELP command for other information (like subscribing). Hemant K Chitale 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: switch logfile vs. archive log current

command for other information (like subscribing). Hemant K Chitale 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

DB_FILE_MULTIBLOCK_READs and Extent boundaries -- was RE: db

to confitrm that on Metalink. -Original Message- From: Hemant K Chitale [mailto:[EMAIL PROTECTED] Sent: Monday, March 17, 2003 9:44 AM To: Multiple recipients of list ORACLE-L Subject: Re: db file scattered read If 14706+3 is one extent and another extent begins at 14710

Thin JDBC and IPC -- was re: OT: 11i Autoupgrade and IPC

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

Usage of mySQL in enterprise environments

I've been asked to consider whether we can use mySQL for non-critical, but probably, enterprise-wide databases [e.g. information stores]. How good is the feedback on mySQL handling Queries, Transactions, ConcurrentUserCounts and DatabaseSize ? Hemant K Chitale http://hkchital.tripod.com

Re: db file scattered read

WAIT #32: nam='db file scattered read' ela= 1 p1=4 p2=14739 p3=3 WAIT #32: nam='db file scattered read' ela= 1 p1=4 p2=14744 p3=8 WAIT #32: nam='db file scattered read' ela= 1 p1=4 p2=129784 p3=8 Thanks -ak Hemant K Chitale My personal web site is : http://hkchital.tripod.com -- Please see

Re: Sizing Indexes - URGENT

take into account the 10 bytes consumed by the ROWID pseudocolumn apart from the column(s) that are indexed ? TIA for all your help. Best Regards Jai Hemant K Chitale My personal web site is : http://hkchital.tripod.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author

Re: Standby errors

to be removed from). You may also send the HELP command for other information (like subscribing). Hemant K Chitale 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: Oracle Client Software Version

of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Hemant K Chitale My 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 : Running multiple instances on a [large] server -- Thanks

running. Therefore, I would just buy the CPU license and not have to pay seperately for a NamedUser license for any databases on the same server. thanks everybody ! Hemant K Chitale My personal web site is : http://hkchital.tripod.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net

Re: Oracle Forms 6i - Does not Display

, distribute or copy this e-mail. Hemant K Chitale 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 Diego

Running multiple instances on a [large] server

the number of CPUs on the server, across all partitions, and buy a CPU license. Also, a CPU license is much preferable to Named-User as some of these databases would host Portals for 1,000+ end-users. Hemant K Chitale http://hkchital.tripod.com -- Please see the official ORACLE-L FAQ: http

RE: Oracle Internet File System

BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Hemant K Chitale My personal web site is : http://hkchital.tripod.com -- Please see the official ORACLE-L FAQ: http

Re: Oracle Internet File System

want to be removed from). You may also send the HELP command for other information (like subscribing). Hemant K Chitale 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

RE: ORA-00018: maximum number of sessions exceeded

PROTECTED][EMAIL PROTECTED] Hemant K Chitale 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 Diego, California

RE: Duplicate online Database

database? Inconsistent backups of RMAN + archivelogs = duplicate database?? Thanks Edouard Dormidontov Hemant K Chitale 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

Re: Metalink Oracle Support Improving.......

). Hemant K Chitale 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 Diego, California-- Mailing list

Re: MetaLink on the blink

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 http://hkchital.tripod.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hemant K

Re: History

] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Hemant K Chitale My web site page is : http

Fwd: Re: Optimizer help, get query to run as good as with RULE

://www.orafaq.net -- Author: Jonathan Lewis INET: [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hemant K Chitale INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web

Re: Cardinality Hint?

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

Re: Optimizer help, get query to run as good as with RULE hint

') 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 http://hkchital.tripod.com -- Please see the official

AW: was re Backups in a SAN with heterogenous environments

replied earlier. 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://www.fatcity.com San Diego, California-- Mailing list and web

re SAN, Heterogenous environments, Backups

Volume holding VxFS for HP to a Sun backup server as the Sun server cannot mount the file system. 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

Re: Optimizer help, get query to run as good as with RULE hint

). 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://www.fatcity.com San Diego, California-- Mailing list and web hosting

Re: Histograms on VARCHAR2 columns ?

positions would not get meaningful histogram statistics ? 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://www.fatcity.com San Diego

Re: 02/11/2003 security alerts

a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Hemant K Chitale My web site page is : http://hkchital.tripod.com -- Please see the official ORACLE-L FAQ: http

Fwd: Histograms on VARCHAR2 columns ?

Resending and hoping for some responses, even some real-world stories ... ?... Date: Sun, 09 Feb 2003 18:38:35 -0800 To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] X-Sender: Hemant K Chitale [EMAIL PROTECTED] Subject: Histograms on VARCHAR2 columns ? I have just begun trying

RE: Count(*) last 30 seconds

-- -- - -- DTMVENTAS 0 128 16384 TKS -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Hemant K Chitale Sent: Wednesday, February 12, 2003 8:59 AM To: Multiple recipients of list ORACLE-L Subject: RE: Count(*) last 30 seconds That's approx 100 records per blocks

RE: Count(*) last 30 seconds

sorts (memory) 0 sorts (disk) 1 rows processed -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Hemant K Chitale Sent: Tuesday, February 11, 2003 10:24 PM To: Multiple recipients of list ORACLE-L Subject: Re: Count(*) last 30 seconds You are doing Full

Re: Count(*) last 30 seconds

space. I consider that time exagerated. The TBS is LMT with a Uniform size of 128 MB. The block size is 8MB, version 9.2.0.1.0 in Windows 2000. Where should I start looking ??? TIA Ramon E. Estevez [EMAIL PROTECTED] 809-565-3121 Hemant K Chitale My web site page is : http

RE: SAN, Heterogenous environments, Backups

** -Original Message- From: Hemant K Chitale [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 05, 2003 5:34 PM To: Multiple recipients of list ORACLE-L Subject: SAN, Heterogenous environments, Backups We are considering implementing a SAN, using Sun StorEdge SS9970 [OEM from Hitachi], where

Histograms on VARCHAR2 columns ?

information and the selectivity will be 1 / DISTINCT. Does this mean that a column with, say, 10 or 12 character values but with the same character-string in the first 5 positions would not get meaningful histogram statistics ? Hemant K Chitale http://hkchital.tripod.com -- Please see

Re: Using Soft Links for Datafiles

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

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

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

RE: SQL*Net Connection under-performing

, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Hemant K Chitale My web site page is : http://hkchital.tripod.com -- Please see the official ORACLE-L FAQ: http

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

__ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art! Hemant K Chitale My web site

Re: Antwort: SAN, Heterogenous environments, Backups

Hemant K Chitale hkchital@singne An: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] t.com.sgKopie: Gesendet von:Thema: SAN, Heterogenous environments, Backups

SAN, Heterogenous environments, Backups

. How are Heterogenous implementations on a SAN done ? How are backups done ? 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

Oracle DB License - Named User Multi Server

of users n at your site does not exceed the Named User count, it does not matter how many databases m you create. The license my organisation had negotiated [when many seperate purchased license orders were combined into one] a few years ago is Named User Multi Server. Hemant K Chitale http

RE: SQL*Net Connection under-performing

Databases Qs How may the issue be approached ? Hemant K Chitale My web site page is : http://hkchital.tripod.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hemant K Chitale INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http

Re: Can logminer be used against 7.3 databases?

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

<    1   2   3   4   >