OraFAQ Forum: Server Utilities » Database Management issue

Home » RDBMS Server » Server Utilities » Database Management issue

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Database Management issue [message #155345]

Sat, 14 January 2006 02:40

karan.shandilya
Messages: 64
Registered: July 2005
Location: mumbai

Member

Hi to all,
We are using database server oracle 9i.
Now we are getting the problems in connectivity with database.
We are using Forms 6i.
When we connect to databse whether on SQL prompt or from forms 6i it is taking time.And due this problem our application is not running.
Before all this happen i store the 9-10 .bmp images(each has 1.5 mb appx) in one of our major table. Now i removed those images from that table and also increased the size of system,temporary tablespace but the result is same.

I just want to check it out whether this problem is due to network connection or with databse.

I pinged the ip's of the servers while connecting to database and it seems to be absoluetly fine.

Now i am confused that what exactly the problem is.

So pls anyone tell me that what steps should i take to sort this matter.

Karan.

Report message to a moderator

Re: Database Management issue [message #155360 is a reply to message #155345]

Sat, 14 January 2006 23:05

orausern
Messages: 826
Registered: December 2005

Senior Member

few points to check would be:
1. what is ur server configuratin? post output of show sga command.how much ram,and other hardware u have for oracle server?

2. whether any error has been logged in alert log file?

3 how much free space is there in all the tablespaces?

4. when did this problem start happening?

5. what are other applications running on the machine that has oracle database installed? -did u install forms on same machine that has oracle db?

6 what is the memory/cpu usage u see when trying to connect oracle?

Report message to a moderator

Re: Database Management issue [message #155368 is a reply to message #155345]

Sun, 15 January 2006 04:03

karan.shandilya
Messages: 64
Registered: July 2005
Location: mumbai

Member

1. what is ur server configuratin? - Advance 2000 window P-III,
2.how much ram-256mb

and other hardware u have for oracle server?

3. whether any error has been logged in alert log file?

4. how much free space is there in all the tablespaces? Mostly all the tablespaces are empty.

5. when did this problem start happening?- 3Days before.

6. what are other applications running on the machine that has oracle database installed?-Only oracle database

7.Did u install forms on same machine that has oracle db? NO

Karan

Report message to a moderator