date:20030819

Re: Using "noatime" mount-flag to improve performance ?

2003-08-19 Thread Craig I. Hagan

uness you've external reasons for caring about access time updates to your
datafiles, I'd recommend turning it off so that you don't have the extra writes
going to disk.

> 
> 
> I've recently come across references to setting
> the "noatime" attribute to improve performance 
> of a Database server because Unix does not then
> need to update the "last-access time" for each file.
> 
> e.g. the Oracle for Linux tuning paper at
> http://otn.oracle.com/oramag/webcolumns/2002/techarticles/scalzo_linux01.html
> also mentions this.
> 
> Has anyone used this on Unix [Solaris/AIX/HPUX/Tru64]
> servers ?
> 
> Hemant K Chitale
> http://hkchital.tripod.com
> 

-- 



  .-... . -.-. .-. . --- . ... ... .- --. .

Craig I. Hagan
   hagan(at)cih.com

"Capitalism is the uneven distribution of wealth, and
 socialism the even distribution of poverty."

Winston S. Churchill

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Craig I. Hagan
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail 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).

RE: 32 or 64? -- on Solaris 8 ?

2003-08-19 Thread Hemant K Chitale



Has anyone tests / benchmarks showing a multiuser
OLTP Oracle database performs better with 
64-bit 8.1.7 on 64-bit Solaris8 then 
32-bit 8.1.7 on 64-bit Solaris8 ?

ie, the default Solaris8 install is 64-bit.
If the DB is less than 100GB with db_block_buffers
of less than 1GB and db_block_size of 4K [sorry !]
and there are 10 to 20 concurrent users, 
would 32-bit 8.1.7 or 64-bit 8.1.7 be better ?

What about databases with 1.5GB db_block_buffers,
8K db_block_size and 50 to 100 concurrent users ?

Hemant

--- Niall Litchfield <[EMAIL PROTECTED]> wrote:

> To sell more sun kit? To add to a resume? 
> 
> As for bugs, I'll bet my hat there are more bugs on any newer,
> limited
> circulation release than there are on wide circulation popular
> releases.
> 
> 
> Niall
> 
> > -Original Message-
> > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On 
> > Behalf Of Daniel Fink
> > Sent: 18 August 2003 17:14
> > To: Multiple recipients of list ORACLE-L
> > Subject: 32 or 64?
> > 
> > 
> > From a technical and business perspective, what are the 
> > reasons to migrate from 32-bit to 64-bit Oracle? Are there 
> > known bugs/problems with one version that are not present in 
> > the other?
> > 
> > Daniel Fink
> > 
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: Niall Litchfield
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting
> services
> -
> To REMOVE yourself from this mailing list, send an E-Mail 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).
> 



Hemant K Chitale
http://hkchital.tripod.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Hemant K Chitale
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail 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).

Failing to launch dbassist: Oracle 8.1.7 on AIX5L

2003-08-19 Thread Zhou, Tapiwanashe

Hi gurus
I am having a strange problem after successfully installing Oracle 817 on
AIX 5.2
If I try to start dbassist I get the following error

Xlib: connection to 172.20.4.11:0:0 refused by server
Xlib: Invalid MT-MAGIC-COOKIE-1 key etc tec

The screen just hangs until I run Ctrl-D

What could be the problem


regards
Tapiwa

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Zhou, Tapiwanashe
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail 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).

Using "noatime" mount-flag to improve performance ?

2003-08-19 Thread Hemant K Chitale



I've recently come across references to setting
the "noatime" attribute to improve performance 
of a Database server because Unix does not then
need to update the "last-access time" for each file.

e.g. the Oracle for Linux tuning paper at
http://otn.oracle.com/oramag/webcolumns/2002/techarticles/scalzo_linux01.html
also mentions this.

Has anyone used this on Unix [Solaris/AIX/HPUX/Tru64]
servers ?

Hemant K Chitale
http://hkchital.tripod.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Hemant K Chitale
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail 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).

RE: Oracle DBA interview for Oracle INDIA Ltd

2003-08-19 Thread Naveen Nahata

Hi Raju,
I think it is unethical for anyone to reply to points 1-4.

