db_files setting on 10g
Date: Sat, 22 Nov 2008 22:34:25 -0800 (PST)
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