ITSM 764 sp2, Oracle, Linux While copying our production database to development I noticed a huge difference in the number of tables. Running the following SQL "select count(*) from user_tables" I found there were over 7000 in production but our development server had about 5000. After doing some digging I found the difference to be in the temp tables that FTS creates, but never deletes. These all start with "AR[number]CHAR[ThreadPID]". According to BMC support the system should delete them when ARS services are stopped but this is not the case, at least for 764 sp2. Support said that we can delete them at any time with impacting the application.
Anybody else dealing with these temp tables? Thank you Frank Caruso _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
