Can’t find what you want or need? Do you have a tip or trick to
share? Do you want to lament over a technical woe? If yes, then
blog and send it to us for the Log Buffer, just as this one
contains tips, tricks, and woes.
The red carpet has been laid down at this Log Buffer Edition, and
you can witness and cheer the cat-walking blog posts from Oracle,
SQL Server, and MySQL. Every one of them is chic, elegant, and
sensual in its own right. Enjoy.
Create colored heat maps in SQL*Plus with Kyle Hailey.
Here’s a quick and dirty script to create a procedure (in the SYS schema – so be careful) to check the Hakan Factor for an object.… [Read more...]
News and views are an integral part of our modern daily life. When it comes to the information-hungry roles such as database professionals, such need becomes more pressing. Log Buffer is one way to keep abreast of news and views from the world of Oracle, SQL Server, and MySQL.
There is a significant update SLOB 2, Kevin Closson informs.
Charles Hooper is …[Read more...]
When you setup a monitoring system for SQL Server, you often use thresholds to determine when an instance is healthy. You might say that you want to be alerted when CPU use is over 90% or when there’s only 10% of disk space left. The trouble with these thresholds is that they will often throw off false positives, or send you an alert when really nothing is wrong. Simple thresholds often have to be tuned to the individual instance, since a server with 10 TB still has 1 TB of space left at 90% disk use.[Read more...]
I am doing a reporting proof-of-concept (POC) for my company. Business intelligence (BI) is often the last thing that gets thought of during an application’s life cycle because it’s only really necessary after you get customers. Before that, the main focus is on application features. Soon after launch, your coworkers and your customers start asking questions about usage and adoption, and customers start to ask for summary information on their data as well as just dumping their data. If you’re the only guy in charge of the database, this is often overwhelming.
Thankfully, we now …[Read more...]
Reminders are an inevitable part of our personal and professional lives. Keep reminding of oneself about goals, priorities, and milestones is key to stay on top of things. This Log Buffer Edition is a reminder about all those not-to-be-missed blogs out there.
One of the developers was performing a delete using a nested subquery, which was throwing out ORA-00600 errors. The ORA-00600 Lookup Tool on MOS suggested it was caused by a bug, Tim Hall reports.
The healthcare sector has a clear opportunity …[Read more...]
Just as information has become an integral part of technology, blogging has become an inseparable part of technology too. Database technologies are no exception and blogging in that arena is booming. This Log Buffer Edition is booming with some bombastic blog posts.
Arup Nanda asks. Application Design is the only Reason for Deadlocks? Think Again.
It’s time that businesses …[Read more...]
Like in love there is no precondition, there are no limits held when it comes to the labor of love called as blogging. Lovingly this Log Buffer edition brings you some more roses from database arena.
Marco Vigelini shares as how to duplicate a production database on a different server mantaining the same SID and directory structures with ‘duplicate’ RMAN command and …[Read more...]
It is an industry norm, supported by analyst researches that blogs are the best informal medium to share the information. This unique medium provides readers with increased leverage in negotiating the hard turns in their technological lives. Log Buffer makes that leverage more powerful.
Alan Gardner is deploying Cloudera Impala on EC2 with Example Live Demo.
If you want to follow the real news and insight into the online learning revolution, then …[Read more...]