Home » RDBMS Server » Performance Tuning » ADDM report (10g Linux)
ADDM report [message #487029] Wed, 22 December 2010 01:24 Go to next message
gkrishn
Messages: 506
Registered: December 2005
Location: Putty a dark screen
Senior Member

Using       13,143,097 for database Id
Using                1 for instance number
  :dbid      :=        13,143,097;
                         *
ERROR at line 2:
ORA-06550: line 2, column 26:
PLS-00103: Encountered the symbol "," when expecting one of the following:



i am generating addm report and dbid is not geting value as database id is coming with commas. Whts the setting to remove it.

Thanks
Re: ADDM report [message #487037 is a reply to message #487029] Wed, 22 December 2010 01:56 Go to previous messageGo to next message
Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
execute
alter session set nls_numeric_characters='. ';
before calling ADDM.

Regards
Michel
Re: ADDM report [message #487040 is a reply to message #487037] Wed, 22 December 2010 02:15 Go to previous messageGo to next message
gkrishn
Messages: 506
Registered: December 2005
Location: Putty a dark screen
Senior Member
Thanks, but ..

SQL> alter session set nls_numeric_characters='. ';

Session altered.

SQL> select dbid from DBA_HIST_DATABASE_INSTANCE;

      13,143,097
      13,143,097
Re: ADDM report [message #487043 is a reply to message #487040] Wed, 22 December 2010 02:23 Go to previous messageGo to next message
Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
first execute:
clear column

Regards
Michel
Re: ADDM report [message #487524 is a reply to message #487043] Tue, 28 December 2010 07:27 Go to previous message
mani.aggarwal
Messages: 1
Registered: January 2006
Junior Member
Hi,
Try to generate it from OEM, and it should not show the same there, as sometimes it behaved like that.

Thanks
Manish
Previous Topic: How to overcome rownum clause from select
Next Topic: Less Cost,Cardinality,Bytes Query is taking More time to execute
Goto Forum:
  


Current Time: Mon Nov 25 04:05:57 CST 2024