I need to carry out a survey at Banco Oracle (I'm not DBA) in the following scenario: I have The quantity of rows, after deleting some tables in the database.
This value, reaches approximately 50 million records that I will perform the "purge".
Doubt:
For not having access to dba_segments , I can, make a calculation, converting the Quantity of lines in bytes? [/ list]
on the conversion, until I found on a site, but, as I am a little bit, I preferred to act otherwise (climb to a team with permission DBA_SEGMENTS, even if it slows longer than I do the queries myself).
About the survey?
I am in a project of "purged" base, that is, dozens of bank objects will suffer delete, Others, trucize and there goes.
What happens is that the client wants to know in size (Storage), how much he will save.
That's why I need the information.
– Tamanho de Cada Tabela
SELECT owner, tablespace_name, segment_name,
round(sum(bytes/1024/1024),2) as Tamanho_MB –, extents as Num_extents
FROM dba_segments
WHERE owner = ‘SCOTT’
AND segment_type = ‘TABLE’
– AND segment_name like ‘DEPT%’
GROUP BY owner, tablespace_name, segment_name
– Tamanho das Tabelas Por Usuário
SELECT owner, round(sum(bytes/1024/1024),2) as Tamanho_MB –, extents as Num_extents
FROM dba_segments
GROUP BY owner
– Tamanho Total das Tabelas
SELECT round(sum(bytes/1024/1024),2) as Tamanho_MB –, extents as Num_extents
FROM dba_segments
on dba_segments does not really help me very much, by the facts of permissions, etc.
I would like to know if there is any script, which I can, for example, through 1 record of the databases, calculate your size, having this record columns number, varchar2, date etc .
Why?
I need to do a partial cleaning of a table and, before cleaning, inform the client the "gain" that he will have.
Brother,
Would not you duplicate this somewhere?
So you would raise the current size ... After that deleting the data, etc. You would raise the new size
then yes you did the calculation, graphic, percentage for the customer showing ...
is what I would give to be done, since you do not administer the database.
