TKPROF: Release 9.2.0.4.0 - Production on Wed Apr 28 13:57:02 2004 Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved. Trace file: /opt/app/oracle/product/udump/tkoutput.TRC Sort options: prsela exeela fchela ******************************************************************************** count = number of times OCI procedure was executed cpu = cpu time in seconds executing elapsed = elapsed time in seconds executing disk = number of physical reads of buffers from disk query = number of buffers gotten for consistent read current = number of buffers gotten in current mode (usually for update) rows = number of rows processed by the fetch or execute call ******************************************************************************** EXPLAIN PLAN option disabled. ******************************************************************************** update world_data set server_id=:server_id, key=:key, value=:value, zone_name=:zone_name where world_data_id = :world_data_id call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 33 0.00 0.00 0 0 0 0 Execute 33 0.00 0.05 0 66 331 33 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 66 0.00 0.05 0 66 331 33 Misses in library cache during parse: 0 Optimizer goal: CHOOSE Parsing user id: 21 Rows Row Source Operation ------- --------------------------------------------------- 1 UPDATE (cr=2 r=0 w=0 time=279 us) 1 INDEX UNIQUE SCAN OBJ#(6151) (cr=1 r=0 w=0 time=16 us)(object id 6151) ******************************************************************************** update character_blobs set data=:data where blob_id = :COND_blob_id call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 13 0.00 0.00 0 0 0 0 Execute 13 0.00 0.02 0 60 234 21 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 26 0.00 0.02 0 60 234 21 Misses in library cache during parse: 1 Optimizer goal: CHOOSE Parsing user id: 21 Rows Row Source Operation ------- --------------------------------------------------- 1 UPDATE (cr=3 r=0 w=0 time=291 us) 1 INDEX UNIQUE SCAN OBJ#(6046) (cr=2 r=0 w=0 time=19 us)(object id 6046) ******************************************************************************** update character_store set active=:active, last_name=:last_name, race=:race, gender=:gender, class_id=:class_id, tradeskill_class=:tradeskill_class, pocket_zonename=:pocket_zonename, pocket_loc_x=:pocket_loc_x, pocket_loc_y= :pocket_loc_y, pocket_loc_z=:pocket_loc_z, pocket_heading=:pocket_heading, zonename=:zonename, loc_x=:loc_x, loc_y=:loc_y, loc_z=:loc_z, heading= :heading, bind_zonename=:bind_zonename, bind_x=:bind_x, bind_y=:bind_y, bind_z=:bind_z, bind_heading=:bind_heading, char_level=:char_level, tradeskill_level=:tradeskill_level, experience=:experience, tradeskill_experience=:tradeskill_experience, experience_debt= :experience_debt, debt_decay=:debt_decay, debt_decay_time=:debt_decay_time, waiting_for_subclass=:waiting_for_subclass, cur_hp=:cur_hp, cur_mana= :cur_mana, copper=:copper, silver=:silver, gold=:gold, platinum=:platinum, socials_version_num=:socials_version_num, guild_id=:guild_id, guild_rank= :guild_rank, family_id=:family_id, family_rank=:family_rank, fellowship_id= :fellowship_id, fellowship_rank=:fellowship_rank, fellowship_exp= :fellowship_exp, serial_data=:serial_data, shared_serial=:shared_serial where character_id = :character_id call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 23 0.00 0.00 0 0 0 0 Execute 23 0.01 0.00 0 92 101 23 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 46 0.01 0.01 0 92 101 23 Misses in library cache during parse: 1 Optimizer goal: CHOOSE Parsing user id: 21 Rows Row Source Operation ------- --------------------------------------------------- 2 UPDATE (cr=4 r=0 w=0 time=227 us) 2 INDEX UNIQUE SCAN OBJ#(6039) (cr=4 r=0 w=0 time=33 us)(object id 6039) ******************************************************************************** begin :result_code := eq2.character_methods.delete_character_2( :account_id, :character_id );end; call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.01 0.00 0 0 0 1 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 0.01 0.00 0 0 0 1 Misses in library cache during parse: 1 Optimizer goal: CHOOSE Parsing user id: 21 ******************************************************************************** update equipment_table set character_id=:character_id, container_id= :container_id, slot_num=:slot_num, template_id=:template_id, serial_data= :serial_data where item_id = :COND_item_id call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 14 0.01 0.00 0 0 0 0 Execute 14 0.00 0.00 0 33 71 17 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 28 0.01 0.00 0 33 71 17 Misses in library cache during parse: 1 Optimizer goal: CHOOSE Parsing user id: 21 Rows Row Source Operation ------- --------------------------------------------------- 2 UPDATE (cr=2 r=0 w=0 time=178 us) 2 INDEX UNIQUE SCAN OBJ#(6058) (cr=2 r=0 w=0 time=27 us)(object id 6058) ******************************************************************************** begin :retval := eq2.character_methods.save_ui_settings( :acct_num, :profile_name, :raw_settings ); end; call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.01 0.00 0 0 0 1 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 0.01 0.00 0 0 0 1 Misses in library cache during parse: 1 Optimizer goal: CHOOSE Parsing user id: 21 ******************************************************************************** insert into equipment_table ( item_id, character_id, server_id, container_id, slot_num, template_id, serial_data ) values ( :item_id, :character_id, :server_id, :container_id, :slot_num, :template_id, :serial_data ) call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 14 0.00 0.00 0 0 0 0 Execute 14 0.00 0.00 0 14 125 16 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 28 0.00 0.00 0 14 125 16 Misses in library cache during parse: 1 Optimizer goal: CHOOSE Parsing user id: 21 ******************************************************************************** delete from equipment_table where item_id = :item_id call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 4 0.00 0.00 0 0 0 0 Execute 4 0.00 0.00 0 6 35 6 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 8 0.00 0.00 0 6 35 6 Misses in library cache during parse: 1 Optimizer goal: CHOOSE Parsing user id: 21 Rows Row Source Operation ------- --------------------------------------------------- 1 DELETE (cr=1 r=0 w=0 time=233 us) 1 INDEX UNIQUE SCAN OBJ#(6058) (cr=1 r=0 w=0 time=17 us)(object id 6058) ******************************************************************************** DELETE FROM character_beliefs WHERE character_id = :b1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.00 0.00 0 1 0 0 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 0.00 0.00 0 1 0 0 Misses in library cache during parse: 1 Optimizer goal: CHOOSE Parsing user id: 21 (recursive depth: 1) ******************************************************************************** delete from character_blobs where character_id = :character_id call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.00 0.00 0 2 14 4 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 0.00 0.00 0 2 14 4 Misses in library cache during parse: 1 Optimizer goal: CHOOSE Parsing user id: 21 Rows Row Source Operation ------- --------------------------------------------------- 0 DELETE (cr=2 r=0 w=0 time=509 us) 4 INDEX RANGE SCAN OBJ#(6047) (cr=2 r=0 w=0 time=37 us)(object id 6047) ******************************************************************************** select c.active, c.server_id, c.account_id, c.character_id, c.char_name, c.last_name, c.race, c.gender, c.class_id, c.tradeskill_class, c.zonename,