As a Database Administrator, we need to follow Failed Logons. And we need to warn users for unauthorized access attempts. Or if there is a …
Read More »Automatic Undo Management On Oracle
To run the database in automatic undo management mode, you must set undo_management to auto from the oracle startup parameters. You can use …
Read More »SQL Server Trigger Types
Trigger is used to trigger another event when an event occurs in the database server. There are 3 types of trigger. 1) DML(Data Manipulation Language) …
Read More »Cursor Usage In SQL Server
WHAT IS CURSOR? In SQL Server, the Cursor walks through the recordset, which is returned as a select result, to perform a transaction on each …
Read More »FATAL: remaining connection slots are reserved for non-replication superuser connections
You will get this error when you reach the max connection count in PostgreSQL. You need to increase the max connection count in the …
Read More »How To Create an Oracle Password File
The Oracle password file is a file that is created automatically during installation. Users defined in this file can connect to oracle via sqlplus without …
Read More »Differences Between Temp Table and Table Variable
I wrote some articles about Temp Table and Table Variable. In general, people who are new to tsql code development are wondering which one …
Read More »What is Table Variables
Table Variable is a special data type. In the query we can create and insert a result set into the table variables and use …
Read More »How To Create Tablespace On Oracle
Tablespaces are areas dedicated to storing objects in the database. Tablespaces are logical constructs. However, it contains physical data files or temp files. There are …
Read More »How To Stop, Start, Restart and Reload PostgreSQL Service
You can do PostgreSQL service management in two ways. Generally, restart or reload is required when changes are made to the postgresql.conf file. You can …
Read More »