Tags » Database Administrator

ORA-04031: unable to allocate 4192 bytes of shared memory ("shared pool","unknown object","sga heap(1,0)","parameter handle")

I got this recently and the way I fixed it is by increasing the shared_pool_size parameter to 15G.

alter system set shared_pool_size=15G scope=spfile;

then restart database.


Connecting SQL Database with Different Windows credential in SQL Server Management Studio (SSMS)

It’s very common practice a database administrator guy has two login as WINDOWS authentication and a SQL’s sysadmin at database box. DBA guy always connect DB Server from their own working workstation (Desktop/Laptop) via SQL Server Management Studio (SSMS). 256 more words

Database Administrator

Granting permissions to Users/Roles to view Oracle Triggers

I was asked by a developer to grant them access to view Triggers within the database.  There is no “read only” option to view triggers.  Shown below are the only options to give the user or role. 18 more words


DataGuard Warning: ORA-16826: apply service state is inconsistent with the DelayMins property

This is how I resolved this warning message.

1. Log onto the standby database and stop the redo apply by issuing this command, alter database recover managed standby database cancel; 24 more words


DataGuard error: ORA-16766: Redo Apply is stopped

I encountered this today and I was wondering what recently changed that caused this to happen.  Then I remembered that I added new datafiles to a tablespace that was 97% full on the primary database.   220 more words


A database administrator and a VP-Certification's perspective

A database administrator’s perspective

Paul Button has been a database administrator since he completed his postgraduate studies in computer science 13 years ago. A database administrator is an information technology professional responsible for the installation, configuration, upgrading, administration, monitoring, maintenance, and security of databases in an organisation. 170 more words


SQL Server 2016 : New Feature with Import and Export Wizard

Hi Guys, Today when I was just doing some R&D with SQL server 2016 CTP2, got a new feature in “SQL Server Import and Export Wizard”. 118 more words

Database Administrator