Comments for Oracle DBA Daily Experiences

Comment on Oracle RAT Workload Replay with filters by Ken

Ken — Tue, 08 Jun 2010 23:05:05 +0000

Hmm, this looks familiar…

Comment on How to create a NetApp FlexClone RAC Database by Shekhar

Shekhar — Wed, 28 Apr 2010 01:05:01 +0000

Hi,

I appreciate if any one related to can answer my questions.

What are the requirement for the above exercise? Do I have to install Oracle RAC cluster and DB before that? I was wondering if I can use this solution to clone existing installation cluster and database from Prod and database.

Please let me know

Comment on Kill session with TOAD or other tools by Alex Lima

Alex Lima — Mon, 19 Apr 2010 20:11:28 +0000

Hi, I guess the idea here was not to check for sys or dba using with tools…
Sometimes you might go to a site where changes in the privileges can be very challenging.
Thank you for you feedback.. let;s keep in touch. feel free to submit any ideias…
Alex

Comment on Kill session with TOAD or other tools by rajesh

rajesh — Mon, 19 Apr 2010 19:06:58 +0000

sys (dba) connections don’t invoke logon trigger. Hence the check for sys user in the trigger may be unnecessary. Also if the intention is to prevent development then it may be better to control it through privileges.

Comment on How to schedule a job on unix? by Alex Lima

Alex Lima — Tue, 26 Jan 2010 21:42:38 +0000

Hi,
Look at the botton of the pages.. there is a link there for the theme..
Thanks,
Alex

Comment on How to lock/unlock statistics on a table? by chandra

chandra — Thu, 31 Dec 2009 16:00:55 +0000

It is a great document

can you also tell

what all we should monitor to know is the whole configuration is working fine or not

like what scripts we should check

I want to monitor it manually I dont want to use the datguard broker

I want to use automated scripts for monitoring teh databases and
I want to use the alerts from teh scripts to do failover

can you please give more insight in the above mentioned direction

Regards
Chandra

Comment on How to find the tables that have stale statistics? by Pinaki

Pinaki — Sun, 29 Nov 2009 08:58:58 +0000

Nice … so beautiful and useful

Comment on How to find success/failure status of a command in different shells? by [cli] Find out success status of a command in BASH/ CSH « *NIX tricks

[cli] Find out success status of a command in BASH/ CSH « *NIX tricks — Fri, 20 Nov 2009 21:11:09 +0000

[...] Credit: Oracle Spin. [...]

Comment on How to create a on-demand AWR snapshot? by Amin

Amin — Thu, 19 Nov 2009 01:02:36 +0000

Hi Chris,

What is the error you see, which user does the script login as and can you send the script that you are using?

Comment on How to create a on-demand AWR snapshot? by chris economy

chris economy — Wed, 18 Nov 2009 23:31:20 +0000

Hi,

Do you know if one can create a snapshot from a unix shell
script ? I have sqlplus running nicely from a shell script and can issue SQL commands with no problem, but when I exec dbms_workload_repository.create_snapshot();
it will not work. I have Goggled for days, and have found no exapmples of this

Thank you for your time and expertise!