Home » SQL & PL/SQL » SQL & PL/SQL » Tips (merged 5) (Oracle 11g Advanced)
Tips (merged 5) [message #426073] Wed, 14 October 2009 01:00 Go to next message
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 Go to previous messageGo to next message
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
Re: Tips [message #426075 is a reply to message #426073] Wed, 14 October 2009 01:04 Go to previous messageGo to next message
Frank
Messages: 7901
Registered: March 2000
Senior Member
So you have a question?
Re: Tips [message #426080 is a reply to message #426075] Wed, 14 October 2009 01:10 Go to previous messageGo to next message
kuberentp
Messages: 6
Registered: October 2009
Location: Vizag
Junior Member
These are not questions just tips see the next tip I had posted
Re: Tips [message #426081 is a reply to message #426080] Wed, 14 October 2009 01:11 Go to previous messageGo to next message
Maaher
Messages: 7065
Registered: December 2001
Senior Member
If you have tips, why not add them to the OraFAQ wiki or start your OraFAQ blog? The forum is for questions.

MHE
Tips [message #426082 is a reply to message #426073] Wed, 14 October 2009 01:12 Go to previous messageGo to next message
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
Re: Tips [message #426084 is a reply to message #426082] Wed, 14 October 2009 01:14 Go to previous messageGo to next message
Maaher
Messages: 7065
Registered: December 2001
Senior Member
Same story: use http://www.orafaq.com/blog or http://www.orafaq.com/wiki/Main_Page

MHE
Tips [message #426085 is a reply to message #426073] Wed, 14 October 2009 01:14 Go to previous messageGo to next message
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 Go to previous messageGo to next message
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 #426087 is a reply to message #426086] Wed, 14 October 2009 01:18 Go to previous messageGo to next message
vamsi kasina
Messages: 2112
Registered: October 2003
Location: Cincinnati, OH
Senior Member
Thanks for the "TIPS".
Continue in the same thread.

By
Vamsi
Re: Tips [message #426089 is a reply to message #426087] Wed, 14 October 2009 01:20 Go to previous messageGo to next message
Maaher
Messages: 7065
Registered: December 2001
Senior Member
I rather like to see them combined in a single blog post or a wiki article.

This way, other questions get pushed away. Wink

MHE
Re: Tips [message #426091 is a reply to message #426080] Wed, 14 October 2009 01:24 Go to previous messageGo to next message
Frank
Messages: 7901
Registered: March 2000
Senior Member
kuberentp wrote on Wed, 14 October 2009 08:10
These 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.
Re: Tips [message #426095 is a reply to message #426091] Wed, 14 October 2009 01:48 Go to previous messageGo to next message
Michel Cadot
Messages: 68733
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
I bet the next "tip" will come with a link to his blog, site or company.

Regards
Michel
Re: Tips [message #426144 is a reply to message #426095] Wed, 14 October 2009 03:35 Go to previous messageGo to next message
Frank
Messages: 7901
Registered: March 2000
Senior Member
Already removed two non-relevant threads pointing to a training-company..
Re: Tips [message #426149 is a reply to message #426144] Wed, 14 October 2009 03:42 Go to previous messageGo to next message
Michel Cadot
Messages: 68733
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Yes, usual behaviour of spammers that can't post a link before 5 posts and so post 5 useless ones anywhere.

Regards
Michel
Re: Tips [message #426157 is a reply to message #426149] Wed, 14 October 2009 04:04 Go to previous message
Maaher
Messages: 7065
Registered: December 2001
Senior Member
Hah! I didn't know about that '5 post rule'. Should the OP be banned, then?

MHE

[Updated on: Wed, 14 October 2009 04:04]

Report message to a moderator

Previous Topic: utl_file issue?
Next Topic: To remove the special character from the starting of the string (merged)
Goto Forum:
  


Current Time: Fri Feb 07 00:03:14 CST 2025