DBAsupport.com Forums - Powered by vBulletin
Results 1 to 8 of 8

Thread: ORA-604, ORA-00018 (urgent)

  1. #1
    Join Date
    Dec 2001
    Location
    USA
    Posts
    620

    Angry

    Hi there,

    Oracle 8.0.5/ Apps 11.0.3, NT 4.0.

    Today, users are getting following errors at random when they execute modules in the application.

    ORA-604: Error occurred at recursive SQL 1 Level.
    ORA-00018: Maximum number of sessions exceeded.

    ORA-01000: Maximum open cursors exceeded.

    I checked count(*) from v$session. It was 63 (including background processes)

    Foll. are other init.ora parameters.

    PROCESSES = 75
    SESSION = 87
    TRANSACTION = 95

    OPEN_CURSORS = 300
    SESSION_CAHCHED_CURSORS = 150
    SESSION_MAX_OPEN_FILES = 0

    It is on Production.

    Pl. help...

    Thanks in Adv.


    Sam
    ------------------------
    To handle yourself, use your head. To handle others, use your heart

  2. #2
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    do select * from v$resource_limit and paste here but you MUST have not shutdown the datatabse because the data in that v$ is from instance startup

  3. #3
    Join Date
    Dec 2001
    Location
    USA
    Posts
    620
    Hi Pando,

    Foll. is the output from v$resource_limit. I don't know how to indent the output in editor of this forum.

    processes 49 62 75 75
    sessions 59 87 87 87
    lm_procs 0 0 0 0
    lm_ress 0 0 0 UN
    lm_locks 0 0 0 UN
    enqueue_locks 129 221 1306 1306
    enqueue_resourc 131 243 5000 5000
    dml_locks 4 95 500 500
    temp_table_locks0 5 UN UN
    transactions 48 65 95 95
    sort_seg_locks 0 0 UN UN
    max_rbs 9 9 31 31
    distr_trans 0 1 23 23
    mts_max_servers 0 0 20 20
    para_max_server 0 0 6 6

    Thanks,

    Sam
    ------------------------
    To handle yourself, use your head. To handle others, use your heart

  4. #4
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    Code:
    this is from the crm application here (production)
    
    select * from v$resource_limit
    
    RESOURCE_NAME                  CURRENT_UTILIZATION MAX_UTILIZATION INITIAL_AL LIMIT_VALU
    ------------------------------ ------------------- --------------- ---------- ----------
    processes                                       93             102        450        450
    sessions                                        93             114        500        500
    enqueue_locks                                   80             124       6030       6030
    enqueue_resources                               85             142       1500       1500
    _lm_procs                                        0               0          0          0
    lm_ress                                          0               0          0  UNLIMITED
    lm_locks                                         0               0          0  UNLIMITED
    lm_cache_ress                                    0               0          0  UNLIMITED
    dml_locks                                        3              36       2200       2200
    temporary_table_locks                            0              13  UNLIMITED  UNLIMITED
    transactions                                     3              14        550        550
    sort_segment_locks                               2              12  UNLIMITED  UNLIMITED
    max_rollback_segments                           11              11        111        111
    distributed_transactions                         0               0        137        137
    mts_max_servers                                  0               0         20         20
    parallel_max_servers                             0               0          6          6

    look your max_utilization of sessions, it reached to 87 so obviously your count(*) from v$session wasnt correct, when you run the query the number of session had already decreased

    so just increase you init.ora parameter

  5. #5
    Join Date
    Dec 2001
    Location
    USA
    Posts
    620
    Hi pando,

    How did you paste your output to look it so nice?

    In my init.ora, there is no parameter 'SESSIONS', PROCESSES is defined as 75. Should I increase this value so that as per forumla SESSIONS = (1.1*processes)+5, it will calculate SESSIONS automatically?

    Thanks,
    Sam
    ------------------------
    To handle yourself, use your head. To handle others, use your heart

  6. #6
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    ye it will calculate auto if you increase process

    I am good looking so my post looks bettah

  7. #7
    Join Date
    Dec 2001
    Location
    USA
    Posts
    620

    Talking

    Pando,

    I am good looking so my post looks bettah

    Pl. tell me where you have placed your photograph so that your thread first l**k at your photo and then do indenting as per your l##k.

    Just kidding. Finally, tell me how did you do that?

    Thanks,
    Sam
    ------------------------
    To handle yourself, use your head. To handle others, use your heart

  8. #8
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    \[\code\]
    post here
    \[\/code\]

    ignore escape character \

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width