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

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. 

NO SQL - Part 2

https://oracle-plsql10g.blogspot.com/2013/02/nosql.html

Schemaless is one of the main reasons for interest in NoSQL databases.

Dev OPS - Part 2

https://oracle-plsql10g.blogspot.com/2016/12/dev-ops.html

DevOps = Continuous Delivery + Operatability

UNDO & TEMP Tablespace

Oracle stores global temporary table  rows in the users temporary tablespace of the user, but you can change this to a "real" tablespace by using the tablespace clause of the create global temporary table syntax.

Prior to Oracle12c, Oracle transactions used UNDO for temporary tables (WITH Clause materializations, global temporary tables) within the standard UNDO tablespace.  Now, you can specify "alter session set temp_undo_enabled=true" to force the UNDO to be managed within the TEMP tablespace instead of within the UNDO tablespace