ORA-12154 TNS:could not resolve service name ORA-12154 is generated by the oracle network layer. ORA-12154 error message is thrown during the logon process to a database. This error indicates that the communication software in Oracle ( SQL *Net or Net8 ) did not recognize the host/service name specified in the connection parameters. ORA-12154 most of the time indicates a misconfiguration of the oracle tns entries   ORA-4031: Unable to allocate bytes of shared memory ORA-4031 is a very common error that many dba's face in their day to day activities. This error can commonly occur due to the SHARED POOL SIZE. This error can be due to an inadquate sizing of the SHARED POOL or due to  fragmentation of the shared pool.    Data Loads into Oracle Compressed Tables Oracle introduced table compression feature in Oracle 9i to help reduce the disk space utilization in databases. Datawarehousing and decision support systems have been evolving over years and have become the biggest hogs of disk space. Managing disk capacity has become a challenge for the dba as well as the infrastructure team. In todays world terabyte systems have become very common and require large volumes of data to be stored in various large tables. The compression of data is transparent to users and applications and the access to data continues the same way it has already been developed.   Oracle Instance : What is Large Pool Oracle Large Pool is an optional memory component of the oracle database SGA. This area is used for providing large memory allocations in many situations that arise during the operations of an oracle database instance.   Oracle Data Dictionary : An Introduction Oracle data dictionary is the heart of an oracle database. It comprises of read-only set of tables that provide information about every possible aspect of the oracle database. The data dictionary holds definitions of schema objects, space allocation, database security, audit information etc. Oracle data dictionary is stored in the system tablespace and is structured in tables and views just like other database data. SQL statements are used to access the information contained in the data dictionary. Oracle data dictionary is read only, and only select queries can be run against the tables and views.   Do not attempt to alter or manipulate the oracle data dictionary since it can permanently damage the integrity of the database

<< Start < Prev 1 2 3 4 5 6 Next > End >>

Results 16 - 20 of 30