Re: Is it possible to filter or hook the Oracle SQL parser?

Comments in-line.

Shangwu wrote:
> Daniel,
>
> Thank you again for the response.

You're welcome.

> Even if I set some partition's tablespace
> read-only, it still affects the server's performance.

And this statement is based upon testing? This is utter nonsense. Not that there isn't always some cost to something. But a read-only tablespace is going to impact performance less than your kludge.

> If I take them offline
> and rewrite query's FROM clause for online partitions only, the performance
> should become better. Would you please to provide any example of your
> creativity using DBMS_RLS to rewriting a query's FROM clause?
>
> Regards,
>
> Shangwu

You are making assumptions I suspect you can not back up with a benchmark. I personally don't believe you will gain enough to justify the time you spent on these posts.

<tongue-in-cheek>
Don't you have any real work to do?
</tongue-in-cheek>

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)