Why Insulation is a Good Investment

Why Insulation is a Good Investment Investing in products to make homes more energy efficient pays significant dividends over a lifetime =97 with none of the wild fluctuations of Wall Street. Insulation contributes to: - Greater comfort - Even temperature distribution - Improved acoustics - Better moisture control, which can reduce floor squeaks, drywall cracks, structure damage and condensation - Potential for increased resale value: Installing proper insulation levels can also make your home more attractive to potential buyers. In fact, most buyers list energy-efficiency as a

OpenWorld 2010?

Hi All, I am going to OpenWorld, but no one else from my company is this year. Is anyone else on CDOS going? I wouldn't mind getting together and putting a name with a face with someone from the group. Regards, Steve

joining streamed pipelined function results with "real" tables

Hi, i like the approach for pipelined functions. But i wonder about the performance of joining the streamed result of a pipelined function with a "normal" table. There have been stated performance problems for this here: http://asktom.oracle.com/pls/asktom/f?p=100:11:1635437276096187::::P11_QUESTION_ID:19481671347143 However this is from 2005. Actually i expect oracle to perform good, if my join is like this: select something(rec.x, rec.y, rec.z) bulk collect into data from table(cast (dynData(cur) as table_of_something)) rec, account acct where acct.acct_id = rec.x

Direct load mystery

A colleague of mine contacted me with the following issue. She's loading data, large quantities of it, into a 64-bit Oracle 10.2.0.5 on SUN Slowaris (should I say Oracle Slowaris?). She noticed that there is a significant increase in performance if the transit tables she's loading the data into are analyzed after they're truncated, immediately before the load. She's loading using the direct=true option to sqlldr. Now, my problem with the situation is the following: direct load should bypass the SQL layer, which also includes the optimizer. There shouldn't be anything to optimize

PL/SQL removes comments from SQL statements

I've notices that PL/SQL removes comments from SQL statements For example if I execute folloing SQL select /* MyComment */ count(*) from big_table; and while it is running try to find it in V$SQL then the comment is visible select hash_value, sql_text from V$SQL where sql_text like '%MyComment %' However if I create stored procedure create or replace procedure commenttest as l_count number; begin select /* MyComment */ count(*) into l_count from big_table; end; / then execute it exec commenttest; and check V$SQL from another session then the comment isn't visi

Sr Informatica Developer/Analyst in MA

Title: Sr Informatica Developer Duration: Long Term Location: MA My direct client in MA has a long-term contract position available for a Sr Informatica Developer/Analyst; 5 years of Informatica development experience is required. This person will work as a senior member of the integration team on an enterprise-wide systems implementation effort. This individual is responsible for gathering requirements, performing analysis, writing technical specs, writing/interpreting design documents, performing detailed program design, coding and testing of integration processes to support thi

[RMAN] Slow target when duplicate

Hi, We duplicate the OLTP database from RMAN backup every morning. The target database (OLTP) is very slow seems due to control file access. I know there is an access to the control file. Can we alleviate this slow down? Thanks in advance Oracle 10.2.0.4

UI Developer , San Francisco, CA

Title:-UI Developer Location: San Francisco, CA Durations: 12 Months Skills =95 CIM UI Developer: Develop custom user interfaces to expose master data elements in a more user-friendly fashion, based on end-user feedback. Assure existing functionality and capabilities are exposed to end-users to prevent loss of functionality. =95 Experience using user-interface technologies like AJAX, experience interacting with CIM Web Services, CIM Workflow, CIM data models, CIM rulebases, Java, and JMS. UI Designer someone who can actually build the UI as well as work with End users to figure ou

=?windows-1256?B?yNHkx+PMIMfh0cfGzyDd7SDKzePt4SDH4ePh3Q==?= =?windows-1256?B?x8ogSW50ZXJuZXQgRG93bmxvYWQgTWFuYWdlcg==?=

yNHkx+PMIMfh0cfGzyDd7SDKzePt4SDH4ePh3cfKIEludGVybmV0IERvd25sb2FkIE1hbmFnZXIK CgpodHRwOi8vd3d3LmFnZDNhczdhYi5jb20vdmIvc2hvd3RocmVhZC5waHA/dD0yOTg4NA==

temp space useage on Oracle 10.2.0.4 enterprise / windows 2003

Is there a way of working out the maximum out of temp capacity used since a database was started. I currently have a temp space of 3 60g temp files & would like to remove one if possible regards Chris B

Simple hack to get* $5000 * to your Paypal account

Simple hack to get* $5000 * to your Paypal account At http://moneyforwarding.co.cc i have hidden the Paypal Form link in an image. in that website on Right Side below search box, click on image and enter your name and Paypal ID.

Core Java Developer, Stanford, CT

Core Java Developer ($70 =96 80/Hr) Location: Stanford, CT Duration =96 6 Months + =95 Core java expert (5+ years) =95 Commodities Experience - Required =95 Triple point CXL exp=E9rience or ETRM package impl=E9mentation (ie Endur, Calypso, Solarc, etc) - Required Please send you updated resume to jobs@mapleresource.net

Oracle BI Applications Development Resources>>Boston, MA

