Tags » Dba

"Switch" Huge Non Partitioned Tables in Seconds

ALTER TABLE SWITCH TO

There are many challenges with gigantic tables and modifying their schema is one of those that could make many operational DBAs cry. 368 more words

Database

Basic concepts required for understanding Oracle.

This world is full of Oracle DBAs.

But there are a select few who develop a deep understanding and work their magic.

Now to be above average will take a strong foundation of the basic concepts to build upon them and then even sky is not the limit. 117 more words

Oracle

ORA-12519: TNS:no appropriate service handler found

The number of database processes that can run in Oracle DB is set to 150 as default which can be viewed from v$resource_limit.

select * from v$resource_limit where resource_name = 'processes';


RESOURCE_NAME CURRENT_UTILIZATION MAX_UTILIZATION INITIAL_ALLOCATION LIMIT_VALUE
------------- ------------------- --------------- ------------------ -----------
processes     148                 149              150                150
… 97 more words
HOWTO

Is the DBA Dead?

No, he’s busy migrating to the Cloud!

No, he’s busy modelling data!

No, he’s busy integrating!

No, he’s still alive and kicking!

Are DBA’s really dead, or have they shifted from one organization to another? 643 more words

Don't get taken advantage of...

The title may be obvious but sometimes you just don’t know.  I wanted to get registered for a DBA (Doing Business As).  Well since it is 2017 I opted to register online.  170 more words

BTM

Business entity vs. DBA: What's the difference?

Many people think a business entity is the same thing as a DBA, which stands for “doing business as.” In fact, they have different meanings and purposes. 152 more words

Business Tips

5 CLI Commands, Sr DBA should know!

I am going to put together a list of command line interface (CLI) commands that has helped me over the years in troubleshooting SQL Server virtual/physical machines, especially when we bring in a new SQL VMs in our existing environment and want to make sure that it works and connected to every necessary part of the network. 503 more words

Intro