Hello - I'm new to OEM 12c and I'm still getting my head around the monitoring aspects of it. I just added two temporary tablespaces to a database. When I look at the tablespaces via OEM12c, I notice that the Avaliable Space Used (%) Alerts column has a check mark for all the tablespaces except the two I just created. The original TEMP tablespace does have check in the column. Will these two new tablespaces be monitored for used space?
Can you elaborate on where and how you check the "Available Space Used (%) Alerts column"? Assuming you are referring to the Tablespace Space Used (%) metric, unless the name of a tablespace and its thresholds values are specifically specified for the metric in the (database homepage >) Metric and Collection Settings page, threshold values seen in the page will be used.
Hi! When I select a database target then go to Administration - Storage - Tablespaces, there is a column on that screen called Available Space Used (%) Alerts. In my case, there are green check marks in this column for all the tablespaces except for the two new tablespaces I created last week. I haven't changed any metric settings. I would assume that the metric settings would apply to any newly created tablespaces as well.
Thanks for your post!
I'm assuming you're on DB 11.2 or higher... Temp and Undo are typically excluded from monitoring due to their cyclical nature. Thresholds must explicitly be set from 11.2 and higher. Please see this note for more details. Another explanation might be timing... if you just added them, and the tablespace collection hasn't run, you won't see that check because the metric hasn't validated them yet. If you go back after the collection runs, you should see (if they were a normal tablespace and the temp/undo monitoring wasn't in play)...
I think I figured it out. I added two tablespaces last week. They did not have any activity until this afternoon. I believe that when the tablespaces started to be used, that is, started to have extents added to them, they became candidates for the metric to start checking them. The Green Check mark is now visible under the Tablespace home page and they show used Space Used greater than zero. It appears the metric for Tablespace USED looks past tablespaces that haven't had any activity yet.
Thanks for the feedback.