Hot answers tagged oracle
The documentation clearly describes the precedence for NLS settings: http://docs.oracle.com/cd/E11882_01/server.112/e10729/ch3globenv.htm#NLSPG188 1 (highest) Explicitly set in SQL functions 2 Set by an ALTER SESSION statement 3 Set as an environment variable 4 Specified in the initialization parameter file 5 Default ...
Technically, you could create a Java stored procedure or a dbms_scheduler external job that you invoke from your APEX process. Doing so, however, would almost certainly be a mistake. First, you'd have the issue of concurrency. If you did invoke your Python script from within your APEX process, for example, that process would start immediately and would ...
"On what parameters can we monitor data warehouse?". Exactly the same ones that you use for monitoring an OLTP database. You might want to pay more attention to things like slow query log (MySQL) for a DW, but that should be on the radar for an OLTP system also. The common "gotchas" may change, but databases all sit on machines with disk, RAM, CPU and ...
If a materialized view is already fast refreshable, the DBMS_ADVISOR.TUNE_MVIEW procedure will return a message saying "the materialized view is already optimal and cannot be further tuned" So there is nothing to do.
Only top voted, non community-wiki answers of a minimum length are eligible