Hi,

i am newbie to oracle db and want to know the solution for the following querry.

1. What is the total database size?
2. What is the freespace on the server?
3. Login failed details?
4. User created in last 24Hrs?
5. No of users in the DB server and among them how many has administrative previlege?

I badly need some querry for my requirements, i hope u guys can help me.

Thanks in advance.
Thaya