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

(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: ADMIN PLZ REPLY - FW: !!Please Read - Oracle-L moving!!

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

RE: Unusable partition index -- working funny

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

RE: chk integrity of a .dmp exp

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: Exporting a partition with transport tablespace

: 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 Services

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

-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-538-5051

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

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

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

-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 - To REMOVE

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 this

RE: Writing a delay in PL/SQL?

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 San Diego

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:

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 lookingfor autility package for throwing output in html format from a query . This

RE: granting SELECT privilege on SYS.X$ TABLES

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

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

RE: (looong) PCTFREE, PCTUSED and ASSM

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

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

RE: Interesting PL/SQL Puzzle

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 not if it's a good

RE: (looong) PCTFREE, PCTUSED and ASSM

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

RE: Interesting PL/SQL Puzzle

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

RE: Interesting PL/SQL Puzzle

of Oracle Corporation. Khedr, Waleed wrote: Below are two dummy procs that are good enough to explain the issue (Jared forgive me for posting this big code). All the code in proc test_plsql1 is inside an IF clause that will not run. [...] proc test_3 ran 30 million times in 9 minutes while test_2

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

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

RE: Interesting PL/SQL Puzzle

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

Interesting PL/SQL Puzzle

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, California

RE: Interesting PL/SQL Puzzle

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

RE: Interesting PL/SQL Puzzle

: 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 seems that execution speed

RE: pattern search

: 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 Services

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 recipients

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

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: nologging for IOT

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 San Diego

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] Date: 2003/11/05 Wed AM 11:34:33 EST

RE: nologging for IOT

(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-538-5051

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

RE: What is a local write wait?

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

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

RE: how to get rid of default

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 City

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: Finding the session causing compile to hang

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

RE: bitmap index not used

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

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

RE: Execution Plan is good but HIGH CPU

). -- 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: 9I RAC corporate standard.

). -- 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: Perm job opening in MA

(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-538-5051 http

RE: Coalescing tablespace

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

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

: 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 - To REMOVE

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

-- 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 mailing list

RE: Cache a table

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 San Diego

RE: Re: stupid dbms_job question

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

RE: Can I concatenate several rows without a procedure?

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 City Network

RE: who writes the OCP tests?

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 San Diego, California

RE: questions regarding nologging

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

RE: Cache a table

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.com San Diego

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

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 add ' (comma) at the begining and end of each line? Ei

(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: 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: Issue:RE: ORA-02270: no matching unique or primary key for th

IMMEDIATE So my question now is does anyone know who you get into a disabled state? Since my creation statements for this primary key, I did put to disable... puzzled. Many Thanks, -Lizz "Khedr, Waleed" [EMAIL PROTECTED] wrote: I ran the same

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: 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: SUPPRESS SQL STATEMENTS

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

RE: SUPPRESS SQL STATEMENTS

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 inside sqlplus. Run it from outside

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

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

RE: Can someone please verify this for me?

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

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

, 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? Waleed -Original Message- Sent

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 sqlis submitted and was lucky enough to request a group of processes that include one of this dead processes, it ends up

RE: USERENV('SESSIONID') on RAC

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

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 San Diego

RE: EMC striping question

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

Sequence and order by

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 http://www.fatcity.com San Diego

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

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

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: Seems odd to me....(bug?)

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

RE: vertical serches on a table - how to

, 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: interesting sql question

-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 - To REMOVE

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

RE: SQL AREA and LIBARARY CACHE size?

: 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 Services

RE: Oracle Compress Option

an 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: equivalent for isdate, isnumeric

(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-538-5051

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 reduce

RE: how to generate unique file names on Windows.

-- 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 mailing list

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

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: weird

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

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

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

RE: Interview Questions for a Unix Solaris System Admin

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

RE: Compressed tables

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

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

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

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

RE: Interesting!

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

Interesting!

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

RE: RE: question about large pool

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

RE: Bulk collect got truncated? RESOLVED

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: skip scan index

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

RE: skip scan index

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 list

RE: skip scan index

, 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: skip scan index

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 services

RE: skip scan index

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

RE: skip scan index

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 San Diego, California

RE: lengthy URL's

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-- 858-538

RE: skip scan index

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 plan, good in certain data distributions and bad in others. But I do not think it's correct

  1   2   3   4   5   6   7   >