Re: Large number of Tablespaces 8.1.6

Jonathan Lewis wrote:
>
> I am putting together a database design
> which looks as if I need about 6,000
> tablespaces.
>
> Since the block size is likely to be 16K
> this looks like a lot of work for SMON to
> do every three minutes. Especially since
> I will be using locally managed tablespaces
> with uniform sizing !
>
> I could hacke sql.bsq to change the cluster SIZE
> on c_ts#, or set event 10269 to stop the SMON scan.
> Has anyone had official blessing for doing this, or
> come up with an alternative ? Has anyone come
> across any other side-effects from having this many
> tablespaces ? (This isn't OPS by the way).
>
> --
>
> Jonathan Lewis
> Yet another Oracle-related web site: http://www.jlcomp.demon.co.uk

Hi Johnathan,

That sounds like a nice project... :-)

Most I've used is a couple of hundred (actually for a small db, but that config was insisted upon by the app vendor in this case). If memory serves, we actually had more grief with the resultant number of files (checkpointing et al) than the number of tablespaces.

On this db I changed C_TS# with no problems encountered (to date...)

I've been using 10269 on any 8.1 db with exclusively locally managed tspaces - I've haven't seen any ill effects (but I'm the first to admit I've have not been looking too hard).

HTH

-- 
===========================================
Connor McDonald
http://www.oracledba.co.uk

We are born naked, wet and hungry...then things get worse