User contributions

(newest | oldest) View (newer 250 | older 250) (20 | 50 | 100 | 250 | 500)

• 20:32, 26 October 2020 (diff | hist) . . (+7,139)‎ . . N Real Time Statistics ‎ (Created page with "<pre> Introduction ======= Oracle Database 19c introduces real-time statistics, which extends online statistics gathering to also include conventional DML statements. Statist...") (current)
• 20:31, 26 October 2020 (diff | hist) . . (+31)‎ . . Oracle 19c New Features ‎ (current)
• 18:13, 26 October 2020 (diff | hist) . . (+4,651)‎ . . N High Frequency Automatic Statistics Job ‎ (Created page with "<pre> Introduction ======= • The automatic optimizer statistics collection job which calls DBMS_STATS package runs in predefined maintenance windows and these maintenance wi...") (current)
• 18:12, 26 October 2020 (diff | hist) . . (+50)‎ . . Oracle 19c New Features ‎
• 14:51, 25 October 2020 (diff | hist) . . (+4,082)‎ . . N Create an application container and application ‎ (Created page with "<pre> Introduction ======== Oracle 12.2 introduces the concept of application containers, which act like a mini-root container. They can be used to centralize shared configur...") (current)
• 14:50, 25 October 2020 (diff | hist) . . (+58)‎ . . Oracle Multitenant ‎ (current)
• 09:54, 18 October 2020 (diff | hist) . . (+961)‎ . . Create a refreshable PDB clone and switchover ‎ (current)
• 09:52, 18 October 2020 (diff | hist) . . (+362)‎ . . N Create a refreshable PDB clone and switchover ‎ (Created page with "__TOC__ From Oracle Database 12.2 onward it is possible to refresh the contents of a remotely hot cloned PDB provided it is created as a refreshable PDB and has only ever been...")
• 08:53, 18 October 2020 (diff | hist) . . (+607)‎ . . Create a PDB snapshot carousel ‎ (→‎Example 2 create an automatic PDB snapshot carousel) (current)
• 08:52, 18 October 2020 (diff | hist) . . (+25)‎ . . Create a PDB snapshot carousel ‎ (→‎Introduction)
• 08:51, 18 October 2020 (diff | hist) . . (+558)‎ . . Create a PDB snapshot carousel ‎ (→‎Example 1 create a manual snapshot and create a new PDB from that snapshot)
• 08:50, 18 October 2020 (diff | hist) . . (-1)‎ . . Create a PDB snapshot carousel ‎ (→‎Example 1 create a manual snapshot and create a new PDB from that snapshot)
• 08:49, 18 October 2020 (diff | hist) . . (+1,847)‎ . . N Create a PDB snapshot carousel ‎ (Created page with "__TOC__ == Introduction == This feature allows you to make instant snapshot copies of the Pluggable Database (PDB) and keep them in an external binnacle. A PDB snapshot is an...")
• 08:47, 18 October 2020 (diff | hist) . . (+125)‎ . . N Oracle Multitenant ‎ (Created page with "create a PDB snapshot carousel<br /> create a refreshable PDB clone and switchover<br /> manage a CDB Fleet<br />")
• 08:45, 18 October 2020 (diff | hist) . . (+48)‎ . . Oracle Database ‎ (current)
• 07:21, 8 October 2020 (diff | hist) . . (0)‎ . . Oracle Dictionary ‎ (→‎S) (current)
• 07:21, 8 October 2020 (diff | hist) . . (+1,170)‎ . . Oracle Dictionary ‎ (→‎S)
• 18:19, 6 October 2020 (diff | hist) . . (+1,476)‎ . . GGSCI Utility ‎ (→‎View the GG replication status) (current)
• 18:18, 6 October 2020 (diff | hist) . . (+441)‎ . . GGSCI Utility ‎ (→‎configure supplemental logging)
• 18:03, 6 October 2020 (diff | hist) . . (+24)‎ . . Oracle Utilities ‎ (current)
• 06:31, 6 October 2020 (diff | hist) . . (+886)‎ . . Container Maps ‎ (→‎Synchronize the PDB and add data to the table) (current)
• 06:29, 6 October 2020 (diff | hist) . . (+850)‎ . . Container Maps ‎ (→‎Create an application in the application root that uses the container map)
• 06:27, 6 October 2020 (diff | hist) . . (+6)‎ . . Container Maps ‎ (→‎Create an application in the application root that uses the container map)
• 06:27, 6 October 2020 (diff | hist) . . (+1,120)‎ . . Container Maps ‎ (→‎Create the Container Map)
• 06:25, 6 October 2020 (diff | hist) . . (+926)‎ . . Container Maps ‎ (→‎Create the Application PDBs)
• 06:23, 6 October 2020 (diff | hist) . . (+1,081)‎ . . Container Maps ‎ (→‎Create the application root)
• 06:21, 6 October 2020 (diff | hist) . . (-21)‎ . . Container Maps ‎ (→‎Create the application root and application PDBs)
• 06:21, 6 October 2020 (diff | hist) . . (-53)‎ . . Container Maps ‎ (→‎Introduction)
• 06:20, 6 October 2020 (diff | hist) . . (+1,534)‎ . . N Container Maps ‎ (Created page with "__TOC__ == Introduction == In Oracle Database version 12.1.0.2 Oracle introduced the “CONTAINERS” clause, a very useful clause that can be used to execute queries across...")
• 06:15, 6 October 2020 (diff | hist) . . (+72)‎ . . N Partitioning Enhancements ‎ (Created page with "Converting non partitioned tables to partitioned tables online<br />") (current)
• 06:15, 6 October 2020 (diff | hist) . . (+115)‎ . . N New Features for Datawarehousing and partitioning ‎ (Created page with "Partitioning Enhancements<br /> Partitioning External Tables<br /> Materialized View Enhancements<br />") (current)
• 06:14, 6 October 2020 (diff | hist) . . (0)‎ . . Oracle 12cR2 New Features ‎ (current)
• 06:13, 6 October 2020 (diff | hist) . . (+141)‎ . . N New Features for Utilities and Scheduling ‎ (Created page with "Oracle Datapump Parallel Metadata Management<br /> External Table Access Driver Improvements<br /> In Memory Scheduler Jobs<br />") (current)
• 06:12, 6 October 2020 (diff | hist) . . (+193)‎ . . N New Features for Developers ‎ (Created page with "Cast<br /> Validate_Conversion<br /> Listagg<br /> Approximate query processing<br /> Identifier Length Changes<br /> New Views: DBA_STATEMENTS and DBA_I...") (current)
• 06:10, 6 October 2020 (diff | hist) . . (+4)‎ . . New Features for Compression and Archiving ‎ (current)
• 06:10, 6 October 2020 (diff | hist) . . (+142)‎ . . N New Features for Compression and Archiving ‎ (Created page with "NFS Server in the database<br /> Advanced Index compression enhancements<br /> [[Improvements to Hybrid Columnar Compression (HCC)<br />")
• 06:09, 6 October 2020 (diff | hist) . . (+148)‎ . . N New Features for Performance ‎ (Created page with "Monitoring Index Usage enhancements<br /> Statistics Advisor<br /> In-Memory Advisor enhancements<br /> Per-Process PGA limits<br />") (current)
• 06:07, 6 October 2020 (diff | hist) . . (+207)‎ . . N New Features for Multitenant ‎ (Created page with "Local Undo<br /> PDB Lockdown Profiles<br /> Application Containers<br /> New Features for Creating, Cloning and Moving PDB<br /> Container Maps<br /> Mi...") (current)
• 06:06, 6 October 2020 (diff | hist) . . (+265)‎ . . N New Features for Security ‎ (Created page with "Encryption and Redaction enhancements<br /> Database Vault enhancements<br /> Unified Auditing enhancements<br /> Privilege Analysis enhancements<br /> Separ...") (current)
• 06:04, 6 October 2020 (diff | hist) . . (+72)‎ . . N New Features for Datawarehousing adn partitioning ‎ (Created page with "Converting non partitioned tables to partitioned tables online<br />") (current)
• 06:04, 6 October 2020 (diff | hist) . . (+24)‎ . . New Features for High Availability ‎ (current)
• 06:04, 6 October 2020 (diff | hist) . . (+137)‎ . . N New Features for High Availability ‎ (Created page with "Restart online table definition after failure Cluster resource activity log Flex ASM Disk Group Quota Management Sharding")
• 06:02, 6 October 2020 (diff | hist) . . (+229)‎ . . N New Features for RMAN ‎ (Created page with "Table Recovery Enhancements<br /> Cross-Platform Transport via RMAN<br /> RMAN Duplicate TDE Tablespace<br /> [[Backup and Recovery of Sparse Databases on Exadata]...") (current)
• 06:01, 6 October 2020 (diff | hist) . . (+112)‎ . . Oracle 12cR2 New Features ‎
• 05:59, 6 October 2020 (diff | hist) . . (+136)‎ . . Oracle 12cR2 New Features ‎
• 05:58, 6 October 2020 (diff | hist) . . (-1)‎ . . Oracle 12cR2 New Features ‎
• 05:57, 6 October 2020 (diff | hist) . . (-12)‎ . . High Availability New Features ‎ (current)
• 05:55, 6 October 2020 (diff | hist) . . (+234)‎ . . N High Availability New Features ‎ (Created page with "RESTART ONLINE TABLE DEFINITION AFTER FAILURE<br /> CONVERTING NON PARTITIONED TABLES TO PARTITIONED TABLES ONLINE<br /> CLUSTER RESOURCE ACTIVITY LOG<br /> FLEX...")
• 05:54, 6 October 2020 (diff | hist) . . (+41)‎ . . Oracle 12cR2 New Features ‎
• 05:53, 6 October 2020 (diff | hist) . . (+50)‎ . . Multitenant New Features ‎ (current)
• 05:44, 6 October 2020 (diff | hist) . . (-60)‎ . . Oracle New Features per version ‎ (current)
• 16:37, 4 October 2020 (diff | hist) . . (+41)‎ . . Local Undo ‎ (→‎Local Undo Concept) (current)
• 16:36, 4 October 2020 (diff | hist) . . (+595)‎ . . Local Undo ‎ (→‎Change from shared to local undo)
• 16:35, 4 October 2020 (diff | hist) . . (+270)‎ . . Local Undo ‎
• 16:32, 4 October 2020 (diff | hist) . . (+688)‎ . . N Local Undo ‎ (Created page with "<pre> COLUMN property_name FORMAT A30 COLUMN property_value FORMAT A30 SELECT property_name, property_value FROM database_properties WHERE property_name = 'LOCAL_UNDO_ENAB...")
• 16:31, 4 October 2020 (diff | hist) . . (+21)‎ . . Multitenant New Features ‎
• 09:55, 4 October 2020 (diff | hist) . . (+1,109)‎ . . Application Containers ‎ (→‎Synchronize the changes in the Application Containers) (current)
• 09:52, 4 October 2020 (diff | hist) . . (+1,345)‎ . . Application Containers ‎ (→‎Update the Application)
• 09:51, 4 October 2020 (diff | hist) . . (+985)‎ . . Application Containers ‎ (→‎Create an Application Seed (optional))
• 08:53, 4 October 2020 (diff | hist) . . (+844)‎ . . Application Containers ‎ (→‎Create an application PDB)
• 08:50, 4 October 2020 (diff | hist) . . (+662)‎ . . Application Containers ‎ (→‎Create an application inside the Application Root)
• 08:49, 4 October 2020 (diff | hist) . . (+1,159)‎ . . Application Containers ‎ (→‎Create the Application Root)
• 08:48, 4 October 2020 (diff | hist) . . (+1)‎ . . Application Containers ‎
• 08:47, 4 October 2020 (diff | hist) . . (+599)‎ . . N Application Containers ‎ (Created page with "_TOC__ == Introduction == Oracle 12.2 introduces the concept of application containers, which act like a mini-root container. They can be used to centralize shared configurati...")
• 08:46, 4 October 2020 (diff | hist) . . (+33)‎ . . Multitenant New Features ‎
• 08:34, 4 October 2020 (diff | hist) . . (+49)‎ . . Multitenant New Features ‎
• 08:24, 4 October 2020 (diff | hist) . . (+499)‎ . . Multitentant miscellaneous New Features ‎ (→‎Parallel PDB Creation) (current)
• 08:17, 4 October 2020 (diff | hist) . . (+131)‎ . . Multitentant miscellaneous New Features ‎ (→‎Number of PDB)
• 08:15, 4 October 2020 (diff | hist) . . (+115)‎ . . N Multitentant miscellaneous New Features ‎ (Created page with "__TOC__ == Number of PDB == In 12cR1 you can have up to 255 PDB, in 12cR2 you can have up to 4096 PDB per Container")
• 08:14, 4 October 2020 (diff | hist) . . (+49)‎ . . N Multitenant New Features ‎ (Created page with "Multitentant miscellaneous New Features<br />")
• 08:13, 4 October 2020 (diff | hist) . . (0)‎ . . Oracle 12cR2 New Features ‎
• 12:48, 3 October 2020 (diff | hist) . . (-2)‎ . . Oracle Complete Recipes ‎ (current)
• 12:48, 3 October 2020 (diff | hist) . . (-36)‎ . . Oracle Complete Recipes ‎
• 07:56, 25 September 2020 (diff | hist) . . (+555)‎ . . GGSCI Utility ‎ (→‎configure supplemental logging)
• 07:52, 25 September 2020 (diff | hist) . . (+320)‎ . . N GGSCI Utility ‎ (Created page with "__TOC__ == configure supplemental logging == <pre> GGSCI (rob01db01.robdomain as c##/CDB$ROOT) 23> info trandata pdb4.robla.rl_objects GGSCI (rob01db01.robdomain as c##/CD...")
• 07:42, 25 September 2020 (diff | hist) . . (+24)‎ . . Oracle Golden Gate ‎ (current)
• 17:05, 20 September 2020 (diff | hist) . . (0)‎ . . Oracle Complete Recipes ‎
• 17:04, 20 September 2020 (diff | hist) . . (+146)‎ . . Oracle Complete Recipes ‎
• 17:02, 20 September 2020 (diff | hist) . . (-4)‎ . . Oracle Complete Recipes ‎
• 08:25, 11 March 2020 (diff | hist) . . (+2)‎ . . Oracle Dictionary ‎ (→‎L)
• 08:25, 11 March 2020 (diff | hist) . . (+323)‎ . . Oracle Dictionary ‎ (→‎O)
• 19:19, 5 March 2020 (diff | hist) . . (+160)‎ . . Oracle Dictionary ‎ (→‎D)
• 16:18, 5 March 2020 (diff | hist) . . (+527)‎ . . Cursor loop example 1: until end of table ‎ (→‎Example 3: create public synonyms in a loop) (current)
• 11:17, 5 March 2020 (diff | hist) . . (+7)‎ . . Oracle Administration Manage Database Auditing (traditional) ‎ (→‎= Check the user audit trail for the last 100 failed logon attempts in which a wrong password was provided) (current)
• 11:17, 5 March 2020 (diff | hist) . . (+303)‎ . . Oracle Administration Manage Database Auditing (traditional) ‎ (→‎Check the user logon audit trail)
• 09:34, 29 February 2020 (diff | hist) . . (+23)‎ . . Oracle Configuration : Oracle Patches ‎ (→‎Oracle Release Updates (RU) and Release Update Revisions (RUR)) (current)
• 09:33, 29 February 2020 (diff | hist) . . (+272)‎ . . Oracle Configuration : Oracle Patches ‎ (→‎What is a Release Update (RU) ?)
• 09:30, 29 February 2020 (diff | hist) . . (+192)‎ . . Oracle Configuration : Oracle Patches ‎ (→‎Patch Set Updates versus Bundle Patch)
• 09:27, 29 February 2020 (diff | hist) . . (+173)‎ . . Oracle Configuration : Oracle Patches ‎ (→‎Oracle Release Updates (RU) and Release Update Revisions (RUR))
• 09:25, 29 February 2020 (diff | hist) . . (0)‎ . . Oracle Configuration : Oracle Patches ‎
• 09:25, 29 February 2020 (diff | hist) . . (+303)‎ . . Oracle Configuration : Oracle Patches ‎ (→‎Patch Set Updates versus Bundle Patch)
• 09:23, 29 February 2020 (diff | hist) . . (+354)‎ . . Oracle Configuration : Oracle Patches ‎ (→‎Patch Set Updates versus Bundle Patch)
• 09:22, 29 February 2020 (diff | hist) . . (-9)‎ . . Oracle Configuration : Oracle Patches ‎ (→‎Patch Set Updates versus Bundle Patch)
• 09:22, 29 February 2020 (diff | hist) . . (+326)‎ . . N Oracle Configuration : Oracle Patches ‎ (Created page with "__TOC__ == Patch Set Updates versus Bundle Patch == * A Patch Set Update (PSU) contains usually security fixes and regression fixes, i.e. bug fixes. * Whereas a Proactive Bu...")
• 09:21, 29 February 2020 (diff | hist) . . (+48)‎ . . Oracle Administration ‎ (current)
• 17:20, 25 February 2020 (diff | hist) . . (+3)‎ . . NULL values ‎ (current)
• 17:20, 25 February 2020 (diff | hist) . . (+277)‎ . . NULL values ‎ (→‎Null values and indexes)
• 17:19, 25 February 2020 (diff | hist) . . (+2,749)‎ . . N NULL values ‎ (Created page with "__TOC__ == Introduction A NULL value in databases is a systemvalue that takes up one byte ofstorage and indicates that a value isnot present as opposed to a space orzero or an...")
• 17:18, 25 February 2020 (diff | hist) . . (+22)‎ . . Data Modelling ‎ (current)
• 09:35, 25 February 2020 (diff | hist) . . (+1,602)‎ . . N UGA versus PGA ‎ (Created page with "So a connection a made when a client process sends a request to the server process and server process reverts back in establishing the session. But this happens in Dedicated S...") (current)
• 09:35, 25 February 2020 (diff | hist) . . (+25)‎ . . Database Memory Structures ‎ (current)
• 10:28, 24 February 2020 (diff | hist) . . (+218)‎ . . Datapump (export and import database objects) ‎ (→‎Export Database Links of multiple Schemas) (current)
• 10:03, 24 February 2020 (diff | hist) . . (+11)‎ . . Datapump (export and import database objects) ‎ (→‎Export a Schema, but only the tables)
• 10:03, 24 February 2020 (diff | hist) . . (+180)‎ . . Datapump (export and import database objects) ‎ (→‎Export and Import a Schema)
• 20:52, 22 February 2020 (diff | hist) . . (+223)‎ . . N Use large pages ‎ (Created page with "Whether or not the database (SGA) uses large page memory upon startup * FALSE * TRUE : use if possible, otherwise use normal memory * ONLY: use and if not available, do not st...") (current)
• 20:50, 22 February 2020 (diff | hist) . . (+26)‎ . . Oracle Database Parameters ‎ (→‎Parameters) (current)
• 22:12, 21 February 2020 (diff | hist) . . (+199)‎ . . SQL Process Flow ‎ (→‎Step 1 Statement is parsed) (current)
• 22:08, 21 February 2020 (diff | hist) . . (+250)‎ . . SQL Process Flow ‎ (→‎Step 1 Statement is parsed)
• 22:06, 21 February 2020 (diff | hist) . . (+435)‎ . . SQL Process Flow ‎ (→‎Step 1 Statement is parsed)
• 22:03, 21 February 2020 (diff | hist) . . (+18)‎ . . SQL Process Flow ‎ (→‎Step 1 Statement is parsed)
• 22:30, 20 February 2020 (diff | hist) . . (+62)‎ . . SQL Process Flow ‎ (→‎Step 1 Statement is parsed)
• 22:28, 20 February 2020 (diff | hist) . . (+279)‎ . . SQL Process Flow ‎ (→‎Step 1 Statement is parsed)
• 22:24, 20 February 2020 (diff | hist) . . (+489)‎ . . N SQL Process Flow ‎ (Created page with "__TOC__ == Step 1 Statement is parsed == The user issues a statement and the statement is parsed by the database. When an application issues a SQL statement, the application...")
• 22:22, 20 February 2020 (diff | hist) . . (+27)‎ . . Oracle Internals ‎ (current)
• 22:21, 20 February 2020 (diff | hist) . . (+816)‎ . . N Undo versus Redo ‎ (Created page with "Oracle uses UNDO to undo changes and to keep a read consistent image of block. UNDO holds a copy of previous data until the transaction commits and for some time afterwards (d...") (current)
• 22:18, 20 February 2020 (diff | hist) . . (+27)‎ . . Oracle Internals ‎
• 22:16, 20 February 2020 (diff | hist) . . (+31)‎ . . N Database Memory Structures ‎ (Created page with "Database Buffer Cache<br />")
• 22:16, 20 February 2020 (diff | hist) . . (-32)‎ . . Oracle Internals ‎
• 22:15, 20 February 2020 (diff | hist) . . (+37)‎ . . Oracle Internals ‎
• 10:02, 14 February 2020 (diff | hist) . . (+372)‎ . . List database collation ‎ (current)
• 09:56, 14 February 2020 (diff | hist) . . (+104)‎ . . N List database collation ‎ (Created page with "<pre> SELECT CONVERT (varchar(256), SERVERPROPERTY('collation')); SQL_Latin1_General_CP1_CI_AS </pre>")
• 09:55, 14 February 2020 (diff | hist) . . (+58)‎ . . SQLServer Metadata Queries ‎ (current)
• 08:26, 14 February 2020 (diff | hist) . . (+518)‎ . . N SQL and PL/SQL Enhancements ‎ (Created page with "__TOC__ == DML Enhancements == === Row Pattern Matching === Pattern matching provides the ability to recognize patterns in a sequence of rows in a projection, called the row...") (current)
• 08:22, 14 February 2020 (diff | hist) . . (+38)‎ . . Oracle 12c New Features ‎ (current)
• 14:05, 13 February 2020 (diff | hist) . . (-137)‎ . . Private Temporary Tables ‎ (→‎Create a Private Temporay Table) (current)
• 14:04, 13 February 2020 (diff | hist) . . (+296)‎ . . Private Temporary Tables ‎ (→‎Create a Private Temporay Table)
• 14:01, 13 February 2020 (diff | hist) . . (+540)‎ . . Private Temporary Tables ‎ (→‎Introduction)
• 13:58, 13 February 2020 (diff | hist) . . (+697)‎ . . N Private Temporary Tables ‎ (Created page with "__TOC__ == Introduction == Oracle 18c introduced the concept of a private temporary table, a memory-based temporary table that is dropped at the end of the session or transac...")
• 13:57, 13 February 2020 (diff | hist) . . (+60)‎ . . N General Enhancements ‎ (Created page with "Private Temporary Tables<br />") (current)
• 13:57, 13 February 2020 (diff | hist) . . (+30)‎ . . N Oracle 18c New Features ‎ (Created page with "General Enhancements<br />") (current)
• 13:57, 13 February 2020 (diff | hist) . . (+31)‎ . . Oracle 12c New Features ‎
• 08:28, 13 February 2020 (diff | hist) . . (+237)‎ . . Dataguard Enhancements ‎ (→‎Cascaded Redo Transport Destinations) (current)
• 08:26, 13 February 2020 (diff | hist) . . (+1,889)‎ . . N Dataguard Enhancements ‎ (Created page with "__TOC__ == SYSDG Privilege == This new privilege is used to handle Oracle Dataguard administrative duties. This privilege provides only the minimum privilege level required t...")
• 14:57, 11 February 2020 (diff | hist) . . (+1,044)‎ . . Oracle Administration Manage Database Links ‎ (→‎Change a database link password) (current)
• 12:14, 11 February 2020 (diff | hist) . . (+359)‎ . . Datapump (export and import database objects) ‎ (→‎Export Database Links of multiple Schemas)
• 11:08, 11 February 2020 (diff | hist) . . (+159)‎ . . Datapump (export and import database objects) ‎ (→‎Generate SQL File from export file)
• 11:02, 11 February 2020 (diff | hist) . . (+195)‎ . . Datapump (export and import database objects) ‎ (→‎Export Database Links of multiple Schemas)
• 09:38, 11 February 2020 (diff | hist) . . (+116)‎ . . Oracle Administration Manage Database Links ‎ (→‎View current database links)
• 09:36, 11 February 2020 (diff | hist) . . (+4,394)‎ . . N Admin check dblinks.sql ‎ (Created page with "This scripts lists the database links and checks the status of the links. <br /><br /> Sample output: <pre> *** list of available database links *** OWNER DB_LINK...") (current)
• 09:34, 11 February 2020 (diff | hist) . . (+1)‎ . . Oracle Scripts ‎ (current)
• 09:33, 11 February 2020 (diff | hist) . . (+121)‎ . . Oracle Scripts ‎
• 08:17, 11 February 2020 (diff | hist) . . (+758)‎ . . RMAN Miscellaneous New Features ‎ (→‎Sysbackup privilege) (current)
• 08:12, 11 February 2020 (diff | hist) . . (+698)‎ . . N RMAN Miscellaneous New Features ‎ (Created page with "__TOC__ == SQL Commands for the RMAN prompt == You can now execute SQL statements from the RMAN prompt. You no longer need to prefix the SQL Command and you do not need to enc...")
• 08:08, 11 February 2020 (diff | hist) . . (+74)‎ . . RMAN Enhancements ‎ (current)
• 08:07, 11 February 2020 (diff | hist) . . (+33)‎ . . Oracle 12c New Features ‎
• 14:58, 10 February 2020 (diff | hist) . . (+682)‎ . . JSON INFO ‎ (→‎Rules for JSON syntax) (current)
• 14:56, 10 February 2020 (diff | hist) . . (+170)‎ . . JSON INFO ‎ (→‎Features of JSON)
• 14:54, 10 February 2020 (diff | hist) . . (+701)‎ . . JSON INFO ‎ (→‎Why use JSON ?)
• 14:41, 10 February 2020 (diff | hist) . . (+608)‎ . . JSON INFO ‎ (→‎JSON snippet)
• 14:39, 10 February 2020 (diff | hist) . . (+944)‎ . . N JSON INFO ‎ (Created page with "__TOC__ == Introduction == For a while, XML (extensible markup language) was the only choice for open data interchange. But over the years there has been a lot of transformati...")
• 14:35, 10 February 2020 (diff | hist) . . (+282)‎ . . Oracle Dictionary ‎ (→‎O)
• 10:42, 10 February 2020 (diff | hist) . . (+47)‎ . . N RMAN Enhancements ‎ (Created page with "RMAN Restore Table<br />")
• 10:42, 10 February 2020 (diff | hist) . . (+58)‎ . . Oracle 12cR2 New Features ‎
• 10:38, 10 February 2020 (diff | hist) . . (+1,897)‎ . . N SQL Quarantine ‎ (Created page with "__TOC__ == Introduction == This feature is only available for Exadata (Oracle Database Enterprise Edition on Engineered Systems) and DBCS/ExaCS (Oracle Database Exadata Cloud...") (current)
• 10:20, 10 February 2020 (diff | hist) . . (+39)‎ . . N Oracle 19c New Features ‎ (Created page with "SQL Quarantine<br />")
• 10:19, 10 February 2020 (diff | hist) . . (+116)‎ . . Oracle New Features per version ‎
• 10:11, 10 February 2020 (diff | hist) . . (-22)‎ . . Oracle 12c New Features ‎
• 10:10, 10 February 2020 (diff | hist) . . (+126)‎ . . Oracle 12c New Features ‎
• 10:10, 10 February 2020 (diff | hist) . . (-126)‎ . . Oracle Database ‎
• 10:09, 10 February 2020 (diff | hist) . . (+121)‎ . . N Oracle New Features per version ‎ (Created page with "Oracle 12cR1 New Features<br /> Oracle 12cR2 New Features<br />")
• 10:09, 10 February 2020 (diff | hist) . . (-122)‎ . . Oracle Database ‎
• 10:08, 10 February 2020 (diff | hist) . . (+6)‎ . . Oracle Database ‎
• 10:07, 10 February 2020 (diff | hist) . . (+75)‎ . . Oracle Database ‎
• 10:06, 10 February 2020 (diff | hist) . . (+63)‎ . . Oracle 12c New Features ‎
• 09:29, 10 February 2020 (diff | hist) . . (+574)‎ . . Cursor loop example 1: until end of table ‎
• 16:44, 6 February 2020 (diff | hist) . . (+1,122)‎ . . ORA-08177: can't serialize access for this transaction ‎ (→‎Reference) (current)
• 16:29, 6 February 2020 (diff | hist) . . (+842)‎ . . ORA-08177: can't serialize access for this transaction ‎ (→‎Implement the 3rd solution)
• 15:23, 6 February 2020 (diff | hist) . . (+759)‎ . . ORA-08177: can't serialize access for this transaction ‎ (→‎Implement the solution)
• 15:05, 6 February 2020 (diff | hist) . . (+294)‎ . . ORA-08177: can't serialize access for this transaction ‎ (→‎Implement the 3rd solution)
• 15:00, 6 February 2020 (diff | hist) . . (+4,347)‎ . . N Isolation Levels ‎ (Created page with "<pre> ************************************************************* This article is being delivered in Draft form and may contain errors. Please use the MetaLink "Feedback" b...") (current)
• 14:59, 6 February 2020 (diff | hist) . . (+27)‎ . . Oracle Internals ‎
• 14:51, 6 February 2020 (diff | hist) . . (+314)‎ . . ORA-08177: can't serialize access for this transaction ‎ (→‎Explanation)
• 14:49, 6 February 2020 (diff | hist) . . (+215)‎ . . ORA-08177: can't serialize access for this transaction ‎ (→‎Solutions)
• 14:47, 6 February 2020 (diff | hist) . . (+236)‎ . . ORA-08177: can't serialize access for this transaction ‎ (→‎Reproduce the error)
• 14:45, 6 February 2020 (diff | hist) . . (-13)‎ . . ORA-08177: can't serialize access for this transaction ‎ (→‎Reproduce the error)
• 14:45, 6 February 2020 (diff | hist) . . (+346)‎ . . ORA-08177: can't serialize access for this transaction ‎ (→‎Reproduce the error)
• 14:37, 6 February 2020 (diff | hist) . . (+195)‎ . . ORA-08177: can't serialize access for this transaction ‎ (→‎Error Explanation)
• 14:37, 6 February 2020 (diff | hist) . . (+215)‎ . . ORA-08177: can't serialize access for this transaction ‎ (→‎Reproduce the error)
• 14:31, 6 February 2020 (diff | hist) . . (+248)‎ . . ORA-08177: can't serialize access for this transaction ‎ (→‎Reproduce the error)
• 14:23, 6 February 2020 (diff | hist) . . (+83)‎ . . SQLPlus ‎ (→‎Use Bind Variables in SQL Plus) (current)
• 14:21, 6 February 2020 (diff | hist) . . (+166)‎ . . ORA-08177: can't serialize access for this transaction ‎ (→‎Reproduce the error)
• 14:18, 6 February 2020 (diff | hist) . . (+1)‎ . . ORA-08177: can't serialize access for this transaction ‎ (→‎Error Explanation)
• 14:18, 6 February 2020 (diff | hist) . . (+453)‎ . . ORA-08177: can't serialize access for this transaction ‎ (→‎Error Explanation)
• 14:16, 6 February 2020 (diff | hist) . . (+156)‎ . . N ORA-08177: can't serialize access for this transaction ‎ (Created page with "__TOC__ == Reference == My Oracle Support Note : Insert Into Table Fails With ORA-08177 (Doc ID 160593.1) == Error Explanation == == Reproduce the error ==")
• 14:15, 6 February 2020 (diff | hist) . . (+65)‎ . . Oracle Errors and Solutions ‎ (current)
• 09:38, 6 February 2020 (diff | hist) . . (+420)‎ . . N DBMS HM ‎ (Created page with "__TOC__ == Introduction == The Oracle DBA wants to run Health Checks command with Health Monitor upon his database. With Oracle 12c/18c, these checks can be done on a regula...") (current)
• 09:37, 6 February 2020 (diff | hist) . . (+26)‎ . . Oracle Packages ‎ (current)
• 13:02, 1 February 2020 (diff | hist) . . (+392)‎ . . Oracle Dictionary ‎ (→‎C)
• 12:51, 1 February 2020 (diff | hist) . . (+2)‎ . . Oracle Dictionary ‎ (→‎O)
• 12:51, 1 February 2020 (diff | hist) . . (+261)‎ . . Oracle Dictionary ‎ (→‎P)
• 12:50, 1 February 2020 (diff | hist) . . (+733)‎ . . Oracle Dictionary ‎ (→‎I)
• 09:53, 29 January 2020 (diff | hist) . . (+331)‎ . . OUTER JOIN ‎ (current)
• 15:06, 28 January 2020 (diff | hist) . . (+338)‎ . . N DBMS ASSERT ‎ (Created page with "__TOC__ == Introduction == The DBMS_ASSERT package was introduced in Oracle 10g Release 2 and backported to Release 1 in the Oracle October 2005 Critical Patch Update. The pa...") (current)
• 15:05, 28 January 2020 (diff | hist) . . (+34)‎ . . Oracle Packages ‎
• 15:03, 28 January 2020 (diff | hist) . . (+107)‎ . . Oracle Security: SQL Injection ‎ (→‎How to protect against SQL Injection) (current)
• 12:07, 28 January 2020 (diff | hist) . . (+367)‎ . . Rman backup: compression ‎ (→‎Introduction) (current)
• 12:05, 28 January 2020 (diff | hist) . . (+467)‎ . . Rman backup: compression ‎ (→‎How to perform a compressed backup)
• 12:00, 28 January 2020 (diff | hist) . . (+1,238)‎ . . N Rman backup: compression ‎ (Created page with "__TOC__ == Introduction == There are 4 levels of compression for rman: BASIC, LOW, MEDIUM and HIGH. BASIC is free and the others require the "Advanced Compression" license. =...")
• 11:55, 28 January 2020 (diff | hist) . . (+60)‎ . . Oracle Backup & Recovery ‎ (current)
• 11:46, 28 January 2020 (diff | hist) . . (+251)‎ . . Oracle Dictionary ‎ (→‎I)
• 11:46, 28 January 2020 (diff | hist) . . (-250)‎ . . Oracle Dictionary ‎ (→‎D)
• 11:45, 28 January 2020 (diff | hist) . . (+658)‎ . . Oracle Dictionary ‎ (→‎P)
• 11:45, 28 January 2020 (diff | hist) . . (-657)‎ . . Oracle Dictionary ‎ (→‎D)
• 11:45, 28 January 2020 (diff | hist) . . (+94)‎ . . Oracle Dictionary ‎ (→‎R)
• 11:44, 28 January 2020 (diff | hist) . . (+1,560)‎ . . N More copy on write ‎ (Created page with "There are two very different ways to create snapshots: copy-on-write and redirect-on-write. <br /> What all snapshot types have in common is that they are virtual copies not p...") (current)
• 11:42, 28 January 2020 (diff | hist) . . (-1,609)‎ . . Oracle Dictionary ‎ (→‎C)
• 11:41, 28 January 2020 (diff | hist) . . (+1,724)‎ . . Oracle Dictionary ‎ (→‎C)
• 10:56, 28 January 2020 (diff | hist) . . (+260)‎ . . Oracle Security: SQL Injection ‎ (→‎How does SQL Injection take place?)
• 10:55, 28 January 2020 (diff | hist) . . (+157)‎ . . Oracle Security: SQL Injection ‎ (→‎How does SQL Injection take place?)
• 09:56, 28 January 2020 (diff | hist) . . (+456)‎ . . Oracle Security: SQL Injection ‎ (→‎How does SQL Injection take place?)
• 09:46, 28 January 2020 (diff | hist) . . (+491)‎ . . Oracle Security: SQL Injection ‎ (→‎How does SQL Injection take place?)
• 09:01, 28 January 2020 (diff | hist) . . (+1)‎ . . Oracle Security: SQL Injection ‎ (→‎How does SQL Injection take place?)
• 09:00, 28 January 2020 (diff | hist) . . (0)‎ . . Oracle Security: SQL Injection ‎ (→‎How does SQL Injection take place?)
• 09:00, 28 January 2020 (diff | hist) . . (+91)‎ . . Oracle Security: SQL Injection ‎ (→‎How does SQL Injection take place?)
• 08:49, 28 January 2020 (diff | hist) . . (+236)‎ . . Oracle Security: SQL Injection ‎ (→‎How does SQL Injection take place?)
• 08:44, 28 January 2020 (diff | hist) . . (+558)‎ . . N Oracle Security: SQL Injection ‎ (Created page with "__TOC__ == What is SQL Injection ? == SQL injection is a technique to maliciously exploit applications that use client-supplied data in SQL statements. Attackers trick the SQ...")
• 08:42, 28 January 2020 (diff | hist) . . (+72)‎ . . Oracle Administration ‎
• 11:19, 27 January 2020 (diff | hist) . . (+222)‎ . . Oracle Dictionary ‎ (→‎S)
• 15:11, 24 January 2020 (diff | hist) . . (+268)‎ . . Oracle Dictionary ‎ (→‎R)
• 10:32, 24 January 2020 (diff | hist) . . (+29)‎ . . ORA-23622: Operation SYS.DBMS STREAMS ADM.MAINTAIN CHANGE TABLE is in progress. ‎ (→‎Solution II) (current)
• 10:15, 24 January 2020 (diff | hist) . . (+406)‎ . . ORA-23622: Operation SYS.DBMS STREAMS ADM.MAINTAIN CHANGE TABLE is in progress. ‎ (→‎Solution II)
• 10:06, 24 January 2020 (diff | hist) . . (+782)‎ . . ORA-23622: Operation SYS.DBMS STREAMS ADM.MAINTAIN CHANGE TABLE is in progress. ‎ (→‎Solution)
• 09:40, 24 January 2020 (diff | hist) . . (+574)‎ . . N ORA-23622: Operation SYS.DBMS STREAMS ADM.MAINTAIN CHANGE TABLE is in progress. ‎ (Created page with "__TOC__ == Analysis == This error most likely happens when you use Oracle Streams and when an error occurred, for example when you set up a streams configuration and have mad...")
• 09:37, 24 January 2020 (diff | hist) . . (+90)‎ . . Oracle Errors and Solutions ‎
• 16:40, 23 January 2020 (diff | hist) . . (-11)‎ . . Circular references ‎ (current)
• 16:39, 23 January 2020 (diff | hist) . . (+262)‎ . . Circular references ‎
• 12:46, 23 January 2020 (diff | hist) . . (+249)‎ . . N Circular references ‎ (Created page with "__TOC__ A circular reference is a series of references where the last object references the first, resulting in a closed loop. <pre> A => B => C => A </pre> You can prevent c...")
• 12:44, 23 January 2020 (diff | hist) . . (+30)‎ . . Logical Datamodel ‎ (current)
• 10:07, 21 January 2020 (diff | hist) . . (+424)‎ . . RDA ‎ (→‎Step 6 Collect the required information) (current)
• 10:05, 21 January 2020 (diff | hist) . . (+3,969)‎ . . RDA ‎ (→‎Step 6 Collect the required information)
• 09:43, 21 January 2020 (diff | hist) . . (+1,820)‎ . . RDA ‎ (→‎Step 6 Collect the required information)
• 09:41, 21 January 2020 (diff | hist) . . (+3,070)‎ . . RDA ‎ (→‎Step 6 Collect the required information)
• 09:33, 21 January 2020 (diff | hist) . . (+380)‎ . . RDA ‎ (→‎Step 6 Collect the required information)
• 09:31, 21 January 2020 (diff | hist) . . (+43)‎ . . RDA ‎ (→‎Step 5 Check which modules and profiles are available)
• 09:31, 21 January 2020 (diff | hist) . . (+494)‎ . . RDA ‎ (→‎Step 5 Check which modules are available)
• 09:27, 21 January 2020 (diff | hist) . . (+417)‎ . . RDA ‎ (→‎Step 4 Check the installation)
• 09:26, 21 January 2020 (diff | hist) . . (-61)‎ . . RDA ‎ (→‎Step 3 Unzip the RDA zip file)
• 09:26, 21 January 2020 (diff | hist) . . (-30)‎ . . RDA ‎ (→‎Step 2 Check the current perl version)
• 09:21, 21 January 2020 (diff | hist) . . (+319)‎ . . RDA ‎ (→‎Step 3 Unzip the RDA zip file)
• 09:12, 21 January 2020 (diff | hist) . . (+92)‎ . . RDA ‎ (→‎Step 3 Unzip the RDA zip file)
• 09:11, 21 January 2020 (diff | hist) . . (+233)‎ . . RDA ‎ (→‎Step 2 Check the current perl version)
• 09:10, 21 January 2020 (diff | hist) . . (+449)‎ . . RDA ‎ (→‎Step 1 Download RDA)
• 09:06, 21 January 2020 (diff | hist) . . (+66)‎ . . RDA ‎ (→‎References)
• 09:06, 21 January 2020 (diff | hist) . . (+191)‎ . . RDA ‎ (→‎Introduction)
• 09:04, 21 January 2020 (diff | hist) . . (+1,028)‎ . . N RDA ‎ (Created page with "__TOC__ == References == * Note 314422.1 "Remote Diagnostic Agent (RDA) 4.0 - Overview" * Note 330363.1 "Remote Diagnostic Agent (RDA) 4 - FAQ" * Note 330344.1 "Remote Diag...")
• 09:02, 21 January 2020 (diff | hist) . . (+42)‎ . . Oracle Utilities ‎
• 15:14, 17 January 2020 (diff | hist) . . (+113)‎ . . N REST API ‎ (Created page with "__TOC__ == Introduction == REST API stands for representational state transfer Application Programming Interface.") (current)
• 15:13, 17 January 2020 (diff | hist) . . (+25)‎ . . Data Modelling ‎
• 15:12, 17 January 2020 (diff | hist) . . (+36)‎ . . Data Modelling ‎
• 09:02, 17 January 2020 (diff | hist) . . (+286)‎ . . Primary keys: Natural versus Surrogate Keys ‎ (→‎Surrogate Key : Pros) (current)

(newest | oldest) View (newer 250 | older 250) (20 | 50 | 100 | 250 | 500)