The Oracle (tm) Users' Co-Operative FAQ
What are all these tables with names like EVT% and SMP% that have recently appeared in my system ?
| Author's name: Connor McDonald Author's Email: http://www.oracledba.co.uk |
Date written: September 09, 2002 Any Oracle Version |
| What are all these tables with names like EVT% and SMP% that have recently appeared in my system ? |
These tables are installed as part of Oracle Enterprise Manager (OEM). They most commonly appear if you have opted for a default database installation and the Enterprise Manager Management Server component was included. Unfortunately they have historically been dumped into the SYSTEM tablespace which is not the best location (for anything). Also in days gone by with the 2-tier client/server version of the console, if you happened to connect to a database that did not contain the objects (for example, you've logged on to the wrong schema), then the objects would be created automatically, which could leave you with multiple copies of the objects across several databases.
If you do not use OEM then they can be dropped, otherwise it is best to ensure that they are within their own tablespace (an option that the more recent versions of OEM will give you during installation).
Further reading: http://otn.oracle.com/docs/products/oracle9i/doc_library/release2/em.920/a96670/toc.htm Enterprise Manager Admin Guide
