Any interest in Oracle-related articles???
-
Well, I've been 'lurking' arround CP for about 6 months now and not an article to my credit, mainly due to time constraints. However a recent article by Daniel T. on SQL DOs and DON'Ts got me thinking that I could probably add some insight in that area. My main background is as a DBA on Oracle and Sql Server (and, god help me, Pervasive) platforms and was wondering if there is any interest in articles related to Oracle perhaps? Anything specifically bugging you about Oracle that I can help explain? :) *looks for a hole to crawl into before the bomb drops* Mark Conger
I'd certainly be very interested. I did a some work a few years back on VC++ apps which talked to an Oracle DB on HP-UX and found there was very little information available. I was most interested in the best method of accessing the data. In the end I opted for Oracle Objects For OLE because it has support for parameters and Stored Procedures whereas the ODBC driver didn't seem to. Cheers James
-
Well, I've been 'lurking' arround CP for about 6 months now and not an article to my credit, mainly due to time constraints. However a recent article by Daniel T. on SQL DOs and DON'Ts got me thinking that I could probably add some insight in that area. My main background is as a DBA on Oracle and Sql Server (and, god help me, Pervasive) platforms and was wondering if there is any interest in articles related to Oracle perhaps? Anything specifically bugging you about Oracle that I can help explain? :) *looks for a hole to crawl into before the bomb drops* Mark Conger
I think some Oracle articles would be great. When I first started trying to get Windows apps and Oracle to talk, I ran into some real problems. There was a sparsity of documentation especially in regard to stored procedures via ADO. Some Oracle articles could only add more value to the CP site. Michael Life’s not a song. Life isn’t bliss. Life is just this. It’s living. -- Buffy the Vampire Slayer: Once more, with feeling
-
Well, I've been 'lurking' arround CP for about 6 months now and not an article to my credit, mainly due to time constraints. However a recent article by Daniel T. on SQL DOs and DON'Ts got me thinking that I could probably add some insight in that area. My main background is as a DBA on Oracle and Sql Server (and, god help me, Pervasive) platforms and was wondering if there is any interest in articles related to Oracle perhaps? Anything specifically bugging you about Oracle that I can help explain? :) *looks for a hole to crawl into before the bomb drops* Mark Conger
-
Well, I've been 'lurking' arround CP for about 6 months now and not an article to my credit, mainly due to time constraints. However a recent article by Daniel T. on SQL DOs and DON'Ts got me thinking that I could probably add some insight in that area. My main background is as a DBA on Oracle and Sql Server (and, god help me, Pervasive) platforms and was wondering if there is any interest in articles related to Oracle perhaps? Anything specifically bugging you about Oracle that I can help explain? :) *looks for a hole to crawl into before the bomb drops* Mark Conger
-
Well, I've been 'lurking' arround CP for about 6 months now and not an article to my credit, mainly due to time constraints. However a recent article by Daniel T. on SQL DOs and DON'Ts got me thinking that I could probably add some insight in that area. My main background is as a DBA on Oracle and Sql Server (and, god help me, Pervasive) platforms and was wondering if there is any interest in articles related to Oracle perhaps? Anything specifically bugging you about Oracle that I can help explain? :) *looks for a hole to crawl into before the bomb drops* Mark Conger
Mark Conger wrote: if there is any interest in articles related to Oracle perhaps? IMHO Of course there is ... article please :cool: Cheers,Joao Vaz And if your dream is to care for your family, to put food on the table, to provide them with an education and a good home, then maybe suffering through an endless, pointless, boring job will seem to have purpose. And you will realize how even a rock can change the world, simply by remaining obstinately stationary.-Shog9 Remember just because a good thing comes to an end, doesn't mean that the next one can't be better.-Chris Meech
-
Well, I've been 'lurking' arround CP for about 6 months now and not an article to my credit, mainly due to time constraints. However a recent article by Daniel T. on SQL DOs and DON'Ts got me thinking that I could probably add some insight in that area. My main background is as a DBA on Oracle and Sql Server (and, god help me, Pervasive) platforms and was wondering if there is any interest in articles related to Oracle perhaps? Anything specifically bugging you about Oracle that I can help explain? :) *looks for a hole to crawl into before the bomb drops* Mark Conger
Yes, Oracle articles would be great, especially integrating Oracle with the .NET environment. I really enjoyed developing with Oracle in the 7.x days, but I got discouraged when they started tying in all that Java support stuff, that neither I nor my clients needed nor wanted. I recently looked at Oracle 9i, and it's such a resource hog! I can run SQL Server without even noticing! So, some articles on how to configure resource utilization (I remember this was possible in an INI file in the 7.x days) would be useful too! On a side note, I'm sitting here installing BusinessWorks Gold for a client, and the manufacturer (Best) uses Pervasive! First time I've heard about it. What's so great about Pervasive, and what technology is it based on? It sounds like their trying to rip MS, with the name "Pervasive SQL 2000i". Marc Obviously it is not all Muslims. Just like all VB programmers are not bad...both groups tend to cause trouble, get excited and do stupid things. -- Paul Watson
Help! I'm an AI running around in someone's f*cked up universe simulator. -
Well, I've been 'lurking' arround CP for about 6 months now and not an article to my credit, mainly due to time constraints. However a recent article by Daniel T. on SQL DOs and DON'Ts got me thinking that I could probably add some insight in that area. My main background is as a DBA on Oracle and Sql Server (and, god help me, Pervasive) platforms and was wondering if there is any interest in articles related to Oracle perhaps? Anything specifically bugging you about Oracle that I can help explain? :) *looks for a hole to crawl into before the bomb drops* Mark Conger
* balantly self-promotion * My latest article: SQL Server DO's and DONT's[^]
-
Well, I've been 'lurking' arround CP for about 6 months now and not an article to my credit, mainly due to time constraints. However a recent article by Daniel T. on SQL DOs and DON'Ts got me thinking that I could probably add some insight in that area. My main background is as a DBA on Oracle and Sql Server (and, god help me, Pervasive) platforms and was wondering if there is any interest in articles related to Oracle perhaps? Anything specifically bugging you about Oracle that I can help explain? :) *looks for a hole to crawl into before the bomb drops* Mark Conger
in my company i am responsible for creating a data service layer so no applications access our oracle database directly (they must either soap or dcom to our data services) ... our major point of conflict when designing this layer is whether most of the logic should be in the database (pl/sql packages), or in the com+ components ... the "oracle guys" think oracle should do all the work, and the com+ components should be very simple ... i personally think the opposite, move most of the logic to the com+ components what would your opinion be? thanks, john
-
Yes, Oracle articles would be great, especially integrating Oracle with the .NET environment. I really enjoyed developing with Oracle in the 7.x days, but I got discouraged when they started tying in all that Java support stuff, that neither I nor my clients needed nor wanted. I recently looked at Oracle 9i, and it's such a resource hog! I can run SQL Server without even noticing! So, some articles on how to configure resource utilization (I remember this was possible in an INI file in the 7.x days) would be useful too! On a side note, I'm sitting here installing BusinessWorks Gold for a client, and the manufacturer (Best) uses Pervasive! First time I've heard about it. What's so great about Pervasive, and what technology is it based on? It sounds like their trying to rip MS, with the name "Pervasive SQL 2000i". Marc Obviously it is not all Muslims. Just like all VB programmers are not bad...both groups tend to cause trouble, get excited and do stupid things. -- Paul Watson
Help! I'm an AI running around in someone's f*cked up universe simulator.Yeah, memory resource utilization is still configurable through 9i. most of the same setting in 7.X still apply with a few twists. Tuning resource utilization on Oracle is less a science than an art on Unix. If you try to run oracle on NT....well, lets just say the architecture was not intended to ru on NT's threading model. they made some fudges to get arround it. Pervasive...Um, Well, the big thing about Pervasive is its Btrieve with a SQL query engine slapped atop of it.. That's it. It's not a true RDBMS per say, but they have enough of the feature set that they attempt to compete with oracle and MS inn that segment. Pervasive claims that they are no-DBA required but that's a conceit. They still need a Btrieve developer who can set thigns up and manage things. Basically its a dumbed down Btrieve system that can be queried with SQL. just when you thought Btrieve had died :) Mark
-
* balantly self-promotion * My latest article: SQL Server DO's and DONT's[^]
LOL! I loved that article, Daniel but there are some things in oracle that change your outlook on a scenario. For instance, I have had occasion and reason to create what is called a bitmap index on a sex code field. Yeah, it was generally pointless for finding an individual, it is great for sorting and for specific scenarios where that distinction mattered. And consideering I was dealing with 20mil rows, tablescanning the whole thing would have been painful. Also, you didn't mention statistics. Creating an index is nice and all, but without statistics on the table/index the optimizer may not use it. oracle also has different optimizer modes compared to SQL Server. So, I think there may be a little call :) BTW, just so you know. I printed that article of yours and dropped it on 20 developers desks. I spent half the day explaining what most of the article meant! :wtf: Mark
-
in my company i am responsible for creating a data service layer so no applications access our oracle database directly (they must either soap or dcom to our data services) ... our major point of conflict when designing this layer is whether most of the logic should be in the database (pl/sql packages), or in the com+ components ... the "oracle guys" think oracle should do all the work, and the com+ components should be very simple ... i personally think the opposite, move most of the logic to the com+ components what would your opinion be? thanks, john
That mentality is pretty common for 'oracle guys' (of whcih I'm one :) ). When you say Data Service layer, are you talking about business rules? how complex is it? If its fairly basic integrity enforcement type of stuff, use PL/SQL. However if its full blown logic, extract it out into another technology. PLSQL can do it but tends to bog down the more complex the package gets (this way lies Dynamic SQL :wtf:) If I'm not understanding what you are trying to do, let me know. Mark
-
Sounds great. As well as that, and I'm quite serious, would be interested in what a DBA really does.:-D
Ok, I'll start thinking about topics this weekend :) What does a DBA do? Well, I've been told that DBa stands for Does Bull$#!% Alot :P Seriously though, most RDBMS's don't maintain themselves without a little guidance. SQL Server kinda spoils ya; It's install and go. Everyone else you have to worry about memory settings, disk allocations, planning. Generally I spend one to two hours a morning reviewing logs and dumped trace information for the database engine. After that, I take care of any requests (You'd be amazed how many developers can't deal with adding a column to a table that already has data in it). I also spend alot of time looking at the database as a whole looking for badly coded SQL (which there usually is alot of) and places where I can tune the system via structural changes like partitioning. Mark
-
I'd certainly be very interested. I did a some work a few years back on VC++ apps which talked to an Oracle DB on HP-UX and found there was very little information available. I was most interested in the best method of accessing the data. In the end I opted for Oracle Objects For OLE because it has support for parameters and Stored Procedures whereas the ODBC driver didn't seem to. Cheers James
James Spibey wrote: In the end I opted for Oracle Objects For OLE I think this product is the best kept secret for C++ developers connecting to Oracle. I've been using it for years and the only negative is my code is not too portable. Chris Meech "what makes CP different is the people and sense of community, things people will only discover if they join up and join in." Christian Graus Nov 14, 2002.
-
LOL! I loved that article, Daniel but there are some things in oracle that change your outlook on a scenario. For instance, I have had occasion and reason to create what is called a bitmap index on a sex code field. Yeah, it was generally pointless for finding an individual, it is great for sorting and for specific scenarios where that distinction mattered. And consideering I was dealing with 20mil rows, tablescanning the whole thing would have been painful. Also, you didn't mention statistics. Creating an index is nice and all, but without statistics on the table/index the optimizer may not use it. oracle also has different optimizer modes compared to SQL Server. So, I think there may be a little call :) BTW, just so you know. I printed that article of yours and dropped it on 20 developers desks. I spent half the day explaining what most of the article meant! :wtf: Mark
Mark Conger wrote: I loved that article, Daniel but there are some things in oracle that change your outlook on a scenario. I know, I'm making the transition now. BTW, an article of yours about this would be great! Mark Conger wrote: For instance, I have had occasion and reason to create what is called a bitmap index on a sex code field. In SQL Server 2k you have something like a "filtered index", too, so you can have an index only including male. It can achieve the same result, but there's more overhead. You can create indexes on views, too, but I never used that. Mark Conger wrote: BTW, just so you know. I printed that article of yours and dropped it on 20 developers desks. Thank you: I was quite depressed today about some things that are happening and I cannot make a difference. This has made me feel WAY better! My latest article: SQL Server DO's and DONT's[^]
-
Mark Conger wrote: I loved that article, Daniel but there are some things in oracle that change your outlook on a scenario. I know, I'm making the transition now. BTW, an article of yours about this would be great! Mark Conger wrote: For instance, I have had occasion and reason to create what is called a bitmap index on a sex code field. In SQL Server 2k you have something like a "filtered index", too, so you can have an index only including male. It can achieve the same result, but there's more overhead. You can create indexes on views, too, but I never used that. Mark Conger wrote: BTW, just so you know. I printed that article of yours and dropped it on 20 developers desks. Thank you: I was quite depressed today about some things that are happening and I cannot make a difference. This has made me feel WAY better! My latest article: SQL Server DO's and DONT's[^]
I'll start thinking about some topics :) Daniel Turini wrote: In SQL Server 2k you have something like a "filtered index", Yeah, I forgot the filtered index was there. I've NEVER seen it used inn SQL server by anyone. Personally I think the index implementation in Sql server is kinda braindead Daniel Turini wrote: Thank you: I was quite depressed today about some things that are happening and I cannot make a difference. This has made me feel WAY better! Glad I could help!:-D I've had days like that. The only thing that bothered me is how often I had to actually explain what normalizing data meant. Mark
-
James Spibey wrote: In the end I opted for Oracle Objects For OLE I think this product is the best kept secret for C++ developers connecting to Oracle. I've been using it for years and the only negative is my code is not too portable. Chris Meech "what makes CP different is the people and sense of community, things people will only discover if they join up and join in." Christian Graus Nov 14, 2002.
You must be using it after they got it working half way decently. I've heard its a bit of a resource pig, but what from Oracle isn't. I just wish all these different 'client's didnt require the normal SQL*Net client underneath. Mark
-
I'll start thinking about some topics :) Daniel Turini wrote: In SQL Server 2k you have something like a "filtered index", Yeah, I forgot the filtered index was there. I've NEVER seen it used inn SQL server by anyone. Personally I think the index implementation in Sql server is kinda braindead Daniel Turini wrote: Thank you: I was quite depressed today about some things that are happening and I cannot make a difference. This has made me feel WAY better! Glad I could help!:-D I've had days like that. The only thing that bothered me is how often I had to actually explain what normalizing data meant. Mark
Mark Conger wrote: The only thing that bothered me is how often I had to actually explain what normalizing data meant. :omg: My latest article: SQL Server DO's and DONT's[^]
-
Mark Conger wrote: The only thing that bothered me is how often I had to actually explain what normalizing data meant. :omg: My latest article: SQL Server DO's and DONT's[^]
More like.... :confused::wtf::confused: After a morning of that, my next sto was my boss to talk to the development groups boss about scheduleing SQL classes. In their defense, most of them are ex-COBOL programmers. What do you expect with someone whose been writing in that language for a while. rots da brain :) Mark
-
More like.... :confused::wtf::confused: After a morning of that, my next sto was my boss to talk to the development groups boss about scheduleing SQL classes. In their defense, most of them are ex-COBOL programmers. What do you expect with someone whose been writing in that language for a while. rots da brain :) Mark
Mark Conger wrote: In their defense, most of them are ex-COBOL programmers. The worst people to get programming on SQL + OOP, IMHO. I often avoid COBOL programmers like hell, it's hard to change their mind. I only try it if they are 25 years old or less. And they usually don't mix well with other programmers, not because of COBOLers fault, but normally COBOLers are seen as vile even by VB programmers! Someday, maybe, I write a "Hiring staff: DO's and DONT's". I have lots of experience in it. Specially in the DONT's :) My latest article: SQL Server DO's and DONT's[^]
-
Mark Conger wrote: In their defense, most of them are ex-COBOL programmers. The worst people to get programming on SQL + OOP, IMHO. I often avoid COBOL programmers like hell, it's hard to change their mind. I only try it if they are 25 years old or less. And they usually don't mix well with other programmers, not because of COBOLers fault, but normally COBOLers are seen as vile even by VB programmers! Someday, maybe, I write a "Hiring staff: DO's and DONT's". I have lots of experience in it. Specially in the DONT's :) My latest article: SQL Server DO's and DONT's[^]
Well, We have a bunch of COBOL proggies that have been doing this a long time (old HP3K system). You're right, they usually just don't get it most of the time. Mainly they need a best practices and tuning course. Mark