OraFAQ Forum: Server Administration » how to check ASM is used

Home » RDBMS Server » Server Administration » how to check ASM is used (Oracle 10g, R 10.2.0.3.0, Solaris 10)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

how to check ASM is used [message #464450]

Thu, 08 July 2010 02:16

ko_aung
Messages: 8
Registered: July 2010

Junior Member

Hi,

How can I check whether the ASM is used in the environment?
Appreciate if anyone can let me know how I can check for it and if being used, how to connect to that instance later on.

Thank.
Regards,
ko_aung

Report message to a moderator

Re: how to check ASM is used [message #464459 is a reply to message #464450]

Thu, 08 July 2010 02:35

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Just read the name of a file in dba_data_files, if it starts with + then you use ASM.

Regards
Michel

Report message to a moderator

Re: how to check ASM is used [message #464522 is a reply to message #464459]

Thu, 08 July 2010 04:51

ko_aung
Messages: 8
Registered: July 2010

Junior Member

Hi Michel,

Thanks. Do I need to execute

SQL> select file_name from dba_data_files

and look for the "+"?
Btw, when executed

SQL> show parameter log_archive_dest

, it displays as

LOCATION=+DATA1

. Does it also mean I'm using ASM?

I'm a total newbie here. Really appreciate your help. Can you tell me how to get the ASM instance name also?

Thanks.
Regards,
ko_aung

Report message to a moderator

Re: how to check ASM is used [message #464541 is a reply to message #464522]

Thu, 08 July 2010 05:31

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

There are many ways, you found one that suits you, then use it. You can also query V$ASM_DISK.

V$ASM_CLIENT

Regards
Michel

[Updated on: Thu, 08 July 2010 05:33]

Report message to a moderator

Re: how to check ASM is used [message #464618 is a reply to message #464522]

Thu, 08 July 2010 09:13

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

>>Can you tell me how to get the ASM instance name also?
By default it will be +ASM (for single instance. For RAC it will be +ASM1 or +ASMnode).
Go to server, do a

ps -ef | grep smon

Report message to a moderator

Re: how to check ASM is used [message #464984 is a reply to message #464450]

Sun, 11 July 2010 22:33

ko_aung
Messages: 8
Registered: July 2010

Junior Member

thanks a lot for the instructions, guys.
appreciate it !

Report message to a moderator

Previous Topic:	Shared pool Free percentage greater than 100
Next Topic:	Removing a tablespace & its associated datafiles

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Nov 29 08:55:17 CST 2024