Tags » Database Administrator

How To : Reporting Server (SSRS) – Activity Details

Hi Guys, Here I am starting How To series, hope it will be helpful for SQL’s lovers.

It’s a daily routine we see system reports where all things like Server health, DB Status, Jobs Status, Disk Spaces … etc. 253 more words

Database Administrator

Skill Yang Diperlukan Untuk Menjadi Seorang DBa

Berjumpa kembali dengan saya febriyant,

kali ini saya akan bagi – bagi informasi sedikit tentang kebutuhan akan skill untuk menjadi seorang Dba, kebetulan tempat saya bekerja menggunakan aplikasi entreprise oracle. 202 more words


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