|
|
|
|
|
|
| Re: Would like to know, how to find the size of individual folder in ASM 10g ! [message #559220 is a reply to message #547787] |
Fri, 29 June 2012 20:56  |
 |
alan.kendall@nfl.com
Messages: 163
Registered: June 2012
Location: Culver City, California
|
Senior Member |
|
|
After the asm groups are created I manage the space with the following query.
ECSCDAS1S > @gig
INSTANCE_NAME NAME TOTAL_GIG FREE_GIG PERCENT_USED
---------------- --------------- ---------- ---------- ------------
CSCDAS1 CRS_DG 2.0 1.6 19.5
CSCDAS1 VOTE_DG 9.0 8.0 11.2
CSCDAS1 CCDA_DATA_01 300.0 268.6 10.5
CSCDAS1 CCDA_FLASH_01 400.0 395.8 1.0
4 rows selected.
ECSCDAS1S > list
1 select instance_name,name,TOTAL_MB/1024 total_gig,FREE_MB/1024 free_gig,
2 (total_mb-FREE_MB)/TOTAL_MB*100 percent_used
3* from v$asm_diskgroup,v$instance
I manage the archive logs from rman, the datafiles with sql commands and the flashback with alter system commands. I use the gig.sql above to see the results of my maintenance.
I only do a 1) .oraenv sid and 2) asmcmd to remove archive logs that rman had trouble erasing (which is very rare).
ECSCDAS1S > alter database datafile '+CCDA_DATA_01/cscdas/undotbs01.dbf' resize 2000m;
Database altered.
ECSCDAS1S > alter database datafile '+CCDA_DATA_01/cscdas/undotbs02.dbf' resize 2000m;
Database altered.
ECSCDAS1S > @gig
INSTANCE_NAME NAME TOTAL_GIG FREE_GIG PERCENT_USED
---------------- --------------- ---------- ---------- ------------
CSCDAS1 CRS_DG 2.0 1.6 19.5
CSCDAS1 VOTE_DG 9.0 8.0 11.2
CSCDAS1 CCDA_DATA_01 300.0 266.8 11.1 Changed
CSCDAS1 CCDA_FLASH_01 400.0 395.8 1.0
RMAN> delete archivelog all;
ECSCDAS1S > @gig
INSTANCE_NAME NAME TOTAL_GIG FREE_GIG PERCENT_USED
---------------- --------------- ---------- ---------- ------------
CSCDAS1 CRS_DG 2.0 1.6 19.5
CSCDAS1 VOTE_DG 9.0 8.0 11.2
CSCDAS1 CCDA_DATA_01 300.0 266.8 11.1
CSCDAS1 CCDA_FLASH_01 400.0 399.9 .0 Changed
So I rarely go into asmcmd to do any work. I can reclaim flashback space with the following.
For a NON RAC system:
alter system set db_recovery_file_dest_size=1g scope=memory;
alter system set db_flashback_retention_target=180 scope=memory;
alter system set db_flashback_retention_target=1440 scope=memory;
alter system set db_recovery_file_dest_size=107374182400 scope=memory;
for a RAC system:
alter system set db_recovery_file_dest_size=1g scope=memory sid='*';
alter system set db_flashback_retention_target=180 scope=memory sid='*';
alter system set db_flashback_retention_target=1440 scope=memory sid='*';
alter system set db_recovery_file_dest_size=107374182400 scope=memory sid='*';
[Updated on: Fri, 29 June 2012 20:58] Report message to a moderator |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