As far as point no. 5 is concerned, even though I don't work with Oracle
India, I can get the resume forwarded, simply because if forwarded through
internal sources the resume doesn't get trashed, but you won't get any special
favors simply because it has got forwarded through internal
sources.
But you said you are going to face the interview, then why do you need to
get the resume forwarded? Your resume has already been reviewed,
right?
Regards
Naveen

-Original Message-From: Ora DBA
[mailto:[EMAIL PROTECTED]Sent: Tuesday, August 19, 2003 11:59
PMTo: Multiple recipients of list ORACLE-LSubject:
Oracle DBA interview for Oracle INDIA Ltd
Dear Friends, I am raju from India , going to face Oracle India
Interview. This mail is intended for indian Oracle DBAs. I wanna know the
following things. 1. How will be the interview ? What are the
process for interview ? 2. Any previous question papers , if there is an
written test ? 3. What are the TOPICs mainly to focus about ? 4. Any
information to help me in this regard. 5. Any one who are with Oracle
India at present , can help me as an internal referral to forward my resume ,
etc. Thank you very much, Regards Raju.

Do you Yahoo!?Yahoo!
SiteBuilder - Free, easy-to-use web site design
softwareDISCLAIMER:This message (including attachment if any) is confidential and may be privileged. Before opening attachments please check them for viruses and defects. MindTree Consulting Private Limited (MindTree) will not be responsible for any viruses or defects or any forwarded attachments emanating either from within MindTree or outside. If you have received this message by mistake please notify the sender by return e-mail and delete this message from your system. Any unauthorized use or dissemination of this message in whole or in part is strictly prohibited. Please note that e-mails are susceptible to change and MindTree shall not be liable for any improper, untimely or incomplete transmission.

RE: cursor_sharing in 8.1.7.4 - good or bad

2003-08-19 Thread Cary Millsap

And don't count too heavily upon 9i's "bind value peek" capability.
Here's a simple test that Jonathan Lewis conjured up last year:

PREPARATION. Create data for "select c1, c2 from t1 where c1 = :bind1",
where different bind1 values could have different paths if we used
literals.

1. flush shared pool
   set bind1 = 5
   execute query, notice an indexed access (optimal plan for bind1=5)
   set bind1 = 70
   execute query, notice that kernel still uses the index

2. flush shared pool
   set bind1 = 70
   execute query, notice a table scan (optimal plan for bind1=70)
   set bind1 = 5
   execute query, notice that kernel still uses the table scan

The moral: the kernel only peeks once per session.


Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com

Upcoming events:
- Hotsos Clinic 101 in Sydney
- Hotsos Symposium 2004, March 7-10 Dallas
- Visit www.hotsos.com for schedule details...


-Original Message-
Jesse, Rich
Sent: Tuesday, August 19, 2003 3:09 PM
To: Multiple recipients of list ORACLE-L

True, but using binds isn't always an option, like when running a 3rd
party
product.  I also could not justify weeks of recoding homegrown software
for
the relatively minor gains we would have using binds.  And scalability
(or
lack thereof) didn't seem to be argument enough.

We're using CS=F on 8.1.7.4 on HP/UX 11.0.  We haven't yet had a single
issue attributable to it in the 7 months we've been at the .4 release.
There were some nasty issues with 8.1.7.2 (ORA-600 and silently
returning
WRONG data), but like I said, .4 seems to have cleaned that up.  YMMV.

Remember that under 8i, you may see some performance DROP by using
binds.
The case that comes to mind is if you're using histograms with ANALYZE
or
DBMS_STATS.  Under 8i, the optimizer can no longer "see" the values and
therefore can't use the histograms.  Under 9i (R2 only?), you can tell
the
optimizer to peek at the bind variables' values in order to make use of
histograms.  We plan on doing this when we get to 9i in order to use a
very
low cardinality index, where less than 0.0001% of the rows is what we
need
to fetch, but 8i won't use the index because of the cardinality.

Your best bet, of course, is to test!  HTH!  GL!  :)


Rich

Rich Jesse   System/Database Administrator
[EMAIL PROTECTED]  Quad/Tech Inc, Sussex, WI USA



-Original Message-
Sent: Tuesday, August 19, 2003 2:49 PM
To: Multiple recipients of list ORACLE-L


