Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Mailing Lists -> Oracle-L -> 5 child latches means 5 lib cache hash chains ??

5 child latches means 5 lib cache hash chains ??

From: Rahul <>
Date: Wed, 26 Jul 2000 12:30:06 +0700
Message-Id: <>

querying v$latch_children (v7.3) i get
5 library cache latches.,
does this mean that i have 5 hash chains each pointing to a linked list of library handles ??

TIA Rahul

 From: Rustem Valeev <>  Date: Wed, 26 Jul 2000 09:42:40 +0400
 Subject: Re: Indexing a table

1. The common filed should be last. Oracle use first column in query where condition only for first column
2. Uncertain question:

      Selectance of xx,x,...
      tables size
      foreing (primary) key.

   Oracle query steps: insert view source in you select, optimize query, then execute

   (although in complex query that is't fact, read "Oracle Tuning" from Oracle documentation) wrote:

> hi
> if searching and updating a large database is required in realtime
> then indexing increases the performance a lot. I had doubt regarding the
> order of columns in which indexing needs to be done
> 1). when a compound index is t be created then what should be the order
> of the fields in the index. The common field which is same for a large no
> of rows should be the first column to be included in index or should be
> the last.
> 2). while operating on views does the index of the tables which are
> constituting the view are used as it is , and shoul a separate index needs
> to be created on the columns appearing tin the where clause of the view
> independently even though a composite index exists over the where clause
> of the view creation sql + the where clause of the query from the view.
> e.g. create view a as select b.x,c.y,c.z,c.xx
> from tableb b, tablec c,
> where b.x=c.y;
> a query is made as "select * from a where xx="some value";
> existing index on c.y + c.xx
> should a new index over only c.xx and only c.y and only b.x is is
> required
> any suggestions in this regard will be very useful
> thanks
> Arvind
> --
> Author:
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: (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).

Rustem Valeev,, (095)4360496


 From: "Bryan Michael Lenihan" <>
 Date: Wed, 26 Jul 2000 01:48:40 -0400
 Subject: Re: Passing the "&" in PL/SQL

Have you tried...

-----------  BeginPaste --------------
SQL*Plus: Release - Production on Wed Jul 26 1:45:25 2000

(c) Copyright 1997 Oracle Corporation.  All rights reserved.

Connected to:
Oracle7 Server Release - Production
With the distributed, replication, parallel query and Spatial Data options
PL/SQL Release - Production

SQL> create procedure test (invar in varchar2)
  2  is
  3  begin
  4    dbms_output.put_line(invar);
  5  end;
  7  /

Procedure created.

SQL> set serveroutput on
SQL> execute test ('Entry 1'||'&'||' Entry2');
Entry 1& Entry2

PL/SQL procedure successfully completed.

-----------  End Paste --------------
Bryan Lenihan

----- Original Message -----
From: David Barbour <>
To: Multiple recipients of list ORACLE-L <>
Sent: Tuesday, July 25, 2000 8:44 PM
Subject: RE: Passing the "&" in PL/SQL

> Thanks to all who have replied. I've tried all your suggestions, and
> a number of my own variations ..... all to no avail.
> Her's the scenario - A user types in a few letters of a company name and
> returned a list of those firms that match the input. The list hypertext
> links to the next page, passing the business name and other information as
> input variables. This list comes from a table where numerous firms are
> identified using the '&' symbol. I have no way of knowing what firm the
> user will ultimately select from the list they generate, so I don't know
> there will be a & in the name. I've attempted to compensate for this by
Received on Wed Jul 26 2000 - 00:30:06 CDT

Original text of this message