Oracle Sharding
A scalability and availability feature for custom-designed OLTP applications that enables distribution and replication of data across a pool of discrete Oracle Databases. This pool of databases is presented to…
Read MoreLEAST PRIVILEGE AND SEPARATION OF DUTY
To support the principles of least privilege and separation of duty, the SYSOPER administrative privilege allows an administrator to perform limited tasks such as starting and stopping the database without having…
Read MoreOracle Data Redaction
Oracle Data Redaction provides the ability to masking data, typically sensitive data in real-time like credit card, Aadhar card details etc. before displaying with application. For example, in a call…
Read MoreHow Oracle Database Vault Addresses Database Consolidation Concerns
Consolidation and cloud environments reduce cost but can expose sensitive application data to those without a true need-to-know. Data from one country may be hosted in an entirely different country,…
Read MoreOracle Database Vault
The Oracle Database Vault security controls protect application data from unauthorized access and comply with privacy and regulatory requirements. We can deploy controls to block privileged account access to application…
Read MoreObject Storage vs Block Storage
Block storage is the oldest and simplest form of data storage. Block storage stores data in fixed-sized ‘blocks’. By itself, a block typically only houses a portion of the data.…
Read MoreHow is Oracle Autonomous Data Warehouse different from the rest of Cloud Database Services
Cloud Database is not new. There are several options from various technology vendors to choose from. However, Oracle Autonomous Data Warehouse is a perfect fit for enterprise business analysts, and…
Read MoreOracle Analytics Server (OAS) vs Oracle Analytics Cloud (OAC)
OAC and OAS are congruent products and therefore enable organizations to leverage both deployments simultaneously. Going from OAS to OAC or vice-versa is as simple as creating a snapshot from…
Read MoreACLPrivileges for websites
FIND ACL PRIVILEGES ==================== set pages 1000 lines 1000 col acl for a50 col principal for a20 col privilege for a20 col is_grant for a20 col invert for a20 col…
Read MoreFind the table size including LOB segments
col owner FOR a20 col segment_name FOR a40 SELECT S.owner “Owner”, Nvl(S.segment_name, ‘TABLE TOTAL SIZE’) “Segment_name”, Round(SUM(S.bytes) / 1024 / 1024 / 1024, 1) “Segment_size_GB” FROM dba_segments S WHERE S.segment_name…
Read More