TNS Ping Utility for Linux: Version 184.108.40.206.0 - Production on 23-8月 -2012 20:01:17
Copyright (c) 1997, 2008, Oracle. All rights reserved.
Used parameter files:
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = xxx.xxx.xxx.xxx)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = ora11)))
OK (0 msec)
can you run awrrpt.sql, an AWR report for your database ? This will be available in $ORACLE_HOME/rdbms/admin/awrrpt.sql. Once you run it post " Load Profile " and " Top 5 Timed Foreground Events " from the report. we can review it to see what is happening. Regards.