Unix mailing List

Hi all, Can someone recommend good unix mailing list by the way how to check the existence of a file ? My logic : if (findThisFile(/tmp/myfile.txt) == 0) echo the file is exists else echo file not found endif what is the unix function

rollback for temp tablespace

Hi lists, Can anybody clarify this: Do the sort/idx rebuild etc.,(tasks that use temp tablespace), use rollback segments? I need to rebuild indexes of 20 Gig to a new tablespace. Do I need to verify the RBS free space for this.? Thnx and Regards, Srinivas -- Please see the official

difference between temporary tablespaces

Title: difference between temporary tablespaces Hi! I'm getting kinda confused concerning the two types of temporary tablespaces: create tablespace NAME temporary... is the old way of creating a temporary tablespace for sorting purposes. It only allows for sort segments to be

Re: rollback for temp tablespace

They do use some rollback but not the volumes you'd typically need to worry about. The rollback space is for mods to the data dictionary as your segments are created. hth connor --- Tatireddy, Shrinivas (MED, Keane) [EMAIL PROTECTED] wrote: Hi lists, Can anybody clarify this: Do

RE: space used by pinned objects

Hi, You can select the information from V$DB_OBJECT_CACHE. Best Regards, K Gopalakrishnan Bangalore, INDIA -Original Message- Sent: Tuesday, December 04, 2001 8:55 PM To: Multiple recipients of list ORACLE-L I've pinned some procs that were being loaded very frequently. How can I

RE: Unix mailing List

we can check the existence of the file by using fopen command and in read mode. if(fopen(temp.rpt,r) == null return(0) - file not found. -Original Message- Sent: Wednesday, December 05, 2001 1:40 PM To: Multiple recipients of list ORACLE-L Hi all, Can someone recommend good unix

RE: BMC Patrol DBXray / CA Unicenter

Lisa, Have you seen or heard of NORAD (Surveillance Module)? Currently you can monitor: Database: O/S: Oracle NT/2000 Sybase HP/UX SQLServer Solaris AIX LINUX All from the same client console.

RE: Unix mailing List

I think what you want to do is if [ -d $FILENAME ] then echo the file exists else echo file not found fi $FILENAME is a variable holding the name of the file you are looking for. You can assign a value to it by doing: FILENAME='/tmp/myfile.txt' before the if statement. Regards, Kev. my

Re: difference between temporary tablespaces

The new way (ie tempfile) must be locally managed. It is used for ANY temporary segment (including sorting). They have other advantages as well - less redo generated, can be used to open a standby for query, trivially quick to allocate etc. hth connor --- Daiminger, Helmut [EMAIL PROTECTED]

RE: rollback for temp tablespace

By the way Does this process (rebuilding of indexes) generate redo? Srinivas -Original Message- Sent: Wednesday, December 05, 2001 6:30 AM To: Multiple recipients of list ORACLE-L They do use some rollback but not the volumes you'd typically need to worry about. The rollback space

RE: Unix mailing List

Apologies for the last replythe [ -d $FILENAME ] should be [ -a $FILENAME ]. Hope that helps, Cheers, Kev. my computer beat me at chess but i won when it came to kick boxing. __ Kevin Thomas Technical Analyst Deregulation Services Calanais Ltd. (2nd Floor East - Weirs

Update query

Hallo, How can I update the field PRICE in table B with prices from field NEW_PRICE in table A. with condition LANGUAGE_CODE IS = 412 (that condition should be taken from table B) Please give me an example of a sql statementö. Thanks in advance Roland -- Please see the official ORACLE-L FAQ:

RE: Update query

SELECT a.sql_basics ,b.chapter3 FROM bookshelf ,b.book WHERE b.chapter3 = 'basic sql constructs' AND a.sql_basics = 'book that should be read before posting requests like this'; ;o) -Original Message- Sent: 05 December 2001 09:55 To: Multiple recipients of list

Re: Embedding perl in Oracle

On Tue, Dec 04, 2001 at 08:26:52PM -0500, Thomas A.Lowery wrote: My office mate (cc'd) also set this up to demo the process. I'm considering testing out the possibility of using an Oracle view on top of function that calls a extproc_perl to a MySQL database. I imagine that'll be at least an

RE: Update query

And yea, I got the syntax wrong ;o)) Don't point it out to methe bad day continues... -Original Message- Sent: 05 December 2001 11:25 To: '[EMAIL PROTECTED]' Importance: High SELECT a.sql_basics ,b.chapter3 FROM bookshelf ,b.book WHERE b.chapter3 = 'basic sql

