Tablespace Administration - 2

For ASM disks details you can use query as below.

column Name format A30
column Group_Number format 9999
column Path format A50
set linesize 150
select Name,Group_Number,Total_MB,Free_MB,PATH, Hot_Used_MB, Cold_Used_MB from v$asm_disk;

The Total Space details can be seen with below query.

R12 Blank Login Page

This may happen some times, mainly after the clone or even after some bounce.

There are multiple options to check, and try:-

11g alert log

The alert log location is obviously changed in 11g. The parameter that defines the top location ( Can be called ADR Base ) is "diagnostic_dest"

SQL> show parameter diag