Hey Brian You got a good point there.. There is a good chance for statistics to be locked if the database has been restored out of a dmp. From my experience when importing a database from a dmp, it imports the database with all its tables locked, so dbms statistics procs will fail over the tables owned by the ARADMIN schema.. It would be a good idea to analyze the tables to estimate statistics for all the ARADMIN owned tables and if this fails becauase the tables are locked, unlock them by unlocking the entire ARADMIN schema and then estimate the statistics.. Joe
----- Original Message ---- From: Brian Goralczyk <[EMAIL PROTECTED]> To: [email protected] Sent: Tuesday, August 26, 2008 3:16:40 PM Subject: Re: system table actlink_set and performance ** Joe, I agree with you regarding the size and efficiency of the table, however, if the statistics on the database are not being updated the indexes will be out of date and the system will still do a table scan. I would check to see how often the database statistics are updated, or if they have been updated recently. That would be the first stop for me. Brian Goralczyk 2008/8/26 Joe DeSouza <[EMAIL PROTECTED]> ** ACTLINK_SET is an internal meta data table, that the AR System uses to store information of all the Set Fields actions from all Active Links.. Considering that nearly 70% to 80% or even more Active Links from most systems contain set field actions, this table is expected to be pretty large.. This table is already appropriately indexed for use by Remedy to avoid any table scans when the system is reading information from this table at the time of building its cache, and there is not much you can do about further improving performance as basically whenever there is a search to this table, the search is against a significantly larger table than most of your other data tables. This search however would happen only during system startup, when the system is reading all the definitions to build up its cache, and at the time there is a recache of definitions when there are changes in the active links. It shouldn't significantly impact end users non-development users. So even if there was a way to bring down your 4 seconds to something lower, you aren't really going to achieve much.. Joe ----- Original Message ---- From: BROTONS Oscar <[EMAIL PROTECTED]> To: [email protected] Sent: Tuesday, August 26, 2008 9:26:56 AM Subject: system table actlink_set and performance ** Hi all, I'm trying to improve the performance on our environment and inapi-sql logs analized with arwklga.exe I get that the worst query I've doing isSELECT actlink_set, with an average of 4,24seconds. I found this unacceptable because is not my workflow but remedy who runs that. Have someone an idea about what could be happening? Thanks a lot. Oscar Brotons. IT Consultant. ________________________________ IMPORTANT: This message is intended exclusively for information purposes. It cannot be considered as an official OHIM communication concerning procedures laid down in the Community Trade Mark Regulations and Designs Regulations. It is therefore not legally binding on the OHIM for the purpose of those procedures. The information contained in this message and attachments is intended solely for the attention and use of the named addressee and may be confidential. If you are not the intended recipient, you are reminded that the information remains the property of the sender. You must not use, disclose, distribute, copy, print or rely on this e-mail. If you have received this message in error, please contact the sender immediately and irrevocably delete or destroy this message and any copies. ________________________________ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
