Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Oracle/Linux @ 100% CPU

389043Mar 4 2003 — edited Mar 4 2003

Hi,

My platform is Oracle 9.2.0 Enterprise, RH Linux 2.4.18 on a Dell PowerEdge 8450, 6x550 Xeon Processors, 4GB RAM.

This is the second time this happens. Whenever Oracle has some especially demanding I/O activity, the system goes to 100% CPU utilization and I/O almost ceases. The systems becomes hardly manageable until it is shut down.

First it was a long-running rman backup archivelog statement, and now it got triggered by this:

CREATE TABLESPACE SDE_RASTER DATAFILE
'/oradata/data1/oragis/sderaster01.dbf' SIZE 2048M AUTOEXTEND OFF,
'/oradata/data1/oragis/sderaster02.dbf' SIZE 2048M AUTOEXTEND OFF,
'/oradata/data1/oragis/sderaster03.dbf' SIZE 2048M AUTOEXTEND OFF,
'/oradata/data1/oragis/sderaster04.dbf' SIZE 2048M AUTOEXTEND OFF
EXTENT MANAGEMENT LOCAL AUTOALLOCATE
SEGMENT SPACE MANAGEMENT AUTO;

I'm using a 16KB blocksize and I'm allocating approx. 1.8GB for Oracle, if that can help somehow.

Thanks for any leads,
Ivan.

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 1 2003

Added on Mar 4 2003

#general-database-discussions

1 comment

503 views