Re: unicode performance penalty

applicant2006_at_rambler.ru wrote:
> I'm in the process of migrating our database to Unicode and have
> discovered that it works 4 to 5 times faster than non-unicode database.
>
>
> Oracle docs says that Unicode db should perform same or better than a
> non-unicode one.

Where? Which docs?

 > Server : Oracle 9.2.0.1.0

Patch to the most recent patch. 9.2.0.1.0 was the initial release.

> Any suggestions are welcome.

run dbms_stats.gather_schema_stats

Are the clustering factors the same (from all_indexes)?

EXPLAIN PLAN
SET STATEMENT_ID = 'abc' FOR
<your_statement_here>;

SELECT * FROM TABLE(dbms_xplan.display('PLAN_TABLE','abc','ALL'));

Post the results.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org