Home » RDBMS Server » Server Administration » Would like to know, how to find the size of individual folder in ASM 10g ! (Oracle 10g)
Would like to know, how to find the size of individual folder in ASM 10g ! [message #547774] Fri, 16 March 2012 09:59 Go to next message
vishnu_ora
Messages: 12
Registered: April 2011
Junior Member

Hi Guys,

Would like to know, how to find the size of individual folder in ASM 10g !

Also I am not able to find the PATH/name of the raw devices in ASM 10g !

Thanks
Vishnu V
Re: Would like to know, how to find the size of individual folder in ASM 10g ! [message #547786 is a reply to message #547774] Fri, 16 March 2012 11:03 Go to previous messageGo to next message
Michel Cadot
Messages: 57612
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
Would like to know, how to find the size of individual folder in ASM 10g !

Maybe using "asmcmd" program?

Regards
Michel

[Updated on: Fri, 16 March 2012 11:04]

Report message to a moderator

Re: Would like to know, how to find the size of individual folder in ASM 10g ! [message #547787 is a reply to message #547786] Fri, 16 March 2012 11:05 Go to previous messageGo to next message
Michel Cadot
Messages: 57612
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
Also I am not able to find the PATH/name of the raw devices in ASM 10g !


Maybe v$asm_disk.path will do it.

Regards
Michel
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 Go to previous message
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

Previous Topic: compression
Next Topic: how to drop datafile
Goto Forum:
  


Current Time: Sat Apr 19 11:17:29 CDT 2014

Total time taken to generate the page: 0.08985 seconds