Radoslav Rusinov

Subscribe to Radoslav Rusinov feed
My experience, findings and thoughts in my daily work with Oracle productsRadoslav Rusinovhttp://www.blogger.com/profile/18163031714036680150noreply@blogger.comBlogger27125
Updated: 6 days 21 hours ago

Using of BULK COLLECT and FORALL for better performance

Tue, 2005-08-16 12:38
Lets see some quotes from the Oracle documentation:---PL/SQL engine executes procedural statements but sends SQL statements to the SQL engine, which executes the SQL statements and, in some cases, returns data to the PL/SQL engine.Too many context switches between the PL/SQL and SQL engines can harm performance. That can happen when a loop executes a separate SQL statement for each element of a Radoslav Rusinovhttp://www.blogger.com/profile/18163031714036680150noreply@blogger.com6

Strange behaviour of the CBO, part 2

Thu, 2005-08-11 03:08
After playing around with setting of columns to allow NULL values or not (setting COL1 and COL3 to allow NULL values, test and put it again to their default condition) and precomputing statistics, the issue from previous post become more unclear.Now the structure of the table is the same like it was before, statistics are fresh but cost for the execution plan is always 175. It doesn't matter whatRadoslav Rusinovhttp://www.blogger.com/profile/18163031714036680150noreply@blogger.com0

Strange behaviour of the CBO, part 1

Wed, 2005-08-10 11:36
The following interesting issue does not have clear explanation till now.I have query that is using the following predicates. ... AND COL1 LIKE '%%' AND COL2 LIKE '%%' AND COL3 LIKE '%%' AND COL4 LIKE '%%' ...May be I should explain from where is coming this strange query.If you are developping some application and you Radoslav Rusinovhttp://www.blogger.com/profile/18163031714036680150noreply@blogger.com2

How to see the MOD_PLSQL passwords in clear text

Wed, 2005-08-10 09:37
If you have some web-based PL/SQL application then you can be interested in the following information.May be many DBAs who have been involved in the database security have asked themselves: "How to be sure that my DAD files hides well the application schema passwords?"Well, Oracle doesn't have very good solution for this problem.Lets take a look at one DAD file used from an Oracle Application Radoslav Rusinovhttp://www.blogger.com/profile/18163031714036680150noreply@blogger.com0

Forcing Oracle to use LOGGING mode

Wed, 2005-08-10 08:43
I've just read an interesting newsletter about that how we can force the database (or some tablespace) to use the LOGGING mode for all operations. For example, lets imagine that we don't want someone improperly to start some operation in NOLOGGING mode that will lead the database to impossibility of performing of full database recovery after media failure. This could be important issue if a Radoslav Rusinovhttp://www.blogger.com/profile/18163031714036680150noreply@blogger.com0