eG Helpdesk posted
almost 10 years ago
AdminBest Answer
Follow the below steps to find the
eG database size,
If you are monitoring eG
database server as a sql component then go to the component> MS SQL Database
layer>SQL Database Space>(eG Database). On the right side you will see
the total size measures for the eG database.
On the eG Database server connect to the SQL.Select eG Database and click on New Query, run the Query sp_spaceused. Once the Query is completed you will get the total DB space utilized.
Command
to find the size of the eG Database in oracle.
a)To
Find the Actual size of the Database in GB
SELECT SUM (bytes) / 1024 / 1024 / 1024
AS GB FROM dba_data_files;
b)To
Find the Size Occupied by Data in the Database
SELECT
SUM (bytes)/1024/1024/1024 AS GB FROM dba_segments;
c)To
Find the Overall/Total Database Size
select
( select sum(bytes)/1024/1024/1024
data_size from dba_data_files ) +
( select
nvl(sum(bytes),0)/1024/1024/1024 temp_size from dba_temp_files ) +
( select sum(bytes)/1024/1024/1024
redo_size from sys.v_$log ) +
( select
sum(BLOCK_SIZE*FILE_SIZE_BLKS)/1024/1024/1024 controlfile_size from
v$controlfile) "Size in GB"
from
dual
0 Votes
1 Comments
eG Helpdeskposted
almost 10 years ago
AdminAnswer
Follow the below steps to find the
eG database size,
If you are monitoring eG
database server as a sql component then go to the component> MS SQL Database
layer>SQL Database Space>(eG Database). On the right side you will see
the total size measures for the eG database.
On the eG Database server connect to the SQL.Select eG Database and click on New Query, run the Query sp_spaceused. Once the Query is completed you will get the total DB space utilized.
Command
to find the size of the eG Database in oracle.
a)To
Find the Actual size of the Database in GB
SELECT SUM (bytes) / 1024 / 1024 / 1024
AS GB FROM dba_data_files;
b)To
Find the Size Occupied by Data in the Database
SELECT
SUM (bytes)/1024/1024/1024 AS GB FROM dba_segments;
c)To
Find the Overall/Total Database Size
select
( select sum(bytes)/1024/1024/1024
data_size from dba_data_files ) +
( select
nvl(sum(bytes),0)/1024/1024/1024 temp_size from dba_temp_files ) +
( select sum(bytes)/1024/1024/1024
redo_size from sys.v_$log ) +
( select
sum(BLOCK_SIZE*FILE_SIZE_BLKS)/1024/1024/1024 controlfile_size from
v$controlfile) "Size in GB"
How can i find the eG database size?
0 Votes
eG Helpdesk posted almost 10 years ago Admin Best Answer
Follow the below steps to find the eG database size,
Command to find the size of the eG Database in oracle.
a) To Find the Actual size of the Database in GB
SELECT SUM (bytes) / 1024 / 1024 / 1024 AS GB FROM dba_data_files;
b) To Find the Size Occupied by Data in the Database
SELECT SUM (bytes)/1024/1024/1024 AS GB FROM dba_segments;
c) To Find the Overall/Total Database Size
select
( select sum(bytes)/1024/1024/1024 data_size from dba_data_files ) +
( select nvl(sum(bytes),0)/1024/1024/1024 temp_size from dba_temp_files ) +
( select sum(bytes)/1024/1024/1024 redo_size from sys.v_$log ) +
( select sum(BLOCK_SIZE*FILE_SIZE_BLKS)/1024/1024/1024 controlfile_size from v$controlfile) "Size in GB"
from
dual
0 Votes
1 Comments
eG Helpdesk posted almost 10 years ago Admin Answer
Follow the below steps to find the eG database size,
Command to find the size of the eG Database in oracle.
a) To Find the Actual size of the Database in GB
SELECT SUM (bytes) / 1024 / 1024 / 1024 AS GB FROM dba_data_files;
b) To Find the Size Occupied by Data in the Database
SELECT SUM (bytes)/1024/1024/1024 AS GB FROM dba_segments;
c) To Find the Overall/Total Database Size
select
( select sum(bytes)/1024/1024/1024 data_size from dba_data_files ) +
( select nvl(sum(bytes),0)/1024/1024/1024 temp_size from dba_temp_files ) +
( select sum(bytes)/1024/1024/1024 redo_size from sys.v_$log ) +
( select sum(BLOCK_SIZE*FILE_SIZE_BLKS)/1024/1024/1024 controlfile_size from v$controlfile) "Size in GB"
from
dual
0 Votes
Login to post a comment