{"id":1613,"date":"2010-09-19T12:00:00","date_gmt":"2010-09-19T12:00:00","guid":{"rendered":"http:\/\/orcldoug.com\/blog\/?p=1613"},"modified":"2010-09-19T12:00:00","modified_gmt":"2010-09-19T12:00:00","slug":"alternative-pictures-demo","status":"publish","type":"post","link":"http:\/\/orcldoug.com\/blog\/2010\/09\/19\/alternative-pictures-demo\/","title":{"rendered":"Alternative Pictures Demo"},"content":{"rendered":"

Note – features in this post require the Diagnostics Pack license<\/em><\/p>\n

Not long after I’d finished the last post<\/a>, I realised I could reinforce the points I was making with a quick post showing another one of the example tests supplied with Swingbench – the Calling Circle (CC) application. Like the Sales Order Entry application, CC is a mixed read\/write test consisting of small transactions. As always, there’s more information at Dominic’s website<\/a>.<\/p>\n

One of the main differences to the SOE test is that the CC test consumes data so you need to generate a new set of data before each test using the supplied ccwizard utility. I won’t show you the entire workflow here but enough to give you a flavour of the process. The utility is the same one used to create the necessary CC schema in the first place but the option I’m looking for here is “Generate Data for Benchmark Run”.<\/p>\n

\"\"<\/p>\n

I’d already decided that my CC schema is populated with data for 1 million customers when I created it so I just need to specify the number of transactions the next test will be for. I happen to know that on my particular configuration, a 1000 transaction test will take around 5 minutes to run.<\/p>\n

\"\"<\/p>\n

I ran the test twice. I’ve highlighted the first run here in the Top Activity page.<\/p>\n

\"\"<\/p>\n

It should be clear that CC suffers significant log file sync waits on my particular test platform, just like the SOE test. Therefore I’ll regenerate the test data set, enable asynchronous commits and re-run the test. Here I’ve highlighted the second test run.<\/p>\n

\"\"<\/p>\n

As well as seeing a similar change in the activity profile according to the ASH samples (the log file sync activity has disappeared as has the LGWR System I\/O), there’s a significant difference to the SOE test. Because this test run is based on a specific workload volume, as defined by the size of the test data, rather than a fixed time period, the second test run completed more quickly than the first run. The activity only fills the 5 minute activity bar partially, rather than the first test which filled the whole bar.<\/p>\n

If you test a specific and limited workload volume it is much clearer from the Top Activity page which test is processing transactions more quickly, based on the Time axis. That’s why I didn’t pick this example the first time – it’s too obvious what’s going on!<\/p>\n","protected":false},"excerpt":{"rendered":"

Note – features in this post require the Diagnostics Pack license Not long after I’d finished the last post, I realised I could reinforce the points I was making with a quick post showing another one of the example tests supplied with Swingbench – the Calling Circle (CC) application. Like the Sales Order Entry application,… Continue reading Alternative Pictures Demo<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-1613","post","type-post","status-publish","format-standard","hentry","category-uncategorized","entry"],"jetpack_featured_media_url":"","jetpack-related-posts":[{"id":1404,"url":"http:\/\/orcldoug.com\/blog\/2008\/04\/19\/swingbench\/","url_meta":{"origin":1613,"position":0},"title":"Swingbench","date":"April 19, 2008","format":false,"excerpt":"A short post in praise of Swingbench. (There's much more information at that link.)Without this utility, demonstrating performance problems during the course would have been much more difficult so I owe Dominic Giles. It's simple to set up using one small configuration file to set up environment variables, a JVM\u2026","rel":"","context":"Similar post","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1428,"url":"http:\/\/orcldoug.com\/blog\/2008\/08\/14\/time-matters-an-infinite-capacity-for-waiting\/","url_meta":{"origin":1613,"position":1},"title":"Time Matters – An Infinite Capacity for Waiting*","date":"August 14, 2008","format":false,"excerpt":"When I was teaching the 10g Performance class at my last customer site, I remarked that the total number of seconds you see in the \"Top 5 Timed Events\" section of a Statspack or AWR report will often be greater than the total number of seconds between the snapshot intervals.\u2026","rel":"","context":"With 6 comments","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1417,"url":"http:\/\/orcldoug.com\/blog\/2008\/06\/08\/real-application-testing-and-more-relinking\/","url_meta":{"origin":1613,"position":2},"title":"Real Application Testing and more Relinking","date":"June 8, 2008","format":false,"excerpt":"I'd been thinking of blogging about the appearance of Real Application Testing in 10.2.0.4 since I noticed it post-upgrade, just before the course in Prague. Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - Production With the Partitioning, OLAP, Data Mining and Real Application Testing optionsIt looked like a\u2026","rel":"","context":"With 9 comments","img":{"alt_text":"","src":"\/serendipity\/uploads\/xRAT_7.png.pagespeed.ic.3MsqSFp_gp.png","width":350,"height":200},"classes":[]},{"id":1432,"url":"http:\/\/orcldoug.com\/blog\/2008\/09\/01\/time-matters-db-cpu\/","url_meta":{"origin":1613,"position":3},"title":"Time Matters – DB CPU","date":"September 1, 2008","format":false,"excerpt":"In his comment on the last post, John Beresniewicz mentioned the following property of DB CPU :-\"... 'DB time' fully contains 'DB CPU' and both are measured values (which means in particular that 'DB CPU' is not inflated by runq time)\"I'd like to talk about the end of that sentence\u2026","rel":"","context":"With 24 comments","img":{"alt_text":"","src":"https:\/\/i0.wp.com\/18.133.199.212\/wp-content\/uploads\/recovered\/DBCPU4.png?resize=350%2C200","width":350,"height":200},"classes":[]},{"id":868,"url":"http:\/\/orcldoug.com\/blog\/2006\/02\/05\/we-never-learn-do-we\/","url_meta":{"origin":1613,"position":4},"title":"We Never Learn, Do We?","date":"February 5, 2006","format":false,"excerpt":"I had an interesting day at work yesterday. We've run into major performance problems when upgrading a number of Production databases from 8i to 9i. How could that happen, when we've performed regression tests to ensure that the applications perform as well as or better than they did on 8i?Probably\u2026","rel":"","context":"With 5 comments","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1612,"url":"http:\/\/orcldoug.com\/blog\/2010\/09\/12\/that-pictures-demo-in-full\/","url_meta":{"origin":1613,"position":5},"title":"That Pictures demo in full","date":"September 12, 2010","format":false,"excerpt":"Note - features in this post require the Diagnostics Pack licenseWith so many potential technical posts in my pile, it was initially difficult to decide where to start again but I figured I should avoid the stats series until I'm back into the swing of things \ud83d\ude09 Instead I decided\u2026","rel":"","context":"With 6 comments","img":{"alt_text":"","src":"https:\/\/i0.wp.com\/18.133.199.212\/wp-content\/uploads\/recovered\/pic_demo9.png?resize=350%2C200","width":350,"height":200},"classes":[]}],"_links":{"self":[{"href":"http:\/\/orcldoug.com\/blog\/wp-json\/wp\/v2\/posts\/1613","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/orcldoug.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/orcldoug.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/orcldoug.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/orcldoug.com\/blog\/wp-json\/wp\/v2\/comments?post=1613"}],"version-history":[{"count":0,"href":"http:\/\/orcldoug.com\/blog\/wp-json\/wp\/v2\/posts\/1613\/revisions"}],"wp:attachment":[{"href":"http:\/\/orcldoug.com\/blog\/wp-json\/wp\/v2\/media?parent=1613"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/orcldoug.com\/blog\/wp-json\/wp\/v2\/categories?post=1613"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/orcldoug.com\/blog\/wp-json\/wp\/v2\/tags?post=1613"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}