>Oracle Performance

>select * from sapsr3.TPFYPROPTY
where obj_name=’ENQUE/TABLE_SIZE’

SELECT job_name, owner, enabled, state
FROM DBA_SCHEDULER_JOBS
WHERE JOB_NAME = ‘GATHER_STATS_JOB’;

select * from V$SGA_CURRENT_RESIZE_OPS

select * from V$SGA_RESIZE_OPS;

select component, current_size, granule_size from v$sga_dynamic_components;

select * from V$SGA_DYNAMIC_FREE_MEMORY;

OBJECT_NAME = ‘COEP~Z02’ AND

SELECT
SUBSTR(OBJECT_NAME, 1, 40) SEGMENT_NAME,SUBSTR(STATISTIC_NAME, 1, 20) STATISTIC_NAME,VALUE “NUMBER”
FROM V$SEGMENT_STATISTICS
WHERE
STATISTIC_NAME IN (‘logical reads’, ‘physical reads’);

SELECT SUBSTR(OBJECT_OWNER, 1, 10) OWNER,
SUBSTR(OBJECT_NAME, 1, 25) OBJECT,
SUBSTR(OPERATION, 1, 15) OPERATION,
SUBSTR(OPTIONS, 1, 15) OPTIONS,
COUNT(*) “NUMBER”
FROM V$SQL_PLAN
GROUP BY OBJECT_OWNER, OBJECT_NAME, OPERATION, OPTIONS;

SELECT BYTES FROM V$SGASTAT
WHERE POOL = ‘shared pool’ AND NAME = ‘free memory’;

select * from V$ARCHIVE_DEST
—————————–
SELECT job_name, owner, enabled, state
FROM DBA_SCHEDULER_JOBS
WHERE JOB_NAME = ‘GATHER_STATS_JOB’;

————————————-
select * from sapsr3.TPFYPROPTY
where obj_name=’ENQUE/TABLE_SIZE’

select * from V$ARCHIVE_DESt

select * from v$parameter
where name like ‘%archive%’

select * from v$_lock

—-
abap/buffersize : Program Buffer Size
500MB 000 1500MB 000 kb
enque/table_size
16384 96MB 000
ipc/shm_psize_10
150MB 000 000 600MB 000 000
ipc/shm_psize_40 Size of shared memory segment
124MB 000 000 250MB 000 000 byte

RSPLSE
enque/table_size or abap/shared_objects_size_MB

http://sapkb.blogspot.com/search/label/Oracle
http://benstudycenter.blogspot.com/2008_01_01_archive.html

This entry was posted in Uncategorized. Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s