- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: database problem
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
тАО07-12-2002 10:18 AM
тАО07-12-2002 10:18 AM
database problem
I have HP-UX 10.20 over a K380 server, I have installed Oracle 7.1 and a application that make query and insert data into the database.
Data comes from many sources trough a x25 network, and there're certain kind of occurrences in which the data arrive in a intempestive way.
Data incoming occupies the lowest virtual circuits free, when there's massive data incoming, there's a problem with the application and in many cases it falls down.
I've found a temporary solution which is stopping data incoming from the source problem.
Could it be a database problem?
Any help would be really appreciated.
Thanks
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-12-2002 11:40 AM
тАО07-12-2002 11:40 AM
Re: database problem
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-12-2002 01:08 PM
тАО07-12-2002 01:08 PM
Re: database problem
In the file attached is the information provided by Ignite.
I'll sent in a while the datafiles distribution
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-12-2002 02:23 PM
тАО07-12-2002 02:23 PM
Re: database problem
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-15-2002 04:56 PM
тАО07-15-2002 04:56 PM
Re: database problem
Also, can you turn timed_statistics on your database, and look at the v$filestat view again. The "READTIME" and "WRITETIME" columns are 0 because this is set to false. You might be able to set this by running "alter system set timed_statistics = true;" from the command line, however in Oracle 7 you might have to bounce the database.
Also, look at your logfile size and archive parameters. It could be that your redo logfiles could be filling up, and hanging the database until they can be archived.
Brian