Home » RDBMS Server » Server Administration » ORA-06502: PL/SQL: numeric or value error: character string buffer too small (product :oracle,version:10203(rac) os:5.3)
|
|
|
|
| Re: ORA-06502: PL/SQL: numeric or value error: character string buffer too small [message #359536 is a reply to message #359531] |
Mon, 17 November 2008 02:54   |
mengxb001
Messages: 4
Registered: December 2007
Location: China
|
Junior Member |
|
|
|
Error encountered in Top Blocking Sessions While executing SQL statement: Len = 6845 SELECT dbms_ash_internal.get_sid_str(ash.blocking_session, ash.blocki ng_session_serial#) as sess, ash.dim1_percentage, ash.event, ash.dim 12_percentage, dbms_ash_internal.get_blksid_user( ash.blocking_s ession, ash.blocking_session_serial#), dbms_ash_internal.get_blk sid_program( ash.blocking_session, ash.blocking_session_seri al#, 30), dbms_ash_internal.get_blksid_active( ash.blocking_sess ion, ash.blocking_session_serial#, 18), dbms_ash_internal.get_bl ksid_xids( ash.blocking_session, ash.blocking_session_serial #) FROM ( SELECT d12aa_ash.* FROM ( SELECT d12gb_ash.*, ( dim1_count*100/:ash_num_rows) as dim1_percentage, dense_rank() over (order by dim1_count desc, blocking _session, blocking_session_serial# ) as dim1_rank FROM ( SELE CT blocking_session, blocking_session_serial# , event , count(*) as dim12_count, (count(*) * 100 / :ash_num_row s) as dim12_percentage, rank() over (partition by blocking_session, blocking_session_serial# order by count(*) desc, event ) as dim12_rank, sum(count(*)) over (partition by blocking_session, blocking_session_serial#) as dim1_count FROM ( SELECT unified_ash.* FROM ( ( SELECT d.dbid , inst.instance_number, 0 as snap_id, a.sample_id, a.sample_tim e, a.session_id, a.session_serial#, a.session_type, a.session_state, a.user_id, a.sql_id, a.sql_opcode, a .sql_child_number, a.sql_plan_hash_value, a.plsql_entry_object_ id, a.plsql_entry_subprogram_id, a.plsql_object_id, a.plsql_sub program_id, a.service_hash, a.qc_session_id, a.qc_instance_id, nvl(a.event, 'CPU + Wait for CPU') as event, nvl(a.event _id, 1) as event_id, nvl(a.wait_class, 'CPU') as wait_class, nvl(a.wait_class_id, 9999) as wait_class_id, a.seq#, a.p1, a.p1text, a.p2, a.p2text, a.p3, a.p3text, a.wait_time, a.time_waited, a.xid, a.blocking_session, a.blocking_session_serial#, a.blocking_session_status, a .current_obj#, a.current_file#, a.current_block#, a.program, a. module, a.action, a.client_id FROM V$ACTIVE_SESSION_HISTORY a, V$DATABASE d, V$INSTANCE inst WHERE 1=1 and :as h_enable_mem_view = 1 and a.sample_time between :ash_mem_ Encountered error: ORA-06502: PL/SQL: numeric or value error: character string buffer too small Continuing to Next Section...
|
|
|
|
|
|
|
|
Goto Forum:
Current Time: Fri Jul 05 11:36:05 CDT 2024
|
] 
Blog
Search
Help
Members
Register
Login
Home
