RE: How to find the last execution time of a Procedure.

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

RE: ADMIN PLZ REPLY - FW: !!Please Read - Oracle-L moving!!

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

RE: Unusable partition index -- working funny

ote 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://w

RE: chk integrity of a .dmp exp

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

RE: large pl/sql table sucking up all memory on a server

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

RE: Exporting a partition with transport tablespace

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

RE: any single serial session will never get more than 5% of pga

ces-- 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 message > to: [EMAIL PRO

RE: any single serial session will never get more than 5% of pga

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

RE: ora-4030 pga memory allocation running wild

This is scary, I'm planning to upgrade 9.2.0.4 from 9.2.0.2.   I don't know how removing pga_aggegrate_target will help reducing memory!!   Does the program have any memory tables, etc?   Did you monitor the PGA size from the Oracle side using v$sesstat?   A sql by itself can't consume thi

RE: Writing a delay in PL/SQL?

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

RE: Using miss-spelled hint changes explain plan ...

Title: Using miss-spelled hint changes explain plan ... Did you see any changes in the Execution plan?   Waleed -Original Message-From: Jamadagni, Rajendra [mailto:[EMAIL PROTECTED]Sent: Thursday, November 20, 2003 10:20 AMTo: Multiple recipients of list ORACLE-LSubject: Usi

RE: html output

 sqlplus -M "html on" -Original Message-From: AK [mailto:[EMAIL PROTECTED]Sent: Wednesday, November 19, 2003 6:50 PMTo: Multiple recipients of list ORACLE-LSubject: html output I am looking for a utility package for throwing output in html format from a query . This sho

RE: granting SELECT privilege on SYS.X$ TABLES

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

RE: (looong) PCTFREE, PCTUSED and ASSM

AQ: http://www.orafaq.net > > -- > > Author: Tanel Poder > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > > San Diego, California -- Mailing list and web hosting services > > ---

RE: (looong) PCTFREE, PCTUSED and ASSM

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

RE: (looong) PCTFREE, PCTUSED and ASSM

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

RE: (looong) PCTFREE, PCTUSED and ASSM

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

RE: Interesting PL/SQL Puzzle

t was easy for anybody to figure it out from here. The idea is to add value instead of waiting to have the final words! Regards, Waleed -Original Message- Sent: Monday, November 10, 2003 11:34 PM To: Multiple recipients of list ORACLE-L Khedr, Waleed wrote: > The question was

RE: Interesting PL/SQL Puzzle (found the cause)

t > very pleased the way native compilation works. > > > Does anybody have a clue why? > > I tried to include the proc in a package and pin it but there was no > difference. > > > Thanks > > Wal

RE: Interesting PL/SQL Puzzle

coding --> bad NC results. HTH, -- Vladimir Begun The statements and opinions expressed here are my own and do not necessarily represent those of Oracle Corporation. Khedr, Waleed wrote: > Below are two dummy procs that are good enough to explain the issue (Jared > forgive me for postin

RE: Interesting PL/SQL Puzzle

there was no difference. Thanks Waleed -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Khedr, Waleed INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting service

RE: Interesting PL/SQL Puzzle

> very pleased the way native compilation works. > > > Does anybody have a clue why? > > I tried to include the proc in a package and pin it but there was no > difference. > > > Thanks > > Waleed > > -- > Ple

RE: Interesting PL/SQL Puzzle

Sent: Saturday, November 08, 2003 3:29 PM To: Multiple recipients of list ORACLE-L Let me give you a carystic advice: run your app with 10046, lev 8 and see what are you waiting on and how long the waits are. On 2003.11.08 13:09, "Khedr, Waleed" wrote: > I have a weird problem. It se

RE: Interesting PL/SQL Puzzle

enerated by the native compilation, I was not very pleased the way native compilation works. Does anybody have a clue why? I tried to include the proc in a package and pin it but there was no difference. Thanks Waleed -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author

Interesting PL/SQL Puzzle

? I tried to include the proc in a package and pin it but there was no difference. Thanks Waleed -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Khedr, Waleed INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego,

RE: Getting Number of Rows in CTAS across DBLink

Use pl/sql block with execute immediate 'create table < > as ...' Number of rows should be in sql%rowcount (immediately after execute immediate).   Waleed -Original Message-From: Arup Nanda [mailto:[EMAIL PROTECTED]Sent: Friday, November 07, 2003 3:34 PMTo: Multiple recipien

RE: pattern search

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

RE: long time to kill a session

Did you try orakill? -Original Message-From: Mauricio "Vilez [mailto:[EMAIL PROTECTED]Sent: Thursday, November 06, 2003 4:14 PMTo: Multiple recipients of list ORACLE-LSubject: long time to kill a session Hi, the limit of connections on my Dedicated Serveris 400. The Serv

RE: IMP using the same DMP file

Title: IMP using the same DMP file I do not see a problem. The file can be read only. -Original Message-From: Whittle Jerome Contr NCI [mailto:[EMAIL PROTECTED]Sent: Wednesday, November 05, 2003 4:50 PMTo: Multiple recipients of list ORACLE-LSubject: IMP using the same DMP f

RE: nologging for IOT

: 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). __ Do you Yahoo!? Protect your identity with Yahoo! Mail AddressGuard http://antispam.yahoo.com/wh

RE: RE: External Tables question

select * from (Select rownum m_id, table_name from dba_tables) -Original Message- Sent: Wednesday, November 05, 2003 12:10 PM To: Multiple recipients of list ORACLE-L cant you use rownum with a 'merge'? > > From: "Khedr, Waleed" <[EMAIL PROTECTED]> &g

RE: nologging for IOT

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

RE: External Tables question

Title: External Tables question What about rownum?   Waleed -Original Message-From: Jamadagni, Rajendra [mailto:[EMAIL PROTECTED]Sent: Wednesday, November 05, 2003 11:25 AMTo: Multiple recipients of list ORACLE-LSubject: External Tables question I am trying to use external

RE: Finding overlapping time periods - suggestions please

Title: Finding overlapping time periods - suggestions please Easy, this should do it:   Create a time dimensions--drop table test_date_dim;create table test_date_dim (time_dt date);--

RE: What is a local write wait?

stGuru') 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: Khed

RE: Finding the session causing compile to hang

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

RE: dual

Do you think it will work if it has no rows ?   Waleed -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]Sent: Thursday, October 30, 2003 1:44 PMTo: Multiple recipients of list ORACLE-LSubject: Re: dualYou may find this interesting. Looks like a 'where

RE: how to get rid of default

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

RE: 10046 trace data question

Title: 10046 trace data question I believe it's from v$timer   This view lists the elapsed time in hundredths of seconds. Time is measured since the beginning of the epoch, which is operating system specific, and wraps around to 0 again whenever the value overflows four bytes (roughly 497 da

RE: bitmap index not used

] (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: http://www.o

RE: Perm job opening in MA

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 information (like subscribing). -- Please

RE: 9I RAC corporate standard.

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

RE: Execution Plan is good but HIGH CPU

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

RE: Coalescing tablespace

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

RE: index full scan over an index fast full scan in an analytic f

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 i

RE: index full scan over an index fast full scan in an analytic f

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

RE: Re: stupid dbms_job question

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

RE: Cache a table

-- Mailing list and web hosting services - 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:

RE: questions regarding nologging

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 fr

RE: who writes the OCP tests?

ing 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: Khedr, Waleed INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.co

RE: Can I concatenate several rows without a procedure?

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

RE: Cache a table

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

RE: What is difference between "SYSDATE" and "SYSDATE@!" ??

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

RE: How to add ' (comma) at the begining and end of each line? Ei

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

RE: bitmap conversion on a index that is not bitmapped ???

It seems that you have tow predicates in the where clause that can take advantage of two different indexes. Also you have "AND" condition that Oracle tries to take advantage of using "BITMAP AND" operation.   Since you like the performance of the plan that uses the BITMAP conversion, I can

RE: re Rebuilding Indexes in Oracle Apps -- was RE: RE: Separate

Not again :) At least we have to justify our pay :)   Waleed    Any views or opinions presented in this email are solely those of the author and do not necessarily represent those of the company -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]Sent: Wednesday

RE: Issue:RE: ORA-02270: no matching unique or primary key for th

  Many Thanks, -Lizz "Khedr, Waleed" <[EMAIL PROTECTED]> wrote: I ran the same ddl in 9.2 and had no problems. Check for tables having the same names in other schemas   Waleed -Original Message-From: laura pena [ma

RE: ORA-02270: no matching unique or primary key for this column-

I ran the same ddl in 9.2 and had no problems. Check for tables having the same names in other schemas   Waleed -Original Message-From: laura pena [mailto:[EMAIL PROTECTED]Sent: Wednesday, October 15, 2003 11:19 AMTo: Multiple recipients of list ORACLE-LSubject: ORA-02270:

RE: SUPPRESS SQL STATEMENTS

nsive lines, but I should be able to use sqlplus formatting statements to give the correct results. I did include message off (from a previous email), but the results remain the same sofar. --- "Khedr, Waleed" <[EMAIL PROTECTED]> wrote: > Don't run the script while you&#

RE: SUPPRESS SQL STATEMENTS

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

RE: USERENV('SESSIONID') on RAC

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

Some bug in 9.2

Title: Re: Avoiding full table scan This problem started really to be annoying. Suddenly some PQ processes die and the system is never able to bring them back. If some sql is submitted and was lucky enough to request a group of processes that include one of this dead processes, it ends up ru

RE: Redos gone crazy--a job for audit?

E-L Well, that was an excellent idea. But sadly, that's not it. (We actually don't use hot backups, but I checked just in case someone mucked with it. No dice.) Thanks. Barb --- "Khedr, Waleed" <[EMAIL PROTECTED]> wrote: > Do you have the database in backup mode?

RE: Can someone please verify this for me?

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

RE: Redos gone crazy--a job for audit?

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

RE: How to copy recursive files in Windows? like unix cp -r

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

Sequence and order by

3 order by dummy; select test_seq.nextval * ERROR at line 1: ORA-02287: sequence number not allowed here Waleed -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Khedr, Waleed INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 h

RE: EMC striping question

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

RE: Seems odd to me....(bug?)

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

Deterministic Functions: am I missing something?

) = 3; F2(1,3) -- 3 select * from test_det; C1 - 02-OCT-03 02-OCT-03 It did not save an execution even in the same sql call! Oracle 9.2.0.2 Solaris 2.8 Regards, Waleed -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Khedr, Waleed INET: [EMAIL

RE: Physical I/O and databases other than oracle

Title: RE: Physical I/O and databases other than oracle So to look good, I should unplug all the CPU boards except one or two to end up with CPU limitation :)   Regards,   Waleed -Original Message-From: David Wagoner [mailto:[EMAIL PROTECTED]Sent: Thursday, October 02, 2003 12

RE: Sql query : select max timestamp value from table

select ip, max(timestamp) from table group by ip; -Original Message-From: Johan Muller [mailto:[EMAIL PROTECTED]Sent: Thursday, October 02, 2003 10:45 AMTo: Multiple recipients of list ORACLE-LSubject: Sql query : select max timestamp value from table I have multiple times

RE: vertical serches on a table - how to

ee.com/clinic/ibuy/campaign.asp?cid=3963 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Susan Tay INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services -

RE: interesting sql question

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

RE: equivalent for isdate, isnumeric

I was just explaining Deterministic independently of the function. -Original Message- Sent: Friday, September 26, 2003 1:50 AM To: Multiple recipients of list ORACLE-L Khedr, Waleed wrote: > Boolean is A PL/SQL data type won't work in sql. > Deterministic is nice to have to

RE: equivalent for isdate, isnumeric

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 remo

RE: Oracle Compress Option

opinion is an art ! -Original Message-From: Khedr, Waleed [mailto:[EMAIL PROTECTED]Sent: Thursday, September 25, 2003 9:35 AMTo: Multiple recipients of list ORACLE-LSubject: RE: Oracle Compress Option Disk is not cheap if you pay for high availability

RE: "SQL AREA" and "LIBARARY CACHE" size?

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

RE: Oracle Compress Option

Title: RE: Oracle Compress Option Disk is not cheap if you pay for high availability configuration. I compress historical data on daily basis and was able to save 70 percent of the disk space. Imagine the amount of savings for five TB.   Two major issues:   1) Oracle says updates will be sl

RE: how to generate unique file names on Windows.

orafaq.net -- Author: Khedr, Waleed 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 ma

RE: possible to have a primary key with a bitmap indx?

7;) 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: Khedr, Waleed INE

RE: weird

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

RE: Anyone have a copy of DUL ??

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

RE: parallel processes

2 producers & 2 consumers -Original Message-From: AK [mailto:[EMAIL PROTECTED]Sent: Wednesday, July 23, 2003 8:44 PMTo: Multiple recipients of list ORACLE-LSubject: parallel processes while rebuilding indexes i gave parrallel 2 . But I see there are four ora_p00 process

RE: Interview Questions for a Unix Solaris System Admin

://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in

RE: Compressed tables

ssage- From: Khedr, Waleed [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 09, 2003 2:25 PM To: Multiple recipients of list ORACLE-L Subject: RE: Compressed tables I'm using it for six months now without problems. I was able to save more than 70% of the used disk space in big data

RE: Compressed tables

I'm using it for six months now without problems. I was able to save more than 70% of the used disk space in big data warehouse project. Attached is a pdf paper that might be helpful: Regards, Waleed Any views or opinions presented in this email are solely those of the author and do not neces

RE: WARNING: Re: [suse-oracle] AIO trouble

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

RE: Interesting!

1(10)); end; Regards, Waleed -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Khedr, Waleed INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California

Interesting!

o2'); end; function c1 ( p1 in number) return number as begin return(p1 * 2); end; begin dbms_output.put_line('hello1'); test_test2; dbms_output.put_line( c1(10)); end; Regards, Waleed -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Khedr, Waleed INE

RE: RE: question about large pool

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

RE: Bulk collect got truncated? RESOLVED

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

RE: skip scan index

nyway, you are right. That, in turn, implies that oracle indexes are not classic B*Tree structures as I was lead to believe but are spiked with an unknown liquor. Thanks for helping me clarify this. On 2003.05.28 18:29 "Khedr, Waleed" wrote: > It's like any other execution pla

RE: lengthy URL's

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

RE: skip scan index

(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: ht

RE: skip scan index

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

RE: skip scan index

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

RE: skip scan index

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

RE: skip scan index

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

RE: skip scan index

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

  1   2   3   4   5   6   7   >