OraFAQ Forum: General

Home » Other » General » Database

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Database [message #104336]

Sun, 26 September 2004 10:11

valiBasha
Messages: 9
Registered: September 2004

Junior Member

How can we found the size of Database.By using SQL queries.What are the alternate ways to find Size of the Database.

Report message to a moderator

Re: Database [message #104338 is a reply to message #104336]

Mon, 27 September 2004 00:18

easywebtech
Messages: 20
Registered: August 2004

Junior Member

To get the total size of the databse you need to look at the sizes of all of the datafiles.

select sum(bytes)/1024/1024 Database_in_MB from dba_data_files;

To see how many bytes have been allocated, you need to look at the segments:

select sum(bytes)/1024/1024 Used_space_in_mb from dba_segments;

webmaster
www.easywebtech.com

Report message to a moderator

Re: Database [message #104349 is a reply to message #104338]

Mon, 27 September 2004 10:54

valiBasha
Messages: 9
Registered: September 2004

Junior Member

I am vary thankful to easywebtech.
I got a size by executing that query. What is DBSNMP user. How can we logon into that user. How can we opened the locked users by executing Queries.
Is any machanism to modify column datatype which contains data.

Report message to a moderator

Re: Database [message #131137 is a reply to message #104336]

Thu, 04 August 2005 10:18

easywebtech123
Messages: 22
Registered: March 2005
Location: c

Junior Member

DBSNMP is the Intelligent Agent.
SNMP =Simple Network Management Protocol .
you can logon to the user by changing the password.

SQL> alter user "dbsnmp" identified by "<newpassword>";

http://www.easywebtech.com/
http://www.err-codes.com/
http://www.certified-easy.com

Report message to a moderator

Previous Topic:	Why need a Schema
Next Topic:	Oracle Apps Resources

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Dec 29 03:31:29 CST 2024