What is Princeton Sentinel?

Princeton Sentinel is an enterprise security monitoring platform that analyzes audit logs, detects cloud security anomalies, and enforces governance across multi-cloud environments.

Does Princeton Sentinel support Microsoft 365 and Azure Purview?

Yes, Princeton Sentinel integrates directly with Microsoft Purview audit logs and Azure telemetry to provide real-time compliance alerting and security intelligence.

Oracle Archives - Page 4 of 4 - Princeton IT Services

Category: Oracle

oracle – generate kill database sessions script

Here is the script that comes handy to Oracle DBAs for generating script to kill sessions based on user sessions. For example, this SQL script generates the script to kill […]

Oracle dbms job remove from another schema

[vc_row][vc_column][vc_row_inner][vc_column_inner][vc_raw_html]SW4lMjB0aGUlMjBmb2xsb3dpbmclMjB1c2UlMjBjYXNlJTJDJTIwYXMlMjBzeXNkYmElMjBJJTIwYW0lMjB0cnlpbmclMjB0byUyMHJlbW92ZSUyMHRoZSUyMGpvYiUyMHRoYXQlMjBiZWxvbmdzJTIwdG8lMjBhbm90aGVyJTIwdXNlciUyMC0lMjAlMjdBTVMyMDAwJTI3JTIwdGhhdCUyMHJlc3VsdHMlMjBpbiUyMGVycm9yJTIwLSUyME9SQS0yMzQyMS4lMEElMEElM0NwJTNFQXMlMjBhJTIwc3lzZGJhJTJDJTIwd2hlbiUyMHlvdSUyMHRyeSUyMHJlbW92aW5nJTIwam9iJTIwYmVsb25naW5nJTIwdG8lMjBhbm90aGVyJTIwdXNlciUyQyUyMHlvdSUyMHdpbGwlMjBnZXQlMjBPUkEtMjM0MjElM0MlMkZwJTNFJTBBJTNDcHJlJTIwY2xhc3MlM0QlMjIlMjBsYW5ndWFnZS1ub25lJTIyJTNFJTBBJTNDY29kZSUzRSUwQVNRTCUyNmd0JTNCJTIwJTIwQkVHSU4lMjBEQk1TX0pPQi5yZW1vdmUlMjg0MDAyJTI5JTNCJTBBMiUyMCUyMEVORCUzQiUwQTMlMjAlMjAlMkYlMEFCRUdJTiUyMERCTVNfSk9CLnJlbW92ZSUyODQwMDIlMjklM0IlMEElMkElMEFFUlJPUiUyMGF0JTIwbGluZSUyMDElM0ElMEFPUkEtMjM0MjElM0ElMjBqb2IlMjBudW1iZXIlMjA0MDAyJTIwaXMlMjBub3QlMjBhJTIwam9iJTIwaW4lMjB0aGUlMjBqb2IlMjBxdWV1ZSUwQU9SQS0wNjUxMiUzQSUyMGF0JTIwJTIyU1lTLkRCTVNfU1lTX0VSUk9SJTIyJTJDJTIwbGluZSUyMDg2JTBBT1JBLTA2NTEyJTNBJTIwYXQlMjAlMjJTWVMuREJNU19JSk9CJTIyJTJDJTIwbGluZSUyMDc4MSUwQU9SQS0wNjUxMiUzQSUyMGF0JTIwJTIyU1lTLkRCTVNfSk9CJTIyJTJDJTIwbGluZSUyMDE4MCUwQU9SQS0wNjUxMiUzQSUyMGF0JTIwbGluZSUyMDElMEElM0MlMkZjb2RlJTNFJTBBJTNDJTJGcHJlJTNFJTBBJTNDcCUzRVVzaW5nJTIwZGJtc19pam9iLnJlbW92ZSUyMG9uZSUyMGNhbiUyMHJlbW92ZSUyMGpvYiUyMGJlbG9uZ2luZyUyMHRvJTIwYW5vdGhlciUyMHNjaGVtYSUzQyUyRnAlM0UlMEElM0NwcmUlMjBjbGFzcyUzRCUyMiUyMGxhbmd1YWdlLW5vbmUlMjIlM0UlMEElM0Njb2RlJTNFJTBBU1FMJTI2Z3QlM0IlMjBleGVjJTIwZGJtc19pam9iLnJlbW92ZSUyODQwMDIlMjklM0IlMEFQTCUyRlNRTCUyMHByb2NlZHVyZSUyMHN1Y2Nlc3NmdWxseSUyMGNvbXBsZXRlZC4lMEElM0MlMkZjb2RlJTNFJTBBJTNDJTJGcHJlJTNF[/vc_raw_html][/vc_column_inner][/vc_row_inner][/vc_column][/vc_row]

