Discussions
Categories
- 17.9K All Categories
- 3.4K Industry Applications
- 3.3K Intelligent Advisor
- 63 Insurance
- 535.7K On-Premises Infrastructure
- 138.1K Analytics Software
- 38.6K Application Development Software
- 5.6K Cloud Platform
- 109.3K Database Software
- 17.5K Enterprise Manager
- 8.8K Hardware
- 71K Infrastructure Software
- 105.2K Integration
- 41.5K Security Software
sql monitoring page is missing query start and ended columns in enterprise manager 13.3

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..
Answers
-
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.
-
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...
-
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