FAQ

Oracle > oracle-l > September 2007

Search Discussions

164 discussions - 848 posts

  • Hi all: I am working on tuning an app running against oracle 10.2.0.3 We have 48G on the server; my db_cache is 18G. When I look at the awr reports, I see db hit ratio being over 99% and a lot of ...
    Genegurevich_at_discover.comGenegurevich_at_discover.com
    Sep 25, 2007 at 6:57 pm
    Jan 12, 2008 at 12:14 am
  • Running 10gR2 (10.2.0.2) on RHEL4 on 4 64-bit dual-core box. Earlier today users complained en masse about not being able to connect to the database. I got to a term and found that even trying to log ...
    Don SeilerDon Seiler
    Sep 14, 2007 at 6:19 pm
    Oct 25, 2007 at 8:09 pm
  • Hi Experts, Is there any built-in SQL function which can convert JAVA Timestamp to Oracle TIMESTAMP data type. I need this to partition a table based on the TIMESTAMP(JAVA TIMESTAMP). I want to ...
    DBA DeepakDBA Deepak
    Sep 20, 2007 at 10:14 am
    Oct 2, 2007 at 6:20 pm
  • Dear list, Our peoplesoft HR system recently upgraded from 9i to 10.2.0.3. We did some statistics adjustment to solve one major sql statement. However, we had another performace issue last week for a ...
    Joan HsiehJoan Hsieh
    Sep 10, 2007 at 1:21 pm
    Sep 10, 2007 at 7:20 pm
  • Oracle 10.2.0.3 on Solaris. Table is range-partitioned on TCONTRACT_TRADE_DATE. Query is select min(TCONTRACT_TRADE_DATE) from ods.ods_tcontract; A single-column partitioned index ...
    Baumgartel, PaulBaumgartel, Paul
    Sep 28, 2007 at 8:35 pm
    Oct 4, 2007 at 3:54 pm
  • Background: We go back and forth about whether it is better to use a repository or to just rely on the control files. I have read many emails on this list about this issue also. We have decided that ...
    Joe Armstrong-ChampJoe Armstrong-Champ
    Sep 14, 2007 at 6:25 pm
    Sep 19, 2007 at 3:41 pm
  • This error occured on Windows Server 2003 while the weekly backup (Symantec) was running. Anyone have any ideas why this occurred and as possible work areound? Thanks Sat Sep 08 04:18:13 2007 Errors ...
    Brian LockBrian Lock
    Sep 11, 2007 at 8:56 pm
    Sep 14, 2007 at 7:28 am
  • I was wondering if it is possible to parameterizes a view. did some googling but did not find any satisfactory results. -- Mir M. Mirhashimali Oracle Systems Manager Database Architecture, Enterprise ...
    Mir M. MirhashimaliMir M. Mirhashimali
    Sep 19, 2007 at 4:47 pm
    Sep 19, 2007 at 7:20 pm
  • We have a two nodes RAC, the strange thing is that many sessions run on both nodes. select sid from gv$session group by sid having count(*) 1 they are lots of rows return. My understanding for load ...
    Qihua wuQihua wu
    Sep 27, 2007 at 4:55 am
    Sep 29, 2007 at 6:23 am
  • The Oracle docs state that ASM can perform striping and mirroring. If I use ASM on a SAN how is it able to stripe? All it will see are mount points? My understanding is that it is possible create ...
    Ryan_gaffuri_at_comcast.netRyan_gaffuri_at_comcast.net
    Sep 13, 2007 at 2:55 am
    Sep 13, 2007 at 8:25 pm
  • Greetings HP-UX 11.11, 4X4 Server Oracle version: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bi PL/SQL Release 10.2.0.1.0 - Production CORE 10.2.0.1.0 Production TNS for HPUX ...
    BNBN
    Sep 19, 2007 at 8:13 pm
    Sep 20, 2007 at 7:29 pm
  • Hello list, I have a uphill taks of migrating our datawarehouse Oracle 9i database, 3TB size, from HP Superdom to AIX, Oracle 10g. Since the migration is across platofrms, exp/imp is the obvious ...
    Syed Jaffar HussainSyed Jaffar Hussain
    Sep 19, 2007 at 10:43 am
    Sep 20, 2007 at 1:59 pm
  • Hi all, Just a general question about controlfiles. I was ready the archive messages for this list and found out that controlfiles are updated everytime a checkpoint happens. Can anyone list any ...
    Lyall BarbourLyall Barbour
    Sep 11, 2007 at 1:36 pm
    Sep 13, 2007 at 2:57 pm
  • Hello Oracle People, I'd like to run a shell script from the Scheduler in my 10g database. Right now it is a simple shell script. Eventually it will wrap RMAN commands to back up my DB. I wrote a ...
    Owen SmithOwen Smith
    Sep 7, 2007 at 8:56 am
    Oct 11, 2007 at 12:04 pm
  • While trying to restore a RAC database, I had a perplexing problem. OSEE 10.2.0.3 all around rman run { set until time "to_date('29-AUG-2007 17:51:55','DD-MON-YYYY HH24:MI:SS')"; restore database ...
    Charles SchultzCharles Schultz
    Sep 7, 2007 at 6:42 pm
    Sep 14, 2007 at 7:38 pm
  • Hi again, Development question. User wants the sum of all the purchase orders for this year and last year. I'm trying to get it in the same select statement. I want something like this, but don't ...
    Lyall BarbourLyall Barbour
    Sep 11, 2007 at 5:32 pm
    Sep 12, 2007 at 2:48 pm
  • Hello OCP's. I have some free time at night and I'm looking for a good book to read/study from, geared toward the OCP exams. I believe these exams are the 1Z0-042 and 1Z0-043. Any suggestions would ...
    Patrick O'BrienPatrick O'Brien
    Sep 4, 2007 at 10:39 pm
    Sep 9, 2007 at 4:28 am
  • We are in the process of setting up Oracle RAC on Redhat Linux. I need RAC expert's comments for the following questions. What type of filesystem are you using for Oracle datafiles? Are your ...
    Rama.ari_at_accenture.comRama.ari_at_accenture.com
    Sep 4, 2007 at 1:59 am
    Sep 7, 2007 at 3:23 am
  • I asked a similiar question a couple of weeks ago. I have done some more reading and have some additional questions. Here is what I am considering: One bigfile tablespace for my data and one for my ...
    Ryan_gaffuri_at_comcast.netRyan_gaffuri_at_comcast.net
    Sep 26, 2007 at 2:15 am
    Sep 28, 2007 at 7:34 pm
  • I am on Linux x86 OEL4 using Oracle 10.2.0.3. My listener.log is not been updated since the 30 May. cd /opt/oracle/app/oracle/product/10.2.0/db_1/network/log [oracle_at_juk-prod log]$ ll total ...
    Steeve BissonSteeve Bisson
    Sep 26, 2007 at 1:19 am
    Sep 27, 2007 at 12:36 pm
  • Hi All, We are having a lot of Log file sync waits because of frequent commits issued from the third party application. What are the solutions to fix this apart from the follwing one... We are using ...
    DBA DeepakDBA Deepak
    Sep 3, 2007 at 3:48 pm
    Sep 5, 2007 at 6:50 pm
  • Hello, I searched the archives for general ZFS information and found a few threads about ZFS and snapshots. These threads are about a year old. I am wondering if there is any general impression of ...
    Joe FrohneJoe Frohne
    Sep 20, 2007 at 3:07 pm
    Oct 12, 2007 at 12:24 am
  • Folks For an upcoming Multi-Node RAC Benchmark having 10,000 Dedicated Server Database Connections Each, need to setup 20 Listener processes per Node. Need to Simulate the listener Setup on a 2-Node ...
    VIVEK_SHARMAVIVEK_SHARMA
    Sep 25, 2007 at 3:45 pm
    Oct 8, 2007 at 11:57 pm
  • Has any one heard if 11G Data Pump is going to support compression? In some cases, while we would love to go to data pump, we don't have the disk to hold it until it gets compressed. Michael Kline ...
    Kline.MichaelKline.Michael
    Sep 28, 2007 at 12:10 pm
    Sep 28, 2007 at 7:16 pm
  • i am by no means a developer and want to throw this out to the list. i got a pl/sql pkg with some functions and procedures in it. it's working beautifully for other programs that use it within the ...
    Doug GernaatDoug Gernaat
    Sep 14, 2007 at 8:52 pm
    Sep 17, 2007 at 5:04 pm
  • We have a setup where the jobs are run through Autosys on the Oracle 9.2 server (AIX 5L). I've installed oracle client 9.2 on another AIX box. I can connect the database via sqlplus and also able to ...
    Khan, Muhammad SKhan, Muhammad S
    Sep 11, 2007 at 5:34 pm
    Sep 13, 2007 at 2:07 pm
  • Not an answer to your query but just another approach. Wouldn't login.sql do? This runs every time you make a connection and you can set the Sqlprompt to the dbstring here. thanks! amar kumar Padhi ...
    Amar Kumar PadhiAmar Kumar Padhi
    Sep 8, 2007 at 10:18 pm
    Sep 11, 2007 at 1:29 am
  • Ok, I just ran into a strange one this morning. US central time that is. We are moving our clustered databases to new servers, and we put one database onto the new hardware for initial testing. We ...
    Andrew KerberAndrew Kerber
    Sep 26, 2007 at 3:36 pm
    Sep 26, 2007 at 10:52 pm
  • We recently noticed, through Quest Performance Analysis, that a particular index creation statement on a newly populated table occasionally suffers from enqueue waits that extend the creation time ...
    David AldridgeDavid Aldridge
    Sep 12, 2007 at 12:31 pm
    Sep 15, 2007 at 10:19 pm
  • I have a question about Oracle licenses. If you use the dbca to create a set of scripts to use as a model for database creation it will add entries for different options. Such as ultraSearch, ...
    Joe SmithJoe Smith
    Sep 12, 2007 at 4:52 pm
    Sep 14, 2007 at 5:38 am
  • Hello All, I have installed oracle 10g on windows and on linux on two different machines, I need to create a application in which, through front end any changes made to the database on windows that ...
    Nilesh kumarNilesh kumar
    Sep 10, 2007 at 1:13 pm
    Sep 13, 2007 at 5:43 pm
  • We had couple of similar cases in the past. Certain Sys privileges were required to be built into the Application design. I did some analysis and identified that it was best to grant the access using ...
    Amar Kumar PadhiAmar Kumar Padhi
    Sep 4, 2007 at 5:36 am
    Sep 6, 2007 at 1:06 am
  • Hello, This OLEDB/ADO question was asked several times, and I try it once more time. The Oracle ODBC/OLEDB Provider, on certain situations, sends out to the RDBMS dictionary querys on its own (aka ...
    Alvaro Jose FernandezAlvaro Jose Fernandez
    Sep 3, 2007 at 6:07 pm
    Sep 5, 2007 at 11:24 pm
  • Folks Comparative Benchmark is being done for the following 2 Cases:- CASE 1 - When Executing a FULL Set of Transactions on Node 1, with the 2nd Node's RAC instance in SHUTDOWN Condition CPU Usage of ...
    VIVEK_SHARMAVIVEK_SHARMA
    Sep 24, 2007 at 3:36 pm
    Oct 12, 2007 at 6:01 pm
  • List, Does anyone have a list of common DBA tasks, rated by DBA experience required? I'm assuming sites with several DBAs probably have a method for taking on a non-DBA, getting them some training, ...
    Dennis WilliamsDennis Williams
    Sep 23, 2007 at 5:31 pm
    Sep 25, 2007 at 3:37 pm
  • I'm just curious how "big" the conference is, usually? Chances are my employer will foot the bill, but they'll ask some questions like "who else is going?". Any one been before, and know how many ...
    Grant AllenGrant Allen
    Sep 21, 2007 at 12:45 am
    Sep 21, 2007 at 3:30 pm
  • Hello Oracle People, I'm trying to figure out how to import a transportable tablespace I found. The tablespace contains the "sample schema" The export file and corresponding database file look like ...
    Owen SmithOwen Smith
    Sep 15, 2007 at 9:37 am
    Sep 16, 2007 at 6:54 am
  • I'm trying to resolve a client situation which involves a lot of hard parsing and library cache latch waits, and I'm hoping to bounce some ideas off people. The database is 10.2.0.3 on Solaris ...
    Terry SuttonTerry Sutton
    Sep 27, 2007 at 2:51 am
    Sep 27, 2007 at 5:03 pm
  • Hi List, I need to load a cobol file with a record structure (a portion of it) like this: 10 MV-TPR-BILL-AMT-REC-TO-DATE PIC S9(07)V99. 10 MV-TPR-BILL-NH-DIAG-DESC PIC X(30). 10 ...
    GBA-DBAGBA-DBA
    Sep 24, 2007 at 5:22 pm
    Sep 25, 2007 at 12:45 pm
  • It was recommended to us by Oracle to do benchmarking. Anyone use it? What do you think? -- http://www.freelists.org/webpage/oracle-l
    Ryan_gaffuri_at_comcast.netRyan_gaffuri_at_comcast.net
    Sep 15, 2007 at 8:35 pm
    Sep 18, 2007 at 2:13 pm
  • Hi Does any one know in Oracle 9.2 when histograms are involved how is density calculated? Without histograms is 1/NDV but I cant find a suitable way to find the density when there are histograms ...
    LS ChengLS Cheng
    Sep 13, 2007 at 5:28 pm
    Sep 13, 2007 at 9:03 pm
  • We are going through this debate right now. Our 12i Oracle Apps will be Oracle 10.2 on Linux Oracle Unbreakable, Dell hardware. EMC San Storage. Dell is pushing OCSF and Oracle is pushing ASM I have ...
    Kathy duretKathy duret
    Sep 13, 2007 at 4:32 pm
    Sep 13, 2007 at 6:39 pm
  • Hi, All, I recently patched our 2-node RAC (10.2.0.2 on RHEL AS 4 update 4) to 10.2.0.3. I got the impression that you can do rolling upgrade in a RAC environment, until I dig into the patch ...
    Li LiLi Li
    Sep 10, 2007 at 4:48 pm
    Sep 11, 2007 at 3:00 pm
  • In the EM, we can view the CPU usage at the server(OS) level that the CPU I/O wait is very high. And from the database level, statspack will tell use the time about IO, such as scatter read or ...
    Qihua wuQihua wu
    Sep 29, 2007 at 9:19 pm
    Oct 3, 2007 at 4:38 pm
  • Hi All, I would like to know if anyone has tried the role transition between primary and the physical standby in a real production environment. We have a situation to switch the roles for couple of ...
    Senthil SubramanianSenthil Subramanian
    Sep 30, 2007 at 11:59 pm
    Oct 2, 2007 at 11:58 pm
  • What books/classes would you recommend for someone taking on a RAC implementation and support of a company's key revenue system? I am a certified DBA and I have worked with Oracle Applications for ...
    Nancy IlesNancy Iles
    Sep 28, 2007 at 3:25 am
    Sep 29, 2007 at 7:14 pm
  • Hi all, Sorry for the dodgy earlier version (could fail with div by 0 error), here's an improved version: select --snap_time trunc(snap_time,'HH24') snap_time_hr Don't forget the group by if you ...
    Tony AdolphTony Adolph
    Sep 20, 2007 at 12:23 am
    Sep 27, 2007 at 6:35 am
  • We have ORACLE 10GR2 on LINUX server. I am testing RMAN function and found some syntax issue need help: If I use "set until time "to_date('2007-09-21:15:00:00','YYYY-MM-DD:hh24:mi:ss')"; it work ...
    Dba1 mccDba1 mcc
    Sep 25, 2007 at 3:15 pm
    Sep 25, 2007 at 5:17 pm
  • We are building a web application that will be accessing a database cache for its queries. Essentially, the system of record will be polled periodically and any updates will be applied to the cache ...
    Peter BarnettPeter Barnett
    Sep 19, 2007 at 1:43 am
    Sep 20, 2007 at 5:38 pm
  • We were hitting shared memory errors. Googled it and this is common when an Oracle install is wrong. I looked into it and the kernel parameters were never set(I didnt do the install). This is in ...
    Ryan_gaffuri_at_comcast.netRyan_gaffuri_at_comcast.net
    Sep 19, 2007 at 3:00 pm
    Sep 20, 2007 at 1:54 am
Sep 2007
1234
Group Navigation
period‹ prev | Sep 2007 | next ›
Group Overview
grouporacle-l @
categoriesoracle
discussions164
posts848
users208
websiteoracle.com

208 users for September 2007

Alvaro Jose Fernandez: 46 posts LS Cheng: 31 posts Jared Still: 25 posts Don Seiler: 24 posts Niall Litchfield: 21 posts Hemant K Chitale: 17 posts Ryan_gaffuri_at_comcast.net: 15 posts Andrew Kerber: 14 posts Nigel Thomas: 14 posts Alberto Dell'Era: 13 posts Genegurevich_at_discover.com: 13 posts John Hallas: 12 posts Owen Smith: 12 posts Pras N: 12 posts Robert Freeman: 12 posts Allen, Brandon: 11 posts David Sharples: 10 posts Greg Rahn: 10 posts Rajeev Prabhakar: 10 posts Stefan Knecht: 10 posts
show more
Archives