Hello,

We are using Oracle 8i on Windows 2000. Can anyone help us to know How to control resources at session level?

By setting CPU_PER_CALL=1000 in profile and RESOURCE_LIMIT = TRUE we will enforce the same to all sessions of same database user. But how can limit this to specific sessions (Alter session set resource_limit=true) is not there.

Is there any other way using packages/triggers?

Please guide us.

Thanks & Regards,

Shailesh