Update query

Hallo, How can I update the field PRICE in table B with prices from field NEW_PRICE in table A. with condition LANGUAGE_CODE IS = 412 (that condition should be taken from table B) Please give me an example of a sql statementö. Thanks in advance Roland -- Please see the official ORACLE-L

Re: contradictory information in v$session_wait?

You are right. SECONDS_IN_WAIT is not defined for known short waits. However, it is only reset it when known waits happens. Regards. --- Paul Baumgartel [EMAIL PROTECTED] wrote: I had a process showing what I think is contradictory information in v$session_wait. The event was direct

RE: BMC Patrol DBXray / CA Unicenter

I second that, too long to list the problems I had w/ CA Unicenter, worthless expensive product. CA touts their product to top management, then you get the call to implement. Just my $.02, since you asked :) Gene [EMAIL PROTECTED] 12/04/01 08:35PM CA Unicenter sucks, CA support sucks. CA

Problem with DYNAMIC SQL

Hello As I found in proc docs the following statement should work properly: EXEC SQL EXECUTE IMMEDIATE CREATE TABLE dyn1 (col1 VARCHAR2(4)); But when I want to compile a PROC prog. that has the above stmt in a function I recevive the following compile error: sample1.cc: In function

RE: background processes

Title: RE: background processes ora_s000_ora8 ora_s001_ora8 ora_s002_ora8 ORacle MTS (multithreaded server) server processes ora_p000_ora8 ora_p001_ora8 Oracle parallel query processes Matt Adams - GE Appliances - [EMAIL PROTECTED] Contrary to popular opinion, Unix is user

checking free space on hard disk drive from RDBMS (Oracle 8i)

Hi, I would like to know if thwere is a way to check free space on a certain hard disk drive from stored proecedure on Windows NT and Oracle 8i. UTL_FILE does not seem to be able to do this for me. TIA, Tamas Szecsy -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author:

RE: Virus Warning

Yeah, unfortunately our mail server was down for the count when your message arrived. Well Bill Gates didn't get to be the richest man on the planet by spending time worrying about security. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday,

RE: BMC Patrol DBXray / CA Unicenter

HI Lisa, We don't use Xray or CA unicenter but we use Patrol from BMC with UNIX,NT and the Oracle Availability Suite. Installation is straight forward and support is great. Does allot of proactive monitoring. The psl programming language is easy for customization. It comes packaged

RE: buffer busy wait latch free ( cache buffer chain )

One way I can say there are bunch of patches which has to be applied on 8.1.7.2,We had nightmares out when we migrated to 8.1.7.2,There are lot of work arounds which you will have to get from oracle for library cache,cache buffer chains,ora 7445 errors etc etc etc.. We had an issue like if

RE: buffer busy wait latch free ( cache buffer chain )

I may have missed it, but has anyone mentioned a particular OS here? Or, are these generic bugs across OS's. I don't have access to Metalink so I can't lookup the various bugs mentioned. Regards, Larry G. Elkins [EMAIL PROTECTED] 214.954.1781 -Original Message- From: [EMAIL

RE: Update query

Roland, How about update B set PRICE = (select NEW_PRICE from A where join condition betn a and b) where language_code = 412 Shailesh -Original Message- Sent: Wednesday, December 05, 2001 6:35 AM To: Multiple recipients of list ORACLE-L Hallo, How can I update the field

Re:Problem with DYNAMIC SQL

Ehsan, I don't think so. In the case you've listed the better way would be to do: EXEC SQL CREATE TABLE dyn1 (col1 VARCHAR2(4)); The use of EXECUTE IMMEDIATE is more suited to statements that are being dynamically created on the fly. This one is not. Dick Goulet Pro*C Evangelist

RE: space used by pinned objects

You can try following query for ver 7.3.4 select substr(c.owner,1,5)OWNER,substr(c.name,1,30)name, round(c.sharable_mem / 1024) K, c.loads, c.executions, c.kept from v$db_object_cache c, sys.obj$ o, sys.user$ u where c.executions 1000 and kept = 'NO' and

