I recently learned that new tables shouldn't be created in the SYSTEM tablespace, so I copied them to a new tablespace called CAT_DAT. Also, I transfered the corresponding indexes (some generated by Oracle and others custom made) to the tablespace CAT_IDX. Since this time, the performance of the DB is very poor.
The user specified to draw from CAT_DAT and CAT_IDX is configured the same as the old user who drew from the SYSTEM tablespace. Is there something I can do to get the performance back up?