• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar
  • Skip to footer navigation

The Geek Diary

  • OS
    • Linux
    • CentOS/RHEL
    • Solaris
    • Oracle Linux
    • VCS
  • Interview Questions
  • Database
    • oracle
    • oracle 12c
    • ASM
    • mysql
    • MariaDB
  • DevOps
    • Docker
    • Shell Scripting
  • Big Data
    • Hadoop
    • Cloudera
    • Hortonworks HDP

Oracle Database: Profile Limits (Resource Parameter(s)) Are Not Enforced / Do Not Work

by admin

The Problem

After creating a new profile or altering an old one to limit the following profile resources there is no change:

SESSIONS_PER_USER
CPU_PER_SESSION
CPU_PER_CALL
CONNECT_TIME
IDLE_TIME
LOGICAL_READS_PER_SESSION
COMPOSITE_LIMIT
PRIVATE_SGA

The resource usage limits are not enforced and the users that are assigned the profile continue to use resources beyond profile’s limits.

The Solution

The initialization parameter RESOURCE_LIMIT is set to FALSE (default). Set RESOURCE_LIMIT = TRUE in INIT.ORA and restart your database. This ensures that the resource limits will be enforced.

You can also modify this parameter at system level via the following command:

SQL> ALTER SYSTEM SET RESOURCE_LIMIT = TRUE ;

This will only apply for new sessions. The sessions that are already started will not be affected.

It is possible to check the current value of this parameter by running the following query:

SQL> SELECT * FROM V$PARAMETER WHERE NAME = 'resource_limit' ;

Filed Under: oracle

Some more articles you might also be interested in …

  1. IF statements in PL/SQL
  2. How to Use Udev Rules to Create oracleasm Disks in CentOS/RHEL 8
  3. Oracle Golden gate GGSCI commands quick reference (Cheat Sheet)
  4. What is OCFS or OCFS2
  5. PL/SQL: Palindrome Program
  6. How Realms Work in Oracle Database Vault
  7. How to Disable Oracle Net Tracing without stopping server process
  8. PL/SQL Nested Blocks
  9. How to duplicate a Oracle Database to a previous Incarnation
  10. Using Explicit Cursors in PL/SQL

You May Also Like

Primary Sidebar

Recent Posts

  • vgextend Command Examples in Linux
  • setpci command – configure PCI device
  • db_load command – generate db database
  • bsdtar command – Read and write tape archive files

© 2022 · The Geek Diary

  • Archives
  • Contact Us
  • Copyright