Re: Java stored procedure and LDAP?

[[ This message was both posted and mailed: see

   the "To," "Cc," and "Newsgroups" headers for details. ]]

Hi Andriy,

you may have a very unhappy query (which will end now or next millenium ;-) ) Tried to create indexes for the involved tables?

Try something like this:

select
  disk_read,
  sql_text
from v$sqlarea
where disk_reads > 10000
order by disk_reads desc;

to see if there is a select-pig

Hope this helps,

Toni

In article <946407189.606913_at_Nova.PolyNet.Lviv.UA>, Andriy Korud <akorud_at_polynet.lviv.ua> wrote:

> Hi, I have such question:
> I create JSP which perform LDAP search using:
> Hashtable env = new Hashtable();
> env.put(Context.INITIAL_CONTEXT_FACTORY,
> "com.sun.jndi.ldap.LdapCtxFactory");
> env.put(Context.PROVIDER_URL, "ldap://tytan:389/o=LP");
> try {
> DirContext ctx = new InitialDirContext(env);
> Attributes attrs = ctx.getAttributes("cn=pm");
> ctx.close();
> }
> ...{Some other operations}
>
> It's imported into Oracle 8i database using loadjava successfully.
> It execute successfully - I got value from LDAP and {Some others ops} are
> executed but it never returns - at the end of procedure Oracle begin to eat
> 100% of CPU and that's all.
>
> Environment:
> Oracle 8i for Linux standart edition, Linux 2.2.13, 256RAM,
> other Java Stored Procedures are executed Ok.
>
> Any ideas?
>
> Thanks in advance,
> Andriy Korud, Lviv, Ukraine.
>
> P.S. Please send copy of reply by email to akorud_at_polynet.lviv.ua
Received on Tue Jan 18 2000 - 10:04:44 CST