Oracle 9.0.1.3 or 9.2.0?

-- Author: Raj Gopalan 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 this mailing list

RE: Statistics not updated

Hi DBAs The DB is 8.1.5 on Solaris under CBO. The statistics for some of the tables are getting updated after issuing analyze table. I tried with dbms_utility also but no result. What could be wrong? Thanks Raj -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: R

Statistics not updated

: Raj Gopalan 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 this mailing list, send an E

RE: Oracle Reports....

he 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raj Gopalan INET: [EMAIL PROTECTED] Fa

RE: Unix Cron Job

d the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raj Gopalan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access

Slightly OT : IFS Search is Slow.

ing mode :MTS table space for ifs : localymanaged Thanks in Advance Raj -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raj Gopalan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858)

Higher Consistent Gets...

optimizer mode is choose. How do I tune this or Am I missing something obivious?? Thanks Raj -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raj Gopalan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California

RE: STOP THE PRESS!!

ices-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists ---- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT

Recall: Extent's datafile.

Raj Gopalan would like to recall the message, "Extent's datafile.". -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raj Gopalan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California

Extent's datafile.

DBAs I manually allocated extents of a table to different datafiles. Which performance views will give information relating extents and datafiles? Cheers Raj -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raj Gopalan INET: [EMAIL PROTECTED] Fat City Network

RE: Locally managed tablespaces

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

RE: PL/SQL

e HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raj Gopalan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051

RE: Quick select question

communication is strictly prohibited. If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computer system. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raj Gopalan

Ora-600 : Internal error code.. Help!!!

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

Shared server model

. Any thoughts on this would be helpful to me.. Thanks Raj -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raj Gopalan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access

RE: Shared Pool info - V$sqlarea.

atio is 60%. Any Idea what could be reason? TIA, Raj -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raj Gopalan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mai

Shared Pool info - V$sqlarea.

library cache hit ratio is 97%.where us SQLAREA hit ratio is 60%. Any Idea what could be reason? TIA, Raj -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raj Gopalan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San

Deleting Files in NT

DBAs How do I delete files from NT which are older than a week. I need this to organise my backup dump files. Cheers Raj -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raj Gopalan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858

RMAN Catalog - Backup Strategy

DBAs I am taking the export backup of RMAN catalog DB from the Target DB server , immediately after the target DB RMAN backup. Is it a decent way or can it be done better? Cheers Raj -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raj Gopalan INET: [EMAIL

RE: Alert log

: http://www.orafaq.com -- Author: Raj Gopalan 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 fro

RE: Alert log

later you can control the level of tracing with the LOG_ARCHIVE_TRACE parameter. See the following docs: Note 94055.1 "Init.ora Parameter "LOG_ARCHIVE_TRACE" Reference Note" Note 104405.1 "ARCH tracefile messages VALIDATE, PREPARE, INITIALIZE, SPOOL, FINISH" HTH, --

Alert log

setting for this.. Could you help me in locating the cause for these messages in alert.log.. TIA Cheers Raj -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raj Gopalan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego

No Subject

-- Author: Raj Gopalan 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 this mailing list

RMAN Question

-- Author: Raj Gopalan 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 this mailing list

RMAN Backup Size

-- Author: Raj Gopalan 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 this mailing list, send

Background Process

DBAs I facing severe IO on the server. I got no clue why. I find three oracle background processes which I never heard of. They are ora_i101_orcl, ora_i102_orcl, ora_i201_orcl. Any idea what is this? Thanks Raj -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raj

RE: RMAN-06004 Error

ase see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raj Gopalan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists -

RMAN-06004 Error

this issue in metalink. Any Idea what could be the cause? Thanks Raj -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raj Gopalan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet

RE: RE: Rollback seg for an entire session, not just per tran

Oops.. That was typo :-) -Original Message- Sent: 03 April 2001 17:01 To: Raj Gopalan; Multiple recipients of list ORACLE-L Raj, OH, I hate to contradict people, but several months ago we had a couple of very long running jobs that accidentally filled all of the rollback segment

RE: Rollback seg for an entire session, not just per transaction?

pelling 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq

RE: Sql question

27;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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Auth

RE: Pinning Tables

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). -- Please see the official ORACLE-L FAQ: http://www.o

RE: V$log Status

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

RE: V$log Status

because the arch process is still working. If it was a noarchivelog database, it would be a block recovering what is going on. Regards. > -Mensaje original- > De: Raj Gopalan [SMTP:[EMAIL PROTECTED]] > Enviado el: viernes 2 de febrero de 2001 13:26 > Para: Multiple recipi

V$log Status

for this? I got 8.1.6 undex solaris. TIA Raj -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raj Gopalan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing

RE: book topic request

g list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raj Gopalan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051