Jun 8: Real Application Testing and more Relinking
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.
It looked like a nice addition because, as others have pointed out on their blogs, 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 :-
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 £5000 per processor.
So it looked like it was time for another relink operation. (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.
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?
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. Actually, my first attempt failed with the following error message.
OK, so let me fix that and try again
Yes, it worked this time. Here's the Summary Screen and you can pick up the associated capture report from here. Note that this was a 5 minute/2 user test of the SOE benchmark that's supplied with Swingbench.
More to the point, maybe the feature usage view has been updated?
Perhaps not, but I expect it will be next time this sample is updated.
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - Production With the Partitioning, OLAP, Data Mining and Real Application Testing options
It looked like a nice addition because, as others have pointed out on their blogs, 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 :-
The Oracle Real Application Testing license is required on both capture and replay systems for Database Replay and is charged by the total number of CPUs on those systems.
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 £5000 per processor.
So it looked like it was time for another relink operation. (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.
/usr/ccs/bin/make -f ins_rdbms.mk olap_off dm_off rat_off ioracle
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?
TESTUSER@TEST1020> select name, detected_usages, currently_used, 2 first_usage_date, feature_info, last_sample_date, 3 sample_interval, description 4 from DBA_FEATURE_USAGE_STATISTICS 5 where name like 'Database Replay%' 6 / NAME DETECTED_USAGES CURRE FIRST_USA ---------------------------------------- --------------- ----- --------- FEATURE_INFO -------------------------------------------------------------------------------- LAST_SAMP SAMPLE_INTERVAL --------- --------------- DESCRIPTION -------------------------------------------------------------------------------- Database Replay: Workload Capture 0 FALSE 20-MAY-08 604800 Database Replay: Workload was ever captured.
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. Actually, my first attempt failed with the following error message.
SYSTEM@TEST1020> BEGIN dbms_workload_capture.start_capture('CAPTURE-TEST1020-20080608151755',
'DATA_FILE_DIR', 300, 'INCLUDE', FALSE); END;
*
ERROR at line 1:
ORA-15591: cannot start capture because parameter "PRE_11G_ENABLE_CAPTURE" is
not enabled
ORA-06512: at "SYS.DBMS_WORKLOAD_CAPTURE", line 799
ORA-06512: at line 1OK, so let me fix that and try again
SYS@TEST1020> alter system set pre_11g_enable_capture=true; System altered.
Yes, it worked this time. Here's the Summary Screen and you can pick up the associated capture report from here. Note that this was a 5 minute/2 user test of the SOE benchmark that's supplied with Swingbench.
More to the point, maybe the feature usage view has been updated?
SYS@TEST1020> select name, detected_usages, currently_used, 2 first_usage_date, feature_info, last_sample_date, 3 sample_interval, description 4 from DBA_FEATURE_USAGE_STATISTICS 5 where name like 'Database Replay%'; NAME DETECTED_USAGES CURRE FIRST_USA ---------------------------------------- --------------- ----- --------- FEATURE_INFO -------------------------------------------------------------------------------- LAST_SAMP SAMPLE_INTERVAL --------- --------------- DESCRIPTION -------------------------------------------------------------------------------- Database Replay: Workload Capture 0 FALSE 08-JUN-08 604800 Database Replay: Workload was ever captured.
Perhaps not, but I expect it will be next time this sample is updated.
Trackbacks
Trackback specific URI for this entry
No Trackbacks
