Sharing Tips & Tricks from my Database Experience
Tag: free
GoldenGate 23c Free Oracle GoldenGate 23c Free is the same, powerful Oracle GoldenGate that businesses throughout the world rely on. It offers a full-featured experience and is packaged for ease of use and simple download—for free. Whether you are a developer, a data scientist, a DBA, an educator, or just interested in real-time data, Oracle … Continue reading Download Now the New GoldenGate 23.3
SQL> compute sum of bytes on pool SQL> break on pool skip 1 SQL> SELECT pool, name, bytes from v$sgastat order by pool, name;
Shows how to flush buffer cache and v$bh, you may only want to do this on Dev or Test enviornment as it would affect performance on production. -- displays the status and number of pings for every buffer in the SGA SQL> select distinct status from v$bh; STATUS ------- xcur cr -- flush buffer cache … Continue reading How to free buffer cache?
Get current total TEMP tablespace currently allocated, used and free: SELECT A.tablespace_name tablespace, D.mb_total, SUM (A.used_blocks * D.block_size) / 1024 / 1024 mb_used, D.mb_total - SUM (A.used_blocks * D.block_size) / 1024 / 1024 mb_free FROM v$sort_segment A, (SELECT B.name, C.block_size, SUM (C.bytes) / 1024 / 1024 mb_total FROM v$tablespace B, v$tempfile C WHERE B.ts#= C.ts# … Continue reading TEMP space usage overall and by session
alexlima.com 