Biju

www.bijoos.com

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

Using Flashback during repeated load tests

by

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