Title: Oracle BI Applications Development Resources Location: Boston, MA Duration: 3 Months + Looking for strong Oracle BI Applications (Oracle's pre-built Analytics) development resources. Must have knowledge and experience in installation and configuration of the ETL components of OBIA which Informatica and DAC. Must be able to support ETL mapping of source systems (Custom Spend Warehouse as well as from E-Business Suite 11.5.10 and R12) into OBIA (focus is on Procurement and Spend Analytics). Requirements: =B7 Minimum of 2 years of Oracle BI Applications experience

Difference bwtwwen REMOTE_LISTENER parameter not set and '' (empty string)

I looked at one of our databses' configuration settings using Embarcadero DBArtisan and the value came up as "N/A" which means "not available". If you look at it under SQLPlus, you get a line that shows the name and what looks like no value but no indication that the configuration parameter has actually be set. Our database standard calls for the value to be set as '' (empty string). Is there a difference between these two (not set and empty string)? Thanks in advance!

Micro Strategy Developer ,Mclean, VA

Title:- Micro Strategy Developer Mandatory: US Citizen or GC only. Location :- Mclean, VA Duration: 3+ Months Roles and Responsibilities: MHA-Compliance Risk and Analytics (IR2, First Look, Second Look Sampling and Logistics (Loan File Reviews) Responsibilities include managing for development, stage and production of MHA-C Reporting Application. Detailed duties will include the use of Architecture tools - Object Manager, Integrity Manager and Enterprise Manager to setup the metadata layer, security setup and administration

XML Import via XML Schema

Hi, in my company we are providing web services for information extraction returning XML files validated by a given XML Schema. One of our customers requires to import the resulting XML files directly into his Oracle database (10g 10.2.0.4.0) and runs into problems which sound uncommon to me. Parts of the XML Schema definition are 1:n occurences in complex types together with 0:1 occurences. An example: <xs:complexType name="projects"> <xs:sequence> <xs:element name="phase" type="workPhase" maxOccurs="unbounded" minOccurs="0"></xs:element> <xs:element name="additionalT

Dynamic "Orde by" parameter in Oracle Stored procedure

Hi, I would like to execute a SELECT * from table1 order by <XYZ> and get the results into IN OUT cursor. I want to pass XYZ as input parameter to stored procedure. It is treating it as string. For example: if XYZ value is field1, it is executing the SQL statement as SELECT * from table1 order by 'field1' instead of SELECT * from table1 order by field1 Please help.

QueuePool and ORA-12519

I got following exceptions. ----------------------- Exception-1 raise exc.DBAPIError.instance(None, None, e) DatabaseError: (DatabaseError) ORA-12519: TNS:no appropriate service handler found None None Solution i found in the net: 1. Run SQL*Plus and login 2. Run the command =93alter system set processes=3D150 scope=3Dspfile;=94 in the SQL*Plus 3. Restart the database. Question: Is the correct way to solve this problem? ----------------------- Exception -2 QueuePool limit of size 10 overflow 10 reached, connection timed out, timeout

Problem with network access Oracle 10g

Hello folks I�m trying to find a solution for a strange problem. First, let me say that my knowledge of Oracle is almost nil. I�m the local Windows tech support, am am trying to help the Oracle admins to fix this. We have a Oracle 10g server which was set up in a fixed IP Windows 2003 server (call it server1, temporary IP 111.111.111.111). After it was set up, everything seemed to go ok: every other workstation could access it via web portal (http://server1, and application at http://server1/pls/prt) However, we have now changed the IP of the server to it�s definitive (call i

Database 32-bit on win 64-bit

Hi, Is a database 32-bit certified on a win 64-bit OS It seems not but the certification matrix is not clear about tis have you any clue ? Thanks

problems w/ external files

Hi, I tried this over in the 'misc' oracle group w/o result - I'm hoping somebody here might see something going on. several problems with external tables (on a PC w/ Oracle 10g downloaded - I'm running Vista Home Premium - yes I know this isn' t exactly the right op sys but everything seems fine up til now - honest!): when I create an external table and write a pl/sql anonymous block which has a for i in (select * from <external_table> order by <col>) loop and run it from sqlplus in a command window I get an immediate 29913 error which goes away when I take away the orde

Sr Developer ,SFO

Title :- Java/J2EE - Sr Developer Locationv :- SFO Durtation :- 3 Months+ JDK 1.5, JSP, Servlet, Struts 2.0 or above, Oracle 10g, PL SQL, Please send your updated resume to jobs@mapleresource.net

Block Corruption in empty pages in Oracle 11g

I am using Oracle 11.1.0.7.1 on HP UNIX 11i. On several occasions, I have been seen that block corruptions are reported by rman. I have never seen this problem in previous release of databases; but I have seen it more than once in Oracle 11g. However, when I run dbv command; I do not see any corruption in data and index blocks; so my conclusion is block corruption is in empty pages. Anyone has ideas why block corruption occurs in Oracle 11g. Has Oracle=92s algorithm for checking block corruption have changed in 11g; I.e.; these corruptions existed in older Oracle releases but not rep

Distinct values

I have recently had a conversation with an Oracle support engineer who told me that, when analyzing VARCHAR2 columns, Oracle only counts the first 32 characters. I checked the statement and it is true: SQL> create table test1(col varchar2(40)); Table created. Elapsed: 00:00:00.07 SQL> insert into test1 values('01235678901234567890123456789012A'); 1 row created. Elapsed: 00:00:00.07 SQL> insert into test1 values('01235678901234567890123456789012B'); 1 row created. Elapsed: 00:00:00.08 SQL> commit; Commit complete. Elapsed: 00:00:00.06 SQL> analyze table test1

Need example for 11g's new response file db_install.rsp

I download oracle software from otn.oracle.com Trying to install 11g 32 bit oracle , I download disk1 and disk2. My question is , now the db_install.rsp is the "new response file" for installing oracle software?? In the past, I used enterprise.rsp. Also there is 2 disk2, one is disk1 and one is disk2, now I am confuse how to tell oracle's response file to look for one after the other one. Also, do anyone has one 11g db_install.rsp file (example) that I could take a look. thanks, Dominica