How to Identify User and SQLs in an Oracle database?
This is a very common scenario for a DBA to be in a situation where a DBA needs to find out one of the following: Which user is running which SQL? A particular SQL is being run by which user? A particular user is running which SQL? As it is evident from these questions – […]
Continue readingAutomated SQL Tuning in Oracle 11g
Oracle Database 11g made it easier for the less experienced to have a shot at SQL tuning, which was earlier considered to be a bastion for veteran SQL tuners. A typical Oracle SQL tuning process had the following steps: Identification of high-resource SQL statements and bottlenecks Generating and interpreting execution plans Extracting data from the […]
Continue reading
1
PeopleTools 8.53 – PeopleSoft Homes
PeopleSoft Home refers to a file system location in which artifacts associated with a PeopleTools runtime environment are located. The various PeopleSoft Homes are intended to serve specific purposes. Until PeopleTools 8.50, all file system content related to a PeopleSoft environment was consolidated within the same directory tree, which was referred to as PeopleSoft Home […]
Continue reading
1
What is Oracle VirtualBox?
Oracle has been on such a buying and renaming spree that it is difficult to identify the products, especially for those who had worked on one of the products before Oracle bought it. We’ll try to provide you with brief history of Oracle products, so that it help you sink in all the information. Also, […]
Continue reading
1
PeopleTools 8.53 – Secure Enterprise Search, SES and Search Framework
Prior to PeopleTools 8.53, search functionality worked by building search engine indexes using custom PeopleCode and Application Engine programs. Each PeopleSoft application used a unique method for creating and maintaining search artifacts like collections and indexes–all of which required search engine-specific calls, commands, syntax, and so on. The PeopleSoft Search Framework consists of PeopleSoft components (pages […]
Continue reading