安装Oracle APEX后如何确定虚拟目录？可查询哪些关联数据表？

Absolutely! You can easily confirm the virtual directory (/i/) you set when installing APEX, and there are dedicated Oracle views/tables to pull this information. Here's how:

1. Directly Query the APEX Instance Parameter #

The most straightforward way is to check the IMAGE_PREFIX parameter in the APEX_INSTANCE_ADMIN_PARAMETERS view. This parameter stores exactly the virtual path you provided during installation (in your case, /i/).

Run this SQL query with a user that has APEX administrator privileges or DBA access:

SELECT parameter_value
FROM apex_instance_admin_parameters
WHERE parameter_name = 'IMAGE_PREFIX';

This will return the exact virtual directory string you specified.

2. Check the Associated Physical Directory #

If you also want to see the physical filesystem path that /i/ maps to, you can query the database directory object linked to APEX's images. By default, this directory is named APEX_IMAGES, and you can retrieve its path with:

SELECT directory_name, directory_path
FROM dba_directories
WHERE directory_name = 'APEX_IMAGES';

This shows where the actual APEX image files are stored on the server, which is tied to the /i/ virtual path you set.

3. (Optional) Verify EPG Mapping (If Using Embedded PL/SQL Gateway) #

If you're using Oracle's Embedded PL/SQL Gateway (EPG) to serve APEX, you can confirm the virtual path to DAD (Database Access Descriptor) mapping with:

SELECT dad_name, url_pattern
FROM dba_epg_dad_mappings
WHERE url_pattern LIKE '/i/%';

This will show how the /i/ path is routed to the APEX DAD in EPG.

All these views are part of APEX's built-in metadata and Oracle's core data dictionary, so they're reliable sources for this information.

内容的提问来源于stack exchange，提问作者Rithesh Bhat