 | | | Oracle List | |
Christian has given you the answer you need.
Personally I find it irritating that dbms_xplan fails to
show the partition_id column from the plan_table.
If it did it would be obvious when you had a
Considering only the optimizer the most likely problems
on a migration from 8i to 10g come from
Subquery unnesting - use /*+ no_unnest */ hint in the
subquery for special cases _unnest_subque
**************** CAUTION - Disclaimer *****************
This e-mail contains PRIVILEGED AND CONFIDENTIAL INFORMATION intended solely for the use of the addressee(s). If you are not the intended Have u checked DBA_POLICIES?
Regards
-Fairlie
xiaoyan <xiaoyezi.xyz@(protected) > wrote
Hi all
Is there any view I can get information about FGAC policies on tables?such whetNot sure what happened here but getting message below every minute.
-rw-r-----1 oracle dba 10486784 Jun 30 09 45
/u02/oradata/MTCP/redo01a.log
-rw-r-----1 oracle dba 10486784 Jul 19 18 40
/u02/oradatHi
We are in need to buy or find scripts which compares multiple schemas in depth.
I am pretty sure it is already out there.
I would prefer scripts so that it can be automated.
Please do suggest somMadhu V wrote
> Hello All
>
> AIX 5.3 (ML4) Oracle 10.2.0.1.
>
> After Installing the Oracle Clusterware w/o any issues i tried to
> install the database software. But I am getting the error atRyan
>My expectation before running this query was
>1. Each slave will scan a partition
>2. Then eight slaves will each do a partition wise hash join.
>3. The results will queued. The query coordinaHi
Last few days I was dialing with task of restoring and recovering database into
test environment. Database size ~1TB. Production backups are kept on TSM server
and we are using RMAN. Oracle 9.2.0Hello All
AIX 5.3 (ML4) Oracle 10.2.0.1.
After Installing the Oracle Clusterware w/o any issues i tried to
install the database software. But I am getting the error at linking
phase. below isHad to resend...hope it formats OK. I can send the script to anyone offline just email me...after next Tuesday...off to Alaska for a few days.
-joe
http //www.peaceaday.com
-----Original Message-are you connecting as "/ as sysdba " or using a service name? Is the
application on the same server or different server?
if different server can you use tcpdump to get any information or
strace?
ARaj
Can you show us your sql statement? Also why not use a column alias in
your select and use that column alias in your format statement?
column patient_name format a37 heading 'Patient_NameOn 7/19/06 eagle fan <eagle.f@(protected) > wrote
>
> hi
>
> My oracle version is 9205 and optimizer_features_enable is set to 9.2.0.
>
> We have a query choose a bad plan.
>
> ...
> What do you think
Hi
We use Materialized Views to implement replication. A is the center RAC database several B are A 's read-only Materialized Views sites. Some Materialized Views are very big so we need use OfflHi
Your command will modify the password file on the node on which you run the command.
You either have to copy the file manually to the other nodes or run the same command on all nodes of thJust a bit sideways from the Q
I would seriously question that approach and rather propose to follow
more minimalistic approach giving only grants that are needed.
In addition there is no way to graHm... I thought it 's more like that people recommend to include
references to nice entries from their friends collegues and just
blogs we read and not your own masterpiece... Otherwise it 's like
bec
On 07/18/2006 06 48 37 PM Jared Still wrote
> I was just able to download that patch so I wonder what they mean by that?
You have to open a TAR to find out what do they mean. It 's classified on > > >
> > >
> > >NUMA as in Sequent NUMA (non-uniform memory architecture or
> > >maybe it is access). There is more to server performance
> > >that just the CPU speed.
I don 't mean to pick apart your emaHi All
My database is configured to use approx. 4Gb of
memory
Connected to
Oracle9i Release 9.2.0.6.0 - 64bit Production
JServer Release 9.2.0.6.0 - Production
SQL > select *
2 from v$sga
3 Hi!
The upgrade-manual but I think you have looked at that.
Expect problems with dangling synonyms and
differences with parameter-types between spec and body in packages
for example leaving default-Hello List
Our RMAN backup failed early this morning with the message "RMAN-04004
error from recovery catalog database ORA-12541 TNS no listener ". I
checked the listener log files and obser
On 07/17/2006 11 58 25 AM gparc@(protected) wrote
>
> Hi listers
>
> FYI skip_unusable_indexes is now a pfile/spfile parameter in 10g
> (not only alter session based as in 8i/9i) and defaults to ..You have to read Note 212809.1 Limitations of the Oracle Cost Based Optimizer and notes on bind variable peeking and notes on histograms. Apart of bugs there are some fundamental problems in optimizatHello!
I hope this "all-knowing "-group can help (-
I want to spend some time about one of my favourite interests astronomi
and use my knowledge about Oracle.
Do any of you know some projects where First in oracle "writes " do not block "reads ".
Second start reading oracle docs in general and regarding origins of
deadlocks specifically.
Igor
I would think that the controlfile that the STARTUP MOUNT and RECOVER
commands are reading is _*not*_ the "current " (ie this now point-in-time)
file.
eg when you said you restored the control > Not yet. The 1.5 is still larger than what the error is complaining
> about and it is on the target not the catalog and the errors says it 's
> a RPC error which makes it look like the catalog is
On 07/17/2006 07 57 20 AM rjamya wrote
> For a new application (dot.net) connecting to Oracle (10gr2) RAC DB
> what options are available for connection pooling? developers want to
> write their o |
|
|
