DBA Archives - Princeton IT Services

What Are the Major Advantages of Good and Reliable Data Management?

Data management is the process of collecting, storing, organizing, and managing data from distinct sources. This data further gets projected as more meaningful insight and report to aid decision making […]

No package mysql-server available

Starting CentOS7 MySQL is replaced with MariaDB. You might encounter the following error “mysql -u root -p4Samsung4” when you try installing mysql using yum. [root@myhost~]# yum install mysql-server Loaded plugins: […]

How to Create an Awesome Database Design?

Creating an awesome database design asks for the discipline of following certain rules. Here are some of them for you to get an overall idea of the data modeling and […]

oracle impdp as sysdba and attach job

impdp allows Oracle DBA to exit out of the current process while the job continues to run in the background. In the event you have to connect to the job […]

oracle – generate kill database sessions script

Here is the script that comes handy to Oracle DBAs for generating script to kill sessions based on user sessions. For example, this SQL script generates the script to kill […]

Enabling and Disabling – auto optimizer stats collection

Here is how you can query if the Auto Optimizer Stats Collection job is running in Oracle Database 11g: Login to database as SYSDBA: [sql] SELECT CLIENT_NAME, STATUS FROM DBA_AUTOTASK_CLIENT […]

expdp fails with ORA-27037 on Oracle RAC

When parallel option is used in expdp, it expects the DIRECTORY path to be available on nodes of the cluster. If you have created the directory on only one node […]

Identifying Blocking Sessions in Oracle Database

Below SQL gives the blocker and blockee sessions in database. Oracle RAC Environment: select (select username from gv$session where sid=a.sid) blocker, a.sid, ‘is blocking’, (select username from gv$session where sid=b.sid) […]

oracle archive log history

Here is the Oracle SQL script that comes handy to find out the number of archive logs that are generated by the database by day by the hour. set lines […]