OracleDB12c New Feature: Capture Privilege Usage

One of the top features of the Oracle Database 12c that attracted me is capturing the privileges used (and unused). This feature is introduced to strengthen the security of the database to enforce the principle of least privilege. Many application users today have excessive privileges assigned, and believe me, have seen many applications connect to … Read more

Oracle Database 12c is now GA… (Finally!!)

Oracle Database 12c is released today [June 25]… there is a wealth of new features in 12c database, most major ones were discussed by Oracle speakers in conferences since OOW 2012… The major feature is the introduction of container databases and pluggable databases. Database 12c software is available for download at OTN. Documentation is also … Read more

Registering a Database in Server Control (srvctl)

Even if you are managing a non-RAC database, in 11g, it is recommended to use “srvctl” commands to start and stop the database. But, if the database is not created using DBCA or not upgraded using DBUA, the database will not be registered in the “Oracle Restart” configuration automatically. Oracle Restart monitors the services registered … Read more

Active or Recently Used Printers in Oracle EBS

Recently had a request from one of the admins for list of printers used in the EBS application and how many jobs are directed to a printer. The following SQL provided what the admin needed, thought a good one to share… select distinct fcr.printer, fu.user_name,         fu.description, count(*) jobs from apps.fnd_concurrent_requests fcr, apps.fnd_user … Read more

Using Flashback during repeated load tests

We are in the middle of migrating several databases to a new data center. One of the requirement is to do rigorous load and stress tests on the new servers to make sure they can handle the load and the configuration is correct. For this purpose, there are several load/stress test scripts are written and … Read more

SYSAUX Tablespace Growth – Review and Fix

Received an alert from one of the databases that SYSAUX tablespace is nearing its allocated 24GB space. 24GB is too much for SYSAUX, especially on a development database… so need to make sure the contents are reviewed before adding more space… Oracle10g+ versions have a view V$SYSAUX_OCCUPANTS, showing what components are in SYSAUX tablespace and … Read more