Jul 25, 2020

Compress index and its Performance

select nodename, sum(length) length from coaxcable c, nodeboundary n where sdo_relate (c.ogc_geometry,n.ogc_geometry,'MASK=ANYINTERACT')='TRUE'
group by Nodename  ---8  sec with  parallel and cache and compress for indexes only because due to version enable table compress table will not work

select nodename, sum(length) length from coaxcable c, nodeboundary n where sdo_relate (c.ogc_geometry,n.ogc_geometry,'MASK=ANYINTERACT')='TRUE'
group by Nodename  ---8  sec with  parallel  and cache 

--COMPRESS FOR INDEX ALONE WILL NOT GIVE MORE PERFORMANCE FOR QUERY

select nodename, sum(length) length from coaxcable c, nodeboundary n where sdo_relate (c.ogc_geometry,n.ogc_geometry,'MASK=ANYINTERACT')='TRUE'
group by Nodename  ---32  sec without  parallel  and  withcache

Dec 25, 2019

Oracle Virtual Private Database (VPD)

  Oracle has provided several solutions to ensure and secure the database. An efficient security policy not only prevents the database against the database corruption or hacking threats but also minimizes the risk of unprivileged user access. Oracle Virtual Private Database (VPD) enables you to create security policies to control database access at the row and column level.