Are there any tables that I can get all Oracle supported system privileges and object privileges? I know there is a view called
all_sys_privs in Oracle. But I can't find more information about it.
You can look into sys.table_privilege_map (at-least 11g onwards, might exist before but I have no way to check) for a listing of possible object privileges, be warned not all apply to all object types.
Try this query for object privileges by object type.
The following takes into account privilege types that exist in table_privilege_map but not in the existing database objects.