Question : Background: I have numerous databases with a large number of VIEW’s, and an extremely large number of SYNONYM’s. […]
Can `sys.aud$` recycle itself?
Question : In Oracle 11, what happens if I leave sys.aud$ to get bloated up to soak up the whole […]
Making sense of sys.objects, sys.system_objects, and sys.sysobjects?
Question : In this question I was writing a query using sys.sysobjects. However, one of the answers mentioned sys.system_objects. I’m […]
I want to see all tables of db,but no system tables
Question : On a db oracle we have system tables created by oracle and our tables created by us. I […]
Does MySQL have a more private and complete catalog other then INFORMATION_SCHEMA?
Question : Most databases provide the standardized INFORMATION_SCHEMA, however most also provide something else, In PostgreSQL we have the system […]
postgres system catalog query columns from table
Question : I am building an integration test against an app that provisions a database for a user. The User […]
dual table postgres doesn’t return timestamp
Question : I am trying to select now() from my local postgres database dual table: select now() from dual; It […]
Update sys.job$ set this_date=:1 where job=:2 as one of the most time-consuming queries – oracle
Question : I am currently helping some organization with their Oracle database performance. They are using Oracle 11gR2 Standard Edition […]
How to list all the indexes along with their type (BTREE, BRIN, HASH etc…)
Question : I’m querying to the system catalog in Postgresql 9.6.4 Getting a result set of tables and their indexes […]
Where are SQL Server catalog views persisted?
Question : It seems that sys catalog views can be found under every database, either built in or user created. […]