row count procedure

declare

sql_stmt varchar2(254);
row_count number;

cursor get_tab is
select table_name, num_rows
from dba_tables
where owner=upper('&&1');

begin

dbms_output.put_line('Checking Record Counts for schema &&1 ');
dbms_output.put_line('Log file to numrows_&&1.lst ....');
dbms_output.put_line('....');

FOR get_tab_rec IN get_tab LOOP

BEGIN

sql_stmt := 'select count(*) col1 from &&1.'||get_tab_rec.table_name;

EXECUTE IMMEDIATE sql_stmt INTO row_count;

dbms_output.put_line('Table '||rpad(get_tab_rec.table_name,30)
||' '||TO_CHAR(row_count)||' rows (Analyze '||get_tab_rec.num_rows||' rows).');

EXCEPTION WHEN OTHERS THEN
dbms_output.put_line('Error counting rows for table '
||get_tab_rec.table_name);

END;

END LOOP;

END;

oracle data to xml format

http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:4061080732051

process search

[root@merkezora root]# ps -fe|grep LOCAL|wc -l

17

[root@merkezora root]# ps -efw|grep ora_

oracle 21891 1 0 08:14 ? 00:00:00 ora_pmon_orcl

oracle 21893 1 0 08:14 ? 00:00:00 ora_dbw0_orcl

oracle 21895 1 0 08:14 ? 00:00:00 ora_lgwr_orcl

oracle 21897 1 0 08:14 ? 00:00:00 ora_ckpt_orcl

oracle 21899 1 0 08:14 ? 00:00:00 ora_smon_orcl

oracle 21901 1 0 08:14 ? 00:00:00 ora_reco_orcl

oracle 21903 1 0 08:14 ? 00:00:00 ora_cjq0_orcl

oracle 21905 1 0 08:14 ? 00:00:00 ora_qmn0_orcl

oracle 21907 1 0 08:14 ? 00:00:00 ora_s000_orcl

oracle 21909 1 0 08:14 ? 00:00:00 ora_d000_orcl

root 22058 21957 0 08:19 pts/0 00:00:00 grep ora_

[root@merkezora root]#

dbms random value from a table

SELECT * FROM employees

WHERE employee_id IN

(SELECT employee_id FROM

(SELECT employee_id, SYS.DBMS_RANDOM.RANDOM FROM employees ORDER BY 2)

WHERE rownum <= 1 );

Oracle JHeadstart for ADF (10.1.3)

http://www.oracle.com/technology/products/jdev/tips/muench/jhstutorial/index.html

My DBA commands history

http://pages.kivancg.com/DBAcommandshistory.txt

TheFutureofJava

http://pages.kivancg.com/TheFutureofJava.pdf