Indexing Question
We are using Oracle if that matters. I don't think it does. My question is specifically Remedy related. I know that when you modify an index in Remedy via the admin tool, it drops the old index and creates a new one. Does it drop ALL of the old indexes or JUST the one you are modifying? I need to make sure I am clear on this. We are experiencing some pretty extreme slowness all of a sudden. I think that some indexes were modified on the Oracle side. Remedy won't necessarily see the new or changed indexes unless they are created via the Admin tool. Could this be the problem? We had 41 gigs of oracle trace files that the DBA deleted last week and the problems seem to have started after that was done. ARS 6.3 Patch 18 HD 6.0 Oracle 10 w/9 libraries Oracle lives on a remote server Windows 2003 4 gig on app server and 8 gig on DB server Claire Sanford Information Systems Division Memorial Hermann Healthcare System Phone: 713 448 6035 [EMAIL PROTECTED] ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Indexing Question
Claire, I believe that only the index you changed will re-created. We have had luck making changes to indexes in two steps; Delete old, save, Create new, save. I really don't know if it makes any difference. Creating indexes outside of the admin tool has always been a big no no. Talk with your DBA. HTH, Roger A. Nall Manager, OSSNMS Remedy T-Mobile, USA Desk:972-464-3712 NEW Cell: 973-652-6723 FAX: sf49fanv AIM IM RogerNall Yahoo IM -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Sanford, Claire Sent: Friday, July 11, 2008 10:43 AM To: arslist@ARSLIST.ORG Subject: Indexing Question We are using Oracle if that matters. I don't think it does. My question is specifically Remedy related. I know that when you modify an index in Remedy via the admin tool, it drops the old index and creates a new one. Does it drop ALL of the old indexes or JUST the one you are modifying? I need to make sure I am clear on this. We are experiencing some pretty extreme slowness all of a sudden. I think that some indexes were modified on the Oracle side. Remedy won't necessarily see the new or changed indexes unless they are created via the Admin tool. Could this be the problem? We had 41 gigs of oracle trace files that the DBA deleted last week and the problems seem to have started after that was done. ARS 6.3 Patch 18 HD 6.0 Oracle 10 w/9 libraries Oracle lives on a remote server Windows 2003 4 gig on app server and 8 gig on DB server Claire Sanford Information Systems Division Memorial Hermann Healthcare System Phone: 713 448 6035 [EMAIL PROTECTED] ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Indexing Question
I agree with Roger. Make sure there are no bitmap indexing at Oracle level. If there are , drop them off and follow the procedure suggested by Roger. Test it out first on Development system though. Regards, Chintan. --- On Fri, 7/11/08, Nall, Roger [EMAIL PROTECTED] wrote: From: Nall, Roger [EMAIL PROTECTED] Subject: Re: Indexing Question To: arslist@ARSLIST.ORG Date: Friday, July 11, 2008, 8:58 AM Claire, I believe that only the index you changed will re-created. We have had luck making changes to indexes in two steps; Delete old, save, Create new, save. I really don't know if it makes any difference. Creating indexes outside of the admin tool has always been a big no no. Talk with your DBA. HTH, Roger A. Nall Manager, OSSNMS Remedy T-Mobile, USA Desk:972-464-3712 NEW Cell: 973-652-6723 FAX: sf49fanv AIM IM RogerNall Yahoo IM -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Sanford, Claire Sent: Friday, July 11, 2008 10:43 AM To: arslist@ARSLIST.ORG Subject: Indexing Question We are using Oracle if that matters. I don't think it does. My question is specifically Remedy related. I know that when you modify an index in Remedy via the admin tool, it drops the old index and creates a new one. Does it drop ALL of the old indexes or JUST the one you are modifying? I need to make sure I am clear on this. We are experiencing some pretty extreme slowness all of a sudden. I think that some indexes were modified on the Oracle side. Remedy won't necessarily see the new or changed indexes unless they are created via the Admin tool. Could this be the problem? We had 41 gigs of oracle trace files that the DBA deleted last week and the problems seem to have started after that was done. ARS 6.3 Patch 18 HD 6.0 Oracle 10 w/9 libraries Oracle lives on a remote server Windows 2003 4 gig on app server and 8 gig on DB server Claire Sanford Information Systems Division Memorial Hermann Healthcare System Phone: 713 448 6035 [EMAIL PROTECTED] ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Indexing Question
Claire, There is a knowledge base entry that states that all indexes are dropped and recreated. So much for what I know. Roger A. Nall Manager, OSSNMS Remedy T-Mobile, USA Desk:972-464-3712 NEW Cell: 973-652-6723 FAX: sf49fanv AIM IM RogerNall Yahoo IM -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Sanford, Claire Sent: Friday, July 11, 2008 10:43 AM To: arslist@ARSLIST.ORG Subject: Indexing Question We are using Oracle if that matters. I don't think it does. My question is specifically Remedy related. I know that when you modify an index in Remedy via the admin tool, it drops the old index and creates a new one. Does it drop ALL of the old indexes or JUST the one you are modifying? I need to make sure I am clear on this. We are experiencing some pretty extreme slowness all of a sudden. I think that some indexes were modified on the Oracle side. Remedy won't necessarily see the new or changed indexes unless they are created via the Admin tool. Could this be the problem? We had 41 gigs of oracle trace files that the DBA deleted last week and the problems seem to have started after that was done. ARS 6.3 Patch 18 HD 6.0 Oracle 10 w/9 libraries Oracle lives on a remote server Windows 2003 4 gig on app server and 8 gig on DB server Claire Sanford Information Systems Division Memorial Hermann Healthcare System Phone: 713 448 6035 [EMAIL PROTECTED] ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Indexing Question
I've read the KB entry, but have been told otherwise, so that was why I asked the list. He has created some indexes outside the admin tool which I think may be the problem. He has created them to make some views that were created for some odbc reporting to run quickly. -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Nall, Roger Sent: Friday, July 11, 2008 11:05 AM To: arslist@ARSLIST.ORG Subject: Re: Indexing Question Claire, There is a knowledge base entry that states that all indexes are dropped and recreated. So much for what I know. Roger A. Nall Manager, OSSNMS Remedy T-Mobile, USA Desk:972-464-3712 NEW Cell: 973-652-6723 FAX: sf49fanv AIM IM RogerNall Yahoo IM -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Sanford, Claire Sent: Friday, July 11, 2008 10:43 AM To: arslist@ARSLIST.ORG Subject: Indexing Question We are using Oracle if that matters. I don't think it does. My question is specifically Remedy related. I know that when you modify an index in Remedy via the admin tool, it drops the old index and creates a new one. Does it drop ALL of the old indexes or JUST the one you are modifying? I need to make sure I am clear on this. We are experiencing some pretty extreme slowness all of a sudden. I think that some indexes were modified on the Oracle side. Remedy won't necessarily see the new or changed indexes unless they are created via the Admin tool. Could this be the problem? We had 41 gigs of oracle trace files that the DBA deleted last week and the problems seem to have started after that was done. ARS 6.3 Patch 18 HD 6.0 Oracle 10 w/9 libraries Oracle lives on a remote server Windows 2003 4 gig on app server and 8 gig on DB server Claire Sanford Information Systems Division Memorial Hermann Healthcare System Phone: 713 448 6035 [EMAIL PROTECTED] ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Indexing Question
Not to start a war, but my experience has been that Oracle DBA's are absolutely the WORST for doing things. You must teach them to keep their hands off, unless disk space is involved. David M Clark Remedy Programmer/Analyst Sanford, Claire [EMAIL PROTECTED] 7/11/2008 12:11 PM I've read the KB entry, but have been told otherwise, so that was why I asked the list. He has created some indexes outside the admin tool which I think may be the problem. He has created them to make some views that were created for some odbc reporting to run quickly. -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Nall, Roger Sent: Friday, July 11, 2008 11:05 AM To: arslist@ARSLIST.ORG Subject: Re: Indexing Question Claire, There is a knowledge base entry that states that all indexes are dropped and recreated. So much for what I know. Roger A. Nall Manager, OSSNMS Remedy T-Mobile, USA Desk:972-464-3712 NEW Cell: 973-652-6723 FAX: sf49fanv AIM IM RogerNall Yahoo IM -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Sanford, Claire Sent: Friday, July 11, 2008 10:43 AM To: arslist@ARSLIST.ORG Subject: Indexing Question We are using Oracle if that matters. I don't think it does. My question is specifically Remedy related. I know that when you modify an index in Remedy via the admin tool, it drops the old index and creates a new one. Does it drop ALL of the old indexes or JUST the one you are modifying? I need to make sure I am clear on this. We are experiencing some pretty extreme slowness all of a sudden. I think that some indexes were modified on the Oracle side. Remedy won't necessarily see the new or changed indexes unless they are created via the Admin tool. Could this be the problem? We had 41 gigs of oracle trace files that the DBA deleted last week and the problems seem to have started after that was done. ARS 6.3 Patch 18 HD 6.0 Oracle 10 w/9 libraries Oracle lives on a remote server Windows 2003 4 gig on app server and 8 gig on DB server Claire Sanford Information Systems Division Memorial Hermann Healthcare System Phone: 713 448 6035 [EMAIL PROTECTED] ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are