RE: Unix research source ???

') 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: Richard Ji INET

RE: AW: RMAN: I don't trust it

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: Richard Ji INET: [EMAIL PROTECTED] Fat City Network

RE: Oracle License for Training

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

RE: Bind variables

alter session set events '10046 trace name context off' or exec sys.dbms_system.set_ev(sid, serial#, 10046, 0, '') Richard Ji -Original Message- Sent: Tuesday, February 11, 2003 9:29 AM To: Multiple recipients of list ORACLE-L TMTOWTDI ... It's everywhere. All these choices. Why do

RE: AW: RMAN: I don't trust it

between Oracle, DB2, MS SQL, because these databases are in the same playing field. Richard Ji -Original Message- Sent: Tuesday, February 11, 2003 11:24 AM To: Multiple recipients of list ORACLE-L Hi I just posted that as reply to your question about hsql (what is it ?). But you're right here

RE: [new info] Redhat Advanced Server Dev Edition - RAC

FAQ: http://www.orafaq.net -- Author: Richard Ji 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: AW: RMAN: I don't trust it

Quoting Richard Ji [EMAIL PROTECTED]: Well no. Since you are comparing Postgresql with Oracle, why can't I compare it with HSql or any other database for that matter. You can compare anything here. I misunderstood hsql as an Oracle command/script/package (new?, hidden?, secret??) that I have

RE: Count(*) last 30 seconds

Why use count(1) instead of count(*)? They all does the same thing. So does count(primary key). Richard Ji -Original Message- Sent: Tuesday, February 11, 2003 12:09 PM To: Multiple recipients of list ORACLE-L Hi, 1. create unique index or primary key AND update statistics

RE: AW: RMAN: I don't trust it

. And editing init.ora is not how you achive scalability. Some of the tuning solution might come down to change a init parameter but most of them aren't. Richard Ji -Original Message- Sent: Tuesday, February 11, 2003 12:39 PM To: Multiple recipients of list ORACLE-L Quoting Richard Ji [EMAIL

RE: AW: RMAN: I don't trust it

, DB2, MS SQL, because these databases are in the same playing field. Richard Ji -Original Message- Sent: Tuesday, February 11, 2003 11:24 AM To: Multiple recipients of list ORACLE-L Hi I just posted that as reply to your question about hsql (what is it ?). But you're right here

RE: Count(*) last 30 seconds

says that count(1) has better performance than count(*). I do not know why is it so. WIll it make clear some guru on this list? JP On Tuesday 11 February 2003 18:59, you wrote: Why use count(1) instead of count(*)? They all does the same thing. So does count(primary key). Richard Ji

RE: [new info] Redhat Advanced Server Dev Edition - RAC

Hrm, let's see. I use one PC with 1/2gb RAM, 20GB HD $500. VMWare $399. RAC (download from OTN). There you go. :) Richard Ji -Original Message- Sent: Monday, February 10, 2003 9:04 AM To: Multiple recipients of list ORACLE-L This is great! So how can we get a RAC configuration

RE: [new info] Redhat Advanced Server Dev Edition - RAC

Oh forgot the $60 for RHASD. -Original Message- Sent: Monday, February 10, 2003 10:49 AM To: Multiple recipients of list ORACLE-L Hrm, let's see. I use one PC with 1/2gb RAM, 20GB HD $500. VMWare $399. RAC (download from OTN). There you go. :) Richard Ji -Original Message

RE: Bind variables

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

RE: Bind variables

') 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: Richard Ji INET: [EMAIL

RE: RMAN: I don't trust it

Lyndon, You are comparing Apple with Orange here. I can backup my hsql database which is stored in a text file with: cp my_db my_db.backup using OS command only. :) Richard Ji -Original Message- Sent: Monday, February 10, 2003 6:04 PM To: Multiple recipients of list ORACLE-L

[new info] Redhat Advanced Server Dev Edition - RAC

