DBA Tools |
|
Good tools make the work easy and improve life quality. |
|
Tips: Add to Google | Oracle DUL? | AUL License | AnySQL.net | asyncdata | ociuldr
Contact: anysql©yahoo.com/anysql©126.com, MSN: loufangxin©msn.com, AIM: loufangxin
Get Oracle space usage information in AnySQL
You can get the table and it's indexes' or lob segments' size by "ORA SIZE" command easily. ASQL> ora size sh.t_lobtest OWNER SEGMENT_NAME SEGMENT_TYPE SIZE_MB INIEXT MAXEXT ----- ------------------------- ------------ ------- ------ ------ SH T_LOBTEST TABLE 0.0625 65536 SH SYS_IL0000012006C00001$$ LOBINDEX 0.0625 65536 SH SYS_LOB0000012006C00002$$ LOBSEGMENT 0.0625 65536...
Personal Information
| Name | Fangxin Lou |
| Job | Oracle DBA |
| Loc | Shanghai China (+08:00) |
| Skype | anysql |
| MSN | anysql©live.com |
| AIM | loufangxin |
| anysql©126.com anysql©yahoo.com |
Contact us: anysql©yahoo.com/anysql©126.com, MSN: loufangxin©msn.com, AIM: loufangxin