New Spamming Thread....

nospam.jpg
 
spool temp



drop table t1;



create table t1 as

select * from all_objects

where rownum <= 3000

;



begin

dbms_stats.gather_table_stats(

ownname => user,

tabname =>'T1',

cascade => true,

estimate_percent => null,

granularity => 'DEFAULT',

method_opt => 'for all columns size 1'

);

end;

/



Prompt Note the number of blocks in the table.

select blocks from user_tables where table_name = 'T1';



alter session set "_rowsource_execution_statistics"=true;



rem

rem Run both queries 100 times

rem



declare

m_n number;

begin

for i in 1..100 loop

select count(*) into m_n from t1 where 1=1;

select count(*) into m_n from t1 where 1=2;

end loop;

end;

/



alter session set "_rowsource_execution_statistics"=false;



connect / as sysdba



column hash_value new_value m_hash



column sql_text format a50



column operation format a24

column object_name format a10

column cardinality format 9,999

column bytes format 99,999

column starts format 99,999

column cr_buffer_gets format 99,999





Prompt Execution plan for: where 1=1



select

hash_value, sql_text

from

V$sql

where

sql_text like '%1=1'

and sql_text not like '%v$sql%'

;



select

pl.operation || ' ' || pl.options operation,

pl.object_name,

pl.cardinality,

pl.bytes,

st.starts,

st.cr_buffer_gets

from

v$sql_plan pl,

v$sql_plan_statistics st

where

pl.hash_value = &m_hash

and pl.child_number = 0

and st.hash_value = pl.hash_value

and st.child_number = pl.child_number

and st.operation_id = pl.id

order by

pl.id

;



Prompt Execution plan for: where 1=2



select

hash_value, sql_text

from

V$sql

where

sql_text like '%1=2'

and sql_text not like '%v$sql%'

;



select

pl.operation || ' ' || pl.options operation,

pl.object_name,

pl.cardinality,

pl.bytes,

st.starts,

st.cr_buffer_gets

from

v$sql_plan pl,

v$sql_plan_statistics st

where

pl.hash_value = &m_hash

and pl.child_number = 0

and st.hash_value = pl.hash_value

and st.child_number = pl.child_number

and st.operation_id = pl.id

order by

pl.id

;





spool off
 
Instead of talking to your plants, if you yelled at them would they still grow, but only to be troubled and insecure?
 
How important does a person have to be before they are considered
assassinated instead of just murdered?
 
If corn oil is made from corn, and vegetable oil is made from vegetables,
what is baby oil made from?
 
The deep, dark truth about Spam. Also some nifty trivia. Impress your friends and relatives!

Ingredients:
Chopped pork shoulder meat with ham meat added.
Salt (for binding, flavour, and firmness)
Water (to help in mixing)
Sugar (for flavour)
Sodium Nitrite (for colour and as a preservative)
Yum yum!

Nutrition Information For SPAM (original style):
Calories Per Serving: 170
Calories Per Serving From Fat: 140
Serving Size: 2 oz.
Servings Per Container: 6 (large) or 3.5 (small)
Total Fat: 16g
Saturated Fat: 6g
Cholesterol: 40mg
Sodium: 750mg
Total Carbohydrates: 0g
Fiber: 0g
Sugars: 0g
Proteins: 7g
Vitamin A: 0%
Vitamin C: 0%
Calcium: 0%
Iron: 2%
Deee-licious!
 
The deep, dark truth about Spam. Also some nifty trivia. Impress your friends and relatives!

Ingredients:
Chopped pork shoulder meat with ham meat added.
Salt (for binding, flavour, and firmness)
Water (to help in mixing)
Sugar (for flavour)
Sodium Nitrite (for colour and as a preservative)
Yum yum!

Nutrition Information For SPAM (original style):
Calories Per Serving: 170
Calories Per Serving From Fat: 140
Serving Size: 2 oz.
Servings Per Container: 6 (large) or 3.5 (small)
Total Fat: 16g
Saturated Fat: 6g
Cholesterol: 40mg
Sodium: 750mg
Total Carbohydrates: 0g
Fiber: 0g
Sugars: 0g
Proteins: 7g
Vitamin A: 0%
Vitamin C: 0%
Calcium: 0%
Iron: 2%
Deee-licious!

123
 
SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM
 
SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM

SPAM!
 
mmmm...that made no sense...not to mention how long did it take you to do that with the 30 sec in between each post?
 
Back
Top