sql monitoring page is missing query start and ended columns in enterprise manager 13.3

Gothman

I've got the 13.3 em release installed and updated the agent plugins to the latest releases but I'm looking at various db targets (of different versions) and I am noticing that the query start/ended columns on the sql monitoring page are no longer there. Were these columns purposely removed? Is there a way to add the columns back? They've always been extremely important for quickly finding problem queries. Removing the start/ended columns makes this performance page far less valuable and seems like a choice made by someone with zero dba experience..

Gothman

When checking 11.2 database targets I see the start/end datetime columns but when I check 12.1 and 12.2 database targets I don't see those columns now, even clicked the drop down to scope the page to the container db and the plug-able. I hope there's an ez fix to add these columns.

Courtney Llamas-Oracle

I'm not seeing a way to add the columns back, but i did notice that if you hover over the Duration, it shows the start/end time.  I don't have an 11g db to test against right now, but what I would suggest is logging an SR and asking them to log a bug/ER to add the columns back in and provide some details as to why you need them in columns vs as a pop up - like ability to sort by start time/end time, etc...

Venkata Thiruveedhi-Oracle

Hi,

Yes those columns were removed with the new JET page implementation.

The following ER was filed for this requirement:

Enh 30493065 - SQL Monitoring Page in JET missing Start & Ended Columns

For validation and workaround purpose you always have an option to move back to FLASH page using the following command:

./emctl set property -sysman_pwd <SYSMAN_Password> -name oracle.sysman.db.ena_flash.perf_home -value true

This command will load the Performance Home & SQL Monitoring pages in Flash.

You can revert back to the JET pages again with the following command:

./emctl set property -sysman_pwd <SYSMAN_Password> -name oracle.sysman.db.ena_flash.perf_home -value false

NOTE: No OMS restart is needed for these commands.

Best Regards,
Venkat