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

Thread: Txn_index

  1. #1
    Join Date
    Feb 2006
    Posts
    34

    Txn_index

    1. Txn_index is full.There is no indication on alert file. How do we prevent this kind of situation.

    2. Using metalink userid, can't download oracle 10g software. how do we download oracle 10g s/w.
    Please let me know the details.

    Regards.

  2. #2
    Join Date
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    4,166
    Quote Originally Posted by vijill
    1. Txn_index is full.There is no indication on alert file. How do we prevent this kind of situation.
    Is txn_index a tablespace? Is it set to autoextend? Is it really full, or is it almost ready to entend itself?

    Quote Originally Posted by vijill
    2. Using metalink userid, can't download oracle 10g software. how do we download oracle 10g s/w.
    Please let me know the details.
    You need to get a technet account. All you need to do that is go to technet.oracle.com and have an email account. You need metalink to log itars and download patches.

  3. #3
    Join Date
    Feb 2006
    Posts
    34

    txn_index

    Yes, it is a table space. but we do not want set to auto extent. How do we avoid this kind of situation.
    there is no error msg on alert or table space log file.

  4. #4
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    Monitoring will solve your problem (that is what everyone do)

  5. #5
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    stop putting data in will also solve this

    and what is this tablespace log file you talk of? - and if the tablespace was full and couldnt extend you would get an error in the alert log

  6. #6
    Join Date
    Feb 2006
    Posts
    34
    thanks for your informations.
    yes, we found the problem it is due to big transaction.
    I can able to extend, no problem. but there is no error msg on alert log file.

  7. #7
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    if the tablespace fails to extend, you will have a message in your alert log

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