Timeline for Does increased Data Dictionary size affects performance
Current License: CC BY-SA 3.0
7 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Dec 28, 2017 at 1:12 | history | edited | Paul White♦ | CC BY-SA 3.0 |
Removed link that attracted some spam flags
|
| Dec 28, 2017 at 0:04 | comment | added | RDFozz | I agree with you there. Personally, I would be quite surprised if the built-in data structure table or views could be so filled with information as to cause a performance problem. However, as I have no definitive proof one way or the other, I'm not (actively) chiming in. Oh, and welcome to DBA.SE! Just to clarify, your post was quite nice - I just felt I had to note that it didn't seem to answer the OP's question, when it came up in the review queue. I look forward to more from you! | |
| Dec 27, 2017 at 23:41 | comment | added | Treasa Ní Mhaoltuile | According to dba-oracle.com/concepts/data_dictionary.htm The data dictionary views can be used to manage your database and good DBA's will put scripts together that run on a regular schedule....to monitor the database looking for problems, like running out of disk space. Data dictionaries are a necessary and crucial component to the performance of the db - therefore I cannot see how they could negatively impact performance. In my experience performance always comes down to the design of the db. | |
| Dec 27, 2017 at 22:46 | comment | added | RDFozz | While this is of potential interest, it does nothing to answer whether increases in the size of the built-in "data dictionary" tables found in Oracle (among other DBMSes) have a noticeable impact on performance. The "data dictionary" tables in the question simply define the structure of the database (table names, column names and types, triggers, indexes, possibly stored procedures and functions. etc.); they don't include any info on the intended contents of the columns (which, at a glance, seems like what the MuleSoft offering is about). These are two fundamentally different things. | |
| Dec 27, 2017 at 22:43 | review | Low quality posts | |||
| Dec 28, 2017 at 1:15 | |||||
| Dec 27, 2017 at 22:26 | review | First posts | |||
| Dec 27, 2017 at 22:46 | |||||
| Dec 27, 2017 at 22:22 | history | answered | Treasa Ní Mhaoltuile | CC BY-SA 3.0 |