RE: How do I check whether a rollback activity is going on

st 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: Khedr, Waleed INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858)

RE: SPFILE Bug [RE: Where is Oracle 9.2 init.ora?]

do things you shouldn't on test boxes just to see how things work > > and > > > to > > > learn. FWIW, I've heard rumors about other people doing similar > things. > > > You've probably even intentionally crashed a DB or pulled the plug > jus

RE: Your password!

help desk or the CSC at 1-800-525-3274 option 2. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Khedr, Waleed INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mai

RE: Re: Help me tuning the log file sync wait event

) 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 spelling of 'ListGuru'

RE: Where is Oracle 9.2 init.ora?

f '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: Where is Oracle 9.2 init.ora?

st 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: Deshpande, Kirti > INET: [EMAIL PROTECTED] > > Fat City Network Se

RE: OT - Oracle U. defends OCP title  

I think this will be very competitive! -Original Message- Sent: Thursday, July 11, 2002 4:31 PM To: Multiple recipients of list ORACLE-L >From when MS started offering ORACLE Certified Professional exams :-) "Khedr, Waleed" <[EMAIL PROTECTED]> wrote: >I wi

RE: killing sessions

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: Khedr, Waleed INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051

RE: OT - Oracle U. defends OCP title

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

RE: Where is Oracle 9.2 init.ora?

#x27;) 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 -- Author: Khedr, Waleed

