I created an sql file running a series of analyze table and index rebuild commands for group of tables. When I run the script in Toad, it is OK. However, via sqlplus -s, it hangs at the middle of the operation.
An example run:
$ORACLE_HOME/bin/sqlplus -s xxx/yyy@zzz @/opt/app/table_statistics.sql
The system is Red-Hat Enterprise Linux with 64 GB of RAM, 4 Processors. How can I solve this problem?