| SQL Id | SQL Text |
|---|
| 00tm61bfvkww3 |
DECLARE l_APPLICATION VARCHAR2(240); l_PROGRAM VARCHAR2(240); l_DESCRIPTION VARCHAR2(240); l_START_TIME VARCHAR2(240); l_SUB_REQUEST BOOLEAN := FALSE; l_ARGUMENT1 VARCHAR2(240); l_ARGUMENT2 VARCHAR2(240); l_ARGUMENT3 VARCHAR2(240); l_ARGUMENT4 VARCHAR2(240); l_ARGUMENT5 VARCHAR2(240); l_ARGUMENT6 VARCHAR2(240); l_ARGUMENT7 VARCHAR2(240); -- To run for 2500 set l_ARGUMENT7 to 3298 -- To run for 5000 set l_ARGUMENT7 to 3299 -- To run for 10000 set l_ARGUMENT7 to 3300 -- To run for 50000 set l_ARGUMENT7 to 3301 -- To run for 250000 set l_ARGUMENT7 to null (leave it undefined) l_ARGUMENT8 VARCHAR2(240); l_ARGUMENT9 VARCHAR2(240); l_ARGUMENT10 VARCHAR2(240); l_ARGUMENT11 VARCHAR2(240); l_ARGUMENT12 VARCHAR2(240); l_payroll_name VARCHAR2(240):= LTRIM(RTRIM('01Semi-Month')); l_user_name VARCHAR2(240):= LTRIM(RTRIM('01BM_USER')); l_responsibility_name VARCHAR2(240):= LTRIM(RTRIM('01BM_US SHRMS Manager')); l_start_date VARCHAR2(240):= LTRIM(RTRIM('2007/03/01')); l_end_date VARCHAR2(240):= LTRIM(RTRIM('2007/03/15')); l_employees VARCHAR2(240):= LTRIM(RTRIM('250000')); l_success BOOLEAN; l_boolean BOOLEAN; l_req_id number; l_err VARCHAR2(2000); l_pay_thrd VARCHAR2(240) := '32'; l_prepay_thrd VARCHAR2(240) := '32'; l_archive_thrd VARCHAR2(240) := '32'; l_nacha_thrd VARCHAR2(240) := '16'; l_chkwrite_thrd VARCHAR2(240) := '20'; l_costing_thrd VARCHAR2(240) := '32'; concurrent_program_failure EXCEPTION; -- perfdata: variables l_snapshot_id number := 0; --Cursor to get Payroll Id CURSOR c_payroll_id(p_payroll_name IN VARCHAR2) IS SELECT payroll_id, business_group_id FROM pay_all_payrolls_f WHERE payroll_name = p_payroll_name; l_payroll_id pay_all_payrolls.payroll_id%TYPE; l_business_group_id pay_all_payrolls.business_group_id%TYPE; invalid_payroll_id EXCEPTION; --Cursor to get consolidation set id CURSOR c_consolidation_set_id(p_payroll_id IN NUMBER) IS SELECT c.consolidation_set_id FROM pay_consolidation_sets c , pay_all_payrolls_f p WHERE p.consolidation_set_id = c.consolidation_set_id AND p.payroll_id = p_payroll_id; l_consolidation_set_id pay_consolidation_sets.consolidation_set_id%TYPE; invalid_consolidation_set_id EXCEPTION; CURSOR c_run_type_id IS SELECT run_type_id FROM pay_run_types_f WHERE legislation_code='US' AND run_method = 'C' AND shortname='REGULAR'; l_run_type_id pay_run_types_f.run_type_id%TYPE; invalid_run_type_id EXCEPTION; --Cursor to get User ID CURSOR c_user_id(p_user_name IN VARCHAR2) IS SELECT user_id FROM fnd_user WHERE user_name = p_user_name; l_user_id fnd_user.user_id%TYPE; invalid_user EXCEPTION; --Cursor to get responsibility id CURSOR c_resp_id(p_responsibility_name IN VARCHAR2) IS SELECT responsibility_id, application_id FROM fnd_responsibility_tl WHERE responsibility_name = p_responsibility_name; l_application_id fnd_responsibility_tl.application_id%TYPE; l_responsibility_id fnd_responsibility_tl.responsibility_id%TYPE; invalid_responsibility EXCEPTION; --Cursor to get Org Payment Type id for NACHA(MT)/Check(CH) CURSOR c_payment_type_id(p_payment_type_name IN VARCHAR2, p_category IN VARCHAR2) IS SELECT payment_type_id FROM pay_payment_types WHERE territory_code = 'US' AND category = p_category AND payment_type_name = p_payment_type_name; l_payment_type_id pay_payment_types.payment_type_id%TYPE; invalid_payment_type_id EXCEPTION; --Cursor to get Org Payment Method for the NACHA, Business Group and Payroll CURSOR c_org_pay_method_id(p_payment_type_id IN NUMBER , p_business_group_id IN NUMBER , p_payroll_id IN NUMBER) IS SELECT popmf.org_payment_method_id FROM pay_org_payment_methods_f popmf , pay_org_pay_method_usages_f popmuf WHERE payment_type_id = p_payment_type_id AND business_group_id = p_business_group_id AND popmf.org_payment_method_id = popmuf.org_payment_method_id AND popmuf.payroll_id = p_payroll_id; l_org_payment_method_id pay_org_payment_methods_f.org_payment_method_id%TYPE; invalid_org_payment_method_id EXCEPTION; --Cursor to get Org Payment Method for the NACHA, Business Group, Payroll and Ch
eck CURSOR c_org_pay_method_id1(p_payment_type_id IN NUMBER , p_business_group_id IN NUMBER , p_payroll_id IN NUMBER , p_org_payment_method_name IN VARCHAR2) IS SELECT popmf.org_payment_method_id FROM pay_org_payment_methods_f popmf , pay_org_pay_method_usages_f popmuf WHERE payment_type_id = p_payment_type_id AND business_group_id = p_business_group_id AND popmf.org_payment_method_id = popmuf.org_payment_method_id AND popmuf.payroll_id = p_payroll_id AND popmf.org_payment_method_name = p_org_payment_method_name; l_org_payment_method_id1 pay_org_payment_methods_f.org_payment_method_id%TYPE; invalid_org_payment_method_id1 EXCEPTION; CURSOR c_payroll(p_request_id IN NUMBER) IS SELECT action_status FROM pay_payroll_actions WHERE request_id = p_request_id; l_action_status pay_payroll_actions.action_status%TYPE; PROCEDURE get_status(p_request_id IN NUMBER) IS CURSOR c_payroll(p_request_id IN NUMBER) IS SELECT action_status FROM pay_payroll_actions WHERE request_id = p_request_id; l_action_status pay_payroll_actions.action_status%TYPE; data_found exception; BEGIN -- dbms_output.put_line('User Name -> '||l_user_name); -- dbms_output.put_line('Respon Name -> '||l_responsibility_name); -- dbms_output.put_line('payroll Name -> '||l_payroll_name); -- dbms_output.put_line('Start Date -> '||l_start_date); -- dbms_output.put_line('End Date -> '||l_end_date); -- dbms_output.put_line('Employees -> '||l_employees); OPEN c_payroll(p_request_id); FETCH c_payroll INTO l_action_status; IF c_payroll%NOTFOUND THEN l_action_status := NULL; END IF; CLOSE c_payroll; IF l_action_status NOT IN ('C', 'E') OR l_action_status IS NULL THEN -- dbms_output.put_line('sleeping .....'); dbms_lock.sleep(30); get_status(p_request_id); ELSE raise data_found; END IF; EXCEPTION WHEN data_found THEN NULL; END get_status; BEGIN OPEN c_user_id(l_user_name); FETCH c_user_id INTO l_user_id; IF c_user_id%NOTFOUND THEN RAISE invalid_user; END IF; CLOSE c_user_id; OPEN c_resp_id(l_responsibility_name); FETCH c_resp_id INTO l_responsibility_id, l_application_id; IF c_resp_id%NOTFOUND THEN RAISE invalid_responsibility; END IF; CLOSE c_resp_id; OPEN c_payroll_id(l_payroll_name); FETCH c_payroll_id INTO l_payroll_id, l_business_group_id; IF c_payroll_id%NOTFOUND THEN RAISE invalid_payroll_id; END IF; CLOSE c_payroll_id; OPEN c_consolidation_set_id(l_payroll_id); FETCH c_consolidation_set_id INTO l_consolidation_set_id; IF c_consolidation_set_id%NOTFOUND THEN RAISE invalid_consolidation_set_id; END IF; OPEN c_run_type_id; FETCH c_run_type_id INTO l_run_type_id; IF c_run_type_id%NOTFOUND THEN RAISE invalid_run_type_id; END IF; CLOSE c_run_type_id; --Initialize for concurrent program fnd_global.apps_initialize( user_id => l_user_id , resp_id => l_responsibility_id , resp_appl_id => l_application_id); l_snapshot_id := dbms_workload_repository.create_snapshot(); trackrun('payroll', 'start', l_snapshot_id); update pay_action_parameters set parameter_value = l_pay_thrd where parameter_name = 'THREADS'; commit; --Submit the Payroll Process -- Define the number of employees to run Payroll for : IF l_employees = '2500' then l_ARGUMENT7 := 3298; ELSIF l_employees = '5000' then l_ARGUMENT7 := 3299; ELSIF l_employees = '10000' then l_ARGUMENT7 := 3300; ELSIF l_employees = '50000' then l_ARGUMENT7 := 3301; ELSIF l_employees = '250000' then l_ARGUMENT7 := null; END IF; l_req_id := FND_REQUEST.SUBMIT_REQUEST( APPLICATION => 'PAY' , PROGRAM => 'RUNGEN' , DESCRIPTION => 'Test' , START_TIME => l_START_TIME , SUB_REQUEST => l_SUB_REQUEST , ARGUMENT1 => 'RUN' , ARGUMENT2 => l_payroll_id , ARGUMENT3 => l_consolidation_set_id , ARGUMENT4 => l_start_date --Date Earned , ARGUMENT5 => l_start_date --Date Paid , ARGUMENT6 => l_ARGUMENT6 --Assignment Set , ARGUMENT7 => l_ARGUMENT7 --Element Set , ARGUMENT8 => l_run_type_id , ARGUMENT9 => l_ARGUMENT9 , ARGUMENT10 => l_ARGUMENT10 ); dbms_output.put_line('Request ID for P
ayroll Process -> '||to_char(l_req_id)); dbms_output.put_line('Payroll Process Starting Time -> '||to_char(SYSDATE, 'DD-MON-YYYY HH24:MI:SS')); IF l_req_id = 0 THEN l_err := fnd_message.get; dbms_output.put_line(l_err); ELSE -- dbms_output.put_line('commiting...'); COMMIT; --Commit, otherwise program is not submitted END IF; --dbms_output.put_line('sleeping .....in main call'); --dbms_lock.sleep(60); get_status(l_req_id+1); --Recursive call to wait for the completion of process --Test whether the program exited in Error. OPEN c_payroll(l_req_id); FETCH c_payroll INTO l_action_status; CLOSE c_payroll; IF l_action_status = 'E' THEN RAISE concurrent_program_failure; END IF; l_snapshot_id := dbms_workload_repository.create_snapshot(); trackrun('payroll', 'end', l_snapshot_id); trackrun('prepay', 'start', l_snapshot_id); --Start of PrePayments update pay_action_parameters set parameter_value = l_prepay_thrd where parameter_name = 'THREADS'; commit; --Submit the PrePayments l_req_id := FND_REQUEST.SUBMIT_REQUEST( APPLICATION => 'PAY' --l_APPLICATION , PROGRAM => 'PREPAY' --l_PROGRAM , DESCRIPTION => 'Test' --l_DESCRIPTION , START_TIME => l_START_TIME , SUB_REQUEST => l_SUB_REQUEST , ARGUMENT1 => 'PREPAY' --Process Name , ARGUMENT2 => l_payroll_id --Payroll , ARGUMENT3 => l_consolidation_set_id --Consolidation Set , ARGUMENT4 => l_start_date --Start Date , ARGUMENT5 => l_end_date --End Date , ARGUMENT6 => NULL --Payment Method Override , ARGUMENT7 => NULL --Action Parameter Group ); dbms_output.put_line('Payroll Process Stop Time -> '||to_char(SYSDATE, 'DD-MON-YYYY HH24:MI:SS')); dbms_output.put_line('Request ID for PrePayments-> '||to_char(l_req_id)); dbms_output.put_line('Prepayments Process Start Time -> '||to_char(SYSDATE, 'DD-MON-YYYY HH24:MI:SS')); IF l_req_id = 0 THEN l_err := fnd_message.get; dbms_output.put_line(l_err); ELSE -- dbms_output.put_line('commiting...'); COMMIT; --Commit, otherwise program is not submitted END IF; --dbms_output.put_line('sleeping .....in main call'); --dbms_lock.sleep(60); get_status(l_req_id); --Recursive call to wait for the completion of process --Test whether the program exited in Error. OPEN c_payroll(l_req_id); FETCH c_payroll INTO l_action_status; CLOSE c_payroll; IF l_action_status = 'E' THEN RAISE concurrent_program_failure; END IF; --End of PrePayments l_snapshot_id := dbms_workload_repository.create_snapshot(); trackrun('prepay', 'end', l_snapshot_id); trackrun('archive', 'start', l_snapshot_id); update pay_action_parameters set parameter_value = l_archive_thrd where parameter_name = 'THREADS'; --update fnd_concurrent_programs --set enable_trace = 'Y' --where concurrent_program_name in ('PAYUSXFR', 'PYUSLV'); commit; --Start of External Process Archive l_req_id := FND_REQUEST.SUBMIT_REQUEST( APPLICATION => 'PAY' , PROGRAM => 'PAYUSXFR' , DESCRIPTION => 'Test' , START_TIME => l_START_TIME , SUB_REQUEST => l_SUB_REQUEST , ARGUMENT1 => 'ARCHIVE' , ARGUMENT2 => 'XFR_INTERFACE' , ARGUMENT3 => 'FED' , ARGUMENT4 => l_start_date , ARGUMENT5 => l_end_date , ARGUMENT6 => 'RT' , ARGUMENT7 => l_business_group_id , ARGUMENT8 => 'XFR_INTERFACE' , ARGUMENT9 => 'XFR_INTERFACE' , ARGUMENT10 => l_payroll_id , ARGUMENT11 => l_consolidation_set_id , ARGUMENT12 => '1' , ARGUMENT13 => 'TRANSFER_PAYROLL_ID='||l_payroll_id||'' , ARGUMENT14 => 'TRANSFER_CONSOLIDATION_SET_ID='||l_consolidation_set_id||'' ); dbms_output.put_line('Prepayments Process Stop Time -> '||to_char(SYSDATE, 'DD-MON-YYYY HH24:MI:SS')); dbms_output.put_line('Request ID for External Archive Process -> '||to_char(l_req_id)); dbms_output.put_line('External Archive Process Start Time -> '||to_char(SYSDATE, 'DD-MON-YYYY HH24:MI:SS')); IF l_req_id = 0 THEN l_err := fnd_message.get; dbms_output.put_line(l_err); ELSE -- dbms_output.put_line('commiting...'); COMMIT; --Commit, otherwise program i
s not submitted END IF; get_status(l_req_id); --Test whether the program exited in Error. OPEN c_payroll(l_req_id); FETCH c_payroll INTO l_action_status; CLOSE c_payroll; IF l_action_status = 'E' THEN RAISE concurrent_program_failure; END IF; --End of External Process Archive l_snapshot_id := dbms_workload_repository.create_snapshot(); trackrun('archive', 'end', l_snapshot_id); trackrun('nacha', 'start', l_snapshot_id); update pay_action_parameters set parameter_value = l_nacha_thrd where parameter_name = 'THREADS'; update fnd_concurrent_programs set enable_trace = 'N' where concurrent_program_name in ('PAYUSXFR', 'PYUSLV'); commit; --Start of NACHA OPEN c_payment_type_id('NACHA', 'MT'); FETCH c_payment_type_id INTO l_payment_type_id; IF c_payment_type_id%NOTFOUND THEN RAISE invalid_payment_type_id; END IF; CLOSE c_payment_type_id; OPEN c_org_pay_method_id(l_payment_type_id, l_business_group_id, l_payroll_id); FETCH c_org_pay_method_id INTO l_org_payment_method_id; CLOSE c_org_pay_method_id; --begin dbms_workload_repository.create_snapshot(); end; l_req_id := FND_REQUEST.SUBMIT_REQUEST( APPLICATION => 'PAY' , PROGRAM => 'NACHA' , DESCRIPTION => 'Test' , START_TIME => l_START_TIME , SUB_REQUEST => l_SUB_REQUEST , ARGUMENT1 => 'MAGTAPE' , ARGUMENT2 => l_payroll_id , ARGUMENT3 => l_consolidation_set_id , ARGUMENT4 => l_start_date , ARGUMENT5 => l_end_date , ARGUMENT6 => l_payment_type_id --Payment Type Name , ARGUMENT7 => l_org_payment_method_id --Org Pay Method Id , ARGUMENT8 => NULL , ARGUMENT9 => '0' , ARGUMENT10 => '1' , ARGUMENT11 => '1' , ARGUMENT12 => 'FILE_ID_MODIFIER=0' , ARGUMENT13 => NULL , ARGUMENT14 => NULL , ARGUMENT15 => NULL ); --begin dbms_workload_repository.create_snapshot(); end; dbms_output.put_line('External Archive Process Stop Time -> '||to_char(SYSDATE, 'DD-MON-YYYY HH24:MI:SS')); dbms_output.put_line('Request ID for NACHA-> '||to_char(l_req_id)); dbms_output.put_line('NACHA Process Start Time -> '||to_char(SYSDATE, 'DD-MON-YYYY HH24:MI:SS')); IF l_req_id = 0 THEN l_err := fnd_message.get; dbms_output.put_line(l_err); ELSE -- dbms_output.put_line('commiting...'); COMMIT; --Commit, otherwise program is not submitted END IF; --dbms_output.put_line('sleeping .....in main call'); --dbms_lock.sleep(60); get_status(l_req_id); --Recursive call to wait for the completion of process --Test whether the program exited in Error. OPEN c_payroll(l_req_id); FETCH c_payroll INTO l_action_status; CLOSE c_payroll; IF l_action_status = 'E' THEN RAISE concurrent_program_failure; END IF; --End of NACHA l_snapshot_id := dbms_workload_repository.create_snapshot(); trackrun('nacha', 'end', l_snapshot_id); trackrun('checkwriter', 'start', l_snapshot_id); --Start of Check Writer update pay_action_parameters set parameter_value = l_chkwrite_thrd where parameter_name = 'THREADS'; commit; OPEN c_payment_type_id('Check', 'CH'); FETCH c_payment_type_id INTO l_payment_type_id; IF c_payment_type_id%NOTFOUND THEN RAISE invalid_payment_type_id; END IF; CLOSE c_payment_type_id; OPEN c_org_pay_method_id1(l_payment_type_id, l_business_group_id, l_payroll_id, 'Check'); FETCH c_org_pay_method_id1 INTO l_org_payment_method_id1; CLOSE c_org_pay_method_id1; l_req_id := FND_REQUEST.SUBMIT_REQUEST( APPLICATION => 'PAY' , PROGRAM => 'CHECK_WRITER' , DESCRIPTION => 'Test' , START_TIME => l_START_TIME , SUB_REQUEST => l_SUB_REQUEST , ARGUMENT1 => 'CHEQUE' , ARGUMENT2 => l_payroll_id , ARGUMENT3 => l_consolidation_set_id , ARGUMENT4 => l_start_date , ARGUMENT5 => l_end_date , ARGUMENT6 => l_payment_type_id , ARGUMENT7 => l_org_payment_method_id1 , ARGUMENT8 => 'DEFAULT' , ARGUMENT9 => 'PAYUSCDA' , ARGUMENT10 => '1' , ARGUMENT11 => NULL , ARGUMENT12 => NULL , ARGUMENT13 => NULL , ARGUMENT14 => NULL ); dbms_output.put_line('NACHA Process Stop Time -> '||to_char(SYSDATE, 'DD-MON-YYYY
HH24:MI:SS')); dbms_output.put_line('Request ID for Check Writer-> '||to_char(l_req_id)); dbms_output.put_line('Check Writer Process Start Time -> '||to_char(SYSDATE, 'DD-MON-YYYY HH24:MI:SS')); IF l_req_id = 0 THEN l_err := fnd_message.get; dbms_output.put_line(l_err); ELSE -- dbms_output.put_line('commiting...'); COMMIT; --Commit, otherwise program is not submitted END IF; --dbms_output.put_line('sleeping .....in main call'); --dbms_lock.sleep(60); get_status(l_req_id + 1); --Recursive call to wait for the completion of process --Test whether the program exited in Error. OPEN c_payroll(l_req_id); FETCH c_payroll INTO l_action_status; CLOSE c_payroll; IF l_action_status = 'E' THEN RAISE concurrent_program_failure; END IF; --End of Check Writer l_snapshot_id := dbms_workload_repository.create_snapshot(); trackrun('checkwriter', 'end', l_snapshot_id); trackrun('costing', 'start', l_snapshot_id); --Start of Costing update pay_action_parameters set parameter_value = l_costing_thrd where parameter_name = 'THREADS'; commit; l_req_id := FND_REQUEST.SUBMIT_REQUEST( APPLICATION => 'PAY' , PROGRAM => 'COSTING' , DESCRIPTION => 'Test' , START_TIME => l_START_TIME , SUB_REQUEST => l_SUB_REQUEST , ARGUMENT1 => 'COSTING' , ARGUMENT2 => l_payroll_id , ARGUMENT3 => l_consolidation_set_id , ARGUMENT4 => l_start_date , ARGUMENT5 => l_end_date , ARGUMENT6 => NULL ); dbms_output.put_line('Check Writer Process Stop Time -> '||to_char(SYSDATE, 'DD-MON-YYYY HH24:MI:SS')); dbms_output.put_line('Request ID for Costing-> '||to_char(l_req_id)); dbms_output.put_line('Costing Process Start Time -> '||to_char(SYSDATE, 'DD-MON-YYYY HH24:MI:SS')); IF l_req_id = 0 THEN l_err := fnd_message.get; dbms_output.put_line(l_err); ELSE -- dbms_output.put_line('commiting...'); COMMIT; --Commit, otherwise program is not submitted END IF; --dbms_output.put_line('sleeping .....in main call'); --dbms_lock.sleep(60); get_status(l_req_id); --Recursive call to wait for the completion of process --Test whether the program exited in Error. OPEN c_payroll(l_req_id); FETCH c_payroll INTO l_action_status; CLOSE c_payroll; IF l_action_status = 'E' THEN RAISE concurrent_program_failure; END IF; --End of Costing l_snapshot_id := dbms_workload_repository.create_snapshot(); trackrun('costing', 'end', l_snapshot_id); dbms_output.put_line('Costing Process Stop Time -> '||to_char(SYSDATE, 'DD-MON-YYYY HH24:MI:SS')); dbms_output.put_line('User Name -> '||l_user_name); dbms_output.put_line('Respon Name -> '||l_responsibility_name); dbms_output.put_line('payroll Name -> '||l_payroll_name); dbms_output.put_line('Start Date -> '||l_start_date); dbms_output.put_line('End Date -> '||l_end_date); dbms_output.put_line('Employees No -> '||l_employees); EXCEPTION WHEN concurrent_program_failure THEN RAISE; IF c_payroll%ISOPEN THEN CLOSE c_payroll; END IF; END; |
| 01pkua627ktjk | SELECT fnd_number.number_to_canonical(nvl(sum(fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale), 0)) FROM /* Assignment within Government Reporting Entity */ pay_run_result_values TARGET , pay_balance_feeds_f FEED , pay_run_results RR , pay_assignment_actions ASSACT , pay_assignment_actions BAL_ASSACT , pay_payroll_actions PACT , pay_payroll_actions BACT where BAL_ASSACT.assignment_action_id = :ASSIGNMENT_ACTION_ID and BAL_ASSACT.payroll_action_id = BACT.payroll_action_id and FEED.balance_type_id = :U1 + decode(TARGET.INPUT_VALUE_ID, null, 0, 0) and FEED.input_value_id = TARGET.input_value_id and nvl(TARGET.result_value, '0') != '0' and TARGET.run_result_id = RR.run_result_id and RR.assignment_action_id = ASSACT.assignment_action_id and ASSACT.payroll_action_id = PACT.payroll_action_id and PACT.effective_date between FEED.effective_start_date and FEED.effective_end_date and RR.status in ('P', 'PA') and ASSACT.action_sequence <= BAL_ASSACT.action_sequence and ASSACT.assignment_id = BAL_ASSACT.assignment_id and ASSACT.tax_unit_id = :TAX_UNIT_ID /* Year To Date */ and PACT.effective_date >= trunc(BACT.effective_date, 'Y') |
| 02k10jzw8c495 | SELECT INTLK.LOCKING_ACTION_ID FROM PAY_ACTION_INTERLOCKS INTLK, PAY_ASSIGNMENT_ACTIONS PAA, PAY_PAYROLL_ACTIONS PPA WHERE INTLK.LOCKED_ACTION_ID = :B1 AND INTLK.LOCKING_ACTION_ID = PAA.ASSIGNMENT_ACTION_ID AND PAA.PAYROLL_ACTION_ID = PPA.PAYROLL_ACTION_ID AND PPA.ACTION_TYPE IN ('P', 'U') AND PAA.SOURCE_ACTION_ID IS NULL |
| 0k8522rmdzg4k | select privilege# from sysauth$ where (grantee#=:1 or grantee#=1) and privilege#>0 |
| 0wmwsjy9kd92f | SELECT PROFILE_OPTION_ID, APPLICATION_ID, SITE_ENABLED_FLAG , APP_ENABLED_FLAG , RESP_ENABLED_FLAG , USER_ENABLED_FLAG, ORG_ENABLED_FLAG , SERVER_ENABLED_FLAG, SERVERRESP_ENABLED_FLAG, HIERARCHY_TYPE, USER_CHANGEABLE_FLAG FROM FND_PROFILE_OPTIONS WHERE PROFILE_OPTION_NAME = :B1 AND START_DATE_ACTIVE <= SYSDATE AND NVL(END_DATE_ACTIVE, SYSDATE) >= SYSDATE |
| 1cq3qr774cu45 | insert into WRH$_IOSTAT_FILETYPE (snap_id, dbid, instance_number, filetype_id, small_read_megabytes, small_write_megabytes, large_read_megabytes, large_write_megabytes, small_read_reqs, small_write_reqs, small_sync_read_reqs, large_read_reqs, large_write_reqs, small_read_servicetime, small_write_servicetime, small_sync_read_latency, large_read_servicetime, large_write_servicetime, retries_on_error) (select :snap_id, :dbid, :instance_number, filetype_id, sum(small_read_megabytes) small_read_megabytes, sum(small_write_megabytes) small_write_megabytes, sum(large_read_megabytes) large_read_megabytes, sum(large_write_megabytes) large_write_megabytes, sum(small_read_reqs) small_read_reqs, sum(small_write_reqs) small_write_reqs, sum(small_sync_read_reqs) small_sync_read_reqs, sum(large_read_reqs) large_read_reqs, sum(large_write_reqs) large_write_reqs, sum(small_read_servicetime) small_read_servicetime, sum(small_write_servicetime) small_write_servicetime, sum(small_sync_read_latency) small_sync_read_latency, sum(large_read_servicetime) large_read_servicetime, sum(large_write_servicetime) large_write_servicetime, sum(retries_on_error) retries_on_error from v$iostat_file group by filetype_id) |
| 1v717nvrhgbn9 | SELECT USER FROM SYS.DUAL |
| 2450j0nxcnga5 | declare sql_dummy1 boolean;begin fnd_profile.get_specific(:name, :userid, :respid, :applid, :val, sql_dummy1, :org_id, :server_id);end; |
| 2dqtvtdcud8mb | SELECT ACTION_INFORMATION_ID, EFFECTIVE_DATE, OBJECT_VERSION_NUMBER FROM PAY_ACTION_INFORMATION WHERE ACTION_CONTEXT_ID = :B2 AND ACTION_CONTEXT_TYPE = 'AAP' AND ASSIGNMENT_ID = :B1 AND ACTION_INFORMATION_CATEGORY = 'EMPLOYEE DETAILS' |
| 36z3h9rgkd8aa | begin hrassact.update_action_sequence (:aa_id, :itpflg); end; |
| 3ktacv9r56b51 | select owner#, name, namespace, remoteowner, linkname, p_timestamp, p_obj#, nvl(property, 0), subname, type#, d_attrs from dependency$ d, obj$ o where d_obj#=:1 and p_obj#=obj#(+) order by order# |
| 43w0r9122v7jm | select max(bytes) from dba_segments |
| 4ds53shhfcynn | declare begin hr_pre_pay.do_prepayment(:p1, :p2, :p3, :p4, :5, :p6:p6ind, :p7); end; |
| 4f5mjr4hnaz3u | declare begin pay_archive.process_employee(:asg_action); end; |
| 4gz4b2bh1fs14 | SELECT CONTEXT_ID, SEQUENCE_NO FROM FF_ROUTE_CONTEXT_USAGES WHERE ROUTE_ID = :B1 ORDER BY SEQUENCE_NO |
| 51hgwky1770tq | begin owa_vpd_ctx.set_ctx(1); owa_vpd_ctx.set_user_ctx(user); end; |
| 58xbrd1qqhkr7 | SELECT PBG.LEGISLATION_CODE FROM PER_BUSINESS_GROUPS_PERF PBG WHERE PBG.BUSINESS_GROUP_ID = :B1 |
| 5p88n2zhuqfd9 | SELECT PPA.EFFECTIVE_DATE, PPA.BUSINESS_GROUP_ID, PPA.PAYROLL_ID, PPA.ACTION_TYPE FROM PAY_PAYROLL_ACTIONS PPA, PAY_ASSIGNMENT_ACTIONS PAA WHERE PAA.ASSIGNMENT_ACTION_ID = :B1 AND PAA.PAYROLL_ACTION_ID = PPA.PAYROLL_ACTION_ID |
| 5sfm6rppc4y8x | BEGIN pay_us_action_arch.action_archive_data(:aactid, :l_effective_date); END; |
| 5ts0t88sz97xs | SELECT PDB.DEFINED_BALANCE_ID FROM PAY_DEFINED_BALANCES PDB, PAY_BALANCE_DIMENSIONS PBD WHERE PDB.BALANCE_TYPE_ID = :B3 AND PBD.DATABASE_ITEM_SUFFIX = :B2 AND PBD.BALANCE_DIMENSION_ID = PDB.BALANCE_DIMENSION_ID AND ((PBD.LEGISLATION_CODE = :B1 AND PBD.BUSINESS_GROUP_ID IS NULL) OR (PBD.LEGISLATION_CODE IS NULL AND PBD.BUSINESS_GROUP_ID IS NOT NULL)) |
| 6500rnmy4f88w | SELECT PAP.ACCRUAL_PLAN_ID, PAP.ACCRUAL_PLAN_ELEMENT_TYPE_ID FROM PAY_ACCRUAL_PLANS PAP, PAY_ELEMENT_LINKS_F PEL, PAY_ELEMENT_ENTRIES_F PEE WHERE PAP.ACCRUAL_CATEGORY = :B3 AND PEL.ELEMENT_TYPE_ID= PAP.ACCRUAL_PLAN_ELEMENT_TYPE_ID AND :B1 BETWEEN PEL.EFFECTIVE_START_DATE AND PEL.EFFECTIVE_END_DATE AND PEE.ELEMENT_LINK_ID = PEL.ELEMENT_LINK_ID AND PEE.ASSIGNMENT_ID = :B2 AND :B1 BETWEEN PEE.EFFECTIVE_START_DATE AND PEE.EFFECTIVE_END_DATE |
| 6pb42jb41fb6w | insert into pay_costs (cost_id, assignment_action_id, input_value_id, run_result_id, cost_allocation_keyflex_id, balance_or_cost, costed_value, debit_or_credit, distributed_input_value_id, distributed_run_result_id, source_id, transfer_to_gl_flag) values (pay_costs_s.nextval , :b1, :b2, :b3, :b4, :b5, fnd_number.canonical_to_number(:b6), :b7, :b8:b9, :b10:b11, :b12:b13, :b14:b15) |
| 6v07302134wyf | INSERT INTO PAY_ACTION_INFORMATION (ACTION_INFORMATION_ID , ACTION_CONTEXT_ID , ACTION_CONTEXT_TYPE , TAX_UNIT_ID , JURISDICTION_CODE , SOURCE_ID , SOURCE_TEXT , TAX_GROUP , OBJECT_VERSION_NUMBER , EFFECTIVE_DATE , ASSIGNMENT_ID , ACTION_INFORMATION_CATEGORY , ACTION_INFORMATION1 , ACTION_INFORMATION2 , ACTION_INFORMATION3 , ACTION_INFORMATION4 , ACTION_INFORMATION5 , ACTION_INFORMATION6 , ACTION_INFORMATION7 , ACTION_INFORMATION8 , ACTION_INFORMATION9 , ACTION_INFORMATION10 , ACTION_INFORMATION11 , ACTION_INFORMATION12 , ACTION_INFORMATION13 , ACTION_INFORMATION14 , ACTION_INFORMATION15 , ACTION_INFORMATION16 , ACTION_INFORMATION17 , ACTION_INFORMATION18 , ACTION_INFORMATION19 , ACTION_INFORMATION20 , ACTION_INFORMATION21 , ACTION_INFORMATION22 , ACTION_INFORMATION23 , ACTION_INFORMATION24 , ACTION_INFORMATION25 , ACTION_INFORMATION26 , ACTION_INFORMATION27 , ACTION_INFORMATION28 , ACTION_INFORMATION29 , ACTION_INFORMATION30 ) VALUES (:B42 , :B41 , :B40 , :B39 , :B38 , :B37 , :B36 , :B35 , :B34 , :B33 , :B32 , :B31 , :B30 , :B29 , :B28 , :B27 , :B26 , :B25 , :B24 , :B23 , :B22 , :B21 , :B20 , :B19 , :B18 , :B17 , :B16 , :B15 , :B14 , :B13 , :B12 , :B11 , :B10 , :B9 , :B8 , :B7 , :B6 , :B5 , :B4 , :B3 , :B2 , :B1 ) |
| 73rvua18a9ytx | declare ret number ; BEGIN hr_nonrun_asact . get_next_pop_chunk ( :pactid , :atype , :l_lckhandle , :lub , :lul , :chunk_method , :threads , :slave_no , :curr_chunk , :max_chunks , :stperson:stperson_ind , :endperson:endperson_ind , :chunk:chunk_ind , :rand_chunk:rand_chunk_ind ) ; END ; |
| 77d28bpwm9svg | SELECT PBV.RUN_BALANCE_STATUS, PBV.BALANCE_LOAD_DATE FROM PAY_BALANCE_VALIDATION PBV WHERE PBV.DEFINED_BALANCE_ID = :B2 AND PBV.BUSINESS_GROUP_ID = :B1 |
| 7d66dw0vz7yaa | begin pay_cc_process_utils . reset_dates_for_run ( p_asg_id => :v_asg_id , p_sysdate => to_date ( :v_sysdate , :date_format ) , p_assact_id => :v_assact_id ) ; end ; |
| 7qs7fx89194u1 | SELECT PROFILE_OPTION_VALUE FROM FND_PROFILE_OPTION_VALUES WHERE PROFILE_OPTION_ID = :B4 AND APPLICATION_ID = :B3 AND LEVEL_ID = :B2 AND LEVEL_VALUE = :B1 AND PROFILE_OPTION_VALUE IS NOT NULL |
| 7rks7t2gukcwn | SELECT /*+ ORDERED */ fnd_number.number_to_canonical(nvl(sum(fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale), 0)) FROM pay_assignment_actions BAL_ASSACT , pay_payroll_actions BACT , pay_run_types_f BAL_PRT , pay_assignment_actions PPASSACT , pay_payroll_actions PPACT , pay_run_types_f PRT , pay_action_interlocks INTLCK2 , pay_assignment_actions ASSACT , pay_payroll_actions PACT , pay_run_results RR , pay_run_result_values TARGET , pay_balance_feeds_f FEED where BAL_ASSACT.assignment_action_id = :ASSIGNMENT_ACTION_ID and BAL_ASSACT.payroll_action_id = BACT.payroll_action_id and BACT.action_type in ('P', 'U', 'R', 'Q') and PPASSACT.assignment_action_id = pay_core_utils.get_pp_action_id( BACT.action_type, BAL_ASSACT.assignment_action_id) and PPASSACT.payroll_action_id = PPACT.payroll_action_id and PPACT.action_type in ('P', 'U') and PPASSACT.assignment_action_id = INTLCK2.locking_action_id and INTLCK2.locked_action_id = ASSACT.assignment_action_id and nvl(BAL_ASSACT.run_type_id, -999) = BAL_PRT.run_type_id (+) and nvl(ASSACT.run_type_id, -999) = PRT.run_type_id (+) and ASSACT.assignment_action_id = decode(BACT.action_type, 'P', ASSACT.assignment_action_id, 'U', ASSACT.assignment_action_id, 'R', decode(nvl(BAL_PRT.run_method, 'N'), 'S', BAL_ASSACT.ASSIGNMENT_ACTION_ID, decode (nvl(PRT.run_method, 'N'), 'S', -999, ASSACT.assignment_action_id)), 'Q', decode(nvl(BAL_PRT.run_method, 'N'), 'S', BAL_ASSACT.ASSIGNMENT_ACTION_ID, decode (nvl(PRT.run_method, 'N'), 'S', -999, ASSACT.assignment_action_id)) ) and ASSACT.tax_unit_id = decode(BACT.action_type, 'P', ASSACT.tax_unit_id, 'U', ASSACT.tax_unit_id, 'R', decode(BAL_ASSACT.SOURCE_ACTION_ID, NULL, ASSACT.TAX_UNIT_ID, BAL_ASSACT.tax_unit_id), 'Q', decode(BAL_ASSACT.SOURCE_ACTION_ID, NULL, ASSACT.TAX_UNIT_ID, BAL_ASSACT.tax_unit_id) ) and ASSACT.assignment_id = BAL_ASSACT.assignment_id and ASSACT.payroll_action_id = PACT.payroll_action_id and nvl(PACT.future_process_mode, 'Y') = 'Y' and PACT.action_type not in ('V') and RR.assignment_action_id = ASSACT.assignment_action_id and TARGET.run_result_id = RR.run_result_id and nvl(TARGET.result_value, '0') != '0' and FEED.balance_type_id = :U1 + DECODE(TARGET.INPUT_VALUE_ID, NULL , 0, 0) and FEED.input_value_id = TARGET.input_value_id and PACT.effective_date between FEED.effective_start_date and FEED.effective_end_date and RR.status in ('P', 'PA') /* Within Jurisdiction */ and substr (RR.jurisdiction_code, 1, :JURISDICTION_LEVEL) = substr (:JURISDICTION_CODE, 1, :JURISDICTION_LEVEL) |
| 7vku4w123mkap | SELECT /*+ ORDERED INDEX (ac2 PAY_ASSIGNMENT_ACTIONS_N51) (pa2 PAY_PAYROLL_ACTIONS_PK) */ AC2.ROWID, AC2.ASSIGNMENT_ACTION_ID, AC2.SOURCE_ACTION_ID, AC2.OBJECT_TYPE FROM PAY_PAYROLL_ACTIONS PAC, PER_ALL_ASSIGNMENTS_F ASG, PER_ALL_ASSIGNMENTS_F AS2, PAY_ASSIGNMENT_ACTIONS ACT, PAY_ASSIGNMENT_ACTIONS AC2, PAY_PAYROLL_ACTIONS PA2, PAY_ACTION_CLASSIFICATIONS ACL WHERE PAC.PAYROLL_ACTION_ID = :B4 AND ACT.PAYROLL_ACTION_ID = PAC.PAYROLL_ACTION_ID AND ACT.ASSIGNMENT_ID = :B3 AND ACT.SOURCE_ACTION_ID IS NULL AND ASG.ASSIGNMENT_ID = ACT.ASSIGNMENT_ID AND PAC.EFFECTIVE_DATE BETWEEN ASG.EFFECTIVE_START_DATE AND ASG.EFFECTIVE_END_DATE AND AS2.PERSON_ID = ASG.PERSON_ID AND DECODE(:B2 , 'G', PAC.EFFECTIVE_DATE, AS2.EFFECTIVE_END_DATE) >= PAC.EFFECTIVE_DATE AND AC2.ASSIGNMENT_ID = AS2.ASSIGNMENT_ID AND PA2.PAYROLL_ACTION_ID = AC2.PAYROLL_ACTION_ID AND AS2.EFFECTIVE_START_DATE = (SELECT MAX(PAF3.EFFECTIVE_START_DATE) FROM PER_ALL_ASSIGNMENTS_F PAF3 WHERE PAF3.ASSIGNMENT_ID = AC2.ASSIGNMENT_ID ) AND ACL.CLASSIFICATION_NAME = 'SEQUENCED' AND PA2.ACTION_TYPE = ACL.ACTION_TYPE AND AC2.ACTION_SEQUENCE > :B1 AND (AC2.SOURCE_ACTION_ID IS NULL OR (AC2.OBJECT_ID IS NOT NULL AND AC2.OBJECT_TYPE = 'POG') ) ORDER BY PA2.EFFECTIVE_DATE, AC2.ACTION_SEQUENCE FOR UPDATE OF AC2.ASSIGNMENT_ACTION_ID |
| 8v2cvg5zhw9ua | SELECT fnd_number.number_to_canonical(nvl(sum(fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale), 0)) FROM /* Assignment within Government Reporting Entity */ pay_run_result_values TARGET , pay_balance_feeds_f FEED , pay_run_results RR , pay_assignment_actions ASSACT , pay_assignment_actions BAL_ASSACT , pay_payroll_actions PACT , pay_payroll_actions BACT where BAL_ASSACT.assignment_action_id = :ASSIGNMENT_ACTION_ID and BAL_ASSACT.payroll_action_id = BACT.payroll_action_id and FEED.balance_type_id = :U1 + decode(TARGET.INPUT_VALUE_ID, null, 0, 0) and FEED.input_value_id = TARGET.input_value_id and nvl(TARGET.result_value, '0') != '0' and TARGET.run_result_id = RR.run_result_id and RR.assignment_action_id = ASSACT.assignment_action_id and ASSACT.payroll_action_id = PACT.payroll_action_id and PACT.effective_date between FEED.effective_start_date and FEED.effective_end_date and RR.status in ('P', 'PA') and ASSACT.action_sequence <= BAL_ASSACT.action_sequence and ASSACT.assignment_id = BAL_ASSACT.assignment_id and ASSACT.tax_unit_id = :TAX_UNIT_ID /* Year To Date */ and PACT.effective_date >= trunc(BACT.effective_date, 'Y') /* Within Jurisdiction */ and :JURISDICTION_LEVEL != 0 and substr (RR.jurisdiction_code, 1, :JURISDICTION_LEVEL) = substr (:JURISDICTION_CODE, 1, :JURISDICTION_LEVEL) |
| 8w57t3xaxs89k | SELECT NAME, VERSION FROM FND_CACHE_VERSIONS |
| 9gut0j2v6npp7 | select 'X' into :b0 from Fnd_Concurrent_Requests where Request_ID=:b1 for update of Status_Code |
| 9jv68n0ctas75 | begin pay_core_utils . get_prorated_dates ( :ee_id , :asg_act_id , :time_def_type , :time_def_id:time_def_ind , :pro_dates:prod_ind , :pro_types:prot_ind ) ; END ; |
| 9wupzu1crbdbb | SELECT RO.TEXT, RO.OPTIMIZER_HINT FROM FF_ROUTES RO WHERE RO.ROUTE_ID = :B1 |
| a9pf25b5p69c6 | declare cursor dp ( p_act in number ) is select distinct paf2 . assignment_id , paa . action_sequence from pay_assignment_actions paa , pay_payroll_actions ppa , per_all_assignments_f paf , per_periods_of_service pos , per_all_assignments_f paf2 where paa . assignment_action_id = p_act and paa . payroll_action_id = ppa . payroll_action_id and paf . assignment_id = paa . assignment_id and ppa . effective_date between paf . effective_start_date and paf . effective_end_date and paf . person_id = pos . person_id and pos . period_of_service_id = paf2 . period_of_service_id ; BEGIN for dprec in dp ( :assactid ) loop begin select 1 into :act_exists from sys . dual where exists ( select null from pay_assignment_actions paa , pay_payroll_actions ppa , pay_action_classifications pcl where paa . assignment_id = dprec . assignment_id and paa . payroll_action_id = ppa . payroll_action_id and ppa . action_type = pcl . action_type and pcl . classification_name = 'SEQUENCED' and paa . action_status not in ( 'C' , 'S' , 'B' ) and paa . action_sequence < dprec . action_sequence ) ; exception when no_data_found then null ; end ; end loop ; END ; |
| bb8xj89g0aq9q | select parameter_value into :b0 from pay_action_parameters where ((parameter_name=:b1 or parameter_name=REPLACE(:b1, ' ', '_')) or parameter_name=REPLACE(:b1, '_', ' ')) |
| bd7gbctp7jjhz | begin if ( FND_FLEX_KEYVAL . validate_segs ( :operation , :appl_short_name , :key_flex_code , :tmp_c_structure , :cat_segs , :opmode , to_date ( :tmp_comb_date , 'YYYY/MM/DD' ) ) = TRUE ) then :valid := 1 ; end if ; END ; |
| bkzygbymgqf34 | INSERT INTO PAY_ASSIGNMENT_ACTIONS ( ASSIGNMENT_ACTION_ID, ASSIGNMENT_ID, PAYROLL_ACTION_ID, ACTION_STATUS, CHUNK_NUMBER, ACTION_SEQUENCE, PRE_PAYMENT_ID, OBJECT_VERSION_NUMBER, TAX_UNIT_ID, SOURCE_ACTION_ID, OBJECT_ID, OBJECT_TYPE, START_DATE, END_DATE) SELECT :B12 , :B11 , :B10 , :B9 , :B8 , PAY_ASSIGNMENT_ACTIONS_S.NEXTVAL, :B7 , 1, :B6 , :B5 , :B4 , :B3 , :B2 , :B1 FROM DUAL |
| bm8gwn43tn8hd | SELECT PLB.LATEST_BALANCE_ID, PLB.ASSIGNMENT_ACTION_ID, PLB.VALUE, PLB.EXPIRY_DATE, ACT.ACTION_SEQUENCE CURRENT_ACTION_SEQ, OWN_ACT.ACTION_SEQUENCE OWNER_ACTION_SEQ, PACT.EFFECTIVE_DATE CURRENT_EFFECTIVE_DATE, PLB.EXPIRED_ASSIGNMENT_ACTION_ID, PLB.EXPIRED_VALUE, PLB.EXPIRED_DATE, PLB.PREV_ASSIGNMENT_ACTION_ID, PLB.PREV_BALANCE_VALUE, PLB.PREV_EXPIRY_DATE, PLB.TAX_UNIT_ID, PLB.JURISDICTION_CODE, PLB.ORIGINAL_ENTRY_ID, PLB.SOURCE_ID, PLB.SOURCE_TEXT, PLB.SOURCE_TEXT2, PLB.SOURCE_NUMBER, PLB.TAX_GROUP, PLB.PAYROLL_ID, PLB.LOCAL_UNIT_ID, PLB.ORGANIZATION_ID, PLB.SOURCE_NUMBER2 FROM PAY_LATEST_BALANCES PLB , PER_ALL_ASSIGNMENTS_F ASSIGN , PAY_ASSIGNMENT_ACTIONS ACT , PAY_PAYROLL_ACTIONS PACT , PAY_ASSIGNMENT_ACTIONS OWN_ACT WHERE PLB.DEFINED_BALANCE_ID = :B15 AND ACT.ASSIGNMENT_ACTION_ID = :B14 AND ASSIGN.ASSIGNMENT_ID = ACT.ASSIGNMENT_ID AND EXISTS (SELECT '' FROM PAY_OBJECT_GROUPS POG WHERE POG.SOURCE_ID (+) = ACT.ASSIGNMENT_ID AND POG.SOURCE_TYPE (+) = 'PAF' AND NVL(PLB.PROCESS_GROUP_ID, NVL(POG.PARENT_OBJECT_GROUP_ID, -1)) = NVL(POG.PARENT_OBJECT_GROUP_ID, -1) ) AND PLB.PERSON_ID = ASSIGN.PERSON_ID AND NVL(PLB.ASSIGNMENT_ID, ACT.ASSIGNMENT_ID) = ACT.ASSIGNMENT_ID AND PACT.PAYROLL_ACTION_ID = ACT.PAYROLL_ACTION_ID AND PACT.EFFECTIVE_DATE BETWEEN ASSIGN.EFFECTIVE_START_DATE AND ASSIGN.EFFECTIVE_END_DATE AND OWN_ACT.ASSIGNMENT_ACTION_ID = PLB.ASSIGNMENT_ACTION_ID AND NVL(PLB.TAX_UNIT_ID, NVL(:B13 , -1)) = NVL(:B13 , -1) AND NVL(SUBSTR(NVL(PLB.JURISDICTION_CODE, NVL(:B12 , -1)), 1, :B11 ), -1) = NVL( SUBSTR(NVL(:B12 , -1), 1, :B11 ), -1) AND NVL(PLB.ORIGINAL_ENTRY_ID, NVL(:B10 , -1)) = NVL(:B10 , -1) AND NVL(PLB.SOURCE_ID, NVL(:B9 , -1)) = NVL(:B9 , -1) AND NVL(PLB.SOURCE_TEXT, NVL(:B8 , -1)) = NVL(:B8 , -1) AND NVL(PLB.SOURCE_TEXT2, NVL(:B7 , -1)) = NVL(:B7 , -1) AND NVL(PLB.SOURCE_NUMBER, NVL(:B6 , -1)) = NVL(:B6 , -1) AND NVL(PLB.TAX_GROUP, NVL(:B5 , -1)) = NVL(:B5 , -1) AND NVL(PLB.PAYROLL_ID, NVL(:B4 , -1)) = NVL(:B4 , -1) AND NVL(PLB.LOCAL_UNIT_ID, NVL(:B3 , -1)) = NVL(:B3 , -1) AND NVL(PLB.ORGANIZATION_ID, NVL(:B2 , -1)) = NVL(:B2 , -1) AND NVL(PLB.SOURCE_NUMBER2, NVL(:B1 , -1)) = NVL(:B1 , -1) ORDER BY PLB.LATEST_BALANCE_ID |
| brhrt8s5mn8kq | SELECT PTS.TIME_IN_STATE, PTS.STATE_NAME, PTS.JURISDICTION_CODE, PTS.FILING_STATUS_CODE, DECODE(PST.SIT_EXEMPT, 'Y', 'Exempt', PTS.MEANING), PTS.WITHHOLDING_ALLOWANCES, PTS.SIT_ADDITIONAL_TAX, PTS.SIT_OVERRIDE_AMOUNT, PTS.SIT_OVERRIDE_RATE FROM PAY_US_EMP_TIME_IN_STATE_V PTS, PAY_US_EMP_STATE_TAX_RULES_F PST WHERE PTS.ASSIGNMENT_ID = :B3 AND PTS.JURISDICTION_CODE LIKE :B2 AND PST.JURISDICTION_CODE = PTS.JURISDICTION_CODE AND PST.ASSIGNMENT_ID = PTS.ASSIGNMENT_ID AND :B1 BETWEEN PST.EFFECTIVE_START_DATE AND PST.EFFECTIVE_END_DATE AND :B1 BETWEEN PTS.EFFECTIVE_START_DATE AND PTS.EFFECTIVE_END_DATE |
| cm5vu20fhtnq1 | select /*+ connect_by_filtering */ privilege#, level from sysauth$ connect by grantee#=prior privilege# and privilege#>0 start with grantee#=:1 and privilege#>0 |
| cn5un9cxnah8w | SELECT NVL(PBD.PERIOD_TYPE, 'NULL'), PBD.START_DATE_CODE FROM PAY_BALANCE_DIMENSIONS PBD, PAY_DEFINED_BALANCES PDB WHERE PDB.DEFINED_BALANCE_ID = :B1 AND PDB.BALANCE_DIMENSION_ID = PBD.BALANCE_DIMENSION_ID |
| dab1prc9qyv3v | begin hr_nonrun_asact.asact(:pactid, :atype, :itpflg, :ptype, :lub, :lul, :use_pop_person); end; |
| dz7tyjxnar7gt | SELECT /*+ ORDERED */ fnd_number.number_to_canonical(nvl(sum(fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale), 0)) FROM pay_assignment_actions BAL_ASSACT , pay_payroll_actions BACT , pay_run_types_f BAL_PRT , pay_assignment_actions PPASSACT , pay_payroll_actions PPACT , pay_run_types_f PRT , pay_action_interlocks INTLCK2 , pay_assignment_actions ASSACT , pay_payroll_actions PACT , pay_run_results RR , pay_run_result_values TARGET , pay_balance_feeds_f FEED where BAL_ASSACT.assignment_action_id = :ASSIGNMENT_ACTION_ID and BAL_ASSACT.payroll_action_id = BACT.payroll_action_id and BACT.action_type in ('P', 'U', 'R', 'Q') and PPASSACT.assignment_action_id = pay_core_utils.get_pp_action_id( BACT.action_type, BAL_ASSACT.assignment_action_id) and PPASSACT.payroll_action_id = PPACT.payroll_action_id and PPACT.action_type in ('P', 'U') and PPASSACT.assignment_action_id = INTLCK2.locking_action_id and INTLCK2.locked_action_id = ASSACT.assignment_action_id and nvl(BAL_ASSACT.run_type_id, -999) = BAL_PRT.run_type_id (+) and nvl(ASSACT.run_type_id, -999) = PRT.run_type_id (+) and ASSACT.assignment_action_id = decode(BACT.action_type, 'P', ASSACT.assignment_action_id, 'U', ASSACT.assignment_action_id, 'R', decode(nvl(BAL_PRT.run_method, 'N'), 'S', BAL_ASSACT.ASSIGNMENT_ACTION_ID, decode (nvl(PRT.run_method, 'N'), 'S', -999, ASSACT.assignment_action_id)), 'Q', decode(nvl(BAL_PRT.run_method, 'N'), 'S', BAL_ASSACT.ASSIGNMENT_ACTION_ID, decode (nvl(PRT.run_method, 'N'), 'S', -999, ASSACT.assignment_action_id)) ) and ASSACT.tax_unit_id = decode(BACT.action_type, 'P', ASSACT.tax_unit_id, 'U', ASSACT.tax_unit_id, 'R', decode(BAL_ASSACT.SOURCE_ACTION_ID, NULL, ASSACT.TAX_UNIT_ID, BAL_ASSACT.tax_unit_id), 'Q', decode(BAL_ASSACT.SOURCE_ACTION_ID, NULL, ASSACT.TAX_UNIT_ID, BAL_ASSACT.tax_unit_id) ) and ASSACT.assignment_id = BAL_ASSACT.assignment_id and ASSACT.payroll_action_id = PACT.payroll_action_id and nvl(PACT.future_process_mode, 'Y') = 'Y' and PACT.action_type not in ('V') and RR.assignment_action_id = ASSACT.assignment_action_id and RR.status in ('P', 'PA') and TARGET.run_result_id = RR.run_result_id and nvl(TARGET.result_value, '0') != '0' and FEED.balance_type_id = :U1 + DECODE(TARGET.INPUT_VALUE_ID, NULL , 0, 0) and FEED.input_value_id = TARGET.input_value_id and PACT.effective_date between FEED.effective_start_date and FEED.effective_end_date and exists (select null from pay_taxability_rules TR , pay_element_types_f ET , pay_balance_types BT where ET.element_type_id = RR.element_type_id and PACT.date_earned between ET.effective_start_date and ET.effective_end_date and BT.balance_type_id = :U1 and TR.classification_id = ET.classification_id + 0 and TR.tax_category = ET.element_information1 and TR.tax_type = BT.tax_type and TR.jurisdiction_code = '00-000-0000' and nvl(TR.status, 'VALID') <> 'D' ) |
| f78ff26qcfjan | update PAY_ASSIGNMENT_ACTIONS set ACTION_STATUS='C' where (rowid=:b0 and ACTION_STATUS<>'S') |
| fbpf0hy40v80s |
select /*+ ORDERED USE_NL(AA PA RR RRV LIV IV PERA ET FC EC EL) INDEX(AA PAY_ASSIGNMENT_ACTIONS_PK, PA PAY_PAYROLL_ACTIONS_PK, RR PAY_RUN_RESULTS_N50, ET PAY_ELEMENT_TYPES_F_PK, EL PAY_ELEMENT_LINKS_F_PK, EE PAY_ELEMENT_ENTRIES_F_PK, IV PAY_INPUT_VALUES_F_N1, PERA +*/ EL2.element_link_id , EL2.costable_type , EL2.cost_allocation_keyflex_id , EL2.balancing_keyflex_id , EL2.element_set_id , decode(IV.uom, 'M', nvl(FC.precision, 3), 3) , nvl(EC.costing_debit_or_credit, 'D') , to_char(RR.run_result_id) , decode(:b0, 'A', decode(EE.entry_type, 'A', EE.target_entry_id, 'R', EE.target_entry_id, RR.source_id), RR.source_id) , decode(:b0, 'A', nvl(EE.entry_type, 'N'), 'N') , decode(RR.source_type, 'E', nvl(EE.creator_type, 'X'), 'I', decode(EE.creator_type, null , 'X', 'N')) , EE.cost_allocation_keyflex_id , RR.element_type_id , RRV.input_value_id , RRV.result_value , IV.uom , decode(EL2.costable_type, 'D', decode(decode(RR.source_type, 'E', EE.creator_type, 'N'), 'RR', 2, 'EE', 2, 'NR', 2, 'PR', 2, 3), 1) , RR.jurisdiction_code , decode(IV.uom, 'M', decode(IV.name, 'Pay Value', 1, 0), 0) , to_char(decode(:b2, 0, PA.date_earned, decode(RR.end_date, null , PA.date_earned, hr_cost.get_cost_date(RR.source_id, RR.source_type, RR.end_date, PA.date_earned))), 'YYYY/MM/DD') , EL2.transfer_to_gl_flag , decode(:b3, null , null , hr_cost.get_context_value(:b3, RR.run_result_id, RR.element_type_id, PA.date_earned)) , decode(:b5, null , null , hr_cost.get_context_value(:b5, RR.run_result_id, RR.element_type_id, PA.date_earned)) , decode(:b7, null , null , hr_cost.get_context_value(:b7, RR.run_result_id, RR.element_type_id, PA.date_earned)) , decode(:b9, null , null , hr_cost.get_context_value(:b9, RR.run_result_id, RR.element_type_id, PA.date_earned)) from pay_assignment_actions AA , pay_payroll_actions PA , per_all_assignments_f PERA , pay_run_results RR , pay_element_entries_f EE , pay_element_types_f ET , pay_element_classifications EC , fnd_currencies FC , pay_input_values_f IV , pay_run_result_values RRV , pay_link_input_values_f LIV , pay_element_links_f EL , pay_element_links_f EL2 where (((((((((((((((((((((((((((((((AA.assignment_action_id=:b11 and AA.payroll_action_id=PA.payroll_action_id) and RR.assignment_action_id=:b11) and RR.status like 'P%') and RR.element_type_id=ET.element_type_id) and RRV.run_result_id=RR.run_result_id) and IV.input_value_id=RRV.input_value_id) and decode(RR.end_date, null , PA.date_earned, hr_cost.get_rr_date(RR.source_id, RR.source_type, RR.end_date, PA.date_earned)) between IV.effective_start_date and IV.effective_end_date) and IV.element_type_id=ET.element_type_id) and RRV.result_value is not null ) and (decode(:b13, 'Y', 1, fnd_number.canonical_to_number(RRV.result_value))+decode(LIV.DEFAULT_VALUE, 'M', 0, 0))<>0) and RRV.input_value_id=LIV.input_value_id) and decode(RR.end_date, null , PA.date_earned, hr_cost.get_rr_date(RR.source_id, RR.source_type, RR.end_date, PA.date_earned)) between LIV.effective_start_date and LIV.effective_end_date) and LIV.costed_flag='Y') and LIV.element_link_id=EL.element_link_id) and decode(RR.entry_type, 'B', nvl(RR.element_entry_id, RR.source_id), RR.source_id)=EE.element_entry_id(+)) and decode(RR.end_date, null , to_date(:b14, 'YYYY/MM/DD'), hr_cost.get_rr_date(RR.source_id, RR.source_type, RR.end_date, to_date(:b14, 'YYYY/MM/DD'))) between EE.effective_start_date(+) and EE.effective_end_date(+)) and RR.element_type_id=ET.element_type_id) and decode(RR.end_date, null , PA.date_earned, hr_cost.get_rr_date(RR.source_id, RR.source_type, RR.end_date, PA.date_earned)) between ET.effective_start_date and ET.effective_end_date) and ET.classification_id=EC.classification_id) and ET.output_currency_code=FC.currency_code) and (ET.element_type_id+0)=(EL.element_type_id+0)) and decode(RR.end_date, null , PA.date_earned, hr_cost.get_rr_date(RR.source_id, RR.source_type, RR.end_date, PA.date_earned)) between EL.effective_start_date and EL.effective_end_date) and EL.costable_t
ype<>'N') and ((PA.action_type='B' and hr_cost.cost_bal_adj(nvl(RR.element_entry_id, RR.source_id), PA.date_earned)='Y') or PA.action_type<>'B')) and PERA.assignment_id=:b16) and (PERA.business_group_id+0)=(EL.business_group_id+0)) and decode(RR.end_date, null , PA.date_earned, hr_cost.get_rr_date(RR.source_id, RR.source_type, RR.end_date, PA.date_earned)) between PERA.effective_start_date and PERA.effective_end_date) and (((EE.element_entry_id is not null and RR.source_type='E') and EL.element_link_id=EE.element_link_id) or ((((((((((EE.element_entry_id is null or (EE.element_entry_id is not null and RR.source_type<>'E')) and (((EL.payroll_id is not null and EL.payroll_id=PERA.payroll_id) or (EL.link_to_all_payrolls_flag='Y' and PERA.payroll_id is not null )) or EL.payroll_id is null )) and (EL.organization_id=PERA.organization_id or EL.organization_id is null )) and (EL.position_id=PERA.position_id or EL.position_id is null )) and (EL.job_id=PERA.job_id or EL.job_id is null )) and (EL.grade_id=PERA.grade_id or EL.grade_id is null )) and (EL.location_id=PERA.location_id or EL.location_id is null )) and (EL.pay_basis_id=PERA.pay_basis_id or EL.pay_basis_id is null )) and (EL.employment_category=PERA.employment_category or EL.employment_category is null )) and (EL.people_group_id is null or exists (select 1 from pay_assignment_link_usages_f PAL where ((PAL.assignment_id=:b16 and PAL.element_link_id=EL.element_link_id) and decode(RR.end_date, null , PA.date_earned, hr_cost.get_rr_date(RR.source_id, RR.source_type, RR.end_date, PA.date_earned)) between PAL.effective_start_date and PAL.effective_end_date)))))) and EL2.element_link_id=EL.element_link_id) and decode(:b2, 0, PA.date_earned, decode(EL.costable_type, 'D', PA.date_earned, decode(RR.end_date, null , PA.date_earned, hr_cost.get_rr_date(RR.source_id, RR.source_type, RR.end_date, PA.date_earned)))) between EL2.effective_start_date and EL2.effective_end_date) and (:b19=0 or (:b19<>0 and exists (select null from pay_ele_classification_rules ECR where ((ECR.element_set_id=:b19 and ET.classification_id=ECR.classification_id) and not exists (select null from pay_element_type_rules ETR where ((ETR.element_set_id=:b19 and ETR.element_type_id=ET.element_type_id) and ETR.include_or_exclude='E'))) union select null from pay_element_type_rules ETR where ((ETR.element_set_id=:b19 and ETR.element_type_id=ET.element_type_id) and ETR.include_or_exclude='I'))))) order by 17, 8, 14 |
| fh5m86a7xvv2k | SELECT 1 FROM PAY_UPGRADE_LEGISLATIONS PUL WHERE PUL.UPGRADE_DEFINITION_ID = :B2 AND PUL.LEGISLATION_CODE = :B1 |
| fkrq6dbyub3fv | INSERT INTO PAY_ACTION_INTERLOCKS ( LOCKING_ACTION_ID, LOCKED_ACTION_ID) VALUES (:B2 , :B1 ) |
| g2daxnc5b7rav | SELECT /*+ ORDERED */ fnd_number.number_to_canonical(nvl(sum(fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale), 0)) FROM pay_assignment_actions BAL_ASSACT , pay_payroll_actions BACT , pay_run_types_f BAL_PRT , pay_assignment_actions PPASSACT , pay_payroll_actions PPACT , pay_run_types_f PRT , pay_action_interlocks INTLCK2 , pay_assignment_actions ASSACT , pay_payroll_actions PACT , pay_run_results RR , pay_run_result_values TARGET , pay_balance_feeds_f FEED where BAL_ASSACT.assignment_action_id = :ASSIGNMENT_ACTION_ID and BAL_ASSACT.payroll_action_id = BACT.payroll_action_id and BACT.action_type in ('P', 'U', 'R', 'Q') and PPASSACT.assignment_action_id = pay_core_utils.get_pp_action_id( BACT.action_type, BAL_ASSACT.assignment_action_id) and PPASSACT.payroll_action_id = PPACT.payroll_action_id and PPACT.action_type in ('P', 'U') and PPASSACT.assignment_action_id = INTLCK2.locking_action_id and INTLCK2.locked_action_id = ASSACT.assignment_action_id and nvl(BAL_ASSACT.run_type_id, -999) = BAL_PRT.run_type_id (+) and nvl(ASSACT.run_type_id, -999) = PRT.run_type_id (+) and ASSACT.assignment_action_id = decode(BACT.action_type, 'P', ASSACT.assignment_action_id, 'U', ASSACT.assignment_action_id, 'R', decode(nvl(BAL_PRT.run_method, 'N'), 'S', BAL_ASSACT.ASSIGNMENT_ACTION_ID, decode (nvl(PRT.run_method, 'N'), 'S', -999, ASSACT.assignment_action_id)), 'Q', decode(nvl(BAL_PRT.run_method, 'N'), 'S', BAL_ASSACT.ASSIGNMENT_ACTION_ID, decode (nvl(PRT.run_method, 'N'), 'S', -999, ASSACT.assignment_action_id)) ) and ASSACT.tax_unit_id = decode(BACT.action_type, 'P', ASSACT.tax_unit_id, 'U', ASSACT.tax_unit_id, 'R', decode(BAL_ASSACT.SOURCE_ACTION_ID, NULL, ASSACT.TAX_UNIT_ID, BAL_ASSACT.tax_unit_id), 'Q', decode(BAL_ASSACT.SOURCE_ACTION_ID, NULL, ASSACT.TAX_UNIT_ID, BAL_ASSACT.tax_unit_id) ) and ASSACT.assignment_id = BAL_ASSACT.assignment_id and ASSACT.payroll_action_id = PACT.payroll_action_id and nvl(PACT.future_process_mode, 'Y') = 'Y' and PACT.action_type not in ('V') and RR.assignment_action_id = ASSACT.assignment_action_id and RR.status in ('P', 'PA') and TARGET.run_result_id = RR.run_result_id and nvl(TARGET.result_value, '0') != '0' and FEED.balance_type_id = :U1 + DECODE(TARGET.INPUT_VALUE_ID, NULL , 0, 0) and FEED.input_value_id = TARGET.input_value_id and PACT.effective_date between FEED.effective_start_date and FEED.effective_end_date |
| gr4znbghgcwpn | SELECT PUS.STATUS FROM PAY_UPGRADE_STATUS PUS WHERE PUS.UPGRADE_DEFINITION_ID = :B2 AND PUS.BUSINESS_GROUP_ID = :B1 |
| grg3zu94xp62h | SELECT PDB.BALANCE_TYPE_ID, PDR.ROUTE_ID, PDR.BALANCE_TYPE_COLUMN, PDR.RETRIEVAL_COLUMN, NVL(PDR.DECODE_REQUIRED, 'N'), NVL(JURISDICTION_LEVEL, 0) FROM PAY_DEFINED_BALANCES PDB, PAY_DIMENSION_ROUTES PDR, PAY_BALANCE_TYPES PBT WHERE PDB.DEFINED_BALANCE_ID = :B2 AND PDB.BALANCE_DIMENSION_ID = PDR.BALANCE_DIMENSION_ID AND PBT.BALANCE_TYPE_ID = PDB.BALANCE_TYPE_ID AND PDR.PRIORITY = :B1 |
| Statistic | Total | per Second | per Trans |
|---|
| Batched IO (bound) vector count | 459 | 0.27 | 0.00 |
| Batched IO (full) vector count | 0 | 0.00 | 0.00 |
| Batched IO (space) vector count | 3 | 0.00 | 0.00 |
| Batched IO block miss count | 1,431 | 0.85 | 0.01 |
| Batched IO buffer defrag count | 0 | 0.00 | 0.00 |
| Batched IO double miss count | 2 | 0.00 | 0.00 |
| Batched IO same unit count | 945 | 0.56 | 0.00 |
| Batched IO single block count | 446 | 0.26 | 0.00 |
| Batched IO vector block count | 43 | 0.03 | 0.00 |
| Batched IO vector read count | 16 | 0.01 | 0.00 |
| Block Cleanout Optim referenced | 102,227 | 60.69 | 0.43 |
| CCursor + sql area evicted | 0 | 0.00 | 0.00 |
| CPU used by this session | 2,951,980 | 1,752.49 | 12.39 |
| CPU used when call started | 2,950,834 | 1,751.81 | 12.38 |
| CR blocks created | 9,093,857 | 5,398.71 | 38.16 |
| Cached Commit SCN referenced | 17,980 | 10.67 | 0.08 |
| Commit SCN cached | 958,870 | 569.25 | 4.02 |
| DB time | 7,040,837 | 4,179.90 | 29.54 |
| DBWR checkpoint buffers written | 2,413,449 | 1,432.78 | 10.13 |
| DBWR checkpoints | 1 | 0.00 | 0.00 |
| DBWR revisited being-written buffer | 1,152 | 0.68 | 0.00 |
| DBWR thread checkpoint buffers written | 2,413,449 | 1,432.78 | 10.13 |
| DBWR transaction table writes | 16,614 | 9.86 | 0.07 |
| DBWR undo block writes | 1,289,259 | 765.39 | 5.41 |
| DFO trees parallelized | 0 | 0.00 | 0.00 |
| Effective IO time | 0 | 0.00 | 0.00 |
| HSC Heap Segment Block Changes | 17,817,678 | 10,577.74 | 74.76 |
| Heap Segment Array Inserts | 2,086,534 | 1,238.70 | 8.76 |
| Heap Segment Array Updates | 107,355 | 63.73 | 0.45 |
| IMU CR rollbacks | 1,397,583 | 829.70 | 5.86 |
| IMU Flushes | 151,489 | 89.93 | 0.64 |
| IMU Redo allocation size | 1,468,892,224 | 872,030.25 | 6,163.43 |
| IMU commits | 87,218 | 51.78 | 0.37 |
| IMU contention | 74,488 | 44.22 | 0.31 |
| IMU ktichg flush | 202 | 0.12 | 0.00 |
| IMU pool not allocated | 67 | 0.04 | 0.00 |
| IMU recursive-transaction flush | 4,794 | 2.85 | 0.02 |
| IMU undo allocation size | 2,988,300,944 | 1,774,050.38 | 12,538.82 |
| IMU- failed to get a private strand | 67 | 0.04 | 0.00 |
| Number of read IOs issued | 0 | 0.00 | 0.00 |
| PX local messages recv'd | 0 | 0.00 | 0.00 |
| PX local messages sent | 0 | 0.00 | 0.00 |
| Parallel operations downgraded 50 to 75 pct | 0 | 0.00 | 0.00 |
| Requests to/from client | 21,715,822 | 12,891.93 | 91.12 |
| RowCR - row contention | 125,868 | 74.72 | 0.53 |
| RowCR attempts | 10,200,961 | 6,055.96 | 42.80 |
| RowCR hits | 10,065,022 | 5,975.25 | 42.23 |
| SMON posted for undo segment shrink | 17 | 0.01 | 0.00 |
| SQL*Net roundtrips to/from client | 21,715,828 | 12,891.93 | 91.12 |
| active txn count during cleanout | 62,267,398 | 36,965.99 | 261.27 |
| application wait time | 143,178 | 85.00 | 0.60 |
| background checkpoints completed | 1 | 0.00 | 0.00 |
| background checkpoints started | 1 | 0.00 | 0.00 |
| background timeouts | 9,854 | 5.85 | 0.04 |
| branch node splits | 975 | 0.58 | 0.00 |
| buffer is not pinned count | 1,744,820,580 | 1,035,839.32 | 7,321.21 |
| buffer is pinned count | 1,050,146,350 | 623,435.38 | 4,406.38 |
| bytes received via SQL*Net from client | 5,787,803,418 | 3,436,017.68 | 24,285.44 |
| bytes sent via SQL*Net to client | 3,303,679,668 | 1,961,279.77 | 13,862.14 |
| calls to get snapshot scn: kcmgss | 220,780,553 | 131,069.74 | 926.39 |
| calls to kcmgas | 11,327,918 | 6,724.99 | 47.53 |
| calls to kcmgcs | 7,596,714 | 4,509.91 | 31.88 |
| cell physical IO interconnect bytes | 46,587,784,704 | 27,657,548.19 | 195,480.88 |
| change write time | 32,938 | 19.55 | 0.14 |
| cleanout - number of ktugct calls | 11,323,638 | 6,722.45 | 47.51 |
| cleanouts and rollbacks - consistent read gets | 8,641,947 | 5,130.42 | 36.26 |
| cleanouts only - consistent read gets | 237,226 | 140.83 | 1.00 |
| cluster key scan block gets | 1,823,180 | 1,082.36 | 7.65 |
| cluster key scans | 688,316 | 408.63 | 2.89 |
| commit batch/immediate performed | 42,233 | 25.07 | 0.18 |
| commit batch/immediate requested | 42,233 | 25.07 | 0.18 |
| commit cleanout failures: block lost | 404 | 0.24 | 0.00 |
| commit cleanout failures: buffer being written | 6,085 | 3.61 | 0.03 |
| commit cleanout failures: callback failure | 690,468 | 409.91 | 2.90 |
| commit cleanout failures: cannot pin | 74,413 | 44.18 | 0.31 |
| commit cleanouts | 5,663,666 | 3,362.32 | 23.76 |
| commit cleanouts successfully completed | 4,892,296 | 2,904.39 | 20.53 |
| commit immediate performed | 42,233 | 25.07 | 0.18 |
| commit immediate requested | 42,233 | 25.07 | 0.18 |
| commit txn count during cleanout | 2,909,396 | 1,727.21 | 12.21 |
| concurrency wait time | 104,355 | 61.95 | 0.44 |
| consistent changes | 447,288,074 | 265,539.38 | 1,876.81 |
| consistent gets | 2,835,890,400 | 1,683,569.54 | 11,899.31 |
| consistent gets - examination | 1,905,705,105 | 1,131,350.87 | 7,996.28 |
| consistent gets direct | 5 | 0.00 | 0.00 |
| consistent gets from cache | 2,835,890,395 | 1,683,569.54 | 11,899.31 |
| consistent gets from cache (fastpath) | 856,323,687 | 508,369.60 | 3,593.11 |
| cursor authentications | 178 | 0.11 | 0.00 |
| data blocks consistent reads - undo records applied | 446,972,230 | 265,351.87 | 1,875.48 |
| db block changes | 135,869,094 | 80,660.76 | 570.10 |
| db block gets | 177,610,057 | 105,440.92 | 745.25 |
| db block gets direct | 168 | 0.10 | 0.00 |
| db block gets from cache | 177,609,889 | 105,440.82 | 745.25 |
| db block gets from cache (fastpath) | 37,383,153 | 22,193.08 | 156.86 |
| deferred (CURRENT) block cleanout applications | 286,304 | 169.97 | 1.20 |
| dirty buffers inspected | 1,715 | 1.02 | 0.01 |
| enqueue conversions | 1,521 | 0.90 | 0.01 |
| enqueue releases | 2,391,653 | 1,419.84 | 10.04 |
| enqueue requests | 2,393,305 | 1,420.82 | 10.04 |
| enqueue timeouts | 1,669 | 0.99 | 0.01 |
| enqueue waits | 698,040 | 414.40 | 2.93 |
| exchange deadlocks | 567,378 | 336.83 | 2.38 |
| execute count | 232,433,054 | 137,987.42 | 975.28 |
| failed probes on index block reclamation | 1 | 0.00 | 0.00 |
| file io service time | 27,135,503 | 16,109.40 | 113.86 |
| file io wait time | 62,944,860,644 | 37,368,175.53 | 264,114.65 |
| free buffer inspected | 2,825,373 | 1,677.33 | 11.86 |
| free buffer requested | 11,571,809 | 6,869.78 | 48.55 |
| heap block compress | 385,769 | 229.02 | 1.62 |
| hot buffers moved to head of LRU | 761,197 | 451.90 | 3.19 |
| immediate (CR) block cleanout applications | 8,879,317 | 5,271.34 | 37.26 |
| immediate (CURRENT) block cleanout applications | 857,046 | 508.80 | 3.60 |
| in call idle wait time | 10,823,554 | 6,425.57 | 45.42 |
| index crx upgrade (positioned) | 5,766 | 3.42 | 0.02 |
| index fetch by key | 434,134,174 | 257,730.37 | 1,821.61 |
| index scans kdiixs1 | 401,883,060 | 238,584.00 | 1,686.29 |
| java call heap collected bytes | 0 | 0.00 | 0.00 |
| java call heap collected count | 0 | 0.00 | 0.00 |
| java call heap gc count | 0 | 0.00 | 0.00 |
| java call heap object count | 0 | 0.00 | 0.00 |
| java call heap object count max | 0 | 0.00 | 0.00 |
| java call heap total size | 0 | 0.00 | 0.00 |
| java call heap total size max | 0 | 0.00 | 0.00 |
| java call heap used size | 0 | 0.00 | 0.00 |
| java call heap used size max | 0 | 0.00 | 0.00 |
| java session heap live size | 0 | 0.00 | 0.00 |
| java session heap live size max | 0 | 0.00 | 0.00 |
| java session heap used size | 0 | 0.00 | 0.00 |
| java session heap used size max | 0 | 0.00 | 0.00 |
| leaf node 90-10 splits | 40,368 | 23.97 | 0.17 |
| leaf node splits | 230,036 | 136.56 | 0.97 |
| lob reads | 3,307 | 1.96 | 0.01 |
| lob writes | 6,904 | 4.10 | 0.03 |
| lob writes unaligned | 6,904 | 4.10 | 0.03 |
| logical read bytes from cache | 24,682,173,956,096 | 14,652,948,620.11 | 103,565,624.76 |
| logons cumulative | 334 | 0.20 | 0.00 |
| max cf enq hold time | 20 | 0.01 | 0.00 |
| messages received | 300,373 | 178.32 | 1.26 |
| messages sent | 300,373 | 178.32 | 1.26 |
| min active SCN optimization applied on CR | 35,748,283 | 21,222.51 | 150.00 |
| no buffer to keep pinned count | 482 | 0.29 | 0.00 |
| no work - consistent read gets | 871,576,318 | 517,424.56 | 3,657.11 |
| non-idle wait count | 34,378,382 | 20,409.25 | 144.25 |
| non-idle wait time | 300,259 | 178.25 | 1.26 |
| opened cursors cumulative | 220,130,109 | 130,683.59 | 923.66 |
| parse count (describe) | 16 | 0.01 | 0.00 |
| parse count (failures) | 0 | 0.00 | 0.00 |
| parse count (hard) | 583 | 0.35 | 0.00 |
| parse count (total) | 43,072 | 25.57 | 0.18 |
| parse time cpu | 48,395 | 28.73 | 0.20 |
| parse time elapsed | 54,634 | 32.43 | 0.23 |
| physical read IO requests | 65,093 | 38.64 | 0.27 |
| physical read bytes | 810,188,800 | 480,980.92 | 3,399.53 |
| physical read total IO requests | 229,558 | 136.28 | 0.96 |
| physical read total bytes | 3,482,395,648 | 2,067,377.23 | 14,612.02 |
| physical read total multi block requests | 1,278 | 0.76 | 0.01 |
| physical reads | 98,900 | 58.71 | 0.41 |
| physical reads cache | 92,911 | 55.16 | 0.39 |
| physical reads cache prefetch | 29,693 | 17.63 | 0.12 |
| physical reads direct | 5,989 | 3.56 | 0.03 |
| physical reads direct (lob) | 0 | 0.00 | 0.00 |
| physical reads direct temporary tablespace | 4,278 | 2.54 | 0.02 |
| physical reads prefetch warmup | 74 | 0.04 | 0.00 |
| physical write IO requests | 1,674,905 | 994.33 | 7.03 |
| physical write bytes | 19,825,459,200 | 11,769,685.91 | 83,187.00 |
| physical write total IO requests | 2,134,636 | 1,267.26 | 8.96 |
| physical write total bytes | 43,105,389,056 | 25,590,170.96 | 180,868.86 |
| physical write total multi block requests | 65,749 | 39.03 | 0.28 |
| physical writes | 2,420,100 | 1,436.73 | 10.15 |
| physical writes direct | 4,786 | 2.84 | 0.02 |
| physical writes direct (lob) | 26 | 0.02 | 0.00 |
| physical writes direct temporary tablespace | 4,281 | 2.54 | 0.02 |
| physical writes from cache | 2,415,314 | 1,433.89 | 10.13 |
| physical writes non checkpoint | 1,636,900 | 971.77 | 6.87 |
| pinned buffers inspected | 1,871 | 1.11 | 0.01 |
| prefetch clients - default | 0 | 0.00 | 0.00 |
| prefetch warmup blocks aged out before use | 27,420 | 16.28 | 0.12 |
| prefetched blocks aged out before use | 3 | 0.00 | 0.00 |
| process last non-idle time | 1,557 | 0.92 | 0.01 |
| queries parallelized | 0 | 0.00 | 0.00 |
| recursive calls | 408,568,369 | 242,552.84 | 1,714.34 |
| recursive cpu usage | 2,678,137 | 1,589.92 | 11.24 |
| redo blocks checksummed by FG (exclusive) | 11,568,872 | 6,868.04 | 48.54 |
| redo blocks written | 45,382,483 | 26,942.00 | 190.42 |
| redo buffer allocation retries | 19 | 0.01 | 0.00 |
| redo entries | 70,028,235 | 41,573.33 | 293.84 |
| redo ordering marks | 927,444 | 550.59 | 3.89 |
| redo size | 22,361,483,900 | 13,275,235.61 | 93,828.08 |
| redo size for direct writes | 1,924 | 1.14 | 0.01 |
| redo subscn max counts | 1,938,157 | 1,150.62 | 8.13 |
| redo synch long waits | 1,354 | 0.80 | 0.01 |
| redo synch time | 11,440 | 6.79 | 0.05 |
| redo synch time (usec) | 114,504,405 | 67,977.28 | 480.46 |
| redo synch writes | 91,993 | 54.61 | 0.39 |
| redo wastage | 113,616,500 | 67,450.17 | 476.73 |
| redo write time | 13,974 | 8.30 | 0.06 |
| redo writes | 265,887 | 157.85 | 1.12 |
| rollback changes - undo records applied | 184,886 | 109.76 | 0.78 |
| rollbacks only - consistent read gets | 404,229 | 239.98 | 1.70 |
| root node splits | 2 | 0.00 | 0.00 |
| rows fetched via callback | 305,716,052 | 181,492.99 | 1,282.77 |
| session connect time | 0 | 0.00 | 0.00 |
| session cursor cache hits | 7,023,066 | 4,169.35 | 29.47 |
| session logical reads | 3,013,500,457 | 1,789,010.46 | 12,644.55 |
| shared hash latch upgrades - no wait | 39,789,046 | 23,621.37 | 166.95 |
| shared hash latch upgrades - wait | 1,742,609 | 1,034.53 | 7.31 |
| sorts (disk) | 0 | 0.00 | 0.00 |
| sorts (memory) | 14,828,198 | 8,802.99 | 62.22 |
| sorts (rows) | 28,634,166 | 16,999.11 | 120.15 |
| sql area evicted | 0 | 0.00 | 0.00 |
| sql area purged | 4 | 0.00 | 0.00 |
| summed dirty queue length | 9,112 | 5.41 | 0.04 |
| switch current to new buffer | 733,858 | 435.67 | 3.08 |
| table fetch by rowid | 1,045,001,501 | 620,381.06 | 4,384.79 |
| table fetch continued row | 14,581 | 8.66 | 0.06 |
| table scan blocks gotten | 82,041,758 | 48,705.34 | 344.24 |
| table scan rows gotten | 300,633,687 | 178,475.77 | 1,261.45 |
| table scans (direct read) | 0 | 0.00 | 0.00 |
| table scans (long tables) | 0 | 0.00 | 0.00 |
| table scans (rowid ranges) | 0 | 0.00 | 0.00 |
| table scans (short tables) | 6,266,782 | 3,720.37 | 26.30 |
| temp space allocated (bytes) | 1,048,576 | 622.50 | 4.40 |
| total cf enq hold time | 300 | 0.18 | 0.00 |
| total number of cf enq holders | 103 | 0.06 | 0.00 |
| total number of times SMON posted | 142 | 0.08 | 0.00 |
| transaction rollbacks | 42,232 | 25.07 | 0.18 |
| transaction tables consistent read rollbacks | 5 | 0.00 | 0.00 |
| transaction tables consistent reads - undo records applied | 51 | 0.03 | 0.00 |
| undo change vector size | 8,267,462,612 | 4,908,105.14 | 34,690.01 |
| user I/O wait time | 6,814 | 4.05 | 0.03 |
| user calls | 23,145,644 | 13,740.76 | 97.12 |
| user commits | 236,613 | 140.47 | 0.99 |
| user rollbacks | 1,711 | 1.02 | 0.01 |
| workarea executions - onepass | 8 | 0.00 | 0.00 |
| workarea executions - optimal | 9,905,568 | 5,880.59 | 41.56 |
| write clones created in background | 30 | 0.02 | 0.00 |
| write clones created in foreground | 22,565 | 13.40 | 0.09 |
| Tablespace | Filename | Reads | Av Reads/s | Av Rd(ms) | Av Blks/Rd | Writes | Av Writes/s | Buffer Waits | Av Buf Wt(ms) |
|---|
| APPS_CALCLIP | /slot/ems8643/oracle/VIS/db/apps_st/data/apps_calclip.dbf |
4 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
| APPS_CALCLIP | /slot/ems8643/oracle/VIS/db/apps_st/data/apps_calclip1.dbf |
4 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
| APPS_CALCLIP | /slot/ems8643/oracle/VIS/db/apps_st/data/apps_calclip2.dbf |
4 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
| APPS_CALCLIP | /slot/ems8643/oracle/VIS/db/apps_st/data/apps_calclip3.dbf |
4 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
| APPS_OMO | /slot/ems8643/oracle/VIS/db/apps_st/data/omo1.dbf |
5 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
| APPS_TS_ARCHIVE | /slot/ems8643/oracle/VIS/db/apps_st/data/archive1.dbf |
4,199 | 2 | 1.32 | 1.00 | 243 | 0 | 50 | 0.00 |
| APPS_TS_DISCO | /slot/ems8643/oracle/VIS/db/apps_st/data/disco1.dbf |
216 | 0 | 0.32 | 1.00 | 1 | 0 | 0 | 0.00 |
| APPS_TS_DISCO | /slot/ems8643/oracle/VIS/db/apps_st/data/disco2.dbf |
1 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
| APPS_TS_DISCO | /slot/ems8643/oracle/VIS/db/apps_st/data/disco3.dbf |
6 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
| APPS_TS_DISCO_OLAP | /slot/ems8643/oracle/VIS/db/apps_st/data/disco_drake1.dbf |
6 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
| APPS_TS_INTERFACE | /slot/ems8643/oracle/VIS/db/apps_st/data/apps_ts_interfac27.dbf |
6 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
| APPS_TS_INTERFACE | /slot/ems8643/oracle/VIS/db/apps_st/data/apps_ts_interfac28.dbf |
6 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
| APPS_TS_INTERFACE | /slot/ems8643/oracle/VIS/db/apps_st/data/apps_ts_interfac29.dbf |
7 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
| APPS_TS_INTERFACE | /slot/ems8643/oracle/VIS/db/apps_st/data/apps_ts_interfac30.dbf |
6 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
| APPS_TS_INTERFACE | /slot/ems8643/oracle/VIS/db/apps_st/data/apps_ts_interfac31.dbf |
6 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
| APPS_TS_INTERFACE | /slot/ems8643/oracle/VIS/db/apps_st/data/apps_ts_interfac32.dbf |
6 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
| APPS_TS_INTERFACE | /slot/ems8643/oracle/VIS/db/apps_st/data/apps_ts_interfac33.dbf |
6 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
| APPS_TS_INTERFACE | /slot/ems8643/oracle/VIS/db/apps_st/data/apps_ts_interfac34.dbf |
6 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
| APPS_TS_INTERFACE | /slot/ems8643/oracle/VIS/db/apps_st/data/apps_ts_interfac35.dbf |
6 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
| APPS_TS_INTERFACE | /slot/ems8643/oracle/VIS/db/apps_st/data/apps_ts_interfac36.dbf |
7 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
| APPS_TS_INTERFACE | /slot/ems8643/oracle/VIS/db/apps_st/data/apps_ts_interface.dbf |
12 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
| APPS_TS_INTERFACE | /slot/ems8643/oracle/VIS/db/apps_st/data/apps_ts_interface1.dbf |
1 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
| APPS_TS_INTERFACE | /slot/ems8643/oracle/VIS/db/apps_st/data/apps_ts_interface10.dbf |
4 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
| APPS_TS_INTERFACE | /slot/ems8643/oracle/VIS/db/apps_st/data/apps_ts_interface11.dbf |
5 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
| APPS_TS_INTERFACE | /slot/ems8643/oracle/VIS/db/apps_st/data/apps_ts_interface12.dbf |
7 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
| APPS_TS_INTERFACE | /slot/ems8643/oracle/VIS/db/apps_st/data/apps_ts_interface13.dbf |
5 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
| APPS_TS_INTERFACE | /slot/ems8643/oracle/VIS/db/apps_st/data/apps_ts_interface14.dbf |
5 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
| APPS_TS_INTERFACE | /slot/ems8643/oracle/VIS/db/apps_st/data/apps_ts_interface15.dbf |
5 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
| APPS_TS_INTERFACE | /slot/ems8643/oracle/VIS/db/apps_st/data/apps_ts_interface16.dbf |
6 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
| APPS_TS_INTERFACE | /slot/ems8643/oracle/VIS/db/apps_st/data/apps_ts_interface17.dbf |
6 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
| APPS_TS_INTERFACE | /slot/ems8643/oracle/VIS/db/apps_st/data/apps_ts_interface18.dbf |
7 | 0 | 10.00 | 1.00 | 1 | 0 | 0 | 0.00 |
| APPS_TS_INTERFACE | /slot/ems8643/oracle/VIS/db/apps_st/data/apps_ts_interface19.dbf |
6 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
| APPS_TS_INTERFACE | /slot/ems8643/oracle/VIS/db/apps_st/data/apps_ts_interface2.dbf |
1 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
| APPS_TS_INTERFACE | /slot/ems8643/oracle/VIS/db/apps_st/data/apps_ts_interface20.dbf |
6 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
| APPS_TS_INTERFACE | /slot/ems8643/oracle/VIS/db/apps_st/data/apps_ts_interface21.dbf |
7 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
| APPS_TS_INTERFACE | /slot/ems8643/oracle/VIS/db/apps_st/data/apps_ts_interface22.dbf |
7 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
| APPS_TS_INTERFACE | /slot/ems8643/oracle/VIS/db/apps_st/data/apps_ts_interface23.dbf |
6 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
| APPS_TS_INTERFACE | /slot/ems8643/oracle/VIS/db/apps_st/data/apps_ts_interface24.dbf |
6 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
| APPS_TS_INTERFACE | /slot/ems8643/oracle/VIS/db/apps_st/data/apps_ts_interface25.dbf |
7 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
| APPS_TS_INTERFACE | /slot/ems8643/oracle/VIS/db/apps_st/data/apps_ts_interface26.dbf |
8 | 0 | 8.75 | 1.00 | 1 | 0 | 0 | 0.00 |
| APPS_TS_INTERFACE | /slot/ems8643/oracle/VIS/db/apps_st/data/apps_ts_interface3.dbf |
4 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
| APPS_TS_INTERFACE | /slot/ems8643/oracle/VIS/db/apps_st/data/apps_ts_interface4.dbf |
4 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
| APPS_TS_INTERFACE | /slot/ems8643/oracle/VIS/db/apps_st/data/apps_ts_interface5.dbf |
4 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
| APPS_TS_INTERFACE | /slot/ems8643/oracle/VIS/db/apps_st/data/apps_ts_interface6.dbf |
5 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
| APPS_TS_INTERFACE | /slot/ems8643/oracle/VIS/db/apps_st/data/apps_ts_interface7.dbf |
5 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
| APPS_TS_INTERFACE | /slot/ems8643/oracle/VIS/db/apps_st/data/apps_ts_interface8.dbf |
5 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
| APPS_TS_INTERFACE | /slot/ems8643/oracle/VIS/db/apps_st/data/apps_ts_interface9.dbf |
7 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
| APPS_TS_MEDIA | /slot/ems8643/oracle/VIS/db/apps_st/data/media1.dbf |
2 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
| APPS_TS_MEDIA | /slot/ems8643/oracle/VIS/db/apps_st/data/media2.dbf |
3 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
| APPS_TS_MEDIA | /slot/ems8643/oracle/VIS/db/apps_st/data/media3.dbf |
3 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
| APPS_TS_MEDIA | /slot/ems8643/oracle/VIS/db/apps_st/data/media4.dbf |
6 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
| APPS_TS_MEDIA | /slot/ems8643/oracle/VIS/db/apps_st/data/media5.dbf |
6 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
| APPS_TS_MEDIA | /slot/ems8643/oracle/VIS/db/apps_st/data/media6.dbf |
7 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
| APPS_TS_MEDIA | /slot/ems8643/oracle/VIS/db/apps_st/data/media7.dbf |
4 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
| APPS_TS_NOLOGGING | /slot/ems8643/oracle/VIS/db/apps_st/data/nologging1.dbf |
277 | 0 | 0.32 | 1.00 | 1 | 0 | 0 | 0.00 |
| APPS_TS_NOLOGGING | /slot/ems8643/oracle/VIS/db/apps_st/data/nologging2.dbf |
6 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
| APPS_TS_NOLOGGING | /slot/ems8643/oracle/VIS/db/apps_st/data/nologging3.dbf |
6 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
| APPS_TS_NOLOGGING | /slot/ems8643/oracle/VIS/db/apps_st/data/nologging4.dbf |
6 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
| APPS_TS_QUEUES | /slot/ems8643/oracle/VIS/db/apps_st/data/queues1.dbf |
11 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
| APPS_TS_QUEUES | /slot/ems8643/oracle/VIS/db/apps_st/data/queues10.dbf |
6 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
| APPS_TS_QUEUES | /slot/ems8643/oracle/VIS/db/apps_st/data/queues11.dbf |
6 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
| APPS_TS_QUEUES | /slot/ems8643/oracle/VIS/db/apps_st/data/queues12.dbf |
6 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
| APPS_TS_QUEUES | /slot/ems8643/oracle/VIS/db/apps_st/data/queues13.dbf |
6 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
| APPS_TS_QUEUES | /slot/ems8643/oracle/VIS/db/apps_st/data/queues2.dbf |
1 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
| APPS_TS_QUEUES | /slot/ems8643/oracle/VIS/db/apps_st/data/queues3.dbf |
7 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
| APPS_TS_QUEUES | /slot/ems8643/oracle/VIS/db/apps_st/data/queues4.dbf |
7 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
| APPS_TS_QUEUES | /slot/ems8643/oracle/VIS/db/apps_st/data/queues5.dbf |
7 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
| APPS_TS_QUEUES | /slot/ems8643/oracle/VIS/db/apps_st/data/queues6.dbf |
7 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
| APPS_TS_QUEUES | /slot/ems8643/oracle/VIS/db/apps_st/data/queues7.dbf |
7 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
| APPS_TS_QUEUES | /slot/ems8643/oracle/VIS/db/apps_st/data/queues8.dbf |
7 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
| APPS_TS_QUEUES | /slot/ems8643/oracle/VIS/db/apps_st/data/queues9.dbf |
7 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
| APPS_TS_SEED | /slot/ems8643/oracle/VIS/db/apps_st/data/reference1.dbf |
3,941 | 2 | 1.33 | 1.00 | 1 | 0 | 231 | 8.48 |
| APPS_TS_SEED | /slot/ems8643/oracle/VIS/db/apps_st/data/reference10.dbf |
6 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
| APPS_TS_SEED | /slot/ems8643/oracle/VIS/db/apps_st/data/reference11.dbf |
7 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
| APPS_TS_SEED | /slot/ems8643/oracle/VIS/db/apps_st/data/reference12.dbf |
7 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
| APPS_TS_SEED | /slot/ems8643/oracle/VIS/db/apps_st/data/reference13.dbf |
7 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
| APPS_TS_SEED | /slot/ems8643/oracle/VIS/db/apps_st/data/reference14.dbf |
7 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
| APPS_TS_SEED | /slot/ems8643/oracle/VIS/db/apps_st/data/reference15.dbf |
8 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
| APPS_TS_SEED | /slot/ems8643/oracle/VIS/db/apps_st/data/reference16.dbf |
8 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
| APPS_TS_SEED | /slot/ems8643/oracle/VIS/db/apps_st/data/reference17.dbf |
6 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
| APPS_TS_SEED | /slot/ems8643/oracle/VIS/db/apps_st/data/reference18.dbf |
6 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
| APPS_TS_SEED | /slot/ems8643/oracle/VIS/db/apps_st/data/reference19.dbf |
6 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
| APPS_TS_SEED | /slot/ems8643/oracle/VIS/db/apps_st/data/reference2.dbf |
1,612 | 1 | 0.58 | 1.00 | 1 | 0 | 92 | 3.37 |
| APPS_TS_SEED | /slot/ems8643/oracle/VIS/db/apps_st/data/reference20.dbf |
6 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
| APPS_TS_SEED | /slot/ems8643/oracle/VIS/db/apps_st/data/reference21.dbf |
6 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
| APPS_TS_SEED | /slot/ems8643/oracle/VIS/db/apps_st/data/reference22.dbf |
6 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
| APPS_TS_SEED | /slot/ems8643/oracle/VIS/db/apps_st/data/reference23.dbf |
6 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
| APPS_TS_SEED | /slot/ems8643/oracle/VIS/db/apps_st/data/reference24.dbf |
6 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
| APPS_TS_SEED | /slot/ems8643/oracle/VIS/db/apps_st/data/reference25.dbf |
6 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
| APPS_TS_SEED | /slot/ems8643/oracle/VIS/db/apps_st/data/reference3.dbf |
3 | 0 | 3.33 | 1.00 | 1 | 0 | 61 | 4.43 |
| APPS_TS_SEED | /slot/ems8643/oracle/VIS/db/apps_st/data/reference4.dbf |
2 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
| APPS_TS_SEED | /slot/ems8643/oracle/VIS/db/apps_st/data/reference5.dbf |
1 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
| APPS_TS_SEED | /slot/ems8643/oracle/VIS/db/apps_st/data/reference6.dbf |
6 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
| APPS_TS_SEED | /slot/ems8643/oracle/VIS/db/apps_st/data/reference7.dbf |
6 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
| APPS_TS_SEED | /slot/ems8643/oracle/VIS/db/apps_st/data/reference8.dbf |
6 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
| APPS_TS_SEED | /slot/ems8643/oracle/VIS/db/apps_st/data/reference9.dbf |
6 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
| APPS_TS_SUMMARY | /slot/ems8643/oracle/VIS/db/apps_st/data/summary1.dbf |
2 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
| APPS_TS_SUMMARY | /slot/ems8643/oracle/VIS/db/apps_st/data/summary10.dbf |
4 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
| APPS_TS_SUMMARY | /slot/ems8643/oracle/VIS/db/apps_st/data/summary11.dbf |
4 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
| APPS_TS_SUMMARY | /slot/ems8643/oracle/VIS/db/apps_st/data/summary12.dbf |
6 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
| APPS_TS_SUMMARY | /slot/ems8643/oracle/VIS/db/apps_st/data/summary13.dbf |
7 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
| APPS_TS_SUMMARY | /slot/ems8643/oracle/VIS/db/apps_st/data/summary14.dbf |
6 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
| APPS_TS_SUMMARY | /slot/ems8643/oracle/VIS/db/apps_st/data/summary15.dbf |
6 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
| APPS_TS_SUMMARY | /slot/ems8643/oracle/VIS/db/apps_st/data/summary2.dbf |
3 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
| APPS_TS_SUMMARY | /slot/ems8643/oracle/VIS/db/apps_st/data/summary3.dbf |
3 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
| APPS_TS_SUMMARY | /slot/ems8643/oracle/VIS/db/apps_st/data/summary4.dbf |
1 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
| APPS_TS_SUMMARY | /slot/ems8643/oracle/VIS/db/apps_st/data/summary5.dbf |
1 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
| APPS_TS_SUMMARY | /slot/ems8643/oracle/VIS/db/apps_st/data/summary6.dbf |
3 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
| APPS_TS_SUMMARY | /slot/ems8643/oracle/VIS/db/apps_st/data/summary7.dbf |
1 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
| APPS_TS_SUMMARY | /slot/ems8643/oracle/VIS/db/apps_st/data/summary8.dbf |
3 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
| APPS_TS_SUMMARY | /slot/ems8643/oracle/VIS/db/apps_st/data/summary9.dbf |
5 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
| APPS_TS_TOOLS | /slot/ems8643/oracle/VIS/db/apps_st/data/apps_ts_tools01.dbf |
1 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
| APPS_TS_TX_DATA | /slot/ems8643/oracle/VIS/db/apps_st/data/tx_data1.dbf |
1 | 0 | 0.00 | 1.00 | 28 | 0 | 3 | 0.00 |
| APPS_TS_TX_DATA | /slot/ems8643/oracle/VIS/db/apps_st/data/tx_data10.dbf |
4 | 0 | 0.00 | 1.00 | 401 | 0 | 545 | 0.00 |
| APPS_TS_TX_DATA | /slot/ems8643/oracle/VIS/db/apps_st/data/tx_data11.dbf |
1,461 | 1 | 0.65 | 1.00 | 8,827 | 5 | 16,319 | 0.03 |
| APPS_TS_TX_DATA | /slot/ems8643/oracle/VIS/db/apps_st/data/tx_data12.dbf |
18 | 0 | 0.56 | 1.00 | 8,650 | 5 | 16,922 | 0.02 |
| APPS_TS_TX_DATA | /slot/ems8643/oracle/VIS/db/apps_st/data/tx_data13.dbf |
446 | 0 | 0.49 | 1.00 | 1,499 | 1 | 1,980 | 0.01 |
| APPS_TS_TX_DATA | /slot/ems8643/oracle/VIS/db/apps_st/data/tx_data14.dbf |
1 | 0 | 0.00 | 1.00 | 18 | 0 | 8 | 0.00 |
| APPS_TS_TX_DATA | /slot/ems8643/oracle/VIS/db/apps_st/data/tx_data15.dbf |
1 | 0 | 0.00 | 1.00 | 26 | 0 | 26 | 0.00 |
| APPS_TS_TX_DATA | /slot/ems8643/oracle/VIS/db/apps_st/data/tx_data16.dbf |
2 | 0 | 0.00 | 1.00 | 427 | 0 | 518 | 0.02 |
| APPS_TS_TX_DATA | /slot/ems8643/oracle/VIS/db/apps_st/data/tx_data17.dbf |
2 | 0 | 0.00 | 1.00 | 18 | 0 | 5 | 0.00 |
| APPS_TS_TX_DATA | /slot/ems8643/oracle/VIS/db/apps_st/data/tx_data18.dbf |
2 | 0 | 0.00 | 1.00 | 26 | 0 | 1 | 0.00 |
| APPS_TS_TX_DATA | /slot/ems8643/oracle/VIS/db/apps_st/data/tx_data19.dbf |
8 | 0 | 1.25 | 1.75 | 442 | 0 | 1,716 | 0.03 |
| APPS_TS_TX_DATA | /slot/ems8643/oracle/VIS/db/apps_st/data/tx_data2.dbf |
2 | 0 | 0.00 | 1.00 | 1,304 | 1 | 1,783 | 0.03 |
| APPS_TS_TX_DATA | /slot/ems8643/oracle/VIS/db/apps_st/data/tx_data20.dbf |
4 | 0 | 0.00 | 1.00 | 26 | 0 | 3 | 0.00 |
| APPS_TS_TX_DATA | /slot/ems8643/oracle/VIS/db/apps_st/data/tx_data21.dbf |
34 | 0 | 0.29 | 1.00 | 6,191 | 4 | 4,718 | 0.23 |
| APPS_TS_TX_DATA | /slot/ems8643/oracle/VIS/db/apps_st/data/tx_data22.dbf |
21 | 0 | 0.48 | 1.33 | 91 | 0 | 14 | 0.00 |
| APPS_TS_TX_DATA | /slot/ems8643/oracle/VIS/db/apps_st/data/tx_data23.dbf |
23 | 0 | 0.87 | 1.00 | 53 | 0 | 17 | 0.00 |
| APPS_TS_TX_DATA | /slot/ems8643/oracle/VIS/db/apps_st/data/tx_data24.dbf |
4 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
| APPS_TS_TX_DATA | /slot/ems8643/oracle/VIS/db/apps_st/data/tx_data25.dbf |
4 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
| APPS_TS_TX_DATA | /slot/ems8643/oracle/VIS/db/apps_st/data/tx_data26.dbf |
4 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
| APPS_TS_TX_DATA | /slot/ems8643/oracle/VIS/db/apps_st/data/tx_data27.dbf |
2 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
| APPS_TS_TX_DATA | /slot/ems8643/oracle/VIS/db/apps_st/data/tx_data28.dbf |
6 | 0 | 0.00 | 1.00 | 21 | 0 | 76 | 0.00 |
| APPS_TS_TX_DATA | /slot/ems8643/oracle/VIS/db/apps_st/data/tx_data29.dbf |
7 | 0 | 7.14 | 1.00 | 163 | 0 | 7,442 | 0.01 |
| APPS_TS_TX_DATA | /slot/ems8643/oracle/VIS/db/apps_st/data/tx_data3.dbf |
2 | 0 | 0.00 | 1.00 | 22 | 0 | 7 | 0.00 |
| APPS_TS_TX_DATA | /slot/ems8643/oracle/VIS/db/apps_st/data/tx_data30.dbf |
21 | 0 | 1.43 | 1.90 | 183 | 0 | 108 | 0.00 |
| APPS_TS_TX_DATA | /slot/ems8643/oracle/VIS/db/apps_st/data/tx_data31.dbf |
5 | 0 | 0.00 | 1.00 | 123 | 0 | 57 | 0.00 |
| APPS_TS_TX_DATA | /slot/ems8643/oracle/VIS/db/apps_st/data/tx_data32.dbf |
5 | 0 | 0.00 | 1.00 | 107 | 0 | 56 | 0.00 |
| APPS_TS_TX_DATA | /slot/ems8643/oracle/VIS/db/apps_st/data/tx_data33.dbf |
5 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
| APPS_TS_TX_DATA | /slot/ems8643/oracle/VIS/db/apps_st/data/tx_data34.dbf |
5 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
| APPS_TS_TX_DATA | /slot/ems8643/oracle/VIS/db/apps_st/data/tx_data35.dbf |
6 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
| APPS_TS_TX_DATA | /slot/ems8643/oracle/VIS/db/apps_st/data/tx_data36.dbf |
6 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
| APPS_TS_TX_DATA | /slot/ems8643/oracle/VIS/db/apps_st/data/tx_data37.dbf |
6 | 0 | 0.00 | 1.00 | 3 | 0 | 0 | 0.00 |
| APPS_TS_TX_DATA | /slot/ems8643/oracle/VIS/db/apps_st/data/tx_data38.dbf |
6 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
| APPS_TS_TX_DATA | /slot/ems8643/oracle/VIS/db/apps_st/data/tx_data39.dbf |
7 | 0 | 0.00 | 1.00 | 6,139 | 4 | 4,597 | 0.01 |
| APPS_TS_TX_DATA | /slot/ems8643/oracle/VIS/db/apps_st/data/tx_data4.dbf |
2 | 0 | 0.00 | 1.00 | 158 | 0 | 41 | 0.00 |
| APPS_TS_TX_DATA | /slot/ems8643/oracle/VIS/db/apps_st/data/tx_data40.dbf |
6 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
| APPS_TS_TX_DATA | /slot/ems8643/oracle/VIS/db/apps_st/data/tx_data41.dbf |
8 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
| APPS_TS_TX_DATA | /slot/ems8643/oracle/VIS/db/apps_st/data/tx_data42.dbf |
8 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
| APPS_TS_TX_DATA | /slot/ems8643/oracle/VIS/db/apps_st/data/tx_data43.dbf |
19 | 0 | 0.53 | 2.05 | 6,139 | 4 | 5,725 | 0.19 |
| APPS_TS_TX_DATA | /slot/ems8643/oracle/VIS/db/apps_st/data/tx_data44.dbf |
1,471 | 1 | 0.67 | 1.00 | 9,156 | 5 | 15,788 | 0.16 |
| APPS_TS_TX_DATA | /slot/ems8643/oracle/VIS/db/apps_st/data/tx_data45.dbf |
1,434 | 1 | 0.62 | 1.00 | 9,406 | 6 | 16,161 | 0.06 |
| APPS_TS_TX_DATA | /slot/ems8643/oracle/VIS/db/apps_st/data/tx_data46.dbf |
13 | 0 | 1.54 | 1.00 | 872 | 1 | 804 | 0.15 |
| APPS_TS_TX_DATA | /slot/ems8643/oracle/VIS/db/apps_st/data/tx_data47.dbf |
1,426 | 1 | 0.74 | 1.00 | 9,377 | 6 | 16,058 | 0.09 |
| APPS_TS_TX_DATA | /slot/ems8643/oracle/VIS/db/apps_st/data/tx_data48.dbf |
1,462 | 1 | 0.62 | 1.00 | 9,318 | 6 | 14,430 | 0.02 |
| APPS_TS_TX_DATA | /slot/ems8643/oracle/VIS/db/apps_st/data/tx_data49.dbf |
1,477 | 1 | 0.60 | 1.00 | 9,457 | 6 | 13,280 | 0.02 |
| APPS_TS_TX_DATA | /slot/ems8643/oracle/VIS/db/apps_st/data/tx_data5.dbf |
2 | 0 | 0.00 | 1.00 | 33 | 0 | 3 | 0.00 |
| APPS_TS_TX_DATA | /slot/ems8643/oracle/VIS/db/apps_st/data/tx_data50.dbf |
1,461 | 1 | 0.56 | 1.00 | 9,422 | 6 | 16,401 | 0.08 |
| APPS_TS_TX_DATA | /slot/ems8643/oracle/VIS/db/apps_st/data/tx_data51.dbf |
1,490 | 1 | 0.57 | 1.00 | 9,404 | 6 | 16,940 | 0.20 |
| APPS_TS_TX_DATA | /slot/ems8643/oracle/VIS/db/apps_st/data/tx_data52.dbf |
8 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
| APPS_TS_TX_DATA | /slot/ems8643/oracle/VIS/db/apps_st/data/tx_data53.dbf |
1,470 | 1 | 0.61 | 1.00 | 9,059 | 5 | 18,495 | 0.13 |
| APPS_TS_TX_DATA | /slot/ems8643/oracle/VIS/db/apps_st/data/tx_data54.dbf |
1,456 | 1 | 0.81 | 1.00 | 9,051 | 5 | 18,626 | 0.09 |
| APPS_TS_TX_DATA | /slot/ems8643/oracle/VIS/db/apps_st/data/tx_data55.dbf |
1,442 | 1 | 0.75 | 1.00 | 9,073 | 5 | 16,742 | 0.15 |
| APPS_TS_TX_DATA | /slot/ems8643/oracle/VIS/db/apps_st/data/tx_data56.dbf |
1,459 | 1 | 0.71 | 1.00 | 9,077 | 5 | 14,830 | 0.09 |
| APPS_TS_TX_DATA | /slot/ems8643/oracle/VIS/db/apps_st/data/tx_data57.dbf |
6 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
| APPS_TS_TX_DATA | /slot/ems8643/oracle/VIS/db/apps_st/data/tx_data58.dbf |
506 | 0 | 0.53 | 1.00 | 4,654 | 3 | 5,978 | 0.05 |
| APPS_TS_TX_DATA | /slot/ems8643/oracle/VIS/db/apps_st/data/tx_data59.dbf |
469 | 0 | 0.41 | 1.00 | 4,656 | 3 | 5,800 | 0.05 |
| APPS_TS_TX_DATA | /slot/ems8643/oracle/VIS/db/apps_st/data/tx_data6.dbf |
2 | 0 | 0.00 | 1.00 | 12 | 0 | 2 | 0.00 |
| APPS_TS_TX_DATA | /slot/ems8643/oracle/VIS/db/apps_st/data/tx_data60.dbf |
471 | 0 | 0.38 | 1.00 | 4,669 | 3 | 5,626 | 0.02 |
| APPS_TS_TX_DATA | /slot/ems8643/oracle/VIS/db/apps_st/data/tx_data61.dbf |
461 | 0 | 0.37 | 1.00 | 4,757 | 3 | 6,702 | 0.03 |
| APPS_TS_TX_DATA | /slot/ems8643/oracle/VIS/db/apps_st/data/tx_data62.dbf |
472 | 0 | 0.51 | 1.00 | 4,484 | 3 | 4,664 | 0.02 |
| APPS_TS_TX_DATA | /slot/ems8643/oracle/VIS/db/apps_st/data/tx_data63.dbf |
464 | 0 | 0.54 | 1.00 | 4,656 | 3 | 5,140 | 0.02 |
| APPS_TS_TX_DATA | /slot/ems8643/oracle/VIS/db/apps_st/data/tx_data64.dbf |
461 | 0 | 0.39 | 1.00 | 4,677 | 3 | 6,178 | 0.06 |
| APPS_TS_TX_DATA | /slot/ems8643/oracle/VIS/db/apps_st/data/tx_data65.dbf |
454 | 0 | 0.44 | 1.00 | 4,742 | 3 | 7,641 | 0.01 |
| APPS_TS_TX_DATA | /slot/ems8643/oracle/VIS/db/apps_st/data/tx_data66.dbf |
461 | 0 | 0.52 | 1.00 | 4,753 | 3 | 6,165 | 0.02 |
| APPS_TS_TX_DATA | /slot/ems8643/oracle/VIS/db/apps_st/data/tx_data67.dbf |
467 | 0 | 0.39 | 1.00 | 4,942 | 3 | 5,424 | 0.02 |
| APPS_TS_TX_DATA | /slot/ems8643/oracle/VIS/db/apps_st/data/tx_data68.dbf |
468 | 0 | 0.36 | 1.00 | 4,519 | 3 | 5,731 | 0.02 |
| APPS_TS_TX_DATA | /slot/ems8643/oracle/VIS/db/apps_st/data/tx_data69.dbf |
475 | 0 | 0.38 | 1.00 | 4,446 | 3 | 5,931 | 0.02 |
| APPS_TS_TX_DATA | /slot/ems8643/oracle/VIS/db/apps_st/data/tx_data7.dbf |
2 | 0 | 0.00 | 1.00 | 405 | 0 | 504 | 0.02 |
| APPS_TS_TX_DATA | /slot/ems8643/oracle/VIS/db/apps_st/data/tx_data70.dbf |
465 | 0 | 0.41 | 1.00 | 4,394 | 3 | 5,989 | 0.05 |
| APPS_TS_TX_DATA | /slot/ems8643/oracle/VIS/db/apps_st/data/tx_data71.dbf |
471 | 0 | 0.42 | 1.00 | 4,569 | 3 | 4,228 | 0.05 |
| APPS_TS_TX_DATA | /slot/ems8643/oracle/VIS/db/apps_st/data/tx_data72.dbf |
462 | 0 | 0.48 | 1.00 | 4,716 | 3 | 5,132 | 0.05 |
| APPS_TS_TX_DATA | /slot/ems8643/oracle/VIS/db/apps_st/data/tx_data73.dbf |
469 | 0 | 0.36 | 1.00 | 4,576 | 3 | 6,782 | 0.03 |
| APPS_TS_TX_DATA | /slot/ems8643/oracle/VIS/db/apps_st/data/tx_data74.dbf |
467 | 0 | 0.39 | 1.00 | 4,404 | 3 | 5,881 | 0.03 |
| APPS_TS_TX_DATA | /slot/ems8643/oracle/VIS/db/apps_st/data/tx_data75.dbf |
459 | 0 | 0.52 | 1.00 | 4,773 | 3 | 28,019 | 0.04 |
| APPS_TS_TX_DATA | /slot/ems8643/oracle/VIS/db/apps_st/data/tx_data76.dbf |
463 | 0 | 0.58 | 1.00 | 4,411 | 3 | 6,063 | 0.11 |
| APPS_TS_TX_DATA | /slot/ems8643/oracle/VIS/db/apps_st/data/tx_data77.dbf |
450 | 0 | 0.40 | 1.00 | 4,428 | 3 | 7,471 | 0.03 |
| APPS_TS_TX_DATA | /slot/ems8643/oracle/VIS/db/apps_st/data/tx_data78.dbf |
455 | 0 | 0.40 | 1.00 | 4,332 | 3 | 5,665 | 0.04 |
| APPS_TS_TX_DATA | /slot/ems8643/oracle/VIS/db/apps_st/data/tx_data79.dbf |
452 | 0 | 0.44 | 1.00 | 4,544 | 3 | 5,165 | 0.04 |
| APPS_TS_TX_DATA | /slot/ems8643/oracle/VIS/db/apps_st/data/tx_data8.dbf |
2 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
| APPS_TS_TX_DATA | /slot/ems8643/oracle/VIS/db/apps_st/data/tx_data80.dbf |
446 | 0 | 0.54 | 1.00 | 4,621 | 3 | 6,896 | 0.04 |
| APPS_TS_TX_DATA | /slot/ems8643/oracle/VIS/db/apps_st/data/tx_data81.dbf |
454 | 0 | 0.44 | 1.00 | 4,572 | 3 | 8,307 | 0.05 |
| APPS_TS_TX_DATA | /slot/ems8643/oracle/VIS/db/apps_st/data/tx_data82.dbf |
458 | 0 | 0.59 | 1.00 | 4,435 | 3 | 6,047 | 0.11 |
| APPS_TS_TX_DATA | /slot/ems8643/oracle/VIS/db/apps_st/data/tx_data83.dbf |
467 | 0 | 0.51 | 1.00 | 4,417 | 3 | 5,431 | 0.07 |
| APPS_TS_TX_DATA | /slot/ems8643/oracle/VIS/db/apps_st/data/tx_data84.dbf |
7 | 0 | 0.00 | 1.00 | 4,591 | 3 | 5,783 | 0.03 |
| APPS_TS_TX_DATA | /slot/ems8643/oracle/VIS/db/apps_st/data/tx_data85.dbf |
10 | 0 | 0.00 | 1.00 | 4,682 | 3 | 7,189 | 0.04 |
| APPS_TS_TX_DATA | /slot/ems8643/oracle/VIS/db/apps_st/data/tx_data86.dbf |
8 | 0 | 0.00 | 1.00 | 4,741 | 3 | 5,645 | 0.02 |
| APPS_TS_TX_DATA | /slot/ems8643/oracle/VIS/db/apps_st/data/tx_data87.dbf |
7 | 0 | 0.00 | 1.00 | 4,705 | 3 | 5,741 | 0.02 |
| APPS_TS_TX_DATA | /slot/ems8643/oracle/VIS/db/apps_st/data/tx_data88.dbf |
7 | 0 | 0.00 | 1.00 | 4,561 | 3 | 5,661 | 0.03 |
| APPS_TS_TX_DATA | /slot/ems8643/oracle/VIS/db/apps_st/data/tx_data89.dbf |
8 | 0 | 0.00 | 1.00 | 4,543 | 3 | 6,160 | 0.03 |
| APPS_TS_TX_DATA | /slot/ems8643/oracle/VIS/db/apps_st/data/tx_data9.dbf |
3 | 0 | 0.00 | 1.00 | 215 | 0 | 176 | 0.00 |
| APPS_TS_TX_DATA | /slot/ems8643/oracle/VIS/db/apps_st/data/tx_data90.dbf |
7 | 0 | 0.00 | 1.00 | 4,862 | 3 | 4,717 | 0.04 |
| APPS_TS_TX_DATA | /slot/ems8643/oracle/VIS/db/apps_st/data/tx_data91.dbf |
7 | 0 | 0.00 | 1.00 | 5,141 | 3 | 5,946 | 0.04 |
| APPS_TS_TX_DATA | /slot/ems8643/oracle/VIS/db/apps_st/data/tx_data92.dbf |
7 | 0 | 0.00 | 1.00 | 4,696 | 3 | 5,443 | 0.04 |
| APPS_TS_TX_DATA | /slot/ems8643/oracle/VIS/db/apps_st/data/tx_data93.dbf |
9 | 0 | 0.00 | 1.00 | 4,811 | 3 | 6,822 | 0.02 |
| APPS_TS_TX_IDX | /slot/ems8643/oracle/VIS/db/apps_st/data/tx_idx1.dbf |
2 | 0 | 0.00 | 1.00 | 8 | 0 | 0 | 0.00 |
| APPS_TS_TX_IDX | /slot/ems8643/oracle/VIS/db/apps_st/data/tx_idx10.dbf |
13 | 0 | 0.77 | 1.00 | 1,046 | 1 | 124 | 0.48 |
| APPS_TS_TX_IDX | /slot/ems8643/oracle/VIS/db/apps_st/data/tx_idx11.dbf |
4 | 0 | 27.50 | 1.00 | 177 | 0 | 24 | 0.00 |
| APPS_TS_TX_IDX | /slot/ems8643/oracle/VIS/db/apps_st/data/tx_idx12.dbf |
1 | 0 | 0.00 | 1.00 | 74 | 0 | 0 | 0.00 |
| APPS_TS_TX_IDX | /slot/ems8643/oracle/VIS/db/apps_st/data/tx_idx13.dbf |
1 | 0 | 0.00 | 1.00 | 8 | 0 | 0 | 0.00 |
| APPS_TS_TX_IDX | /slot/ems8643/oracle/VIS/db/apps_st/data/tx_idx14.dbf |
2 | 0 | 0.00 | 1.00 | 21 | 0 | 0 | 0.00 |
| APPS_TS_TX_IDX | /slot/ems8643/oracle/VIS/db/apps_st/data/tx_idx15.dbf |
11 | 0 | 0.00 | 1.00 | 72 | 0 | 7 | 0.00 |
| APPS_TS_TX_IDX | /slot/ems8643/oracle/VIS/db/apps_st/data/tx_idx16.dbf |
6 | 0 | 0.00 | 1.00 | 166 | 0 | 39 | 0.00 |
| APPS_TS_TX_IDX | /slot/ems8643/oracle/VIS/db/apps_st/data/tx_idx17.dbf |
17 | 0 | 0.59 | 1.00 | 857 | 1 | 21 | 0.48 |
| APPS_TS_TX_IDX | /slot/ems8643/oracle/VIS/db/apps_st/data/tx_idx18.dbf |
13 | 0 | 0.77 | 1.00 | 780 | 0 | 117 | 0.00 |
| APPS_TS_TX_IDX | /slot/ems8643/oracle/VIS/db/apps_st/data/tx_idx19.dbf |
9 | 0 | 1.11 | 1.00 | 340 | 0 | 16 | 0.00 |
| APPS_TS_TX_IDX | /slot/ems8643/oracle/VIS/db/apps_st/data/tx_idx2.dbf |
24 | 0 | 4.17 | 1.00 | 91 | 0 | 41 | 5.61 |
| APPS_TS_TX_IDX | /slot/ems8643/oracle/VIS/db/apps_st/data/tx_idx20.dbf |
10 | 0 | 1.00 | 1.00 | 272 | 0 | 16 | 0.00 |
| APPS_TS_TX_IDX | /slot/ems8643/oracle/VIS/db/apps_st/data/tx_idx21.dbf |
25 | 0 | 0.80 | 1.00 | 412 | 0 | 11 | 2.73 |
| APPS_TS_TX_IDX | /slot/ems8643/oracle/VIS/db/apps_st/data/tx_idx22.dbf |
15 | 0 | 0.00 | 1.00 | 1,649 | 1 | 370 | 0.00 |
| APPS_TS_TX_IDX | /slot/ems8643/oracle/VIS/db/apps_st/data/tx_idx23.dbf |
19 | 0 | 2.11 | 1.00 | 1,497 | 1 | 496 | 0.00 |
| APPS_TS_TX_IDX | /slot/ems8643/oracle/VIS/db/apps_st/data/tx_idx24.dbf |
132 | 0 | 0.76 | 1.00 | 53 | 0 | 84 | 7.62 |
| APPS_TS_TX_IDX | /slot/ems8643/oracle/VIS/db/apps_st/data/tx_idx25.dbf |
2,624 | 2 | 0.58 | 1.00 | 37,107 | 22 | 1,436 | 0.04 |
| APPS_TS_TX_IDX | /slot/ems8643/oracle/VIS/db/apps_st/data/tx_idx26.dbf |
2,556 | 2 | 0.65 | 1.00 | 37,079 | 22 | 1,438 | 0.16 |
| APPS_TS_TX_IDX | /slot/ems8643/oracle/VIS/db/apps_st/data/tx_idx27.dbf |
354 | 0 | 0.54 | 1.00 | 1 | 0 | 82 | 0.61 |
| APPS_TS_TX_IDX | /slot/ems8643/oracle/VIS/db/apps_st/data/tx_idx28.dbf |
2,155 | 1 | 0.67 | 1.00 | 42,081 | 25 | 31,917 | 0.05 |
| APPS_TS_TX_IDX | /slot/ems8643/oracle/VIS/db/apps_st/data/tx_idx29.dbf |
8 | 0 | 0.00 | 1.00 | 167 | 0 | 285 | 0.00 |
| APPS_TS_TX_IDX | /slot/ems8643/oracle/VIS/db/apps_st/data/tx_idx3.dbf |
366 | 0 | 0.55 | 1.00 | 11 | 0 | 98 | 0.71 |
| APPS_TS_TX_IDX | /slot/ems8643/oracle/VIS/db/apps_st/data/tx_idx30.dbf |
124 | 0 | 0.32 | 1.00 | 2,639 | 2 | 198 | 0.05 |
| APPS_TS_TX_IDX | /slot/ems8643/oracle/VIS/db/apps_st/data/tx_idx31.dbf |
149 | 0 | 0.54 | 1.00 | 4,820 | 3 | 12,893 | 0.16 |
| APPS_TS_TX_IDX | /slot/ems8643/oracle/VIS/db/apps_st/data/tx_idx32.dbf |
146 | 0 | 0.41 | 1.00 | 6,369 | 4 | 46,278 | 0.14 |
| APPS_TS_TX_IDX | /slot/ems8643/oracle/VIS/db/apps_st/data/tx_idx33.dbf |
138 | 0 | 1.38 | 1.00 | 7,585 | 5 | 50,076 | 0.14 |
| APPS_TS_TX_IDX | /slot/ems8643/oracle/VIS/db/apps_st/data/tx_idx34.dbf |
145 | 0 | 0.76 | 1.00 | 7,647 | 5 | 47,650 | 0.12 |
| APPS_TS_TX_IDX | /slot/ems8643/oracle/VIS/db/apps_st/data/tx_idx35.dbf |
153 | 0 | 0.78 | 1.00 | 8,930 | 5 | 61,900 | 0.16 |
| APPS_TS_TX_IDX | /slot/ems8643/oracle/VIS/db/apps_st/data/tx_idx36.dbf |
143 | 0 | 1.19 | 1.00 | 6,100 | 4 | 49,010 | 0.12 |
| APPS_TS_TX_IDX | /slot/ems8643/oracle/VIS/db/apps_st/data/tx_idx37.dbf |
139 | 0 | 0.86 | 1.00 | 7,264 | 4 | 53,604 | 0.16 |
| APPS_TS_TX_IDX | /slot/ems8643/oracle/VIS/db/apps_st/data/tx_idx38.dbf |
160 | 0 | 0.44 | 1.00 | 10,500 | 6 | 84,532 | 0.17 |
| APPS_TS_TX_IDX | /slot/ems8643/oracle/VIS/db/apps_st/data/tx_idx39.dbf |
146 | 0 | 0.62 | 1.00 | 11,018 | 7 | 76,542 | 0.11 |
| APPS_TS_TX_IDX | /slot/ems8643/oracle/VIS/db/apps_st/data/tx_idx4.dbf |
27 | 0 | 0.37 | 1.00 | 16 | 0 | 292 | 0.00 |
| APPS_TS_TX_IDX | /slot/ems8643/oracle/VIS/db/apps_st/data/tx_idx40.dbf |
142 | 0 | 0.42 | 1.00 | 11,401 | 7 | 82,958 | 0.14 |
| APPS_TS_TX_IDX | /slot/ems8643/oracle/VIS/db/apps_st/data/tx_idx41.dbf |
136 | 0 | 0.81 | 1.00 | 10,948 | 6 | 81,587 | 0.13 |
| APPS_TS_TX_IDX | /slot/ems8643/oracle/VIS/db/apps_st/data/tx_idx42.dbf |
139 | 0 | 1.51 | 1.00 | 11,220 | 7 | 80,349 | 0.13 |
| APPS_TS_TX_IDX | /slot/ems8643/oracle/VIS/db/apps_st/data/tx_idx43.dbf |
136 | 0 | 0.44 | 1.00 | 11,247 | 7 | 85,886 | 0.16 |
| APPS_TS_TX_IDX | /slot/ems8643/oracle/VIS/db/apps_st/data/tx_idx44.dbf |
139 | 0 | 0.43 | 1.00 | 10,772 | 6 | 77,557 | 0.13 |
| APPS_TS_TX_IDX | /slot/ems8643/oracle/VIS/db/apps_st/data/tx_idx45.dbf |
148 | 0 | 0.54 | 1.00 | 10,458 | 6 | 78,769 | 0.12 |
| APPS_TS_TX_IDX | /slot/ems8643/oracle/VIS/db/apps_st/data/tx_idx46.dbf |
143 | 0 | 0.35 | 1.00 | 10,656 | 6 | 77,794 | 0.12 |
| APPS_TS_TX_IDX | /slot/ems8643/oracle/VIS/db/apps_st/data/tx_idx47.dbf |
137 | 0 | 0.80 | 1.00 | 10,505 | 6 | 77,495 | 0.13 |
| APPS_TS_TX_IDX | /slot/ems8643/oracle/VIS/db/apps_st/data/tx_idx48.dbf |
127 | 0 | 0.79 | 1.00 | 11,039 | 7 | 77,605 | 0.12 |
| APPS_TS_TX_IDX | /slot/ems8643/oracle/VIS/db/apps_st/data/tx_idx49.dbf |
131 | 0 | 0.99 | 1.00 | 10,598 | 6 | 75,077 | 0.13 |
| APPS_TS_TX_IDX | /slot/ems8643/oracle/VIS/db/apps_st/data/tx_idx5.dbf |
29 | 0 | 1.72 | 1.00 | 61 | 0 | 17 | 5.88 |
| APPS_TS_TX_IDX | /slot/ems8643/oracle/VIS/db/apps_st/data/tx_idx50.dbf |
143 | 0 | 1.82 | 1.00 | 10,591 | 6 | 81,265 | 0.13 |
| APPS_TS_TX_IDX | /slot/ems8643/oracle/VIS/db/apps_st/data/tx_idx51.dbf |
119 | 0 | 0.50 | 1.00 | 11,222 | 7 | 77,344 | 0.12 |
| APPS_TS_TX_IDX | /slot/ems8643/oracle/VIS/db/apps_st/data/tx_idx52.dbf |
130 | 0 | 0.54 | 1.00 | 10,700 | 6 | 73,905 | 0.12 |
| APPS_TS_TX_IDX | /slot/ems8643/oracle/VIS/db/apps_st/data/tx_idx53.dbf |
152 | 0 | 0.46 | 1.00 | 11,040 | 7 | 80,204 | 0.14 |
| APPS_TS_TX_IDX | /slot/ems8643/oracle/VIS/db/apps_st/data/tx_idx54.dbf |
133 | 0 | 0.53 | 1.00 | 10,740 | 6 | 74,688 | 0.15 |
| APPS_TS_TX_IDX | /slot/ems8643/oracle/VIS/db/apps_st/data/tx_idx55.dbf |
125 | 0 | 0.80 | 1.00 | 10,451 | 6 | 76,261 | 0.13 |
| APPS_TS_TX_IDX | /slot/ems8643/oracle/VIS/db/apps_st/data/tx_idx56.dbf |
132 | 0 | 0.45 | 1.00 | 10,679 | 6 | 78,012 | 0.13 |
| APPS_TS_TX_IDX | /slot/ems8643/oracle/VIS/db/apps_st/data/tx_idx57.dbf |
108 | 0 | 0.46 | 1.00 | 10,302 | 6 | 76,042 | 0.11 |
| APPS_TS_TX_IDX | /slot/ems8643/oracle/VIS/db/apps_st/data/tx_idx58.dbf |
100 | 0 | 0.40 | 1.00 | 10,378 | 6 | 79,076 | 0.13 |
| APPS_TS_TX_IDX | /slot/ems8643/oracle/VIS/db/apps_st/data/tx_idx59.dbf |
118 | 0 | 0.25 | 1.00 | 10,468 | 6 | 76,768 | 0.16 |
| APPS_TS_TX_IDX | /slot/ems8643/oracle/VIS/db/apps_st/data/tx_idx6.dbf |
373 | 0 | 0.54 | 1.00 | 23 | 0 | 108 | 0.74 |
| APPS_TS_TX_IDX | /slot/ems8643/oracle/VIS/db/apps_st/data/tx_idx60.dbf |
131 | 0 | 1.37 | 1.00 | 11,112 | 7 | 73,256 | 0.14 |
| APPS_TS_TX_IDX | /slot/ems8643/oracle/VIS/db/apps_st/data/tx_idx61.dbf |
127 | 0 | 0.63 | 1.00 | 10,388 | 6 | 73,349 | 0.10 |
| APPS_TS_TX_IDX | /slot/ems8643/oracle/VIS/db/apps_st/data/tx_idx62.dbf |
124 | 0 | 0.73 | 1.00 | 10,138 | 6 | 75,395 | 0.13 |
| APPS_TS_TX_IDX | /slot/ems8643/oracle/VIS/db/apps_st/data/tx_idx63.dbf |
118 | 0 | 0.59 | 1.00 | 10,062 | 6 | 69,163 | 0.14 |
| APPS_TS_TX_IDX | /slot/ems8643/oracle/VIS/db/apps_st/data/tx_idx64.dbf |
120 | 0 | 1.25 | 1.00 | 9,547 | 6 | 70,704 | 0.13 |
| APPS_TS_TX_IDX | /slot/ems8643/oracle/VIS/db/apps_st/data/tx_idx65.dbf |
123 | 0 | 0.65 | 1.00 | 10,111 | 6 | 72,103 | 0.12 |
| APPS_TS_TX_IDX | /slot/ems8643/oracle/VIS/db/apps_st/data/tx_idx66.dbf |
122 | 0 | 1.23 | 1.00 | 9,660 | 6 | 78,128 | 0.15 |
| APPS_TS_TX_IDX | /slot/ems8643/oracle/VIS/db/apps_st/data/tx_idx67.dbf |
122 | 0 | 1.72 | 1.00 | 9,607 | 6 | 71,170 | 0.13 |
| APPS_TS_TX_IDX | /slot/ems8643/oracle/VIS/db/apps_st/data/tx_idx68.dbf |
102 | 0 | 2.25 | 1.00 | 9,730 | 6 | 75,423 | 0.13 |
| APPS_TS_TX_IDX | /slot/ems8643/oracle/VIS/db/apps_st/data/tx_idx69.dbf |
110 | 0 | 0.55 | 1.00 | 10,548 | 6 | 69,948 | 0.12 |
| APPS_TS_TX_IDX | /slot/ems8643/oracle/VIS/db/apps_st/data/tx_idx7.dbf |
4 | 0 | 2.50 | 1.00 | 43 | 0 | 164 | 0.18 |
| APPS_TS_TX_IDX | /slot/ems8643/oracle/VIS/db/apps_st/data/tx_idx70.dbf |
122 | 0 | 0.66 | 1.00 | 10,348 | 6 | 74,326 | 0.12 |
| APPS_TS_TX_IDX | /slot/ems8643/oracle/VIS/db/apps_st/data/tx_idx71.dbf |
122 | 0 | 1.07 | 1.00 | 9,782 | 6 | 72,116 | 0.11 |
| APPS_TS_TX_IDX | /slot/ems8643/oracle/VIS/db/apps_st/data/tx_idx72.dbf |
120 | 0 | 0.42 | 1.00 | 9,598 | 6 | 75,407 | 0.11 |
| APPS_TS_TX_IDX | /slot/ems8643/oracle/VIS/db/apps_st/data/tx_idx8.dbf |
25 | 0 | 1.20 | 1.00 | 132 | 0 | 17 | 4.12 |
| APPS_TS_TX_IDX | /slot/ems8643/oracle/VIS/db/apps_st/data/tx_idx9.dbf |
39 | 0 | 1.54 | 1.00 | 1,221 | 1 | 92 | 1.09 |
| APPS_UNDOTS1 | /slot/ems8643/oracle/VIS/db/apps_st/data/undo.dbf |
1 | 0 | 0.00 | 1.00 | 86,737 | 51 | 35,070 | 0.03 |
| APPS_UNDOTS1 | /slot/ems8643/oracle/VIS/db/apps_st/data/undo2.dbf |
6 | 0 | 0.00 | 1.00 | 86,904 | 52 | 37,586 | 0.02 |
| APPS_UNDOTS1 | /slot/ems8643/oracle/VIS/db/apps_st/data/undo3.dbf |
7 | 0 | 0.00 | 1.00 | 92,158 | 55 | 50,839 | 0.02 |
| APPS_UNDOTS1 | /slot/ems8643/oracle/VIS/db/apps_st/data/undo4.dbf |
7 | 0 | 0.00 | 1.00 | 101,703 | 60 | 74,852 | 0.03 |
| APPS_UNDOTS1 | /slot/ems8643/oracle/VIS/db/apps_st/data/undo5.dbf |
6 | 0 | 0.00 | 1.00 | 95,524 | 57 | 47,867 | 0.03 |
| APPS_UNDOTS1 | /slot/ems8643/oracle/VIS/db/apps_st/data/undo6.dbf |
6 | 0 | 0.00 | 1.00 | 92,441 | 55 | 43,928 | 0.03 |
| APPS_UNDOTS1 | /slot/ems8643/oracle/VIS/db/apps_st/data/undo7.dbf |
6 | 0 | 0.00 | 1.00 | 91,618 | 54 | 50,733 | 0.03 |
| APPS_UNDOTS1 | /slot/ems8643/oracle/VIS/db/apps_st/data/undo8.dbf |
7 | 0 | 0.00 | 1.00 | 83,549 | 50 | 37,159 | 0.02 |
| APPS_UNDOTS1 | /slot/ems8643/oracle/VIS/db/apps_st/data/undo9.dbf |
6 | 0 | 0.00 | 1.00 | 84,587 | 50 | 38,565 | 0.03 |
| B2B_DT | /slot/ems8643/oracle/VIS/db/apps_st/data/b2b_dt.dbf |
7 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
| B2B_IDX | /slot/ems8643/oracle/VIS/db/apps_st/data/b2b_idx.dbf |
6 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
| B2B_LOB | /slot/ems8643/oracle/VIS/db/apps_st/data/b2b_lob.dbf |
6 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
| B2B_RT | /slot/ems8643/oracle/VIS/db/apps_st/data/b2b_rt.dbf |
7 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
| BAM | /slot/ems8643/oracle/VIS/db/apps_st/data/bam.dbf |
6 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
| CTXSYS | /slot/ems8643/oracle/VIS/db/apps_st/data/ctx1.dbf |
84 | 0 | 0.71 | 1.00 | 1 | 0 | 0 | 0.00 |
| CWMLITE | /slot/ems8643/oracle/VIS/db/apps_st/data/cwmlite01.dbf |
1 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
| CWMLITE | /slot/ems8643/oracle/VIS/db/apps_st/data/cwmlite02.dbf |
6 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
| DCM | /slot/ems8643/oracle/VIS/db/apps_st/data/dcm.dbf |
7 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
| DCM | /slot/ems8643/oracle/VIS/db/apps_st/data/dcm1.dbf |
5 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
| DISCO_PTM5_CACHE | /slot/ems8643/oracle/VIS/db/apps_st/data/discopltc1.dbf |
7 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
| DISCO_PTM5_META | /slot/ems8643/oracle/VIS/db/apps_st/data/discopltm1.dbf |
6 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
| DSGATEWAY_TAB | /slot/ems8643/oracle/VIS/db/apps_st/data/oss_sys01.dbf |
7 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
| GEOR_TBS | /slot/ems8643/oracle/VIS/db/apps_st/data/apps_ts_spatial.dbf |
7 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
| GEOR_TBS | /slot/ems8643/oracle/VIS/db/apps_st/data/geor_tbs02.dbf |
6 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
| HTMLDB | /slot/ems8643/oracle/VIS/db/apps_st/data/htmldb.dbf |
563 | 0 | 1.33 | 1.00 | 1 | 0 | 0 | 0.00 |
| IAS_META | /slot/ems8643/oracle/VIS/db/apps_st/data/ias_meta01.dbf |
15 | 0 | 0.67 | 1.00 | 1 | 0 | 0 | 0.00 |
| MTR | /slot/ems8643/oracle/VIS/db/apps_st/data/opmtr01.dbf |
31 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
| NOETIX | /slot/ems8643/oracle/VIS/db/apps_st/data/noetix.dbf |
6 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
| NON_APPS_TS_DATA | /slot/ems8643/oracle/VIS/db/apps_st/data/non_apps_data1.dbf |
487 | 0 | 0.35 | 1.00 | 1 | 0 | 0 | 0.00 |
| OCATS | /slot/ems8643/oracle/VIS/db/apps_st/data/oca.dbf |
6 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
| ODM_DATA | /slot/ems8643/oracle/VIS/db/apps_st/data/odm.dbf |
206 | 0 | 0.87 | 1.00 | 1 | 0 | 0 | 0.00 |
| OLTS_ATTRSTORE | /slot/ems8643/oracle/VIS/db/apps_st/data/attrs1_oid.dbf |
6 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
| OLTS_BATTRSTORE | /slot/ems8643/oracle/VIS/db/apps_st/data/battrs1_oid.dbf |
6 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
| OLTS_CT_STORE | /slot/ems8643/oracle/VIS/db/apps_st/data/gcats1_oid.dbf |
6 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
| OLTS_DEFAULT | /slot/ems8643/oracle/VIS/db/apps_st/data/gdefault1_oid.dbf |
6 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
| OLTS_SVRMGSTORE | /slot/ems8643/oracle/VIS/db/apps_st/data/svrmg1_oid.dbf |
6 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
| OPMOR | /slot/ems8643/oracle/VIS/db/apps_st/data/opmor01.dbf |
62 | 0 | 0.16 | 1.00 | 1 | 0 | 0 | 0.00 |
| ORABPEL | /slot/ems8643/oracle/VIS/db/apps_st/data/orabpel.dbf |
6 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
| OWAPUB | /slot/ems8643/oracle/VIS/db/apps_st/data/owa1.dbf |
1 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
| PORTAL | /slot/ems8643/oracle/VIS/db/apps_st/data/portal.dbf |
6 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
| PORTAL_DOC | /slot/ems8643/oracle/VIS/db/apps_st/data/ptldoc.dbf |
6 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
| PORTAL_IDX | /slot/ems8643/oracle/VIS/db/apps_st/data/ptlidx.dbf |
6 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
| PORTAL_LOG | /slot/ems8643/oracle/VIS/db/apps_st/data/ptllog.dbf |
6 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
| RE | /slot/ems8643/oracle/VIS/db/apps_st/data/opre01.dbf |
59 | 0 | 0.17 | 1.00 | 1 | 0 | 0 | 0.00 |
| SYNCSERVER | /slot/ems8643/oracle/VIS/db/apps_st/data/mobile01.dbf |
743 | 0 | 0.78 | 1.00 | 1 | 0 | 0 | 0.00 |
| SYSAUX | /slot/ems8643/oracle/VIS/db/apps_st/data/sysaux01.dbf |
472 | 0 | 1.31 | 1.23 | 1,986 | 1 | 0 | 0.00 |
| SYSAUX | /slot/ems8643/oracle/VIS/db/apps_st/data/sysaux02.dbf |
200 | 0 | 1.65 | 1.09 | 702 | 0 | 0 | 0.00 |
| SYSAUX | /slot/ems8643/oracle/VIS/db/apps_st/data/sysaux03.dbf |
107 | 0 | 0.28 | 1.00 | 108 | 0 | 0 | 0.00 |
| SYSAUX | /slot/ems8643/oracle/VIS/db/apps_st/data/sysaux04.dbf |
81 | 0 | 0.25 | 1.00 | 18 | 0 | 0 | 0.00 |
| SYSAUX | /slot/ems8643/oracle/VIS/db/apps_st/data/sysaux05.dbf |
11 | 0 | 0.00 | 1.00 | 16 | 0 | 0 | 0.00 |
| SYSAUX | /slot/ems8643/oracle/VIS/db/apps_st/data/sysaux06.dbf |
12 | 0 | 0.00 | 1.00 | 12 | 0 | 0 | 0.00 |
| SYSTEM | /slot/ems8643/oracle/VIS/db/apps_st/data/sys1.dbf |
1,231 | 1 | 2.13 | 7.80 | 169 | 0 | 1 | 0.00 |
| SYSTEM | /slot/ems8643/oracle/VIS/db/apps_st/data/sys10.dbf |
213 | 0 | 0.70 | 2.39 | 26 | 0 | 649 | 0.08 |
| SYSTEM | /slot/ems8643/oracle/VIS/db/apps_st/data/sys2.dbf |
550 | 0 | 1.13 | 5.36 | 205 | 0 | 17 | 0.00 |
| SYSTEM | /slot/ems8643/oracle/VIS/db/apps_st/data/sys3.dbf |
418 | 0 | 0.86 | 7.04 | 190 | 0 | 0 | 0.00 |
| SYSTEM | /slot/ems8643/oracle/VIS/db/apps_st/data/sys4.dbf |
267 | 0 | 0.82 | 8.66 | 30 | 0 | 0 | 0.00 |
| SYSTEM | /slot/ems8643/oracle/VIS/db/apps_st/data/sys5.dbf |
415 | 0 | 1.23 | 5.97 | 16 | 0 | 1 | 0.00 |
| SYSTEM | /slot/ems8643/oracle/VIS/db/apps_st/data/sys6.dbf |
481 | 0 | 0.91 | 7.12 | 109 | 0 | 0 | 0.00 |
| SYSTEM | /slot/ems8643/oracle/VIS/db/apps_st/data/sys7.dbf |
679 | 0 | 2.14 | 8.34 | 47 | 0 | 0 | 0.00 |
| SYSTEM | /slot/ems8643/oracle/VIS/db/apps_st/data/sys8.dbf |
1,258 | 1 | 0.99 | 3.29 | 74 | 0 | 1 | 10.00 |
| SYSTEM | /slot/ems8643/oracle/VIS/db/apps_st/data/sys9.dbf |
316 | 0 | 0.95 | 1.10 | 1 | 0 | 0 | 0.00 |
| TEMP1 | /slot/ems8643/oracle/VIS/db/apps_st/data/temp1_01.dbf |
54 | 0 | 0.00 | 31.00 | 54 | 0 | 0 | |
| TEMP1 | /slot/ems8643/oracle/VIS/db/apps_st/data/temp1_03.dbf |
43 | 0 | 0.00 | 31.00 | 43 | 0 | 0 | |
| TEMP1 | /slot/ems8643/oracle/VIS/db/apps_st/data/temp1_04.dbf |
0 | 0 | | | 3 | 0 | 0 | |
| TEMP1 | /slot/ems8643/oracle/VIS/db/apps_st/data/temp1_06.dbf |
41 | 0 | 0.00 | 31.00 | 41 | 0 | 0 | |
| UDDISYS_TS | /slot/ems8643/oracle/VIS/db/apps_st/data/uddisys01.dbf |
6 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
| WCRSYS_TS | /slot/ems8643/oracle/VIS/db/apps_st/data/wcrsys01.dbf |
7 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
| XDB | /slot/ems8643/oracle/VIS/db/apps_st/data/xdb01.dbf |
43 | 0 | 4.65 | 23.49 | 1 | 0 | 0 | 0.00 |