Registering a Database in Server Control (srvctl)

by

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

by

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