How can I know the size of my Oracle database?
=====================================================
An oracle database consists of data files, redo log files, control files, temporary files.
Whenever you say the size of the database this actually means the summation of these files.
Also, if you are in archive log mode, you will generate files in your archive log
destination. Issue the following query to see where your archived redo
logs get placed:
select * from v$parameter where name = 'log_archive_dest';
overall Database Size Query will be ...
SELECT round( a.data_size
+ b.temp_size
+ c.redo_size
+ d.controlfile_size,4) "total_size in GB"
FROM (SELECT SUM (BYTES) / 1024 / 1024/ 1024 data_size
FROM dba_data_files) a,
(SELECT NVL (SUM (BYTES), 0) / 1024 / 1024/ 1024 temp_size
FROM dba_temp_files) b,
(SELECT SUM (BYTES) / 1024 / 1024/ 1024 redo_size
FROM SYS.v_$log) c,
(SELECT SUM (block_size * file_size_blks) / 1024/ 1024
/ 1024 controlfile_size
FROM v$controlfile) d
or you can see it
---its only oracle datafiles summation size
SELECT name, highwater/ 1024 / 1024/ 1024, last_value / 1024 / 1024/ 1024
FROM dba_high_water_mark_statistics where name = 'DB_SIZE';
Halim is a Sr. Database Engineer/Data Architect (in Atlanta, USA) who is an Oracle certified (OCP) DBA, (OCP) Developer, Certified Cloud Architect Professional as well as OCI Autonomous DB specialist with extensive expertise in Database design, configuration, tuning, capacity planning, RAC, DG, Scripting, Python, PL/SQL etc. He achieved 16th position in worldwide first-ever PL/SQL Challenge cup playoff- http://plsql-challenge.blogspot.com/2010/07/winners-of-first-plsql-challenge.html
Subscribe to:
Post Comments (Atom)
My Blog List
-
-
-
4096 Columns1 week ago
-
-
-
-
-
-
-
Oracle Cloud & Third party tools4 years ago
-
-
-
Moving Sideways8 years ago
-
Upcoming Events...10 years ago
-
No comments:
Post a Comment