. http://www.redhat.com/software/advancedserver/developer/ Have fun. Richard Ji -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Richard Ji INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California

RE: newbie question

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: Richard Ji INET: [EMAIL PROTECTED

RE: multiple oracle homes

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

RE: RAC on linux?

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: Richard Ji INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http

RE: RAC on linux?

still have 8.0.6 for Solaris Intel. But of course, now I got Linux so I no longer need Solaris for Intel. Sorry Scott. :) Richard Ji -Original Message-From: Nick Wagner [mailto:[EMAIL PROTECTED]]Sent: Friday, February 07, 2003 1:04 PMTo: Multiple recipients of list ORACLE

RE: multiple oracle homes

Maybe, but Ray will decide what's best for him. I think we have offered enough points for him to consider. File permission is a big headache. In my case, I have two totally separate environment since one is 32 bit, on is 64 bit. Regards Richard Ji -Original Message- Sent: Friday

RE: Windows 2000 Cluster on oracle

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

RE: DB character set

://www.orafaq.net -- Author: Richard Ji 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: Help with a truncate command in a procedure

t;; Otherwise, look into DBMS_SQL. Richard Ji -Original Message-From: Smith, Ron L. [mailto:[EMAIL PROTECTED]]Sent: Thursday, February 06, 2003 5:09 PMTo: Multiple recipients of list ORACLE-LSubject: Help with a truncate command in a procedure I am not a coder but I received thi

RE: ORA-1000 - How to trace culprit

v$open_cursor doesn't reflect all cursors counting towards the max open cursor limit. To see truly how many cursor each session is consuming you need to associate v$sesstat with v$session and look at statistics#=3. Richard Ji -Original Message- Sent: Thursday, February 06, 2003 7:39 PM

RE: RH AS2.1 (was: RAC on linux)

OCFS = Oracle Cluster File System. An open source project lead by Wim Coekaerts from Oracle. There is no such thing as raw FS, it's just raw (without any file system). And I just learned about this NBD (Network Block Device) from this list. So that's a third option. Richard Ji -Original

RE: Where is result set maintained?

. Richard Ji -Original Message- Sent: Wednesday, February 05, 2003 12:35 PM To: Multiple recipients of list ORACLE-L When one executes a query, the result set is identified. Fetching the rows in the result set can be done over a period of time. In what form does Oracle maintain

RE: Size of a Long Field

, 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: Richard Ji INET: [EMAIL PROTECTED] Fat City

RE: 7.3.4 upgrade

Wow, never thought I'd see a request like this. :) Nothing wrong to ask though, who knows, someone here might have the time and resource to do it. Let me know the kind soul who will do this. I have a list of my own test to give out. :) Richard Ji -Original Message- Sent: Wednesday

RE: Windows 2000 Cluster on oracle

Oh yeah, the thing I hate most about Windows as a server. Try to do remote administration from any machine regardless of the OS. Richard Ji -Original Message- Sent: Wednesday, February 05, 2003 5:42 PM To: Multiple recipients of list ORACLE-L -Original Message- As much

RE: VMware

not like you are consolidating 100+ database servers, or are you? Richard Ji -Original Message-From: SusanK [mailto:[EMAIL PROTECTED]]Sent: Wednesday, February 05, 2003 6:30 PMTo: Multiple recipients of list ORACLE-LSubject: VMware All, I was wondering if anyone has any

RE: Which rollback segment is currently active?

Title: Which rollback segment is currently active? Check v$rollstat for xact 0. -Original Message-From: Nguyen, David M [mailto:[EMAIL PROTECTED]]Sent: Tuesday, February 04, 2003 6:24 PMTo: Multiple recipients of list ORACLE-LSubject: Which rollback segment is currently

RE: RAC on linux

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

RE: Urgent - how to make SYSTEM tbls smaller ?

: 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: Richard Ji INET: [EMAIL PROTECTED] Fat City Network Services-- 858

RE: books recommendations

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

RE: RH AS2.1 (was: RAC on linux)

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

