{"_id":"@credenceanalytics/diagnostic-oracle","_rev":"7-fc40bb66004491c4afad1f230a301077","name":"@credenceanalytics/diagnostic-oracle","dist-tags":{"latest":"1.1.0"},"versions":{"1.0.0":{"name":"@credenceanalytics/diagnostic-oracle","version":"1.0.0","author":"","license":"ISC","_id":"@credenceanalytics/diagnostic-oracle@1.0.0","maintainers":[{"name":"shruti_shende","email":"shrutishende@credenceanalytics.com"},{"name":"sonalnadkar","email":"sonalnadkar@credenceanalytics.com"},{"name":"cred-shubham","email":"shubhamyadav@credenceanalytics.com"},{"name":"sagarf","email":"sagarfernandes@credenceanalytics.com"},{"name":"prajaktacred","email":"prajaktashinde@credenceanalytics.com"},{"name":"mandakadam","email":"mandakadam@credenceanalytics.com"},{"name":"prabhuvikas","email":"vikasprabhu@credenceanalytics.com"},{"name":"jimmyjammerx","email":"pratiksatardekar@credenceanalytics.com"},{"name":"suraj_chavan","email":"surajchavan@credenceanalytics.com"},{"name":"mohinim18","email":"mohinimemane@credenceanalytics.com"}],"dist":{"shasum":"725f7b60778632e02408f63d7a4ee60f131bb060","tarball":"https://registry.npmjs.org/@credenceanalytics/diagnostic-oracle/-/diagnostic-oracle-1.0.0.tgz","fileCount":9,"integrity":"sha512-DriqCryKCgcqT+rlIeRybx1s0KRqmOWjVgT0OPIOLgwxRxBWLHCb48NbrRX6ddC2XvczsXWLRmVZJ9EoOmHM6g==","signatures":[{"sig":"MEUCIBpV0GIbXyypQIsqt+Oi/HmHl1vsh1AFx0m9SeFPd0QzAiEAyF0L3jm++45FeLZbqgy4Usj9zSVSbm3iZF64w65CNxc=","keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA"}],"unpackedSize":22254},"main":"connection.js","gitHead":"dcd40522f4dc9500007309146dd43939ab296817","scripts":{"test":"mocha --timeout 10000"},"_npmUser":{"name":"jimmyjammerx","email":"pratiksatardekar@credenceanalytics.com"},"_npmVersion":"9.6.7","description":"Independent module to generate diagnostic reports from Oracle Database.","directories":{},"_nodeVersion":"18.17.1","dependencies":{"lodash":"^4.17.21","oracledb":"=5.5.0"},"_hasShrinkwrap":false,"devDependencies":{"chai":"^4.3.8","mocha":"^10.2.0"},"_npmOperationalInternal":{"tmp":"tmp/diagnostic-oracle_1.0.0_1695816172720_0.03302956702942761","host":"s3://npm-registry-packages"}},"1.1.0":{"name":"@credenceanalytics/diagnostic-oracle","version":"1.1.0","author":"","license":"ISC","_id":"@credenceanalytics/diagnostic-oracle@1.1.0","maintainers":[{"name":"shruti_shende","email":"shrutishende@credenceanalytics.com"},{"name":"sonalnadkar","email":"sonalnadkar@credenceanalytics.com"},{"name":"cred-shubham","email":"shubhamyadav@credenceanalytics.com"},{"name":"sagarf","email":"sagarfernandes@credenceanalytics.com"},{"name":"prajaktacred","email":"prajaktashinde@credenceanalytics.com"},{"name":"mandakadam","email":"mandakadam@credenceanalytics.com"},{"name":"prabhuvikas","email":"vikasprabhu@credenceanalytics.com"},{"name":"jimmyjammerx","email":"pratiksatardekar@credenceanalytics.com"},{"name":"suraj_chavan","email":"surajchavan@credenceanalytics.com"},{"name":"mohinim18","email":"mohinimemane@credenceanalytics.com"}],"dist":{"shasum":"9aac3a99564c3b1ac7a3d9d15bc30c78e192aa6e","tarball":"https://registry.npmjs.org/@credenceanalytics/diagnostic-oracle/-/diagnostic-oracle-1.1.0.tgz","fileCount":6,"integrity":"sha512-ULlJ0SZkji8OrcWOYvWHV9jWSq8MQnnTPoMZg2h+irMdyi1G0lB0Fwh3aW1P2snXELoQxGfzE8ImD3U61NMjDA==","signatures":[{"sig":"MEYCIQDEUQWtxiFzn8EfRejQScUJzBF10TKeKEdYhmLlPc3wyAIhAOuvd1H3xU8pPUz/ho/QtoKbobUHqlnWeBECLsGGzqKH","keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA"}],"unpackedSize":16321},"main":"connection.js","gitHead":"0a0d85070e859af33c0ff870aecf63dda77952f8","scripts":{"test":"mocha --timeout 10000"},"_npmUser":{"name":"jimmyjammerx","email":"pratiksatardekar@credenceanalytics.com"},"_npmVersion":"9.6.7","description":"Independent module to generate diagnostic reports from Oracle Database.","directories":{},"_nodeVersion":"18.17.1","dependencies":{"lodash":"^4.17.21","oracledb":"=5.5.0"},"_hasShrinkwrap":false,"devDependencies":{"chai":"^4.3.8","mocha":"^10.2.0"},"_npmOperationalInternal":{"tmp":"tmp/diagnostic-oracle_1.1.0_1695816577680_0.1924903471787578","host":"s3://npm-registry-packages"}}},"time":{"created":"2023-09-27T12:02:52.644Z","modified":"2026-09-21T10:50:48.983Z","1.0.0":"2023-09-27T12:02:53.080Z","1.1.0":"2023-09-27T12:09:37.937Z"},"license":"ISC","description":"Independent module to generate diagnostic reports from Oracle Database.","maintainers":[{"email":"vikasprabhu@credenceanalytics.com","name":"prabhuvikas"},{"email":"surajchavan@credenceanalytics.com","name":"suraj_chavan"},{"email":"mohinimemane@credenceanalytics.com","name":"mohinim18"},{"email":"jiteshsuthar@credenceanalytics.com","name":"jiteshsuthar"},{"email":"mandakadam@credenceanalytics.com","name":"mandakadam"},{"email":"sonalnadkar@credenceanalytics.com","name":"sonalnadkar"},{"email":"suhassurwase@credenceanalytics.com","name":"suhas_surwase"}],"readme":"# @credenceanalytics/diagnostic-oracle\r\n\r\nIndependent module to generate diagnostic reports from Oracle Database.\r\n\r\n# Installation\r\n```\r\nnpm install -s @credenceanalytics/diagnostic-oracle\r\n```\r\n\r\n# Usages\r\n```javascript\r\nconst { OracleReport } = require('@credenceanalytics/diagnostic-oracle')\r\nconst report = new OracleReport({\"user\": \"\", \"password\": \"\", \"connectString\": \"127.0.0.1:1521/SAMPLEDS\"})\r\n```\r\n\r\n# API\r\n\r\n## generateReport\r\n\r\nReturns promise that is resolved with json data or empty object.\r\n\r\n```javascript\r\nconst jsondata = await report.generateReport()\r\n```\r\n\r\nO/P:\r\n```json\r\n{\"DATABASE_STORAGE\": [], \"TABLESPACE\": [], \"LONG_RUNNING\": [], \"BLOCKED_SESSION\": [], \"FAILED_JOB\": [], \"UNUSABLE_INDEX\": [], \"INVALID_OBJECT\": [], \"SPACE_USAGE\": [], \"STALE_INDEX\": [], \"AUTOMATIC_STORAGE_MANAGEMENT\": [], \"DATABASE_ALERTS_AND_INCIDENTS\": [], \"DATABASE_RESOURCE_USAGE\": [], \"DATABASE_CONFIGURATION_SETTINGS\": [], \"BUFFER_CACHE_PARAMETER\": [], \"LARGE_DATA_SIZE\": [], \"BUFFER_PARAMETERS\": [], \"PGA_PARAMETER\": [], \"SHARED_POOL_PARAMETERS\": [], \"SGA_MEMORY_ALLOCATION\": [], \"TEMPORARY_TABLESPACE\": [], \"GROWTH_TRENDS\": [], \"DATABASE_PERFORMANCE_METRICS\": [], \"OPTIMIZER_PARAMETERS\": [], \"DATA_GUARD_STATUS\": [] }\r\n```\r\n\r\n*NOTE:* See [Diagnostic Information](#diagnostic-information) section for more details.\r\n\r\n## writeReport\r\n\r\nGenerate and write json data in given file path.<br>\r\nFully absolute path of file is required as parameter.<br>\r\nReturns promise that is resolved with undefined.<br>\r\n\r\n```javascript\r\nconst jsondata = await report.writeReport(\"/data.json\")\r\n```\r\n\r\n# Diagnostic Information\r\n1)  `DATABASE_STORAGE` Database details\r\n2)  `TABLESPACE` Check table space usage\r\n3)  `LONG_RUNNING` Check for long-running queries\r\n4)  `BLOCKED_SESSION` Check for blocked sessions\r\n5)  `FAILED_JOB` Check for failed jobs\r\n6)  `UNUSABLE_INDEX` Check for un usable index\r\n7)  `INVALID_OBJECT` Identify invalid objects\r\n8)  `SPACE_USAGE` Check ASM disk group space usage\r\n9)  `STALE_INDEX` Identify stale indexes\r\n10) `AUTOMATIC_STORAGE_MANAGEMENT` Check Automatic Storage Management (ASM) health\r\n11) `DATABASE_ALERTS_AND_INCIDENTS` Check database alerts and incidents\r\n12) `DATABASE_RESOURCE_USAGE` Check database resource usage\r\n13) `DATABASE_CONFIGURATION_SETTINGS` Check database configuration settings\r\n14) `BUFFER_CACHE_PARAMETER` Check buffer cache parameters\r\n15) `LARGE_DATA_SIZE` Identify tables for archiving due to large data size\r\n16) `BUFFER_PARAMETERS` Read log buffer parameters\r\n17) `PGA_PARAMETER` PGA parameters\r\n18) `SHARED_POOL_PARAMETERS` Shared pool parameters\r\n19) `SGA_MEMORY_ALLOCATION` Identify inadequate SGA memory allocation\r\n20) `TEMPORARY_TABLESPACE` Identify low temporary table space\r\n21) `GROWTH_TRENDS` Check database growth trends\r\n23) `DATABASE_PERFORMANCE_METRICS` Check database performance metrics\r\n24) `OPTIMIZER_PARAMETERS` Optimizer Parameters\r\n25) `DATA_GUARD_STATUS` Check Data Guard status (if applicable)","readmeFilename":"README.md"}