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 ?

Back to index of questions


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


Back to top

Back to index of questions