SYSAUX tablespace growing rapidly in Oracle, 12c Unified Audit Trail AUDSYS

The Unified Auditing in Oracle 12c can Grow the SYSAUX table to a large size. In our case it grew to about 100GB and We had to take action to make sure it did not grow any larger. First we query to identify what is residing inside the SYSAUX tablespace. In our case it was … Continue reading SYSAUX tablespace growing rapidly in Oracle, 12c Unified Audit Trail AUDSYS

Check ASM Diskgroup Space and Directory Size

The script below can be used to check the Disk Group Space Free and also Check Directory sizes for each Disk Group The script is written by somebody at Pythian but i cannot re-collect the original link to the blog. eg: ./asmcmd_du.sh DiskGroup Total_MB Free_MB % Free --------- -------- ------- ------ DATAC1 15962112 11215880 70 … Continue reading Check ASM Diskgroup Space and Directory Size

Tables Larger than 1 GB in Size in Oracle Database

Sometimes it is required to find the largest tables residing in your database. It helps to identify candidates for table Paritioning. This is the query you can run to identify largest segments in database.   select segment_name as "Table Name" , round (bytes/1024/1024/1024) || ' GB' as "Size" from user_segments where bytes > 1073741824 order … Continue reading Tables Larger than 1 GB in Size in Oracle Database

Check size of table in Oracle

SQL Query to check size of Table   -- Check Size in GB SELECT bytes/1024/1024/1024 FROM USER_SEGMENTS WHERE SEGMENT_NAME in ('TABLE1','TABLE2');   -- Check Size in MB SELECT bytes/1024/1024 FROM USER_SEGMENTS WHERE SEGMENT_NAME in ('TABLE1','TABLE2');   -- Check Size in KB SELECT bytes/1024 FROM USER_SEGMENTS WHERE SEGMENT_NAME in ('TABLE1','TABLE2');