Oracle DBA Articles

Share via:

Oracle DBA Articles

Dear Readers,

Please check below articles to get good knowledge on Oracle DBA.

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
 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

 

Thanks for browsing we will update more…………

Share via:
Note: Please test scripts in Non Prod before trying in Production.
1 Star2 Stars3 Stars4 Stars5 Stars (4 votes, average: 5.00 out of 5)
Loading...

Add Comment