sz.ksh 255 B

123456789101112
  1. #!/bin/ksh
  2. count=`sqlplus -s expman/expdp@$ORACLE_SID <<-END
  3. set pagesize 0 feedback off verify off heading off echo off;
  4. col bytes format 999,999,999,999
  5. select sum(bytes) bytes from sys.dba_extent;
  6. exit;
  7. END
  8. `
  9. echo $count