Bug Report: Session window

[ScottMattes]

I thought it was just being tired, but I think that there might be more to it than that.

I like to change my session stats query to "order by stats.valued desc", so when I went to update this PC's query and when I click on the Stat tab nothing is displayed. I took the query and ran it from a sql window and it worked like that.

I gave up and restored the query and once it ran I clicked on the sort button for the value column and no sorting! The other two columns did sort when I click on their sort button.

 

[Marco Kalter]

It works fine for me. I used "order by stats.value desc" instead of "order by stats.valued desc", but I assume this is a typo in this topic?

 

[ScottMattes]

Marco,
I didn't keep my previous attempt, so I went back and copied your order by and it displays nothing. I then took the query and put it into a SQL Window, used my sid in place of the :sid and it works.

Here is my query, do you see anything wrong with it?

select names.name, stats.statistic#,
stats.value
from v$sesstat stats,
v$statname names
where stats.sid = :sid
and names.Statistic# = stats.Statistic#
order by stats.VALUE desc -- stats.statistic#

Which led me to one more test, I took off the comment on the order by line and now it works. Is this a bug in PL/SQL Dev, or in Oracle?

Here is the working version

select names.name, stats.statistic#,
stats.value
from v$sesstat stats,
v$statname names
where stats.sid = :sid
and names.Statistic# = stats.Statistic#
order by stats.VALUE desc

 

[Roeland]

I like to change my session stats query to "order by stats.valued desc", so when I went to update this PC's query ...

I just like to know where and how do you obtain and change the query's for PL/DEV?

 

[Marco Kalter]

Is this a bug in PL/SQL Dev, or in Oracle?

Seems like a PL/SQL Developer bug. We'll fix it.

I just like to know where and how do you obtain and change the query's for PL/DEV?

For the Session Window you can change the queries for the session filters and details. Just press the "Define Session Queries" button on the Session Window toolbar.