Re: Oracle In-Memory Database Cache and PL/SQL
Date: Sun, 25 Jul 2010 16:06:16 +0200
Message-ID: <AANLkTi=r3fYV0g7BHJowg3vsWyXkdKgOv9FW8383dbDg_at_mail.gmail.com>
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_at_hotmail.com> 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/
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>
-- Martin Berger martin.a.berger_at_gmail.com Lederergasse 27/2/14 +43 660 660 83306 1080 Wien http://berx.at/ -- http://www.freelists.org/webpage/oracle-lReceived on Sun Jul 25 2010 - 09:06:16 CDT