A year or so ago, we figured out how to change the option for oracle visual explain to include the schema where the explain plan could be generated. I have since added another oracle db with different accounts and space. Is there a way to tie this to the specific server instance/user account? otherwise, I'll need to change this option from one db/user to another db/user. I'd love to be able to say my users schema or multiple schemas. ERASE_RO_APP would be my additional schema.
[cid:2f4739f9-60df-421a-a703-3fc2dc1edb84]
License Key: F3A863DEA57ED00989EB8C9C5F51E9C8080C8B44523D558D****************
Product: Aqua Data Studio
Version: 19.0.2
Build #: 55969
Build Date: 2018-Aug-14 12:32:14 PM
Operating Environment: Windows 10 (10.0, amd64) / Cp1252 / en / US / Oracle Corporation 1.8.0_102-b14
Memory: Max=477,626,368; Total=418,906,112; Free=36,080,376; CPUs=8
In-Window Graphics Capabilities
Graphics Vendor: Intel
OpenGL Renderer: Intel(R) UHD Graphics 620
OpenGL Version: 4.5.0 - Build 22.20.16.4799
Double-Buffering: Enabled
Anti-Aliasing: Enabled
Anti-Aliasing Sample Count: 16
Hardware Acceleration: Enabled
Color Bits: Red: 8 Green: 8 Blue: 8 Alpha: 8
Depth Bits: 16
Accumulation Buffer Bits: Red: 0 Green: 0 Blue: 0
Initialization Time: 1590 ms
Offscreen Graphics Capabilities
Graphics Vendor: Brian Paul
OpenGL Renderer: Mesa OffScreen
OpenGL Version: 2.1 Mesa 7.8.2
Double-Buffering: Disabled
Anti-Aliasing: Disabled
Anti-Aliasing Sample Count: 0
Hardware Acceleration: Disabled
Color Bits: Red: 8 Green: 8 Blue: 8 Alpha: 8
Depth Bits: 16
Accumulation Buffer Bits: Red: 16 Green: 16 Blue: 16
Initialization Time: 51 ms
Hardware PBuffer Available: No
Using PBuffer: No
Using Ram Buffer: Yes
Offscreen Rendering: Enabled
Offscreen Buffer Size: 800x600
2 differnet users 2 different domains. The plan table will run from the users namespace.
app1 db server
user1
user1 schema (plan table allowed)
app1 schema (plan table not allowed)
app2 db server
user2
user2 schema (plan table allowed)
app2 schema (plan table not allowed)
i have the configuration setup, to use user1 schema. Unfortunately, this appears to be global as it is in the file/options section instead of specific to the server/connection (such as in server properties). If I have this setup to run a plan for app1 schema (using user 1 schema for the plan table), then I cannot run a plan for app2 without changing the options to reflect user2 schema. I'd really like to be able to run a plan from either db without having to make the global config change. It seems this setting would fit best under advanced options in server properties so that it is specific to that app/user/schema as opposed to for all oracle dbs.
Issue #15784 |
New |
Completion |
No due date |
No fixed build |
No time estimate |
2 differnet users 2 different domains. The plan table will run from the users namespace.
app1 db server
user1
user1 schema (plan table allowed)
app1 schema (plan table not allowed)
app2 db server
user2
user2 schema (plan table allowed)
app2 schema (plan table not allowed)
i have the configuration setup, to use user1 schema. Unfortunately, this appears to be global as it is in the file/options section instead of specific to the server/connection (such as in server properties). If I have this setup to run a plan for app1 schema (using user 1 schema for the plan table), then I cannot run a plan for app2 without changing the options to reflect user2 schema. I'd really like to be able to run a plan from either db without having to make the global config change. It seems this setting would fit best under advanced options in server properties so that it is specific to that app/user/schema as opposed to for all oracle dbs.