4.1.3 Monitor Session - Active SQL printed in single line

Hi Jeff,

It seems to be program specific problem.

We have an old ETL Tools called Sagent and it seems all queries fired from that tool are coming in this one-line format.

Notice the horizontal scroll bar at the bottom.

Please don't mind the Master layout of the Session Monitor, which I adjust to be more informational with Gauge Bar and so on.

For the time being, I need to open another worksheet, copy and paste that line and use Ctrl + F7 to re-format.

Thank you for clarifying.

Regards,

Buntoro

Hi Jeff,

On second thought.

I need to unmark as correct.

Probably this problem happened on DML command (insert / update / delete) only.

Here is another example, query coming from user tool (PL/SQL Developer).

I try to dig into the query for "Active SQL" and try to execute it myself on worksheet.

Notice the SID = 2024 which I get from the above.

I thought that it will return one line, which justify why SQL Dev show single line output.

However, as you can see it is not.

The question still hold.

Regards,

Buntoro

I copy the Report from the Template (All Reports - Data Dictionary Reports - Database Administration - Sessions - Sessions).

And paste it under User Defined Reports, and name it Session Browser instead.

Every time I open Tools - Monitor Sessions, it seems to be pointing out to the User Defined Reports - Session Browser (the one that I modified).

Regards,

Buntoro

Hi Jeff,

Mine is :

select replace(q.SQL_TEXT, chr(0), chr(10) || chr(13)) sql_text

  from gv$session s, v$sqltext_with_newlines q

where  s.sql_address = q.address

  and  s.sql_hash_value = q.hash_value

  and  s.sid = :SID

order by q.piece

I also tried yours too. But on detail tab produces the same result.

select replace(q.SQL_FULLTEXT,chr(0)) sql_text

  from gv$session s, gv$sql q

where  s.sql_address = q.address

  and  s.sql_hash_value = q.hash_value

  and  s.sid = :SID

FYI, if executed on Worksheet

My query will produce multiple rows result

Your query will produce single line result

Nevertheless, both produce the same single line output on Detail tab.

Regards,

Buntoro