Server Administration :: Monitoring Auto Allocate Tablespaces

Nov 7, 2011

Currently all my tablesapces are "UNIFORM" and I am looking into going to "AUTOALLOCATE" so space will not be some much of an issue.

I am using the following code and here is the output

sqlplus -s / <<-EOT
set pages 50
set line 100
set verify off
set feed off
set trimspool on
[code]........

Have a script that can emulate my above output and also deal with tablespaces that can autotallocate?

View 4 Replies


ADVERTISEMENT

Oracle Auto Extensible Tablespaces

Jan 7, 2011

I need to create a shell script to find the free space of an auto extensible tablespaces and send an alert when the free space is < 700MB. I tried checking with the dba_free_space, but I did not get the exact free space.

Tell me the logic to find the exact free space of autoextensible enabled tablespaces?

View 1 Replies View Related

Server Administration :: Managing Tablespaces

Jul 22, 2011

I have deleted lots of data from existing tables in one tablespace. shrink or coalesce the size of the tablespace.

View 7 Replies View Related

Server Administration :: Tablespaces In Autoextend Settings

Jun 9, 2011

I just want to know what are precautionary measures if tablespaces in a database is in autoextend mode. I'm wondering if these tablespaces reached its maximum sizes.

In our case, we are administering a database (turned over by our outsourcer after a 2-year maintenance) with SAP interface, and we noticed that most of it's tablespaces were created with initial size of 2Gb up to a maximum size of 10Gb, all were 'autoextensible'.

View 1 Replies View Related

Server Administration :: Application Related Tablespaces

Oct 31, 2011

How to find out the tablespaces specific to application (i.e. not related to oracle like system, sysaux,temp,undo etc..)

View 1 Replies View Related

Server Administration :: How To Alter / Change Size Of Tablespaces

Feb 26, 2013

1-how can i alter/change the size of tablespaces?.

2-is any changing in tablespace size will effect the over all performance?

Tablespace ; Size (MB); Free (MB); % Free; % Used
------------------------------;----------;----------;----------;----------
USERS ; 5; 4; 80; 20
SYSAUX ; 600; 140.875; 23; 77
UNDOTBS1 ; 640; 114.125; 18; 82
SYSTEM ; 700; 28.3125; 4; 96
TEMP ; 64; 0; 0; 100

View 4 Replies View Related

Server Administration :: Specifying Nonstandard Block Sizes For Tablespaces?

Jan 6, 2011

We are creating non standard blocking size for 16k and so accordingly have to set the parameter db_16k_cache_size.

if have any thumb rule for setting the value for this parameter.

View 5 Replies View Related

Server Administration :: Monitoring Open_cursors

Sep 13, 2011

When I monitoring db, I see open cursor increase from a machine running Java application. On the develop machine, everything is ok, but on the production server, open cursors can not close.Although the parameters are the same on 2 servers.

View 15 Replies View Related

Server Administration :: Monitoring Script Required For Oracle 9.2.0.7.0 On Windows 2000 Server

Apr 8, 2010

My manager is asking to create a SQL scrip, which will provide following information.

Our database is 9.2.0.7.0 on Windows 2000 Server

-How many records Insert / Update or Delete daily in my Oracle database?

- Check Archive log / Redo Log switching information?

-Check database growth ?

View 10 Replies View Related

Server Administration :: Pre-allocate Space For Temporary Tablespace?

Jan 4, 2012

I just want to know whether we have to pre-allocate space for temporary tablespaces?

View 1 Replies View Related

Server Administration :: Allocate Extents To Tables With Zero Rows

Aug 30, 2011

create a procedure or cursor to allocate extents to all tables with zero rows for all the user in the database.I have used the below query to check table with zero rows and no extents allocated.

select onwer,table_name,initial_extent
from dba_tables where initial_extent is null order by owner;
I generated the query to allocate extents by using concatenation in the above query.
select 'ALTER TABLE '||table_name|| ' ALLOCATE EXTENT; '
from dba_tables where initial_extent is null order by owner;

now I want the extent allocation for such table auutomatically for aal the tables with zero rows.

View 17 Replies View Related

Server Administration :: Monitoring Alerts And Logs?

Dec 19, 2012

I have version 11.2.0.3 installed in a server AIX and i'd like to know where are alerts and logs like "max extents reached in table....". I don't see them in alert.log.

Where is the best way to monitoring this class of alerts and logs?

How can i see how many actuals extents go consumed in tables and indexes?

View 10 Replies View Related

Server Administration :: Monitoring Unusable Objects

