Hot answers tagged oracle
I guess, you can use parallel operations: Parallel DML Let your table support parallel operations: ALTER TABLE EFF parallel; Then you perform all your steps as you describe in the question. Parallel DDL + CTAS CREATE TABLE temp_table_EFF PARALLEL AS SELECT MOD, MP, PROG, TO_NUMBER(RNK), EFF_PART FROM EFF Then you drop your table: DROP TABLE EFF; ...
No need to de-install Oracle rdbms software. Just install and configure ASM. If you have enough storage available you can copy your database to ASM using rman.
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 ...
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 ...
"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