Re: What to look for in STATSPACK report

to generate charts. It includes some modifications to YAPPPACK. That sound OK Mogens? Jared Joan Hsieh [EMAIL PROTECTED] To:Multiple Sent by: [EMAIL PROTECTED] recipients of list ORACLE-L [EMAIL PROTECTED] 01/22/2004 09:19 AM

Re: What to look for in STATSPACK report

for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Joan Hsieh INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

Re: rman restore question

Of Joan Hsieh Sent: Tuesday, December 30, 2003 4:34 PM To: Multiple recipients of list ORACLE-L Subject: rman restore question Hi Listers, I have a question about rman restore. Right now, I configured RETENTION POLICY TO REDUNDANCY=1 and deleted the obsolete backupset on the disk

Re: rman restore question

Sorry, I tried set until time, it works. Now I think we can move rman to production since we tested all kinds of restore. Thanks and have nice day! Joan Joan Hsieh wrote: Ruth, thanks, I am back. I took the redundancy policy to 4 now and deleted today's backupset and try to recover from

Re: rman restore question

or directory Joan Joan Hsieh wrote: Hi Listers, I have a question about rman restore. Right now, I configured RETENTION POLICY TO REDUNDANCY=1 and deleted the obsolete backupset on the disk after a new rman full backup is done. The old backupset will be backup-ed

Re: rman restore question

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.net -- Author: Joan Hsieh INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California

Re: rman restore question

-03002: failure of restore command at 12/31/2003 15:36:27 ORA-19505: failed to identify file /rmanbackup/ADVDBA_F_20031231:15:03:39_1.450.rman ORA-27037: unable to obtain file status IBM AIX RISC System/6000 Error: 2: No such file or directory Joan Joan Hsieh wrote: Hi Listers, I have

rman restore question

. Many many thanks! Joan -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Joan Hsieh INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

RE: rman restore question

many thanks! Joan -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Joan Hsieh INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

RE: rman restore question

command and example to restore a obsoleted backupset. Any comments will be appreciated. Many many thanks! Joan -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Joan Hsieh INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http

Re: rman restore question

of view) I could find any command and example to restore a obsoleted backupset. Any comments will be appreciated. Many many thanks! Joan -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Joan Hsieh INET: [EMAIL PROTECTED] Fat City

Re: Clone db 9.2 on AIX 5L

I did it yesterday on AIX 5L 9.2.0.4, no problem at all Joan -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Joan Hsieh INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web

Re: sqlplus prompt question in 9i

command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Joan Hsieh INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

RE: sqlplus prompt question in 9i

instance. But if I do it manually (although not often I would say), I need to remember this and do it by hand. Also I think you only need to do it with dbstart script, not dbshut. Guang -Original Message- Joan Hsieh Sent: Wednesday, October 29, 2003 3:55 PM To: Multiple recipients

Re: Cary's book - Rapidly moving OT....

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.net -- Author: Joan Hsieh

Re: Huge optimization costs with 9.2

like query plans. alter session set _UNNEST_SUBQUERY = FALSE; alter session set _ORDERED_NESTED_LOOP = FALSE; alter session set _ALWAYS_SEMI_JOIN = off; explain plan for query; -Original Message- Joan Hsieh Sent: Wednesday, October 01, 2003 2:10 PM To: Multiple recipients of list

Re: Huge optimization costs with 9.2

INDEX GOAL: ANALYZED (FULL SCAN) OF [EMAIL PROTECTED] wrote: Yes. You have to bounce the database for this to take effect. -Original Message- Joan Hsieh Sent: Thursday, October 02, 2003 10:10 AM To: Multiple recipients of list ORACLE-L Govind, I will test it out today

Re: Huge optimization costs with 9.2

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.net -- Author: Joan Hsieh INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com

Re: Huge optimization costs with 9.2

Yes, they are same. Basically I didn't change any parameter after upgrade. Guang Mei wrote: Hi Joan: Is your hash_area_size parameter the same in both situations? Guang -Original Message- Joan Hsieh Sent: Wednesday, October 01, 2003 11:55 AM To: Multiple recipients of list

Re: Huge optimization costs with 9.2

