Database Administration (MOSC)

MOSC Banner

Post MOUNT stage DB Taking looooooooong time to Open

edited Nov 3, 2009 2:51PM in Database Administration (MOSC) 8 commentsAnswered
System = SunOS
Node = czssd1007
Release = 5.10
KernelID = Generic_127111-09
Machine = sun4u
BusType = <unknown>
Serial = <unknown>
Users = <unknown>
OEM# = 0
Origin# = 1
NumCPU = 24

SQL> select VERSION from v$instance;

VERSION
-----------------
10.2.0.4.0

SQL> select count(1) from v$datafile;

  COUNT(1)
----------
       108

SQL> select round(sum(bytes/1024/1024/1024)) GB from dba_data_files;

        GB
----------
        53

SQL>

* DB was cleanly shutdown. (No Abort)

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center