Search
Tag Cloud
10.2 10.2.0.5 11.1 11.2 ADR alertlog ASM bug bundle patch cleanupDeploy database database appliance digest diskgroup enterprise manager gi grid control grid infrastructure GrindInst hashes LinkedIn listener localhost monitoring oak oakcli ODA odachk OEM one-off ORA oracle oracle database appliance password patch bundle PLSQL privileges RAC REDO sha1 solaris troubleshooting usable_file_mb x-windws xtermCategories
-
Recent Posts
Blogroll
Tag Archives: database
Simulating ORA-errors
Sometimes it can be useful to simulate a problem in your database by simulating an ORA-error. After we had a nasty bug with Grid Control (GC suddenly wasn’t able to monitor the alertlog of 10.2.0.5 databases anymore, see my post … Continue reading
Posted in Database
Tagged ADR, alertlog, database, dbms_system.ksdwrt, enterprise manager, grid control, LinkedIn, ORA, oracle, simulation, troubleshooting
Leave a comment
Calculating Compression Ratio
Before implementing one or more of the Oracle compression options that are available within an Oracle database, there are a couple of things you would like to examine before implementing one or more of these compression options. One thing you … Continue reading
Posted in Database
Tagged compress, compression, database, dbms_comp_advisor, DIRECT_LOAD, index key compression, LinkedIn, OAC, OLTP, oracle, oracle advanced compression, PLSQL
2 Comments
Constraint Exceptions
When adding or enabling a constraint on a table, it is possible that an error occurs because of an constraint violation. If for example you are trying to add a unique constraint to a column (or combination of columns) of … Continue reading
Password Hashes
Within Oracle databases passwords get hashed. When, for example, you create a new account or change the password of an account, the specified clear-text password gets hashed. This hash value is stored in the database with the account. Once hashed … Continue reading
Unwrapping wrapped PLSQL in 10g, 11g and 12c
There are circumstances where you whish to have a look at the source of an wrapped PL/SQL package, procedure or function. The circumstances I want to have peek at the source is when some PL/SQL code becomes invalidated because an … Continue reading