OraFAQ Forum: Performance Tuning » DATABASE TUNING PRINCIPLE AND DATABASE TROUBLESHOOTING.

Home » RDBMS Server » Performance Tuning » DATABASE TUNING PRINCIPLE AND DATABASE TROUBLESHOOTING. (LINUX)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

DATABASE TUNING PRINCIPLE AND DATABASE TROUBLESHOOTING. [message #657020]

Wed, 26 October 2016 05:32

osama.mansoor
Messages: 9
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.

Report message to a moderator

Re: DATABASE TUNING PRINCIPLE AND DATABASE TROUBLESHOOTING. [message #657024 is a reply to message #657020]

Wed, 26 October 2016 06:36

Flyby
Messages: 188
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)
...

Report message to a moderator

Re: DATABASE TUNING PRINCIPLE AND DATABASE TROUBLESHOOTING. [message #657026 is a reply to message #657020]

Wed, 26 October 2016 07:04

John Watson
Messages: 8964
Registered: January 2010
Location: Global Village

Senior Member

Is this anything to do with Oracle?

Report message to a moderator

Re: DATABASE TUNING PRINCIPLE AND DATABASE TROUBLESHOOTING. [message #657030 is a reply to message #657026]

Wed, 26 October 2016 08:01

osama.mansoor
Messages: 9
Registered: October 2016

Junior Member

yes

Report message to a moderator

Re: DATABASE TUNING PRINCIPLE AND DATABASE TROUBLESHOOTING. [message #657031 is a reply to message #657030]

Wed, 26 October 2016 08:07

John Watson
Messages: 8964
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

Report message to a moderator

Re: DATABASE TUNING PRINCIPLE AND DATABASE TROUBLESHOOTING. [message #657034 is a reply to message #657031]

Wed, 26 October 2016 08:25

osama.mansoor
Messages: 9
Registered: October 2016

Junior Member

Not 100 % related to oracle , its about general DB

Report message to a moderator

Re: DATABASE TUNING PRINCIPLE AND DATABASE TROUBLESHOOTING. [message #657038 is a reply to message #657034]

Wed, 26 October 2016 10:16

Michel Cadot
Messages: 68733
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

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

[Updated on: Mon, 17 May 2021 09:21]

Report message to a moderator

Re: DATABASE TUNING PRINCIPLE AND DATABASE TROUBLESHOOTING. [message #657055 is a reply to message #657038]

Thu, 27 October 2016 03:05

Roachcoach
Messages: 1576
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.

Report message to a moderator

Previous Topic:	Cursor Optimization
Next Topic:	Query Tuning

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Feb 09 01:04:18 CST 2025