What is a Materialized View?

A database object that stores the results of a query

–Marries the query rewrite features found in Oracle Discoverer with the data refresh capabilities of snapshots

Features/Capabilities

–Can be partitioned and indexed

–Can be queried directly

–Can have DML applied against it

–Several refresh options are available

–Best in read-intensive environments

 

Advantages

–Useful for summarizing, pre-computing, replicating and distributing data

–Faster access for expensive and complex joins

–Transparent to end-users

MVs can be added/dropped without invalidating coded SQL

Disadvantages

–Performance costs of maintaining the views

–Storage costs of maintaining the views

Oracle Default Port connection

The following table contains Oracle default ports for different products like Oracle Database or Oracle Application Server.
Changing the default ports can help to stop simple attacks but not real portscans. In the world of Oracle it is very often not possible to change the default port because the port is hardcoded.

At least for the Oracle database (except iasdb) it's is recommended to change the TNS listener port from 1521/1526 to something else.

Service	Port	Product	How to change
Oracle HTTP Server listen port / Oracle HTTP Server port	80	Oracle Application Server	Edit httpd.conf and restart OHS
Oracle Internet Directory(non-SSL)	389	Oracle Application Server
Oracle HTTP Server SSL port	443	Oracle Application Server	Edit httpd.conf and restart OHS
Oracle Internet Directory(SSL)	636	Oracle Application Server
Oracle Net Listener / Enterprise Manager Repository port	1521	Oracle Application Server / Oracle Database	Edit listener.ora and restart listener
Oracle Net Listener	1526	Oracle Database	Edit listener.ora and restart listener
Oracle Names	1575	Oracle Database	Edit names.ora and restart names server
Oracle Connection Manager (CMAN)	1630	Oracle Connection Manager	Edit cman.ora and restart Connection Manager
Oracle JDBC for Rdb Thin Server	1701	Oracle Rdb
Oracle Intelligent Agent	1748	Oracle Application Server	snmp_rw.ora
Oracle Intelligent Agent	1754	Oracle Application Server	snmp_rw.ora
Oracle Intelligent Agent	1808	Oracle Application Server	snmp_rw.ora
Oracle Intelligent Agent	1809	Oracle Application Server	snmp_rw.ora
Enterprise Manager Servlet port SSL	1810	Oracle Enterprise Manager
Oracle Connection Manager Admin (CMAN)	1830	Oracle Connection Manager (CMAN)	Edit cman.ora and restart Connection Manager
Enterprise ManagerAgent port	1831	Oracle Enterprise Manager
Enterprise Manager RMI port	1850	Oracle Enterprise Manager
Oracle XMLDB FTP Port	2100	Oracle Database	change dbms_xdb.cfg_update
Oracle GIOP IIOP	2481	Oracle Database	Edit listener.ora/init.ora and restart listener/database
Oracle GIOP IIOP for SSL	2482	Oracle Database	Edit listener.ora/init.ora and restart listener/database
Oracle OC4J RMI	3201	Oracle Application Server
Oracle OC4J AJP	3301	Oracle Application Server
Enterprise Manager Reporting port	3339	Oracle Application Server	Edit oem_webstage/oem.conf and restart OHS
Oracle OC4J IIOP	3401	Oracle Application Server
Oracle OC4J IIOPS1	3501	Oracle Application Server
Oracle OC4J IIOPS2	3601	Oracle Application Server
Oracle OC4J JMS	3701	Oracle Application Server
Oracle9iAS Web Cache Admin port	4000	Oracle Application Server	Webcache Admin GUI or webcache.xml
Oracle9iAS Web Cache Invalidation port	4001	Oracle Application Server	Webcache Admin GUI or webcache.xml
Oracle9iAS Web Cache Statistics port	4002	Oracle Application Server	Webcache Admin GUI or webcache.xml
Oracle Internet Directory(SSL)	4031	Oracle Application Server
Oracle Internet Directory(non-SSL)	4032	Oracle Application Server
OracleAS Certificate Authority (OCA) - Server Authentication	4400	Oracle Application Server
OracleAS Certificate Authority (OCA) - Mutual Authentication	4401	Oracle Application Server
Oracle HTTP Server SSL port	4443	Oracle Application Server	Edit httpd.conf and restart OHS
Oracle9iAS Web Cache HTTP Listen(SSL) port	4444	Oracle Application Server	Webcache Admin GUI or webcache.xml
Oracle TimesTen	4662	Oracle TimesTen
Oracle TimesTen	4758	Oracle TimesTen
Oracle TimesTen	4759	Oracle TimesTen
Oracle TimesTen	4761	Oracle TimesTen
Oracle TimesTen	4764	Oracle TimesTen
Oracle TimesTen	4766	Oracle TimesTen
Oracle TimesTen	4767	Oracle TimesTen
Oracle Enterprise Manager Web Console	5500	Oracle Enterprise Manager Web
iSQLPlus 10g	5560	Oracle i*SQLPlus
iSQLPlus 10g	5580	Oracle i*SQLPlus RMI Port
Oracle Notification Service request port	6003	Oracle Application Server
Oracle Notification Service local port	6100	Oracle Application Server
Oracle Notification Service remote port	6200	Oracle Application Server
Oracle9iAS Clickstream Collector Agent	6668	Oracle Application Server
Java Object Cache port	7000	Oracle Application Server
DCM Java Object Cache port	7100	Oracle Application Server
Oracle HTTP Server Diagnostic Port	7200	Oracle Application Server
Oracle HTTP Server Port Tunneling	7501	Oracle Application Server
Oracle HTTP Server listen port / Oracle HTTP Server port	7777	Oracle Application Server	Edit httpd.conf and restart OHS
Oracle9iAS Web Cache HTTP Listen(non-SSL) port	7779	Oracle Application Server	Webcache Admin GUI or webcache.xml
Oracle HTTP Server Jserv port	8007	Oracle Application Server
Oracle XMLDB HTTP port	8080	Oracle Database	change dbms_xdb.cfg_update
OC4J Forms / Reports Instance	8888	Oracle Developer Suite