Home » RDBMS Server » Performance Tuning » DATABASE TUNING PRINCIPLE AND DATABASE TROUBLESHOOTING. (LINUX)
DATABASE TUNING PRINCIPLE AND DATABASE TROUBLESHOOTING. [message #657020] Wed, 26 October 2016 05:32 Go to next message
osama.mansoor
Messages: 4
Registered: October 2016
Junior Member
Hi Experts,

I am new in learning of DATABASE.

My next assignment is to understand about DATABASE TUNING PRINCIPLE AND DATABASE TROUBLESHOOTING.

Can some one please gudie me what should be topics / contents in my this assignment.
Re: DATABASE TUNING PRINCIPLE AND DATABASE TROUBLESHOOTING. [message #657024 is a reply to message #657020] Wed, 26 October 2016 06:36 Go to previous messageGo to next message
Flyby
Messages: 187
Registered: March 2011
Location: Belgium
Senior Member
That is quite a broad scope. Which have you found?
You can have database tuning designs (OLTP 3th normal form, OLAP datamarts)
, tuning methodoloy
, understanding database concepts
, troubleshooting software (software errors)
, troubleshooting hardware (hardware errors/configuration that might affect your database)
...
Re: DATABASE TUNING PRINCIPLE AND DATABASE TROUBLESHOOTING. [message #657026 is a reply to message #657020] Wed, 26 October 2016 07:04 Go to previous messageGo to next message
John Watson
Messages: 7664
Registered: January 2010
Location: Global Village
Senior Member
Is this anything to do with Oracle?
Re: DATABASE TUNING PRINCIPLE AND DATABASE TROUBLESHOOTING. [message #657030 is a reply to message #657026] Wed, 26 October 2016 08:01 Go to previous messageGo to next message
osama.mansoor
Messages: 4
Registered: October 2016
Junior Member
yes
Re: DATABASE TUNING PRINCIPLE AND DATABASE TROUBLESHOOTING. [message #657031 is a reply to message #657030] Wed, 26 October 2016 08:07 Go to previous messageGo to next message
John Watson
Messages: 7664
Registered: January 2010
Location: Global Village
Senior Member
If it really is Oracle related, you had better post the actual question for this assignment. You could also talk to your fellow student, who posted the same question on OTN (with a similar lack of detail),
https://community.oracle.com/thread/3985224
Re: DATABASE TUNING PRINCIPLE AND DATABASE TROUBLESHOOTING. [message #657034 is a reply to message #657031] Wed, 26 October 2016 08:25 Go to previous messageGo to next message
osama.mansoor
Messages: 4
Registered: October 2016
Junior Member
Not 100 % related to oracle , its about general DB
Re: DATABASE TUNING PRINCIPLE AND DATABASE TROUBLESHOOTING. [message #657038 is a reply to message #657034] Wed, 26 October 2016 10:16 Go to previous messageGo to next message
Michel Cadot
Messages: 65964
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Each and every RDBMS are different, so no general principles bit this one which is the performances directive: never asks a database to do more work than it has to do.

Re: DATABASE TUNING PRINCIPLE AND DATABASE TROUBLESHOOTING. [message #657055 is a reply to message #657038] Thu, 27 October 2016 03:05 Go to previous message
Roachcoach
Messages: 1571
Registered: May 2010
Location: UK
Senior Member
If you're new to databases, tuning is not where to start. First understand how your database works and understand it well. Then you're in a better position to understand the bottlenecks you will encounter and how to resolve them.

Before you read anything, read the concepts book and make sure you fully understand it.
Previous Topic: Cursor Optimization
Next Topic: Query Tuning
Goto Forum:
  


Current Time: Thu Nov 15 10:40:36 CST 2018