Feed aggregator

Oracle Database 10g Release 2 for Windows

Radoslav Rusinov - Fri, 2005-09-09 02:58
Oracle have released the official version of 10g R2 for Windows.The software can be downloaded from here: Oracle Database 10g DownloadsThe Windows-related documentation for R2 is already available as well: Oracle Database 10g Relase 2 Documentation LibraryRadoslav Rusinovhttp://www.blogger.com/profile/18163031714036680150noreply@blogger.com

Oracle 10g ASM vs. Linux Filesystems, Part 2

Radoslav Rusinov - Fri, 2005-09-09 01:13
Andrew Carr let me to know that there is an interesting follow up to the ASM vs. LVM article on the Wim Coekaerts Blog: ASM vs LVM Wim Coekaerts is the Director of Linux Engineering at Oracle. The post is discussing the interaction between OS buffercache and Oracle buffercache and how they are affected by using ASM or Linux filesystem.Radoslav Rusinovhttp://www.blogger.com/profile/18163031714036680150noreply@blogger.com2

Bitmap Indexes - History and Future

Radoslav Rusinov - Wed, 2005-09-07 13:05
A small introduction: Bitmap indexes are tailored to data warehouses.In its simplest form, a bitmap index on an index consists of one vector of bits (i.e., bitmap) per attribute value, where the size of each bitmap is equal to the number of records in the indexed relation. For example, if the attribute is day of the week, then there would be seven bitmap vectors for that attribute, one for each Radoslav Rusinovhttp://www.blogger.com/profile/18163031714036680150noreply@blogger.com5

Oracle 10g ASM vs. Linux Filesystems for non-RAC systems

Radoslav Rusinov - Thu, 2005-09-01 03:16
Bert Scalzo has published an interesting article in Linux Journal that compares the performance of non-RAC Linux systems, which are using the new Oracle 10g feature - ASM versus using of Linux filesystems: Optimizing Oracle 10g on Linux: Non-RAC ASM vs. LVMRadoslav Rusinovhttp://www.blogger.com/profile/18163031714036680150noreply@blogger.com2

A Big Set of Oracle Presentations from NYOUG

Radoslav Rusinov - Fri, 2005-08-26 03:41
On the web site of The New York Oracle Users Group (NYOUG) you can find some very interesting presentations from the recent NYOUG events:June 2005Things You “Know” - from Tom Kyte, Oracle CorporationResource Mapping: A Wait Time-Based Methodology for Database Performance Analysis – from Matt Larson, Confio SoftwarePresents the Resource Mapping Methodology and how it can be used for Wait-Event Radoslav Rusinovhttp://www.blogger.com/profile/18163031714036680150noreply@blogger.com3

Once More Into The Fray

Radoslav Rusinov - Thu, 2005-08-25 00:45
Mike Ault has published an answer to all comments about the recent published article from Don Burleson: Once More Into The FrayAdded from Rado: All of the comments (from Tom Kyte and other visitors) after the above blog post was deleted from Mike as he declares into his post and here: Comment on "Getting Credible Information" blog postAdded from Rado: Sorry but now I just have discovered that Radoslav Rusinovhttp://www.blogger.com/profile/18163031714036680150noreply@blogger.com3

The _PGA_MAX_SIZE post is updated

Radoslav Rusinov - Tue, 2005-08-23 12:50
I have updated my post about the _PGA_MAX_SIZE hidden parameter with additional information that pop-up in the past few days.I will appreciate any comments and corrections about my points if you think that they are wrong or you just have more valuable information that I can add to this post.Radoslav Rusinovhttp://www.blogger.com/profile/18163031714036680150noreply@blogger.com0

Oracle OPatch Security Holes

Radoslav Rusinov - Tue, 2005-08-23 01:05
A new white paper is coming from one of the leading security companies - NGS (Next Generation Security) Software Ltd.It will be related to discovered problems after using of the OPatch utility for applying of Oracle patches and the title is "Patch Verification of Oracle Database Servers".Some quotes from this Eweek news story: Security Firm: Oracle Opatch Leaves Firms Uncovered:A total of more Radoslav Rusinovhttp://www.blogger.com/profile/18163031714036680150noreply@blogger.com0

Pete Finnigan's Weblog

Radoslav Rusinov - Mon, 2005-08-22 10:28
Pete Finnigan has mentioned my blog in his Oracle Security weblog, especially the security-related post: How to see the MOD_PLSQL passwords in clear textThanks to him for his comments!I want to note that this information can be found at his book: Oracle Security Step-by-Step (Version 2.0) as step 8.1.2 from Phase 8 - Application Servers and the Middle Tier.Additional information online:Fact Radoslav Rusinovhttp://www.blogger.com/profile/18163031714036680150noreply@blogger.com0

