Convert physical standby to snapshot standby database
Snapshot standby is a feature in Oracle 11g that allows doing a read-write operation on the standby database. i. e we can convert the physical standby database to snapshot standby.…
Read MoreLife At Doyensys – G.K.VENKATESH KUMAR
Employees are the backbone of an organisation. With the right people, a company can not only achieve its goals but also surpass them. We want to thank our employees and…
Read MoreSQL PROFILE IN ORACLE
SQL PROFILE IN ORACLE SQL profile is a collection of additional statistical information stored in the data dictionary that helps the optimizer to generate the best plan for the query.…
Read MoreCreating sqlplan Baselines
Creating sqlplan Baselines Create sql tuning set ————————- begin DBMS_SQLTUNE.CREATE_SQLSET(SQLSET_NAME => ‘&&sql_id’, DESCRIPTION => ‘SQL TUNE SET2’); END; / ——-SELECT DBMS_SQLTUNE.report_sql_monitor(type => ‘TEXT’, report_level=>’ALL’, SQL_ID=>’f2nydgpwc252s’) AS REPORT FROM DUAL; —…
Read MoreOracle 11g Resize Redo Log Size on Data Guard and Primary Database
Current Status Of Redo Logs Primary Side SQL> select group#,sum(bytes/1024/1024)”Size in MB” from v$log group by group#; GROUP# Size in MB ——- ———- 1 750 2 750 3 750 SQL>…
Read MoreHow Oracle Is Helping to Fight Against a Mosquito Borne Disease
Certain deadly diseases in the world don’t have any proper vaccination. One such disease is the mosquito-borne disease, Chikungunya. Chikungunya is a deadly disease transmitted by mosquitoes. The signs of…
Read MoreDoyensys at Collaborate 2020
Update: Collaborate 2020 will not be occurring as scheduled on April 19-23, in light of the recent Coronavirus pandemic. We shall keep you posted about further developments. Please refer https://collaborate.oatug.org/coronavirus.…
Read MoreOracle Cloud Achieves New Milestone
Oracle Cloud joins the IO500, as per the announcement by Oracle. Andrew Reichman who is the senior director of Oracle Cloud’s product management reflected this announcement in his recent blog…
Read MoreDoyensys Receives the Award for The Best Workplace in IT and IT-BPM!
Doyensys received recognition for one of the best Mid-Size Indian workplaces in 2019 along with one of the best workplaces for women in 2019 from Great Place to Work. Doyensys…
Read MoreDoyensys is now listed on Oracle Cloud Marketplace!
We are now happy to announce that Doyensys is now listed in Oracle Cloud Marketplace, an online marketplace committed to cloud business applications and proficient services offered by Oracle Cloud Associates.…
Read More