, Joan Hsieh wrote: Kirti, I had upgraded a database from 8.1.7.4 to 9.2.0.4. Before the upgrade, performance is good. After upgrade, one query run time from 2 min to 12 hours. Of course, I re-analyzed all tables and indexes. The explain plan changed from hash join to nested-loop. All

Re: Huge optimization costs with 9.2

of those parameters can be tweaked to your benefit? On Wed, 2003-10-01 at 11:54, Joan Hsieh wrote: Kirti, I had upgraded a database from 8.1.7.4 to 9.2.0.4. Before the upgrade, performance is good. After upgrade, one query run time from 2 min to 12 hours. Of course, I re-analyzed all

standby questions

, no rows returned from select message from v$dataguard_status Thanks in advance! Joan -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Joan Hsieh INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California

Re: IBM AIX 32-Bit

I think 64 bit application have to run on a 64 bit hardware. but can be booted as 32 bit mode. That at least apply to oracle 9i version. Joan -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Joan Hsieh INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538

create standby db confusion

to auxiliary database: ADVDMO7 (not mounted) -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Joan Hsieh INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

Re: create standby db confusion (fixed this one)

how stupid I am, I connected target without @dbname. Now wonder I didn't get it right. But looks like I got some other errors after I run duplicate command. Joan Joan Hsieh wrote: Hi Listers, I followed the Note:118409.1 Creating a standby database using rman. The production database

question on how to retrive document

on UNIX? Thanks and Regards, Joan -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Joan Hsieh INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

Re: question on how to retrive document

Thanks Stephane, I am new to this system, I think it was stored in blobs but I was told it was too slow and need to think a new way to handle this type operation. So bfiles is the right way to go? Joan Quoting Stephane Faroult [EMAIL PROTECTED]: Joan Hsieh wrote: Hi Listers, We

Re: oracle logical standby

Thanks Paul, Paul Baumgartel wrote: My mistake, it's the doc set that came with 9.2.0.2.0: download-west.oracle.com/docs/cd/B10501_01/server.920/a96653/create_ls.htm#1073769 --- Joan Hsieh [EMAIL PROTECTED] wrote: Hi Paul, Do you have url handy on the subject how to setup

Re: oracle logical standby

-- Author: Joan Hsieh 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: 9iR2

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.net -- Author: Joan Hsieh INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538

Re: trace for error number

command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Joan Hsieh INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting

Re: script

://www.orafaq.net -- Author: Joan Hsieh 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: index rebuild

yeh, just found the rebuid_clause syntax have compute statistics option. My-bad. joan Joan Hsieh wrote: Ak, I just know you can collect statistics while creating index not rebuild index. Joan AK wrote: Does index rebuild generates new statistics as well ? How does that can

Re: Another OCP slant...

information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Joan Hsieh INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

Re: nt script

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

Re: nt script

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

nt script

if errorlevel 1 goto run_proc echo 'there is a match' if errorlevel 0 goto end echo 'there is no match' :run_proc d:\start_proc.bat goto end :end -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Joan Hsieh INET: [EMAIL PROTECTED] Fat City Network Services-- 858

Re: nt script

from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Joan Hsieh INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California

Re: nt script

'there is no match' :run_proc d:\start_proc.bat goto end :end -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Joan Hsieh INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list

Re: nt script

