Home » RDBMS Server » Performance Tuning » Batch Tuning
Batch Tuning [message #120792] Mon, 23 May 2005 15:16 Go to next message
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
Re: Batch Tuning [message #120794 is a reply to message #120792] Mon, 23 May 2005 15:39 Go to previous messageGo to next message
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.
Re: Batch Tuning [message #120795 is a reply to message #120794] Mon, 23 May 2005 15:43 Go to previous messageGo to next message
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
Re: Batch Tuning [message #120797 is a reply to message #120795] Mon, 23 May 2005 15:49 Go to previous message
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
Previous Topic: Performance problem!!
Next Topic: All "Rows" equal 0 in TKPROF. Is this a setting?
Goto Forum:
  


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