RE: [Fwd: Please Advise--Your Reaction to Ellison Comment]

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-Mail message to: [EMAIL PROT

RE: [Fwd: Please Advise--Your Reaction to Ellison Comment]

r 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: Khedr, Waleed INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051

RE: slightly OT, permissions unix/oracle puzzler

ttp://www.orafaq.com -- Author: Khedr, Waleed 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 fr

RE: Error on creating index

Are you creating the index on each table using the user id of the table owner? -Original Message-From: Ali TOYGAR [mailto:[EMAIL PROTECTED]]Sent: Monday, July 08, 2002 5:04 PMTo: Multiple recipients of list ORACLE-LSubject: Error on creating index Hi ,     I have a prob

RE: Setting Up EXTPROC

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

RE: C++ classes

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: Khedr, Waleed INET: [EMAIL PROTECTED] Fat City Networ

RE: client-server in 9iR2

f from this mailing list, send 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 informa

RE: dbms_space_admin.tablespace_migrate_to_local

[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-Mail message to: [EMAI

RE: Accessing views across a db link

Title: Accessing views across a db link Try this:   select --+ DRIVING_SITE(rv) * from view_name@remotedb rv where columnA = '...';   - Regards,   Waleed -Original Message-From: Martin, Alan [mailto:[EMAIL PROTECTED]]Sent: Tuesday, July 02, 2002 5:28 PMTo:

RE: Remove numbers from string

-- To REMOVE yourself from this mailing list, send 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 remov

RE: Questionable V$SQLAREA Statistics

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

RE: Asynchronous Procedure Calls

communications. Jared "Khedr, Waleed" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 07/01/2002 12:23 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject:RE: Asynchronous Procedure Calls

RE: Asynchronous Procedure Calls

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

RE: Oracle DBA with TS SCI Clearance Needed in Dayton, Ohio..

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

RE: Example of AND-EQUALS

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: Khedr, Waleed INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (

RE: Oracle DBA with TS SCI Clearance Needed in Dayton, Ohio..

Another certification! -Original Message-From: Jesse W. Asher [mailto:[EMAIL PROTECTED]]Sent: Thursday, June 27, 2002 3:15 PMTo: Multiple recipients of list ORACLE-LSubject: Re: Oracle DBA with TS SCI Clearance Needed in Dayton, Ohio..Very good question!  I've wondered th

RE: Oracle AQ & MQ Series

the use of AQ in this situation.   Hopefully, the product will mature and it can be useable someday.   Lisa -Original Message-From: Khedr, Waleed [mailto:[EMAIL PROTECTED]]Sent: Wednesday, June 19, 2002 6:03 PMTo: Multiple recipients of list ORACLE-LSubject: RE:

RE: the ora certified masters cert, yet again

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

RE: V9.2 & SGA

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

RE: RE: Suggestions on MV Implementation !!!!!!!

t, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from).  You mayalso send the HELP command for other information (like subscribing).--Please s

RE: RE: Suggestions on MV Implementation !!!!!!! (FAST REFRESH RE

t, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from).  You mayalso send the HELP command for other information (like subscribing).--Please s

RE: Suggestions on MV Implementation !!!!!!!

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: Khedr, Waleed INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego

RE: the ora certified masters cert, yet again

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

RE: the ora certified masters cert, yet again

--- To REMOVE yourself from this mailing list, send 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

RE: PERFORMANCE ISSUE

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

RE: order by versus order by desc problem ..... probably a simple

ike subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Khedr, Waleed INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Pu

RE: SEQ#, DUAL and Oracle literacy

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

RE: How to extract data from existing table to csv file.

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: Khedr, Waleed INET: [EMAIL PROTECTED] Fat City Network Services--

RE: Replication question

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

RE: Complex Integrity Checking

had an instructor that said "a test is worth a thousand pages of documentation."  If you have access to the book, give the sample a try.    Regards,   Tony Aponte -Original Message-From: Khedr, Waleed [mailto:[EMAIL PROTECTED]]Sent: Monday, June 10,

RE: Complex Integrity Checking

ansactions to get around mutating table errors.  But it might be just right for someone's need. Regards, Tony Aponte -Original Message- From: Khedr, Waleed [mailto:    Sent: Thursday, June 06, 2002 12:08 PM To: Multiple recipients of list ORACLE-L Subject: RE: Complex

RE: Why is Parallel Query Running after upgrading to 8.1.7.2

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

RE: Complex Integrity Checking

Title: RE: Complex Integrity Checking The problem with this solution is the Autonomous Transactions  will not be able to see any changes done within the current transaction only the committed one. So no way to enforce business logic during the context of the transaction.   This is why I ask

RE: Complex Integrity Checking

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

RE: Complex Integrity Checking

ypical insert&update statements. ==== Attn: Khedr, Waleed [[EMAIL PROTECTED]] - Can you give me an example for your unique function based index, I mean how can you assign an unique number for various intervals. - anyway if this c

RE: Complex Integrity Checking

T 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.orafa

RE: partition tables

http://docs.oracle.com/cd_a87860/doc/server.817/a76965/c09parti.htm#436972 -Original Message-From: BigP [mailto:[EMAIL PROTECTED]]Sent: Thursday, May 30, 2002 8:59 PMTo: Multiple recipients of list ORACLE-LSubject: partition tables Hi All , We are thinking of converting o

RE: Limited SORT_AREA_SIZE

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

RE: partitioning

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.

RE: Do you ever have days where you dont want to think ?

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: Khedr, Waleed INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051

RE: How to drop a datafile from a tablespace quickly

To REMOVE yourself from this mailing list, send 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

RE: How to translate PL/SQL to C

ACT 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

RE: TEMP tablespace growing abnormally -Sort Area

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

RE: Trigger or ????

Title: Trigger or Do you mind if I ask why do you want to reset the sequence?   Regards,   Waleed -Original Message-From: Burton, Laura L. [mailto:[EMAIL PROTECTED]]Sent: Tuesday, May 14, 2002 10:58 AMTo: Multiple recipients of list ORACLE-LSubject: Trigger or I

RE: Migratory birds

Look at the doc: Oracle8i Parallel Server Administration, Deployment, and PerformanceChapter 2.   Waleed -Original Message-From: Gogala, Mladen [mailto:[EMAIL PROTECTED]]Sent: Monday, May 13, 2002 4:24 PMTo: Multiple recipients of list ORACLE-LSubject: Migratory birds My

RE: formating 10046 (level 12) trace file

OTECTED] 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-Mail message to: [EMAIL PRO

RE: too low optimizer_index_cost_adj causing bizarre index choice

o, California-- Public Internet access / Mailing Lists -------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, inc

RE: pl/sql is INTERPRETED?

Public Internet access / Mailing Lists > > > > > > To REMOVE yourself from this mailing list, send an E-Mail message > > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in

RE: Reverse Key Index Performance

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). -- Please see the official ORACLE-

RE: pl/sql is INTERPRETED?

-- > > > To REMOVE yourself from this mailing list, send 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 lis

RE: pl/sql is INTERPRETED?

ibing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Khedr, Waleed 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 return a ref cursor to Java client

SUB 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: Khedr, Waleed INET: [EMAIL PROTECTED] Fat City Network Services--

RE: what is wrong with this export?

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

RE: unix df -k .. not giving extact space at point in time

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: Khedr, Waleed INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 53

RE: Problem in Dropping a MV : ORA-07445: exception encountered:

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: Khedr, Waleed INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego,

RE: pl/sql is INTERPRETED?

48 PM Waleed, have you actually tried this? Or anyone else for that matter? Jared "Khedr, Waleed" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 04/29/2002 04:23 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>

RE: pl/sql is INTERPRETED?

OTECTED] (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). -- Please see the official ORACLE-L FAQ:

RE: Oracle Financials Sys Admin. Needed in South Carolina

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

RE: CPU Pegged at 100%

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 -- Author: Khedr, Waleed INET: [EMAIL

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

subscribing). > > > = > Gaja Krishna Vaidyanatha > Director, Storage Management Products, > Quest Software, Inc. > Co-author - Oracle Performance Tuning 101 > http://www.osborne.com/database_erp/0072131454/0072131454.shtml > > __

RE: index status misleading?

E-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: Khedr, Waleed INET: [EMAIL PROTECTED] Fat City Network Services-- (8

RE: How come I don't get postings

Title: How come I don't get postings I can not see you on the list! -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]Sent: Thursday, April 25, 2002 8:43 PMTo: Multiple recipients of list ORACLE-LSubject: How come I don't get postings Guys, Please s

RE: No Rows Deadlock and PCTFREE, INITRANS on 8.1.7.2

for a couple of years in the current 8.0.4 database without any obvious locking errors. Cherie Machler "Khedr, Waleed" To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> S

RE: No Rows Deadlock and PCTFREE, INITRANS on 8.1.7.2

rrors. Cherie Machler "Khedr, Waleed" To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Subject: RE: No Rows Deadlock and PCTFREE, INITRANS on 8.1.7.2

RE: No Rows Deadlock and PCTFREE, INITRANS on 8.1.7.2

LE-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: Khedr, Waleed INET: [EMAIL PROTECTED] Fat City Network Services

RE: No Rows Deadlock and PCTFREE, INITRANS on 8.1.7.2

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: Khedr, Waleed INET: [EMA

RE: Number of File systems to use.

5000 & 8000 line. I would be keenly interested to know as we have many TB here of EMC and all of it is software striped. What product line are you referring to? When did they start? Thanks, Bill --- "Khedr, Waleed" <[EMAIL PROTECTED]> wrote: > Now they have hardware stripin

RE: Number of File systems to use.

re of EMC and all of it is software striped. What product line are you referring to? When did they start? Thanks, Bill --- "Khedr, Waleed" <[EMAIL PROTECTED]> wrote: > Now they have hardware striping. > > Regards, > > Waleed > > -Original Message-

RE: Number of File systems to use.

----- To REMOVE yourself from this mailing list, send 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 t

RE: Currval and buffer gets

d 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: Khedr, Waleed INET: [EMAIL PROTECTED] Fat City Network Services-- (

RE: column level grants

7;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 -- Author

RE: Currval and buffer gets

Title: RE: Currval and buffer gets Thanks (this is why I'm surprised that Oracle did not improve dual and the way they implemented pl/sql functions. SYSDATE is done using a C interface now in PL/SQL) Just to confirm your results I got these times:    run time using view x_$dual in centiseco

RE: Currval and buffer gets

first one was running as I started the second one) no problems. Now I ran as sys and changed it to x$dual because I got errors (table or view not found) when I ran as system and used x_$dual so I don't know if that changed the test --- "Khedr, Waleed" <[EMAIL PROTECTED]> wrote:

RE: Currval and buffer gets

test but in a worse efficiency case. shows only a 2-3 percent gain .. Anjo. "Khedr, Waleed" wrote: > Can you guys tell me about all the overhead to resolve the view definition > to reach the magical X$dual table? > > Waleed > > -Original Message- > Sent: T

RE: Currval and buffer gets

age 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: Khedr, Waleed INET: [EMAIL PROTECT

RE: Currval and buffer gets

t 2 simultaneoussessions and then 2) second test 3 simultaneoussessions running.RegardsLyubomir Petrov--- "Khedr, Waleed" <[EMAIL PROTECTED]> wrote:> Never mess up with Oracle's memory:>> It seems that x$dual is not designed for concurrent> access. When I try to&g

RE: Currval and buffer gets

rcent improvent. But beaware: the test suite only accesses x$dual and not other tables so the impact is large and the application is written in the most efficient way. Running the same test but in a worse efficiency case. shows only a 2-3 percent gain .. Anjo. "Khedr, Waleed" wrote

RE: Currval and buffer gets

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). > > > > > > = >

RE: Currval and buffer gets

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 inform

RE: Currval and buffer gets

is mailing list, send 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

RE: Currval and buffer gets

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). > > > > > > = > > Gaja Krish

RE: set current_schema & PLS-00201

-- Public Internet access / Mailing Lists -------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY,

RE: Parallel load direct path

I will try to duplicate this. What is the Oracle version? -Original Message- To: Multiple recipients of list ORACLE-L Sent: 4/23/02 12:25 PM Absolutely sure. In my test script I drop and recreate this table before the load. --- "Khedr, Waleed" <[EMAIL PROTECTED]> wrot

RE: Parallel load direct path

No you are not mistaken. Are you sure the table had no records before loading? Look at the log file. -Original Message- To: Khedr, Waleed; 'Multiple recipients of list ORACLE-L ' Sent: 4/23/02 9:24 AM I have done a test and only ran one session, which has faile (ran out of s

RE: column level security

stuck with this: if userA needs to see cols 1,3,5 of tableA and userB needs to see cols 1,2,3,4 of tableA. We're still stuck with doing private views? we dont need row level security so a VPD is kinda overkill, right? thanks, joe -- Please see the official ORACLE-L FAQ: http:/

RE: Parallel load direct path

thing. Does SQL*Loader in direct more commit/saves the data it already put into a table if the proces fails? Gene --- "Khedr, Waleed" <[EMAIL PROTECTED]> wrote: > sqlldr has rows option: rows -- Number of rows in > conventional path bind > array or between direct path data s

RE: Currval and buffer gets

na Vaidyanatha > Director, Storage Management Products, > Quest Software, Inc. > Co-author - Oracle Performance Tuning 101 > http://www.osborne.com/database_erp/0072131454/0072131454.shtml > > __ > Do You Yahoo!? > Yahoo! Games - pla

RE: Parallel load direct path

ssage 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: Khedr, Waleed INET: [EMAIL PROTECTED]

RE: What is truth?

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: Khedr, Waleed INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858)

RE: Currval and buffer gets

://www.orafaq.com -- Author: Yechiel Adar 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

<    1   2   3   4   5   6   7   >