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)
ORA-06502: PL/SQL: numeric or value error: character string buffer too small [message #359526] Mon, 17 November 2008 02:43 Go to next message
mengxb001
Messages: 4
Registered: December 2007
Location: China
Junior Member
when i run ashrpt.sql,the html page hava a ORA-06502 problem.

how to resolve the problem?thank you .
Re: ORA-06502: PL/SQL: numeric or value error: character string buffer too small [message #359531 is a reply to message #359526] Mon, 17 November 2008 02:51 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You have to show us otherwise we can't help.

Regards
Michel
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 Go to previous messageGo to next message
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...
Re: ORA-06502: PL/SQL: numeric or value error: character string buffer too small [message #359545 is a reply to message #359536] Mon, 17 November 2008 03:09 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
The query is not complete and is not formatted so it is hard to say.
Anyway, I think there is nothing you can do or try to upgrade to 10.2.0.4 maybe it is fixed there.

Regards
Michel

Re: ORA-06502: PL/SQL: numeric or value error: character string buffer too small [message #359553 is a reply to message #359545] Mon, 17 November 2008 04:33 Go to previous message
mengxb001
Messages: 4
Registered: December 2007
Location: China
Junior Member
my db is prod,not upgrade to 10.2.0.4
Previous Topic: Deadlock Occurs
Next Topic: Segment Advisor report
Goto Forum:
  


Current Time: Sat Dec 10 18:43:14 CST 2016

Total time taken to generate the page: 0.04849 seconds