Here is a silly little thing you can do to your columns for … some reason. Create a constraint on a table full of data that would not pass the check for the constraint. This is not something that should be done if it can be avoided. You want your constraints to define a rule … Read more Enforce a constraint but do it fast and don’t look at my data
I have seen on few places in the net questions about how to disable logon and logoff audit for only one specific user (usually DBSNMP). This would really come in handy since some applications can have really excessive number of connections to the database. This should of course be addressed in other manner like creating … Read more Audit oracle connections only for specific users
These are the minimum grants needed to execute AWR reports.
I just found a strange behavior in one of our PL/SQL procedures that is designed to load the data from external tables (files that arrive on the server). During one run, I noticed that “session PGA memory” was constantly increasing which made me look for a leak in the first place. To cut the very … Read more Memory leak when changing external table location
As many of you know default date command on AIX doesn’t support “–date” parameter as Linux systems do. So, what can you do if you want to display another date in your shell script? There are some scripts roaming around the web, but the simplest thing i found is this. Get your time zone (let’s … Read more Get yesterday’s date into a variable on AIX