RE: buffer busy wait latch free ( cache buffer chain )

I was mentioning this on Sun 2.6 os From: Larry Elkins [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: buffer busy wait latch free ( cache buffer chain ) Date: Wed, 05 Dec 2001 06:30:23 -0800 I may have missed it, but has

Known problems or comments about ERwin, QDesigner or ERStudio????

I could be at OpenWorld, but n...I get the pleasure of staying home and evaluating the three design products to see which one we should purchase. Anway, I just found what appears to be a flaw in QDesigner, in that, it reverse engineered a database schema successfully, but it will not

Re: Rollbacks - ORA-1555

Christine, Howdy neighbor. I've almost eliminated 1555's. It took some trial and error, but what we ended up with in one of our bigger db's is: 30 rollback segments OPTIMAL (NULL) minextents 20 initial = next = 4MB 6GB total space We have between 400 and 500 interactive users, several

RE: Unix mailing List

Sinardy - Make sure you are using Korn shell. Make the first line #! /bin/ksh. A good reference is the O'Reilly book UNIX in a Nutshell. It is cheap and a thorough reference (not a tutorial). For example, on the -a and -D options that Kevin mentions, there are about a page of different file

RE: Rollbacks - ORA-1555

Hello All, I changed the rollback segments, and here are the results. I'm now at 20 segments, 1 meg each, minextents 20, optimal 20. Here are the results after running the process within the application with auto-commits turned off... data requests - 2969079 CLASS

RE: buffer busy wait latch free ( cache buffer chain )

Re: 8.1.7.2 problems We are also on Solaris 2.6. We've been testing 8.1.7.2 for the past several weeks, and have not seen these kinds of problems. This is a very critical upgrade for us. Are others seeing major problems with 8.1.7.2 on Solaris?? Thanks for any responses. Barb

RE: BMC Patrol DBXray / CA Unicenter

I appreciate everyone sharing their experiences. My question on this topic is what tools are appropriate for what environments? Some tools seem more extensive (and expensive) and therefore appropriate to sites with many Oracle instances. I am currently responsible for 5 production instances all

Re: Unix mailing List

This is untested and from memory, but: if [test -f filename] then echo found else echo help, are you an idiot fi --Scott --- Sinard Xing [EMAIL PROTECTED] wrote: Hi all, Can someone recommend good unix mailing list by the way how to check the existence of a file ? My logic :

RE: Unix mailing List

Couple clarifications: 1. -a : file exists (any type of file) -d : file is a directory -f : file is a regular file (like Scott Said) 2. The test is not neccessary vFILE_NAME='The file in question' if [ -f ${vFILE_NAME} ] then echo File is there. You do not have to spend hours

Column Title

Hello DBA-Gurus, Executing the same query on 2 databases, but getting different output- the column title. In all the databases its limited to the value of the row except in one database we've. All the databases are of 8.1.7.2 running on IBM/unix server. Database- A -- select

RE: BMC Patrol DBXray / CA Unicenter

Lisa I didn't get the opportunity to work with BMC, but was somewhat involved in the selection process for enterprise monitoring tools a couple of jobs ago. BMC Patrol ( or whatever it may be called now ) was very impressive. I had lots of questions, and everything I asked, it was already

Re: Embedding perl in Oracle

Tim, That sounds rather interesting, as the impression that MySQL users sometimes give is that they're perfectly happy with MySQL and don't have any need to move to Oracle or anything else. Any particular features of Oracle that the owners feel they need, or is it a move to satisfy

Create View From Another Schema

Question? I try to create a view from another schema and get the error: ORA-00942: table or view does not exist It is a very simple thing don't know why doesn't work??? Create or replace view test_v as select col1,col2,col3 from schemaA.tableA Any Idea realy appreciate. Thanks Hamid Alavi

RE: Create View From Another Schema

You need to have select priveleges on the schema which want to create the views from. ReedK -Original Message- Sent: Wednesday, December 05, 2001 10:40 AM To: Multiple recipients of list ORACLE-L Question? I try to create a view from another schema and get the error: ORA-00942: table

RV: Create View From Another Schema

Hi, You try: As SchemaA do: grant select on tableA to schemaX; As SchemaX do: Create or replace view test_v as select col1,col2,col3 from schemaA.tableA; - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, December 05, 2001 2:40 PM

Re: Column Title

Binay, Try typing the command 'CLEAR COLUMNS' before doing the select. It may be something in login.sql or glogin.sql that is creating the difference. Jared PS. You seem to be hung up on 'The Captain and Tenille'. Therapy is available.

RE: BMC Patrol DBXray / CA Unicenter

We looked at Quest extensively, and even began rolling it out. I/Watch fell apart at the seams when we tried to scale... Jim __ Jim Hawkins Oracle Database Administrator Data Management Center of Expertise Pharmacia Corporation 800 North

ORACLE 9i Courses

Hi, I am looking for good courses on Oracle 9i Database and Oracle 9iAS. Does anybody knows some links or resources??. It could be in Video, CD or something like that. Not interested in online courses (unless they are free :-) ). Thanks for all Gonzalo Romero -- Please see the

