ORACLE - DBA Tips Corner

Oracle DBA Tips Corner

Return to the Oracle DBA Tips Corner.

ASM SQL Scripts

by Jeff Hunter, Sr. Database Administrator

Contents

Overview
ASM Script Repository

Overview

This article provides links to several SQL scripts that can be used to monitor and manage an ASM instance. All of the scripts are meant to be run against the ASM instance logged in with SYSDBA privileges.

ASM Script Repository

Output Script Name Last Update Date

asm_disks.sql Feb 1, 200

asm_files2.sql Feb 1, 200

asm_templates.sql Feb 1, 200

asm_files.sql Feb 1, 200

asm_clients.sql Feb 1, 200

asm_alias.sql Feb 1, 200

asm_disks_perf.sql Feb 1, 200

asm_diskgroups.sql Feb 1, 200

asm_drop_files.sql Feb 1, 200

All articles, scripts and material located at the Internet address of http://www.idevelopment.info is the copyright of Jeffrey M. Hunter and is protected under copyright laws of the United States. This document may not be hosted on any other site without my express, prior, written permission. Application to host any of the material elsewhere can be made by contacting me at jhunter@idevelopment.info.

I have made every effort and taken great care in making sure that the material included on my web site is technically accurate, but I disclaim any and all responsibility for any loss, damage or destruction of data or any other property which may arise from relying on it. I will in no case be liable for any monetary damages arising from such loss, damage or destruction.

Last modified on
Monday, 25-Jul-2005 12:53:13 EDT
Page Count: 11617

Output	Script Name	Last Update Date
	asm_disks.sql	`Feb 1, 200`
	asm_files2.sql	`Feb 1, 200`
	asm_templates.sql	`Feb 1, 200`
	asm_files.sql	`Feb 1, 200`
	asm_clients.sql	`Feb 1, 200`
	asm_alias.sql	`Feb 1, 200`
	asm_disks_perf.sql	`Feb 1, 200`
	asm_diskgroups.sql	`Feb 1, 200`
	asm_drop_files.sql	`Feb 1, 200`