|
 |
Op 17-1-2010 22:47, Hiscoming schreef:
> Preparing for my Oracle 11g OCA/OCP Exams.
> I welcome any suggestion and help from anyone please.
>
>
>
> --- news://freenews.netfront.net/ - complaints: news@netfront.net ---
Taking into account your earlier posts, I'd say: pray!
Hiscoming
|
|
4 |
1,700 |
|
|
|
joel garry wrote,on my timestamp of 19/01/2010 5:03 AM:
> Are you spelling _his_ name correctly? :-)
Dunno, jgarr. Did I get yours?
Lost track somewhere between the last beer
and the first scotch...
<g,d&r>
(
1
2
)
Jeremy
|
15th December 2010 16:03
by Noons 
|
31 |
496 |
|
|
|
Hi!
Mark D Powell wrote:
> Sessions can also be terminated via the user profile which has an idle
> time setting and also through the use of the database resource manager
> so if you do not find any sqlnet settings that seem to apply check
> these.
You will be able to identify such a...
Troels Arvin
|
|
9 |
258 |
|
|
|
On Mon, 18 Jan 2010 21:17:10 +0100, bob123 wrote:
> but it doesn't free space allocated for the LOBSEGMENT's how can I get
> the released space ?
TRUNCATE TABLE DROP STORAGE;
--
bob123
|
|
2 |
292 |
|
|
|
"Malcolm Dew-Jones" <yf110@vtn1.victoria.tc.ca> wrote in message
news:4b50d4ca$1@news.victoria.tc.ca...
> Terry Dykstra (tddykstra@forestoil.ca) wrote:
> : "Malcolm Dew-Jones" <yf110@vtn1.victoria.tc.ca> wrote in message
> : news:4b50aff2$1@news.victoria.tc.ca...
> : > joel garry...
Terry Dykstra
|
|
11 |
248 |
|
|
|
On Jan 18, 3:06 am, Lucyna Witkowska <ypwit...@nospamcyf-kr.edu.pl>
wrote:
> joel garry <joel-ga...@home.com> napisa³:
>
> > I was going to joke around about Mladen and Frank's responses, but the
> > Windows mind-set of over-estimating how plugable software parts are is
> > reasonable to...
Lucyna Witkowska
|
|
10 |
244 |
|
|
|
1. Deleting data: I guess if you want to avoid outage then the only
way is to run DELETE statement.
2. Re-organizing the table: it depends on what you are trying to
achieve. You mention improving performance,
do you have queries that select columns other than VALUE (LOB column)?
Or all queries...
UXDBA
|
|
5 |
251 |
|
|
|
On Jan 13, 7:49 pm, "The Boss" <use...@No.Spam.Please.invalid> wrote:
> zigzagdna wrote:
> > On Jan 13, 5:22 pm, Sybrand Bakker <sybra...@hccnet.nl> wrote:
> >> On Wed, 13 Jan 2010 13:37:35 -0800 (PST), zigzagdna
>
> >> <zigzag...@yahoo.com> wrote:
> >>> I am Oracle 11g 11.1 on HP UNIX 11i. I...
zigzagdna
|
|
4 |
253 |
|
|
|
On 13 Jan, 09:28, Frank van Bortel <frank.van.bor...@gmail.com> wrote:
> Ralph.in...@googlemail.com wrote:
> > Hi,
>
> > I am involved in designing the architecture for a green field web
> > application. Oracle 11g on the back end, tomcat at the front. No fully
> > fledged apps server in the...
Ralph.in.NZ@googlemail.com
|
|
4 |
237 |
|
|
|
On Jan 12, 1:51 pm, Mladen Gogala <n...@email.here.invalid> wrote:
> On Tue, 12 Jan 2010 12:35:52 -0800, The Magnet wrote:
> > Yes, I know what the error is. But what conditions? How simple can it
> > get? A select statement with no joins, no referential constraints, a
> > primary key, no...
The Magnet
|
|
6 |
257 |
|
|
|
joel garry wrote:
> On Jan 6, 3:07 am, Frank van Bortel <frank.van.bor...@gmail.com>
> wrote:
>> joel garry wrote:
>>> On Dec 23, 4:35 am, Daneel Yaitskov <rtfm.rtfm.r...@gmail.com> wrote:
>> <snip>
>>>> You must admit that such behavior strong differentiate from others
>>>> languages for...
Daneel Yaitskov
|
|
12 |
247 |
|
|
|
"vsevolod afanassiev" <vsevolod.afanassiev@gmail.com> wrote in message
news:6b53357e-dde5-42ad-91e7-e9bfc850d423@a32g2000yqm.googlegroups.com...
> Hi,
>
> Since we started running Statspack at level 7 I noticed that often
> "Top 5 Wait Events" section does not match object statistics section....
vsevolod afanassiev
|
|
1 |
264 |
|
|
|
On Mon, 11 Jan 2010 18:54:08 -0800, Hemant K Chitale wrote:
> stating that read only
> tablespaces are very useful in RAC becaue GC_% waits 'vanish' may well
> be misunderstood.
Actually, that was not a joke. Making tablespaces read only is rather
obscure but efficient technique to...
Cliff
|
|
15 |
237 |
|
|
|
In article <925740be-b4ed-45b7-b6ea-
fabc72a5f5dd@c34g2000yqn.googlegroups.com>, Mark.Powell2@hp.com says...>
I will gather that you have so all I can suggest is adding the CLOB
> column then performing an update process to populate the CLOBs. Once
> populated you could remove the long column...
Jeremy
|
15th December 2010 16:03
by Jeremy
|
4 |
234 |
|
|
|
I'd also like to throw the consideration into the discussion that
shrinking a tablespace is only a reasonable thing to do if the TS stays
smaller permanently. If you are going to need the space again later you
should at least consider whether the exercise is worthwhile.
Kind regards
...
dba cjb
|
|
4 |
257 |
|
|
|
On solution is :
select a1.person_id,a1.creation_date
from tbl_A a1
where a1.person_id in (
select a.person_id
from tbl_A a
minus
select b.person_id
from tbl_B b
jimmyb
|
|
4 |
254 |
|
|
|
I believe the value you are looking for is:
x:=ADD_MONTHS(v_date,3)-v_date
When oracle subtracts dates you get the number in days.
Thanks,
"The Magnet" <art@unsu.com> wrote in message
news:0e6387e0-d57d-4cf1-b51f-dd391c582f52@f5g2000yqh.googlegroups.com...
The Magnet
|
|
10 |
322 |
|
|
|
> That simple answer is:
>
> 1) Copy or rename the datafile at the O/S level BEFORE attempting to
> rename it in the database. Take the tablespace offline, copy the
> datafile to the proper name, rename the datafile in the database,
> recover the tablespace and then bring the tablespace...
Johne_uk
|
|
2 |
248 |
|
|
|
On Jan 8, 7:26 pm, vsevolod afanassiev <vsevolod.afanass...@gmail.com>
wrote:
> >> there
> >> are still transactions in the online redo log when the copied file is
> >> bought online,
>
> Yes, and these online redo log files belong to the same database so
> they will be used during recovery....
bob123
|
|
10 |
247 |
|
|
|
On Jan 6, 2:22 pm, Maxim Demenko <mdeme...@gmail.com> wrote:
> On 06.01.2010 22:48, Mladen Gogala wrote:
>
>
>
> > On Wed, 06 Jan 2010 21:10:56 +0100, Maxim Demenko wrote:
>
> >> Sorry, of course, i am interpreting your words like it better suit my
> >> needs ;-)
> >> But either your meant...
Mladen Gogala
|
|
14 |
236 |
|
|
|
Mladen Gogala wrote:
> On Wed, 30 Dec 2009 07:46:30 -0800, Mark D Powell wrote:
>
>
>> which in turn lead me to a page with the 11g OCP test requirements for
>> database associate, professional, and master listed at
>
> How can I become a DBA 2.0? I am an old hack, very well versed in log
>...
happy
|
|
5 |
245 |
|
|
|
bob123 wrote:
> OK thanks all ...
> The problem is that i can't rewrite the code
> it's a third party software ...
> any clue ?
>
>
written in a far and distant country, where the programmers had
no clue about the data model.
bob123
|
|
18 |
256 |
|
|
|
On 05/01/2010 11.27, Gerard H. Pille wrote:
> Hallo en een gelukkig nieuwjaar / happy new year!
>
> Our Oracle instances on AIX use DS6800 for storage, but the DS6800
> will have to be replaced.
>
> One of the candidates is NetApp. My colleague, who is responsible for
> keeping these...
Gerard H. Pille
|
15th December 2010 16:02
by skyste-
|
3 |
231 |
|
|
|
Hello,
today an old oracle rac 9.2 database crashed to due power problem. Both
nodes were restarted.
Manually I've restard oracm as root and the gsdctl as oracle user.
Now running
srvctl start instance -i INST1 -d INST
skyste-
|
15th December 2010 16:02
by skyste-
|
0 |
236 |
|
|
|
On Jan 5, 12:25 pm, joel garry <joel-ga...@home.com> wrote:
snip
> > Sure you need a support contract to get patches etc. Does that mean
> > that you need a certified config? Probably not.
>
> In the past I've taken the position this is like saying you probably
> don't need insurance on...
Bruce
|
15th December 2010 16:02
by hpuxrac
|
6 |
295 |
|
|
|
On Jan 6, 8:37 am, nanto <anant.na...@gmail.com> wrote:
> PLEASE SEND YOUR RESUME AT anant.me...@ustechsolutionsinc.com or you
Idiot! This is a worldwide technical newsgroup. Job postings are not
allowed here. Please delete your post and apologize. There are
plenty of other places where...
nanto
|
|
1 |
245 |
|
|
|
On Jan 1, 11:03 am, zigzagdna <zigzag...@yahoo.com> wrote:
> On Jan 1, 10:20 am, ddf <orat...@msn.com> wrote:
>
>
>
>
>
> > On Dec 31 2009, 2:41 pm, zigzagdna <zigzag...@yahoo.com> wrote:
>
> > > I am on Oracle 11g Release 1 (11.1.0.7.1). Oracle 11g provides
zigzagdna
|
15th December 2010 16:02
by ddf
|
3 |
234 |
|
|
|
Mladen Gogala wrote,on my timestamp of 2/01/2010 12:42 AM:
> Ah, saint John on yet another mission to preserve civility on this group.
> Nuno, you shall wash your hands before lunch and eat your spinach! While
> at that, have a happy New Year, both of you.
Spinach? Now you just gave me an...
zigzagdna
|
15th December 2010 16:02
by Noons
|
26 |
331 |
|
|
|
On Dec 28, 6:54 pm, z1hou1 <z1h...@gmail.com> wrote:
> Hi,
> I have a situation where I have a materialized view/log to refresh on
> commit on a fact table that is subject to archive considerations. The
> fact table is partitioned by date range.
>
> Now, the materialized view has very few...
z1hou1
|
|
2 |
240 |
|
|
|
On Sat, 26 Dec 2009 17:02:03 -0800, hpuxrac wrote:
> On Dec 26, 7:21*pm, vsevolod afanassiev <vsevolod.afanass...@gmail.com>
> wrote:
>
> snip
>
>> Hi All,
>>
>> In 10g Oracle introduced view DBA_TAB_STATISTICS. Many columns are
vsevolod afanassiev
|
|
4 |
236 |
|
|
|
A new entry:
http://multi-platformdba.blogspot.com/2009/12/database-parameters-changes-and-logging.html
JAW
|
15th December 2010 16:02
by JAW
|
0 |
241 |
|
|
|
On Dec 28, 3:44 am, eh <timo.talja.em...@gmail.com> wrote:
> Hi,
> There are two identical oracle 9.2 db's running identical software and
> basically amount of transactions is same - still there's a huge
> difference between archive log amount generated in these db's.
> Logs generated from...
eh
|
15th December 2010 16:02
by JAW
|
4 |
241 |
|
|
|
Mark D Powell (Mark.Powell2@hp.com) wrote:
: On Dec 23, 10:10=A0am, Jeremy <jeremy0...@gmail.com> wrote:
: > In article <79bb2ee5-f28a-43b9-af1e-4597012495f0
: > @a32g2000yqm.googlegroups.com>, Mark.Powe...@hp.com says...
: >
: >
: >
: > > Cate, why not test for a NULL value being returned...
cate
|
|
9 |
219 |
|
|
|
On Dec 25, 4:57 am, "Jonathan Lewis" <jonat...@jlcomp.demon.co.uk>
wrote:
> "Ind-dba" <oraclear...@googlemail.com> wrote in message
>
> news:c18c2018-d228-40f4-a7ba-9e332387f390@15g2000prz.googlegroups.com...>Hi Jonathan,
>
> .> I just read your article on Transitive closure - so no need to...
Ind-dba
|
15th December 2010 16:02
by Ind-dba
|
12 |
236 |
|
|
|
On Dec 24, 9:19 am, GaryA <garyi...@yahoo.com> wrote:
> On Dec 23, 3:49 pm, Mark D Powell <Mark.Powe...@hp.com> wrote:
>
>
>
>
>
> > On Dec 23, 11:13 am, GaryA <garyi...@yahoo.com> wrote:
>
> > > Hoping someone can explain why I am running into the issue seen
GaryA
|
|
8 |
222 |
|
|
|
On Dec 23, 11:32 am, songyu <songy...@gmail.com> wrote:
snip
> Hi,
> I am currently auditing "GRANT ANY OBJECT PRIVILEGE" and "GRANT ANY
> PRIVILEGE". That works well if I grant privileges of other schema
> objects to others.
>
> I would also like to audit in cases where a schema grants...
songyu
|
15th December 2010 16:02
by hpuxrac
|
1 |
215 |
|
|
|
Windows release still dragging behind ... that is a change in behavior
from last couple of releases. ( Not that we run any oracle databases
on windows where I play ).
HPUX is Itanium only apparently so far.
hpuxrac
|
15th December 2010 16:02
by hpuxrac
|
0 |
213 |
|
|
|
Hi,
Thanks for all ur responses.
Sorry, but I think, still i am not convinced with the answers.
The question that i asked is related to PERFORMANCE impact.
Will there be an impact in performance ( either increase or decrease )
when we create a MV with ROWNUM as one of the columns :
1)...
raja
|
15th December 2010 16:02
by raja
|
5 |
229 |
|
|
|
On Dec 21, 2:34 pm, zigzagdna <zigzag...@yahoo.com> wrote:
> On Dec 20, 6:24 pm, zigzagdna <zigzag...@yahoo.com> wrote:
>
>
>
>
>
> > On Dec 20, 10:31 am, bdbafh <bdb...@gmail.com> wrote:
>
> > > On Dec 20, 12:39 am, zigzagdna <zigzag...@yahoo.com> wrote:
zigzagdna
|
15th December 2010 16:02
by ddf
|
9 |
219 |
|
|
|
On Dec 20, 7:04 pm, Mark D Powell <Mark.Powe...@hp.com> wrote:
> On Dec 20, 10:40 am, "Michel Cadot" <micadot{at}altern{dot}org> wrote:
>
> > "pradeep" <pkna...@gmail.com> a écrit dans le message de news: 037a2e01-8dd0-410b-b8f8-5fde26701...@b2g2000yqi.googlegroups.com...
> > | Hi,
> > | We need...
pradeep
|
15th December 2010 16:02
by pradeep
|
5 |
218 |
|
|
|
On Nov 23, 1:11*pm, lsllcm <lsl...@gmail.com> wrote:
> On 11月23æ—¥, 上åˆ12時22分, Charles Hooper <hooperc2...@yahoo.com> wrote:
>
>
>
> > On Nov 22, 7:46 am, lsllcm <lsl...@gmail.com> wrote:
>
> > > Hi All,
>
> > > I have put both 10053 trace for both execution plan as below url,
lsllcm
|
|
13 |
357 |
|
|
|
On Dec 21, 9:37 am, Uzoma <whatifyouwer...@gmail.com> wrote:
> I've been trying to install Oracle on Solaris 10 (sparc) for the past
> week without progress. Below is what I get. What baffles me is that, I
> did not choose to install the oracle companion cd. I just want to
> install the...
Uzoma
|
|
1 |
260 |
|
|
|
In article <43a46a19-1e49-4085-becb-edd52ccaed95@21g2000yqj.googlegroups.com>,
hpuxrac <johnbhurley@sbcglobal.net> wrote:
>Linux 32 bit and 64 bit ... solaris 64 bit both sparc and x86-64 ...
Thanks for the heads up. 11gR2 for Solaris x64 been on OTN for about
a month, but I just noticed...
hpuxrac
|
|
3 |
209 |
|
|
|
On Sat, 19 Dec 2009 21:33:39 -0800, zigzagdna wrote:
> I want to monitor if system accounts such as system, sys or other DBA
> accounts
> did any DML in my application schema. What are the minimal audit
> statements
> needed to accomplish this. I did read Oracle's documentation on AUDIT
>...
zigzagdna
|
|
1 |
201 |
|
|
|
On Sat, 19 Dec 2009 06:42:49 -0800, Steve Howard wrote:
> Both. The single platform DBA is dead.
Undead would better describe the situation. Before the night is through,
I want to do bad things....
Rohit
|
|
16 |
229 |
|
|
|
On Dec 18, 5:51 pm, Mladen Gogala <n...@email.here.invalid> wrote:
snip
> On Fri, 18 Dec 2009 13:23:16 -0800, bdbafh wrote:
> > OS word size?
> > Database release and word size?
>
> In the beginning was the Word, but nobody really knew the word size in
> bits.
keekee
|
15th December 2010 16:02
by hpuxrac
|
4 |
286 |
|
|
|
On Dec 17, 10:12 pm, joel garry <joel-ga...@home.com> wrote:
> On Dec 17, 7:50 am, Vijay Soni <vijay.k.s...@gmail.com> wrote:
>
> > Hi,
> > I have a query about the parameter ADMIN_RESTRICTIONS, what is the
> > value of the parameter if not set explicitly.
> > And apart from listener.ora...
Vijay Soni
|
|
3 |
228 |
|
|
|
On Dec 16, 2:44 am, Hary <harendrakishore...@gmail.com> wrote:
> Hello ,
>
> I am looking out for some one with Valid UK Visa and exp. with RBAC
> with Financial skills set.
>
> Interested , Pl. do send your resume ASAP.
Hello
Hary
|
|
1 |
207 |
|
|
|
On Dec 17, 4:19 am, jimmyb <jimmybr...@gmail.com> wrote:
>
> > At least the communication is improving...
>
> > Saturday I received 6 closure emails for the same SR almost 1 an hour
> > for 6 hours.
>
> LOL, I also got several emails closing out my SR as well last weekend.
> Go figure.
Mladen Gogala
|
15th December 2010 16:02
by Noons
|
10 |
202 |
|
|
|
On Dec 16, 4:49 am, jan <janmben...@googlemail.com> wrote:
> Hi,
> i installed a oracle database 10 instance with scrips
>
> CreateDB.sql
> CreateDBFiles.sql
> xdb_protocol.sql
> labelSecurity.sql
> spatial.sql
> context.sql
jan
|
|
1 |
225 |
|
|
|
On Dec 15, 11:43 pm, jan <janmben...@googlemail.com> wrote:
> Hi all,
>
> i have a database with many users like 4_0, 4_1, 4_2, 4_21, 4_22
> and so on.
> I think - if you update the Front-End software from version 4.1 to
> 4.2 the software create a new User 4_2 and will
> now work with...
jan
|
|
3 |
228 |
|
|
|
On Tue, 15 Dec 2009 09:47:39 -0800, Mark D Powell wrote:
> On Dec 14, 5:20*pm, joel garry <joel-ga...@home.com> wrote:
>> http://www.marketwire.com/press-release/Oracle-Corporation-NASDAQ-
ORC...
>>
>> Already made it to slashdot, too.
>>
>> jg
>> --
joel garry
|
|
2 |
242 |
|
|
|
On Dec 14, 3:40 pm, lora <anjela_...@yahoo.com> wrote:
> So, I'm trying to replace all rows that have $myString with myString
> and this particular field is already a primary key field. The primary
> key is already defined for this table so performing the update gives
> me a constraint...
lora
|
|
4 |
227 |
|
|
|
On Dec 15, 2:13 am, gazzag <gar...@jamms.org> wrote:
> On 14 Dec, 19:41, Mladen Gogala <n...@email.here.invalid> wrote:
>
>
>
> > The word "compression" is very fashionable these days. I find that
> > strange because everybody keeps telling me how cheap disks are these days
> > and yet,...
Mladen Gogala
|
|
5 |
227 |
|
|
|
On 15 Dec, 15:25, Mladen Gogala <n...@email.here.invalid> wrote:
<snip>
> Is Al Qaeda now using spam to finance itself?
That and helping to prop up the capitalist system, it would appear:
http://www.guardian.co.uk/global/2009/dec/13/drug-money-banks-saved-un-cfief-claims
aghla brahim
|
15th December 2010 16:02
by gazzag
|
4 |
224 |
|
|
|
On Tue, 15 Dec 2009 23:20:07 +1100, Noons wrote:
> I'd settle for 10g compressing partitioned tables. Unfortunately, it
> doesn't.
> Or at least: it didn't the ones I threw at it. Which BTW compressed fine
> while not partitioned...
>
> Ah well: I'm sure 11gRsomething-or-other solves all...
Pat
|
|
22 |
224 |
|
|
|
Hi,
I have a useful pl/sql script that facilitated the tracing of other
users sessions. Bascially it checked the session was connected, asked
what type of trace was required, set the max dumpfile size and started
the trace. Since upgrading to 11g this is no longer such a useful
script as the...
Ralph.in.NZ@googlemail.com
|
|
0 |
265 |
|
|
|
Shakespeare wrote:
>>> This is a regular event in our shop. Our developers used to try to
>>> insert, and then handle the exception if it existed and update it. We
>>> cut our redo by a large factor when we asked them to switch to MERGE.
>>
>> They used to do an UPDATE when an exception...
lora
|
|
15 |
240 |
|
|
|
On Sun, 13 Dec 2009 15:39:46 +0100, Robert Klemme
<shortcutter@googlemail.com> wrote:
>On 13.12.2009 14:21, Gerard H. Pille wrote:
>> Robert Klemme wrote:
>>> On 11.12.2009 11:01, Jaap W. van Dijk wrote:
>>>> I'm loading millions of records in a transformation step in a
>>>> datawarehouse...
Jaap W. van Dijk
|
|
16 |
220 |
|
|
|
On Dec 14, 7:50 am, Gary <gjwater...@gmail.com> wrote:
>
> This section comes last in the backup script, just before the the
> logfile is switched. I'm not sure what is meant by "keeptime is longer
> than the age of the oldest archivelog"; does this mean the controlfile
> should be backed up...
Gary
|
|
6 |
215 |
