more then 1900 hidden parameters in 11g

SELECT A.KSPPINM FROM X$KSPPI A,X$KSPPSV B WHERE a.indx=b.indx;

Comments

Post a Comment

Popular posts from this blog

First Step : Oracle DBA

First Step towards Oracle DBA: My thoughts: I think a learner DBA should not jump on the Oracle database,sql,plsql to start with. It will be really nice to understand the basics of RDBMS: (May be learnig in parallel, But donot avoid Learning database design concpets) To learn DBA from very basics you must understand the database design. Learn RDBMS concepts. Learn Normalization Relations Between Tables Best Practices in Database Design Try to Create Few tables based on some data, Normalization is an important step in database design, as it minimizes the redundancy in information. If required level of Normalization is not achieved , It will not be a good database design. If redundancy is not eliminated then more space is required to store the data. Which is not a good database design. You can google normalization and you will get lot of pages so i am not describing here. You can read from the website http://www.dbnormalization.com/ The key here is that you sh...
Read more

OCM 11g -Finally complete

Hello everybody.... Many thanks to god....... finally my OCM exam result is out and I got a mail ..and I have successfully cleared the Oracle Certified Master exam and I have been awarded OCM status by Oracle Corp.....It was the most awaited email which i got couple of hours back................Cheers !!!
Read more

Covert to Shared appltop.

Covert to Shared appltop. : This was tested on 11.5.10, Please check the Oracle documentations for the latest patches and updates. (Ref: metalink note : Sharing the Application Tier File System in Oracle Applications Release 11i [ID 233428.1] ) 1 Verify the pre-requisites 1.1 Software Requirements: Ensure that these minimum versions are present in your system. • 5035661 to each iAS ORACLE_HOME in the application tier. • TXK AutoConfig Templates RUP O or higher (Apply patch 5478710 to each APPL_TOP in the application tier) • TXK Technology Stack Minipack B (Apply patch 3219567 to each APPL_TOP in the application tier) • AD Mini-pack I or higher (Apply patch 4038964) • iAS Oracle HTTP Server Rollup 5 or higher (Apply the latest critical patch update available for Oracle E-Business Suite 11i. Refer to section "Oracle HTTP Server Patches for Oracle E-Business Suite 11i" for instructions) • Discoverer 4.1.48.08 (See OracleMetaLink Doc ID: 139516.1 OracleMetaLink Doc...
Read more