A client has a healthy system but often sees delays in some queries because of workload concurrency limits. These limits have been carefully chosen, so the client needs a solution that will not modify them.What should the Administrator use to assist this client?
Given a user creation request on a 10-AMP system:CREATE USER hr_user AS PERM = 100e9 SKEW = 10 PERCENT,SPOOL = 100e9 SKEW = 20 PERCENT;How does the SKEW factor affect the user's Perm space, assuming the total space consumed is under the specified perm space limit?
An Administrator has been tasked with analyzing previous growth and usage patterns by utilities such as Multiload and FastLoad. The aim is to project the likely resource requirements of the existing loads in the next three to six months.In the last month, the Administrator team have started using AccountString expansion on all user accounts and have started maintenance jobs to housekeep system data older than seven years. Two years ago, the following command was issued on the system:BEGIN QUERY LOGGING WITH ALL ON ALL;No other logging commands have been issued.Which view contains the utility usage data for the prior months?
A middle-tier application server logs on to the database as TrustedUser and submits requests on behalf of application end users. The server is shared by Finance and Human Resources groups and uses ProxyUser query band to identify end users to the database. Each group needs access to its own sensitive data, so the Administrator has created two separate roles with the appropriate permissions.What is the best way to control access to each group's sensitive data?
An Administrator needs to provide end users access to data in a Native Object Store using shared credentials.How can this be accomplished?
What is a use case for Data Mover?
