Re: Oracle In-Memory Database Cache and PL/SQL
- From: Martin Berger <martin.a.berger@xxxxxxxxx>
- To: mccmx@xxxxxxxxxxx
- Date: Sun, 25 Jul 2010 16:06:16 +0200
Oracle Times Ten supports PL/SQL
http://download.oracle.com/otn_hosted_doc/timesten/1121/quickstart/html/developer/plsql/plsql.html
but not all data types and functions are supported yet, also many
packages are missing.
unfortunately a simple 'compile' and 'show error' will not be
sufficient. you have to test every code manually.
hth
Martin
On Thu, Jul 22, 2010 at 07:47, Matt McClernon <mccmx@xxxxxxxxxxx> wrote:
>
> I’m in the process of doing a proof of concept with IMDB to
> cache a subset of our application data to improve the performance of our
> application.
>
>
>
> I’ve hit a problem which I think makes the product
> unsuitable in our current environment and I was wondering if I’m missing
> something in the research I’ve done.
>
>
>
> Does IMDB allow the caching (and execution) of stored pl/sql
> packages and types which are stored in the main Oracle database..?
>
>
>
> Based on the research I’ve done it only appears as though
> IMDB can cache table data. I have seen evidence of the ability to create
> pl/sql stored units independently in IMDB but no mention of caching and
> executing existing pl/sql units that live in the RDBMS.
>
>
>
> If IMDB is restricted to table data then our application
> would effectively have to go to the RDBMS to execute the pl/sql code and then
> back
> to the IMDB layer to read the ‘cached’ table data which seems to be
> counter-productive.
>
>
>
> Is this the case or am I missing something..?
> _________________________________________________________________
> http://clk.atdmt.com/UKM/go/195013117/direct/01/
> --
> //www.freelists.org/webpage/oracle-l
>
>
>
--
Martin Berger martin.a.berger@xxxxxxxxx
Lederergasse 27/2/14 +43 660 660 83306
1080 Wien http://berx.at/
--
//www.freelists.org/webpage/oracle-l
Other related posts:
