FAQ

Search Discussions

168 discussions - 848 posts

  • We aren't sure WHAT is the discrepancy that you see -- whether it relates to specific types of segments or depends on extent sizes. See MetaLink Note#463101.1 Hemant K Chitale ...
    Hemant K ChitaleHemant K Chitale
    Mar 11, 2009 at 3:41 pm
    Jul 8, 2009 at 10:00 pm
  • I find myself constantly struggling with developers constructing views on top of views on top of still other views. I understand this makes their job easier in the short run but whenever problems ...
    Stephens, ChrisStephens, Chris
    Mar 26, 2009 at 3:27 pm
    Mar 27, 2009 at 7:10 pm
  • Hi all... I came across this question on twitter (http://twitter.com/Michael_Corey). How do you prevent DBA burnout? I know there are a lot of smart people on this list - any thoughts? I replied via ...
    Jerry CunninghamJerry Cunningham
    Mar 30, 2009 at 1:44 pm
    Mar 31, 2009 at 12:11 am
  • Hi all, I wonder if you can share how you manage your tnsnames.ora file. I currently have about a dozen database servers and each one has tnsnames.ora locally. Whenever IP, server name, ... gets ...
    Eugene PipkoEugene Pipko
    Mar 3, 2009 at 6:25 pm
    Apr 29, 2009 at 9:19 pm
  • Hello List, I am pretty much stuck on a bitmap costing problem. I have a query on a table with 10M rows (709MB), and the predicates are correctly estimated to return 800 000 rows. As a result with ...
    Christo KutrovskyChristo Kutrovsky
    Mar 27, 2009 at 8:40 pm
    Mar 30, 2009 at 4:37 pm
  • Hi We have exported 8i database and imported into 10g using full=y. After this i notice useres complaining about unique constraint violation as the sequence numbers have a value less then the primary ...
    HrishyHrishy
    Mar 13, 2009 at 9:46 am
    Mar 16, 2009 at 2:39 pm
  • Hi Gurus, I get below error while trying to change the permission of oracle directory. Kindly advice were could be the problem Bash[]$ id uid=200(oracle) gid=200(dba) groups=200(dba),201(oinstall) ...
    Nagaraj SNagaraj S
    Mar 3, 2009 at 1:22 pm
    Mar 4, 2009 at 1:06 am
  • Hi, I want to update a stored outline to change the join method. Is there a way it can be done from sqlplus instead of from OEM or tool. Using just unix sqlplus access. I looked at DBMS_OUTLN package ...
    A JoshiA Joshi
    Mar 18, 2009 at 2:12 pm
    Mar 20, 2009 at 6:27 pm
  • Sys admin wants to change the hostname of the server running Oracle 10. What oracle configuration do I need to change so oracle will still work? John -- http://www.freelists.org/webpage/oracle-l
    John DunnJohn Dunn
    Mar 31, 2009 at 12:48 pm
    Apr 2, 2009 at 4:47 am
  • Hi all, I have a need for a java app to be able in some guaranteed manner to grab a block of sequence values that are consecutive in order. Given the fact that there can potentially be multiple ...
    FmHabashFmHabash
    Mar 24, 2009 at 5:20 pm
    Mar 26, 2009 at 10:02 am
  • Greetings, I am running oracle 10.2.0.3 SE. We are in the process of implementing CAS (Central Authentication Service). The request has been made to use an existing production database to house the ...
    William WagmanWilliam Wagman
    Mar 31, 2009 at 11:07 pm
    Apr 10, 2009 at 5:01 am
  • Manual upgrade 10.1.0.4 to 10.2.0.4 HP UNIX Have any of you guys encountered this situation when running the pre upgrade script (utlu102i.sql)? (output pasted below) The upgrade manual shows the ...
    OrclOrcl
    Mar 31, 2009 at 12:53 pm
    Apr 2, 2009 at 11:08 pm
  • The long running thread on monitoring tools has piqued my curiosity. What would you say are the essentials for database monitoring? Here's a list of things I consider important and track closely ...
    Jared StillJared Still
    Mar 31, 2009 at 9:02 pm
    Apr 7, 2009 at 3:59 am
  • OK, I am the first one to admit I very rarely am called upon to write SQL, so when some does come along I have to struggle. What I need to do is insert some information into a table and include a ...
    Robertson Lee - lerobeRobertson Lee - lerobe
    Mar 6, 2009 at 5:26 pm
    Mar 6, 2009 at 5:55 pm
  • Hi Guys: Is there a tool out there that would sniff out my network and find all the oracle installs, versions, hardware info on the servers etc? Thanks, Manjula -- ...
    Manjula KrishnanManjula Krishnan
    Mar 16, 2009 at 8:00 pm
    Mar 24, 2009 at 3:55 pm
  • Hallo Listers, I am on site by a pretty creative customer. Developers want to partition a (fact) table(s) to the smallest slice possible. The number of calculated/estimated partitions is 200 000 - ...
    Milen KulevMilen Kulev
    Mar 30, 2009 at 4:47 pm
    Apr 9, 2009 at 3:34 pm
  • We moved from one node rac to 2 node rac. A simple query takes 9 seconds instead of 0.3 second. The user activated 10046 trace and I see a lot of "gc current block 2-way". Help urgently required ...
    Yechiel AdarYechiel Adar
    Mar 15, 2009 at 9:37 am
    Mar 18, 2009 at 2:18 am
  • We are seeing packages invalidated in our production database and I don't have a clue how to track down the actual cause. I've taken a look at dba_dependencies and know the potential candidates for ...
    Stephens, ChrisStephens, Chris
    Mar 12, 2009 at 3:23 pm
    Mar 15, 2009 at 12:25 pm
  • Hi Vivkek, should not be if you are taking care of indexes... thanks and take care..subodh From: VIVEK_SHARMA To: ORACLE-L Sent: Monday, 9 March, 2009 18:49:57 Subject: Number of Columns in a Table & ...
    Subodh DeshpandeSubodh Deshpande
    Mar 9, 2009 at 2:45 pm
    Mar 10, 2009 at 5:30 pm
  • What about using Oracle Streams ? Or if not possible use logminer. You would only have to dump some extra info in the transaction to 'bind it' to a specific user. -- Christo Kutrovsky Senior DBA The ...
    Christo KutrovskyChristo Kutrovsky
    Mar 4, 2009 at 4:17 pm
    Mar 9, 2009 at 2:08 pm
  • Hi I am trying to tune a query which is attached along with the plan. In some of the steps the estimated cardinality and actual rows is way off . esp step 7,8,9,10,11 As a result of the wrong ...
    HrishyHrishy
    Mar 6, 2009 at 9:41 am
    Mar 9, 2009 at 10:10 am
  • confio makes one ... i forgot the name. Raj -- http://www.freelists.org/webpage/oracle-l
    RjamyaRjamya
    Mar 26, 2009 at 2:49 am
    Mar 31, 2009 at 11:03 pm
  • Hi all, I have a file that I am moving from Windows to the Linux box. The file looks like: "1,2,3,....." "1,2,3,....." So, every like is in double quotes. How can I open the file and remove them ...
    Eugene PipkoEugene Pipko
    Mar 24, 2009 at 11:08 pm
    Mar 25, 2009 at 5:04 am
  • I plan on activating sys 10046 trace, to find a problem that occurs late at night. I have about 21 GB free space on the server. What happened when this fill up? That will stop also the alert log from ...
    Yechiel AdarYechiel Adar
    Mar 17, 2009 at 7:45 am
    Mar 18, 2009 at 4:48 pm
  • How can I tell how many parallel threads were spawned by a parallel query after the query completed. I have a query that normally takes a couple hours but ran for 24 hours over the weekend. My theory ...
    Kenneth NaimKenneth Naim
    Mar 11, 2009 at 1:35 pm
    Mar 15, 2009 at 3:36 pm
  • ('binary' encoding is not supported, stored as-is) Does the dblink name have to be the same as the SID name? -- Lyndon Tiu -- http://www.freelists.org/webpage/oracle-l
    Lyndon TiuLyndon Tiu
    Mar 12, 2009 at 6:51 pm
    Mar 15, 2009 at 9:27 am
  • I am looking at how to consolidate various RMAN backups to be scheduled and managed through Grid. Currently we have a mixture of Grid, crontab and 3rd party schedules running RMAN jobs. I am guessing ...
    John HallasJohn Hallas
    Mar 1, 2009 at 9:26 am
    Mar 5, 2009 at 2:40 pm
  • Hi Lists, I need to configure streams for tables within database (From schema A to B) which i feels difficult since my configuration just fails. Can someone help me with the steps on configuring ...
    Gidhin joyGidhin joy
    Mar 9, 2009 at 12:58 pm
    Mar 27, 2009 at 3:41 pm
  • Hi Some indexes were build using the nologging option. This creates corruption when the instance is refreshed. Now they need to be converted to logging option. I have two options to do this. Alter ...
    Kumar MadduriKumar Madduri
    Mar 21, 2009 at 3:47 pm
    Mar 25, 2009 at 12:04 pm
  • I have spotlight and use OEM however this doesn't allow me to dynamically set the thresholds for table size so I can say find that tablespace data now needs at least 10g of space not 5g due to a ...
    Howard LathamHoward Latham
    Mar 16, 2009 at 6:34 pm
    Mar 19, 2009 at 10:56 am
  • Gotta love that old Panic and Point dance...Why not just increase the temp space to 42 terabytes and kick all users out of the database? I presume that the session who consumed the temp space was ...
    Daniel FinkDaniel Fink
    Mar 11, 2009 at 4:13 pm
    Mar 13, 2009 at 7:58 am
  • can anyone tell me when this first came out - I'm guessing between v7 in 1992 and v8 in 1997, probably in 7.3.4 but would really like a definitive answer -- Niall Litchfield Oracle DBA ...
    Niall LitchfieldNiall Litchfield
    Mar 3, 2009 at 6:48 am
    Mar 7, 2009 at 6:57 am
  • Greetings, With the usual caveats that we are not lawyers, I would like your opinion on licensing and annual support. The question is whether annual support is required to use licensed products. The ...
    M HandM Hand
    Mar 5, 2009 at 2:01 pm
    Mar 6, 2009 at 6:28 am
  • Hi there! Does anybody now where I can find until when Oracle supports 10G R2 Database? Thanks! Rob -- http://www.freelists.org/webpage/oracle-l
    RobRob
    Mar 2, 2009 at 3:10 pm
    Mar 3, 2009 at 2:09 pm
  • List, Some security auditors are stating that the ALL_ views are a security risk and are recommending that I revoke them. In particular, they are pointing to ALL_USERS as offering a hacker useful ...
    Dennis WilliamsDennis Williams
    Mar 30, 2009 at 2:32 pm
    Apr 1, 2009 at 1:06 pm
  • After having read some documentation, I am still confused. Is the process of running analyze gathering statistics automated in 10g (specifically 10.2.0.3) or is there still something that needs to be ...
    J. DexJ. Dex
    Mar 30, 2009 at 8:29 pm
    Mar 31, 2009 at 2:48 pm
  • Hi, I have OEM java console 9, 10g installed on windows xp. I can start it up and go to the database connect information screen. Then after I enter the connect information and click OK nothing ...
    A JoshiA Joshi
    Mar 18, 2009 at 2:15 pm
    Mar 20, 2009 at 1:50 am
  • Platform: Windows 23k Server SP2 64bit Oracle: 10.2.0.4 EE I have two databases for which both audit_file_dest and audit_sys_operations are set. NAME VALUE VAL? MOD? MOD? ------------------------- ...
    Jared StillJared Still
    Mar 18, 2009 at 11:29 pm
    Mar 19, 2009 at 9:23 am
  • Hello All, Env - Solaris 9, oracle 9.2.0.4 Getting the following while restoring archivelogs, all the datafiles get restored successfully but fails at while restoring archivelogs executing command ...
    Arvind KumarArvind Kumar
    Mar 17, 2009 at 6:33 pm
    Mar 18, 2009 at 4:46 pm
  • In Oracle 8 and 9 we saw that at 1000 extents performance began to drop off. At 2K extents it leapt, laughing maniacally off a cliff. I know that 10g is supposed to handle much more than that without ...
    Joel WittenmyerJoel Wittenmyer
    Mar 13, 2009 at 10:50 pm
    Mar 16, 2009 at 2:59 pm
  • Last night I tried to do: alter table move lob ... and the database froze on archive log destination full. From the docs I see that using the NO LOGGING clause will stop also later changes to be ...
    Yechiel AdarYechiel Adar
    Mar 15, 2009 at 6:32 am
    Mar 15, 2009 at 9:35 am
  • Hi All, On Unix if I want to confirm that a database is shutdown I can run a ps and check for absense of smon/pmon etc. and also run ipcs if really paranoid. On Windows the Windows Service might be ...
    Charlotte HammondCharlotte Hammond
    Mar 11, 2009 at 5:42 pm
    Mar 12, 2009 at 6:53 am
  • Hi, I have this application that archives data to a different schema on the same instance using database link. This is probably due to the fact that in the Production environment it is archived to a ...
    Romeo YbanezRomeo Ybanez
    Mar 10, 2009 at 10:13 am
    Mar 11, 2009 at 6:40 am
  • also you can check if they are part of the cluster registry (crs_stat) Alan Bort Oracle Certified Professional -- http://www.freelists.org/webpage/oracle-l
    Guillermo Alan BortGuillermo Alan Bort
    Mar 27, 2009 at 1:53 pm
    Apr 19, 2009 at 6:24 pm
  • Oracle 10.1.latest patch OS: Tru 64 oracle does not have 10.2 for tru 64. This just started to happen. We have not changed anything. If we login from the command line on the server and bypass sqlnet ...
    Dba DBADba DBA
    Mar 30, 2009 at 3:38 pm
    Apr 2, 2009 at 1:50 am
  • Greetings, Our test/development databases are on Oracle 10.2.0.4.0 64-bit running on Windows Server 2003 Enterprise x64 edition, v5.2 SP2. We have just moved our production database, also Oracle ...
    William WagmanWilliam Wagman
    Mar 20, 2009 at 6:44 pm
    Mar 23, 2009 at 3:25 pm
  • Hello Wizards of the Oracle-L list. I'm facing an issue of accessing data from an MS ACCESS database from an Oracle 10gR2 instance. I've successfully been able to setup Oracle XE (to use the Oracle ...
    Langston, ChrisLangston, Chris
    Mar 17, 2009 at 9:51 pm
    Mar 19, 2009 at 6:28 pm
  • Hi We are planning to install RAC on solaris without using any third party clutser filesystem. On linux we use OCFS2 for the OCR and voting disk. At this moment SAN or NAS is not finalized. My ...
    HrishyHrishy
    Mar 17, 2009 at 3:19 pm
    Mar 19, 2009 at 11:25 am
  • Hi, I need windows scripts to monitor 9i database(win 2003 server) 1)database and listener up and down status 2)alert log scan 3)alert log rename Thanks for any help Reg, Ed -- ...
    Edwin devadanamEdwin devadanam
    Mar 15, 2009 at 2:28 pm
    Mar 16, 2009 at 9:36 pm
  • Hi list! I'm trying to import a table with about 8 million rows in to oracle 9.2.0.6 EE on solaris 10. The import starts as you would expect but seems to hit a wall at about 2 million rows and the ...
    David CheyneDavid Cheyne
    Mar 12, 2009 at 2:47 pm
    Mar 13, 2009 at 3:53 pm
Group Navigation
period‹ prev | Mar 2009 | next ›
Group Overview
grouporacle-l @
categoriesoracle
discussions168
posts848
users201
websiteoracle.com

201 users for March 2009

Jared Still: 40 posts Riyaj Shamsudeen: 27 posts Bobak, Mark: 24 posts Hrishy: 22 posts FMHabash: 19 posts Mark W. Farnham: 17 posts Yechiel Adar: 16 posts : 14 posts Genegurevich_at_discover.com: 14 posts Goulet, Richard: 14 posts Greg Rahn: 14 posts Amar Padhi: 13 posts Kenneth Naim: 12 posts Yong Huang: 12 posts Eugene Pipko: 11 posts Howard Latham: 11 posts Allen, Brandon: 10 posts Crisler, Jon: 10 posts Rich Jesse: 10 posts Toon Koppelaars: 10 posts
show more
Archives