Enabling and Disabling – auto optimizer stats collection

Here is how you can query if the Auto Optimizer Stats Collection job is running in Oracle Database 11g: Login to database as SYSDBA: [sql] SELECT CLIENT_NAME, STATUS FROM DBA_AUTOTASK_CLIENT […]

oracle standard edition one vs oracle standard edition 2

Starting Sept 2015, Oracle Standard Edition and Oracle Standard Edition One are no longer available from Oracle. Oracle Standard Edition 2 is the new product offering under standard edition starting […]

Goldengate Integrated Extract – Identifying and resolving extract process hang issue

[vc_row][vc_column][vc_row_inner][vc_column_inner][vc_raw_html]R29sZGVuZ2F0ZSUyMGV4dHJhY3QlMjBwcm9jZXNzJTIwY2FuJTIwaGFuZyUyMGZvciUyMHZhcmlvdXMlMjByZWFzb25zLiUyMEl0JTIwaXMlMjB2ZXJ5JTIwaW1wb3J0YW50JTIwdG8lMjBoYXZlJTIwYSUyMHByb2Nlc3MlMjBpbiUyMHBsYWNlJTIwdG8lMjBtb25pdG9yJTIwZ29sZGVuZ2F0ZSUyMHByb2Nlc3MlMjBhbmQlMjBkZXRlY3QlMjBoYW5naW5nJTIwaXNzdWVzLiUyMEklMjByZWNlbnRseSUyMGVuY291bnRlcmVkJTIwR29sZGVuZ2F0ZSUyMEV4dHJhY3QlMjBIYW5nJTIwaXNzdWUuJTIwQmVsb3clQzIlQTBpcyUyMGhvdyUyMEklMjByZXNvbHZlZCUyMHRoaXMlMjBpc3N1ZSUzQSUwQSUwQUNvcHklMjB0aGUlMjBmb2xsb3dpbmclMjBTUUwlMjBhbmQlMjBzYXZlJTIwdG8lMjBmaWxlJTIwLSUyMGRiYV9jYXB0dXJlX2luZm8uc3FsJTNBJTBBJTNDcHJlJTNFJTNDY29kZSUzRWNvbCUyMENBUFRVUkVfTkFNRSUyMGZvciUyMGEyMCUzQiUwQWNvbCUyMFFVRVVFX05BTUUlMjBmb3IlMjBhMTUlM0IlMEFjb2wlMjBTVEFSVF9TQ04lMjBmb3IlMjA5OTk5OTk5OTk5JTNCJTBBY29sJTIwU1RBVFVTJTIwZm9yJTIwYTEwJTNCJTBBY29sJTIwQ0FQVFVSRURfU0NOJTIwZm9yJTIwOTk5OTk5OTk5OSUzQiUwQWNvbCUyMEFQUExJRURfU0NOJTIwZm9yJTIwOTk5OTk5OTk5OSUzQiUwQWNvbCUyMFNPVVJDRV9EQVRBQkFTRSUyMGZvciUyMGExMCUzQiUwQWNvbCUyMExPR01JTkVSX0lEJTIwZm9yJTIwOTk5OTk5OSUzQiUwQWNvbCUyMFJFUVVJUkVEX0NIRUNLUE9JTlRTQ04lMjBmb3IlMjBhMzAlM0IlMEFjb2wlMjBTVEFUVVNfQ0hBTkdFX1RJTUUlMjBmb3IlMjBhMTUlM0IlMEFjb2wlMjBFUlJPUl9OVU1CRVIlMjBmb3IlMjBhMTUlM0IlMEFjb2wlMjBFUlJPUl9NRVNTQUdFJTIwZm9yJTIwYTEwJTNCJTBBY29sJTIwU1RBUlRfVElNRSUyMGZvciUyMGEzMCUwQWNvbCUyMENBUFRVUkVfVFlQRSUyMGZvciUyMGExMCUzQiUwQVNFTEVDVCUyMENBUFRVUkVfTkFNRSUyQyUyMFFVRVVFX05BTUUlMkMlMjBTVEFSVF9TQ04lMkMlMjBTVEFUVVMlMkMlMEFDQVBUVVJFRF9TQ04lMkMlMjBBUFBMSUVEX1NDTiUyQyUyMFNPVVJDRV9EQVRBQkFTRSUyQyUwQUxPR01JTkVSX0lEJTJDJTIwUkVRVUlSRURfQ0hFQ0tQT0lOVF9TQ04lMkMlMEFTVEFUVVNfQ0hBTkdFX1RJTUUlMkMlMjBFUlJPUl9OVU1CRVIlMkMlMjBFUlJPUl9NRVNTQUdFJTJDJTBBQ0FQVFVSRV9UWVBFJTJDJTIwU1RBUlRfVElNRSUwQUZST00lMjBEQkFfQ0FQVFVSRSUzQiUwQSUwQSUzQyUyRmNvZGUlM0UlM0MlMkZwcmUlM0UlMEExLiUyMEV4ZWN1dGUlMjB0aGUlMjBmb2xsb3dpbmclMjBRdWVyeSUyMHRvJTIwaWRlbnRpZnklMjB0aGUlMjBzdGF0dXMlMjBvZiUyMGNhcHR1cmUlMjBhbmQlMjBpZGVudGlmaWVkJTIwdGhhdCUyMHRoZXJlJTIwaXMlMjBhJTIwZGlzLWNvbm5lY3QlMjBiZXR3ZWVuJTIwREIlMjBhbmQlMjBHRyUyMFByb2Nlc3MuJTBBJTNDcHJlJTNFJTNDY29kZSUzRVNRTCUyNmd0JTNCJTIwJTQwZGJhX2NhcHR1cmVfaW5mby5zcWwlMEElMEFDQVBUVVJFX05BTUUlMjBRVUVVRV9OQU1FJTIwU1RBUlRfU0NOJTIwU1RBVFVTJTIwQ0FQVFVSRURfU0NOJTBBLS0tLS0tLS0tLS0tLS0tLS0tLS0lMjAtLS0tLS0tLS0tLS0tLS0lMjAtLS0tLS0tLS0tLSUyMC0tLS0tLS0tLS0lMjAtLS0tLS0tLS0tLS0lMEFBUFBMSUVEX1NDTiUyMFNPVVJDRV9EQVQlMjBMT0dNSU5FUl9JRCUyMFJFUVVJUkVEX0NIRUNLUE9JTlRfU0NOJTIwU1RBVFVTX0NIQU5HRV9UJTBBLS0tLS0tLS0tLS0lMjAtLS0tLS0tLS0tJTIwLS0tLS0tLS0tLS0lMjAtLS0tLS0tLS0tLS0tLS0tLS0tLS0tLSUyMC0tLS0tLS0tLS0tLS0tLSUwQUVSUk9SX05VTUJFUiUyMEVSUk9SX01FU1MlMjBDQVBUVVJFX1RZJTIwU1RBUlRfVElNRSUwQS0tLS0tLS0tLS0tLSUyMC0tLS0tLS0tLS0lMjAtLS0tLS0tLS0tJTIwLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tJTBBT0dHJTI0Q0FQX0VEX0FQUF9CJTIwT0dHJTI0UV9FRF9BUFBfQiUyMDUwMDg4NzU5NjIlMjBESVNBQkxFRCUyMDUwNjE1NjQxMjYlMEE1MDYxNTY0MTE4JTIwTlVUUklRQSUyMDEzJTIwNTA2MTU2NDExOCUyMDA0LU5PVi0xNSUwQUxPQ0FMJTBBJTBBT0dHJTI0Q0FQX0VEX0FQUF9BJTIwT0dHJTI0UV9FRF9BUFBfQSUyMDUwMDc3NDEzNzIlMjBFTkFCTEVEJTIwNTA2MTY2ODMyNCUwQTUwNjE2NjgzMTQlMjBOVVRSSVFBJTIwMTIlMjA1MDYxNjY4MzE0JTIwMDQtTk9WLTE1JTBBTE9DQUwlMEElMEElM0MlMkZjb2RlJTNFJTNDJTJGcHJlJTNFJTBBMi4lMjBJJTIwdHJpZWQlMjBkb2luZyUyMG5vcm1hbCUyMHN0b3AuJTIwTm9ybWFsJTIwc3RvcCUyMGRpZCUyMG5vdCUyMHdvcmslMjBhcyUyMHRoZSUyMHByb2Nlc3MlMjB3YXMlMjBqdXN0JTIwaGFuZ2luZy4lMEElMEElM0NwcmUlM0UlM0Njb2RlJTNFR0dTQ0klMjAlMjhsb2NhbGhvc3QlMjBhcyUyMGdnYWRtaW4lNDBQUUFEQjIlMjklMjAzJTI2Z3QlM0IlMjBzdG9wJTIwRURfQVBQX0IlMEElMEFTZW5kaW5nJTIwU1RPUCUyMHJlcXVlc3QlMjB0byUyMEVYVFJBQ1QlMjBFRF9BUFBfQiUyMC4uLiUwQSUwQUVSUk9SJTNBJTIwc2VuZGluZyUyMG1lc3NhZ2UlMjB0byUyMEVYVFJBQ1QlMjBFRF9BUFBfQiUyMCUyOFRpbWVvdXQlMjB3YWl0aW5nJTIwZm9yJTIwbWVzc2FnZSUyOS4lMEElM0MlMkZjb2RlJTNFJTNDJTJGcHJlJTNFJTBBJTNDcCUzRTMuJTIwQXMlMjB0aGUlMjBwcm9jZXNzJTIwd2FzJTIwaGFuZ2luZyUyQyUyMEklMjBkaWQlMjAlMjJraWxsJTIyJTIwdGhlJTIwZXh0cmFjdCUyMHByb2Nlc3MuJTNDJTJGcCUzRSUwQSUzQ3ByZSUzRSUzQ2NvZGUlM0VHR1NDSSUyMCUyOGxvY2FsaG9zdCUyMGFzJTIwZ2dhZG1pbiU0MFBRQURCMiUyOSUyMDUlMjZndCUzQiUyMGtpbGwlMjBleHRyYWN0JTIwRURfQVBQX0IlMEFTZW5kaW5nJTIwS0lMTCUyMHJlcXVlc3QlMjB0byUyME1BTkFHRVIlMjAuLi4lMEElM0MlMkZjb2RlJTNFJTNDJTJGcHJlJTNFJTBBJTBBJTNDcCUzRTQuJTIwQ2hlY2slMjB0aGUlMjBjdXJyZW50JTIwc3RhdHVzJTIwYnklMjBpc3N1aW5nJTIwJTIyaW5mbyUyMGFsbCUyMiUyMGNvbW1hbmQlM0ElM0MlMkZwJTNFJTBBJTNDcHJlJTNFJTNDY29kZSUzRSUwQUdHU0NJJTIwJTI4bG9jYWxob3N0JTIwYXMlMjBnZ2FkbWluJTQwUFFBREIyJTI5JTIwNiUyNmd0JTNCJTIwaW5mbyUyMGFsbCUyMCUwQVByb2dyYW0lMjBTdGF0dXMlMjBHcm91cCUyMExhZyUyMGF0JTIwQ2hrcHQlMjBUaW1lJTIwU2luY2UlMjBDaGtwdCUwQSUwQU1BTkFHRVIlMjBSVU5OSU5HJTBBSkFHRU5UJTIwUlVOTklORyUwQUVYVFJBQ1QlMjBSVU5OSU5HJTIwRURfQVBQX0ElMjAwMCUzQTAwJTNBMDYlMjAwMCUzQTAwJTNBMDQlMEFFWFRSQUNUJTIwU1RPUFBFRCUyMEVEX0FQUF9CJTIwMDElM0EzMCUzQTA2JTIwMDAlM0EyNCUzQTQ4JTBBRVhUUkFDVCUyMFJVTk5JTkclMjBQRF9BUFBfQSUyMDAwJTNBMDAlM0EwMCUyMDAwJTNBMDAlM0EwMCUwQUVYVFJBQ1QlMjBSVU5OSU5HJTIwUERfQVBQX0IlMjAwMCUzQTAwJTNBMDAlMjAwMCUzQTAwJTNBMDclMEFSRVBMSUNBVCUyMFJVTk5JTkclMjBSRF9BUFBfQSUyMDAwJTNBMDAlM0EwMCUyMDAwJTNBMDAlM0EwMSUwQVJFUExJQ0FUJTIwUlVOTklORyUyMFJEX0FQUF9CJTIwMDAlM0EwMCUzQTAwJTIwMDAlM0EwMCUzQTA2JTBBJTNDJTJGY29kZSUzRSUzQyUyRnByZSUzRSUwQSUzQ3AlM0U1LiUyMFN0YXJ0JTIwdGhlJTIwZXh0cmFjdCUzQSUzQyUyRnAlM0UlMEElM0NwcmUlM0UlM0Njb2RlJTNFJTBBR0dTQ0klMjAlMjhsb2NhbGhvc3QlMjBhcyUyMGdnYWRtaW4lNDBQUUFEQjIlMjklMjA4JTI2Z3QlM0IlMjBzdGFydCUyMEVEX0FQUF9CJTBBU2VuZGluZyUyMFNUQVJUJTIwcmVxdWVzdCUyMHRvJTIwTUFOQUdFUiUyMC4uLiUwQUVYVFJBQ1QlMjBFRF9BUFBfQiUyMHN0YXJ0aW5nJTBBJTNDJTJGY29kZSUzRSUzQyUyRnByZSUzRQ==[/vc_raw_html][/vc_column_inner][/vc_row_inner][/vc_column][/vc_row]

expdp fails with ORA-27037 on Oracle RAC

When parallel option is used in expdp, it expects the DIRECTORY path to be available on nodes of the cluster. If you have created the directory on only one node […]

Identifying Blocking Sessions in Oracle Database

Below SQL gives the blocker and blockee sessions in database. Oracle RAC Environment: select (select username from gv$session where sid=a.sid) blocker, a.sid, ‘is blocking’, (select username from gv$session where sid=b.sid) […]