equal
deleted
inserted
replaced
90 |
90 |
91 List of tablespaces:: |
91 List of tablespaces:: |
92 |
92 |
93 select distinct TABLESPACE_NAME from USER_TABLES; |
93 select distinct TABLESPACE_NAME from USER_TABLES; |
94 |
94 |
|
95 List user objects:: |
|
96 |
|
97 select OBJECT_NAME, OBJECT_TYPE from USER_OBJECTS |
|
98 order by OBJECT_TYPE, OBJECT_NAME; |
|
99 |
95 List of current user permissions:: |
100 List of current user permissions:: |
96 |
101 |
97 select * from SESSION_PRIVS; |
102 select * from SESSION_PRIVS; |
98 |
103 |
99 List of user permissions to tables:: |
104 List of user permissions to tables:: |
126 show parameter control_files; |
131 show parameter control_files; |
127 |
132 |
128 Place for dumps:: |
133 Place for dumps:: |
129 |
134 |
130 show parameter user_dump_dest; |
135 show parameter user_dump_dest; |
|
136 |
|
137 Installing express edition |
|
138 ========================== |
|
139 |
|
140 Disable APEX port |
|
141 ----------------- |
|
142 |
|
143 Find APEX port in usage:: |
|
144 |
|
145 select dbms_xdb.GetHttpPort, dbms_xdb.GetFtpPort from dual; |
|
146 |
|
147 Disable APEX lisener (to free useful 8080 port) from ``system``:: |
|
148 |
|
149 execute dbms_xdb.SetHttpPort(0); |
|
150 |
|
151 or move to another port:: |
|
152 |
|
153 execute dbms_xdb.SetHttpPort(8090); |
|
154 |
|
155 http://stackoverflow.com/questions/165105/how-to-disable-oracle-xe-component-which-is-listening-on-8080 |
|
156 How to disable Oracle XE component which is listening on 8080? |
|
157 http://daust.blogspot.co.il/2006/01/xe-changing-default-http-port.html |
|
158 XE: Changing the default http port. |
|
159 https://erikwramner.wordpress.com/2014/03/23/stop-oracle-xe-from-listening-on-port-8080/ |
|
160 Stop Oracle XE from listening on port 8080. |
131 |
161 |
132 Profiling. |
162 Profiling. |
133 ========== |
163 ========== |
134 |
164 |
135 Timing info about last queries:: |
165 Timing info about last queries:: |