dkim18
asked on
user uage, table usage metrics in Oracle?
Hi,
I am trying to find out if I can access these metrics through system catalog of the ORacle database.
-user uage (how often a user made connection to the database)
-table uage(what tables are accessed by this user)
-space usage on the database and table (how big is it? How much free space?)
THanks.
I am trying to find out if I can access these metrics through system catalog of the ORacle database.
-user uage (how often a user made connection to the database)
-table uage(what tables are accessed by this user)
-space usage on the database and table (how big is it? How much free space?)
THanks.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Man, this is great.
Very fast respone...
Very fast respone...
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
-allocated space versus actual used space
-how much free space in the table space
If auditing was on, how do I query them?
What are the sql queries?
THanks.