Thursday, August 30, 2012

Usefull links

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 practice
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

Execute sql query/procedure from oracle:
http://examples.oreilly.com/9780596001292/
Store proc:

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/technology/sample_code/tech/java/jsp/oracle9ijsp.html
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-highest-salary-in-oracle/
http://www.oraclemagician.com/mag/magic14.pdf
http://rampant-books.com/book_1002_oracle_tuning_definitive_reference_2nd_ed.htm

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/sql/t-sql-programming/exploring-your-database-schema-with-sql/

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/oracle.html( Good one) 
http://www.oratable.com/nocopy-parameter-hint/?goback=%2Egde_74566_member_264548297
PL SQL Development:
http://www.allroundautomations.com/plsqldev.html?gclid=CJLl07SJs54CFcEtpAodFFFdnA
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:

Interview questions:

http://careerride.com/Oracle-Interview-Questions.aspx

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:

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

Unix Guru:

Unix shell script:
http://www2.cs.usfca.edu/~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

For anything:
http://www.cavdar.net
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

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.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.htm

SCJP:
http://www.janeg.ca/scjp/overload/poly.html
http://dev.fyicenter.com/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

Java and OOPS concepts:

http://www.cs.umd.edu/class/spring2006/cmsc132/Slides/lec35.pdf
http://www.javapractices.com/topic/TopicAction.do?Id=39

http://www.jguru.com/faq/

Very good java link for jars:

http://www.java2s.com/Code/Jar/glassfish/Downloadactivationjar.htm

Program related to java:
Basic programs:http://www.glearn.net/c/cbasic.htm and http://lernc.blogspot.in/
www.techlabs4u.com
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

6 comments:

  1. https://www.innomatics.in/advanced-data-science-training-in-hyderabad/
    https://www.innomatics.in/digital-marketing-course-training-hyderabad/
    https://www.innomatics.in/ibm-certified-predictive-analytics-modeler-course-training/

    ReplyDelete
  2. This article is full of informative and knowledgeable courses to know more get into Digital Marketing Course and expand your knowledge.

    ReplyDelete
  3. 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