Oracle Profile Limit Not Working

It can be useful to set a high CPU usage limit to stop runaway queries. "High" is application-specific, so set the limit as appropriate.

When the limit is reached, the session will be killed with the message, "ORA-02393: exceeded call limit on CPU usage".

If the limit does not work, verify the resource_limit parameter is set to true.


prompt -- Set pfile for: resource_limit=true
alter system set resource_limit=true scope=both;

drop profile profile_example
/

CREATE PROFILE profile_example
LIMIT CPU_PER_SESSION UNLIMITED CPU_PER_CALL 120000
CONNECT_TIME UNLIMITED IDLE_TIME UNLIMITED SESSIONS_PER_USER
UNLIMITED LOGICAL_READS_PER_SESSION UNLIMITED
LOGICAL_READS_PER_CALL UNLIMITED PRIVATE_SGA UNLIMITED
COMPOSITE_LIMIT UNLIMITED FAILED_LOGIN_ATTEMPTS UNLIMITED
PASSWORD_LOCK_TIME UNLIMITED PASSWORD_GRACE_TIME UNLIMITED
PASSWORD_LIFE_TIME UNLIMITED PASSWORD_REUSE_MAX UNLIMITED
PASSWORD_REUSE_TIME UNLIMITED PASSWORD_VERIFY_FUNCTION NULL
/

alter user limt_me profile profile_example
/

Online Office Suite

ThinkFree offers 1GB of storage for their online word processor, spreadsheet, and presentation tool.

There are quick and full editors. Any formatting will need the full editor, which runs in a jvm. The full editor allows saving to PDF.

What's On My PC

February 2006 we received a zv6000 laptop from HP. 15.4" monitor, AMD x64, lots of built in hardware, and running XP Home. This is the software I have installed and updated.

First go to MS Update and get patched.

Get the CPU information with WCPUID. Depending on power settings, this AMD will throttle down and show significantly fewer MHz.
A couple alternative browsers: Opera and Firefox.
Winamp music player.
Real player. Deny the TkBellExe browser help object.
OpenOffice office productivity.
ClamWin virus scanner.
Protect from spyware.
X-Ray displays running process information to allow removal of removal of spyware. This is for more advanced users.
X-Cleaner free version does a reasonable job finding and cleaning malware.
Hosts file changes to reduce advertisements while browsing.
Site Advisor installs in Firefox or Internet Explorer and rates the safety of web sites.
Adobe Acrobat reader.

Power archiver works on TARs.
SFTP client
===== Some others. =====

Check the prices of gold and silver.

For those supporting remote machines, try Real VNC to forward a screen.
PuTTY is a telnet and ssh character-based logon tool.