2 physical concepts in Oracle database
https://studymind.co.uk/notes/work-energy-and-power

2 physical concepts in Oracle database

It could be strange, but yes, there are 2 concepts that came from physic that you can apply to your oracle database.

  1. The Heisenberg Uncertainty Principle
  2. The energy

The first one is about the concept of to influence the database while you are analyzing it to understand the performance problems [1]. And this was a very important issue in old days before 10g version. With this version, Oracle introduced the "Intelligent Infrastructure" in order to manage itself, introduced AWR, ASH, ADDM, Advisor ad other things.

The second one is about of how to "need to find a common currency between machines and not just between different areas in the same server" [2]. In Oracle 10g, Oracle introduced the DB Time metric that is the core concept of all performance analysis. "Database time is defined as the sum of the time spent inside the database processing user requests" [2]. Low values of DB Time is like to do the same thing in less time.

I wrote more on these two concept in my blog.

[1]?The Self-Managing Database: Automatic Health Monitoring and Alerting

[2] Automatic Performance Diagnosis and Tuning in Oracle


要查看或添加评论,请登录

Andrea Salzano的更多文章

  • How to rescue data after a mistake

    How to rescue data after a mistake

    Oracle give you the opportunity to recover data also if you delete them or dropped the table. Here 2 simple example…

  • Using SQL like Excel - First example

    Using SQL like Excel - First example

    In my previous post, I have shown the relation between SQL MODEL clause and an Excel spreadsheet. In this post, you can…

  • Using SQL like Excel

    Using SQL like Excel

    SQL allow you to manage a result set as a spreadsheet. It is possible using the MODEL clause.

  • MATCH_RECOGNIZE order of application

    MATCH_RECOGNIZE order of application

    Starting 12c, Oracle introduced THE MATCH_RECOGNIZE analytic function to recognize patterns. IF you are NEW TO this…

  • Analytic Function preserve the partitioning

    Analytic Function preserve the partitioning

    Analytic Functions are great. They are SQL standard so all databases implement them.

  • ITOUG Tech Day 2019 (Milano)

    ITOUG Tech Day 2019 (Milano)

    Il primo giorno del Tech Day 2019 a Milano, si è concluso. Alla grande dire.

    2 条评论
  • ITOUG 2019: Oracle, Mediamente, R1

    ITOUG 2019: Oracle, Mediamente, R1

    L'ITOUG event che si terrà il 30/Gennaio/2019 a Milano ed il 01/Febbraio/2019 a Roma è stato possibile grazie a tre…

  • ITOUG 2019: ancora insieme

    ITOUG 2019: ancora insieme

    Ormai ci abbiamo preso gusto. E' bello iniziare un nuovo anno (più o meno :) sapendo che poi sarà tutto in discesa.

  • ITOUG 2019 Thech Days

    ITOUG 2019 Thech Days

    Finalmente ci siamo. il 30 Gennaio ed il 1 Febbraio IOTUG organizzerà un nuovo evento.

  • Blocking session

    Blocking session

    Some time ago, I wrote a post on how to show a chain of blocked sessions. In this days Kaley Crum wrote a new version…

社区洞察

其他会员也浏览了