This is an archive of the Maximo Yahoo Community. The content of this pages may be a sometimes obsolete so please check post dates.
Thanks to the community owner Christopher Wanko for providing the content.
Hi Everyone,
How can I find the size of the existing data in the database?
Any help would be appreciated.
--
Thanks & Regards,
Krishna Gali
select count(*) will return the number of records in a table.
It is specific to each database. Your DBA can run admin scripts to get
that value for you. Similarly, a tool such as TOAD can do this for Oracle
by estimations if you lack the permissions. You yourself can calculate a
decent estimate, a ceiling if you will, by summing the maximum bytes of a
rows * the number of rows.
-C
On Thu, Nov 20, 2014 at 6:56 AM, 'krishna.Gali Gali'
krishna.agalakera@gmail.com [MAXIMO] <MAXIMO@yahoogroups.com> wrote:
>
>
> Hi Everyone,
>
> How can I find the size of the existing data in the database?
>
> Any help would be appreciated.
>
> --
> Thanks & Regards,
> Krishna Gali
>
>
>
>
>