RE: how to create datafile in shared network drive ??

-- Author: Richard Ji 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: Urgent - how to make SYSTEM tbls smaller ?

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

RE: Borderline OT - Unix for Oracle at home

a 2GB of RAM from curcial for like two hundred bucks. Richard Ji -Original Message-From: Fink, Dan [mailto:[EMAIL PROTECTED]]Sent: Thursday, January 30, 2003 10:14 AMTo: Multiple recipients of list ORACLE-LSubject: Borderline OT - Unix for Oracle at home I am looking to add

RE: why so many log switches?

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: Richard Ji INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538

RE: Borderline OT - Unix for Oracle at home

have, and many others has upgraded Blade with bigger IDE drives and PC memeory. If you check crucial web site, they sell memory for Sun Blade lines. That's why I favor it over Intel/Linux, because you get a Sparc box and can take advantage of cheap Intel components. Richard Ji -Original Message

RE: why so many log switches?

://www.orafaq.net -- Author: Richard Ji 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: how to create datafile in shared network drive ??

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: Richard Ji INET: [EMAIL PROTECTED] Fat

RE: Advice needed on PL/SQL code

, 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: Richard Ji INET: [EMAIL PROTECTED] Fat City

RE: Take Care of your DBAs

Title: RE: "Take Care of your DBAs" Yeah, the good old days. :) We even had tournaments with other dot coms. And foos ball too. -Original Message-From: Koivu, Lisa [mailto:[EMAIL PROTECTED]]Sent: Wednesday, January 29, 2003 4:55 PMTo: Multiple recipients of list

RE: Replication..

') 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: Richard Ji INET: [EMAIL

RE: Advice needed on PL/SQL code

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

RE: TimesTen

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: Richard Ji

Base conversion - WAS: RE: 100% CPU utilization, urgent

Can't you just use to_char function to convert from decimal to hex? select to_char(255,'x') from dual; TO_CHA -- ff Richard Ji -Original Message- Sent: Monday, January 20, 2003 3:55 PM To: Multiple recipients of list ORACLE-L Hussain Ahmed Qadri wrote: Thanks

RE: Undo Segment of 4GB for 1mn 4col update ?

). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Richard Ji 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 question unusual behavior

: Richard Ji 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 an E-Mail

RE: Slient Install

Thanks for point it out. -Original Message-From: Michael Fontana [mailto:[EMAIL PROTECTED]]Sent: Saturday, January 18, 2003 5:59 PMTo: Multiple recipients of list ORACLE-LSubject: re: Slient Install [EMAIL PROTECTED] 01/17/03 09:24AMHey guys- Have any of you all

RE: quest shareplex

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

RE: Problem with Oracle 8.0.6 and Cisco Intrusion Detection Syst

(the IDS manual shows it)! All Oracle variables are set in the profile of this user! If I connected in the Solaris with this user and call the sqlplus, I connect to the database allright!!! Thanks Flávio Reis -Mensagem original- De: Richard Ji [mailto:[EMAIL PROTECTED]] Enviada em: terça-feira

RE: Date data type

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

RE: Database/system Crashing

in advance!Val -Original Message-From: Richard Ji [mailto:[EMAIL PROTECTED]]Sent: Tuesday, January 14, 2003 12:39 AMTo: Multiple recipients of list ORACLE-LSubject: RE: Database/system Crashing Sorry for getting back to you late on this. In our case, the server

RE: re-directing database connection requests

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: Richard Ji INET: [EMAIL PROTECTED] Fat City Network

RE: Problem with Oracle 8.0.6 and Cisco Intrusion Detection Syste

://www.orafaq.net -- Author: Richard Ji 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: Date data type

://www.orafaq.net -- Author: Richard Ji 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: Database/system Crashing

the symptoms of your Sun NFS related crashed and how did you diagnois the problem and what was the solution (if it were that simple) Val -Original Message-From: Richard Ji [mailto:[EMAIL PROTECTED]]Sent: Monday, January 06, 2003 4:19 PMTo: Multiple recipients of list

