size of tables

[Roshan]

Oracle Database 12.1.0.2

Hi Erman,

happy New Year 2018.

I have some tables on a production server.
Table_cbs.xlsx

Can you please advise how I can find the size of all the tables in the excel. I need to provision a new server and find an approximate size for hard disk.

Thanks,

Roshan

[ErmanArslansOracleBlog]

Happy new year roshan.

For finding the size of a table, you can use SQL.

Here is a sql for you:

elect segment_name,segment_type,bytes/1024/1024 MB
 from dba_segments
 where segment_type='TABLE' and segment_name='<yourtablename>';

You can modify this query to display the sizes of all your tables  or you can execute this query for every table in your excel.

[Roshan]

Oracle Database 12.1.0.2

Hello,

we have a production environment with 2 nodes cluster.

Database 12.1.0.2

It is clustered HP physical servers with the shared disk ( LUN ) on our 3PAR storage making use of Oracle ASM

Now, for the archiving part, it is proposed to deploy on VM infra. We propose to deploy according to the following best practice:

 https://www.vmware.com/content/dam/digitalmarketing/vmware/en/pdf/solutions/vmware-oracle-databases-on-vmware-best-practices-guide.pdf

Can you please confirm

Two VMs with shared 1.5 TB hard disk will be provisioned for as follows:

 

-        Shared disk on ISILON

-        Separate /var ,/tmp,/opt is separate from root

if we can go through?

Regards,

Roshan

[ErmanArslansOracleBlog]

Please create a seperate issue for this one..
This is completely different question.