Schema Owner

May be odd question, but I realy need to do this, I want to revoke the privilege of the schema owner. I mean give only select priv to the schema owner. Thanks Hamid Alavi Office 818 737-0526 Cell818 402-1987 The information contained in this message and any attachments is intended only

RE: Create View From Another Schema

Thanks, but I have define a role and give select from tableA to the role then assign the role to user but it wasn't work till directly assign select on tableA to schema. BTW thanks for reply -Original Message- Sent: Wednesday, December 05, 2001 10:26 AM To: Multiple recipients of list

Partitioning Questions

Hi, The system is Oracle 9i on Sun 2.8 1) Which partitioning is better to use HASH or RANGE. Do there is some overhead for oracle to calculate the hash number (hash partitioning) to find the particular partition. We need to partition 2 tables of sizes 175G and 162G

RE: Rollbacks - ORA-1555

Title: RE: BMC Patrol DBXray / CA Unicenter Christine, Here is a white paper I recently found while chasing down another link on this site. I wish I had read something like this 4 years ago, when I was a developer first trying to figure out what to do about snapshot too old problems. I

RE: Rollbacks - ORA-1555

Hi Christine, these results are slightly differnt from the earlier ones you .. as the latest ones had 8,48409 fewer data requests. I believe you are worried about the wraps.. if yes .. dont be , cuz at some point or the other the rbs will wrap. the definition of wrapping is controversial and

Parallel Server

Is anyone using Oracle Parallel Server? It that the best solution for a standby server? Any idea what it would cost? Are there any classes covering implementation? Ron Smith -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Smith, Ron L. INET: [EMAIL PROTECTED]

Re: difference between temporary tablespaces

Hi Helmut, here is the breakdown Tablespaces 1 DMT (dictionary managed) a Normal b temporary(only temp objects) 2. LMT temporary tblspces (True temp tblspces) syntax: create temporary tablespace The behaviour of this is similar to the /tmp of unix as temp files gets

RE: Schema Owner

Someone mentioned you could do it with the fine grained access control stuff... -Original Message- Sent: Wednesday, December 05, 2001 3:05 PM To: Multiple recipients of list ORACLE-L Hamid - this was discussed recently on this list and as I recall you can't revoke the schema owner. Can

RE: Problem with DYNAMIC SQL

So I'm poking around the web looking for product reviews for data modeling tools, when I come across this article about Computer Associates and in particular a quote from a certain DBA... - Dick Goulet, a database administrator at a U.S.-based maker of

RE: Has anyone heard of Mirror Accessible?

We just had someone from Oracle in yesterday who said a) it will be a 9.0.2 feature b) 9.0.2 won't be out until June, 2002 Unfortunately they are still holding fixed to forcing me to come in on Christmas weekend to upgrade to 8.1.7. For no good reason. Forcing me to cancel the plans I've had

query rewrite

Hi, Does anyone know how can I create a materialized view for query rewrite on the following query: select distinct parttable from emp where exists (select * from addr where ((addr.zip=24811) and emp.timestamp='11/23/2001') and emp.id=addr.id and emp.sn=addr.sn) order by emp.parttable; I tried

Re: Embedding perl in Oracle

