Category: Oracle

[code]</pre> 21:41:18 SYSTEM/bitst/BITST>set lines 10000 21:41:29 SYSTEM/bitst/BITST>column current_size format 999999 21:41:29 SYSTEM/bitst/BITST>column min_size format 9999999 21:41:29 SYSTEM/bitst/BITST>column max_size format 9999999 21:41:29 SYSTEM/bitst/BITST> 21:41:29 SYSTEM/bitst/BITST>select component,current_size/(1024*1024*1024) current_size ,min_size/(1 024*1024*1024) min_size ,max_size/(1024*1024*1024) max_size from v$sga_dynamic_components 21:41:29 2 / COMPONENT CURRENT_SIZE MIN_SIZE MAX_SIZE —————————————————————- ———— ——– ——– shared pool 3 3 3 large pool 0 0 0 java… Continue reading SGA Current Resize Operations

[code]</pre> set lines 132 col name format a30 col val format a30 col isdefault format a5 col DESCRIPTION format a31 head ‘Description|Update Comment’ col ses_mod format a11 head ‘SessM|sysM’ col mod format a11 head ‘Modifiable|Adjustable’ col adj format a5 head ‘ADJ’ col update_comment format a30 select name,value val,isdefault, RPAD(ISSES_MODIFIABLE,10)||’ ‘||rpad(ISSYS_MODIFIABLE,10) ses_mod, RPAD(ISMODIFIED,10)||’ ‘||rpad(ISADJUSTED,10) mod, rpad(description,30)||’… Continue reading Script to check the Parameter Value

You use online segment shrink to reclaim fragmented free space below the high water mark in an Oracle Database segment. The benefits of segment shrink are these: Compaction of data leads to better cache utilization, which in turn leads to better online transaction processing (OLTP) performance. The compacted data requires fewer blocks to be scanned… Continue reading Shrink Space in Table in Oracle

Today came a requirement to see how frequently log switch is taking place and how much of archive logs are being generated and at what rate… I certainly went through the alert log first and found it too be very time exauhsting…so then looked for the better option.. Then came accross the view V$LOG_HISTORY…and it… Continue reading Calculating number of archive logs/log switches per hour

Hi… Today i tested the new feature of Oracle 11gR2 that is Deferred Segment Creation…. In the previous versions, whenever any segment is created, it consist of atleast one Extent…But starting from Oracle 11gR2, it has changed…or we can say we have the option to create an empty segment or we should say object with… Continue reading Deferred Segment Creation—-Oracle 11gR2 new feature.