OraFAQ Forum: Performance Tuning

Home » RDBMS Server » Performance Tuning » ADDM report (10g Linux)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

ADDM report [message #487029]

Wed, 22 December 2010 01:24

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

Report message to a moderator

Re: ADDM report [message #487037 is a reply to message #487029]

Wed, 22 December 2010 01:56

Michel Cadot
Messages: 68645
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

execute
alter session set nls_numeric_characters='. ';
before calling ADDM.

Regards
Michel

Report message to a moderator

Re: ADDM report [message #487040 is a reply to message #487037]

Wed, 22 December 2010 02:15

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

Report message to a moderator