OraFAQ Forum: Performance Tuning

Home » RDBMS Server » Performance Tuning » Batch Tuning

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

Batch Tuning [message #120792]

Mon, 23 May 2005 15:16

kanth33
Messages: 2
Registered: May 2005

Junior Member

Hi Gurus,

1.What is the purpose of batch tuning in an application

2.Say if the size of datbase is 1.75TeraByte then how many tables exists in the database for this datasize [i need an approximate figure, if possible] and number of rows that is possible in a table.

Thanks
Naveen

Report message to a moderator

Re: Batch Tuning [message #120794 is a reply to message #120792]

Mon, 23 May 2005 15:39

Mahesh Rajendran
Messages: 10694
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

>>.Say if the size of datbase is 1.75TeraByte then how many tables exists in the database for this datasize [i need an approximate figure, if possible] and number of rows that is possible in a table.

you have a database of size 1.75 TB.
You want to find how many tables exist.
There is no generalized theory to predict this.
login as admin user and issue

sql>select count(*) from dba_tables;

>> number of rows that is possible in a table.
Virtually unlimited.

Report message to a moderator

Re: Batch Tuning [message #120795 is a reply to message #120794]

Mon, 23 May 2005 15:43

kanth33
Messages: 2
Registered: May 2005

Junior Member

Hi Mahesh
Thanks for the immediate reply.It was helpful

and regarding batch tuning, i need some information like where it is employed and in an application like merchandising systems how it is used..

any information will be very useful

Thanks once again
Naveen

Report message to a moderator

Re: Batch Tuning [message #120797 is a reply to message #120795]

Mon, 23 May 2005 15:49

Mahesh Rajendran
Messages: 10694
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

>>and regarding batch tuning, i need some information like where it >>is employed and in an application like merchandising systems how it is used..

>>any information will be very useful

Batch loading is a process where you load data in a series of steps and usually it may handly huge volumes of data.
Typically used in warehouse or any such environment

Report message to a moderator

Previous Topic:	Performance problem!!
Next Topic:	All "Rows" equal 0 in TKPROF. Is this a setting?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Jan 19 22:29:35 CST 2021