Renaming/Dropping and recreating online redo logs and Standby logfiles

After we created Primary and Standby DB’s we realize what we haven’t put file names as per our standard. So I got the task to rename both, online redo logs and standby logs. This what I did : 1. Following is the script to identify all log files we have SELECT GROUP#, BYTES, ‘ONLINE’ AS…

Basic’s of BI

Most companies are virtually swimming in data. If only there was a way to collect this data in one place and make sense of it all with a simple report (or set of reports). Companies who can successfully extract pertinent data from their mountain of information are gaining unique perspectives of their business, enabling them…

In simple words, What is BI ?

What is BI? Business Intelligence (BI) is a computer based technique to identified, extracting (*1) and analyzing business data. For example senior management of an industry can inspect sales revenue by products and/or departments, or by associated costs and incomes. BI technologies provide historical, current and predictive views of business operations. So, management can take…

Oracle 12c Datagaurd have Simplified Switchover

[vc_row][vc_column][vc_column_text css_animation=”slideInLeft”]I want to mention a new feature about data guard that came with Oracle 12c. This feature is switchover verify. As you know switchover is planned role transition. So you make switchover when you want to test that whether standby database is working correctly.Before 12c you make switchover and you see an error during…

What is your contribution on educating your children’s future ?

[vc_row][vc_column][vc_column_text css_animation=”slideInLeft”] What is your contribution on educating your children future and their job scenario in future/ within 10 years Most parents ask their kids: What do you want to be when you grow up? But the thing is, that question is outdated and misleading in the world we live in today. There’s a powerful…