- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Database hangs
Categories
Company
Local Language
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Discussions
Discussions
Forums
Forums
Discussions
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Community
Resources
Forums
Blogs
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО09-01-2002 10:37 PM
тАО09-01-2002 10:37 PM
What could be the problem,
TIA.
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО09-01-2002 10:50 PM
тАО09-01-2002 10:50 PM
SolutionLooks 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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО09-01-2002 10:52 PM
тАО09-01-2002 10:52 PM
Re: Database hangs
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
here I am adding a datafile of 100M to a tablespace.
THanks
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО09-01-2002 10:56 PM
тАО09-01-2002 10:56 PM
Re: Database hangs
alter tablespace
datafile '/xxxx/xxx/xxxxx/xxxx.xxx'
autoextend ON
maxsize unlimited;
Thanks
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО09-02-2002 11:37 PM
тАО09-02-2002 11:37 PM
Re: Database hangs
- 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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО09-03-2002 02:49 AM
тАО09-03-2002 02:49 AM
Re: Database hangs
1000M is 1GB.
Does openview use so much space?
I don't think so much space is required.
THanks