Welcome to alphaora
Tech Blog
Latest from the Blog
Identify duplicate rows in a table and delete them
I create a table and insert some rows into the table t11. When i create id column with unique constraint,the data dictionary is not allowing to insert duplicates to the table. So we can either drop or disable the constraint on the id column I disable the constraint and somehow inserted the rows by mistakeContinue reading “Identify duplicate rows in a table and delete them”
How many log switches per hour is normal?
we had a production database for one of our cloudera application.The application users started scheduled and batch jobs on the database.There was a complaint from application team about the slow performance.When we diagnosed the logfile,we found out that there was frequent log switches and archive generation which filled FRA space very fast.So we had toContinue reading “How many log switches per hour is normal?”
Calculate the bandwidth of IO subsystem from OS linux
We can calculate the IO rate of the disk from the OS to get an estimate of read/write to and from disk. Locate a particular datafile on any of storage partition Use dd to read the datafile and write the output to a output file and use time to determine the time taken for roundContinue reading “Calculate the bandwidth of IO subsystem from OS linux”
Get new content delivered directly to your inbox.
