Halimdba

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

Monday, October 12, 2009

How much a Database user use space

How much a Database user use space ?
solution:

---in Mega bytes

SELECT SUM (BYTES) / 1024 / 1024 mb
FROM dba_segments
WHERE owner = 'SCOTT';

Halimdba

Monday, October 12, 2009

How much a Database user use space

No comments:

My Blog List