Hi,
  No. I recommend that you do not change cursor_sharing if you are doing
it
just to get rid of 4031. There could be serious problems. ora-600 etc.
Maybe
Oracle has fixed everything in latest 817 but I suggest not to take that
chance.
  For 4031 you can do the following : pin pl/sql sql preferably at
startup,
use bind variables and periodically check for sql not using bind
variables.
Goodluck. 


"Fedock, John (KAM.RHQ)" <[EMAIL PROTECTED]> wrote:
 
Does anyone have any experience using cursor_sharing in 8.1.7.4?I
feel I
need to use it due to literal SQL statements being used.  We have had
misc
4031 errors off and on and I feel this is my last hope.  I have a very
busy
OPFS server (HP-UX).  
 
I did try using cursor_sharing in 8.1.7.2, and I remember incorrect
sorting
and other unexpected results happening.
 
Thanks for any input.
 
 
John
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jesse, Rich
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail 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 see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Cary Millsap
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail 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).

Re: tuning question when you have a 3GL application

2003-08-19 Thread Chip

Just wondering if the Software Engineering Team can be taught how to run 
their own 10046 trace (capturing the painful "part" of their 
application).  The Hotsos Sparky tool (free) can help the 10046 tracing, 
including the automation of sending the trace file to the team for analysis.


The Hotsos profiler is ideal for analyzing the trace file.

The free trace analysis tools: tkprof and Oracle Trace Analyzer have 
some shortcomings.

Have Fun :)

[EMAIL PROTECTED] wrote:

its the way the taem is organized. all communication goes through the product managers to the client. No direct access for the technical people.

i dont make the rules. I just have to live with them. Ive been onsite with clients before. its easier.

So Im looking for things to make my life easier... :( 
luckily yesterday was a problem with the COM objects and had nothing to do with the database. 
 

From: Jared Still <[EMAIL PROTECTED]>
Date: 2003/08/19 Tue AM 10:34:24 EDT
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Subject: Re: tuning question when you have a 3GL application
Your customer tells you that the database is slow, but won't 
allow you the opportunity to correct it if that is the case?

As Cary says, your problem is not a technical one.  It sounds as
if they don't *want* you to have the opportunity to prove that
the database is not the problem.
Jared

On Mon, 2003-08-18 at 12:24, [EMAIL PROTECTED] wrote:
   

We have two teams. Database team and a Software engineering team. The software engineering team wrote an application in .net.

We periodically get 'the application is slow' from them. I have not gotten the ok to run statspack in production. 

Are there any canned scripts I can run to monitor the v$views or latch contention etc... It may not be the database, but I need some metrics. 

--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: <[EMAIL PROTECTED]
 INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail 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 see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Jared Still
 INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail 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 see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Chip
 INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail 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).

RE: Re: Row level security and latch waits

2003-08-19 Thread Madhavan Amruthur

Hi Raj,
Vadim is right and if RLS is implemented without application context then
there would be hard parses especially if there are literals in the policy
function . We have a client warehouse with about 500 users and 300 tables
and FGAC has been working very well and we do not see latch waits.

The policy function has to be devoid of literals as vadim indicated. We
ste up the policy function based on the application context and in order
to look at the where clause generated, an evetn can be set.

Hope this helps.

Thanks
Madhavan
http://www.dpapps.com

On Tue, 19 Aug 2003 12:24:26 -0800, "Gorbounov,Vadim"
<[EMAIL PROTECTED]> said:
> Jack, 
> You are right, app context is treated as a bind variable, but someone may
> decide not to use it in RLS policy function. Example (maybe a little
> unreal
> but valid):
> 
> CREATE OR REPLACE PACKAGE BODY Oe_security AS
> 
> FUNCTION Custnum_sec (D1 VARCHAR2, D2 VARCHAR2) RETURN VARCHAR2
> IS
> D_predicate VARCHAR2 (2000)
> BEGIN
>  D_predicate = 'create_date > '''||to_char(sysdate-1)||;
>  RETURN D_predicate;
> END Custnum_sec;
> END Oe_security;
> 
> Hence hard parses.
> 
> Vadim
-- 
Madhavan Amruthur
DecisionPoint Applications

