set role

Trying to get autotrace out of SQL Developer and getting error message.

Failed to access V$MYSTAT.

Please obtain read catalog privilege

from your database administrator:

grant SELECT_CATALOG_ROLE to RAFU

grant SELECT ANY DICTIONARY toRAFU

NOTE: you need to reconnect your current session

in order for the settings change to have an effect

Granted the privileges. I guess less would be enough. Weird note. Why do I need to reconnect the session? There exists SET ROLE command.

SET ROLE ALL;

That does the job. No reconnect needed.

Anoying SQL Developer

Yet another new installation of SQL Developer. I am writing SQL. The query includes ANALYTIC functions not AGGREGATE ones. SQL Developer hits and adds some group by clause somewhere in between my clause. Getting rid of that.

Tools

Preferences...

Code editor

Completion Insight

unselect Autogenerate GROUP BY clause.

OK

I so wish this would be the default.