The Don Burleson's article

Radoslav Rusinov - Sun, 2005-08-21 06:17
Added from Rado (23 August): Don updated his article again yesterday (see the link below). Now it is more detailed and there are lot of quoted documents.But there is again some questionable information:No RAM sort may use more than 5% of pga_aggegate_target or _pga_max_size, whichever is smaller. This means that no task may use more than 200 megabytes for sorting or hash joins.Again, for serial Radoslav Rusinovhttp://www.blogger.com/profile/18163031714036680150noreply@blogger.com13

Petals Around the Rose

Wijaya Kusumo - Sat, 2005-08-20 20:42
A friend introduced this interesting game to me. It is more like an observation game plus a little bit of math. Apparently it took Dr. Richard Duke at the University of Michigan over a year to "see the solution". He claimed "the smarter you were, the longer it took to figure it out". Maybe smarter people tend to think too much, or loose themselves in the details.... (hint) Interestingly I got it

The _PGA_MAX_SIZE hidden parameter

Radoslav Rusinov - Thu, 2005-08-18 11:38
Check the following links for more details regarding to my previous post (Management of the Oracle9i PGA): Discussion from Don Burleson's Oracle forum: Question for Don, Regarding _pga_max_size Article from Ora!Ora!Oracle mail magazine: Sort Metalink discussion thread: high pga_aggregate_target but low "cache hit percentage" Metalink discussion thread: PGA memory usage exceeding Radoslav Rusinovhttp://www.blogger.com/profile/18163031714036680150noreply@blogger.com5

Management of the Oracle9i PGA

Radoslav Rusinov - Thu, 2005-08-18 02:43
If you think that your PGA can be configured properly just by increasing of the PGA_AGGREGATE_TARGET parameter, think twice - it is NOT!See this article from Don Burleson: Undocumented secrets for super-sizing your PGAIt shows that there are two hidden parameters that can help for proper using of the PGA. Otherwise, Oracle will never use more than 200 MB for the whole PGA nor will it use more Radoslav Rusinovhttp://www.blogger.com/profile/18163031714036680150noreply@blogger.com3

Using of BULK COLLECT and FORALL for better performance

Radoslav Rusinov - 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

Mac OS X on your PC

Wijaya Kusumo - Mon, 2005-08-15 20:58
With Apple moves to x86 architecture, it is no wonder people start to do "what if" scenario. And now someone built a Mac for US $199! http://osx86project.org/ It is a shame why it took Apple so long to realize its cash cow is actually on x86 platform. Just imagine if you get a Dell box pre-installed with Mac OS!

Where is Oracle?

Denis Goddard - Sat, 2005-08-13 16:34
I spent about 8 years working at Oracle Headquarters in Redwood Shores, California.
Actually, I almost took a job working for Oracle as a consultant in Columbus, Ohio; it was a tough decision. The consulting job offered more money, and Ohio is closer to my family in the midwest.

In the end, though, it was a no-brainer; I wanted to be in Development, and especially in the specific area of Configuration Management, and that job was in California.
Having made that decision, the first few years it seemed easy; Redwood Shores is the center of the Oracle universe -- the place to be!

Now, I work extremely closely with a team of (brilliant, by the way) engineers in Thames Valley Park, in England.
Also, half my team are in Bangalore (aka India Development Center, aka "IDC"). Last but not least, I made some friends in the Adelaide, Australia office (including one with an OraBlog).

Anyway... meeting times with TVP and IDC were always a hassle when I worked in California. There really is no convenient time between these 3 nearly equidistant geographical points!

Now I have spent the past 2 months working in Oracle's New England Development Center (NEDC) in Nashua, New Hampshire.
I can honestly say, from the standpoint of working with people in England and India, New England is a far, far more advantageous place to be. The 3 timezones offset from California mean I have several hours each day where the British and Indians are reasonably available. As everyone is connected via Oracle RTC (Oracle's chat program), it's quite easy to interact with everyone.

I would say to anyone that's working with folks in Bangalore or Britain -- you ought to have a look at New England. Aside from being a really nice place in its own right, the timezones are quite favorable.

For the next week I'll be back in Redwood Shores, visiting my boss, my team at Headquarters, making presentations, etc.
No doubt, I will also be eating as much Indian cuisine as I can get my hands on -- there are precious few Indian restaurants here in Nashua.

Strange behaviour of the CBO, part 2

Radoslav Rusinov - 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

Radoslav Rusinov - 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

Radoslav Rusinov - 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

Radoslav Rusinov - 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


Subscribe to Oracle FAQ aggregator