Search Discussions

237 discussions - 1,142 posts

  • Hi all: I'm using Oracle9204 and we have been running into a following problem lately. My users execute the following command alter table owner.table exchange partition part1 with table ...
    Mar 8, 2006 at 5:39 pm
    Jun 20, 2006 at 5:46 pm
  • Is there anyway to map sessionid (or any other parameter) from dba_audit_session to a specific process to get more information on what it actually is that is running? My system password keeps locking ...
    J. DexJ. Dex
    Mar 29, 2006 at 2:47 pm
    Apr 3, 2006 at 6:06 pm
  • Hi List, What is the best practice for installing two 9i instance in a Solaris 10 environment? No zones or containers. Any white paper or website on this? Also, where do I get the evaluation software ...
    Roger XuRoger Xu
    Mar 30, 2006 at 3:17 pm
    Apr 1, 2006 at 12:47 am
  • I am wondering how other shops handle security changes relating to password complexity. We just implemented a lot of security features into our database including password complexity. The users login ...
    J. DexJ. Dex
    Mar 2, 2006 at 8:49 pm
    Mar 4, 2006 at 1:41 am
  • Hi, Are 'solid state disks' a viable technology to build Oracle DBs, or are they still 'a niche'? I'd appreciate if anybody could share their experience or point me to recent literature (case ...
    Luca CanaliLuca Canali
    Mar 9, 2006 at 9:16 am
    Mar 13, 2006 at 4:01 pm
  • Hi, The execution plan for a query in oracle 9i shows "Optimizer= CHOOSE", how can i force the DB engine to use the COST based optimization for a query ? Oracle version is Thanks Savio ...
    Savio Pinto (s)Savio Pinto (s)
    Mar 2, 2006 at 3:27 pm
    Mar 3, 2006 at 3:38 pm
  • Sorry if this is a bit off topic, but I imagine that a few of you may have encountered this in the past... Recently, I have observed a couple different Linux boxes (I'm reasonably sure both were ...
    Mark BrinsmeadMark Brinsmead
    Mar 10, 2006 at 7:05 am
    Mar 16, 2006 at 12:14 am
  • We are considering OpenSource for less critical databases to reduce Licence and Maintenance costs. MySQL apparently does have Annual Fees (or Support). Does Postgres have Annual Fees ? Technically ...
    Hemant K ChitaleHemant K Chitale
    Mar 20, 2006 at 3:29 pm
    Mar 22, 2006 at 6:45 pm
  • Hi, Well, I am a final year B.E. student doing a project on Grid and we selected the oracle 10g database for the project. Now, we have installed the database, client and evrything but are confused ...
    Marwin saldanhaMarwin saldanha
    Mar 1, 2006 at 5:23 am
    Mar 5, 2006 at 11:06 pm
  • Hi I am going to install a 10gR2 RAC in a couple of weeks. It will be RHEL 4 Update 2 and I will be using ASM for all database files. However I have some doubts, I am wondering if ASMLib API gives ...
    LiShan ChengLiShan Cheng
    Mar 7, 2006 at 9:54 am
    Mar 10, 2006 at 7:40 am
  • If I recall, Oracle has a tool that can read datafiles and assemble the data is some type of useable format, from a crashed database. We have a database that we may need this type of tool ...
    Fedock, John (KAM.RHQ)Fedock, John (KAM.RHQ)
    Mar 22, 2006 at 9:31 pm
    Mar 31, 2006 at 7:28 am
  • Hello, We are currently evaluating hw replacement: Sun Fire 440 4 processors - T2000 8 cores. I'd appreciate if anybody could share his/her experience of moving DBs from Sun Fire 440 to T2000, or ...
    Vlad SadilovskiyVlad Sadilovskiy
    Mar 27, 2006 at 5:32 pm
    Mar 30, 2006 at 7:22 pm
  • Folks, It seems that truncating a table under RAC is more expensive than truncating it under a single instance because of the dictionary cache synchronization. We converted a single instance to a ...
    Hameed, AmirHameed, Amir
    Mar 15, 2006 at 3:59 pm
    Mar 29, 2006 at 4:25 am
  • Hi, all, I just started to look into RMAN backup and recovery and have a question: for example, it takes 2 hours for RMAN to backup the database, how much impact will RMAN have on the database during ...
    Li LiLi Li
    Mar 9, 2006 at 4:42 pm
    Mar 10, 2006 at 11:31 pm
  • Hi :) I can be wrong, But personally I had seen several people who only answer offline about database topics, and I must say very good answer that should be done publicly. And severla of them are ...
    Juan Carlos Reyes PachecoJuan Carlos Reyes Pacheco
    Mar 31, 2006 at 9:30 pm
    Apr 3, 2006 at 10:13 pm
  • Hi list Does anyone has an interesting idea about how to use, specially for tuning, ora_hash or DBMS_UTILITY.GET_HASH_VALUE, to get hash values. One is to encrypt, but I was asking about the ...
    Juan Carlos Reyes PachecoJuan Carlos Reyes Pacheco
    Mar 21, 2006 at 1:37 pm
    Mar 23, 2006 at 1:44 am
  • Does anyone have a standard procedure for doing db refreshes that they'd be willing to share? I'd be going from Production down to test and development dbs. These were usually done by a co-worker who ...
    Coleman, Kelley (HAC)Coleman, Kelley (HAC)
    Mar 21, 2006 at 3:58 pm
    Mar 22, 2006 at 10:51 pm
  • Reading through some very long and complicated SQL trace files today, I find I frequently have to go grep the code to try to find out where the SQL originated from. Do you think a comment in the SQL ...
    Ethan PostEthan Post
    Mar 17, 2006 at 8:45 pm
    Mar 18, 2006 at 2:22 pm
  • Even with specifying DEGREE=4, the dbms_stats internally generates this Hint to use no_parallel_index when processing the Indexes for the table being analyzed. Any ways to force it to use parallel or ...
    Deepak SharmaDeepak Sharma
    Mar 29, 2006 at 8:26 pm
    Apr 11, 2006 at 3:51 pm
  • I have a script that does the following: ########################################################### echo "EXPORT FOR $DBNAME" $LOGFILE echo "----------------------------------------------------" ...
    Stankus, PaulaStankus, Paula
    Mar 20, 2006 at 9:39 pm
    Mar 21, 2006 at 3:51 pm
  • Dear list, we have some PL/SQL procesdures that submit jobs to our 8i database. And we have a logon trigger that sets an application context like this: dbms_session.set_context('BENUTZER', ...
    Peter AlteheldPeter Alteheld
    Mar 2, 2006 at 1:25 pm
    Mar 2, 2006 at 7:30 pm
  • 11


    My boss asked me what logs we can have our HelpDesk monitor for errors. Other than the alert log, what other logs can they look at? We are running oracle ERP on HP unix. Are there OS logs they can ...
    Zelli, BrianZelli, Brian
    Mar 1, 2006 at 3:04 pm
    Mar 2, 2006 at 2:27 pm
  • Hi, All, Has anybody used Oracle Advanced Security to encrypt all the network traffic between client and server? I set up the following in sqlnet.ora both on the client and server, but it didn't ...
    Li LiLi Li
    Mar 16, 2006 at 2:41 pm
    Jun 13, 2006 at 9:27 pm
  • I just found the following in the 10.2 documentation on licensing for the Diagnostics Pack ( http://download-west.oracle.com/docs/cd/B19306_01/license.102/b14199/options.htm#CIHHIGBI): Oracle ...
    Allen, BrandonAllen, Brandon
    Mar 1, 2006 at 8:35 pm
    Mar 2, 2006 at 2:57 pm
  • Hi, We are currently on 8.1.7 and considering upgrade to 10G. I would like to know any opinions or list of issues to expect for this. Maybe this issue has been discussed already on this forum in ...
    A JoshiA Joshi
    Mar 18, 2006 at 4:58 pm
    Apr 10, 2006 at 7:29 pm
  • Can anyone let me know why the advisory is saying i can so drastically reduce my PIO's by reducing my db_cache_size? I have looked around the web and have never seen an explanation for this. I also ...
    Stephen AndersonStephen Anderson
    Mar 28, 2006 at 8:45 am
    Mar 29, 2006 at 10:21 am
  • Hi everybody: I'm importing a table with 9M records and when I use commit=N it takes about 5 hours and with commit=Y it takes about 14hours. (NO INDEXES) Would anybody can tell me why? it shouldn't ...
    Alfonso LeónAlfonso León
    Mar 22, 2006 at 7:14 pm
    Mar 23, 2006 at 12:56 am
  • Has anyone been able to view a 10g DB w OEM? I'm having difficultly transitioning to Grid Control or dbcontrol. At this point I'm finding it awkward and time-consuming using it as a replacement for ...
    Mar 1, 2006 at 5:53 pm
    Mar 1, 2006 at 9:47 pm
  • Hi, Is 9i supported with Solaris 10? Any comments on running two instances of oracle on two different zones in a SUN V490 server? Thanks, Roger Xu This e-mail is intended solely for the person or ...
    Roger XuRoger Xu
    Mar 24, 2006 at 4:13 pm
    Mar 24, 2006 at 10:54 pm
  • We have a large datawarehouse database on Oracle and are encountering strange performance problems. A query such as "select count(*) from dba_data_files;" will run in a few seconds or as long as 15 ...
    Ebadi, AbdulEbadi, Abdul
    Mar 23, 2006 at 5:19 pm
    Mar 23, 2006 at 7:01 pm
  • Hi, While redeclaration of variables is not allowed in anonymous blocks, the same is being allowed in Package specs. What could be the reason behind it ? Following script can give you a test case ...
    Manu SankarManu Sankar
    Mar 16, 2006 at 1:54 pm
    Mar 20, 2006 at 1:15 pm
  • � Hi, The following is a portion of a sql query that extracts data from an XML source. I would like to get the sequence/position number of the current node, but I can't seem to find the right ...
    Davey, AlanDavey, Alan
    Mar 16, 2006 at 9:42 pm
    Mar 18, 2006 at 4:27 pm
  • HI, I recived a link to for java from Kuassi today, http://www.oracle.com/technology/tech/java/jsp/index.html This is different from the one you find on otn at the left ...
    Juan Carlos Reyes PachecoJuan Carlos Reyes Pacheco
    Mar 15, 2006 at 1:54 pm
    Mar 16, 2006 at 9:46 pm
  • Hi all Looking for best practice for allowing Oracle Network (functionality) thru a firewall. Scenario Client wants to allow external clients to access information in the internal network as well as ...
    Tony JambuTony Jambu
    Mar 6, 2006 at 2:15 pm
    Mar 14, 2006 at 6:19 pm
  • Anybody seen this before? Oracle on AIX 5.2: SQL show parameter db_file_multiblock_read_count NAME TYPE VALUE ------------------------------------ ----------- ----- ...
    Allen, BrandonAllen, Brandon
    Mar 10, 2006 at 11:44 pm
    Mar 14, 2006 at 5:31 pm
  • Hello gurus, I searched on this list for ADDM. I did not find the answer on this topic. Are ADDM and its successors going to put DBAs out of jobs? or reduce the number of DBAs required? I read about ...
    Ram KRam K
    Mar 4, 2006 at 11:04 pm
    Mar 6, 2006 at 11:26 pm
  • Hi, We have a schema named User1 that owns all the objects of the application. Now we need to create 3-4 dynamic schema's User2-User5 that will have about 10 tables each and we want to give full ...
    Harvinder SinghHarvinder Singh
    Mar 28, 2006 at 9:28 pm
    Jul 31, 2006 at 7:06 pm
  • Hello, I'm new to oracle dba responsibilities and in need of some direction. I need to implement a process and I'm not sure which technologies and/or processes I should investigate. Our application ...
    Tricia McKellarTricia McKellar
    Mar 21, 2006 at 12:26 am
    Mar 21, 2006 at 4:49 pm
  • Had you read this? Is this better than using java? Any experience? http://www.oracle.com/technology/pub/articles/mastering_dotnet_oracle/williams_sps.html -- http://www.freelists.org/webpage/oracle-l
    Juan Carlos Reyes PachecoJuan Carlos Reyes Pacheco
    Mar 15, 2006 at 2:15 pm
    Mar 20, 2006 at 12:55 pm
  • Hi, all I have a question, just for curious. I can prove "alter system dump datafile # block #" will *NOT* read the block into buffer cache although that block is not in the buffer cache. But, can ...
    Leyi Zhang (Kamus)Leyi Zhang (Kamus)
    Mar 12, 2006 at 5:35 pm
    Mar 14, 2006 at 9:49 am
  • Folks, I need some help in understanding why a job is taking longer when it is run in multiple nodes under RAC versus a single node in RAC and with RAC disabled. I generated trace files with 10046 at ...
    Hameed, AmirHameed, Amir
    Mar 9, 2006 at 6:41 pm
    Mar 26, 2006 at 3:54 pm
  • Hello list, We have recently moved our datawarehouse oracle database 9i Rel.2 from AIX to HP-SUPERDOM, using export and import utility. Well, I have used the same init file for both database, i.e ...
    The Human FlyThe Human Fly
    Mar 25, 2006 at 7:55 am
    Mar 26, 2006 at 9:12 am
  • Hello list, How can I rewrite the query which uses concatination in the where clause? For an example, SELECT ...... FROM where COLUMN = 'S'||'VALUE2'; Thanks for your time. -- Best Regards, Syed ...
    The Human FlyThe Human Fly
    Mar 21, 2006 at 3:10 pm
    Mar 21, 2006 at 4:11 pm
  • Does anyone have any insight as to why taking an export w/ rows=n would take many, many hours? Details are as follows: Solaris 8, running Oracle, 64 bit Schema being exported has 2,451 ...
    Bobak, MarkBobak, Mark
    Mar 17, 2006 at 3:49 pm
    Mar 19, 2006 at 4:14 pm
  • Hi, One of my friend was experiancing a terrible response time after RAC upgrade( on Solaris 9. I started with checking environment setup and found the following netstat -ni output shows Name ...
    Sriram KumarSriram Kumar
    Mar 13, 2006 at 2:59 pm
    Mar 15, 2006 at 3:09 pm
  • Hi, I've traced a long running piece of SQL and observed the following in the trace file (only a small sample): WAIT #3: nam='direct path read' ela= 3 p1=202 p2=641041 p3=1 WAIT #3: nam='direct path ...
    Chris DunscombeChris Dunscombe
    Mar 7, 2006 at 10:14 am
    Mar 15, 2006 at 7:52 am
  • Hi I just installed Oracle Clusterware using VMWare Workstation 5.5. I noticed the two virtual machines clocks get out of synch. The voting disk and OCR files which are located in a shared storage ...
    LiShan ChengLiShan Cheng
    Mar 8, 2006 at 2:48 pm
    Mar 8, 2006 at 4:06 pm
  • Hi I have a server (Windows Server ) with Oracle EE with databases using Data Guard. (Oracle 9iR2) There is an Oracle Listener (1521) and Oracle Data Guard Listener (1748) on a server. If I TNSPING ...
    Tony JambuTony Jambu
    Mar 7, 2006 at 12:55 pm
    Mar 8, 2006 at 10:55 am
  • Trying to run opatch and it fails per below. However, inventory command works. [oracle_at_RHGC 4716787]$ /home/oracle/OracleHomes/agent10g/OPatch/opatch apply Oracle Interim Patch Installer version ...
    Jeffrey BeckstromJeffrey Beckstrom
    Mar 27, 2006 at 2:07 pm
    Mar 27, 2006 at 7:44 pm
  • Anyone have any tips about re-starting RMAN with netbackup? Is it possible to re-start from where backup died? TIA LArry The information contained in this communication is confidential, is intended ...
    Wolfson Larry - lwolfsWolfson Larry - lwolfs
    Mar 22, 2006 at 12:46 am
    Mar 22, 2006 at 5:26 pm
Group Navigation
period‹ prev | Mar 2006 | next ›
Group Overview
grouporacle-l @

243 users for March 2006

LiShan Cheng: 40 posts Juan Carlos Reyes Pacheco: 38 posts Oracle-l-bounce_at_freelists.org: 33 posts Jared Still: 30 posts Kevin Closson: 29 posts Baumgartel, Paul: 21 posts Ethan Post: 21 posts Bobak, Mark: 20 posts Dennis Williams: 20 posts Mladen Gogala: 20 posts Reidy, Ron: 20 posts Rjamya: 20 posts Ray Stell: 18 posts Kevin Lidh: 16 posts Michael McMullen: 16 posts Christian Antognini: 15 posts David Sharples: 14 posts Hemant K Chitale: 13 posts Radoulov, Dimitre: 13 posts Genegurevich_at_discoverfinancial.com: 12 posts
show more