PROTECTED]|findstr ORA-03113 if errorlevel 1 goto run_proc echo 'there is a match' if errorlevel 0 goto end echo 'there is no match' :run_proc d:\start_proc.bat goto end :end -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Joan Hsieh INET: [EMAIL

Re: nt script

-03113 if errorlevel 1 goto run_proc echo 'there is a match' if errorlevel 0 goto end echo 'there is no match' :run_proc d:\start_proc.bat goto end :end -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Joan Hsieh INET: [EMAIL PROTECTED] Fat City

Re: nt script

' if errorlevel 0 goto end echo 'there is no match' :run_proc d:\start_proc.bat goto end :end -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Joan Hsieh INET: [EMAIL PROTECTED] Fat City Network Services-- 858

Re: nt script

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

Re: Index question

=i.table_name and c.index_name=i.index_name order by c.index_name, c.column_position / -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Joan Hsieh INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California

Re: asking your opinion

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

Re: asking your opinion

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

asking your opinion

this is a series of databases for each unit or a central database that is shared by all? I am new to this area, I would appreciate any input informantion. Thanks again, Joan -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Joan Hsieh INET: [EMAIL PROTECTED] Fat City Network

odbc privilege

privilege. Did I missed anything? Joan -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Joan Hsieh INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

Re: randomly generate unique key

://www.orafaq.net -- Author: Joan Hsieh 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

randomly generate unique key

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

Re: thanks all/OCP

, 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.net -- Author: Joan Hsieh INET: [EMAIL PROTECTED] Fat

Re: daily clone

CONTROL_FILES can be reused, thus ignoring and overwriting any information they may currently contain. If you omit this clause and any of these control files already exists, Oracle returns an error. So it would seem a valid syntax. Jared Joan Hsieh [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 04

Re: dbshut script - shutdown or shutdown immediate

shutdown Should I modify the script to shutdown immediate so that it kills any connections? Environment is Oracle 8.1.7 /AIX 4.3.3. From: Joan Hsieh [EMAIL PROTECTED] Peter, I modified to shutdown abort, starup then shutdown immediate. Shutdown abort

Re: oracle full table scan

') 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.net -- Author: Joan Hsieh INET

Re: HP-UX 11i/8.1.7.4/login.sql

FAQ: http://www.orafaq.net -- Author: Joan Hsieh 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: How to enable Java on ORACLE 9ir2 database???

ORACLE-L FAQ: http://www.orafaq.net -- Author: Joan Hsieh 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: dbshut script - shutdown or shutdown immediate

, 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.net -- Author: Joan Hsieh INET: [EMAIL PROTECTED] Fat

Re: dbshut script - shutdown or shutdown immediate

is connect internal shutdown Should I modify the script to shutdown immediate so that it kills any connections? Environment is Oracle 8.1.7 /AIX 4.3.3. From: Joan Hsieh [EMAIL PROTECTED] Peter, I modified to shutdown abort, starup then shutdown immediate

Re: daily clone

-- Author: Joan Hsieh 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: Upgrade to AIX 5.2

us know what Oracle support has to say. Cheers! - Kirti -Original Message- From: Joan Hsieh [mailto:[EMAIL PROTECTED] Sent: Thursday, March 27, 2003 7:44 PM To: Multiple recipients of list ORACLE-L Subject: Re: Upgrade to AIX 5.2 Kirti, I did some home work toward our near

Re: utl_smtp error

Chris, Thanks for explantion. I asked the smtp mail admin. He said The relays are running Exim-4.10. Is that help? Joan Chris Berry wrote: From: Joan Hsieh [EMAIL PROTECTED] Chris, you got me, what MTA stand for? Mail Transfer Agent, its the program that uses SMTP to send or recieve

utl_smtp error

case. Does anyone can point me where I should look into it? Thanks always, Joan -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Joan Hsieh INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California

Re: utl_smtp error

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

Re: utl_smtp error

). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Joan Hsieh INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California

Re: Upgrade to AIX 5.2

may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Joan Hsieh INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list

upgrading AIX

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

Re: upgrading AIX

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

nt script

match then mailx -s 'FMRPT P.SCHEDULER IS DOWN' [EMAIL PROTECTED] errfilelog exit -1 fi -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Joan Hsieh INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http

Re: nt script

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.net -- Author: Joan Hsieh INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538

Re: Upgrading from 8.1.5 to 8.1.6

subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Joan Hsieh 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 unauthenticated remote system compromise (

command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Joan Hsieh INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

Re: rootpre.sh

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.net -- Author: Joan

Re: How to create a new oracle database from SVRMGRL??

also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Joan Hsieh INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list

Re: How to create a new oracle database from SVRMGRL??

forgot couple things, add this database to your oratab and added it to your tnsnames.ora Joan Hsieh wrote: Majid, 1. Create ini.ora, link this ini.ora to your oracle_home/dbs 2. startup nomount pfile=$ORACLE_HOME/dbs/initestdb.ora create database TESTDB maxdatafiles 1021

Re: dw report tool question

: http://www.orafaq.net -- Author: Joan Hsieh 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: slowish query causing problems...

and cleared by MailMarshal - For more information please visit www.marshalsoftware.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Joan Hsieh INET: [EMAIL PROTECTED] Fat City Network Services

Re: sql run by users

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.net -- Author: Joan Hsieh INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego

dw report tool question

? Can you give me some feedback as dba standpoint of view, like how report distributed, power user vs end user, performance and security advange or disadvantage, concerns? lots of thanks! Joan -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Joan Hsieh INET: [EMAIL

RE: dw report tool question

Objects is also good for complex situations. How complex do you want to get ? HTH. Regards : Ferenc Mantfeld -Original Message- From: Joan Hsieh [SMTP:[EMAIL PROTECTED]] Sent: Saturday, January 11, 2003 8:44 AM To: Multiple recipients of list ORACLE-L Subject: dw report

Re: 8.1.7 with *what* version of Portal??

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.net -- Author: Joan Hsieh INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego

Re: Oracle and Peoplesoft

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.net -- Author: Joan Hsieh INET: [EMAIL PROTECTED] Fat City Network

slow query help

.MIDDLENAME),UPPER(T27.MIDDLENAME),1) 0 )) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joan Hsieh INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

