Skip to main content

Oracle DBA Information at one place

Search This Blog

The B-Tree Index

on August 27, 2015

Get link
Facebook
X
Pinterest
Email
Other Apps

The B-Tree Index
http://docs.oracle.com/cd/E11882_01/server.112/e40540/indexiot.htm#CNCPT1182 https://www.google.co.in/url?

sa=t&rct=j&q=&esrc=s&source=web&cd=1&cad=rja&uact=8&ved=0CB0QFjAAahUKEwiVwMf-g8vHAhWUA44KHZgsB4I&url=http%3A%2F%2Fwww.cs.sjsu.edu%2Ffaculty%2Flee%2Fcs157%2FCS157AL22Indexing.ppt&ei=vO_fVZXyDZSHuASY2ZyQCA&usg=AFQjCNEK-Y3KJ5X8PuGSsKrLF_Jh9YptOA

https://richardfoote.files.wordpress.com/2007/12/index-internals-rebuilding-the-truth.pdf

Videos:
==========
https://www.youtube.com/watch?v=Ji6NVCb-td8 -------------PART1
https://www.youtube.com/watch?v=Do2kIruqJnk -------------PART2
https://www.youtube.com/watch?v=vr1DUj0jL38 ---------------PART3
https://www.youtube.com/watch?v=DoUWf3ASwpQ ----------- B-Tree insert, split, delete, merge

https://www.youtube.com/watch?v=7cmDQW2VcUg -------

Oracle AUTOTRACE Fundamentals to Analyze & Tune SQL

https://www.youtube.com/watch?v=8CQO2mEJg0s -------------

ORACLE TKPROF fundamentals Part 1 - Introduction to SQL Tracing & TKPROF

https://www.youtube.com/watch?v=OiVu6vFq28w

ORACLE TKPROF fundamentals Part 2 - Interpret TKPROF Report
https://www.youtube.com/watch?v=9IPS7uelbxg

ORACLE EXPLAIN PLAN FUNDAMENTALS
https://www.youtube.com/watch?v=7rBf7IVOh3A

Oracle 11g Hints Overview

https://www.youtube.com/watch?v=Ke_tII6Y0GE

https://www.youtube.com/watch?v=4ZJQ6ehmAsg

https://www.youtube.com/watch?v=_6IGfyI-6vM
https://www.youtube.com/watch?v=CwM-Cxilk4g

Hashing and Hash table in data structure and algorithm

Get link
Facebook
X
Pinterest
Email
Other Apps

Comments

Post a Comment

Oracle DBA Information

Popular Posts

How to read AWR reports

How to read AWR reports : The output of the AWR report contains a wealth of information that you can use to tune your database. The output of the AWR report can be divided into the following sections: Report Header This section is self explanatory which provides database name, id, instance if RAC , platform information and snap interval. (database workload time duration in review). This report is for instance number 2 of my RAC environment. So if you need to the analysis on RAC environment, you need to do it separately of all the instances in the RAC to see if all the instances are balanced the way they should be. DB Name DB Id Instance Inst num Startup Time Release RAC TestRAC 3626203793 TestRac2 2 17-Aug-11 19:08 11.1.0.6.0 YES Host Name Platform CPUs Cores Sockets Memory (GB) T estRAC Linux 64-bit for AMD 8 8 2 31. 44 Snap Id Snap Time Sessions Cursors/Session Begin Snap: 28566 27-Sep-11 01:00:21 130 4.8 End Snap: 28567 27-Sep-11 02:00:43 135 ...

Oracle Golden Gate on RAC

Oracle Golden Gate on RAC 1 Oracle GoldenGate GGSCI Commands http://docs.oracle.com/goldengate/1212/gg-winux/GWURF/ggsci_commands.htm RAC Oracle GoldenGate - Heartbeat process to monitor lag and performance in GoldenGate (Doc ID 1299679.1) Note 966181.1 Installing GoldenGate For Oracle RAC Note 965373.1 Installing And Configuring OGG In A RAC Environment Note 970876.1 Oracle ASM RAC EXTRACT Hanging Note 967390.1 Using Alternative Archived Log Destination On Oracle RAC Note 1242965.1 Re-enabling a RAC thread got extract abend with 'begin time .. prior to oldest log in log history.' Note 957112.1 Encountered SCN That Is Not Greater Than The Highest SCN Already Processed Note 987379.1 How to recover from Extract ERROR 180 encountered commit SCN that is not greater than the highest Note 1342635.1 How the mapping of OGG thread ...

Oracle DBA ALL Interview questions and answers..

Oracle DBA ALL Interview questions and answers.. Flash back interview questions: ************************************** Questions you always wanted to ask about Flashback Database… Nov 6, 2009 / By André Araujo Tags: Oracle Last Friday in the Sydney Oracle Meetup I talked about Oracle Flashback technology and how it helps to reduce downtime. The session generated great interest among the attendees, which led to interesting discussions and many questions about the subject. Some of the questions couldn’t be answered during the meeting so I’ve followed up on them and I’m posting the answers here since they may be of interest for many others. Q: Is there a separate background process for writing flashback logs? A: Yes. RVWR (Recovery Writer, a.k.a Flashback Writer) was introduced in Oracle 10g to write flashback data from the Flashback Buffer in the SGA to the flashback database logs on disk. Q: Do I need to shutdown and mount the database to turn flashback on? A: A...

Powered by Blogger