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
1 Comment
eG Helpdesk
said
over 8 years ago
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"
Doug Schreiner
How can i find the eG database size?
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
eG Helpdesk
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
-
Finding eG Agent version
-
Delete and Acknowledge alarms
-
Updating nick names
-
Changing IP address of a monitored component
-
Changing IP address of remote agent and external agent
-
Inside view metrics are not collected by eG
-
Error 1067
-
Agent stopped running
-
eG agent auto-startup
-
Remote agent connection issue
See all 77 topics