Tips (merged 5) [message #426073] |
Wed, 14 October 2009 01:00  |
kuberentp
Messages: 6 Registered: October 2009 Location: Vizag
|
Junior Member |
|
|
UNCOMPRESSED DATA
SQL> create table myobjects
2 as select * from all_objects;
Table created.
SQL> select sum(bytes)/1048576 from user_segments where segment_name='MYOBJECTS';
SUM(BYTES)/1048576
------------
21
|
|
|
Tips [message #426074 is a reply to message #426073] |
Wed, 14 October 2009 01:04   |
kuberentp
Messages: 6 Registered: October 2009 Location: Vizag
|
Junior Member |
|
|
COMPRESSED DATA
SQL> create table myobjects_compress
2 compress for all operations
3 as select * from all_objects;
SQL> select sum(bytes)/1048576 from user_segments where segment_name='MYOBJECTS_COMPRESS';
SUM(BYTES)/1048576
------------
9
|
|
|
|
|
|
Tips [message #426082 is a reply to message #426073] |
Wed, 14 October 2009 01:12   |
kuberentp
Messages: 6 Registered: October 2009 Location: Vizag
|
Junior Member |
|
|
SQL> insert into myobjects
2 select * from all_objects;
56261 rows created.
Elapsed: 00:00:09.39
SQL> select count(*) from myobjects where object_type='TABLE';
COUNT(*)
-------
444
Elapsed: 00:00:00.66
|
|
|
|
Tips [message #426085 is a reply to message #426073] |
Wed, 14 October 2009 01:14   |
kuberentp
Messages: 6 Registered: October 2009 Location: Vizag
|
Junior Member |
|
|
SQL> insert into myobjects_compress
2 select * from all_objects;
56261 rows created.
Elapsed: 00:00:09.08
SQL> select count(*) from myobjects_compress where object_type='TABLE';
COUNT(*)
-------
444
Elapsed: 00:00:00.21
|
|
|
Tips [message #426086 is a reply to message #426073] |
Wed, 14 October 2009 01:17   |
kuberentp
Messages: 6 Registered: October 2009 Location: Vizag
|
Junior Member |
|
|
SQL> delete myobjects;
168780 rows deleted.
Elapsed: 00:00:12.22
SQL> delete myobjects_compress;
168783 rows deleted.
Elapsed: 00:00:10.96
|
|
|
|
|
Re: Tips [message #426091 is a reply to message #426080] |
Wed, 14 October 2009 01:24   |
Frank
Messages: 7901 Registered: March 2000
|
Senior Member |
|
|
kuberentp wrote on Wed, 14 October 2009 08:10These are not questions just tips see the next tip I had posted
I may be thick, but I really miss the point you are trying to make.
You insert some records, and when you query the table you see it has records inserted.
Apart from what Maaher already pointed out (welcome back, Maarten!), please elaborate on what tip you are providing.
|
|
|
|
|
|
|