Cammandus
New Member
i know we dont play anything other than WoW, especially when we are not 70....
New Spamming Thread....
- Thread starter Icthus
- Start date
noname
New Member
rrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrr boom crash!
*WALL*
New Member
/bump
Azzie
New Member
noname
New Member
dude
yes.
noname
New Member
noname
New Member
if 1+1=2, then 2+2=5
its so simple
its so simple
noname
New Member
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
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
noname
New Member
Instead of talking to your plants, if you yelled at them would they still grow, but only to be troubled and insecure?
noname
New Member
The chicken
is the egg's way
of producing more eggs.
is the egg's way
of producing more eggs.
noname
New Member
How important does a person have to be before they are considered
assassinated instead of just murdered?
assassinated instead of just murdered?
noname
New Member
If corn oil is made from corn, and vegetable oil is made from vegetables,
what is baby oil made from?
what is baby oil made from?
noname
New Member
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!
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!
noname
New Member
123
noname
New Member
hahahahahaha spam raid!!!
noname
New Member
SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM SPAM
noname
New Member
SPAM!
noname
New Member
noname
New Member
*WALL*
New Member
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?