[Home] [Help]
View: AHM_HST_DB_V
Product: | AHM - Hosting Manager(Obsolete) |
Description: | View on which databases hold which SECURITY_GROUP_IDs |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT B.DB_ID
, A.DB_NAME
, A.DB_TYPE
, A.HOSTNAME
, A.MAX_SLOTS
, A.MID_TIER_URL
, A.PORT
, A.SID
, A.HOSTED_DATABASE
, A.INSTANCE_NAME
, B.SLOT_ID
, B.SECURITY_GROUP_ID
, B.SLOT_TYPE_ID
, B.SLOT_STATUS
FROM AHM_SLOT_ALLOCATIONS B
, AHM_HOST_DATABASES_VL A
WHERE A.DB_ID=B.DB_ID
Columns
Name |
DB_ID |
DB_NAME |
DB_TYPE |
HOSTNAME |
MAX_SLOTS |
MID_TIER_URL |
PORT |
SID |
HOSTED_DATABASE |
INSTANCE_NAME |
SLOT_ID |
SECURITY_GROUP_ID |
SLOT_TYPE_ID |
SLOT_STATUS |