RE: Oracle CD's

, 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: Richard Ji INET: [EMAIL PROTECTED] Fat City

RE: Some of you may find this useful

') 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: Richard Ji INET: [EMAIL PROTECTED

RE: Protecting schema changes

Title: Protecting schema changes Seperate the object owner from the account which they use to connect. So they would connect through an account that doesn't actually own any objects but just have enough privilege to access them. -Original Message-From: Webber Valerie H

RE: v$sgastat question

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

RE: RE: test this email ad

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

RE: split mirror backups and alter system suspend

doesn't need to be brought down just as if you are doing a hot backup. Richard Ji -Original Message-From: Brooks, Russ [mailto:[EMAIL PROTECTED]]Sent: Thursday, January 09, 2003 5:00 PMTo: Multiple recipients of list ORACLE-LSubject: split mirror backups and alter system suspend

RE: v$sgastat question

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

RE: filesystemio_options question

Don't understand why would he want to set it to none. I don't see any benefit of doing that. By setting it to none, he disables Async IO and Direct IO. A metalink discussion says you would do it to avoid IO related OS bugs. Were there any IO related problems with that system? Maybe someone

RE: invalid procedure/trigger

Check the status column of user_objects for procedures etc. -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]Sent: Wednesday, January 08, 2003 9:59 PMTo: Multiple recipients of list ORACLE-LSubject: invalid procedure/trigger Dear all DBAs, Is there

RE: invalid procedure/trigger

FAQ: http://www.orafaq.net -- Author: Richard Ji 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: Linux and Oracle Cluster File System

on OCFS is also easier than using raw. Richard Ji -Original Message-From: Jos [mailto:[EMAIL PROTECTED]]Sent: Tuesday, January 07, 2003 8:49 AMTo: Multiple recipients of list ORACLE-LSubject: OT: Linux and Oracle Cluster File SystemList,I am a newbie on Linux and Clustering

RE: Unix for oracle dba -- Suggest a book ?

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

RE: Database/system Crashing

Title: RE: Database/system Crashing Val, Sorry I missed the previous messages. Was this a Sun platform? Did the system crash with a CPU panic in /var/adm/messages? We resovled a Sun NFS related crashes a couple of months ago. Richard Ji -Original Message-From: Webber Valerie H

RE: Caching a huge table's data in memory

://www.orafaq.net -- Author: Richard Ji 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: list java classes

select dbms_java.long_name(object_name) from user_objects where object_type like 'JAVA%'; Richard Ji -Original Message- Sent: Friday, January 03, 2003 6:49 AM To: Multiple recipients of list ORACLE-L How do I list java classes that have been loaded into my schema via loadjava? John

RE: Automatic backup on Oracle 9i -- For Jared

lol = laughing out loud lots of luck, lots of love, lots of laughs, little old lady. I will stop here now :) Richard Ji -Original Message- Sent: Thursday, January 02, 2003 11:14 AM To: Multiple recipients of list ORACLE-L I thought lol meant laughing out loud? Tom Mercadante Oracle

RE: Automatic backup on Oracle 9i -- For Jared

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

RE: join after saving rowid Value into a Field - For Design , Dev

Title: Message Not a good idea to store rowid in table M. If you ever move table P to a different tablespace or within the same tablespace, all it's rowid would change. Richard Ji -Original Message-From: VIVEK_SHARMA [mailto:[EMAIL PROTECTED]]Sent: Friday, December 27, 2002

RE: Script to recreate schema

://www.orafaq.net -- Author: Richard Ji 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: Cache on sysdate? --From 9i performance planning manual

procedure successfully completed. That further proves it no longer uses "select sysdate into a from dual;". Richard Ji -Original Message-From: Jamadagni, Rajendra [mailto:[EMAIL PROTECTED]]Sent: Thursday, December 26, 2002 5:14 PMTo: Multiple recipients of list ORACLE-LS

