Re: ORA-4030

From: Chuck <chuckh_at_softhome.net>
Date: 24 Feb 2003 15:42:14 GMT
Message-ID: <Xns932C6CE1F8AC3chuckhsofthomenet@130.133.1.4>

Sybrand Bakker <gooiditweg_at_nospam.demon.nl> wrote in news:0m6d5v0v7f80fnvlgsgh0nm6u5519qdk66_at_4ax.com:

> Sure you can set it at session level. In 8i, just create an
> after-logon trigger, have a few execute immediate in the trigger code
> and you can do anything you want

That would work if only specific users were doing sorts and/or hash joins. That however is not the case. Any user on this database can do those things depending on what part of the application they access. Received on Mon Feb 24 2003 - 09:42:14 CST