1.
Oracle9i, spfile, alter system
Oracle has replaced the init.ora file because all parameters can now be changed dynamically with the “alter system” commands. ...
2.
Killing Oracle User Processes - Killing sessions from the ...
Essentially, you can issue an ALTER SYSTEM KILL SESSION or you can issue a manual ... The DBA can either issue a series of ALTER SYSTEM commands manually or ...
3.
Correlated Subqueries with the NOT IN Operator - Correlated Non ...
Correlated Subqueries with the NOT EXISTS Operator. Recall that Oracle doesn't consider transforming correlated subqueries that are interfaced via the NOT ...
4.
Oracle SQL CBO Cost-based Optimizer Internal IN EXISTS Correlated ...
Oracle SQL CBO Cost-based Optimizer Internal IN EXISTS Correlated Query Uncorrelated Query EXISTS Predicate NOT EXIST Predicates.
5.
Oracle System Global Area (SGA) - Standardizing SQL And PL/SQL Code
Oracle’s System Global Area ( SGA ) is essentially short-term memory for the database. As the database references data and stored PL/SQL objects, ...
6.
Oracle Export Options
full – The entire Oracle database is exported with a full Oracle export. · grants – [Y] Specifies object grants to Oracle export. ...
7.
Oracle Export Options
full – The entire Oracle database is exported with a full Oracle export. · grants – [Y] Specifies object grants to Oracle export. ...
8.
Unix, RAM page fencing for Oracle, DBA, SGA, swap
The solution for the Oracle DBA is “page fencing”. By marking the SGA as ineligible for swapping ... Today, page fencing is available for Solaris and HP/UX. ...
9.
Oracle Export Options
compress – When “Y”, Oracle export will mark the table to be loaded as one ... tables – Indicates that the type of Oracle export is table-mode and lists the ...
10.
Oracle9i, Locally Managed Tablespaces (LMT) - EXTENT MANAGEMENT ...
'c:\oracle\oradata\diogenes\asm_test.dbf'. size. 5m. EXTENT MANAGEMENT LOCAL. SEGMENT SPACE MANAGEMENT AUTO. ;. In Oracle9i, we expect an error if we try to ...