oracle查询表空间下的所有用户

select * from v$tablespace;

0 SYSTEM YES NO YES
1 SYSAUX YES NO YES
2 UNDOTBS1 YES NO YES
4 USERS YES NO YES
3 TEMP NO NO YES
6 EXAMPLE YES NO YES
7 AYD YESNO YES
8 AYD_TEMP NO NO YES
9 CD_TEMP NO NO YES
10 CD_DATA YES NO YES
11 OK_TEMP NO NO YES
12 OK_ZHZS YES NO YES
15 AHZHZS_TEMPNO NO YES
16 AHZHZS_DATAYES NO YES