-- 
http://www.fastmail.fm - mmm... Fastmail...
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Madhavan Amruthur
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail 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).

Re: Oracle Utilities book?

2003-08-19 Thread Jonathan Gennick

Tuesday, August 19, 2003, 4:49:32 PM, Rich Holland wrote:
RH> Has anyone read this yet?

RH> http://tinyurl.com/kis0

RH> It looks like a useful reference, but I thought I'd get other opinions
RH> before I purchase it

Interesting. The full title is "Oracle Utilities: Using
Hidden Programs Import/Export, SQL*Loader...". I never
thought of utilities such as import and export as being
hidden, but perhaps to a GUI user that'd be the case. I have
no idea how good the content is. I might just order myself a
copy to find out.

Best regards,

Jonathan Gennick --- Brighten the corner where you are
http://Gennick.com * 906.387.1698 * mailto:[EMAIL PROTECTED]

Join the Oracle-article list and receive one
article on Oracle technologies per month by 
email. To join, visit http://four.pairlist.net/mailman/listinfo/oracle-article, 
or send email to [EMAIL PROTECTED] and 
include the word "subscribe" in either the subject or body.


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jonathan Gennick
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail 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).

Re: RE: Urgent! Is it safe to apply patch Windows2000-KB823980?

2003-08-19 Thread Prem Khanna J

Luis,

Sorry for the delayed reply.
we installed the same patch on all our 8i/9i instances on win2k.
we have not faced any problem so far.

Regards,
Jp.

>Has anybody applied Windows2000-KB823980-x86-ENU on their boxes hosting the Database?
>We are running 9i  9.0.1.1.1 on an Windows 2000 advanced server and our network group 
>is patching all the 
systems. Is there anything that I need to watch for?
>We are also runing 9iAS ver 1.0.2.2.0 on Windows 200 advanced server, anything to be 
>aware here?
>Any information is very welcomed.
>TIA
>Luis Octavio de Urioste



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Prem Khanna J
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail 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).

RE:

2003-08-19 Thread Jared . Still


Personally, I got tired of explaining it to newbies.







"Eberhard, Jeff" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
 08/19/2003 03:54 PM
 Please respond to ORACLE-L

        
        To:        Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
        cc:        
        Subject:        RE:


whatever happened to "are you an idiot?"

-Original Message-
Sent: Tuesday, August 19, 2003 4:50 PM
To: Multiple recipients of list ORACLE-L



sorry, no help available. 




                 Benny Pei <[EMAIL PROTECTED]> 
Sent by: [EMAIL PROTECTED] 


 08/19/2003 03:24 PM 
 Please respond to ORACLE-L 


        
        To:        Multiple recipients of list ORACLE-L
<[EMAIL PROTECTED]> 
        cc:         
        Subject:        



help

__
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software
http://sitebuilder.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Benny Pei
 INET: [EMAIL PROTECTED]

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail 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 see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Eberhard, Jeff
  INET: [EMAIL PROTECTED]

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail 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).

Re: select strings with '_' in it

2003-08-19 Thread Scott Lamb

Tanel Poder wrote:

Hi!
 
I think translate is overkill here.
 
Use:
 
select col from tab where col like 'v\_lan' escape '\';
vs

> Select col1 from table
> where translate(col1,'_','#') like 'v#lan%'
> /
Not only is the escape method cleaner, it's much more efficient. Unless 
you have an index on translate(col1,'_','#') (unlikely), that query will 
always result in a sequential scan. Ugh.

--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Scott Lamb
 INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail 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).

Re: select strings with '_' in it

2003-08-19 Thread Tanel Poder

Title: RE: select strings with '_' in it



Hi!
 
I think translate is overkill here.
 
Use:
 
select col from tab where col like 'v\_lan' escape 
'\';
 
