Server Administration :: Hash_Area_Size Unit In Show Parameter

Aug 27, 2012

When I list the parameters with "show parameter", I get only numeric value for hash_area_size with no unit, what is the unit for that value and conversion of it to MegaBytes.

View 3 Replies


ADVERTISEMENT

Server Administration :: MR Lock / Show All Datafiles

Nov 25, 2010

Just noticed MR(media recovery lock ) in our database,further check showd all datafiles had this lock since our database was shutdown abortly but was startup gracefully.

View 2 Replies View Related

Show Parameter Audit_trail And Function

Dec 16, 2010

Is there any way to get audit_trail.VALUE? I know the statement: show parameter audit_trail; can show that value. But, i want to build a function which will return a string that contain audit_trail.VALUE

View 1 Replies View Related

Server Administration :: How To Reset Parameter Value

Dec 9, 2011

I often use "alter session set xxx=xxx;" command to change parameter value temporarily. After that, how to reset parameter value to default and I don't want logout sqlplus.

View 3 Replies View Related

Server Administration :: Increase SGA Parameter

Jul 22, 2010

SQL> alter system set sga_max_size=1G scope=spfile;

System altered.

SQL> startup force
ORA-12545: Connect failed because target host or object does not exis
SQL> show parameter sga
ERROR:
ORA-03114: not connected to ORACLE

SQL> startup force
ORA-24324: service handle not initialized
ORA-01041: internal error. hostdef extension doesn't exist
SQL> startup
ORA-24324: service handle not initialized
ORA-01041: internal error. hostdef extension doesn't exist
SQL> startup force
ORA-24324: service handle not initialized
ORA-01041: internal error. hostdef extension doesn't exist

View 3 Replies View Related

Server Administration :: How To Change DB Timezone Parameter

Aug 31, 2010

How to change db timezone parameter. My application team has asked me to change the db timzone parameter by following sql.

ALTER database SET TIME_ZONE = '+10:00';

Is this way is the correct one , and do we have any impact on database and does it require a db bounce.

View 2 Replies View Related

Server Administration :: Use Large Pages Parameter And AMM?

Jul 29, 2011

It always used to be that Automatic Memory Management and Linux huge pages were incompatible: you had to use one or the other. But 11.2.0.2 has new parameter, USE_LARGE_PAGES. This isn't documented apart from a few articles on metalink, but Googling it suggests that if it is on TRUE (the default) or ONLY then I can use AMM with huge pages.

View 3 Replies View Related

Server Administration :: UNDO In Parameter File?

Dec 9, 2011

I have a question ragarding undo tablespace. I want to ask that why only undo tablespace information we need to specify in parameter file. We do not specify any other tablespace information. Not even for temporary tablespace. Then why we need to give undo tablespace name while instance is creating.

View 5 Replies View Related

Server Administration :: Which Initialization Parameter Can't Be Changed

Apr 29, 2012

which initializaion parameter cant be change after creating the database?

View 5 Replies View Related

Server Administration :: Database Parameter Comparison

Nov 4, 2013

We have migrated database data from physical servers to virtual servers. i want to ensure all database parameters are set correctly in both physical and vblock servers. My question is what are all the parameters need to check and compare in both servers to ensure database from both servers ( physical/vblock ) are in sync.

Database used -- RAC database
OS used -- RHL 5.7

View 5 Replies View Related

Server Administration :: Change Parameter Value In Oracle 11gR2?

May 11, 2012

I want to change cursor_sharing, open_cursors and session_cached_cursors parameter values for SPFILE (Only SPFILE) using SQL Query.

I have found following SQL Queries, but I don't know these queries are only for SPFILE or not.

ALTER SESSION SET cursor_sharing='EXACT';
ALTER system set open_cursors=2500;
ALTER SESSION set session_cached_cursors=70;

I need SQL Queries only for SPFILE.

View 3 Replies View Related

Server Administration :: Database Sessions - Setting Value Of Parameter

Mar 26, 2013

I have a simple question about database sessions. The value of parameter "sessions" is set to 500 and the users connect to database through an application server(Jboss). There are more than 500 users connect to the database through application.

My question is, how more than 500 users can connect to the database without any issue, if we set the value of "sessions" parameter to 500?

View 2 Replies View Related

Server Administration :: Quick Check On Hidden Parameter?

Mar 20, 2013

quick check on a hidden parameter? I need to know the default value and possible values for _serial_direct_read on various releases, I have only 11.2.0.3 available right now and I'ld like to know this for 11.2.x.x 11.1.x.x, and 10.2.x.x.

