techsupport

2622 readers

1 users here now

The Lemmy community will help you with your tech problems and questions about anything here. Do not be shy, we will try to help you.

If something works or if you find a solution to your problem let us know it will be greatly apreciated.

Rules: instance rules + stay on topic

Partnered communities:

You Should Know

Software gore

Recommendations

founded 2 years ago

MODERATORS

[email protected]

Are there any tools that can make a visual representation/summary of oracle databases? (sh.itjust.works)

submitted 2 weeks ago* (last edited 2 weeks ago) by [email protected] to c/[email protected]

5 comments fedilink hide all child comments

I have a system that involves a rather large and complex oracle database, and while the system as a whole is easy enough (for me) to understand, the database feels more like a black box of mysterious powers that I need some assistance wrapping my head around.

Are there any analytical tools to help with this? Ideally, I'd like a tool that would connect to the database and make a diagram over which tables connect to which other tables, as well as naming any stored procedures relevant to each. If such a tool exists, that'd be grand, but any other tools that can help breaking down this rube goldberg machine into something more digestible would be great.

And yes, it is much overdue for a postgresql successor. Getting the current contraption mapped out is the first step in building its replacement.

EDIT: Oh, and this database also interacts a lot with orasched, as well as external processes. A lot of things that should have been a cron job is now a procedure stored in the scheduler. A lot of things that should have been an external script/program is a stored procedure. And most offensive of all: many things that should have been in a config file is part of an SQL table. Whoever built this contraption must've been paid to write SQL and nothing else.

you are viewing a single comment's thread
view the rest of the comments

[–] [email protected] 1 points 1 week ago

We usually just dump a whole load SHOW CREATE TABLE dumps into drawsql at work when we discuss database migrations, and then drop a bunch of "tables" with no columns as comments. I am not aware of an tool that could deal with procedures and such, but we've only looked at that, SQLyog and Intellij's built-in visualizers.