Monthly Archives: maggio 2014

Hide Pl/Sql source code
  • 26
    Mag

Hide Pl/Sql source code

To hide PlSql source code you can use both: dynamic obfuscation the wrap utility You might have to wrap some of yours PlSql objects just to provide the security of your code. Once wrapped, your code can't be displayed from the static data dictionary views [ *_SOURCE ]. You can wrap the following types of PlSql objects Package...

Read More
Execution flow of an sql statements
  • 20
    Mag

Execution flow of an sql statements

  The execution flow can be divided into four stage. Not all Sql Statements will use all the stages: Parse:  at the beginning the statement must be parsed, this mean check the syntax and associate it with the cursor. It also verifies if the privilege are correct and if the objects referenced really exists Bind:      ...

Read More
If tablespace sysaux is rapidly growing
  • 13
    Mag

If tablespace sysaux is rapidly growing

  Sometimes, expecially for new databases, DBAs can face with a rapidly growing SYSAUX tablespace. In most of the cases this is due to AWR snapshot information, so you should adjust SYSAUX space in order to keep it. Typically a size between 500MB and 1GB should be adequate, because AWR snapshot space is reused based on the AWR...

Read More
How to install Oracle Apex Listener 2.0.5 under Tomcat Application Server
  • 5
    Mag

How to install Oracle Apex Listener 2.0.5 under Tomcat Application Server

  This guide refer to Oracle Apex Listener 2.0.5 and installed on debian like server under Tomcat Application Server (Tomcat 7 for this guide).   First you must download the package of APEX Listener from Oracle site and then unzip the package on your server with command (use “sudo” if you not have right permission for do this...

Read More