5 child latches means 5 lib cache hash chains ??

From: Rahul <rahul_at_ratelindo.co.id>
Date: Wed, 26 Jul 2000 12:30:06 +0700
Message-Id: <10569.112967@fatcity.com>

List,
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 <valeev_at_avicomp.ru>  Date: Wed, 26 Jul 2000 09:42:40 +0400
 Subject: Re: Indexing a table

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

aheda_at_cdotd.ernet.in 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:
> INET: aheda_at_cdotd.ernet.in
>
> 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: ListGuru_at_fatcity.com (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, valeev_at_avicomp.ru, (095)4360496




------------------------------

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

Have you tried...

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

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


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

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

Procedure created.

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

PL/SQL procedure successfully completed.

SQL>
-----------  End Paste --------------
Thanks,
Bryan Lenihan

----- Original Message -----
From: David Barbour <DBarbour_at_connectsouth.com>
To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
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

added


> 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

is


> 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

if


> 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