Data Buffer Quality is less than 80%

[Former Member]

Hi SAP Guru's,

We are getting Data Buffer Quality 80% for the last 15 days in the ST04 screen.but SAP Recommands that it should be more than 96%.

My Plate form is :-

Window NT*

ECC 6.0

Oracle 10G

Please suggest that which database parameter need to be change.

I am attaching that init<sid>.ora profie also

-

---

tcp.__db_cache_size=838860800

tcp.__shared_pool_size=159383552

*._B_TREE_BITMAP_PLANS=false

*._BLOOM_FILTER_ENABLED=false

*._FIX_CONTROL='4728348:OFF'

*._IN_MEMORY_UNDO=false

*._INDEX_JOIN_ENABLED=false

*._OPTIM_PEEK_USER_BINDS=false

*._OPTIMIZER_MJC_ENABLED=false

*._SORT_ELIMINATION_COST_RATIO=10

*._TABLE_LOOKUP_PREFETCH_SIZE=0

*.background_dump_dest='I:\oracle\TCP\saptrace\background'

*.compatible='10.2.0'

*.control_file_record_keep_time=30

*.control_files='K:\oracle\TCP\sapdata1\cntrl\cntrlTCP.dbf','K:\oracle\TCP\sapdata2\cntrl\cntrlTCP.dbf','K:\oracle\TCP\sapdata3\cntrl\cntrlTCP.dbf'

*.core_dump_dest='I:\oracle\TCP\saptrace\coretrace'

*.db_block_size=8192

*.db_cache_size=838860800

*.db_files=254

*.db_name='TCP'

*.event='10027 trace name context forever, level 1','10028 trace name context forever, level 1','10162 trace name context forever, level 1','10183 trace name context forever, level 1','10191 trace name context forever, level 1','38068 trace name context forever, level 100'

*.FILESYSTEMIO_OPTIONS='SETALL'

*.LARGE_POOL_SIZE=155000000

*.log_archive_dest='F:\oracle\TCP\saparch\TCParch'

*.log_buffer=1048576

*.log_checkpoints_to_alert=TRUE

*.max_dump_file_size='20000'

*.open_cursors=1000

*.OPTIMIZER_INDEX_CACHING=50

*.OPTIMIZER_INDEX_COST_ADJ=20

*.parallel_execution_message_size=16384

*.parallel_max_servers=4

*.parallel_threads_per_cpu=1

*.pga_aggregate_target=367001600

*.processes=150

*.query_rewrite_enabled='FALSE'

*.RECYCLEBIN='OFF'

*.REMOTE_OS_AUTHENT=TRUE

*.REPLICATION_DEPENDENCY_TRACKING=false

*.sessions=300

*.sga_max_size=1363148800

*.shared_pool_size=159383552

*.STAR_TRANSFORMATION_ENABLED='TRUE'

*.timed_statistics=true

*.UNDO_MANAGEMENT='AUTO'

*.UNDO_RETENTION=14400

*.UNDO_TABLESPACE='PSAPUNDO'

*.user_dump_dest='I:\oracle\TCP\saptrace\usertrace'

-

---

Thanks and Regards

Vinay Patel

[Former Member]

Hi Vinay,

your buffer pool is only 800MB. This is may be to small. But a bad buffer quality could be caused also by bad optimizer statistics or missing indexes. You should check first for missing indexes, run update statistics first and then if nothing helped, you should increase your buffer if you still have free memory. This could be checked in transaction ST06 or OS06.

Regards

Ralph Ganszky

[Former Member]

Hi Vinay,

Try and schedule a EWA session with SAP or if you have a Solution Manager connection to your system.

Make the necessary changes on your for OS, DB and SAP Memory parameters that would come in the report.

Regards,

Nilesh

[Former Member]

Thanks boss

My problem has been resolved.

[Former Member]

Hi Vinay,

Its always a good practice in such forums to share how you attended and resolved your problem.

This will have others to gain knowledge from your experience.

Kindly share the your experience on how this was solved and close this thread.

Regards,

Nilesh

[Former Member]

Hi,

I have changed my data buffer size

[Former Member]

Hi,

check folloiwng

regards,

kaushal