Below is the query that will show what it is currently which (unless you've changed it) will be the default: auto for my 11.2.0.3. Then to see the options, try to set it to something wrong, my options are false/true/never/auto/always. I think false/true were the only choices for 10.2 and are maintained only for compatibility. But I can't rememebnr 11.1.

orcl>
orcl> set lin 80
orcl> select KSPPSTVL from x$ksppcv join x$ksppi using (indx) where ksppinm='_serial_direct_read';
KSPPSTVL
--------------------------------------------------------------------------------
auto

orcl>
orcl> alter system set "_serial_direct_read"=rubbish;
alter system set "_serial_direct_read"=rubbish
*
ERROR at line 1: ORA-00096: invalid value RUBBISH for parameter _serial_direct_read, must be from among false, true, never, auto, always

orcl>
update: added 11.1.x.x to my wishlist

View 10 Replies View Related

Server Administration :: ORA-32004 / Obsolete And / Or Deprecated Parameter(s) Specified

Nov 9, 2011

I am getting the following error while starting database.

ORA-32004:obsolete and/or deprecated parameter(s) specified

View 25 Replies View Related

Server Administration :: Differences In Versions According To Init-parameter Compatible

Dec 15, 2010

How oracle deals with the setting of init.ora parameter compatible.

e.g. we have
DB Version=10.2.0.4
compatible=10.2.0

what is the possible leak for us ? Is there any description about the features changed in 10.2 up to 10.2.0.4 in all steps - so that we can check out which functions we do not have.

View 3 Replies View Related

Server Administration :: Initialization Parameter File - Currently In Effect For Session

Jan 31, 2012

I have a question about spfile.

SQL> SELECT COUNT(*) FROM v$parameter WHERE value IS NOT NULL;
COUNT(*)
----------
246
SQL> SELECT COUNT(*) FROM v$spparameter WHERE value IS NOT NULL;
COUNT(*)
----------
20

v$parameter displays information about the initialization parameters that are currently in effect for the session,but v$spparameter displays information about the contents of the spfile.I want to know why the count of parameters whose values are not null in v$parameter is greater.where are they from? My initialization parameter file is spfile.

View 3 Replies View Related

Server Administration :: Deprecated Parameter Not In Spfile And Cannot Reset In Memory?

Apr 12, 2013

i try to startup a database, and get that obsolete/deprecated parameter specified(ORA-32004: obsolete and/or deprecated parameter(s) specified)so i try to reset the parameter, but it seems it is already reset(not in spfile), so maybe this is in memory. SO now i try to reset with scope = memory or both, it gives this error(ORA-32029: resetting with SCOPE=MEMORY or SCOPE=BOTH is currently not supported).

what to do, because now i cannot reset with scope = memory and in spfile it is not there but still it comes in deprecated parameter.

View 7 Replies View Related

Application Express :: To Change The Default Behavior Of Hide / Show Region To Show

Jun 26, 2012

I am trying to change the default behavior of Hide/Show Region to show, after some attempts i got it partially working but now clicking the icon to toggle hide/show doesn't work also changed the icons and added type="" but its not working.

View 16 Replies View Related

Allocation Unit And Striping Attribute

Dec 21, 2012

difference between stripe attribute and the AU size.The ASM distributes the data in AU in the disk, and what the role of strip size in this case?

View 2 Replies View Related

SQL & PL/SQL :: ORA-06508 - Could Not Find Program Unit Being Called?

Jan 2, 2013

I am facing below Oracle error when ever I am changing the contents of the package within it. %ORA-06508: PL/SQL: could not find program unit being called:

The packages and the dependents are recopmiled successfully and there are no invalid objects.The problem is resolved only if the database is reastarted.

What might be the problem?I am using a PL/SQL collection of record datatype in this package.

View 13 Replies View Related

ORA-06508 / PL/SQL / Could Not Find Program Unit Being Called

Jan 25, 2013

When i am trying to create awr snap shot using

exec dbms_workload_repository.create_snapshot;

ERROR at line 1:
ORA-04063: package body "SYS.DBMS_WORKLOAD_REPOSITORY" has errors
ORA-06508: PL/SQL: could not find program unit being called:
"SYS.DBMS_WORKLOAD_REPOSITORY"
ORA-06512: at line 1

View 3 Replies View Related

SQL & PL/SQL :: ORA-06508 / Could Not Find Program Unit Being Called

Apr 5, 2010

I am getting below error when SP (Packaged Procedure) is called from application...

ORA-06508: PL/SQL: could not find program unit being called

After checking DB, i found package to be valid and call to SP giving same error ORA-06588.If i fire alter command to compile the package..

alter package name compile; and then if i try to run the SP in db it runs sucessfully.again after some time ORA-06508 it occurs again. after compiling it starts working fine again.

Body of the procedure :-

begin
indexFields.extend;
indexFields(indexFields.last) := ATTRIBUTE_REC_TYPE(i_attributeName,i_attributeValue);
o_errorcode := '0';
o_errormsg := null;
EXCEPTION

[code]....

sometimes it is working fine, sometimes gives error on compiling it works again.

View 11 Replies View Related

Performance Tuning :: Statspack Unit Information?

Sep 6, 2011

Is there a webpage that posts the units of the fields in statspack Example readtim in PERFSTAT.STATS$FILESTATXS (centiseconds?)

SELECT snap_id
,phyrds
,readtim
,phywrts
,writetim
,wait_count
FROM PERFSTAT.STATS$FILESTATXS

View 2 Replies View Related

SQL & PL/SQL :: ORA-06552 / Compilation Unit Analysis Terminated

Apr 28, 2011

The following error has occurred:

ORA-06550: line 26, column 30:
PL/SQL: ORA-06552: PL/SQL: Compilation unit analysis terminated
ORA-06553: PLS-320: the declaration of the type of this expression is incomplete or malformed
ORA-06550: line 7, column 6:
PL/SQL: SQL Statement ignored

I am getting the error when i run the below anonymous block. Historic_report_data has got plenty of columns and using only the columns that are in tb_Statement in the query. It is working fine if i use a table with same number of columns as tb_statement instead of historic_report_data.

DECLARE
v_cnt NUMBER:=0;
v_data_load_error EXCEPTION;
BEGIN
dbms_output.put_line('Reconciliation scripts');
dbms_output.put_line('Reconcile tb_bank_Account_month and report_hist_data');

[code]....

View 16 Replies View Related

SQL & PL/SQL :: ORA-06508 - Couldn't Find Program Unit Being Called

Oct 15, 2013

I am using oracle 10g and toad 11.5 . i am trying to call an api from an anonymous block . If i recompile the api after adding dbms_output.put_line and then try to execute the anonymous block ,it shows error as "ORA-06508: PL/SQL: could not find program unit being called". However if i end current session and open a new session , then the anonymous block will execute without the error. i am made to reconnect the session everytime i make a change to API. making any configurations in toad or database level.

View 12 Replies View Related

SQL & PL/SQL :: ORA-06508 Couldn't Find Program Unit Being Called

Feb 21, 2011

ORA-06508: PL/SQL: could not find program unit being called ORA error, why it is getting, what is the corrective action for this error. i checked my package and dependent objects all are in VALID state only. But as soon as i get this error, LAST_DDL_TIME for my package is being changed to current time when the package was running.

View 10 Replies View Related

Forms :: ORA-06508 - PL/SQL - Could Not Find Program Unit Being Called

Feb 18, 2010

Actually what happens is that we are connected to oracle through forms 6i. suddenly we receive the error " ORA-06508: PL/SQL: could not find program unit being called "

while doing some transaction. we have searched on net and meta link. they say that the package / procedure called has become invalid or recompilation has occurred and that is not compatible. Now we have monitored carefully that there are no changes what so ever has been made in the the package/ procedure.

what could be the reason behind this. we have also checked the global variable issue. we use package level variables but declared in the package body only. (so these are not public)

View 20 Replies View Related

Server Utilities :: Imported Dump File Does Not Show Any Table Under User Amol

Dec 20, 2011

I have dump file of 17 GB,which i want to import in my database db1 in user amol ;so i created new user under db1 as below ,before this i have created tablespace so that i can import my data only to that tablespace only. My steps are as below.

CREATE TABLESPACE ptaxold1 DATAFILE '/home/oracle/oracle/product/10.2.0/oradata/cvsdbm/ptaxold1.dbf' SIZE 6024M AUTOEXTEND ON;

create user amol identified by amol default tablespace ptaxold1 temporary tablespace tem; imp amol/amol then i mentioned my dump file but after importing it does not show any table under user amol.

View 12 Replies View Related

Reports & Discoverer :: Using Functions In Report Builder Program Unit

Oct 27, 2010

i am creating a report using a function in the select query..suppose this is my function that i created in the program unit of the report

FUNCTION is_numeric_rep (p_strval in varchar2) RETURN
NUMBER
IS
l_numval NUMBER;
BEGIN
l_numval := TO_NUMBER(p_strval);
RETURN 1;
EXCEPTION
WHEN OTHERS THEN
RETURN 0;
END is_numeric_rep;

and also suppose this is the query of the report

Select
is_numeric_rep('343aa43')
From dual

when pressing ok on the query statment in the report it give me this error: ORA-00904 "is_numeric_rep":invalid identifier although when i create this function as a stored function in the database schema and use it in the report it works fine with no problems.

View 1 Replies View Related

SQL & PL/SQL :: WEBADI Error ORA-06508 Could Not Find Program Unit Being Called

May 30, 2010

When I run my package in TOAD and SQL plus I am not getting any errors. My package is being compiled well. When I integrate my Package through WED ADI .I am getting the above error. I am new to oracle apps WEDADI. can any give your valuable sugessions. I have even bounched the apache two times.

The schema for my package is APPS. Can you tell us how to go check the schema of WEB ADI. We see my integrator created in BNE_INTEGRATORS_TL. Since it is store in BNE table, the schema for BNE table is 'BNE'?

How to provide the access of package to the WEB ADI?

View 1 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved