Cloud Control 13c Metric and Collection Settings

GokhanAta

Hi,

I have a database instance 12c on Oracle Linux 7 and its contain over 100 tablespaces. I want to create Tablespaces Full Metric in Cloud Control 13c but I have a problem. Because, while some tablespaces size is so fastly increase data, other tablespaces is slowly increase data. As a result of I want to create distinct group for fastly and slowly increase tablespaces.

Is it feasible?

Regards,

Gokhan

EricvdS

Hi Gokhan,

Why not use bigfile tablespaces?

For now you could create two Metric Extensions, one for the fast growing and one for the slower ones. Based on the query mentioned below combined with an AND column_label IN (<the fast growing TSses>) for the fast growing tablespaces you can set a warning or critical depending on the pct_used.

https://stackoverflow.com/questions/42257238/get-tablespace-output

Regards, Eric

EricvdS

Hi Gokhan,

Why not use bigfile tablespaces?

For now you could create two Metric Extensions, one for the fast growing and one for the slower ones. Based on the query mentioned below combined with an AND column_label IN (<the fast growing TSses>) for the fast growing tablespaces you can set a warning or critical depending on the pct_used.

https://stackoverflow.com/questions/42257238/get-tablespace-output

Regards, Eric

GokhanAta

Hi Eric,

Thanks for your answer. I will try your suggest.

Regards, Gokhan