Re: slow query help

07:58 Please respond to ORACLE-L Joan Hsieh wrote: Hi, This is the query bothered us very much recently. It run at least 15 min. and sometimes crashed the temp tablespace. Do you have any idea how to make it run better. Our

Re: slow query help

: perhaps incorrect firstname/middlename usage, etc). Name: ESPN_Disclaimer.txt ESPN_Disclaimer.txtType: Plain Text (text/plain) Encoding: 7BIT -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joan Hsieh INET: [EMAIL

Re: STATSPACK

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: Joan Hsieh INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California

io error on alert file

() failure, unable to write to file O/S-Error: (OS 5) Access is denied.' KCF: write/open error block=0x8d5c online=0 file=14 D:\ORACLE\ORADATA\ORCL\SISDW.DBF -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joan Hsieh INET: [EMAIL PROTECTED] Fat City Network Services

Re: io error on alert file

not sure this would be an issue butI would switch it temporarily to a user account and then back to LocalSystem to regenerate the security identifier. Also...check the NTFS permissions on the D: drive for who has write access. HTH Jeff Herrick On Thu, 5 Dec 2002, Joan Hsieh wrote

Re: simple ? question

Stephane, you are right, after I talked to the developer. She is totally confused by alias name, dbname, schema name. She is referring database name. joan Joan Hsieh wrote: Stephane, Well spoken- my bad. Our developer threw me this question when I was just leaving from work. (I copied

simple ? question

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

Re: simple ? question

it clear tomorrow. Tomorrow is going to be a long day for me. Too many projects going on at once and we have a very tight schedule. Thanks, Joan Quoting Stephane Faroult [EMAIL PROTECTED]: Joan Hsieh wrote: Hi Listers, I am trying to find a way to know the schema name. Say, if I logged

Re: simple ? question

the schema. I will make it clear tomorrow. I have been very busy lately and we have too many projects going on at once. Please bear with me if I didn't put my effort into it. Many thanks, Joan Stephane Faroult wrote: Joan Hsieh wrote: Hi Listers, I am trying to find a way to know

dabase hang on update statement

POST_STATUS_AP = 'P', IN_PROCESS_FLG = 'N' WHERE PROCESS_INSTANCE = :1 AND PYMNT_ID = :2 AND IN_PROCESS_FLG = 'Y' -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joan Hsieh INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http

utl_file_dir question

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

Re: utl_file_dir question

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

Re: utl_file_dir question

reconnect on logon. Joan Hsieh joan.hsieh To: Multiple recipients of list ORACLE-L @tufts.edu [EMAIL PROTECTED] Sent by: rootcc: Subject

Re: Deleting old archive log files.

: 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: Joan Hsieh INET: [EMAIL PROTECTED] Fat City Network Services

Re: spfile mystery on 9i

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

Re: undocumented initSID.ora parameter

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

Re: CASE under Oracle8i

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

Re: Number of Active Users inside the Database

://www.orafaq.com -- Author: Joan Hsieh 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

  1   2   >