Website Technology Profiler

{
  "PageContent": "Ask The Oracle Mentors Recently Answered Ask a QuestionAll Questions Recently Answered 2.0 #SELECTION# Architectural Advice: Reporting via Pipelined Functions vs. Views in a 4-Schema SmartDB I am implementing a 4-Schema SmartDB architecture for an Oracle APEX project to strictly enforce the principle of least privilege. My schemas are: DATA_LAYER (Tables), LOGIC_LAYER (Private Logic), API_LAYER (Public Interface), and APEX_UI_LAYER (Parsing Schema). I am currently de... #MISC# #ACTIONS# #SELECTION# Numeric sorting inside strings This query: with T1 as ( select 'A4' from dual union select 'A3' from dual union select 'A100' from dual union select 'A20' from dual ) select * from t1; produces the normal sort: A100 A20 A3 A4 In recent Oracle versions ( 19 and later ) is there a #MISC# #ACTIONS# #SELECTION# String to rows using connect by &lt;u&gt;&lt;/u&gt;table has two rows select id,value from IIO_SYSTEM_PARAMETER; 200 1027/1029/1000 199 1027/1029/1000 when I ran the below query, it is giving 7 records, instead of 3 records query1: SELECT REGEXP_SUBSTR(VALUE, '[^/]+', 1, LEVEL) DEST FROM #MISC# #ACTIONS# #SELECTION# Massive Space Discrepancy (13GB Allocated vs 23MB Data) in List-Hash Partitioned Table I am troubleshooting a severe storage efficiency issue on a batch logging table in our Oracle 19c database on the below table Table DDL: CREATE TABLE APP_BATCH_LOGS ( BATCH_ID VARCHAR2(100 CHAR) NOT NULL, -- Partition Key PROCESS_ID VARCHAR2(100 #MISC# #ACTIONS# #SELECTION# WITH Clause Doesn't Work in MOUNTED Database When querying a mounted database, an ORA-01219 occurs when querying anything besides instance views such as v$database. This is even the result when using a WITH clause that, itself, is an allowed query for a mounted database. For example: SQL&gt; select status from v$instance; STAT... #MISC# #ACTIONS# Upcoming Live Sessions All Upcoming Upcoming <h3>Ask TOM</h3> Live report",
  "Url": "https://asktom.oracle.com",
  "IpAddress": "23.62.254.128",
  "ReverseDns": "a23-62-254-128.deploy.static.akamaitechnologies.com",
  "Asn": null,
  "Http2": false,
  "Http3": false,
  "ResponseTimeMs": 1238,
  "StatusCode": 200,
  "ServerHeaders": [],
  "Ssl": {
    "Issuer": "CN=DigiCert Global G3 TLS ECC SHA384 2020 CA1, O=DigiCert Inc, C=US",
    "Subject": "CN=apexapps.oracle.com, O=Oracle Corporation, L=Austin, S=Texas, C=US",
    "NotBefore": "2025-08-17T17:00:00-07:00",
    "NotAfter": "2026-04-29T16:59:59-07:00",
    "SubjectAltNames": [
      "DNS Name=apexapps.oracle.com",
      "DNS Name=ace.oracle.com",
      "DNS Name=acenomination.oracle.com",
      "DNS Name=asktom.oracle.com",
      "DNS Name=bimetadata.oracle.com",
      "DNS Name=curie.oracle.com",
      "DNS Name=devgym.oracle.com",
      "DNS Name=doctool.health.oracle.com",
      "DNS Name=einstein.oracle.com",
      "DNS Name=gbanomination.oracle.com",
      "DNS Name=gettogether.oracle.com",
      "DNS Name=ilc.oracle.com",
      "DNS Name=labs.oracle.com",
      "DNS Name=livelabs.oracle.com",
      "DNS Name=ocvsestimator.oracle.com",
      "DNS Name=plsqlchallenge.oracle.com",
      "DNS Name=scheduler.oracle.com",
      "DNS Name=studyparticipantinfo.oracle.com",
      "DNS Name=sure.oracle.com",
      "DNS Name=vlcestimator.oracle.com",
      "DNS Name=well-architected.oracle.com",
      "DNS Name=wfm.oracle.com"
    ],
    "Hsts": true,
    "Ciphers": [],
    "Protocol": "Tls13",
    "DaysUntilExpiry": 87
  },
  "Cdns": [
    "Akamai"
  ],
  "HostingHints": [],
  "Cms": [],
  "Frameworks": [],
  "JsLibraries": [],
  "Analytics": [
    "Google Analytics GA4"
  ],
  "AdsAndMarketing": [],
  "PaymentGateways": [],
  "EcommerceHints": [
    "PrestaShop"
  ],
  "SocialSignals": [],
  "MediaProviders": [
    "YouTube"
  ],
  "SeoTags": [
    "content-type: text/html; charset=utf-8"
  ],
  "HtmlLanguage": "en-us",
  "HasRobots": true,
  "HasSitemap": false,
  "SecurityHeaders": [
    "HSTS",
    "X-Content-Type-Options",
    "X-Frame-Options",
    "X-XSS-Protection",
    "Referrer-Policy"
  ],
  "CookiesObserved": [
    "ORA_WWV_APP_1D92C5D1754A4AC=ORA_WWV-HzmX1q3EG5G7UNlUFe5qq6Tu; path=/ords/; samesite=none; secure; HttpOnly",
    "ORA_WWV_RAC_INSTANCE=8; path=/ords/; samesite=none; secure; HttpOnly",
    "bm_mi=B5323BA7053AA8640AE4E4A3A6A87E15~YAAQnlbbFxgDyAicAQAAx/T/Fx7M6BOMUwJRwXmPUOH63bWE/y/ocFxfZOZ2AAVafyjKvQi5MHb1tgDAD9cND/0u7LjtfYn//CEwgnhldnVeIY7zGDY8qXxIUtvK/Tp1/qH7Hj7rHelokyYYuzEUE2pwyOsT6/c79E2DEX+SwFOu3t/lLKPaZZ4Kdbq3dp/lvKXEUQb69uCLIYdqR8JwM711jzD3SWqzF6289Y5tO7RaAle/rbiqNFZvL5JqYb41jgCN9VUSeuZiApJ7JvXSr05Xo/pXytF7dnqyWSG+r5gkvytoThya/vIkQJ1vRmVeHY6qHA==~1; Domain=.oracle.com; Path=/; Expires=Sun, 01 Feb 2026 08:59:36 GMT; Max-Age=7200; Secure",
    "bm_sv=FEB3FC1E637802A9063DAB4E52C4D874~YAAQnlbbFxkDyAicAQAAyPT/Fx4ndJJ46356tcjgUtJUcMNqnhRyEFHU0NJNjAlQ3dxiPQ7/tSKjVK8R/H2kcash8R/G01YukY4uG2iQCeofd8yqTvQUgGINV8kBwkdTu1c/ydPByU+Iwnu0UhS0aECy/bpnLVLjJw6MEwk+McAKKnhH1nd5m3wWXQytQTIuFeaEf3Jw/lUSBtTehGz8Nd0XkZVdpR0/txR3koL0t1CuYtebb898oYFomhmvh6xs~1; Domain=.oracle.com; Path=/; Expires=Sun, 01 Feb 2026 08:59:36 GMT; Max-Age=7200; Secure"
  ],
  "XhrApiHints": [],
  "SitemapCounts": {},
  "ChatWidgets": [],
  "ABTesting": [],
  "PrivacyConsent": [],
  "EmailMarketing": [],
  "WebFonts": [
    "Font Awesome"
  ],
  "DynamicJs": [
    "jQuery (script Resource)",
    "Bootstrap (CSS Classes)",
    "jQuery (CDN Detection)",
    "React (Script Analysis)",
    "jQuery (Script Analysis)"
  ],
  "ResourceHosts": [
    "www.oracle.com",
    "consent.truste.com",
    "asktom.oracle.com",
    "static.oracle.com",
    "www.oracleimg.com"
  ],
  "CssFrameworks": [],
  "BuildTools": [],
  "ServerTech": [],
  "DatabaseHints": [],
  "PageTitle": "Ask TOM",
  "MetaDescription": null,
  "ImageCount": 6,
  "ScriptCount": 24,
  "LinkCount": 11,
  "Errors": [],
  "UiFrameworks": [
    "Ionic (Class Names)",
    "Bootstrap (Class Names)",
    "Vuetify (Class Names)"
  ]
}