Website Technology Profiler

{
  "PageContent": "<h3>Data Flux | Maker Electronics, Data Science, Visualizations, and Information Technology Management</h3>What Query Plan Stability?Query Plan Stability ensures predictable and appreciable database performance no matter how much data is being stored in the buffer cache or on disk.   It ensures that all queries are performing according to business requirements and processes are running in a timely manner during the all business hours.The information presented in this document applies to object relational databases with a cost-base optimizer. The principal audience for this documentation are database administrators, database programmers and customer support analyst.Whenever confronted with a poorly performing application.  The following typically occurs during troubleshootingAsk stakeholder when and at what frequency statistical collection is performed.  If stakeholder has not computed statistics recently or has never computed statistics, they must compute statistics before proceeding.Ask customers if there has been a recent change in data.  If this has occurred, get as much detail on the changesWhen and where the changes madeThe quantity of changes.During execution of processes  plan instability can occur due to the following factors:Lack of adherence to cardinality and primary and foreign key relationships.Lack of proper statistics.Misuse of predicates in query and plan binding.Flush of “good” plans from the shared pool (plan cache).One of the best tools for ensuring plan stability in Oracle is the cost-based optimizer explain plan, which helps determine how costly it is to execute a plan based on its cost in CPU.Query identifies in Oracle (SQL_ID) are indexes with alphanumeric characters (e.g. 3mx8whn1c5jbb).  When reviewing query execution performance, it’s always best to create a query plan:SQL&gt;EXPLAIN PLAN FOR \r\nselect XML_LOADID, XML_RECORDTEXT FROM OLAPSYS.XML_LOAD_RECORDS WHERE XML_RECORDID=2;\r\n\r\nSQL&gt;  select * from TABLE(DBMS_XPLAN.DISPLAY);Explain plans show how the query is performing in the cost-based optimizer once parsed.  It provides valuable information of where the highest cost are in your query.  Query tuning is essential for maintaining performance in a cost-based optimizer.If plan instability occurs in an Oracle database, there are several options in addition to the list in the preceding sections to correct the issue.    Query performs very poorly or performs full table scans on very high cardinal and big table objects. Make sure that statistical collection script has been executed.  Make certain that statistics are up to date.   See appendix for script to check statistics.If Statistics are up to date.  Attempt to generate a plan analysis (SQL profile) of the current plan.  Note:  Oracle Diagnostic Pack and Automated Database Diagnostic Manager (ADDM) needs to be installed.  The profile can be generated via the OEM GUI or using scripts.The following steps allow an administrator to create SQL profile tuning sets as well as export out those profiles from a source database and import it into a new database.  This allows administrator to create and test better plans in test systems and then load them safely into production systems and enable/disable them when needed.SET HEADING ON\r\nSET PAGESIZE 20000\r\nSET LINESIZE 2000\r\nCOL text FOR A50\r\nCOL ctext FOR A50\r\n\r\n\r\nselect vs.last_load_time, ao.OWNER, parsing_schema_name, first_load_time , ao.OBJECT_NAME, vs.program_line#, executions exe, vs.sqltype, vs.sql_id, vs.rows_processed rows_processed, concurrency_wait_time, elapsed_time/1000000 elapsed_secs, elapsed_time/1000000/(case when executions = 0 then 1 else executions end) elap_per_exec_secs, vs.sql_fulltext text, vs.sql_text ctext\r\nfrom v$sql vs, all_objects ao\r\nwhere vs.PROGRAM_ID = ao.OBJECT_ID and parsing_schema_name not in ('SYS','SYSTEM') and parsing_schema_name in ('&lt;SCHEMA_OWNER&gt;')\r\nand owner not in ('SYS','SYSTEM','DBSNMP','SYSMAN','MDSYS')\r\norder by vs.last_load_time desc , vs.parsing_schema_name, vs.first_load_time desc , program_id, vs.program_line#;\r\nExecute v$sqlarea query to find plan and hash values that identify that query.\r\nselect address, hash_value, plan_hash_value from v$sqlarea where sql_id in ('2zd224kurqsr9');\r\n\r\nADDRESS          HASH_VALUE PLAN_HASH_VALUE\r\n---------------- ---------- ---------------\r\n00000003ACC32290 3419553494      1111780545\r\nPrior to doing a purge of a PLAN_HASH from the shared_pool, it’s important to collect information about the bad plan.   You can do this by executing an DBMS_XPLAN outline on the Plans.  To preserve the plan prior to flushing if from the shared_pool, read section on Loading Plan from Cache to Baseline and return here to continue.SQL&gt; EXPLAIN PLAN FOR select XML_LOADID, XML_RECORDTEXT FROM OLAPSYS.XML_LOAD_RECORDS WHERE XML_RECORDID=2;\r\n\r\nExplained.\r\n\r\nSQL&gt; select * from TABLE(DBMS_XPLAN.DISPLAY);If plan exists in memory, but has a bad hash plan number, create tuning task and SQL set for the query.Execute tuning task command to see if ADDM will generate a better plan (Do not purge from memory if using this step).var stmt_task VARCHAR2(64);\r\n\r\nSET SERVEROUTPUT ON LINESIZE 200 PAGESIZE 20000 LONG 9999\r\n\r\nEXEC :stmt_task := DBMS_SQLTUNE.CREATE_TUNING_TASK(sql_id =&gt; '2zd224kurqsr9', task_name =&gt; 'sga_tuning_task_1');\r\n\t\r\nSELECT DBMS_SQLTUNE.REPORT_TUNING_TASK('sga_tuning_task_1', 'TEXT', 'TYPICAL', 'FINDINGS') FROM DUAL;\r\n If no results are returned, then ADDM will not be able to tune.SQL&gt; SELECT DBMS_SQLTUNE.REPORT_TUNING_TASK('sga_tuning_task_1', 'TEXT', 'TYPICAL', 'FINDINGS') FROM DUAL;\r\nERROR:\r\nORA-13631: The most recent execution of task sga_tuning_task_1 contains no results.\r\nORA-06512: at \"SYS.PRVT_ADVISOR\", line 5739\r\nORA-06512: at \"SYS.DBMS_SQLTUNE\", line 1045\r\nORA-06512: at line 1\r\nIf no results are returned skip following query and go to step 6.  Always make sure not to purge SGA if you use these steps.DECLARE\r\n    \r\n    sqlprofile_name VARCHAR2(30);\r\n\r\nBEGIN\r\n\t \r\n    sqlprofile_name := DBMS_SQLTUNE.ACCEPT_SQL_PROFILE ( \r\n    task_name    =&gt; 'sga_tuning_task_1'\r\n,   name         =&gt; 'sql_profile_1'\r\n,   force_match  =&gt; true \r\n);\r\nEND;\r\n/\r\nCreate a SQL Tuning Set from AWR.Find the begin and end span for the SQL_ID and plan hash that you need from AWR (This is if the plan has been purged from the pool and exists in AWR repository.SET LINESIZE 2000 PAGESIZE 20000\r\nSET LONG 99999\r\n     select\r\n        SNAP_ID,\r\n        TO_CHAR(begin_interval_time,'DD-MON-YYYY HH24') begin_interval_time,\r\n        TO_CHAR(end_interval_time,'DD-MON-YYYY HH24') end_interval_time,\r\n        SQL_ID,\r\n        round((round((avg(ELAPSED_TIME_DELTA)/1000000),2)/(case when avg(EXECUTIONS_DELTA)=0 then 1 else avg(EXECUTIONS_DELTA) end)),2) as ELAPSED_TIME_SECS,\r\n        round((round((avg(CPU_TIME_DELTA)/1000000),2)/(case when avg(EXECUTIONS_DELTA)=0 then 1 else avg(EXECUTIONS_DELTA) end)),2) as CPU_TIME_SECS,\r\n        round((avg(BUFFER_GETS_DELTA)/(case when avg(EXECUTIONS_DELTA)=0 then 1 else avg(EXECUTIONS_DELTA) end)),2) as GETS_PER_EXEC\r\n     from\r\n        dba_hist_snapshot natural join dba_hist_sqlstat natural join dba_hist_sqltext\r\n     where\r\n      (elapsed_time_delta &gt; 0 or elapsed_time_delta is not null)\r\n      and SQL_ID = 'bbuc9hr5x4gqq'\r\n     group by\r\n        SNAP_ID,\r\n        TO_CHAR(begin_interval_time,'DD-MON-YYYY HH24'),\r\n        TO_CHAR(end_interval_time,'DD-MON-YYYY HH24'),\r\n        SQL_ID\r\n     order by\r\n        snap_id asc\r\n/\r\nCreate a SQL set.Begin \r\n  DBMS_SQLTUNE.CREATE_SQLSET (sqlset_name =&gt; '2zd224kurqsr9_TUNING_SET_1');\r\nEND;\r\n/\r\n Load SQL Tuning Set.DECLARE\r\n   Cur sys_refcursor;\r\n BEGIN\r\n    OPEN cur FOR\r\n     SELECT VALUE(P) FROM TABLE(dbms_sqltune.select_workload_repository(begin_snap=&gt;13645, end_snap=&gt;13649, Basic_filter=&gt;'sql_id=''2zd224kurqsr9''', attribute_list =&gt; 'ALL' )\r\n) p;\r\nDBMS_SQLTUNE.LOAD_SQLSET(sqlset_name=&gt; '2zd224kurqsr9_TUNING_SET_1', populate_cursor=&gt; cur);\r\nCLOSE cur;\r\nEnd;\r\n/\r\n Verify tuning set is correct.SELECT * FROM TABLE(DBMS_SQLTUNE.SELECT_SQLSET(sqlset_name =&gt; '2zd224kurqsr9_TUNING_SET_1')); create the sql set staging table (Cannot be created in the SYS or SYSTEM schema).execute DBMS_SQLTUNE.CREATE_STGTAB_SQLSET(table_name =&gt;'TUNING_SET_1_STGTAB');Pack the tuning set into the staging table.execute DBMS_SQLTUNE.PACK_STGTAB_SQLSET(sqlset_name =&gt; 'bbuc9hr5x4gqq_TUNING_SET_1',staging_table_name =&gt; 'TUNING_SET_1_STGTAB', staging_schema_owner=&gt;'&lt;SCHEMA_OWNER_SOURCE&gt;');Check the count of the table to make sure it’s been populated.SQL&gt; select count(*) from &lt;SCHEMA_OWNER_SOURCE&gt;.TUNING_SET_1_STGTAB;\r\n\r\n  COUNT(*)\r\n----------\r\n         3\r\nExport out the staging table.[oracle]$ expdp system/******* DUMPFILE=TUNIING_SET_1.DMP DIRECTORY=BACKUPS TABLES='&lt;SCHEMA_OWNER_SOURCE&gt;.TUNING_SET_1_STGTAB'\r\n\r\nExport: Release 11.2.0.4.0 - Production on Fri Mar 9 04:10:34 2018\r\n\r\nCopyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.\r\n\r\nConnected to: Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production\r\nWith the Partitioning, OLAP, Advanced Analytics and Real Application Testing options\r\nStarting \"SYSTEM\".\"SYS_EXPORT_TABLE_01\":  system/******** DUMPFILE=TUNIING_SET_1.DMP DIRECTORY=BACKUPS TABLES=&lt;SCHEMA_OWNER_SOURCE&gt;.TUNING_SET_1_STGTAB\r\nEstimate in progress using BLOCKS method...\r\nProcessing object type TABLE_EXPORT/TABLE/TABLE_DATA\r\nTotal estimation using BLOCKS method: 9.562 MB\r\nProcessing object type TABLE_EXPORT/TABLE/TABLE\r\nProcessing object type TABLE_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS\r\nProcessing object type TABLE_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS\r\nProcessing object type TABLE_EXPORT/TABLE/STATISTICS/MARKER\r\n. . exported \"&lt;SCHEMA_OWNER_SOURCE&gt;\".\"TUNING_SET_1_STGTAB\"             54.01 KB       3 rows\r\nMaster table \"SYSTEM\".\"SYS_EXPORT_TABLE_01\" successfully loaded/unloaded\r\n******************************************************************************\r\nDump file set for SYSTEM.SYS_EXPORT_TABLE_01 is:\r\n  /data/backups/TUNIING_SET_1.DMP\r\nJob \"SYSTEM\".\"SYS_EXPORT_TABLE_01\" successfully completed at Fri Mar 9 04:11:10 2018 elapsed 0 00:00:32\r\n\r\n\r\n******** impdp staging table into target database  ******\r\n\r\nConnected to: Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production\r\nMaster table \"SYSTEM\".\"SYS_IMPORT_FULL_01\" successfully loaded/unloaded\r\nStarting \"SYSTEM\".\"SYS_IMPORT_FULL_01\":  system/******** DUMPFILE=TUNIING_SET_1.DMP REMAP_SCHEMA=&lt;schema_owner_source&gt;:&lt;schema_owner&gt; DIRECTORY=BACKUPS\r\nProcessing object type TABLE_EXPORT/TABLE/TABLE\r\nProcessing object type TABLE_EXPORT/TABLE/TABLE_DATA\r\n. . imported \"&lt;SCHEMA_OWNER&gt;\".\"TUNING_SET_1_STGTAB\"                54.01 KB       3 rows\r\nProcessing object type TABLE_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS\r\nProcessing object type TABLE_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS\r\nProcessing object type TABLE_EXPORT/TABLE/STATISTICS/MARKER\r\nJob \"SYSTEM\".\"SYS_IMPORT_FULL_01\" successfully completed at Fri Mar 9 04:29:52 2018 elapsed 0 00:00:41\r\nPurge the plan from the shared pool on source database.exec sys.dbms_shared_pool.purge('00000003ACC32290,3419553494','C');\r\n\r\n*** OR ***\r\n\r\nset pagesize 20000\r\nselect 'exec sys.dbms_shared_pool.purge(''' || address || ',' ||  hash_value   || ''',''C'');' from v$sqlarea where sql_text like '%TASKTEMPLATEPARAMETERVALUE X  where (1=1)%'\r\n/\r\n\r\n'EXECSYS.DBMS_SHARED_POOL.PURGE('''||ADDRESS||','||HASH_VALUE||''',''C'');'\r\n--------------------------------------------------------------------------------\r\nexec sys.dbms_shared_pool.purge('00000003ACC32290,3419553494','C');\r\nexec sys.dbms_shared_pool.purge('0000000127D41C68,3957004154','C');\r\nexec sys.dbms_shared_pool.purge('00000001A851BB70,525044174','C');\r\nexec sys.dbms_shared_pool.purge('000000016C757A98,4128744307','C');\r\nexec sys.dbms_shared_pool.purge('000000025115E2A8,4132567071','C');\r\nInstalling new plan on target database.  Unpack the SQL set in the target database.\r\nNAME\r\n--------------------------------------------------------------------------------\r\nCREATED             STATEMENT_COUNT\r\n------------------- ---------------\r\nbbuc9hr5x4gqq_TUNING_SET_1\r\n2018-03-09 04:33:59               \r\nLoad plan into SQL Plan Management (SPM).set serveroutput on\r\ndeclare\r\nmy_integer pls_integer;\r\nbegin\r\nmy_integer := dbms_spm.load_plans_from_sqlset (\r\nsqlset_name =&gt; '2zd224kurqsr9_TUNING_SET_1',\r\nsqlset_owner =&gt; 'SYS',\r\nfixed =&gt; 'YES',\r\nenabled =&gt; 'YES'\r\n);\r\nDBMS_OUTPUT.PUT_line(my_integer);\r\nend;\r\n/\r\nGather stats on objects used by tuning set.begin\r\ndbms_stats.gather_table_stats( \r\nownname=&gt; '&lt;schema_owner&gt;', \r\ntabname=&gt; 'TASKTEMPLATEPARAMETERVALUE', \r\nestimate_percent=&gt; null, \r\ncascade=&gt; TRUE, \r\ndegree=&gt; null, \r\nno_invalidate=&gt; DBMS_STATS.AUTO_INVALIDATE, \r\ngranularity=&gt; 'AUTO', \r\nmethod_opt=&gt; 'FOR ALL COLUMNS SIZE AUTO');\r\nend;\r\nLoad known STS for baseline.DECLARE\r\nmy_plans pls_integer;\r\nBEGIN\r\n  my_plans := DBMS_SPM.LOAD_PLANS_FROM_SQLSET(\r\n     sqlset_name =&gt; '2zd224kurqsr9_TUNING_SET_1',\r\n     basic_filter =&gt; 'plan_hash_value = '1111780545');\r\nEND;\r\n/\r\nList out baseline.SELECT * FROM dba_sql_plan_baselines;Please make sure that the plan we would like optimizer to use is fixed enabled.DECLARE\r\nMy_plan pls_integer;\r\nBEGIN\r\n\tmy_plans := DBMS_SPM.ALTER_SQL_PLAN_BASELINE (\r\n sql_handle =&gt;&lt;sql_handle&gt;, plan_name =&gt; &lt;plan_name&gt;, attribute_name =&gt; &lt;attribute_name&gt;, ‘ENABLED’, attribute_value =&gt;’YES’);\r\nEND;\r\n/\r\nFor the plan that was manually loaded, check to make sure it has been accepted.select sql_handle, plan_name, enabled, accepted,fixed,origin from dba_sql_plan_baselines where signature=&lt;signature&gt;;Load old plan(s) from cache into baseline to preserve it.Query the pool.Select sql_id, exact_matching_signature, force_matching_signature from v$sql where sql_text like ‘%&lt;sql_text%’;Create baseline from plan.SET SERVEROUTPUT ON\r\n\r\ndeclare\r\nmy_int pls_integer;\r\nbegin\r\nmy_int := DBMS_SPM.load_plans_from_cursor_cache(sql_id =&gt; '2zd224kurqsr9’, plan_hash_value =&gt; 1111780545, fixed =&gt; 'NO', enabled =&gt; 'NO');\r\nDBMS_OUTPUT.PUT_line(my_int);\r\nend;\r\n/\r\nList baseline to make sure it has been loaded.SELECT * FROM dba_sql_plan_baselines where signature=&lt;exact matching signature query&gt;;Make sure to load current plan from cursor cache into baseline and disable with the following command.  Also make certain that the baseline is not accepted.DECLARE\r\nMy_plan pls_integer;\r\nBEGIN\r\n\tmy_plans := DBMS_SPM.ALTER_SQL_PLAN_BASELINE (\r\n sql_handle =&gt;&lt;sql_handle&gt;, plan_name =&gt; &lt;plan_name&gt;, attribute_name =&gt; &lt;attribute_name&gt;, ‘ENABLED’, attribute_value =&gt;’NO’);\r\nEND;\r\nPurge the SQL from cursor Cache, so that the optimizer will pick the new plan from baseline.select 'DBMS_SHARED_POOL.PURGE ('''||ADDRESS||', '||HASH_VALUE||''', ''C'');' from V$SQLAREA where SQL_ID = '2zd224kurqsr9';\r\n\r\nexec DBMS_SHARED_POOL.PURGE ('000000051A0961B0, 1111780545', 'C');\r\nConfirmation and rollback proceduresYou can roll back the changes by enabling the previous plans within SQL Profile Manager and running the application to reload planes into the pool.DECLARE\r\nMy_plan pls_integer;\r\nBEGIN\r\n\tmy_plans := DBMS_SPM.ALTER_SQL_PLAN_BASELINE (\r\n sql_handle =&gt;&lt;sql_handle&gt;, plan_name =&gt; &lt;plan_name&gt;, attribute_name =&gt; ‘ENABLED’, \r\nattribute_value =&gt;’YES’);\r\nEND;\r\n/\r\nCheck to make sure old plan is enabled and accepted.select sql_handle, plan_name, enabled, accepted,fixed,origin from dba_sql_plan_baselines where signature=&lt;signature&gt;;Derek Moore",
  "Url": "https://rtpopendata.com",
  "IpAddress": "192.0.78.129",
  "ReverseDns": null,
  "Asn": null,
  "Http2": false,
  "Http3": false,
  "ResponseTimeMs": 2187,
  "StatusCode": 200,
  "ServerHeaders": [
    "nginx"
  ],
  "Ssl": {
    "Issuer": "CN=E8, O=Let's Encrypt, C=US",
    "Subject": "CN=tls.automattic.com",
    "NotBefore": "2026-01-19T19:40:32-08:00",
    "NotAfter": "2026-04-19T20:40:31-07:00",
    "SubjectAltNames": [
      "DNS Name=420capitol.com",
      "DNS Name=ally.science.blog",
      "DNS Name=amarilla.fashion.blog",
      "DNS Name=angelscourierservicetcapital.finance.blog",
      "DNS Name=automaxreidarot.car.blog",
      "DNS Name=filmeshdonline.movie.blog",
      "DNS Name=freesoftware.law.blog",
      "DNS Name=gritglorygames.game.blog",
      "DNS Name=hatgau.fashion.blog",
      "DNS Name=kidsjump.sport.blog",
      "DNS Name=laurumcomolake.com",
      "DNS Name=liberadime.com",
      "DNS Name=lim-accounting.com",
      "DNS Name=lovvelavva.com",
      "DNS Name=mindbodyvoiceproductions.com",
      "DNS Name=myfriendpepino.de",
      "DNS Name=opinion-politique-quebec.politics.blog",
      "DNS Name=rajatbhalla.blog",
      "DNS Name=rtpopendata.com",
      "DNS Name=seejanesurvive.life",
      "DNS Name=sla.politics.blog",
      "DNS Name=taravictorialeigh.com",
      "DNS Name=tls.automattic.com",
      "DNS Name=vinechristiancounseling.org",
      "DNS Name=www.420capitol.com",
      "DNS Name=www.420grand.com",
      "DNS Name=www.angelscourierservicetcapital.finance.blog",
      "DNS Name=www.dkod.blog",
      "DNS Name=www.filmeshdonline.movie.blog",
      "DNS Name=www.freesoftware.law.blog",
      "DNS Name=www.gritglorygames.game.blog",
      "DNS Name=www.kidsjump.sport.blog",
      "DNS Name=www.laurumcomolake.com",
      "DNS Name=www.liberadime.com",
      "DNS Name=www.lovvelavva.com",
      "DNS Name=www.mindbodyvoiceproductions.com",
      "DNS Name=www.myfriendpepino.de",
      "DNS Name=www.opinion-politique-quebec.politics.blog",
      "DNS Name=www.projektratgeber.blog",
      "DNS Name=www.rajatbhalla.blog",
      "DNS Name=www.rtpopendata.com",
      "DNS Name=www.seejanesurvive.life",
      "DNS Name=www.shihweier.com",
      "DNS Name=www.taravictorialeigh.com",
      "DNS Name=www.titan-estate.com",
      "DNS Name=www.undervaluedonline.finance.blog",
      "DNS Name=www.vinechristiancounseling.org"
    ],
    "Hsts": true,
    "Ciphers": [],
    "Protocol": "Tls13",
    "DaysUntilExpiry": 78
  },
  "Cdns": [],
  "HostingHints": [],
  "Cms": [
    "WordPress",
    "WordPress (robots.txt)"
  ],
  "Frameworks": [
    "jQuery"
  ],
  "JsLibraries": [],
  "Analytics": [
    "Google Analytics GA4"
  ],
  "AdsAndMarketing": [],
  "PaymentGateways": [],
  "EcommerceHints": [
    "Magento",
    "PrestaShop"
  ],
  "SocialSignals": [],
  "MediaProviders": [],
  "SeoTags": [
    "content-type: text/html; charset=UTF-8"
  ],
  "HtmlLanguage": "en-US",
  "HasRobots": true,
  "HasSitemap": true,
  "SecurityHeaders": [
    "HSTS",
    "Permissions-Policy"
  ],
  "CookiesObserved": [],
  "XhrApiHints": [],
  "SitemapCounts": {
    "total_urls": 2
  },
  "ChatWidgets": [],
  "ABTesting": [],
  "PrivacyConsent": [],
  "EmailMarketing": [],
  "WebFonts": [],
  "DynamicJs": [
    "Angular (Data Attributes)",
    "Foundation (CSS Classes)",
    "Bootstrap (CSS Classes)",
    "Tailwind CSS (CSS Classes)",
    "Web Server: nginx",
    "jQuery (CDN Detection)",
    "jQuery (script Resource)",
    "ES6+ JavaScript Features"
  ],
  "ResourceHosts": [
    "rtpopendata.com",
    "s0.wp.com",
    "stats.wp.com",
    "gmpg.org",
    "secure.gravatar.com",
    "widgets.wp.com",
    "jetpack.wordpress.com",
    "public-api.wordpress.com",
    "0.gravatar.com",
    "1.gravatar.com",
    "2.gravatar.com",
    "i0.wp.com",
    "c0.wp.com",
    "wp.me",
    "github.githubassets.com"
  ],
  "CssFrameworks": [],
  "BuildTools": [],
  "ServerTech": [
    "PHP (inferred from WordPress)"
  ],
  "DatabaseHints": [],
  "PageTitle": "Data Flux | Maker Electronics, Data Science, Visualizations, and Information Technology Management",
  "MetaDescription": "Maker Electronics, Data Science, Visualizations, and Information Technology Management",
  "ImageCount": 32,
  "ScriptCount": 15,
  "LinkCount": 27,
  "Errors": [
    "Reverse DNS failed: No such host is known."
  ],
  "UiFrameworks": [
    "D3.js",
    "Slate",
    "Swiper",
    "Vuetify (Class Names)",
    "Angular Material (Class Names)",
    "Bootstrap (Class Names)",
    "Tailwind CSS (Class Names)",
    "Ionic (Class Names)"
  ]
}