Experience: is what you get soon after you need it.

Experience: is what you get soon after you need it.

****************Got the opportunity to pen a Book on Database Cloud Services.......More details to follow.***************

Title : Database Cloud Revealed
Publisher : Apress
Release Date : Jan-2020

**********************************************************************************


My Cloud Certifications:

AWS Certified Solutions Architect Associate

Azure Certified Architect

Azure Certified Administrator

Oracle Cloud Infrastructure 2018 Certified Architect Associate.

Oracle Cloud Infrastructure Classic 2018 Certified Architect Associate.

Oracle Database Cloud Administrator Certified Professional.

Oracle Database Cloud Service Operations Certified Associate.

Search This Blog

Tuesday, July 3, 2012

SQL Profiles- ENABLE, DISABLE and DROP


SQL> exec dbms_sqltune.alter_sql_profile('SYS_SQLPROF_0236d8f37a490001','STATUS','DISABLED');

PL/SQL procedure successfully completed.

SQL> exec dbms_sqltune.alter_sql_profile('SQL_PROF_FOR_DELETE','STATUS','ENABLED');

PL/SQL procedure successfully completed.


SQL> EXEC DBMS_SQLTUNE.DROP_SQL_PROFILE('SYS_SQLPROF_02384d2b5e320000');

PL/SQL procedure successfully completed.


SQL> COMMIT;

Commit complete.

7 comments:

sheela rajesh said...

I appreciate your effort and you have done a great job.thanks for the ideas and please add more in future.
Software Testing Training in Chennai
Software testing training in OMR
JAVA Training in Chennai
Python Training in Chennai
Big data training in chennai
IOS Training in Chennai
Software Testing Training in Chennai
Software testing training in Tambaram

Chris Hemsworth said...

The article is so informative. This is more helpful for our
Learn best software testing online certification course class in chennai with placement
Best selenium testing online course training in chennai
Best online software testing training course institute in chennai with placement
Thanks for sharing.

divi said...

Thanks for taking the time to discuss this, I feel happy about it.web design company in velachery

markson said...

The inquiries posed in the test are in various decision positions, establishing 200 things, out of which 175 will be reviewed and 25 are pre discharge questions. ExcelR PMP Certification

digitaltucr said...

Truly, this article is really one of the very best in the history of articles. I am a antique ’Article’ collector and I sometimes read some new articles if I find them interesting. And I found this one pretty fascinating and it should go into my collection. Very good work!
ExcelR pmp certification

Priyanka said...

Attend The Analytics Course in Bangalore From ExcelR. Practical Analytics Course in Bangalore Sessions With Assured Placement Support From Experienced Faculty. ExcelR Offers The Analytics Course in Bangalore.
ExcelR Analytics Course in Bangalore

360digitmg05 said...

Thanks for the informative and helpful post, obviously in your blog everything is good..

360DigiTMG project management institute malaysia