Dev Corner

The following SQL shows the SQL text for the SQL being executed by a session. Read the rest of this entry »

The following SQL can be used by Oracle Database Administrator (DBA) to retrieve information about the currently active sessions with longest execution. The SQL statement is designed to run with SQL*Plus. Read the rest of this entry »

You are a new database administrator. You are assigned a task to find all obfuscated PL/SQL procedures in an Oracle Database. Here is a simple recipe that solves the problem. After running the SELECT SQL statement you will get a list of obfuscated objects. Read the rest of this entry »

With this recipe you can count the number of rows for ALL tables in current Oracle Database schema. Read the rest of this entry »

Here is a simple recipe. The following SQL finds the top ten SQL statements with the greatest elapsed time. Read the rest of this entry »

Oracle database control administrators can create other database control administrators, configure e-mail and other notification methods, control alert thresholds for database metrics, select database policies to apply, define maintenance periods (blackouts). Read the rest of this entry »

Problem: You want to create a user that can access the Oracle Database Administrative console. For example, it might be required that the user login to the Oracle Enterprise Manage and monitor the database. Read the rest of this entry »