debugging pl/sql procedure

This requires "DEBUG CONNECT SESSION" system privilege. (Debugging using PL/SQL developer).

cannot run set autotrace on statistics;

The sqlplus command set autotrace on statistics; gave SQL> set autotrace on statistics SP2-0618: Cannot find the Session Identifier. Check PLUSTRACE role is enabled SP2-0611: Error enabling STATISTICS report SQL> connect / as sysdba Connected. SQL> grant plustrace to aarav; grant plustrace to aarav * ERROR at line 1: ORA-01919: role 'PLUSTRACE' does not exist executed $ORACLE_HOME/sqlplus/admin/plustrce.sql as sys user then "grant PLUSTRACE to aarav" then autotrace worked fine.

Error in adding datafile to users tablespace

alter tablespace users add datafile '/opt/oracle/app/oradata/aarav/users02.dbf' size 16G autoextend on next 1G maxsize 32G

Error report: SQL Error: ORA-03206: maximum file size of (4194304) blocks in AUTOEXTEND clause is out of range 03206. 00000 - "maximum file size of (%s) blocks in AUTOEXTEND clause is out of range" *Cause: The maximum file size for an autoextendable file has exceeded the maximum number of blocks allowed. *Action: Reduce the size and retry.


I users01.dbf was at 32G so I could not create any more data segments in it so had to add a new datafile to the tablespace above. Got the error so I modified the statement to alter tablespace users add datafile '/opt/oracle/app/oradata/aarav/users02.dbf' size 16G autoextend on next 1G;

Things I need to do/learn well. 1. Install subversion with individual logins and webpage to view the repository. 2. Perl one liners 3. Awk one liners 4. sed one liners 5. Java Certification - core java and more JVM internals Effective Java book Patterns in Java Datastructures in Java 6. Oracle 11G OCP Tuning RMAN 7. PHP 8. Essential computer mathematics 9. Perl 10. Python 11. MySQL 12. Postgres 13. LPIC - Linux