11.0 oracle 8.1.7.4 .
Thanks,
ak
My boss want me to give kill session privilage one
of the developer here . He doesn't have any dba privilage to see session or
anything . Is there any way I can give likited access to him.
Thanks,
ak
not a OAS/IAS report ).
Thanks
-ak
Thanks for reply everybody ,
I was not closing the file , which was causing write not to flush . Solved
now
-ak
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Tuesday, November 18, 2003 10:59 AM
>
what is max filesize for utl_limit.fopen ? I am
unable to past beyond 51K .
-ak
How to recycle sbtio.log . Is it same way as
alert.log ?
-ak
truck_id
load
date_delivered
blah
blah
from
to
This takes care of split cargo ( consigment ) .
-Ak
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Thursday, November 06, 2003 6:44 AM
> I remember seeing this question asked on
Is it a freeware :)
-ak
- Original Message -
From:
Karniotis, Stephen
To: Multiple recipients of list ORACLE-L
Sent: Thursday, October 30, 2003 9:24
AM
Subject: RE: proc to pl/sql
Actually
there is. It is called a
consultant.
Because
Is there any tool out there that can convert pro*c
code to pl/sql ?
thanks,
-ak
ha ha ha ha ha ha ha ;)
-ak
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Tuesday, October 28, 2003 5:54 PM
> Don't get me wrong, I've recently changed positions and am not interested,
> but what are &qu
Thanks Dennis for Reply,
My confusion is , does RMAN sees only those archived logs which are backup
using rman or it can use current archived log as well stored in original
format at other disk ?
-ak
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EM
run { restore
databse; recover database } from rman and then apply remaing archived logs from
a separated disk ( not a rman backup ).
Thanks,
-ak
S Does it mean that a network with 100 computers of 1 cpu each is almost
equivalent to 100 cpu giant computer ??
-ak
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Monday, October 27, 2003 4:39 PM
> Rich,
>
> That
rman restore.
oyaa i do have free(man)'s guide but that's for 9i .
Thanks,
-ak
- Original Message -
To: <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Friday, October 24, 2003 11:15 AM
> AK - This sounds like a disaster recovery test. Be sure to buy Robert
&g
I am also interested in this paer .
-ak
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Friday, October 24, 2003 12:14 PM
> List,
>
> Anyone has the copy of Steve Adams' 'Seven deadly sins in Oralce'
. ( here I get confused , since I dont have
latest control file , what are implication , and what should I do )
5. connect to rman
6. run ( set until ...; restore db ; recover
db ; )
Thanks,
-ak
Thanks Ron ,
This worked . But do you know why it happens . As I said its happening third
time with me . My unix screen behaves weired sometimes it doesn't print any
character I type and some time it prints characters which I never type ( in
this particular case ).
Thanks,
-ak
- Ori
This happening with me 3 rd time on this hp box .
When I do ls -alt I can see a file in current directory but when I try to open
it (vi/cat ) it says no such file or directory . I am same user who
created the file . ( no permission problem )
Any idea ??
-ak
/home/ak/myscripts
and which sql makes server HOT
-ak
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Thursday, October 23, 2003 2:14 PM
> 1) What does it mean to grokkk?
> 2) What is the answer to the question of life, universe and
is there any way trigger I can write so that no
body can compile object (package/procedure) and alter table during business
hours in 8.1.7.4 db.
-ak
Same here ,
I delete few mails in evening and they show up
again in morning . I doubted myself 2-3 times ;)
-ak
- Original Message -
From:
[EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L
Sent: Wednesday, October 22, 2003 8:44
AM
Subject: Re
Hi Guys ,
I have been recently tasked to write up
procedures and steps / documentation for disaster recovery of db/system
.
Any help , pointers ,links related to this is
highly appreciated .
Thanks,
-ak
OCP DBA 8i
why one can't do same on widoz as well ?
works well .
-ak
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Tuesday, October 21, 2003 8:44 AM
> is this a Unix box?
>
> if so, log on as the oracle accou
Congrates Dennis ,
Get set for 9i upgrade soon. 10g is on the way :)
-ak
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Thursday, October 16, 2003 12:24 PM
> I just passed the Net8 Administration OCP exam. This was
There is a toll "schema manager " by quest . Have a look at that as well. I
haven't used it though.
-ak
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Thursday, October 16, 2003 10:24 AM
> Hi All,
>
Looks like Tanel Podar is hiding some where or
restraining from answering ? Missing his highly sophisticated answers
;)
-ak
only if your backupset size is more then total_arc_log_file_sizes .
Otherwise there will be more then one pieces , rite ( ??)
-ak
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Wednesday, October 15, 2003 1:19 PM
> With RM
rease to 0 this table is still coming in my list of monitored exntents
which doesn't have room for next growth.
Question is , when does oracle calcs next space
requirement ? It looks like its precalculated .
-ak
Rajesh ,
I think in 9i dataguard this task became little easier . It doesn't take
that much time to change role of database from primary to standby and vice
versa . That's what doc says I haven't tried it myself though.
-ak
- Original Message -
To: "Multiple recip
Is it okay to resize datafile while user activity
is going on ? version 8.1.7.4 hp-ux .
-ak
I think
' begin
> mystorageArray.field_''i'' := 1;
> end; ';
will not recongize mystoragearray as a variable .
-ak
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Thursday, October
Just curious ,
If I buy named user licence and use some
application to connect using same user (Just like any app server with
connection pooling ) does the cost multiply to no of
user_connecting_to_app_server or no_of_users_actually_connected to
database ( mean schemas) ??
-ak
This will set your current schema to act like "sys" so that you no longer
need a qualifier like sys.v_$instance . This is another way to avoid public
sunonym . ( btw, do the people here use public synonym , i see tom kyte is
against it )
-ak
- Original Message -
To:
where can I get binaries for perl DBI and DBD for
hp-ux 9000 . I dont have pre requisite for building binaries from source
.
Thanks,
-ak
I don't remember appearing this one in exam .
-Ak
OCP 8i
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Monday, September 29, 2003 2:34 PM
> Can anyone recall whether the Oracle Intelligent Agent figured on th
How to one subcribe to
Comp.database.oracle newsgroup . Can it be added into outlook
directly .
thanks,
-ak
(numer or value error) -- get proper exception
result=false
return result;
end;
same can be done for isDate as well.
-ak
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Thursday, September 25, 2003 8:
In US it is called take the exam while in INDIA it is give the exam . ug
need ANSI english .
-ak
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Wednesday, September 24, 2003 2:14 PM
> Give or take the exam? Mak
program work.
-ak
- Original Message -
From:
Stephane Paquette
To: Multiple recipients of list ORACLE-L
Sent: Friday, September 19, 2003 8:59
AM
Subject: Reducing the number of
databases
Hi,
We have around 120
databases. Most applications have 5
Never mind, its working .
-ak
- Original Message -
From:
AK
To: Multiple recipients of list ORACLE-L
Sent: Tuesday, September 16, 2003 11:39
AM
Subject: oracle Apache
thought about playing with apache ( shipped in
oracle cd ) . It's a win 2000 s
0/apache/apache/htdocs/.. . I want it to look for
index.html in c:/myweb/ .
Am i missing something here .
-ak
generated then you can first install same
version of databases as originally then recover till current date and
migrate to 9i finally . But yeah during 9i migration I guess you will need some
downtime .
-ak
- Original Message -
From:
Chindarkar, Chetan (CONS FIN
Is there some changes in default archivelog file
format with oracle 9i ?
-ak
n (like subscribing).
>
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: AK
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
Title: Message
You can user perl package manager in activestate .
from ppm command prompt issue "search dbi" or "search dbd" and then issue
install dbd /dbi.
-ak
- Original Message -
From:
Mladen
Gogala
To: Multiple recipients of list ORACLE-L
Congrates Arup !!! You doing a great job .
-ak
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Thursday, August 28, 2003 7:54 AM
>
> Just came to know from CTOUG news that Oracle has chosen Arup Nanda(our
> List me
-
From:
AK
To: Multiple recipients of list ORACLE-L
Sent: Wednesday, August 27, 2003 9:09
PM
Subject: oracle sessions from term
server
Hi Guys ,
we have forms/report application installed
on windows terminal servers and user access application
Title: International Language Support Experiences?
we have been using utf8 char set for international
support in the database .
-ak
- Original Message -
From:
David Wagoner
To: Multiple recipients of list ORACLE-L
Sent: Wednesday, August 27, 2003 11:34
AM
problem with some sql*net setting ?? Any
help in this regard is highly appreciated .
thanks,
-ak
I am sure you guys might have some nice
perl/shell script to analyze alert log for errors or potential problem . Can you
share it with me /list .
Ohh thanks in advance guys .
-ak
looks like internally from proc its setting dbms_output.enable();
-ak
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Tuesday, August 26, 2003 11:04 AM
> talk about unprofessional... this stuff should never go into producti
EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>
--
Please s
Hi Gang ,
I have some upgrade script from vendor ( no source code ) which calling some procs .
Now I am getting "buffer overflow, limit of 100 bytes" error from it . Looks like
they are spitting out debug statmts out with dbms_output . How can I stop this to
happen without touching source co
lback entry for one update statement ??
-ak
---
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).
Does OEM 9.2.0.1 works well with 8.1.7.4 database ?
or in general with all versions of databases (7.3,8.0,8i,9i ) ? Does it
recognise underline db version and sends commands appropriately . Any Idea
?
thanks,
-ak
stripe size of 32k on 3
disks can make 12 block read at parallel .
I think Ahmed Alomari has some good stuff on io
tuning in book 'Oracle and Unix performance tuning '.
-ak
- Original Message -
From:
Matthew Zito
To: Multiple recipients of list ORACLE-L
Is there any command on hp-ux which can tell me on
what disks particular file is striped on and stripe size .
Hp-ux ( 11 )
Thanks,
ak
that's rite . But what if you want to change something in param file for
this db .
-ak
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Thursday, August 14, 2003 4:44 PM
> Hi!
>
> But it really doesn't ma
se changes to the target dbs .
Are there any similer tools , to compare with
?
Thanks,-Ak
Dennis ,
One can always find good and bad programmers any whre in world . But in this
thread competency is brought up only bacause of cheap labor they are
concerned .
-ak
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Thu
labor is just like another raw material . when America can dump chemical ,
weapons , plastic and electronic on name of free trade to all over world ,
why are we scarred when someone else is dumping labor ??
-ak
- Original Message -
To: "Multiple recipients of list ORACLE-L&quo
Is there a way to find which init.ora is a running
db is using ?
-ak
select new_time(sysdate,'GMT','PST') from dual;
-ak
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Tuesday, August 12, 2003 4:39 PM
>
> I need some help to convert a GMT date into PST date and t
100 instances woh . If you are in 9i look at possibilities like context
or label security . or creating another schema .
-ak
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Wednesday, August 06, 2003 9:24 PM
&g
How to diiferentiate views and tables in all_tables
and all_tab_columns . which column and what criteria can return only tables
??
-ak
Now , what is your server configuration ? windows , sun ,
hp ?? memory ??
-ak
- Original Message -
From:
Dilip Patel
To: Multiple recipients of list ORACLE-L
Sent: Thursday, August 07, 2003 3:54
PM
Subject: Re: 100 instances on same server
Thanks Dennis ,
But I am looking something for oracle application server .
-ak
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Wednesday, August 06, 2003 10:14 AM
> AK - My favorite for people that are new to Oracle, or
Any good book on oracle 9iAS for beginners which
covers installation , configurations etc .
There is too much in oracle docs .
-Ak
Avnish ,
As far as log buffer is considered , look at how much redo ur generating .
That will be help you in finding optimal size of log buffer .
-ak
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Tuesday, August 05, 2003 4:54
One more thing to look at , if there were any object or tablespace in
nologging mode earlier ?
-ak
- Original Message -
From:
Munish Bajaj
To: Multiple recipients of list ORACLE-L
Sent: Friday, August 01, 2003 4:24
AM
Subject: RE: Redo Logs Problem
; also send the HELP command for other information (like subscribing).
>
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: AK
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list
oops looks like i missed "using package ..."
part in doc and shoot the question . Not this makes little sens
;)
sorry guys .
-ak
- Original Message -
From:
AK
To: [EMAIL PROTECTED]
Sent: Thursday, July 31, 2003 1:41
PM
Subject: global context
by any session . Now here i am confused ..
How does this thing is secure, cuz any session can
say my context is "MANAGER' or "CLERK" or whatever . Isn't it back to the roles
initially where any session can say heyyy enable role "MANAGER" ( offcourse if
its granted ).
-ak
grant create any trigger to xyz ;
-ak
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Thursday, July 31, 2003 12:59 PM
> My brain is not working todayI cannot figure out how to allow one user
> to look a
This is happening 3rd time with me so I have to
figure out what's wrong . When I issue the given sql first time i get
an error as shown . After that I copy and paste it again and it works second
time . Any clue what should be the reason ? btw, it happens with any sql ..not
just this one . I
points
datafile ?
-ak
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Thursday, July 31, 2003 9:09 AM
> What we found is that it doesn't matter which tablespace the session
> causing the wait is accessing. As explain
it mean
that all transactions which started before issuing "alter tablespace read
only" should be finished ??
-ak
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Wednesday, July 30, 2003 5:44 PM
> Ah, one I have the
why does it take long time to turn a tablespace
read only . I issued the command 10 mins back , its still not returned .
There is almost no activity in db .
8.1.7.4
hp-ux
-ak
In that case you dont need more then 1 member per group . :)
-ak
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Wednesday, July 30, 2003 12:14 PM
> I thought you need to preserve the groups, not (necessarily) the members.
&
Answe is 4 disks . to keep each member on different disks .
-ak
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Wednesday, July 30, 2003 10:19 AM
> Hi all,
>
> What is the correct answer for this?
>
> Q>
Hi
where can I find steps ( procedure ) for upgrading
from 8.1.7 to 9i .
Thanks,
-ak
Not sure but this might have something to do with charset (if toad can
handle clob??? ) . what is db charset ? is it utf8 .
-ak
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Tuesday, July 29, 2003 8:19 AM
> Hi,
&
We are using AQ for long time . No problems so far .
-ak
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Monday, July 28, 2003 8:29 PM
> Hi,
>
> I am looking at using Oracle AQ to post messages.I know they are just
so what happens when first node goes down , oracle instance (processes )
will start on other node ? OS will take care of everything ?
-ak
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Monday, July 28, 2003 9:29 AM
> ak,
Try to give this index initial sufficient space so that it does not
autoextend the extents.
-ak
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Monday, July 28, 2003 9:09 AM
> I asked this last week, but I have a little
Hi Guys ,
I am new to this clustering concept. Just trying to
understand few basics . Need ur help .
what is differece between oracle running on sun /hp
cluster with 2 nodes and oracle with RAC running
on 2 nodes ?
thanks,
-ak
while rebuilding indexes i gave parrallel 2 . But I
see there are four ora_p00 processes . ???
-ak
Yeap , Thanks Dennis . I am keeping that in mind .
-ak
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Wednesday, July 23, 2003 2:54 PM
> AK
> Even though you can rebuild indexes online, it is a good idea to
perfor
The only reason I wanted to build the indexes was
to relocate them to another tablespace ( LMT ) so that I can get rid of high
fragmentation and start living .
-ak
- Original Message -
From:
Tanel
Poder
To: Multiple recipients of list ORACLE-L
Sent: Wednesday
You will have to write separate batch script or use some tool to back them
up to tape .
Yes, RMAN can do it all for you if setup accordingly to delete xyz days old
archived log;
-ak
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent:
will still have trace of error . One thing to make sure is autonomous
block always do a commit or rollback of its work before exiting .
begin
xxx
xxx
exception
call errorlog; -- this is autonomous
rollback;
end ;
-ak
- Original Message -
To: "Multiple recipients of list ORA
Does index rebuild generates new statistics as well
? How does that can hit performance intermediately if I want to rebuild few
indexes daily just to finish everything in 5 days .
-ak
where can i find a script to find segments which
can't extend due to low of space in tablespace .
-ak
Now this one is difficult folks ..
what is average age of an experienced oracle dba
?
-ak
never mind got the answer.
- Original Message -
From:
AK
To: [EMAIL PROTECTED]
Sent: Tuesday, July 22, 2003 2:26
PM
Subject: maxsize
is it possible to change maxsize of autoextend
datafile ? how ?
is it possible to change maxsize of autoextend
datafile ? how ?
different
tablespace.
Does number of extents is a performance issue in
LMT as well ? Any experience ?
Thanks,
-ak
Thanks KG for the info . You guys rock .
-ak
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Monday, July 21, 2003 11:39 PM
> AK:
>
> Very much possible and very simple if you are using Linux or Windoze. I
&
1 - 100 of 209 matches
Mail list logo