What is plssql/database cache ?

.NET C C++ CSS DBA General HTML Java JavaScript JSP JUnit MySQL Networking Oracle Perl Perl PHP PL/SQL RSS Software QA SQL Server Struts Unix Windows XHTML XML

Home Hot About Collections Index RSS Atom Ask

Tester Developer DBA Windows JAR DLL Files Certificates RegEx Links Q&A Biotech Phones Travel FAQ Forum

Home > Oracle

✍: Guest

In order to improve performance mod_pls (Apache component) caches some database content to file. This database/plssql cache is usually of type session and plsql cache
# session cache is used to store session information.
# plsql cache is used to store plsql cache i.e. used by mod_pls

2011-11-26, 3116👍, 0💬

What is your Oracle application 11i Webserver Version and how to find it ?
What is your Oracle application 11i Webserver Version and how to find it ? From 11.5.8 to 11.5.10 Webserver version is iAS 1.0.2.2.2, In order to find version under $IAS_ORACLE_HOME/Apache/Apache /binexecute ./httpd -version ./httpd -version Server version: Oracle HTTP Server Powered by Apache/1.3.1... 2011-11-24, 3719👍, 0💬

What are few profile options which you update after cloning ?
What are few profile options which you update after cloning ? Rapid clone updates profile options specific to site level . If you have any profile option set at other levels like server, responsibility, user....level then reset them. 2011-11-29, 3692👍, 0💬

How to retrieve SYSADMIN password ?
How to retrieve SYSADMIN password ? If forgot password link is enabled and SYSADMIN account is configured with mail id user forget password link else you can reset sSYSADMIN password via FNDCPASS. 2011-11-29, 3322👍, 0💬

What is content of DBC file and why its important ?
What is content of DBC file and why its important ? DBC file is quite important as whenever Java or any other program like forms want to connect to database it uses DBC file. Typical entry in DBC file is GUEST_USER_PWD APPS_JDBC_URL DB_HOST 2011-11-28, 3245👍, 0💬

How do you find the number of rows in a Table ?
How do you find the number of rows in a Table ? select count(*) from table, or from NUM_ROWS column of user_tables if the table statistics has been collected. 2011-11-22, 3222👍, 0💬

What is a pseudo column. Give some examples?
What is a pseudo column. Give some examples? Information such as row numbers and row descriptions are automatically stored by Oracle and is directly accessible, ie. not through tables. This information is contained within pseudo columns. These pseudo columns can be retrieved in queries. These pseudo... 2011-11-23, 3177👍, 0💬

Where is DATABASE/PLSSQL cache stored ?
Where is DATABASE/PLSSQL cache stored ? PLSSQL and session cache are stored under $IAS_ORACLE_HOME/ Apache/modplsql/cache directory. 2011-11-26, 3138👍, 0💬

What is plssql/database cache ?
What is plssql/database cache ? In order to improve performance mod_pls (Apache component) caches some database content to file. This database/plssql cache is usually of type session and plsql cache # session cache is used to store session information. # plsql cache is used to store plsql cache i.e.... 2011-11-26, 3117👍, 0💬

Whats is location of access_log file ?
Whats is location of access_log file ? access_log file by default is located in $IAS_ORACLE_HOME/ Apache/Apache/logs. Location of this file is defined in httpd.conf by patameter CustomLog or TransferLog 2011-11-23, 3037👍, 0💬

.NET C C++ CSS DBA General HTML Java JavaScript JSP JUnit MySQL Networking Oracle Perl Perl PHP PL/SQL RSS Software QA SQL Server Struts Unix Windows XHTML XML

Home Hot About Collections Index RSS Atom Ask

Tester Developer DBA Windows JAR DLL Files Certificates RegEx Links Q&A Biotech Phones Travel FAQ Forum

All rights in the contents of this web site are reserved by the individual author. fyicenter.com does not guarantee the truthfulness, accuracy, or reliability of any contents.