tips

sqlplus cbs/cbs@10.10.1.13:1521/cbs exec DBMS_STATS.GATHER_SCHEMA_STATS('CBS',DBMS_STATS.AUTO_SAMPLE_SIZE,degree => 15); select table_name, num_rows, last_analyzed from  dba_tables where owner ='CBS' and table_name ='ACCOUNT';

startup mount pfile='pfile-asm-single.txt'  

ALTER SESSION SET NLS_DATE_FORMAT="YYYY-MM-DD HH24:MI:SS";

/*文件系统*/ #mount -o rw,bg,hard,intr,proto=tcp,vers=3,rsize=65536,wsize=65536,timeo=600 192.168.99.143:/dbbackup /home/conv/dbbackup/

内部帐明细查询