Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.
Course Of The Month
Become a Premium Member and unlock a new, free course in leading technologies each month.
Solved
how to do perfomance tuning in oracle
Posted on 2014-01-14
Hi experts,
i need to do some some performance tuning in oracle. please help me in this.
any sites where i can follow.
if any doubts please let me know i will do clarify.
Thanks
Thomos
i need to do some some performance tuning in oracle. please help me in this.
any sites where i can follow.
if any doubts please let me know i will do clarify.
Thanks
Thomos
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
3-
2
- +1
12 Comments
Active today
People make entire careers and write entire books on tuning Oracle. We really cannot offer specifics on how you need to tune your system.
I would start with the online docs:
Oracle Database 2 Day + Performance Tuning Guide
http://docs.oracle.com/cd/E11882_01/server.112/e10822/toc.htm
Oracle Database Performance Tuning Guide
http://docs.oracle.com/cd/E11882_01/server.112/e41573/toc.htm
You also need to set tuning goals. Remember "faster" isn't a goal.
What is running slow?
Where are you going to focus your efforts?
etc...
If you are licensed for it the Performance Pack in Enterprise Manager has some very nice advisors that can help a lot.
I would start with the online docs:
Oracle Database 2 Day + Performance Tuning Guide
http://docs.oracle.com/cd/E11882_01/server.112/e10822/toc.htm
Oracle Database Performance Tuning Guide
http://docs.oracle.com/cd/E11882_01/server.112/e41573/toc.htm
You also need to set tuning goals. Remember "faster" isn't a goal.
What is running slow?
Where are you going to focus your efforts?
etc...
If you are licensed for it the Performance Pack in Enterprise Manager has some very nice advisors that can help a lot.
Active today
Starting with the Oracle documentation as noted above is a great place to start. If you read and understand those, you'll already be ahead of 90% of everyone else.
If you want to get in deeper into internals of Oracle operations then I suggest following the blog of the Oracle Optimizer Team. It's updated fairly regularly with really good content describing how execution plans are generated, how statistics should be gathered and how they affect the plans as well as descriptions of how different sql syntax will impact the choices of optimization. It hasn't been updated much recently but it's still a very good resource.
https://blogs.oracle.com/optimizer/
Jonahthan Lewis and Richard Foote provide fantastic analysis of the plan, trace and index usage. Foote in particular dives VERY deep into the structure and usage of indexes.
Lewis's blog is broader in scope - encompassing nearly all aspects of tuning and is definitely well worth a read, as are his books.
http://jonathanlewis.wordpress.com/
http://richardfoote.wordpress.com/
And last, Tom Kyte has written several books, maintains a blog and is the Tom behind asktom.oracle.com - He's definitely someone to follow
http://tkyte.blogspot.com/
If you want to get in deeper into internals of Oracle operations then I suggest following the blog of the Oracle Optimizer Team. It's updated fairly regularly with really good content describing how execution plans are generated, how statistics should be gathered and how they affect the plans as well as descriptions of how different sql syntax will impact the choices of optimization. It hasn't been updated much recently but it's still a very good resource.
https://blogs.oracle.com/optimizer/
Jonahthan Lewis and Richard Foote provide fantastic analysis of the plan, trace and index usage. Foote in particular dives VERY deep into the structure and usage of indexes.
Lewis's blog is broader in scope - encompassing nearly all aspects of tuning and is definitely well worth a read, as are his books.
http://jonathanlewis.wordpress.com/
http://richardfoote.wordpress.com/
And last, Tom Kyte has written several books, maintains a blog and is the Tom behind asktom.oracle.com - He's definitely someone to follow
http://tkyte.blogspot.com/
Assuming the performance problem NOT related to Network/IO/Storage/or any OS related.
There are few simple steps you can solve this issue
1) Get the TOP SQL by running TOP command in *nix or using OEM
2) Check the STATISTICS on the table involved, run the STATS if required
3) Check on the explain plan, if full table scan found go for the indexes
4) Look out for any Locking or Blocking
These are the basic steps you can do to troubleshoot the performance issues.
There are few simple steps you can solve this issue
1) Get the TOP SQL by running TOP command in *nix or using OEM
2) Check the STATISTICS on the table involved, run the STATS if required
3) Check on the explain plan, if full table scan found go for the indexes
4) Look out for any Locking or Blocking
These are the basic steps you can do to troubleshoot the performance issues.
@SlightVW
Hope you'll NOT delete this post, this is purely comes from my note as well as collect the info from internet.
If this is deleted again, I'll never ever login to EE.
Thanks,
Stanley
PTChart.docx
Hope you'll NOT delete this post, this is purely comes from my note as well as collect the info from internet.
If this is deleted again, I'll never ever login to EE.
Thanks,
Stanley
PTChart.docx
Featured Post
Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
Have you ever had to make fundamental changes to a table in Oracle, but haven't been able to get any downtime? I'm talking things like:
* Dropping columns
* Shrinking allocated space
* Removing chained blocks and restoring the PCTFREE
* Re-orβ¦
Shell script to create broker configuration file using current broker Configuration, solely for purpose of backup on Linux.
Script may need to be modified depending on OS-installation.
Please deploy and verify the script in a test environment.
This video explains at a high level about the four available data types in Oracle and how dates can be manipulated by the user to get data into and out of the database.
This video shows information on the Oracle Data Dictionary, starting with the Oracle documentation, explaining the different types of Data Dictionary views available by group and permissions as well as giving examples on how to retrieve data from thβ¦
Suggested Courses
Earn Certification
HTML5 Specialist - Certification
Free withPremium
Course of the Month6 days, 1 hour left to enroll
Earn Certification
Certified Information Systems Auditor (CISA)
$99.00$89.10
626 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.