Dear Readers, Please check the below articles to get good knowledge on Data Pump (Export & Import). SNO Article Name Article Link 1 How to Kill & Trace Datapunp Job https://www.ktexperts.com/how-to-kill-trace-datapunp-job/ 2 How to Generate DDL from existing dumpfile https://www.ktexperts.com/how-to-generate-ddl-from-existing-dumpfile/ 3 How to utilize PARFILE… Read More
Dear Readers, Please check the below articles to get good knowledge on Oracle DataGuard Articles. SNO Article Name Article Link 1 Step By Step Configuration of Oracle DGMGRL Utility https://www.ktexperts.com/step-by-step-configuration-of-oracle-dgmgrl-utility/ 2 Oracle Physical Standby Data guard in 11g https://www.ktexperts.com/oracle-physical-standby-data-guard-in-11g/ 3 Switchover and Switchback in Oracle… Read More
Dear Readers, Please check the below articles to get good knowledge on Oracle Production Support Scripts. SNO Article Name Article Link 1 Oracle : Check Partition Summary More than N Days (60 Days) https://www.ktexperts.com/oracle-partition-check-summary-more-than-n-days-60-days/ 2 UNDO segments not Releasing Space https://www.ktexperts.com/undo-segments-not-releasing-space/ 3 Oracle : How… Read More
Dear Readers, Please check the below articles to get good knowledge on Performance Tuning. SNO Article Name Article Link 1 Autonomous Health Framework https://www.ktexperts.com/autonomous-health-framework/ 2 Oracle: Free Buffer Wait https://www.ktexperts.com/oracle-free-buffer-wait/ 3 Internal mechanism of Buffer Cache https://www.ktexperts.com/internal-mechanism-of-buffer-cache/ 4 Performance Investigation(Database / SQL) https://www.ktexperts.com/performance-investigation-database-sql/ 5 Oracle:… Read More
Dear Readers, In this article, we will see the following Backup Details of SQL. SQL Server offers many options for creating backups. As we discussed what types of backups can be performed based on the recovery model of the database. Here different types of backups… Read More
Hello Readers, In this article, we will see Recovery models in SQL Server. SQL Server backup and restore operations occur within the context of the recovery model of the database. Recovery models are designed to control transaction log maintenance. A recovery model is a database… Read More
Dear Readers, In this article, we will see the following Daily Tips for Linux. Tip-1 Date: 05-Feb-21 Provided By: Sridhar What is Operating System ? 👉 Operating system is an interface between user and the computer hardware.… Read More
Dear Readers, In this article, we will see SQL Server Database Architecture. SQL Server MDF Files In the SQL Server Primary Data Files are the basic data files which are related to the database for the storing and supervision of the information. MDF file in… Read More
Dear Readers, In this article, we will see the Upgradation and Data Migration in SQL Server. We have to download the Sql server patches from Sql server Builds site. (https://sqlserverbuilds.blogspot.com/) What is Cumulative updates (CU) 👉 Each new CU contains all the fixes that were… Read More
Dear Readers, In this article, we will see the Upgradation and Data Migration in SQL Server. Version upgradation 2014 to 2016 SQL 2014 evaluation edition….. Enterprise edition. In SQL server 2014 standard edition to enterprise edition The upgrading the version in SQL server 2014 it… Read More
