CPU missing:
https://fritshoogland.wordpress.com/2017/03/01/oracle-12-2-wait-event-pga-memory-operation/
https://ardentperf.com/2016/07/01/understanding-cpu-on-aix-power-smt-systems/
Certification programs for latest technology:
https://www.analyticsvidhya.com/learning-paths-data-science-business-analytics-business-intelligence-big-data/
https://www.udemy.com/courses/
http://www.insofe.edu.in/certification/big-data-certification-courses-bengaluru.html
https://www.greatlearning.in/great-lakes-pgp-big-data-analytics
https://www.simplilearn.com/it-service-management/togaf-certification-program-training?
Data science competition:
https://www.kaggle.com/competitions
Oracle:
Metalink articles:
Worked Example of Replacing the Current Existing Plan with a Different Plan Using a SPM SQL Plan Baseline (Doc ID 1580762.1)
How to Analyze the Performance History of a SQL Statement as Recorded in AWR Using Simple SQL (Doc ID 1580764.1)
Investigate database issues.
https://database-investigator.com/2019/01/08/insert-running-slowly-after-delete/
Sql plan management:
https://orastory.wordpress.com/2015/08/11/sql-plan-management-choices/
https://hourim.wordpress.com/2015/04/06/bind_equiv_failure-or-when-you-will-regret-using-adaptive-cursor-sharing/
https://carlos-sierra.net/2017/09/01/poors-man-script-to-summarize-reasons-why-cursors-are-not-shared/
DBA scripts to download:
http://dbaclass.com/monitor-your-db/
https://github.com/tanelpoder/tpt-oracle
https://carlos-sierra.net/category/scripts/
Statspack idle events:
http://blog.dbi-services.com/statspack-idle-events/
Upgrade application(Database changes) online:
http://www.oracle.com/technetwork/issue-archive/2010/10-mar/o20asktom-098897.html
Live Sql: Oracle provides live 12.1.0.2 enterprise edition database for practicehttps://www.analyticsvidhya.com/learning-paths-data-science-business-analytics-business-intelligence-big-data/
https://www.udemy.com/courses/
http://www.insofe.edu.in/certification/big-data-certification-courses-bengaluru.html
https://www.greatlearning.in/great-lakes-pgp-big-data-analytics
https://www.simplilearn.com/it-service-management/togaf-certification-program-training?
Data science competition:
https://www.kaggle.com/competitions
Oracle:
Metalink articles:
Worked Example of Replacing the Current Existing Plan with a Different Plan Using a SPM SQL Plan Baseline (Doc ID 1580762.1)
How to Analyze the Performance History of a SQL Statement as Recorded in AWR Using Simple SQL (Doc ID 1580764.1)
Investigate database issues.
https://database-investigator.com/2019/01/08/insert-running-slowly-after-delete/
Sql plan management:
https://orastory.wordpress.com/2015/08/11/sql-plan-management-choices/
https://hourim.wordpress.com/2015/04/06/bind_equiv_failure-or-when-you-will-regret-using-adaptive-cursor-sharing/
https://carlos-sierra.net/2017/09/01/poors-man-script-to-summarize-reasons-why-cursors-are-not-shared/
DBA scripts to download:
http://dbaclass.com/monitor-your-db/
https://github.com/tanelpoder/tpt-oracle
https://carlos-sierra.net/category/scripts/
Statspack idle events:
http://blog.dbi-services.com/statspack-idle-events/
Upgrade application(Database changes) online:
http://www.oracle.com/technetwork/issue-archive/2010/10-mar/o20asktom-098897.html
https://livesql.oracle.com/apex/f?p=590:1000:108475428310375:::::
How to add hint to a query without placeholder:
https://blogs.oracle.com/optimizer/entry/how_can_i_hint_a
Recent posts on Asktom
https://asktom.oracle.com/pls/apex/f?p=100:6:::NO:::
https://blogs.oracle.com/sql/entry/12_things_developers_will_love#real-time-mv
top-50-oracle-sql-blogs-for-2016:
http://www.databasestar.com/top-50-oracle-sql-blogs-for-2016/
Oracle white papers:
http://www.orafaq.com/wiki/Papers
Use hint in query without changing code/query:
http://intermediatesql.com/oracle/how-to-add-a-hint-to-oracle-query-without-touching-its-text/
For any questions:
Performance issues :https://www.hotsos.com/apex/f?p=200:50507:11560840435594
http://oracle-randolf.blogspot.in/2016/02/big-nodes-concurrent-parallel-execution.html
http://blog.tanelpoder.com/archives/
https://orainternals.wordpress.com/tag/xkgllk/
https://jonathanlewis.wordpress.com/statspack-examples/
http://www.online-database.eu/index.php/sql-tuning/214-create-manually-a-sql-profile-and-set-your-own-hints
http://www.orafaq.com/wiki/Blogs---Important blogs on oracle
http://www.oracle.com/technetwork/articles/sql/11g-schemamanagement-089869.html
add column on very large table with default value
http://asktom.oracle.com
http://arup.blogspot.in/2010/12/100-things-you-probably-didnt-know.html
https://hoopercharles.wordpress.com/2011/07/21/session_cached_cursors-possibly-interesting-details/
https://hourim.wordpress.com/2012/02/06/how-to-solve-ora-08102-index-key-not-found/
http://logicalread.solarwinds.com/database/oracle/page/4/#.Vo-z8vl94dU
http://gavinsoorma.com/2009/07/performance-tuning-methodology/
http://managingoracle.blogspot.in/2010/08/oracle-table-reorganization-online-or.html
Parallel merge:
Oracle Mastering Oracle SQL example code
http://orajourn.blogspot.in/2007/11/day-1-with-jonathan-lewis-execution.html
http://juliandontcheff.wordpress.com/2011/04/22/table-annotations-in-11-2-0-2/
http://www.stevenfeuerstein.com/
http://www.vamsipavan.com/blog/javasqlsqlexception-io-exception-invalid-packet-lenght/
http://juliandontcheff.wordpress.com/2011/04/22/table-annotations-in-11-2-0-2/
http://www.stevenfeuerstein.com/
http://www.vamsipavan.com/blog/javasqlsqlexception-io-exception-invalid-packet-lenght/
Execute sql query/procedure from oracle:
http://examples.oreilly.com/Store proc:
http://www.devshed.com/c/a/ Oracle/Oracle-Stored- Procedures/
validate invalid objects:
http://www.oracle-base.com/articles/misc/recompiling-invalid-schema-objects.php
validate invalid objects:
http://www.oracle-base.com/articles/misc/recompiling-invalid-schema-objects.php
Excellent link for pl-sql programming best practices from Steven Feuerstein:
http://www.oracle.com/technetwork/issue-archive/index-087690.html
Good blog and use full scripts:
http://sql-plsql.blogspot.in/2007/05/oracle-plsql-cursors-with-parameters.html
http://dwhlaureate.blogspot.in/
http://halimdba.blogspot.in/2012/05/how-to-importinsert-data-from-csvexcel.html
http://ora-12034.ora-code.com/msg/32029.html
http://www.oramoss.com/wiki/index.php/Main_Page
http://arjudba.blogspot.in/2012/04/data-pump-export-to-network-mapped.html
http://jonathanlewis.wordpress.com/testing-autotrace/
http://nimishgarg.blogspot.in/
http://sbhoracle.wordpress.com/
For Iz0-144 certification
http://www.srikanthtechnologies.com/blog/personal/1Z0-144-Study-Guide.pdf
Oracle programs:
http://www.oratable.com/regular-expressions-in-oracle/
http://www.oracle.com/
http://psoug.org/browse.htm?cid=4 http://www.techonthenet.com/oracle/functions/index.php
https://blogs.oracle.com/optimizer/entry/how_does_auto_sample_size
Tough Questions:http://searchoracle.techtarget.com/answers
http://www.sql-ex.ru
http://www.programmerinterview.com/index.php/database-sql/find-nth-highest-salary-sql/
http://www.oratable.com/nth-
http://www.oraclemagician.com/
http://rampant-books.com/book_
New features in oracle 11g:
http://www.dbanotes.com/database-development/oracle-11g-new-features-for-developers/
http://www.oracle-base.com/articles/11g/articles-11g.php#db11gr2
Code Based Access Control (CBAC):
pl-sql daily puzzle:http://www.plsqlchallenge.com/pls/apex/f?p=10000:10:8520920492035792
For locks and deadlocks in oracle:
http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:4530093713805
https://clouddba.co/online-training-dba/
Link to find out tables without primary key:
http://www.simple-talk.com/Set operations in oracle:
http://oreilly.com/catalog/mastorasql/chapter/ch07.html
Find out long running pl-sql or sql:
http://gavinsoorma.com/2009/06/monitor-long-running-operations-using-vsession_longops/
Good links:
http://www.oracle-base.com/articles/11g/articles-11g.php
http://www.dba-oracle.com/oracle_news/
http://psoug.org/reference/functions.html
http://www.arikaplan.com/
http://www.oratable.com/nocopy-parameter-hint/?goback=%2Egde_74566_member_264548297
PL SQL Development:
http://www.
http://steveharville.wordpress.com/page/2/
DBA Blogs:
http://www.jlcomp.demon.co.uk/faq/ind_faq.html
http://www.jlcomp.demon.co.uk/
Cardinality:http://jonathanlewis.wordpress.com/2009/05/11/cardinality-feedback/
Sql monitoring:http://www.oracle-base.com/articles/11g/real-time-sql-monitoring-11gr1.php
Tips for query optimization:http://www.mbjconsulting.com/oracle_links/Tips_for_Effective_Queries.html
sql coding best practices:http://www.toadworld.com/KNOWLEDGE/KnowledgeXpertforOracle/tabid/648/TopicID/CEXP/Default.aspx
sql practices(translate):
http://www.oracle.com/technetwork/issue-archive/2006/06-jan/o16plsql-097201.html
http://www.careerride.com/Oracle-Interview-Questions.aspx
Test your Oracle skills:
Oracle interview test part 1 (40 questions)
Oracle DBA interview test (30 questions)
Oracle PLSQL interview test (30 questions)
Oracle Replication interview test (20 questions)
Oracle Architecture interview test (20 questions)
Oracle Transaction interview test (20 questions)
Interview questions:Oracle DBA interview test (30 questions)
Oracle PLSQL interview test (30 questions)
Oracle Replication interview test (20 questions)
Oracle Architecture interview test (20 questions)
Oracle Transaction interview test (20 questions)
http://careerride.com/Oracle-
Performance related issues:
http://perfhints.blogspot.in/2009/03/improving-performance-with-result-cache_9126.html
https://blog.tanelpoder.com/
hierarchical profiler:
http://www.oracle-base.com/articles/11g/plsql-hierarchical-profiler-11gr1.php
Emails and answers:
http://www.freelists.org/archive/oracle-l/01-2014
Oracle Expert:
http://www.oracleexpert.co.uk/
Unix:
Very good tutorials:
http://www.devdaily.com/
RSYNC:
RSYNC:
http://www.thegeekstuff.com/2010/09/rsync-command-examples/
Unix commands with examples:
http://www.ats.ucla.edu/stat/fileman/unix_cmds.htm
http://www.dwbiconcepts.com/tutorial/24-interview-questions/50-top-25-unix-interview-questions-with-answers-part-i.html
Unix commands with examples:
http://www.ats.ucla.edu/stat/fileman/unix_cmds.htm
http://www.dwbiconcepts.com/tutorial/24-interview-questions/50-top-25-unix-interview-questions-with-answers-part-i.html
Nice find tutorial:
http://www.softpanorama.org/ Tools/Find/using_exec_option_ and_xargs_in_find.shtml
Ultimate explanation of Unix commands:
http://www.softpanorama.org/Utilities/ps.shtml
parrt/course/601/lectures/ unix.util.html
http://www.codecoffee.com/ tipsforlinux/articles2/042. html
http://unix-simple.blogspot. com/search/label/Oracle
http://developers.sun.com/ solaris/articles/prstat.html
http://www.panix.com/~elflord/ unix/sed.html
For oracle code unwrap:
http://www.codecrete.net/UnwrapIt/
http://www.sqlfiddle.com/
For batch scripts:
http://batcheero.blogspot.in/2007/06/how-to-enabledelayedexpansion.html
http://ss64.com/nt/findstr.html
http://www.robvanderwoude.com/errorlevel.php
http://ss64.com/nt/if.html
http://ss64.com/nt/for_f.html
SCJP:
Interview-Questions/Java-3/ What_if_the_main_method_is_ declared_as_private_.html
http://stackoverflow.com/questions/10042/how-do-i-implement-a-linked-list-in-java
EJB:
http://download.oracle.com/ docs/cd/E15051_01/wls/docs103/ ejb/DDreference-ejb-jar.html
spring2006/cmsc132/Slides/ lec35.pdf
http://www.javapractices.com/ topic/TopicAction.do?Id=39
http://www.jguru.com/faq/
Jar/glassfish/ Downloadactivationjar.htm
http://www.codechef.com/
http://kickjava.com/src/com/ mchange/v2/resourcepool/ BasicResourcePool.java.htm
http://efreedom.com/Question/ 1-3732851/Exception-Thread- Main- JavalangClassCastException
Java compilers and challenges:
http://compilr.com/ietanand/anand/Program.java#
https://amazon.interviewstreet.com/challenges/dashboard/#problem/4e14a0058572a
Java interview :
Java programming questions:
http://kundansingh.com/interview/
http://www.careercup.com/
http://www.techinterview.org/
http://www. mydeveloperconnection.com/ html/JavaTrap.htm
http://www.allapplabs.com/
Data Structure Related:
http://www.brilliantsheep.com/in-place-string-reversal-in-java/
http://geeksforgeeks.org/forum/topic/spiral-order-traversal-of-binary-tree
https://www.codechef.com/problems/CEXP04
http://www.softpanorama.org/
Ultimate explanation of Unix commands:
http://www.softpanorama.org/Utilities/ps.shtml
Unix Guru:
Unix shell script:
http://www2.cs.usfca.edu/~http://www.codecoffee.com/
http://unix-simple.blogspot.
http://developers.sun.com/
http://www.panix.com/~elflord/
For oracle code unwrap:
http://www.codecrete.net/UnwrapIt/
http://www.sqlfiddle.com/
For batch scripts:
http://batcheero.blogspot.in/2007/06/how-to-enabledelayedexpansion.html
http://ss64.com/nt/findstr.html
http://www.robvanderwoude.com/errorlevel.php
http://ss64.com/nt/if.html
http://ss64.com/nt/for_f.html
http://www.thegeekstuff.com/best-of-the-blog/
http://www.techfaq360.com/oracle_interview_questions.jsp?qid=1016
http://www.oraclehome.co.uk/oracle_plsql_functions.htm
https://medium.com/swlh/7-things-you-need-to-stop-doing-to-be-more-productive-backed-by-science-a988c17383a6#.kezfvhmj3
Resume tips from linkedin :
http://vidyapsi.wordpress.com/2009/02/10/java-collection-hierarchy/
Java:
Five Essential phone screen questions
http://sites.google.com/site/steveyegge2/five-essential-phone-screen-questions
http://www.codinghorror.com/blog/2007/02/why-cant-programmers-program.htm
http://www.codinghorror.com/blog/2012/03/how-to-hire-a-programmer.html
Very good java site for SCJP and prep for interview/
http://www.javabeat.net/cert/scjp-6-0/mock-exams/garbagecollection-1.php
http://www.freejavaguide.com/ scjp1.htm
OOAD Concepts
http://www.codeproject.com/Articles/22769/Introduction-to-Object-Oriented-Programming-Concep
JSP Tutorials:
http://www.roseindia.net/jsp/jsp.shtml
Hibernate Tutorial:
http://www.roseindia.net/hibernate/index.shtml
Struts tutorial:
http://www.roseindia.net/struts/
JSF Tutorial:
http://www.roseindia.net/jsf/
MySQL Tutorial:
http://www.roseindia.net/mysql/
J2EE certification questions:
http://www.javacertificate.net/jsp_iqns_2.htm
http://www.javacertificate.net/scwcd_2.htmhttp://www.techfaq360.com/oracle_interview_questions.jsp?qid=1016
http://www.oraclehome.co.uk/oracle_plsql_functions.htm
https://medium.com/swlh/7-things-you-need-to-stop-doing-to-be-more-productive-backed-by-science-a988c17383a6#.kezfvhmj3
Resume tips from linkedin :
http://vidyapsi.wordpress.com/2009/02/10/java-collection-hierarchy/
Java:
Five Essential phone screen questions
http://sites.google.com/site/steveyegge2/five-essential-phone-screen-questions
http://www.codinghorror.com/blog/2007/02/why-cant-programmers-program.htm
http://www.codinghorror.com/blog/2012/03/how-to-hire-a-programmer.html
IIT Lectures:
http://nptel.iitm.ac.in/courses.php?disciplineId=106
Very good java site for SCJP and prep for interview/ /Go through it:
http://www.javabeat.net/cert/scjp-6-0/mock-exams/garbagecollection-1.phphttp://www.freejavaguide.com/
OOAD Concepts
http://www.codeproject.com/Articles/22769/Introduction-to-Object-Oriented-Programming-Concep
JSP Tutorials:
http://www.roseindia.net/jsp/jsp.shtml
Hibernate Tutorial:
http://www.roseindia.net/hibernate/index.shtml
Struts tutorial:
http://www.roseindia.net/struts/
JSF Tutorial:
http://www.roseindia.net/jsf/
MySQL Tutorial:
http://www.roseindia.net/mysql/
J2EE certification questions:
http://www.javacertificate.net/jsp_iqns_2.htm
SCJP:
http://www.janeg.ca/scjp/overload/poly.html
http://www.javabeat.net/qna/302-overridding-method-rules-in-java/
Interview questiones
http://java-success.blogspot.com.au/
http://www.interview- questions-java.com/classes- objects.htm
http://dev.fyicenter.com/Interview questiones
http://java-success.blogspot.com.au/
http://www.interview-
http://stackoverflow.com/questions/10042/how-do-i-implement-a-linked-list-in-java
EJB:
http://download.oracle.com/
Java and OOPS concepts:
http://www.cs.umd.edu/class/http://www.javapractices.com/
http://www.jguru.com/faq/
Very good java link for jars:
http://www.java2s.com/Code/
Program related to java:
Basic programs:http://www.glearn.net/c/cbasic.htm and http://lernc.blogspot.in/
www.techlabs4u.comBasic programs:http://www.glearn.net/c/cbasic.htm and http://lernc.blogspot.in/
http://www.codechef.com/
http://kickjava.com/src/com/
http://efreedom.com/Question/
Java compilers and challenges:
http://compilr.com/ietanand/anand/Program.java#
https://amazon.interviewstreet.com/challenges/dashboard/#problem/4e14a0058572a
Java interview :
http://excusemeworld.com/java-j2ee-interview-questions/java-collections-api-interview-questions/
http://jav
Java profiler:
http://www.yourkit.com/ download/index.jsp
www.Java2Share.com
http://jav apeople.bl ogspot.com /2006/02/j ava-multi- threading- interview. html
Java profiler:http://www.yourkit.com/
www.Java2Share.com
Java programming questions:
http://kundansingh.com/interview/
http://www.careercup.com/
http://www.techinterview.org/
http://www.
http://www.allapplabs.com/
Data Structure Related:
http://www.brilliantsheep.com/in-place-string-reversal-in-java/
http://geeksforgeeks.org/forum/topic/spiral-order-traversal-of-binary-tree
https://www.codechef.com/problems/CEXP04
https://www.innomatics.in/advanced-data-science-training-in-hyderabad/
ReplyDeletehttps://www.innomatics.in/digital-marketing-course-training-hyderabad/
https://www.innomatics.in/ibm-certified-predictive-analytics-modeler-course-training/
Such an amazing informative blog post.
ReplyDeleteSalesforce Training
This article is full of informative and knowledgeable courses to know more get into Digital Marketing Course and expand your knowledge.
ReplyDeleteI really liked your blog article. Great.
ReplyDeletejava online training hyderabad
java online training hyderabad
Awesome Blog.Thanks a lot
ReplyDeleteData Science Course in Hyderabad
Thanks for sharing the valuable information about data Science. If you are looking for Degree course. Should check out B tech CSE in Data Science from K.R. Mangalam University
ReplyDelete