RE: Killed status

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

RE: ORA-07445

media failure such as lose of a disk that has your data file on it. You should read the Oracle Administrator's Guide on what is ARCHIVELOG mode and how to switch to ARCHIVELOG mode. Regards, Richard Ji -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]Sent

RE: Cache on sysdate? --From 9i performance planning manual

: http://www.orafaq.net -- Author: Richard Ji 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: Cache on sysdate? --From 9i performance planning manual

That's because doing dt := sysdate is more optimized, it's still select sysdate into dt from dual but more optimized. select from dual doing 4 db block gets in 8i and 2 db block gets in 9i, but you can tune it to cut it down. Richard Ji -Original Message- Sent: Thursday, December 26

RE: Out of topic -Unx question

, 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: Richard Ji INET: [EMAIL PROTECTED] Fat City

RE: Temp table space

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

RE: Spool file behavior on Solaris

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: Richard Ji INET: [EMAIL PROTECTED] Fat City

RE: read only tablespaces

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

RE: password

It's brute force attack,and relies on a dictionary. Only weak passwords will be cracked, like common words etc. I don't think you need to worry at all if you enforce passwords that must contain numeric besides characters etc. Richard Ji -Original Message- Sent: Tuesday, December 17

RE: DUAL

I remember when you had a weird application problem, one of the first thing Oracle support ask you to check is the dual table to see if it's got more than one row in it. Don't know if they are still doing that. Richard Ji -Original Message- Sent: Tuesday, December 17, 2002 1:26 PM

RE: password

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

RE: DUAL

: Tuesday, December 17, 2002 1:40 PM To: Multiple recipients of list ORACLE-L I remember when you had a weird application problem, one of the first thing Oracle support ask you to check is the dual table to see if it's got more than one row in it. Don't know if they are still doing that. Richard Ji

RE: password

Don't think the db name plays a role in this. But the username does. i.e. user1, user2 share the same password and the hash comes out different. but user1 from two different database share the same password and the hash comes out the same. Richard Ji -Original Message- Sent: Tuesday

RE: Increase size of data files and rollback segments

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: Richard Ji INET: [EMAIL PROTECTED] Fat City Network

RE: Another Java Question

Runtime might not recognize Unix pipe, you need to do it like: Process p = Runtime.getRuntime().exec(new String[] {/bin/sh,-c, tnsping emsd | grep Host}); Richard Ji -Original Message- Sent: Monday, December 09, 2002 11:29 AM To: Multiple recipients of list ORACLE-L Good Morning. I

RE: Are There any way of calling NT OS Commands like print, del e

What commands aren't working for you. Some of the commands are not external executables but rather part of cmd, i.e. internal commands. So you need to invoke cmd with the command. HTH Richard Ji -Original Message-From: Baswannappa, Shiva [mailto:[EMAIL PROTECTED]]Sent

RE: ORA-1653: unable to extend table - Why?

about a month ago, haven't talked with her since. Rachel --- Richard Ji [EMAIL PROTECTED] wrote: Rachel, What I mean to say is when there are a lot of contiguous smaller free extents. Then coalesce will produce a larger free extent so Jay wouldn't have to add a datafile for his table

RE: [Q] ORACLE 9.2 SGA_MAX_size cause SUN server crash ????

You are most likely running into an OS bug, because its a CPU panic. Have your SA run adb on the core file. Look at what thread ffba0ac0 is. Richard Ji -Original Message- Sent: Tuesday, December 03, 2002 4:20 PM To: Multiple recipients of list ORACLE-L We are doing ORACLE 9.2.0.2

RE: instance and database

(pre-9i) or Real Application Cluster (9i). You would need a cluster of minimum two nodes with a shared disk to implement it. It's possible to set up RAC on a single node under Windows or Linux. Regards, Richard Ji -Original Message- Sent: Saturday, November 30, 2002 9:39 AM To: Multiple

<    1   2   3   4   >