Best way to learn oracle

Real performance issues:

http://www.runningoracle.com/index.php?cPath=1&osCsid=t8gc7eoa5igsgmb93goik617g2


12 Things You Will Love about Oracle Database 12c R2
https://go.oracle.com/LP=61561?src1=:em:ne:ie:pt:SEV100664921STG3&elq_mid=93659&sh=26132613230226232605293436080903&cmid=OUNV170405P00034C0004

http://blog.enmotech.com/2018/01/11/12-things-you-need-to-know-about-oracle-database-12c-r2/

Video tutorials:

https://www.youtube.com/watch?v=2QggbUdNsfI&feature=youtu.be&list=PLKCk3OyNwIzvwEXdaubc6PQXwnQOAE9h2


Follow biggies:
Jonathan:
https://community.oracle.com/reputation.jspa?username=Jonathan+Lewis&viewID=history
https://jonathanlewis.wordpress.com

https://community.oracle.com/reputation.jspa?username=rp0428&viewID=history

https://community.oracle.com/reputation.jspa?username=Frank+Kulash&viewID=history

https://community.oracle.com/reputation.jspa?username=BluShadow&viewID=history

https://community.oracle.com/reputation.jspa?username=sb92075&viewID=history

https://community.oracle.com/reputation.jspa?username=Solomon+Yakobson&viewID=history

https://community.oracle.com/reputation.jspa?username=John+Stegeman&viewID=history

DBA Gods blog links can be found here;
http://dbakevlar.com/links/
http://allthingsoracle.com/topics/performance-tuning/

Blogs:
http://arup.blogspot.in/2010/12/100-things-you-probably-didnt-know.html
http://www.proligence.com/downloads.html
Arup Nanda:database administration, from performance tuning to security and disaster recovery
http://www.oracle.com/technetwork/issue-archive/nanda-column-index-2098438.html

Steven Feuerstein: For pl-sql
http://www.oracle.com/technetwork/issue-archive/index-087690.html

Melanie Caffrey: SQL/PL_SQL
http://www.oracle.com/technetwork/issue-archive/index-1429427.html

Tom Kyte: Anything
http://www.oracle.com/technetwork/issue-archive/index-093676.html

Must read articles from Tom:
http://www.oracle.com/technetwork/issue-archive/2013/13-sep/o53asktom-1999186.html
http://www.oracle.com/technetwork/issue-archive/2013/13-nov/o63asktom-2034271.html
http://www.oracle.com/technetwork/issue-archive/2014/14-jan/o14asktom-2079690.html
http://www.oracle.com/technetwork/issue-archive/2014/14-mar/o24asktom-2147206.html
http://www.oracle.com/technetwork/issue-archive/2014/14-may/o34asktom-2162246.html


Oracle performance tunning:
https://antognini.ch/publications/
https://people.sap.com/stefan.koehler

Adaptive query optimization related blogs:
https://blogs.sap.com/2013/09/24/oracle-db-optimizer-part-vii-looking-under-the-hood-of-adaptive-query-optimization-adaptive-plans-oracle-12c/
http://www.ludovicocaldara.net/dba/cpu-usage-12c-dbms_feature_awr/
http://www.ludovicocaldara.net/dba/sql-plan-directives-problem/
https://blog.dbi-services.com/nothing-in-feature-usage-statistics-since-12c/

Other articles written by prominent writers
http://www.oracle.com/technetwork/oramag/magazine/tech-articles/index.html

https://richardfoote.wordpress.com/
http://newbiedba.blogspot.in/

http://gerardnico.com/wiki/database/oracle/dbwn

http://oracle-randolf.blogspot.in

https://jonathanlewis.wordpress.com/ or http://allthingsoracle.com

http://blog.tanelpoder.com/2007/

https://blogs.oracle.com/sql/12-things-developers-will-love-about-oracle-database-12c-release-2#approx-queries


https://coskan.wordpress.com/blogroll/

https://oracleriddleblog.wordpress.com/

https://carlos-sierra.net/

https://blogs.oracle.com/optimizer/

http://blog.tanelpoder.com/2010/06/23/the-full-power-of-oracles-diagnostic-events-part-2-oradebug-doc-and-11g-improvements/
https://blog.tanelpoder.com/files/

http://db-oriented.com/en/

Oracle ACE laurent schneider
http://laurentschneider.com/
http://laurentschneider.blogspot.in/

Misc articles by tim hall:
https://oracle-base.com/articles/misc/articles-misc#development

Data Modeling:

http://databaseanswers.org/data_models/index.htm

Read new release features and implement them. It will make you champion
http://docs.oracle.com/database/121/NEWFT/chapter12101.htm#NEWFT167
http://www.oracle-developer.net/display.php?id=506
Read analytical functions and aggregate functions

http://psoug.org/reference/analytic_functions.html
http://psoug.org/reference/analytic_functions.html

Tips and tricks by Erik Wramner:
https://erikwramner.wordpress.com/category/database/page/3/

https://dioncho.wordpress.com/2010/12/10/interpreting-parallel-merge-statement/

How to read bind variable values:
http://tech.e2sn.com/oracle/troubleshooting/how-to-read-errorstack-output(If you don't have tunning pack)
http://tech.e2sn.com/oracle/troubleshooting/oracle-s-real-time-sql-monitoring-feature-v-sql_monitor
(If you have tunning pack)
JDA related blog:
https://vjdba.wordpress.com

People with my name :)

https://aprakash.wordpress.com/

https://www.linkedin.com/in/anand-yadav-96a79b

Data mining:
http://www.deep-data-mining.com/2014/03/flush-shared-pool-and-buffer-cache.html

Oracle interview questions:

http://www.orafaq.com/wiki/Interview_Questions

Simple oracle learning:
http://www.studytonight.com/dbms/database-normalization.php
http://its-all-about-oracle.blogspot.in/search/label/Partitioning

Removing black magic in optimizer:
https://blogs.oracle.com/optimizer/
http://optimizermagic.blogspot.in/

Bug fixes in oracle :
http://www.eygle.com/Notes/11203_buglist.htm

Basic interview questions:
https://jagguonline.wordpress.com/sql-queries/