 | | | Oracle List | | Srini
We 've been using it in production on 9.2.0.6 since the middle of last
year with very few problems. Its a bit limited but it works. Its
only a log table and an internal DML trigger in the enSrini
I have and I sincerely doubt that you 'll have any fun with it below
v10.2. But you can certainly have fun trying... -)
Tim Gorman
consultant - Evergreen Database Technologies Inc.
4651 HLarry
Did you try the ORA-7445 and/or stack trace lookup tool? (See ML doc id
153788.1.)
-Mark
--
Mark J. Bobak
Senior Oracle Architect
ProQuest/CSA
"There are 10 types of people in the Is your LD_LIBRARY_PATH set correctly ?
Stefan
On 4/28/07 John Darrah <darrah.john@(protected) > wrote
>
> Its a permissions thing Oracle changed the permissions in 10g for some
> reason. There is Hi Cosmin
You can use dbms_pipe to communicate and dbms_lock to synchronize.
I used them to create a parallel stats gathering package for standard
edition Oracle. There would be a master process thhttp //www.symantec.com/enterprise/support/index.jsp
Hi
I am having 10g RAC with service name ldptsrv created and here is the status of service on one of the Oracle RAC node
"/export/home/oracle " > srvctl status service -d LDPDB
Service ldptsOn 5/2/07 Neil Overend <neiloverend@(protected) > wrote
>
>
> Our current production server (that I inherited) has a complex
> arrangement of disks with oracle files separated out to different disk
> aIf I want to find a server patch I just enter "RDBMS Server " select the OS
and patch level and hit search. Makes perfect sense. However I am trying
to see if any of the client components have been pJordan
Hopefully you 'll get some expert replies. In the meantime I have a simple
suggestion.
Have one username for your schema owner. This schema owns all the
application 's objects.
Use other usernhi all
what 's the best & most robust package these days whether Oracle supplied (DBMS_AQ?) or third party to do asynchronous PL/SQL development (9i or 10g). I have various scenarios multiple pryou are going to have fun! In an ideal world I 'd be looking at defined
transactions and setting targets for elapsed time EM can measure this.
On the other hand what they 've given you are technical effHello.
I am on RedHat Linux DB 10.2.0.2. I was playing with TAF.
I have a session with FAILOVER_TYPE SESSION and FAILOVER_METHOD BASIC. This
session is inactive. I kill it with 'alter system kill shi
is there any way (other than taking a system state dump/hang analyze) to figure out which are the SESSIONs HOLDING A LIBRARY CACHE LOCK in rac. i am working on a 10.2.0.2 10 node rac system.
Hi
If anyone out there is on a 10.2.0.3 RAC Cluster on Sparc Solaris 64 bit can you let me know if you have applied any one off "must apply " patches either to the CRS HOME or the ORACLE_HOME
Anyone has information about Active Session History views (both V$ and
DBA)
So far I have more questions than answers how those views can be used...
I am especially interested in the wait events colCharlotte
Didn 't see/save your first email but thought I 'd point out that using
Application Context features in conjunction with views is quite powerful
and to my knowledge is available in StanGreetings
This is dropping a Big Table around 150 GB in different Oracle Versions
(8i 9i 10g) with LMTS and Dictionary TBS
Can a TRUNCATE Table Before drop help in system resources and drop time?
> > We have TOAD 9.0 version. Can anyone tell me how to
> > use TOAD to export table and save as format which
> > EXCEL can accept (possible csv)?
When you have run the query click the icon in the tI have an issue where i am unable to stop dbas updating/deleting information
from sys.aud$ table has anybody got any ideas/methods of protecting the
audit trial as sending the information to a log --but if size to flush > os max single write size
lgwr will flush at following conditions.
1) log buffer is 1/3 full of log_buffer
2) log buffer is has 1mB redo
3) issue a commit
As I know Max sing
I don 't really have too much trouble with that snippet to be honest.
Especially given the context that it is in the quote below being the
immediately preceding text
I agree with Niall and MWe have found that in a cluster environment that you will be able to
more easily do updates if you use multiple homes.
We create homes and apply the patch to the new home and then migrate the
databaseIs there a way to capture all the SQL_IDs that a session generated - historically?
I have tried a couple of options like v$open_cursor (it 's volatile in the sense that entries exist as long as the se <EDUCATED GUESS >
It is likely that under 10g flushes at 1/3rd full and 1MB redo may now be out of date in detail if not in spirit. Log buffers of 14M+ are now commonplace and automatically managed ifDo you see any reason? I think the recovery could fail only if there is
a difference in the format of archivelogs generated from 9.2.0.4 32- bit
and 9.2.0.4 64-bit or there is a difference between recYeah the 301 and 302 datafile ids means that you have db_files set to
300. Tempfiles start numbering w/ db_files+1.
As to the sort analysis what do you get if you do
select vsn.name vss.value
On 4/25/07 Kerber Andrew W. <Andrew.Kerber@(protected) > wrote
>
> Perhaps he could resolve the problem by creating a standard view of the
> materialized view?
>
My thoughts exactly! ) I told him thaWould I be correct in saying that if you have data that is or could be
foreign keyed you should not generate histograms since the CBO default will
produce a better map than the formula?
EspeciallyOnly if your application maintains it as columns in the tables. Most ERP
tables work this way. You can also audit these actions on tables that you
are interested and see all the times there was inse |
|
|
