To find out a size of a table in Megabytes use below SQL select segment_name,(bytes)/1024/1024 MB
2 from user_segments where
3 segment_type = 'TABLE'
4* and SEGMENT_NAME='TABLE_NAME'
negative regexp
3 months ago
Hi Readers, I want share my Oracle learning with all oracle users/ developers/DBAs and Oracle lovers. if you would like to learn or know any oracle database feature , please leave me a comment will try to explore and post my experience ~Ajay
To find out a size of a table in Megabytes use below SQL select segment_name,(bytes)/1024/1024 MB
2 from user_segments where
3 segment_type = 'TABLE'
4* and SEGMENT_NAME='TABLE_NAME'
Labels: Table size
Zona Cerebral | WP Premium Blogger Template | Original WP Premium theme by WP Remix | Server Monitoring
Copyright 2008. R.Bhavesh. All rights reserved
0 comments:
Post a Comment