0 Comments

How to check tablespace size. 5 (2)

Below sql query is used to find total tablespace size of your database. which includes Tablespace name used size in MB, free size in MB and Total size in MB Sql command which fetch tablesapce size in GB Click here to get sample output We always encourage the technical person to visit section SCRIPTS to get more […]

 237 total views,  4 views today

Spread the love

0 Comments

How to check oracle client version. 5 (1)

Sometime we have to run application script from application server, but script required defined oracle version to run application script successfully Below are the Sql query to find the oracle client version. SQL command to get oracle client version. Click here to get sample output.  226 total views DBsGuruHello and welcome to DBsGuru, DBsGuru is a […]

 226 total views

Spread the love

0 Comments

How to find all physicals files in Oracle 4 (1)

Below is command, how to find all physical files in Oracle in one short (control files, datafiles & redolog files). Click here to get sample output of all physical files in oracle Question: Why do we need all physical files together? Answer: Whenever we do decommission / clone etc. Hope so you like this article!Please […]

 162 total views,  1 views today

0 Comments

How to find Database size in Oracle 5 (1)

Below commands to find Database size in Oracle which includes Total DB size, Free size, used size of DB along with DB name & Hostname, etc. SQL command which fetches database size in GB. Click here to get a sample output of the Oracle client version. SQL command which fetch database size in MB. Click […]

 245 total views

Spread the love