Description:
Oracle database administration/server topics.
|
|
|
Unable to disable tracing - XE
|
| |
... or at least I would be if I had any. I am running a copy of 10G XE on a WinXP box. In a troubleshooting session some time ago, I turned on some additional tracing - and quite simply have been unable to turn it off. Below is an extract from one of my .trc files in my bdump directory. It's the alter session statements in this trace that I want to disable... more »
|
|
|
what's the internal transaction table for....
|
| |
The 10g discussion of transaction commitment has this: The internal transaction table for the associated undo tablespace that the transaction has committed, and the corresponding unique system change number (SCN) of the transaction is assigned and recorded in the table. which the 11g manual corrects to:... more »
|
|
|
rant - does oracle know how to design a website?
|
| |
I think I see the method behind the new metalink, or "my oracle support" for that matter. Make it as frustratingly clunky and user unfriendly as humanly (or not) possible, and support calls will go down, along with that "unsatisfied" support calls. I know for me it is a last resort after I have exhausted all other avenues.... more »
|
|
|
Best way to duplicate 11g table and range partition
|
| |
Hello I'm looking to do some 11g performance testing on insert rates with tables that are split by range into various partitions. I don't want to have to keep pre-filling my table/partition every time I start a new test (as the partition volume will increase every time I carry out each test). What would be the best way to either duplicate the table and... more »
|
|
|
Fwd: கம்ப்யூட்டர் மூலமாக அதிகம் பணம் சம்பாதிக்க
|
| |
Invitation to join RupeeMail! Hi , I have something interesting for you, RupeeMail! It’s really amazing! You get paid to open & read the contents of RupeeMail. You receive promotional offers & special discounts in RupeeMail. Interestingly RupeeMails will reach you based on the preference list you opted for.... more »
|
|
|
Why I can not using alias in 11G
|
| |
hi all: I found some query will cause ORA-00918 error(column ambiguously defined) in 11G, but running well in 10G. I give an example: --------------------------- select supplier_code,dept_code,local_ name,english_name from supplier a inner join... more »
|
|
|
Physical Standby Database and v$Recover_file Query
|
| |
Hi I have created a traditional physical standby instance from a hot backup using a standby controlfile etc. from the primary db (10.2.0.4). Not using dataguard but there were no issues during creation. In standby mode if I querry v$recover file I receive the following. FILE# ONLINE ONLINE_STATUS ERROR CHANGE# TIME... more »
|
|
|
How to use REGEXP_SUBSTR to extract owner/obj/part from full obj name ?
|
| |
i got object or schema name in following format: owner[.object_name[.partition_ name]] This naming allows to define schemans, objects and partitions. I have a sp_crackname procedure to extract fields form this name but i think it is running slow when processign thousands of names. I need to use REGEXP_SUBSTR to extract indivvidual fields.... more »
|
|
|
|
