| SNO |
ARTICLE LINK |
DESCRIPTION |
|
ORACLE ARCHITECTURE ARTICLES |
|
| 1 |
https://www.ktexperts.com/oracle-architecture-1/ |
Oracle log & phy level |
| 2 |
https://www.ktexperts.com/oracle-architecture-2/ |
Oracle server arch |
| 3 |
https://www.ktexperts.com/oracle-architecture-3/ |
Oracle optional background proceeses |
| 4 |
https://www.ktexperts.com/oracle-architecture-4physical-representation-of-database/ |
Physical representation of Oracle database |
| 5 |
https://www.ktexperts.com/how-to-create-new-database-using-rman-backup-pieces/ |
How to Create New database using RMAN backup pieces. |
| 6 |
https://www.ktexperts.com/oracle-database-creation/ |
Oracle : DATABASE CREATION |
| 7 |
https://www.ktexperts.com/oracle-redolog-file-management/ |
Oracle : REDOLOG FILE MANAGEMENT |
| 8 |
https://www.ktexperts.com/oracle-oracle-server-architecture/ |
Oracle : Oracle Server Architecture |
| 9 |
https://www.ktexperts.com/oracle-steps-for-update-statement-process-in-sga/ |
Oracle : Steps for Update Statement Process in SGA |
| 10 |
https://www.ktexperts.com/oracle-steps-for-select-statement-process-in-sga/ |
Oracle : Steps for Select Statement Process in SGA |
| 11 |
https://www.ktexperts.com/oracle-startup-and-shutdown/ |
Oracle : STARTUP and SHUTDOWN |
| 12 |
https://www.ktexperts.com/oracle-spfile-and-pfile/ |
Oracle : SPFILE AND PFILE |
|
|
|
|
|
|
|
ORACLE EXPORTS AND IMPORTS |
|
| 1 |
https://www.ktexperts.com/transportable-tablespace-between-two-pluggable-databasepdbs/ |
Transportable Tablespace between two pluggable database(PDB’s). |
| 2 |
https://www.ktexperts.com/datapump-in-oracle-12c/ |
DATAPUMP IN ORACLE 12c.(Video included) |
| 3 |
https://www.ktexperts.com/how-to-perform-datapump-operations-on-standby-database-by-converting-snapshot-standby/ |
How to perform DATAPUMP operations on standby database by converting snapshot standby. |
| 4 |
https://www.ktexperts.com/oracle-different-options-in-export-and-imports/ |
Oracle: Different options in Export and Imports |
| 5 |
https://www.ktexperts.com/oracle-selective-data-export-from-table-using-expdp-ora-31693-ora-39035-ora-29913/ |
Oracle Selective Data Export from Table using EXPDP (ORA-31693, ORA-39035, ORA-29913) |
|
|
|
|
ORACLE FRAGMENTATION |
|
| 1 |
https://www.ktexperts.com/oracle-checking-fragmentation-in-database/ |
Oracle – Checking Fragmentation in Database |
|
|
|
|
ORACLE MATADATA |
|
| 1 |
https://www.ktexperts.com/oracle-metadata-information/ |
Oracle Metadata information |
| 2 |
https://www.ktexperts.com/how-to-perform-datapump-operations-on-standby-database-by-converting-snapshot-standby/ |
How to perform DATAPUMP operations on standby database by converting snapshot standby. |
| 3 |
https://www.ktexperts.com/difference-bw-common-user-and-local-user-in-oracle-12c/ |
Difference b/w Common user and Local user in Oracle 12c.(Video included) |
| 4 |
https://www.ktexperts.com/transportable-tablespace-between-two-pluggable-databasepdbs/ |
Transportable Tablespace between two pluggable database(PDB’s). |
| 5 |
https://www.ktexperts.com/easy-way-to-perform-transportable-tablespace-across-platforms/ |
Easy way to perform Transportable tablespace across platforms.(Video included) |
|
|
|
|
ORACLE NETWORKING |
|
| 1 |
https://www.ktexperts.com/implementing-replication-concept-using-materialized-views/ |
IMPLEMENTING REPLICATION CONCEPT USING MATERIALIZED VIEWS. |
|
|
|
|
ORACLE PARTITIONING |
|
| 1 |
https://www.ktexperts.com/oracle-high-level-steps-for-partitioning-a-non-partitioned-table-manual-online-redefinition/ |
Oracle : High Level steps for Partitioning a non partitioned table (Manual & Online Redefinition) |
| 2 |
https://www.ktexperts.com/oracle-partitioning-using-online-redefinition-method-which-requires-minimal-downtime/ |
Oracle : Partitioning using online Redefinition method which requires minimal downtime |
| 3 |
https://www.ktexperts.com/partition/ |
Partition |
|
|
|
|
|
|
|
|
|
|
SQL LOADER IN ORACLE 12C |
|
| 1 |
https://www.ktexperts.com/sqlloader-in-oracle-12c/ |
SQL*Loader in Oracle 12c |
|
|
|
|
ORACLE FLASHBACK |
|
| 1 |
https://www.ktexperts.com/oracle_flashback_important_queries/ |
Oracle_Flashback_Important_Queries |
|
|
|
|
ORACLE STATS |
|
| 1 |
https://www.ktexperts.com/oracle-how-to-gather-stats-for-table-where-stats-of-that-table-is-locked/ |
Oracle – How to Gather Stats for Table where stats of that table is locked. |
|
|
|
|
|
|
|
ORACLE TABLESPACE |
|
| 1 |
https://www.ktexperts.com/oracle-storage-management/ |
Oracle : Storage Management |
| 2 |
https://www.ktexperts.com/transportable-tablespace-on-cross-platform/ |
ORACLE: Cross Platform Transportable Tablespace |
| 3 |
https://www.ktexperts.com/oracle-transportable-tablespace-in-oracle/ |
Oracle : TRANSPORTABLE TABLESPACE IN ORACLE |
| 4 |
https://www.ktexperts.com/oracle-tablespace-management/ |
Oracle : TABLESPACE MANAGEMENT |
| 5 |
https://www.ktexperts.com/oracle-query-to-find-how-much-space-can-be-reclaimed-from-each-datafile/ |
Oracle : Query to find how much space can be reclaimed from each datafile |
|
|
|
|
|
|
|
OS COMMANDS FOR DBA’S |
|
| 1 |
https://www.ktexperts.com/oracle-setting-up-oramenu-for-databases/ |
Oracle : Setting up Oramenu for Databases |
| 2 |
https://www.ktexperts.com/oracle-important-osunix-commands-for-dbas-part-2/ |
Oracle : Important OS/Unix Commands for DBA’s – Part 2 |
| 3 |
https://www.ktexperts.com/oracle-home-getting-filled-up-database-going-into-stale-state-part-1-unix-commands/ |
ORACLE : HOME GETTING FILLED UP & DATABASE GOING INTO STALE STATE – Part 1 (Unix Commands) |
|
|
|
|
PATCHING |
|
| 1 |
https://www.ktexperts.com/oracle-backup-of-gi-and-rdbms-home-before-patching/ |
Oracle : Backup of GI and RDBMS home before patching |
|
|
|
|
|
|
|
PERFORMANCE MONITORING |
|
| 1 |
https://www.ktexperts.com/query-issues-ask-questions-to-dev-before-working-on-it/ |
Query Issues (Ask questions to Dev before working on it) |
| 2 |
https://www.ktexperts.com/how-to-generate-explain-plans-in-different-ways/ |
How to generate Explain Plans in different ways |
| 3 |
https://www.ktexperts.com/generating-oracle-awr-reports-on-rac-and-non-rac-dbs/ |
Generating Oracle AWR reports on RAC and Non RAC DB’s |
| 4 |
https://www.ktexperts.com/oracle-change-awr-retention/ |
Oracle : Change AWR Retention |
| 5 |
https://www.ktexperts.com/performance-tuning-in-oracle-part1/ |
Performance Tuning in Oracle – Part1 |
| 6 |
https://www.ktexperts.com/performance-tuning-in-oracle-part2/ |
Performance Tuning in Oracle – Part2 |
| 7 |
https://www.ktexperts.com/performance-tuning-in-oracle-part3/ |
Performance Tuning in Oracle – Part3 |
| 8 |
https://www.ktexperts.com/performance-tuning-part4/ |
Performance Tuning – Part4 |
| 9 |
https://www.ktexperts.com/performance-tuning-part5/ |
Performance Tuning-Part5 |
|
|
|
|
|
|
|
PRODUCTION SUPPORT |
|
| 1 |
https://www.ktexperts.com/how-to-move-or-rename-oracle-home/ |
How to move or rename Oracle Home |
| 2 |
https://www.ktexperts.com/ddl-wait-option-in-oracle/ |
DDL Wait Option in Oracle. |
| 3 |
https://www.ktexperts.com/oracle-important-queries-for-checking-temp-usage/ |
Oracle : Important Queries for Checking Temp Usage. |
| 4 |
https://www.ktexperts.com/oracle-procedure-to-capture-the-tables-row-count-and-actual-table-size/ |
Oracle : Procedure to capture the Tables row count and Actual table size |
| 5 |
https://www.ktexperts.com/oracle-how-to-purge-cursors-related-to-a-single-sql_id-from-library-cache/ |
Oracle : How to Purge CURSORS related to a single SQL_ID from library cache |
| 6 |
https://www.ktexperts.com/oracle-list-all-the-hidden-parameter-and-their-values-simulate-ora-error-in-alert-log/ |
Oracle : List all the hidden parameter and their values – &&&&&& – Simulate ORA error in Alert log |
| 7 |
https://www.ktexperts.com/oracle-how-to-trace-sessions/ |
Oracle : HOW TO TRACE SESSIONS |
| 8 |
https://www.ktexperts.com/oracle-script-for-email-alert-for-blocking-sessions-in-database/ |
Oracle : Script for Email alert for Blocking sessions in Database. |
| 9 |
https://www.ktexperts.com/executing-job-in-background-for-one-sql/ |
Executing job in Background for one sql |
| 10 |
https://www.ktexperts.com/generate-output-in-html/ |
Generate output in HTML |
| 11 |
https://www.ktexperts.com/generate-service-and-db-details-with-one-command-for-n-dbs-on-one-cluster/ |
Generate Service and DB Details with one command for N DB’s on one cluster |
| 12 |
https://www.ktexperts.com/start-all-dbs-using-script/ |
Start All DB’s using script |
| 13 |
https://www.ktexperts.com/simple-script-to-delete-archive-logs/ |
Simple Script to Delete Archive logs |
| 14 |
https://www.ktexperts.com/rman-full-backup/ |
RMAN Full Backup |
|
|
|
|
TABLESPACE MANAGEMENT |
|
| 1 |
https://www.ktexperts.com/tablespace-management-in-oracle/ |
Tablespace Management |
|
|
|
|
|
|
|
|
|
|
USER MANAGEMENT |
|
| 1 |
https://www.ktexperts.com/oracle-user-management/ |
Oracle : USER MANAGEMENT |
|
|
|
|
|
|
|
ORACLE RMAN |
|
|
|
|
| 1 |
https://www.ktexperts.com/oracle-important-queries-for-rman/ |
Oracle : Important Queries for RMAN |
|
|
|
|
ORACLE ASM |
|
|
ARTICLE LINK |
DESCRIPTION |
| 1 |
https://www.ktexperts.com/oracle-rename-disk-label-rac/ |
Oracle : Rename ASM Disk Label in Oracle 12c (RAC) |
| 2 |
https://www.ktexperts.com/oracle-add-asm-disks-to-existing-diskgroup/ |
Oracle : Add ASM Disks to existing Diskgroup (RAC) |
| 3 |
https://www.ktexperts.com/oracle-asm-important-queries/ |
Oracle : ASM Important Queries |
| 4 |
https://www.ktexperts.com/asm-disk-group-performance-summary/ |
ASM Disk Group Performance Summary |
|
ORACLE AUDITING |
|
| 1 |
https://www.ktexperts.com/auditing-in-oracle/ |
Auditing in Oracle |
| 2 |
https://www.ktexperts.com/oracle-types-of-auditing/ |
ORACLE TYPES OF AUDITING |
|
|
|
|
ORACLE DATAGUARD |
|
| 1 |
https://www.ktexperts.com/creating-a-data-guard-physical-standby-environment/ |
ORACLE – Creating a Data Guard Physical Standby environment – PART1 |
| 2 |
https://www.ktexperts.com/oracle-creating-a-data-guard-physical-standby-environment-part2/ |
ORACLE – Creating a Data Guard Physical Standby environment – Part2 |
| 3 |
https://www.ktexperts.com/oracle-physical-standby-database-creation-part-3/ |
ORACLE – Physical Standby Database creation – Part 3 |
| 4 |
https://www.ktexperts.com/oracle-creating-a-data-guard-physical-standby-environment-part4/ |
ORACLE – Creating a Data Guard Physical Standby environment – Part4 |
| 5 |
https://www.ktexperts.com/how-to-perform-datapump-operations-on-standby-database-by-converting-snapshot-standby/ |
How to perform DATAPUMP operations on standby database by converting snapshot standby. |
| 6 |
https://www.ktexperts.com/how-to-re-sync-the-standby-database-with-primary-database-using-an-rman-incremental-backup-from-the-primary-database/ |
How to Re-sync the standby database with primary database using an RMAN incremental backup from the primary database. |
| 7 |
https://www.ktexperts.com/oracle-12c-multitenant-architecture-creating-database-manually/ |
Multi-Tenant Architecture and DB creation |
| 8 |
https://www.ktexperts.com/what-are-the-oracle-12c-pluggable-databases-how-does-a-pluggable-database-work/ |
|
| 9 |
https://www.ktexperts.com/datapump-in-oracle-12c/ |
Datapump on Multitebet |
| 10 |
https://www.ktexperts.com/difference-bw-common-user-and-local-user-in-oracle-12c/ |
Common user Vs Local Users |
| 11 |
https://www.ktexperts.com/how-to-build-active-standby-database-using-rman-duplicate-command-in-12c/ |
Oracle 12c Data Guard |
|
|
|
|
https://www.ktexperts.com/oracle-12c-data-guard-switchover-and-switchback/ |
Switchover and switchback |
|
ORACLE PARAMETER |
|
| 1 |
https://www.ktexperts.com/oracle-comparing-parameter-files-from-two-different-databases/ |
ORACLE :Comparing parameter files from two different databases. |
| 2 |
https://www.ktexperts.com/how-to-deinstall-oracle-software/ |
How to Deinstall Oracle software |
|
|
|
| 3 |
https://www.ktexperts.com/oracle-batch-updates-using-plsql-blocks/ |
Oracle :Batch updates using PLSQL Blocks
|
Loading...
