All geek questions in one place

SQL Developer 4 Monitor Sesions not working properly

I have SQL Developer version 4.0.0.13, and I'm connected to Oracle9i Enterprise Edition Release 9.2.0.8.0.

I try to use monitoring sessions from the Tools menu / by running the Sessions report in the Database Administration → Sessions section, and I always get the following error.

An error was encountered performing the requested operation:

ORA-00904: "SQL_ID": invalid identifier
00904. 00000 -  "%s: invalid identifier"
*Cause:    
*Action:
Vendor code 904

I accepted the Sessions report, copied it to UserDefinedReports, and edited it. I found the following:

The report makes a SELECT from the gv $ session and tries to select a column called SQL_ID, which when I execute DESC gv $ session does not exist.

So, I removed the SQL_ID from the selected and the whole report, and I can successfully run my own report.

Question:

, ""? , , , .

.

+4
2

:

sqlplus sys admin, :

GRANT SELECT ON gv_$session TO payroll;
GRANT SELECT ON gv_$sql TO payroll;

SQL Developer: 4.1.0.19

:

sys sql- sqsdba, , :

http://turingsman.net/my-blog-list/158-part-10-configuring-sys-and-system-users-connections-for-sql-developer-in-oracle-database-11gr2-client

+1

Source: https://habr.com/ru/post/1527696/

More articles:


All Articles