I am using the dta utility successfully.
I have problem to tune query without specifying the schema as prefix in
case the tuning session is not with the login that own the schema, the
dta utility fails.
Create a new login: login1, pass1
CREATE USER user1 FOR LOGIN login1 WITH DEFAULT_SCHEMA = user1_schema
select * from table1
Table list file:
1. If the tuning session of the dta is connected with login1, pass1 the
2. If the tuning session of the dta is connected with other login the
If I will specify the owner in the workload file the dta in this case
Is there a way to update the dta with the correct user/schema
dynamically instead of specifying the owner for each object in the
Is there a way to active setuser function in the workload file?
Is there an option in the XML file to set the correct user?