FYI: EVENT: Oracle's Next Generation Data Centre Summit 2010 - Sydney (Thursday 16 September 2010 8:30 a.m. to 6:00 p.m.) - Hi All,
Just FYI if anyone is interested to win a Navman as Andrey G. from
Pythian did last time :)
http://eventreg.oracle.com/web apps/events/ns/EventsDetail.js p?p_eventId=115260&src=701 8099&src=7018099&Act=1 48
Regards,
Yury Velikanov
Oracle [Ap
|
Yury Velikanov
|
Aug 31, 2010
11:05 AM
|
Status update ... - Hello Community,
Just to let you know that I have uploaded the presentation file from
the last Meetup.
http://files.meetup.com/141152 0/Oracle%20Stats%20Aug%2025%20 2010%20v2%20%28Core%29.ppt
As a follow up on the discussion related to job_queue_pro
|
Yury Velikanov
|
Aug 27, 2010
11:00 AM
|
|
RE: [Sydney-Oracle] Fwd: Announcing "Preliminary Booking", Wednesday, September 8, 2010 5:30 PM! -
|
Nuno Pinto do Souto
|
Aug 25, 2010
1:58 PM
|
|
Fwd: Announcing "Preliminary Booking", Wednesday, September 8, 2010 5:30 PM! - Preview not available
|
Yury Velikanov
|
Aug 25, 2010
1:18 PM
|
|
Re: [Sydney-Oracle] 10.2.0.4 CRS to 11gR2 Grid Infrastructure upgrade issue - Hi Neil, Have you tried look into the CRS daemons are all up and running? I've come across the situation after upgrading the clusterware, the CRSD will crash after a few fail startup attempts. Regards
Geoffrey
|
Geoffrey Zhang
|
Aug 12, 2010
3:56 PM
|
|
Re: [Sydney-Oracle] 10.2.0.4 CRS to 11gR2 Grid Infrastructure upgrade issue - I see. Just wonder what installation type you are after? Are you
implementing full scope SCAN/GNS solution?
If yes, there are DHCP service should be configured in a certain way
to assign IP addresses to SCAN and VIP components.
Yury Velikanov
Orac
|
Yury Velikanov
|
Aug 11, 2010
5:21 PM
|
|
[Off topic] - VPN help - Hi everyone,
I need to grant access to my LAN and I am a little bit confused about
where to start. The router allows to add VPN polices, but I guess I
still need to install a VPN server, don't I?
I have a Ubuntu Server running by the way.
If
|
Sebas
|
Aug 11, 2010
12:03 PM
|
|
RE: [Sydney-Oracle] 10.2.0.4 CRS to 11gR2 Grid Infrastructure upgrade issue -
Thanks Yury, However, this is an Upgrade from a long standing and
|
Neil Campbell
|
Aug 11, 2010
10:54 AM
|
|
Re: [Sydney-Oracle] 10.2.0.4 CRS to 11gR2 Grid Infrastructure upgrade issue - Hi Neil,
I was facing the issue like yours. I would suggest to double check
that Innterconnect network is working fine.
The easiest way is to to ping the other node or ssh to private IPs.
Yury Velikanov
Oracle [Apps] DBA
The Pythian Group (tem
|
Yury Velikanov
|
Aug 11, 2010
10:50 AM
|
|
10.2.0.4 CRS to 11gR2 Grid Infrastructure upgrade issue -
Hi all, I am working on an in place upgrade of a 2 node RAC clust
|
Neil Campbell
|
Aug 11, 2010
9:11 AM
|
Martin Wisniewski added a post - If you are interested in Exadata... https://www2.gotomeeting.com/r egister/171889707
|
Martin Wisniewski
|
Aug 9, 2010
1:40 PM
|
|
Fwd: [ACTOUG] Presentation On 13th October 2010, the ACT Oracle User Group will be running a DBA/Dev/Apps/Java day. - Hello Everyone,
Our friendly Oracle Group from Canberra organizing an event this
October (see an email bellow).
Everyone from our group is welcome to participate. There should be a
free lunch for participants.
At the moment Marcel who presented f
|
Yury Velikanov
|
Jul 27, 2010
5:08 PM
|
|
Martin Wisniewski added a post - I will be presenting "Database Support Outsourcing Worst Practices - Avoiding a Recipe for Disaster" in Melbourne during InSync10 (Aug 16-17)
|
Martin Wisniewski
|
Jul 27, 2010
4:24 PM
|
|
[Sydney-Oracle] OMS and OEM Agent Upgrade on 400+ servers - Preview not available
|
Hayden Barile
|
Jun 28, 2010
11:20 AM
|
|
Re: [Sydney-Oracle] OMS and OEM Agent Upgrade on 400+ servers - There are some notes on oracle support
that describes approaches to upgrade agents
There is one note for 10.2.0.5 where new link
to patch agent (in deployments tab) appeared and
through GC interface you will be able to selected targets
to patch etc
|
Andrey Goryunov
|
Jun 26, 2010
3:08 PM
|
|
Re: [Sydney-Oracle] OMS and OEM Agent Upgrade on 400+ servers - Forgot to ask about versions of agents - have you thought about agent11g?
It can work with oms 10.2.0.4(5) and also there are some interesting and
helpful commands like switch of oms (can be helpful)
and of course there are improvements of monitoring t
|
Andrey Goryunov
|
Jun 25, 2010
10:41 AM
|
|
Re: [Sydney-Oracle] OMS and OEM Agent Upgrade on 400+ servers - Bill,
I think it should be separated to 2 parts - mass upgrade of agents and
upgrade of OMS itself
First part can be handled through mass agent deployment: you should
provide software
accessible on hosts (either through upload from oms web server o
|
Andrey Goryunov
|
Jun 25, 2010
10:39 AM
|
Re: [Sydney-Oracle] OMS and OEM Agent Upgrade on 400+ servers - Since you are using OEM GC, you might find this useful: Patch a Thousand Databases, Using Oracle Enterprise Manager Grid Control: http://www.oracle.com/technolo gy/pub/ar
|
Geoffrey Zhang
|
Jun 25, 2010
9:20 AM
|
|
OMS and OEM Agent Upgrade on 400+ servers - Hi Guys,
I am working on a project that upgrading OMS and OEM Agent both from 10.2.0.4 to 10.2.0.5 on 400+ servers. Could anyone please suggest a solution to facilitate this operation? The main purpose is to
|
Bill Shi
|
Jun 24, 2010
11:14 AM
|
|
One row select optimization from one row table (ref: last meetup discussion) - Hi all,
Just to follow up a discussion that we had during last meetup.
I was stating that FULL SCAN isn't the best for selecting one row from
one row table.
Here is the example showing that I was saying.
A full scan select 3 blocks. An index scan
|
Yury Velikanov
|
Jun 7, 2010
8:39 AM
|
|
Re: [Sydney-Oracle] I need you help. Odd performance difference comparing 4k data block size and 8k databases - > could you please provide also all init parameters for the databases
> in attached file?
not a problem at all (see attachment)
PS The 8kb DB is having Standby DB. Not sure if it makes any difference :)
Yury Velikanov
Oracle [Apps] DBA
The Pyt
|
Yury Velikanov
|
Jun 4, 2010
3:57 PM
|
|
Re: [Sydney-Oracle] I need you help. Odd performance difference comparing 4k data block size and 8k databases - Yuri,
could you please provide also all init parameters for the databases
in attached file?
Cheers,
Andrey
On 4 June 2010 13:33, Yury Velikanov wrote:
> Hello Everyone,
>
> Just to follow up on the issue.
> The inve
|
Andrey Goryunov
|
Jun 4, 2010
3:09 PM
|
|
Re: [Sydney-Oracle] I need you help. Odd performance difference comparing 4k data block size and 8k databases - Hello Everyone,
Just to follow up on the issue.
The investigation is still in process. I work on that as time permits
(as client doesn't complain and have other priorities). However this
definitely looks like a technical challenge. And who but us Or
|
Yury Velikanov
|
Jun 4, 2010
1:33 PM
|
|
RE: [Sydney-Oracle] /etc/oratab settings in Red Hat linux for ORACLE_HOME before upgrade from 10.2 to 11.2 -
Thank you Geoffrey. Yes i could proceed only setting ORACLE
|
karunika
|
Jun 4, 2010
12:46 PM
|
|
Re: [Sydney-Oracle] /etc/oratab settings in Red Hat linux for ORACLE_HOME before upgrade from 10.2 to 11.2 - The oratab file should be taken care by the OUI root.sh script and I
don't think you have to do anything to it. From my past upgrade experience on Solaris and Enterprise Linux, you only need to make sure ORACLE_BASE, ORACLE_HOME, and ORACLE_S
|
Geoffrey Zhang
|
Jun 4, 2010
11:05 AM
|
|
/etc/oratab settings in Red Hat linux for ORACLE_HOME before upgrade from 10.2 to 11.2 -
Hi All
I am going to upgrade fr
|
karunika
|
Jun 3, 2010
11:59 AM
|
|
Remainder & Introduction of new time keeping policy - Hello Community, This email contains two things: - Remainder about coming Friday's Meetup - Announcement of changes introduce
|
Yury Velikanov
|
Jun 2, 2010
2:04 PM
|
|
Re: RE: [Sydney-Oracle] db console issues on AIX - Preview not available
|
Andrey Goryunov
|
Jun 2, 2010
1:43 PM
|
|
RE: RE: [Sydney-Oracle] db console issues on AIX -
|
Nuno Pinto do Souto
|
Jun 2, 2010
10:19 AM
|
|
Re: RE: [Sydney-Oracle] db console issues on AIX - Preview not available
|
Dipak Sharma
|
Jun 2, 2010
10:13 AM
|
|
RE: [Sydney-Oracle] db console issues on AIX - Preview not available
|
karunika
|
Jun 2, 2010
9:44 AM
|
|
RE: [Sydney-Oracle] db console issues on AIX - Preview not available
|
Neil Campbell
|
Jun 2, 2010
8:45 AM
|
|
Re: RE: [Sydney-Oracle] db console issues on AIX - Preview not available
|
Dipak Sharma
|
Jun 2, 2010
7:39 AM
|
|
RE: [Sydney-Oracle] db console issues on AIX - Preview not available
|
Nuno Pinto do Souto
|
Jun 2, 2010
7:20 AM
|
|
db console issues on AIX - Preview not available
|
Dipak Sharma
|
Jun 1, 2010
6:21 PM
|
|
Re: Reminder: DB Performance brick: SQL Access paths is in one week. | CALL FOR PRESENTERS - Preview not available
|
Yury Velikanov
|
May 28, 2010
12:49 PM
|
|
RE: [Sydney-Oracle] I need you help. Odd performance difference comparing 4k data block size and 8k databases - Bugger, I don't have access to any RHLinux system at the moment...
A couple of things to check, from a vague memory:
1- What file system block size for each db
2- Are datafiles for all dbs on same file system
3- What is the value of filesystemio_optio
|
Nuno Pinto do Souto
|
May 26, 2010
2:40 PM
|
|
Re: Re: Re: Re: [Sydney-Oracle] storage capacity planning - Hi Hrishikesh, One of approaches that can be used is UDM (user-defined metric) but I think it allows only to use max of 2 columns of the output that means if you want to get information about owner, segment type and segment name
together
|
Andrey Goryunov
|
May 26, 2010
12:56 PM
|
|
Re: [Sydney-Oracle] I need you help. Odd performance difference comparing 4k data block size and 8k databases - Thank you Alex to the suggestion.
I will do suggested latter on today.
As for now I did have another a look on the TRC files generated.
The following are two lines that shows that i case of 8k DB it takes
twice more time to process twice less blocks
|
Yury Velikanov
|
May 26, 2010
12:17 PM
|
|
Re: [Sydney-Oracle] I need you help. Odd performance difference comparing 4k data block size and 8k databases - Oh my bad. I forgot to mention that I did 10046 already :). Please
find RAW and TKPROFed files attached for your reference.
Beside of the fact that it doing FULL scan instead of INDEX 10046
doesn't show anything suspicious.
The odd thing in this case
|
Yury Velikanov
|
May 26, 2010
11:44 AM
|
|
Re: [Sydney-Oracle] I need you help. Odd performance difference comparing 4k data block size and 8k databases - Yuri,
First of all I would suggest you creating two tables testlio8k and testlio4k in the same database but in the tablespaces with a different block sizes.
Afterwards use runstats_pkg to compare your runs.
|
Alexander Sobyanin
|
May 26, 2010
11:39 AM
|
|
RE: [Sydney-Oracle] I need you help. Odd performance difference comparing 4k data block size and 8k databases -
Yury why not post a 10046 trace to see where the time is being s
|
Neil Campbell
|
May 26, 2010
11:23 AM
|
|
I need you help. Odd performance difference comparing 4k data block size and 8k databases - Hello everyone,
I need any idea that may came you your head to find out the reason for
the following problem. Please do not hesitate to through any
suggestions and I will check those for you.
This is a super-duper new Dell server, 11GR2, Red Hat En
|
Yury Velikanov
|
May 26, 2010
11:17 AM
|
Are you a DBA, Developer, Both or Neither - Hello Everyone Please take the time to answer our Poll. It will help us to generate better content for future events. http://www.sydneyoracle.com.au /polls/
|
Martin Wisniewski
|
May 25, 2010
12:15 PM
|
|
Re: Re: Re: Re: [Sydney-Oracle] storage capacity planning - Preview not available
|
Hrishikesh Samant
|
May 25, 2010
10:38 AM
|
|
Re: Re: Re: [Sydney-Oracle] storage capacity planning - Hi Hrishikesh, I think there is no such information to show space allocation for tables in GC by default. But it can be gathered by user-defined metrics with enabled collection for historical analysis. Cheers,
Andrey
|
Andrey Goryunov
|
May 23, 2010
11:23 PM
|
|
Re: Re: Re: [Sydney-Oracle] storage capacity planning - Preview not available
|
Hrishikesh Samant
|
May 22, 2010
10:17 PM
|
Fwd: FOLLOWUP: Let's discuss Hardware Performance Testing Tools (Oracle DB) - I forgot to mention that presentations' files and testlio scripts from
last night have been uploaded to the web site
http://www.sydneyoracle.com.au /files/
Yury Velikanov
Oracle [Apps] DBA
The Pythian Group (Sydney Office) - www.pythian.com
http:
|
Yury Velikanov
|
May 20, 2010
12:31 PM
|
|
TODAY'S MEETUP: Hardware Performance Testing Tools (Oracle DB) - Hello everyone!
This is a short reminder that we do have a Meeting today.
Casey Dyke (DBA team lead at Macquarie Bank) confirmed his
participation. Do not miss to hear about his experience in HW testing
area.
The short agenda for tonight is:
- 0 -
|
Yury Velikanov
|
May 19, 2010
9:46 AM
|
|
RE: [Sydney-Oracle] Strange ASM issue - RESOLVED -
Hi Yury Its a valid point, but I did inspect the header
|
Neil Campbell
|
May 18, 2010
10:55 AM
|
|
Re: [Sydney-Oracle] Strange ASM issue - RESOLVED - Hey Neil,
I am glad to see that our group helps :)
Just a possible hint form my side
>> was on a disk previously assigned to another diskgroup. I removed that diskgroup by shutting down the database,
>> removing the datafiles through asmcmd. Then
|
Yury Velikanov
|
May 18, 2010
10:41 AM
|
|
RE: [Sydney-Oracle] Strange ASM issue - RESOLVED -
Thanks Alex. The problem has been resolved. I firstly tri
|
Neil Campbell
|
May 18, 2010
9:05 AM
|
|
Re: [Sydney-Oracle] Strange ASM issue - Neil, For your point about startup issues with sqlplus vs srvctl. You probably want to check alert.log and traces for the root of " ORA-03113 " and the trace of the process (probably in udump as it
|
Alex Gorbachev
|
May 18, 2010
12:10 AM
|
|
Re: [Sydney-Oracle] Strange ASM issue - Just have another thought over your comment: "There is nothing strange in the ASM alert logs,
and the diskgroups etc seem to be ok." You could double check: 1)the oracle user should be in the asmadm
|
Geoffrey Zhang
|
May 17, 2010
12:06 PM
|
|
RE: [Sydney-Oracle] Strange ASM issue -
Hi Paul Good to hear from you mate ! Yeah, I had looked a
|
Neil Campbell
|
May 17, 2010
11:44 AM
|
Re: [Sydney-Oracle] Strange ASM issue - Hey Neil,
I am guessing you already found this article
http://jarneil.wordpress.com/2 008/07/07/asmlib-troubleshooti ng/
Given it is complaining about the driver not found, potentially it is a
path issue.
I noticed you rpm -qa|grep asm command lis
|
Paul Moen
|
May 17, 2010
11:25 AM
|
|
RE: [Sydney-Oracle] Strange ASM issue -
Thanks Geoffrey, I did look at this, and couldn't see anything o
|
Neil Campbell
|
May 17, 2010
10:52 AM
|
|
Re: [Sydney-Oracle] Strange ASM issue - Hi Neil, It might be worthy to check out the oracle home permission such as owner and group. Regards Geoffrey On Fri, May 14, 2010 at 4:09 PM, Neil Campbell <
|
Geoffrey Zhang
|
May 14, 2010
4:44 PM
|
|
Strange ASM issue -
Hi all, I have a 2 node (10.2.0.4) RAC cluster, (RHEL 4 update 8
|
Neil Campbell
|
May 14, 2010
3:42 PM
|
Another cool 10046 interface - Just to add on our discussion how to switch SQL trace. There is
another great interface :)
http://oraclue.com/2009/03/24/ oracle-event-sql_trace-in-11g/
Yury Velikanov
Oracle [Apps] DBA
The Pythian Group (Sydney Office) - www.pythian.com
http:/
|
Yury Velikanov
|
May 13, 2010
10:34 AM
|
|
RE: [Sydney-Oracle] Very good blog post -
|
Nuno Pinto do Souto
|
May 12, 2010
2:02 PM
|
|
Very good blog post - Just trolling blogs and ran over this. Very interesting technically and troubleshooting-wise. Anyone that eats mutexes for breakfast is ... well ... good. Very very good methinks.
|
Casey Dyke
|
May 10, 2010
9:38 PM
|
|
Re: To meet or not to meet: We move the event to 19th of May. TODAY's MEETUP IS CANCELED!!! - Preview not available
|
Yury Velikanov
|
May 3, 2010
1:52 PM
|
|
Re: [Sydney-Oracle] Re: Meetup details changed: Let's discuss Hardware Performance Testing Tools (Oracle DB) - Preview not available
|
Casey Dyke
|
Apr 29, 2010
8:35 PM
|
|
Re: Meetup details changed: Let's discuss Hardware Performance Testing Tools (Oracle DB) - Preview not available
|
Yury Velikanov
|
Apr 29, 2010
10:32 AM
|
|
Re: [Sydney-Oracle] LD_PRELOAD usage to fake hostname | Solution (including JAVA ;) ! - Hello everyone,
Thanks Sergey again.
It appears that JAVA unlike C based processes uses "gethostname"
function. Interesting enough that strace doesn't show that call at all
in the trace.
I checked and can confirm that with FAKE "gethostname" func
|
Yury Velikanov
|
Apr 28, 2010
3:37 PM
|
|
Re: [Sydney-Oracle] LD_PRELOAD usage to fake hostname | Solution ! - Hi Yury,
> Thank you for following up on our discussion. For others: it appears
> that the FAKE hostname method works for C code but doesn't for Java.
No, in my last message, I gave an example, that FAKE hostname works
fine both for C and JAVA. I
|
Sergey Kosourikhin
|
Apr 27, 2010
3:04 PM
|
|
Re: [Sydney-Oracle] LD_PRELOAD usage to fake hostname | Solution ! - >> Business Continuity for Oracle Applications Release 11i Using Oracle Real Application Clusters and Physical Standby Database [ID 341437.1]
Is a very good, correct and official Oracle version of an EBS DR solution.
However it is complex to setup,
|
Yury Velikanov
|
Apr 27, 2010
1:39 PM
|
|
Re: [Sydney-Oracle] LD_PRELOAD usage to fake hostname | Solution ! - Hi Sergey,
Thank you for following up on our discussion. For others: it appears
that the FAKE hostname method works for C code but doesn't for Java.
Sergey made some research on how to make java believe that it is
running on other host.
I will re
|
Yury Velikanov
|
Apr 27, 2010
12:51 PM
|
|
Re: [Sydney-Oracle] LD_PRELOAD usage to fake hostname | Solution ! - Hi all, Yep, Oracle has its standard method... But it uses LD_PRELOAD :)
|
Sergey Kosourikhin
|
Apr 25, 2010
8:12 AM
|
|
Re: [Sydney-Oracle] LD_PRELOAD usage to fake hostname | Solution ! - Sorry, Nuno and all !
I thought it would be direct message, because I pressed button "reply" on Yury's message. :)
Anyway,
I wrote it looks like this method with LD_PRELOAD doesn't work with Java. I tried to trace execution with
strace and found t
|
Sergey Kosourikhin
|
Apr 25, 2010
7:49 AM
|
|
Re: Re: [Sydney-Oracle] storage capacity planning - Hi Hrishikesh, I would definitely go with use of GC to that type of project since all infromation being saved in repository and you can use different metrics that already there for CPU, tablespaces, data files etc.
There is already r
|
Andrey Goryunov
|
Apr 24, 2010
9:51 PM
|
|
RE: [Sydney-Oracle] LD_PRELOAD usage to fake hostname | Solution ! - bless you!
;)
-----Original Message-----
From: [address removed] on behalf of Sergey Kosourikhin
Sent: Sat 4/24/2010 9:39 AM
To: [address removed]
Subject: Re: [Sydney-Oracle] LD_PRELOAD usage to fake hostname | Solution !
|
Nuno Pinto do Souto
|
Apr 24, 2010
6:03 PM
|
|
Re: [Sydney-Oracle] LD_PRELOAD usage to fake hostname | Solution ! - Preview not available
|
Sergey Kosourikhin
|
Apr 24, 2010
9:39 AM
|
|
Re: Re: [Sydney-Oracle] storage capacity planning - Preview not available
|
Hrishikesh Samant
|
Apr 24, 2010
2:17 AM
|
|
Re: [Sydney-Oracle] storage capacity planning - Hi Yury, I used GNUPlot along with KSH shell and Oracle scripting to generate the graphs via a cron job. The graphing framework
|
Paul Peterson
|
Apr 23, 2010
2:10 PM
|
|
Re: [Sydney-Oracle] storage capacity planning - > libraries and you get flexibility (combined with complexity).
It IMHO depends on what complexity level you are talking about.
Once (~3 months ago) I tried to used Google graphs for Oracle Events
historical data reflections.
Found some limitations th
|
Yury Velikanov
|
Apr 23, 2010
1:36 PM
|
|
Please update your RSVP for today's meeting - Hello everyone,
Please make sure that you current RSVP reflects the real live status.
It is important for the event planing purposes.
On behalf for Sydney Oracle Meetups organizers,
Yury Velikanov
Oracle [Apps] DBA
The Pythian Group (Sydney
|
Yury Velikanov
|
Apr 23, 2010
1:30 PM
|
|
Re: [Sydney-Oracle] storage capacity planning - Can also recommend Google Graphs for graphing.
It takes a little bit of work to begin with but there are lots of
libraries and you get flexibility (combined with complexity).
Nice looking graphs and very scriptable.
Yury Velikanov wrote:
> Hi
|
Andrew Boag
|
Apr 23, 2010
1:24 PM
|
|
Re: [Sydney-Oracle] storage capacity planning - Hi Paul,
|
Yury Velikanov
|
Apr 23, 2010
1:21 PM
|
|
Re: [Sydney-Oracle] storage capacity planning - Hi Hrishikesh, What level of capacity planning system are you looking for? I built a Capacity Planning system in my last positi
|
Paul Peterson
|
Apr 23, 2010
12:27 PM
|
|
RE: [Sydney-Oracle] Tools that doesn't lie ... | strace for performance problems diagnostic - Very slightly different in AIX, but same effective results:
-c
Counts traced system calls, faults, and signals rather than
displaying trace results line by line. A summary report is
produced after the traced
|
Nuno Pinto do Souto
|
Apr 22, 2010
1:55 PM
|
|
Re: [Sydney-Oracle] Tools that doesn't lie ... | strace for performance problems diagnostic - On Linux
-c Count time, calls, and errors for each system call
and report a summary on program exit. On Linux, this attempts
to show system time (CPU time spent running in the
kernel) independent of wall clock time.
|
Yury Velikanov
|
Apr 22, 2010
1:47 PM
|
|
RE: [Sydney-Oracle] Tools that doesn't lie ... | strace for performance problems diagnostic - Actually, I did NOT suggest strace -c. I suggested truss -c, in AIX: two completely different things...
I don't have strace in AIX.
Cheers
Nuno Pinto do Souto
DBA Team, Australia/NZ
-----Original Message-----
From: [address removed]
|
Nuno Pinto do Souto
|
Apr 22, 2010
1:42 PM
|
|
Re: [Sydney-Oracle] Tools that doesn't lie ... | strace for performance problems diagnostic - Preview not available
|
Yury Velikanov
|
Apr 22, 2010
1:40 PM
|
|
Re: [Sydney-Oracle] Tools that doesn't lie ... | strace for performance problems diagnostic - Preview not available
|
Yury Velikanov
|
Apr 22, 2010
1:27 PM
|
|
RE: [Sydney-Oracle] Tools that doesn't lie ... | strace for performance problems diagnostic -
|
Nuno Pinto do Souto
|
Apr 22, 2010
1:06 PM
|
|
Re: [Sydney-Oracle] Tools that doesn't lie ... | strace for performance problems diagnostic - Good stuff! I've used strace to nail some network configuration on Oracle support ID 561429.1 It appears the Oracle EL default setting in /etc/nsswitch.conf require review to your network en
|
Geoffrey Zhang
|
Apr 22, 2010
12:57 PM
|
|
Re: [Sydney-Oracle] Tools that doesn't lie ... | strace for performance problems diagnostic - Hi all,
I never used trace for performance diagnostic before.
Today I came across the case of sqlplus initial login slowdown. It
took 6 secs instead of 0.081s to get SQL*Plus prompt on a server (IPC
connection, no SQL*Net involved).
I had suspiciou
|
Yury Velikanov
|
Apr 22, 2010
12:38 PM
|
|
Tools that doesn't lie ... - Hi Community,
Just remembered another great tool from "tools that doesn't lie". It
is "/usr/bin/pmap 26037" gives a full virtual memory map for a
process. Great for memory problems troubleshooting.
Current list:
Linux:
-- strace
-- netstat
-
|
Yury Velikanov
|
Apr 22, 2010
11:04 AM
|
|
RE: [Sydney-Oracle] storage capacity planning - I run a variation of the attached script1 - with html output - to show
daily in our services web server what free space there is. It adds free
space to autoextend space and shows the "true" free space.
Got another variation that spews out comma-separ
|
Nuno Pinto do Souto
|
Apr 21, 2010
7:52 AM
|
|
Re: [Sydney-Oracle] Fwd: WFH: Sick child | I am sorry to out of topic post | My mistake - But we can still wish him to get well! ;)
Alex
On Tuesday, April 20, 2010, Yury Velikanov wrote:
> Hi List!
>
> I am sorry for spamming. I mixed up mail addresses. This should go to
> Pythian Sydney's group rather to Syd
|
Alex Gorbachev
|
Apr 20, 2010
3:26 PM
|
|
RE: [Sydney-Oracle] LD_PRELOAD usage to fake hostname | Solution ! - It's already archived!
Thanks, guys!
Cheers
Nuno Pinto do Souto
DBA Team, Australia/NZ
-----Original Message-----
From: [address removed] [mailto:[address removed]] On Behalf Of Yury Velikanov
Sent: Tuesday, 20 April 2
|
Nuno Pinto do Souto
|
Apr 20, 2010
2:54 PM
|
|
Re: [Sydney-Oracle] LD_PRELOAD usage to fake hostname | Solution ! - Hello Community,
I managed to resolve the issue by faking uname system call.
It looks like this functionality might be quite useful in some cases
(DR, Installation problems, make an application believe that it is
working on other host, OS, OS versio
|
Yury Velikanov
|
Apr 20, 2010
2:47 PM
|
|
tkprof record=$L.sql option | Very cool ! - Hi Everyone,
Just came across a tkprof option that i didn't know about.
Partially it covers something that we discussed during last meetup.
We said that it would be nice to have a tool that could parse a 10046
TRC file and generate *.sql with all SQ
|
Yury Velikanov
|
Apr 20, 2010
11:27 AM
|
|
Fwd: WFH: Sick child | I am sorry to out of topic post | My mistake - Hi List!
I am sorry for spamming. I mixed up mail addresses. This should go to
Pythian Sydney's group rather to Sydney Oracle Meetup mailing list.
See you Friday!
Yury Velikanov
Oracle [Apps] DBA
The Pythian Group (Sydney Office) - www.pythian
|
Yury Velikanov
|
Apr 20, 2010
10:46 AM
|
Re: [Sydney-Oracle] LD_PRELOAD usage to fake hostname | Looking for C programming advise .... - Just to let everybody know. Sergey - is the man! His solution worked.
I will update the list with full text today.
I would suggest to shake his hand next time you meet him
(http://www.sydneyoracle.com.a u/members/10736893/).
BTW: We reached 200 MEMBE
|
Yury Velikanov
|
Apr 20, 2010
9:13 AM
|
|
WFH: Sick child - Hello Team,
My youngest child got sick tonight.
In order to give a bit of help to my wife (let her to drive oldest to
school) i will work from home today.
Please let me know if there are any related issues.
Regards,
Yury Velikanov
Oracle [Apps]
|
Yury Velikanov
|
Apr 20, 2010
7:45 AM
|
|
storage capacity planning - Preview not available
|
Hrishikesh Samant
|
Apr 20, 2010
12:37 AM
|
|
Re: [Sydney-Oracle] Database upgration from 10g to 11g - Paul,
small correction - the script for convertion called utlirp and
database should be in upgrade mode for it
and after utlrp (recompilation of invalid objects) should be executed
(normal mode)
Regards,
Andrey Goryunov
On 19 April 2010 12:16
|
Andrey Goryunov
|
Apr 19, 2010
1:44 PM
|