Make sure that you have the queries optimized since you're using Oracle 11. It doesn't keep its query optimizations like Oracle 10 did so it they will become very inefficient over time. I had to capture queries using SQL Logging then send the trouble queries to my Oracle DBA team to optimize and "pin?" the execution path. It was a real pain but the performance of our Asset Management / CMDB operations did improve noticeably.
Tommy Morris CMDB Certified Specialist Director of IT Service Management [cid:[email protected]]<http://www.pinebreeze.com/> [email protected]<https://exg5.exghost.com/owa/redir.aspx?C=1d40184b0dc44e86917981c2ecb56197&URL=mailto%3atommy.morris%40pinebreeze.com> 817.727.1021 - mobile 972.899.2366 - office 972.899.2898 - fax From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Mike Worts Sent: Friday, December 21, 2012 6:43 AM To: [email protected] Subject: 30+ million rows in the CMDB ** Hi all, Let's say that we have a requirement to load 30million records into the CMDB and there is a good business justification. 1. Technically, do you think this is good practical? 2. How would it impact ITSM or CMDB performance? 3. Is anyone already doing this? My thought is that since all 30m records would have to go into BaseElement, there must be an impact to overall performance since BaseElement is queried on a regular basis. I assume that most queries will be indexed correctly, however, my concern is that one or two irregular queries on the form would have a serious impact. Thanks and Merry Christmas. Mike. Remedy ITSM 7.6.04 AIX 6.1 Oracle 11g This email, its content and any files transmitted with it are for the personal attention of the addressee only, any other usage or access is unauthorised. It may contain information which could be confidential or privileged. If you are not the intended addressee you may not copy, disclose, circulate or use it. If you have received this email in error, please destroy it and notify the sender by email. Any representations or commitments expressed in this email are subject to contract. Although we use reasonable endeavours to virus scan all sent emails, it is the responsibility of the recipient to ensure that they are virus free and we advise you to carry out your own virus check before opening any attachments. We cannot accept liability for any damage sustained as a result of software viruses. We reserve the right to monitor email communications through our networks. Arqiva Limited. Registered office: Crawley Court, Winchester, Hampshire SO21 2QA United Kingdom Registered in England and Wales number 2487597 _ARSlist: "Where the Answers Are" and have been for 20 years_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
<<inline: image001.png>>
