OraFAQ Forum: Performance Tuning » How Oracle using SAMPLE Clause on statistics?

Home » RDBMS Server » Performance Tuning » How Oracle using SAMPLE Clause on statistics?

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

How Oracle using SAMPLE Clause on statistics? [message #250769]

Wed, 11 July 2007 04:36

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

Report message to a moderator

Re: How Oracle using SAMPLE Clause on statistics? [message #250772 is a reply to message #250769]

Wed, 11 July 2007 04:41

Michel Cadot
Messages: 68664
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

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'
----

Report message to a moderator

Re: How Oracle using SAMPLE Clause on statistics? [message #250788 is a reply to message #250781]

Wed, 11 July 2007 06:03

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

Senior Member
Account Moderator

I think these are 2 distincts problems which have no relation.

Regards
Michel

Report message to a moderator

Previous Topic:	Performance tuning
Next Topic:	execution plan for a stored procedure

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Jun 24 07:58:42 CDT 2024