List user objects.
--- a/oracle.rst Sat Mar 04 19:54:58 2017 +0200
+++ b/oracle.rst Sat Mar 04 23:23:47 2017 +0200
@@ -92,6 +92,11 @@
select distinct TABLESPACE_NAME from USER_TABLES;
+List user objects::
+
+ select OBJECT_NAME, OBJECT_TYPE from USER_OBJECTS
+ order by OBJECT_TYPE, OBJECT_NAME;
+
List of current user permissions::
select * from SESSION_PRIVS;
@@ -129,6 +134,31 @@
show parameter user_dump_dest;
+Installing express edition
+==========================
+
+Disable APEX port
+-----------------
+
+Find APEX port in usage::
+
+ select dbms_xdb.GetHttpPort, dbms_xdb.GetFtpPort from dual;
+
+Disable APEX lisener (to free useful 8080 port) from ``system``::
+
+ execute dbms_xdb.SetHttpPort(0);
+
+or move to another port::
+
+ execute dbms_xdb.SetHttpPort(8090);
+
+http://stackoverflow.com/questions/165105/how-to-disable-oracle-xe-component-which-is-listening-on-8080
+ How to disable Oracle XE component which is listening on 8080?
+http://daust.blogspot.co.il/2006/01/xe-changing-default-http-port.html
+ XE: Changing the default http port.
+https://erikwramner.wordpress.com/2014/03/23/stop-oracle-xe-from-listening-on-port-8080/
+ Stop Oracle XE from listening on port 8080.
+
Profiling.
==========