Skip to Main Content
Forums

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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

ORA-1688: unable to extend table SYS.WRH$_ACTIVE_SESSION_HISTORY

683218Feb 6 2010 — edited Feb 15 2010
Hi,

In the alert log file it is occuring below error on some interval.The database version is 10.2.0.4.0.

ORA-1688: unable to extend table SYS.WRH$_ACTIVE_SESSION_HISTORY partition WRH$_
ACTIVE_506486335_9939 by 128 in tablespace SYSAUX

Thanks,

Quadri

Edited by: Quadri on Feb 6, 2010 6:52 AM

Comments

Sounds nice, but what do I do when I have to check 100s or 1000s of servers/VMs? Look at 1000s of HTML pages?

Glynn Foster-Oracle

Sounds nice, but what do I do when I have to check 100s or 1000s of servers/VMs? Look at 1000s of HTML pages?

Great comment! Being able to provide a multi-node compliance solution is pretty critical. Since our compliance solution is based on the industry standard OpenSCAP (Main Page - Openscap), you could write your own tools to achieve something similar. That said, this is something that we're actively working on right now and we'll be taking advantage of Remote Administration Daemon (RAD) to allow multi-node communication with a compliance RAD module. Stay tuned!

artsunixlabs

May I suggest? Try SPLUNK Enterprise to see if it fits your requirement and license it, and get the demo app called "health status" for graphical status. - Is very futuristic far more advanced than ZABBIX or NAGIOS. Currently I am looking for a job but also learning SPLUNK Dashboarding in Solaris11.3 Beta - I have (8)zones "Forwarding" to MASTER/SLAVE "Receiver" and works fine for the Intel Platform - not sure on SPARC. Also you can experiment with Solaris11.3 Beta and ruby2.1(facter) which reports all system information pretty much like INXI linux. (I am working on a "facter" project load to be pushed to Oracle12c for permanent system reporting. - Currently I need help here because the file is too large...

1 - 3
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Mar 15 2010
Added on Feb 6 2010
#general-database-discussions
10 comments
19,711 views