Home » RDBMS Server » Server Administration » If a user complaints the database is slow
If a user complaints the database is slow [message #169285] Wed, 26 April 2006 02:01 Go to next message
anjali_anaidu
Messages: 1
Registered: February 2006
Location: India
Junior Member
HI
Can anyone help what are the option to check if the user complaints database is slow.

regards
Anjali

Report message to a moderator

Re: If a user complaints the database is slow [message #169286 is a reply to message #169285] Wed, 26 April 2006 02:03 Go to previous messageGo to next message
kmsalih
Messages: 197
Registered: March 2006
Senior Member
ps -ef | grep LOCAL

monitor the v$session.

monitor the locks.

Kill unwanted sessions.

[Updated on: Wed, 26 April 2006 02:03]

Report message to a moderator

Re: If a user complaints the database is slow [message #169331 is a reply to message #169285] Wed, 26 April 2006 05:22 Go to previous message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
>>Can anyone help what are the option to check if the user complaints database is slow.
With the wealth of information provided NO.
You can start by reading performance manual and administration manual.

Report message to a moderator

Previous Topic: Login into database without correct password in SYS user
Next Topic: Database migration
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 20 12:21:48 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.