How to avoid TAF in Oracle database

Tags:
Oracle Database
PL/SQL
I have one table, and indexes are created for all the columns still. I'm getting table access full for the same table, please tell me how to avoid TAF in Oracle database.


Software/Hardware used:
Oracle database
0

Answer Wiki

Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.
  • carlosdl
    Full table scans are not necessarily bad. If the optimizer thinks that doing a full scan is more efficient than using some other access path, it will do a full scan, and that is good.

    We would need more information in order to know if a full table scan sounds like a good option in your specific case.

    At a minimum, we would need to know the table definition, the existence of indexes, the number of rows in the table, the number of distinct values in the columns you are using to filter, and of course, your query and an execution plan.

    The database version is also important.
    84,745 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following

Share this item with your network: