Network Security Internet Technology Development Database Servers Mobile Phone Android Software Apple Software Computer Software News IT Information

In addition to Weibo, there is also WeChat

Please pay attention

WeChat public account

Shulou

High utilization of Oracle database ASM disk group + ASM2_ARCH

2025-04-03 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > Database >

Share

Shulou(Shulou.com)06/01 Report--

View the process

Ps-ef | grep pmon

# su-oracle

[YOU HAVE NEW MAIL]

$sqlplus / as sysdba

SQL*Plus: Release 10.2.0.4.0-Production on Mon Feb 9 16:30:23 2015

Copyright (c) 1982, 2007, Oracle. All Rights Reserved.

Connected to:

Oracle Database 10g Enterprise Edition Release 10.2.0.4.0-64bit Production

With the Partitioning, Real Application Clusters, OLAP, Data Mining

And Real Application Testing options

SQL > select name,total_mb,free_mb from v$asm_diskgroup

NAME TOTAL_MB FREE_MB

ARCH 3334794 3254850

DATA 4077376 553269

SQL > quit

Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.4.0-64bit Production

With the Partitioning, Real Application Clusters, OLAP, Data Mining

And Real Application Testing options

$rman target /

Recovery Manager: Release 10.2.0.4.0-Production on Mon Feb 9 16:33:38 2015

Copyright (c) 1982, 2007, Oracle. All rights reserved.

Connected to target database: ZLJG (DBID=4286942513)

RMAN > exit

Delete archive command: delete archivelog all completed before 'sysdate-1'; (manual input command)

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.

Views: 0

*The comments in the above article only represent the author's personal views and do not represent the views and positions of this website. If you have more insights, please feel free to contribute and share.

Share To

Database

Wechat

© 2024 shulou.com SLNews company. All rights reserved.

12
Report