db_files setting on 10g

From: Havel Zhang <havel.zhang_at_gmail.com>
Date: Sat, 22 Nov 2008 22:34:25 -0800 (PST)
Message-ID: <4050f43b-bee5-4c84-bbd6-f8029e0f87a5@i24g2000prf.googlegroups.com>


hi all:

     Recently, we move a oracle 9i DB up to a oracle 10g. Everything is nice, but i found a problem about a parameter db_files. when i set db_files to 65535, you can find yourself can not analyze / scan a big table on 10g, but on 9i will running smoothly. when i set this parameter to 45535 or less, the problem solved.

any one have the same experience ? It is a Oracle 10g Bug?

Havel Received on Sun Nov 23 2008 - 00:34:25 CST

Original text of this message