 | | | Oracle List | | Great Company in North Dakota (city of 150 000) has an opening for an
Oracle DBA / Data Warehousing to join their IT team.
*Description
Well-known company is looking to add an experienced Oracle DBAWhy do you think your temporary table went to disk?
Where you think data in a temporary table physically located?
I 'm not sure on that but I would guess that GTT data stored in sessions PGA.
If it tNo problem here.....
--
Mark J. Bobak
Senior Oracle Architect
ProQuest Information & Learning
"There are 10 types of people in the world Those who understand
binary and those who don 't. "
-----Hello everyone
I have openings for both a senior DBA here in Ottawa Ontario Canada. I
measure senior not by years of experience but rather by overall abilities
so please feel free to apply even i <html > <div style 'background-color ' > <DIV class RTE >
<P > <BR >I am not able to do select from dba_waiters and dba_blockers views. It says table or view does not exist. Do I have to run some script to maHi
check your tnsnames.ora on the client pc as well as the server side for both
instances.
have you defined service_names in spfile or init.ora? this value should
exactly match service_name in tnsnThis may sounds really bizarre but I don 't think OCFS2 is
certified with 10gR2 yet...believe it or not.
Likely not your problem though.
Did you pre-size the cor and css files to ~200MB and 20MB
wHi Amir
Inline with Jonathan reply As per my understnading Oracle uses Lampport
scheme for SCN implimentation which has some limitations also. Like if you
have two instance rac1 and rac2 and botIt will go to the redo log holding the oldest first_change#
Joseph Amalraj
oracle-l-bounce@(protected) wrote
Hi List
Why after Group 8 it goes to Group 2? I always thought it went to GrSetting the BLKSIZE does help I have set it upto 512K
also SIZE_DATA_BUFFERS and
NUMBER_DATA_BUFFERS on the netbackup size also needs to be adjusted.
Increasing the number of channels h... if the sql comes from a stored code. v$sql
parsing_user_id and parsing_schema_id show the owner
of the stored code (at least for code running with
definer-rights scope) not the actual user.
TheHi All
We have two oracle instances on two different Unix boxes (but same OS platform) both running Oracle 9206.
The 1st instance is called "staging " with OS and Oracle Info below
SunOS phwebsOn 12/01/06 Bobak Mark <Mark.Bobak@(protected) > wrote
>
> Please say some prayers to the Gods of Oracle..... -)
>
> -Mark
>
IRRC that woud be Apollo the sun god.
Coincidence? http //www.theDeepak
Is it a RAC database ? Is it possible for you to run awr report for the
time of the load. Curious to see the top 5 events portion.
-----Original Message-----
From oracle-l-bounce@(protected)I just got an e-mail message stating that posting to the lazy-dba list is
now going to cost $112.75 per year.
I thought that was interesting . . .
I just got an e-mail message stating that posting toPlease advise me if any one implemented ASM in server HA environments
with VCS HP Service guard or suncluster w/o RACE.
...as a former Engineer in the Veritas Database Editions Group I think
the b
Morning Niall
Norman Dunbar.
Contract Oracle DBA.
Rivers House Leeds.
Internal 7 28 2051
External 0113 231 2051
> > > Niall Litchfield <niall.litchfield@(protected) > 01/13/06 06 14am > > >
> > It A programmer here asked me whether there was a way for him inside a
function to obtain the SQL used to call the function. He 's tried
identifying the calling session and then looking into v$sqlarea We are currently in the process of migrating to RAC. I 've been going through
otn docs white papers and discussions on 10.2 TAF Load Balancing and the
use of Services however I think I am a liitle c
In 10.2 there is an undocumented hint (one of dozens)
opt_param(parameter_name value)
that could be used to set the _optim_peek_user_binds
parameter to false - but that probably isn 't somethingHi
Oracle v9.2 on sun
Any experience with silent install batch usage of oui ? best documents ?
I found metalink note?122386.1 but Im uncertain where to find the right TOPLEVEL_COMPONENT in 9.Hi
When the job is run by Netbackup do you have a script that does an "su - oracle -c... " type command? If so do you export the NLS_DAE_FORMAT inside of the "su " bit if you don 't it will not apply.Hi folks
AND_EQUAL hint is deprecated in Oracle 10g.
does anyone know if there is another suitable replacement for it?
or
should i replace it with INDEX_JOIN or INDEX_COMBINE hints?
sure will te
I don 't have current code but had access to it for 12 years
ending at 9i so I 'll pitch in...
> > >1) Oracle calculates the hash value of the block and
> > >searches the SGA hash
> > > table for the plaHi
I am trying to configure Oracle ASMlib on RHEL AS but getting some strange error. Here is more detailed information of the environment
# ls -ltr oracleasm*.rpm
oracleasm-support-2.0.Bryan
Does your OCR still have the ASM info. crs_stat output (better yet
ocrdump output) should reveal it.
Thanks
Ravi
Not (absolutely) certain but you should be able to get around this by
setting (and exporting) the TZ variable in your
environment before starting the instance that runs in GMT.
For example
------
2. Has anyone used such a scenario where the storage
(forgive me if I offend some vendors out there) does not support a
SCSI-3 Persistence Reservation requirement? (SCSI-3 PR is a requirement
for I came across the message at
http //www.freelists.org/archives/oracle-l/10-2004/msg00462.html
which contains a link to
http //www.cybcon.com/~jkstill/util/util_master.html
but all I get is "Pa
When the query was taking 10 minutes to parse
did anyone check to find out how many join
orders were examined in each query block ?
I 'd be interested to find out whether it was the
number of join o |
|
|
