It looked like a nice addition because, as others<\/a> have pointed out on their blogs<\/a>, it could prove very useful for capturing an application workload on 10g to test how it will work on 11g before upgrading. There’s a genuine business need for that. Then, having updated our first couple of test instances at work, I was reminded of the great care we take with license management at my current site (thanks, Tam) and, on closer inspection of the documentation<\/a> :-<\/p>\n The Oracle Real Application Testing license is required on both capture and replay systems<\/strong> for Database Replay and is charged by the total number of CPUs on those systems.<\/p><\/blockquote>\n Whilst I realise that’s a link to the 11g documentation, I don’t imagine for a second that Oracle won’t apply the same license rules to the 10.2.0.4 or 9.2.0.8 instances where the workload is captured. The additional cost is around \u00a35000 per processor.<\/p>\n So it looked like it was time for another relink operation<\/a>. One or two people have questioned our relinking of the product because it means we’re running on an executable that few sites are using and I have some sympathy with that view, but it’s far too easy for a DBA to think ‘Mmmm, I’ll try that out’ or not even be aware that they’re trying out an additional cost option. Oh, and if you think Oracle wouldn’t know about it, then how about this view?<\/p>\n I haven’t used workload capture on this instance yet, so I thought I’d give it a quick try. Interesting though it is to try this out for the first time, I’m going to keep this post short by referring you to another blog that shows how to use RAT via OEM DB Console<\/a>. Actually, my first attempt failed with the following error message.<\/p>\n OK, so let me fix that and try again<\/p>\n
\n(Note that this operation was performed on an AIX server. Windows is very different!) It didn’t take long to have a look in ins_rdbms.mk and search for ‘rat’. Sure enough, there are options to enable or disable RAT. So our new standard relink command included in our installation process is.<\/p>\n\/usr\/ccs\/bin\/make -f ins_rdbms.mk olap_off dm_off rat_off<\/strong> ioracle<\/pre>\n
TESTUSER@TEST1020> select name, detected_usages, currently_used,\n 2 first_usage_date, feature_info, last_sample_date,\n 3 sample_interval, description\n 4 from DBA_FEATURE_USAGE_STATISTICS\n 5 where name like 'Database Replay%'\n 6 \/\n\nNAME DETECTED_USAGES CURRE FIRST_USA\n---------------------------------------- --------------- ----- ---------\nFEATURE_INFO\n--------------------------------------------------------------------------------\nLAST_SAMP SAMPLE_INTERVAL\n--------- ---------------\nDESCRIPTION\n--------------------------------------------------------------------------------\n\nDatabase Replay: Workload Capture 0 FALSE\n\n20-MAY-08 604800\nDatabase Replay: Workload was ever captured.<\/pre>\n
SYSTEM@TEST1020> BEGIN dbms_workload_capture.start_capture('CAPTURE-TEST1020-20080608151755', \n 'DATA_FILE_DIR', 300, 'INCLUDE', FALSE); END;\n\n*\nERROR at line 1:\nORA-15591: cannot start capture because parameter \"PRE_11G_ENABLE_CAPTURE\" is\nnot enabled\nORA-06512: at \"SYS.DBMS_WORKLOAD_CAPTURE\", line 799\nORA-06512: at line 1<\/pre>\nSYS@TEST1020> alter system set pre_11g_enable_capture=true;\n\nSystem altered.<\/pre>\n
![\"\"](\"\/serendipity\/uploads\/xRAT_7.png.pagespeed.ic.3MsqSFp_gp.png\")
<\/p>\n