Re: XML SQL Utility for Oracle 8i

From: <rereidy_at_my-deja.com>
Date: Fri, 26 Jan 2001 23:35:34 GMT
Message-ID: <94t1k6$mc9$1@nnrp1.deja.com>

Rob,

The problem is your shared_pool. Becuase this utility is Java based inside the DB instance, you will need to adjust (radically!) all of your shared_pool, large_pool, and java_pool parameters.

Also, I worked with this utility at a job last summer. At that time, this was Beta software. Beware - it could create temporary LOBs that are **never** (until you bounce the instance) removed from your TEMP tablespace(s).

Good luck.

Ron Reidy
Oracle DBA

In article <3a713891.581890554_at_reading.news.pipex.net>,   rob_at_commercenti.com (Rob Gilchrist) wrote:
> I have been recently tasked with developing a project on Oracle and
> Unix, coming from a NT and SQL Serve background this has been a steep
> learning curve.
> I have hit a major stumbling block as part of the project involves
> creating XML from the output of a SQL query. This can be achieved by
> using the XML SQL Utility for Oracle 8i. When I try to install this on
> my machine (SUN SOLARIS 2.7 and Oracle 8.1.6) it throws up this error
>
>

---

---

> oracle/xml/sql/XSUMesg is already resolved
> resolving: oracle/xml/sql/OracleXMLSQLException
> Error while resolving class oracle/xml/sql/OracleXMLSQLException
> ORA-04031: unable to allocate 4096 bytes of shared memory ("shared
> pool","unknown object","joxlod: in phe","joxlod: s bcd")
>

---

---

>
> Has anybody seen this error before or know how to fix it.
>
> Thanks
>
> Rob Gilchrist
>

Sent via Deja.com
http://www.deja.com/ Received on Fri Jan 26 2001 - 17:35:34 CST