On Wed, Dec 05, 2001 at 09:30:55AM -0800, [EMAIL PROTECTED] wrote: Tim, That sounds rather interesting, as the impression that MySQL users sometimes give is that they're perfectly happy with MySQL and don't have any need to move to Oracle or anything else. Any particular features of

Re: buffer busy wait latch free ( cache buffer chain )

Hi, it seems we have similar situation today. Our production db hangs suddenly. We couldn't even login into the db. Before aborting oracle we found a process like svrmgrl @/tmp/sql. The body includes single command 'alter system flush shared_pool'. It seems it was generated by db agent

RE: BMC Patrol DBXray / CA Unicenter

We looked at Quest extensively, and even began rolling it out. I/Watch fell apart at the seams when we tried to scale... Jim __ Jim Hawkins Oracle Database Administrator Data Management Center of Expertise Pharmacia Corporation 800 North

RE: buffer busy wait latch free ( cache buffer chain )

Ed - It sounds like someone at your site fixed a previous SGA problem. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, December 05, 2001 3:25 PM To: Multiple recipients of list ORACLE-L Hi, it seems we have similar situation today. Our

package implementation?

Hi Is there any impact on old data If I implement dbms_obfuscatio_toolkit after some data insert? Thanks Seema _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp -- Please see the official ORACLE-L FAQ:

RE: Partitioning Questions

Harvinder... What is the access patterns of the queries that will be using these tables... Knowing how the data will be accessed is am important factor in determining how to set this stuff up... i.e. If your data is historical in nature and the queries typically access data for via time

OT : Listers met at OOW

Dear all, I had promised a few people on the list that I would send an update about Listers meeting at OOW, so here goes! A few of us got together at a Chevy's restaurant near Moscone for a chance to say hello and put a face to a name. This included Steve 'Guru' Adams (yes - *the* Steve A all

Re: RE: Has anyone heard of Mirror Accessible?

Ain't being a DBA glamorous??? Me, I'm just in it because I heard that DBA's get all the chicks :) Believe me, I feel your pain. I have more Oracle 7.3.4 databases here to upgrade than I can say without embarassment. That's what I get for being the new hire. :) A fellow DBA, Scott Lockhart

[Q] ORACLE text string search case problem???

We have third party application, while doing text string search, user need type in upper case otherwise nothing display. The vendor said it is ORACLE problem, because MS Access do NOT have this problem. Because we does NOT have application source code, does their has way We can setup parameter

RE: Embedding perl in Oracle

How well does MySQL scale. How does it handle parallel direct inserts? Does it do it better than the Oracle OCI interface. We've got an Oracle experiment running now for our channel archive data, real time data from sensors monitoring the accelerator. We haven't switched off the old

RE: RE: Has anyone heard of Mirror Accessible?

Same here! I have an HP-UX upgrade and an Oracle upgrade over the holidays. It's been on the queue for more than a year. bye-bye Oracle 7.3.4 Woo Hoo __   _ =  -o)/ /  (_)__  __   __ | Ed Sherman    |  /\\ /__/ /

RE: RE: Has anyone heard of Mirror Accessible?

You guys will get no sympathy from me. We have an Apps 11.5 implementation going live on Jan 1. In Brazil no less. And of course the PHBs want this to interface with our local 10.7 installation. BTW, Anybody speak Porteguese? Ron Thomas Hypercom, Inc [EMAIL PROTECTED]

RE: Parallel Server

What version and platform??? I've had some exposure to OPS in 7.3 on HP a couple years ago and it was nightmare... I've heard it is much better now though... Anyone using the 9i stuff yet??? I'm sure there are people with more recent experience and their input more up to date than mine...

RE: buffer busy wait latch free ( cache buffer chain )

Metalink: advance search on the keywords, click only Bug Database for Sources, and take your pick from the list. [EMAIL PROTECTED] 12/05/01 08:05PM Your statement there are several bugs relating to waiting for latch-free on cache-buffer-chains, and the possibility of the instance hanging.

Oracle DB Connection Problem

8.1.7 on Dell W2000 server. When I try to login via sqlplus I get this: ORA-01034 Oracle not available ORA-27101 shared memory realm doesn't exist Then I get: Login: Password: And this error: ORA-12560 TNS: protocol adapter error. Any ideas as to what the problem is? Thanks,

