Technological recipes that I've held to prepare some solutions DBA environment. (by Felipe Donoso Bastias)

30 Oct 2007

Script que entrega cantidad de Filas en Oracle

Este script es útil a la hora de calcular las estadisticas para saber a que tablas es conveniente aplicar esto. Adjuntto script:

spool cantidad_de_filas.txt

v_ct number := 0 ;
v_sqlcode number := 0 ;
v_stmt varchar2(90) ;
cursor c_tbl is
select owner, table_name
from sys.dba_tables
where owner = 'SAMA'
and rownum < 11
r_tbl c_tbl%rowtype;
open c_tbl;
fetch c_tbl into r_tbl;
exit when c_tbl%notfound;
v_stmt := 'select count(*) from '||r_tbl.owner||'.'||r_tbl.table_name;
execute immediate v_stmt into v_ct;
v_sqlcode := SQLCODE;
if v_sqlcode = 0
then dbms_output.put_line('Table '||r_tbl.owner||'.'||
' count is '||to_char(v_ct,'999999999990')
else dbms_output.put_line('Bad return code'||v_sqlcode||
' on select of '||r_tbl.owner||
end if;
end loop;
close c_tbl;
spool off


xumeiqing said...

coach purses on sale
hermes outlet
chaussure louboutin
michael kors outlet online
adidas nmd black
reebok shoes
louboutin outlet
michael kors outlet clearance
rolex submariner
coach factory outlet online
lululemon athletica
asics running shoes
toms shoes
nike free runs
true religion outlet
armani outlet
vans store
canada goose jackets
coach factory outlet online
hermes belt
ray ban outlet
gucci borse
ray-ban sunglasses outlet
prada sunglasses wholesale
nhl jerseys wholesale
polo ralph lauren outlet
michael kors uk
nike air max 95
adidas shoes
polo ralph lauren outlet
coach factory outlet
burberry outlet stores
polo ralph lauren
kate spade outlet
coach outlet online
vans outlet store
oakley sunglasses
cheap ray bans
under armour outlet store

Abel Ahar said...

Here we present to introduce to all visitors in this great blog. and thank you for allowing me .

cara menggugurkan kandungan
obat aborsi
tanda tanda kehamilan

Felipe Rodrigo Donoso Bastias said...

Thanks Abel : )

gondes ribut said...

This is a very good article material and it is very useful for us all. thank you . obat penggugur kandungan

sendul said...

By reading this article I get a lot of lessons and this is very useful . cara menggugurkan hamil

anggita nirbaya said...

By taking the time to read a lot of information like this to add my insight . cara menggugurkan kandungan dengan cepat

Misty Moon said...

Really Awesome Blog Thanks for Sharing...
raster to vector
clipping path service
background removal
ghost mannequin

Unknown said...

By reading the article material very very well and this is very useful.
cara menggugurkan kandungan 100 berhasil
penyebab sering keguguran
cara mengatasi telat haid
tanda tanda kehamilan 1 bulan
kalkulator masa subur akurat dan berhasil
masa subur wanita sebelum haid

Copyright © DBA TIPS | Powered by Blogger
Design by SimpleWpThemes | Blogger Theme by | Free Blogger Templates