I create an monitoring template for my database on OEM GC, apply it on somes database and now i want to know what database is using this template. Can someone help me please?
Oracle implemented monitoring templates a bit differently than you might expect. When you apply a template to a database it doesn't associate the template with the database, but instead applies the template settings to the database. This is why modifying the template after it has been applied to the database has no effect until it is re-applied to the database.
The 11.1 Oracle Enterprise Manager documentation explains how to use the "Compare Monitor Template" feature to determine how closely the template matches a particular target. In this way you can determine if the template has been applied to the database.