Topic: System Administration >> Database Get stuck
|
Disclaimer: The purpose of all dbapool forums including OCP and Other Oracle Certification forums is to help each other with specific issues but not to share dump and copyrighted exam content, materials or intellectual property.
You may review the entire Oracle Certification Program Candidate Agreement online Here.
|
|
|
|
| Title: Database Get stuck |
| kunal |
Posted: Aug 23, 2007 02:32:56 AM |
Total Post: 3
Joined: May, 2007
|
Hi,
My Oracle 10g Database got hanged now and then because of some P.T. Problem so can any one help me to solve this ?
Here attached Latest Listner.log file and i have changed processes prameter check below screenshot.
Enter user-name:
$ export ORACLE_SID=fcr
$ sqlplus sys as sysdba
SQL*Plus: Release 10.1.0.4.0 - Production on Wed Aug 22 16:25:17 2007
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Enter password:
Connected to:
Oracle Database 10g Enterprise Edition Release 10.1.0.4.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options
SQL> show parameter process
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
aq_tm_processes integer 0
db_writer_processes integer 1
gcs_server_processes integer 0
job_queue_processes integer 10
log_archive_max_processes integer 2
processes integer 900
SQL> exit
|
|
|
 Mohammed Taj |
| Posted: Aug 23, 2007 02:59:49 AM |  |
|
Total Post: 634
Joined: Jul, 2007
|
Hi,
Please run awrrpti.sql scripts and send to me @ star_taj@yahoo.com
above generate workload report for your database through this we will findout bottlenecks.
conn DBA granted privs user
and run awrrpti.sql scripts
located : $ORACLE_HOME/db_1/rdbms/admin/awrrpti.sql
Regards
Taj
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
|
|
|
|
Forum Rules & Description
Who Can Read The Forum? Any registered user or guest
Who Can Post New Topics? Any registered user
Who Can Post Replies? Any registered user
|
| |
Get FREE Magazines
|
Top 10 Forum User
|
| Mohammed Taj | 634 |
| Murtuja Khokhar | 588 |
| Jayanta Sur | 479 |
| Vigyan Kaushik | 385 |
| Ramesh Jois | 226 |
| neeraj sharma | 189 |
| snehalatha p | 166 |
| Gitesh Trivedi | 157 |
| Gopu Gopi | 149 |
| Kushal ratnaker | 136 |
|
|
