OraFAQ Forum: Performance Tuning » Logical database design

Home » RDBMS Server » Performance Tuning » Logical database design

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

Logical database design [message #124715]

Tue, 21 June 2005 01:30

hafeez_splendid
Messages: 15
Registered: June 2005
Location: india

Junior Member

Can anyone tell me what are all parameters of Logical database which are to be consider while performing database design for getting better performance.

I got to know some of them,such as,
1.Connection Pool size
2.Index Pool size
3.Connection threads etc.,

I dont have much idea about this. Please throw some light over this .

Thanks in advance

Report message to a moderator

Re: Logical database design [message #124847 is a reply to message #124715]

Tue, 21 June 2005 16:08

andrew again
Messages: 2577
Registered: March 2000

Senior Member

"Logical database design" means logical design of ERD (where you have entities, attributes and M:M relationships) as opposed to physical database design where you have tables, columns, M:M resolving tables etc). Connection pooling is just a way to more efficiently create connections to the database for a large (say > 200) number of concurrent users.

Report message to a moderator

Re: Logical database design [message #124917 is a reply to message #124715]

Wed, 22 June 2005 06:02

hafeez_splendid
Messages: 15
Registered: June 2005
Location: india

Junior Member

Hi Andrew,
First of all thanx for ur reply but actually i want to know the parameters of logical part of database. I heard that by giving appropriate values to those parameters we can gain better performance . And they must be considered while creation of database

Can u tell me how this parameters such as Connection Pool size ,Index pool size can be set .

Thanks in advance

Report message to a moderator

Re: Logical database design [message #124956 is a reply to message #124715]

Wed, 22 June 2005 08:51

smartin
Messages: 1803
Registered: March 2005
Location: Jacksonville, Florida

Senior Member

Suggest you read the concepts guide.
http://download-west.oracle.com/docs/cd/B14117_01/server.101/b10743/toc.htm

Report message to a moderator

Re: Logical database design [message #125504 is a reply to message #124715]

Mon, 27 June 2005 02:29

hafeez_splendid
Messages: 15
Registered: June 2005
Location: india

Junior Member

Thanq for replying .

i read the document and got to know something about " Connection Pooling ".But the main problem is that i didnt find anything about other parameters.

I need to know " Does the size of connection pooling depends upon parameters like I/O reads , I/O writes ,CPU reads, CPU writes, Number of users, Number of concurrent transactions, type of application(OLTP,OLAP) .

Report message to a moderator

Re: Logical database design [message #125566 is a reply to message #125504]

Mon, 27 June 2005 13:20

andrew again
Messages: 2577
Registered: March 2000

Senior Member

There are no specific parameters I know of specifically related to connection pooling. Are you talking about Oracle databse built in connection pooling/sharing capability mode (MTS = old name; shared server mode = new name). Or are you thinking about connection pooling from a middle tier like an application server?

Connection pooling is used to reduce the number connections (which each consume memory and other resourses) specifically when open connections are idle and there are a large number of concurrent users. OLTP is often characterised by large number of concurrent users and short individual transactions or queries. Reporting systems are often characterised by smaller numbers of users and having longer queries.

Database parameters would be influenced by the number of concurrent connections to the database. See PGA, large pool etc. parameters.

Report message to a moderator

Previous Topic:	Index for temporary table
Next Topic:	Explain plan

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Jan 24 04:17:12 CST 2025