ddanil.com
    • SQL
    • VBA (EXCEL)
    • Commercial accounting
  • Login
  1. ddanil

Added Overview of Oracle architecture and performance tuning. Part 2.

CHAPTER 6. "Hints" and CHAPTER 7. "Reading execution plan" have been added to Overview of Oracle architecture and performance tuning. Part 2.

Category: News
Last Updated: 14 December 2024
Hits: 153

Website updated

Website updated (security patches, bug fixes, etc.).

Category: News
Last Updated: 07 December 2024
Hits: 146

New chapter added to Overview of Oracle architecture and performance tuning. Part 1.

CHAPTER 5. "Join methods and types" have been added to Overview of Oracle architecture and performance tuning. Part 1.

Category: News
Last Updated: 01 October 2024
Hits: 455

Added new info to Overview of Oracle architecture and performance tuning. Part 1.

CHAPTER 3. "Tuning. Statistics. Execution plan." and CHAPTER 4. "Table and index scan" have been added to Overview of Oracle architecture and performance tuning. Part 1.

Category: News
Last Updated: 21 September 2024
Hits: 481

New overview about Oracle architecture and performance tuning. Part1.

Short overview about most popular topics as "task-answer" format:

Overview of Oracle architecture and performance tuning. Part 1.

Category: News
Last Updated: 13 September 2024
Hits: 515

Minor updates for Oracle articles

All Oracle articles from https://ddanil/index.php/programming/sql have been updated.

New information has been added and some errors have been fixed.

Category: News
Last Updated: 07 September 2024
Hits: 225

Website updated

Website updated (new PHP version, security patches, bug fixes, etc.).

Category: News
Last Updated: 31 August 2024
Hits: 216

Minor update for all Oracle articles

Added to Oracle articles: some new info (difference between NVL and COALESCE, etc.), fixed errors, ... To Overview of group, analytical, and hierarchical queries added new functions (FIRST, LAST, NTILE).

Category: News
Last Updated: 13 March 2024
Hits: 222

Added overview about group, analytical, and hierarchical queries

In SQL added Overview of group, analytical, and hierarchical queries.

Some examples helps understand it quickly.

Try to solve it.

Category: News
Last Updated: 08 August 2022
Hits: 273

Site description

Welcome to new version of ddanil.com

Imroved style and perfomance.

Now site have topics about:

1) Training examples for Oracle exams 1z0-071, 1z0-149 and some materials about Oracle Database;

2) VBA connection info to Oracle Database and some materials about VBA and Excel;

3) Info about accounting entries and rules with examples (according to Federal Law about Accounting in Russian Federation №402).

Category: News
Last Updated: 06 August 2022
Hits: 236

Most Read

  • New overview about Oracle architecture and performance tuning. Part1.
  • Added new info to Overview of Oracle architecture and performance tuning. Part 1.
  • New chapter added to Overview of Oracle architecture and performance tuning. Part 1.
  • Часть 01. Основные средства (ОС) (RU)
  • Часть 05. Готовая продукция и её продажа (RU)
  • Типовые ситуации в работе с ячейками и диапазонами. Concepts. Cells and Ranges. (RU)
  • Overview of Oracle group, analytical and hierarchical queries
  • Часть 02. Нематериальные активы (RU)
  • Часть 04. Затраты на производство продукции (работ, услуг) (RU)

Latest Posts

  • Added Overview of Oracle architecture and performance tuning. Part 2.
  • Website updated
  • New chapter added to Overview of Oracle architecture and performance tuning. Part 1.
  • Added new info to Overview of Oracle architecture and performance tuning. Part 1.
  • New overview about Oracle architecture and performance tuning. Part1.
  • Minor updates for Oracle articles
  • Website updated
  • Minor update for all Oracle articles
  • Added overview about group, analytical, and hierarchical queries
  • Site description

We have 6 guests and no members online

Donate: BTC 1FRj8H8mpd1Yfe1CdtdSyuh2g6xjst2ADF

Contacts: mail@ddanil.com