We have a license for 300 users in ALC. How do we know how many of those that we are using?
Is it simply the number of Active users in the def_person table?
This query (written for SQL Server) would give you the answer:
SELECT COUNT(*) FROM DEF_PERSON WHERE (EXPIRES IS NULL OR EXPIRES > CURRENT_TIMESTAMP) AND LEN(LOGONID) > 0
For Oracle it would be a little different, so let me know if you need to see an Oracle version of this query.
I think that for license count only users with "ISASSIGNABLE" flag are taken into account.