Help - Search - Members - Calendar
Full Version: oracle tuning
Oracle DBA Forums > Oracle > Oracle Forum
this is my spfile.ora that i have changed.
Are there any other parameters that to be changed for better performance?

>> cursor_sharing='SIMILAR'

NOT Good, unless you are on 11g:

>> *.db_16k_cache_size=83886080

Why are you using a mix of 16k and 8k blocksizes?

>> db_file_multiblock_read_count=8

Have you optimized this?

>> *.shared_pool_size=75M

This seems very small to me.

Are you getting library cache contention?


>> Are there any other parameters that to be changed for better performance?

Sure, dozens of others:

And, specific parms for improving SQL execution performance:

If you want the details (it's very complex), see my book "Oracle Tuning: The Definitive Reference":
Is the ASSM is enabled, if yes, then the it is automatic. db_block_size dpends on the application type whether it OLTP or DSS. For OLTP kind of application 8192 is OK.
Thank you...

We are using 10g.
So what option i can put for cursor_sharing?

to create tablespaces with 16kb block size, i set that parameter. We moved the tables in 8kb table space into 16kb tablespace.


i changed the multiblock_read_count parameter from 16 to 8

I don't know about library cache contention?
but the library cache hit ratio is 93-98%.
On what basis we can set the shared_pool parameter?
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.
Invision Power Board © 2001-2016 Invision Power Services, Inc.