RE: RE: Has anyone heard of Mirror Accessible?

You know, such is the life of a DBA. I did have a Christmas downtime planned. Then they shut the plant. I would rather have the downtime. Part of the job is making sure that databases are available when the users want them. That means that maintenance windows can be tight and at times that

RE: BMC Patrol DBXray / CA Unicenter

I have evaluated I/Watch and it was pretty good. Especially with Spotlight. I have actually seen Spotlight help me quickly identify a problem which I am not sure I could have found so easily with out the visual picture. I had both tools for about 3 months but could not get anyone to agree to

RE: Unix mailing List

Thank you. -Original Message- Kevin Sent: Wednesday, 5 December 2001 6:30 PM To: Multiple recipients of list ORACLE-L Apologies for the last replythe [ -d $FILENAME ] should be [ -a $FILENAME ]. Hope that helps, Cheers, Kev. my computer beat me at chess but i won when it came to

RE: Has anyone heard of Mirror Accessible?

If I were you I would find a conflict during your testing against the new version. If confronted with a problem, few managers will want to press on and put the production system at risk. Some folks would say this is passive aggression. I'd remind them it is preferable to outright aggression.

Re: buffer busy wait latch free ( cache buffer chain )

I could find bug#1467575 which relates to Parallel DML hanging on executing an ALTER SYSTEM FLUSH SHARED_POOL. However, as per the README of the 8.1.7.2 PatchSet, this *is* fixed in 8.1.7.2 Did you log a TAR with Oracle Support for this situation where you could only fix it by restarting the

Re: Schema Owner

You can't revoke the privilege from the schema owner but you CAN keep them from doing ddl and dml by using database triggers. now the catch is this: the trigger HAS to be owned by someone other than the schema owner AND the schema owner can't have the alter any trigger privilege(either direct

statspack interpretations

Hi lists, I have a request to tune the sql statements that are generated in the statspack report. I have a puff document on statspack. But it is of only 7 pages and explains only how to install and run statspack. Does anybody have any document / link for statspack report intepretations. if

RE: rollback for temp tablespace

Definitely. Unless you say NOLOGGING or UNRECOVERABLE (depending on the versions). But data dictionary changes are always logged irrespective of logging mode. Best Regards, K Gopalakrishnan -Original Message- Shrinivas (MED, Keane) Sent: Wednesday, December 05, 2001 2:30 AM To:

Re: Re:Problem with DYNAMIC SQL

Hi, Assign CREATE TABLE statement to a variable and then issue EXEC SQL EXECUTE IMMEDIATE Variable This should work HTH Bye Make a FREE long distance call from your PC! http://www.eboom.com/free/ - Original Message - To: Multiple recipients of

Parsing count way to high

Hi all, Just wondering if any one can help me here, I have an online server that has a number of services within it, just lots of Objects. But the response time is not what it should and after tracing it I got this: OVERALL TOTALS FOR ALL NON-RECURSIVE STATEMENTS call count cpu

Re: Off Topic: Australian Visa

Another site for employment opportunities is www.jobnet.com.au. From there you can find most of the agencies that work in IT employment. You might be best checking out some of there websites and maybe contacting some of those directly about visa requirements etc. Jobs aren't so prolific over

Re: Re:Problem with DYNAMIC SQL

Hi, --- Nikunj Gupta [EMAIL PROTECTED] wrote: Hi, Assign CREATE TABLE statement to a variable and then issue EXEC SQL EXECUTE IMMEDIATE Variable This should work I have tried it before sending the mail, and I tried it after receiving your mail but I did not work and it had the same

RE: Re:Problem with DYNAMIC SQL

Hi, Do u have the privleges granted directly to you ??? Best Regards, Ganesh R Tel : +971 (4) 397 3337 Ext 420 Fax : +971 (4) 397 6262 HP : +971 (50) 7456019 -Original Message- Sent: Thursday, December 06, 2001 10:40 AM To: Multiple recipients of list ORACLE-L Hi, ---

Re: Parsing count way to high

Ian, what type of optimizer do you use? Regards, Ed - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, December 06, 2001 8:50 AM Hi all, Just wondering if any one can help me here, I have an online server that has a number of