IT Tutorial IT Tutorial | Oracle DBA | SQL Server, Goldengate, Exadata, Big Data, Data ScienceTutorial
I will explain ADR file lock wait event during RMAN L0 And L1 Backup in …
Read More »
June 8, 2020
Oracle SQL Tutorials For Beginners – Learn Oracle SQL from scratch with Oracle SQL Online Course
Hi, I will share with you Step by Step Oracle SQL Tutorials For Beginners. 210,236 views …
May 10, 2020
Oracle Tutorial | Oracle Database Tutorials for Beginners ( Junior Oracle DBA )
I will share with you Step by Step Oracle Tutorial | Oracle Database Tutorials for Beginners in this…
April 15, 2020
Performance Tuning and SQL Tuning Tutorial in the Oracle Database
I will share with you Step by Step Performance Tuning and SQL Tuning Tutorial in the Oracle Database…
December 10, 2019
RMAN Tutorial | Backup, Restore and Recovery Tutorials For Beginner Oracle DBA
Hi, I will share with you Step by Step RMAN Backup, Restore and Recovery Tutorials For Beginners in …
July 4, 2019
Dataguard ( Standby ) Monitoring Lag Command and Scripts | Oracle DBA Scripts All in One -2
Hi, I will share all Oracle DBA Scripts related Dataguard in this post. 200,925 views las…
2 weeks ago
ORA-02449: unique/primary keys in table referenced by foreign keys During Drop Tablespace
I got “ORA-02449: unique/primary keys in table referenced by foreign keys During Drop Tablespa…
2 weeks ago
ORA-01136: specified size of file is less than original size of blocks | ORA-01110: data file
I got “ORA-01136: specified size of file is less than original size of blocks | ORA-01110: dat…
May 25, 2022
OGG-02039 Failed to set logmining server parameter MAX_SGA_SIZE to value
I got ” OGG-02039 Failed to set logmining server parameter MAX_SGA_SIZE to value ” error…
May 25, 2022
ORA-30013: undo tablespace ‘UNDOTBS’ is currently in use
I got “ORA-30013: undo tablespace ‘UNDOTBS’ is currently in use ” error in O…
May 25, 2022
ORA-16028: new db_recovery_file_dest causes less destinations than LOG_ARCHIVE_MIN_SUCCEED_DEST requires
I got “ORA-16028: new db_recovery_file_dest causes less destinations than LOG_ARCHIVE_MIN_SUCC…
MapR Hadoop Distribution For Managing Big Data and Step by Step Mapr Cluster Install In The Best Way
Subjects Bigdata Manage What is Hadoop? Why is Hadoop important? What is MapR Hadoop Distribution …
Read More »
Kafka Stream API Json Parse
PySpark Makina Öğrenmesi (PySpark ML Classification Decision Tree)
PySpark Makina Öğrenmesi (PySpark ML Classification Preapering)
PySpark Makine Öğrenmesi
Clustering Wikipedia
Clustering Wikipedia Hi, in this article i’ll make a simple clustering example using wikipedia. You …
Read More »
Dimension reduction with PCA | Python Unsupervised Learning -6
Dimension reduction | Python Unsupervised Learning -5
t-SNE visualization | Python Unsupervised Learning -4
Introduction to gensim (Python)
How to Avoid Activity Monitor Hurting Your SQL Server’s Performance
There is no question that monitoring the performance of your SQL Server deployment is an …
Read More »
Random value for DATETIME column
Free Methods to Repair SQL Server Index Corruption
How to Prevent SQL Injection Attacks by Secure
Fill In Missing Dates for SQL Server Query Output using CTE
Exadata X8M-2 Image Upgrade Operation Step By Step For Image Version 20.1.9 With Best Practices
Exadata X8M-2 Image Upgrade Operation Step By Step For Image Version 20.1.9 With Best …
Read More »Exadata X8M-2 Multi-Rack Introduction
How to Clear ILOM FMA Faults And Reset The SP on Exadata or Other Servers
How to Shutdown and Startup Exadata and Oracle Databases
Exadata Temp Tablespace Migration To Flash Disk
Android Programming -15 Custom Adapter
Hi guys in this tutorial we will continue the custom adapter. In my previous article, …
Read More »
Android Programming -14 Custom Listview-2
Android Programming -13 Custom Listview
Android Programming -12 ArrayAdapter
Android Programming -11 Listview Component
OGG-02039 Failed to set logmining server parameter MAX_SGA_SIZE to value
I got ” OGG-02039 Failed to set logmining server parameter MAX_SGA_SIZE to value ” error …
Read More »
OGG-15121 Error obtaining the list of tables for: Does not match any catalog name
OGG-01433 Failed to validate table. The table is compressed and extract will not be able to extract data from Oracle logs
OGG-00041 Data source not specified.
OGG-00446 Checkpoint table GGSCHKPT does not exist
How to connect to Oracle from Your Windows Host to a VirtualBox Guest
I am sure that anyone who wants to work on a database or a data …
Read More »
Windows İşletim Sistemi ile Oracle Linux Sanal Makinesinin haberleştirilmesi(Virtualbox)
Veri Ambarı Konsepti(OLAP,OLTP)
Tableau Server Architecture
Tableau Server has a high scalable architecture that many users can connect and receive service …
Read More »Tableau Sunucu Mimarisi
DATA WAREHOUSE – ODS (OPERATIONAL DATA STORE)
ODS (Operational Data Store) ODS (Operational Data Store) is the database where all the source …
Read More »
Mapping ile Tablo Aktarılması 2 – ODI Dersleri 6
DATA WAREHOUSE – OLTP/OLAP
DATA WAREHOUSE – CHANGE DATA CAPTURE (CDC)
DATA WAREHOUSE – ETL/ELT
Execute Immediate in Oracle
I will explain Execute Immediate in Oracle in this post. 136,276 views last month, 2 views today
Read More »
Oracle SQL Date Comparison
Alter table rename column in Oracle
How to Prevent SQL Injection Attacks by Secure
Rename Table in Oracle
UTL_FILE FOPEN in PL/SQL
I will explain UTL_FILE FOPEN in PL/SQL in this post. 149,775 views last month, 2 views today
Read More »
DBMS_OUTPUT.PUT_LINE in PL/SQL
Alter Session Set NLS_DATE_FORMAT in Oracle with Examples
PL/SQL Conversion/Decoding/NULL-Related Functions
PL/SQL Datetime Functions
PostgreSQL – How to Eliminate Repeated Values
It’s possible that in a table, some field that has repeated values is necessary to …
Read More »
Performance Tuning and SQL Tuning Tutorial in the Oracle Database
Bulk Insert and Bulk Update in Oracle Database
What is the Optimizer Hints and How to Use Hints in Oracle | Oracle Database Performance Tuning Tutorial -16
How to Create SQL Plan Baselines Using Enterprise Manager Cloud Control | Oracle Database Performance Tuning Tutorial -15
Usefull Scripts For Couchbase Dba
Why Couchbase? Today’s mission-critical applications demand support for millions of interactions with end-users. Traditional databases …
Read More »
MongoDB Backup and Restore Using MongoDump
How to Access MongoDB Instance 4.2?
How to Install MongoDB on Windows System?
How To Install MongoDB 4.2 on RedHat/ CentOS 7 systems
Recent Posts
July, 2021
- 14 July
Oracle Disable Constraints & Enable Constraints
I will explain how to Disable Constraints & Enable Constraints in Oracle in this post. 1,934 views last month, 1 views today
Read More » - 13 July
How to Prevent SQL Injection Attacks by Secure
SQL, short for Structured Query Language, is one of the most common programming languages used for relational database management. Most database systems such as Oracle, MS Access, Informix, MySQL use …
Read More » - 13 July
Convert Physical Standby To Snapshot Standby Database ( Read / Write Mode ) in Oracle
I will explain how to Convert Physical Standby To Snapshot Standby Database in Oracle in this post. 2,313 views last month, 1 views today
Read More » - 12 July
ORA-39405: Oracle Data Pump does not support importing from a source database with TSTZ version 32
I got ” ORA-39405: Oracle Data Pump does not support importing from a source database with TSTZ version 32 into a target database with TSTZ version 18. ” error in …
Read More » - 12 July
ORA-01613: instance UNNAMED_INSTANCE_3 (thread 3) only has 0 logs – at least 2 logs required to enable.
I got ” ORA-01613: instance UNNAMED_INSTANCE_3 (thread 3) only has 0 logs – at least 2 logs required to enable. ” error in the Oracle database. 1,739 views last month, 1 views …
Read More »