Home » RDBMS Server » Performance Tuning » How Oracle using SAMPLE Clause on statistics?
icon5.gif  How Oracle using SAMPLE Clause on statistics? [message #250769] Wed, 11 July 2007 04:36 Go to next message
aprodovikov
Messages: 2
Registered: July 2007
Location: Russia, Yekaterinburg
Junior Member

I have ORA-00933 on DBMS_STATS.gather_database_stats().

Parameter NLS_NUMERIC_PARAMS has value:

database ', '
instance ''
session ', '

If change session parameter on value '. ', then function running successfully. But I have error on Oracle Application. Could I can`t change value database parameter nls_numeric_params.
If change database parameter on value '.,' and session parameter value ', ', then function running succesfully.


Error occur on this query:

select /*+ cursor_sharing_exact dynamic_sampling(0) no_monitoring no_expand index(t,"P_BER_KEY") */ count(*) as nrw,count(distinct sys_op_lbid(73313,'L',t.rowid)) as nlb,null as ndk,sys_op_countchg(substrb(t.rowid,1,15),1) as clf from "IGG"
."BER" sample block (9,36760988338905651145722906303514637528) t where "IBERNUM" is not null or "IBERANUM" is not null
Re: How Oracle using SAMPLE Clause on statistics? [message #250772 is a reply to message #250769] Wed, 11 July 2007 04:41 Go to previous messageGo to next message
Michel Cadot
Messages: 64120
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Oracle version?
In most versions, dbms_stats does ONLY support default (american) NLS_NUMERIC_CHARACTERS value (.,).

Regards
Michel

[Updated on: Wed, 11 July 2007 04:42]

Report message to a moderator

Re: How Oracle using SAMPLE Clause on statistics? [message #250781 is a reply to message #250769] Wed, 11 July 2007 05:35 Go to previous messageGo to next message
aprodovikov
Messages: 2
Registered: July 2007
Location: Russia, Yekaterinburg
Junior Member

Oracle version 9.2.0.6 on SUSE 9
This occur after currupting RAID 5. I have one currupting data block on running this job:

ORA-12012: error on auto execute of job 201
ORA-01578: ORACLE data block corrupted (file # 5, block # 414028)
ORA-01110: data file 5: '/ora1/oradata/new8i/users_new8i.dbf'

Block # 414028 - index. I have drop this index and create them.
After I have this error on gathering statistics.

from dba_jobs
----
NLS_LANGUAGE='RUSSIAN'
NLS_TERRITORY='CIS'
NLS_CURRENCY='?.'
NLS_ISO_CURRENCY='CIS'
NLS_NUMERIC_CHARACTERS=', ' NLS_DATE_FORMAT='DD/MM/RR' NLS_DATE_LANGUAGE='RUSSIAN'
NLS_SORT='RUSSIAN'
----
Re: How Oracle using SAMPLE Clause on statistics? [message #250788 is a reply to message #250781] Wed, 11 July 2007 06:03 Go to previous message
Michel Cadot
Messages: 64120
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
I think these are 2 distincts problems which have no relation.

Regards
Michel
Previous Topic: Performance tuning
Next Topic: execution plan for a stored procedure
Goto Forum:
  


Current Time: Tue Dec 06 12:05:58 CST 2016

Total time taken to generate the page: 0.11595 seconds