 | | | Oracle List | | Hmmm... Your description sounds like the classic story describing havoc
wreaked by bind-variable-peeking. The story goes like this
I have a database supporting my high-volume accounts receivablHi List
I am maintaining above mentioned database.
We will switch to automactic archive log transfer (
log_archive_dest_state_2 ENABLE ).
Until that happens archive logs are transferred using OS co
It isn 't the user doing the update who needs the privileges. It is the owner of the trigger. The trigger will run as the owner of the trigger. All of the objects referenced in the trigger must be Bill
I don 't understand the purpose of doing this. A trigger fires whenever
its triggering condition occurs. If a user has the privileges to cause
the triggering condition (e.g. insert update dToon
I 'm learning something here thanks for the response. If I understand
correctly if the trigger selects from a table then all I need to do is
grant select on that table to the user who will be uWhat PeopleSoft Product and what PeopleTools version?
Are you running Unicode?
regards
Bill
Triggers are not directly executed by users.
Triggers are indirectly executed when the user executes a DML-statement (an insert update or delete statement).
So there is no concept of 'grantiWhy would you need to grant execute or any other privilege on a trigger? It
is executed automatically when the corresponding dml is run on the table or
action is taken within the database. No privilGreetings
I have been playing around trying to grant execute on a trigger to a
particular user. After playing with this for a while and reading docs I
have come to the conclusion that execute on a t
ryan are you talking about in the raw trace or in the tkprof output?
If tkprog output was sys n specified on the tkprof run?
-- Mark D Powell --
-----Original Message-----
From oracle-l-bounce
There 's a bug in AWR - it seems to calculate
CPU time as
CPU used by this session +
recursive cpu usage
Worst case if all you ever do is call pl/sql to wrap
SQL is that the CPU time is dHi list just an update on this issue
After more research it seems that encountering this problem might not
be as likely as I 'd originally thought. Although table prefetching is
enabled by defaulThanks for your valuable and precise suggestion Tanel.
In a nutshell this is what AWR does
select 'CPU ' (e.value-b.value)/1000000 time
from dba_hist_sys_time_model b dba_hist_sys_time_Well you can trace the awrrpt run...
I suspect (but don 't know for sure) that AWR uses DBA_HIST_SYS_TIME_MODEL
for its CPU info... V$SYS_TIME_MODEL CPU values can differ from V$SYSSTAT
ones...
SQL > Hi
Is anyone out there using nCipher NetHSM with Oracle and using Oracle wallets?
Had any luck with configuring SSL using the above combo?
--
mohammed
I think the concern wasn 't that they hadn 't been backed up but that
they hadn 't been applied to the standby yet.
Thanks to everyone who replied. The version below from Finn (adding hash hint) ran in 16 minutes!
Finn Jorgensen <finn.oracledba@(protected) > wrote
The biggest problem for this query is that tDo you know if CPU Time calculation formula has changed from Statspack
to AWR and how it has changed? Or am I missing something?
I tried to get the formula from DBMS_WORKLOAD_REPOSITORY source but
gHello list.
At Statspack age 'CPU Time ' value in section 'Top 5 Timed Events ' was
calculated as the difference of 'CPU used by this session ' values
between two snapshots
seRyan
That sounds pretty weird. All the recursive SQL should be in the trace
file. Have you looked at the raw trace data to confirm that it 's not
there? Or are you by chance looking at your tkprof ouToo many unknowns. And hence too many suggestions can be made. It is hard to
estimate what 's the best path without looking at statistics i.e.
CARDINALITY figures. According to the plan shown the subWe recently had a locking/blocking problem on two different 10.2.0.3 RAC
systems. I ran a query similar to below to get more information
select sid serial# program module action username o
In what version of the database which level of 10046 and for which
command?
I get the following in 10G for a simple create table statement with
10046 level 12. It shows lots of recursive sqls.
OVI 'm not an RM expert but I did learn a lot from the live webcast session that the RAC SIG had last week titled "Using Resource Manager for Managing Mixed Workloads ". I 'm working on getting the recordIf I run a 10046 trace on a DDL statement I do not get the recursive SQL that oracle runs underneath the DDL. Is there another form of trace that will show me what oracle is doing?
--
http //www.freDo you have other tables assigned to KEEP buffer pool? Other tables might
overflow into KEEP buffer pool if you just configured it. Do you have
relevant AWR report to look at? I 'd compare AWR reports Shwe you are going to have more questions about where to look for basic
information about Oracle objects such as what columns are on a table
what indexes exist on a table what columns are in an indHi All
I 'm using OEM 10.2.0.2 and am having a problem with a couple of agents.
If on the Agent 's main page I click on "Alert History " I see the Metric "Count of targets not uploading data " I can
If you are worried about deleting unbacked up archive logs then just include the clause "BACKED UP 1 TIME "
Pat
Joe
First make a copy of the listener.ora file for safe keeping.
Then go ahead and edit the file and do a reload.
The listener is *only* used to establish new connections. The existing
connectio |
|
|
