DBA GENESIS

  • Courses

  • Certification

  • Contact

  • Members

  • More

    Use tab to navigate through the menu items.

    Book a mock interview and get instant feedback - Learn More

    To see this working, head to your live site.
    • Categories
    • All Posts
    • My Posts
    syam Kumar
    Nov 01, 2021

    Tuning support

    in Oracle Performance Tuning

    Hi all, can any one help me to follow the steps to improve performance in oracle standard edition. We are 19c version on aws rds.

    4 answers0 replies
    0
    4 Comments

    Share Your ThoughtsSign up to leave a comment.

    A
    Arun Kumar
    Nov 01, 2021
    •

    It's very hard to improve Oracle performance on RDS as there is not much control over the database sys user. Anyways, try below things to quick fix the performance:


    Optimize Join Conditions

    Many developer when they write join conditions, they actually start with a query which returns highest number of records and then join it over to another table which fetches less records. In such cases, you must make sure the driving query is fetching least amount of records.


    Bind Variables

    Ask developer team to use more of bind variables for queries rather than literals.


    Resize Temp Tablespace

    Many a times temp is overlooked in AWS RDS, make sure you constantly check temp tablespace size and add space as required.


    Also, let us know if querying from database is slow or importing to RDS using datapump is slow? Coz most of the times people complain about RDS slow datapump imports.

    2
    S
    syam Kumar
    Nov 01, 2021
    •
    Replying to

    @Arun Kumar thanks for the response. Definitely I will post the status once I implement above points.

    Like

    robert
    Mar 08

    I created a toolkit that works on standard edition. Ee too it pulls data out and runs 100s of checks to improve performance. Send me email and will help you. I use it on several e-commerce sites and custom built apps.

    robert

    1
    robert
    Mar 08
    Replying to

    Also make sure you install stats pack. In SE you can install this free.

    Like
    4 comments
    Similar Posts
    • Performance Tuning
    • How to determine the optimal degree of parallelism to expedite datapump
    • FLushout bad execution plans only

    support@dbagenesis.com

    • Facebook
    • Instagram
    • Twitter
    • YouTube

    © 2023 Biggest Database Forum by DBA Genesis