May 6, 2012

How monitor the unusable objects in oracle 10g (10.2.0.1.0) os rhel 5? is it same as invalid objects and can be monitor as same?

View 4 Replies View Related

Server Administration :: ORA-01019 - Unable To Allocate Memory In User

Oct 8, 2011

I have installed Oracle 10g on my PC and create a Database on it. I wanted to connect it with PL Sql Developer with the same PC but it`s not connecting. It gives the following error "ORA-01019: unable to allocate memory in the user " And some time blank error message box.

Here is system information:

OS: Winsows 7
Oracle Database 10g Express Edition
PL SQL Developer 8.0.3.1510

Login Setting

User Name: book
Password: oracle
Database: XE
Connect as: Normal

View 5 Replies View Related

Server Administration :: Monitoring User Session And Killing It?

Jun 8, 2010

I am using TOAD to monitor user sessions. I have a user who uses nearly 80% of Overall resources in the mornings. He calls me daily and say that his work is done. But even then the TOAD shows that he is using same resources for some time.

My question is can i kill the session once he confirms his work is done OR do i need to wait till the redologs are cleared.

View 9 Replies View Related

Server Administration :: ORA-04031 / Unable To Allocate 256 Bytes Of Shared Memory

Sep 7, 2010

When user insert rows in table oracle interrupts and raise error- ORA-04031: unable to allocate 256 bytes of shared memory? how to do?

I tried to increase the size of shared_pool also but cant.

large_pool_size = 0
shared_pool_size=134217728(128M)
sga_max_size=218103808(208M)

And when I fire 'select* from v$sga;'

Fixed Size 2142976
Variable Size 159386880
Database Buffers 50331648
Redo Buffers 5296128

View 3 Replies View Related

Server Administration :: Unable To Allocate 4120 Bytes Of Shared Memory

Jan 1, 2013

I have a package when it runs, it terminates with "unable to allocate 4120 bytes of shared memory"error at a particular INSERT statement. So everytime we had this error, we had to flush the shared pool area, after which it would run without issues(for 3-4 weeks).

It had a dynamic subpartition clause framed, which made it to repharse the query every time.So to reduce this, we removed the subpartition clause(made it to static query), which did benefit of not getting shared pool error.

I would like to find the current shared pool memory usage of my program.Is there a way I could find the live consumption of shared pool area of my program(pkg).

View 10 Replies View Related

Server Administration :: When Did A Datafile Auto-extend

Dec 21, 2010

Is there a way to find out when a datafile for an undo tablespace with autoextend enabled actually extended? I've done a few tests, and nothing is written to the alert log or any trace file that I've found. I can't find any V$ or DBA view that will give me the history of a file's size.

View 5 Replies View Related

Server Administration :: Segment Space Management Is Auto?

Oct 18, 2010

the syntax to make a tablespace's segment space mnagement auto which is segement management is *manual* and exent management is *local autoallocate*.

View 2 Replies View Related

Server Administration :: Get Script That Create Partition By Auto?

Oct 27, 2011

Is there a script that it create partitions by auto? who can share it?

View 1 Replies View Related

Server Administration :: Objects Invalid Due To Auto-compilation

Jun 27, 2012

One of my friends is facing a peculiar problem where objects are getting "Invalid" during execution I suspect it is happening as they are changing system date during their testing (time travel) which can create conflicted last_ddl_time on objects having dependencies

Consider a scenario

[1] system date is 10-06-2012 there are total 10 objects which has status as 'valid'

[2] the system date is changed to 10-07-2012 Now out of 10 Only 5 objects are compiled During execution ORA-04065,ORA-06508, ORA-06512 are observed

[3] the system date is brought back to 10-06-2012 Again during execution ORA-04065,ORA-06508, ORA-06512 are observed

suppose in step 2 objects are compiled whereas there synonyms are compiled in step 1, only thus last_ddl_time for objects will be later to that of its' synonym...

Does database validate last_ddl_time for objects having dependency during execution and then auto-compiles or invalidates the objects?

View 3 Replies View Related

Server Administration :: Tablespace Auto-Extend OFF On Production System

Jun 6, 2012

I want to OFF tablspace AUTOEXTEND on a prodution system, we have many RAC databses and that will be done on all stations. i have got a document from net which was written on 29-Jun-2007 and it says that if need to OFF the AUTOEXTEND of a TABLESPACE so you need to ist make it off on the underlying datafiles of that tablespace so this doc is for Oracle 8.1.7.2.0

View 2 Replies View Related

Server Utilities :: Hot Backup Of Tablespaces

May 11, 2011

Is the tablespace actually off-line when doing a user-managed hot backup? I know the data blocks are copied into a redo stream but I am not sure if that means it(tablespace) is actually on-line or off-line.

View 6 Replies View Related

Backup & Recovery :: Shift Data To New Server Using DBF Files Of Tablespaces In Use

Jul 1, 2011

I have a 10G Express system running. I Have 2 tablespaces in production. WHen taking backup, it terminates unsuccessfully saying system01.dbf is damaged. The application works fine and no data loss is found through the application interface.

So can I shift the data to a new server using the dbf files of the tablespaces in use?

View 9 Replies View Related

Monitoring Script From Client Side (no Access To Server)

Sep 12, 2012

We are on oracle 11.2.0.2 on Solaris 10. I dont have acces to the db server but connect to the db from the client side using sqlplus. though I have dba privilege (at oracle level) but no access to db server at os level. I also dont have access to enterprise manager console where such information is available.

I want to set up monitoring so that I can get a mail when the space falls below some threshold like say tablespace is 90% full. Is it possible to get mail from pl/sql script for example?

View 1 Replies View Related

Server Utilities :: Data Pump Import - How To Identify Dump File Tablespaces

Jul 5, 2012

I'm rying to import schema's from a dump file that came from a different environment.

What I have is:

1. dump file
2. log file of the export

I'm trying to import the file(containing three schemas) with remap_schemas, and it fails, gives a lot of ORA-00959: tablespace 'string' does not exist.

Now, I've read in OTN:

[URL]

that what you need to do in that case is to use the REMAP_TABLESPACE option,to redirect the objects to a different tablespace.

I don't see a name of the tablespace I'm getting the error for in the export log.I don't know if I have more tablespaces I have to redirect with REMAP_TABLESPACE.

I don't want to perform this 3 times, have an error, by that find out what's the next tablespace needing redirection and only then starting over...

How can I know from the dump file and the log file,what is the tablespace names i need for the redirection to my names? Or its just that the tablespace giving me the error is the only one in the dump file?

View 3 Replies View Related

Exadata :: Monitoring Cell Server With OS Watcher / Other Command Line Tools

Aug 7, 2012

we can't use the Exadata Plugin for Cloud Control but we need some monitoring of the Cell Servers.Does OS Watcher is the right tool or do we need ADRCI for incidents and so on.

What do have to install and what information do we get.

View 5 Replies View Related

How To Migrate Two Tablespaces Into One

Apr 3, 2013

at my Oracle 11gR2 (11.2.0.3.0) Instance i have two tablespaces that i want to "bundle" into only one tablespace. Herre is the problem, that some of the tables in the two tbalespaces has the same title but some rows of the tables could be not the same.

Is it possible with a kind of migration assistent to migrate two tablespaces into one in that way, that theassistent only writes that rows into the new tablespace, that are not in the tablespace at the moment.

Another way i was thinking about is to have an insert statement coupled with a select statement. The select statement selects all the rows, that are not in the table where i want to migrate in and the insert statement put that selectet rows into the new table.

Is something of that possible?

View 10 Replies View Related

Cannot Allocate New Log

Aug 22, 2012

Database 11.0.1.7
Oracle E BS R12
Linux redhat 5.5

We are experiencing this issue since long as applications hang at this particular activity

Thread 1 cannot allocate new log, sequence 302
Private strand flush not complete
Current log# 1 seq# 301 mem# 0: /u02/OBAPROD/db/apps_st/data/log01a.dbf
Current log# 1 seq# 301 mem# 1: /u02/OBAPROD/db/apps_st/data/log01b.dbf
Tue Aug 21 12:16:49 2012
Beginning log switch checkpoint up to RBA [0x12e.2.10], SCN: 5965234084879
Thread 1 advanced to log sequence 302 (LGWR switch)
Current log# 2 seq# 302 mem# 0: /u02/OBAPROD/db/apps_st/data/log02a.dbf
Current log# 2 seq# 302 mem# 1: /u02/OBAPROD/db/apps_st/data/log02b.dbfe

View 4 Replies View Related

Dictionary Managed Tablespaces

Jul 7, 2010

I've got one database which was Initially upgraded from Oracle 8i to 10.2.04 running on windows. Most of the tabespaces are Dictionary managed. Do you think moving them to locally managed tablespace would give me better performance?

if Yes, what approach I should apply to move them to locally managed? I would like to do this with minimum/no downtime.

View 6 Replies View Related







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