Database hangs

[Nishant Bhaskar]

I am running Oracle 8.1.7(as a remote Openview DB) on HP-UX 11.0. After every couple of days , connection to anyuser (svrmgrl) hangs. Intermittelntly I am also getting errors like Cant extend OV_INDEX on OV_DATA by xxxx bytes.

What could be the problem,
TIA.

[Tom Geudens · Accepted solution]

Hi,
Looks like :
1. Your tablespaces are on auto-extend (this is "default" in an OpenView installation).
2. They try to extend beyond the physical space available to them.
3. As a result the database hangs.

You might want to take a closer look at :
- How much space do you really expect to need for the OpenView database.
- Do you really want the tablespaces to auto-extend or do you want this under "control" of your DBA's (we chose the latter).
- Are you cleaning up your history messages frequently enough (are you cleaning them up at all) ? We do this after a month and even then the database is growing (although not so fast).
- Are you getting ITO messages saying "history table is reaching limit" ?

Hope this puts you on the right track ...
Tom

[T G Manikandan]

Probably your tablespace OV_INDEX and OV_DATA have become full.


First check the amount of free space on each tablespace using


select tablespace_name,sum(bytes) from dba_free_space group by tablespace_name

If you do not have space extend them using

sql>alter tablespace add datafile '' size 100M

here I am adding a datafile of 100M to a tablespace.

THanks

[T G Manikandan]

Also you can auto-extend the tablespace as Tom suggested using

alter tablespace
datafile '/xxxx/xxx/xxxxx/xxxx.xxx'
autoextend ON
maxsize unlimited;



Thanks

[Nishant Bhaskar]

Well some of the measures I had taken was
- Enabling automatic downloading of historical messages every 10 days.
- Autoextending is on , but should maxsize be unlimited ?? Will it not be a problem ??
- On which all tables should i enable maxsize unlimited ??

Yesterday I padded OV_DATA1.dbf by another 1000M to 2000M. Should i do the same for others.

Thanks for the responses.

[T G Manikandan]

I am sure whether you need so much space on that tablespace
1000M is 1GB.
Does openview use so much space?
I don't think so much space is required.

THanks