Tanel.

  - Original Message - 
  From: 
  Martin, 
  Alan (Contractor) (DLIS) 
  To: Multiple recipients of list ORACLE-L 
  
  Sent: Wednesday, August 20, 2003 1:39 
  AM
  Subject: RE: select strings with '_' in 
  it
  
  Remember, '_' matches any 1 character, so change what you're 
  looking for. Try: Select col1 
  from table where translate(col1,'_','#') like 
  'v#lan%' / 
  Regards, Alan Martin Defense Logistics Info Service Battle Creek, 
  MI 
  -Original Message- From: Benny 
  Pei [mailto:[EMAIL PROTECTED]] 
  Sent: Tuesday, August 19, 2003 6:19 PM 
  To: Multiple recipients of list ORACLE-L Subject: select strings with '_' in it 
  Hello, 
  I have this data 'v_lan' and also 'vclan'. I would 
  like to select 'v_lan' but not 'vclan'. Is it possible 
  to do that? 
  I tried set escape on select col1 from table where col1 like 'v\_lan' / 
  but it doesn't work. 
  thank you, 
  benny 
  __ Do 
  you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web 
  site design software http://sitebuilder.yahoo.com -- 
  Please see the official ORACLE-L FAQ: http://www.orafaq.net 
  -- Author: Benny Pei   INET: [EMAIL PROTECTED] 
  Fat City Network Services    -- 858-538-5051 http://www.fatcity.com 
  San Diego, 
  California    -- Mailing list and web 
  hosting services - 
  To REMOVE yourself from this mailing list, send an E-Mail 
  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).

RE: cursor_sharing in 8.1.7.4 - good or bad

2003-08-19 Thread raju pa

Point noted. Excellent posts from both you and Walt. I guess that is what the forum is for. To present one's experience without trashing someone else's point of view.
Since you have first hand experience on the latest I guess John should listen to both of you first. Thanks
"Jesse, Rich" <[EMAIL PROTECTED]> wrote:

True, but using binds isn't always an option, like when running a 3rd partyproduct. I also could not justify weeks of recoding homegrown software forthe relatively minor gains we would have using binds. And scalability (orlack thereof) didn't seem to be argument enough.We're using CS=F on 8.1.7.4 on HP/UX 11.0. We haven't yet had a singleissue attributable to it in the 7 months we've been at the .4 release.There were some nasty issues with 8.1.7.2 (ORA-600 and silently returningWRONG data), but like I said, .4 seems to have cleaned that up. YMMV.Remember that under 8i, you may see some performance DROP by using binds.The case that comes to mind is if you're using histograms with ANALYZE orDBMS_STATS. Under 8i, the optimizer can no longer "see" the values andtherefore can't use the histograms. Under 9i (R2 only?), you can tell
theoptimizer to peek at the bind variables' values in order to make use ofhistograms. We plan on doing this when we get to 9i in order to use a verylow cardinality index, where less than 0.0001% of the rows is what we needto fetch, but 8i won't use the index because of the cardinality.Your best bet, of course, is to test! HTH! GL! :)RichRich Jesse System/Database Administrator[EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA-Original Message-Sent: Tuesday, August 19, 2003 2:49 PMTo: Multiple recipients of list ORACLE-LHi,No. I recommend that you do not change cursor_sharing if you are doing itjust to get rid of 4031. There could be serious problems. ora-600 etc. MaybeOracle has fixed everything in latest 817 but I suggest not to take thatchance.For 4031 you can do the following : pin pl/sql sql preferably at startup,use bind variables and periodically check fo!
r sql not
using bind variables.Goodluck. "Fedock, John (KAM.RHQ)" <[EMAIL PROTECTED]>wrote:Does anyone have any experience using cursor_sharing in 8.1.7.4? I feel Ineed to use it due to literal SQL statements being used. We have had misc4031 errors off and on and I feel this is my last hope. I have a very busyOPFS server (HP-UX). I did try using cursor_sharing in 8.1.7.2, and I remember incorrect sortingand other unexpected results happening.Thanks for any input.John-- Please see the official ORACLE-L FAQ: http://www.orafaq.net-- Author: Jesse, RichINET: [EMAIL PROTECTED]Fat City Network Services -- 858-538-5051 http://www.fatcity.comSan Diego, California -- Mailing list and web hosting services-To REMOVE yourself from this mailing list, 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).
Do you Yahoo!?
SBC Yahoo! DSL - Now only $29.95 per month!

1 2 >

100 matches

Mail list logo